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

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

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.