TRANSACTIONS APPLIED TO THE CREDIT MEMO SHOULD NOT APPEAR IN A STATEMENTS OUTPUT (Doc ID 2125518.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Goal

Statement shows balance of -260.60 on the 3 lines. However, the bottom two lines are invoices that have a $0 balance.
The only line that should have a -260.60 balance is the credit memo line.  Statement shows balance of -260.60 on the 3 lines.
However, the bottom two lines are invoices that have a $0 balance. The only line that should have a -260.60 balance is the credit memo line.

For example, below are three lines for Credit memo 629320 (TRANSACTION NUMBER column) which has Balance total '-260.60':

TRANSACTION TRANSACTION TRANSACTION REFERENCE NUMBER TRANSACTION BALANCE
DATE              NUMBER          TYPE                                           AMOUNT
17-MAY-05       629320         Credit Memo A087120000518          -1,022.32      -260.60
24-JUL-06        629320         Invoice Invoice: 628969                   315.81         -260.60
24-JUL-06        629320         Invoice Invoice: 628919                   445.91         -260.60

Please only show the balance due remaining on the credit note, and do not show the invoices that have been cleared in full. Only the credit
balance remaining on the credit should appear in the balance due on the credit note line. Also do not carry forward the balance remaining
on the credit note forward to the invoices which have been cleared, and the same credit note number (as it follows from the first
statements above) should not appear on each line in the transaction field for these invoices which have been cleared.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms