Error With Microsoft Dynamics GP Historical Company Name in Jet Reports

Jet ReportsI’ve worked with Jet Reports against Microsoft Dynamics GP with a few clients over the last couple of years (as well as writing a book on using it with Microsoft Dynamics GP). One recent client I was working with developed some reports against the live companies, but we had a problem when trying to include some data from historic companies (after a merger, new companies were created and the old ones marked as historic).

I was able to repeat the problem on my demo environment. When oa test company was selected the Options tab showed a #VALUE! error:

Error when selected a test company

When running the report we then received a popup error message:

When you name a test company you can add to the end of the name and it will invoke a popup when a user logs into the test company informing them they are in test; you can also use for a test company for a similar popup message

The problem is that Jet Reports is interpreting the chevrons as less than/greater than symbols. The workaround is to not use the full company name, but to use the * wildcard instead:

Jet Function Wizard showing wildcard example

The only issue with this is that users can't select the company from the lookup without replacing the chevroned section with a wildcard.

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you're looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

Leave a Reply

Your email address will not be published. Required fields are marked *