Payment Distribution Report (Oracle Payables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Payment Distribution Report

You can submit this report after you create a payment batch, manual payment, or Quick payment to verify the payment distributions created by Payables when you pay an invoice. If Payables cannot create a payment distribution because of an invalid account, the report lists this payment as an exception. You cannot post a payment until you manually correct the distribution's account in the Invalid GL Accounts window.

The report displays payment, supplier, invoice, payment distribution, and liability accounting information for a bank account you select. The report also displays the total number of payment documents and the total payment amount. The report orders the information by bank account, payment document name, and document number.

Report Submission

You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.

In addition, if you submit AutoRate, Payables automatically prints this report. See: AutoRate Program.

Selected Report Parameters

Bank Account Name. Enter the name of a bank account for the payment distributions you want to review in this report, or leave the field blank to submit the report for the payment distributions for all bank accounts.

Payment Document Name. Enter the name of the payment document for the payment distributions you want to include in this report, or leave the field blank to submit the report for all payment documents. If you entered a name in the Bank Account Name parameter and you leave this field blank, Payables includes the payment distributions for all payment documents for the bank account you specified.

Begin/End Document Number. The report includes payment documents with document numbers including and between the Begin Document Number and the End Document Number.

Selected Report Headings

Payment Document. Name of the payment document for your bank account. If you define more than one payment document for a bank account, Payables displays each payment document of the bank account on a separate page.

Payment Currency. Payment currency for your payment document. The payment currency could differ from the bank account currency only if the bank account is a multiple currency bank account.

Document Number. Number of a payment. For example, check number.

Void. The report displays Yes if a payment is void and leaves the column blank if a payment is not void.

Gross Amount. Original scheduled payment amount of an invoice. This amount equals the sum of the distributions of an invoice. The invoice Gross Amount minus the invoice Discount Amount equals the Payment Amount.

Discount Amount. Discount amount taken on an invoice. Payables calculates the discount amount using the Payment Terms you entered during invoice entry.

Payment Amount. Amount of a payment. Payables calculates the Payment Amount for the payment by subtracting the Discount Amount from the Gross Amount.

Line. Line number of a payment distribution.

Line Type. Line type of a payment distribution. The payment distribution type indicates the type of Asset account credited for the payment distribution. The possible line types are:

Cash. Payables credits a Cash account for the amount of the payment distribution.

Discount. Payables credits a Discount account for the amount of the payment discount distribution. You can use the Discount Distribution Payables option to determine how you want to distribute discounts you take.

Gain. Payables credits a Realized Gain account if you realized an exchange rate gain on this payment. Payables debits a Realized Loss account if you realized an exchange rate loss on this payment. Payables uses the Realized Gain or Loss account from the bank account used to make the payment.

Distribution Account. If you enable the Automatic Offsets Payables option and pay an invoice from a pooled bank account, Payables creates a corresponding payment distribution for each liability distribution using the Automatic Offset Method you choose in the Payables Options window. If you enable Automatic Offsets and pay an invoice from an unpooled bank account or if you do not enable Automatic Offsets, Payables creates a payment distribution for each liability distribution, using the Asset account of the bank account.

Liability Account. Liability account used to create a payment distribution. If you enable Automatic Offsets and pay an invoice from a pooled bank account, Payables creates a liability distribution for each invoice distribution using the Automatic Offsets Method you choose in the Payables Options window. If you do not enable Automatic Offsets, Payables creates a liability distribution for each invoice distribution using the AP Liability account of the invoice.

Amount. Amount of a payment distribution distributed to a Cash, Discount, Realized Gain, or Realized Loss account.

Payment Distribution Report

Report Submission

Selected Report Parameters

Selected Report Headings

See Also