What version and patch level are you dealing with?

You may want to review https://sagecity.na.sage.com/support_communities/sage_erp_x3/f/sage-x3-general-discussion-forum/97372/change-stock-location-via-an-import/291947#291947

and in the knowledgebase (https://support.na.sage.com/) KB ID 75594.

Note: There is also a correction in V11P5  (#2162) that corrects CUMWIPQTY and CUMWIPQTA in the STOCK table in the event of an import failure.

Casey Knapp

Principal Analyst, North America Services

Sage

Version 8 patch 3