Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Import purchase price using purchase description as mapping key
Is there a way to do this?
Update purchase price in item records by using the Vendor purchase description as the mapping key?
Every month I get updated prices from my vendors, I want to trim their excel file down to only their item # and price. save as CSV and import.
It is a lot of work to translate their item # in to are item name/number with their new purchase price. We usually use VLOOKUP in excel and connect the dots from there..
I hope this is not another hurdle that NS has overseen to remove.
Thank you for your help in advance
0