ok all.. I a need to create sales orders via cvs import.. so they require a unique ID or an external ID file in order to generate a new SO.. do these unique identifiers have to be unique for every import or just the specific import file. ? that can be a pain in the but to generate and track and external id

using the date, file name, line # , So# combination helps set a cadence if you dont have an external id (which would be the internal id of the system you are extracting from)

I normally create a random External ID by doing the following: For the current date (i.e. the date I am importing) YYYYMMDDHHMMRRR. Most you can work out (YYYY is the year, etc.) and RRR is a sequential number (001, 002, 003, etc.). This way you never have to 'track' which External ID's you have used before, and you will always be importing on a different day/hour/minute.