Sage 100

 View Only

  • 1.  Blank ShipExpireDate script

    Posted 04-08-2026 16:02

    I have a very simple 3-line script (below) that blanks out the ShipExpireDate on a new SO. The script is triggered when the customer number is entered (Column-Post Validate) on the SO header screen. Everything works great except for when a Quote is converted to a Standard SO. Sage100 refreshes all the fields, including the customer number, and populates the ShipExpireDate with today's date. In order to blank out the date again, they will need to change the customer number to another and then change it back again in order to trigger the script again. I'm not much of a scripter. Is there any way around this? TIA

    retVal = 0

    TempDate = "       "
    retVal = oBusObj.SetValue("ShipExpireDate$",TempDate)



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------


  • 2.  RE: Blank ShipExpireDate script

    Posted 04-08-2026 16:17

    Perhaps try attaching your script (column post-validate) on the PromotedDate in SO header?  I think that is where Sage stores the date that the quote is promoted into a Standard order... although the Sage programming might not trigger a column event, so you'll want to test that.



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



  • 3.  RE: Blank ShipExpireDate script

    Posted 04-09-2026 12:50

    Thanks Kevin. Sadly, that did not work. Nothing seems to get triggered when you change a Quote to an Order until you confirm and press Accept. However, it's odd that the shipexpiredate does get changed to the current date. I'm guessing they might have to live with changing the customer and changing it back again if they want to blank out the shipexpiredate 



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------

    Original Message


  • 4.  RE: Blank ShipExpireDate script

    Posted 04-09-2026 12:51

    A button script would be easier for the user than changing the customer...



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

    Original Message


Related Content