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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Mass update & multi currency
We buy items in several non-base currencies and sell items in base and non-base currencies.
We find the mass update tool of little use as none of the "based on" options will take into account recent variation in currency exchange rates - we want to add a fixed percentage onto our vendors pricing
(having a "based on" option of 'preferred vendor price' would be the solution to our problem)
Has anyone else had this problem and found a solution
OR would anyone here be able to produce a script for us that updated our base currency item prices based on preferred suppliers price (mostly in non base currency) taking into account exchange rates?
0