Using a stored procedure to process fees paid in advance

Modified on Sun, 19 Apr at 11:25 PM

A stored procedure is available from Synergetic Management Systems to automate the entering of tuition fees paid in advance. See Processing fees paid in advance with enrolment deposits.
If you want to use this stored procedure, Contact Synergetic Management Systems to have one tailored for your organisation.

To use the stored procedure:

Select Module > Students > Current Student Maintenance.
The Current Student Maintenance window is displayed.
Click on the User Forms tab.
The User Forms tab of Current Student Maintenance is displayed.
Select the Student Fees In Advance Concessions user form.
Click .
The Create Fees in Advance Concessions user form is displayed.
Click .
The Enter Stored Procedure Parameters window is displayed.
Type in the year the enrolment deposit was made in @BaseYear.
Note: This is the year from which the fee rates are calculated. For example, if the fees were paid in advance in 2013, the rates from 2013 are used for all tuition fees.
Type in the first year paid in advance in @YearFrom.
Type in the last year paid in advance in @YearTo.
Note: This field is optional: the stored procedure will create concessions for each year until the enrolment deposit is depleted.
Set the @Pay... flags as required (1 for True, 0 or blank for False).
Click .
The concessions, including the rebate, are generated.