Can you auto-generate a vendor ID number?
We are looking to see if the vendor transactions from an excel spreadsheet can evaluate the vendor name to see if it exists within the vendor master table, if not, auto assign the next available vendor ID number, otherwise, assign the vendor ID that exists in the table? Is this possible? I know the vendor ID is a required field but I’m not sure if you can write scripting against it?
Answers