By default, a Quote retains all pricing 'as it was' prior to any price increase applied in NetSuite.
Not only Custom Pricing, but Price Level pricing (where the price level price for that item has been increased) . So for example:
- Item 1 is priced at Base Price at £5 per item
- Quote is generated for 2 x Item 1 at Base Price £5 x 2 Total £10
- Pricing on Item 1 is increased - Base Price to £6 per item
- Quote still shows 2 x Item 1 at £5 x 2 Total £10
- (which I don't think is a problem - this is what was quoted at the time)
- Quote is converted to a Sales Order - this lists 2 x Item 1 at £5 x 2 Total £10
- This I think is incorrect, it should pick up the new pricing for the item(s)
Has anyone found a way around this problem? The only process we can find is to change the customer on the Sales Order to a different Customer, and then revert it back to the original one. This resets all the pricing to the correct rates (but you then have to re-apply delivery address and other customer specific fields). You can also use the same process on a Quote (to 'refresh' it to correct pricing).
Surely there should be a more efficient way to update / refresh pricing on a transaction?