Previous	Next		Contents	Index	Navigation	Glossary	Library

• AR_ADJUSTMENTS

• AR_PAYMENT_SCHEDULES

This transaction is represented as follows:

AR_ADJUSTMENTS
adjustment_ id	amount	customer _trx_id	type	payment_ schedule_id	code_ combination_id
987654	-2400	899143	INVOICE	646566	01-5100-3000-1000
Table 1 - 164. (Page 1 of 1)

Receivables inserts a record into AR_ADJUSTMENTS to record adjustment details such as the amount, the type of adjustment, the customer_trx_id and the payment_schedule_id of the invoice you want to adjust. The amount column equals the amount of the adjustment. The code_combination_id column stores the general ledger distribution for the adjustment transaction.

AR_PAYMENT_SCHEDULES
payment _schedule _id	amount _due_ original	amount_ due_ remaining	customer _trx_id	trx_ number	status	amount _applied	class	amount_ adjusted
646566	6400	0	899143	I-104	CL	4000	INV	-2400
Table 1 - 165. (Page 1 of 1)

Receivables updates the payment schedule record of the invoice in AR_PAYMENT_SCHEDULES, by adjusting the amount_due_remaining to zero, changing the status to CL, and changing the amount_adjusted to -2400.

See Also

About Adjustments