AR_00269 Receipts Workbench Issue: Unbalanced Accounting Entries for Receipt Write-Off, FROM_AMOUNT_DR and FROM_AMOUNT_CR are Populated Incorrectly in AR_DISTRIBUTIONS_ALL
Last updated on FEBRUARY 09, 2018
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
Attempting to create a Receipt Write-Off, against the Receipt for an over application amount, and the FROM_ACCTD_AMOUNT_DR value is not populated properly.
This resulted in unbalanced accounting entries in Subledger Accounting (SLA).
Steps to Reproduce:
VERY IMPORTANT OR YOU WILL NOT REPRODUCE THIS ISSUE
1. Setups that need to be in place for this issue.
Responsibility: System Administrator
Navigation: Profile > System
Query Profile: AR: Always Default Transaction Balance for Applications
Ensure this is Set to Yes
Navigation: Setup > System > System Options
Accounting Tab: Create Detailed Distributions NEEDS TO BE UN-CHECKED.
Navigation: Transactions > Transactions
Generate an Invoice Number
Navigation: Receipts > Batches
Batch> Create a Receipt Batch
Click on Receipts and provide the details.
Batch Number and Receipt Number Generated
Run Post Quick Cash Batch and Allow this to complete.
Navigation: Receipts > Receipts
Query Receipt Number and Click on Applications Button.
You will see receipt is applied to Invoice
Uncheck the application check box for the receipt application
Tab over to the amount applied and change this to make this Overapplied.
DO NOT SAVE
Tab down to next line.
Apply To: Receipt Write off:
Tab over Under Activity LOV: Select Receipt Write off.
Navigation: Control > Request > Run
Run Create Accounting
LOV: Create Accounting
p_ledger_id: <ledger id>
Issue will fail.
NOTE: This only happens if Create Detailed Distributions flag is un-checked.
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