I am having an issue in Vendor Consignment process. Our client is purchasing some precise metal and consume them in regular intervals. The scenario is as below;
Receipt 1) PIR Validity - 01.04.2015 - 30.04.2015 - The Purchase Price is - $90 - Goods purchased are 100 PC.
Receipt 2) PIR Validity - 01.05.2015 - 31.05.2015 - The Purchase Price is -$100- Goods purchased are 100 PC.
They consume 50 PC from the first receipt in the month april, let say on 15.04.2015. The cost of consumption is $90*50=4500. The remaining 50 PC from the first receipt are consumed on 10.05.2015, but the system takes the price from the valid price for 10.05.2015, that is 50*100= 5000, which is not correct.
Please advise whether there is any different process to be followed or any workaround method to solve this issue. Thank you.