Add a "date last line item price change" field to Products

Discussion created by JamesTorr on Jun 24, 2016
Latest reply on Jun 28, 2016 by JamesTorr

So, I've got the usual products, invoices, line item database. I'd like to create a calculated field in the products to prompt me to know when to change the pricing.


I currently don't follow the "price" field in the product so much and would like to use the line items for each product as an indicator of when the last time the price was changed, ie if I have a line item dated 24/6/16 at £1.20 and all of the line items going back until one for £1, dated 01/1/16 are priced at £1.20, I'd like the field to say 1/1/16.


Make sense? I'm guessing I'm going to have to make some sort of calculation which looks for the price of the most recent line item (can do), then looks for the last one that is different and spits out the date field, but I'm not exactly sure how that should look! Any ideas?