Open PO Report Incorrect Calculation
(Doc ID 2955788.1)
Last updated on JUNE 22, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
There appears to be an incorrect calculation on the Open PO Report from MFCS/BI Publisher. An example is PO 282211099. This PO was originally created for quantity 1270 units of item 2022024538. The supplier told us that they could not fit that many units on a container, so they order was adjusted to 1040 units on the order.
ORDLOC now reflects 1040 qty_ordered and 230 qty_cancelled, which is correct. In the Open PO report in BI Publisher however, the order now shows a qty_ordered of 1040, with an outstanding quantity of 810. The outstanding quantity and outstanding cost are incorrect on the PO report, because the math appears to be
qty_ordered - qty_cancelled. Qty 1040 is actually the outstanding quantity in this example.
Steps to Reproduce:
-------------------
1. Find an Approved order with outstanding quantities and cancelled quantities.
2. In MFCS navigate to Report > Orders > Open Orders
3. In put criteria to search for PO.
4. The order outstanding quantity information on the Open PO report is incorrect.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |