Last updated on AUGUST 28, 2017
Applies to:Oracle Receivables - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Reports Issues
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
On Account credit memos should appear in detail with transaction number , date in Customer Open Balance Letter.
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
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