During a recent upgrade to MR 2012, we received the error "The operation could not be completed because doing so would create a bad reference".

 

To resolve the issue, you need to follow the steps below;

 

1. Make a backup of the Management Reporter SQL database as it sits now. 2. Export your reports from MR (Company | Building Block Groups | Export) 3. Start the Management Reporter Configuration Console (it's slow) and use the links under the "Management Reporter Services" level to remove the application service and process service. 4. Close the Management Reporter Configuration Console and then uninstall "Microsoft Dynamics ERP Management Reporter 2012 Server" from Programs and Features in the Control Panel. 5. Use the Management Reporter installer to re-install the server components. 6. Start the Management Reporter Configuration Console and run through the integration again. Point at the same Management...

Great news GP users! As of March 1, 2012 Microsoft Dynamics has made the Professional Services Tools Library (PSTL) available at no additional charge. So what exactly does this mean? To help explain the free tools, I’ve listed each *series tool with a brief description: Read more...

After doing several upgrades to Management Reporter 2012 the past few weeks, we ran into one issue where we went to add an existing GP company and got the error below which reads "An error occurred while retrieving company information.  Verify that the specified credentials are valid.  Check the deployment log for details."



After doing some research, we noticed the upgrade to Management Reporter 2012 automatically added two sample companies, Film Works Demo and File Works Demo for Canada.  When it added these sample companies, the upgrade did not configure the GL Entity Connection in the ControlCompany table within the Management Reporter 2012 SQL database.  To resolve this issue, simply run the SQL statement below against the Managemet Reporter 2012 database.  You will need to change the first where code to a company that is configured correctly.

update



ControlCompany set GLEntityConnectionInformation =

...

Quick charts are a great way to graphically present data on your report or to use in a supporting role in your financial statement presentations. Read more...

Don’t just react to the many changes facing your business, take control and shape your future. Microsoft Dynamics GP 2013 delivers the tools and forward-looking insight your people need to work better, faster, and smarter to create new efficiency and drive the bottom-line impact that will turn your business vision into reality. Read more...

During Monday’s opening keynote session in Houston, Microsoft officially announced that the next version of GP will be Dynamics GP 2013 due for release calendar Q4 of 2012. This is not just a web client release – there are more than 150 new features to help GP-based organizations get down to business without over-burdening the IT person. Read more...

This is useful for anyone that has wanted to utilize the Subscriptions feature of SQL Reporting Services, but did not have access to a local SMTP server.  The blog entry below describes a way to get around this problem.  All of this can be achieved by using your own virtual SMTP server and setting up message relay with basic authentication to the remote SMTP server. Lets go through the steps below to achieve this. Read more...

Have you heard about the intuitive new features of Microsoft Dynamics GP 12? Here is a birds-eye-view of how GP 12 can smooth and enhance your business processes –saving you time, money and costly resources. Read more...

Project Accounting
In order to fix a couple bugs, there were a few changes made to the Benefit Allocation Window. These changes will be included in the Microsoft Dynamics GP 2010 release.

To help with your Fixed Assets year end close, here are a couple FAQ’s. If you still have questions, feel free to contact us.