In Microsoft Dynamics AX, you can sort a form datasource when the form is loaded. On the form, override the init method. After the call to super(), add the sort field to the form datasource. If you need to sort on multiple fields, keep adding the fields you need with the addSortField method.
If you use the pallet ID in your warehousing strategy, you need to feed the pallet ID to your transfer orders if you want to be able to use the Auto receive functionality when shipping your transfer orders. You can find this option in Inventory and warehouse management, Shipments, Functions, Ship transfer order, Auto receive … [Read more…]
In Microsoft Dynamics AX, you can apply a filter to a form datasource to show a subset of data from a table in a form. The executeQuery method is the one you need to look at. In the form datasource, override the executeQuery method. It’s located to \Forms\%FormName%\Data Sources\%DataSourceName%\Methods\executeQuery. Before the call to super(), add … [Read more…]
Here’s a snippet of code that gets the StringSize property of an extended data type. The DictType object can be use to find other properties of an extended data type.
Here’s an example on how to use the OdbcConnection class to connect to an external database in X++. Related & Recommended Content How to: Connect to an External Database from X++ Code [AX 2012] Executing direct SQL statements