Hey guys, I have a client on Odoo Online (standard SaaS) who wants a custom report that I’m not sure is doable without Odoo.sh. They want a "Product Activity Statement" that basically lists every time a specific product was bought (Purchasing) and every time it was sold (Sales) in one combined table or page.
Basically, they want to go to a Product, hit Print, and see a history of both inbound and outbound transactions. Since I'm stuck with just Odoo Studio, is there a way to pull lines from both sale.order and purchase.order into a single report? I can't write custom Python for this, so I’m looking for a workaround using the report designer or maybe some hidden XML tricks. Is this possible, or do I have to tell them it's an Odoo.sh-only job? Thanks!
It depends on what details the client wants to see. If they only need quantities, the “Moves History” report is sufficient. You can filter the movements by Sales or Purchases and then use an Export Template to generate the format they want.