It could be corruption, however, I am unsure if copying a customized library from one user to another actually updates SY_GridDefinition. I was under the impression SY_GridDefinition was only modified by Customizer when you actually edited a grid under a specific customization and saved the changes, and these changes only affected SY_GridDefinition for the specific user/user group and company selected when editing the panel.
I would try editing the grid of the customization you just copied to the affected user and make sure a change is made and committed and see if that helps.
I don't think UDF's normally end up in the Z level records UNLESS it is a user defined table, I think they only end up in B level records as part of changes made with Customizer for a specific company and user/customization group, A level records are created based on B level records if they exist otherwise they would fall back to Y, and then Z level.
So it sounds like whatever initial customization was made to add the UDFs, they didn't apply to this specific user, either because of the user, company, user group, or preexisting customizations.
------------------------------
David Speck II
Tennessee Software Solutions
------------------------------
Original Message:
Sent: 05-05-2022 17:16
From: Thomas Rogers
Subject: UDF created and added to sales order entry lines grids will not appear for all users
Dang.
Created a new customization for a new user and the UDFs display as expected.
Copied the customization from so\custom for the new user into a customization for a user that it does not display. Even after a reset grids, no go.
------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------
Original Message:
Sent: 05-05-2022 16:51
From: Thomas Rogers
Subject: UDF created and added to sales order entry lines grids will not appear for all users
In looking through the grid_definitions I can see As and Bs, but no Y or Z items.
I've noticed that the added UDFs that do not display seem to be restricted to new users added to the system.
Older UDFs are being picked up so I'm beginning to suspect there may be some corruption in the files that define the customizations (SO\CUSTOM)
I'm going to try creating an entirely new customization profile and see what happens.
------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Original Message:
Sent: 05-04-2022 17:06
From: David Speck II
Subject: UDF created and added to sales order entry lines grids will not appear for all users
The Level indicates priority used. A being the highest priority, if there aren't any A, then it checks for B, if there aren't any B, then it checks for Y, if there aren't any Y, then it falls back to the Z level which is stock Sage 100. So if you aren't seeing any for a particular user, it means they either reset their grid (removes the A level records) or they never personalized the grid.
------------------------------
David Speck II
Tennessee Software Solutions
Original Message:
Sent: 05-04-2022 16:59
From: Thomas Rogers
Subject: UDF created and added to sales order entry lines grids will not appear for all users
I've exported the grid file to excel and sorted it and had a hard time making sense of it. The info about A and B might be useful.
What is perplexing to me is that one the users I have looked at with a problem (the first one in the thread) there are no entries in that file for them.
------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Original Message:
Sent: 05-04-2022 15:51
From: David Speck II
Subject: UDF created and added to sales order entry lines grids will not appear for all users
Whenever I have to deal with SY_GridDefinition, I use Crystal Reports or Excel to query it and filter it to the task I'm after. This makes inspecting for the correct records much easier. You should at least see records where the Level$ field is equal to "B" if the field was added to the grid correctly. You may need to confirm which company and user the field was added under because SY_GridDefintion tracks by task, grid (tasks with two grid track fields separately, GD_Lines and GD_Addl), company code, user key, and workstation name.
If the option to reset the grid is disabled, try changing a column in the grid, either swap a column between the grids or resize it, then go to another tab before exiting the task. The next time you launch the task, it should use the last grid settings saved and you should now be able to reset the grid. Resetting the grid should clear out a records for the current user and workstation where the Level$ field is equal to "A".
------------------------------
David Speck II
Tennessee Software Solutions
Original Message:
Sent: 05-04-2022 15:39
From: Doug Higgs
Subject: UDF created and added to sales order entry lines grids will not appear for all users
You might try logging into Sage 100 on one of the affected user computers as a Sage 100 user other than the user having the issue. If you can see the field with another user on the same computer then to me this points to data corruption that is not easy to fix. See the recent thread discussions of @Dan Burleson @David Speck II and @Kevin Moyes if there is only one user affected then workaround would be to create a new user. Creating new users may be kicking the can down the road.
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
Original Message:
Sent: 05-04-2022 15:22
From: Thomas Rogers
Subject: UDF created and added to sales order entry lines grids will not appear for all users
I do have custom scripts that control some fields as to whether or not they are visible on a per user basis. I turned off all the scripts and that didn't make a difference either.
I just had another call from the same client that indicates that in purchase order entry on the lines tab, that the quantity received field disappeared about two weeks ago. It is only for one user (that I am aware of). Logged in as me and the field was present. Logged back in as her and it was gone. She claims that at one point during the two weeks it reappeared and then disappeared again. For some reason the option to reset grids is greyed out?
Used the customizer to see if for some reason the field was not present or had been hidden.. Tried to add it in again and it claimed that it was already there.
I suspect these two incidents are somehow interrelated.
------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Original Message:
Sent: 05-04-2022 15:14
From: Thomas Rogers
Subject: UDF created and added to sales order entry lines grids will not appear for all users
No customization groups. :(
------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Original Message:
Sent: 05-04-2022 12:55
From: Mary Jo Krueger
Subject: UDF created and added to sales order entry lines grids will not appear for all users
Is there a customization group assigned to some users and not all in User Maintenance?
------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)