Inventory System
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: Inventory System

  1. #1
    Join Date
    Oct 2010
    Posts
    1

    Unhappy Inventory System

    Hi,

    I need help on the specified project below. I got no idea on how to do it, if some one could help me in contributing some idea for me to start work on this as i need to submit this project in three weeks....please help!!! VB.net and SQL Server

    Objective
    Create an inventory system that allows records of company inputs and outputs, tht's viewable through daily, weekly, monthly, yearly report as well as online control over items.

    Aim
    To simplify the process of inventory management.

    Target
    Lower Company Cost
    Save Time
    Management Control

    Task
    1. The Management should be able to view transaction of input and output of item in the company.
    2. Employees, supervisor or administrator level personnel will have the ability to input all items o fhte company; such as assets like PErsonal COmputer, LCD television and so forth.
    3. The administrator level personnel will have to key-in items to be posted out.
    4. However, the administration level personnel would not have the ability to approve the transaction.
    5. Only the higher management level people; such as Managers, Head Department and so forth is able to view these transaction and approve them.
    6. The system should be able to identify based on each item code, from that code it is able to tell each transaction(if any), item purchased, item write-off and forth.

  2. #2
    Join Date
    Dec 2009
    Posts
    596

    Re: Inventory System

    You have no idea? That can be interpreted many ways. If I were a computer that would mean to me that you need help with UI design, database design, how to connect to the database and the list goes on. I can only guess what you really need help with. When I'm roughing out a project I keep the output in mind. If in the end it's a report that needs to be viewed and or printed then that will be my guiding light. For me then there will be SQL statements to produce the report. So with that in mind I will mockup how the queries fit in the system. Design the database. Decide how to restrict what parts of the system are available to which ever group of users. Maybe a login will dictate which parts of the system are enabled or something like that. Get everything figured out. Then with your roadmap tackle the bits and pieces making sure to not add or take away anything from the ultimate goal. I saw an Access inventory template available once from Microsoft. Take a look at that to see how that system flows to get some ideas if you think you will benefit from it.

  3. #3
    Join Date
    Jan 2006
    Location
    Chicago, IL
    Posts
    14,875

    Re: Inventory System

    Pretty hard to do a semester project in three weeks. Unless you're about to start a 3 week class, and wonder what a computer is...
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  4. #4

    Re: Inventory System

    I'm about to begin a similar project for our IT Dept.

    It should be a lot of fun.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center