My Oracle Support Banner

Subsequent Receipts Round Previous Receipt Quantities to Two Decimal Places When Calculating Qty Remaining To Receive, Causing the System To Give an Error “Over Shipped by (.39) Pct. Acceptable Overage Is (0.0) Pct. Max Qty Accepted Is (1.00) Line (1) (Doc ID 3012863.1)

Last updated on MARCH 28, 2024

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Initial Receipt allows and user is utilizing four decimal places for quantity on description only lines. Subsequent receipts then round previous receipt quantities to two decimal places when calculating qty remaining to receive. This prevents the user from being able to receive exactly a total qty of 1 and the total dollars received can't be made to match the total of the PO line.


The issue can be reproduced at will with the following steps:
1. Create a new PO (Purchasing-->Purchase Orders-->Add/Update POs).
2. Enter Description Item, Qty of 1, UOM of Ea and Price 29144604.99.
3. Save the PO.
4. Dispatch the PO.
5. Create a Partial Receipt (Purchasing-->Receipts--Add/Update Receipt).
6. Search for the PO.
7. Select the PO and click OK.
8. Change the qty from 1 to .8761.
9. Save the Receipt.
10. Create a 2nd receipt to receive the remaining qty. (Purchasing-->Receipts--Add/Update Receipt).
11. Search for the PO.
12. Select the PO and click OK.
13. The remaining Qty defaults on the receipt.
14. Click Save.
15. Get the warning/error

Warning - Over shipped by (.39) pct. Acceptable overrage is (0.0) pct. Max Qty Accepted is (1.00) Line (1).  (10300,54)
The purchase order schedule has been over received. Either by this receipt or this receipt combined with other receipts. Also, note that a change in the purchase order status values could cause this condition.

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.