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.
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 |