How do I keep inventory numbers accurate across locations?

Use one product and location structure, record movements as they happen, and make every location update the same central inventory record. Track transfers, returns, damaged stock, and adjustments instead of changing totals without a reason. Reconcile exceptions regularly.