Sage 100

 View Only
  • 1.  Increasing size for Business Object UDFs

    Posted 04-20-2023 18:30

    A SO Invoice Header UDF (String, Multi-Line) has downstream UDFs into IM_TransactionPosting and IM_TransactionHistory.  The SO Invoice UDF was increased from 8 to 15 characters.  Is there a way to increase the downstream UDF length?  The field length is inaccessible in UDF Maintenance.  I'm concerned that if I delete and re-create them, the data will be deleted.  Or must I create new UDFs in those two tables and source them from the SO Invoice UDF?  Any other options?



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


  • 2.  RE: Increasing size for Business Object UDFs

    Posted 04-20-2023 18:44

    I just ran into this and I was able to temporarily de-select the Data Source file on tab 3 in the UDF setup, then the length field became available.  After changing the length, I added back my data source and was good to go.  Not sure if there's an easier way, but that worked for me.



    ------------------------------
    Barb Rippberger
    Technology Integrators
    ------------------------------



  • 3.  RE: Increasing size for Business Object UDFs

    Posted 04-20-2023 18:54

    Yes, what Barb says, exactly.  Uncheck the link and resize, then relink.  (Sometimes I've had to save / update without the link before I could resize / relink).
    Remember to refresh database in any reports, to have CR recognize the extra characters.



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



  • 4.  RE: Increasing size for Business Object UDFs

    Posted 04-20-2023 19:34

    Great!  If the client approves it, I'll do that.  Thank You!



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



  • 5.  RE: Increasing size for Business Object UDFs

    Posted 04-25-2023 23:19

    It worked!  Thanks, @Barb Rippberger



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