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  – SCREEN - 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 (= period)

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) 

  2. Purchasing Var. Qty: in material base UoM, according to selected period in prompt (Ex. 01.2021 ⇢ 01.01.2021 to 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)  


  3. Manuf. Consumpt. Var. Qty:  in material base UoM, according to selected period in prompt

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


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

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





Consignment quantities are displayed separately 

  1. Consign. Purch. Var. Qty: Variation of stock consigned (Movement type 411 and Special stock indicator K (transfer from consignment to own stock)) 
  2. Ending Stock Qty (Consign.): Consignment stock at the end of the period




Var. Qty check (6) = Closing stock (5) - Opening stock (1) - Purchasing (2) - Consumption (3) - Others (4) = 0




 Value key figures

  1. Opening Stock: in Local (company) /Target currency, according to selected period in prompt (Ex. 01.2021 ⇢ 01.01.2021)

  2. Purchasing Var: in Local (company) /Target currency, according to selected period in prompt (Ex. 01.2021 ⇢ 01.01.2021 to 31.01.2021)

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


  3. Manuf. Consumpt. Var.: in Local (company) /Target , according to selected period in prompt

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


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

  5. Ending Stock Loc./Target Curr.: in Local (company) /Target currency, according to selected period in prompt (Ex. 01.2021 ⇢ 31.01.2021)



Variation value check (6) = Closing stock (5) - Opening stock (1) - Purchasing (2) - Consumption (3) - Others (4) = 0