Software for Dynamics GP & BC
Here’s a quick resolution to an unusual error you could encounter installing software on Windows.
“Unable to execute file in the temporary directory. Setup Aborted.
Error 5: Access is denied.”
The domain security is preventing running the installer because it … more...
On December 2, 1950, Isaac Asimov published iRobot. The future world had intelligent, autonomous, intelligent, physically capable robots for work and companionship.
Asimov postulated three rules to govern robots (artificial intelligence), the Three Laws of Robotics:
Who doesn’t want EITHER!? Either sounds like both! Awesome.
There are some real problems with using the “either” setting. In case you don’t know what the “either” setting is, let’s review a bit of background.
“BOM Should Treat As” is … more...
I have posted several articles recently about the truth behind D365.
The nutshell is that Dynamics BC is not the “next version” of GP. If you decide … more...
Have you ever needed to add a field to a GP report but the table links are not there to allow it?
Our GP Report Extender tool allows adding any field from any table to any GP report. Below we … more...
Date: 14-OCT-2025
Last year around this time I provided some numbers on the version of Dynamics GP used by our customers. Since Summit is just around the corner and support is likely to be a hot topic, I wanted to … more...
DATE: 26-JUN-2025
Why doesn’t this item appear in MRP? Who hasn’t asked this question? Why is this other stuff showing up in MRP when I don’t think it should? Another great question!
Scroll down for a cool new tool for … more...
25-JUN-2025
We have an interesting addition to PowerATP this week! It addresses a frequent user request that, until now, we have not had a good answer for. The user interface for PowerATP is already rather full, so finding space to … more...
Back in 2000 Microsoft acquired four separate ERP software companies: Navision, Axapta, Great Plains and Solomon. There was a lot of messaging from Microsoft about how Project Green was going to combine all of them into one super ERP … more...
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...
