Previous  Next          Contents  Index  Navigation  Glossary  Library

Transaction Reconciliation Report

Use this report to identify the General Ledger journal entry lines imported from particular transactions in Payables. Transactions that have not been transferred to General Ledger are marked with an indicator.

This report is sorted by supplier, supplier site, and transaction number.

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

Selected Report Parameters

Trx GL Date From/To. Enter a beginning and end dates for the invoice and payment GL dates to include in this report.

Supplier Name From/To. Enter a supplier or a range of suppliers for which you want to submit the report. Leave this field blank to submit this report for all suppliers.

Trx Number From/To. Enter the transaction number (invoice number or payment number), or range of transaction numbers for which you want to submit the report. Leave the field blank to submit this report for all transactions.

Trx Date From/To. Enter a transaction date (invoice date or payment date), or range of transaction dates for which you want to submit the report. Leave the field blank to submit this report for all transaction dates.

Report Headings (Payables Information)

Trx GL Date. GL Date of the invoice or payment distribution.

Trx Doc Seq Name. Name of the document sequence if you assigned a sequential voucher number to the invoice or payment.

Trx Doc Seq No. Payables prints the voucher number if you use sequential voucher numbers.

Associated Trx. Invoice or payment number of any associated transactions. For example, for a payment distribution, Payables prints the number of the invoice that it paid.

Trx Date. Invoice date of the invoice distribution, or payment date of the payment distribution.

Transaction. Transaction type.

Trx Number. Invoice number for an invoice distribution, or payment document number for a payment distribution.

LN. If this is an invoice distribution, Payables prints the distribution line number.

Accounting Flexfield. Account to which this distribution was charged.

Rate. Exchange rate used for the transaction.

Cur. Currency used for the transaction.

Entered Dr/Cr. Invoice or payment distribution amount in the currency in which it was entered.

Accounted Dr/Cr. Invoice or payment distribution amount in your functional currency.

Report Headings (Oracle General Ledger Information)

GL Batch Name. Name of the general ledger journal batch to which this transaction was transferred.

Header Name. Name of the general ledger journal entry to which this transaction was transferred.

LN. Line number of the general ledger journal entry line to which this transaction was transferred.

GL Date. General ledger date of the journal entry line.

Description. Description of the Journal Entry line.

GL Doc Seq. Payables prints the sequence name of the journal entry, if you use sequential voucher numbers.

Doc Seq No. Payables prints the document voucher number of the journal entry, if you use sequential voucher numbers.

Entered Dr/Cr. Credit/debit amount of the journal entry line in the functional currency.

Accounted Dr/Cr. Debit/credit amount of the journal entry line in the functional currency.

         Previous  Next          Contents  Index  Navigation  Glossary  Library