Invoice Register Options Tab

Use the Options tab to select report options for the Invoice Register report.

Detail Options

Field	Description
Billing Client	To display report content for a specific billing client, select a billing client name in this field. Or, use the search option in this field to enter criteria for selecting one or more billing clients to display on the report. The report includes invoices and credit memos that are based on the billing client that an invoice was posted with.
Billing Group	Billing groups are used to combine projects together for the purpose of billing a client. To have the report show content only for specific billing groups, enter the name of a main project for a billing group, or use the Project lookup to select one or more main projects. If you use multiple companies and you bill a client for a set of projects worked on by multiple companies within your enterprise, the company that owns the main project in the billing group is the company that generates the invoice for the entire billing group. Use the Billing Group List to review a billing group's settings, its main project, and a list of its sub-projects.
Intercompany Subledger Transactions	If your enterprise uses Intercompany Billing with detailed subledgers enabled, use this option to specify whether or not intercompany transactions created by Intercompany Billing are included on the report. Select one of the following: Exclude: Select this option to exclude all intercompany billing transactions. Include: Select this option to include all intercompany billing transactions. Include Only: Select this option to include selected intercompany billing transactions. Then select the projects in the Due From Project field. If you use Intercompany Billing with detailed subledgers enabled, intercompany invoices are created using a default project number that is specified in Intercompany Billing Setup (Settings > Accounting > Intercompany Billing, in the desktop application).
Due From Projects	If you select Include or Include Only in Intercompany Subledger Transactions, use this field to select the projects for which you want to include intercompany invoices.

Display Options

Field	Description
Client Detail to Display	Use this field to select additional client information to display on the report. If you select None, no additional client information is added to the report. If you select an option other than None, the effect of that option depends on your selections on the Columns & Groups tab. If you sort and group by the following in the Grouping and Sorting section on the Columns & Groups tab... And you select the following option in the Client Detail to Display field... The report displays this additional client information... Billing Client Number or Billing Client Name The report sorts projects and invoices based on the billing client number or name that an invoice is posted with. Number and Name The billing client number or name that an invoice is posted with. Billing Client Number or Billing Client Name The report sorts projects and invoices based on the billing client number or name that an invoice is posted with. Contact and Telephone The billing contact and telephone details from the posted invoice's billing client. If the billing client for an invoice on the report is the same billing client that is currently entered for the project on the Accounting tab in the Projects hub, the billing contact on the Accounting tab in the Projects hub displays on the report. If the billing client for an invoice on the report is not the same billing client that is currently entered for the project on the Accounting tab in the Projects hub, no billing client displays on the report. Billing Client Number or Billing Client Name The report sorts projects and invoices based on the billing client number or name that an invoice is posted with. Full Address The billing address from the Firms hub for the billing client that an invoice is posted with displays on the report. The billing contact displayed on the report is based on the billing client that an invoice is posted with. If the billing client for an invoice on the report is the same billing client that is currently entered for the project on the Accounting tab in the Projects hub, the billing contact entered for the project on the Accounting tab of the Projects hub displays on the report. If the billing client for an invoice on the report is not the same billing client that is currently entered for the project on the Accounting tab in the Projects hub, no billing client displays on the report. Primary Client Number or Primary Client Name Number and Name No additional client information Primary Client Number or Primary Client Name Contact and Telephone All contacts associated with each primary client Primary Client Number or Primary Client Name Full Address Each primary client's billing address and all of the client's contacts Project Number or Project Name Number and Name The billing client number and name that is currently entered for a project Project Number or Project Name Contact and Telephone Each project's billing contact Project Number or Project Name Full Address The billing address for each project's billing client and the project's billing contact
Column To Display Interest	Select the column where interest amounts are going to be displayed. You specify the headings for the applicable columns on the Accounts Receivable settings form in Billing settings (Settings > Billing > Accounts Receivable).
Only Include Credit Memo Details	Select this option if you want to exclude invoices from the Invoice Register report; only credit memos display on the report.

Time Frame Options

Field	Description
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. Job-to-Date: The report shows data from the beginning of the project 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 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.
Starting and Ending	This field displays when date range or period range related option is selected in a time frame related field. If a date range option is selected, use the Starting and Ending date fields to identify the start and end date range that will be used to generate the report. If a period range option is selected, specify both a starting and ending accounting period in the Starting and Ending fields to generate the report for selected accounting period.

Reporting Amounts

Field

Description

Report In

If you use multiple currencies, select the currency in which to display amounts on the report: Project Currency: Select this setting to use the currency specified in Project Currency on the Overview tab of the Projects form in the Projects hub. Billing Currency: Select this setting to use the currency specified in Billing Currency on the Overview tab of the Projects form in the Projects hub. Functional Currency: Select this setting to display the amounts in the functional currency of the active company.

Rollup Options

Field	Description
Project Number Rollup Options	Use this option to summarize report information for projects that use a standard numbering system. For example, if the first five characters of your project number represent a master contract, you can summarize (roll up) information for all projects that have a common master contract number. The Project Number Rollup slider box displays the number of characters in your (firm's) project numbers. For example, if you use a 10-digit project number, the slider box displays 123456790. A project number can also include up to two delimiters (such as, 12-345.67890). A phase total is the total of all occurrences of that phase across the base project. A task total is the total of all occurrences of that task across the base project. To roll up, 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.
Display Data As	If you set a project number rollup, use this option to select how you want to display the project data: Subtotal on Base Number: Select this option to display a group header at the beginning of each group of projects that matches the base rollup and then list each project in full detail. After the last project in the group, the report displays a group total. Summary on Base Number: Select this option to display totals for each group, but no project detail.
Phase Number Rollup Options	Use this option to summarize report information at the phase level for phases that use a standard numbering system. This option is only available if you use phases. The Phase Number Rollup slider box displays the number of characters in your firm's phase numbers. For example, if you use a 7-digit phase number, the slider box displays 1234567. A phase number can also include one delimiter (such as 12345.12). You can roll up the phase number and still display information by task. When you do, a task total is the total of all occurrences of that task across the base project. For example, the total for Task 00001 is the total of all Task 00001s in the base project. To display only phases (and tasks), use the Project Number Rollup slider (box) to cover the project number completely. To roll up, 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.
Task Number Rollup Options	Use this option to summarize report information at the task level for tasks that use a standard numbering system. This option is only available if you use tasks. The Task Base Rollup slider box displays the number of characters in your firm's task numbers. For example, if you use a 3-digit task number, the slider box displays 123. This option works in the same way as the project and phase number rollup options. For example, if the first two characters of your task number represent a department, you can roll up information for all tasks that have the same department number. To display only tasks, use the Project Number Rollup and Phase Number Rollup sliders to cover the project number and phase number completely. To roll up, 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.