3073528 - Accounts Payable Aging Analytical Query (I_APJrnlEntrItmAgingGrid)

User has created custom aging analytical query based on the data source CDS view I_APJrnlEntrItmAgingGrid. The balance amount for the chosen supplier is with a opposite sign when comparing from the App Manage Supplier Line Items.

"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 

1. Create a Custom CDS view from the data source Accounts Payable Aging Grid Cube (I_APJrnlEntrItmAgingGrid).
2. Use the custom CDS view to create an Analytical query.
3. Preview the query results.
4. Compare the analytical query results from the App Manage Supplier Line Items.

1. This is a Standard system behavior of Accounts Payable analytical query/App
2. Amounts in AP analytic apps (underlying CDS views) = -1 * amounts in Manage supplier line items.
3. Positive / negative sign in the App Manage Supplier line items means Debit/Credit Indicator which shows on which side of the account (S = debit, H = credit) the transaction figures are updated.

Use other analytic apps e.g. Aging Report for Accounts Payable or  Aging Analysis to compare the results from the analytical query.

Accounts Payable Aging Grid Cube

I_APJrnlEntrItmAgingGrid, aging, manage, supplier, line, items, S4_PC, supplier, amount, opposite, accounts, payable , KBA , FI-AP-IS , Information System , Problem