| Application | GSV - Global Spent Visibility |
|---|---|
| Query Name | CVA 01_00_00 - Invoiced purchasing turnover (FI turnover) |
| Query Technical Name | GSV_QRY_CUB_FIAP1_CVA_010000 |
| Info Provider Name | FIAP: Line Item |
| Info Provider Technical Name | CUB_FIAP1 |
| Usage type | Direct execution in Analyzer |
| Expected users | Purchasing family |
| Table of Contents |
|---|
Purpose of this query
The Report allows to follow the invoiced turnover evolution. All invoices are taken into account (without or with Purchase orders, credit notes, reversed down payment) (list of invoices below).
The invoiced turnover is calculated according to all accounting documents (invoices) input in the system (the invoices can be paid or due invoices).
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).
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. |
Filters
- Vendors: Only Standard Vendors (Z010) are included. Non standard (governements for taxes for example) are excluded.
- Document Type (Type of invoice)* : only the following document types are included :
Code | Doc Type |
|---|---|
ZC | BR-COMEX Document |
ZW | Maint inerfac. Inv |
RN | Invoice - net |
RE | Invoice - receipt |
RA | Sub.cred.memo.stlmt |
KR | Vendor Invoice |
KN | Net Vendor |
KG | Vendor credit memo |
KA | Vendor document |
Posting Key: Only the following Posting Keys are included.
Code | Posting Key |
|---|---|
21 | Credit Memo |
22 | Revers Invoice |
24 | Other receivables |
27 | Clearing |
29 | Down payment made |
31 | Invoice |
32 | Revers credit memo |
34 | Other payables |
37 | Other clearing |
39 | Revers down payment |
Characteristics
By default the report only displays one characteristic Supplier Rhodia Grouping. All be below are available to be added in the report (Free characteristics) :
| Axis | Characteristics | Definition |
|---|---|---|
| Accounting data | Profit Center | Profit center of the RCS document (PO or Invoice), It's an orgaisational unit in the accounting. It reflects a management oriented structure of GBU for the purpose internal control. |
| Controlling area | Profit center of the RCS document (PO or Invoice), It's an orgaisational unit in the company. It used to represent a closed system for cost accounting purposes. | |
| Cost center | Cost center of the RCS document (PO or invoice). Cost centers are divisions that add to the cost of the organisation, but only indirectly add to the profit of the company. | |
| Profit Center | Profit Center of the of Cost Center | |
| Capital Expenditure Goods | Flag added in the accounting document in order to identify the invoices related to CAPEX. | |
| WBS Element | WBS (Work Breakdown Structure) element is related to project. The WBS structure describes the work you need to carry out to complete the project. | |
| Document currency | Currency of the supplier's invoice. | |
| Local currency | Currency of the company | |
| Terms of payment key | Terms of payment coming from the RCS accounting document. Terms of payment of invoices with must be the same that the PO terms of payment. Terms of payment of invoices without PO is the terms of payment of the supplier (view company). | |
| Document type | Type of accounting document. A Document type is specified at the Header level during transaction entry and serves many purposes. It defines the numbe range in the documents and allows you to control the type of accounts that can be posted to assets, vendo | |
| Document number | Number range in the accounting document type. The document number is recorded in RCS according the company and the posting year. | |
| Document date | Date of the RCS accounting document | |
| Posting key | Two-character numerical key that controls the entry of line items. The posting key determines: -account type -debit/credit posting -layout of entry screens | |
| Base date | Date to which the periods for the cash discount deadline and the due date for net payment refer | |
| Net due date | The date is calculated from the baseline date for payment and the highest number of days within the terms of payment | |
| Net due date month | Month of the Net due date | |
| Business Organisation | Global Business Unit | GBU : dimension based on the profit center of the material allowing the allocation of the spend per Global Business Unit. |
| Business Unit | Business Unit is a part of GBU | |
| Function | Assignment of the Spend to functions according to the profit center and the cost center | |
| Sub-function | Assignment of the Spend to sub-functions according to the profit center and the cost center | |
| Geographical | Zone (of the company) | Zone of the company contained in the RCS Document |
| Country of company | Country of the company contained in the RCS Document | |
| Plant | Plant of the Purchase Order | |
| Legal organisation | Company code | Company code of the RCS document |
| Product/Services | Material | RCS material code of the PO. Invoices without Purchase Order will have no material assigned. |
| Purchasing Organisation | DSF / Material group | Material group from the Purchase Order corresponding to the Family of the DSF Segmentation |
| DSF / Segment | Purchasing Segment (DSF Segmenter) resulting of the Spend Assignment rules | |
| DSF / Domain | Purchasing Domain (DSF Segmenter) resulting of the Spend Assignment rules. | |
| RCS Purchasing Document | Supplier from PO | Ordering address code Vendor from the purchase order |
| RCS / Purchase Organisation | Purchasing Organisation of the PO according to the production process, the capital expenditure process and so and so This Purchasing Organisation is not related to the DSF Segmenteur. | |
| Supplier | Supplier RCS Code | Invoicing party code of the Vendor, Caution : the invoicing party code of the Vendor can be different from the Ordering address code Vendor (Purchase Order Vendor) |
| Internal supplier | Supplier belonging to Rhodia Sector | |
| Supplier Rhodia Grouping | Grouping of the Vendor. Code gathering supplier RCS codes belonging to the same group. If there is not a grouping code affected to a supplier RCS code, the Supplier Rhodia Grouping will be the supplier RCS code | |
| Minority Indicator | A field in the vendor master record that determines the minority group to which the vendor belongs. The minority indicator is only relevant in the United States. | |
| Certification date | Related to minority indicator, this field display the date of vendor's certification. | |
| Time | Calendar day | Date which is used when entering the document in Financial Accounting or Controlling. |
| Calendar year | Year which is used when entering the document in Financial Accounting or Controlling. | |
| Calendar year/quarter | Year/quarter which is used when entering the document in Financial Accounting or Controlling. | |
| Calendar year/month | Year/month which is used when entering the document in Financial Accounting or Controlling. | |
| Calendar year/week | Year/week which is used when entering the document in Financial Accounting or Controlling. |
Invoiced Purchasing Spend (Target currency)* : Total invoices turnover (before VAT) in target currency (currency input in the invitation) according to the Purchasing perimeter
Key Figures
Definition
Invoiced purchasing turnover (Curr) : Total invoices turnover (before VAT) in local currency (currency of the company)
- Purchasing turnover W/O PO in % : Percentage of invoices turnover (before VAT) in local currency without Purchase Orders
- Purchasing turnover W/O PO (Curr) : Total invoices turnover (before VAT) in local currency without Purchase Orders
Invoiced purchasing turnover (target currency) : Total invoices turnover (before VAT) in target currency (currency input in the invitation)
- Purchasing turnover W/O PO in % : Percentage of invoices turnover (before VAT) in target currency without Purchase Orders
- Purchasing turnover W/O PO (target currency) : Total invoices turnover (before VAT) in target currency without Purchase Orders
Invoiced Purchasing Spend (Curr) : Total invoices turnover (before VAT) in local currency (currency of the company) according to the Purchasing perimeter.
Purchasing Perimeter being :
- RCS perimeter + Acetow
- Including only 50% of Butachimie and Rhodia Energy Spend.
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 CAR3 exchange rate available at the Posting date of the invoice (FI Document Posting Date).