Troubleshooting Dynamics AX incorrect cost posted on Partial Project Purchase Orders

Issue:

We had an issue where Partial Purchase Orders (Project) was not posting proper cost amount to the Project accounts.

Solution:

Microsoft has identified this behaviour as a bug - http://support.microsoft.com/kb/937246.

Note, the hotfix was in form of dis<layer>.aod file. I extracted the .aod file and merged it on the local AX instance running on my laptop, identified the classes which is required for the above fix, Did a compare and imported only the code which fixes the issue.

Just a FYI on the classes which were impacted:

              \Classes\InventMovement

\Classes\InventMov_Virtuel

\Classes\InventUpd_Estimated

SSRS Format Date tips

Hi there!

Recently, I was working on a SSRS Report wherein I need to use the Format function of SSRS for date formatting.

e.g. Format(Parameters!Date.Value,"dd-MM-yyyy")

Note here, if you use "mm" (lowercase), then it won't produce the proper results, as it's case sensitive and we need to pass "MM" (uppercase)

I found the below link useful which describes more on Format function in SSRS - (A good read)
http://thavash.wordpress.com/2007/04/10/working-with-dates-in-reporting-services/

World Vision Implementing Microsoft Dynamics AX

Another feather in cap, for Microsoft Dynamics AX :).. Read more here...

http://www.microsoft.com/casestudies/Microsoft-Dynamics-AX/World-Vision-International/Humanitarian-Group-Enhances-Children-s-Lives-with-Advanced-Supply-Chain-Management/710000001227

SQL Server CTEs and Recursive Parent Grouping in Advanced Mode Group Properties in SSRS

Hello!

Few weeks ago, I was developing an interesting report in SSRS which pulls out data from AX - Projects module.

It was interesting for 2 reasons:

1. I learned to use more effectively SQL Server CTE's (Common table expressions) while developing this report.

From a layman's perspective, CTEs were introduced since SQL Server 2005 and it’s more useful to do a recursive search (display hierarchical data e.g. employee-manager, BOM etc). In my scenario, I had to do a recursive search for Project-Parent Id in my Stored proc)

Below sharing some links, which will explain further more in detail about CTE's and how to implement them.

http://msdn.microsoft.com/en-us/library/ms186243(v=sql.105).aspx

http://msdn.microsoft.com/en-us/magazine/cc794278.aspx

2.  The second concept was about recursive parent Grouping (in SSRS)

In SSRS, we can group the child field based on the recursive parent key (There’s an option in the Edit Group > Advanced Section to key in the Recursive parent field) – explained here in this blog - http://sql-bi-dev.blogspot.com.au/2010/08/recursive-hierarchy-group-in-ssrs-2008.html

Quick Tip - Saving Macro enabled worksheet (Excel 2010)

Have been playing around with VBA coding these days (with Excel 2010) as we are building a Budget Template to capture Budgets for various projects and then consolidate it into one excel workbook so that it can be imported into AX.

VB and VBA has been one of my favorite languages since I started programming back in 2000. I still love to work in VB editor if i get a chance and one of my first project was building a Review Toolbar using VBA (Word Macros), Very interesting then :)

Now after 10 years, there has been quite some changes with the way macros are handled especially with Excel based macros. In Excel 2010, if you want to save a sheet/workbook then while saving you have to use the "Excel Macro Enabled Worksheet" rather than the default Excel option.

Below Link helped me To save macros http://www.dummies.com/how-to/content/saving-and-using-an-excel-2010-macroenabled-workbo.html