The month-end inventory takes a minute instead of four hours. The product data underneath is in better shape than when we started.
What they wanted to improve
The month-end inventory took about four hours, once a month: reading the stock figures out of Odoo and typing them into the workbook the plant reports from.
What I did
A month-end run that fills the workbook straight from the ERP. It works out the right period itself from the stock movements and rebuilds its data on every run, so running it twice is safe. Building it surfaced something else: an older version of Odoo had let duplicate and badly defined products accumulate, so part of the work became cleaning that up with them.
The result
The month-end inventory takes a minute instead of four hours, and the product data underneath it is in better shape than when we started.