Syensqo IS - Customer Support

Page tree



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 PF1at following steps:

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 
  • Calendar Month/Year (3) : MM.YYYY : Document fiscal period (Purchase order creation date / Goods Receipt posting date / Invoice Receipt posting date) 

It is also possible to enter:

Click "OK" 



The report is displayed with :

  1. The company code
  2. The plant
  3. PO Nb & PO Item (=Purchase order)
  4. The list of materials
  5. Agreements & Info Records
  6. Ordered
  7. Goods receipt
  8. Invoice receipt



Agreements & Info Records

  1. Agreement Unit price (in local & target currency)

  2. Info record Unit price (in local & target currency)

Not all Purchase orders are created with reference to an Agreement/InfoRecord



Where to find corresponding data in SAP ?

Display the Purchase order with ME23N - Display Purchase Order. In the header:

1. Double click on "Outline agreement" to display Contract (= transaction ME33K - Display Contract)

2. Double click on "Info rec." to display Info Record (= transaction ME13 - Display Info Record)



Ordered

  1. PO Qty: Ordered qty in PO UoM & in Material base UoM (star)
  2. PO value: Ordered value in PO Currency & in Local (Company code) currency or in any Target currency if entered in prompt  
  3. PO Unit Price: Ordered value in Local curr. / Ordered qty in PO UoM & Ordered value in target curr. / Ordered qty in PO UoM



Where to find corresponding data in SAP ?

Display the Purchase order with ME23N - Display Purchase Order. In the header, the PO Qty (1) & PO Unit Price (3) can be displayed.

(star) PO UoM vs Material base UoM

  • PO UoM = Unit of mesure maintained in the Purchase order

  • Material base UoM = Unit of mesure maintained in the Material master data (MM03 - Display Material - Purchasing view)



Goods Receipt

  1. GR qty: Quantity received in PO UoM & in Material base UoM 

  2. GR value: Value of goods received in PO Currency & in Local (Company code) currency or any Target currency if entered in prompt  

  3. GR unit price: GR value in Local curr. / GR qty in PO UoM & GR value in Local/Target curr. / GR qty in PO UoM

  4. GR Price diff.: difference between GR value and standard value (star) of stock entry, in PO & Local or Target curr., when posted in GR doc.

(star) Standard value = GR qty * Material standard price



Where to find corresponding data in SAP ?

Display the Purchase order with ME23N - Display Purchase Order & open the tab "Purchase Order History" to see the goods receipt. 



Consignment

There are specific indicators to follow-up consignment: 

  1. GR Consign. qty: in Material base UoM
  2. GR Consign. value: in Doc. Curr. & in Local (Company code) curr. or any Target curr. if entered in prompt  
  3. GR unit price: GR Consign. value in Doc. curr. / GR Consign. qty in base UoM & GR Consign. value in Local/Target curr. / GR Consign. qty in base UoM
  4. GR Price diff.: difference between GR Consign. value and standard value of stock entry, in Doc. & Local or Target curr.

GR Unit Price & Price diff. columns/ratios are the same for both standard and consignment GR



Invoice Receipt

  1. IR qty: Invoice receipt in PO UoM & in Material base UoM
  2. IR value: Invoice receipt in PO Currency & in Local (Company code) currency or any Target currency if entered in prompt  
  3. IR unit price: Invoice value in Local curr. / IR qty in PO UoM & IR value in Local/Target curr. / IR qty in PO UoM
  4. IR Price diff.: difference between GR value and standard value of stock entry, in PO & Local or Target currency, when posted in IR doc.

(star) Standard value = IR qty * Material standard price



Where to find corresponding data in SAP ?

Display the Purchase order with ME23N - Display Purchase Order & open the tab "Purchase Order History" to see the invoice receipt. 



Consignment

As for goods receipt, there are specific indicators to follow-up consignment invoices: 

  1. IR Consign. qty: in Material base UoM
  2. IR Consign. value: in Doc. Curr. & in Local (Company code) curr. or any Target curr. if entered in prompt  
  3. IR unit price: GR Consign. value in Doc. curr. / GR Consign. qty in base UoM & GR Consign. value in Local/Target curr. / GR Consign. qty in base UoM
  4. IR Price diff.: difference between IR Consign. value and standard value of stock entry, in Doc. & Local or Target curr.

As Consignment invoices are auto invoices (MRKO tr.), no IR Price diff. should occur

IR Unit Price & Price diff. columns/ratios are the same for both standard and consignment IR



Other Screen packaging workbooks




The best way to get IT support is to use the new Service One Platform.