Sage 100

 View Only

  • 1.  Next key value location

    Posted 11-28-2022 10:32
    Is there a data file where Sage stores the "next key" value for PM work tickets?  We recently did an upgrade to 2022 SQL from 2019 Advanced and the work ticket key jumped to an odd value.  I am hoping it is something in a data file that we can reset.

    Thanks!

    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------


  • 2.  RE: Next key value location

    Posted 11-28-2022 10:37

    I believe that It is in PM_Options Table

     

    NOTE: I will be out of the office Monday 11/28 after 1:00pm and all day Tuesday 11/29. 

     

     

    Do not miss out on our 2022 Sage 100 Year-End Tips Webinar: View the details

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     






  • 3.  RE: Next key value location

    Posted 11-28-2022 10:46
    @David Overholt - I looked in there but only find the Next Work Ticket Number - nothing for the Next Key value.​

    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------

    Original Message


  • 4.  RE: Next key value location

    Posted 11-28-2022 11:19

    I thought that question sounded too easy! J So I looked and did some testing.

     

    It looks like the next key value is based on the highest key value found in PM_WorkTicketHistoryHeader table. The method that increments it must be looking in that table and finding the highest key value in that table and incrementing it for the next record created.

     

    I only did cursory testing and I'm not sure how you could control that unless you manually added a dummy record (using DFDM or SQL) that record would need to have a key value that is higher than all other records in that table.  I did that in my demo database and it did increment that value when I created another work ticket.  I don't know what if any repercussions that might have, so I'm not recommending it, but that I think that is the answer to your question.  

     

    I could look at the 2022 Providex code to be certain.

     

     

     

     

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

    https://higherlogicdownload.s3.amazonaws.com/90MINDS/MessageImages/90d551c5a4be4d4c86e250522e48dc90.png

     




    Original Message


  • 5.  RE: Next key value location

    Posted 11-28-2022 13:31
    @David Overholt - Thanks for digging this one out!  During the conversion Sage created a history record for a deleted work ticket with a number and key of WORK TICKET.  It has been counting up from that ever since.  It will be a long time before it runs out of keys to use and everything still works OK but it just looks odd.  Something to check for and remove on future upgrades.

    Thanks for the help!​

    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------

    Original Message


Related Content