Project Earnings

Use the Project Earnings report to review comprehensive financial data for a given project, phase, or task.

Select the Source of Budget Data

If you use the Planning application, use the options on the Budget tab to select the source of the project budget data for the report:

• Project Budget Worksheet in Accounting
• The plan mapped to the project in Planning

Effective Dates

Billing includes the option to specify effective dates for billing rates. You can establish a schedule of rates at which employee labor is billed throughout the course of a project.

If a project's billing rate is determined by a billing labor rate table, the date of the transaction affects the billing rate. This applies to transactions entered through Transaction Entry, using a Billing Labor Insert, or using a Billing Labor Transfer. DPS compares the transaction date with the effective dates in the billing labor rate table to determine which billing rate to use to calculate the billing amount.

Sorting Options

If you want to sort the report's data by project number, select one of the following sorting and grouping criteria on the Sorting/Grouping tab:

• Project Number: This criterion is a combination of the project number and the full project name. If project names are long, text for a single item may wrap to a second line, making the report a more difficult to scan.
• Project Number (Number Only): This criterion is just the project number. If you have long project names, you can select this criterion instead of Project Number so the text does not wrap to a second line and make the report more difficult to read.

Improve Performance with the Use Summary Table Option

Calculations performed for this report place high demands on processor resources. In some cases, it can take a long time to generate the report for large databases. To minimize the time it takes to generate the report, first run the Refresh Project Summary Table utility and then select the Use Summary Table option on the General tab of the Options dialog box for this report.

Multiple Currencies

If you use multiple currencies, a report may display amounts in different currencies. If the report contains a total for a column that contains mixed currencies, that total displays as ####, rather than as an actual amount. If you generate a report with a mix of currencies, you can include currency symbols or codes to identify the currency for each amount.

For more direct comparison of amounts, you can select a presentation currency for the report so that all amounts display in a single currency. To do that, select Presentation Currency in Report In on the General tab of the Options dialog box and specify the currency and the date for determining exchange rates.

Options Dialog Box

Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.