Microsoft Dynamics GP – Management Reporter Issues

 

While trying to work on Management Reporter, I got the below error:

“The operation could not be completed due to a failure on the server.”

Followed several steps to investigate the issue, checked the functional currency and validated almost everything with no result, even searched the whole web with no result.

I finally decided to reinstall everything, uninstalled server, client, data provider and deleted the database then tried to reinstall, another issue came up:

“An error has occurred while implementing database on server, please refer to error log for more details.”

Error log detailed nothing about the issue, but when I tried to search the log about all database issues, I noticed that the management reporter being failed to grant database access to the domain Administrator user as it was already added.

Deleting the user from all databases and from the database logins level and reinstalling the application resolved the issue and the customer is currently enjoy reporting with management reporter!

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Advertisements

Undefined Symbol Errors When Upgrading from a version to another

 

This morning, a customer reported the following error while printing their checks remittances:

Undefined Symbol F01343D00789 Sequence Num

image

Last week I have upgraded this customer from Microsoft Dynamics GP Version 10.0 with Service Pack 4 to Microsoft Dynamics Version 2010 with Service Pack 1, when the customer sent me the package, I found that the package they sent is mapped to a table called “PM_Payment_WORK” while the original reports is mapped to “pmRemittanceTemp” then I figured out the reason behind this, this was due to the enhancements applied to this feature in GP 2010.

To resolve this, the hard way of doing this is by re-implementing the customizations on the original report. However there is always a workaround!

Below the steps I followed:

  1. I exported the report to a package file.
  2. I opened it using Notepad.
  3. Pressed CTRL+H to find and replaced PM_Payment_WORK to pmRemittanceTemp.
  4. Saved and imported the report.
  5. Regenerated the report and found 2 missing fields, replaced the missing fields with an alternative from the new table and it worked!

Enjoy fixing your reports without re-implementing your customizations!

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Management Reporter–Load Database is not loading my database?!?

 

I been in a situation were I have upgraded to GP 2010 and migrated FRx to Management Reporter, during the installation I wanted to configure my company and setup the Dynamics GP data provider.

I filled all fields in the form several time to make sure that I used the correct information and pressed “Load Databases” a dozen of times with no luck!

image

I ran profiler to get a clarification with no luck, then did an internet research that resulted in to the below article answered by Cory Severson from MS support team:

http://community.dynamics.com/product/gp/f/32/p/46091/84925.aspx

It was the Dynamics database name, the name at the customer SQL was “Dynamics” it should all be in caps “DYNAMICS”  Smile

Enjoy.

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Adding Vertical Lines To FRx Report

Interesting article by Amy Walsh, he explained how to add vertical lines into FRx, checkout his article here.

Regards,

Mohammad R. Daoud – CTO
MVP, MCT, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Checkbook Transactions Using SQL Query

Interesting article by Victoria Yudin, she displayed the Checkbook Register using SQL view, find her article here.

Regards,

Mohammad R. Daoud – CTO
MVP, MCT, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Print Multiple Reports

Interesting article by Blinda, the GP CSI! She explained how to combine multiple reports into report groups and print it once, checkout her article here.

Regards,

Mohammad R. Daoud – CTO
MVP, MCT, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Fixed Assets History View

Omar Kloub posted an interesting script that views the history of the fixed assets depreciations, he’s displaying (Asset ID , Asset Description , Year , Period , Depreciation General Journal Number , General Journal Date , Vendor ID , Vendor Name (If the asset was purchased of course) . Purchase document number ,..etc)  in his view, find out his interesting article here.

Regards,

Mohammad R. Daoud – CTO
MVP, MCT, MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com