Mgmt. Reporter & Reporting Ledgers

This will be short and sweet. Management Reporter only supports Dynamics GP Reporting Ledgers feature if you are using the Data Mart connector.

I was working with a client on some new reports and was just about to recommend using the Reporting Ledgers in GP to record some IFRS adjusting entries. Good thing I did some testing first!

Mgmt. Reporter Quirk – unposted entries

I have been working with a client recently where the focus is to minimize any manual reporting in Excel and use Management Reporter more, to the extent that they are able to leverage it. They are using Dynamics GP 2013 R2 and of course, Management Reporter (MR) comes with Dynamics GP so it’s theoretically “free”.  It is hard to argue against using a product that comes with your ERP solution right?  Realistically now I see it as a good stepping stone to, perhaps, ultimately a more robust reporting tool in the future.

In this part of the project, the client is booking entries to “last year” (a closed year) to record opening IFRS balance sheet adjustments that they have been doing manually in Excel to produce IFRS statements.  They are also now using an “elimination” company in Dynamics GP to hold entries they don’t want to really book in production, like consolidation entries between their entities, and the odd IFRS reclassification they don’t want permanently in production just for the sake of financial statement presentation.

If the client was using FRx, everything I’ve been trying to do, based on what I have done in the past, would be easy to do and it would be relatively smooth sailing. I was a loyal FRx proponent for years and as much as that product had some warts, my memories of it grow fonder with every day I work with Management Reporter so far.  It’s that frustrating at times.