Hi
What would be the best way for me to replicate the information available in Netsuite's default work calendar?
Specifically, I am trying to create a saved search which shows the available hours for an employee for the date range specified in the criteria
The available hours figure in turn should be taken from the employee's work calendar. However, since it is not possible to use this in a saved search, what would be the alternate way for me to use the values from this for a saved search?
For example:
If I select 5/4/2020-7/4/2020 as a date range on a saved search under criteria
I want an employee's scheduled or profiled hours for this date range
In this case, their work pattern (in hours) looks like
Sunday
| Monday
| Tuesday
| Wednesday
| Thursday
| Friday
|
|---|
| 0 | 8 | 8 | 0 | 8 | 7 |
| | | | | |
In my saved search, I want to use:
Formula (numeric), Sum, sum(workprofiledhours)
Selecting the date range should give me a 16 hours:
Sunday 5th would be 0 hours, Monday 6th would be 8 hours and Tuesday 7th would be 8 hours based on work patterns
thanks