Sage 100

 View Only

  • 1.  Field Description Change

    Posted 03-06-2019 15:52
    The customer wants to change the description for the "Req Date" field on the PO line detail and also in Item Maintenance, Orders tab.  They would like the field label to be "Est Delivery Date" instead of "Req Date".  Is there an "easy" way to change the description of this field?

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


  • 2.  RE: Field Description Change

    Posted 03-06-2019 16:16
    Best not to change or play around with standard field names. Use UDFs, customizer. and a little custom scripting to do this. Hide the standard fields and put the UDFs on the panels. This way the solution will survive upgrades. Not easy, but not too difficult.

    ------------------------------
    Myron Stevenson
    Consultant
    Clearis Consulting, Inc
    Duluth, MN
    218-525-6720
    ------------------------------



  • 3.  RE: Field Description Change

    Posted 03-07-2019 03:03
    Edited by Alnoor Cassim 03-07-2019 03:12
    Doug,

    Agree with Myron to use Customzer if you can. Changing grid column names however is more troublesome. So you have to do 1 of these 2 things I believe. I prefer the latter because it's safer.

    1) Change Sy_GridDefinition then reset to remove personalized grid records to inherit changes.
    I haven't done it this way in a while so going from memory meaning actual steps may vary!

    a) Backup Sy_GridDefinition.m4t 
    b) DFDM Sy_GridDefinition.m4t 
    c) Find Level Z record for PO_PURCHASEORDER / GD_LINES. Keep moving to next record until you see IOLVar$ = RequiredDate 
    d) Change the ColDec$ to Est Delvy Date
    e) Back into P/O Entry do Reset All Grids, close screen 
    f) Back into P/O Entry. Should see new column name but UDF columns nay need to be added back
    g) Repeat last 2 steps for each user (I think!)

    2) With Customizer, create a UI script and attach it to Panel PostLoad of both PLines and PLinesW
    Something like this:

    Note:
    * Change COLUMNDESC= to whatever you want
    * Required Date doesn't show up if on a Master or Repeating Order (obviously)
    * I assumed Required Date is on primary grid. If secondary, change GD_Lines below to GD_ADDL

    curAttribs = ""

    oUIObj.SetControlProperty "GD_Lines", "Row", "0"
    oUIObj.SetControlProperty "GD_Lines", "Column$", "RequiredDate$"
    oUIObj.GetControlProperty "GD_Lines", "Column", nCurCol

    FormMapId= "" : ctlName = ""
    GridCtl = oUIObj.GetControlID("GD_Lines$", FormMapId, ctlName)
    r=oUIObj.GetColumnAttributes(GridCtl, CInt(nCurCol), curAttribs)

    NewAttribs = Mid(curAttribs,1,InStr(curAttribs,"COLUMNDESC")-1) & _
    "COLUMNDESC=Est Delvy Date" & _
    Mid(curAttribs,InStr(curAttribs,";COLUMNWIDTH"))

    r=oUIObj.SetColumnAttributes(GridCtl, CInt(nCurCol), newAttribs)

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------



  • 4.  RE: Field Description Change

    Posted 03-07-2019 11:27
    Thanks @Alnoor Cassim.  It is great to know this can be done.  I think for this purpose I may be better off creating a couple of UDFs and adding them to the panels.   It is tempting to modify the descriptions in dfdm.​

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

    Original Message


Related Content