Cash flow analysis
Use this function to generate the amounts linked to the extraction code previously set up in the counterpart extraction function.
Once you have entered the data related to the parameter definition, you can create the record where an automatic sequential number is provided.
By clicking on the Calculate button, the values will be automatically displayed.
Prerequisites
Refer to documentation Implementation
Screen management
Header
Use this screen to enter the filtering criteria to be applied to the calculation.
Block number 1
| Query no. (field NUMRPT) |
|
It is an automatic sequential number used to save each processing. |
Parameters
| Extraction code (field CODANY) | ||||||||||||||||||||||||||||||
|
This code identifies the extraction rule. |
||||||||||||||||||||||||||||||
| Company (field CPY) | ||||||||||||||||||||||||||||||
|
Enter the company code or use the Look up tool to search for and select the code. |
||||||||||||||||||||||||||||||
| Ledger type (field LEDTYP) | ||||||||||||||||||||||||||||||
|
Use this field to define the ledger type concerned by the journal balance. In this function, only Manual ledgers can be accessed. You can read the balance on the selected ledger and balance the account for that ledger type. The propagation then initializes the accounts for the non automatic and non prohibited ledger types. This initialization process is based on the entry type setup and account setup. The propagated amount is the one calculated on the main general ledger in transaction currency. This amount is then converted into the currency of the propagated ledgers. When generating the journal balance, the propagation depends on the selected entry type. The entry type used during the journal generation and the entry type used during the balance generation (actual mode) must be consistent.If the two entry types are not consistent, the balance process must be launched on each non-propagated manual ledger where the account needs to be balanced. Examples
Selected ledger type = Social, Generation type = Actual In this case, when generating the balance, the propagation is global.
Selected ledger type = Legal; Generation type = Actual Here, the propagation is incomplete. The IAS ledger is not propagated. If you want to balance the account on the IAS ledger, relaunch the balance process for this ledger type using an entry type that only authorizes IAS ledgers. For an automatic ledger type, the amounts in transaction currency are not calculated from the balance. They are the same as the currency amounts calculated for the original manual ledger. The ledger amounts for the automatic ledger are calculated by converting its currency amounts according to the journal entry rates. |
||||||||||||||||||||||||||||||
| Extraction start date (field DATDEB) | ||||||||||||||||||||||||||||||
|
These two fields are used to define the date ranges. |
||||||||||||||||||||||||||||||
| Extraction end date (field DATFIN) | ||||||||||||||||||||||||||||||
| Previous period (field HMLPERFLG) | ||||||||||||||||||||||||||||||
|
When this flag is checked, the system automatically displays the amounts of the homologous period on the n-1 fiscal year. |
||||||||||||||||||||||||||||||
| All sites (field ALLFCY) | ||||||||||||||||||||||||||||||
| Site (field FCY) | ||||||||||||||||||||||||||||||
|
This code is used to identify the site concerned. It is unique for each site. |
||||||||||||||||||||||||||||||
| Intercompany detail (field BETCPYDET) | ||||||||||||||||||||||||||||||
Tab Lines
Use this tab to display the automatically-generated amounts and to modify these amounts.
Grid Results
| Code (field COD1) |
|
The amounts are aggregated onto lines that can be set up. The code and sub-code define each line in a unique manner. Descriptions and a formula are associated with it. |
| Subcode (field COD2) |
| Description (field LIBEL) |
|
Enter the description of the relevant record. This long description is used as a title in screens and reports. |
| BP code (field BPRNUM) |
| Company (field CPYLIN) |
| Site (field FCYLIN) |
| Ledger currency (field CURLED) |
| Ledger amount (field AMTN) |
| Ledger amount (n-1) (field AMTN1) |
Block number 2
| Start date amount (field STRAMT0) |
| End date amount (field ENDAMT0) |
| Rate variance (field RATDEV0) |
| Start date amount (n-1) (field STRAMT1) |
| End date amount (n-1) (field ENDAMT1) |
| Rate variance (n-1) (field RATDEV1) |
Reports
By default, the following reports are associated with this function :
P-CASHFLO : Cash flow analysis
This can be changed using a different setup.
Specific Buttons
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
The sum of all movements plus the initial amount and rate variances must be equal to the end-of-period amount.
The data displayed in the screen contains inconsistencies because the initial amount plus the period movements must match the period end value.