One Odoo ERP and 8 SQL Reports for a Cleaning-Chemicals Firm

Indep Consulting runs a demanding mix of businesses: daily and professional cleaning chemicals, cleaning equipment and machines, and ongoing maintenance contracts with service-quality commitments. Each line generated its own data, and management visibility suffered for it.

• Sales, stock, and accounting information sat in disconnected tools, making questions like product margin or vendor spend slow to answer.
• Customer-specific pricing and intercompany goods movements were handled manually, inviting errors.
• Maintenance contracts and customer claims had no systematic tracking tied to the commercial records.
• Trading partners expected EDI, which the existing setup could not provide.

iVentureTeam implemented Odoo as the company's single operating system, configured the commercial specifics, and then went a layer deeper — writing SQL-based reports tuned to the exact questions management asks.

Core ERP and eCommerce implementation

• Rolled out Sales, CRM, Inventory, Stock, and Accounting as the operational core.
• Designed the website theme and customized the Odoo eCommerce experience for the product catalog.
• Set up claim management so complaints and service issues attach to the relevant orders and contracts.

Commercial rules built for a chemicals distributor

• Configured custom pricelists reflecting the company's segment- and customer-specific pricing.
• Implemented intercompany transfer rules so stock moving between entities posts correctly without rekeying.
• Enabled EDI for structured document exchange with trading partners.

Eight SQL-powered management reports

• Built invoice, order, and sales-activity reports directly on SQL queries for speed and precision.
• Delivered product margin, vendor summary, stock, and stock rotation reports to expose profitability and slow movers.
• Added a contract report giving management a live view of maintenance commitments.

Indep Consulting now steers its chemicals, equipment, and contract businesses from one Odoo system — and its managers read the business from reports built on their own definitions, not generic dashboards.

• Margins, stock rotation, and vendor performance are visible on demand through the 8 custom SQL reports.
• Pricing and intercompany transfers follow configured rules instead of manual judgment.
• Claims and maintenance contracts are tracked against the same records as sales and invoicing.
• The webshop, warehouse, and accounting reconcile automatically in a single database.