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


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

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