SmartERP Documentation An Ashewa Technology Solutions Platform

Auction vs. Direct Sales & NBE Foreign Exchange Inflow

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

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.

Floriculture cold-chain logistics from greenhouse harvest to pre-cooling, phytosanitary clearance, and air cargo dispatch.
Floriculture post-harvest handling, cold-chain temperature control, and air cargo export.

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

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 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. Navigate to Floriculture → Cold Chain → Shipments.

Step 2: Operational Data Parameters & Controls#

Ensure all mandatory parameters comply with enterprise operational standards:

  • Authorized Operator: Action executed under assigned RBAC permissions (Farm General Manager, Packhouse Supervisor, Export Freight Agent).
  • Relational Integrity: Linked to upstream master records, approval requests, or transactional ledgers.
  • Statutory & Quality Controls: Verified against Ethiopian statutory regulations and corporate governance standards.

Step 3: Operational Execution & State Progression#

  • State Progression Gate: Advance record from Draft through Audited to Confirmed / Certified.
  • Integrated System Impact: Automatically updates real-time operational states and posts financial/inventory journal moves.
  • Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.

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#

Error Symptom / ExceptionProbable Root CauseCorrective Action / Resolution
Cold Chain Alert: Pallet temperature exceeds 4.0°CPre-cooling incomplete or refrigerated truck cooling unit failure.Return consignment to forced-air blast cooling chamber before authorizing truck departure.
Air Cargo Booking Cancellation: Flight payload limitEthiopian Airlines cargo space bumped due to aircraft weight restrictions.Reschedule consignment to next scheduled cargo flight and maintain continuous cold room storage.
Phytosanitary Quarantine BlockInspection detected regulated pest (thrips, false codling moth).Quarantine affected pallet and perform authorized fumigation treatment under MoA supervision.
Last updated: 2026-11-15