Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 7

changes.mady.by.user Karin Weigel-Jung

Saved on

compared with

New Version Current

changes.mady.by.user Karin Weigel-Jung

Saved on

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

Table of Contents

 

 

 

Info
titleSPRINT Glossary

All vocabulary definition here

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

 

 

 

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

Image Removed

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
    • Warning
    titlePayment terms Management

    See Payment Terms Management process

    Total Invoiced Value (FI) (Icurr)
    FI Spend in company currency  including Joint Ventures

     

     

     

    Image Removed

    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) :

     

    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

    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

     

     

    1 - 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                2 - Creditor Payment Terms (Co) are always linked to a Company       => Then a same supplier can have different payment terms according to Solvay different  companies                 3 - Vendor Payment Terms (LFM2) are linked to a plant        => Then a same supplier can have different payment terms according to Solvay different  plants                  4 - 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                5 -If SAP Contract Payment terms are not assigned        => Then no SAP contracts exist                        6 - If Invoice Payment Terms are not assigned         =>  Then no Invoice payments terms exist, the payment has been done manually by the accounting department                 7 - Payment terms can be modified manually at PO level, Contract level and also Invoice level    => Then payment terms can be different sometimes        

     

    A1630 - Dimensions