Labor Detail Options Tab

Use the Detail options to select the level of detail to display on the report. Use the Time Frame options to select a time frame for the report.

Detail Options

Field Description
Level of Detail Select the level of transaction detail included on the report:
  • All Transactions: The report displays all transactions.
  • Employee and Period: The report displays one detail line of summarized labor hours and amounts for each accounting period for each employee.
  • Employee: The report displays one detail line of summarized labor hours and amounts for each employee.
  • None: The report displays no transaction detail. It summarizes labor hours and amounts by labor code.
Print Timesheet Comments Select this option to print timesheet comments on the report.
Include Unposted Labor

Select this option to include hours from unposted timesheets:

  • Unposted timesheet transaction entry files
  • Timesheets that are in progress or submitted, but not posted

Vantagepoint uses extensions for cost and billing rates to calculate unposted labor amounts when timesheets are saved.

This option is not available if the Resource Planning module is activated, but the Accounting module is not activated. It is assumed that you are only importing posted actual values.

Employees Use the Employees lookup to select an individual employee to include on the report.

Time Frame Options

Field Description
Report Format Select one of the following report formats:
  • Specific Labor Posting: Select this option to generate the report for specific labor posting runs. When you select this option, the Labor Posting Logs grid displays, listing all timesheet, labor adjustment, and billing labor transfer posting runs for the current period. Use this grid to select the posting runs for which you want to generate the report. If you save the report options, the labor posting run selections are not saved.
  • Time Frame Options: Select this option to generate the report for a specific time frame. When you select this option, the Time Frame field displays so you can select the time frame you want.
Labor Posting Runs Grid This grid displays all timesheet, labor adjustment, and billing labor transfer posting runs for the current period. Use this grid to select the posting runs for which you want to generate the report. Note that if you save the report options, the labor posting run selections are not saved.

This grid is only available if you select Specific Labor Posting in Report Format.

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.

Reporting Amounts

Field Description
Report At

Select one of the following rate options:

  • Billing: Select this option to display monetary amounts at billing rates. This option is only available if the Enable Reporting at Billing Rates option is selected in Labor Options Settings.
  • Cost: Select this option to display monetary amounts at cost rates.
  • Burden: Select this option to include overhead amounts in labor cost amounts. This option is only available if the Enable Reporting at Burdened Rates option is selected in Labor Options Settings.
Report In

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

  • Billing currency
  • Project currency
  • Project's functional currency
  • Presentation currency

Report Activity Options

Field Description
Report Records with Activity in the Following Area Select the areas in which you want to report activity:
  • Project
  • Phase
  • Task
Define Activity Select the type of activity that you want to include on the report:
  • Labor, Expense, Cash Receipts, and Invoices
  • Labor and Expense Transactions Only
Find Activity in this Time Frame Select the time frame for which you want to include activity:
  • Current
  • Year-to-date
  • Job-to-date

Rollup Options

Field Description
Project Number Rollup Options 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.

Display Data As If you set a project base rollup, use this field to select how you want Vantagepoint to display the project data from the following:
  • 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 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.