This is a discussion on Auto Deduction Of Stock within the Excel Questions forums, part of the Question Forums category; I Need A Formula Which Can Help Me To Minus My Stock When I Make A New Invoice. I Have ...
I Need A Formula Which Can Help Me To Minus My Stock When I Make A New Invoice.
I Have One Master File In Excel For My Stock.
When I Make Some Invoice From Some Lot Number.
That Time The Master Stock Of That Lot Should Minused Automatically.
Hi Onkar. Welcome to the Board,
Try the link below , or you may want to consider an
Access database if you have a considerable amount
of inventory sku's & sales orders.
Creating a Stock Management System