Home » Categories » 01. Shop ManagementSE v 6.x and 7.x

When running a report: String or Binary data would be truncated. The statement has been terminated.

Symptom: When running any financial report (such as Revenue by GL Code or Business Summary) the following error occurs:

 
Error Title: String or Binary data would be truncated. The statement has been terminated

 

Solution: Shorten the description used on Tax and Labor Rates. Excessively long descriptions cause this error due to the fact the report template does not have room for them. 

E.g., if the tax description is 'Wisconsin State Sales Tax' shorten it to 'WI State Sales Tax'

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Comments Comments
Related Articles RSS Feed
User Guide / Directions / Manual
Viewed 19292 times since Thu, Oct 4, 2012
Shop Management: How to set up Program Security
Viewed 550 times since Tue, May 22, 2018
Fix Inaccurate Avg Part Cost
Viewed 3721 times since Thu, Mar 12, 2009
Manager Crashes when using drop down selection on Technician
Viewed 4118 times since Thu, Feb 21, 2013
Shop Management crashes after sending email with Microsoft Outlook
Viewed 680 times since Fri, Jun 8, 2018