My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.