Use the Adjustment Register report to review approved adjustments that affect transaction balances for the selected period.
Adjustments include manual adjustments, automatic adjustments, bills receivable endorsements, invoices applied to commitments, and credit memos applied to commitment-related invoices. This report groups and displays transactions by currency, postable status, document sequence name, and balancing segment.
The Adjustment Register also includes reductions to guarantees and deposits, although these reductions do not affect the commitment balance.
When reconciling, the Adjustment Register's total should match the Adjustments Journal.
The Adjustment Register report is an RXi report with a default attribute set and three other available attribute sets: Customer, Document Number, and Invoice Number. The attribute set determines how information is ordered and what information is included in the report. You can copy any of the attribute sets and customize the layout to suit your reporting needs.
See: Working with Attribute Sets and Using the RXi Reports Concurrent Program.
Enter parameters to define the content of the report.
For more information, see: Common Report Parameters.
Note: See also: Common Report Parameters for Reconciliation Reports.
Company: Receivables displays the company segment for this group of transactions. Receivables groups and displays transactions by company, currency, and postable status.
Currency: The currency code for this group of transactions. Receivables groups and displays transactions by company, currency, and postable status.
D/I: The letter D next to a transaction indicates that it is adjusted by a deposit; I indicates the transaction is a guarantee adjusted by an invoice. Receivables does not display anything if this transaction is adjusted by a receivables adjustment.
GL Date: (Date) to (Date): The general ledger date range you selected as your reporting option.
Invoice Date: (Date) to (Date): The invoice date range you selected as your reporting option.
Postable: The post to general ledger status for this group of transactions. Receivables groups and displays transactions by company, currency, and postable status.
Adjustment Number: The transaction number of this adjustment.
Class: Receivables displays Finance or Adjustment if this transaction is not against a commitment. If an invoice has been applied to a guarantee, Receivables displays Guarantee because the adjustment is made against the guarantee. If an invoice has been applied to a deposit, Receivables displays Invoice because the adjustment is made against the invoice.
Customer Name: Receivables displays the name of the customer for this transaction. If this adjustment is against a deposit, Receivables displays the customer name of the invoice.
Customer Number: The customer's number.
Document Number: The document sequence number for the adjustment. This column appears only if you submitted the report using the Document Number attribute set.
Due Date: The due date for this transaction. If this adjustment is against a deposit, Receivables displays the due date of the invoice.
Functional Currency: The total adjustment amount for this transaction in the functional currency.
Entered Currency: The total adjustment amount for this transaction in the entered currency.
Invoice Date: The invoice date for this transaction. If this adjustment is against a deposit, Receivables displays the invoice date of the invoice.
Invoice Number: The invoice number of the adjusted transaction. If this adjustment is against a deposit, Receivables displays the invoice number of the invoice.
Invoice Type: The transaction type of the adjusted transaction. If this is an adjustment against a deposit, Receivables displays the transaction type of the invoice.
Adjustment Type: For example, Freight, Tax, or Invoice adjustment.