Hi All,

I'm looking for a way to track a Product Items Quantity on hand against a Work order Line Item.

I created a number formula field on the Work order Line Item looking through the pricebook entry > product >Product item > Quantity On Hand, but I am not receiving anything back, even though the product has Product Items.

I'm sure this is a simple enough one, but can't quite get it working. Or should I be using the Product Required Object for this?

Once I have this, I'll be able to Automate other process based on the Quantity of the Work order Line Items (Create Order if stock is below a certain level).

Thanks