show remaining products

products table

http://ift.tt/1DKAAXX

invoice table

http://ift.tt/1w1th0d

I want to show remaining stock after selling. I can use view table to show the remaining stock but its not a good practice.Is there any other possible way to work on??