Skip to Content
Menu
This question has been flagged
1 Reply
138 Views

Hello Odooers, anyone know how to configure so that i can see the profit on my daily sales report i look in settings or filter but it doesn't show the button or filter to show the profit of my sale thankyou  in advance for the answer, Have A Good Day!!

Avatar
Discard
Best Answer

1. Use the Sales Reporting Menu

  • Go to Sales > Reporting > Sales
  • Apply filters to show Today’s data or a custom daily range
  • In the Pivot View, use:
    • Total Revenue (Sales)
    • Total Cost
    • Add a custom field for Profit = Sales - Cost

2. Enable Cost and Margin Fields (Developer Mode)

  • Go to Sales > Orders
  • Activate Developer Mode (Settings > Activate Developer Mode)
  • Open a sales order and check for Cost and Margin fields
  • If not visible, you may need to customize the report view

3. Use Studio or Custom Report

  • If you're using Odoo Studio:
    • Customize the Sales Report view to add profit/margin field
  • Alternatively, create a custom report or use Spreadsheet Reporting to calculate:
    • Profit = Sales Price - Cost Price

4. Install or Use the Margin Module (if available)

  • In some Odoo versions, the ‘Margins’ module is separate
  • Go to Apps and search for ‘Margin’ or ‘Sale Margin’
  • Install it to enable margin calculation in orders and reports

If you need to automate this into a PDF or scheduled report, it will require either Odoo Studio or a custom report template.

Avatar
Discard