Sage 100

 View Only
  • 1.  Module P/R is not on file >> Missing handle to journal report object

    Posted 01-10-2025 08:48

    Have a new client that has been running Sage in a testing company for months. They went live on Monday & when printing the PM Work Ticket Transaction Register, they received "Module P/R is not on file". Still works fine in the test company. Made a copy of the live company to a backup company, removed all open batches, reinitialized GL_CompanyActiveBatch & it didn't help. Renamed Links folder, didn't help. Reinstalled workstation, didn't help. Reviewed SY0CTL, nothing for PR. 

    Happens on all workstations & server. Happens for all users.

    Installed PR & now the error is "Missing handle to journal report object". Renamed Links folder again, didn't help. Replaced the PM & CI program folders from a local install without enhancements, didn't help. Tried replacing the program files in Links with the standard files for those PM programs, didn't help.

    Went back & installed all .NET & redistributables. Uninstalled Crystal & reinstalled.

    Just won't work. Still works fine in the original testing company, but not the live or copy of the live. Reviewed all PM settings between the two companies & they are all the same. PR is not integrated with PM. Labor Crew Maintenance doesn't give any prompts for PR. 

    Any other suggestions??



    ------------------------------
    Dana Young
    Lehman Wesley
    Lansing, MI
    ------------------------------


  • 2.  RE: Module P/R is not on file >> Missing handle to journal report object

    Posted 01-10-2025 09:16

    I just found the fix!

    Bill of Materials was activated, but not setup in the live company because we didnt need it. Only using templates.

    I ran the setup wizard & can now open the PM Work Ticket Trans Register task.



    ------------------------------
    Dana Young
    Lehman Wesley
    Lansing, MI
    ------------------------------



  • 3.  RE: Module P/R is not on file >> Missing handle to journal report object

    Posted 01-10-2025 09:18

    Oh Great!  Probably a good "note" for our Tips and Tricks Session at Meeting of the Minds in March!  (Glad you figured it out).  



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



  • 4.  RE: Module P/R is not on file >> Missing handle to journal report object

    Posted 01-10-2025 09:35
    Edited by Wayne Schulz 01-10-2025 09:37

    @Madeline Stefanou what we need to add is a note to talk with Sage development about improving their error trapping. I've seen "Module P/R" and "Module P/M" type errors which seem to translate to "untrapped error" and their description has nothing to do with the error.  At the very least it would be helpful to have a refresher tips/tricks - perhaps with development - on using DEBUG within Sage 100 to narrow down some of these untrapped errors.

    It would also be interesting to have an overview of the LINKS folder and how that entire system works. I've had situations where renaming the file in links is all I needed to do, then I've seen where I had to replace it. I think this could be a super important area to document before everyone in development is gone and we're making support calls across a 12 hour time zone for Sage 100.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 5.  RE: Module P/R is not on file >> Missing handle to journal report object

    Posted 01-10-2025 09:21

    Interesting...



    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------



  • 6.  RE: Module P/R is not on file >> Missing handle to journal report object

    Posted 01-10-2025 13:10

    Reported to Sage & their response:

    I was able to duplicate the below error when opening Work Ticket Register with BM Activated and not setup:


    I will create a Knowledgebase Article for this message and confirm I can correct with your steps.

    I will also submit to engineering to see if they can display a better message.



    ------------------------------
    Dana Young
    Lehman Wesley
    Lansing, MI
    ------------------------------



  • 7.  RE: Module P/R is not on file >> Missing handle to journal report object

    Posted 01-10-2025 09:30

    @Dana Young can you provide the version number as well as whether this was Scanco PM or Sage PM?  



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 8.  RE: Module P/R is not on file >> Missing handle to journal report object

    Posted 01-10-2025 09:43

    Sage v2024.1 Advanced

    Sage PM



    ------------------------------
    Dana Young
    Lehman Wesley
    Lansing, MI
    ------------------------------