1. Welcome to our site! Electro Tech is an online community (with over 170,000 members) who enjoy talking about and building electronic circuits, projects and gadgets. To participate you need to register. Registration is free. Click here to register now.
    Dismiss Notice

Looking for an Electronic components Inventory system

Discussion in 'General Electronics Chat' started by lilimike, May 13, 2010.

  1. lilimike

    lilimike Member

    Joined:
    Feb 17, 2010
    Messages:
    424
    Likes:
    3
    Location:
    Montreal Canada
    Anyone know of a good free electronic components inventory control?

    Trying to get away from Excel.
    I have tried zParts but it does not have reports and $ values
    I also tried Express Inventory from NCH which I found quite good but it doesn't have sub categories.

    I need to be able to:
    - Generate a report based on minimum quantity (shopping list)
    - Generate a stock value report
    - Create sub categories and have the same product code but with different qty/price in different sub cat.


    Mike
     
  2. Reloadron

    Reloadron Well-Known Member Most Helpful Member

    Joined:
    Dec 23, 2009
    Messages:
    6,778
    Likes:
    281
    Location:
    Cleveland, Ohio USA
    I can understand the frustration with Excel as Excel isn't designed to do what you want. There is no shortage of various inventory control software out there but since regardless of what you buy all your data will need to be moved into a data base I would consider just building my own data base in Access.

    You may want to give this a read and do some looking into Access as a possible choice.

    Ron
     
  3. lilimike

    lilimike Member

    Joined:
    Feb 17, 2010
    Messages:
    424
    Likes:
    3
    Location:
    Montreal Canada
    Ron,

    Funny you are mentioning this, after writing my question I started building my own application in Access, I am an ex software developer trying to make a switch to electronics.
    If I don't find a solution soon, I guess I will have to mess with my old life one more time!

    Thanks

    Mike
     
  4. dave

    Dave New Member

    Joined:
    Jan 12, 1997
    Messages:
    -
    Likes:
    0


     
  5. Hero999

    Hero999 Banned

    Joined:
    Apr 6, 2006
    Messages:
    14,902
    Likes:
    79
    Location:
    England

    Why pay for MS Access when OpenOffice can be dowloaded for free?

    I have not used the database program yet, but the word processor, spreadsheet and drawing programs are quite good.
    OpenOffice.org - The Free and Open Productivity Suite
     
    Last edited: May 13, 2010
  6. lilimike

    lilimike Member

    Joined:
    Feb 17, 2010
    Messages:
    424
    Likes:
    3
    Location:
    Montreal Canada
    Totally agree with you Hero.

    I figured a way out using Express Inventory. I just include what would be a sub category within the product code. For example a 1k axial resistor I call it 1K-TH and its equivalent SMD I call it 1K-1206 so this way i can recognize parts by their code, they appear together in a sorted list and I can have same value in different formats.

    I find Express Inventory the simplest software that does nothing else than what it should do. I get a shopping list based on min/max or an inventory count only one click away.

    Mike
     
  7. Reloadron

    Reloadron Well-Known Member Most Helpful Member

    Joined:
    Dec 23, 2009
    Messages:
    6,778
    Likes:
    281
    Location:
    Cleveland, Ohio USA
    My bad for not mentioning the Open Office apps. The main reason I have used Access is I have embedded data bases on web servers and for small data bases Access worked for me. I never had much luck using Open Office in .ASP applications. Not because of Open Office but likely because my programming skills suck. Likewise foer using MSSQL versus MySQL. Anyway, I used Access because I had it and planting it in a web worked for me at the time. I am sure the open source software would have worked just as well if I had a clue what I was doing at the time. :)

    Ron
     

Share This Page