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: How to Set Up FirstCall Online Parts Catalog
Viewed 1145 times since Mon, Jul 8, 2019
Add a New Technician in version SE 6.x
Viewed 1572 times since Tue, May 22, 2012
Setup for Gmail or Yahoo Email Accounts For Use With SE Shop Mgmt.
Viewed 5103 times since Tue, Aug 5, 2014
Printing Issues After Windows Update (October 3, 2019)
Viewed 14774 times since Fri, Oct 4, 2019
Add a New Service Writer in version SE 6.x
Viewed 5116 times since Tue, May 22, 2012