delete partition in AX 2012 R2

Dec 21, 2013 by Dick Wenning Category: Uncategorized 0 comments

I EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PARTITION = 5637144828’ EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PARTITION = 5637144827’ EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PARTITION = 5637144829’ EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.DATAPARTITION = “ps”‘ EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete […]

Unretrieved values on the companyinfo Table in AX 2012R2.

In AX 2012 R2, table inheritance tables are all stored in the same table. So the Company Info table is on SQL level stored in the table DirPartyTable. They did this for performance reasons. But what happens when you insert a new Colom on that table. We get unretrieved values like below screen. Normal fields […]

Printing PDF documents

I had some trouble generated PDF in AX 2012 last months. The issue is A4 paper size, but also printing in landscape. I start looking in AX, Visual studio; everything was fine, but the PDF documents still suXX. On the end I found a solution in SSRS and it was working. So how did we […]

Security Privilege generator

Jun 27, 2013 by Dick Wenning Category: Uncategorized 0 comments

While upgrading AX 2009 solutions to AX 2012. I became tired of creating all those privileges. It was the same for every menu item; again and again; create a view and a maintain privilege. So for all those lazy developer out there, her it is, a privilege Builder. How it works, easy select right mouse […]

Replacement key in AX 2012

As we all know the default primary and cluster index in AX is the recid index. When we add a primary key based relation to a table we get a new column with the refrecid, an index for that column and a relation to the related table. There is nothing wrong with that. That is […]

Install enterprise portal on SharePoint 2013

It is an exciting day! Someone from MS Redmond (THANKS JARED, you are my  hero of the day!) told me to request KB2830441. It is SharePoint 2013 integration. So I requested it like an ordinary Partner and slipstreamed it an AX 2012R2 Installation. Next I started a brand new Windows 2012 server (Hyper V), added […]

Microsoft Dynamics AX Diagnostic Framework (Beta) tool

Today I have installed the Microsoft Dynamics AX Diagnostic Framework (Beta) tool and I would like to share my first impressions with you.  In simple terms it is a type of windows service, with a database and a web client. When installing the next prerequisite will pop up. I had to struggle a little with […]

Best practice checks.

When checking my Ax code, I always use best practice checks. Most of the time I perform this during the last 10 minutes of the day. I do not use compiler level 4 but I have to admit this has some issues. Most of these issues make sense, but some of them are contradictory or […]

security on your ques

Default Dynamics AX 2012 has a inhabit with cues on role centers. Would it not be great if on cue group with all cues needed for the business in it will fulfill on al role centers. In case you don’t have the rights on that cue, it will disappear? I think you like that.   Ques […]

Ax 2012 (R2) Labels

I see a lot of people having trouble with their labels in Dynamics AX. I will explain a little bit on how it works on the backend. The first thing you should know is that the label files are stored in the model. This is handy, but there is a catch.  Restarting the AOS service […]