3690550 - Customer and Vendor Balance reporting

• There is no app for Customer and Vendor Balance similar to G/L Account Balances app.
• It is difficult to report on customer and vendor balances without a specific account balances app. 
• In G/L Account Balances app the parameters for Customer and Vendor are not available. 

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

SAP S/4HANA Cloud Public Edition

There is no Vendor Balances or Customer Balances app. 

1. G/L Account Balances app.
2. Enter the Ledger, Company Code, Fiscal Year of Ledger and any other input parameters.
3. Adapt Filters.
4. Vendor or Customer is not maintained as an input parameter. 

It is possible to report on the balances for a supplier and customer via the "Display Line Items in General Ledger" app.

1. Display Line Items in General Ledger app.
2. Enter Ledger Company Code, Account, for example the supplier reconciliation account, All Items.
3. Go.
4. Settings.
5. Include Supplier or Customer Data as shown below;
   
   
6. Adapt Filters.
7. Include Supplier or Customer details as shown below.
   
   
8. It is possible to report on a specific period by including 'Fiscal Period' parameter to report on a specific period of the fiscal year.

Additionally the reports "Display Customer Balances" and "Display Supplier Balances" are available within the external audit app "Auditor Direct Access - External Tax Audit", however these reports are provided for external audit function and are not designed to be utilized as a business standard.  For more details on this app and usage see;

Auditor Direct Access - External Tax Audit FIORI apps library 

Auditor Direct Access SAP Help Documentation

The following apps cannot be found via the app finder or search as they are only accessible via "Auditor Direct Access - External Tax Audit" app.

Customer Balances in Local Currency
Vendor Balance in Local Currency

Manage Customer Line Items

Manage Supplier Line Items

CDS Views for General Ledger Accounting

Display G/L Account Balances

FAGLB03, KNA1, LFA1, Recon., A/C, LIFNR, KUNNR, ACDOCA, F2217, F0707A, , KBA , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , FI-FIO-AR-IS-2CL , Reporting Apps: Public Cloud , FI-FIO-AP-IS-2CL , Reporting Apps: Public Cloud , FI-GL-IS-2CL , Information System (Public Cloud) , How To