Hi
What I am trying to do and background:
- Our payroll is processed using a third party bundle installed on to our account. This bundle is used to process the payroll for one of our subsidiaries (one particular country, known as 'A') and not the other. The other subsidiary's payroll is processed outside of Netsuite.
- The non Netsuite payroll subsidiary ('B') has employee record data still maintained in our Netsuite account. This is mainly basic information such as the employee start date, address, and salary. There is a leave balance field which is currently not used.
We are looking to start storing their leave balances in their employee record, even though payroll payments will still continue to be processed outside of Netsuite for them.
The issue: For subsidiary A, the leave balances are updated via scripts and workflows from the third party payroll bundle. The trigger is a payrun being executed and completed. The leave balances are incremented from this.
For subsidiary B, I am trying to create a scheduled workflow that would achieve the same thing as subsidiary A.
i.e. On the first day of every month, a workflow runs that updates the leave balance field with an incremental amount (the leave accrual amount which is based on the employee's work hours and entitlement).
The problem for me is two fold:
1. What workflow parameters do I need to schedule a workflow that is set to run automatically on the first of the month? I have tried testing scheduled workflows and I don't see the option to specify that sort of recurring pattern
2. In the formula value, what formula do I use so that the leave field is incremented by +10 hours per month (or some other similar formula- the main thing being it allows you to calculate and increase the value in the leave balance field (which is currently stored as a decimal number) ?