Skip to main content

Posts

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 \Forms\SysTableBrowser\Designs\Design 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 “...

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.

6 steps to take backup of all the objects from 'user' layer

While working on client side with lot of customizations, someone must take the backup of all the changes which already have done in an application. A very short way of taking backup from a selected layer is as follows; 1. Create a new project and open it. 2. Click on the Advance filter/Sort for this project, it will open the following screen Note: Make sure the above options should be selected for this scenario. 3. Click on ‘Select’ button. 4. Remove all the ranges from this query form and add only one range. The form will now looks like this; 5. Press OK, form will be closed 6. Press OK The new project will contains the entire objects, group by their consecutive groups.