https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42218 --- Comment #53 from Pedro Amorim (ammopt) <pedro.amorim@openfifth.co.uk> --- Hi all, I've attached an RM follow-up adding an atomicupdate that rebuilds erm_usage_yus from erm_usage_mus. Without it, the yearly totals stored before the upgrade stay wrong until that provider, report type and year is imported again. Matt is away, and I'd like to push this soon. Nick, could you please sign off the follow-up when convenient? The test plan is in the commit message. About comment 51: as you noted in bug 41294 comment 30, the yearly drift comes from the old per-file yearly entries, which this series replaces with a rebuild from erm_usage_mus. The remaining monthly issues (duplicate rows left by earlier re-harvests, YOP overwrite, missing access_type) are tracked in bug 42217 and bug 43967. I suggest updating this bug's title to: ERM yearly usage totals can be wrong after re-harvesting And also the release notes to: ERM yearly usage totals are now always calculated from the monthly usage, fixing wrong totals when a year was split over several COUNTER files or re-harvested with corrected figures. Existing totals are recalculated during the upgrade. Only regular usage is now imported from COUNTER master reports; text and data mining (TDM) usage is no longer counted. -- You are receiving this mail because: You are watching all bug changes.