Dry Hulling, Industrial Milling & Yield Loss Accounting

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Dry Hulling, Industrial Milling & Yield Loss Accounting within SmartERP.

Manage dry mill hulling operations, screen size separation, gravity density tables, optical color sorting, and byproduct accounting.

{screenshot:dry-hulling-and-mrp-yield-loss-accounting-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#

1. Log into your SmartERP instance at https://smarterp.et/odoo.
2. Open the main App Switcher (grid icon in the top-left corner).
3. Select the Coffee Export app icon.
4. From the top navigation bar, open Coffee Export → Origination → Lots / Grading / Contracts / Shipping Documents.

{screenshot:dry-hulling-and-mrp-yield-loss-accounting-app-switcher-navigation}

Step 2: Creating and Parameterizing Records#

1. Click the New button in the top-left control panel.
2. 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
3. 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
4. Click the Save icon in the control bar to commit the record.

{screenshot:dry-hulling-and-mrp-yield-loss-accounting-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:dry-hulling-and-mrp-yield-loss-accounting-transaction-processing-state}

Dry Milling Industrial Process Flow#

Parchment coffee (or dried cherry pods for natural coffees) must be hulled and polished into export-ready green coffee beans:

1. Pre-Cleaning: Destoners eliminate stones, soil clods, and metal debris.
2. Hulling: Impact hullers crack and strip dried parchment husks.
3. Polishing: Friction polishers remove the thin silverskin layer.
4. Grading by Size: Vibrating screen decks sort beans by screen size (Screen 17/18 Large, Screen 15/16 Medium, Screen 14 Small).
5. Density Separation: Gravity separator tables float low-density defective beans away from dense specialty beans.
6. Bichromatic Optical Sorting: High-speed optical color sorters reject discolored, black, sour, or insect-damaged beans with high-pressure air nozzles.

Calculating Standard Milling Yield Ratios#

SmartERP MRP tracks yield losses across batches:

$$\text{Clean Coffee Yield Ratio} = \frac{\text{Clean Green Coffee Weight (kg)}}{\text{Raw Parchment Weight (kg)}} \times 100\%$$

• Standard Washed Parchment: 78% – 82% clean green coffee yield (18% – 22% husk loss).
• Natural Dried Cherry (Jenfel): 48% – 52% clean green coffee yield (48% – 52% pod husk loss).

If yield drops below standard thresholds (e.g., clean yield $< 75\%$), the system flags an excess loss alert, prompting immediate inspection of huller clearance and screen mesh wear.

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 windows
  • Traceability: 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#