Ratib Hussaini
Registered User.
- Local time
- Today, 15:58
- Joined
- Nov 7, 2012
- Messages
- 31
Hello everyone, i am making a small database, almost half of that is complete,, and i am facing the following problem.
There is one warehouse and two stores A and B respectively. The same product could be at warehouse, Store A and B. As per requirement some of the products are moved from warehouse to Store A and B, some times returned back to warehouse and from A to B as well.
e.g. there is a product code 001.
in the warehouse: QTY =10
in the Store A: QTY=3
in the Store B: QTY=2
Now I want to move 5 of the product 001 from warehouse to Store B. First it should be checked weather that much amount is available in warehouse, if available after moving it should update the qty in both locations. If not available should show a msg that this much amount is not available or else.
it is urgent .thanks
There is one warehouse and two stores A and B respectively. The same product could be at warehouse, Store A and B. As per requirement some of the products are moved from warehouse to Store A and B, some times returned back to warehouse and from A to B as well.
e.g. there is a product code 001.
in the warehouse: QTY =10
in the Store A: QTY=3
in the Store B: QTY=2
Now I want to move 5 of the product 001 from warehouse to Store B. First it should be checked weather that much amount is available in warehouse, if available after moving it should update the qty in both locations. If not available should show a msg that this much amount is not available or else.
it is urgent .thanks
