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
Manager Crashes when using drop down selection on Technician
Viewed 3799 times since Thu, Feb 21, 2013
Error Attempting to Add a New Technician
Viewed 2082 times since Fri, Feb 6, 2015
Use Part To Handle Fee Or Tax SE
Viewed 3154 times since Wed, Jun 6, 2012
How To Launch SE Demo Mode
Viewed 3515 times since Wed, May 22, 2013
Clearing A Late Fee With F5 Batch
Viewed 4179 times since Wed, Jun 6, 2012
Handling Changes to MI Part Core Tax on Manager SE Estimate/R.O./Invoice
Viewed 1329 times since Tue, Mar 28, 2017
Add a New Technician in version SE 6.x
Viewed 3915 times since Tue, May 22, 2012
Prior Release Details
Viewed 2513 times since Fri, Nov 20, 2015
Export Data from Manager SE Followup Reports to .CSV format
Viewed 3877 times since Tue, Jul 17, 2012
Shop Management: Program Security
Viewed 694 times since Wed, Jan 3, 2018