Thread (1 Viewer)

mike60smart

Registered User.
Local time
Today, 21:40
Joined
Aug 6, 2017
Messages
1,899
Here it is. Thanks so much. Kindly assist me in creating an invoice and a receipt to be given to a student after making payments in a certain date in a certain term and a certain year.
Hi
Not sure if we have the structure correct yet.

A student attends in a specific Year.
He signs up for 1 or more courses to be completed over the following 3 Terms.

Or

Student signs of for specific Course(s) in 1 Term and payments for the course a paid during just that 1 Term

Can you explain ?
 

mercystone

Member
Local time
Tomorrow, 00:40
Joined
Sep 20, 2021
Messages
108
Hi
Not sure if we have the structure correct yet.

A student attends in a specific Year.
He signs up for 1 or more courses to be completed over the following 3 Terms.

Or

Student signs of for specific Course(s) in 1 Term and payments for the course a paid during just that 1 Term

Can you explain ?
A student pays fees for a class spread in three terms.e.g
FORM 1 STUDENTS
CLASS-FORM 1
YEAR- 2022
TERM 1- 40,000
TERM 2- 30,000
TERM 3- 20,000
TOTAL FORM 1- 80,000

FORM 2 STUDENTS
CLASS- FORM 2
YEAR - 2022
TERM 1- 30,000
TERM 2- 20,000
TERM 3- 10,000
TOTAL FORM 2 - 60,000

FORM 3 STUDENTS
CLASS- FORM 3
YEAR- 2022
TERM 1- 20,000
TERM 2- 15,000
TERM 3 - 10,000
TOTAL FORM 3- 45,000

FORM 4 STUDENTS
CLASS - FORM 4
TERM 1 - 15,000
TERM 2- 10,000
TERM 3 - 5,000
TOTAL FORM 4 - 30,000

The above fees changes every year and every term for a class.
Not the same.

A student may not complete payments in a certain term which should be reflected in the following term(next term).
 

mike60smart

Registered User.
Local time
Today, 21:40
Joined
Aug 6, 2017
Messages
1,899
A student pays fees for a class spread in three terms.e.g
FORM 1 STUDENTS
CLASS-FORM 1
YEAR- 2022
TERM 1- 40,000
TERM 2- 30,000
TERM 3- 20,000
TOTAL FORM 1- 80,000

FORM 2 STUDENTS
CLASS- FORM 2
YEAR - 2022
TERM 1- 30,000
TERM 2- 20,000
TERM 3- 10,000
TOTAL FORM 2 - 60,000

FORM 3 STUDENTS
CLASS- FORM 3
YEAR- 2022
TERM 1- 20,000
TERM 2- 15,000
TERM 3 - 10,000
TOTAL FORM 3- 45,000

FORM 4 STUDENTS
CLASS - FORM 4
TERM 1 - 15,000
TERM 2- 10,000
TERM 3 - 5,000
TOTAL FORM 4 - 30,000

The above fees changes every year and every term for a class.
Not the same.

A student may not complete payments in a certain term which should be reflected in the following term(next term).
Hi
On the frmStudentFees I added a Command Button to "View Receipt"

Study how this works and I am sure you can work out how to generate an Invoice
 

Attachments

  • FEES PAYMENTSv2.zip
    193.3 KB · Views: 116

mercystone

Member
Local time
Tomorrow, 00:40
Joined
Sep 20, 2021
Messages
108
Hi
On the frmStudentFees I added a Command Button to "View Receipt"

Study how this works and I am sure you can work out how to generate an Invoice
Is there any way to filter:-
1. Years
2. GradeDesc
3. Stream
4. Term

This will print Student Report in a term
 

mike60smart

Registered User.
Local time
Today, 21:40
Joined
Aug 6, 2017
Messages
1,899
You would use criteria in the query that the Receipt is based on
 

Users who are viewing this thread

Top Bottom