Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.
The last four total lines always display in the following order, no matter which options you select on the General tab and Options tab:
- Final Totals (Interest Included)
- Distribution
- Interest Totals
- Final Totals (Net of Interest)
Contents
| Field | Description |
|---|
| Invoice
|
This column displays the invoice number.
|
| Invoice Date
|
This column displays the date on which the invoice was issued.
|
| Due Date
|
This column displays the due date of the invoice.
|
| Balance
|
This column displays the unpaid balance of the invoice. The balance does not include outstanding retainage, because retainage is not considered due for payment.
|
| Age 01 to Age 05
|
For each age column, you can specify a range of days in the grid on the Columns tab. Five additional age columns are available if you need additional age ranges.
|
| Project
|
This column displays the project number associated with the transaction.
|
| Phase
|
This column displays the phase number associated with the transaction.
|
| Task
|
This column displays the task number associated with the transaction.
|
| Age 06 to Age 10
|
Use these columns to display additional age ranges.
|
| Interest
|
This column displays the amount of interest posted for past due invoice amounts.
|
| Retainage
|
This column displays the amount of retainage that is not currently due for payment. This column is available only if
Enable Retainage is selected on the General tab of the Accounting System Settings form ().
|
| Unassigned Receipts
|
This column displays the amount of any unassigned receipts. An unassigned receipt is a cash receipt posted to an invoice for which there is no record in
DPS. An invoice number is required if you enter a cash receipt, but the receipt is considered unassigned if there is no corresponding invoice record in
DPS.
|
| Invoice Comment
|
This column displays the text of invoice comments.
|
| Project Currency Code
|
This column displays the three-character code for the project currency.
|
| Billing Currency Code
|
This column displays the three-character code for the billing currency.
|
| Functional Currency Code
|
This column displays the three-character code for the functional currency.
|
| Due To/From Project, Phase, Task
|
If your enterprise uses Intercompany Billing with detailed subledgers enabled, the following columns are also available:
- Due To/From Project
- Due To/From Phase
- Due To/From Task
These columns display the associated project, phase, and task in the company for which you performed the work and that you billed using Intercompany Billing.
|
