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

Continue reading “Error With Microsoft Dynamics GP Historical Company Name in Jet Reports”