How can i handle to sell same stock from different location ?

Question

5.00/5 (1 vote)

See more:

SQL-Server-2005

Hi all,

I don't know how to handle to sell same stock from different Counter.
How can i check that stock is in store or not because that can sell from different Counter at the same time.

e.g.
I have an Item 001.
I keep Stock In record of an Item by Batch No. .

Stock In
          Item Code      Batch No.        Qty
             001             1               10
             001             2               30

And also keep Sales record of an Item by Batch No. .

Sales 
          Sales ID    Item Code      Batch No.        Qty
             1            001             1            5

I wanna know how can i check which batch is how many left qty in store.

* **Main point is i can't handle of Stock Checking from different Counter. When 'CounterA' insert 5 qty of Item 001 to sell, at the same time 'CounterB' insert 5 qty of Item 001 to sell.

When 'CounterA' check that Item of Store Qty, Store returns batch no. 1 is 5 left because 'CounterB' is not Complete in sales issued. And also When 'CounterB' check that Item of Store Qty, Store return batch no. 1 is 5 left because 'CounterA' is not Complete in sales issued.

A Counter insert an item to sell, I just check and insert sales qty on DataTable of each Form.

After insert all sales items then i add that DataTable to MS SQL DB. So I got Two Sales Records with Batch No.1 .

Sales 
          Sales ID     Item Code      Batch No.        Qty
          2             001             1               5
          3             001             1               5

The fact is there's only 5 qty of Batch No.1 because i've already sold 5 qty.

Hope you all can give me an advice on my post.

regards,
nway nge

Posted 3-Dec-11 21:38pm

nwayynge

Updated 3-Dec-11 23:13pm

DaveAuld

v6

Add a Solution

Comments

DaveAuld 4-Dec-11 3:41am

Sorry, you are not making much sense with that question. please explain a little more.

[no name] 4-Dec-11 4:09am

agree indeed

nwayynge 4-Dec-11 4:13am

i don't know really how to explain more ..
thanks ..

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)

Amir Mahfoozi · Accepted Answer · 2011-12-03T22:32:00

As I understood your problem, the race that occurs between counters ran you into a trouble.
To solve this problem you need to bundle all operations into a transaction and set its type to a serializable one.
It will guarantee for you that client operations do not coincide with each other and no further race will happen.

You can do the transaction in application level or SQL level. so its up to you to decide.
If you prefer SQL then write a stored procedure that get the parameters and do its operation in begin and commit transaction block.
so you will have something like this :

begin transaction 
  see how much items have remained
  save its sale quntity if its possible 
commit transaction

to learn more about transaction read these resources :
http://msdn.microsoft.com/en-us/library/ms188929.aspx[^]

http://msdn.microsoft.com/en-us/library/ms173763.aspx[^]

http://msdn.microsoft.com/en-us/library/2k2hy99x%28v=vs.71%29.aspx[^]

Hope it helps.