Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Problem with script updating UDF with date based on SO header order status

Posted By brookem over 9 years ago

Hey all,

I need to write a script that can put the current date into a UDF when the Order Status is changed from "Hold" to "Open".

We have the release date UDF set as a table-post-write.

This is the code so far.

TMPStatus=0

Date=0

retval=oBusObj.GetValue("OrderStatus$",TMPStatus)

if TMPStatus = "O" then

retval=oBusObj.SetValue(“UDF_Release_Date”, date)

end if

I'm really new to this and I'm not sure what I'm doing wrong. Any help would be greatly appreciated. 

Thanks

0 Natasha Chang over 9 years ago

You can do it this way:

SO_SalesOrderHeader - Post Read (save the old value of OrderStatus$)

origStatus = ""

retVal = oBusObj.GetValue("OrderStatus$", origStatus)

retVal = oScript.SetStorageVar("OrigOrderStatus", origStatus)

SO_SalesOrderHeader - Pre Write (set UDF value, date needs to be in YYYYMMDD format)

origStatus = ""

status = ""

retVal = oScript.GetStorageVar("OrigOrderStatus", origStatus)

retVal = oBusObj.GetValue("OrderStatus", status)

If origStatus = "H" and status = "O" then

retVal = oBusObj.SetValue("UDF_Release_Date$", oSession.SystemDate)

end if
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Problem with script updating UDF with date based on SO header order status

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING