Sage 100

 View Only
Back to discussions
Expand all | Collapse all

P/M v2021 Error during Work Ticket Transaction Register Update

  • 1.  P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 11:21

    I have a user who did 'kill task' during the register update. (Don't even get me started.) Now when we try to update, we get:

    GL_FiscalYearDetail does not have correct permissions

    Error #13: File access mode invalid
    Program    JT_WTTransactionRegister_upd.pvc
    Line       3456

    Sage support had me rebuild that key file, which did nothing. Now they're having to find a specialist. Does anyone know how to fix this?



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    90 Minds Secretary
    ------------------------------


  • 2.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 12:31

    PM 2021 - Is that Scanco or Sage?



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 3.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 12:39

    Scanco.



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 4.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 12:44

    Sage may have been referring to this Sage 100 KB but your error is line 3456, but this may be Sage's version.

    Error: "13 JT_WTTransactionRegister_UPD.PVC 3478" or 3472 occurs when updating the Work Ticket Transaction Register.

    Ref: GL_FiscalYearDetail.M4T

    Resolution

    Rebuild key files to the GL_FiscalYearDetail.M4T file.

    1. Go to Library Master, Utilities, Rebuild Key Files
    2. Select Company Code and select General Ledger as the Module Code
    3. Select GL_FiscalYearDetail.M4T file and click Proceed.

    If the file referenced in the error is JT_WorkTicketLabelPrint.m4t

    1. DFDM JT_TransactionEntryRestart.m4t and remove the record with a blank batch number.

    2. Review the work ticket to confirm if the entry already updated. If it did, do not update the batch again and delete either using DFDM or by reinitializing the WT Transaction Entry files after all other batches have updated.

     

     

    Kenneth Phillips | Enhancement Support Specialist

     

    





     

    p: 800.627.9032 x120 | w: dsdinc.com

     

    For DSD Enhancement pricing, sales or support email:  enhancements@dsdinc.com

     




    Original Message


  • 5.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 12:55
    Yes, that's what he had me follow. It didn't help.




    Original Message


  • 6.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 12:55
    Scanco, unfortunately. 




    Original Message


  • 7.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 13:01

    If it's Advanced / Premium, you could try resetting the service files... (in case the "kill task" didn't actually release everything properly).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 8.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 13:07
    It's standard. ��




    Original Message


  • 9.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 13:10

    The only equivalent I know of for Standard (short of rebooting the server) is looking for (and forcing closed) open files, that might have an active lock:



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


  • 10.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 13:22
    I had to reboot the server last night before the file rebuild. 




    Original Message


  • 11.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-07-2023 18:23

    The issue is fixed. Karen McWhirter removed the ONE record (the only one) from JT_TransactionEntryRestart. Then we were able to update. 

    Thanks for everyone's consideration!

    Karen



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    90 Minds Secretary
    ------------------------------

    Original Message


  • 12.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-08-2023 12:47

    Karen

    There would only be one record in the Restart file -- because the user killed the task that was being updated.  Deleting the restart record is the correct solution.  Same thing happens in Ops Management with the Daily Labor Register update - if the update errors out or the task is killed during the update, then the restart record in the DailyLaborControl file has to be deleted in order to restart the update.



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------

    Original Message


  • 13.  RE: P/M v2021 Error during Work Ticket Transaction Register Update

    Posted 06-08-2023 14:34

    Thank you, @Jane Scanlan



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    90 Minds Secretary
    ------------------------------

    Original Message


Related Content