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 (). 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.