Previous  Next          Contents  Index  Navigation  Glossary  Library

Transaction Reconciliation Report

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

This report totals the debits and credits for each transaction, customer, and customer site.

Use either the Submit Request or the Print Accounting Reports window to submit this report.

Report Parameters

When you request this report, Receivables provides the following reporting options.

Trx GL Date From/To: Enter the range of GL Dates for this report. Receivables prints transactions whose GL dates are within this range.

Customer Name From/To: Enter the customer or range of customers whose transactions you want to print, or select from QuickPick.

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

Trx Date From/To: Enter a range of transaction dates to include in this report. Receivables prints transactions whose dates are within this range. Leave this field blank to submit the report for all transaction dates.

Report Headings (Oracle Receivables Information)

Trx GL Date: The GL date of the subledger transaction.

Trx Doc Seq Name: If you are using document sequencing, Receivables prints the name of the document sequence used for the transaction.

Trx Doc Seq No: If you are using document sequencing, Receivables prints the document number.

Associated Trx: The number of the transaction associated with the original transaction. For example, for a receipt applied to an invoice, Receivables prints the invoice number.

Customer Name/Customer Address: The customer's name and address.

Trx Date: The date of the transaction. This can be the invoice date, receipt date, or credit memo date.

Transaction: The transaction type.

Trx Number: The transaction number.

LN: If there are line numbers for transactions (for example, invoice lines), Receivables prints the invoice line number. This column is empty for transactions without line numbers (for example, receipts).

Accounting Flexfield: The account to which this transaction line was charged.

Rate: The exchange rate used for the transaction.

Cur: The currency used for this transaction.

Entered Dr/Cr: The invoice or receipt line amount in the currency in which it was entered.

Accounted Dr/Cr: The invoice or receipt line amount in your functional currency.

Column Headings (Oracle General Ledger Information)

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

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

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

GL Date: The general ledger date of the journal entry line.

Description: The description of the Journal Entry line.

GL Doc Seq: The sequence name of the journal entry, if you use sequential numbering.

Doc Seq No: The document number of the journal entry, if you use sequential numbering.

Entered Dr/Cr: The credit/debit amount of the journal entry line in the currency of the original transaction.

Accounted Dr/Cr: The debit/credit amount of the journal entry line in the functional currency.

         Previous  Next          Contents  Index  Navigation  Glossary  Library