{toc}

Basic Information

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

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.
/warning

Filters

* endors*: 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.

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.

Invoiced Purchasing Spend (Target currency)* : Total invoices turnover (before VAT) in target currency (currency input in the invitation) 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).