Invoice Register General Tab

Use the General tab to select report options for the Invoice Register report and to save sets of options for reuse.

Base Rollup

Field Description
Project Base Rollup

Use this option to summarize 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 Base Rollup slider box displays the number of characters in your project numbers. For example, if you use a 10-digit project number, the slider box displays 1234567890. A project number can also include up to two delimiters (for example, 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 project 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.

Subtotal or Summarize on Base Number

If you set a project base rollup, use this field to select how you want Deltek 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.
  • Summarize on Base Number: Select this option to display totals for each group but no project detail.
Phase Base Rollup

Use this option to summarize report information for phases that use a standard numbering system. The Phase Base 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 (for example, 12345.12).

You can roll up the base phase 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 Base Rollup slider to cover the project number completely.

To roll up phase 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.

Task Base Rollup

Use this option to summarize 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 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 show only tasks, use the Project Base Rollup and Phase Base Rollup sliders to cover the project number and phase number completely.

To roll up task 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.

Field Description
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.

Billing Client Select one or more clients on the Client lookup.
Client Info to Display

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 Sorting/Grouping tab.
If you sort and group by... Option The report displays this information:
Billing Client Number or Billing Client Name Number and Name No additional client information
Contact and Telephone All contacts associated with each billing client
Full Address Each billing client's billing address and all of the client's contacts
Client Number or Client Name Number and Name No additional client information
Contact and Telephone All contacts associated with each primary client
Full Address Each primary client's billing address and all of the client's contacts
Project Number or Project Name Number and Name Each project's billing client number and name
Contact and Telephone Each project's billing contact
Full Address The billing address for each project's billing client and the project's billing contact

Print Client Notes Select this check box to include notes entered in the Firms hub. Deltek displays the full text of the notes as the last line of the client information section. If you commonly want to include notes on this report, we recommend that you try to limit the length of the notes you enter for clients. Otherwise, the notes can increase the size of the report significantly. The notes in the report retain any text formatting that was applied when they were entered in the Firms hub.
Interest Column

Select the user-defined column in which to include interest amounts. Interest amounts are added to any other invoice amounts included in the column you select.

If you select No Interest, Deltek displays interest amounts in the Other column.

You specify headings for the user-defined columns on the Ledger Headings tab of the Accounts Receivable Configuration form (Settings > Accounting > Accounts Receivable). You map invoice accounts and accounts receivable accounts on the Invoice Mapping Accounts tab and the AR Mapping Accounts tab.

Only Include Credit Memo Details Select this check box if you want to exclude invoices from the Invoice Register report; only credit memos display on the report.
Report at If you use multiple currencies, select the type of currency in which monetary amounts display.

Time Frame

Use these options to specify the timeframe for data included on the report.

Field Description
Period

Select a setting:

  • Current: The report shows data for the accounting period that is currently open.
  • Year-to-Date: The report shows data for the current fiscal year through the current accounting period.
  • Job-to-Date: The report shows data from the beginning of the project through the current accounting period.
Period Range Specify a range of accounting periods.
Date Range Specify the start and end dates of the range.
Field Description
Exclude/Include 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. If you want to see the accounts receivables from projects that belong to other companies on the report, you must change the default Sorting/Group By options on the Sorting/Grouping tab: Clear the Sort check box for Project Number, and select the Sort check box for Due From Project.

Due from Project If you select Include Only in Exclude/Include Intercompany Subledger Transactions, use this field to select the projects for which you want to include intercompany invoices.