AutoGenerate Rows from Open Items?

This column is only available if you are licensed to use Open Items (OI), if you selected the Open Items radio button on the A/R Configuration window, and if rows exist in the Subsidiary Master table for the ID Number entered.

If you select the AutoGenerate Rows from Open Items? checkbox and then click the Generate Detail Rows button, the Receipt Detail grid rows are populated as follows if you have selected the Priority Distribution radio button on the A/R Configuration window:

1. Each Transaction History Open Item View is retrieved for this ID Number and ordered by the Receipting Priority.

2. If the Open Item Balance to Date as of today, including credits of unapplied financial aid and third party billing amounts, is greater than 0, detail rows are generated in the grid for the balance up to the Cash Tendered amount.

3. Based on Receipting Priority of the Open Item and/or charge, detail rows continue to be generated until Cash Tendered amount is used up (= to 0) or there are no debit balances remaining.

4. When you save, the system checks to ensure that the total of the Transaction Amount column in the detail grid does not exceed the amount in the Cash Tendered column in the window header.

If you select the AutoGenerate Rows from Open Items? checkbox and then click the Generate Detail Rows button, the Receipt Detail grid rows are populated as follows if you have selected the Proportional Distribution radio button on the A/R Configuration window:

1. Each Transaction History Open Item View row is retrieved for this ID Number and ordered by the Receipting Priority.

3. The distribution percentage is calculated by dividing the Cash Tendered amount by the Open Item Balance to Date as of today

4. The system calculates the payment amount for each Receipt Detail row by multiplying the Cash Tendered amount by the distribution percentage and enters the payment amount in the Transaction Amount column and the Transaction Description column includes the words "Payment of".

5. When you Save, the system checks to ensure that the total of the Transaction Amount column in the detail grid does not exceed the amount in the Cash Tendered column in the window header.

Examples

Examples for Priority Distribution

Note that the amount should only be distributed when the receipt amount changes.

Example 1:

Open Item Balance to Date greater than Amount Tendered (receipt amount)
Amount Tendered:	$22,000.00
Open Item Balance to Date (Net Total Due )	$22,750.00

Charge Fee Code	Subsidiary Code	Net Total Due	SUBSID_DEF_EXT. RECEIPTING PTY	Amount Distributed in Payment Detail
TU	AR	15000.00	001	15000.00
CR	AR	250.00	050	0.00
BK	AR	5000.00	002	5000.00
RG	AR	2500.00	010	2000.00

Example 2:

Open Item Balance to Date less than Amount Tendered (receipt amount)
Amount Tendered:	$32,000.00
Open Item Balance to Date (Net Total Due )	$22,750.00

Charge Fee Code	Subsidiary Code	Net Total Due	SUBSID_DEF_EXT. RECEIPTING PTY	Amount Distributed in Payment Detail
TU	AR	15000.00	001	24250.00
CR	AR	250.00	050	250.00
BK	AR	5000.00	002	5000.00
RG	AR	2500.00	010	2500.00

Examples for Proportional Distribution

Note that the amount should only be distributed when the receipt amount changes.

Example 1:

Open Item Balance to Date greater than Amount Tendered (receipt amount)
Amount Tendered:	$22,000.00
Open Item Balance to Date (Net Total Due )	$22,750.00
Calculated Distribution Percentage	.9670 (96%)

Charge Fee Code	Subsidiary Code	Net Total Due	SUBSID_DEF_EXT. RECEIPTING PTY	Amount Distributed in Payment Detail
TU	AR	15000.00	001	14505.00
CR	AR	250.00	050	241.75
BK	AR	5000.00	002	4835.00
RG	AR	2500.00	010	2418.25

Example 2:

Open Item Balance to Date less than Amount Tendered (receipt amount)
Amount Tendered:	$32,000.00
Open Item Balance to Date (Net Total Due )	$22,750.00
Calculated Distribution Percentage	1.4065 (140%)

Charge Fee Code	Subsidiary Code	Net Total Due	SUBSID_DEF_EXT. RECEIPTING PTY	Amount Distributed in Payment Detail
TU	AR	15000.00	001	21097.50
CR	AR	250.00	050	351.63
BK	AR	5000.00	002	7032.50
RG	AR	2500.00	010	3518.17