Diffrent No Range as per Sales office while saving Order

[mukesh_kumar23]

Hi

I have a scenario which i need to configure , there is 4 offices located in different Location i.e

Delhi,Mumbai.Kolkatta etc, when i save order the no should generate differently in Sales order ,delivery,billing, not as general suppose if i save order in Delhi office the no should be 4 if i save order for Mumbai the no should be 5 etc ,

Kindly suggest how to configure.

thanx

[Former Member]

No, ranges can be assigned to

1.Sales Order(Sale Document) (VOV8)--No ranges assignment (Internal/External).

2.Delivery Order(Delivery Document(OVLK).No ranges assignment (Internal/External)

3.Billing Document(LIPS).No ranges assignment (Internal/External)

U can assign to your own no. ranges for all the Documents mentioned above.

[mukesh_kumar23]

am trying the solution given by kapildev so not got any new reply its better to close rather than keep lingering in it

[Former Member]

Hi Mukesh,

to achieve this you need to define a Z table, in which you need to maintain the sales office as one of the column, against which you can maintain the number range and it's key.

for example the range is 1 to 100,000, and key is Z1.

Maintain the table as follows.

Mumbai 1 to 10000,

kolkatta 10,001 to 20,000 and so on.

you can define the other parameters also and write a code in the user exit USEREXIT_SAVE_DOCUMENT or the number range user exits which ever is suitable for you to read this table and fetch the number range from this table according to the sales office.

Hope this will help you,

Venkat.

[Former Member]

Hi Mukesh,

I think its a Std. functionality.

Create a order type ZOR --> assign the number range --> ask all offices to use the same order type

System always generate the unique number for orders.

If this is not the solution then please explain the issue again.

Regards,

MT

[mukesh_kumar23]

Hi MT

thanks for your suggestion

thats ok my requirement is let suppose i have ZOR order type for common to all but when mumbai office saves the order the no is 4 , and when Delhi saves the order the number should come starting with 5, and so on .

either i need to create diifferent Ztypes for order delivery and billing for different offices and assign the no range accordingly but during Report or analysis it would be problem .

Kindly suggest

[Former Member]

Hi,

in order to solve this issue you have to program the userexit

USEREXIT_NUMBER_RANGE in MV45AFZZ for orders

USEREXIT_NUMBER_RANGE in MV50AFZ1 for deliverys and

USEREXIT_NUMBER_RANGE in RV60AFZZ

Regards

William

[Former Member]

If you are using different Document Types for Sales , Delivery & Billing then you can assign the different Number Ranges.

In case with the Same Document Types , you have to take a Help of ABAPer to create a Z Program accordingly wrt Sales Office to get the Number Range.

Best Regards,

Ankur

[Former Member]

Hi,

If u want diffrent number ranges on basis of sales office then find out proper4 user exit & carry out enhancement

http://saptechsolutions.com/pdf/SDDocumentNumberRangeEnhancements.pdf

http://help.sap.com/saphelp_46c/helpdata/en/1c/f62c7dd435d1118b3f0060b03ca329/content.htm

Kapil