The following report parameters are common to many Receivables reports:

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 that you specify. Receivables prints all open items with a GL date that 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 default date.

The default for this parameter is Yes, which prompts AutoInvoice to use the transaction dates as the due dates for your invoices.

If you change the value to No, then AutoInvoice looks at the setting of the Derive Date option on a transaction's batch source to determine the due date. Depending on the Derive Date setting, AutoInvoice derives the due date in a different way. See: Importing Transactions Using AutoInvoice and Determining Dates.

Additionally, if the value of this parameter is No, then AutoInvoice uses this parameter in conjunction with the Due Date Adjustment Days parameter to determine the final due date.

Currency/Entered 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 entered 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.

If two customers with the same name exist, then Receivables includes both customers on the report. To include a specific customer on a report, use the Customer Number parameter.

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 Adjustment Days: Use this parameter to adjust your invoice due date calculations. You can enter any integer between the range of -9999 and 9999. AutoInvoice uses this parameter only when the Base Due Date on Trx Date parameter is set to No.

When Base Due Date on Trx Date is No, AutoInvoice compares the due date that it derived against the transaction date plus the number of days that you enter here. AutoInvoice uses whichever date is later as the final due date.

The examples in the following table assume a Net 30 payment term:

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.

Low and High parameters: Throughout Receivables reports, certain Low and High parameters, such as Batch Name Low and Batch Name High, accept alphanumeric values. In such cases, Receivables does not compare each number as a whole when determining the range of data to display in the report. Instead, Receivables determines the range by comparing the first digit in each entered parameter value, and then the next digit, and so on. In other words, if the low and high values are 99 and 100, then Receivables perceives 99 as higher than 100, and cannot successfully determine a range to report on.

To resolve this issue, submit reports in separate batches, if necessary. For example, if you entered low and high batch name values, then submit the report for batches 1-999, 1000-1999, and so on.

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 in certain reports according to the value you enter in the Alternate Name field in the Customers window. Otherwise, Receivables sorts information according to the Customer Name field.

  For a list of reports that sort according to a customer's alternate name, refer to the profile option AR: Sort Customer Reports by Alternate Fields in: Overview of Receivables Profile Options.

• Reporting Level: If you use Multiple Organization Support, then specify the level at which you want to run the report.

  • If you choose Ledger, then you can run this report for any ledger that you have access to. Ledger access means that you have access to at least one operating unit assigned to the ledger.

    Use the Reporting Context parameter to select a ledger. The report will run for all operating units that are assigned to the selected ledger, and which you have access to.

    Note: If you have access to only some operating units that are assigned to the selected ledger, then a message will inform you that the report provides only a partial view of the ledger.

  • If you choose Operating Unit, then you can run this report for any operating unit that you have access to, as defined in your security profile.

    Use the Reporting Context parameter to select an operating unit.

  Reporting Context: If you use Multiple Organization Support, then specify the level at which you want to run the report. The list of values for this parameter depends on the Reporting Level that you specified.

  Note: If you are not using the multiple organization support feature then the report ignores the Reporting Level and Reporting Context parameters.

  For more information, see: Oracle E-Business Suite Multiple Organizations Implementation Guide.