R12:AP:Transaction Amount And Entered Amount Are Not The Same For AP Invoice (Custom SLAM) (Doc ID 2998175.1)

Last updated on FEBRUARY 11, 2024

Applies to:

Symptoms

Transaction Amount and Entered Amount are not the same for an AP Invoice.

Transaction Amount (AP_Invoices_All.invoice_amount): 2000 INR
Entered Amount (XLA_AE_Lines.entered_cr / entered_dr): 3306 INR

▼
AP_INVOICES_ALL
INVOICE_ID INVOICE_AMOUNT APPROVED_AMOUNT
1xxxx5 2000 3306


▼
XLA_AE_LINES
AE_HEADER_ID AE_LINE_NUM APPLICATION_ID ACCOUNTING_CLASS_CODE ENTERED_DR ENTERED_CR
13xxxxx7 1 200 ITEM EXPENSE 3306
13xxxxx7 2 200 LIABILITY 3306

The invoice has its Approved amount (AP_Invoices_All.approved_amount): 3306. Whereas, invoice amount is: 2000 ( a different value). AP tables like AP_Invoice_Lines_All and AP_Invoice_Distributions_All are echoing invoice amount: 2000. The entered amount in Accounting entries is not in sync with Payables amount.



Steps To Reproduce
------------------------
1. (N) Payables responsibility> Invoices > Query the invoice.
2. Run Create Accounting.
3. File Menu > Tools > View Accounting
Invoice amount (2000) is different from Entered Amount (3306) in Accounting Entries.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.