[Axapta-Knowledge-Village] Dynamic Group by Statement

Hi All, I would like to group and sum by fields dynamically in an AX while statement. Basically I want to sum and group by any field on the table using a setup table. Example: while select sum(qty) from projinvoiceempl group by CategoryID { //Some code which does some stuff with the qty sum

[Axapta-Knowledge-Village] Trade discounts in Dynamics AX 4 - Projects

Hi All, Does anyone know if there is a way to apply a trade discount on a Project invoice? If so, please can you point me in the direction of where to look or maybe some documentation :) Many thanks for your assistance. Regards, Shaakera

[Axapta-Knowledge-Village] Shared tables across environmnets

Hi All, We are planning to do a multi-site deployment for a group of companies belonging to the same holding company. The chart of accounts and a few other setup tables are required to be shared across all the companies. When the companies are in the same database, one would use a virtual

[Axapta-Knowledge-Village] Domain issue - cross company checking

Hi All, We have the following business requirement: A validation on South African ID numbers for employees needs to be run across all Live companies. We have 5 different companies in the Live environment and the ID number validation needs to be run across all 5 companies. This is not an

[Axapta-Knowledge-Village] Record Level Security - Strange

Hi All, I have been setting up RLS in our test environment and have across something really strange. I have set up the RLS for the Project Category table. There are a number of category codes that have been set up, however in my test user group I have set the restriction to only use the

[Axapta-Knowledge-Village] Virtual company - ProjCategory

HI All, Has anyone had any experiences with the ProjCategory being part of a virtual company? We are wanting to add this table to the collection, however I feel a bit nervous about this move as there is so much transactional data dependant on this? Any recommendations ?

[Axapta-Knowledge-Village] The Values on the form displayed are not current - F5 refresh

Hi All, We have very complex form, with many data sources. When some of the fields one of the data sources are changed, the other data sources need to be refreshed as usually they have been updated on the data sources table validate method. I have been using the datasourcename_ds.research()

[Axapta-Knowledge-Village] Development certiifcation exams - MorphX

Hi All, Has anyone written the second development exam? The MorphX one? Any tips, pointers or sample questions will be greatly appreciated. Many thanks :) Shaakera