Solved

Cartridge Inventory

Posted on 2006-06-15
12
3,231 Views
Last Modified: 2008-02-07
Hi,

Is there a FREE/CHEAP software/db out there that can help me inventory my company's printer cartridges.
I need something that will remind me when it's time to buy some more.
0
Comment
Question by:kupzpenny
  • 5
  • 4
  • 3
12 Comments
 
LVL 5

Expert Comment

by:BPeb
Comment Utility
A better resource for this type of question would be www.Download.Com at Cnet.Com.  There you can search for the type of software and see reviews from other users.  And of course you can download what you find.

Good Luck.
1
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
Here are a few free software packages for you to look at:

If you need a full featured accounting system that includes general ledger, invoicing , i
inventory, etc. here are two free packages.

              http://www.dblonline.com.au/free.htm

              http://www.freeaccountingsoftware.net/

E-Commerce (web) based free inventory system

               http://www.dirfile.com/tincontrol.htm

Full featured Parts inventory system for $20 -see screenshot
                 http://www.sobersoftware.com/screenshots.htm

0
 
LVL 7

Author Comment

by:kupzpenny
Comment Utility
Thanks for the response. But it's not quite what I'm looking for. Is there anything dedicated to printer supplies only?
0
 
LVL 5

Expert Comment

by:BPeb
Comment Utility
It sounds like your looking for either a off the shelf solution or a template to be used with Access or something.  Off the shelf is not going to be free or cheap.  A template for inventory can certainly be found.  MS has them for Excel and Access.  With those you just open and go, but you have to live with whatyou get.

If you have any DB experience at all you could easily and quickly create what you need.  All your tracking is the Printers, the type of cartridge they use, and an expected life of the cartridge and thats one table.  Then you have a table that tracks when the cartridges were installed.  Running a report off of that weekly will give you your schedule.

Good Luck
0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
You want something like the one used at this link:

               http://www.allprinterinkcartridges.com/

Unfortunately, I have not found an off the shelf solution for sale, and certainly not for cheap or free.  However, I will research a little more to see if I can find anything for..
0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 7

Author Comment

by:kupzpenny
Comment Utility
http://www.allprinterinkcartridges.com/
http://www.fishbowlinventory.com/?utm_medium=ppc&utm_source=Google&gclid=CIuvju-81oUCFRaAFQod-1i8nw

- Thanks for the link but I it's too much. I'm not planning to sell inks. i just need to monitor them and order when the supplies are low.

I'm leaning towards Bped suggestion of using access. however, I can't find a template suitable for my needs. And i'm not very good in access to create my own db. Do you guys now any link where i can download more access templates. I already tried google and office.m$.com. thanks
0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
Sorry, I misunderstood...I thought you were in the business. I can get you links to some simple free inventory systems. Will get back to you.
0
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 125 total points
Comment Utility

http://office.microsoft.com/en-us/templates/TC010184581033.aspx
             Microsoft Access Inventory Template (free download)

http://www.tinit.co.uk/?s=Stock_Control
          MS Access based, tracks reordering levels ($34.95)

http://www.100inventory.com/
          designed for home use, but can be adapted for small business use   (free)


       
0
 
LVL 5

Assisted Solution

by:BPeb
BPeb earned 125 total points
Comment Utility
The templates above will work if you can live with what they do.  You say you don't have a lot of experience with Access, well this would be a good project for you to learn it on.  It's not too difficult and you can improve on it later on.   So here are some thoughts on table design to get you started.

Use at least two tables (you could roll the Maintenace into the Printers tables)

    Printers      (prtID, prtName, prtLocation, prtType, prtVolumePerMonth, prtReplaceEvery, crtID)
    Cartridge    (crtID, crtCartridge#, crtVolume)
    Maitenance (prtID, mtLastChanged, mtExpectChangeDate)

Create a form with Printers as the source, place a combo drop down with Cartrideges as the source (bind on crtID).  That will give you your setup screen.  The maintenace table can be a subform that shows your change history, or if you've rolled it into the Printers table then it will only show you one entry and that will be the last changed date and the expected change date (and that is a simple calc between printer volume per month and cartridge volume).

Good luck.
0
 
LVL 7

Author Comment

by:kupzpenny
Comment Utility
Thanks for all your help. I'll probably modify the MS template. I'll post some more if i run into any problems.
0
 
LVL 5

Expert Comment

by:BPeb
Comment Utility
Sounds good.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now