Vendor

Internal ID: vendor

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
accountnumber text true Account false If your vendors assign account numbers to you, enter one here. This number will later appear in these places: * In the Vendor # field on purchase orders * In the Memo field on checks
altemail email true Alt. Email false
altphone phone true Alt. Phone false Enter an optional alternate phone number for this record. Phone numbers can be entered in the following formats:999-999-9999, 1-999-999-9999, (999) 999-9999, 1(999) 999-9999 or 999-999-9999 ext 9999 .
autoname checkbox false Auto false
balance currency false Balance false The vendor's current accounts payable balance due appears here.
balanceprimary currency false Balance false
bcn text false Business Number false Enter the 15-digit registration number that identifies this vendor as a client of the Canada Customs and Revenue Agency (CCRA).
billpay checkbox false Enable Online Bill Pay false Check this box in order to send this vendor payments online. Before you can use this feature, you must set up Online Bill Pay at <_TABNAME=ADMI_XML_PAYTRUST_SETUP_> > <_TASKCATEGORY=ADMI_XML_PAYTRUST_SETUP_> > Online Bill Pay.
category select true Category false You can select the category that applies to this vendor. To add choices to this list, go to <_TABNAME=LIST_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY=LIST_ACCOUNTINGOTHERLIST_> > Accounting Lists > New > Vendor Category. You must select a Tax agency for sales tax agencies, payroll tax agencies and payroll benefits providers.
comments textarea true Comments false Enter any other information you wish to track for this vendor.
companyname text true Company Name false In the Company name field, enter the supplier's legal name. If you use Auto-Generated Numbering, you should enter the vendor name here to ensure that it appears along with the code in lists.
contact select false Primary Contact false
creditlimit poscurrency true Credit Limit false Enter an optional credit limit for your purchases from this vendor. If you have a NetSuite OneWorld account, enter the global credit limit for this vendor and any assigned subsidiary. This value can exceed the sum of the vendor and subsidiary credit limits. This credit limit sets a maximum currency amount that should be spent using credit without making a payment. The value displays in the vendor&#x2019;s primary currency. The default is no value, or no credit limit. You can place the vendor on hold by entering 0 (zero.) Any new purchase order or vendor bill transaction displays a warning message. You cannot enter a negative value. NetSuite validates the transaction amounts on purchase orders and vendor bills against the global credit limit specified in the Credit Limit field. NetSuite does not include individual subsidiary credit limits in the global credit limit validation.
currency select false Primary Currency true Select the currency that this vendor uses. If you use the Multi-Currency Vendors feature, select this vendor's primary currency. You can enter other transaction currencies on the Currencies subtab below. To view existing currencies or add currencies to this list, go to <_TABNAME=LIST_CURRENCY_> > <_TASKCATEGORY=LIST_CURRENCY_> > Currencies.
customform select false Custom Form true Standard Vendor Form is selected here by default. Do not select another form if you want to continue using this form. If you have already created a custom vendor form and want to use it, select that form here. To create custom vendor forms, go to <_TABNAME=LIST_CUSTENTRYFORM_> > <_TASKCATEGORY=LIST_CUSTENTRYFORM_> > Entry Forms, and click Customize next to Standard Vendor Form.
datecreated datetime false Date Created false The date this record was created displays here.
defaultaddress address false Address false This field automatically shows the default billing address that you enter and add using the Address subtab.
defaultbankaccount select false Bank Account false
email email false Email false Enter the e-mail address of your vendor. If you allow your vendors online access, this becomes part of their access code.
emailpreference select true Email Preference false Select the format for email that is sent to this person or company. Select Default to use the preference set at Home > Set Preferences.
emailtransactions checkbox true Email false Set a preferred transaction delivery method for this vendor. Choose to send transactions by regular mail, by email, by fax, or by a combination of the three. Then, when you select the vendor on a transaction, their preferred delivery method is marked by default. * Email &#x2013; Check this box to check the To Be Emailed box by default on transactions when this vendor is selected. * Print &#x2013; Check this box to check the To Be Printed box by default on transactions when this vendor is selected. * Fax &#x2013; Check this box to check the To Be Faxed box by default on transactions when this vendor is selected. Once you enter these settings on the vendor record, these boxes are checked by default for transactions created from the vendor record or for transactions that are copied or converted. Note: These settings override any customized settings on transaction forms you use. There are also preferences to set default values for new vendor records at <_TABNAME=ADMI_PRINTING_> > <_TASKCATEGORY=ADMI_PRINTING_> > Printing, Fax and Email Preferences. On the Print subtab, Fax subtab, or Email subtab, check Vendors Default to [Print/Fax/Email] Transactions. You can also set these fields using the Mass Update function. Go to <_TABNAME=LIST_BULKOP_> > <_TASKCATEGORY=LIST_BULKOP_> > Mass Updates > General and click Vendor.
entityid text true Vendor ID true In the Supplier ID field, enter your supplier's name as it should appear in all lists. If you use Auto-Generated Numbering, this field fills with the vendor number or code.
expenseaccount select false Default Expense Account false Select the standard expense account for goods and services you purchase from this vendor. This account appears on any transaction involving this vendor. You can always change this account for any individual order or bill. Select New to set up a new account. For details on accounts, go to <_TABNAME=LIST_ACCOUNT_> > <_TASKCATEGORY=LIST_ACCOUNT_> > Chart of Accounts.
externalid text false ExternalId false
fax phone true Fax false Enter a fax number for this record. You should enter the fax number exactly as it must be dialed. If a '1' is required to fax to this number, be sure to include it at the beginning of the number. The number you enter here automatically appears in the To Be Faxed field of transactions when you select this customer. To fax NetSuite forms, an administrator must first set up fax service at <_TABNAME=ADMI_PRINTING_> > <_TASKCATEGORY=ADMI_PRINTING_> > Printing, Fax and Email Preferences.
faxtransactions checkbox true Fax false Set a preferred transaction delivery method for this vendor. Choose to send transactions by regular mail, by email, by fax, or by a combination of the three. Then, when you select the vendor on a transaction, their preferred delivery method is marked by default. * Email &#x2013; Check this box to check the To Be Emailed box by default on transactions when this vendor is selected. * Print &#x2013; Check this box to check the To Be Printed box by default on transactions when this vendor is selected. * Fax &#x2013; Check this box to check the To Be Faxed box by default on transactions when this vendor is selected. Once you enter these settings on the vendor record, these boxes are checked by default for transactions created from the vendor record or for transactions that are copied or converted. Note: These settings override any customized settings on transaction forms you use. There are also preferences to set default values for new vendor records at <_TABNAME=ADMI_PRINTING_> > <_TASKCATEGORY=ADMI_PRINTING_> > Printing, Fax and Email Preferences. On the Print subtab, Fax subtab, or Email subtab, check Vendors Default to [Print/Fax/Email] Transactions. You can also set these fields using the Mass Update function. Go to <_TABNAME=LIST_BULKOP_> > <_TASKCATEGORY=LIST_BULKOP_> > Mass Updates > General and click Vendor.
firstname text false Name false Optionally enter a first name here.
giveaccess checkbox false Give Access false Check this box to give your vendor access to NetSuite. Then, assign a role to customize the level of access. You can assign multiple roles. To let your vendor view prior transactions and purchase orders, select the Vendor Center role. You must also assign a password and email address for the vendor to log in.
globalsubscriptionstatus select false Global Subscription Status false Email recipients can have one of four subscription statuses: * Confirmed Opt-In - When an email recipient has indicated that they want to receive your campaign messages, they are assigned this subscription status. Only a recipient can set his or her subscription status to Confirmed Opt-In. * Soft Opt-In - Recipients with this status can receive opt-in messages that enable them to confirm whether or not they want to receive your email campaigns as well as email marketing campaigns. You can set a recipient&#x2019;s status to Soft Opt-In manually or through a mass update. * Soft Opt-Out - Recipients with this status cannot receive campaign email messages but can receive opt-in messages. You can change this subscription status to Soft Opt-In manually or through a mass update. * Confirmed Opt-Out - Only the recipient can set their subscription status to Confirmed Opt-Out. Recipients with this status cannot receive email campaigns or opt-in messages. Recipients with this status can only opt in again through the Vendor Center or by clicking the link in a campaign message they have received prior to opting out.
homephone phone true Home Phone false
image select false Image false Select an image from your file cabinet to attach to this record. Select -New- to upload a new image from your hard drive to your file cabinet in a new window.
incoterm select false Incoterm false Choose the standardized three-letter trade term to be used on transactions related to this vendor. These terms are international commercial procurement practices that communicate the tasks, costs, and risks associated with the transportation and delivery of goods. Incoterms define where the customer takes ownership of the product and are typically used for international orders, such as when an item goes through customs or crosses a border.
is1099eligible checkbox true 1099 Eligible false If this vendor requires you to issue an annual 1099 income statement form, place a check mark in this box. Vendors you pay $600 or more a year for goods and/or services are 1099 eligible. Only vendors that use the U.S. dollar are 1099 eligible.
isinactive checkbox true Inactive false When you check this box, this vendor will no longer appear on a list unless you check the Show Inactives box at the bottom of the list page.
isjobresourcevend checkbox true Project Resource false Check this box to enable this vendor to be chosen as a resource on tasks and jobs. As a job resource, a vendor can be assigned to complete a task or to manage a project. Clear this box if you do not want this vendor assigned as a job resource. Note: If you use NetSuite OneWorld, you cannot share a vendor with multiple subsidiaries and define the vendor as a resource on tasks and jobs.
isperson radio true Company false Next to Type, select to identify the supplier as a Company or Individual.
laborcost currency true Labor Cost false Enter the cost of labor for this vendor in order to be able to calculate profitability on jobs.
lastmodifieddate datetime false Last Modified Date false
lastname text false false Optionally enter a last name here.
legalname text false Legal Name false Enter the legal name for this vendor for financial purposes. If you entered a name in the Company Name field, that name appears here.
middlename text false false
mobilephone phone true Mobile Phone false
openingbalance currency false Opening Balance false Enter the opening balance of your account with this vendor.
openingbalanceaccount select false Opening Balance Account false Select the account this opening balance is applied to.
openingbalancedate date false Opening Balance Date false Enter the date of the balance entered in the Opening Balance field
otherrelationships select false Other Relationships false
parent integer false Parent false
payablesaccount select false Default Payables Account false Choose the default payable account for this vendor record.
phone phone true Phone false Enter a phone number for your vendor. It will appear on the Vendor List report. This field is required for the Online Bill Pay feature.
phoneticname text false Furigana false Enter the furigana character you want to use to sort this record.
printoncheckas text false Print on Check As false What you enter here prints on the Pay to the Order of line of a check instead of what you entered in the Vendor field.
printtransactions checkbox true Print false Set a preferred transaction delivery method for this vendor. Choose to send transactions by regular mail, by email, by fax, or by a combination of the three. Then, when you select the vendor on a transaction, their preferred delivery method is marked by default. * Email &#x2013; Check this box to check the To Be Emailed box by default on transactions when this vendor is selected. * Print &#x2013; Check this box to check the To Be Printed box by default on transactions when this vendor is selected. * Fax &#x2013; Check this box to check the To Be Faxed box by default on transactions when this vendor is selected. Once you enter these settings on the vendor record, these boxes are checked by default for transactions created from the vendor record or for transactions that are copied or converted. Note: These settings override any customized settings on transaction forms you use. There are also preferences to set default values for new vendor records at <_TABNAME=ADMI_PRINTING_> > <_TASKCATEGORY=ADMI_PRINTING_> > Printing, Fax and Email Preferences. On the Print subtab, Fax subtab, or Email subtab, check Vendors Default to [Print/Fax/Email] Transactions. You can also set these fields using the Mass Update function. Go to <_TABNAME=LIST_BULKOP_> > <_TASKCATEGORY=LIST_BULKOP_> > Mass Updates > General and click Vendor.
purchaseorderamount posfloat false Vendor Bill - Purchase Order Amount Tolerance false Enter the tolerance limit for the discrepancy between the amount on the vendor bill and purchase order.
purchaseorderquantity posfloat false Vendor Bill - Purchase Order Quantity Tolerance false Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and purchase order
purchaseorderquantitydiff posfloat false Vendor Bill - Purchase Order Quantity Difference false Enter the difference limit for the discrepancy between the quantity on the vendor bill and purchase order.
receiptamount posfloat false Vendor Bill - Item Receipt Amount Tolerance false Enter the tolerance limit for the discrepancy between the amount on the vendor bill and item receipt.
receiptquantity posfloat false Vendor Bill - Item Receipt Quantity Tolerance false Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and item receipt.
receiptquantitydiff posfloat false Vendor Bill - Item Receipt Quantity Difference false Enter the difference limit for the discrepancy between the quantity on the vendor bill and item receipt.
representingsubsidiary select false Represents Subsidiary false Indicates that this entity is an intercompany vendor. Select the subsidiary this vendor represents as the seller in intercompany transactions.
requirepwdchange checkbox false Require Password Change On Next Login false Check this box to require this user to change their password on their next login to NetSuite. When the user next logs in, they see the Change Password page and cannot access other NetSuite pages until a new password is created and saved. Requiring this action protects your account from unauthorized access using generic passwords and prepares your account for an audit. Note that the Require Password Change on Next Login box never displays as checked. When you check this box and save the record, an internal flag is set. When the password change occurs, the flag is cleared. If you later check the box again and resave the record, the internal flag is reset to require another password change.
salutation text true Mr./Ms... false
sendemail checkbox false Send Notification Email false Check this box if you want to send email notifying the vendor that you have given limited access to your NetSuite account. If you do not check this box, you need to tell the vendor when you have given access and how to log in. For security reasons, the email notification does not disclose the password. You will need to contact the vendor with this information.
strength text false Password Strength false
subsidiary select false Subsidiary true Select the subsidiary to associate with this vendor. If you use NetSuite OneWorld, select the primary subsidiary to assign to this vendor. You cannot enter transactions for this vendor unless a subsidiary, or primary subsidiary is assigned. The default primary currency for the vendor is the base currency of the primary subsidiary. If you select this vendor on a transaction, the transaction is associated with this subsidiary. The vendor is able to access only information associated with this subsidiary. Note: After a transaction has posted for the vendor, you are not able to change the subsidiary selected on the vendor record. If you have NetSuite OneWorld, after you save the vendor record, you cannot change the primary subsidiary.
subsidiaryedition text false Edition false
taxfractionunit select false Tax Rounding Precision false
taxidnum text true Tax ID false Enter your vendor's tax ID number (SSN for an individual). This is necessary if you are required to issue a 1099 form.
taxitem select false Tax Code false Select the default tax code you want applied to purchase orders and bills for this vendor. You can change the tax code on individual transactions.
taxrounding select false Tax Rounding Method false
tegatamaturity integer false Tegata Maturity Date false
terms select true Terms false Select the standard discount terms for this vendor's invoices. You can always change terms for an individual order or bill, however. To add choices to this list, go to <_TABNAME=LIST_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY=LIST_ACCOUNTINGOTHERLIST_> > Accounting Lists > New > Term.
title text false Job Title false
unbilledorders currency false Unbilled Orders false This field displays the total amount of orders that have been entered but not yet billed. If you have enabled the preference Vendor Credit Limit Includes Orders, then this total is included in credit limit calculations. Set this preference at <TABNAME=ADMI_ACCTSETUP_> > <_TASKCATEGORY=ADMI_ACCTSETUP_> > Accounting Preferences > General.
unbilledordersprimary currency false Unbilled Orders false
unsubscribe select false Unsubscribe from Campaigns false
url url true Web Address false Enter a URL for this vendor's Web address. When you return to this record for viewing, this address is a link.
vatregnumber text false Tax Reg. Number false Enter this vendor's VAT tax registration number.
workcalendar select true Work Calendar true Select the work calendar for this vendor.

Sublists

addressbook - Address Book

Internal ID Type Label Required Help
addressbookaddress summary Edit false
addressid text false
addrtext address Address false
attention text Attention false
city text City false
country select Country false
defaultbilling checkbox Default Billing false
defaultshipping checkbox Default Shipping false
displaystate text State/Province false
id integer ID false
internalid integer false
label text Label false
override checkbox Override false
phone phone Phone false
state text State/Province false
zip text Zip false

currency - Currencies

Internal ID Type Label Required Help
balance currency Balance false
currency select Currency true
unbilledorders currency Unbilled Orders false

Tabs

Name Label
access Access
address Address
commission Commission
custom Custom
financial Financial
general General
info Info
marketing Marketing
workflow Workflow

Search Joins

Join ID Join Description Actual Join Name
account Payable Account Account
campaignresponse Campaign Response Campaign
contact Contact Contact
contactprimary Contact (Primary) Contact
expaccount Expense Account Account
messages Messages Message
messagesfrom Messages From Message
messagesto Messages To Message
msesubsidiary Subsidiary Subsidiary

Search Filters

Internal ID Type Label
accountnumber text Account
address textarea Address
addressee text Addressee
addresslabel text Address Label
addressphone phone Address Phone
attention text Attention
balance currency Balance
category select Category
city text City
comments textarea Comments
contact text Contact
country select Country
county text County/State
creditlimit currency Credit Limit
currency select Currency
currentexchangerate currency Current Currency Exchange Rate
datecreated datetime Date Created
eligibleforcommission checkbox Eligible For Commission
email text Email
emailpreference select Email Preference
emailtransactions checkbox Email Transactions
entityid text Name/ID
expenseaccount select Default Expense Account
externalid select External ID
externalidstring text External ID (Text)
fax phone Fax
faxtransactions checkbox Fax Transactions
firstname text First Name
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
fxbalance currency Balance (Foreign Currency)
fxunbilledorders currency Unbilled Orders (Foreign Currency)
giveaccess checkbox Login Access
globalsubscriptionstatus select Global Subscription Status
group multiselect Group
hasduplicates checkbox Duplicate
image image Image
incoterm select Incoterm
internalid select Internal ID
internalidnumber integer Internal ID (Number)
is1099eligible checkbox 1099 Eligible
isdefaultbilling checkbox Default Billing Address
isdefaultshipping checkbox Default Shipping Address
isinactive checkbox Inactive
isjobresourcevend checkbox Is Job Resource
isperson checkbox Is Individual
laborcost currency Labor Cost
language select Language
lastmodifieddate datetime Last Modified
lastname text Last Name
level select Level
middlename text Middle Name
otherrelationships multiselect Other Relationships
payablesaccount select Default Payables Account
pec text PEC
permission select Permission
phone phone Phone
phoneticname text Phonetic Name
printtransactions checkbox Print Transactions
purchaseorderamount float Vendor Bill - Purchase Order Amount Tolerance
purchaseorderquantity float Vendor Bill - Purchase Order Quantity Tolerance
purchaseorderquantitydiff float Vendor Bill - Purchase Order Quantity Difference
receiptamount float Vendor Bill - Item Receipt Amount Tolerance
receiptquantity float Vendor Bill - Item Receipt Quantity Tolerance
receiptquantitydiff float Vendor Bill - Item Receipt Quantity Difference
representingsubsidiary select Represents Subsidiary
salutation text Mr./Mrs...
state select State/Province
subsidiary select Subsidiary
taxidnum text Tax ID
title text Job Title
type select Entity Type
unbilledorders currency Unbilled Orders
url url Web Address
vatregnumber text Tax Number
workcalendar select Work Calendar
zipcode text Zip

Search Columns

Internal ID Type Label
accountnumber text Account
address text Address
addressee text Addressee
addressinternalid text Address Internal ID
addresslabel text Address Label
addressphone text Address Phone
altcontact text Alt. Contact
altemail email Alt. Email
altname text Name
altphone phone Office Phone
attention text Attention
balance currency Balance
billcountrycode text Billing Country Code
billzipcode text Billing Zip
category select Category
city text City
comments text Comments
companyname text Company Name
contact select Primary Contact
country select Country
countrycode text Country Code
creditlimit currency Credit Limit
currency select Currency
currentexchangerate float Current Currency Exchange Rate
datecreated datetime Date Created
eligibleforcommission checkbox Eligible for Commission
email email Email
emailpreference select Email Preference
emailtransactions checkbox Email Transactions
entityid text Name
entitynumber integer Number
expenseaccount select Default Expense Account
externalid select External ID
fax text Fax
faxtransactions checkbox Fax Transactions
firstname text First Name
formulacurrency currency Formula (Currency)
formuladate date Formula (Date)
formuladatetime datetime Formula (Date/Time)
formulanumeric float Formula (Numeric)
formulapercent percent Formula (Percent)
formulatext text Formula (Text)
fxbalance currency Balance (Foreign Currency)
fxunbilledorders currency Unbilled Orders (Foreign Currency)
giveaccess checkbox Login Access
globalsubscriptionstatus select Global Subscription Status
hasduplicates checkbox Duplicate
homephone phone Home Phone
image select Image
incoterm select Incoterm
internalid select Internal ID
is1099eligible checkbox 1099 Eligible
isdefaultbilling checkbox Default Billing Address
isdefaultshipping checkbox Default Shipping Address
isinactive checkbox Inactive
isjobresourcevend checkbox Job Resource
isperson checkbox Is Individual
laborcost currency Labor Cost
language select Language
lastmodifieddate datetime Last Modified
lastname text Last Name
lastviewed datetime Last Viewed
level select Level
middlename text Middle Name
mobilephone phone Mobile Phone
payablesaccount select Default Payables Account
pec text PEC
permission select Permission
phone phone Phone
phoneticname text Phonetic Name
printoncheckas text Print As
printtransactions checkbox Print Transactions
purchaseorderamount float Vendor Bill - Purchase Order Amount Tolerance
purchaseorderquantity float Vendor Bill - Purchase Order Quantity Tolerance
purchaseorderquantitydiff float Vendor Bill - Purchase Order Quantity Difference
receiptamount float Vendor Bill - Item Receipt Amount Tolerance
receiptquantity float Vendor Bill - Item Receipt Quantity Tolerance
receiptquantitydiff float Vendor Bill - Item Receipt Quantity Difference
representingsubsidiary select Represents Subsidiary
salutation text Mr./Mrs...
shipcountrycode text Shipping Country Code
state select State/Province
statedisplayname select State/Province Display Name
subscription select Subscription
subscriptiondate datetime Subscription Date
subscriptionstatus checkbox Subscription Status
subsidiary select Subsidiary
subsidiarynohierarchy select Subsidiary (no hierarchy)
taxidnum text Tax ID
terms select Terms
title text Job Title
type select Type
unbilledorders currency Unbilled Orders
url text Web Address
vatregnumber text Tax Number
workcalendar select Work Calendar
zipcode text Zip Code

Transform Types

Target Record Type Field Defaults
purchaseorder customform
vendorbill customform,entity,poids
vendorpayment customform