Dear Friends,
This is a test job I wrote a few weeks ago to list out my custom security policies, roles and queries associated with it into a table. Hope someone finds it useful.
Greetings! Welcome to my Dynamics AX 7 and related MS Technologies blog.
Thursday, September 19, 2013
EOMONTH function in SQL Server 2012
Dear Friends,
A few weeks ago, I was writing some stored procs in SQL Server and I found this EOMONTH function handy.
This is a new function in SQL Server 2012
EOMONTH function takes a date argument/parameter and returns the last day of that month.
Quite handy.
Please refer to this technet article below for detailed syntax and some examples
http://technet.microsoft.com/en-us/library/hh213020.aspx
And if you would like to know how to achieve this in previous versions of SQL, have a look at the below link.
http://www.sql-server-helper.com/tips/tip-of-the-day.aspx?tkey=49ffa5c2-03a3-4888-aac2-a80320f2faf4&tkw=last-day-of-the-month-function
Btw, in AX, we have an equivalent dateEndMth function in Global class for the above purpose.
Happy Querying :)
Top 10 issues discovered from Microsoft Dynamics AX 2012 implementations
Greetings!
Dear Friends, Would highly recommend you to bookmark the below useful link:
Below are top 10 practical tips from MSDN blogs (from the field) which talks about some handy tips for your AX 2012 implementations!
http://blogs.msdn.com/b/axinthefield/archive/2013/06/18/top-10-issues-discovered-from-premier-field-engineer-dynamics-ax-health-check.aspx?CommentPosted=true#commentmessage
Good work!
Dear Friends, Would highly recommend you to bookmark the below useful link:
Below are top 10 practical tips from MSDN blogs (from the field) which talks about some handy tips for your AX 2012 implementations!
http://blogs.msdn.com/b/axinthefield/archive/2013/06/18/top-10-issues-discovered-from-premier-field-engineer-dynamics-ax-health-check.aspx?CommentPosted=true#commentmessage
Good work!
AIF Tip - Troubleshooting custom Dynamics AX 2012 AIF Services
Greetings Friends!
It's been a while since I have posted. Have been very busy with work. Thought to do a quick post on how important is to Generate CIL in AX 2012 which I tend to forget often as this was not required in the previous versions of AX!
Scenario
1. Create a new AIF Service
2. Generate and Deploy it
3. Consume .net code
4. Make modifications to the AIF Service
5. Update the AIF Service
.Net code still cant understand the modifications made to AXDClass e.g. updatenow method, hence the old logic is still used the new logic implemented in updateNow method never gets invoked.
Solution
Run Generate Icremental/Full CIL from System Administration > Periodic > Compile into .Net Framework CIL
It's been a while since I have posted. Have been very busy with work. Thought to do a quick post on how important is to Generate CIL in AX 2012 which I tend to forget often as this was not required in the previous versions of AX!
Scenario
1. Create a new AIF Service
2. Generate and Deploy it
3. Consume .net code
4. Make modifications to the AIF Service
5. Update the AIF Service
.Net code still cant understand the modifications made to AXDClass e.g. updatenow method, hence the old logic is still used the new logic implemented in updateNow method never gets invoked.
Solution
Run Generate Icremental/Full CIL from System Administration > Periodic > Compile into .Net Framework CIL