Making payments in Dynamics GP is pretty easy and interacts nicely with the Bank Reconciliation module. This is true for payments made via EFT and paper check. However, organizations who make payments using credit cards often have to do a bit of a work around in order to get these transactions handled correctly within the system. This makes reconciling painful… even though using the CC makes things easier on the front side.
Posted by Jonathan Crowell
What happened to Microsoft Dynamics CRM?
Nothing... sort of.
Posted by George Delp
Wow. That is a lot to take in. If you have questions about any part of this, you are not alone. This is the largest shake up in the Microsoft Dynamics world in years, if not ever. Let’s look at each of these items one by one and by the time we are done you should have a solid understanding of what these new offerings do and their intended target markets.
On a recent screen share with a client, we discovered script errors when the client was trying to open the payables document inquiry window. The message the client was receiving was below:
Unhandled script exception:
Index 0 of array 'PM Transaction Abbreviation' is out of range in
script 'PM_Transaction_Inquiry_Scroll_FILL'. Script Terminated.
The message appeared twice before disappearing and the records appeared in the window. When they did, I noticed two blank historical records showing up in the first two lines. There were two broken records in the PM00400 table of GP.
Here are the steps I took to fix this. Before you start, make sure you take a backup of your company database in question.
In my previous blog, I discussed the purpose and advantage of Microsoft Dynamics GP Refreshable Excel Reporting. The benefits of these reports are amazing and security is easy and simple.
Due to the fact that these reports can be used across a company domain, the security to the reports are granted in SQL Server Management Studio. Below are the steps to grant access to your users. User security will follow the same role logic as Microsoft Dynamics GP basic roles, which is shown below. The following steps should be followed once Microsoft Dynamics Excel Reports are deployed.
If you are like most accounting staff, you spend a lot of your time running reports, exporting, and emailing data out of Great Plains to your non-GP users. Many users also spend time exporting SmartList data as well. Microsoft has come up with an amazing solution, which requires no additional user licensing in Great Plains: Excel Reporting.
Have you ever been setting up Sales Order Processing in Microsoft Dynamics GP and come across a message during the transaction entry that says there is no price set up for the item price list? I've seen this happen a million times when assisting clients with the set up.
But guess what?! There's an easy fix.
Posted by Chelsea Schlepp
This isn't a new feature in Microsoft Dynamics GP. In fact, these basic customization have been around for some time. However, for new users or users that may not know about them, they can be a big time saver and enhance your user experience - I know they have for me!
Posted by Shawn Dorward
Throughout the years, Business Intelligence has been a term that has grown in popularity, and for good reason. “Good Data in” MUST mean “Good data out”! We come up with intuitive and efficient ways to get data into our ERP, but often struggle getting the data out. Business Intelligence, up until recently, relied heavily on the individual who created the reports but much like those flip phones, those times are behind us.
Posted by Tyler Boswell
Management Reporter is nearing the end of its development cycle. The most recent cumulative update (CU15) will be the last update released by Microsoft. They will continue to support it, but it won’t be getting any new features or enhancements. For the most part users are upgrading from older versions of Management Reporter to the new CU15 version, which is going well. However, what if you are new to Management Reporter? What if you have decided to get GP 2016 and wish to also implement the newest version of Microsoft’s ERP reporting software as a fresh install? As of this moment, you may have a tough time. When going through the steps of deploying Management Reporter as a fresh install you will come to the point where you need to set up the Dynamics GP Connection Information. This step is what creates the connection from your Management Reporter database to your DYNAMICS database. Normally you would enter SQL credentials to connect to your SQL instance and select the DYNAMICS database from the drop down. However, that does not work as intended in this new environment. You will instead see this error message “Couldn’t retrieve the list of available databases: The connection attempt failed.”