There is an option in Sun to generate reports based on so-called balance table instead of the general ledger one. The ledger balance table contains summaries of the transactions from the ledger file. It is used to improve the speed with which financial reports and trial balances are produced.

To setup the balance table first you need to create it using Optional Ledger Tables (OLT).
If you are creating a balance table for your actuals ledger A, select letter A from Ledger Balance drop-down box:

Click OK and balance table consolidation screen will pop-up:

The balances hold data summarized by the following transaction details:

• account code
• period
• currency code
• provisional posting flag
• corrections flag
• analysis code.

Other information such as asset code or journal type is not held. The balance file cannot be used for reports which rely on these codes.
In addition, you can consolidate individual transaction analysis codes to consolidate the ledger information further. The balance file is only used for a financials report when it is appropriate to the report setup. Therefore financial reports which include items such as transaction reference, description and journal number, do not use the balances.
The next step you need to do is to enable balance table reporting. You can set up your ledger so that reports which use the Ledger Balances file do so regardless of whether or not it is up to date. If you want to do this, check the Report From Balance File field in LS - Ledger Setup

Click here to see the screenshot

Updating The Ledger Balances
Ledger Balance Update (LBU) is used to update the ledger balances with the latest transactions from your actual or budget ledger so that reports using the balance data give a true representation of the data.
To Update the Ledger Balances

1. Select the Ledger Balance Update (LBU) from the Navigation menu.
2. From the Action menu select Process, or click the Process button.

When you select Process, any transactions posted since the last update are consolidated and added to the balance file.
The time it takes to update your balances depends on the number of transactions you have entered since the last update. You may want to update your balances prior to running weekly or monthly financial reports.

Updating the balance table when Running Reports
When you request a report that uses the Ledger Balances file, you are offered the option to update the balances. This is the same as running the Ledger Balances Update (LBU) and is useful if you are running a single report.
Click here to see the screenshot

Note: The Trial Balance does not include this feature.
However, if you are printing a series of reports for a particular time frame, it is more efficient to use Ledger Balances Update (LBU) to update the balances once, and then produce all of the reports required without selecting the update option for the reports.

Rebuilding Ledger Balances
Ledger Balance Rebuild (LBR) recreates your ledger balances. You can roll forward previous years' data as brought forward balances. This has a similar effect to the Year Cleardown action in Ledger Cleardown. You can specify a year prior to your current year, known as 'last year', into which all previous values are accumulated. This also results in more efficient reporting.

Comments

Only registered users can write comments.
Please login or register.