Hi, The vendor currency is not directly available ...
# inventory
b
Hi, The vendor currency is not directly available as a separate field in the Item CSV Import because NetSuite determines the vendor currency from the vendor record currency setup. For updating the preferred vendor and vendor-specific purchase price, you usually need to import the Item Vendor sublist information. The key fields are: • Preferred Vendor → Item > Vendors sublist > Vendor • Purchase Price → Item > Vendors sublist > Purchase Price • Vendor → Used to identify which vendor the price belongs to The currency will be inherited from the vendor record. Since your vendor is configured with USD currency, the purchase price should be entered in USD and NetSuite should use that currency when creating purchase orders for that vendor. If the vendor has multiple currencies enabled, you may need to review the vendor currency settings first, but there is generally no separate "Vendor Currency" column available in the Item CSV import. One thing to check is that the Multiple Vendors and Vendor Pricing features are enabled, because the vendor purchase price is stored under the Item Vendor sublist rather than the main item fields. If CSV Import does not expose the vendor sublist fields in your account, another option would be using SuiteScript or a Map/Reduce script to update the item vendor pricing records directly.
n
Thank you so much for your detailed explanation and guidance. I really appreciate you taking the time to help. I went ahead and imported the data without specifying the currency, and NetSuite automatically picked up the vendor's primary currency, so it worked perfectly. Thanks again for pointing me in the right direction!