<?xml version='1.0' encoding='UTF-8'?><xwikidoc><web>
BW - Business Warehouse</web><name>
CVA-03-03-01 Receipt & Invoiced Quantity & Price</name><language>
</language><defaultLanguage>
en</defaultLanguage><translation>
0</translation><parent>
BW - Business Warehouse.BW GSV Global Spent Visibility</parent><creator>
xwiki:XWiki.DTONDA</creator><author>
xwiki:XWiki.DTONDA</author><customClass>
</customClass><contentAuthor>
xwiki:XWiki.DTONDA</contentAuthor><creationDate>
1377076523000</creationDate><date>
1377154726000</date><contentUpdateDate>
1377154726000</contentUpdateDate><version>
9.1</version><title>
CVA-03-03-01 Receipt & Invoiced Quantity & Price</title><template>
</template><defaultTemplate>
</defaultTemplate><validationScript>
</validationScript><minorEdit>
false</minorEdit><syntaxId>
xwiki/2.1</syntaxId><hidden>
false</hidden><content>{toc}
Basic Information
| Application | GSV - Global Spent Visibility |
|---|---|
| Query Name | CVA 03_03_01 : Receipt/ Invoiced Quantity & |
...
| Price (MM) |
| Query Technical |
|---|
...
| Name | BW_QRY_MPR_PUR03_CVA_030301 |
|---|---|
| Info Provider |
...
| Name | Purchasing Data and Historical PO |
|---|---|
| Info Provider Technical |
...
| Name | MPR_PUR03 |
|---|---|
| Usage |
...
| type | Direct execution in Analyzer |
|---|---|
| Expected |
...
| users | Purchasing family |
|---|
| Table of Contents |
|---|
Purpose of this query
The Report allows to get the quantities and values of receipts and the quantities / values of invoices from RCS Purchase Order (PO History) according to the posting date :
- Receipt quantities and Receipt values (goods & services)
- Receipt delivery costs quantities and Receipt delivery costs values (available soon)
- Invoiced quantities and Invoiced values
- Invoiced subsequent quantities and Invoiced subsequent values
- Invoiced delivery costs quantities and delivery costs values (available soon)
- Average price : receipt and invoiced
- Consumption consignment & pipeline quantities and values (caution : consignment/pipeline is inventory movement, don't use the RCS Purchasing Organisation
Variables screen
Several variables are available in the report to allow filtering. Some are mandatory :
- Time (mandatory)
...
- : Based on the posting dates of the accounting documents (Invoices, Goods Receipt).
- Target Currency (mandatory)
...
- : Some key figures will be converted to the selected currency. Note that both local and selected currency will be displayed.
All other variables are not mandatory and correspond to characteristics described below.
| Warning |
|---|
Although the |
...
"Company" variable is not mandatory, if you have only access to Asia Pacific entities, it is mandatory to select the list of companies. Otherwise no data will be displayed. |
...
- Convert Unit
...
- : By default BW displays in base unit, but by selecting a unit in this variable you can ask BW to convert to a single unit. More on quantity conversion
...
...
Filters
...
- Vendors: Only Standard Vendors (Z010) are included. Non standard (governements for taxes for example) are excluded.
- Item Category
...
- : Excludes consignment/Pipeline items (Item Category
...
- <> 2 Consignment).
- Del ind - PO = No
...
- : Excludes deleted Purchase Orders.
- Del ind - PO Item = Empty
...
- : Excludes deleted Purchase Order items
...
Characteristics
By default the report doesn't display any characteristic. All be below are available to be added in the report (Free characteristics)
| Main Axis of Analysis | Characteristic | Definition |
|---|---|---|
| Accounting data | Local currency | Currency of the company |
| Profit Center | Profit center of the PO | |
| Purchase Order Currency | PO currency | |
| Support of costs | Support of costs of the PO | |
| WBS Element | WBS element of the PO | |
| Business Organisation | Global Business Unit (1 - GBU) | GBU : dimension based on the profit center of the material allowing the allocation of the spend. |
| Business Unit (2 - Business Unit) | Business Unit is a part of GBU dedicated to a market |
...
| Geographical | Plant | Plant of the PO |
| Zone (of the company) | Zone of the company | |
| Human Organisation | Login (Created by) | RCS ID who created the Purchase Order |
| Legal organisation | Company code | Company code of the PO |
| Material | Order unit | Order Unit |
| Product/Services | Material | RCS material code of the PO |
| Purchasing Organisation | DSF |
...
...
| / Material group | Material group from the Purchase Order corresponding to the Family of the DSF Segmenteur |
| DSF |
...
| / Segment | Purchasing Segment from the DSF Segmenteur (Purchasing structure) | |
| Contract | Contract | RCS Contract number used on the Purchase order to affect a price and condition |
| Contract: Condition group with | RCS condition group of the |
...
| contract | ||
| Contract: Incoterms part 1 | Incoterm from the RCS contract | |
| Contract: Incoterms part 2 | Location of incoterm of the contract | |
| Contract: Purchasing group | RCS code of the buyer from the contract | |
| Purchase Info Record | PIR: Number | Purchase info record number |
| Country of origin (PIR) | Origin country of the material from the Purchase Info Record | |
| PIR: Condition group with vendor | Condition group from PIR | |
| PIR: Incoterms 1 | Incoterm from the RCS PIR | |
| PIR: Incoterms 2 | Location of incoterm of the PIR | |
| PIR: Purchasing group | RCS code of the buyer from the PIR | |
| Purchase Request | PR: Number | Purchase request number |
| PR: Requisition date | Date of the Purchase requisition | |
| Purch. Request Item nb | Purchase request item number | |
| Purchase Requisition nb | Purchase request number | |
| Purchase Order | Country of origin (PO) | Origin country of the material from the Purchase Order |
| Document Date | Date of the Purchase Order | |
| Order acknowledgment | Supplier confirmation used on the European RM workflow | |
| PO: Header Text Ln 1 | Header text of the PO | |
| PO: Line Item | Item of the PO | |
| PO: Number | Number of the PO | |
| PO: Purchasing group | RCS Purchasing group code of the PO's requester | |
| Purchasing doc categ | Category of PO | |
| RCS / Purchase Organisation | Purchasing Organisation of the PO | |
| Requesting entity / Requester | Requester of the PO | |
| Shopping Card Number | Shopping Card Number from Bip | |
| Item Category | Key defining how the procurement of a material or service item is controlled. |
...
| The item category determines the field selection and whether any additional data screens are shown. |
...
| In addition, it determines whether a goods receipt or invoice receipt is to follow. |
...
| List of item category |
...
|
...
|
...
|
...
| |
| Material group | Key that you use to group together several materials or services according to he purchasing hierarchy |
| Material type | Key that assigns the material to a group of materials such as raw materials, operating supplies or trading goods. |
...
| The material type defines certain attributes of the material and has important control functions. |
...
| The main type : |
...
|
...
|
...
|
...
|
...
|
...
| |
| It.cate purch doc. | Specifies whether accounting for an item is to be effected via an auxiliary account (such as a cost center). |
...
| The account assignment category determines which account assignment data (such as cost center, account number and so on) is necessary for the item. | ||
| RCS System | System need origin | The system used to express the need |
| Supplier | Alternative Payment terms by plant (LFM2) | Alternative payment terms according to the plant. If there is a particular payment terms for a plant, this dimension will display |
| Internal supplier | Supplier belonging to Rhodia | |
| Payment Terms (LFM1) | Payment terms of the PO's vendor | |
| Supplier Rhodia Grouping | Grouping of the Vendor | |
| Supplier RCS Code | PO Vendor | |
| Time | Posting day | Calendar day of the posting date |
| Posting Year/Week | Calendar year/week of the posting date | |
| Posting Year/Month | Calendar year/month of the posting date | |
| Posting Year/Quarter | Calendar year/quarter of the posting date | |
| Posting Year | Calendar year of the posting date |
Key Figures
Definition
The quantity key figure is displayed in Base Unit if no conversion unit is selected when running the query. Otherwise BW tries to convert all to the selected unit.
- Total Receipted Qty (Qty Unit)
...
- : Total receipt quantity = receipt-return+consumed consignment/pipe (in convert unit)
...
- Receipted Qty (Qty Unit) : Total receipt quantity = receipt-return(in convert unit)
...
- Receipted Consignment Qty (Qty Unit) : Consumed consignment/pipe (in convert unit)
- Total Invoiced Qty (Qty Unit)
...
- : Total invoiced quantity (without delivery costs) = invoiced quantity + invoiced consignment quantity (in convert unit)
- Invoiced Quantity (Qty Unit) : Invoiced quantity (in convert unit)
- Invoiced Consignment Qty (Qty Unit) : Invoiced consignment quantity in convert unit
| Info |
|---|
In this query the Receipted/Invoiced Value key figures exist in 3 versions :Target Currency (Currency selected in prompt), Internal Currency, Order Currency. By default only the Target currency key figure is displayed. |
...
- Total Receipted Value
...
- : Total receipt value = receipt-return+consumed consignment/pipe + delivery costs
- Receipted Value: Total receipt value = receipt-return
...
- Receipted Consignment Value : Consumed consignment/pipe in target currency
...
- Receipted Delivery Cost : Total receipt value of the delivery costs
- Average Reception Price : Average receipt price : total receipt value without del costs /Total receipt quantity in convert unit.
- Av Rec. Price (without Del Cost) : Average receipt price : total receipt value /Total receipt quantity in convert unit. This indicator is the average TCO price
- Total Invoiced Value
...
- : Invoiced value + invoiced consignment + subsequent turnover + delivery costs
...
- Invoiced Value: Invoiced value coming from the Purchase Order
- Invoiced Consignment Value : invoiced consignment value
- Delivery
...
- Cost Value: Invoiced delivery cost related to the delivery costs
- Subsequent Del. Cost: Subsequent delivery costs = delivery costs which are not excepted
- Subsequent Turnover : Subsequent invoices = invoices which are not excepted
- Average Invoice Price : Average invoiced price = total invoiced value / Total invoiced quantity in convert unit
Currency Conversion
Some of the key figures are in "Curr" meaning "Local Currency" (Legal Entity/Company currency) but others are on "Target Currency". These will show the amounts converted from local currency to the currency selected in the query prompt.
The conversion in this queries applies the BW exchange rates available at the Posting date of the invoice (FI Document Posting Date).
Conditions
Note that there is a condition active by default in this query. Condition "not all key figures equal to 0" basically filters out all rows where all key figures are empty. This is a technical condition that should not be de-activated.
...