Does anyone else use the finish or equipment replacement reports? We have started using them and have found a couple of issues. If you have a finish or piece of equipment with a lifecycle of 5 years and due to be replaced in 2009 and you run a replacement report for the next 10 years, the numbers for 2014 are going to be inaccurate because the finish is going to be reported on only once even though the finish that will replace it will need to be replaced in 2014.
It seems that the replacement reports are only going to be accurate as far out as your shortest lifecycle (in our case, 5 years).
Can anyone think of a way to work around this at least temporarily?
My guess is Josh that its probably just something that needs to be modified in the query for those reports. Which one of the replacement reports are you using? I'll take a look at the query and see if I can find something that is being omitted.