Is there anyway to find how many active employees ...
# suitescriptr
raghav
04/05/2023, 11:33 AMIs there anyway to find how many active employees are unallocated today through search or script ?
raghav
04/05/2023, 1:36 PMSomething like this using query module.
Copy code
SELECT name, internalid
FROM EMPLOYEE
WHERE imternalid NOT IN (
SELECT resource.internalid
FROM resourceallocation
WHERE startdate <= today && enddate >= today
GROUP BY resource.internalid
)2 Views