calculation of partial shipments

V

vandy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

database design issues- tracking item movement 0
HELP WITH DESIGN BASED ON MOVEMENT OF ITEMS 1
Problem locking a transaction record 5
Average shipments in any given month 2
Formula for percentage calculation 1
Attempting to compare and deduct values based on date codes 3
Count/Sum rows of a column depending on criteria from drop-down li 4
I need to do a calculation based on the values in two cells 2

Top