Previous	Next		Contents	Index	Navigation	Glossary	Library

• AR_CASH_RECEIPTS, which stores one record for each receipt.

• AR_PAYMENT_SCHEDULES, which stores customer balance information at the transaction level.

• AR_RECEIVABLE_APPLICATIONS, which stores accounting entries for cash and credit memo applications.

Example 1 - Same Currency Receipt Application

Receipt Number: R-101

Received From: ABC Inc

Transaction Date: 05-Jul-97

Receipt Amount: 4000 USD

Receipt number R-101 would be represented in Receivables tables as follows:

AR_CASH_ RECEIPTS
credit_receipt_id	receipt_number	amount	status	type	currency	rate
1521	R-101	4000	UNAPP	CASH	USD	NULL
Table 1 - 145. (Table 1 of 1)

After you apply the receipt, Receivables updates the status column from UNAPP to APP. If the receipt were only partially applied, the status would remain UNAPP.

AR_PAYMENT_SCHEDULES
payment_ schedule_ id	amount _due_ original	amount_ due_ remaining	cash_ receipt_id	customer _trx_id	trx_ number	status	amount_ applied	class	curr
2211	6400	2400	NULL	1422	I-101	OP	4000	INV	USD
2225	-4000	0	1521		R-101	CL	-4000	PMT	USD
Table 1 - 146. (Table 1 of 1)

The payment schedule of invoice I-101 has a class of INV, while the payment schedule of receipt R-101 has a class of PMT. The payment schedule record of the receipt is updated to reduce the amount_due_remaining column by the amount applied. Since the entire amount is applied, the amount_due_remaining is zero. The status of the receipt is changed to CL, and the amount_applied is -4000.

Note: If the cash receipt is not confirmed in the AR_CASH_RECEIPT_HISTORY table, the applications of that receipt are not reflected in the payment schedule of the transaction the receipt is applied against.

Receivables updates the payment schedule record of the invoice to reduce the amount_due_remaining by the amount of the applied receipt. The status is still OP because the entire balance has not been paid. Receivables updates the amount_applied to reflect the amount applied to the invoice.

AR_RECEIVABLE_APPLICATIONS
receivable_ application_ _id	status	trx_ number	amount_ applied	code_ combination_ id
3132	UNAPP	NULL	4000	01-1100-1000
3134	UNAPP	NULL	- 4000	01-1200-1100
3135	APP	I-101	4000	01-1200-1100
Table 1 - 147. (Table 1 of 1)

Receivables inserts three records into AR_RECEIVABLE_APPLICATIONS. The first record, with a status of UNAPP, records the original unapplied receipt. The second record, with a status of UNAPP, offsets the original unapplied receipt. The third record, with a status of APP, stores the applied receipt information, including a reference to the applied invoice, via the trx_number column.

The code_combination_id column stores the general ledger account for this receipt, based on the status of the receipt. For the UNAPP record, the code_combination_id represents the general ledger account associated with unapplied receipts. For the APP record, the code_combination_id is the receivable account associated with the invoice transaction to which this receipt is applied.

Example 2 - Same Currency Receipt Application

Invoice Number: I-102	Receipt Number: R-102
Transaction Date: 05-JUN-97	Received From: ABC Inc.
Invoice Amount:	Transaction Date: 5-JUL-97
Exchange Rate: 1 CND = .666667 USD	Receipt Amount: 100 DEM Exchange Rate: 1 DEM = .333333 USD

Receipt number R-102 would be represented in Receivables tables as follows:

AR_CASH_ RECEIPTS
credit_receipt_id	receipt_number	amount	status	type	currency	rate
1520	R-102	100	APP	CASH	DEM	.333
Table 1 - 148. (Table 1 of 1)

When you apply the entire receipt, Receivables updates the status column from UNAPP to APP. If the receipt were only partially applied, the status would remain UNAPP.

AR_PAYMENT_SCHEDULES
payment_ schedule_ id	amount _due_ original	amount_ due_ remaining	cash_ receipt_id	customer _trx_id	trx_ number	status	amount_ applied	class	curr
2212	52.5	0		1423	I-102	CL	52.5	INV	CND
2224	-100	0	1520		R-102	CL	-100	PMT	DEM
Table 1 - 149. (Table 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. The payment schedule record of the receipt is updated to reduce the amount_due_remaining column by the amount applied. Since the entire amount is applied, the amount_due_remaining is zero. The status of the receipt is changed to CL, and the amount_applied is -4000.

Note: If the cash receipt is not confirmed in the AR_CASH_RECEIPT_HISTORY table, the applications of that receipt are not reflected in the payment schedule of the transaction the receipt is applied against.

Receivables updates the payment schedule record of the invoice to reduce the amount_due_remaining by the amount of the applied receipt. The status is still OP because the entire balance has not been paid. Receivables updates the amount_applied to reflect the amount applied to the invoice.

AR_RECEIVABLE_APPLICATIONS
receivable_ application_ _id	status	trx_ number	amt_ applied	amount_ applied _from	trx_to_rcpt_ rate	acct_amt_ applied _to	acct_amt_ applied _tfrom	code_ combination_ id
3142	UNAPP	NULL	100				33.33	01-1100-1000
3134	UNAPP	NULL	-100	- 100		-33.33	-33.33	01-1200-1100
3135	APP	I-102	52.5	100	1.9048	35	33.33	01-1200-1000
Table 1 - 150. (Table 1 of 1)

Again, Receivables inserts three records into AR_RECEIVABLE_APPLICATIONS. The first record, with a status of UNAPP, records the original unapplied receipt. The second record, with a status of UNAPP, offsets the original unapplied receipt. The third record, with a status of APP, stores the applied receipt information, including a reference to the applied invoice, via the trx_number column.

The code_combination_id column stores the general ledger account for this receipt, based on the status of the receipt. For the UNAPP record, the code_combination_id represents the general ledger account associated with unapplied receipts. For the APP record, the code_combination_id is the receivable account associated with the invoice transaction to which this receipt is applied.

See Also

Credit Memos

Unapplied Receipts

Reverse Receipts

Miscellaneous Receipts