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

Advertisements

Common Data Service (CDS) vs Azure SQL Database

CDS Azure SQL Database The main benefit of the CDS is that it's simple to use. Non-IT guys can use it very easily to design their database On the other hand, Azure SQL needs to be managed by someone who has knowledge of relational database and SQL Queries CDS tables can be designed through web-based … Continue reading Common Data Service (CDS) vs Azure SQL Database

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("https://d365_instance.api.crm.dynamics.com/api/data/v8.2") to OData.Feed("https://d365_instance.api.crm.dynamics.com/api/data/v8.2", null, [Implementation="2.0"])  

Solved – How to replace Data Source for existing report?

After development of Report or Dashboard from Development Server, we need to switch to the production data. To achieve this we will need to change the datasource of Power BI PBIX file. Here are the steps to do so In Power BI Desktop,  go to File -> Options and settings -> Data source settings. Select the … Continue reading Solved – How to replace Data Source for existing report?

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