Reference group in table browser in AX 2012Continue reading
Table browser is a widely used tool for viewing table data directly from Microsoft Dynamics AX development workspace. A simple, grid-based form presents selected records from a particular table.
List of columns consists of all visible non-system fields in alphabetical order as well as some of system fields in the end.
Although the key feature of Table browser has not changed in Microsoft Dynamics AX 2012, the nature of data has slightly evolved – the surrogate keys have been introduced. As a result, RefRecId-based fields can be seen in table browser quite often. Obviously, it is not a preferable way of exploring data for any team member. Fortunately, there is a chance to make the form more human-readable:
All we need is to add a reference group just after surrogate key field is shown on the grid. We modify addField() method of SysTableBrowser class.
Changes are in:
When we deal with Int64-based DictField:
The reference group is read-only and labelled as “REF: field” to mark it is not a field from table:
In general, there can be more than one column added in reference group. It depends on AutoIdentification field group from related table. Let us look at DirPartyLocationRole table and surrogate key PartyLocation.
This example is even more interesting, because referenced AutoIdentification field group in DirPartyLocation table contains two surrogate keys – Party and Location. The described mechanism finally takes DirPartyTable.Name and LogisticsLocation.Description (both belong to AutoIdentification field group of proper table) as a content of reference group displayed on grid.
The retail industry is still dealing with the effects of the pandemic that lasted almost three years. In addition to this, further global events are causing disruption to the supply chain or financial stability of many retailers globally. As the industry confronts new challenges shaped by economic and geopolitical factors, it also faces trends influenced by changing customer expectations and needs. Here are 5 developments and trends to watch.
An interactive, AI-powered support for sales, customer service, marketing, and supply chain - Microsoft Dynamics 365 Copilot leverages generative AI and natural language processing technology to perform simple, yet time-consuming daily tasks that workload employees but can be automated.
Every company management facing a system change wonders what steps should be taken to ensure that this change does not cause turbulence to its business. Identical dilemmas are faced by any IT company that provides services to implement a new system. I will focus on these dilemmas today.
Artificial intelligence (AI) and machine learning (ML) technologies are changing business every day - just as new tools and services are frequently emerging to expand their use cases. PwC estimates that the impact of these technologies on the global economy will add approximately $15.7 trillion to its value by 2030 (1).