Home » Categories » 01. Shop ManagementSE v 6.x and 7.x

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
Late Fee Calculation - Annual Percentage Rate (APR)
Viewed 700 times since Fri, Sep 2, 2016
Change Sequence of Line Items on Order Screen SE
Viewed 501 times since Wed, Jun 6, 2012
SE Reports Strategy
Viewed 132 times since Tue, Oct 4, 2016
Tracking eCRM Coupons in Mgmt SE
Viewed 841 times since Wed, Jun 6, 2012
SE DEFAULT PRINTER NOT STICKING IN WINDOWS 10
Viewed 358 times since Thu, Dec 29, 2016