Hi everyone,
I am trying to update Item records using CSV Import, specifically the Preferred Vendor and Purchase Price fields.
My requirement is:
• Vendor currency is USD
• Our NetSuite base currency is AED
• Purchase Orders are created in USD for this vendor
• I want to update the vendor-specific item purchase price in USD so that the price defaults automatically when creating POs.
I can update this manually on the item record, where I can select the vendor currency, but I cannot find the currency field/column available during CSV import.
Can someone advise which CSV fields are required to update:
• Preferred Vendor
• Vendor Purchase Price
• Vendor Currency (USD)
or is there any limitation with updating vendor currency through CSV import?
Thanks in advance.