The Basic Order Inventory System should have the following features:
1) Main Inventory System
This will have details of the stock in the company stores.
It should have the following fields-
a) Product (compulsory field)
b) Quantity (compulsory field)
c) Unit Price (compulsory field, in INR)
The company has 6 products at present, hence, there should be an accomodation for these. Besides, it should have a capacity to scale up if the organization desires to add more products in its inventory.
2) An Order Database
This will be used to store details of the orders places by the customers.
It should have the following fields:
a) Customer name (compulsory field)
b) Address
c) Product (compulsory field, should be the same as the ones in the main inventory)
d) Quantity (compulsory field)
e) Order Value (compulsory field, in INR)
As soon as the order is placed, the system should be able to check whether there is enough stock available with the company to complete the order. If not, then a message stating that should appear. If the order is completed then the order value should immediately be calculated. The system should be realtime enabled.
The Inventory Management System
Inventory Database
Inventory View
Order Database
Order View
Sunday, March 23, 2008
Subscribe to:
Posts (Atom)