Previous	Next		Contents	Index	Navigation	Glossary	Library

Transaction Register (postable items) + 2 (Credit Memo Total) = Sales Journal (debits + credits)

You also use the Transaction Register when you balance your revenue accounts to your accounts receivable aging. Use the following formula to ensure that your revenue accounts match your accounts receivable:

This month's aging = Last month's aging + Transaction Register - Adjustment Register total - Invoice Exception Report total - Payments

You must use the Invoice Exception Report to adjust the Transaction Register for any transactions that do not show up on your agings. You also must use the Adjustment Register to adjust for amounts applied to commitments since the Transaction Register displays both the commitment amount and the applied amount and the agings only show the commitment amount.

Report Parameters

Currency Code: The currency code range to include in this report.

GL Date: The invoice general ledger date range to include in this report. Receivables prints all transactions based on the general ledger date range you enter here.

Invoice Type: The transaction type range to include in this report.

Order By: Select the option you want Receivables to use to sort your information from the following:

• Customer: Sort information by the invoice type, then by customer.

• Alternate Name: Sort customers according to the value you entered in the Alternate Name field of the Customers window. (Oracle Receivables only displays this option if the profile option AR: Sort Customer Reports by Alternate Fields is Yes.)

• Invoice Number: Sort information by the invoice type, then by invoice number.

Transaction Type: The transaction type range to include in this report.

Report Headings

Currency: The currency code for this group of transactions.

GL Date From (Date) to (Date): The range of general ledger dates you selected to print on this report.

Invoice Date From (Date) to (Date): The range of invoice dates you selected to print on this report.

Postable: The post to general ledger status for this group of transactions.

See Also

Common Report Parameters

Receivables Standard Reports