SCREEN - Purchasing analysis

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






The aim of Purchasing query is to provide users with a transversal view in qty/value of Packaging Materials purchasing in WP1 and PF1

at following steps:

  • Agreements / InfoRecords
  • Orders 
  • Good Receipts (GR)
  • Invoice Receipts (IR)


It mainly includes Purchase orders data (with Creation date greater than 01.2018)

  • Packaging items are filtered according to Material Valuation Class: WP1 Z110 (GL Account 31000300) and PF1 Z051 (2110110000)

PO items w/o a Material (i.e. only assigned to a Material Group) are excluded from the report

  • Both PO items for stock entry (see Acct Assignment Category #) and PO items assigned to a CO object like a Cost Center, a Maint. Order… (see <> #) are taken into accounts
  • Additional Delivery costs are included in GRs/IRs valuation  

It also includes FIGL data:

  • Consignment GRs/IRs w/o a PO (with a Posting date greater than 01.2018)

=> Same filter based on Material Val. Class in KOS/KBS FI items (see accounts WP1 40100380 / PF1 2320000000)

  • Price diff. on GRs/IRs (with a Posting date greater than 01.2018) - To get Standard values in addition with POs values

=> Same filter based on Material Val. Class in PRD/AKO FI items (see accounts WP1 98151982 / PF1 6091311100)

Data update 

  • Purchase orders data: once a day in the morning (French time)

=> Sources are the same than the ones used in SPRINT - Solvay Purchasing Reporting INTelligence

  • FI data: at least 3 times a day





Access the workbook

The workbook to be used is BW_WBK_SCRE_0002   – Pack. Purchasing 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) 

  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 Qty :  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