>For Stardard situation,
>
>
>Orders (Order_ID, ....)
> |
> /|\
>OrdItems (Order_ID, ITEM, QTY, ....)
> |
> /|\
>Shipment (SHIP_NO, Order_ID, ITEM, SHIPQTY, ....)
>
>
>
>
>Serval Shipment to Finish this Orders!
>
>How to Calculate the Left QTY (Not send to Shipment for the Orders)?
>Thank you!
Hi Justok,
Not sure if this is what your asking, but when I process orders against blanket open purchase orders I do something like the following using a view and a SCAN ENDSCAN:
*If PO has some parts left but not the entire amount do this
IF (shipview1.qty_ordered - shipview1.qty_shipped) - QtyToShip < 0
*get remaining parts on this PO
OldQtyToShip = QtyToShip
NewQtyToShip = shipview1.qty_ordered - shipview1.qty_shipped
*define QtyToShip for the return loop
QtyToShip = OldQtyToShip - NewQtyToShip
..........rest of processing code
HTH
Tony
Skill comes from Diligence