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 Bad Line Items Fix
Viewed 2582 times since Tue, Jul 17, 2012
Manager SE: Florida Sales Tax Calculation
Viewed 2451 times since Thu, Dec 14, 2017
Odometer In value is required by the system manager. Please enter a value greater than or equal to the Previous Odometer
Viewed 1881 times since Thu, Jul 26, 2012
Shop Management: Program Security (List of Protected Areas)
Viewed 658 times since Wed, Jan 3, 2018
How to Write Off Bad Debt
Viewed 2568 times since Fri, Aug 3, 2012