Previous	Next		Contents	Index	Navigation	Glossary	Library

• RA_CUSTOMER_TRX

• RA_CUSTOMER_TRX_LINES

• RA_CUST_TRX_LINE_GL_DIST

• AR_PAYMENT_SCHEDULES

• AR_RECEIVABLE_APPLICATIONS

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)

Because this is a credit memo, the revenue and tax accounts will be debited and the receivable will be credited.

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.

See Also