Hi.
I have this Item save search that provided me open sales orders committed and not committed and work orders. This image is just as a reference to try to explain what I am looking for to do.
I am looking the following formulas:
1- To Sum all the Sales Orders that are not Committed that are minor of the date of the Work Order. For example: The first WO date is on 10/28 so I would like to Sum the Sales Orders containing 0 committed, the one from 9/28 and the two of 10/03. Will sum the quantities. 25+41+15=81.
2- If there is not WO to Substract Qty in Inventory Now - the previous result: 415 - 81 = 334. But if there is a WO to sum the (Qty in Inventory Now + WO) - the previous result: (415+72)-81 = 406.
As I mentioned before that image is a reference. I would like the save search to have two columns, the Item and the result of the formula.
is an Item save search and this is what I have on my criteria:
this are my results: This is just to show how i am getting the data.
I really appreciate your help.