I have created consignment info record price for X material from 15/5/2007 to 16/05/2007 is Rs 10
Iam doing GR ( between these dates) for qty is 100 @ Rs 10 and do the GI 50 Nos and taken the rate is Rs 10
Then i changed the Price Rs 16 Validy date is 16/05/2007 to 31/12/9999
after that i received GR 100 Nos For Rs 16.. Now the total qty is 150..
Now iam doing GI 150 nos and price taken is Rs 16.. My client is asking why the price taken Rs 16 for all GI quantities
Sytem should take the price Rs 10 for the 50 Nos and Rs 16 for 100 nos
How i can do this settings.. Pl advice