The following are report parameters common to many Payables reports:
Accounting Period. Accounting period for which you want to submit the request.
Batch. Name of invoice for which you want to submit the request. Payables displays N/A if you do not use invoice batches to enter invoices.
Currency. Currency of the invoice or payment.
Functional. Payables lists each amount converted into the currency you use for your ledger.
Original. Payables lists each amount in the currency in which you entered it.
Entered By. Name of the person who entered the data.
From/To Payment Date. Enter the first and last dates in a range for which you want Payables to submit the request.
From/To Date. Enter the date range for which you want to submit the request.
From/To Invoice Date. Enter the first and last invoice dates in a range for which you want Payables to submit the request.
From/To Period. Enter the period range for which you want to submit the request.
Functional Amount. Amount of the invoice or payment in your ledger currency. Your ledger currency is the currency you choose for your ledger. Payables uses the exchange rate to convert the invoice or payment into your ledger currency.
Income Tax Type. The income tax type for an invoice distribution. For U.S. reporting, your income tax type is also known as your 1099 type.
Invoice Amount. Original amount of the invoice.
Invoice Batch. The name of the batch in which the invoice was entered, if you have enabled the Allow Invoice Batches Payables option.
Invoice Number. Number of an invoice, assigned by you during invoice entry.
Invoice Type. Type of invoice (Standard, Prepayment, Credit Memo, Debit Memo, Interest, Mixed, Withholding Tax, and Expense Report).
Minimum Invoice Amount. Enter the minimum invoice amount you want to include in the report. The report will not include invoices below the minimum invoice amount you enter here.
Order By. Select from the list of values the criteria by which you want Payables to sort report output. For example, if Supplier Name is an option and you select it, Payables will sort the report alphabetically by supplier name.
Operating Unit. If you are using the multiple organization feature, select an operating unit from the list of values.
Note: The profile option MO: Operating Unit determines the operating units available for your responsibility.
Payment Batch. Payment batch in which the payment was created.
Payment Date. Date on payment document.
Payment Number. Document number for the payment. For example, check number.
Reporting Context: If you entered Ledger for the Reporting Level, the default is the ledger associated with your responsibility. If you entered Legal Entity for the Reporting Level, select a legal entity from the list of values. The profile option MO: Top Reporting Level determines which legal entities appear in the list of values. If this profile option is set to Ledger, you can choose any legal entity that posts to your ledger. If the profile option is set to Legal Entity, you can choose only the legal entity associated with the operating unit assigned to your responsibility.
If you entered Operating Unit for the Reporting Level parameter, select an operating unit from the list of values. The profile option MO: Top Reporting Level determines which operating units appear in the list of values. If the profile option is set to Ledger, you can choose any operating unit that posts to your ledger. If the profile option is set to Legal Entity, you can choose any operating unit within the legal entity associated with the operating unit assigned to your responsibility. If the profile is set to Operating Unit, you can select only the operating unit assigned to your responsibility.
Note: The profile option MO: Operating Unit determines the operating unit for your responsibility.
Reporting Level: Enter the reporting level for the report. Choose Ledger, Legal Entity, or Operating Unit. If you use Multiple Organization Support, the default is Operating Unit. If you do not use Multiple Organization Support, the default is Ledger.
Note: The profile option MO: Top Reporting Level determines the top reporting level for your responsibility.
Ledger Currency. Currency you want to use for the report output. The list of values for this parameter varies depending on the Reporting Level and Reporting Context parameter values. If your Reporting Level is Ledger, you can display the report only in your ledger currency. If the Reporting Level is Legal Entity or Operating Unit, the available values for this parameter are the reporting currencies of the ledger associated with the legal entity or operating unit selected in the Reporting Context parameter.
Site. Name of supplier site.
Supplier Name. Supplier name. For some reports you can leave this field blank to submit the request for all suppliers.
Supplier Number From/To: Enter the range of supplier numbers for which you want to submit the request. Payables includes all suppliers with numbers between and including the supplier numbers you enter.
Supplier Number. Supplier number.
Supplier Type. Type of supplier. You define supplier types in the Oracle Payables Lookups window, and enter a supplier type for a supplier in the Suppliers window.