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
  • 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
Shop Management Software and Carfax
Viewed 4628 times since Wed, Mar 13, 2013
Shop Management: Back Ordered, Partially Received, and Cancelled Parts
Viewed 892 times since Mon, Aug 13, 2018
User List Name Stores Screen Preferences
Viewed 1100 times since Thu, Jul 30, 2009
Shop Management: Email setup
Viewed 12227 times since Wed, Mar 27, 2013
Manager SE: Lube Sticker Printer User Guide
Viewed 1277 times since Tue, Oct 30, 2018