2 Replies Latest reply: Jul 8, 2013 5:08 AM by Arjun Chemicals Arjun Chemicals RSS

    Autonumber starts from vMaxAutoNumber

      MaxNumber:

      LOAD

                num(max(%_KEY_SALES_FACT)) AS MaxAutoNumber

      RESIDENT SALES_HEADER ;

       

       

      LET vMaxAutoNumber = peek('MaxAutoNumber', 0, 'MaxNumber');

      vMaxAutoNumber=1200;

       

      SALES_HEADER:

      LOAD

           AUTONUMBER(COMPANY & TRN_NO) as %_KEY_SALES_FACT

      Resident XX ;

       

       

       

      I want to start my autonumber from vMaxAutoNumber>1200.

       

      Please sugest how to write autonumber syntax.