Sage 100

 View Only

  • 1.  Large UDF in Item Cost Table

    Posted 02-08-2020 11:00
    I created a large UDF (500 characters) in the Item cost field (and may other tables for that matter) an am wondering if there is a way to reveal its contents without super sizing the field display.  In other words, can a button be created that could open a popup (similar to the memo buttons in invoice history line detail.


    At this point, it would appear that my only other option would be to create a crystal or Excel query pulling the information.

    TIA

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: Large UDF in Item Cost Table

    Posted 02-11-2020 09:51
    Jeff, I had the same issue for a client a while ago.  I couldn't figure it out either even with a modification.  I wanted to be able to highlight the line and then display the entire description but just couldn't get there.

    ------------------------------
    Marcos DeLuna
    Deluna Consulting
    ------------------------------



  • 3.  RE: Large UDF in Item Cost Table

    Posted 02-11-2020 10:20
    Total bummer!!!  What did you do?  Write a report?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: Large UDF in Item Cost Table

    Posted 02-11-2020 10:43
    i ended up what you suggested.  Created a button to pop it up.  It was in a different screen but similar to your dilemma.  Even then I did a modification because I had to make sure I pass  the description based on the highlighted line.  Since this was about 9 years ago, I vaguely remember I couldn't do this using a Custom Office button with script behind it.  Maybe it can be done in the current version now.

    ------------------------------
    Marcos DeLuna
    Deluna Consulting
    ------------------------------

    Original Message


  • 5.  RE: Large UDF in Item Cost Table

    Posted 02-11-2020 23:58
    Can be done with a script but it is a little tricky because you have to either parse the listbox and determine the column position to retrieve or get the "key" from either column -1, 0, or 1, can't remember which off the top of my head but i know the listboxes store the key in a hidden column or column with a width set to 0, just don't remember which at the moment. Once you have the key, you could then get the value by either querying IM_ItemCost via ODBC or use IM_ItemCost_Svc to get the value. You could then use the oSession.UI's MessageBox method to display the content or trigger a dialogue panel to display the value like the extended description but this would be more involved.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


Related Content