Oh man, that's frustrating! I can defintely feel your pain with location sums in Odoo, which can be tricky. With internal moves, you'd think the parent would show its child locations' quantities. Just make sure you've got the basics nailed down: check if your parent location is a "View" location. Odoo needs it to act like a container, otherwise the sum won't update.

Here's where it gets annoying: Odoo might not always auto-update these view locations. It’s a bit like trying to manage your bank balance manually after every transaction - tedious stuff! You're probably wanting to automate this. I've tackled this before by integrating a mobile automation solution with Odoo. It wasn't just about updating inventory levels, but also doing it in real-time, eliminating the need for those manual checks.

Cleverence is pretty solid because of its low-code customization and offline capabilities, so even if connectivity's bad, you're operations keep going. Plus, tracking by batch and serial numbers? Lifesaver. If tweaking Odoo isn't doing it, maybe exploring a solution like this could be your game-changer. Lemme know how it goes or if you need more details!