Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Selection grid values associated with a form code (script?)

  • 1.  Selection grid values associated with a form code (script?)

    Posted 02-27-2026 17:33

    We want a Picking Sheet Printing form code to automatically select a specific warehouse code (so a user can choose their own form code, and have it only print their location-specific orders). 

    Has anyone been able to do something like this?

    Ideally we'd want something based on choosing the form code (or opening the panel with the last form code already set), to automatically fill in the warehouse associated with that form code, so the user doesn't have to click into the grid and type the code.

    If a script is needed (probably a button... easier than typing), what would the syntax be for setting those values in GD_SELECT?  I've never seen a script modify that kind of grid data.



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


  • 2.  RE: Selection grid values associated with a form code (script?)

    Posted 03-05-2026 11:46

    Anyone?  Bueller?



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



  • 3.  RE: Selection grid values associated with a form code (script?)

    Posted 03-05-2026 15:55

    Have the same form design using separate form codes, each form code is for a warehouse code?  Form code 000, form code WH2, Form code WH3, etc,  The warehouse associated with the form code is populated in the print settings and the settings will  stick after the first rint. 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 4.  RE: Selection grid values associated with a form code (script?)

    Posted 03-05-2026 16:10

    It doesn't "remember" the grid selection values for me.  (v2025).

    Print using code 002...

    ...then re-open the printing task, form code 002 is there but the selection grid values are gone.



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

    Original Message


  • 5.  RE: Selection grid values associated with a form code (script?)

    Posted 03-07-2026 10:08

    Use Crystal Report Designer, Select Expert to set the WarehouseCode equal to 002.

    image


    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 6.  RE: Selection grid values associated with a form code (script?)

    Posted 03-09-2026 09:12

    I don't think that works with Forms, Doug, just reports.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 7.  RE: Selection grid values associated with a form code (script?)

    Posted 03-09-2026 09:15

    You can override the Forms selection if you use the GROUP selection instead of RECORD selection...(for Forms)



    ------------------------------
    Beth Bowers
    Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
    (269) 358-0989
    ------------------------------

    Original Message


  • 8.  RE: Selection grid values associated with a form code (script?)

    Posted 03-09-2026 09:35

    @Brett Zimmerman  I tested it and it worked for me.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 9.  RE: Selection grid values associated with a form code (script?)

    Posted 03-09-2026 09:56

    Doug, you have it working using RECORD selection?



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 10.  RE: Selection grid values associated with a form code (script?)

    Posted 03-09-2026 11:39

    Yes, it "works" for Record selection.  If you set the warehouse = "001" then it only selects 001 warehouse orders.  However, as Kevin mentioned in a previous post, the "printed" flag doesn't work correctly.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 11.  RE: Selection grid values associated with a form code (script?)

    Posted 03-09-2026 11:23

    Thanks for the suggestion Doug, but a Crystal Reports filter marks everything as "printed" (as the data is pushed into the work table).  We want the selection grid to work so only the printed orders are marked as printed.



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

    Original Message


Related Content