Hello Dear Experts
i want only the data in blue highlighted column range E14:E37 in invoice must be added against its respective product codes in Stock.
In case of sale transaction it should be added to qty. sold against respective product code in stock.
In case of Purchase transaction same data should be added to qty. purchased in stock against its respective code.
i hope my question is clear
My sheet attached