W_QRY_MV_SPD01_0005

 

This query gives you :

  

All payment terms information from suppliers (supplier masterdata, PO, Invoice, Contracts) in payment terms conditions and days. The indicators are weighted, therefore the results are dynamic when you change a dimension.
An analysis between the payment due date coming from the Invoice and the effective payment done to the suppliers with a calculation of delay.
Only Supplier SAP codes from each legacy must be used with this query (not the PRS Supplier codes).

Table of content

 

 

  • Payment terms are now translated in days for a better comparison
  • Check discrepancies between contract, PO and actual payment terms

 

 

 

A1610 - Prompt

In this prompt, we can select more accounting fields, such as the Net Due Date, the Clearing Date, the Accounting document


A1620 - Indicators

 

A1630 - Dimensions