Balance in currency

• Company (field CPY)

• Group of companies.
• Company/Site The inquiry can concern a company or a site. The Site field can be accessed if the inquiry concerns a group of companies.

• Site (field FCY)

• Ledger type (field LEDTYP)

This field is used to define the ledger type concerned by the inquiry.
In this function, only the 'General' ledgers can be accessed.

• Start date (field DATDEB)

Date from which the records are selected. This date can only correspond to the beginning of a period.

• End date (field DATFIN)

Date until which the records are selected. This date can only correspond to the end of a period.

• Chart of accounts (field COA)

Field calling the chart of accounts associated to the selected ledger.

• Control (field SAC)

This field is optional. If it is assigned, the corresponding auxiliary balances are displayed, if not, the general balances are displayed.

• Filter (field STRFLT)

This field is used to limit the balances displayed to those where the account corresponds to the filter for the general balances, and to the BPs for the auxiliary balances.

The filter specifies the first BP or the first account from which the balance is to be inquired. It can be entered on a specific BP or a general account (or account template using the wildcards * or ?).

The ? and * characters can be used to replace respectively any character or a group of characters. For instance: 4* to only display class 4.

In the absence of the ? or * characters, the filter specifies the display start account or BP.
For instance: 4 to display the classes >= 4.

• Exchange currency (field CNVCUR)

Requested exchange currency.

Currency used to convert the balance. The converted amounts are displayed in the "conversion" columns. If no currency has been selected, the "conversion" columns are not loaded.

 The currency entered is not used as a filter but as a conversion data. The recovery grid displays all the transactions for the selected period, irrespective of their original currency.
The conversion is performed based on the type of exchange rate entered for the CNSTYPCUR parameter value ("Common Data" chapter, group CUR "Currency management").
Based on the screen code used (to be set up by the GESGTC function), it is possible to display the amounts in the original currency, in ledger currency and in conversion currency

• Divisor (field DIV)

Used to choose a rounding to display the result. For instance, the value 1,000 displays the result of the inquiry in thousands.

• Account (field ACC)

Account number.

• Description (field ACCDES)

Title of the account.

• Currency (field CUR)

Transaction currency

• Beginning debit balance (field ANTDEB)

Amount expressed in the original currency.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is with the same fiscal year start and end dates.
The field is loaded if the total of the credit and debit entries displays a debit balance, between the start date of the fiscal year and the start date of the inquiry..
The carry forward amounts are included or not according to the criterion selection ([Criteria] button).
If the inquiry concerns several fiscal years, the intermediary carry forward periods are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the former balances are not displayed.

• Beginning credit balance (field ANTCDT)

Amount expressed in the original currency.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is with the same fiscal year start and end dates.
The field is loaded if the total of the credit and debit entries displays a credit balance, between the start date of the fiscal year and the start date of the inquiry.
The carry forward amounts are included or not according to the criterion selection ([Criteria] button).
If the inquiry concerns several fiscal years, the intermediary carry forward periods are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the former balances are not displayed.

• Debit (field DEB)

Amount expressed in the original currency.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded with the total of the debit movements carried out during the inquired period.
The carry-forward entries are never included.
The closure postings are included according to the selection of the Criteria button and if the end date of the inquiry corresponds to the fiscal year end date.
If the inquiry concerns several fiscal years, the intermediary closure postings are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the carry-forward entries and the closure entries are not taken into account.

• Credit (field CDT)

Amount expressed in the original currency.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is with the same fiscal year start and end dates.
The field is loaded by the total of credit movements carried out during the inquired period.
The carry forward entries are never included.
The closure postings are included according to the selection of the Criteria button and if the end date of the inquiry corresponds to the fiscal year end date.
If the inquiry concerns several fiscal years, the intermediary closing postings are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the carry-forward entries and the closure entries are not taken into account.

• Debit balance (field DEBBLC)

This field specifies the debit balance of the period in the original currency.

• Credit balance (field CDTBLC)

This field specifies the credit balance of the period in the original currency.

• Ending debit balance (field FINDEB)

Amount expressed in the original currency.

Loading of the field

The field is loaded if the actual accounting balance (former balances and period balances) displays a debit balance.

• Ending credit balance (field FINCDT)

Amount expressed in the original currency.

Loading of the field

The field is loaded if the actual accounting balance (former balances and period balances) displays a credit balance.

• Currency (conv) (field CNVCUR)

Conversion currency chosen in the header.
Currency in which the converted amounts are expressed.

• Beginning debit bal. (conv) (field ANTCNVDEB)

Amount expressed in the conversion currency.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded if the total of the credit and debit entries displays a debit balance, between the start date of the fiscal year and the start date of the inquiry.
The carry forward entries are included, or not, according to the criterion selection ([Criteria] button).
If the inquiry impacts several fiscal years, the intermediary carry-forward periods are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the former balances are not displayed.

• Beginning credit bal. (conv) (field ANTCNVCDT)

Amount expressed in the conversion currency.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded if the total of the credit and debit entries displays a credit balance, between the start date of the fiscal year and the start date of the inquiry.
The carry forward entries are included, or not, according to the criterion selection ([Criteria] button).
If the inquiry impacts several fiscal years, the intermediary carry-forward periods are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the former balances are not displayed.

• Begin. progressive bal. (conv) (field ANTCNVPRG)

Amount expressed in the conversion currency.

For the accounts containing several lines, and thus several original currencies, this column displays the total of the former balances expressed in conversion currency. It is then used to display the former balance in conversion currency, all currencies considered.

• Debit (conv) (field CNVDEB)

Amount expressed in the conversion currency.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded with the total of the debit movements carried out during the inquired period.
The carry-forward entries are never included. 
The closure postings are included according to the selection of the criterion ([Criteria] button) and if the end date of the inquiry corresponds to the fiscal year end date.
If the inquiry concerns several fiscal years, the intermediary closing postings are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the carry-forward entries and the closure entries are not taken into account.

• Credit (conv) (field CNVCDT)

Amount expressed in the conversion currency.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded with the total of the credit movements carried out during the inquired period.
The carry-forward entries are never included.
The closure postings are included according to the selection of the Criteria button and if the end date of the inquiry corresponds to the fiscal year end date.
If the inquiry concerns several fiscal years, the intermediary closing postings are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the carry-forward entries and the closure entries are not taken into account.

• Debit balance (conv) (field DEBBLCCNV)

This field specifies the debit balance for the period, in conversion currency.

• Credit balance (conv) (field CDTBLCCNV)

This field specifies the credit balance for the period, in conversion currency.

• Progressive balance (conv) (field PRGBLCCNV)

Amount expressed in the conversion currency.

For the accounts containing several lines, and thus several original currencies, this column displays the total of balances for the inquiry period expressed in conversion currency. It is then used to display the balance of the period in conversion currency, all currencies together.

• Ending debit bal.(conv) (field FINDEBCNV)

Amount expressed in the conversion currency.

Loading of the field

The field is loaded if the actual accounting balance (former balances and period balances) displays a debit balance.

• Ending credit bal.(conv) (field FINCDTCNV)

Amount expressed in the conversion currency.

Loading of the field

The field is loaded if the actual accounting balance (former balances and period balances) displays a credit balance.

• Ending progressive bal. (conv) (field FINPRGCNV)

Amount expressed in the conversion currency.

For the accounts containing several lines, and thus several original currencies, this column displays the total of the end-of-inquiry balances expressed in conversion currency. It is then used to display the end balance in conversion currency, all currencies considered.

• Ledger currency (field CURLED)

Displays the ledger currency for the selected ledger type.

 If the inquiry is launched for a group of companies, the ledger currencies do not need to be identical.

• Ledger beginning debit balance (field ANTDEBLED)

Amount expressed in the currency used to keep the ledger.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded if the total of the credit and debit entries displays a debit balance, between the start date of the fiscal year and the start date of the inquiry.
The carry forward entries are included, or not, according to the criterion selection ([Criteria] button).
If the inquiry impacts several fiscal years, the intermediary carry-forward periods are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the former balances are not displayed.

• Ledger beginning credit balance (field ANTCDTLED)

Amount expressed in the currency used to keep the ledger.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded if the total of the credit and debit entries displays a credit balance, between the start date of the fiscal year and the start date of the inquiry.
The carry-forward entries are included, or not, according to the criterion selection ([Criteria] button).
If the inquiry impacts several fiscal years, the intermediary carry-forward periods are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the former balances are not displayed.

• Ledger begin. progressive bal. (field ANTPRGLED)

Amount expressed in the currency used to keep the ledger.

For the accounts containing several lines, and thus several original currencies, this column displays the total of the former balances expressed in ledger currency. It is then used to display the former balance in ledger currency, all currencies considered.

 The closures are not displayed if the inquiry concerns a group of companies with different ledger currencies.

• Ledger debit (field LEDDEB)

Amount expressed in the currency in which the ledger is kept.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded with the total of the debit movements carried out during the inquired period.
The carry-forward entries are never included.
The closure postings are included according to the selection of the Criteria button and if the end date of the inquiry corresponds to the fiscal year end date.
If the inquiry concerns several fiscal years, the intermediary closure postings are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the carry-forward entries and the closure entries are not taken into account.

• Ledger credit (field LEDCDT)

Amount expressed in the currency in which the ledger is kept.

Loading of the field

First case: the inquiry concerns a company, a site or a group of companies with homogeneous fiscal years, that is, with the same fiscal year start and end dates.
The field is loaded with the total of the credit movements carried out during the inquired period.
The carry-forward entries are never included.
The closure postings are included according to the selection of the Criteria button and if the end date of the inquiry corresponds to the fiscal year end date.
If the inquiry concerns several fiscal years, the intermediary closure postings are not taken into account.

Second case: the inquiry concerns a group of companies with fiscal years having different start and end dates.
In that case, the carry-forward entries and the closure entries are not taken into account.

• Ledger debit balance (field DEBBLCLED)

This field specifies the debit balance for the period, in ledger currency.

• Ledger credit balance (field CDTBLCLED)

This field specifies the credit balance for the period, in ledger currency.

• Ledger progressive balance (field PRGBLCLED)

Amount expressed in the currency in which the ledger is kept.

For the accounts containing several lines, and thus several original currencies, this columns displays the total of closures of the inquiry period expressed in ledger currency. It is then used to display the closure of the period in ledger currency, all currencies together.

 The closures are not displayed if the inquiry concerns a group of companies with different ledger currencies.

• Ledger ending debit balance (field FINDEBLED)

Amount expressed in the currency in which the ledger is kept.

Loading of the field

The field is loaded if the actual accounting balance (former balances and period balances) displays a debit balance.

• Ledger ending credit balance (field FINCDTLED)

Amount expressed in the currency in which the ledger is kept.

Loading of the field

The field is loaded if the actual accounting balance (former balances and period balances) displays a credit balance.

• Ledger ending progressive bal. (field FINPRGLED)

Amount expressed in the currency in which the ledger is kept.

For the accounts containing several lines, and thus several original currencies, this column displays the total of the end-of-inquiry balances expressed in ledger currency. It is then used to display the end balance in ledger currency, all currencies considered.

 The closures are not displayed if the inquiry concerns a group of companies with different ledger currencies.