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.
Attention: To ensure the accuracy of receipt information in this report, you should always transfer data to your general ledger in Detail format.
Use either the Submit Request or the Print Accounting Reports window to submit this report.
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:
Doc Seq Name and Number: This option groups your transactions by the unique identifier Sequence Name and Document Number. For each Document Name/Number, Oracle Receivables calculates a total.
Trx GL Date: This option groups transactions by their GL date. Oracle Receivables prints a total for each GL Date.
Receivables prints all Report Parameters/Parameter ranges and the values selected from the above list as report header 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.
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 the currency in which it was entered.
Accounted Dr/Cr: The debit/credit amount of the journal entry line in your functional currency.