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?