How can I handle Sales Returns & Sales (Cash & Installment) in SQL Server Database?

Question

1.25/5 (3 votes)

See more:

SQL-Server-2008

Hi, I have this Database:

http://social.msdn.microsoft.com/Forums/getfile/397664[^]

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

Updated:

My database tables like that:

<img src="http://i43.tinypic.com/2s7gwn5.jpg" border="0" alt="Image and video hosting by TinyPic"></img>

And there is sample for data in it:

<img src="http://i40.tinypic.com/6fa06w.jpg" border="0" alt="Image and video hosting by TinyPic"></img>

And I mean by "So , the total amount of this customer will be 400, & he pay $ 500 , The remaining amount in installments" that some customers pay there amount - not this case - in installments

Posted 15-Jan-14 6:40am

Doudy_2020

Updated 16-Jan-14 4:35am

v3

Add a Solution

Comments

gettgotcha 15-Jan-14 14:11pm

Sorry I couldn't get a clear picture here, what exactly you mean "then he returned products by $ 600"

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2014-01-15T10:56:00

You just need to sum up the amount paid and the amount bought. What I don't see is a way to record items returned in this database ? Perhaps if you gave us SQL to create these tables, and sample data and your expected output, we could help more.

Your question is clear to me. Someone bought $1000 in goods, and paid $500. So they owed $500, but then they returned $600 worth. I don't get 'The remaining amount in installments', do you mean he intended to pay in installments ? Because he's now owed $100.

And you don't 'handle a scenario' in SQL Server, you just get the data and your business layer decides what to do with it. What do you WANT to do, is the core question ?

You have not answered me. What do you WANT to do ? What is your question ? Do you not know how to create the tables to manage returns or installment plans ? Which bit are you stuck on ?