This section includes the fields and descriptions for the Print Balance Sheet tab.
Selection Criteria Island
| Field | Description |
|---|
| Company No.
|
In these fields, you enter a range of companies. If you enter a range, the balance will only include information pertaining to companies within the specified range. If you leave these fields blank, they will not affect the balance.
|
| Account No.
|
In this field, you enter a range of account numbers. The balance will only include accounts with an account number within this range, and marked “Balance Sheet” in the window Account Structure. If you leave these fields blank, they have no influence on the selection criteria.
If you have marked the “Invert Sign” field in the Print Control island in the Account Information Card workspace, credit amounts will be printed as positive figures and debit amounts as negative figures.
|
| Department
|
Here you can select a department. The printout will only include balance sheet accounts assigned to this department If you leave these fields blank, they will not affect the balance.
|
| Statistics 1-4
|
Here you enter up to four statistics code ranges. The printout will only include balance sheet accounts with statistics codes within this range. If you leave the codes blank, the statistics fields will not affect the selection criteria.
|
| Sum Level
|
Here you can enter a range of sum levels. The printout will only include accounts marked “Balance Sheet” in the Account Structure workspace on a sum level within the given range. If you leave these fields blank, they will not affect the balance.
|
| Line No.
|
In these fields, you can specify a range of line numbers from the account structure. The printout will only include accounts marked “Balance Sheet” in the Account Structure workspace, and appearing on an account structure line within the specified range.
|
Select Criteria, Dimensions Island
| Field | Description |
|---|
| Location
|
In this field, you enter a range of locations. The balance will only include entries to locations within this range. If you leave the fields blank, they will not affect the balance.
|
| Entity
|
The functionality of this field is similar to the functionality of the field “Location” above.
|
| Project
|
The functionality of this field is similar to the functionality of the field “Location” above.
|
| Purpose
|
The functionality of this field is similar to the functionality of the field “Location” above.
|
| Spec. 1-3
|
The functionality of these fields is similar to the functionality of the field “Location” above.
|
| Local Spec. 1-3
|
The functionality of these fields is similar to the functionality of the field “Location” above.
|
Period Island
| Field | Description |
|---|
| Month/Yr.
|
Here you enter the starting month/year and ending month/year of the period for which the balance is to be printed. Enter the period as a number, for example, “1” for January, “2” for February, and so on.
If your company uses flexible periods that do not follow the calendar year, the month and year you enter here refer to the period defined in the window Fiscal Year.
|
Print Control Island
| Field | Description |
|---|
| Layout
|
In this field, you can select which layout to use for the printout. If no additional layouts for the current printout have been added in the Print Layout workspace in the Set-Up module, “Standard” is the only option.
|
| Include Zero Balances from Level
|
Here you specify whether to include balance sheet accounts with both zero opening and zero closing balances from a given level. If, for example, you enter “1,”,the balance will only show posting accounts (that is, accounts with sum level 0) if either the opening or closing balance for the period is different from 0.
|
| Include Page Break
|
Here you can specify whether to include page breaks, where this is specified by page break accounts marked “Balance Sheet” in the Account Structure workspace. If the box is checked, the printout includes page breaks.
|
| Include Headings
|
Here you can specify whether to include headings, where this is specified by heading accounts marked “Balance Sheet” in the Account Structure workspace. If the box is checked, the printout includes headings.
|
Currency Island
| Field | Description |
|---|
| Reporting Currency
|
In this field, you can specify the currency in which figures on the printout should be displayed. All total figures will be converted into and displayed in this currency. If the current user has been assigned to a company in the Users workspace, Maconomy suggests the company base currency of the company in question.
When converting amounts into the selected currency, Maconomy uses the exchange rates that are valid on the date entered in the field “Exchange Rate Date” below, and the exchange rate table used is the exchange rate table selected in the field “Exchange Rate Table” below. Please note that Maconomy performs currency conversion even though the original amount has been registered in the same currency as the one specified in this field, which may give rise to discrepancies between the registered amounts and the amounts shown in this window.
|
| Exchange Rate Date
|
In this field, you can specify an exchange rate date. When converting amounts into the reporting currency, Maconomy uses the exchange rates valid on this date according to the exchange rate table selected in the field “Exchange Rate Table” below.
|
| Exchange Rate Table
|
In this field, you can specify the exchange rate table to use when converting between currencies in the printout.
|
| Basis
|
In this field, you can specify which amounts on each G/L entry should form the basis of the printed figures. Each G/L entry stores the amount in enterprise currency, the base currency of the company in question, and the currency of the account on which the entry is recorded. The printout will for every G/L entry convert the amount in the currency of the basis selected into the reporting currency, using the selected exchange rate date and table.
|