Valuation methods are what determines how the costs of inventory items are calculated. There are several different methods you can use in Microsoft Dynamics GP. I recently had a client question how the various Inventory Valuation Methods in Dynamics GP differ. In this client’s case, the valuation they were using did not make sense for … Read more
I recently helped a Microsoft Dynamics GP client create a SmartList to pull in purchase order numbers for shipments and match receiving lines. Additionally they wanted to see the number of the receiving line. To accomplish this I created a SmartList Builder Report from the SmartList “Receiving Transactions.” Here’s how: The trick is we had … Read more
Attention Dynamics SL Users: You’ll notice a lot of “Dynamics GP” language used below – that’s only because we used Dynamics GP for our presentation. Management Reporter works exactly the same in Dynamics SL! Maybe you have heard that Microsoft will no longer be releasing updates to Management Reporter. This does not mean, however, … Read more
Many times I get asked questions about what all the different dates in Microsoft Dynamics GP do and or mean. All the dates in Dynamics GP can be confusing. So, I created this handy overview to help you out. Basic User Dates Thanks to Jen Kuntz for her post. User Date: Your “User Date” … Read more
I recently came across a client that had issues accessing new Items, Customers, and Vendors. The issue wound up being relatively simple; it was because when these things were setup in Dynamics GP, the Entity Relationship in Multi Entity Management was not setup. What is Multi-Entity Management? If you use multiple companies in Dynamics … Read more
Have you ever encountered a Purchase Order in Microsoft Dynamics GP that was still open but should be closed? I had a customer run into this problem recently. Here’s what I did to fix it. First, I reviewed the Purchase Order process the client used. We entered a PO like this one. Next, we entered … Read more
I recently helped a customer solve an issue with their Purchase Order (PO) in Microsoft Dynamics GP. They had changed the cost on an inventory item, but the new item cost was not showing up on the PO. Why is this? Here’s what happened First, my customer had changed the “Current Cost” of an item … Read more
Problem & Fix I recently encountered an issue with a Microsoft Dynamics GP Purchase Order not being allowed for a specific item. When I looked closer, I found the Inventory Item was missing setup information, which was causing the problem. Here is the Item Maintenance Card: In the Dynamics GP Item Maintenance card, make … 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
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
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