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

Account Analysis Options Tab

Use the Options tab to select report options for the Account Analysis report.

Format Options

Field Description
Group Table If you want to use an account group to organize the account information in the report, select the group in this field. The Trial Balance report does not display data at the summary account group level.
Use Account Specific Settings If you select this check box and also group by Transaction Detail (on the Columns & Group tab), the setting selected in the Report Detail field on the Accounts settings form (Settings > General Ledger > Chart of Accounts) determines the level of detail to display.
Sort By Select a sort criterion, such as transaction type or project number, for the transaction detail.
Show Account Number and Name on Subsequent Pages Select this check box to have the report repeat the account number and account name at the top of subsequent pages of the report for easier identification.
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).

Organization and Time Frame

Field Description
Organization If your enterprise uses organizations and you want to generate the report for selected organizations rather than for the whole company, use the Organization lookup to select the organizations for the report.

If you use multiple companies, organizations in the active company are listed by default, but you can change that setting.

For the consolidated version of the report, this option is not available. Instead, you select a consolidation group.

Time Frame
Use these options to specify the time frame for data included on the report.
  • Current Period: The report shows data for the active accounting period.
  • Year-to-Date: The report shows data for the current fiscal year through the active accounting period.
  • Date Range: The report shows data for a date range that you specify. Vantagepoint examines transactions within the specified date range, regardless of the period in which the transactions were posted or the dates of the current active accounting period. Enter the start and end dates, or click the calendar icons to select the dates.
  • Period Range: The report shows data for a range of accounting periods that you specify.

Drill Down

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.
+ Manage 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.

Reporting Amounts

Field Description
Report In

Select the currency in which to display amounts on the report:

  • Project Currency: Choose this option to use the currency specified in Project Currency on the Overview tab of the Projects form in the Projects hub.
  • Presentation Currency: Choose this option to use the currency that you specify for the corresponding Presentation Currency option.
Presentation Currency If you set Report in to Presentation Currency, select the three-character ISO code for the currency. The list includes only the currencies that are enabled for your enterprise. All amounts on the report are presented in this currency. Vantagepoint calculates the exchanges between the project currency and the presentation currency based on the date that you specify in Exchange Rate as of.
Exchange Rate as of If you set Report in to Presentation Currency, specify the date that Vantagepoint uses to calculate exchanges between the presentation currency that you select and the project currency. Vantagepoint determines the correct exchange rates in the daily exchange rate table based on this date.

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.