ININF066 - Inventory Quantity As At - Opening Balance Incorrect

Description

Opening Balance on the report is excluding GRN reversals.

Steps to recreate:

  1. Create new PO for creditor 5001 for 28/02/2025. Add item 01140008, QTY 5. Save Set Status to Sent.

  2. Create GRN. Receive all outstanding. Activate.

  3. Click on Reverse. Activate.

  4. Change login date to 04/03/2025.

  5. Create another PO for creditor 5001. Add item 01140008, QTY = 30. Save Set Status to Sent.

  6. Create GRN. Receive all outstanding. Activate.

  7. Run Inventory Quantity Report As At. Start Date = 28/02/2025. End Date = 04/03/2025. Part No = 01140008.

    • Opening Balance = 6

      image-20250228-014107.png
  8. Run Inventory Quantity Report As At. Start Date = 01/03/2025. End Date = 04/03/2025. Part No = 01140008.

    • Opening Balance = 6. The GRN reversal has not been taken off the opening balance it should have been 1.

      image-20250228-014118.png

Environment

None

Attachments

5
  • 28 Feb 2025, 02:04 am
  • 28 Feb 2025, 02:04 am
  • 28 Feb 2025, 02:04 am
  • 28 Feb 2025, 01:41 am
  • 28 Feb 2025, 01:41 am

Activity

Monica Holliday4 March 2025 at 04:51

Passed testing 07.02.01.22

Monica Holliday28 February 2025 at 02:04

Fixed.

Attached updated report and stored procedures. Note this also includes fixes for https://jiwa.atlassian.net/browse/DEV-9983

Done

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created 27 February 2025 at 23:36
Updated 4 March 2025 at 04:51
Resolved 28 February 2025 at 02:04

Flag notifications