Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

  • 1.  Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-20-2019 10:49
    I'm wondering if there's a way to change the sorting within the 'Selections' grid of S/O Pick Sheet Printing. Can't modify via CO. Client has LOTS of UDF's, so every time they have to scroll all the way to the bottom of the Selections to specify their criteria. Not the end of the world, just a little bit of a nuisance. Currently we've instead created a parameter inside the .rpt. I suppose another option is to create a new UDF that begins with the letter 'A' so that it shows near the top of the Selections list. Or I'm wondering if there's a way to just remove certain fields from that screen. v2018.3 provides the ability to exclude UDF's from the Selections, but this client is running v2017. Plus, it's possible they may still want the UDF's showing in other Selections/screens.

    ------------------------------
    - Brett
    ------------------------------


  • 2.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-21-2019 00:48
    If the panel will trigger a UI post load event, then yes it is possible to remove rows from the grid during the post load but IIRC, i also had to tack on some logic to the form code/report setting field because when changed, it also triggers the grid to reload using the default grid definition.

    The same routine, with a little tweaking can also be used to insert a row at a specific point in the grid as well.

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



  • 3.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-21-2019 08:37
    Appreciate the info, @David Speck II.​

    ------------------------------
    - Brett
    ------------------------------

    Original Message


  • 4.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-21-2019 17:13
    "so every time they have to scroll all the way to the bottom of the Selections to specify their criteria."

    CTRL+END will instantly put them to the bottom of the selections.


    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------



  • 5.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 08:09
    Thanks, @Dan Burleson, that works for me, but you know how 'people' are :) .  And then of course they'd still have to scroll up a little since the desired field isn't at the very bottom.  But that did make me realize that maybe another reasonable option is to just maximize the Pick Sheet Printing screen so you can see more of the Selections at once and lessen the need to scroll down.   ​

    ------------------------------
    - Brett
    ------------------------------

    Original Message


  • 6.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 08:31
    Fyi, recap to client:

    Apparently Scripting may be feasible for controlling the 'Selections' grid, but first I think we have some other decent options (in addition to just creating a parameter inside the .rpt):

    • Create a new UDF that begins with the letter 'A' so that it shows near the top of the Selections grid (e.g. ARELEASE_DATE).
    • Just maximize the Pick Sheet Printing screen so that more of the Selections can be seen at once and therefore lessen the need to scroll down; and as needed, it appears the Selection grid can be re-sized while in Pick Sheet Printing (via double arrow ↔).     ​
    • Ctrl+End will bring user to the bottom of the Selections, although you'd still have to scroll up a little since the desired field isn't at the very bottom.


    ------------------------------
    - Brett
    ------------------------------

    Original Message


  • 7.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 08:38

    I don't think I have ever tested this but I thought the UDFs that display in the selection grid appear in the order that they were added to the table.

     

     

     

    Thanks

    David Speck

    TSS

    Sage | Sage 100 Certified Consultant

     



    ------Original Message------

    Fyi, recap to client:

    Apparently Scripting may be feasible for controlling the 'Selections' grid, but first I think we have some other decent options (in addition to just creating a parameter inside the .rpt):

    • Create a new UDF that begins with the letter 'A' so that it shows near the top of the Selections grid (e.g. ARELEASE_DATE).
    • Just maximize the Pick Sheet Printing screen so that more of the Selections can be seen at once and therefore lessen the need to scroll down; and as needed, it appears the Selection grid can be re-sized while in Pick Sheet Printing (via double arrow ↔).     ​
    • Ctrl+End will bring user to the bottom of the Selections, although you'd still have to scroll up a little since the desired field isn't at the very bottom.


    ------------------------------
    - Brett
    ------------------------------


  • 8.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 08:41
    It's alpha, @David Speck II.​​

    ------------------------------
    - Brett
    ------------------------------

    Original Message


  • 9.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 09:42
    Do all the udf's need to appear for selection?  If not, then you can suppress them via CO from appearing.



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

    Original Message


  • 10.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 09:51
    As @Brett Zimmerman said above, that option isn't available until 2018.3. I just had this exact issue for a customer yesterday. They have a UDF they need to use for picking sheet selection (instead of just printing them for all SO's). They too, have a ton of UDF's. I suggested making the selection panel larger OR delete the UDF's not needed. Then I looked in Custom Office and the ​exclude checkbox wasn't available. They are on 2018.2.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 11.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 09:53
    Dang it, I hate support questions that are more than two lines in length......

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

    Original Message


  • 12.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 09:59

    Jeff, I think the problem with doing that is that would be done at the table where the UDF exists, like in SO_SalesOrderHeader and I think Brett already stated that some UDFs are needed for selection in one printing task but not another so if you if were to suppress them via CO, it would mess up the other printing task and prevent them from using the UDFs.

     

    I think the other issue was they are not on a version that has that feature yet.

     

    Also, if you are referring to using Customizer, the printing tasks do not allow hiding fields.

     

     

     

    Thanks

    David Speck

    TSS

    Sage | Sage 100 Certified Consultant

     



    ------Original Message------

    Do all the udf's need to appear for selection?  If not, then you can suppress them via CO from appearing.



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


  • 13.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 10:04
    Hmmm.  Maybe we should flood the voting box for this enhancement.  I hear they are looking for suggestions for what to do in 2025.....

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

    Original Message


  • 14.  RE: Controlling 'Selections' grid...specifically S/O Pick Sheet Printing

    Posted 08-22-2019 10:22

    Good point, it would be nice to have an interface that would allow customizing the rows that appear in the selection grid for printing tasks.

     

     

     

    Thanks

    David Speck

    TSS

    Sage | Sage 100 Certified Consultant

     



    ------Original Message------

    Hmmm.  Maybe we should flood the voting box for this enhancement.  I hear they are looking for suggestions for what to do in 2025.....

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


Related Content