Receipt Merchandise Amount Rounds off and as a result is not equal to Purchase Order (PO) Merchandise Amount

(Doc ID 2343487.1)

Last updated on FEBRUARY 02, 2018

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Goal

When have more partial receipts, the total of Receipt Merchandise Amount is getting round off so is different than PO Merchandise Amount. Because of the difference in PO and receipt Merchandise Amount is conducting to match exception error at voucher.

An example is when there is a PO with merchandise amount 9517.50 and 3 receipts are created from the same PO. But while creating the receipts, the receipt amount gets round-off for e.g. 176.25*31.5=5551.875 this gets round off to 5551.880. Because of these the total receipt amount exceeds than PO amount and gives exception error on voucher.

Steps to Reproduce the Issue:
---------------
1. Create PO with PO distributed by amount having for example PO Qty=54 and price=176.25000 (54*176.25=9517.50) and Item is description only.
2. Dispatch PO
3. Create 3 receipts as following:
Receipt 1: 176.25*31.500 = 5551.875
Receipt 2: 176.25*4.500 = 793.125
Receipt 3: 176.25*18 = 3172.5
4. Notice for the receipts 1 and 2 the Merchandise Amount is getting round off to 5551.88 and 793.13 respectively which increases the total amount of receipt (5551.875+793.125+3172.5=9517.51) than PO.
While the PO Merchandise Amount = 9517.50.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms