SCREEN - Inventory analysis

>> Back to the SCREEN - Logistics & Packaging home page






The aim of Inventory query is to provide users with an helicopter view in qty/value of Packaging stocks in WP1 and PF1

  • Opening/closing stock in qty/value, including consignment stock 
  • Stock variation in qty/value, by main categories:
    • Purchasing + Consignment purchasing  
    • Manufacturing consumption
    • Other receipts (GR) and issues (GI)


It is based on stock postings of Packaging materials

Packaging entries are filtered according to material Valuation classes and related Stock accounts: WP1 Z110 (GL Account 31000300) and PF1 Z051 (2110110000) + WP1 adjustment account 31000309

  • Opening/Closing inventory figures are the sum up of all postings according to entered period in prompt (Ex. 01.2021 Closing ⇢ All postings up to 31.01.2021 / Opening ⇢ all postings up to 31.12.2020)
  • Variation figures are the sum up of postings of selected period (Ex. 01.2021 ⇢ All postings from 01.01.2021 to 31.01.2021)
  • Entries are valuated at the material standard price of posted period; this way, they are fully reconcilable with Working Cap. inventory values
  • FI entries are enhanced with related material document data, mainly in order to catch movement type used to categorize stock variations as well as CO object assignment (Order, Cost center…)


Access the workbook

The workbook to be used is BW_WBK_SCRE_0001  – Pack. Inventory analysis (Core Workbook)

=> Go to Analysis for Office in excel 

=> Click "Open Workbook"




Run the workbook

It is mandatory to enter:

  • Conso view (2) : enter 1 to apply the legal entity consolidation rate or 0 not to take the consolidation rate into consideration 
  • Cal. Year/Month (3) : MM.YYYY

It is also possible to enter:

Click "OK" 



The report is displayed with :

  1. The company code
  2. The plant
  3. The list of materials
  4. Quantity key figures
  5. Value key figures



Quantity key figures

  1. Opening Stock Qty (w/o. Consign.): in material base UoM, according to selected period in prompt (Ex. 01.2021 = 01.01.2021) 

    Consignment quantities are displayed separately because not valuated in Solvay’s stocks


  2. Purchasing Var. Qty: in material base UoM, according to selected period in prompt (Ex. 01.2021 = 01.01.2021 to 31.01.2021)

  3. Consign. Purch. Var. Qty: the same, but allocated to movement type 411 and Special stock indicator K (transfer from consignment to own stock) 
  4. Manuf. Consumpt. Var. Qty:  in material base UoM, according to selected period in prompt
    1.  


  5. Others Var. Qty: all other GR/GI which are not Purchasing nor Manuf. consumption

    Consignment quantities are displayed separately because not valuated in Solvay’s stocks


  6. Ending Stock Qty (w/o Consign.): in material base UoM, according to selected period in prompt (Ex. 01.2021 ⇢ 31.01.2021)




Packaging postings assigned to a PO (and not assigned to a Process order/Cost collector), mainly allocated to movement type 101/102 (GR goods receipt/Reversal)  


Packaging postings assigned to a Process order/Cost collector, also allocated to movement type 261/262 (GI for order/Reversal) 


☛ Packaging postings assigned to a PO (and not assigned to a Process order/Cost collector), mainly allocated to movement type 101/102 (GR goods receipt/Reversal)  






 Value key figures