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 will receive a couple of emails listing a large number of releases as this roll-out occurs.

The first new system feature is that our Error Reporting window and About window can now create support case with WilloWare from inside GP.

The information displayed in the window will be added to a Support Ticket, and you will be provided the Ticket ID, as shown below:

The second new feature is something we are excited about.  All of our software will now be 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 without needing a temporary, time-limited key.

Second, if you already have our software but are not registered for all of its features, you will be able to test ALL functionality in the <TEST> company without changing your registration key.

In short, all functionality of all of our modules is always available in a <TEST> company.

In case you are not familiar with a <TEST> company, here’s a quick overview.

Dynamics GP has a little feature that is not well documented, which provides support for Test and Historical company databases.  To enable this feature, put <TEST> or <HISTORICAL> at the end of the Company Name, as shown below:

 

The primary effect of this is that it Zeros the Employee Count so the Employees in a TEST or HISTORICAL Company do not affect payroll.

It also causes a warning to pop-up during login to help alert users that they are not in the live company:

And, with the new builds of all WilloWare software, it causes the software to enable full functionality.

Lastly, our software can now automatically check to see if there are updates.  The check is done when “SA” logs-in to GP.  If there is a new build available you will see a window like this:

If you click the Do Not Remind Me link, it will turn off further notifications until a new build is installed.  When a new build is installed it re-enables the Update Reminder.

 

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, Color Settings can create a whopping 5900 different colorful combinations.

Since only SA has access to the system-wide settings, end-users can play around with their personal Color Settings to create a GP look that makes them happy.  Below is a quick highlight of each color setting.

Button And Label Text

Control Bar 3D Button Background

Control Bar 3D Button Hover Bottom

Control Bar 3D Button Hover Middle

Control Bar 3D Button Hover Top

Control Bar 3D Button Top/Middle/Bottom (Red/White/Blue)

Control Bar 3D Button Selected Bottom

Control Bar 3D Button Selected Middle

Control Bar 3D Button Selected Top

Control Bar 3D Button Selected Top/Middle/Bottom (Pink/Yellow/Green)

Control Bar Background Bottom

Control Bar Background Top

Control Bar Background Top/Bottom (Green/Yellow)

Disabled Button Highlights

Disabled Field Text

Drop Menu Background

Drop Menu Text

Editable Field Background

Field Text

Locked Field Label And Field Text

Scroll Window Column Headers

Scroll Window Column Header Text

Scroll Window Line One Background

Scroll Window Line One Text

Scroll Window Line Two Background

Scroll Window Line Two Text

Scroll Window Both Lines

Window Background

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 leaders in Microsoft recruitment, features 70 of the most useful, functional, and reputable Dynamics add ons available, and we are proud to see our name featured in the compilation.

When compiling the list, Nigel Frank was conscious of the needs of modern businesses, with an emphasis placed on showcasing e-commerce, customer relationship management, and supply chain management software.

WilloWare products were identified for their customer-focused interface, where tweaks can be applied to ensure specific performance in areas such as general ledger, inventory, sales, and manufacturing.

Our inclusion on the list comes as great recognition, and adds to our accolades after receiving Microsoft’s President’s Club Award in 2016.

WilloWare’s VP of Development, Troy Gullacher, said “We’re thrilled to be a part of the Nigel Frank Best 70 Add Ons. Our goal has always been to provide helpful and useful software to Dynamics GP users, so we appreciate this recognition!”

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 basic steps that can always be used to start the process, in the order they should be performed.

Basics

What Did I Just Do?

The moment you get an unusual error, stop.  Take a moment to take some notes about what just happened.  Take a “history” of the incident, recording as much pertinent information as you can recall, without touching GP.

• What was the document number/customer number/item number/etc?
• What were the last few things you did in GP prior to the error?  Be specific.  Which buttons, which fields, etc?
• Record the Date/Time.  This is important because it could correspond to something else occurring on the computer/network at the same time.

Screen Capture

Make this a habit!  When anything unusual happens in GP, press ALT+PrtScn.  Do it the first time.  Do it every time.  If you do not capture these important messages, troubleshooting may be very difficult if you cannot reproduce the error.

Using ALT+PrtScn is different than pressing the just PrtScn (Print Screen)–pressing Alt+PrtScn takes a capture of the “active window”.

Capturing the Active Window gets just the error message:

While just PrtScn (Print Screen) captures the entire window:

A screen capture that includes all open applications on multiple monitors can be so difficult to read that it is not helpful.

Then open Word, or an Email, and press CTRL+V (paste).

 

Types of GP Messages

There are several different “message” boxes that GP can present, and they provide a hint about the issue you are experiencing.  Being familiar with these may point you in a direction to find the solution.

An “ASK” dialog can have up to three buttons on it (such as Yes, No, Cancel).  This is an informational message.  This is a message coded by the developer, and might indicate setup is missing or incorrect.

A “WARNING”message has a single button: OK.  A warning message may simply be important information (“you can’t do that!”), but it may also be reporting an error.  We will look at a warning message presenting an error condition later in this post.  A warning message is also coded by a developer, so when it appears you know, at a minimum, it was an event anticipated by the developer.

An “ERROR” message is generally more severe.  An Error is usually presented when a problem has occurred with a table operation, or some fundamental software error has occurred.  It may indicate there is something wrong with the data, or the table storing the data, or in a calculation.  A developer can code an Error message, as shown below:

However, error messages are more often system generated:

If possible, scroll down in the error message and capture all of it.  If the message has a scrolling window, like the one above, you can copy the text.  Click into the message, then press CTRL+A (select all) and CTRL+C (copy).  Then paste it (CTRL+V) into Word or an Email.

If the message has another button (i.e. Debug, More Info, etc), click it can capture that information too.

WilloWare uses our own error reporting throughout all products to provide more detailed information.

 

This window provides the name of the product (“TEST”), the build number, the location of the error, and the cause of the error.  The window can also automatically generate a support case by clicking the email address.

Version Information

Depending on where the problem is occurring, you may not be able to even launch GP.  The steps below provide several methods to retrieve version information.

During log-in, the Welcome screen displays the GP version information.  This is read as Major Version 14, Minor Version 00, Build 0524.

If you can get logged-in to GP, go to Help >> About Microsoft Dynamics GP

The HELP button is the blue question mark in the upper-right corner

Take a screen capture of this window, and paste it into Word or an email.

Many 3rd Party Products will have “About” navigation on the first menu (where About Microsoft Dynamics GP is located), or off the Additional Menu on the About Microsoft Dynamics GP window.

The WilloWare About window (for all products) is off the Additional Menu (i.e. Additional >> About GP PowerPack).

Click into the window, press CTRL+A (select all), CTRL+C (copy), then paste it (CTRL+V) into Word, or an Email.

If you cannot launch GP because it crashes before you can even get to the login window, you can find version information on the application files themselves.

Open Windows Explorer, and navigate to the GP Program Folder.  This is usually in the following path:

c:\Program Files (x86)\Microsoft Dynamics\GP2015 (or GP2016, etc)

Right-click on Dynamics.exe

The right-click menu can be rather large.  Properties is normally at the bottom.

Click the DETAILS tab.  Note the File Version/Product Version.  This matches the Dexterity Version Information from the About window.

Steps To Reproduce

This might not be safe to do in the live company.  See the section in Tools regarding Test Company versus Test Server.

If it is safe to do so, attempt to reproduce the issue.  Write down the specific steps needed to reproduce the issue.  Think of writing a recipe where ingredients need to be added in a certain order.

What if you cannot reproduce it?  Computers are not random, so there is some logic to what happened, but it may not be possible to reproduce the issue.  For example, it could depend on a certain number of users all doing the same task at approximately the same time.  This would be extremely difficult to reproduce.  An issue that cannot be reproduced may not be fixable.

User Specific

At this point you have gathered some information.  You have tracked down version information, you may have screen captures, and you have determined how to reproduce the issue.  If you cannot reproduce the issue, the following steps cannot be performed.

One of the first troubleshooting steps is to check whether or not the issue is user-specific.

• Can another user perform the same task and get the same error on a different machine?  If not, the issue might be related to one User ID and/or computer.
• Eliminate all security issues and test again.  Log-in to the computer as the Windows Domain Administrator, then log-in to GP as “SA”.  Can you reproduce the issue?  If not, the issue is related to security.  It could be GP security (i.e. access to windows, reports, etc), or Windows Security (i.e. access to shared files, or appropriate access to the files in the GP program folder).  NOTE: you must use the actual account called Administrator to ensure complete access to all computer and network resources.
• Can you reproduce the issue in another Company database (or Fabrikam)?  If not, there may be a company setting causing the issue, or a company-specific data issue.

Tools

Test Environment

Test Company or Test Server?  See our discussion of this question here:

//willoware.com/install/installation-best-practices/

In a nutshell, a Test Company is a safe place to test transactions.  It is usually a good place to attempt to reproduce an issue.  However, it is possible to create inter-company transactions, so a Test Company is not necessarily isolated from the Live Company.  A Test Server is a separate, replica of the live server.  This is a good place to test anything because there is no chance of impacting the live environment.

Log Files

Open Windows Explorer and navigate to the GP Program folder, which is typically:

c:\Program Files (x86)\Microsoft Dynamics\GP2015 (or GP2016, etc)

Go into the Data sub-folder.  Locate DEX.INI, right-click, select EDIT.

If ScriptDebugger and ScriptLogEnhanced switches not in the file, add them as shown above.

The other “SQLLog” switches are normally in the file.  Be sure to check the entire file before adding them.

Set all of the switches shown above to TRUE, then save the file and close it.

Log-in to GP.  The SQLLog settings are active immediately and will begin logging.  We’ll return to that log file in a moment.  The ScriptDebugger setting adds a DEBUG menu to the top of every window, and ScriptLogEnhanced adds a time-stamp to each line in the file.

You want to keep the log files as small as possible so they contain only what occurs when the issue is reproduced.

For example, we have found that when we click the “end of file” scrolling button (the right-most scrolling button), we get an error message.  The Sales Transaction Entry window is open, as shown above.  Go to Debug >> Log Scripts.  Save the file to an easy to find location, such as your Desktop.

WAIT! Before reproducing the error, delete the SQLLog file.  Use Windows Explorer to navigate to the GP Program folder.  In the Data subfolder, locate DEXSQL.LOG.  Delete it.  Keep Windows Explorer open on the Data folder.

Go back to GP and reproduce the error.

Go back into Windows Explorer and COPY DEXSQL.LOG.  This will ensure nothing else gets written to the file.  If possible, make a copy of the log file while the error message is displayed in GP.

Returning to GP, you may need to click on several messages before you can get back to the Debug menu to turn off script logging.  Go to Debug >> Log Script to disable script logging.

 

Close GP.  Go back to the DEX.INI file and set the logging switches to FALSE.

Save Dex.ini and close the file.

WilloWare’s Consulting Toolkit contains several free SQL Management tools, one of which is the SQL Trace utility.  This utility can enable the SQLLog switches discussed above, from inside GP, so that SQL Logging can be enabled/disabled exactly when needed just like the Script Log.  Read more about the SQL Trace utility here.

Interpreting Log Files

By copying DEXSQL.LOG at the moment the issue occurs, the last lines in the log file are what immediately preceded the issue.  So begin by scrolling to the bottom and working up.

An example from the file:

{CALL TWO.dbo.zDP_CO40100F_1(NULL,NULL)}

TWO is the database, and CO40100 is the table.

Likewise, the end of the Script Log contains the last steps GP performed before the issue:

The key to reading this file is trying to get a general idea of what is happening without getting buried in the details.  For example:

‘SetAttachmentButtons of form coAttachManagement‘, “0\Sales\Sales Order\2~”, DocumentsAttached, DocumentsNotAttached

The bold-red words are dexterity code and everything that follows that is input or output data.  From this script we can see that something is happening with Attachments.  We can also infer from this that the SQL log might be showing the tables involved in managing document Attachments.  Retrieving table information is discussed below.

The time-stamp is useful when troubleshooting a long running process.  Watch the time-stamp to see what process takes a long time to run.

Pay particular attention to entries in the script log that look like this:

‘Security’, 0, 2, 116, “”

The GP Security procedure checks to see if the user has access to the resource (a window or report).  Scrolling backwards in the Script Log until you find an entry for Security can help identify which product is encountering the issue.  The red number, in this case zero, is the Product ID.  You can connect the Product ID to the Product Name through the Edit Launch File window (Tools >> Setup >> System >> Edit Launch File):

In this case we can see that Product ID = 0 is Microsoft Dynamics GP.

Table Information

A little known, but very useful tool in GP is the Table Information window.  Go to Tools >> Resource Descriptions >> Tables.

Click the … button.

Select the Product (see the “Security” procedure in the previous section), and set View By to “By Table Physical Name”.  Tables are grouped by Series (i.e. Financial, Inventory, etc).  You can make an educated guess about the series, but sometimes tables are not where you would expect them to be and it requires a bit of searching.

SQL Profiler

SQL Profiler is a component of Microsoft SQL Server and is installed on the server.  We are not going to go into depth on how to use Profiler, except to say that the SQLLog file captures information similar to what can be recorded in Profile, but Profile has many more options for what can be recorded and how the information is displayed.

Note the similarities in the Profiler log to the SQLLog file:

Sysinternals Process Monitor

This tool can be downloaded from:

//technet.microsoft.com/en-us/sysinternals/bb896645

If that link is not available, check www.sysinternals.com for “Process Monitor”.

Process Monitor can report on pretty much everything an application does, from reading Registration Key settings, to internet communication, to file access.  It is this last task that can be helpful when there is a security related issue (i.e. there is tight network security and it is interfering with GP).

Begin by adding a couple of filters.

Filter 1: Process Name is dynamics.exe.  Click ADD.

Filter 2: Operation is ReadFile

Click OK to close the window.

Perform the task in GP that is causing an issue.  As an example, GP is generating a warning message shortly after launching the application, before reaching the login window:

As soon as the error appears, stop the Process Monitor.  Scroll up from the bottom of the window.

There are a large number of reads on the Dynamics.dic file.  An additional filter excluding these file reads would make the display easier to read.  Scrolling up in the file we start to see reads from other dictionaries:

In this case, the last dictionary it reads (excluding Dynamics.dic) is BS71.DIC.  Using the Edit Launch File window (discussed above), we could identify which product this is.  With this type of login error, the next step would be to edit the Dynamics.SET file to remove this product, then relaunch GP to see if the warning disappears.

Editing Dynamics.Set

Editing the SET file should not be done on a terminal server if there are other users in the system (or who could be in the system).  It is possible to launch GP using a separate SET file, but that is not covered here.

Dynamics.SET contains a list of the dexterity modules that comprise Dynamics GP.  It is located in the GP Program Folder:

c:\Program Files (x86)\Microsoft Dynamics\GP2013 (or GP2015, GP2016, etc)

Make a copy of Dynamics.set before editing it.

Open it in Notepad.  The file has three sections.

• The number of products installed (47)
• The product list (consisting of pairs of Product ID and Product Name)
• The pathnames list below the “Windows” line (consisting of three lines per product, list the path to the application dictionary, forms dictionary, and reports dictionary)

The forms and reports dictionary files are only present if a window or report has been modified.

To remove a product from the SET file, decrease the product count by one, remove the two lines that identify the product, and remove the three pathname lines for the product.

To remove Manufacturing from this SET file, the product count could be 46.

Remove the two lines highlighted above, leaving no blank rows (Fixed Assets should be followed by 414).

Remove the three lines highlighted above, leaving no blank lines between “R309.DIC” and “HR.DIC”.

Save the file.

Google

An often overlooked troubleshooting tool is Google.  Search for the error message, or the window involved and include the word “error”.  If you have done some of the troubleshooting steps above you may have additional information such as a table name, or a script name from the script log.

 

 

 

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 manually, where it runs one time and processes all available records in the integration tables, and then stops.  Or, it can be run continuously.  When running continuously, it periodically polls the integration tables to see if there is anything to process.

When MOGen is part of a system integration, a common need is to have it run automatically on an unattended machine.  The steps below describe how a GP client can be configured to launch automatically everyday, run MOGen during business hours, then shut down.  The benefits of this process are that it ensures no GP clients remain connected to the SQL server during maintenance periods, and it provides for regular “refreshing” of the GP client (which tends to run better if it is regularly restarted).

 

Configuring MOGen

See the MOGen documentation for more information about this window.

Mark the box next to “Auto-start after login”.

All of the Timer settings are saved automatically, and reload when each time the window is opened.

The Timer must be ENABLED.

Stop After x-Hours.  Enter the number of hours the utility should run before it shuts down.  For example, 10-hours would calculate an end time 10-hours in the future from the moment the IMPORT button is clicked.

Close GP When Done.  MARK this box.  The macro discussed below will launch MOGen, when the stop time is reached, MOGen will stop processing and close GP.

If the utility will run overnight, add this setting to the DEX.INI file:

SuppressChangeDateDialog=TRUE

This setting keeps GP from popping the “Do you want to change the date” dialog at midnight.

Login Macro

If MOGen is going to be run on a dedicated GP client PC, or a VM that is not a shared GP instance, you can configure GP to remember the Username/password and Company.  These settings are stored in the DEX.INI file so they can only be used on a dedicated GP client.  If you can do this, skip the Login Macro information below.

The Login Macro will be used by Windows Scheduler to launch and log-in to Dynamics GP.  It then opens MOGen and clicks the Import button.

There are a few import sections of the macro.

The logging file entry:

Using a logging file keeps GP from popping up a dialog box when the macro finishes running.  The dialog box would interfere with MOGen, and also prevent GP from closing.  Set the path name to an appropriate location for your system.  A good place is in the GP\Data folder.

Username and password:

The Username and password are in plain text.

The next section of the macro selects a Company.  If you only have one company, or the MOGen user has access to only one company, remove these lines from the macro.

The next section of the macro opens the MOGen window and clicks the Import button.  If you have a newer build of the software that has the “Auto-start after login” option, remove these lines from the macro.

Selecting the company :

Edit the macro so that the “item 1” line selects the correct company from your login window:

As shown above “item 1” corresponds to “Fabrikam”, and “item 3” corresponds to “ZArchive”.  If you need “ZArchive” change the macro to “item 3”.

Download the MOGen login macro text file at the link below.  After downloading the file, change the extension to “.mac”.  Save the file into the GP Program folder, in the same location as DYNAMICS.EXE.

GPLoginMacroMOGen

Windows Scheduler

Use Windows Scheduler to create a Basic Task to “Start a program”.

The Program/Script is the path to DYNAMICS.EXE, such as

“c:\Program Files (x86)\Microsoft Dynamics\GP2016\DYNAMICS.EXE”

In the Add Argument field, enter:

DYNAMICS.SET GPLoginMacroMOGen.mac

If you can set GP to remember Username/password and Company, you do not need the Login Macro line above, just DYNAMICS.SET.

Set up the Task Schedule as desired.  The frequency with which the Task runs must be coordinated with the Timer Settings on MOGen to prevent launching GP before MOGen has closed GP from the previous run.

 

Monitoring MOGen

MOGen updates a record in a “heartbeat” table every time it runs.  So if MOGen is set to run once every 15 minutes, the heartbeat will be updated every 15 minutes.   The heartbeat table can be monitored to see if MOGen is still running–if it has quit updating the date/time stamp, it has quit running.

See the MOGen documentation for more information about monitoring MOGen remotely.

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.