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
Record Lock
Viewed 2741 times since Fri, Jun 20, 2014
SE Reports Strategy
Viewed 1537 times since Tue, Oct 4, 2016
Manager SE "You do not have an active license" Message
Viewed 2813 times since Wed, Sep 9, 2015
Fix Inaccurate Avg Part Cost
Viewed 2561 times since Thu, Mar 12, 2009
Creating A Manual Purchase Order
Viewed 6246 times since Wed, Jun 6, 2012
SE Recommended Local Backup Instructions
Viewed 4225 times since Wed, Jan 14, 2015
Florida State Reqs: Estimates & Invoices
Viewed 3276 times since Tue, May 22, 2012
Viewed 1054 times since Thu, Dec 29, 2016
Adding Shop Logo to EST/RO/INV 6.x SE
Viewed 22974 times since Tue, May 22, 2012
How to Add Exceptions to AVG Anti-virus
Viewed 1329 times since Tue, Aug 9, 2016