An Information System For Inventory Management (A computer- Oriented)

(A computer- Oriented)

The proposed system will be designed to allow a keep track of all goods in stock, goods on order, and the location of the goods in the store. When the store decides to receive a new item, the item will be assigned a unique part-number and added to the master dataBase file. The system will provide the user with reports of all goods in stock, items that need to be reordered, and items on order, and it will automatically produce purchase orders. The system will also allow the user to keep track of all individual sales transactions: item sold. to whom sold, salesperson, date of sale, and invoice number. The user will be able to keep track of all incoming goods as stock is filled up again. The individual transaction records from sales and goods received will be used to update the stock status records in the master dataBase file automatically. The proposed system generally requires the use of several data files. The most important data files are the master file (MASTER.DBF) and two transaction files. One of these transaction files is called sales trans- action file (SALES.DBF), and the second is called the new stock trans- action file (NEWSTOCK.DBF).