Objective

New reporting solution brings Stock data from the same source as the old one (WP1+PF1) but merging them in BW with objective to:

• Report Inventory related data in timely, precise and transparent way
• Harmonize data from both system for easier and more precise reporting
• Enable global analysis
• Provide better user's experience
• Ensure easier future maintenance
• Minimize impacts of source data quality problems
• Create a new Dashboard "Inventory Visibility Tool"

Reports (Queries/Workbooks)

Reporting Enhancements (not available in the *old* models)

Valuation on Batch Level

Valuation of stock is typically done on Material/Plant level, Batch-level data were not valuated. To assign value to the Batches, Material/Plant valuation has been split into an unit price and then assigned 

In Transit

Inclusion of daily "in transit" figures (values and quantities) based on Finance/Accounting program:

SAP Standard process doesn't fully enable to track stock in transit (when material is issued from one plant, but not yet received to another plant)

To provide visibility on such stock, a specific program was developed to track it and send data every day to BW, where it is added to the "standard" Stock in plants.

There are 3 types of "In-Transit" evaluated by Finance

• Intercompanies Inbounds : stocks between 2 Solvay plants (replenishment, stock transfers), stock has left Plant 1 and has not yet arrived in Plant 2.

• External Inbounds : inbound flows coming from external suppliers : purchases made with incoterm FCA or Ex-works, and Solvay has to organize the transport from the supplier plant. We consider that the stock belongs to Solvay as soon as the carrier loaded it ==> these flows are identified by a tick that Supply Chain teams have to update somewhere in the Purchase order to indicate that the goods left the supplier plant.

• Outbounds : stocks shipped and invoiced that are restored in our financial books because the transfer of property did not happen yet.

Integrated Margin Cost Valuation

Material/Plant valuation based on Finance/Accounting program "Model S".

Unit price is calculated and assigned to the Stock based on its quantities as a complementary figure to the standard Stock Value.