Is it possible (Customization, Existing SuiteApp) to base an Item Sales Price regarding the effective sales date? For example, I have an item and id like to specify some rates based on specific dates Date 01/01/2024 --> 31/01/2024 = 500$ Date 01/02/2024 --> 28/02/2024 = 650$ Date 01/03/2024 --> 31/03/2024 = 675$ Ect.. So If a customer buy somethind today for march I should be able to have transaction date = today but Item sales price will be 675$ PS: Effective Date Pricing feature isnt an option!

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the desired functionality of setting an item's sales price based on the effective sales date is not natively supported by NetSuite. The Effective Date Pricing feature or bundle mentioned in the threads does not seem to automatically set the future price for a sales order created today but to be shipped in the future. It only updates the item price levels, so only transactions created after the items have been updated would get the new pricing. However, a potential workaround could be to use SuiteScript, NetSuite's scripting language, to create a custom solution. This could involve creating a script that updates the sales price of an item based on the effective sales date. Another workaround mentioned is to create a new price level with the increased price and use that for future orders, although this might be difficult to manage with a large number of products. Please note that these are potential solutions and their feasibility and effectiveness would depend on your specific business requirements and NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******