Blog

nolock hint

Instead of setting the transaction level in SQL for seeing uncommitted transactions you can now use the nolock hint as in the sql statement below:select * from PROJTABLE (nolock) order by RECID descif you have many tables in the query:-- Get the funding limit tracking records by project IDselect T8.AccountingDistribution, T1.ProjectAccountingDistribution, T1.RecId as ProjFundingLimitTrackingRecId,...

Microsoft Dynamics Ax7 quick notes from 2016 technical conference

Release to web version shipped on 23rd February 2016 (7.0.1265.3015)Web client supported on any device and any browser10 customers already running Ax7 liveWorldwide localization will be available from fall 2016Full compilation takes around 8 minutes, this includes 4 min for cross - referencesData upgrade from previous versions still not available, will be ready around fall 2016No code upgrade hist...

Good way of commenting code

It is important to comment code in such a way that will be possible later to identify the exact changes therefore we can easily merge code when applying hot fixes or installing new solutions.See the example below:...

Work with excel documents on the server side in Dynamics Ax

As you probably noticed, the SysExcel classes in Dynamics Ax only work on the client side. Therefore, if you use these classes in a service or in a batch process you will get an error. In order to overcome this problem you will need to create a custom .DLL.Creating a .DLL sounds simple, but you could encounter different configuration issues on your server, so these are the steps I have done that m...

Back to Blog

© 2019 Dynaxti, inc. All rights reserved.

Navigation

Social Media