Sage 100

 View Only

  • 1.  On Hold Picking Sheets

    Posted 08-06-2020 14:01
    Does anyone have any thoughts on the following request?

    Major Goal: Client wants to only print picking sheets that are marked on hold.

    Background:
    All web orders come in Website pipeline and are automatically are placed on hold. Our client has normally open each order, reviewed it, made any corrections if necessary, and then change the status flag off hold and print the picking sheet. 

    Due to reduce staff of Covid, they are now wanting to print only picking sheets orders on that are on Hold. Going back to Website Pipeline to make that program change was going to be expensive.

    Of course, after printing the picking sheet, they would like the status flag to automatically change from on Hold.

    Any suggestions?

    Thank you,
    Michael

    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    Birmingham, AL
    ------------------------------


  • 2.  RE: On Hold Picking Sheets

    Posted 08-06-2020 14:08
    Set up a mirror UDF in SO header to allow Selection by that value.
    Column post validate script on PickingSheetPrinted might allow updating the Hold flag as they are printed (if the event triggers).

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



  • 3.  RE: On Hold Picking Sheets

    Posted 08-06-2020 14:13
    If you are looking for something reasonably inexpensive, select everything for printing using the select button, then create a VI job that has a condition based on the status.  If the status <> Hold then set the print picking ticket flag to "N".

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 4.  RE: On Hold Picking Sheets

    Posted 08-07-2020 04:06
    What @Doug Higgs said sounds good! Kevin's idea is really good too but I don't think it will trigger the script as I don't believe the SO business object is used for write-back. You could test it. Otherwise if you foresee needing this on an ongoing basis, a mod for Pick Sheet Printing to allow an option for printing orders on Hold​ and then clearing the Hold seems best.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------

    Original Message


  • 5.  RE: On Hold Picking Sheets

    Posted 08-07-2020 08:30
    What about the old convert a sales order form to a pick sheet and run it through sales order printing.

    Doesn’t SO printing let you print orders on hold?

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 6.  RE: On Hold Picking Sheets

    Posted 08-07-2020 09:28
    Picking sheets can be printed for orders on hold.

    Another option is Visual Cut and VI... automate things with a batch process (printing and the flag updates).


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

    Original Message


  • 7.  RE: On Hold Picking Sheets

    Posted 08-10-2020 15:03
    Thank you everyone for the suggestions.

    I tried Kevin's idea of the event and/or column post validate script, but it was not successfully as I hoped. I was able to get the script to run (messagebox), but since it could not read any of the fields, the setvalue did not change anything after it was printed.

    Going to approach the client with Doug idea and see if they are good with it before moving to custom modification.

    Thank you
    Michael

    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    Birmingham, AL
    ------------------------------



  • 8.  RE: On Hold Picking Sheets

    Posted 08-10-2020 15:12
    Can you get the MessageBox to show the SalesOrderNo during printing?  If you can get that much I wonder if you'd be able to create a new SO business object, open the SO with SetKey, then SetValue and Write. I'm guessing the SO would be locked, but if your SetValue isn't working, it might?

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

    Original Message


  • 9.  RE: On Hold Picking Sheets

    Posted 08-10-2020 15:43
    Unfortunately, I could not get the message box to show more than "I am here". The getvalue results are showing a null/ blank value.

    Thank you
    Michael

    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    Birmingham, AL
    ------------------------------

    Original Message


  • 10.  RE: On Hold Picking Sheets

    Posted 08-10-2020 15:59
    Do they have SA&WF?  Perhaps a process using a new/changed alert might be an option?

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

    Original Message


Related Content