Hi,
Just wondering has anybody come across this error on the HQ Client event log. The text below is as much of the query I could retrieve from the client log. This error occurs processing a 401 worksheet, where interstore transfers are involved,from HQ to store - note it occurs intermittantly and does not consistantly occur after every interstore transfer. The transfers in are created correctly at the store and are complete. Maybe there is an issue with the PurchaseOrder,PurchaseOrderEntry tables on the store database? Any help would be greatly appreciated.
Regards, Pat.
Error -2147217833: String or binary data would be truncated. UPDATE #POTemp SET POType = CASE POType WHEN 2 THEN 3 WHEN 3 THEN 2 ELSE POtype END, PONumber = RIGHT('00000' + CAST(StoreID AS NVARCHAR), 5)