only using InvoiceHistoryHeader, InvoiceHistoryDetail, and InventoryMasterFile

only using InvoiceHistoryHeader, InvoiceHistoryDetail, and InventoryMasterFile

Sometimes doing a "Verify Database" in the report can point at the issue.

If you have a numeric parameter, there is a known issue related to those...

Verify Database, just comes back with "The database is up to date" and returns to error above after a couple of minutes.  Using Date fields to select range, What numeric parameter issues? Is there a knowledge base article?

The numeric parameter issue is related to CR, not Sage 100.  If you remove your parameter and the report runs, that is the test.

By any chance is the report looking at a SQL View?  You might need to recompile the view, to correct column alignment... (for fields added by the upgrade).

Started a new report using just the Invoice History Header and Details.  It is tripping on a bad date field in Invoice History Header. I need instructions on DFDM or do I need to call support and have them walk me through it. I made a backup copy of the company files that I can use for testing.

Sage used to have a utility for fixing bad dates, but I can't seem to find it in the new KB.  Perhaps someone from Sage will post a link.