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?

    user11655073

      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:

      Condition:

       

      (((:PO_SHIPMENTS.QUANTITY) +

          (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..

      Sunny