Previous | Next | Contents | Index | Navigation | Glossary | Library |
Credit Memo Number: CM-101
Bill-To: ABC Inc
Credit Memo Date: 01-Jun-94
Credit Memo Amount: -1000
Credit memo number CM-101 would be represented in Receivables tables as follows:
RA_CUSTOMER_TRX | ||||
---|---|---|---|---|
customer_ trx_id | trx_number | bill_to customer_id | trx_date | previous_ customer_ trx_id |
123456 | CM-101 | ABC Inc | 01-Jun-94 | 101467 |
Table 1 - 131. (Page 1 of 1) |
The previous_customer_trx_id column references the original transaction you have credited.
RA_CUSTOMER_TRX_LINES | ||||||
---|---|---|---|---|---|---|
customer_ trx_line_id | customer_ trx_id | link_to_ cust_trx_ line_id | line_type | extended_ amount | previous_ customer_ trx_id | previous_ customer_ trx_line_id |
150 | 123456 | LINE | -926 | 101467 | 100 | |
151 | 123456 | 120 | TAX | -74 | 101467 | 101 |
Table 1 - 132. (Page 1 of 1) |
Based on the example credit memo, Receivables inserts two records into RA_CUSTOMER_TRX_LINES. The total value of the credit memo is prorated between the invoice and tax lines associated with line 1 of the original invoice. The previous_customer_trx_line_id column references the customer_trx_line_id of the original invoice you have credited.
RA_CUST_TRX_LINE_SALESREPS | |||||
---|---|---|---|---|---|
cust_trx_line_ salesrep_id | sales_rep_id | customer_trx _line_id | revenue_ amount_split | non_revenue_ amount_split | prev_cust_trx_line salesrep_id |
150205 | 1492 | 100 | -463 | 0 | 140195 |
150206 | 1525 | 100 | -463 | 0 | 140196 |
150207 | 1492 | 101 | 0 | -37 | 14097 |
150208 | 1525 | 101 | 0 | -37 | 14098 |
Table 1 - 133. (Page 1 of 1) |
Assuming the credit memo only applied to the first line of the invoice, salesperson 1492 and salesperson 1525 will split the loss of the sales credit. The prev_cust_trx_line_salesrep_id column references the original sales credit from the original invoice.
RA_CUST_TRX_LINE_GL_DIST | ||||
---|---|---|---|---|
cust_trx_line_ gl_dist_id | code_combination_id | customer_trx _line_id | account_class | amount |
150160 | 01-1200-1000-3000 | REC | -1000 | |
150161 | 01-8100-1000-3000 | 150 | REV | -926 |
150162 | 01-4100-1000-3000 | 151 | TAX | -74 |
Table 1 - 134. (Page 1 of 1) |
AR_PAYMENT_SCHEDULES | ||||||||
---|---|---|---|---|---|---|---|---|
payment _schedule _id | amount _due_ original | amount_ due_ remaining | customer _trx_id | trx_ number | status | amount_ applied | class | amount_ adjusted |
400100 | -1080 | 0 | 123456 | CM-101 | CL | -1080 | CM | NULL |
Table 1 - 135. (Page 1 of 1) |
The class column of the credit memo payment schedule is CM. The example credit memo has a status of CL (closed) and the amount_applied column equals the amount of the credit memo, because the credit memo has been applied to an invoice. The amount_due_original column equals the amount of the credit memo, -1000. The amount_due_remaining is zero because the credit memo has been applied to an invoice.
AR_PAYMENT_SCHEDULES | ||||||||
---|---|---|---|---|---|---|---|---|
payment _schedule _id | amount _due_ original | amount_ due_ remaining | customer _trx_id | trx_ number | status | amount_ applied | class | amount_ credited |
30191 | 6400 | 5400 | 101467 | I-101 | OP | NULL | INV | -1000 |
Table 1 - 136. (Page 1 of 1) |
Receivables updates the payment schedule of the invoice to reflect the application of the credit memo. The amount_due_remaining column is reduced by -1000 and the amount_credited column is -1000, the amount of the credit memo.
AR_RECEIVABLE_APPLICATIONS | |||||||
---|---|---|---|---|---|---|---|
receivable_ application _id | amount_ applied | status | payment_ schedule_ id | customer _trx_id | cash_ receipt _id | applied_ payment_ schedule_ id | applied_ customer_ trx_id |
400 | 1000 | APP | 400100 | 123456 | NULL | 30191 | 101467 |
Table 1 - 137. (Page 1 of 1) |
Receivables uses the AR_RECEIVABLE_APPLICATIONS table to store the mapping of the credit memo to the invoice being credited. The payment_schedule_id and customer_trx_id columns contain the credit memo data, while the applied_payment_schedule_id and applied_customer_trx_id reference the original invoice. If the credit memo applies to an invoice with multiple payment schedules, a record is inserted into AR_RECEIVABLE_APPLICATIONS for each payment schedule of the invoice. The code_combination_id column, which is not shown, stores the receivable account of the invoice. However. when the transaction is posted to the general ledger it posts as two distributions. One entry is posted to the receivable account of the credit memo, as it is stored in the RA_CUST_TRX_LINE_GL_DIST table, and the other entry is posted to the receivable account of the invoice, as it is stored in the RA_CUST_TRX_LINE_GL_DIST table.
For a standard credit memo, the receivable account of the credit memo is debited, while the receivable account of the invoice is credited. Normally, the receivable accounts will be the same, but this process permits the flexibility of using a unique receivable account to record your credit memos.
Previous | Next | Contents | Index | Navigation | Glossary | Library |