Invoice Register Columns Tab

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.

Contents

Field	Description
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.
Project	This column displays the project number to which the invoice amounts are charged.
Phase	This column displays the phase number to which the invoice amounts are charged.
Task	This column displays the task number to which the invoice amounts are charged.
Invoice Date	This column displays the invoice date.
User-defined columns	On the Accounts Receivable Configuration form, you can define a set of columns for this report. For example, you could set up columns for fees billed, reimbursable expenses billed, taxes billed, interest, and retainers. You specify the headings for these columns on the Ledger Headings tab of the Accounts Receivable Configuration form. You map the columns to invoice accounts and accounts receivable accounts on the Invoice Mapping Accounts tab and the AR Mapping Accounts tab. You can select any or all of these columns from the list on the Columns tab of the Options dialog box for this report.
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 described above. Amounts for the invoice or receipt that were posted to an account that is mapped to a user-defined column that is not currently included on the report.
Total	This column displays the total amount of the invoice and the total amount of each receipt for that invoice. The total is then distributed to the user-defined columns and to the Other column. The total of the amounts in user-defined columns and Other should equal the amount in the Total column.
Retainage	This column displays the amount of retainage for the invoice. This column is available only if Enable Retainage is selected on the General tab of the Accounting System Settings form (Settings > Advanced Accounting > System).
Row Count	This column displays the total number of detail lines for each group, based on the sorting and grouping selections on the Sorting/Grouping tab. If the report groups data at more than one level, this column displays row counts for all grouping levels.
Net	This column displays the net amount of the invoice.
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 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.