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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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