18
Hi,
If I print a summary or detail GL trial balance in GP, my balances are correct. When I print a balance sheet in Management Reporter, the balances are not correct. My row format is set to just pull the natural accounts. What maintenance can I do to get the balances correct? My client is using MR 2.1.1032.3
Thanks.
*This post is locked for comments
Hmmm... I found this:
www.uxceclipse.ca/how-to-rebuild-datamart-ddm-for-management-reporter-2012-in-microsoft-dynamics-erp
Rater cumbersome process to force the Datamart to refresh itself; it is actually not really a rebuild process but a destroy and restart...
Hopefulle there's a cleaner approach...
Hello TLC1967,
how do you proceed to Rebuild the DDM Database?
Thanks
Rebuilding the DDM Database did the trick and removed the duplicates in our Management Reporter. We were a new rollout, so I can only assume that the DDM was not rebuilt after our test system.
Thanks for the detailed steps! Worked like a charm and I got to look like the hero.
I have a related error situation. Our client has GP2013 and has been successfully printing MR Financial statements for a few months. They accidentally posted an AP transaction into the wrong period. We opened the period and voided the transaction. The transactional level MR report shows correctly. But the subtotal of the transactions is not the accurate on the MR report..
Good afternoon,
I just encountered this same issue and figured I would update this blog with my findings. I did the usual troubleshooting stuff...
1. Verified that I am on MR 2012 RU 5 -- 2.1.1037.15
2. Checked for NULL records in GP for the Budget, Account Number, Category, User Defined Fields, etc.
3. Verified that my company had a functional currency and that the Currencies were setup with ISO codes
4. Checked all my building blocks for accuracy.
In this case, since I was finding that for some of my accounts, I was missing the January 2013 and any post April 2013 transactions, I created a row layout with 4 of those accounts and a column definition with a DESC, a Beg of Year column, 12 periodic columns (one for each period 1 - 12), a CALC column adding those columns and a FD column with YTD. I used the P<=BASE column restriction for the 12 Periodic columns.
When I ran the report, the January column was blank as well as my May - July columns, but the other columns had the correct figures. Not good...
5. Since my customer has multiple SQL instances for Prod and Dev, I also verified that the DDM was connected to the correct SQL Server in the Management Reporter 2012 Configuration Console.
6. Checked the Data Mart Integration logs and Service logs for any errors... none noted.
7. Since all the above checked out, I recreated the DDM database.... THIS WAS THE MAGIC TICKET.
7a. Make sure no one is logged into Management Reporter Designer
7b. From the MR 2012 Configuration Console, Select the ERP integration for your DDM.
7c. Click on the Disable Integration Button
7d. Click on the Remove Link on the upper right of the window
7e. Stop the MR 2012 Application and Process Services from the main MR 2012 Services window in the Configuration Console
7f. Log out of the MR 2012 Configuration Console
7f. Log into SQL Management Studio and delete the DDM database
7g. Log back into the MR 2012 Configuration Console and start both services
7h. Go to File > Configure and choose to Add the Microsoft Dynamics GP Data Mart and follow the prompts.
7i. Enable the Datamart integration and wait for that to finish
7j. Log into Report Designer and verify that you are pulling from the correct Building Block for your company(ies)
7k. Test your reports.
Rebuilding the Data Mart fixed it for us. I believe in our case, it was because we were in a test environment and the GP databases were refreshed. We needed to also refresh our DDM.
first time running management reporter against a new company set up in GP. New install of GP. December 2011 holds the opening trial balance.
Jan - March have transactions.
I have set up a balance sheet for:
December January February March March YTD
Fiscal Year Base -1 (i.e. 2012) Base Base Base
Period 12 Base -2 Base -1 Base
Periods Covered YTD Periodic Periodic Periodic
Formula B+C+D+E (i.e. Dec + Jan + Feb + Mar)
I have tried to run the report with both posted and unposted transactions turned on and get the same result as reported by Linda, the balance calculated is not the correct balance.
I have now ran with Financial Account and Transaction. Reviewing the 167 pages of one of the lines that is calculating incorrectly and I find that where the report sub totals January it shows the correct amount. Where the report shows the final totals for all periods the total for January is different.
Sadly in our case the solution Linda offers of running the report with both posted and unposted turned on did not fix the report.
Any other thoughts or solutions would be greatly appreciated!
Figured it out - it is a known issue with MR where you must chose Provisional - both Posted and Unposted. Silly. Thanks.
Okay, back to basics, how long have you been using Management Reporter, have you looked at your dimensions and are the dimensions in the right segments. Did you just convert from FRx. Are the companies setup correctly and pointing at the right databases (go to the SQL console for MR and take a look). Can you go in and create a TB so that you are doing 1*, 2*, 3* as your account dimensions for (Assets, Liabilities and OE) if your accounts start with 1, 2, 3 for each of those and then setup a basic column. Then run against one company and can you get the right numbers. Has MR ever worked properly?
I've tried both Periodic and YTD. Both are wrong - just pulling bizarre numbers. I've even tried pulling a monthly column for the whole year side-by-side.
Linda, are you pulling the period balances or the YTD. I know I just ran into this when I was training someone and they were pulling period balances (sum or db and cr for the period) as opposed to the YTD balances. Check you column setup
Share
Report
All responses (
Answers (
