Auction vs. Direct Sales & NBE Foreign Exchange Inflow

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Auction vs. Direct Sales & NBE Foreign Exchange Inflow within SmartERP.

Manage commercial invoicing for Royal FloraHolland Dutch flower auctions versus direct retailer sales, and settle NBE 50/50 FX retention.

{screenshot:auction-vs-direct-sales-invoicing-and-nbe-fx-overview-dashboard}

2. Prerequisites & Security Access Groups#

• Required Modules: smarterp_commodity_export, smarterp_agri_traceability
• Security Groups:
  • Cold Chain & Packhouse Officer (Technical ID: smarterp_export.group_export_user)
  • Floriculture Quality Inspector (Technical ID: smarterp_export.group_export_qa)
  • Floriculture Export Manager (Technical ID: smarterp_export.group_export_manager)
• Master Data Dependencies: Greenhouse greenhouse blocks, rose stem varieties, cold storage temperature telemetry (2°C–4°C), Ethiopian Airlines Bole Cargo space bookings, and European auction buyers.

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 Floriculture Export app icon.
4. From the top navigation bar, open Floriculture Export → Greenhouse → Harvest / Cold Chain / Packhouse / Air Waybills.

{screenshot:auction-vs-direct-sales-invoicing-and-nbe-fx-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:
   • Greenhouse Harvest Batch (Mandatory): Block origin, stem length (cm), and cut date/time
   • Rose Variety & Head Size (Mandatory): Commercial cultivar (Rhodos, Red Naomi, Athena) and bud profile
   • Pre-Cooling Verification (Mandatory): Confirmed forced-air cooling record achieving 2°C–4°C core temperature
   • Bole Cargo e-AWB Number (Mandatory): Ethiopian Airlines booked air waybill identifier
3. Configure optional operational parameters and localized tags as required:
   • Cold Chain Logger ID (Optional): Digital temperature datalogger serial number placed in pallet
   • Auction Consignment Code (Optional): Royal FloraHolland auction lot reference
   • MoA Phytosanitary Seal Number (Optional): Official government export inspection security tag
4. Click the Save icon in the control bar to commit the record.

{screenshot:auction-vs-direct-sales-invoicing-and-nbe-fx-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Harvested → Pre-Cooled (2°C) → Packhouse Sorted → Cold Truck Transit → Bole Airport Loaded → Cleared).
• Ledger & System Impact: Direct greenhouse labor and packaging costs absorb into crop inventory; e-AWB air freight dispatch recognizes export revenue in foreign currency.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:auction-vs-direct-sales-invoicing-and-nbe-fx-transaction-processing-state}

Dual Commercial Sales Channels#

Ethiopian floriculture enterprises operate across two distinct export channels:

1. Dutch Clock Auction (Royal FloraHolland): Consignments shipped on consignment to Aalsmeer or Naaldwijk; prices determined dynamically by the auction clock. Auction clearing reports settle weekly with commission deductions.
2. Direct Retail Contracts: Fixed-price forward supply contracts with international supermarket chains (e.g., Tesco, Marks & Spencer, Rewe) with guaranteed weekly volumes.

Managing the NBE 50/50 Foreign Currency Retention#

When export proceeds remit from Royal FloraHolland or direct supermarket buyers:

• Conforms to the standard National Bank of Ethiopia export framework:

$$\text{Remitted Foreign Currency ($EUR$)} = 50\% \text{ (Converted to ETB)} + 50\% \text{ (Retained EUR Account)}$$

1. Commercial bank converts 50% into Ethiopian Birr at the daily interbank buying rate.
2. Remaining 50% credits to the farm's Foreign Currency Retention Account in EUR, utilized to import agrochemicals, greenhouse plastic sheeting, and soluble fertilizers.

4. Advanced Configuration Points#

• Automated Actions & Scheduled Tasks (Crons):
  • Cold Chain: Alert temperature breach above 4°C (smarterp_export.ir_cron_temp_monitor): Runs every 15 minutes checking IoT temperature telemetry
  • Air Cargo: Track Bole cargo flight departure (smarterp_export.ir_cron_flight_status): Runs hourly checking Ethiopian Airlines cargo flight tracking
• Custom Print Templates & Reports:
  • Cold Chain Temperature Compliance Certificate
  • MoA Phytosanitary Export Inspection Dossier
  • Bole Cargo Air Waybill (e-AWB) & Pallet Manifest
  • Consignment Net Realization & Auction Settlement Summary
• 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#