Message Box Showing Up Even When Intended Criteria is not Met

Question

Hi, 
 
 A few days ago I had a Post that I was lucky enough to get help with. After getting some feedback from some of our shipping department, they let me know that even if they go in and change the Ship Date in Sales Order Entry, the message box will still pop-up. I thought maybe it was because the order's ship date was original older than today's date. But after creating some test orders with ship dates a week from today, I realized this message box is showing up no matter what. I attached the code I was using which again, I got from the original post, the only change being what I wanted in the message box. Maybe I'm missing something in this script that is causing the message box to show up no matter what but does anyone have any ideas? 
 sShipExpireDate = "" : oBusObj.GetValue "ShipExpireDate$", sShipExpireDate

	
	If oSession.UI <> 0 And sShipExpireDate < oSession.SystemDate Then

 oSession.AsObject(oSession.UI).MessageBox "", "Ship Date is Past Due. If necessary, change the Ship Date in Sales Order Entry."

	End If

David Speck · Accepted Answer

Having the script on SO_SalesOrderHeader will not help because the script won't trigger when you need it. 
 What event do you currently have it assigned to on SO_InvoiceHeader? 
 If on the post-validate of the SalesOrderNo field, it is possible that the ShipDate$ hasn't been populated yet with the value from the sales order source document. If this is the case, you may need to use the following. 
 oBusObj.ReadAdditional "SalesOrderNo"
sShipExpireDate = "" : oSession.AsObject(oBusObj.GetChildHandle("SalesOrderNo")).GetValue "ShipExpireDate$", sShipExpireDate
If oSession.UI <> 0 And sShipExpireDate < oSession.SystemDate Then
	oSession.AsObject(oSession.UI).MessageBox "", "Ship Date is Past Due. If necessary, change the Ship Date in Sales Order Entry."
End If 
 You could instead put the script on the pre-write event of SO_InvoiceHeader and then it could reference the ShipDate$ field in SO_InvoiceHeader because at the point when the script is triggered, the ShipDate field should definitely have a value AND since it is checking the ship date of the actual shipping entry, if the user does adjust it accordingly, they won't get the message. 
 
 Keep in mind though that a change to the ShipDate in shipping data entry will not update the ShipExpireDate in sales order entry.

Sage 100

Message Box Showing Up Even When Intended Criteria is not Met

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING