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
Hi StephenRobertso , welcome to the forum. Can you attach the log file created when you import the inventory adjustment file?
Hello Mike
Thanks fro looking at this for me.
I have attached a INVADJ.TXT file which has some sample data. I have also attached the importlog.txt. file
Thanks
Steve
Hi Steve StephenRobertso , sorry for the delay. From the log, the -6 errors are probably caused by blank lines at the end of the text file, so just delete those; and the missing location is probably caused by the location value of 001. If you have created multiple locations, look at the location list and use the appropriate ID value. If you have not added any, then the file will only have the one (default) location, and the ID value should be 1.
The row sequence of the inventory adjustment file seems unusual, in that rows with like ID (journal) numbers are generally together. But the rows should still be imported.
Hope this gets you closer to a correct import.
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
