HOW TO DEFINE THE MORE THAN ONE INVENTORY ACCOUNT IN AVERAGE COSTING ORG.

 Hi All,

In my organization we are using the Average Costing method. My Inventory consist of Raw Materials(RM), Semi Finished Goods(SF), Finished Goods(FG).

In this existing setup, We defined only one Inventory Account. We require each group wise inventory account and Inventory also should be maintained sepratly. My Group wise Inventory Value and GL Account value should tally.

And We should know the RM, SF and FG values in TB itself.

How map this requirement in Average Costing based Inventory Org.

Regards

Kumar