Access the workbook

The workbook to be used is BW_WBK_CO_0026 - BW - IMEP - PF1 ML synthesis (Core Workbook) 

=> Go to Analysis for Office in excel 

=> Click "Open Data Source"

Go to the tab "Role" and open the folder IMEP - Integrated Manufacturing & Energy Performance => Manufacturing 

Double-click on the workbook BW_WBK_CO_0026 - BW - IMEP - PF1 ML synthesis (Core Workbook) to open it

Open the workbook

It is mandatory to enter the period (2) : MMM.YYYY

It is also recommended to enter at least a GBU (5), a company code (6) or a plant code (9)

It is also possible to enter:

• a target currency (3) to have all values converted with the same currency
• a Unit of Measure for the quantity conversion (ex: TO for Tons) (4)
• a Cost object (7)
• a material code (8)

Click "OK" 

The report

The report is displayed with the list of raw materials and the detail of stock movements

There are 20 columns in the report for amounts (blue) and quantities (green) 

1. Inventory at the beginning of the period entered in the prompt
2. Production of the material during the period
3. Other receipts such as purchases
4. Consumption of the material in production
5. Sales
6. Other consumption such as transfer to another plant
7. Other movements of inventory 
8. Ending inventory
9. Delta is the difference between the beginning and the ending inventory
10. Control that the difference between the beginning inventory and the ending inventory corresponds to the sum of all inventory movements. It should be equal to zero.