GEL script/Process to close projects for time entry and reduce ETC to 0

Discussion created by matpj on Oct 12, 2010
Latest reply on Oct 12, 2010 by matpj
Hi all,I want a script or process that will be run on a weekly basis to 'close for time entry' and reduce ETC to zero, any project that satisifes a criteria on a field.  If I associate the process with an object I can do both of these things, but I want the process to run across all projects.Is this pobbile to do (if so, how)?  Alternatively I guess a GEL script containing an SQL read, returning only those projects that qualify - followed by a XOG read/XOG wrtie to reduce things.   that seems like overkill when it is already possible on a project by project basis to do it using system actions.  thank in advance,Matt