What is Vendor Record in Netsuite?
Vendor:
A vendor means anyone who provides goods or services to a company or individuals.
These records are used to track information of your vendors.
Enter New Vendor record:
Go to Lists > Relationships > Vendors > New
Fields on Vendor record:
- Custom Form field, accept the default form or select the form you prefer to use to
create this record. - Vendor ID field, enter vendor's name the way it should appear in all lists.
If this field is blank, this field fills with the name that is entered in the Company Name field.
If Auto-Generated Numbering is used, this field fills with the vendor number or code.
- Next to Vendor ID, if the Auto box is checked then one can manually enter a name for
this record. If this box is not checked, a name or number is assigned for this record,
based on the settings at Setup > Set Up Auto-Generated Numbers. - Next choose whether vendor is a company or an individual.
- Company Name field, here enter the legal name of this vendor.
If Auto-Generated Numbering is used then enter the vendor name to ensure that it
appears along with the code in lists.
appears along with the code in lists.
- Web Address field, URL for this vendor's web address.
- Category field, select the category.
To create new categories, Setup > Accounting > Setup Tasks > Accounting Lists > New.
- Image field, to select an image.
- Comments field, to enter any additional notes.
- Email, enter the email address of vendor. If vendors are given permit for online access,
this becomes part of their access code. - Phone, enter a phone number for vendor. Can also enter alternate phone number.
- Fax, enter vendor’s fax number.
- Address field automatically shows the default billing address that you enter and add
using the Address subtab. - Subsidiary field, select the subsidiary that can share this vendor.
- Credit Limit field, enter the credit limit for this subsidiary. The default is no value, or
no credit limit. - Tax Code field, select the tax code you want to apply.
Relationships:
- Contacts subtab, enter information about your contacts with this vendor.
Communication:
- Phone Calls subtab, view or enter new phone calls for this vendor.
- Tasks subtab, view or enter CRM tasks records relating to this vendor.
- Events subtab, enter events for this vendor.
- Files subtab, you can select and add files from the File Cabinet that are associated
with this vendor. - User Notes subtab, add and track notations about this vendor.
Address:
- Check the Default Shipping address box if this is the main address to send returned
products to the vendor. - Check the Default Billing address box if this is the remittance address where payments
should be sent for this vendor. - Enter the Label for this address.
- Ensure the value for Country is correct.
- In the Attention field, enter the person at this address who should be notified of receipt
of documents or goods. - In the Addressee field, enter the company name that should show on the shipping label
here. - Enter a phone number where the person receiving the package or mail can be
reached. - Enter the vendor’s street address.
- To enter additional addresses, click Add.
Marketing:
- Campaigns subtab shows recent campaigns for this vendor.
- Subscriptions subtab shows subscriptions for this vendor.This vendor is considered
as subscribed if the box is checked in Subscribed column. - Global Subscription Status field, select the status you want to assign this vendor.
Account Information:
- Legal Name field, enter the legal name for this vendor for financial purposes.
- Business Number field, enter the 15-digit registration number that identifies this vendor
as a client of the Canada Customs and Revenue Agency (CCRA) - Account field, enter the account name or number for this vendor.
- Select a Default Expense Account for purchases from this vendor.
- Default Payables Account field, choose the default payable account for this vendor
record. - Terms field, select the standard discount terms for this vendor's invoices.
- If Multiple Currencies feature enabled, select the currency.
Tax Information:
- Tax Reg. Number field, enter the vendor’s VAT registration number.
- Enter vendor's Tax ID.This number is a Social Security Number (SSN) for an individual.
- Check the 1099 Eligible box, If more than $600 is paid for this vendor for the
services this year.
Balance Information:
- Enter the Opening Balance of this vendor's account.
- Enter or pick the date of the balance in the Opening Balance field.
Project Information:
- Check the Project Resource box to enable this vendor to be chosen as a resource
on tasks and jobs. - Select a Work Calendar for this vendor.
- In the Labor Cost field, enter the cost of labor for this vendor to be able to calculate
profitability on jobs.
Schedules:
If Quantity Pricing feature (used to apply prices you have negotiated with vendors) is used
then the Schedules subtab shows pricing schedules for this vendor.
then the Schedules subtab shows pricing schedules for this vendor.
ACH:
If ACH Vendor Payments feature is enabled, then enter bank account information for this
vendor in ACH subtab.
vendor in ACH subtab.
Transactions:
- Enter new transactions for this vendor using New Purchase Order or New Bill .
- Existing transactions for this vendor show in the list.
Items:
- Click Import Price List to import a price list for this vendor.
- Items associated with this vendor show in the list.
Preferences:
- Email Preference field, select the format for email that is sent to this person
or company. Select Default to use the preference set at Home > Set Preferences. - Print on Check As field, enter the vendor name the way it should appear on a check.
- Send Transactions Via:
- Email – Check this box to check the To Be Emailed box by default on transactions
when this vendor is selected. - Print – Check this box to check the To Be Printed box by default on transactions
when this vendor is selected. - Fax – Check this box to check the To Be Faxed box by default on transactions
when this vendor is selected.
System Information:
- Date Created field displays the date this vendor record was entered.
- If you check the Inactive box, this vendor will no longer appear on a list unless
you check the Show Inactives box.
Access:
- Check the Give Access box to give this vendor access.
- Check the Send Notification Email box, which sends an email message to
the vendor regarding access. - Password field, enter a password for the vendor to login with.
- Retype your password in the Confirm Password field.
- Check the Require Password Change on Next Login box to require this
vendor to change their password on their next login to NetSuite. - In the Role column, select a role of vendor.
Time Tracking:
If vendor time tracking permissions is given then, in the Time Approver field, select
an employee to approve time tracked by this vendor.
an employee to approve time tracked by this vendor.
If a Time Approver is not selected, any time tracked by this vendor is automatically
approved until entered against a project with project time approval preferences defined.
approved until entered against a project with project time approval preferences defined.
Editing a Vendor Record:
Go to Lists > Relationships > Vendors
Click edit next to the name of vendor make changes and then save.
Inactivating a Vendor Record:
Go to Lists > Relationships > Vendors
Click edit next to the name of vendor , check the Inactive box and then save.
Deleting a Vendor Record:
Go to Lists > Relationships > Vendors
Click edit next to the name of vendor - under Actions, click Delete.
Merging Vendor Records:
- Go to Lists > Relationships > Vendors
- Click edit next to the name of the vendor , this serves as the source vendor
which will be merged into the target vendor record.
Source vendor will be deleted during merge process.
- After clicking Merge, select the target vendor.
Both the source and target vendor records must have the same primary subsidiary
to merge the records.
to merge the records.
- On the Duplicate Resolution Status page, the merge is queued for process.
Click Refresh to process the merge or the Cancel link to halt the merge process. - Go to Lists > Relationships > Vendors and verify that the source vendor does
not appear in the vendor list.
Assigning Roles to Vendors:
- Go to Setup > Company > Setup Tasks > Enable Features >
under Web Presence subtab > Check Vendor Access box > Save. - Create Vendor record and give access by checking the Give Access box
under Access subtab and also select a role for this vendor.
Associating Vendors with Items:
- Go to Lists > Accounting > Items
- Click edit next to an item.
- On the Purchasing/Inventory subtab, click the Vendors subtab.Here
set item price based on subsidiary. - In the Preferred Vendor field, select a vendor.
- Click Save.
Importing a Vendor Price List:
- Create the import file which contains the following fields in order, with no header row:
- Item Name
- Vendor Code.
- Purchase Price
- Price Schedule (optional)
- Currency (if using Multiple Currencies feature)
- Go to Lists > Relationships > Vendors - click edit next to vendor record.
- Under Financial subtab, click Items subtab, clcik Import Price List.
- Import Vendor Price List popup window opens, here browse and navigate
to the vendor price list file. - Save.
Multiple Venodrs:
For this we need to enable Multiple Vendors feature:
- Enter Vendor records.
- Enable feature - [Go to Setup > Company > Setup Tasks > Enable Features
> Click the Items & Inventory subtab > Check the Multiple Vendors box > Save]. - Associate Vendors with items.
Please comment if you have any question regarding this.
Thanks
Abhi
Comments
Post a Comment
Thanks for you message, please join us on Facebook and Linkedin