Odoo ERP Implementation for
Mattison Stone & Tile
Client Background:
Mattison Stone & Tile, based in Trinidad & Tobago, is a well-established supplier of premium tiles and natural stones. Since 1999, they have been serving architects, designers, contractors, and homeowners across the Caribbean. Their product range includes porcelain, ceramic tiles, marble, granite, and limestone, sourced from top European manufacturers. Mattison offers end-to-end support-from product consultation and material selection to installation guidance-serving a wide range of residential and commercial projects across the region.
Problem Statement:
Mattison faced several operational challenges:
Inefficient manual processes for managing invoices, inventory transfers, and product details.
Limited visibility into inventory turnover, stock movement, and sales performance.
Complex sales commission structures that were difficult to track and distribute accurately.
Cumbersome product management, especially with variations in brand, size, style, and color.
Difficulty in handling UOM (Unit of Measure) conversions and accurate reporting for sales, delivery, and billing.
Lack of dynamic, customizable templates for business documents.
Implementation
Setu Consulting, specialists in Odoo ERP and digital transformation, worked closely with Mattison Stone & Tile to address their operational challenges. The team started with detailed requirements gathering and process mapping to tailor the solution to Mattison’s needs. Setu Consulting then implemented Odoo in phases, ensuring minimal disruption and smooth user adoption
Operation Implemented:
Journal Entry Sequence for Invoice
- Custom invoice sequence setup with ability to reset from journal
- Added user groups for secure sequence field visibility
Inter Warehouse Transfer (ICT)
- Enabled internal warehouse-to-warehouse transfer
- Handled UoM changes effectively in internal transfers
Sale Order Lot Selection
- Lot selection at sale order level, reflected automatically in delivery
- Hidden lot fields in stock quant to avoid clutter
Sales Commission Automation
Configurable sales commission at partner, product, and category levels
Automated commission lines at sale, invoice, or payment
Multi-level commission distribution with agent linkage
Product creation wizard to assign brand, size, style, and color attributes
Enhanced SO line display for easy identification
Custom-designed dynamic templates for delivery, invoice, purchase, and quotation
Company-level template management
Cheque number and image capture during payment
Automated sales margin calculation and reporting in sales & invoice analysis
UoM Conversion Enhancements
Complete integration of UoM conversion in RFQ, Quotation, Delivery, Invoice
Accurate tracking of delivered/invoiced/received/billed quantities
Landed cost valuation updates post UoM conversion
Advanced pricing rules with package-level ordering
Return Management
Lot-wise return handling with return slip
Return valuation traceability
Advanced Reporting
Inventory Tax Reporting based on config
FSN, XYZ, FSN-XYZ Combined Reports
Inventory Turnover, Age, Out-of-Stock & Overstock Reports
Inventory Stock Movement and Age Breakdown Reports
