A/R History Report

You will not be able to limit the level of the projects printed on the report unless you are selecting "Project" as your selection range. If you select any other criteria such as "Customer Name," "Account," "Project Type," etc., all projects associated with the customers, accounts, or project types within the selected range will be included.

Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen.

When you save your record, all the selections you made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously-defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.

Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.

Use this drop-down box to select the option by which you want the report grouped. Options are "Customer Account," "Project," "Customer Type," "Project Type," "Account," "Organization," "Customer Name," and "Project Manager."

For example, if you select "Customer Name," all invoices followed by their cash receipts will be grouped for each customer name.

Enter, or use the drop-down box to select, the range of information you want to see on the report. Options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."

Enter, or use Lookup to select, the starting value for the range you want to include. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.

Enter, or use Lookup to select, the ending value for the range you want to include. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.

Use this drop-down box to select the range to include on this report. Options are "All," "One," "Range," "From Beginning," and "To End."

Only invoices that were entered or computed and subsequently posted within the range of the Fiscal Year/Period/Subperiod selected will be included in the report. In addition, only cash receipts that you entered and subsequently posted within the selected Fiscal Year/Period/Subperiod will be included in the report.

The default for this field is "All."

Enter the fiscal year to be included in the report or select a fiscal year from Lookup.

If you select "All" or "From Beginning" in the  Option field, this field will be unavailable.

Enter the period to be included in the report or select a period from Lookup.

If you select "All" or "From Beginning" in the Option field, this field will be unavailable.

Enter the subperiod to be included in the report or select a subperiod from Lookup.

If you select "All" or "From Beginning" in the Option field, this field will be unavailable.

This non-editable field displays the subperiod ending date.

Enter, or use Lookup to select, the correct fiscal year for this report.

If you select "All," "One," or "To End" in the Option field, this field will be unavailable.

Enter, or use Lookup to select the correct fiscal period for this report.

If you select "All," "One," or "To End" in the Option field, this field will be unavailable.

Enter, or use Lookup to select the correct fiscal subperiod for this report.

If you select "All," "One," or "To End" in the Option field, this field will be unavailable.

This field displays the subperiod ending date and is not editable.

Make a selection from this drop-down box. Your  choices are "Invoice Number" or "None."

"Invoice Number" is selected by default. If you select "None," no invoice detail or invoice amounts will print on the report.

Use the drop-down box to select the range of invoice numbers to include on this report.

Options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."

Enter the first invoice number to be included in the report.

If you select "All" or "From Beginning" in the Option field, this field will be unavailable.

Enter the last invoice number to be included in the report.

If you select "All," "One," or "To End" in the Option field, this field will be unavailable.

Make a selection from the drop-down box.  Choices are "Receipt Number" or "None." "Receipt Number" is selected by default. If you select "None," no cash receipt detail or receipt amounts will print on the report.

Use the drop-down box to select the range of cash receipts to include on this report.

Options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."

Enter the first cash receipt number to be included in the report. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.

Enter the last cash receipt number to be included in the report. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.

This field is available only if you select "Account" or "Organization" in the Select By - Grouping drop-down box.

Enter the account level at which you want the report printed; all lower levels will be rolled up for the report. The larger the level number, the more detailed the report; the smaller the number, the less detailed. To see all levels of detail, enter zero.

Make sure that the account level you enter is not higher than the level for the Accounts Receivable accounts that you want to include on the report. For example, if your billed A/R account is 01100-010, 01100-020, and 01200, and you enter account level 3 and below, you will not have any invoices or cash receipts posted against these A/R accounts.

If you enter account level 1 and below, you will have invoice details grouped by Accounts Receivable account 01100 and 01200.

If you select account level zero and below, you will see invoice and cash receipt detail grouped by each Accounts Receivable account.

This field is available only if you select "Account" or "Organization" in the Select By - Grouping drop-down box.

Enter the organization level at which you want the report printed; all lower levels will be rolled up for the report. The larger the level number, the more detailed the report; the smaller the number, the less detailed.

Make sure that the organization level you enter is not higher than the level of the organization to which your Accounts Receivable was posted. For example, if you want to include customer invoices from projects with owning orgs of 1.1.2.3, 1.1, and 1.2, you must select an org level of 2 or below to include all invoices and/or associated posted cash receipts.

If you choose to select an org level of 4 and below, the invoices and cash receipts posted to org 1.1 and 1.2 will be excluded.

Entering an org level of 2 or below will sum invoices and cash receipts by org 1.1 and 1.2.

Entering an org level of 0 and below, will group posted invoices and cash receipts by each Accounts Receivable organization.

This field is available only if you select "Project" in the Select By - Grouping drop-down box.

Enter the project level at which you need the report printed; all lower levels will be rolled up for the report. To see all levels of detail, enter zero.

Make sure that the project level you enter is not higher than the level of the project to which the invoices were posted.

For example, if you want to include a project whose billing formula is at the third level, then you would need to print the report at 0, 1, 2, or 3 and below to include this project.

Select this checkbox to exclude progress payments on the report.

You may want to exclude your progress payment bills on this report if you have unselected the 1443 Postings - Progress Bills to GL When Billed checkbox in the Billing Settings screen.

Unselecting this checkbox in the Billing Settings screen means that when you post a progress payment bill, the A/R and billing history tables will be updated but nothing will post to the GL until the cash receipt paying the invoice is posted.

Select this checkbox to include finance charges on the report.

This checkbox is selected by default.

In order to apply finance charges to a customer, the Apply Finance Charges checkbox for that customer must be selected in the Credit Info tab of the Customers screen (Accounting\Maintain\Customers). In the Credit Info tab you can also specify the number of grace days and the interest percentage to assess. The finance charges will print on the report in detail by invoice number and are stored in the AR_FIN_CHARGE table.

The finance charges will not post to the General Ledger until the cash is received for the finance charges.

Enter, or use Lookup to select, a valid currency code. The default is "USD."

Only those invoices and cash receipts using the transaction currency code selected will be included on the report.

This checkbox is unavailable if the billing currency and functional currency are the same.

Select this checkbox to see the invoices and cash receipts in your company's functional currency and in the billing currency.

This non-editable field displays the grouping you chose in the Select By-Grouping drop-down box.

Use this drop-down box to select how you wish to sort the Finance Charge Receipts Supplemental Report. Valid options are: "Project," "Account," and "Organization."

This report will print after the AR History Report and will display any cash receipts against finance charges based on the secondary sort.

Select this checkbox to insert a page break after each sort group selected.