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
Important columns in the AR_ADJUSTMENTS table include:
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:
The code_combination_id column stores the accounting distribution associated with the adjustment transaction.