Issue in printing IC Valuation Report in Sage 2017

Hi Guys

My client recently have upgraded from v6.0 to vv2017. Also change from SQL 2005 to SQL2016. They are running on VM machine (both old and new server). 

In the old VM, they are able to print the IC Valuation report from 2005 to 2017 (by Transaction cost and print in summary even though we did not set any max limit to the SQL.

However in the new environment, we have set the SQL max limit to 4gb and when they print the IC Valuation Report, they encountered the above message after running sometime.

I have load their data (only the IC data) on my VM to test. Still encountered the same issue.

Any idea?

Any help is much appreciated.

  • That is an old issue with the item valuation report, it seems to return every couple of versions. Take it up with Sage support.
  • Is the report being ran with a from cutoff date that is many years back? It might be the issue that started with the new crystal runtime introduced in v6.1. I believe Sage's position on this issue is to use a from cutoff date that is sooner. It is a crystal issue so SAP would need to address it. If you need IC valuation info that far back you may want to consider a custom report in crystal or Sage Intelligence.