Cash flow analysis

• Query no. (field NUMRPT)

It is an automatic sequential number used to save each processing.

• 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.

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.
These ranges are used to filter the lines whose date is included within this time interval.

• 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)

• 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)

• 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)