We want to pick the different sales price on different month from different sub inventory

 Hi,

How can i achieve my business requirement as per below :-

We have 3 Sub inventories like A, B, C and On hand Qty are lying in these all sub inventories

then We want to pick the different sales price on different month from different sub inventory

Ex- In Jun Month System should pick qty from A Sub inventory with 100 unit price

      In Jul Month System should pick qty from B Sub inventory with 200 unit price

      In Jul Month System should pick qty from C Sub inventory with 300 unit price.

So Pls help me to achieve this.

Rgds

Naveen