Basic Order Collection Application

I have a small store dealing primarily with six products- confectionaries, biscuits, ice-cream, chips, chocolates and cold drinks. There are twenty salesmen who go around 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 Inventory and 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.

Master Inventory

Inventory View

Order

Order View

Beverages Market Research