+1-888-319-3663

COMMUNITY FORUM

Can you auto-generate a vendor ID number?

Lydia asked 6 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?

Answers

0 Vote Up Vote Down

Lorren Zemke answered 6 years ago

Lydia,
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.

Lorren

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