A new knowledge base article has been published on our support portal.
In this scenario when an order is marked as ‘Fulfilled’ we need to loop over each of the Order Line Items & decrement the ‘Quantity On Hand’ field on the product entity with the quantity on the Order line Item.
N52 Formula Manager Solution
The Formula Manager solution works like this,
- We create a formula of type Process Genie so that it can be called from a workflow
- A workflow is created that checks when the order goes to a status of Fulfilled
- If it does go to Fulfilled then call the formula to loop over the order line items & decrement the quantity on hand from the product