External data integration for stock & quantity on hand
I would like to integrate a third-party pos system into odoo, and use odoo for stock management and other aspects. So far I've been able to make a setup to modify `product.product` / `product.template` and override`qty_available` with real-time information- but this approach doesn't seem to play well with other aspects of odoo.
For example current inventory valuation this is calculated based on qty_available, but the stock report seems to work based on another mechanic. There are views, where they split up goods in different warehouses, seem to work based on stock.moves and others work on quants.
What I would like to do is every day or hour create a `stock.move` aggregate with information of outgoing or returning stock that day. But even this seems to be conflicting with the way inventory adjustments work are set to absolute numbers rather than doing a relative correction.
I could really use some pointers on what would be a good way to integrate this external data into Odoo.