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


 

PAYMENT TERMS FROM MASTERDATA :

 

  • Vendor Payment Terms (PUR) in day

  • Payments terms from SAP Supplier Masterdata (purchasing view) translated in days

  • Creditor Payment Terms (Co) in days

  • Payments terms from SAP Supplier Masterdata (company view) translated in days

  • Vendor LFM2 Payment Terms in day

  • Alternative Payments terms from SAP Supplier Masterdata (by division) translated in days

 

 

PAYMENT TERMS FROM DOCUMENTS:

 

Contract Payment Terms in days

 

Payment terms from SAP Contracts translated in days

 

 

 

Purchase Order Payment Terms (weighted) in days

 

Payment terms from SAP Purchase Orders translated in days

 

 

 

Invoice Payment Terms (weighted) in days

 

Payment terms from SAP Invoices translated in days

 

 

 

ACCOUNTING INFORMATION :

 

 

 

Net Due Date - Clearing Date

 

It is the Net Due Date minus the Matching Date (payment)

 

 

 

Total Invoiced Value (FI) (EUR)

 

FI Spend in euro including Joint Ventures

 

 

 

Total Invoiced Value (FI) (Ocurr)

 

FI Spend in invoicing currency including Joint Ventures

 

 

 

Total Invoiced Value (FI) (Icurr)

 

FI Spend in company currency  including Joint Ventures

 

 


 

 

A1630 - Dimensions