Hi Thomas,
do you guys Zero the year to date quantities each year? if you look at 'inventory adjustments' in the more actions menu there is an option to zero the quantities. this rolls down the year to date into the 'last year', 2 years into 3 years etc... just be aware performing this action mid year would skew your data. Its an action you can perform annually or at the beginning of each fiscal year.