We are attempting to Remove the Location from all our Inventory through a CSV update on the Item records. The Location fields are all Drop Down boxes with "Warehouse" selected as the Preferred Location and the Classification Location. (We are using Multi-Location in NetSuite) We currently set up a Subsidiary in our Sandbox Account and through testing realized we cannot have the Location fields set (they must be blank) on the Item Records.
Is there a way we can update all the Inventory (in our LIVE Account) through a CSV Import?? I have tried leaving those fields blank and also used NULL in hopes it would clear those fields. So far no luck.
Anyone know the answer to this?? If we can't update with a CSV then we are going to have to manually edit hundreds of item records.