We have installed Management Reporter 2 SP2 and testing the reports migrated from FRX (Dynamics SL). It appears that the Management Reporter does not render the information correctly if period in the column format is 1:3 or 4:6 etc.
E.g. of a column
Column Type: FD
Book Code: 001
Fiscal Year: BASE
Period: 1:3
Periods Covered: PERIODIC
Has anyone encountered this issue, is there a hot fix or SQL script to run with Management Reporter to correct this?
Asoka
*This post is locked for comments
I have downloaded and installed the latest SP for Management Reporter and it didn't seem to solve Issue #2 above...can anyone confirm yes or no? I'm on the latest SP of Dynamics GP.
Thanks!
I found bug 24008 has to do with ranges of periods in the Dynamics SL data provider. This bug was fixed in Management Reporter 2012. Upgrading to the new release should resolve this error.
23940 that John mentions has also been fixed.
Thanks
Ryan
There are a couple of bugs in MR that affect the creation of a YTD Cash Flow Statement, or the ability to report on YTD Activity using the "1 TO BASE" functionality.
1) Bug #23940 - The beginning balance for an account with a normal credit balance has the sign reversed
In the tried & true YTD Cash Flow Statement from the old FRx demo reports, and from the MR demo reports, the YTD calculation would typically involve pulling the YTD Beg. Balance, then the YTD Balance for the Base Period, hiding those columns but then doing the math on those two columns to compute the YTD Activity. However, as the description above indicates, accounts with a normal credit balance (in this case, Liability & Equity accounts on my Cash Flow) do not appear properly in the YTD Beg. Balance column. The signs are incorrectly reversed. Only for "normal credit balance" accounts, and only in the YTD Beg Balance column.
2) The 2nd bug (I don't have a number for it) relates to pulling YTD Activity into a single column using the "1:BASE" and "PERIODIC" elements (formerly "1 TO BASE" and "CUR" in FRx). It don't work. It only pulls the base period, not all period up thru BASE as it should.
After discovering the problem in #1 above, I was hoping to do a work-around by using the "1:BASE"/"PERIODIC" functionality in #2 above, but MBS told me they already know that's a bug. So, my next option was to load individual columns for each period, N-P them and then add them together to get the YTD Activity.
MBS is hoping to have these issues corrected in the next release of MR. This was as of March 14, 2012.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (