Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 18

changes.mady.by.user Karin Weigel-Jung

Saved on

compared with

New Version Current

changes.mady.by.user Karin Weigel-Jung

Saved on

Key

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

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

Info
titleSPRINT Glossary

All vocabulary definition here

toc


 

 

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

 

 

Image Removed

  • 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

 

StatuscolourBluetitleStep 1 WarningMANDATORY -
Warning

 

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

 

Image Removed

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.

 

Image Removed

Status
colourBlue
titleStep 2

The field "Event Type" has to be completed by chosing :

  • Purchase Order
  • Goods Receipt
  • Invoice Receipt

 

titleTechnical Restriction

Due to technical restriction, huge PO Follow Up extracts don't work with Analysis.

Then, for huge reports (for ex. global domain extract for a 6 month period), thank you to use ANALYZER tool.

For an ANALYZER training, kindly ask SBS.

For other reports (small period,or GBU extracts), Analysis works perfectly.

Warning

MANDATORY - 

In the report, you need to filter on the same period than the chosen period in the prompt

 

 

 

 

 

 

 

 

 

 

 

 

Image Removed

Image Removed Put "Calendar Month" as a dimension & Right Click on it

 

Image Removed

Image Removed

 

StatuscolourBluetitleStep 2 - Orders & Receipts

 

Image Removed

 

  • 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

 

 

Status
colourBlue
titleStep 3
 - Consignment Consumption

 

This is when the stock property transfer is done between the supplier and Solvay :

  • Transfer in Solvay stock location or

  • Direct Consumption

 

Note
titleConsignment

See Consignment flow

 

SPRINT gives you the quantity and the related amount consumed.

Image Removed

 

Status
colourBlue
titleStep 4
 - Invoices

 

Each column can be opened by clicking on 

Image Removed

 

Image Removed

  • 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. 

.

Image Removed By default, the system selects old invoicing dates (even if the chosen period in the prompt was Jan.2016>Oct.2016).

See details A1440 - Indicators