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: Enable a Catalog and Link a Vendor in Manager
Viewed 6815 times since Fri, Sep 11, 2015
Shop Management crashes after sending email with Microsoft Outlook
Viewed 331 times since Fri, Jun 8, 2018
QuickBooks Integrator 2.0 Frequently Asked Questions- QBI 2.0 FAQs
Viewed 3331 times since Wed, May 13, 2015
Odometer In value is required by the system manager. Please enter a value greater than or equal to the Previous Odometer
Viewed 7145 times since Thu, Jul 26, 2012
Add a New Technician in version SE 6.x
Viewed 4068 times since Tue, May 22, 2012
SE Using Custom Data Export Option
Viewed 3008 times since Wed, May 23, 2012
SE Bad Line Items Fix
Viewed 4745 times since Tue, Jul 17, 2012
Setup for Gmail or Yahoo Email Accounts For Use With SE Shop Mgmt.
Viewed 9757 times since Tue, Aug 5, 2014
Florida State Reqs: Estimates & Invoices
Viewed 3883 times since Tue, May 22, 2012
SE DEFAULT PRINTER NOT STICKING IN WINDOWS 10
Viewed 1766 times since Thu, Dec 29, 2016