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:

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

Active InventDim dimension on ListPage

If you want to check on a list page if a specific inventDim dimension is active and shown on the grid the following code can check that case: (The example checks if the invent batch id is displayed on the grid:   if (element.inventDimSetupObject().parmDimParmVisibleGrid().InventBatchIdFlag) { // Display some new field }