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
SE Using Print Preview Export Option
Viewed 4545 times since Wed, May 23, 2012
How To Launch SE Demo Mode
Viewed 1265 times since Wed, May 22, 2013
Manager SE: ProSpect User Guide June 2019
Viewed 4182 times since Tue, Dec 4, 2018
SE Using Custom Data Export Option
Viewed 1790 times since Wed, May 23, 2012
Shop Management SE Mail Merge
Viewed 935 times since Tue, Jul 2, 2013