My Oracle Support Banner

R12: AP: 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 FEBRUARY 27, 2019

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 Supplier B for currency GBP with amount 850. Exchange rate   5.12689054088695
Entered 'INV2' against Supplier B for currency GBP with amount 850. Exchange rate  5.02891626854412
Entered 'INV3' credit memo against Supplier B for currency GBP with amount 833.33. and  Exchange rate 5.38938291565615
 All dated 21st June 2011
 .
 All Validated
 Ran Create Accounting for invoices and date as 30th June 2011
 .
 All accounted OK
 .
 .
 Enter payment No 'XXXX' 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 XXXXX 
 .
 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. Liability GBP 850.00 DR 169.02 DR
 2. Liability GBP 850.00 DR 165.79 DR
 3. Loss GBP 0.00 DR 7.19 DR
 4. Loss GBP 0.00 DR 3.96 DR
 5. Future Dated Pa GBP 866.67 CR 176.38 CR
 6. Liability GBP 833.33 CR 154.62 CR
 7. 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 XYZ,
 .
 The Payment XXXX 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.

Changes

None

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.