Help with code for subtracting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi – Trying to set up a formula as to where when create a work and enter a part from inventory it will subtract that part item (amount in inventory) from inventory. In other words say I have 10 processors on hand and I use 1 processor. I want my inventory to show 9. Is there some type of formula I can use for this

Thank's in advance
 
The basic formula for the number of processors you have left is:
Number of processors last stocktake,
+ acquisitions since then,
- sales since then.

For details on how to implement that, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Marty D said:
Hi - Trying to set up a formula as to where when create a work and enter a
Click to expand...
part from inventory it will subtract that part item (amount in inventory)
from inventory. In other words say I have 10 processors on hand and I use 1
processor. I want my inventory to show 9. Is there some type of formula I
can use for this.
 
Back
Top