5 Replies Latest reply on Aug 1, 2018 4:58 AM by Ahmad Naim Ahmad Rosdi

    Assign PO outstanding if one of the item outstanding

    Ahmad Naim Ahmad Rosdi

      Hi, I tried to assign PO status 'complete' or 'outstanding' if any item inside a PO is not fully received. Attached in screenshot for example : PO18010079 should be outstanding because line 1 item is still outstanding.

      I cant use

       

      { FIXED [Pdcono],[PO. No.]:

          IF AVG([Pdqty0]) > SUM([Ivrqty])

          THEN 'Outstanding' ELSE 'Completed'

          END}

       

      because some item inside a PO might receive extra quantity. Example PO18010079 should be outstanding because line 1 is outstanding but the receive quantity is higher than purchase quantity.