Preview

Warehouse Management

Powerful Essays
Open Document
Open Document
7373 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Warehouse Management
WAREHOUSE MANAGEMENT SYSTEM
By

HEMANAND.R (Reg. No: 35203051)

A PROJECT REPORT Submitted to the Department of Computer Applications in the FACULTY OF ENGINEERING & TECHNOLOGY in partial fulfillment of the requirements for the award of the degree

of

MASTER OF COMPUTER APPLICATIONS

S.R.M. ENGINEERING COLLEGE S.R.M. INSTITUTE OF SCIENCE AND TECHNOLOGY Deemed University May, 2006

CHAPTER 1

INTRODUCTION

1.1 Literature Survey

The main objective of this project is to computerize the Warehouse Management System. Warehouse is a place where materials are stocked. Warehouse deals with wide range of computer spares like drivers, monitors, add-on cards and multimedia products etc. For that, they need several materials and components. To get better and sufficient

components with least cost and with better quality they place the order to the suppliers to accomplish the purchase task. After receiving the

required material the finished goods are prepared and dispatched. Service for finished goods are done.

As the first step, the Customer places the purchase order to the Head Office. If all the terms and conditions are satisfied, it sends the purchase order to the Warehouse management department. The

Warehouse department keys-in the purchase order and if the stocks are available for the purchase order, the warehouse department sends the goods to the Customer along with a delivery note. A copy of the

delivery note is sent to the HO and it produces the invoice, which is sent to the customer. In the Warehouse, if the quantity on hand value of the products becomes less than that of the re-order level of the product. The warehouse places an order to the supplier seeking for the product with their quantity mentioned. These details are noted down as in the order details of the warehouse.

When the stock arrives from the supplier to the warehouse, Raw materials inward note is prepared. After inspection of the goods, the

goods that are turned to be good and without any



References: BOOKS REFERRED 1. Harold Davis (2003)" Visual Basic .Net Programming ",2 n d Edition, Apress, PP 204-508 2. Steven Holzner (2005) " Visual Basic .Net Programming ", 2 n d Edition, DreamTech, PP 327-774 3. Gayle Coffman (2005)" Sql Server – 7 The Complete Reference ", 3rd edition, Apress, PP 516-734 4. Paul Conte,Gayle Coffman (2002)" Sql Server – 2000 Developer Guide ", 2ndEdition, Macbeth, PP 167-413 WEBSITES REFERRED 1. http://www.dotnetbips.com/displayarticle.aspx?id=205 2. http://www.codeguru.com/forum/showthread.php?p=1125666

You May Also Find These Documents Helpful

  • Good Essays

    They first order the products that are needed. Then these items are shipped to Riordan manufacturing warehouse. Once truck arrives each item must be scanned to ensure they are receiving every item, the correct items, and making sure it was not over ordered. As they scan each item in it is electronically put in to their warehouse system and then if all information is accurate they put it all away in the warehouse at that time. There new system has stopped them from wasting time in areas that they did before, which was what their goal as a business was to…

    • 766 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Riordan Manufacturing

    • 390 Words
    • 2 Pages

    Once orders are concurred, the receiving team unloads truck and moves raw materials into the factory.…

    • 390 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Fast Fit Case Study

    • 1580 Words
    • 7 Pages

    | HQ sends orders to the supplier notifying them of the quantity of goods that needs to be sent to the warehouse. When the supplier receives these orders, they then send the goods to the warehouse. From there, the warehouse records and sends the appropriate amount of goods to the store. And from the store, the goods are sold to the customer.…

    • 1580 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Kroenke, D. M., & Auer, D. J. (2010). Database Concepts (4th ed.). Retrieved from https://ecampus.phoenix.edu/content/eBookLibrary2.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    CS320 Lab1

    • 874 Words
    • 3 Pages

    format and submit it to the course canvas. This covers SQL Part A (Chapters 2,8&…

    • 874 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    The process performs on manual entry at the end of each business day by the warehouse department. Each of the locations within the company operates independently of each other with no inner communication. Each department has its own inventory which could result in the possiblility of over purchasing of materials while another location could have overstocked. The process of receiving materials is a long an unaccurate process. A receiving department employee must visually inspect the paper work and verify that all the items purchased on the invoice has come in.…

    • 769 Words
    • 7 Pages
    Good Essays
  • Good Essays

    Cole Swot Analysis

    • 730 Words
    • 3 Pages

    Orders entered on a computer terminal at the store and transmitted to the warehouse for picking. Packed goods were then delivered to the store ready to be picked up by the customer later in the day.…

    • 730 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Upon receipt of goods, Betta Burger will receive a delivery note/supplier invoice with all the details of the stock ordered.…

    • 1045 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Accountant 492

    • 1210 Words
    • 5 Pages

    3. The inventory control department prepares purchase requisitions. Reason: This is not an authorized way of preparing purchase requisitions.…

    • 1210 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    1. Look up the history of SQL. How many revisions of the standard have there been?…

    • 327 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Cis 111

    • 790 Words
    • 4 Pages

    (2012). Database systems: Design, implementation, and management. (10 ed.). United States of America: Joe Sabatino.…

    • 790 Words
    • 4 Pages
    Good Essays
  • Good Essays

    1.) There have been several versions of SQL created in the last 26 years. In 1986, SQL-86 (SQL-87) was first published. In 1989, SQL-89 was a minor revision made to the original SQL. In 1992, SQL-92 (SQL2) was a major revision to its previous version. In 1999, SQL-99 (SQL3) added regular expression matching, recursive queries, triggers, non scalar types and some object oriented features. In 2003, SQL-2003 introduced XML related features, standardized sequences, and columns with auto generated values. In 2006, SQL-2006 defined ways in which SQL can be used in conjunction with XML and it defined ways of importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form. It also enables applications to integrate into their SQL code the use of XQuery. In 2008, SQL-2008 Legalized ORDER BY outside cursor definitions, added INSTEAD OF triggers, and added the TRUNCATE statement. As of March 2012, the newest SQL was released its new features include AlwaysOn SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new Spatial features, Metadata discovery, Sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and Partition level operations and security enhancements including Provisioning During Setup, new permissions, improved role management and default schema assignment for groups…

    • 701 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Today's ASDA¡¯s warehouses function autonomously, but they must also learn to think universally. This can lead to the development of advanced systems built on the idea of distribution at an enterprise level, connecting multiple sites and supply chains together for a network-centric view. Storage is the core activity of warehousing and it identifies the location where the goods are deposited and held…

    • 3356 Words
    • 14 Pages
    Powerful Essays
  • Powerful Essays

    Cis515

    • 3200 Words
    • 13 Pages

    O 'Brien, M. C., & Winter, J. (n.d.). Developing Stored Procedures for Microsoft SQL Server.…

    • 3200 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    11. Quantitative details of Raw material Work in progress and Finished Goods stock and certificate of Physical verification and stock on hand.…

    • 510 Words
    • 3 Pages
    Satisfactory Essays

Related Topics