Search HansaManuals.com HansaManuals Home >> Standard ERP >> Nominal Ledger >> Reports Previous Next Entire Chapter in Printable Form Search This text refers to program version 5.3 Balance Sheet - Defining You can define the structure of the Balance Sheet to suit your requirements. The following example illustrates the set-up process.To change the report definition of the Balance Sheet, first click the [Settings] button in the Master Control panel and double-click 'Report Settings' in the subsequent list. Then, highlight 'Balance Sheet' in the list on the left-hand side of the 'Report Settings' window and click the [Definition] button. The 'Definition of Balance Sheet: Browse' window is opened. Double-click the first row, "10: Fixed Assets". The 'Definition of Balance Sheet: Inspect' window is opened, showing the current definition of the row. The number identifies the row in the Balance Sheet, and the Text "Fixed Assets" is printed in the report as a heading for a group of Accounts when the report is sent to the screen or to the printer. Of the four Type options, "Accounts" has been selected, which means that each of the Accounts in the range will be printed individually in the report. After the last Account in the group, a total for the group will be printed. The Account Type is "Asset". The Account Type concept is explained here. The Side and Active/Passive options are described on the Special Features of the Balance Sheet page. You should use the grid to enter various translations of the Text (i.e. the report heading or sub-heading). Specify a Language in the first column using 'Paste Special' if necessary, and the appropriate translation in the second column. There is no need to enter a row for your home Language. When you print the report, you can specify which Language is to be used. The Extra Code is used in Russia where the Balance Sheet is printed using a standard report design that includes line numbers: use this field to specify the correct line number for this row of the report. The Extra Code only appears in the report when you produce it using the No Comparison option. The Accounts field consists of three rows, with room for a definition 300 characters long. As alternatives to specifying a range of Accounts, you can also specify a number of individual Accounts, or ranges of Accounts, separated by commas. If you enter a range of Accounts with the highest number first, the Accounts in that range will be presented in reverse order. For example, the sequence "605:601,626,651:655" will appear as follows in the printed report:
Click forward to row 40, "Total Current Assets". The Type of this row is "Sum", which means that the total values from rows 25, 30 and 35 will be added together. The result will be shown on line 40 under the heading "Total Current Assets". The Account Type is still "Asset". Since the Type is "Sum", the Accounts field contains previously defined row numbers (25+30+35), not Account Numbers. Do not enter Account Numbers in the three Accounts fields if the Type is "Sum". Click forward to row 100. Taken together, rows 100 and 105 will print the total balance for Accounts 100:599999 without listing those Accounts individually. Since these are the Income and Expense Accounts, this is appropriate for the Balance Sheet. When you have finished with the last row, if you want to save your changes, click [Save], or else close the window with the close box. Then, close the list of definitions using the close box once again. The new Balance Sheet report is now ready to print.
If you stay within the structure of the Chart (e.g. avoid putting Liability Accounts among the Assets!), there is no need to alter the definitions. But remember, it is a good idea to print a test Balance Sheet to see if your definitions produce exactly what you expect. Inserting a Row in the Balance Sheet
|