Hi,

To get sales reports in kilograms or by brand in Odoo, start by ensuring each product has the correct unit of measure (kilograms) set in its product form. Then, navigate to Sales > Reporting > Sales, switch to the Pivot view, and use the "+" button to add custom groups. Select "Unit of Measure" to group sales by kilograms.

To group by brand, either add another custom group for "Brand" (if you have a custom field for it) or use "Product Category" if you categorize products by brand. If "Brand" isn't available, create a custom field using Odoo Studio or developer mode. Alternatively, use product categories to represent brands by creating categories for each brand and assigning them to products. This setup allows you to analyze sales data effectively by kilograms and brand in your sales reports.

Hope it helps

in sales report pivot view click on + button select add custom group -> select unit of measure

To generate sales reports in kilograms in Odoo, you can leverage the product weight and adjust your reporting setup. Here’s how you can do it:

Make sure each product in your inventory has a weight specified in kilograms. This can be set under the "Sales" tab in the product form. If you haven’t done so already, you can go ahead and enter the weight for each product.

Custom Reporting: Once your products have weight in kilograms, you can create a custom report that aggregates the total sales in kilograms. You can do this by using Odoo’s built-in reporting features or by customizing an existing sales report to include the total weight sold.

Group by Brand: To get reports per brand (or any other grouping), you can filter your reports by product category or brand, and then can sum up the weight based on the quantity that sold and the product weight.

Odoo Studio can help you adjust or create custom reports if needed. This way, you can easily track and generate reports on kilograms sold, either for individual products, brands, or categories.