Customer Open Balance Letter Does Not Include Details Of An On Account Credit Memo And Receipts
(Doc ID 2140969.1)
Last updated on MARCH 07, 2023
Applies to:
Oracle Receivables - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5 version, Reports Issues
ACTUAL BEHAVIOR
---------------
Customer Open Balance Letter includes only invoices and does not show the detail of the on account credit memos. Only amount will be shown under column "On-Account Credits and Receipts" in the report output
EXPECTED BEHAVIOR
-----------------------
On Account credit memos should appear in detail with transaction number , date in Customer Open Balance Letter.
Changes
Customer Open Balance Report does not list details for credit memo (Transaction number, date etc..), but instead, it shows the open credit amount as a total, along with the On-account and Unapplied Receipt amounts.
Table AR_CUSTOMER_BALANCE_ITF stores the credit memo details, but only the total will be printed under column "On-Account Credits and Receipts" in report output.
In this particular case, "On-Account Credits and Receipts" has Zero(0) in the report output, because, the report was run WITHOUT following parameters.
Include On Account Credits
Include On Account Receipts
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |