Calculation of Balances

7.10. Calculation of Balances

Important information!

The Balance Revaluation function will not produce valid data unless the system parameter ‘Functional Currency 1 in use’ is in use. (You find this parameter on the Currency sub tab on the Accounting tab in the System Parameter Maintenance folder currency tab)

Request a Balance Revaluation #

inset_2000121.jpg
General Ledger
Balance Revaluation icon Click the General Ledger Balance Revaluation icon in the Period Functions folder on the System Utility desktop to see the Balance Revaluation window. In this window you see fields for:

  • Booking year and period
  • Specification of Exchange rate

Balance_Revaluation_new.png

After you have entered the Booking year, Period and Exchange rate and clicked Start, SICS produces a set of entries in the GL_BALANCE table.

From Technical booking, movements will be created for each Entry Code Subcategory except for Entry Code Category Technical and Non-technical.

In addition, movements for liquid balance will be calculated both from technical bookings and pairing items.

New Period end balances will be created based on previous balances and above movements. Revaluation items will be included in GL_BALANCE.

For a description of GL_BALANCE, refer to the comments in the database.

Balance Revaluation Job Steps #

SICS goes through a set of steps when re-valuing balances. The section below describes these steps.

  1. Flags the rows in GL_T_ALL and GL_P_ALL that are going to be part of the balance calculation.

  2. Only items with booking year and period up to and including the booking year and period specified by the user will be part of the calculation.

  3. Sums up all the non-liquid balance movements from GL_T_ALL and insert into GL_BALANCE. (Status = ‘N’, Balance type = ‘TM’, IS_LIQUID = ‘N’)

  4. Sums up all the liquid balance movements from GL_T_ALL and insert into GL_BALANCE. (Status = ‘N’, Balance type = ‘TM’, IS_LIQUID = ‘Y’)

  5. Sums up all the liquid balance movements from GL_P_ALL using the first balance and insert into GL_BALANCE. (Status = ‘N’, Balance type = ‘PM’, IS_LIQUID = ‘Y’)

  6. Sums up all the liquid balance movements from GL_P_ALL using the second balance and insert into GL_BALANCE. (Status = ‘N’, Balance type = ‘PM’, IS_LIQUID = ‘Y’)

  7. Adds the newly created balance movements and the balance out for the previous period and insert the result into GL_BALANCE.

  8. The re-valued balance has been calculated (in FUNC_AMOUNT). The functional amounts (in FUNC_AMOUNT) has been added, and put into PREV_FUNC_AMOUNT. (Status = ‘N’, Balance type = ‘B’)

  9. The difference between FUNC_AMOUNT and PREV_FUNC_AMOUNT is calculated and inserted into GL_BALANCE.
    (Status = ‘N’, Balance type ‘R’) These items could/should be transferred to General Ledger.

  10. Cleanup. Status is set to ‘O’ (old) for all rows with Status ‘C’ (current).
    Status is set to ‘C’ for all rows with Status ‘N’ (new).

  11. The user can use any tool to delete rows with status ‘O’ from the table.