Does anyone know if NS have a simple solution in keeping historical price levels and an effective date? The only thing I can think of is to create another record type and add it to a sublist on the item

Hey @Chris, I was able to create a saved search on the Item Record. Criteria:

Type = (your preference)

system notes: field = is pricing

system notes: date = (your preference)

I doubt that applies at the price level

yea I looked at system notes and it doesn't record everything we would need. It's something we already capture in another system so it seems like the best option would be to create a record type and just have it viewable in a sublist.

That would be my suggestion: create a custom record for each item and record your historical pricing table there.

ok thanks

You could also create a script on the Item record that saves a copy of the current pricing levels to a custom record when the record is saved. Or if you want the price at the end of every day (i.e. even if it doesn't change) you could create a scheduled script every night to save a copy of the current prices to that custom record (as opposed to above where it would only log when there is a change).