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...
GP Manufacturing Prevents Deleting Item-Site or Site
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...
Prorate Setup Time
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...
PSTL Combiner Duplicate Key Error
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...
GP Manufacturing Multi-Product/By-Product
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:
- Hackers acquired a copy of the entire LastPass customer password database
- Changing your LastPass master password
Should I update GP?
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...
GP18.3+ Delete/Void Bug
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...
Prevent DEX_ROW_ID Overflow
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...
MOP-SOP Links and MO Receipts
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...
GP18.4 Releases Ready
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...
Extended Pricing SQL Locking
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...
GP Stock Count Ends in 2020
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...
Complete Count Demo Video 2020
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...
Payables Transaction Inquiry – Document Performance Issue
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...
Manufacturing Order Picklist Draw From Site
The Manufacturing documentation has this to say about specifying sites:
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
New Installation Process
- A WilloWare product that has Minor Version 1 or above contains the New Installer (i.e. 12.1.36 has the New Installer, 12.0.35 does not).
- Minor Version 1 (and above) will require a “complete install” on
Functional Currency Decimals
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...
Pricing & Downloads
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...
Trying Our Software
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...
Grant SQL All Objects
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.
We … more...
New Help Buttons
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...
MORI WIP Transfers
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...
Dynamics GP HEAP Tables
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...
WilloWare in TEST
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...
Fun With Color Settings
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...
Nigel Frank Honors WilloWare
WilloWare named one of the 70 best Dynamics add ons
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...
WithoutWire and Dynamics GP Manufacturing
WithoutWire Inventory Sciences (www.withoutwire.com) just released a new video showing how manufacturers can make efficiency gains with their WMS System and Microsoft Dynamics GP. WoW integrates to GP Manufacturing through WilloWare’s MO Receipt Integration utility.… more...
Quickly Create And Update Items with Item Copy
ItemCopy (in WilloWare’s MFG PowerPack Suite) creates a new Item by copying settings from an existing Item. “But wait,” you say, “Doesn’t GP already have an Item Copy?”
Yes, but the list of what the GP Item Copy can copy … more...
GP Report Extender Video
GP Report Extender (GP-REX) is a Report Writer enhancement that allows easily adding any field, from any table, to any GP Report Writer report.
You do not need to know VBA or Dexterity. You just need to be able to … more...
Dynamics GP Report Extender
We just released (06-FEB-2017) an exciting new feature in Consulting Toolkit called GP Report Extender (GP-REX). GP-REX adds Report Writer functions that allow retrieving data from any table in the database.
A quick internet search on “Dynamics GP Report Writer” … more...
Dynamics GP tracks activity, such as having a Transaction window open or posting a transaction, in two System Database (i.e. DYNAMICS) tables:
Just opening the GL Transaction Entry window results in records being added to both tables.
If the transaction … more...
Manufacturing Move Out Logic
Microsoft Dynamics GP Manufacturing has the ability to create “Move Out” recommendations as part of the Material Requirements Planning (MRP) routine. How this works is not very well explained in the documentation, and whether or not it can be helpful … more...
WilloWare Stock Portfolio 2016-11
At the beginning of this year we started an internal project to gather information about our customers. We knew that, in general, we had quite a few customers in manufacturing and distribution, but we had not ever attempted to define … more...
Newsletter October 2016
Microsoft President’s Club 2016
Microsoft President’s Club 2016
Congratulations to our 2016 President’s Club Members
Microsoft recognizes WilloWare for outstanding performance.
WilloWare has been named to the 2016 President’s Club for Microsoft Dynamics. This achievement is a direct result of WilloWare’s outstanding dedication to … more...
Read the original article here: APIAnnouncement (site link)
Quinn & Associates, the United States representative for Preactor International, and WilloWare announce advanced integration between Dynamics GP and Preactor.… more...
Read the original article here: PandoraJewelry
Global Jewelry producers improves sales volume and customer service with WilloWare modules and custom solutions.… more...
Mark Polino, Dynamics GP MVP
Read the original article here: JournyxInterview (site link)
WilloWare CEO, Brenner Klenzman, interviewed by Journyx CEO, Curt Finch.… more...
Read the original article here: CustomIS (site link)
Their consultants and customers are “big fans” of WilloWare products.
Read the original article here: CustomIS_21MAY2015
Custom IS uses WilloWare products to enhance GP for their customers.