https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27950 Bug ID: 27950 Summary: Add a script to automatically deprecate replacement costs based on age Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: robin@catalyst.net.nz It would be useful to have an automated process for adjusting items.replacement price based on age -- some libraries do not wish to charge the full purchase price for an item that's older. At its simplest, this could be just UPDATE items SET replacementprice=(replacementprice * X) WHERE replacementpricedate < date_sub(curdate(),interval Y day); With X and Y set in flags on a cronjob. We could go one better and add a syspref to allow those values to be set within the staff interface. Or we could do better still and add a more complicated syspref to take some YAML defining different X and Y values per itemtype. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.