RE: Dispatch of Controlled item
I don't know if this would help for Dispatch of Controlled items, but it works for me if I need to adjust in controlled items. When it imports, it only looks at the first two columns in the csv file. Any additional columns are ignored.
I put the part number in the 3rd column so I can keep track of where I'm at.
Lotnumber,Qty,Partnumber
The rows that I don't want to import (the rows for subsequent part numbers)
I replace the comma with a * character.
Lotnumber*Qty*Partnumber
Since its looking for csv, those lines are ignored.
I replace the "*" with "," as I work my way down the list.
This works best when you have many lot numbers per part number to import.
|