Previous	Next		Contents	Index	Navigation	Glossary	Library

Account Status: Receivables selects and prints information between the low and high values you specify for your Account Status range.

Adjust Amount in Foreign Currency: Receivables prints the adjustment amount for each invoice, debit memo, and chargeback in the currency that the debit item was entered. The adjustment amount is determined by the remaining amount range or remaining percent range you specify in the AutoAdjustment window.

Approval Limits: (AutoAdjustment parameter) Receivables prints the adjustment approval limits for the person who submits your AutoAdjustment process.

As Of Date: Receivables selects and prints your report information from the as of date you specify. Receivables prints all open items whose GL date is less than or equal to the As Of Date you specify. The As Of Date defaults to the system date. You can choose this date or enter another.

Balance Due: Receivables selects and prints transactions from the balance due range you specify.

Base Due Date on Trx Date: Use this parameter to indicate whether you want AutoInvoice to calculate invoice due dates based on transaction dates or based on either the ship date, sales order date or rule start date. The default for this parameter is Yes, which will prompt AutoInvoice to use the transaction date to calculate due dates for your invoices.

If you elect to change the value to No, AutoInvoice will calculate due dates using the following algorithm:

AutoInvoice will first compare the ship date in the interface table to the transaction date plus the number of days you enter in the Due Date Adjusted Days parameter. If the ship date does not exist, AutoInvoice will use the sales order date or rule start date to compare to the transaction date plus the number of days in the Due Date Adjusted Days parameter.

AutoInvoice will then set the due date equal to whichever date is greater. For example:

Due Date				Terms = Net 30
Trx Date	Ship Date	Base Due Date on Trx Date	Due Date Adjusted Days	Calculated Due Date
15-Sep-94	20-Sep-94	Yes	Null	15-Oct-94
15-Sep-94	20-Sep-94	No	0	20-Oct-94
15-Sep-94	20-Sep-94	No	10	25-Oct-94
15-Sep-94	15-Sep-94	No	-10	15-Oct-94
Table 1 - 173. (Table 1 of 1)

Currency: A currency code. If you do not enter a code, Receivables displays all of your items converted to your functional currency. If you choose a specific currency, then Receivables only displays items in that currency in this report. Receivables displays the currency you select at the top of each page of this report.

Collector: Receivables selects and prints information between the low and high values you specify for your Collector range.

Customer Name: Receivables selects and prints information between the low and high values you specify for your customer name range.

Customer Number: Receivables selects and prints information between the low and high values you specify for your customer number range.

Days Late: Receivables selects and prints information between the low value and high value you specify for your days late range. If you enter a negative number for one or both of these values, Oracle Receivables prints information about invoices that are not late.

Due Date Adjusted Days: This AutoInvoice parameter can only be used if the Base Due Date on Trx Date parameter is set to No and will only accept integers between the range of -9999 and 9999. Use this parameter to adjust your invoice due date calculations.

GL Date: The invoice general ledger date range you want to include in this report. Receivables prints all transactions based on the general ledger date range you enter here.

Invoice Number: The transaction number range to include in the report.

Invoice Type: Receivables selects and prints your report information for the transaction type range you specify.

Order By: The option you want Receivables to use to sort your information. For example, you can sort by:

• Collector

• Currency Code

• Customer Name

• Customer Number

• Range of Dates

• Transaction Type

• Alternate Name

Note: If the profile option AR: Sort Customer Reports by Alternate Fields is Yes and you choose to sort information by Customer Name, Receivables sorts information according to the value you enter in the Alternate Name field of the Customers window. Otherwise, Receivables sorts information according to the Customer Name field.

See Also

Running Standard Reports and Listings

Receivables Standard Reports and Listings

Accounting Reports

Collection Reports

Listing Reports

Tax Reports

Other Reports