Hi All,

I have a situation were i need to calculate the current stock inventory of
items.

eg:

item no Instock Issued Qoh

aa 56 2 54
bb 30 1 29

next time when i go to item aa and bb and issue some more items than it
should update the qoh

eg
qoh. should get updated as instock for the next transaction.

item no Instock Issued Qoh

aa 54 4 40
bb 29 2 27

can this be done. I am not very good with VBA. Any help would be appreciated.
thanks in advance