BW_QRY_MV_SPD01_0002
This query is aimed to :
- Give you the activity (portfolio) in value and quantity for a chosen period. Ex : Invoicing spend for January 2016.
- Track all the document flows history from the PO till the Invoicing document.
Table of content
Added Value
- One single and common query to get the whole PO/Receipt and Invoice amount instead of several queries previously
In the prompt, complete the period "Calendar Month/Year"
It will provide you all the PO, Receipts and Invoices posted in SAP during this selected period.
STEP 2
The field "Event Type" has to be completed by chosing :
- Purchase Order
- Goods Receipt
- Invoice Receipt
This Event type is linked to the chosen period.
Ex : we choose 2 - Invoice Receipt.
In the report, if we take the dimension "calendar day", it will give the exact day of the Invoice posting in SAP.
You can also enter directly a PO number, or a SAP Contract number to track its document flow.
STEP 1
MANDATORY - In the report, you need to filter on the same period than the chosen period in the prompt
1) Put "Calendar Month" as a dimension
Right Click on It
2) By default, the system selects old invoicing dates (even if the chosen period in the prompt was Jan.2016>Oct.2016).
3) Deselect the wrong period and select the same period that the one chosen in the prompt.
Ordered Qty
Quantity from the SAP purchase order
Ordered value
Amount from the SAP purchase order
Average Ordered value :
Purchase Order price unit
Receipt Qty :
Received quantities (from SAP Goods Receipts)
Receipt value :
Goods receipt amount
Average Receipt Value :
Receipt Price Unit
Consignment Consumption
This is when the stock property transfer is done between the supplier and Solvay :
Transfer in Solvay stock location or
Direct Consumption
Consignment
See Consignment flow
SPRINT gives you the quantity and the related amount consumed.
Each column can be opened by clicking on
Total Invoiced Qty :
It is the Total Invoiced quantity from SAP Invoice document + the SAP invoiced quantities from consignment (which is a specific flow).
Invoiced Consignment Qty :
SAP Invoiced quantities from Consignment flow.
Invoiced Qty :
SAP invoiced quantities (all flows except Consignment).
Invoiced Delivery Cost :
SAP invoiced transportation costs.
Subsequent Qty :
Debit or Credit note quantities.
Subsequent Delivery Cost Qty :
Debit or Credit note quantities related to transportation.
The best way to get IT support is to use the new
Service One Platform.