How to get the filtered datasource query after pressing Ctrl +G
Question: How to get filtered query after using filter by grid option in grid Grid showing filter records Grid showing complete list of records Answer: You can get the query which is created after providing filter criteria like this; datasourceName.queryRun().query().datasourceNo(1).ToString();
Find On-Hand inventory
While working on inventory module I wrote this code to find out the On-Hand inventory by using the InventOnHand class. static void findingOnHand(Args _args) { ItemId itemId; InventDim inventDim, inventDimCriteria; InventDimParm inventDimParm; InventOnhand inventOnhand = new InventOnhand(); ; itemId = ‘00200956’; inventDimCriteria.InventLocationId = ’08’; inventDimParm.initFromInventDim(inventDimCriteria); inventOnhand.parmInventDim(inventDimCriteria); inventOnhand.parmInventDimParm(inventDimParm); }
Find On-Hand inventory on given date
This piece of code can help you to find out On-Hand inventory at a particular date. static void findingOnHandByDate(Args _args) { ItemId itemId; InventDim inventDimCriteria; InventDimParm inventDimParm; InventSumDateDim inventSumDateDim; ; // Specify the item to get onhand info on itemId = ‘00005’; //inventDimCriteria.InventColorId = ’02’; inventDimParm.initFromInventDim(inventDimCriteria); inventSumDateDim = InventSumDateDim::newParameters(mkdate(31,12,2009), itemId, inventDimCriteria, inventDimParm); info(strfmt(“PostedQty: %1”,inventSumDateDim.postedQty())); info(strfmt(“DeductedQty: %1”,inventSumDateDim.deductedQty())); info(strfmt(“ReceivedQty: %1”,inventSumDateDim.receivedQty())); }
Check Active Inventory Dimension
In recent time I came across with a requirement how to find out an active inventory dimension associated with an item. Here is a sample job to do this task; static void checkInventDimActive(Args _args) { ItemId itemid = “1000”; ; info(strfmt(“%1”, InventDimSetup::find(InventTable::find(itemid).dimGroupId, fieldNum(InventDim, configId)).Active)); }
Dynamics Ax 4.0 installation
This question is being from many folks. How to install the Dynamics AX on non-domain computers. This article is going to help you to resolve the issue.
Update record after record insert in table
If you are getting the following error while inserting and updating records. Cannot edit a record in Table (Tablename).An update conflict occurred due to another user process deleting the record or changing one or more fields in the record. You will be doing it in this way; 1.Table table; 2.; 3.table.Field1 = ‘A’; 4.table.insert(); 5. 6.table.Field2 = ‘Desc’; 7.table.update(); To avoid such cases: 01.Table table; 02.; 03.ttsbegin; 04.table.Field1 = ‘A’; 05.table.insert(); 06. 07.table.Field2 = ‘Desc’; 08.table.update(); 09.ttscommit; Or this way: 01.Table table; 02.; 03.table.Field1 = ‘A’; 04.table.insert(); 05. 06.// time consuming other code here 07. 08.ttsbegin; 09.table.selectForUpdate(true); 10.table.reread(); 11.table.Field2 = ‘Desc’; 12.table.update(); 13.ttscommit;
List of “Whats New in Dynamics AX 2012″ Documents is Now on PartnerSource!
Finally Microsoft has released some documents about the long waited Microsoft Dynamics AX 2012. These new training materials highlight the new features in Microsoft Dynamics AX 2012. These materials are currently downloadable on PartnerSource (Partner Service Plan required). They will be orderable (can be purchased) beginning April 21. What’s New – Application in Microsoft Dynamics AX 2012 for Finance, PA, Case Mgmt., HRM and Public Sector Course Number 80164 What’s New – Technical in Microsoft Dynamics AX 2012 for Implementation Course Number 80165 What’s New – Application in Microsoft Dynamics AX 2012 for Supply Chain Management and Manufacturing Course Number 80163 What’s New – Technical in Microsoft Dynamics AX 2012 for Development Course Number 80299 What’s New – Local Functionality in Microsoft Dynamics AX 2012
Easy Extended AX Table-Browser
During implementations and regular developments in AX, I observed that many consultants/developers open the tables from AOT in the Table-Browser and by hand attempt to add/delete the records by hitting Ctrl+N/Alt+F9 keys and often copies the records from the table-browser and paste them to excel for checking/saving/printing/… the table data. The distress of manually copying/pasting of records and recalling the control-keys can be avoided by simply extending the Table-Browser by adding the Standard data Toolbar to the form Step-1: Go to the AOT and select FormsSysTableBrowserDesignsDesign and then change the design property WindowType value from “Popup” to “Standard” Fig1: Changing WindowType property value to “Standard” Step-2: Save and compile the SysTableBrowser Form after changing the WindowType property value Fig2: The original Table-Browser (WindowType property is “Popup”) Fig3: Easy Extened Table-Browser with Standard-Toolbar (WindowType property is “Standard”)
Document management directory issue in AX
Question: When using document handling in AX 2009, there are 3 options: note, file, and document. While using any one of the options I am getting the following error; “Document management directory does not exist”. Answer: Check the Document Management directory by navigating to Basic > Setup > Document management > Document types form, on the General tab in the archive directory field ensure that the path is correct as the system appears to be trying to save the document but cannot find it.
Microsoft Dynamics AX Financial Videos
Enjoy the comprehensive videos over Microsoft Dynamics AX financials from here