I have a small mess in an upcoming B-School in Kolkata dealing in products- soft drinks, eggs, milk, bread etc. There are 20 salesmen who go around the hostel collecting orders. It has to be ensured that the order quantity is not more than inventory. Thus there has to be a mechanism by which salesmen are aware of inventory status. If the inventory is adequate, then the order is accepted, and if the inventory is inadequate, then the order is rejected. To facilitate this process, the following is done:
There will be two forms naming Mess_Inventory and Mess_Order.
The inventory application will add and remove items from the inventory. It will update the quantities and price of items available in the warehouse.
The order application will take order from customers. Once the product name is entered, it will show whether the order can be met or not. If the product is out of stock, it will reject the order. If there is sufficient inventory, then the order is carried out and the customer details are updated in the database. After the order is executed, the application updates the inventory.
Mess Inventory
Mess Invetory View
Mess Order
Mess Order View
Sunday, March 23, 2008
Monday, March 3, 2008
Subscribe to:
Posts (Atom)
