Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Consolidated Balance Sheet Options Tab

Use the Options tab to select report options for the Consolidated Balance Sheet report and to save sets of options for reuse.

Format Options

Field Description
Consolidation Group Lookup If you use multiple companies, you can generate a consolidated report that combines financial data from multiple companies in your enterprise that are members of a consolidation group.

To generate the consolidated version of the report, select the consolidation group for which you want to generate it. Before you can select a consolidation group here, you must run the consolidation process in General Ledger > Consolidations.

If you use multiple currencies, the report displays amounts in the currency specified for the consolidation group.

Account Group Table If you want to use an account group to organize the account information in the report, select the account group in this field.
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.
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 the Digit field, 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 (for example, Subtotal).
Set Start period For Current Years 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 will be based on the retained earnings start period.

Drill Down

Use this section to select the types of data for which you want to drill down.

Vantagepoint organizes the drill-down report based on your selection. For example, if you select Transaction Type and drill down from a balance or total, the drill-down report displays the amount that each transaction type (for example, cash disbursements, cash receipts, journal entries) contributed to the balance or total.

Field Description
Detail Starting Period Select the starting period.
Drill Down The selected data for the drill-down report displays in this grid. Click and drag to the left of a row to re-order the drill-down sequence or select at the right end of a row to delete a category.
+ New Drill Down Click this link to display the Manage Drill Down dialog box, on which you can specify the data to display in the Drill Down grid. For details, see Contents of the Manage Drill Down Dialog Box.
Sort Account Detail Use this section to specify multiple levels of sorting criteria for the data that displays on the report.

Base Rollup

Field Description
Base Rollup Use this option 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 Number Rollup Options slider box shows the format of your enterprise’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.