create no range

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[srinivasa_maruvada]

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