Adjustment JLT for DEFERRED_TAX is Missing for AAD: MFAR_ADJ_ACCRUAL_ACCOUNT - Create Accounting Error - The Subledger Journal Entry Does Not Balance in the Entered Currency. Please Verify the Entered Amounts on the Journal Entry Lines
Last updated on MAY 01, 2018
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
EXECUTABLE:ARACCPB - Submit Accounting
EXECUTABLE:XLAACCPB - Create Accounting
EXECUTABLE: XLAACCUP - Accounting Program
In Accounts Receivable, you are creating Adjustments against Invoices, with deferred tax.
The DEFERRED_TAX / Tax Journals are generated correctly, in the AR_DISTRIBUTIONS_ALL table.
In XLA, the DEFERRED_TAX side of the Journal is missing.
The Create Accounting program is successfully processing the invoices, but the Adjustment fails the Create Accounting with the following error:
The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines.
Reviewed the adjustment diagnostics and it indicates the accounting for AR_DISTRIBUTIONS_ALL.SOURCE_TYPE = DEFERRED_TAX (line_id 217362) was not generated in XLA_DISTRIBUTION_LINKS.
Ledger linked to Application Accounting Definitions (AAD): Multi-Fund Account Receivables Accrual - Account Method (MFAR_ACCRUAL_ACCOUNT).
Steps to Reproduce:
Create an adjustment against a deferred tax invoice number.
Run create accounting for the adjustment and it fails due to unbalanced journal.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms