4 Replies Latest reply on Jul 31, 2013 7:15 AM by user11655073

    Sum of quantity entered in blanket purchase release and total quantity released must be less than agreed quantity?


      Hi All,


      I need to achieve following functionality using form personalization:


      Quantity Released + shipment quantity in current release must not greater than Quantity Agreed mentioned in the purchase order.


      For example,

      In my po following are the details:

      Quantity Agreed - 100

      Quantity Released -80


      Now when I enter the quantity in release, system will give an error message.

      So I cannot enter more than 20 here.


      How can I achive this using form personalization.


      My main query is as follows:




          (select sum(quantity_ordered) quantity_committed from po_distributions_all where po_header_id =(select po_header_id from po_headers_all where     segment1=:PO_RELEASES.PO_NUM)

          and po_line_id =(select po_line_id from po_lines_all where po_header_id=(select po_header_id from po_headers_all where segment1=:PO_RELEASES.PO_NUM) and         line_num=:PO_SHIPMENTS.SOURCE_LINE_NUM))


      Thanks in advance for all your help..