Odoo Functional
Architect Guide.
77+ expert questions covering industry domains, requirement gathering, finance, and enterprise problem-solving.
Industry Roadmap
- 01. Consulting Methodology
- 02. Core Financials & BFO
- 03. Manufacturing & Production
- 04. Retail & Omnichannel
- 05. Supply Chain & WMS
- 06. Projects & Field Service
- 07. Healthcare Traceability
- 08. SaaS & Subscriptions
- 09. Problem Solving Scenarios
- 10. Odoo 19.0 Functional
- 11. Soft Skills & PM
- 12. Localization & E-Invoicing
- 13. HR, Payroll & Workforce
Consulting Methodology & GAP Analysis
Walk me through your 'Discovery Phase' for a new enterprise client.
ANS:I start by identifying key stakeholders. I document the 'As-Is' process, identify pain points, and then map them to Odoo's 'To-Be' process. I focus on high-level workflows first (Sales, Purchase, Accounting) before diving into granular details.
How do you handle a 'GAP' where Odoo standard doesn't meet the requirement?
ANS:I follow the hierarchy: 1. Configuration. 2. Workaround. 3. App Store (OCA). 4. Customization (as a last resort).
What is a 'User Acceptance Test' (UAT) and why is it critical?
ANS:UAT is where actual business users test the system in a staging environment. It ensures the configuration meets business needs and secures 'buy-in' before Go-Live.
How do you manage 'Scope Creep' during implementation?
ANS:By maintaining a strict 'Change Request' process. Any requirement outside the initial SOW is documented, estimated, and approved as a separate phase.
Explain the importance of 'Data Cleaning' before migration.
ANS:Garbage in, garbage out. Cleaning ensures no duplicates, correct formatting, and accurate opening balances, which are vital for a clean start.
Core Financials & Accounting
Explain the difference between 'Anglo-Saxon' and 'Continental' accounting.
ANS:Anglo-Saxon records COGS at the time of the customer invoice. Continental records the expense at the time of product reception. Anglo-Saxon is standard for international firms.
How does Odoo handle 'Inter-Company' transactions?
ANS:By enabling Inter-Company Transactions in settings. Odoo automatically generates corresponding SO/PO and syncs invoices/bills between entities.
Explain 'Bank Reconciliation' in Odoo v19.
ANS:The process of matching bank statement lines with internal Odoo records. Odoo uses Reconciliation Models to automate this with up to 95% accuracy.
What are 'Analytic Accounts' vs 'Analytic Tags'?
ANS:Analytic Accounts are for cost centers. Analytic Tags (integrated as Analytic Plans in v16+) allow for multi-dimensional reporting.
How do you configure 'Multi-Currency' for a global entity?
ANS:Enable multi-currency, define 'Base Currency', and activate 'Automatic Currency Rates'. Odoo handles unrealized/realized gains/losses automatically.
What is 'Deferred Revenue' and 'Deferred Expense'?
ANS:Spreading income or expenses over a period (e.g., insurance). Odoo automates this by creating Deferred Entries across months.
How do you perform 'Year-End Closing' in Odoo?
ANS:Odoo doesn't require a hard 'Closing'. You simply set a 'Lock Date' for non-advisors. P&L resets based on date range, and the Balance Sheet carries forward.
Explain 'Tax Cloud' or 'Avalara' integration.
ANS:Automates US sales tax calculation based on exact zip codes, handling thousands of jurisdictions automatically.
What is 'Asset Management' in Odoo?
ANS:Tracking fixed assets. Odoo calculates depreciation (Linear, Declining) and automatically posts journal entries.
Manufacturing & Production
MO vs WO?
ANS:Manufacturing Order (MO) is the overall document to produce. Work Orders (WO) are specific operations at Work Centers.
Explain 'Work Center Capacity' and 'Efficiency'.
ANS:Capacity is how many units/hours a machine can handle. Efficiency is a percentage used to adjust expected time.
How do you handle 'By-Products' in a BoM?
ANS:Secondary products produced during manufacturing. Odoo defines them and their cost-share in the BoM.
Explain 'Phantom BoM'.
ANS:A BoM for a sub-assembly that isn't stocked. Components are pulled directly into the main MO.
What is 'OEE' and how does Odoo track it?
ANS:Overall Equipment Effectiveness. Availability × Performance × Quality. Odoo compares planned vs actual time on Work Centers.
How do you manage 'Subcontracting'?
ANS:Define BoM as Subcontracting. Odoo generates a PO for the service when an MO is created.
What is 'IoT Box' in manufacturing?
ANS:Hardware device connecting scales, calipers, and cameras to Odoo for automated data capture on the shop floor.
Retail, E-commerce & Omnichannel
26. How do you synchronize Odoo POS with Online Store inventory?
ANS:Odoo uses a 'Real-time' shared database. When a product is sold in POS, the quantity is immediately deducted, reflecting on the E-commerce site to prevent overselling.
27. Explain 'Omnichannel' strategy in Odoo.
ANS:'Buy Online, Pick Up In-Store' (BOPIS). Odoo handles this by creating a Sales Order with a 'In-Store Pickup' delivery method, which triggers a notification to the local store's POS/Inventory.
28. How do you manage 'Pricelists' for different customer segments?
ANS:Define Pricelists based on 'Public', 'VIP', or 'Wholesale'. You can set fixed prices, percentage discounts, or formula-based pricing (e.g., Cost + 20%).
29. What is 'Gift Card' management in Odoo?
ANS:Odoo allows selling physical or digital gift cards. The 'Balance' is tracked in the system, and customers can redeem them in POS or E-commerce.
30. How do you handle 'Returns & Refunds' in Retail?
ANS:In POS, use the 'Return' button to select the previous order. Odoo reverses the stock move and creates a Credit Note/Refund automatically.
Supply Chain, Logistics & WMS
31. What are 'Push' vs 'Pull' Rules?
ANS:Push: Moving goods to a location as soon as they arrive (e.g., Receipt -> Quality Control). Pull: Moving goods only when there is a demand (e.g., Customer Order -> Packing -> Shipping).
32. Explain 'Multi-Step Routes'.
ANS:Instead of a simple 'Receive', you can configure 'Pick -> Pack -> Ship' (3-step) for outgoing and 'Receive -> Input -> Quality' for incoming.
33. What is 'Cross-Docking'?
ANS:Moving goods from the receiving dock directly to the shipping dock without putting them away in storage. Reduces handling time.
34. How do you manage 'Batch Picking'?
ANS:Grouping multiple orders into one 'Batch' so a picker can travel through the warehouse once to pick items for 10 different orders.
35. What is 'Wave Picking'?
ANS:Grouping orders by specific criteria (e.g., Shipping Carrier, Priority, or Product Category) to optimize the fulfillment workflow.
Construction, Projects & Field Service
36. How do you track 'Project Profitability'?
ANS:By linking Sales Orders (Revenue) and Timesheets/Purchase Bills (Costs) to the same 'Analytic Account'. The Project Dashboard then shows the real-time margin.
37. Explain 'Milestone Invoicing'?
ANS:Billing the customer based on project progress (e.g., 20% on start, 50% on completion of Phase 1). Odoo allows manual or task-completion based milestone invoicing.
38. How do you handle 'Materials Consumed' on a Construction site?
ANS:Using 'Internal Transfers' from the Main Warehouse to the Site Location, or by linking the Purchase of materials directly to the Project.
39. What is 'Field Service' module's unique value?
ANS:It provides a mobile-optimized view for technicians, integrated Google Maps for routing, and 'Worksheets' to capture customer signatures and photos on-site.
40. How do you manage 'Resource Allocation' in Projects?
ANS:Using the 'Planning' module to see who is overbooked and dragging/dropping tasks to balance the workload across the team.
Healthcare & Pharmaceutical (Traceability)
41. Why is 'Lot/Serial Number' tracking critical in Pharma?
ANS:For product recalls. If a specific batch of medicine is faulty, Odoo can trace exactly which vendors it came from and which customers received it.
42. How do you handle 'Expiration Dates' (FEFO)?
ANS:First Expiry, First Out. Odoo suggests picking the lot that expires soonest, even if it arrived later than others.
43. What is 'Quality Alert' in Healthcare?
ANS:A notification triggered when a product fails a check. In Pharma, this might automatically 'Lock' the entire lot from being sold or used until cleared.
44. How can Odoo manage 'Appointments' for a Clinic?
ANS:Using the 'Appointments' module where patients can book slots online. This integrates with the 'Calendar' and can trigger an 'Invoice' upon completion.
45. Explain 'Maintenance' for Medical Equipment?
ANS:Scheduling 'Preventive Maintenance' for MRI or X-Ray machines. Odoo tracks the equipment history and creates 'Repair Orders' if a failure occurs.
Professional Services & Subscriptions
46. How do you configure a 'Subscription' product in Odoo v16+?
ANS:Subscriptions are integrated into sale.order. Set product type as Service with a Recurring policy, and define a Recurring Plan (Monthly, Yearly).
47. Explain 'MRR' and 'Churn Rate' in Odoo.
ANS:MRR (Monthly Recurring Revenue) and Churn (rate of cancellations). Odoo provides a dedicated dashboard to track these SaaS KPIs.
48. How do you handle 'Upselling' on Subscriptions?
ANS:By using the 'Upsell' button on a subscription, which allows adding more seats or upgrading the plan, automatically prorating the cost.
49. What is 'Timesheet Validation'?
ANS:A process where managers review and 'Approve' employee timesheets before they can be used for customer invoicing.
50. How do you manage 'Helpdesk' SLAs?
ANS:Service Level Agreements. Define targets (e.g., 'Initial response within 2 hours'). Odoo flags tickets that are in danger of failing the SLA.
Enterprise Problem Solving Scenarios
51. Scenario: A client has 10 companies and wants one consolidated Balance Sheet. How?
ANS:Use 'Consolidation' module. Map the charts of accounts of all companies to a 'Consolidation Chart' and Odoo will generate the combined report.
52. Scenario: Inventory shows stock, but I can't select it on a Delivery. Why?
ANS:The stock might be 'Reserved' for another order, or it is in a 'Non-available' location (like Quality Control or Scrap), or the Lot is expired.
53. Scenario: The client wants to approve every Purchase Order over $5,000.
ANS:Configure 'Purchase Approvals' in settings. Set the threshold. The PO will stay in 'To Approve' state until a manager validates it.
54. Scenario: Customer wants a 5% discount if they pay within 7 days.
ANS:Configure 'Payment Terms' with a 'Cash Discount' (PPD). Odoo will calculate the discount and the tax adjustment automatically.
55. Scenario: A manufacturing client wants to track 'Labor Cost' per item.
ANS:Define an 'Employee Cost' per hour. Link the employee to the 'Work Order'. Odoo multiplies the time spent by the cost to get the total labor value.
Odoo 19.0 Functional Mastery
56. What are 'Smart Server Actions' in v19?
ANS:The ability to use natural language to define business rules or automated actions, making the system more accessible to non-technical managers.
57. How has 'WhatsApp' integration changed business communication?
ANS:It allows sending Invoices, Order Confirmations, and Tracking links directly to the customer's phone, increasing response rates compared to email.
58. Explain the 'Knowledge' module's role in Implementation.
ANS:It acts as an internal Wiki/SOP center. Consultants use it to document client-specific workflows directly within the Odoo database.
59. What is 'AI Bill OCR' and how does it reduce manual entry?
ANS:Odoo uses AI to scan vendor bills (PDF/Image) and automatically fill in the Vendor, Date, Line Items, and Taxes. The user only needs to validate.
60. How does 'Sign' module integrate with HR?
ANS:For 'Onboarding'. Employment contracts can be sent via Odoo Sign, and once signed, they are automatically stored in the employee's document folder.
Consultant's Soft Skills & Project Management
61. How do you handle a 'Difficult Stakeholder' who opposes the Odoo implementation?
ANS:I listen to their concerns to understand if they are based on fear of change or genuine functional gaps. I involve them in the process early, show them 'Quick Wins', and ensure they feel heard during UAT.
62. Describe your process for conducting a 'Training Session' for end-users.
ANS:I use a 'Role-Based' approach. Instead of showing every button, I show them exactly how to complete their specific daily tasks with short, visual SOPs.
63. What is 'Hyper-care' and how do you manage it?
ANS:Hyper-care is the 2-4 week period immediately after Go-Live. I manage it with a dedicated 'War Room' or Slack channel for instant issue resolution.
64. How do you explain 'Double-Entry Bookkeeping' to a non-accountant?
ANS:I explain that every transaction has a source and a destination. Money moves from one place (Bank) to another (Expense). Debits = Credits.
65. How do you prioritize requirements when the client has a limited budget?
ANS:I use the MoSCoW method: Must-have, Should-have, Could-have, Won't-have.
Localization, Fiscal Positions & E-Invoicing
66. What is a 'Fiscal Position' and when do you use it?
ANS:A Fiscal Position automatically maps taxes and accounts based on location (Domestic vs EU vs Export). Assigned manually or auto-detected.
67. How does Odoo handle 'E-Invoicing' for global compliance?
ANS:Supports PEPPOL (EU), Factur-X/ZUGFeRD (FR/DE), SII (Spain), CFDI (Mexico), and E-Way Bill (India). Generates UBL XML or embedded PDF XML.
68. What is a 'Localization Package' in Odoo?
ANS:A country-specific module installing the official Chart of Accounts, Tax rates, Fiscal Positions, and legal report formats.
69. How do you handle 'Tax Groups' vs 'Tax Components'?
ANS:Tax Group is what the customer sees. A Tax can have multiple components (State + Federal). Odoo calculates each but shows the group total.
70. How do you configure 'Cash Rounding' for specific countries?
ANS:Accounting -> Settings -> Cash Rounding. Define precision (0.05) and method (UP/DOWN/HALF-UP). Difference posts to a Rounding account.
HR, Payroll & Workforce Management
71. What is a 'Salary Structure' in Odoo Payroll?
ANS:A template defining how a payslip is calculated using a set of Salary Rules evaluated in sequence (Basic, Allowances, Deductions).
72. How do 'Salary Rules' work?
ANS:Calculation lines with a Category (BASIC, ALW, DED), Condition (Python), and Computation (Fixed/Percentage/Python Code).
Example: "Income Tax (15%)"
Category: DED (Deduction)
Condition: Always True
Computation Type: Percentage
Percentage based on: GROSS (15%)73. What Journal Entries does Payroll create?
ANS:Debit Salary Expense (P&L), Credit Payables (Liabilities: Tax, Social Security, Net Salary).
74. How do you manage 'Employee Contracts'?
ANS:Define Wage, Structure, Schedule, and Dates. Odoo uses the active contract during the payslip date range.
75. How does Odoo handle 'Leave Management' integration?
ANS:Employee requests leave -> Manager approves -> Balance deducted. During payroll, Odoo checks for 'Unpaid Leave' and reduces salary proportionally.
76. How do you handle 'Expense Reimbursement' through Payroll?
ANS:Two ways: Direct (Accounting payment) or via Payslip (Add as an 'Input' to the next payslip calculation).
77. What is 'Batch Payslip Processing'?
ANS:Generates payslips for all employees in a department/company at once via Payroll -> Payslips -> Batches.
Consultant Mastery Checklist
- ✓ Master Accounting Flows (BFO)
- ✓ Know Global E-Invoicing (PEPPOL)
- ✓ Standard-First Implementation Mindset
- ✓ Expert in GAP Analysis & UAT
- ✓ Salary Structure & Rule Logic
- ✓ P2P, O2C, and Inventory FEFO
Streamline Your Business
Workflows in Odoo
Whether you need to align multi-company accounting, structure complex manufacturing routing, or automate multi-warehouse logistics, we map your processes to Odoo standard first.