Help with code for subtracting

[Marty D]

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

 

[Allen Browne]

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.

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.