Hi,
I have 2 tables on with sales invoice format another table is stock. I want to update the stock item's quantity every time I sell something. If I sell 10 Mobiles it should be subtracted from stock table, and the same way If I raise the purchase invoice it should add quantity as 100 in the stock table with respect to product name.
Thank you.