Monday, March 24, 2008

Order Specifications

I have a nokia retail outlet and have 5 sales man who go around taking orders in South Calcutta and i have to ensure that the order quantity is less than the inventory and the salesman should be aware of the status of the inventory. If the inventory is adequate , they would accept the offer or vice-versa

The master inventory would recieve the order and update the inventory left and the order application will take the orders from the customers. If the product is out of stock,it would be informed to the customer immediately and if it is available, the order would be carried out and would be updated in the order view database along with the name , address and quantity ordered by the customer

Sales Man - Enter Product , Quantity for sales
Check if Quantity for sales <= Inventory
If Quantity <= Inventory, Process Order or else decline order (out of stock)

If the prder is process we shall deduct it from the inventory

Order Management System - All Orders

Order Management System - Order

Order Management System - 2

Wednesday, March 5, 2008