You can get training from an Adagio reseller - go to this link to see a list of Canadian resellers:
http://www.softrak.com/resources/links/canada.php
Training is not free, but then we resellers have to make a living.
What Adagio modules are you using? Specifically, do you use Purchase Orders for Adagio and which invoicing module do you use? Also what versions are you using?
There is no such thing as "clear history for qty on hand". If you want to adjust lots of "qty on hands", use the Physical Inventory function. If you want to selectively clear history, wait until the next version of Inventory is released, I think that feature will be in there.
I would strongly recommend not getting rid of old product codes ever. You might want to set up a new Control Account called "Obsolete items" and move the items to there so that they don't appear on any reports. Deleting items that have been bought or sold may result in data integrity errors.