Thanks for the suggestion, in Toolkit I tried to Recalculate Inventory Sales History but the option is not there.
Here is the help instructions which I cannot complete...
If the option to retain historical data has been turned off in Inventory Control, you won’t be able to use this function.



Select IC Sales from the toolbar.

Or

Select Edit…Inventory...Recalculate Inventory Sales History from menu bar.



The form will present the current fiscal calendar as defined in Inventory Control. You can edit the current fiscal periods and prior year date range. The prior year will be applied to last year’s sales statistics.

Our year end/ Period end is up to date in IC.