Hello,
We currently have workflows that define approval processes on sales orders, that go to different people for approval depending on the total amounts of the transaction.
Right now we want to put some approvals based on the total cost of the items in a sales order, not the selling price. For example, if total cost of items < 100,000, then only the accounting manager has to approve. If total cost of items > 100,000, then both the accounting manager and the CFO have to approve.
We already have all the workflows for approvals of sales order based on total selling price. But I need a way to do the following:
1. Sales Order is created
2. Find the total cost of all the items in the sales order (since we do not know the real cost until the fulfillment is done, I think I have to look in the average cost field of each item in the same location of the sales order)
3. Send Sales Order for approval depending on total cost found in step 2. above
The challenge for me really is getting the item average costs, summing them all together, and then putting a condition on that to trigger correct approval person.
I think I can say I am intermediate in SuiteFlow, but this I am not able to figure out. I'd very much appreciate some help here, even if you think I should be doing it in a way other than using SuiteFlow.
Thanks
Rafid