Project Field Depth

Project ID field is 20 characters long in AX 2012 R2 CU7.

AOT – Data Tables – Extended Data Types – ProjID.

The project ID length error sometimes occurs even when the previous project ID is of length of 17. 

This is because the moment the next project is created, the ‘Sub-project ID format’ field from the project is filled with the 'Default sub-project ID format' from the project parameters. 

System validates that assuming that the next project is created and shows the project length error. To get around this problem, go to project parameters remove the default sub-project ID format setup and then setup the sub-project. 

When the limit of the project id length reaches the Sub-project ID format field displays blank. Even if the user tries to enter # in it system errors.

Thanks

Sarang

Expense Ledger Postings

Expense Postings has been the most complex issue because of the number of different areas in which the postings can be setup. The difficult part is when we are asked to correlate what meaning does the posting setup has and what amount posts where based on scenario. On top of it, to add to the complexity, we do have Expense Journal, Expense Report from EP and because that was not enough we do have project and non-project expense. Whoa..!

To cut through the clutter and to present the settings in a much simpler fashion i came up with this grid which will be handy to find out where the postings are coming from, in any scenario and how the system is behaving. The grid is as follows:

Thanks
Sarang