Perfect - I have added the query to my master file and it seems to work perfect. Even better is, that I have learned something from this - e.g. to ma...
I think we are back to the definition - and end dates. A price with no end date are valid "forever", and the price line is active on all future dates....
Or maybe I'm just too much into my data to translate them 🙂 When changing the uniq IDs it seems to work properly, as the output updates according...
The customer is mentioned in column C and is named 17 / A3. But I have concatenated the relevant combinations of data, so it is only the "Uniq ID" tha...
Oh - I did receive a site error when posting, that must have been the xlsx failing - I was afraid it was the post itself... Trying once more., atta...