Hi Epicor Gurus.
I am looking for a way to automate Build Project Analysis to a daily or weekly routine.
The problem is that new projects get added all the time and project reach end as well all the time so it is not a fixed list to be processed using schedule functionality:
Can you please enlighten me?
Regards,
Shizar
Hi @Fernando
Thank you for your reply.
That is available for me as well.
The problem is once you schedule it, you are scheduling it for a fixed list of projects, correct? However as time goes by, new projects get generated which are not in your fixed list. I am trying to find a way that dynamically runs this process for all active projects.
Hi @Fernando
Just a little more info for you. When I go by all selected, this shows up
Do you get the same error?
Yes, this is a known issue.
What we decided at a previous company that used Projects is that we reserved Build Project Analysis for Finance only since it affects revenue recognition and they may want to keep it at the end of the month values for a few days during fiscal closing.
For the project managers, we wrote our own BAQ that summed up the hours/costs on projects.
One other option is to only roll up projects with activity. Write a BAQ that looks at job/purchase activity and return just the project IDs that have activity. I think the Build Project Analysis was able to do around 200 projects if I recall.
Thank you @Mark_Wonsil
This makes sense now.
Although the limit number of projects should be higher right now since I tried it while selecting over 3400 projects and it went through.
Wow! They have raised it!
@Mark_Wonsil
It took over 2 hours though
