| Field | Description |
|---|
| Report Name
|
You can change the default report name.
|
| Group Table
|
If you want to use an account group to organize the account information in the report, select the group in
Group Table.
|
| Account Base Rollup
|
Use
Account Base Rollup to summarize account information based on specific digits of the account number. For example, you could consolidate information for all accounts that share the same first two digits or for accounts that share the final two digits.
If you summarize accounts, the report displays the name of the first account in the range of summarized accounts as the name for the summarized data. This is true even if no amount is posted to that account.
The
Account Base Rollup slider box shows the format of your firm’s account numbers (for example,
123.45 for a five-digit account number with a period separating the first three digits from the last two).
To roll up account numbers, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides.
|
| Organization Lookup
|
If your firm uses organizations in Vision and you want to generate the report for selected organizations rather than for the whole company, click
 in
Organization Lookup to display the Organization Lookup dialog box. In that dialog box, select the organizations for the report.
If you use the Multicompany feature, the default is the organizations in the active company, but you can change that setting. For the Consolidated Balance Sheet, this option is not available. Instead, you select a consolidation group.
|
| Consolidation Group Lookup
|
If you want to generate the Consolidated Balance Sheet, select the consolidation group for which you want to generate it.
If you use the Multicompany feature, you can generate a consolidated Balance Sheet that combines financial data from multiple companies in your enterprise that are members of a consolidation group.
Before you can select a consolidation group in
Consolidation Group Lookup, you must run the consolidation process in Accounting.
If you use the Multicurrency feature, the report displays amounts in the currency specified for the consolidation group.
|
| Cash Basis
|
Select this option to generate the cash-basis version of the report.
This option is not available if the cash-basis reporting feature is not enabled.
|
| Use Summary Table
|
Because of the calculations involved, it may take longer to generate a Balance Sheet than it does for most other reports. This is particularly true for large databases. To get the best performance, run the Refresh GL Summary Table utility and select the
Use Summary Table check box on the General tab in the Options dialog box for the report before you generate the Balance Sheet.
Recommendation: The Refresh GL Summary Table utility calculates and stores the financial data needed for this report in a summary table. We recommend that you schedule the Refresh GL Summary Table utility to run after business hours each night, so that financial reports printed the next day show current data as of close of business the day before.
Use Summary Table is disabled until you run the Refresh GL Summary Table utility the first time. Thereafter, the check box label includes the date on which the utility was last run (for example,
Use Summary Table (Updated: 4/5/11 12:09PM) ).
|
| Account Subtotal
|
Select this check box to display a subtotal row for each group of related accounts, based on the number of account digits that they share. You specify the number of digits to compare in
Digit.
For example, if you enter
2 in
Digit, the report displays a subtotal row for each set of account numbers that begin with the same two digits. If you have accounts 101.00, 102.00, 103.00, and 104.00, the report displays a subtotal row for this set of accounts.
|
| Digit
|
If you selected
Account Subtotal, enter the number of beginning digits that the accounts to be subtotaled must share.
|
| Label
|
If you selected
Account Subtotal, enter a label for the subtotal row. Most firms use
Subtotal for the label.
|
| Hide Account Number
|
Select this check box to hide account numbers and display only account names. If you do not select this check box, the report displays both the account numbers and account names.
|
| Display Amounts in Presentation Currency
|
Select this check box to display all amounts in a single presentation currency.
Select the presentation currency in
Presentation Currency. In
Exchange Rate as of, enter the date you want Vision to use to select the exchange rates when it converts other currencies to the presentation currency.
|
|
Presentation Currency
|
If you select
Display Amounts in Presentation Currency, select the presentation currency for the report in
Presentation Currency. The drop-down list contains the currencies that are enabled for your enterprise.
|
|
Exchange Rate as of
|
If you select
Display Amounts in Presentation Currency, enter the date you want Vision to use to select the exchange rates when it converts other currencies to the presentation currency.
Vision uses the exchange rates from the daily exchange rate table for the date you specify.
|
| Set start period for current year's retained earnings
|
Use this option in conjunction with custom period amount columns if you need to simulate different fiscal years for different companies.
Select this check box, and then select the starting accounting period.
If you use this option, the opening balance on drill-down reports are based on the retained earnings start period.
|