I am attempting to write a BPM that will update the OrderHed table’s UserDate1 field to the current date whenever an Order is Closed. I have tried using Method Directives on the SalesOrder CloseOrder directive and Update directive with the SetField action, but neither one was successful. The CloseOrder BPM seemed to stop the Closing process altogether.
Is there a better way to update a field during the Close Order process?
Two Widgets in a Data Directive (as stated by @Asz0ka)… Widget 1 is a condition widget that looks for a change in value from false to true. Second widget (off the true side of widget 1) put a SETTER and set the date field to Today.
I’ve tested the Data Directive with a condition and an Update Table By Query widget. The Update widget has a query which pulls the Company and OrderNum to use for mapping, and binds the UserDate1 field to BPM.function Today(). I tested it set to updated the changed rows and then the updated rows but neither actually set the UserDate1 value.