The Options tab of the Unbilled Detail and Aging Options dialog box gives you additional control over the data displayed on the Unbilled Detail and Aging report.
Contents
Options
| Field | Description |
|---|
| Show Timesheet Comments
|
Select this check box if you want timesheet comments included in the report.
|
| Use Reporting Default Terms
|
If you select this check box, the report uses default billing terms when no labor or expense billing terms are defined for a
project. If you have
projects that have only fee terms, you can use this option to the see the labor and expense at a billing value.
DPS determines default terms for a
project as follows:
- If default billing terms exist for the
project on the Labor tab and Expenses/Units tab of the Billing Terms form, the report uses those billing terms.
- If no default billing terms exist for the
project on the Labor tab or Expenses/Units tab of the Billing Terms form, the report uses the global default terms defined on the Reporting Default Terms form ().
|
| Show
Project/Phase/Task Info
|
Select this check box to include the following additional information for each
project,
phase, and
task:
-
Compensation
- Revenue Type
-
Principal
-
Project Manager
-
Client Number
If you select this check box, you can also include
job-to-date billed amounts.
|
| Show
JTD Billed
|
Select this check box to include
job-to-date billed amounts. This option is only available if you select
Show
Project/Phase/Task Info.
|
| Single Line Summary
|
Select this check box to display a one-line summary for each
project,
phase, and
task.
|
| Show Final Totals
|
Select this check box if you want a
Final Totals line at the end of the report. That line shows total hours and amounts for the entire report. Whether the final totals are for cost or billing depends on the
Aging Report Basis option (see description below).
|
| Show
Employee Totals
|
Select this check box if you want the report to show total hours and amounts for each
employee.
|
Include
| Field | Description |
|---|
| Billable transactions
|
Select this check box to include transactions with a status of Billable.
|
| Held transactions
|
Select this check box to include transactions with a status of Held.
|
| Transactions to be Written Off
|
Select this check box to include transactions with a status of Write off.
|
| Transactions to be Deleted
|
Select this check box to include transactions with a status of Deleted.
|
| Non-billable transactions
|
Select this check box to include transactions with a status of Non-billable.
- Non-billable transactions at billing rates display with a status of
B and no amount.
- Non-billable transactions at cost rates display with a status of
B and the transaction amount. Generate the report at cost rates to review the non-billable transactions for a
project with their amounts.
|
| Report Cost in
|
If you use multiple currencies, select the currency type for cost amounts.
|
Aging Date
Select the date from which the aging data is calculated:
| Field | Description |
|---|
| Today's Date
|
Age transactions based on the current date.
|
| Period End Date
|
Age transactions based on the last day of the current accounting period.
|
| Specific Date
|
Age transactions based on the date that you specify.
|
Final Totals and Aging Report Basis
Select one of the following:
| Field | Description |
|---|
| At Cost
|
The report includes non-billable transactions.
|
| At Billing
|
The report excludes non-billable transactions.
|
Bill thru Date
Specify a cutoff date for transactions to be included in the report.
| Field | Description |
|---|
| Today's Date
|
The cutoff date is the date that you generate the report.
|
| Accounting Period End Date
|
The cutoff date is the end date of the current accounting period when you generate the report. For example, if you generate the report on 5/11/2018, the cutoff date is 5/31/2018, the last day of the accounting period.
|
| Specific Date
|
The cutoff date is the date that you specify in
Bill thru Date on the Options tab.
|
Bill thru Period
If you enter a specific date in
Bill thru Date, the period that you specify in
Bill thru Period must be consistent with that date. Specify a cutoff period for transactions to be included in the report:
| Field | Description |
|---|
| Current
|
The cutoff period is the current active period when you generate the report. For example, if you generate the report on 5/11/2018, the cutoff period is 05/2018.
|
| Period
|
The cutoff period is the period that you specify in
Bill thru Period on the Options tab.
|
