Execute task command

During the last weeks i had to create a new form with multiple datasources. In the first moment it sounds simple. Up to this point it is too. But some new functionalities later i wanted to refresh the forms datasources. The common approach is to do a research/refresh/reread on the datasources. But that was not … Read moreExecute task command

Error 100 / TimeZone on AOS startup

If the newly installed AOS won’t start and throws an error 100 / 101 a single parameter in the database can fix the issue: Go to the table “SQLSystemVariables” and change the row “SystemTimeZoneVersion” to the number which is required in the error message. After the change is saved, try to start the AOS.

Get available physical quantity

Without joining the InventSum table you can easily get the available quantity for an item: The parameters for the methods are just the relevants. ItemId Find or create the inventDim for the inventory dimension. If you need to check the quantity on different licenseplates (f.E.) you have to loop through the InventDims:

Auto search on form data source

Following scenario: You are creating a new form in AX2012. You are adding a form data source, for example the ProdTable, inserting some fields to the interface. But you don’t want the form to show always the first dataset of the ProdTable on your form fields. In that case you can set the property “AutoSearch” … Read moreAuto search on form data source

Pick from sales order and post packing slip

SalesTable salesTable = SalesTable::find(“SO100053”); SalesLine salesLine; Query inventTransQuery; QueryBuildDataSource inventTransQbds; InventTrans inventTrans; InventTransOrigin inventTransOrigin; TmpInventTransWMS tmpInventTransWMS; InventTransWMS_Pick inventTransWMS_Pick; while select salesLine where salesLine.SalesId == salesTable.SalesId { inventTransQuery                = new Query();     inventTransQbds = inventTransQuery.addDataSource(tableNum(InventTrans));     inventTrans                     … Read morePick from sales order and post packing slip

Display String as barcode

There are several different classes in AX which can convert a simple string to a specific barcode format. I used the following example to convert a string to a EAN128 barcode and display it in a simple dialog in AX2012R3: Which font code you need is declared in the classes “Barcode*” classes. You can initialize … Read moreDisplay String as barcode