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 11199 times since Fri, Aug 3, 2012
Firstcall Online (FCO) No internet Connection - Catalog Communication Error
Viewed 2052 times since Tue, Sep 1, 2015
Manager SE 6.x Export Data (MM) Updated to replace Excel
Viewed 16056 times since Wed, Jun 13, 2012
User Guide / Directions / Manual
Viewed 14718 times since Thu, Oct 4, 2012
Export Data from Manager SE Followup Reports to .CSV format
Viewed 2694 times since Tue, Jul 17, 2012
Email Setup Shop Management SE (V6)
Viewed 25152 times since Wed, Mar 27, 2013
Prior Release Details
Viewed 1792 times since Fri, Nov 20, 2015
How To Add New Referral Type
Viewed 8410 times since Thu, Sep 1, 2011
How Do I Add/Edit Payment Types? SE
Viewed 11266 times since Wed, Jun 6, 2012