On the Financial subtab of a Vendor record, under the Items subtab, you can list items available from that vendor and specify the vendor codes and prices for that item. You also can use CSV import to import vendor price lists from an existing comma delimited file.
If you use the Multiple Currencies feature, you can import prices for an individual item in multiple currencies.
To import a vendor price list:
-
Create the import file.
The import file should contain the following fields in order, with no header row:
-
Item Name (For initial import, the item name must be present. For later updates, it is not required as the vendor code is used to identify each item.)
-
Vendor Code (If your vendor uses a name for this item that is different from the name you use, you can enter up to 60 characters as the vendor's name for this item here.)
-
Purchase Price
-
Price Schedule (optional)
-
Currency (This field is only present if you use the Multiple Currencies feature.)
Important
The items listed in the file must already exist in your NetSuite account and the names must exactly match those in your account.
-
-
Go to Lists > Relationships > Suppliers.
-
Click Edit next to the Vendor record.
-
Click the Financial subtab.
-
Click the Items subtab.
-
Click Import Price List.
The Import Vendor Price List popup window opens.
-
Click Browse and navigate to the vendor price list file.
-
Click Save.
Upon successful import, each item from the imported vendor price list is listed on the Items subtab with the associated vendor codes and prices. The vendor record also is displayed on the Vendor subtab of each item's record with the vendor name, vendor's item code and purchase price.