Columns for Invoice Register Report

You can select the columns to display on your report.

Contents

Field	Description
Billing Currency Code	This column displays the three-character code for the billing currency.
Consultant	This user-defined column displays the total consultant amount for the invoice. You can modify this heading in Settings > Billing > Accounts Receivable.
Due To/From Project, Phase, Task	If you use 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.
Fees	This user-defined column displays the total fee amount for the invoice. You can modify this heading in Settings > Billing > Accounts Receivable.
Functional Currency Code	This column displays the three-character code for the functional currency.
Interest	This user-defined column displays the amount of interest posted for past due invoice amounts. You can modify this heading in Settings > Billing > Accounts Receivable.
Invoice	This column displays the invoice number. If you drill down on the invoice number, a drill-down report displays that shows all relevant accounts receivable entries against the invoice, including receipts, fees, reimbursable expenses, taxes, and interest.
Invoice Date	This column displays the invoice date.
Net	This column displays the net amount of the invoice.
Other	This column displays the sum of the following: Amounts for the invoice or receipt that were posted an account other than those mapped to the user-defined columns in Settings > Billing > Accounts Receivable. Amounts for the invoice or receipt that were posted to an account that is mapped to a user-defined column in Settings > Billing > Accounts Receivable that is not currently included on the report.
Phase	This column displays the phase number to which the invoice amounts were charged.
Project	This column displays the project number to which the invoice amounts were charged.
Project Currency Code	This column displays the three-character code for the project currency.
Reimb.	This user-defined column displays the total reimbursable amount for the invoice. You can modify this heading in Settings > Billing > Accounts Receivable.
Retainer	This user-defined column displays the total retainer amount for the invoice. You can modify this heading in Settings > Billing > Accounts Receivable.
Row Count	This column displays the row number of a line item.
Task	This column displays the task number to which the invoice amounts were charged.
Taxes	This user-defined column displays the total tax amount that is outstanding for the invoice or credited on a credit memo. This column displays only outstanding amounts, not all taxes billed. You can modify this heading in Settings > Billing > Accounts Receivable.
Total	This column displays the total amount of the invoice and the total amount of each receipt for that invoice. The total amount is calculated by adding the amounts from the user-defined columns (Fees, Reimb., Consultant, Taxes, Interest, and Retainer) and the Other column.