AR Adjustments to SLA Link R12

Accounting Data Model – Adjustments

•Where postable <> ‘N’

•Status should be ‘A’

•Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=ADJ)

•Debit & credit amounts should match

•Adjustments Status = ‘W’ (Waiting for Approval) to either A or R

•Adjustments with status R (Reject) should not be processed i.e. EVENT_STATUS_CODE=N

•PROCESS_STATUS_CODE=U in XLA_EVENTS

AR_ADJUSTMENTS table
Important columns in the AR_ADJUSTMENTS table include:

ADJUSTMENT_ID column

AMOUNT column

CUSTOMER_TRX_ID column

TYPE column

PAYMENT_SCHEDULE_ID column

CODE_COMBINATION_ID column

The AR_ADJUSTMENTS table stores information about invoice adjustments. Each adjustment is stored as a unique record, based on the primary key adjustment_id. The amount column stores the amount of the adjustment. Receivables uses the customer_trx_id and payment_schedule_id to link the adjustment to the adjusted transaction and to update the amount_due_remaining and amount_adjusted columns of the adjusted transaction payment schedule in the AR_PAYMENT_SCHEDULES table.

The type column stores a description of the transaction to which the adjustment applies. Valid types include:

Charges Adjustments

Freight Adjustments

Invoice Adjustments

Line Adjustments

Tax Adjustments

The code_combination_id column stores the accounting distribution associated with the adjustment transaction.