Saturday, March 22, 2008

Order Management System - Order Form

Order Management System - Specifications

I am the office manager of a small Business Unit. I want to create a small system that will help the company to track the orders as they are picked up by the sales force. We deal with FMCG products which has three application areas as follows.

  • Personal health care

o Shampoo

o Soap

o Conditioner

  • Chocolates

o Choco Pie

o Five Star

o Bar One

  • Biscuits

o Marie Gold

o Maska Chaska

o Cream Treat

We have 20 salespersons that go around the state collecting orders from a set of distributors. And we have a central warehouse where we have inventories of goods.

I want you people to develop software which will enable my salespersons to record the orders online. The program should have the following features

Data Entry Functions

Manage Customers and orders

  • Add orders
  • Show all orders
  • Customers Name
  • Company Name
  • Contact details for the shipment – Address, Contact Number, Email Id, Fax No
  • Product Details – Product application area, product Name, Quantity Ordered
  • Date and Time when order is placed

Inventory Management

  • Product Application Area
  • Product name
  • Unit-Price for each product
  • Product ID
  • Current Stock.

The program should be such that as soon as the salesperson adds the order the inventory should change accordingly and should show the current stock.

Hope you have got an idea of our requirements.