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
(Doc ID 1662693.1)
Last updated on JUNE 21, 2023
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
Responsibility: Receivables Navigation: Setup > System > System Options Accounting Tab: Create Detailed Distributions NEEDS TO BE UN-CHECKED. Save.
Responsibility: Receivables Navigation: Transactions > Transactions Generate an Invoice Number
Navigation: Receipts > Batches Batch> Create a Receipt Batch Click on Receipts and provide the details. Save 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. SAVE
Navigation: Control > Request > Run Run Create Accounting LOV: Create Accounting p_application_id: 222 p_ledger_id: <ledger id> p_process_category: RECEIPTS p_end_date: <date> Save. Issue will fail.
NOTE: This only happens if Create Detailed Distributions flag is un-checked.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!