3761

This is nothing to do specifically with Dynamics AX 🙂 but this is something that caught my attention and I decided to try it out and share it and this can definitely be used in an AX environment to conduct a health & BP check on the AX SQL Database. The SQL Server team has released the SQL Server 2008 R2 Best Practices Analyzer (BPA) tool. BPA is designed for administrators who want to determine the overall conformance of their SQL Server instances and topology with established best practices. BPA examines your SQL Server instance for system events, reviews login … Continue reading SQL Server 2008 R2 Best Practices Analyzer (BPA)

Recently the technology landscape is going rapid changes. New products/ releases like VS2010, SQL 2008 R2, Office 2010 Suite etc have changed the technology scenario a lot. All these have opened up tremendous opportunities for the developer as well as the customer. Its really an amazing time to be in technology :-). I was present for the India VS 2010 Launch and immediately dived in :-). One of my task was to evaluate TFS for our AX projects. As we had been using TFS 2008, it was an interesting R&D to see if this worked with TFS 2010. Installation of … Continue reading TFS 2010 and Dynamics AX 2009 VCS

I’ve ofter observed that during implementations where there are multiple environments it becomes difficult to identify which environment a form belongs to especially when there are multiple forms open form different environments (Live, Test, Prod, Training etc). I made a very simple tweak which highlights which environment a form belongs to. Very similar to the AX 2008 Workflow band. This was successfully tested in AX 3.0, AX 4.0 and AX 2009. Its really very simple and effective. See screenshot below. The XPO is attached below. This XPO is for AX 2009 SP1 and the SysSetupFormRun class was modified. Happy DAX-ing

I was working on an AX CRM implementation where the need for social networking & company profiling came. Requirement was that BD people should have access to social networking information, stock informations for applicable Business relations which would help them do a profiling of the BR. With the widespread use of social networking like twitter, linkedIn etc, some feature need to be inside AX. Well I like such challenges and did a small POC to show stock information inside AX. Integration to LinkedIn is in WIP :-). I added a flag in BR for the BR the sales people wanted … Continue reading Company Profile, Social networking inside Dynamics AX 2009

Recently I was working on a POC which required me to insert 1,00,000 records into AX 2009 from an external LOB application and post these lines in AX. Well that got me thinking since it was a huge amount of import. .NET BC would be very slow, excel import would not be feasible. Direct SQL inserts seemed to be the feasible solution but I had to deal with RecId, RecVersionId & Company. Well after much R&D I hit upon using SSIS and some custom scripts to get the data inside AX. My test environment was: Environment: WIN 2008 Enterprise 32 … Continue reading Dynamics AX 2009 Bulk Data insert using SSIS

An interesting post by a fellow MVP Michael Nemtsev [MVP, Web Developer and SharePoint Consultant based in Sydney, Australia.] regarding MOSS 2007 & WIN 2008 R2. Definitely a reference if you want to install & configure EP on WIN 2008 R2.Click here to read.

All of you are aware that Standard AX does not carry out any validations on EMail addresses and URL’s present in the contact details of BR/Cust/vend etc. However sometimes it becomes necessary to validate EMail addresses when they are entered in AX [DirECommunicationAddress] table. I was involved in a AX CRM implementation where it was required to validate email id’s of contacts, BR when they are entered. Well if you consider the email validation piece, there are 2 parts:1. Check if the EMail address is well formed 2. Check whether the well formed EMail id is valid. For checking well … Continue reading AX Email & URL Validation

I was just playing around with Outlook and AX trying to see see if the Role centre could be got into outlook as a default homepage. Well the simple way is to add the EP link as the defailt homepage , but it didnt look to good , with the menu etc. However if you append ‘&RUNONCLIENT=1’ at the end on the EP RC URL, the menu’s get chopped off and you see the Role centre real cool. Say if the URL is ‘http://arijit:150/sites/DynamicsAx/Enterprise%20Portal/RoleCenterCEO.aspx?WCMP=CEU’ then append ‘&RUNONCLIENT=1‘ at the end of the url [http://arijit:150/sites/DynamicsAx/Enterprise%20Portal/RoleCenterCEO.aspx?WCMP=CEU&RUNONCLIENT=1] and the heads of the MOSS/WSS … Continue reading AX EP Role Centre inside Outlook [Short n Sweet :)]

After a few hitches I’ve managed finally to get the IDMF started up and running and the results are pretty nice. One prerequisite is that you must have XRef done on your DB (Production :-(). Also during the post install steps watch out for the windows application log coz that goes full and you have to clean it up. However after you complete the post install steps and have executed the batches, the results are nice. To avoid the XRef* tables occupy the top tables in terms of rows and size, do not run the full XRef, just XRef the … Continue reading AX Intelligent Data Management Tool : Inside look

A small example of Dynamics AX 2009 , OBA, .NET BC & Web Services (AIF). I found this OBA & WCF thing pretty interesting and did a simple demo which enables a developer to use VSTO to customize Excel which connects to AX 2009 using 2 ways (.NET BC & AIF WS) and retreives the customer list and populates the excel sheet. A very simple example with great potential. Basically the demo consists of customizing the Ribbon in Excel 2007, adding buttons which fetches the customer master from AX 2009 using .NET BC & AIF WS. The sample code (VS … Continue reading AX 2009 & Office Business Applications [OBA]