Is it possible to have a Project Number segment in your chart of account by keeping project numbering automatic?
Basically if you do that then do you need to manually add the newly generated project number values in your values set define @ COA Project Segment level? Or is there any work aound where these values in the value sets are not mandatory?
There is no out-of-the-box solution to keep the GL value set synchronized withthe list of projects.
You might develop a customization like a data base trigger that will maintain the value set for the COA.
You may need to consider changes in project status so only approved project will have a value enabled in GL. When project is closed in PA you will need to automatically disable or end date the value in GL.
I was just validating further about this scenario and come up with understanding that if I make a value set assigned against project segment with Validation type as "None" instead of "Independant" then will I be achieving creating projects dynamically without doing customization?
This is sheer theorotical and wanted to confirm you.
Your approach may work if all your journals are accounted automaticlly based on Projects.
However, if you allow users to enter manual journals to GL, you might want to have a validation of the value entered for each of the COA segments.