When receiving a SQL Error upon attempting to Save or Close a Work Order, check the error message for the length of the Bill To Name or Ship To Name. If the value is longer than 50 characters, the Save and Close of the Work Order will not allow that. In this case the Work Order was created when the Customer Name was not longer than 50 characters, but then it was changed to longer than 50 Characters in the Customer Form after the Work Order was opened. If you went to Close the Work Order it would provide the SQL Truncate Error.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article