I'll second Brian comments. For a long time I thought FIFO was the only answer for my clients but Average costs eliminates a lot of the headaces that come with maintaining FIFO costing.
With Average costing its a fairly easy task to convert the reported residual costs into an Item Adjustment import. If you need assistance your Adagio dealer should be able to help you out.