Hi All...Hope you all doing Great!!
Need your guys to help me as I am really new (stage 0 of beginner) in Netsuite and have been assigned to submit a POC (Proof of Concept) for College Management System.
Specifically to say, Attendance Management System for a college. Any inputs and or suggestions would be highly appreciated.
m
MGBC
12/23/2023, 2:19 PM
Probably setup your students as customers then use tasks or events assigned to customers as the classes or class schedule
Use a script to create all the events out into the future based on the class schedule, then build a suitelet for professors to mark students as attended or absent for the events
Also possible solution is to create each class as a project and the project template would be the class schedule. Then create items and mark them as project items. Add the items to a sales order for each student (customer) and when approved each line item would create a project with its relative class schedule (ie project task schedule)
Then make a custom suitelet to mark students absent or attended on the project task and complete the task when the class is taught each day
Then you could use the SO to invoice students collect deposits and payments etc
a
AMIT SINGH
12/23/2023, 2:35 PM
Okayy! That sounds really great and surely I'm gonna give try the way you suggested.
But as of now, I had created a Daily Attendance Form (through Suitelet) for marking Students as Present/Absent through checkboxes which gets saved on my Custom Record Type in Custom List. Here only I created another checkbox for "On Leave" & I want to include leave status of students on the basis of their leave applications which students submit to their respective Professors. so I want that 'On Leave' checkbox on my Daily Attendance form gets disabled for that particular date whenever it is approved by the professor.
AMIT SINGH
12/24/2023, 9:54 AM
@MGBC...i really don't have much of scripting knowledge so I request you to please describe a little more on your response please
m
MGBC
12/24/2023, 2:49 PM
It was just a few ideas. I’m not sure which one would work for your account. Plus I don’t know if you have Projects enabled
Also if you are not using NetSuite for billing and A/R then this approach may not be a good idea
My other idea was a few custom records that could designate classes class schedules etc which it sounds like you are already doing
Which option above do you think would be most effective for you?
a
AMIT SINGH
12/24/2023, 6:12 PM
Since I am into the Trainee atmosphere i feel like i don't have Projects permissions enabled. Although i tried and couldn't find the 'Projects' working for us but still I can ask for permission from my Admin given that I ensure them the way of working with it.
And on the other way with which we are working coincides with your suggestion as you correctly mentioned. but I am also not sure which will be the most effective way to get ahead😇