0.01 Difference between AP_CHECKS.BASE_AMOUNT and SUM of AP_INVOICE_PAYMENTS_ALL.PAYMENT_BASE_AMOUNT (Doc ID 1374900.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

For some payments there is a difference between the check base amount and the accounted amount.
The cause of this issue is a difference of 0.01 between SUM (ap_invoice_payments_all.PAYMENT_BASE_AMOUNT) and ap_checks_all.base_amount.

This means that in Cash Management, Bank Statement Reconciliation the available payment is returned with a base amount which is different to that held in the cash clearing account.

The accounting does not error and rounding lines are created to balance the accounting.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Entered 'INV1' against Advantage Corp GBP with amount 850. Exchange rate
 5.12689054088695
 Entered 'INV1' against Advantage Corp GBP with amount 850. Exchange rate
 5.02891626854412
 Enter 'INV3' credit memo against Advantage Corp GBP with amount 833.33.
 Exchange rate 5.38938291565615
 All dated 21st June 2011
 .
 All Validated
 Ran Create Accounting for Ledger 'Vision Services (USA)' for invoices and
 30th June 2011
 .
 All accounted OK
 .
 .
 Enter payment No '181773' with Exchange Rate 4.91400491400491. Amount =
 866.67
 Pay invoices INV1, INV2 and INV3.
 See that the ap_checks_all base_amount is 4258.82 and
 SUM(PAYMENT_BASE_AMOUNT) = 4258.81
 .
 This is Check ID 172923
 .
 AP_CHECKS_ALL
 .
 BASE_AMOUNT AMOUNT
 ----------- ----------
 176.37 866.67
 .
 AP_INVOICE_PAYMENTS_ALL
 .
 .
 INVOICE_BASE_AMOUNT PAYMENT_BASE_AMOUNT
 ------------------- -------------------
 165.79 172.98
 169.02 172.98
 -154.62 -169.58
 .
 SUM(PAYMENT_BASE_AMOUNT)
 ------------------------
 176.38
 .
 0.01 out
 .
 Accounting for this payment in view journal entries
 .
 1 01-000-2210-000 Liability GBP 850.00 DR 169.02 DR
 2 01-000-2210-000 Liability GBP 850.00 DR 165.79 DR
 3 01-740-7844-000 Loss GBP 0.00 DR 7.19 DR
 4 01-740-7844-000 Loss GBP 0.00 DR 3.96 DR
 5 01-000-2580-000 Future Dated Pa GBP 866.67 CR 176.38 CR
 6 01-000-2210-000 Liability GBP 833.33 CR 154.62 CR
 7 01-740-7842-000 Gain GBP 0.00 CR 14.96 CR
 .
 .
 Matured the payment and accounted
 Accounting is
 Future Dated Payments GBP 866.67 DR 176.38 DR
 Cash Clearing GBP 866.67 CR 176.38 CR
 .
 .
 .
 .
 In Cash Management
 Go To bank Statement Reconciliation
 Find available payments for the bank account BofA-458, account 716247142-2647
 .
 The Payment 181773 is returned with a base amount 176.37 Same as
 AP_CHECKS_ALL
 .
 .
 >>> Problem
 Cash Clearing account has base amount = 176.38
 In CE reconcilling to a bank statement shows the base amount for the check
 176.37
 .
 Clearing Accounting
 .
 Cash 01-000-1110-000 USD 176.37 176.37 CR
 Cash Clearing 01-000-1110-000 GBP 866.67 176.38 DR
 Rounding 01-740-7844-000 GBP 0.00 0.01 CR
 Balance 01-000-2990-000 GBP 0.00 0.01 DR
 Balance 01-000-2990-000 GBP 866.67 176.38 CR
 Balance 01-000-2990-000 USD 176.37 176.37 DR
 .
 .
 So the cash account has 176.37 at the end
 But the liability and cash clearing accounts at each stage have 176.38
 They are all reversed when the payment is made and the payment cleared
 But when reconciling there is a difference in the bank statement base amount
 and the actual cash clearing base amount.
 This can't be right can it ...?

Changes

None

Cause

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