Great video. It inspired me. Every month, for all projects that I have, usually around 20, I have to generate a ECAC or estimated cost at completion, then I have to go through the budgets and make changes to the estimated at completion. Since there are often many lines of task codes, I export the rows to excel, where I have written a large amount of visual basic macros to process the data to get the costs to a starting point that is easier to make changes to. Then I take those numbers and copy them back into F&O where they came from. This takes forever. Large portions of this should be easy to automate. I figure I should be able to automate the creation of the ECAC for a given prompted list of projects and some information like the project period dates etc. This video is inspiring me, how would you do it? How would you tackle this problem? I don't have time as the manager to do this, attend meetings, and visit project sites all in the 2 days this usually falls each month.
Thank you for the video, I am trying to do a reception through custom script and I receive this error when I run the test : The custom script is not allowed to access the AccountingEventSourceDocumentLineLink table. any suggestion please?
Hi Dear, Thanks for your training. I have a question: Why the menu item of the custom script does not show for me? I accessed all required duties to a new role builder. Thanks in advance.
Thank you so much. I went through microsoft documentation but couldn't understand much. This helped me alot.
Great video. It inspired me.
Every month, for all projects that I have, usually around 20, I have to generate a ECAC or estimated cost at completion, then I have to go through the budgets and make changes to the estimated at completion. Since there are often many lines of task codes, I export the rows to excel, where I have written a large amount of visual basic macros to process the data to get the costs to a starting point that is easier to make changes to. Then I take those numbers and copy them back into F&O where they came from. This takes forever. Large portions of this should be easy to automate. I figure I should be able to automate the creation of the ECAC for a given prompted list of projects and some information like the project period dates etc. This video is inspiring me, how would you do it? How would you tackle this problem? I don't have time as the manager to do this, attend meetings, and visit project sites all in the 2 days this usually falls each month.
Thank you so much. Informative to me
Great Video Thanks.
Thank you for the video, I am trying to do a reception through custom script and I receive this error when I run the test : The custom script is not allowed to access the AccountingEventSourceDocumentLineLink table. any suggestion please?
I am new to scripts also, but are you not missing something like a model ref in your script model?
@@keleabetswemodiba6105 I don't think so, this table belongs to subledger model which I already added
Hi Dear, Thanks for your training. I have a question: Why the menu item of the custom script does not show for me? I accessed all required duties to a new role builder. Thanks in advance.
are you on a supported version ?
I noticed my cloud hosted environments don't have it. just sandbox and prod
The important thing is that the creation of new model.
p̳r̳o̳m̳o̳s̳m̳