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
SE Reports Pack (Samples)
Viewed 7488 times since Fri, Aug 9, 2013
Flagging a RO As Comeback
Viewed 6640 times since Wed, Jun 6, 2012
How to: Enable a Catalog and Link a Vendor in Manager
Viewed 5194 times since Fri, Sep 11, 2015
Handling Changes to MI Part Core Tax on Manager SE Estimate/R.O./Invoice
Viewed 990 times since Tue, Mar 28, 2017
User Guide / Directions / Manual
Viewed 15770 times since Thu, Oct 4, 2012
Tracking eCRM Coupons in Mgmt SE
Viewed 3159 times since Wed, Jun 6, 2012
SE Bad Line Items Fix
Viewed 4327 times since Tue, Jul 17, 2012
SE Recommended Local Backup Instructions
Viewed 4571 times since Wed, Jan 14, 2015
Viewed 1301 times since Thu, Dec 29, 2016