This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi guys, whats the best practice for adding the legacy vendor account number onto NetSuite? The obvious answer is to use the "Account" field on the Vendor record (under Financial tab) - but doing that means that this field will pull through to the Memo field on the Bill, which isnt what we want. Any advice appreciated :slightly_smiling_face:

Normally I use a custom field for legacy values that we want to have captured - but not have them drive functionality in NS.

You can even have it be global searchable - so they don't have to "relearn" the way they used to find vendors in the global search bar at least (no promises on transactions)

Agreed with <@UER9Q3SGM>.  We wanted to drive netsuite functionality so we used the External ID as the legacy vendor number so we could easily import data (importing data with names is a pain especially when they change).  We then expose the External ID on the vendor form using a custom field (sourcing the external ID) so associates could easily see the value.  Hope that helps.

Thanks both <@UER9Q3SGM> and <@UJ0137EMV> - great ideas, and i guess the moral of the story, dont use Accounts field. Thanks!