Introduction

Database:

Update:

2nd, 8th, 15th, 22nd and 29th of each month

Period:

2 full years + current year

Weight:

Net Weight = weight of active materials sold

Gross Weight = weight of all materials (active or not) and the packaging

Currency:

EUR / USD

Conversion rules:

Transportation Costs  conversion from EUR to USD is based on the exchange rate managed by finance team for the month ‘reference month’ (month of actual completion or if empty planned completion or if still empty, shipment creation date) (Query TIERS)

Inventory Values in BW: conversion from EUR to USD is based on a fixed exchange rate (the rate of the day of the last dashboard update) (Query Working Capital)

Inventory Values in Finance: Only EUR. conversion from EUR to USD is based on the exchange rate managed by finance team for the month ‘reference month’ (month of actual completion or if empty planned completion or if still empty, shipment creation date) (Query FOCUS) 

For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR).

So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.

 

Site:

Purchasing site = geographic clustering of plants managed by Purchasing