| Field | Description |
|---|
| Report Name
|
You can change the default report name.
|
| Project Base Rollup
|
Use this field to summarize the report information for projects that use some common numbering scheme. For example, if the first five characters of your project number represent a master contract, you can consolidate, or 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 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).
You can roll up the base project and still display information by phase or task. If you do, note the following:
- 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
-
Summarize on Base Number
|
| Phase Base Rollup
|
This field displays if you use phases. Use this field to summarize the report information for phases that use some common numbering scheme. The
Phase Base Rollup slider box displays the number of characters in your 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. If you do, note that 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 show only phases and tasks, use the
Project Base Rollup option 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 for tasks that use some common numbering scheme. For example, if the first two characters of your task number represent a department, you can consolidate, or roll up, information for all tasks that have a common department number. The
Task Base Rollup slider box displays the number of characters in your task numbers. For example, if your firm uses a 3-digit task number, the slider box displays
123.
This task base rollup is available only if you use tasks.
To show only tasks on the current report, use the
Project Base Rollup slider and
Phase Base Rollup slider 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.
|
| Billing Group
|
Billing groups are used to combine projects together for the purpose of billing a client.
Enter the name of a main project for a billing group, or click
 and select one or more main projects in the Project Lookup dialog box.
If you use Multicompany 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
|
Enter a client name, or click
and select one or more clients in the Client Lookup dialog box.
|
| Aging Date
|
Select the date as of which you want to age invoice amounts:
-
Current Date — Age invoice amounts as of the date the report is run.
-
Period End Date — Age invoice amounts as of the last day of the active accounting period in which the report is run.
-
Specific Date — Age invoice amounts as of a date you specify. Enter the date, or click
 and select the date.
For example, if you select
Current Date in this field and select
Invoice Date in
Age Using, the age of an invoice amount is the number of days between its invoice date and the current date.
|
| Age Using
|
Select the date from which you want to age invoice amounts.
- Invoice Date — This calculates the age of invoices as the difference between the invoice date and the date you select in Aging Date section.
- Due Date — This calculates the age of invoice amounts as the difference between the invoice due date and the date that you select in the Aging Date section on this tab. If you select this option and the report includes invoices that do not have due dates, the invoices without due dates are aged using the invoice date. When you age invoices by due date, Vision ages an invoice using the oldest due date among the
outstanding (unpaid) invoiced amounts of all work breakdown structure (WBS) levels for which the invoice was posted.
|
| Time Frame
|
Specify the period for the report. The report includes transactions dated within that period.
Period
Select a setting from the drop-down list:
-
Current — The report displays data for the accounting period that is currently open.
-
Year-to-date — The report displays data for the current fiscal year through the current accounting period.
-
Job-to-date — The report displays data from the beginning of the project
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.
Date Range
Enter the start and end dates of the range, or click
in each field and select the dates.
|
| Exclude/Include intercompany subledger transactions
|
If your firm 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.
From the drop-down list, 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, click
 in this field to select the projects for which you want to include intercompany invoices.
|
