Contents of the Consolidated Reporting Form

Use the form to set up a reporting group.

Header Information

Field Description
Find reporting group

At the top of the Consolidated Reporting form, enter either a complete or partial name or number in the Find consolidated reporting group lookup field to find and select an existing consolidated reporting group that you want to view or edit.

Your current record selection will be preserved if you switch to another application and then return to this form.

For information about creating and using searches, see the Search Vantagepoint help topics.

Search Navigation Controls

The Search Navigation Controls display to the right of the Find lookup field at the top of most Vantagepoint hub and application forms. Use these controls and their related components to quickly locate a saved search, create ad hoc or new searches, page through records, and find and select multiple hub records.

On the Saved Search control (), click to display the Saved Searches (left) pane and Record Selection (right) pane. Most search types include standard, personal (My Searches), shared, and complex searches, as well as an ad hoc search Selection. Available search types vary, depending on the active hub or application form.

For more information about Search Navigation Controls, see Search Quick Reference, Components of a Search, and Use Search Navigation Controls to Filter Records.

Saved Searches list To filter the list of reporting groups, select the following search type from the Saved Searches list:
  • All: Display a list of all reporting groups (both active and inactive) to which yo have access.
x of x Use these arrow icons to scroll through the records and open a different record on the form. The numbers indicate which record you are viewing out of the total number of records in the search results.
+ New Reporting Group Click this option to create a new reporting group. The form displays in edit mode with blank editable fields.
Name Enter a descriptive name for the reporting group.
Actions Bar

Use the Actions bar at the upper right of the form to perform common actions.

  • Save: Save changes to the currently displayed group.
  • Cancel: Cancel changes you made on the form.
  • Copy: Copy the currently displayed group.
  • Delete: Delete the currently displayed group.

General

Use this section to create a reporting group and identify the companies that belong to it.

Field Description
Group Enter a code name, up to ten alphanumeric characters, for the consolidation group.
Currency If you use multiple currencies, select the reporting currency for this consolidation group. This drop-down list includes all currencies enabled for use by your enterprise.
Gains and Losses Account If you use multiple currencies, specify the account to use for gains and losses due to rate translations when a company in the consolidation group has a functional currency that is different from the reporting currency selected in the Currency field. Enter an account number in this field or click and select an account on the Account Lookup dialog box.
Companies Grid

Use the grid to add or remove companies in the consolidation group.

  • : Display the filter fields for the grid. Use the filter fields to refine the displayed row items in the grid.
  • Company: Select the company subcode of the company that you want to add to the consolidation group.
  • Name: This field displays the descriptive name for the company.
  • : Remove the corresponding company from the grid.
  • + Add Company: Click this option to add a new company to the grid.

Eliminations

Use this section to identify accounts that you want Vantagepoint to eliminate when it processes consolidations.

Field Description
User Defined Elimination Accounts Grid
  • : Display the filter fields for the grid. Use the filter fields to refine the displayed row items in the grid.
  • Account: Enter the account number of the account that you want to eliminate from consolidations for the consolidation group, or select the account from the Account Lookup dialog box.
  • Name: This field displays the descriptive name for the account.
  • : Remove the corresponding account from the grid.
  • + Add User Defined Elimination Account: Click this option to add a new account to the grid.

Translations

If Vantagepoint is set up to use multiple currencies with the Consolidated Reporting feature, you must specify currency translation methods for the consolidation group when the functional currencies of the companies in the group are not the same. Do this in this section.

Field Description
Assets Select the method to use to determine exchange rates for asset accounts when the functional currencies of the companies in the consolidation group are not the same. The options are period end rate, period average rate, and historical rate.
Liabilities Select the method to use to determine exchange rates for liability accounts when the functional currencies of the companies in the consolidation group are not the same. The options are period end rate, period average rate, and historical rate.
Net Worth Select the method to use to determine exchange rates for net worth accounts when the functional currencies of the companies in the consolidation group are not the same. The options are period end rate, period average rate, and historical rate.
Reimbursables Select the method to use to determine exchange rates for reimbursable expense accounts when the functional currencies of the companies in the consolidation group are not the same. The options are period end rate, period average rate, and historical rate.
Directs Select the method to use to determine exchange rates for direct expense accounts when the functional currencies of the companies in the consolidation group are not the same. The options are period end rate, period average rate, and historical rate.
Indirects Select the method to use to determine exchange rates for indirect expense accounts when the functional currencies of the companies in the consolidation group are not the same. The options are period end rate, period average rate, and historical rate.
Revenue Select the method to use to determine exchange rates for revenue accounts when the functional currencies of the companies in the consolidation group are not the same. The options are period end rate, period average rate, and historical rate.
Other Charges Select the method to use to determine exchange rates for other revenue and expense accounts when the functional currencies of the companies in the consolidation group are not the same. The options are period end rate, period average rate, and historical rate.
Accounts Translation Overrides Grid
  • : Display the filter fields for the grid. Use the filter fields to refine the displayed row items in the grid.
  • Account: Enter or select a single account that is an exception to the translation method specified for its account type. For example, if you specify Historical Rate as the method for Asset accounts but want to set up a different translation for a specific asset account, you select that asset account here and use the corresponding Method field on this grid to select the alternate method.
  • Name: This field displays the descriptive name for the account.
  • Method: Select a translation method for the individual account: period end rate, period average rate, or historical rate.
  • : Remove the corresponding account translation override from the grid.
  • + Add Translation Account Override: Click this option to add an account translation override to the grid.