This query is aimed to provide you the whole Solvay Purchasing spend from Solvay (PF1), Rhodia (RCS) and Acetow (RHO) legacies.

▪It provides all the invoicing amount, with or without purchase orders, including logistic costs
▪You can include or exclude the Joint Ventures turnover
▪The spend can be displayed in target currency, in local (company) currencies or in the invoice currency
▪This query is able to give you some PO information such as the PO number and the vendor of PO

Table of content

 

 

  • Common Spend 
  • Spend Visibility with and without PO
  • Daily update for all legacies

 

 

 

A1410 - The Spend Assignment Rule


To be able to link a domain and a segment to the spend, a specific rule has been implemented in SPRINT : the Spend Assignment rule.


 

A1420 - Prompt

 

When you insert a query, or click on refresh, or on the "Prompts" menu, the "Prompts" window will open. This is where you can select the data you want to display in the report.

All details here

 

 

A1430 - Indicators

 

Double click on"Measures" to find all indicators available.


 

Total Invoiced Value (FI) : Default KPI

FI Spend (based on the Invoice posting date) in target currency (including total Joint Ventures spend) with the split of spend with or without PO.

Total Invoiced Value (FIxJV) 
FI Spend  in target currency with the percentage of consolidated Joint Venture (purchasing perimeter).

Total Value of tax (target currency)
Only used by Credit Management team.

 

 

 

But end users can also add the following KPIs :

Total Invoiced Value (FI) (Document currency)
FI Spend in document currency (including total Joint Ventures spend) with the split of spend with or without PO.

Total Invoiced Value (FIxJV) (Document currency)
FI Spend in document currency with the percentage of consolidated JV (purchasing perimeter).

Total Value of tax (Document currency)

Only used by Credit Management team.

 

Total Invoiced Value (FI) (Company currency) 

FI Spend in internal currency (including total Joint Ventures spend) with the split of spend with or without PO.

 
Total Invoiced  Value (FIxJV) (Company currency) 

FI Spend in company currency with the percentage of consolidated JV (purchasing perimeter).
Total Value of tax (Company Currency)
Only used by Credit Management team.

Each indicator provides also a display of the split of the Spend with and without Purchase Order by clicking on 

 

 

 

 

How the Spend indicators are calculated ?





 

 

The dimension named “Consolidation method” allows you to know how the JV is consolidated :

 

Global Integration = Full consolidated

 Solvay consolidates the legal entity at 100%

Proportional integration = Proportionately consolidated

Solvay consolidates the legal entity at the % indicates for P&L and Balance Sheet (payables).

Equity Method = Equity method.

Solvay consolidates only the legal entity result in the last part of the P&L at the % in the file.  No integration at Balance sheet (payables) thus 0% at spend level.

The others methods:

Sold 0%, Not fully consolidate 0%, Not equity method 0%,Not assigned 0%

 

Are not taken in account and checked with the financial file.

Only merged method is taking also at 100%.