calculation of partial shipments
 

Hi All,

I have a requirement were I accept qty of items issued and received in cells
and calculate the QOH for each tansaction.
(for partial shipments)

tot project qty = 500
eg. shno prod id line no qty rec qty ship qoh
1 P001 1 200 100 100
2 P001 1 300 300 0

i have to calculate the project qty value

ie if project qty - qty rec = 0 than the order is complete

also calculate the qoh and ensure it retains the current value

any suggestions on how to proceed and which function will automatically
calculate the tot proj qty and qoh

thanks in advance