Converted balance

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

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

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

Date from which the records are selected.

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

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

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

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

Code of the selected currency.

This field displays the account number.

Title of the account.

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.

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.

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.

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.

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

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

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.

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.

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.

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.

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.

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.

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

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

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.

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.