Sage 100

 View Only

  • 1.  Need to make a UDF in SO_ShipToAddress editable when it flows into SO Entry

    Posted 05-09-2025 18:38

    Background (hope it's not TMI): Client is implementing a new shipping system from Quadient to handle their shipments, which are shipped by USPS.  An Attn Line UDF has been created to pass to Quadient (via InSynch).  I created a new UDF "Attn" that flows from AR_Customer to SOE Address tab in the Bill To Address section.  I have also added a "Attn" field using the same UDF code in SO_ShipToAddress.  I learned that when standard fields flow into SO Entry from the default or selected ShipToCode, the ShipTo address fields are editable, but the UDF data is Read-Only, which is problematic, as the data is frequently modified on an order by order basis.  Is there a way to hack the Data Dictionary to make the field editable? @Alnoor Cassim



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------


  • 2.  RE: Need to make a UDF in SO_ShipToAddress editable when it flows into SO Entry

    Posted 05-09-2025 18:47

    Your UDF needs to be in SO header, flowing from the STA table.  Then put the SO header UDF on the panel.

    (Linking to the STA field, to display on the SO panel, will always be read-only).



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



  • 3.  RE: Need to make a UDF in SO_ShipToAddress editable when it flows into SO Entry

    Posted 05-09-2025 19:31

    That would require a 2nd UDF (one for BT, one for ST).I've been trying to find a way to avoid that, but that may be the only option.



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 4.  RE: Need to make a UDF in SO_ShipToAddress editable when it flows into SO Entry

    Posted 05-09-2025 19:47

    One SO header UDF, plus a script (instead of the UDF flow) is certainly possible. 

    If you don't want a script (BillToCustomer, ShipToCustomer, ShipToAddress), then yes you need more than one SO header field.

    Note: UDF flow from a default STA code might not work properly.



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

    Original Message


  • 5.  RE: Need to make a UDF in SO_ShipToAddress editable when it flows into SO Entry

    Posted 05-09-2025 19:52

    You can only put 1 instance of a UDF on a panel, however.  Scripting is not out of the picture.  It's preferable to adding a 2nd UDF.



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 6.  RE: Need to make a UDF in SO_ShipToAddress editable when it flows into SO Entry

    Posted 05-09-2025 20:13

    Correct.  You'd have to name the UDF's slightly differently... we've done that for a few similar UDF's.

    Script, column post validate against the customer fields and STA code, open objects to the appropriate table(s), then SetValue on the UDF.



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

    Original Message


Related Content