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.

VS: No symbols have been loaded for this document

Running over a breakpoint without opening the debugger can be very sad. When you hover over the breakpoint VS tells you that the symbol has not been loaded for the document. The solution is simple. Go to VS > Dynamics365 > Options In the options window select the “Debugging” node and make sure the “Load … Read moreVS: No symbols have been loaded for this document

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