Tuesday, June 25, 2013

Ax 2012 - Table References

Table references are new in Ax 2012 and was curious on how it works, didn't get time to explore it in detail, but somehow ended up with an issue related to Table references node in Ax 2012.

Observation:
1. Duplicated  EDT "PriceDiscJournalName" and renamed it to "Tec_PriceDiscJournalName"
2. All the relations in the EDT also copied to new EDT, which may not be relevant and changed the relations node to change the relation to new table as shown in figure below.



3. Adding a table reference on table reference node results in wrong table being related








Resolution:
1. Delete the created table reference by deleting the elements under table references node.
2. This can be rectified by changing the property "Reference Table" from "PriceDiscAdmName" to "Tec_PriceDiscAdmName" in my case. In generic change the refrence from old table to new table.




3.Create a new table reference









4. Table reference node created with new reference.




Intha Naal Iniya Naal :)