Invoice Transaction Detail

The Invoice Transaction Detail report supports the option to post fee billed revenue based on transaction detail. On this report, review the transaction detail used to allocate and post fee billing amounts to revenue accounts and to work breakdown structure (WBS) components (project, phases, and tasks).

For each invoice, the report provides complete transaction detail, grouped and subtotaled by general transaction type (labor, consultant, and expenses). You have the option to also display the invoice total amount and totals for each of the invoice sections: fees, labor, reimbursable expenses, and so on.

In addition to posted transactions, the report includes any billing-only transactions created in Interactive Billing. The detail on this report matches the detail displayed in Interactive Billing when the invoice was posted.

Settings

To enable the option to post fee invoice revenue based on transaction detail, use the Fees tab of the Billing Setup form (Settings > Billing > General). However, the decision to use that option is made on a project-by-project basis on the Billing Terms form.

Revenue Allocation Based on Cost or Billing

On the Fees tab of the Billing Setup form, your enterprise indicates if fee billed revenue is to be allocated to revenue accounts based on transaction cost or transaction billing value. That decision has important implications for how you generate the Invoice Transaction Detail report if you want to review the transaction detail used to make the allocations:

If the Calculate Transaction Values setting is... On the Options tab, you should:
Cost Select all billing statuses under Include
Billing Select only the Final Billed Transactions setting under Include

Invoice Adjustments and Credit Memos

If an invoice included on the report has associated adjustments or credit memos, the adjustments and credit memos are included on the report but are listed separately from the invoice detail.

Voided Invoices

The report includes voided invoices for reference, but they have no billed values or labor and expense amounts.

Record Selection

This report is designed to display information for entire invoices. If you select records for the report based, for example, on phase manager, DPS selects invoices for that phase manager, but the report includes all data for those invoices, not just that manager's portion of the invoice data.

Changes after Invoice Posting

If, after an invoice is posted, changes are made to the transactions associated with the invoice or to the billing terms, or other changes occur that affect the calculation of billing value or cost (whichever is used to allocate fee billed revenue) for those transactions, the transaction detail on the Invoice Transaction Detail report will no longer tie out to the original fee billed revenue allocations. DPS does not adjust the allocations for changes that occur after the invoice is posted, but the report is based on your current data.

Multiple Companies

If you use multiple companies, this report only includes invoices for projects billed by the active company. Those projects include the following:

  • Projects owned by the active company
  • Sub-projects in billing groups with main projects owned by the active company. These sub-projects can belong to other companies.

The report does not include data from sub-projects that are owned by the active company but that are also part of a billing group with a main project owned by another company.

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.