Home » Categories » 01. Shop Management SE

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
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 1925 times since Thu, Feb 21, 2013
Shop Management crashes after sending email with Microsoft Outlook
Viewed 2404 times since Fri, Jun 8, 2018
Shop Management Software and Carfax
Viewed 12547 times since Wed, Mar 13, 2013
Shop Management: Back Ordered, Partially Received, and Cancelled Parts
Viewed 2118 times since Mon, Aug 13, 2018