Read this topic: Inventory accounting using Opening Stock + Purchases - Closing Stock - #17 by Brucanna. It was a lengthy thread, but the approach you are looking for was described beginning at post #17. Locations of a few features have changed in the last two years, but the method remains valid.