Sage 100

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.
------------------------------

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
------------------------------

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:
Sent: 04-08-2026 16:17
From: Kevin Moyes
Subject: Blank ShipExpireDate script

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
------------------------------

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:
Sent: 04-09-2026 12:50
From: Kenny Daniel
Subject: Blank ShipExpireDate script

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:
Sent: 04-08-2026 16:17
From: Kevin Moyes
Subject: Blank ShipExpireDate script

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