I have the following script that pops up a message in Company Code HMC for users other than TAG when a certain UD is populated. Works fine....
retVal = 0
Set oUI = oSession.AsObject(oSession.UI)
TRANS = ""
USER = ""
COMPANYCODE = ""
retVal = oBusObj.GetValue("UDF_TRANSMITTED_TO_WAREHOUSE$", TRANS)
USER = oSession.UserCode
COMPANYCODE = oSession.CompanyCode
Set oUI = oSession.AsObject(oSession.UI)
TRANS = ""
USER = ""
COMPANYCODE = ""
retVal = oBusObj.GetValue("UDF_TRANSMITTED_TO_WAREHOUSE$", TRANS)
USER = oSession.UserCode
COMPANYCODE = oSession.CompanyCode
If USER <> "TAG" THEN
If COMPANYCODE = "HMC" THEN
If TRANS= "Y" THEN
sMsg = "WARNING: CANNOT CHANGE! This line has already been transmitted."
retVal = oScript.SetError(sMsg)
End If
End If
End If
If COMPANYCODE = "HMC" THEN
If TRANS= "Y" THEN
sMsg = "WARNING: CANNOT CHANGE! This line has already been transmitted."
retVal = oScript.SetError(sMsg)
End If
End If
End If
...my question involves when the script is invoked. I went into User-Defined Field and Table Maintenance, selected the User-Defined Scripts button on the right and "told" Sage 100 when to run the script. However, I do not want the script to run at all in a certain Company Code. Is this even possible? I know I set the script above to only perform in HMC however it is still invoked in other Company Codes and I want to prevent that. In other words, in Company Code TST I do not get the Message from the script but I am sure the script is still invoked.
Thanks!
