Skip to content


Can you auto-generate a vendor ID number?

Lydia asked 8 years ago
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?
Lorren Zemke answered 8 years ago
There is no built-in function in SmartConnect to generate a next vendor id number. You could do this with a Calculated Column that would read a SQL table for the next number or generate that number on the fly.

If you would like to submit an answer or comment, please sign in to the eOne portal.