| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) • Sales (sale_management) |
| Lines of code | 958 |
| Technical Name |
cement_email_invoicing |
| License | LGPL-3 |
| Website | https://hozifa.odoo.com/ |
🏗️ Cement Email Invoicing
📋 Overview
The Cement Email Invoicing module monitors a specific email inbox and automatically creates draft invoices from Sale Orders when an Excel file is received. Originally designed for cement distribution businesses, it works for any industry that receives Excel-based delivery confirmations via email.
✨ Key Features
📧 Email Monitoring
Automatically monitors your Gmail inbox via IMAP for incoming Excel files from specific senders.
📊 Excel Processing
Reads Excel files (.xls, .xlsx) with Sale Order references, quantities, and invoice dates.
🧾 Auto Invoice Creation
Creates draft invoices for each Sale Order row in the Excel file automatically.
🔔 Smart Notifications
Sends email notifications for successful processing and errors to keep you informed.
📝 Full Audit Trail
Complete processing logs showing every invoice created, error encountered, and email processed.
🔒 Security Filtering
Only processes emails from configured trusted senders for security.
📤 Manual Upload
Built-in wizard to manually upload Excel files for testing or one-off processing.
⏰ Scheduled Processing
Configurable scheduled action to automatically check emails at your preferred interval.
📁 Excel File Format
The Excel file must have the following columns in the first row:
| Column | Description | Example |
|---|---|---|
Sale Order |
Odoo Sale Order reference number | S00030 |
Quantity |
Delivered quantity to invoice | 22 |
Invoice Date |
Date for the invoice | 2025-11-04 |
⚙️ Configuration
After installation, go to Invoicing → Email Invoicing → Settings and configure:
- Enter your email address and IMAP server details
- Add your Gmail App Password (from Google Account settings)
- Set the allowed sender email address
- Configure notification preferences
- Enable the scheduled action
🔧 Technical Requirements
| Component | Requirement |
|---|---|
| Odoo Version | 18.0 |
| Python Libraries | openpyxl, imaplib (standard library) |
| Odoo Dependencies | sale_management, account, mail |
| Gmail with IMAP and App Passwords enabled |
🚀 How It Works
- Cement company sends an Excel file to your configured email
- Module checks the inbox via IMAP every hour (configurable)
- Excel file is parsed and validated
- For each row, the corresponding Sale Order is found in Odoo
- A draft invoice is created with the specified quantity and date
- You receive a notification email with the results
- Review and confirm invoices in Odoo
📞 Support
For questions, customization requests, or bug reports, please contact us via our website. We provide professional support and can customize this module for your specific needs.
Please log in to comment on this module