Sage 100

 View Only

  • 1.  Read only UDF in Sales order line grid

    Posted 11-14-2019 17:40
    If you disable a UDF field in a grid in Custom Office, is that supposed to a make it read only?  I have done that but it is still editable...this same customer had some other strange issues with UDFs on this grid so I am trying to determine if I am doing something wrong or if the customization is weirding out again...

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------


  • 2.  RE: Read only UDF in Sales order line grid

    Posted 11-15-2019 00:27
    Edited by David Speck II 11-15-2019 00:28
    You may need to try removing the udf, then saving the customization, then adding the udf as disabled, then saving the customization and/or have the user reset the panel including grid settings.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: Read only UDF in Sales order line grid

    Posted 11-15-2019 14:12
    reset panel does not solve the problem

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 4.  RE: Read only UDF in Sales order line grid

    Posted 11-15-2019 14:21

    So this is speculation but I believe when you modify a GRID in Customizer and click save, it runs through SY_GridDefinition to clean up the records.

     

    Likewise, going through the Reset Panel process and checking the option to reset all grids should remove any user level (I think level A or B) records in SY_GridDefinition.

     

    So maybe you should first try remove the UDF completely from the grid, save it, make sure this is done with no one in sales order entry. Have the users reset their grids. Then add the UDF to grid with the disabled option checked and save it.

     

     

     

    Thanks

    David Speck

    TSS

    Sage | Sage 100 Certified Consultant

     



    ------Original Message------

    reset panel does not solve the problem

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------


  • 5.  RE: Read only UDF in Sales order line grid

    Posted 11-15-2019 16:07
    What fixed it (this customer is Premium):

    In ssms, mas_system\sy_griddefinition where formid ='so_salesorder' and IOLvar = 'UDF_JOBNUMBER$'  returned 126 records.  Changed LockFld$ to "Y" for all records.

     



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 6.  RE: Read only UDF in Sales order line grid

    Posted 11-15-2019 17:34
    That's Strange.  I add a UDF to SO lines, and sy_griddefinition file only gets 1 record for the UDF field.  This is not a data-file for multiple orders, but a record-layout file.  How do the 126 records differ from each other?  SQL-Premium conversion?

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

    Original Message


  • 7.  RE: Read only UDF in Sales order line grid

    Posted 11-15-2019 17:41
    Edited by Doug Higgs 11-15-2019 17:42
    A record gets created in sy_griddefinition for each permutation of formid / grid name / company code / user key / workstation name.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 8.  RE: Read only UDF in Sales order line grid

    Posted 11-15-2019 17:42

    SY_GridDefinition maintains grid preferences for each company, user, and workstation combination in addition to the levels.

    Z is standard sage 100.

    Y is master developer added.

    I'm not sure what B means.

    A is a company, user, and workstation specific.

     

    So the moment you add a UDF for the first time, it should create a Z level record. Once users get into the task and start rearranging the grid or changing column widths, an A level record is created.

     

     

     

    Thanks

    David Speck

    TSS

    Sage | Sage 100 Certified Consultant

     



    ------Original Message------

    That's Strange.  I add a UDF to SO lines, and sy_griddefinition file only gets 1 record for the UDF field.  This is not a data-file for multiple orders, but a record-layout file.  How do the 126 records differ from each other?  SQL-Premium conversion?

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


  • 9.  RE: Read only UDF in Sales order line grid

    Posted 11-17-2019 08:36
    I guess the "reset" was not working, and that was the problem.

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

    Original Message


  • 10.  RE: Read only UDF in Sales order line grid

    Posted 11-17-2019 09:18
    Maybe a "B" level record means "Broken".  That would explain why the reset doesn't work.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


Related Content