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