Hi ,
Hope some can help me
I have set of PO qty which is raised daily, and for the same I will receiving qty partially against each PO's
The challenge I'm facing is to identify the remaining PO qty of a particular PO, ( As the Materials are received partially sometimes receipt will done once in 3 months.
Note : Receiving will not in sequence as there will be multiple materials received against multiple PO's
Sample calculation PO PO qty PO Receiving qty Receiving date Pending PO qty 12345 100000 12345 20000 18-07-2016 80000 56789 50000 12345 10000 20-07-2016 70000 56789 20000 20-07-2016 30000 12345 50000 20-07-2016 Here we want a formula which auotmatically calculate the remaining qty of PO# 12345, when ever this is entry against the PO