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.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) -
Your Email (required) -

Leave a Reply

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