Adjustments
You can create adjustments to increase or decrease invoice balances. You can make adjustments to invoices, lines, tax or freight. Receivables uses the following tables to store your adjustment information:
For example, adjust invoice number I-104 to write off the remaining balance of 2400.
This transaction is represented as follows:
adjustment_
id
| amount
| customer
_trx_id
| type
| payment_
schedule_id
| code_
combination_id
|
987654
| -2400
| 899143
| INVOICE
| 646566
| 01-5100-3000-1000
|
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.
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
|
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
Chargebacks
About Adjustments