Uninstall

Removing a WilloWare product requires two steps:

1- Removing Tables

2- Removing Code

If your objective is run Dynamics GP without a WilloWare product (i.e. for troubleshooting or to have a “clean” client for integrations), skip ahead to the Removing Code section.

If your objective is to rollback to an earlier build of your WilloWare product or customization, do NOT follow the Uninstall instructions.  See the Rollback Instructions.

Before Beginning: Make a backup of all Company Databases, and the System Database (DYNAMICS), and make a backup of the entire GP Client folder and any modified Forms/Reports dictionaries.

Removing Tables

Our software does not modify core GP tables, such as by adding SQL table triggers, so there are no changes that need to be “undone”.  Removing WilloWare product tables is optional as leaving them in the database has no effect other than occupying a small amount of storage space.

All of our tables start with a lower case w, such as wATPItems, wBatchOpCode, and wCTPSites.  Only remove tables that start with “w”.

In very rare cases a WilloWare product or customization may contain a copy of a table from another 3rd Party (such as a copy of a Manufacturing table).  These tables have noticeably different naming conventions, such as : “Bomlevel_1”, “Buyer Codes”, or “Manufacture Order Master”.  When in doubt, do not delete the table.

Make sure that no users are in Dynamics GP for the duration of this process.

Removing tables is risky only should only be done if absolutely necessary, and should only be performed by an experienced Dynamics GP professional.

Leaving the tables will not have any effect on normal GP function, so the safest approach is to keep the product’s tables.

Company Tables

Log-in to GP as SA.

Go to Maintenance >> SQL

For each Company Database:

  • Select the Database
  • Select the Product (here MFG PowerPack is used as an example)
  • Mark DROP TABLE and DROP AUTO PROCEDURE
  • Click into the table list and press CTRL+A (select all)

If you have multiple WilloWare products installed (including customizations), they all share a common version tracking table.  DO NOT DELETE THIS TABLE.  Scroll down in the list to “wInstallCoVer”.  Hold down the CTRL key and use the mouse to click on “wInstallCoVer”–this will unselect the table.

Click PROCESS.  Repeat for each Company Database.

 

System Database

If you have multiple WilloWare products installed, they all share common tables in the System Database (DYNAMICS).  Do NOT delete these tables if you have multiple WilloWare products installed.

Log-in to GP as SA.

Go to Maintenance >> SQL

 

  • Select Database DYNAMICS
  • Select the Product (here MFG PowerPack is used as an example)
  • Mark DROP TABLE and DROP AUTO PROCEDURE
  • Click into the table list and press CTRL+A (select all)
  • Click PROCESS

 

Removing Code

Removing the product requires editing the DYNAMICS .SET.  The example below shows how to edit the Dynamics.SET file to remove the GP Manufacturing module.  The process is the same for ANY dexterity module (i.e. all WilloWare products/customizations).

 

DYNAMICS.SET is located in the Dynamics GP Programs Folder. The folder name is different with each version of GP. For GP2013 the folder is:

C:\Program Files\Microsoft Dynamics\GP2013\

Before starting, make a back-up copy of the DYNAMICS.SET file. Open DYNAMICS.SET with Notepad.

DYNAMICS.SET looks like this:

The first number (27) is the total number of installed products. Decrease this by ONE.

The next lines are pairs of entries consisting of a Product ID and the Product Name. In this case 346 & Manufacturing. Locate the Product ID and Name you wish to remove and delete those lines.

In the screen capture above the “. . .” lines represent additional product entries. Your file will not have dots.

Locate the “Windows” line. This final section of the SET file consists of three lines per product, which point to the product dictionary, forms dictionary, and reports dictionary. Locate the three paths for the product you wish to remove and delete them.

After removing the product information, the SET file will look like this:

Save the file then launch GP. If you get any errors, close GP and restore the backup copy of DYNAMICS.SET.

As a final step, to completely remove the WilloWare product, delete the product DIC file.

Editing the SET file must be repeated on each Dynamics GP client where the WilloWare product is installed.