Great product could it:
Show the total value of all stock
Pick up SMTP from the printers so that low toner could be picked up
Produce toner order for suppliler
Send monthly e-mails to finace with departmental charge backs
webman - Can the cost of the consumable be more than £99? I ask as we have some old printers that take cartridges costing more than £100. I dont intend to purchase anymore cartridges for these but we do have some stock on the shelf already. I tried putting in a cost of £104 but it came back as £99 on the consumables screen. Is it as easy to change as going into mysql Db and changing the "Length/Values" attribute for cost from 4,2 to 5,2?
@webman - I added the costs for the cartridges directly into the db via phpmyadmin. I have already installed some cartridges so I was hoping that the reports screen would now reflect the fact that I had added costs to the cartridges. The report shows nothing under costs for those cartridges I already installed before adding in the costs.
Download v1.3.0 (includes fix for consumable costs and added purchase date & cost to printers). Don't forget to read upgrade/changes files.
In response to the costs in the report section. The cost is stored with each log entry at the time, to account for variation in consumable costs over time. E.g. log an install when a consumable is £40, the log entry will be £40. If you then change the consumable cost to £50, previous log entries will remain at £40. This is just to ensure that they always remain accurate, regardless of any changes. If you need to update your logs for that expensive consumable, I would suggest just updating that manually yourself after upgrading to the latest version. The cost columns should now all be float(6,2).
This is brilliant @webman, thank you! Have set it up for all our printers and have done a stock check and now have it all sitting in this system.
The only change I would like to ask for, would it be possible to show the Department for the printer on the Report Page? And be able to sort by this as well? Also, it would be nice to be able to show the cost to each department as a total along with the Grand Total.
A departments feature has always been on the TODO list, but have never really gotten round to adding it. Might do that very soon as well to keep the momentum up
It will be in the 'events' table. The date fields should be readable. You can find the ID of the printer in question by going to the Printers page, click the Edit link on the one that it was wrongly installed to, and look at the address bar at the last bit that says "id=X" where X will be the ID number.
fiza (6th September 2013)
Thank you - all is well again!!
There are currently 2 users browsing this thread. (1 members and 1 guests)