I am the office manager of the famous confectionary called D’elite Pvt. Ltd. It manufactures 6 different types of confectionary items viz Chocolate Ecstasy, Vanilla Fusion, Orange Cracker, Coffee cookies, Caramel Fantasy, Butter Glide. The office is located in the proximity of Bakrahat Road (S).The products are being housed in the warehouse after its being produced. The warehouse is located in Behala. The office has 20 salespersons in all, who goes and picks up that inventory which is being ordered by the different distributors. A sales person can only pick orders only if that particular inventory is there in the warehouse. I am required to make an application which enables me to track the flow of orders to the distributors.
The application will seek data from two different tables viz. Distributors, Products. The table name and the information regarding the table are given below:
Distributor_Details table: Distributor name, Distributor ID, location, salesperson assigned
Products_Details table: Product name, Product ID, Mfg.Price, Qty available.
The Product_Details application will update the quantities available in the warehouse whenever an user enters any data regarding the quantities stored in the warehouse.
The actual application “Order_Details” will urge the user to enter the specific Products Name. It will immediately show the quantity available of that product. The user will know whether the order can be taken care of or not after looking at the field value. If there is inventory then the order is carried out and the distributor name whom it is delivered is entered in the following blanks. Automatically the application calls for data regarding Distributor ID and sales person assigned to him through this application. After the order is being entered the application also updates the actual products table regarding the availability of the products in the warehouse.
the link to the application is given below:
http://creator.zoho.com/deepshikhac/order-management-system-of-d-elite-pvt-ltd-/form/16/
P.S. Apologies for the lack of proper functioning of the above mentioned application since it could not be done due to lack of training on coding in ZOHO. I probably would have a programmer in my office who would be in a better position to handle my requisitions given the logic which I want my application to run on!
