Today’s #TipTuesday I *swear* I’ve blogged about before but for the life of me, I cannot find it in my posts. So… I’m documenting it here because I ran into this again after our latest Dynamics GP upgrade and had to search for my own documentation to find the details of the fix.
This tip is on how to remove the “day of the week” name from the date format on Management Reporter (MR) reports, if using the @datelong autotext code.
Continue reading “Getting rid of Day in Mgmt. Reporter date format”
I’m just catching up on my “to blog” folder and finding a few Dynamics GP or Management Reporter topics that I intended to write about a few months ago. This is another one that actually may end up being more than one post, as I think there are multiple “quirks” going on here.
This one just doesn’t make sense to me and describing it to someone on the Microsoft Partner Technical forums, they said it should work based on how I described it but they cannot reproduce the issue. This is all based on CU14, Mgmt. Reporter 2012 for the record.
Continue reading “Mgmt. Reporter Quirk – Tree Filters & Unit Restrictions”
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!
Continue reading “Mgmt. Reporter & Reporting Ledgers”
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.
Continue reading “Mgmt. Reporter Quirk – unposted entries”