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
How To Search Purchase Orders
Viewed 1355 times since Wed, Jun 6, 2012
Manager SE "You do not have an active license" Message
Viewed 7935 times since Wed, Sep 9, 2015
Use Part To Handle Fee Or Tax SE
Viewed 2250 times since Wed, Jun 6, 2012
How to Enable a Catalog and Link a Vendor in Manager
Viewed 9359 times since Fri, Sep 11, 2015
Search By First Name
Viewed 7092 times since Wed, Jun 6, 2012