3 Replies Latest reply: May 23, 2016 2:33 AM by Mindaugas Bacius RSS

    Records in groups

    Rolf Dastan

      if I have a lot of  account # like this..

      000-1000-000

      000-1001-000

      000-1002-000

      000-1003-000

      000-2000-000

      000-2001-000

      000-2002-000

      000-2003-000

      000-3001-000

      000-3101-000

      000-3201-000 …

      And I need to put them in 4 categories.

      If Account # start with ‘000-1’ then ‘payable’

      If Account # start with ‘000-2’ then ‘Receivable’

      If Account # start with ‘000-3’ then ‘Test’

      If Account # start with ‘000-4’ then ‘Test02’

       

      thanks