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
How to Write Off Bad Debt
Viewed 12620 times since Fri, Aug 3, 2012
SE Reports Strategy
Viewed 1890 times since Tue, Oct 4, 2016
Appointment Creation in New Schedule vs. Legacy
Viewed 1301 times since Wed, Apr 5, 2017
Fix Inaccurate Avg Part Cost
Viewed 2817 times since Thu, Mar 12, 2009
Wrong Vehicle Displays in Catalog
Viewed 2680 times since Tue, Oct 21, 2014
Flagging a RO As Comeback
Viewed 6878 times since Wed, Jun 6, 2012
Creating A Manual Purchase Order
Viewed 6824 times since Wed, Jun 6, 2012
Search By First Name
Viewed 10227 times since Wed, Jun 6, 2012
Viewed 1445 times since Thu, Dec 29, 2016