‎2006 Jul 06 5:16 PM
Hi all,
We are developing new PO format for Release Order ( Contract) where in we want to print the Open order quantity & Open order value along with Contract number.
What is the best logic for Open order quantity, where in it has consider all the previous release order quantities minus the target quantity in contract.
Open order quantity = target quantity in contract - all previously release order quantities.
Thanks in advance.
MM
MM
‎2006 Jul 06 5:19 PM
For a given contract go and get all the delivered quantity from EKET table and then subtract that from the order quantity from the EKPO table. That should give you the open qty.
Regards,
Ravi
Note : Please mark all the helpful answers