Coffee Origination & Export Suite Overview
Architectural and operational overview of SmartERP Coffee Export Suite engineered for Ethiopian coffee exporters, washing stations, and dry mills.
1. Overview & Business Value#
This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Coffee Origination & Export Suite Overview within SmartERP.
Architectural and operational overview of SmartERP Coffee Export Suite engineered for Ethiopian coffee exporters, washing stations, and dry mills.
{screenshot:overview-overview-dashboard}
2. Prerequisites & Security Access Groups#
- Required Modules:
smarterp_commodity_export, smarterp_agri_traceability - Security Groups:
Export Logistics Officer(Technical ID:smarterp_export.group_export_user)Coffee Quality Lab Grader (Q-Grader)(Technical ID:smarterp_export.group_export_qa)Export Commercial Director(Technical ID:smarterp_export.group_export_manager)
- Master Data Dependencies: Coffee origination zones (Yirgacheffe, Sidama, Guji, Jimma, Harar), ECX contracts, washing stations, export container lots, and NBE 50/50 FX retention accounts.
3. Step-by-Step Configuration & Execution#
Step 1: Navigating to the Module Interface#
- Log into your SmartERP instance at
https://smarterp.et/odoo. - Open the main App Switcher (grid icon in the top-left corner).
- Select the Coffee Export app icon.
- From the top navigation bar, open Coffee Export → Origination → Lots / Grading / Contracts / Shipping Documents.
{screenshot:overview-app-switcher-navigation}
Step 2: Creating and Parameterizing Records#
- Click the New button in the top-left control panel.
- Complete the mandatory fields in the record form:
- Export Contract Reference (Mandatory): Registered international sales contract number approved by ECTA
- Origin & Washing Station (Mandatory): Traceable regional washing or hulling station
- Grade & Screen Size (Mandatory): Specialty Grade 1/2 or Commercial Grade classification with moisture %
- Contract Quantity (Metric Tons) (Mandatory): Volume in standard 60 kg export jute bags
- Configure optional operational parameters and localized tags as required:
- Cupping Score & Sensory Profile (Optional): Certified Q-grader sensory score (acidity, body, floral notes)
- Port of Loading & Discharge (Optional): Inland dry port (Modjo) to discharge port (Djibouti/Rotterdam)
- NBE FX Retention Account (Optional): Designated commercial bank foreign exchange account
- Click the Save icon in the control bar to commit the record.
{screenshot:overview-record-creation-form}
Step 3: Validating and Processing Transactions#
- State Transitions: Execute operational state progression (Origination Batch → Cupping & Grading → Contract Confirmed → Processing / Bagging → Customs Cleared → Shipped).
- Ledger & System Impact: Shipment confirmation recognizes export revenue in foreign currency (USD/EUR), debits export receivables, and computes statutory 50/50 NBE foreign exchange retention entries.
- Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.
{screenshot:overview-transaction-processing-state}
Ethiopian Coffee Export Architecture#
SmartERP Coffee Export Suite (smarterp_coffee_export) manages the end-to-end commercial coffee lifecycle in Ethiopia, from primary red cherry intake in highland washing stations (Yirgacheffe, Sidama, Guji, Limu, Harrar, Kaffa) through industrial hulling, ECX cupping grading, export sales contracts, and foreign exchange repatriation.
The complete origination, processing, and export lifecycle:
[coffee-origination-ecx-cupping-flow]
Statutory Regulatory Anchors in Ethiopia#
The coffee platform operates strictly under Ethiopian statutory mandates:
- Ethiopian Coffee and Tea Authority (ECTA): Commercial export licensing, minimum export registration price differentials, and farm-to-cup origin traceability certificates.
- Ethiopian Commodity Exchange (ECX): Centralized cupping scoring, moisture content thresholds, defect classification (Grade 1 through Undergrade), and electronic Warehouse Receipts (e-WHR).
- National Bank of Ethiopia (NBE) FX Retention Directives: Automated compliance with NBE foreign currency surrender and retention rules (50% sold to commercial banks at prevailing rate, 50% credited to exporter foreign currency retention accounts).
- Export Shipping Logistics: Container stuffing in GrainPro hermetic liners, customs export seal inspection, and bonded multimodal transit from Mojo Dry Port to the Port of Djibouti.
4. Advanced Configuration Points#
- Automated Actions & Scheduled Tasks (Crons):
Export: Track NBE 50/50 FX retention account expiration(smarterp_export.ir_cron_fx_retention): Runs weekly to monitor statutory 30-day conversion windowsTraceability: Monitor container transit milestones(smarterp_export.ir_cron_container_tracking): Runs daily to update Modjo dry port to Djibouti customs handoffs
- Custom Print Templates & Reports:
- ECTA Coffee Quality & Traceability Inspection Dossier
- Export Commercial Invoice, Packing List & Certificate of Origin
- Bole Cargo / Modjo Dry Port Multimodal Shipping Manifest
- NBE Foreign Exchange Retention & Commercial Bank Allocation Slip
- Multi-Company Rules: Record-level security isolation under Company 1 (
Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.
5. Comprehensive Troubleshooting Matrix#
| Error Symptom / Exception | Probable Root Cause | Corrective Action / Resolution |
|---|---|---|
FX Retention Block: 50% ETB conversion window expired | Foreign proceeds not converted to local currency within mandatory 30-day window per NBE directives. | Contact commercial bank international banking department to process statutory conversion. |
Quality Grade Rejection: Moisture content exceeds 12.0% | Export sample failed ECTA moisture tolerance threshold. | Return lot to processing facility for further mechanical or sun drying prior to re-sampling. |
Customs Clearance Missing: Phytosanitary certificate not attached | Mandatory Ministry of Agriculture clearance document missing from shipment file. | Complete inspection sampling and attach approved certificate before filing Modjo customs manifest. |