Archiving sales orders errors
Problem
Sales order archiving can sometime give the following errors. Can apply to 7.00.175, 7.01.00, 7.02.01 databases.
“ Error : String or binary data would be truncated.”
The error is caused when there are sales orders with various fields of greater length than can be stored in the table where archived data is transferred SO_SalesHistory. The most common fields are:
Email Logs
Payment Types
PrintlogID
Description
An additional error that could be encountered in sales order archiving relates to sales orders created from Service Manager jobs. It errored as follows:
Solution
SQL skills are required
A working knowledge of SQL Management Studio is required to complete this task
Download and apply the attached modified stored procedure to correct the issues.