Hi,
i am building an Item save search and showing the items Location on Hand, Location Committed, Location Available, Location on Order, Back Ordered, and...
1- Because we want to see the Quantity on the WO that are planned or in Process i created a formula.
2- Because we want to see the Quantity on the WO that are Planned or In process + planned I created a formula.
Now what I am trying to accomplish is the following formula that contains the result from number 2-Back Ordered+Location Available. But I haven't had success.
this is the Item Save Search criteria column: the item to be sold? is a custom field that we check the item we sell.
This is my Results column.
I this next image I kinda put what I am looking for:
the column:
(WO Qty (Released or In Process + Planned) - Back Ordered) + Location Available
I hope somebody can help.