Hi, just learning workflow and wondering if this scenario is feasible?
We have a 3rd party warehouse managment system connected via web services.
[LIST=1]
[*]The sales reps, when finalising a sales order, select a custom drop-down field and select a status of "1-send for picking".
[*]The WMS scans for new orders periodically with this status and pulls them accross and sets the status to "2-in WMS"
[*]When picking commences, another status message is sent back to the netsuite sales order "3-in picking". In theory at this point the reps should never edit an order to add/remove items or change prices.
[*]when picking is finalised a fulfillment is uploaded and the status (not yet implemented but will be shortly) is set to "4-picking complete"
[/LIST]
What I would like to do with workflow, is two tasks:
[LIST=1]
[*]When a sales order is edited and updated (with different qty's for eg) automatically set the status dropdown to "1-send for picking" so that they don't have to remember to do this. I believe this is pretty easy to accomplish with a set field value action.
[*]But I would also like to lock the sales order record for editing when the WMS sets the status to "3-in picking" so that there is no risk of the order being edited while they're picking.
Once the record is locked though, I don't know how you would allow the WMS to still update the status to "4-picking complete" which would then be the criteria to unlock the record for editing again.
According to the suiteflow documentation: Note that if you apply the Lock Record action to a record and then attempt to load that record in Web services or SuiteScript, an error is thrown and the record is not loaded.
Bummer.
[/LIST]
So:
[LIST=1]
[*]is there a way to lock the record for editing in the web user interface in status "3-in picking", but still allow webservices to change that to status "4-picking complete" to unlock the record with workflow??
[*]Should these two tasks be placed into two separate workflow records, or is there a way that you could place them into a single workflow given that they both affect the sales order record.
[/LIST]
Thanks in advance worflow gurus.