I have created 1 custom field that is OnHand Wt in product same functionality like OnHand Qty.
Now, Add 1 more custom field in Purchase order line which is Weight. When I created Purchase order, confirm it and received it, OnHand for qty and Weight is updated.
I have 1 Product that is Product A. Now I Purchase Product A with 10 qty and 100 weight. Now I confirm it and received it. So when I see in Product A's Form, Onhand will show 10 and Onhand wt(Custom field) show me 100 which is correct.
Now, Add 1 more custom field in Sales order line which is Weight. When I created sale order, confirm it and deliver it, OnHand for qty is updated but Weight is not updated.
When I sale Product A with 3 qty and 30 weight, Product Onhand show me 7(Correct) but weight show me 100(Incorrect, It will show me 70).
When I create SO and confirm it, there is create quant for that. I updated new quant with qty and weight but Old quant weight is not updated.
So I want to update Old quant from where new quant generated. So how can i update it ?
Any suggestion will be Appreciated.