2558417 - Cleared Items in Accounts Receivables/Payables - Open Items Reports

In the Report Accounts Receivable/Payable - Open Items you have an open amount for an already cleared item.

1. Go to the General Ledger work centre.
2. Go to the Lists sub view in Reports view.
3. Search and select the Report Accounts Receivable/Payable - Open Items.
4. Set the parameters as Company ABC (ABC stands for the Company ID), Set of Books: XYZ (XYZ stands for the Set of Books ID) and Customer DEF (DEF stands for the Customer ID) and the rest as Default.

There is an open amount of XXX.XX CUR (XXX.XX stands for any open amount and CUR stands for the currency) with a Posting Date of DD.MM.YYYY and the related Journal entry is YYY (YYY stands for the Journal Entry ID).

Click open the Journal Entry, In the Journal entry the amount of XXX.XX CUR has a credit and debit posting to the same G/L-Account ZZZ (ZZZ stands for the G/L-Account ID).

5. Now expand the report to add key figure Open Amounts.
6. Click on Settings button and then select Key Figures from the drop down menu.
7. In the Key Figure Settings from the available Key Figures select Open Amount and move it to the Selected section and then click OK.

You can see in the Report that the Open amount is displayed as 0.00 CUR. So the amount has been cleared.

But you are not able to remove this line item from the report.

The line item stays in the Report as both Credit and Debit postings happened to the same G/L-Account.

This is the expected System behaviour. The Key Figure Open Amount in the Report should be used to check if an item has been cleared or not.

You can blind the line item in the Report by following the steps below, but this is temporary and has to be set up every time you open the Report.

1. In the Report, under Columns and Rows, go to the Columns and click on the small black icon at the Key Figure.
2. Then click on Manage Conditions in the drop down menu. 

3. In the pop-up window, click on the New button to add a new Condition.
4. Select the Key Figure as Open Amount and leave the rest as default.
5. Under Rules click on Add Row to add a new row.
6. Select the Operator as Not equal and enter the From Value as Zero and click Ok.

7. Again click OK.

 All Items with Open Amount 0.00 CUR will be not be displayed.

KBA , offener betrag in bericht , AP-ACC-ARP , Accounts Receivable Payable Ledger Account , How To