5 Replies Latest reply: Jan 18, 2012 10:29 AM by vasim basha RSS

create no range

suvendu nayak
Currently Being Moderated

Dear All,

 

         I am getting overlap message in creating no range in customer master record

 

        how can i delete the no range in existing no range...

 

 

 

tahnx and regards from

 

     SUVENDU SEKHAR

  • Re: create no range
    Srinivasa Maruvada
    Currently Being Moderated

    Hope you are creating customer number range at XDN1 and assigning at OBAR

    Check at XDN1 whehter yournew numbers are already available in exinsting number ranges.

    Create a new number range which is not using existing number range

  • Re: create no range
    K Dasaradha
    Currently Being Moderated

    Hi SEKHAR,

     

    When you get the overlap message those number are already assigned to other account group.

    If the those number ranges are not used you can delete and you can assign the same to your account group.

    its better to create new number ranges instead of deleting others.

     

    Thanks

    Dasaradha

  • Re: create no range
    Anubhav Srivastava
    Currently Being Moderated

    Dear S S,

     

    Please check the existing number ranges clearly & then set up a new range.

    For setting up a new range, you may even try to reduce the existing ranges as well & then you will get a bandwidth to set up the new range.

    BR

  • Re: create no range
    vasim basha
    Currently Being Moderated

    Hi Nayak,

     

    Best possible option is to download in excel,

    1. Sort on the From range  column (smaller number to largest)

    2. find the difference between the  To number column  and the next row, from number column

    3. wherever you find the larger differnce, you can accomodate the new number range.

     

    From Number

    • Re: create no range
      vasim basha
      Currently Being Moderated

      Hi Nayak,

       

      Best possible option is to download in excel,

      1. Sort on the From range  column (smaller number to largest)

      2. find the difference between the  To number column  and the next row, from number column

      3. wherever you find the larger differnce, you can accomodate the new number range.

       

      Column A                   Column B          

      From Number              To Number     Difference     

      1230000                   1239999          formula with reference to cells

      1240000                   1339999     -1     B6-A7

      2330000                    2339999     -990001     B7-A8

       

       

      Regards,

      VBASHA

Actions