Item pricing on customer record, is there a pre-built solution to keep those in logs?

AI generated answer (using internal Slack threads):

Based on the conversations, there doesn't seem to be a pre-built solution in NetSuite for keeping logs of item pricing on customer records. However, there are a few workarounds suggested by the community: 1. Creating a custom record for each item and recording the historical pricing table there. This would involve creating a new record type and adding it to a sublist on the item. This method would allow you to keep track of historical price levels and their effective dates. 2. Creating a script on the Item record that saves a copy of the current pricing levels to a custom record when the record is saved. This would allow you to keep a log of pricing changes. If you want to record the price at the end of every day (even if it doesn't change), you could create a scheduled script to save a copy of the current prices to the custom record. 3. Creating a saved search on the Item Record with specific criteria. This could include

Type = (your preference)

,

system notes: field = is pricing

, and

system notes: date = (your preference)

. However, this method was noted to potentially not capture all necessary information and could make finding a specific price on a given date difficult. 4. Using a transaction search for only that customer, showing only lines (ITEMS) and showing price level value in search results along with amount. This could potentially generate a current pricelist for a customer only showing the products they have purchased before. Remember, these are workarounds and may not perfectly fit your needs. You may need to customize these solutions to better suit your specific requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******