Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 50

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.
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 Image Removed

 

 

 

 

How the Spend indicators are calculated ?

Image Removed

Note
titleThe dimension “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%.

A1440 - Dimensions

 

 

Image Removed

 

 

 

 

BW_QRY_MV_SPD01_0004


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

 

Info
titleSPRINT Glossary

All vocabulary definition here

Table of content

toc 

 

 

Note
titleAdded Value
  • 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.

Image Removed

 

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

 

StatuscolourBluetitleStep 1

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

Image Removed

 

Status
colourBlue
titleStep 2

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.

 

Image Removed

 

 

But end users can also add the following KPIs :