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

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

Report Parameters

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

Customer Name From/To: Enter a customer or a range of customers to include in this report, or select from QuickPick. Leave this field blank to submit this report for all customers.

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

Document Number From/To: If you use sequential document numbers and you want to print a range of documents, enter the range of document sequence numbers.

Sort Order: Enter the method you want to use to sort the information in your report. Select from the following:

Report Headings

Receivables prints all Report Parameters/Parameter ranges and the values selected from the above list as report header information.

Column Headings (Receivables Information)

Trx GL Date: The GL date of the invoice or receipt distribution.

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

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

Associated Trx: The invoice or receipt number of any associated transactions. For example, if this transaction was a receipt application, Receivables prints the invoice number (the receipt is printed as the Transaction Number).

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

Trx Date: The invoice date of the invoice distribution, or receipt date of the receipt distribution.

Transaction: The transaction type. For example, invoice, debit memo, credit memo, chargeback, or adjustment.

Trx Number: The invoice number for an invoice distribution, or receipt document number for a receipt distribution.

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

Accounting Flexfield: The account to which this distribution was charged.

Rate: The exchange rate used for the transaction.

Cur: The currency for this transaction.

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

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

Column Headings (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 document numbers.

Doc Seq No: If you use sequential document numbers, Receivables prints the document sequence number of the journal entry.

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

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

         Previous  Next          Contents  Index  Navigation  Glossary  Library