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.
Units of Measure - Updating Prices
I am trying to create an elegant way of keeping inventory item prices correct during price updates where units of measure (UOM) are used.
For example.
ITEM-A is setup with UOM of type "Metres". Purchase Unit = "20M", Sale Unit = "Metre"
Prices are imported using a CSV import.
Vendor price is $100. RRP is $200.
Item is updated, however we end up with the issue where Netsuite now says we are selling every metre for $200, ie the 20M roll will be sold for $4,000.
We really want the sale price to be set as $200/20 = $10
I'd like to be able to create a saved search or custom field on the item record that shows the CONVERSION RATE (in this case "20") for any given item.
0