Hello Everyone,
This is more of a question for the entire community regarding price list updates in Netsuite and the related processes.
Currently we have MANY price lists in Netsuite - below is a sample but we have about 40 lists all together. Some are basic price lists that im sure most customers use like MSRP and distributor costs. We also have some very specific price lists for specific customers , like Ferguson below.
Throughout the year, we have price updates we receive from our Corporate factory. All our pricing calculations are handled via Excel. We calculate all margins for all our price lists then import into Netsuite. We could have 1 or several price updates throughout the year. And we go through this very manual price update process every time.
What we are wondering is if anyone has figured a better way to do this? We envision a price process where all the calculations are handled within Netsuite. For example, a core price field that feeds all other price lists where we simply enter what margins we need for each price lists or customer. Essentially eliminating the external manual Excel sheet and the time consuming process of updating dozens of price lists.
We would love to hear what others are doing.
THank you!