Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
W

BW_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
Info
toc
title

 

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

 

A1610 - Prompt

Image Removed

 

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 Management

See Payment Terms Management process

 

A1630 - Dimensions