Skip to Content
avatar image
Former Member

Diffrent No Range as per Sales office while saving Order

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Mar 10, 2010 at 09:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2010 at 09:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2010 at 09:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2010 at 09:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Mar 10, 2010 at 10:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2010 at 01:46 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2010 at 02:23 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded