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.
This report may include user-defined columns. You specify headings for those columns on the Ledger Headings tab of the Accounts Receivable Configuration form. You map invoice accounts and accounts receivable accounts on the Invoice Mapping Accounts tab and the AR Mapping Accounts tab of the same form.
Contents
| Field | Description |
|---|
| Invoice
|
This column displays the invoice number. The word
Receipt displays in this column for receipts.
|
| Mod/Receipt Description
|
If the report row is for a receipt, the reference number entered during Cash Receipt transaction entry displays in this column. If you select
Print Modification Detail on the General tab, this column also displays the invoice number, the year and month, and the number of postings for the accounting period for which you generate the report.
|
| Invoice Date
|
This column displays the invoice date or the receipt date.
|
| 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.
|
| 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 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 contains any amount for an invoice or receipt that was posted to an account other than those mapped to the user-defined columns described above.
|
| Description 1
|
If you select
Print Invoice Detail on the General tab, this column displays invoice comments.
|
| Description 2
|
If you select
Print Invoice Detail on the General tab, this column displays cash receipt 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 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.
|
