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
Many businesses use Excel templates to create their annual budgets. By creating a budget template in Excel, you’ll save yourself time. Just populate the monthly data by the general ledger account, and then after uploading the budget into Dynamics GP, you can include these budget numbers on your Management Reporter (MR) reports. Here’s how to … 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
It happens to everyone. You close your fiscal year in Microsoft Dynamics GP and then, when going through your year-end reporting, you discover that one or more General Ledger accounts were closed with an incorrect Posting Type*. That means your Retained Earnings either are over or under stated. Fortunately, beginning with Microsoft Dynamics GP 2013 … Read more
The paid transaction removal tool is used to transfer paid sales transactions to history. It is also used to consolidate balance forward accounts. It consolidates the balance forward transaction amounts and adds the total to the noncurrent aging period. Paid transaction removal will speed up receivables processes, inquiries and windows should open more quickly. Also, … Read more
This is a good one for all you Microsoft Dynamics GP administrators! We have gotten some calls about network or anti-virus type errors in Dynamics GP, but the normal fixes just don’t work. The Errors: Here are the Dynamics GP errors we encountered: FP: Couldn’t close table! An open operation on table ‘taxHistory_TRX’ failed because … Read more
Here’s how to process a credit when using a credit card to pay vendors in Microsoft Dynamics GP. Let’s say you have entered an invoice in a vendor’s account and entered the amount in the credit card field. This will move the document to history in the vendor and create an open invoice in the … Read more
A customer recently had an issue with the number of decimal places for the price of an item on an open Sales Order. The item was incorrectly setup with 2 decimal places when it needed to be four. Note your Item Number and your Order Number. Is there a way to change the Currency Decimals … Read more
Recently, a client of mine had an issue where the Dynamics GP SmartList Window would not open or when it did, it was blank. I found that this is a known issue, as the window settings in the DYNAMICS SY01402 table can become corrupt and cause the window to hide or be blank. Troubleshooting & … Read more
Using Select Checks and Edit Check Batch I recently helped a client print partial checks in Microsoft Dynamics GP. They needed to pay an invoice in multiple payments. I’ve also run into this when someone needs to create a payment for a deposit, but had not yet received the invoice. Here’s how to make a … 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
Included in Microsoft Dynamics GP is the Professional Services Toolkit Library (PSTL). This adds a lot of powerful functionality to help you solve common business problems. One of the tools is the Inventory Site Combiner. It allows you to combine site/location codes without losing any data. Let’s say you created an inventory location and you … Read more
Using logos on your Management Reporter (MR) reports can make your reports look more formal and professional. Luckily, it’s super easy to do! Save a copy of your company’s logo anywhere on your local computer or network. It must be in the format of a “jpg,” “bmp,” or “png” file. Then open the report in … Read more
Recently, we received a call from a client that their Microsoft Dynamics GP web services stopped working. Additionally, they weren’t able to get into the Dynamics Security console either. The Problem: When clicking “Select Applications” the message would appear in the lower left corner “Action: In progress…” and nothing further would appear. Browsing to the … Read more
Entering your Microsoft Dynamics GP registration keys is an easy task to accomplish, as long as you know where to go and what to do. Sometimes your Dynamics GP Registration Keys may need updating. For example, because you have increased your number of licensed users. Here’s how to update your Dynamics GP Registration Keys After … Read more
Which dictionary do I use if I have multiple versions of Microsoft Dynamics GP? If you are a Dexterity developer with many alternate Dynamics GP forms in your development dictionary, e.g., your development dictionary is Dynamics GP2013 RTM and the Dynamics GP client application dictionary is GP2013 SP1, which dictionary do you use? If the … 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
Recently, I came across an issue at a long time Microsoft Dynamics GP client. When they tried to go to the Receivings / Transaction Entry window via Transactions > Purchasing menu, nothing would happen. It would not open, even though the option was present in the menu. Additionally, there was no error message and it didn’t … Read more
There are many instances when you will need to use a Blanket Purchase Order in Microsoft Dynamics GP. For example, you might have subscriptions for support, where a customer is billed $200 per month on an annual basis. Or, you might have a recurring order of widgets, but maybe you get 5,000 every other month. … Read more
You were happily working away every day in Microsoft Dynamics GP, and then one day your company upgraded to Dynamics GP 2013 R2 or later and suddenly, your Print button in Manufacturing was gone! You aren’t the first person to have this happen, and it can be startling the first time you go to print … Read more
We often run into Micorosft Dynamics GP errors with check batches. Sometimes, we find someone saved the batch without filling in the distribution, which generates an error message, but you can save through that. The problem is, when someone comes along to do a check run, the run will not complete. If you can’t complete … 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
Client Issue: We recently had a support case where a client was using one Exchange server, and had just moved their email to Office365. They are using the “Exchange” email option in their environment since they are using Office and Outlook 64-bit. When prompted to login with their Exchange email credentials, they would continue to … Read more