Demo GreenHarvest Cooperative: farm-to-market day

Demo GreenHarvest Cooperative aggregates dates, vegetables, and grains from 1,200 growers, operates two cold stores, and sells to wholesalers and retailers in AED and USD. It pays growers through a seasonal advance and final settlement, grades produce on receipt, tracks lots and expiry, and must explain yield, shrinkage, storage, transport, and margin by crop and grower group.

1. Register growers, seasons, and collection centres

Create legal company GHC, collection centres ALN-C01 and ALN-C02, cold stores COLD-A and COLD-B, and seasons 2026-DATES, 2026-VEG, and 2026-GRAIN. A grower master records legal identity, bank account, farm location, crop, certification, tax status, cooperative share, and payment method.

Field	Demo entry	Impact
Grower ID	GROW-004281	Settlement and traceability key
Crop	Medjool dates	Grade, yield, and price schedule
Season	2026-DATES	Advance and harvest boundary
Collection centre	ALN-C01	Weighing and logistics ownership
Grade	A, 85% packout	Price and customer eligibility
Lot	DT260901-041	Recall and expiry traceability
Advance rate	AED 2.00/kg	Grower receivable or advance liability
Storage rate	AED 0.18/kg/day	Cold-store recovery and margin
Sales currency	AED, USD	Pricing and FX control
Certification	GlobalG.A.P.	Customer and compliance filter

The season master stores start/end, expected yield, advance rules, quality standards, price table, and close date. A new season version preserves historical price and settlement calculations.

2. Pay a seasonal advance

The cooperative approves an advance of AED 80,000 against an estimated 40,000 kg harvest. The advance request records grower, season, crop, estimate, rate, amount, bank, approval, and recovery plan. Posting debits grower advance receivable and credits bank. An advance is not crop cost or expense until produce is delivered and accepted.

When the grower delivers 32,000 kg, the settlement engine recovers AED 64,000 and carries AED 16,000 forward or requests repayment according to policy. Every recovery line links to weighbridge ticket and accepted lot.

3. Receive, grade, and create a lot

At collection, create a receipt with grower, vehicle, field, crop, season, weighbridge gross/tare/net, arrival date, moisture, temperature, pesticide certificate, and inspector. The first weighment is 33,200 kg gross and 1,200 kg tare, giving 32,000 kg net.

Quality splits the receipt into Grade A 27,200 kg, Grade B 3,800 kg, and rejected 1,000 kg. Each lot records grade, lot number, production date, expiry or best-before, packaging, bin, and quality status. Rejected product is returned, composted, or sold as by-product through a reason-coded movement.

Inventory posting debits produce inventory by grade and credits grower payable or receipt accrual. The weighted cost includes approved harvest price, collection labour, packaging, and allocated transport. A quality downgrade changes grade and value through an approved adjustment, not a silent edit.

4. Cold-store operations and shrinkage

The warehouse transfer moves 27,200 kg Grade A to COLD-A, bin A-03-07. The movement records lot, quantity, temperature zone, operator, and storage date. Daily checks capture temperature, humidity, door event, and exception owner. A 2% expected shrinkage rule is configured for dates; actual shrinkage beyond tolerance requires investigation.

After 20 days, a stock count finds 26,450 kg. The 750 kg difference is 2.76%, above tolerance. Create a count document with book quantity, counted quantity, variance, lot, reason, witness, and approval. The adjustment debits shrinkage expense and credits inventory only after approval. The dashboard shows shrinkage by store, crop, grade, and grower group.

5. Sell to a wholesaler

Al Safa Wholesale orders 12,000 kg Grade A at AED 8.50/kg in AED, delivered in three lots, with 30-day terms. The sales order header includes customer, currency, warehouse, ship-to, price list, delivery dates, contract, tax, and credit status. Detail includes crop, grade, lot policy, quantity, rate, discount, and minimum remaining shelf life.

FEFO proposes the earliest valid lots. The delivery records lot, packed quantity, pallet count, seal, vehicle, driver, and proof of receipt. Packing loss of 40 kg is recorded as an approved variance. The invoice shows product, packaging, transport, tax, and dimensions. Posting debits receivable and credits produce revenue and tax; COGS uses the actual lot cost.

6. Export and multi-currency settlement

A US customer buys 8,000 kg at USD 2.35/kg. The export order stores incoterm, port, customs reference, certificate, currency, rate, and tax treatment. The invoice is USD 18,800. At payment, import bank reference, value date, currency, and amount; post realised FX difference separately from crop margin. Month-end revaluation handles the open USD receivable.

The export pack links phytosanitary certificate, lot list, packing list, bill of lading, and inspection. A missing certificate blocks dispatch. A partial export return references the original lot and reason, preserving traceability.

7. Grower final settlement

At season close, the settlement statement groups accepted kg, grade, price, deductions, advance recovery, storage, transport, cooperative fee, rejected quantity, and net payable. For 27,200 kg Grade A at AED 7.20/kg, gross is AED 195,840. Deduct AED 54,400 advance, AED 97,920 storage/handling and other approved charges, leaving AED 43,520 payable before any tax withholding.

The grower approves the statement or raises a dispute. A dispute records line, evidence, owner, and resolution. Payment batches require bank validation, dual approval, and remittance advice. A correction creates an adjustment statement rather than rewriting history.

8. By-products, grants, and close

Rejected dates sold for animal feed create by-product revenue and a reduced waste cost. A sustainability grant reimburses 30% of certified cold-storage energy. The grant record stores award, eligible cost, ceiling, reporting date, and evidence. Claims exclude non-eligible electricity or private-use equipment.

Month end reconciles grower advances, accepted produce, quality adjustments, cold-store stock, shrinkage, sales, export documents, customer receipts, grants, tax, FX, and COGS. Close gates ensure no lot is both sold and on hand, no unpaid grower statement lacks approval, and expired stock is quarantined.

KPI	Baseline	After OSERP discipline	Improvement
Grower settlement cycle	21 days	5 days	76% faster
Lot trace retrieval	6 hours	14 minutes	96% faster
Unexplained shrinkage	5.8%	2.1%	64% lower
Grade disputes	9.4%	3.2%	66% lower
Cold-store stock accuracy	89%	98.7%	+9.7 points
Export document exceptions	18 / month	3	83% lower

Practice challenge

Register a grower and season, pay an advance, receive a weighed harvest, split it into grades, store lots, record a count variance, sell FEFO stock domestically and in USD, settle the grower, and submit a grant claim. Explain every field, status, quality decision, inventory movement, journal, FX result, approval, and audit drill-down.

Related: Inventory, Multi-currency settlement, Procure to pay, Advanced GL Mapping, and API library.