Hi, I have this Database:

My scenario like that:
Customer A has purchased products by $ 1,000 on 1/1, & pay $ 500, then he returned products by $ 600.
So , the total amount of this customer will be 400, & he pay $ 500 , The remaining amount in installments

How can I handle this scenario in SQL server database to create Customer payments form using c#

Go to the complete details ...