How can I update business inventory while making an Invoice in Shoes retail shop?
For example while I'm making an Invoice in Excel and when entering quanity of a particular shoe article with design number how can the particular design number quantity get subtracted in Inventory on a separate sheet in a similar fashion like cash register.
I shall be thankful if any body can guide me.
S k