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
Record Lock
Viewed 1631 times since Fri, Jun 20, 2014
Shop Management: Purchase Order Taxes for Canceled or Unreceived Parts (Canadian Customers)
Viewed 1406 times since Tue, Mar 5, 2019
Adding Shop Logo to EST/RO/INV 6.x SE
Viewed 29668 times since Tue, May 22, 2012
Setup for Gmail or Yahoo Email Accounts For Use With SE Shop Mgmt.
Viewed 7353 times since Tue, Aug 5, 2014
Shop Management: How to Set Up FirstCall Online Parts Catalog
Viewed 2556 times since Mon, Jul 8, 2019