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
Flagging a RO As Comeback
Viewed 7360 times since Wed, Jun 6, 2012
Tracking eCRM Coupons in Mgmt SE
Viewed 3536 times since Wed, Jun 6, 2012
Add a New Technician in version SE 6.x
Viewed 4046 times since Tue, May 22, 2012
Manager SE 6.x Export Data (MM) Updated to replace Excel
Viewed 17333 times since Wed, Jun 13, 2012
Shop Management Software and Carfax
Viewed 9237 times since Wed, Mar 13, 2013
Shop Management: How to perform a refund
Viewed 2009 times since Tue, Dec 12, 2017
Creating A Manual Purchase Order
Viewed 9018 times since Wed, Jun 6, 2012
Exception When Trying to Confirm Parts Using Order Options
Viewed 2210 times since Thu, Apr 23, 2015
Adding Shop Logo to EST/RO/INV 6.x SE
Viewed 27731 times since Tue, May 22, 2012
Shop Management: How to Lock a Specific Markup Value for Multiple Parts in Inventory
Viewed 2160 times since Fri, May 15, 2015