Significant for GP 2013 and SL 2011, but heads up for AX 2012 users
Microsoft released Cumulative Update 7 for Management Reporter a week or so ago. Here’s what’s up:
- You can now Drill to Dynamics from the web viewer if you’re running AX 2012, GP 2013, or SL 2011.
- Currency translation for AX 2012 has arrived. AX does the translation and Management Reporter reports it. Here’s a Microsoft post on how to set up currency in AX.
- AX users can use the web viewer to view both functional and reporting currencies. There’s a new currency icon in the web viewer that will allow the user to switch currencies on the fly.
- AX users can specify the order for their dimensions in MR. They’ve been in alphabetical order(!), but now you can specify Main Account as the first dimension and see it first when either drilling down or while inserting accounts. Here’s how to enable this. In AX, go to GL, Setup, Financial Dimensions, choose Financial Dimension Configuration for Integrating Applications, and you’ll see the Management Reporter option. Use the list of dimensions to order them as you wish. This is a big usability improvement. I haven’t had a chance to test this Sort by Natural option to see how it impacts the new order, but suffice to say it might need to be unchecked.
- For AX, the Fixed Asset Acquisition Date has been added as an attribute.
Cheers! Jan
Sean Ralph says
Whoo Hooo! Looking forward to installing CU7. Lots of AX 2012 enhancements
Jan Harrigan CPA says
Hahahahaha!
Rachel says
Do you have much experience with currency translation in Microsoft AX 2012 and Management Reporter CU09? I have defined a rate type and told AX to use that rate type for all my accounts. When I pull the USD amounts into an MR report, ALL BUT ONE are accurate. The retained earnings is not being translated using the rate I have defined. I have no idea why its being treated differently when the settings are the same. I have tried setting a unique rate type for this account but it still translates at a different rate than what I specified. I’m at a loss and VERY frustrated.
Rachel says
I should specify, I ran the EXACT SAME report in MR but displayed euros and those are accurate for retained earnings. Only USD is wrong, and only for this one account.
Jan Lenoir Harrigan CPA says
Hi Rachel…nope, I’ve avoided currency. You might try either tech support or the AX Community forum…or both. Good luck! Jan
Rachel says
just an FYI for you all to save the headache I’ve got right now – apparently there was a bug in the way the older MR versions calculated the currency translation of retained earnings (a.k.a. it just plain calculated it WRONG) – the issue was not fixed until CU11, so if you are using currency translation, make sure you upgrade to at least that version
Rachel says
PS – the forum and support were no help, a third party was able to dig into the list of bug fixes from the CU11 release and found it for me – seems like this info ought to be more prominently displayed/known
Jan Lenoir Harrigan CPA says
Many thanks for the followup, Rachel!