| HideElements | ||||||
|---|---|---|---|---|---|---|
|
| Note | ||
|---|---|---|
at 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)
| Info |
|---|
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"
| Anchor | ||||
|---|---|---|---|---|
|
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 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:
- a Company Code (4)
- a Plant (5)
- a PRS Company code (6)
- a Qty conv. unit (7)
- Target Curr. for conversion (87) : the exchange rate used is ZRH2 CAR3 (same as WCAP SPRINT - Solvay Group Working CapitalPurchasing Reporting INTelligence)
- BFC GBU (98)
Click "OK"
The report is displayed with :
- The company code
- The plant
- PO Nb & PO Item (=Purchase order)
- The list of materials
- Quantity key figures
- Value key figures
- Agreements & Info Records
- Ordered
- Goods receipt
- Invoice receipt
Opening Stock Qty (w/o. Consign.) : in material base UoM, according to selected period in prompt (Ex. 01.2021 ⇢ 01.01.2021)
Purchasing Var. Qty : in material base UoM, 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 allocated to movement type 101/102 (GR goods receipt/Reversal) |
Manuf. Consumpt. Var. Qty : in material base UoM, according to selected period in prompt
| Info |
|---|
Packaging postings assigned to a Process order/Cost collector, also allocated to movement type 261/262 (GI for order/Reversal) |
Others Var. Qty: all other GR/GI which are not Purchasing nor Manuf. consumption
Ending Stock Qty (w/o Consign.) : in material base UoM, according to selected period in prompt ( Ex. 01.2021 ⇢ 31.01.2021)
| Note |
|---|
Consignment quantities are displayed separately |
- Consign. Purch. Var. Qty: Variation of stock consigned (Movement type 411 and Special stock indicator K (transfer from consignment to own stock))
- 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 |
Opening Stock : in Local (company) /Target currency, according to selected period in prompt ( Ex. 01.2021 ⇢ 01.01.2021)
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) |
Manuf. Consumpt. Var.: in Local (company) /Target , according to selected period in prompt
| Info |
|---|
Packaging postings assigned to a Process order/Cost collector, also related to movement type 261/262 (GI for order/Reversal) |
|
Agreement Unit price (in local & target currency)
- Info record Unit price (in local & target currency)
| Info |
|---|
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)
| Anchor | ||||
|---|---|---|---|---|
|
- PO Qty: Ordered qty in PO UoM & in Material base UoM
- PO value: Ordered value in PO Currency & in Local (Company code) currency or in any Target currency if entered in prompt
- 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.
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)
| Anchor | ||||
|---|---|---|---|---|
|
GR qty: Quantity received in PO UoM & in Material base UoM
GR value: Value of goods received in PO Currency & in Local (Company code) currency or any Target currency if entered in prompt
GR unit price: GR value in Local curr. / GR qty in PO UoM & GR value in Local/Target curr. / GR qty in PO UoM
GR Price diff.: difference between GR value and standard value
of stock entry, in PO & Local or Target curr., when posted in GR doc.
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:
- GR Consign. qty: in Material base UoM
- GR Consign. value: in Doc. Curr. & in Local (Company code) curr. or any Target curr. if entered in prompt
- 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
- GR Price diff.: difference between GR Consign. value and standard value of stock entry, in Doc. & Local or Target curr.
| Info |
|---|
GR Unit Price & Price diff. columns/ratios are the same for both standard and consignment GR |
| Anchor | ||||
|---|---|---|---|---|
|
- IR qty: Invoice receipt in PO UoM & in Material base UoM
- IR value: Invoice receipt in PO Currency & in Local (Company code) currency or any Target currency if entered in prompt
- IR unit price: Invoice value in Local curr. / IR qty in PO UoM & IR value in Local/Target curr. / IR qty in PO UoM
- IR Price diff.: difference between GR value and standard value of stock entry, in PO & Local or Target currency, when posted in IR doc.
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:
- IR Consign. qty: in Material base UoM
- IR Consign. value: in Doc. Curr. & in Local (Company code) curr. or any Target curr. if entered in prompt
- 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
- IR Price diff.: difference between IR Consign. value and standard value of stock entry, in Doc. & Local or Target curr.
| Info |
|---|
As Consignment invoices are auto invoices (MRKO tr.), no IR Price diff. should occur |
| Info |
|---|
IR Unit Price & Price diff. columns/ratios are the same for both standard and consignment IR |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Others Var.: all other GR/GI which are not Purchasing nor Manuf. consumption
Ending Stock Qty : in Local (company) /Target currency, according to selected period 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 |