Converted balance

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

• Ledger currency (field CURLED)

The specified ledger currency depends on the type of ledger selected.

• Start date (field DATDEB)

Date from which the records are selected.

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

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.

• Currency (field CUR)

Currency recovered from the BALANCE table.

The currency information is vital because it is used to filter the entries in the required currency.
There are several possible cases:

• Selection currency = not entered: this means "all currencies together", that is to say that all the totals are selected independently of the currency in which they are entered. The columns in the transaction currency are not entered. The local currency amount columns in company currency are displayed.
• Selection currency = currency XXX: the inquiry only displays the entries recorded in the selected currency. The local currency amount columns in company currency are also displayed.

• Divisor (field DIVISE)

Code of the selected currency.

• Account (field COMPTE)

This field displays the account number.

• Description (field INTIT)

This field displays the account title.

• Beginning debit balance (field ANTDEB)

This field displays the amount expressed in original currency and loaded if the selection currency is entered and depends on the following situations:

For a company, a site, or a group of companies with the same fiscal year start and end dates:

The field is loaded if the amount of credit and debit movements 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 per the criteria selections.

If the inquiry concerns several fiscal years, the intermediary carry forward periods are not included.

For a group of companies with staggered fiscal years, i.e. with different fiscal year start and end dates:

Earlier balances are not displayed.

• Beginning credit balance (field ANTCDT)

This field displays the amount expressed in original currency and loaded if the selection currency is entered and depends on the following situations:

For a company, a site, or a group of companies with the same fiscal year start and end dates:

The field is loaded if the amount of credit and debit movements 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 per the criteria selections.

If the inquiry concerns several fiscal years, the intermediary carry forward periods are not included.

For a group of companies with staggered fiscal years, i.e. with different fiscal year start and end dates:

Earlier balances are not displayed.

• Period debit (field DEB)

This field displays the amount expressed in original currency and loaded if the selection currency is entered and depends on the following situations:

For a company, a site, or a group of companies with the same fiscal year start and end dates:

The field is loaded by the total of debit movements carried out during the inquired period.

The carry forward entries are never included.

The closed postings are included per the selection criteria and if the end date of the inquiry corresponds to the fiscal year end date.

If the inquiry concerns several fiscal years, the intermediary closed postings are not included.

For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

The carry-forward entries and the closed entries are not included.

• Period credit (field CDT)

This field displays the amount expressed in original currency and loaded if the selection currency is entered and depends on the following situations:

For a company, a site, or a group of companies 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 close postings are included per the selection Criteria 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 included.

For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

The carry-forward entries and the closed entries are not included.

• Period debit balance (field SOLDEB)

This field specifies, if the selection currency having been entered, the debit balance of the period in the selection currency.

• Period credit balance (field SOLCDT)

This field displays the credit balance of the period in the selection currency.

• Ending debit balance (field FINDEB)

This field displays the amount expressed in original currency and loaded if the selection currency is entered.

This field displays an amount if the actual accounting balance is a debit based on the total credit and debit movements from the selected and previous periods.

• Ending credit balance (field FINCDT)

This field displays the amount expressed in original currency and loaded if the selection currency is entered.

This field displays an amount if the actual accounting balance is a credit based on the total credit and debit movements from the selected and previous periods.

• Ledger beginning debit balance (field ANTDEBLED)

This field displays the amount expressed in the ledger currency depends on the following situations:

For a company, a site, or a group of companies with the same fiscal year start and end dates:

The field is loaded if the amount of credit and debit movements 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 per the selection criteria.

If the inquiry concerns several fiscal years, the intermediary carry forward periods are not included.

For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

The earlier balances are not displayed.

• Ledger beginning credit balance (field ANTCDTLED)

This field displays the amount expressed in the ledger currency depends on the following situations:

For a company, a site, or a group of companies with the same fiscal year start and end dates:

The field is loaded if the amount of credit and debit movements 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 per the selection criteria.

If the inquiry concerns several fiscal years, the intermediary carry forward periods are not included.

For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

The earlier balances are not displayed.

• Ledger period debit (field DEBLED)

This field displays the amount expressed in the ledger currency depends on the following situations:

For a company, a site, or a group of companies with the same fiscal year start and end dates:

The field is loaded by the total of debit movements carried out during the inquired period.

The carry forward entries are never included.

The close postings are included per the selection criteria 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 included.

For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

The carry-forward entries and the closing entries are not included.

• Ledger period credit (field CDTLED)

This field displays the amount expressed in the ledger currency depends on the following situations:

The field is loaded by the total of credit movements carried out during the inquired period.

The carry forward entries are never included.

The close postings are included per the selection criteria 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 included.

For a group of companies with staggered fiscal years, i.e., with different fiscal year start and end dates:

The carry-forward entries and the closing entries are not included.

• Ledger period debit balance (field SOLDEBLED)

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

• Ledger period credit balance (field SOLCDTLED)

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

• Ledger ending debit balance (field FINDEBLED)

This field displays the amount expressed in the ledger currency.

This field displays an amount if the actual accounting balance is a debit based on the total credit and debit movements from the selected and previous periods.

• Ledger ending credit balance (field FINCDTLED)

This field displays the amount expressed in the ledger currency.

This field displays an amount if the actual accounting balance is a credit based on the total credit and debit movements from the selected and previous periods.