Sage 100

 View Only
Back to discussions
Expand all | Collapse all

GL_CompanyMemoManagerSettings does not have correct permissions

  • 1.  GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-12-2021 16:00
    I have a customer on 2020.1 Standard who uses TimeTrack.
    They don't use Payroll but are required to for integration purposes with TimeTrack.
    They typically purge the PR entries by going to Payroll - Setup - Enable Time Track for TimeCard and removing the check and saving the setup option

    Now they are getting 


    Has anyone seen this? Sage has at least one KB on this which essentially recommends (a) check the memo manager permissions ( done ) or attempt to rebuild the file structure which I have not done because it's midday and not a good time to remove everyone from Sage.

    Has anyone seen this and resolved the problem? If so, how?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-12-2021 16:03


    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 3.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-12-2021 16:12
    Wayne, I had this exact issue occur February of last year following an upgrade to 2019, and am trying to find more information.  Here's a link from Amber's similar situation that may be of help while I search.

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------

    Original Message


  • 4.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-12-2021 16:21
    Thanks! 
    I'm going to try a reboot of the server in the meantime just to rule out some type of odd file locking.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------

    Original Message


  • 5.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-12-2021 17:04
    Here a link to the KB article here that covers the error.  It is KB article 104802.  Hope that helps!​​

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------

    Original Message


  • 6.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-13-2021 10:26
    Edited by Wayne Schulz 04-13-2021 10:56
    Unfortunately the KB suggestions of modifying the memo permissions and rebuilding the table structure don't seem to have had any effect. I also rebooted the server on the odd chance that would help. I'm going to open a case with Sage to see what hidden knowledge they might have on it.

    Case - 8008701270

    Customer is on Payroll 2.20.3 which they only use because it's required by Time Track. They are passing employee hours via Time Track to job cost.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 7.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-14-2021 08:28
    I upgraded to the latest Payroll as suggested by Sage. Rebuilt the data tables as noted in the KB. Provided as much memo manager full access as I could.

    Still receiving the error.

    My guess is one of two things

    1. Data file issue
    2. Product defect

    Debugging is somewhat complicated by my impression that (a) not a lot of people use time track and (b) those that do may not be performing this exact procedure.

    Was working fine since November upgrade to 2020.1. Started having an issue in March 2021.



    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 8.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-14-2021 09:56
    Did you check NTFS (Windows) permissions to the file?

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

    Original Message


  • 9.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-14-2021 10:38
    I did - it looked as if everyone had full permission. I haven't run across any funny access denied and I've been toying with making changes through DFDM, etc on a TST company without issue.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------

    Original Message


  • 10.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-14-2021 11:03
    3rd Party software (and even Sage standard) can generate incorrect error messages leading you to the wrong file.
    Seems like the error-message may be incorrect.   I wonder if this is really a Timecard file problem?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 11.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-15-2021 10:42
    So it had nothing to do with GL.  Did Sage alert you to the Timecard file being involved?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 12.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-15-2021 15:17
    Edited by Wayne Schulz 04-15-2021 15:18
    No, I haven’t heard boo from Sage ( no support rating survey either ). I notified Sage that the KB didn’t work and nothing else was heard from them.

    I backed into the debug info with the helpful advice of another 90 Minder.

    From there I just brute forced one possible solution.

    It could be there are multiple issues. This could be data related only or it could be a combination of data and a bug.

    Mostly I’m adding this so anyone searching our group can find one possible resolution.

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------



    Original Message


  • 13.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-15-2021 20:32
    Thanks Wayne,
    Viva 90 Minds !

    Lee
    --

    Friendly Systems, Inc.

    Sage 100 (Mas90/200), Sage 300 (Accpac), SageCRM, xTupleERP
    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog




    Original Message


  • 14.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-14-2021 10:58
    You might try renaming the file, then try manually re-creating it(Library Master, Utilities, Reinitialize data Files, Manual button.  Renaming and recreating the file should shed some light on whether this file is the source of the error.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 15.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-14-2021 21:14
    Here's how I resolved this - though I'm not 100% sure whether it is all due to a data error or if there could be a programming issue at play as well.

    The customer had one entry in their Time Track file which was from a prior month and which the program seemed to error on.

    To figure out which key the process was stopping on - use the debug screen on the error

    - Info
    - Debug
    Type in:
    - Exit
    - Escape
    ? timetrackkey$

    This should return the key field which is the employee GUID plus other items from the time entry - look in PR_TimeTrack.M4T for it

    ** MAKE A BACKUP OF MAS_XXX JUST IN CASE **

    1. Use DFDM to delete the record from PR_TimeTrack.M4T ( look for key found in above procedure )

    Pull in all JC data from Time Track and update

    Payroll - Setup - Payroll Options - remove check - accept
    Error ( but still does remove records)

    File - Run - *UTL - Purge Time Track to History

    Payroll - Setup - Payroll Options - remove check - accept
    No Error
    0 Records in PR_TimeTrack.M4T

    I haven't traced through to see if all the PR_TimeTrack.M4T records were moved appropriately to history. I have instructed the customer to review. If there seems to be any type of problem I'll update this post.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 16.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 04-15-2021 09:41
    Thank you @Wayne Schulz!!​

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------

    Original Message


  • 17.  RE: GL_CompanyMemoManagerSettings does not have correct permissions

    Posted 05-12-2021 08:19
    Update:

    As is now the industry standard the customer ignored my email until now and is suddenly ready to fix the issue.

    After some additional work I found:

    - if I used the debug routine to find the TimeTrack$ key repeatedly - and deleted them one by one using DFDM from TimeTrack.M4T then eventually the problem was resolved.

    I was ( once I cleared 3-4 bad records ) able to remove the checkmark in payroll setup and then save.

    The TimeTrack records moved to history without any further error.

    The Sage error message is misleading as the solution did not appear to have anything to do with memo manager.

    Ultimately I think Time Track is a one and “ thankfully that’s done “ type module so I doubt we will see this error trapping improvised which is why it’s important to share these types of notes.



    ---------------------------------
    Wayne Schulz - Schulz Consulting -
    ---------------------------------





Related Content