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
Add a New Technician in version SE 6.x
Viewed 3109 times since Tue, May 22, 2012
Firstcall Online (FCO) No internet Connection - Catalog Communication Error
Viewed 1937 times since Tue, Sep 1, 2015
Inventory Worksheets + Update Function
Viewed 4097 times since Wed, Jun 6, 2012
Change Ownership
Viewed 5415 times since Fri, Jan 16, 2015
Tracking eCRM Coupons in Mgmt SE
Viewed 2770 times since Wed, Jun 6, 2012
Shop Management SE Mail Merge
Viewed 10102 times since Tue, Jul 2, 2013
Manager SE "You do not have an active license" Message
Viewed 2501 times since Wed, Sep 9, 2015
Odometer In value is required by the system manager. Please enter a value greater than or equal to the Previous Odometer
Viewed 4783 times since Thu, Jul 26, 2012
Shop Management Software and Carfax
Viewed 7054 times since Wed, Mar 13, 2013
Late Fee Calculation - Annual Percentage Rate (APR)
Viewed 924 times since Fri, Sep 2, 2016