2 Replies Latest reply: Nov 18, 2011 7:01 AM by vishal_pai RSS

    Invoice Flag

    Fredrik Quirin

      Hi,

       

      I am trying to create a Invoiceflag for each invoice (see attached file). One invoice has serveral lines, some with UNERO = N and some without. The idea is to have the enire invoice flagged as N if ANY of it's line item contains UNERO = N.

      So FlagIsNewBiz is to return all uniques invoices that contains UNERO = N. Then what I am trying to do is have FlagIsNewBizInvoice = 'YES' when it´s an invoice that is part of the FlagIsNewBiz list and default to 'NO' when it's not on that list. I am not getting any invoices with NewBizInvoice = 'NO'

       

      Can anyone please give me a hint!