19-NOV-2024

Keywords: Mfg Fixed Lead Time, Mfg Variable Lead Time

Some quick facts:

• It looks at the Primary Routing for each made item.
• It does not explode the BOM and calculate the TOTAL lead time to make a top-level item

… more...

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:

• GP PowerPack
• MFG PowerPack
• MO

… more...

Date: 28-OCT-2024

You have likely heard recently about one or more of the following:

• GP Lifecycle
• Dynamics GP Roadmap
• Microsoft Support
• Timelines
• Or even the scary and completely wrong “end of life”.

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:

• Regular discrete manufacturing where a list of raw materials (Inputs) is used to produce a finished good (Output).
• Disassembly/reverse assembly where a single item (Input)

… more...

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

Summary

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...

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...

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 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:

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

… more...

Key Points

• 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

… more...

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 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...

Overview

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 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...

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 (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...

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...