Implement DynamicsExporter: Field Mapping and Schema
epic-accounting-system-export-engine-task-005 — Implement the DynamicsExporter class that implements the AccountingExporter interface for HLF. Map approved claim fields to the Dynamics portal record schema, including all required portal fields (transaction reference, cost type code, GL account, department). Validate required Dynamics fields and raise structured validation errors for missing values. Covers the mapping and validation layer only.
Acceptance Criteria
Technical Requirements
Execution Context
Tier 1 - 540 tasks
Can start after Tier 0 completes
Implementation Notes
HLF is coordinating this app with an existing Dynamics portal project — the `DynamicsMappedRecord` field names MUST match the Dynamics portal's import JSON schema exactly. Obtain the schema definition from HLF before implementing. Like `XledgerExporter`, never use `double` for amounts — use `Decimal` or integer øre. The `transaction_reference` generation should use `sha256(claimId + orgId)` truncated to 20 characters and uppercased — this makes it deterministic, unique per org+claim, and free of PII.
Store the `DynamicsSchemaMapper` config in a versioned assets JSON file under `assets/accounting/dynamics_schema.json` — same pattern as the Xledger chart of accounts mapper. Both HLF-specific validation rules (travel distance, automatic approval threshold) should be isolated in `DynamicsExporter` and NOT leak into the shared `AccountingExporter` interface. Consider extracting a `HlfExpenseRuleValidator` helper class to keep the exporter's `export()` method readable.
Testing Requirements
Unit tests using `flutter_test`. Required scenarios: (1) happy path — 4 standard claims map to correct `DynamicsMappedRecord` values; (2) travel claim with distance_km maps `travel_distance` field correctly; (3) travel claim missing distance_km produces `ValidationError` for `distance_km` field; (4) claim with unmapped category produces `ValidationError` with category name; (5) batch with mixed valid/invalid claims collects all failures; (6) `transaction_reference` is deterministic — same claim ID always produces same reference; (7) transaction_reference does not contain personal data (assert it equals a hash, not a name string). Use a stub `DynamicsSchemaMapper`. Minimum 10 unit tests.
The Xledger CSV/JSON import specification may not be available in full detail at implementation time. If the field format, column ordering, encoding requirements, or required fields differ from assumptions, the generated file will be rejected by Xledger on first production use.
Mitigation & Contingency
Mitigation: Obtain the official Xledger import specification document from Blindeforbundet before starting XledgerExporter implementation. Build a dedicated acceptance test that validates a sample export file against all documented constraints.
Contingency: If the spec arrives late, implement a configurable column-mapping layer so that field order and names can be adjusted via configuration without code changes. Ship a file-based export that coordinators can manually verify before connecting to Xledger import.
The atomic claim-marking transaction in Double-Export Guard could fail under high concurrency if two coordinators trigger an export for overlapping date ranges simultaneously, potentially allowing duplicate exports to proceed past the guard.
Mitigation & Contingency
Mitigation: Use a database-level advisory lock or a SELECT FOR UPDATE on the relevant claim rows within the export transaction to serialize concurrent exports per organization. Add an integration test that simulates concurrent export triggers.
Contingency: If locking proves problematic at the database level, implement an application-level distributed lock using a Supabase row in a dedicated export_locks table with an expiry timestamp and automatic cleanup on failure.
HLF's Dynamics portal API endpoint may not be available or documented in time for Phase 1, leaving DynamicsExporter unable to be validated against a real system and potentially shipping with an incorrect field schema.
Mitigation & Contingency
Mitigation: Design DynamicsExporter for file-based export first (CSV/JSON download), with the API push implemented behind a feature flag. Request a Dynamics test environment or sandbox from HLF as early as possible.
Contingency: Ship DynamicsExporter as a file export only for Phase 1. Phase the API push integration into a follow-on task once the Dynamics sandbox is available, using the same AccountingExporter interface with no breaking changes.