When we have price changes, we need to send the updated price list to the customers weeks before its effective date. Currently, this is done manually - creating an excel sheet and sending it to customers. This is prone to errors as we have many customers, have multiple brands and subsidiaries who will need to receive different price lists.

The effective date pricing might not work as my understanding is that we will not be able to print/extract the future dated price list. As such, is there a way that we can store additional set of prices that we can use as the 'new price' that we can generate? We want to send the price list directly from NetSuite.