Columns for AR Ledger 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.
Description 1	If you select Include Invoice Detail on the Options tab of the report settings, this column displays invoice comments.
Description 2	If you select Include Invoice Detail on the Options tab of the report settings, this column displays cash receipt comments.
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. The word Receipt displays in this column for receipts.
Invoice Date	This column displays the invoice date or the receipt date.
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 Include Modification Detail on the Options tab of the report settings, 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.
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 in Settings > Billing > Accounts Receivable.
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.
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.