Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 4

changes.mady.by.user ROLLIER, Charlotte

Saved on

compared with

New Version Current

changes.mady.by.user ROLLIER, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HideElements
metastrue
breadcrumbtrue
titletrue



SCREEN - Inventory analysis

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





Note


Excerpt

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  – PackSCREEN - Pack. Inventory analysis (Core Workbook)

=> Go to Analysis for Office in excel 

=> Click "Open Workbook"




Anchor
period
period

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



Anchor
qty
qty
Quantity key figures

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

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

    Info

    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  in prompt

    Info

    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  in prompt (Ex. 01.2021 ⇢ 31.01.2021)





Note

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




Note

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




Anchor
amt
amt
 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)

    Info

    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  in prompt

    Info

    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 QtyLoc./Target Curr.: in Local (company) /Target currency, according to selected period in  in prompt (Ex. 01.2021 ⇢ 31.01.2021)



Note

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





Panel
borderColor#f2f2f2
titleOther Screen packaging workbooks

Children Display
pageSCREEN - Packaging BW query
excerptTypesimple