Symptom
You notice that an invoice that appears as Open Item in the Customer Account does not appear the same in the report Accounts Receivable - Open Items.
Environment
SAP Business By Design
Reproducing the Issue
- Go to the Receivables Work Centre.
- Select Customer Accounts under Customers View.
- Search and open AAA(AAA represents the ID of the Customer Account).
Result: You notice that the invoice BBB appears under Open Items(BBB represents the ID of the invoice).
Now compare it with report Accounts Receivable - Open Items.
- Go to the Receivables Work Centre.
- Select List under Reports view.
- Open report Accounts Receivable - Open Items.
- Fill in the criteria and run the report.
Result: The Open amount shows as 0 and not as the amount of invoice BBB.
Cause
You have reversed and reposted the invoice.
When you reverse an open item, it is no longer an open item. Nonetheless, the reversal of an item can only be done through the workcenter Customer Invoicing.
In Account Monitor and in Accounting, the item is reversed (The journal entry is reversed) if the item was originally in Open status.
However, the Reverse and Repost action is used locally in Accounting in order to post the invoice to a new period. So this action does not only reverse, it also posts the same invoice to a new period and this only in Accounting. On the logistics side, nothing changes.
Resolution
This is an expected system behaviour. An invoice that is open, will show up an open amount, an invoice that is cancelled, will not show up in the Accounts Receivables - Open Items report. Finally an invoice reversal will show up an open amount with the opposite sign.
The above is what you can expect to happen and appear as in this specific report when you use the Reverse and Repost action.
Keywords
Reverse and repost, Open Item , KBA , SRD-FIN-ACR , Receivables , Problem