Previous  Next          Contents  Index  Navigation  Glossary  Library

Journal with GL Details Report

Use this report to identify the General Ledger journal entries imported from particular transactions in Payables. Transactions that have not been transferred to General Ledger are marked with an indicator. You can list your transactions either sorted and grouped by Document Sequence Number or the GL Date of the Transactions.

Report Submission

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

Selected Report Parameters

Trx GL Date From/To. Beginning and end date for the transaction GL dates to include in this report.

Supplier Name From/To. 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.

Sequence Name. If you use sequential voucher numbers and you want to limit the report to one sequence name, enter the sequence name.

Voucher Number From/To. If you use sequential voucher numbers and you want to submit the report for a range of voucher numbers, enter the voucher number range.

Sort Order. Select the order in which you want the report data printed.

Selected Report Headings

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.

Account. 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.

Column 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