Delete Batchjob History from SQL Server – AX2012 R3

Batch job history in AX2012 R3 is consuming too much space. Here is the script to delete old history records from database Use MicrosoftDynamicsAX declare @lastweek datetime declare @now datetime set @now = getdate() set @lastweek = dateadd(day,-7,@now) Delete from BATCHCONSTRAINTSHISTORY where BATCHCONSTRAINTSHISTORY.BATCHID in (select BATCHID from BATCHHISTORY BH join BATCHJOBHISTORY BJH on BH.BATCHJOBHISTORYID = … Continue reading Delete Batchjob History from SQL Server – AX2012 R3


Dynamics 365 v9 with Power BI

Recently my old Power BI reports stopped working when the Dynamics CRM (Dynamics 365) was updated to v9.0 and Power BI was updated in July 2018. Power BI has released some changes in OData endpoint connectivity. The issue can be resolved by changing the connection from Advanced editor from OData.Feed("") to OData.Feed("", null, [Implementation="2.0"])  

Purchase Order Posting Dynamics AX 2012

I found this chart to help us remember what setup fields are used in packing slips and invoices when posting purchase orders in AX 2012 under the new accounting framework. I believe some of the posting complexity is due to accommodating Standard Costing in addition to other costing methods. In addition download the whitepaper from … Continue reading Purchase Order Posting Dynamics AX 2012

Update User Information after Restoring AX Database to a new environment

After restoring the Dynamics AX Database from one environment to another environment, where the domain name is different, you will not be able to log on to AX unless you have updated the SID and user information through SQL Query. Run the below mentioned query on the restored database. update userinfo set networkdomain = 'NEW-DOMAIN-NAME', networkalias … Continue reading Update User Information after Restoring AX Database to a new environment

The Dynamics CRM Connector – Features and Functions

Combining relational and transactional data in a meaningful way has long been one of the most daunting challenges companies face in providing relevant data to their users and customers alike. Now the Dynamics CRM Connector for AX, NAV and GP is opening new doors for combing relational and transactional information in a simple, effective way. … Continue reading The Dynamics CRM Connector – Features and Functions

Dynamics Ax 2009 SSRS report deployment under Windows Server 2008

If you get the following error in the deployment log file: Deployment failed with the following exception: System.Runtime.InteropServices.COMException (0×80040208) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObject.Initialize(Boolean getObject) at System.Management.ManagementBaseObject.get_Properties() at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName) at Microsoft.Dynamics.Framework.Deployment.Reports.SrsWmi.get_ConfigPath() at Microsoft.Dynamics.Framework.Deployment.Reports.ReportLibraryDeployer.DeployBusinessLogicAssemblies(IEnumerable`1 businessLogicAssemblies, DeploymentLogger logger) at Microsoft.Dynamics.Framework.Deployment.Reports.ReportLibraryDeployer.Deploy(IEnumerable`1 reportLibrariesToDeploy, IEnumerable`1 transitiveReferenceClosure, IEnumerable`1 cultures, DeploymentLogger logger, Func`2 connectionStringModifier) You just need to disable … Continue reading Dynamics Ax 2009 SSRS report deployment under Windows Server 2008

Dynamics AX 2009 Workflow Setup

Microsoft Dynamics AX 2009 WorkFlow can cause an error when setting up a workflow on Win2008R2. If you receive this error when you run Workflow infrastructure configuration wizard: The request failed with HTTP status 405: Method Not Allowed. Then you should change the Application pool for your workflow (which is by default MicrosoftDynamicsAXWorkflow50) to enable … Continue reading Dynamics AX 2009 Workflow Setup