Labor Detail General Tab

Use the General tab to select report options for the Labor Detail report and to save sets of options for reuse.

Contents

Field Description
Report Name You can change the default report name.
Create Activity To create activities in the Calendar/Activities application when you generate the report, select this check box. When you generate the report, Vision displays the Activity dialog box so that you can enter the activity information. Vision then creates an activity for each project included on the report.
Project Base Rollup Use Project Base Rollup 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 firm’s project numbers. For example, if your firm uses 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 the field immediately below Project Base Rollup to select how you want Vision 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 Phase Base Rollup 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 your firm uses 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 Task Base Rollup 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 your firm uses 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.

Print Comments Select this check box to include on the report the invoice comments specified during transaction entry. The expanded text content will display when this option is selected.
Final Totals Select this check box to include a line at the end of the report that displays totals for all amount columns.
Unposted Labor Select this check box to include unposted timesheet information on the report.

If you select this check box, Vision includes the following timesheet data:

  • All timesheet data in unposted transaction entry files.
  • All Time & Expense timesheets that are in progress or submitted, but not posted.

The report displays the code u next to unposted time.

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

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.
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 Reporting at billing rates option is selected on the Accounting System Settings form (Configuration > Accounting > System Settings).
  • Cost — Select this option to display monetary amounts at cost rates. This option is only available if the Reporting at burdened rates option is not selected on the Accounting System Settings form (Configuration > Accounting > System Settings).
  • Burden — Select this option to include overhead amounts in labor cost amounts. This option is only available if the Reporting at burdened rates option is selected on the Accounting System Settings form (Configuration > Accounting > System Settings).
Report In If Report At is Cost, indicate in which of the following types of currency you want Vision to display monetary amounts:
  • Project Currency
  • Billing Currency
  • Project's Functional Currency
  • Presentation Currency — Use the Presentation Currency and Exchange Rate as Of options to specify the currency and the date to use in calculating exchange rates.

If Report At is Billing, indicate in which of the following types of currency you want Vision to display monetary amounts:

  • Billing Currency — The currency is based on the setting for the Use billing currency not Project currency option on the Reporting tab of the Accounting System Settings form. When Use billing currency not Project currency is selected, the monetary amounts are displayed in the project's billing currency. When that option is not selected, the amounts are displayed in the project currency.
  • Presentation Currency — Vision uses a single currency to display all monetary amounts. Use the Presentation Currency and Exchange Rate as Of fields to specify the currency and the date to use to determine exchange rates.
Presentation Currency If you select Presentation Currency in Report In, select the currency in which you want the report to display monetary amounts. The drop-down list includes all currencies enabled for use by your enterprise.

Vision presents all amounts on the report in the currency you specify, even though projects might not share a common project currency, billing currency, or functional currency. Vision uses the date you specify in Exchange Rate as Of to determine the exchange rates to use to calculate the amounts.

Exchange Rate as Of If you select Presentation Currency in Report in, specify the date that you want Vision to use to determine the exchange rates used to calculate the presentation currency amounts from the project currency amounts.

Enter the date directly in the field or click and select the date.

Time Frame Specify the period for the report:

Period

Select a setting from the drop-down list:

  • 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. You can select accounting periods from the drop-down lists, or you can enter them in mm/yyyy format.

Dates

Enter the start and end dates of the range, or click for each field and select the dates.

Select Posting Runs Click this option to include only transactions from selected labor posting runs on the report.

When you click this button, Vision displays the Labor Posting Logs dialog box. That dialog box lists all timesheet, labor adjustment, and billing labor transfer postings for the time frame you specified.

  • To select one posting run, click that row.
  • To select multiple posting runs in consecutive rows, hold down the SHIFT key and click the first and last row.
  • To select multiple posting runs that are not in consecutive rows, hold down the CTRL key and click each row.

If you save your report options, Vision does not save labor posting run choices.

Employee Lookup Use this option to select the employee who are included on the report.

Click to display the Employee lookup and select one or more employees

  • To select one employee, click that row.
  • To select multiple employees in consecutive rows, hold down the SHIFT key and click the first and last row.
  • To select multiple employees that are not in consecutive rows, hold down the CTRL key and click each row.