Multiple prices for same itemH

Hi All,

We are having issue with multiple prices..suppose there is a item X, which was purchased three times with different prices for different projects suppose PROJECT A purchased for 2$, PROJECT B  purchased for $ 2.5 and PROJECT C for $3.

After completion of projects all left overs items were moved to Corporate Warehouse (where left over items will be maintained).  Requirement here is to generate a Stock Evaluation Report with different prices purchased for different projects.

Also when we transfer (100) items from Central Warehouse to another PROJECT D for future requirement (50 from Project A left overs, 30 from PROJECT B left overs and 20 from PROJECT C left Overs) user wanted to charge the amount when he purchased for first time for PROJECT A, B and C respectively ie 50 @ 2, 30 @ 2.5 and 20 @ 3.