Here at Chemistry we recently started using a printing charge-back solution called Print Manager Plus. My coworker’s blogs will soon have info on how to setup and optimize PMP, but we ran into an interesting snag that wasn’t caught during testing.
Say someone prints to your poster printer, but the print doesn’t actually come out because the RIP software is stuck or there’s a printer error on the device itself. The user needs the print right away, so they try printing 2-10 more times. Each time they’re charged the full price of the poster so they request that you remove the charges before the billing is compiled. It turns out that the PMP UI doesn’t allow deletion or removal of specific print jobs.
Software Shelf, the creators of PMP, offered me a product called Web Advantage that provides this functionality (in addition to all sorts of other cool features), but we were already over budget on this project. Fortunately, the guys at Software Shelf have designed their database in such a way that manually editing the DB in SQL Server Management Studio is simple and safe (according to their lead developer).
- Open SQL Management Studio and connect to the PMP database.
- Create a new SQL View with necessary modifications to this code:
SELECT TOP (100000000) JobLogID, JobSize, PrintServer, PrinterName, UserName, AppliedGroup_OU, TimeSubmitted, Width, Height, JobCost, PMPJobState FROM dbo.JobLog WHERE (PrintServer = '\\PrintServerName') ORDER BY JobLogID DESC
- Right click the new view and hit, “Edit top ### rows”.
- Find the job you’re looking for, then change the “PMPJobState” value to zero (0).
- Re-run the report and confirm that the job is missing.