This utility is used to carry out a group of checks on the balances:

  • the verification of their balancing,
  • the verification of data with respect to the records in the General Ledger,
  • the recovery of amounts, which, following these verifications, cannot be found in the BALANCE file.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

The balance recovery is made by company and for a given fiscal year. It is possible to limit the selection of the amounts to be processed using a set of criteria (site, currency, account).

The following checks are carried out once the utility is launched and according to the selected option:

  • either the verification of the debit/credit balancing of the GL balance [BAL],
  • or the verification of the balance/General Ledger balancing (in transaction currency, local currency and reporting currency amounts in [DAE]),
  • or the recalculation of the balance on the basis of the General Ledger.  

In particular, the controls and resynchronizations (if the option is selected) are as follows:

  • If the "balance verification" is launched for a given company, for all sites, and an imbalance occurs:
    • gives the total debit/credit for the company and the period concerned,
    • it gives the debit/credit total for the site that is more particularly concerned and the period.
  • If the "GL balance verification" is launched for a given company, with all sites, and an imbalance occurs:
    • It gives for the account concerned the debit/credit total for the balance and GL, for the company and period.
    • gives the total debit/credit for the company and the period concerned,
    • It gives for the account with variance the debit/credit total for the balance and GL, for the site more specifically concerned and the period.
    • it gives the debit/credit total for the site that is more particularly concerned and the period.
  • If the "balance recovery" is launched:
    • AMTCUR (transaction currency), AMTLOC (company currency) and AMTRPT (reporting currency) are stored in [DAE].

The processing is based on these amounts for the recovery.
Example: if a company managed with EUR is specified and the control is carried for the EUR, the verification will be carried out on AMTLOC. If the verification is made in USD and the folder is set up with the reporting currency USD the process is based on AMTRPT. In all other cases it will be based on AMTLOC.

Criteria

Company (field SOCIETE)

No help linked to this field.

All sites (field TOUSITE)
Site (field SITE)
Ledger type (field LEDTYP)
Fiscal year (field EXERCICE)

No help linked to this field.

Start date (field DATDEB)
End date (field DATFIN)
Currency (field DEVISE)

No help linked to this field.

Account (field COMPTE)

No help linked to this field.

Action on

General balance (field BALGEN)

Batch task

This function can be run in batch mode. The standard task ACCRECBAL is provided for that purpose.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Impossible to place an exclusive lock on the company

It is not possible to lock a company if it is subject to updates in another function.

Tables used

SEEREFERTTO Refer to documentation Implementation