Query Student Account {FSAO-7}

This option allows the user to display student debtor transactions.

This option has four panel box's namely:

Search
Student Detail
Account Type / Agreement Totals
Transaction Detail

Panel Box 1: Search

At least one field must be completed to execute a search.

Field	Type & Length	Description
Student Number	N9	If the search is based on a student number enter the student number to search on.
Surname	A40	If the search is based on a surname enter the surname to search on.
Total Balance	N15.2	If the search is based on a student balance enter the balance to search on. The search will retrieve students where the student balance in student currency is less or equal to the search amount.
First Names	A40	If the search is based on first names enter the first name to search on.
ID Number	N13	If the search is based on firstID number enter the ID number to search on.

Example: Search

Panel Box 2: Student Detail

At least one field must be completed to execute a search.

Field	Type & Length	Description
Student Status Information	Button	Open the student status window and displays the statusses for the student.
iComms Query	Button	Call the iComms Query option {FSAO-33}.
Statement	Button	Runs the student statement program {FSAOR2-10} and display the output in the browser.

Student Number	N9	Displays the student number of the students returned through a search.
Title	A5	Displays the title of the students returned through a search.
Initials	A6	Displays the initials of the students returned through a search.
ID Number	A15	Displays the ID number of the students returned through a search.
Fee Balance		All the aging values of the account type agreement code. The values of Current, 30 Days, 60 Days, 90 Days, 120 Days accumulate into Payable. Payable, Unallocated, Future and Credit accumulate into Balance.
Deposit Balance
Total Balance
Current
30 Days
60 Days
90 Days
120 Days
Payable
Unallocated
Future
Credit

Example: Student Detail

Student Status Information

Field	Type & Length	Description
Status Code & Description	A4 + A40	Satus code linked to the student as defined in in {FSAC-1}.
Action Code & Description	A2 + A30	The action linked to that status is displayed.
Account Type & Description	A4 + A30	If the stauts is linked to the status code, the status is only be effective for that account type.
Start Date	A3	The date from which this status is effective.

Example: Student Status Information

Panel Box 3 : Account Type / Agreement Totals

Field	Type & Length	Description
Installments	Button	Open the instalments window and displays the instalments for the student, account type and agreement code.

Account Type	A4	Displays the account type
Agreement Code	A4	Displays the agreement code.
Fee Deposit Indicator	A1	Indicates if the account is a fee or deposit account type.
Balance	Display	All the aging values of the account type agreement code. The values of Current, 30 Days, 60 Days, 90 Days, 120 Days accumulate into Payable. Payable, Unallocated, Future and Credit accumulate into Balance.
Current	Display
30 Days	Display
60 Days	Display
90 Days	Display
120 Days	Display
Payable	Display
Unallocated	Display
Future	Display
Credit	Display

Example: Account Type / Agreement Totals

Installments

Field	Type & Length	Description
Student Number	N9	The student for which the installments are displayed.
Account Type	A4	The account type for which the installments are displayed.
Agreement Code	A4	The agreement code for which the installments are displayed.
Currency Code	A3	The currency in which the instalments are displayed.
No	N3	Payment sequence number
Date/Days	A4	Is the payments/installments calculated using dates or days
Date	DD_MON-YYYY	The date of the installment
Days	N4	Displays the number of days if the payments/installments calculation is based on days.
Percentage	N3	Display the agreement percentage payable if applicable. If the agreement is based on fixed amounts then this field will be null
Agreement Amount Payable	Display	Displays the monetary value of the installment.
Amount Due	Display
Accumulated Amount Due	Display

Example: Installments

Panel Box 4 : Transaction Detail

This panel box displays the detail transactions of the active account type agreement code, in the box above.

The first line contains the balance brought forward for transaction where the transaction date is less than or equal to the block 1 accumulation date.

Field	Type & Length	Description
Accumulation Date	Button	Defaults to the date as set on the system operational definition {FCSM-1b2} code 'SD' for subsystem 'SD'. The default date can be changed to a greater or smaller date, if the user requires more or less detail transactions information for the queried student.
Create Journal	Button	Calls the Maintain Transaction option {FSAO-1}, from which users with update access can create student debtor journals.

Date	DD-MON-YYYY	The process date of transactions.
Reference Date	DD-MON-YYYY	The reference date of the transaction for the student queried. Reference date defaults to the system date when a transaction is processed but may be changed to the date the transaction was initiated by a user.
Reference	A10	Reference number of the transaction
Transaction Code	N4	The transaction type on which the transactions were processed for the student queried.
Debit Cost Centre	A6	The debit cost centre of the transactions.
Debit Account	A8	The debit account of the transactions.
Credit Cost Centre	A6	The credit cost centre of the transactions.
Credit Account	A8	The credit account of the transactions.
Debit/Credit	A1	Indicates if the students account was debited or credited.
Given Currency Amount	N15.2	The transaction values in student currency. Student currency is entered on the student biographical information processed in {SREGB-1, 4 or 6} and may differ form the institutions currency.
Note		The transaction type/code note or alternative note as maintained under {FCSO-7} will default in this field in the preferred language of the student. The user can however update this note. This note will be printed on the student’s statement.
General Ledger Note		The GL note to be displayed in the GL if the transaction is not posted in summary. The GL note will default from the transaction type definition, if not entered on the transaction the student number, name and initials will default on a journal as the GL note.
Batch Journal Sequence Number	N10	If the journal was created through the batch option {FSAO-10}, the sequence number of the template used to create the journal.
Batch Journal Line Number	N10	If the journal was created through the batch option {FSAO-10}, the line number in the sequence used to create the journal.
No Show Indicator	A1	No show indicators on transactions for the student. Corrective transactions (original transaction and contra transaction) on a students account, if flagged, may be suppressed when printing student account statements. Transaction may be flagged using the option “Show Indicators for Statements “ {FSAO-5}.
Auto No Show Indicator	A1	Auto no show indicators on transactions for the student. Transactions (original transaction and contra transaction) on a students account may be flagged not to be included in aging calculations. The auto no show flags are set by programs and cannot be updated by the user.
Year	N4	The financial year of the transaction.
Cycle	N2	The financial cycle the transaction.
Hidden fields
Account Type	A4	The account type.
Agreement Code	A4	The payment agreements.
Exchange Rate	N5.3	The exchange rate at which the transaction was processed
Value Local Currency	N15.2	The transaction values in local currency. The value of “Value Local Currency” is the “ Value in Student Currency” multiplied with the exchange rate.
Date Posted	DD-MON-YYYY	The date on which the transaction was posted to the general.
Posted	A1	The posted indicator for transaction. (Yes/No)
VAT %	N1,3	The VAT % on transactions
VAT Type	A1	The VAT type of a transaction. The following VAT types are inserted with a transaction. Childless - The transaction has a zero VAT rate and no input or output VAT transactions is linked to the record. Father - The transaction had a VAT rate greater than zero (0). An input or output VAT record was created linked to this record by a transaction sequence. Input VAT - The VAT record created for the transaction with a VAT and apportionment rate greater than zero (0). This record is linked to the Father VAT record through a transaction sequence. In calculation of the VAT input value the VAT apportionment percentage was applied. Output VAT - The VAT record created for the transaction with a rate greater than zero (0). This record is linked to the Father VAT record through a transaction sequence.
VAT Apportionment	N1,3	The VAT Apportionment % on transactions.
3rd Party Debtor Number	N9	The debtor number the transactions will be/were transferred to in the Accounts Receivable subsystem. The Accounts Receivable debtor is linked to a contractee or employer on the contract definition. Refer to “Maintain Contracts” {FSAC-10}.
3rd Party Debtor Purchase Order Number	A15	A 3rd Party reference number. The reference may be required by some contract parties that are involved as the Contributing Employers or Contractee.
Document Number	A10	The document number of the invoice or credit note the transaction was transferred to in the Accounts Receivable subsystem.
Type of Document	A2	The document type of the invoice or credit note the transaction was transferred to in the Accounts Receivable subsystem.
Line Number	N3	The line number on the invoice or credit note the transaction was transferred to in the Accounts Receivable subsystem.
Date Copied	(DD-MON-YYYY)	The date the transaction was transferred to in the Accounts Receivable subsystem.

Example: Transaction Detail

Accumulation Date

Field	Type & Length	Description
Accumulation Date	DD-MON-YYYY	The Default Date up to which Student Statement {FSAOR2-10}, {FSAOR2-11} and Account Query {FSAO-7} are accumulate. When account query is done, the program will display this date and the user is allowed to change the value.

Example: Accumulation Date

History Of Changes

Date	System Version	By Whom	Job	Description
23-Apr-2007	v01.0.0.0	Charlene van der Schyff	t130142	New manual format.
21-Nov-2008	v01.0.0.1	Marchand Hilderbrand	t148236	Add Contractee / Employer Purchase Order Number
21-May-2009	v01.0.0.2	Ernie van den Berg	t157364	Review the manual.
29-Jul-2010	v02.0.0.0	Christel van Staden	t168728	Add view and mail statements
17-Nov-2010	v02.0.0.1	Christel van Staden	f168830	Fix spelling error
19-Nov-2014	v03.0.0.0	Clinton Naidu	t203431	Add print statement button
10-NOV-2015	v04.0.0.0	Marchand Hildebrand	t194728	Convert to ADF
03-Mar-2020	v04.1.0.0	Nare Sheron Modikoa	t242418	Manual Update And Updating Images