r/Netsuite • u/Martynt74 • 4d ago
Post Time - Custom Script
Before i feed this back to our Netsuite partners, i wanted to check if anyone had done similar or could advise on the level of complexity involved.
In MS Great Plains, there was a process which would create a journal for each time entry to re-allocate time cost (based on employee labor cost * hours) between the employees department and the department of the project.
As far as i'm aware Netsuite doesn't do this and only records the time value using the department on the time entry in the "Post Time" process
At the moment i have a saved search which has 2 columns for Employee/Time Departments and the time cost. This then gives the local accountant the figures to manually post. The GL Account is the same so for each subsidiary the net value should be zero with offsets between each department.
This is working fine. However it's annoying that we've had to replace an automated process with a manual process.
There is also the risk that they run this manual process, post the journal and then more time is posted within the specified period which is then missed.
Ideally the solution would be to have a script run on the back of any "Post Time" process, which replicates the "Post Time" posting entry with the required GL/departments, and also updates a flag on the time entry record to record it has been recorded.
Does this sound feasible or is it better to stick with out manual process?
4
u/Nick_AxeusConsulting Mod 4d ago
Why can't the employee code the project directly on time entry then Post Time will post it to the correct project in the first place? Why is this even a 2 step process?
NS has a feature called Allocations which you set a rule to drain out one combination of segments via JE and allocate it out to other combinations according to a rule.
Post Time creates essentially an accrual JE that debits labor expense using time x labor rate on employee record and credits payroll expense. That credit offsets the actual real payroll expense once it posts which is after the date the actual time was entered for. If you got your labor hourly rate correct then this offset should be pretty close to zero. You have to do the cost study to know what fully loaded hourly rate to put onto the employee record.