3660611 - Accounts Receivables/Payables - Open Items Reports Displays Cleared Items

The "Accounts Payable - Open Items" report displays items as open even though they are cleared.

Note: The scenario described here could also be applied to Receivables. 

SAP Business ByDesign

1. Navigate to the Business Analytics work center.
2. Open the Design Reports subview.
3. Search for the report: "Accounts Payable - Open Items" (FINGLAU08_Q0004).
4. Enter the mandatory parameters.
5. Click "Apply".
6. Observe that some items appear as open in the report despite being cleared.

The "Accounts Payable - Open Items" report displays cleared items as open because the clearing ID has a posting date set in the future date. Please follow the steps below to check the same:

1. Navigate to the Payables work center.
2. Open the Supplier Accounts subview.
3. Search search for Account ID: XYZ (XYZ represents the Account ID).
4. Open the account and navigate to the "Trade Payables tab > Invoice/Payments sub tab".
5. Filter for cleared items.
6. Locate and open the clearing ID, and here you will see a future posting date.

When the "key date" in the report is set to "Today" (standard), the system considers the items as open due to the future posting date of the clearing.

This is the expected system behavior. 

Adjust the "key date" in the "Accounts Payable - Open Items" report to match the future posting date of the clearing. Verify that the report no longer displays cleared items as open.

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

accounts payable, open items, cleared items, future posting date, supplier accounts, payables report, business analytics, FINGLAU08_Q0004, invoice payments, report discrepancy, cleared expense reports , KBA , SRD-FIN-ACP , Payables , SRD-FIN-ACR , Receivables , Problem