Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Field Service
  3. FSM Reports v 19.0
  4. Sales Conditions FAQ

FSM Reports

by Ganemo https://www.ganemo.co
Odoo

$ 355.99

v 19.0 Third Party
This module requires Odoo Enterprise Edition.
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Field Service (industry_fsm)
• Project (project)
• Discuss (mail)
• Timesheets (timesheet_grid)
• Employees (hr)
• Sales (sale_management)
• Invoicing (account)
Community Apps Dependencies Show
• Auto Cancel FSM Task
• FSM Sale Lost Reason
• Sale Lost Reason
Lines of code 793
Technical Name fsm_reports
LicenseOPL-1
Websitehttps://www.ganemo.co
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Field Service (industry_fsm)
• Project (project)
• Discuss (mail)
• Timesheets (timesheet_grid)
• Employees (hr)
• Sales (sale_management)
• Invoicing (account)
Community Apps Dependencies Show
• Auto Cancel FSM Task
• FSM Sale Lost Reason
• Sale Lost Reason
Lines of code 793
Technical Name fsm_reports
LicenseOPL-1
Websitehttps://www.ganemo.co
  • Description
  • License

Technical Specification for AI & LLM

This Odoo module 'fsm_reports' implements a SQL-based read-only report model 'report.fsm.task.visit' that joins project.task with sale.order. It provides three analytical reports under Field Service → Reporting: Efectividad de Visitas, Conversión → Venta, and Análisis de Ventas. Row-level security: FSM Users see only their own task rows; FSM Managers see all. Compatible with Odoo 19 Enterprise, Odoo.SH, Ganemo Online.

Enterprise (Odoo.SH, Ganemo Online or Ganemo.SH)
English & Spanish Included

FSM Reports

Field Service Analytics & Intelligence

Know exactly how many visits were executed, how many became sales, and how much revenue your field team generated — broken down by salesperson, customer, and month.

What We're Solving

----------------

No Visit Tracking

Without this module, there is no native way to aggregate executed vs. not-executed visits per salesperson in a pivot or graph. Supervisors have to manually count through task lists.

Visit-to-Sale Gap

Managers couldn't quickly see which executed visits generated a confirmed sale and which didn't — or understand why using the captured lost reasons.

No Privacy by Default

FSM users could potentially see data from other salespeople. This module enforces row-level visibility: users see only their own assigned tasks; managers see everything.

Revenue from Field

Directors had no dedicated report to see total sales revenue generated by field visits, broken down by customer, salesperson, and month in a single pivot table.

Setup & User Manual

Step-by-Step implementation

1. Installation

Install this module alongside its dependencies:

  • industry_fsm — Native Field Service
  • industry_fsm_sale — FSM + Sales integration
  • auto_cancel_fsm_task — Adds the not_executed flag
  • fsm_sale_lost_reason — Adds the lost_reason_id field

2. Accessing the Reports

Navigate to Field Service → Reporting and find three new sub-menus:

Efectividad de Visitas

Pivot by salesperson × month. Measures: Executed, Not Executed. Bar chart stacked view.

Conversión → Venta

Of executed visits, how many generated a confirmed SO. Includes lost reason analysis.

Análisis de Ventas

Revenue amounts by customer × salesperson × month. Manager access only.

3. Row-Level Security

FSM User (group_fsm_user):

  • Sees only rows where they are the assigned salesperson
  • Access to: Efectividad and Conversión reports

FSM Manager (group_fsm_manager):

  • Sees all rows across all salespersons
  • Access to: all 3 reports including Análisis de Ventas

Global Ready | Multi-Language Support

This module is fully translated into English and Spanish (en_US, es_ES, es_PE, es_MX).

English Spanish

Why Choose Ganemo?

----------------

Ganemo is the world's leading Odoo App developer and a multi-award-winning Gold Partner. For over 5 years, we have been recognized as the #1 seller of high-quality apps on the Odoo App Store. Trusted as the "Best Partner" in USA, Mexico, Chile, Spain, Colombia, Ecuador, and Peru, we deliver robust, secure, and localization-compliant solutions.

QA / User Testing Scenarios

Enterprise Validation Plan

Scenario 1: Row-Level Security (User)

  1. Log in as an FSM User (group_fsm_user) assigned to Task A.
  2. Go to Field Service → Reporting → Efectividad de Visitas.
  3. Expected: Only rows where the user is the salesperson are visible.
  4. Log in as a second FSM User assigned to different tasks.
  5. Expected: Each user sees only their own data — no cross-contamination.

Scenario 2: Manager Full Access

  1. Log in as an FSM Manager (group_fsm_manager).
  2. Go to Field Service → Reporting → Análisis de Ventas.
  3. Expected: All rows from all salespersons are visible.
  4. Apply group-by: Salesperson. Expected: All agents appear in the pivot.

Scenario 3: Visit Conversion Accuracy

  1. Create an FSM Task assigned to User A. Mark it as executed (not not_executed).
  2. Create and confirm a Sale Order linked to that task.
  3. Go to Conversión → Venta. Filter by User A.
  4. Expected: Row shows has_sale = True and correct sale_amount_total.
  5. Create another executed task without a SO — Expected: Row shows has_sale = False.

Scenario 4: Lost Reason Grouping

  1. Create executed FSM Tasks without SO, fill the lost_reason_id field.
  2. Go to Conversión → Venta.
  3. Apply filter "Sin Venta" and group-by "Motivo No Venta".
  4. Expected: Rows correctly grouped by lost reason with correct counts.

FAQ & Troubleshooting

Common Resolutions

Report shows no data?

Reason: The report filters FSM tasks only (is_fsm = True, active = True, no subtasks).

Fix: Ensure the project has FSM mode enabled and tasks are assigned to users.

I can't see the "Análisis de Ventas" menu?

Reason: This report is restricted to FSM Managers only.

Fix: Ask an administrator to assign you to the group_fsm_manager group.

Task shows duplicate rows in pivot?

Reason: A task with multiple assigned users generates one row per user — by design.

This is intentional for the record rule to work. Group by Task to de-duplicate.

Sale amounts look too large?

Reason: If a task has multiple users and multiple SOs, amounts multiply per user row.

Fix: Always group by Task + Salesperson when analyzing amounts per visit.

Get a Quote & Resolve Commercial Doubts

Join thousands of satisfied clients on Odoo. Contact our sales team directly.

QR WhatsApp

Official WhatsApp

Fastest response time.

COPY
LINK
https://wa.me/18286726150

+1 (828) 672-6150

QR Sales Email

Sales Email

For commercial inquiries.

COPY
ADDR
leads@ganemo.com

leads@ganemo.com

QR Book Demo

Book a Demo

Let's explore your needs.

COPY
LINK
ganemo.co/appointment/5

Schedule Meeting

Need More? We Do It All

Professional Odoo Services

ERP Implementation

Full Odoo implementation including FSM, Sales, Inventory, and Accounting. We analyze, configure, and train your team.

Module Dev & Migration

Custom modules, report tailoring, and migration to Odoo 19 with zero data loss. Expert Odoo developers at your service.

Commercial & Sales

For inquiries about licenses, demos, or partnerships.

QR WhatsApp
Official WhatsApp

+1 (828) 672-6150

QR Sales Email
Sales Email

leads@ganemo.com

QR Book Demo
Book a Demo

ganemo.co/appointment/5

Technical Support

Existing customers regarding module functionality.

QR Technical Support
Help Desk

Exclusive channel for technical assistance and bug reports.

help@ganemo.com
Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with