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

 

 

  • One single and common query to get the whole PO/Receipt and Invoice amount instead of several queries previously

 

 

 

A1510 - Objectives

For buyers, this query provides a clear vision of the commitments (Purchase orders), accruals (Receipts) and Spend (Invoices) for a chosen period.

 

 

A1520 - Prompt

 

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.

 

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.

 

 

A1530 - Indicators

 

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

 

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.