WTable of content
toc
Payments terms from SAP Supplier Masterdata (purchasing view) translated in days
Vendor LFM2 Payment Terms in day
Alternative Payments terms from SAP Supplier Masterdata (by division) translated in days 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
Then, a same supplier can have different payment terms according to Solvay different Purchasing Organizations
Creditor Payment Terms (Co) are always linked to a Company:
Then a same supplier can have different payment terms according to Solvay different companies
Vendor Payment Terms (LFM2) are linked to a plant :
Then a same supplier can have different payment terms according to Solvay different plants
If Vendor Payment Terms (PUR), 'Vendor Payment Terms (LFM2) and PO Payment terms are not assigned and if there is no Vendor of PO :
Then it is a flow without Purchase Orders (Direct Invoice)
Therefore Creditor Payment terms (Co) and Invoice Payment terms are completed with the payment terms
If SAP Contract Payment terms are not assigned :
Then no SAP contracts exist
If Invoice Payment Terms are not assigned
Then no Invoice payments terms exist, the payment has been done manually by the accounting department
Payment terms can be modified manually at PO level, Contract level and also Invoice level
Then payment terms can be different sometimes Compare the SAP Contract Payment terms with the PO Payment terms :
They should be the same unless backoffice changed it in the Purchase Order
If there is no contract, the PO Payment terms should come from the Vendor Payment Terms (LFM2) linked to the Plant if mentioned in the masterdata (optional) :
Then PO Payment terms should be the same than Vendor Payment terms (LFM2) unless backoffice changed it in the Purchase Order
If there is no contract, no Vendor Payment Terms (LFM2) then the PO Payment terms will come from the Vendor Payment Terms (PUR) linked to the Purchasing Organization :
Then PO Payment terms should be the same than Vendor Payment terms (PUR) unless backoffice changed it in the Purchase Order
Compare the Invoice Payment terms with the PO Payment terms :
They should be the same except :
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).
| Info |
|---|
|
| |
| Note | ||
|---|---|---|
| ||
|
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 dayPayments terms from SAP Supplier Masterdata (purchasing view) translated in days
Alternative Payments terms from SAP Supplier Masterdata (by division) translated in days
- Creditor Payment Terms (Co) in days
Payments terms from SAP Supplier Masterdata (company view) 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 :
It is the Net Due Date minus the Matching Date (payment)
FI Spend in euro including Joint Ventures
FI Spend in invoicing currency including Joint Ventures
FI Spend in company currency including Joint Ventures
The objective of these indicators is to compare the different payment terms from SAP masterdata and documents in Solvay 3 legacies (RCS Rhodia, Solvay PF1 and Acetow RHO) :
PAYMENT TERMS DEFINITION :
Vendor Payment terms (PUR) are always linked to a Purchasing Organization :Then, a same supplier can have different payment terms according to Solvay different Purchasing Organizations
Creditor Payment Terms (Co) are always linked to a Company:
Then a same supplier can have different payment terms according to Solvay different companies
Vendor Payment Terms (LFM2) are linked to a plant :
Then a same supplier can have different payment terms according to Solvay different plants
| Warning | ||
|---|---|---|
| ||
Then it is a flow without Purchase Orders (Direct Invoice)
Therefore Creditor Payment terms (Co) and Invoice Payment terms are completed with the payment terms
If SAP Contract Payment terms are not assigned :
Then no SAP contracts exist
If Invoice Payment Terms are not assigned
Then no Invoice payments terms exist, the payment has been done manually by the accounting department
Then payment terms can be different sometimes
HOW TO COMPARE PAYMENT TERMS ?
They should be the same unless backoffice changed it in the Purchase Order
If there is no contract, the PO Payment terms should come from the Vendor Payment Terms (LFM2) linked to the Plant if mentioned in the masterdata (optional) :
Then PO Payment terms should be the same than Vendor Payment terms (LFM2) unless backoffice changed it in the Purchase Order
If there is no contract, no Vendor Payment Terms (LFM2) then the PO Payment terms will come from the Vendor Payment Terms (PUR) linked to the Purchasing Organization :
Then PO Payment terms should be the same than Vendor Payment terms (PUR) unless backoffice changed it in the Purchase Order
Compare the Invoice Payment terms with the PO Payment terms :
They should be the same except :
- if the accounting department changes it in the invoice
- if the accounting department makes manual payment using a specific field ("base date") when invoice payment terms are not assigned
