Previous | Next | Contents | Index | Navigation | Glossary | Library |
AR_CASH_RECEIPTS | ||||
credit_receipt_id | amount | status | receipt_number | type |
338700 | 4000 | REV | R-101 | CASH |
Table 1 - 151. (Page 1 of 1) |
AR_CASH_RECEIPT_HISTORY | ||
---|---|---|
cash_receipt_history_id | amount | status |
545352 | 4000 | REVERSED |
Table 1 - 152. (Page 1 of 1) |
A new record, which is not postable, will be inserted into AR_CASH_RECEIPT_HISTORY to record the reverse receipt. Additionally, the current_record_flag of the original cash receipt record will be updated to null, while the reverse_gl_date column of the original receipt record will be set.
AR_PAYMENT_SCHEDULES | ||||||||
---|---|---|---|---|---|---|---|---|
payment_ schedule_ id | amount _due_ original | amount_ due_ remaining | cash_ receipt_id | customer_ trx_id | trx_ number | status | amount_ applied | class |
510555 | -4000 | 0 | 338700 | NULL | R-101 | CL | 0 | PMT |
30191 | 6400 | 6400 | NULL | 101467 | I-101 | OP | 0 | INV |
Table 1 - 153. (Page 1 of 1) |
The payment schedule of the invoice has a class of INV, while the payment schedule of the receipt has a class of PMT. Because the receipt has been reversed, the amount_due_remaining and amount_applied columns are zero and the status column is CL, closed.
Receivables updates the payment schedule record of the invoice to increase the amount_due_remaining by the amount of the reverse receipt. The status is still OP because the entire balance has not been paid. The amount_applied column is zero because no transactions have been applied to the invoice.
AR_RECEIVABLE_APPLICATIONS | |||||||
---|---|---|---|---|---|---|---|
receivable_ application _id | amount_ applied | status | payment_ schedule_ id | code_ combination_ id | cash_ receipt _id | applied_ payment_ schedule_ id | applied_ customer_ trx_id |
408292 | -4000 | APP | 400100 | 01-1200-1100 | 338700 | 30191 | 101467 |
408293 | 4000 | UNAPP | 400100 | 01-1100-1000 | 338700 | NULL | NULL |
408294 | -4000 | UNAPP | 400100 | 01-1100-1000 | 338700 | NULL | NULL |
Table 1 - 154. (Page 1 of 1) |
Receivables inserts three records into AR_RECEIVABLE_APPLICATIONS. The first record, with a status of APP, offsets the original application of the receipt, including a reference to the applied invoice, via the applied_payment_schedule_id and applied_customer_trx_id columns. The second and third records, with a status of UNAPP, offset the original unapplied transactions. The code_combination_id for the APP record is the receivable account associated with the invoice to which this receipt was originally applied. The code_combination_id for the two UNAPP records is the general ledger account associated with unapplied receipts.
Previous | Next | Contents | Index | Navigation | Glossary | Library |