AutoGenerate Rows from Subsidiary Master?

This column is available only if you selected the Balance Forward 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 Subsidiary Master? checkbox and then click the Generate Detail Rows button, the detail grid rows are populated as follows:

1.    Each Subsidiary Master row is retrieved for this ID Number and ordered by the Receipting Priority and Subsidiary Code.

2.    If the Accounts Receivable Subsidiary 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 Subsidiary, 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.

Examples

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

Example 1:

Accounts Receivable Subsidiary Balance to Date greater than Amount Tendered (receipt amount)

Amount Tendered:

$22,000.00

Accounts Receivable Subsidiary Balance to Date (Net Total Due )

$22,750.00

 

Subsidiary Code

Net Total Due

SUBSID_DEF_EXT. RECEIPTING PTY

Amount Distributed in Payment Detail

AR

15000.00

001

15000.00

BK

250.00

050

0.00

A1

5000.00

002

5000.00

A2

2500.00

010

2000.00

Example 2:

Accounts Receivable Subsidiary Balance to Date less than Amount Tendered (receipt amount)

Amount Tendered:

$32,000.00

Accounts Receivable Subsidiary Balance to Date (Net Total Due )

$22,750.00

 

Subsidiary Code

Net Total Due

SUBSID_DEF_EXT. RECEIPTING PTY

Amount Distributed in Payment Detail

AR

15000.00

001

24250.00

BK

250.00

050

250.00

A1

5000.00

002

5000.00

A2

2500.00

010

2000.00