AnsweredAssumed Answered

Formula/Function

Question asked by rogerslp1957 on Feb 28, 2013
Latest reply on Mar 5, 2013 by mikebeargie

Qty Location Part Number

2 2506 80006710

1 2506 324692

3 JOB 45745

 

I need a formula/function that will look in my WORK ORDER FORM for the number “2506” and only 2506 (which is my van stock location) and then subtract the Qty of that part from my QTY USED van inventory form when a new work order is created

 

 

Part Number Qty Instock Qty Used Qty Needed

80006710 12 2 2

324692 6 1 1

 

any help will be greatly appreciated

Outcomes