I have a question about the stock/inventory system of Odoo. I have a temporary table of items and quantities that I "sold" and every night I want to aggregate/consolidate this into a single sales/purchase order to adjust the inventory. In addition, I would like odoo to report the real inventory, let's everything that's booked via sales order, inventory adjustments with the stuff that comes from the temporary table.
In general, I would want to what is the easiest way to implement this type of logic. I started by (partially re-)implementing `product.template` and `product.product` for the `qty_available`. But reports, this seems to use the quants, I tried to look into that module but I cannot make heads and tails of how it calculates which quantity in which conditions.
What would probably also work in my situation if I had a stock move or sales order that I could just keep appending too but then finalize it at midnight? But I'm not sure odoo allows me to do that? If anybody could give me some pointers and push me in the right direction that would be great.