I’ve been dealing with a similar situation while managing sales and POS reports, especially when real-time updates don’t align with actual transactions. What really helps is keeping your configuration simple and ensuring each location syncs properly under one dashboard. Once everything is streamlined, the reports reflect more accurately and make tracking performance much easier.

Hi,

Odoo's Sales reports are generally designed to include sales data from the Point of Sale (POS) system, as the POS app integrates with other Odoo modules like Sales and Inventory. To view combined Sales and POS data, you can utilize Odoo's dashboard features, which allow for the creation of customized reports and data visualization through user-friendly pivot views with real-time updates. Additionally, the Point of Sale module offers its own reporting section where you can access statistics on orders in graph or pivot views, which can be filtered and grouped as needed.

To address concerns about dashboards not being dynamic, Odoo's business intelligence tools are built to provide real-time data updates. The Odoo Spreadsheet app, in particular, allows for the creation of dynamic reports by automatically incorporating data from your database into charts and spreadsheets, eliminating the need for constant manual updates. By leveraging Odoo's built-in reporting features, you should be able to group sales data by various categories and create combined reports or dashboards that pull data from both the Sales and POS modules without needing to install third-party apps.

Hope it helps