Inventory Import Problems

StephenRobertso

Hello

I am having problems imorting a Inventory Adj file.

I have added 1000 items in the item list by exporting a Item list, opening with Excel, adding the new items and then exporting as a text docuent. This all works ok.

When i try and use the same process to adjust the opening quantities for the same items i recieve errors and no import.

The items will no tbe exported unless they ave a qty value. 

I have tried several variations with no joy. I have attached the Item and Inventory files i am trying to use, as well as the origonal xl docment conating the relevent info.

 

 

Thank you

Stephen

 

 

INVADJ.TXT

ITEM.TXT

StephenRobertso

Hello Mike

Yes thge Location was teh problem. I had to change the cell reference to Text in order to allocate 001 as per the location address then it imported.

Thanks for your help

 

Steve