With the [MAIN_CLASS_BAL (main_class_cd;co;FY;period;balance_type;value;calc;reportdate)] function you can retrieve the balance sheet amount for a classification or a series of classifications (category 1).
Company Select the administration from which you want to retrieve the Exact data. If you select 'Default', the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.
The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.
Function Select the function you want to use. In this case 'MAIN_CLASS_BAL'.
Classifications Select the classification (category 1) for which you want to retrieve the balance. Select multiple classifications as follows: 001:002. In this case the balance of classifications 001 through 002 will be displayed.
Financial year Enter the financial year for which you want to have the amounts displayed.
Period Enter the period for which you want to have the amounts displayed.
Unprocessed You can retrieve information after entry. This means that information from unprocessed entries will also be displayed (unprocessed= 1; processed=0).
Value Select which value you want to have displayed in the worksheet. You have the following options:
Calculation method Indicate which calculation method should be used. You have the following options :
Date Entries up to and including the date entered will be displayed on the worksheet.
Range If you select 'Date' here, entries for which the entry date falls within the range will be included in the result. If you select 'Reporting date' here, entries for which the reporting date falls within the range will be included in the result.
Example
MAIN_CLASS_BAL("001:005";17;2001;"12";1;3;2;"31/12/2001";2) The cumulative balance after entry of the actual amounts for classifications 001 through 005 in period 12, entered up to and including reporting date 31 December 2001, financial year 2001 for Company 17 will be displayed .