Skip to main content

Notifications

Dynamics 365 Community / Forums / Field Service forum / Maximum number of Work...
Field Service forum
Answered

Maximum number of Work Orders

Posted on by 155

Hi Experts

The Work Order numbers are unique as they are getting generated I think from an OOB plugin. Anyway, my question is, right now, we do not have any prefix for the Work Orders and our first work order is created as with the number 00001

Does this mean that it will only be able to create maximum 99999 Work Orders? Or it will automatically increase when it reaches to that number and rename the previous ones?

Looking forward to learn about this.

Thanks

Arafat

  • Arafat Profile Picture
    Arafat 155 on at
    RE: Maximum number of Work Orders

    Thanks for such a great clarification. Cheers!

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Maximum number of Work Orders

    Hi Arafat,

    Yes, Work Order Number(msdyn_name) is not auto number type, which will be filled with the value from the Auto-Numbering (msdyn_autonumbering) field.

    pastedimage1602834612819v3.png

    In general, 99999 is not maximum and previous (00001 to 99999) records will not be affected, they can’t be changed to (000001 to 099999), just new record will add one digits in work order number field, it will begin with 100000.

    If you worry about that the 100000 record can’t extend value, you can set work order number field as your need when work order already has 99999 records.

    1.Navigate to ‘Field Service Setting’ area.

    pastedimage1602834603580v2.png

     2.click on ‘Opt-In to Auto-Numbering’ button on ribbon bar.

    pastedimage1602834631407v4.png

    3.Next click on ‘Opt-In’ button to proceed, then click on ‘Yes, proceed with opt-in’ button.

    4.Click on ‘# Auto Numbering’ button to enable the auto numbering for Work Order entity.

    pastedimage1602834663986v6.png

    5.Test.

    Go Work Order entity to create a new record, you will see following:

    pastedimage1602834837122v7.png

    The new record begins with 100000 value and previous records not be affected.

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Arafat Profile Picture
    Arafat 155 on at
    RE: Maximum number of Work Orders

    Hi Leah Ju

    Thanks for the response. Unfortunately, Work Order Number is a TEXT field and I believe it behaves a little different than this out of the box Auto Number type.

    Therefore, I want to be sure if it's going to restrict if not then what will happen to the previous ones (00001 to 99999) which might have been created. Will they be changed to (000001 to 099999)?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Maximum number of Work Orders

    Hi Arafat,

    No, 99999 is not the maximum for the work order, It can extend range automatically.

    To verify it. I ran a test on a custom entity. As following shown, I set the auto-number field with 1 digital, which means maximum is 9.

    pastedimage1602814459422v1.png

    When I click ! icon behind ‘Mininum number of digitals’, it means it can extends the range automatically.

    pastedimage1602814474817v2.png

    When I create 10th record, it still can create successfully and fill auto-number field with 2 digital.

    pastedimage1602814548746v1.png

    The value of MIN_LENGTH is between 1 and 6, so in your example, the field can automatically increase when it reaches to that number.

    For more information, you can refer it:

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/create-auto-number-attributes#string-length

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans