Rounding Issue When Performing P-Card Reconciliation
Last updated on JUNE 09, 2017
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)"
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