SY_GridDefinition is the file. However, i don't think you are looking at the correct record. Getting the library and panel name while having the panel up resulted in the following.
As for the Level$ field, Z appears to be stock Sage 100, X or Y appears to be for third party enhancements, I think B is for grid customizations made using Customizer, and A is grid customizations made by a user, like when they reorder columns, move columns between grids, resize columns, or hide columns.
You could probably get away with modifying the ColDesc$ field for the correct record in SY_GridDefinition and call it a day but I don't know how well that will survive upgrades, you may want to include an asterisk as a prefix like how customizer adds the asterisk to a task's title bar to indicate it has been customized. This would let anyone know that it isn't stock.
You could also use a UI post load script to change the column description and this should survive upgrades. Something like the following should work.
sGD_Lines_Fmt = "" : oUIObj.GetControlProperty "GD_Lines", "Fmt$", sGD_Lines_Fmt
oScript.DebugPrint "sGD_Lines_Fmt: " & sGD_Lines_Fmt
If sGD_Lines_Fmt <> "" Then
If InStr(UCase(sGD_Lines_Fmt), UCase("[* Repurposed 1]")) = 0 Then
sGD_Lines_Fmt = Replace(Replace(sGD_Lines_Fmt, "[Taxable Freight]", "[* Repurposed 1]"), "[Nontaxable Freight]", "[* Repurposed 2]")
oUIObj.SetControlProperty "GD_Lines", "Fmt$", sGD_Lines_Fmt
End If
End If
If you use msgbox gd_lines.ctl'fmt$ from the command window, you can see what the property looks like.
You will need to assign your script to another temporary library panel to act as a placeholder to create the record in CM_UIScriptSettings so you can DFDM it and modify it. The record's library and panel should look like this. Make sure you compile UI scripts afterwards.
The other way to change a column description would be to set the grid control's row property to -1, then set the column property to either the column number or the IOLVar value (this is equivalent to the field name, not the column description) , then set the value property to whatever description you want. You should first save the current row and column property values so you restore them after making your change.
The LoadList$ property can be used to find out what fields/columns are loaded in the grid.
------------------------------
David Speck II
Tennessee Software Solutions
------------------------------
Original Message:
Sent: 04-29-2022 19:57
From: Jeff Schwenk
Subject: How to modify a field label on Library Master Panel
Keep us posted!
------------------------------
Jeff Schwenk
Bottomline Software, Inc.
------------------------------
Original Message:
Sent: 04-29-2022 18:35
From: Dan Burleson
Subject: How to modify a field label on Library Master Panel
I suspect you are correct and that this dialog is created in a very reusable fashion so that a program supplies the column names. This likely puts an end to that search, Thank You. A variable dump shows the cMainGridPropVals$ variable contains the sub string "Nontaxable Freight" maybe I'll try to replace the label there.
------------------------------
Dan Burleson
Software Consultant
Connex Software
Original Message:
Sent: 04-29-2022 18:05
From: Kevin Moyes
Subject: How to modify a field label on Library Master Panel
Probably SY_GridDefinition.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.