| Application | GSV - Global Spent Visibility |
|---|---|
| Query Name | PCA 06_00_00 : Monitoring gaps payment |
| Query Technical Name | GSV_QRY_ODS_FIAP1_PCA_060000 |
| Info Provider Name | FIAP: Line Item |
| Info Provider Technical Name | ODSFIAP1 |
| Usage type | Direct execution in Analyzer |
| Expected users | Purchasing family |
Purpose of this query
The Report allows to show the gap between the theoretical payment date and the day when the payment order is given to the bank.
Variables screen
Several variables are available in the report to allow filtering. Some are mandatory :
- Fiscal Period (mandatory) : Based on the posting dates of the accounting documents (Invoice).
- 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.
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 here.
Due to the displayed dimensions by default, the advised period of time to run the query is the month.
Filters
- Vendors: Only Standard Vendors (Z010) are included. Non standard (governements for taxes for example) are excluded.
- Account Document Type: Only the following documents are included.
| Code | Description |
|---|---|
| KA | Vendor document |
| KG | Vendor Credit Memo |
| KN | Net Vendors |
| KR | Vendor Invoice |
| RA | Sub cred memo stlmt |
| RE | Invoice - receipt |
| RN | Invoice - Net |
| ZW | Maint. interfac inv |
| ZC | BR-COMEX Document |
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 ec available at the Posting date of the invoice (FI Document Posting Date).
The best way to get IT support is to use the new
Service One Platform.