Rounding Issue When Performing P-Card Reconciliation
(Doc ID 1638185.1)
Last updated on FEBRUARY 03, 2019
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
Rounding Issue when performing P-Card Reconciliation.
The PCard transaction comes in with a quantity of 1 and an amount / unit price of 504.93. The PO was created with a quantity of 1100 and total amount of 504.93.
When attempt to reconcile the PO to the P-Card transaction, the system takes the PO quantity of 1100 and divides it by the total amount of 504.93, to come up with a unit price of .45903.
The system is rounding this unit price to 5 digits and the following error occurs.
"There is a difference amount (0.003) in the statement line after the PO is attached. Please adjust the difference before proceedign to create voucher against the statement or else it leads to voucher stage error."
The issue can be reproduced at will with the following steps:
1 - Create PO and elect to pay via Procurement Card; dispatch
2 - Run Load ProCard Stage - load file provided by customer
3 - Run Load Statement
4 - Select Purchase Details to manually associate PO
5 - When you go to click ‘ok’ - received a message:
"(Quantity * Unit Price = 504.933) does not equal to Transaction Amount (504.930)"
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