The Dynamics GP Landed Cost module could be used for recording tariffs on purchased material, but there are several downsides to this approach.
The Landed Cost module adds some cumbersome overhead to PO Entry, Receiving and Invoicing, but the primary … more...
Keywords: Copilot, AI, ERP data
Date: 17-MAR-2025
Let me start by saying that if you can cite a specific Microsoft document that contradicts the scenario below, please let me know so I can update this post.
I think the following … more...
Keywords: Dynamics GP, tariff, surcharge
Date: 13-MAR-2025
Update 6-APR-2025: See our Tariff Module
This article discusses methods for handling the scenario where your vendors are subject to tariffs and are passing those costs on to you. The specific method of … more...
19-NOV-2024
Keywords: Mfg Fixed Lead Time, Mfg Variable Lead Time
Some quick facts:
Date: 28-OCT-2024
We are starting on the 18.7 updates to our software! You will see new releases of everything over the next few weeks. They will be released every few days in the following order:
Date: 28-OCT-2024
You have likely heard recently about one or more of the following:
If you own your license, GP will keep … more...
That is the headline because if you hear that “support is ending for GP” just consider for a moment that WilloWare still has businesses using GP2010, which is incredibly out of the support window. It still runs, it supports their … more...
Date: 2-OCT-2024
Keywords: Reconcile Inventory Quantities, Speed
If you have a lot of Item Numbers and/or Location Codes it creates an enormous number of Item-Site combinations, all of which combine to give the Inventory Reconcile process a lot to do! … more...
Keywords: SOP Quote, SOPTYPE = 1, Mass Delete
If you have accumulated a large number of unused SOP Quotes in Dynamics GP it can be daunting to consider the best way to remove them. A quick trick to accomplish this … more...
25JUN2024
Keywords: multiple finished goods, multi-product production
WilloWare’s LeanMFG module supports multiple methods of manufacturing:
Select Checks Filters in GP PowerPack can dramatically reduce the amount of time required to create a PM Check Batch.
Create and save a query (aka a Filter) that identifies a group of invoices to pay, such as a list … more...
If you see an email from NetSuite trying to scare you about C++ and security and Dynamics GP, please consider this:
GP is NOT a web-facing application. If a hacker is hacking GP they are already inside your system. If … more...
The Manufacturing Calendar windows (Shop Calendar and Work Center Calendar) are funny. Have you ever looked at the years available in the “years” dropdown list?
The list starts with 1925! Great Plains (what is now Dynamics GP) was not even … more...
SmartList is a wonderful tool! It makes it so easy to explore your GP data and once you get the desired columns, in the right order, with the Search Criteria you need you can save it as a Favorite for … more...
The Low Level Code (LLC) utility in GP Manufacturing calculates the lowest level at which any component is found.
For example, CBA100 is at level 2 and CAP100 is at level 3. Material Requirements Planning (MRP) uses this LLC so … more...
We recently received a support case regarding the MO Scheduler utility in the MO Generator Suite. The consultant reported that when attempting to reschedule an MO they received a SQL error:
Conversion failed when converting the varchar value ‘50.01’ to … more...
Keywords: Manfacturing, Standard Cost, Revaluation, Replace Costs
A client recently encountered the error below after updating pending cost changes (using WilloWare’s Proposed Cost Update), then doing the Roll Up and Replace Costs routines on the Standard Cost Changes … more...
It is hard to be alive if it never existed in the first place. D365 does not exist. D365 is a marketing umbrella term for two completely separate online ERP software packages provided by Microsoft. The two separate ERP packages … more...
Keywords: Manufacturing, Item Delete, Item-Site Delete, Site Delete
You may have tried to clean up data in GP and were prevented from removing an unused or obsolete Item, Item-Site or Site because of a warning message from Dynamics GP Manufacturing … more...
Keywords: Prorate Setup Time, Prorate Quantity, Standard Cost (FIFO/LIFO Periodic), Actual Cost (FIFO/LIFO Perpetual), Backflush
When Prorate Setup Time is marked and Setup Labor is backflushed, the MO Receipt applies an incorrect amount of Setup Cost to each piece.… more...
Keywords: PSTL, Professional Services Tool Library, Duplicate Key
When using PSTL Combiner (i.e. combining Items, Customers or Vendors), you can get a duplicate key error:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint ‘PK-tablename-‘. Cannot insert duplicate key … more...
Keywords: Dynamics GP Manufacturing, multi-product, co-product, by-product
A GP Manufacturing Order can only produce one item. Right?
This may surprise you, but a GP Manufacturing Order can produce multiple items at once. This is often referred to as By-Products, but … more...
If you have not heard about the LastPass hack, you can find lots of information about it on the internet. Here is the nutshell:
Yes.
There are tens of thousands of GP users poking around every nook and cranny of the software every day. Every release contains not only new features, but bug fixes. Even after decades of heavy use people are still able … more...
DATE: 20-OCT-2022
Summary: Deleting partial Invoice corrupts originating Order on GP18.3+
In GP18.3 a change was made to how SOP deletes/voids a document. It appears that the objective was to “rollback” the QTY Invoiced on the Originating Order when the … more...
You may not have given this a thought, but every Dynamics GP database table has a DEX_ROW_ID column, and there is a maximum value for that field. It is 2,147,483,647. Just over 2 billion.
Every time you add a record … more...
Posted: 17-SEP-2022
Keywords: Dynamics GP Manufacturing, MOP-SOP Links, MO Receipt Entry
The issue discussed below applies to all current versions of Dynamics GP. We released an update today for MFG PowerPack that has a new Tweak called “MO-SO Receipt Warning”… more...
All of our software is now ready for GP18.4!
We wanted to take this occasion to share with you our thoughts on the 18.x releases. While this new numbering approach gives the impression that each new “DOT” build (18.2, 18.3, … more...
6-JAN-2021
A client site that uses our MO Receipt Integration (MORI) module recently reported a frequent occurrence of SQL deadlocking from a stored procedure called sopExtPricingPriceBookSetup. Microsoft identified MORI as the source of the problem, however MORI does not use … more...
17-NOV-2020 / Updated 5-JAN-2021
The Dynamics GP Stock Calendar Maintenance window has a “year” dropdown list that contains years only up to 2020. If you are using the Dynamics GP cycling counting functionality you will not be able to extend … more...
It has been 6 years since we created our CompleteCount demo video and there have been a lot of great additions to the software since then. One of the most often requested newer features which wasn’t available for the original … more...
We were busy in 2019 writing software for you! A major task was preparing new releases of all of our products for “GP Next”. We also added 28 NEW features across 9 of our products!
Below is a recap of … more...
We recently had a support case regarding very poor performance in the Dynamics GP Payables Transaction Inquiry – Document window. The client has a very high volume of transactions so the payables transaction tables contain millions of records.
The user … more...
The Manufacturing documentation has this to say about specifying sites:
… more...If no issue-from or issue-to site is specified for a component, default sites will be used.
Default values for the issue-from site site
Refer to the following information about how
Dynamics GP allows setting the Currency Decimal Places on an Item to a larger number than the Company’s Functional Currency Decimal Places (FCDP) For example, an Item could have 5 currency decimals ($12.00124) but the FCDP (which governs the General … more...
We are excited to announce a couple of small changes to our website that we hope will improve you life! Well…that might be overstating things a bit, but we hope the changes will help you do your job more efficiently, … more...
In additional to being fully functional in Fabrikam, all of our software is also fully functional, without registration keys, in <TEST> companies. There are two benefits from this:
First, you can download and test our software using your live data … more...
It is commonly thought that the grant.sql script (found in the GP Folder\SQL\Utils\) takes care of security at the SQL Server level by granting access to DYNGRP to all of the SQL objects used by Dynamics GP.
It doesn’t!
We … more...
As we roll-out new builds for GP2018, we are adding new Help functionality to all of our products across all currently supported GP versions (at this time we are supporting GP2013 through GP2018). There were four goals for the new … more...
One of our core objectives has always been to listen to you. Sometimes we receive your suggestions through an email or a support case, or on a phone call. We also monitor blogs and Microsoft’s Connect site.
We keep our … more...
We just released (3-OCT-2017) a new build of MOGenerator’s MO Receipt Integration (MORI) that now has support for WIP Inventory. This new functionality provides the ability to record usage of raw materials as it happens. There are two components of … more...
You may have looked into a GP performance issue and dug around a bit and discovered that you have high fragmentation in a large number of table indexes. After rebuilding indexes, a large number of indexes still have high fragmentation, … more...
If you feel too constrained by the standard software spec, which describes only the functionality that will be present in the proposed software, we are proud to now offer our exclusive Anti-Specification Service. Our ASS will identify everything that will … more...
During July (2017) we will be rolling out new builds of all of our software. This mid-year update addresses any open, low-priority issue reports, and adds a few helpful system features. If you are receiving our “software release” updates, you … more...
Color Settings (in GP PowerPack), is (a) Awesome and (b) Free! It provides the ability to for users to edit their own settings, and for admins to apply a company-wide setting. With access to 26 user-interface elements, and 17 colors, … more...
WilloWare’s Dynamics GP products have been featured in a list of the 70 best Microsoft Dynamics add ons on the market.
The list from Nigel Frank International, the global … more...
Microsoft Dynamics GP Troubleshooting
Sometimes things go wrong. Is it something you can resolve yourself, or do you need expert help? Where do you start? There are as many troubleshooting techniques as there are unique problems. Here we provide some … more...
MOGenerator provides a number of useful Manufacturing integration utilities, such as the ability to create MOs, reschedule MOs, create child-MOs, and receive MOs. Collectively these utilities will be referred to as MOGen in this post.
MOGen can be run … more...
