Comments by RomanRapido (Top 3 by date)

Here is a link and there is an image for the tables that I have created on sql server.

Thank you Arun Rajendra for your reply. I have done that before but most suggested that it is right to summarize sales and purchases including returns then subtract and add. My question is that , how about if there are millions of records already on sales and purchases alone? They said it is very quick on sql server using view. I have asked this question so that experts like you can comment and suggest on this. If that is the case then will it be applicable also to store Customers balance as a field? then later on, if there are payments made by the customer then I would subtract it when a payment is saved?