Maximo Open Forum

 View Only
  • 1.  Work order autonumbering

    Posted 03-11-2024 21:39

    Hi, we have 2 options for autonumbering workorders on creation.

    Option 1 will start at WO00001, Option 2 will start at WO1.

    I am familiar with using Option 1 and have had no issues aside from having to remember how many zero's precede the final number.

    Any experience/issues with Option 2 please


    #WorkManagement

    ------------------------------
    Peter Watkins
    Northern Asset Reliability Maintenance Solutions
    ------------------------------


  • 2.  RE: Work order autonumbering

    Posted 03-12-2024 11:06

    Hi @Peter Watkins!

    It has a negative impact (in my opinion) on the exported data, since when ordering them from highest to lowest, you will find this:
    WO1
    WO10
    WO100
    WO101
    WO102

    While in the long format they order them naturally as expected. You can test this in Excel.

    Regards!



    ------------------------------
    Martin Fabra
    Mfsi
    ------------------------------



  • 3.  RE: Work order autonumbering

    Posted 03-17-2024 22:34

    Thanks for your input @Martin Fabra, it helped me get this concept across the line.



    ------------------------------
    Peter Watkins
    Northern Asset Reliability Maintenance Solutions
    ------------------------------



  • 4.  RE: Work order autonumbering

    Posted 03-13-2024 19:41

    Good morning, Peter.

    I've taken onboard Martin's comment which makes perfect sense, however, that's true only if:

    1. Your exporting to Excel
    2. Sorting the work orders in Excel based on the work order number.

    What needs to be explored further is why do you feel that you have to change away from the default autoseed starting at 1,000.

    There are typically two reasons:

    1. You have several sites and want to distinguish which one they're from.
    2. You just can't stand having short numbers.

    Several sites

    Let's say you have three sites (ignoring orgs) A, B, and C. By default, each will use the same autoseed and thus based solely on the number, one cannot tell which site the record is from.  Some people are concerned that when referring to work order 1322, they don't know that is for A, B or C.  For me I don't care, even for exporting or reporting as I always include the Site ID.  So, what usually happens is that a prefix is assigned at site level A, B, or C.  Solves the problem, job done.  However, in your sample, you have used a W, most likely at the system level, which means that we're still back to the original issue of "I can't tell where the work order is from." Circular argument, eh?  

    BTW: The W is just used to annotate that whenever you say this you know that the record is a work order.  "A" is for asset, "PM" is for PMs, "JP" for jobplans, well heck you could do this all over.

    Back to the typical resolution where you have defined that W = work order, yet you still also need to distinguish which site it is from.  You'd think that you would apply the prefix at the site level.  Nope, most just change the autoseed value, so A starts at 100000000, B at 200000000, and C at 300000000.

    It does work well, but do think through the number of work orders you are generating per year because, just like an odometer at some stage it will reach a higher number which Maximo will not like.  People have also found it useful to prefix the tasks as per the screenshot too.

    Summary of options

    Site A Site B Site C Comment
    No prefix 1000 1001 1002 Note seed will always increment by 1, so that will never be the same.
    Prefix of W W12345669 W12345669 W12345669
    Prefix of W and different autoseed per site W12345669 W22345669 W32345669
    Prefix per site, same autoseed at org level A1000 B1001 C1002 Note seed will always increment by 1, so that will never be the same.
    Prefix per site, same autoseed value at site level A1000 B1000 C1000

    Too short numbers

    Straight up, I don't care.  A number is a number. However, as Martin said when sorting, interesting things tend to happen.  To overcome that people have changed the autoseed to start at a large number like 10,000,000.

    Short numbers are so easy to remember or say.

    Too longer numbers

    If you change the autoseed to start at large number like 10,000,000, that's a lot of zeros and the eye gets lazy or 'bored' because of the repetition.  If you had 12,433,346, the eye has to read each number.

    There is also the argument that having long number is harder to remember if you have to write (or the like) the number.  It does after all have to be viewed, processed by the brain (without forgetting), then outputted via the hand using a pen or keyboard (ignoring the copy/paste).

    End result

    So, back to using your original seed of W0001 (which you cannot do, it will start a 1) and progressing that in Excel to W116706, the sorting in Excel, still produces the same sorting issue, as per the screenshot that has each column sorted in Excel. 

    In conclusion, you are better off starting with a large number and using a prefix if you need to identify that this is a work order as opposed to an asset.



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------



  • 5.  RE: Work order autonumbering

    Posted 03-17-2024 22:34

    Thanks a bunch @Craig Kokay, fortunately we don't have multiple sites .

    But i do wish I had recommended just to go with the W rather than WO as a prefix. Might still have time before the upload. 



    ------------------------------
    Peter Watkins
    Northern Asset Reliability Maintenance Solutions
    ------------------------------



  • 6.  RE: Work order autonumbering

    Posted 04-02-2024 18:20

    Ahhh I see it now.  It WO, W.  This is a good case of avoiding letters that look like numbers of vice versa.  This is why some letters are not on a car's license plate.  Either way it does not matter and many companies do use WO, but just start their numbering from a value that start with anything other than < 999.



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------