Have you even been working in Dynamics GP and encountered the “Scrolling window link table not on form ERROR” combined with the Unhandled Script Exception Error related to an illegal address User ID? Some Background The reason why the errors occur is there are actually some older c-tree based calls made where code is trying … Read more
Download the PDF with instructions to learn time-saving ways to duplicate format changes to your other reports, historical versions of reports, and documents in Dynamics GP. There are a couple variations on how to do this, depending if you are using the Dynamics Report Writer or Word Templates.
Which Window Do I Need? Determining which window needs to be added to a user’s security in Microsoft Dynamics GP can be difficult. Here are a couple methods we use to figure it out. Winthrop Tool There used to be a free product called the Support Debugging Tool; however, this no longer the case, it’s … Read more
A client recently encountered an issue where the eConnect integration he was using out of SQL stopped working. He received the following error despite of several attempts to repair: “There was no endpoint listening at net.pipe://localhost/Microsoft/Dynamics/GP/eConnect/EntityOperations that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if … Read more
Frequently, our Support Team at Crestwood gets calls where a new Integration Manager (IM) user can only see a “sample” of the integrations they are expecting to see. They don’t see all or the correct integrations that have been created and are used in production. Why? This happens because the IM system default install points … Read more
Many of our clients like to export their Microsoft Dynamics GP SmartLists to Excel. Why? In Excel, you can easily add things like: Summary Totals Pivot Tables Charts And more However, it can become a tedious and time-consuming process if you export many SmartLists. How to Automate your exports Wouldn’t it be nice if you … Read more
There is no MTS object context (Exception from HRESULT: XXXXXXX) We have a client using eConnect to integrate truck and transportation related billing data into Dynamics GP 2013. When they added a version of eConnect to a second machine to run the integrations, they ran into some issues. After setting up the service and checking … Read more
Has your MR database gotten so big it’s out of hand? I recently encountered issues relating to the excessively large size of Management Reporter (MR). So, I wanted to remind everyone of the importance of maintenance of your MR system, and associated data sets. Here are my recommendations for MR maintenance: Have a current backup … Read more
There are many instances when you need to prevent users from logging into Microsoft Dynamics GP. For example, File maintenance Year-end close No problem. Dynamics GP comes with a tool to take your company offline, which prevents users from logging in. Here’s how: Log into Dynamics GP as ‘sa’ Navigate to Administration / Utilities / … Read more
Have you ever worked in Dynamics GP and encountered the “FP: Couldn’t Close Table!” or “Open Operations on File” errors when trying to close out of Dynamics GP? Why might this happen? The reason why these errors occur is usually that something is “interrupting” a process assigned to your machine as it closes (or at … Read more
I recently got a call from a client asking how to associate the Euro currency symbol € in their Dynamics SL system. When using the Dynamics SL currency manager module, you can add additional currency symbols in the Currency Maintenance window. Here’s how: First, you need to start by copying the Euro symbol from the … Read more
Microsoft Dynamics SL allows you to customize buttons on the toolbar. One of the most useful addition is to add the currency symbol. One thing to note, if you’re not using currency manager, the button will be greyed out or inactive. Here’s how: Create a folder called currency in Microsoft Dynamics\SL\Application. Place the icon file … Read more
Have you ever run into this in Microsoft Dynamics SL? You created a Voucher and Adjustment Entry (03.010.00) batch and the batch will not release. So, you look at the event log and find there’s a message indicating the batch is out of balance but it provides no further information. Ugh, what do you do? … Read more
Creating a New Report Template from an Existing Template and How-to Delete a Report Template In Microsoft Dynamics SL, report templates are valuable time-saving features. We use report templates as a starting tool when creating similar type of reports. That way, we can reuse our parameters to run reports. Here are a couple time-saving tips! … Read more
There are times you might need to change the number of decimal places for inventory items in Microsoft Dynamics GP Manufacturing. For example: Items might have been set up incorrectly You might have started purchasing a product from a different supplier, or international supplier and with the currency exchange rates, you want to track 3 … Read more
Every year, our support team comes across this question: How do I change the Account Number Length in Microsoft Dynamics GP? It might be that your chart of accounts no longer fits your company’s reporting objectives or suites your needs. Whatever the reason, here’s a handy step-by-step guide on how to properly increase the account … Read more
In Microsoft Dynamics SL, employee benefits are defined in the Benefit Maintenance (02.340.00) screen. The field ‘Year Type’ is used to determine when a benefit will be reset or roll over. Here’s an example and explanation of how to reset benefits for the next year. You have two options in the Year Type field: Employee … Read more
Have you ever encountered the following in Microsoft Dynamics SL? You are running Order Management in Dynamics SL You have AR or Inventory batches that are voided but appear to have data in them. You are missing AR invoices or Inventory transactions. The most common cause for this issue is that the Sales Journal Processes … Read more
Error I was installing Management Reporter 2012 CU15 and got the following error: “Management Reporter Setup has ended prematurely” or it might state .NET 4.6 is not installed. Resolution: The fix is to run the Windows Server updates to update the server. This will then allow you to install Management Reporter successfully. The update that … Read more
Recently, our support team helped a Crestwood customer set up some new SmartLists using SmartList Designer in Microsoft Dynamics GP. We created this handy, how-to and wanted to share. Here’s how: Open SmartList (click the Dynamics GP button and then click SmartList) Click the New button at the top left of the SmartList window. Type … Read more
Technology is constantly evolving. With each new version of Dynamics there are improvements, more efficiencies, and new features. Sometimes, there are additional new modules available. But in order to justify the time and effort and expense of an upgrade, you need to make sure the benefits of the latest and greatest are worth it. The … Read more