Wednesday, August 15, 2012

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/