SAP Knowledge Base Article - Public

2948356 - How to Filter on FI Open Item Level in App 'Reconcile GR/IR Accounts'

Symptom

You would like to filter on FI Open Item level in app 'Reconcile GR/IR Accounts' but you can only filter on Purchasing Document Item level.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

S/4HANA Cloud

Reproducing the Issue

  1. Open app 'Reconcile GR/IR Accounts' (app ID F3302)
  2. Fill out required fields
  3. See that the resulting table is organized by Purchasing Document Item, not by FI Open Item. 

    Reconcile 3.png

Cause

System behaves as designed

Resolution

While it's not possible to organize the ALP table by FI Open Item, it is possible to filter by FI Open Item within each Purchasing Document.

This can be achieved by the following steps:

  1. Select a Purchasing Document
  2. Select the 'Financial Accounting Open Items' tab
  3. Right click the field you would like to filter by and select 'Filter'. In this example, we chose to filter by 'Posting Date'

    Reconcile 4.png

  4. Choose your filtering parameters 
  5. Select 'Ok'
  6. See that only FI Open Items that meet filter criteria are returned

Keywords

'Reconcile GR/IR Accounts', F3302, filter, PO item, 'purchase order item', PO, purchase order, purchasing document, sort, fields, field, organize, open item , KBA , FI-FIO-GL , Fiori UI for General Ledger Accounting , FI-FIO-GL-2CL , Fiori UI for General Ledger Accounting (Public Cloud) , How To

Product

SAP S/4HANA Cloud all versions