Executive Summary: Red C Aviation transformed airfield ground handling and accounts receivable operations by deploying a unified enterprise ERP middleware architecture. By orchestrating direct FBO One sales order AR billing, Azure-powered Jisr HR flight crew payroll connectors, real-time Saudi ZATCA Phase 2 cryptographic e-invoicing clearance, and custom form extensions, Red C Aviation achieved 99.8% billing accuracy, sub-second tax clearance, and an 85% reduction in manual data entry overhead.
Project Overview & Client Background: Red C Aviation
Red C Aviation is a premier aviation service provider specializing in airfield operations, executive aircraft charter management, passenger terminal concierge, and ground handling services across major aviation hubs in the Middle East. As aircraft movements and private jet charters expanded rapidly, Red C Aviation required an agile, audit-proof enterprise infrastructure capable of handling high-volume ramp services, fuel desk billing, specialized flight crew payroll, and strict regional tax compliance.
To support rapid growth without increasing administrative headcount, Red C Aviation partnered with the senior TWI Technical Staff and enterprise architecture team at Tech West International to engineer a comprehensive digital overhaul. The project scope covered development-side project direction, FBO One Accounts Receivable (AR) integration, custom Azure integration middleware for Jisr HR, Saudi Arabia ZATCA Phase 2 compliance, and extensive technical and functional support.
The Strategic Challenge: Operational Silos & Fragmented Billing
Prior to the transformation, airfield operations faced systemic operational bottlenecks caused by disconnected software environments:
- Manual FBO One Sales Order Processing: Ground handling orders, jet fuel sales, and ramp service charges recorded in FBO One required manual re-entry into financial ledgers, introducing invoice delays and billing errors.
- Fragmented Flight Crew Payroll: Flight crew duty hours, overnight allowances, and pilot compensation managed in Jisr HR were disconnected from general ledger salary cost centers.
- ZATCA E-Invoicing Compliance Risks: Saudi Arabia mandatory ZATCA Phase 2 regulations required real-time XML UBL 2.1 generation, cryptographic CSID signatures, and automated portal clearance for B2B aviation tax invoices.
- Rigid Out-of-the-Box ERP Forms: Default ERP transaction screens lacked specialized airfield data fields, such as tail numbers, flight origin/destination vectors, fuel density readings, and pilot license numbers.
FBO One Sales Order & Accounts Receivable (AR) Integration Architecture
FBO One is the industry-standard management platform for Fixed Base Operators (FBOs) and private jet terminals. To eliminate double data entry, our engineering team architected a real-time, event-driven REST integration pipeline between FBO One and the core Microsoft Dynamics 365 / Odoo ERP ledgers.
When a flight handling request or ramp fueling order is closed in FBO One, an automated webhook triggers an Azure Integration Services payload. The payload validates aircraft tail numbers, customer credit limits, and fuel tariffs before dynamically posting a fiscalized Sales Order and Accounts Receivable (AR) Invoice directly into the general ledger.
Azure Cloud Connector: Wiring Jisr HR & Flight Crew Payroll
Managing aviation human resources across the Middle East requires strict compliance with regional labor laws, GOSI social insurance contributions, and complex flight crew duty allowances. Red C Aviation utilizes Jisr HR as its primary workforce management portal.
We designed and deployed a custom Azure App Service and Azure Logic Apps middleware connector that bridges Jisr HR with the ERP payroll module:
- Automated Employee Master Sync: New pilot hires, ground crew onboardings, and contract updates in Jisr sync bi-directionally with ERP master records.
- Flight Crew Duty Pay Calculation: Pilot flight hours, per diem meal allowances, and overnight layover compensations automatically aggregate from Jisr timesheets into ERP payroll journal drafts.
- GCC Labor & End-of-Service (EOS) Accruals: Automated general ledger journal entries for GOSI contributions, monthly leave accruals, and End-of-Service indemnity reserves.
Tax Compliance: ZATCA Phase 2 Cryptographic CSID Clearance
Operating in Saudi Arabia requires 100% compliance with the Zakat, Tax and Customs Authority (ZATCA) Phase 2 integration mandate. For Red C Aviation, every ground handling and charter invoice must undergo real-time electronic clearance.
Our team embedded a native ZATCA Phase 2 compliance engine directly into the invoice posting routine:
- UBL 2.1 XML Standard Generation: Converts ERP invoice data into ZATCA-compliant UBL 2.1 XML structure containing mandatory aviation tags.
- Cryptographic Stamp (CSID) Signing: Signs XML payloads with ECDSA secp256k1 cryptographic keys stored securely in Azure Key Vault.
- Real-Time ZATCA API Handshake: Transmits B2B tax invoices to ZATCA servers for sub-second clearance before customer distribution.
- Scannable Phase 2 QR Code Rendering: Generates scannable Phase 2 QR codes containing ECDSA digital signatures, cryptographic hashes, and ZATCA timestamps onto printed customer invoices.
Functional & Technical Support, Change Management & Form Customizations
A successful ERP implementation extends beyond code deployment. Our team provided full-lifecycle development-side project management, technical mentoring, and functional support to ensure seamless user adoption across Red C Aviation's airfield staff, finance team, and executive leadership.
Customizations included:
- Custom Airfield Order Screens: Tailored UI screens capturing flight numbers, aircraft registration tail codes, fuel density adjustments, and ramp parking durations.
- QWeb & SSRS Invoice Layouts: Custom digital PDF invoice templates featuring bilingual Arabic/English layouts, scannable ZATCA QR codes, and detailed breakdown of airfield handling fees.
- End-to-End User Training: Hands-on functional training and 24/7 technical AMS support during initial go-live cutover.
Financial & Operational Impact Analysis
The deployment of the integrated aviation ERP solution yielded immediate quantitative improvements across operational throughput, billing accuracy, and tax audit readiness:
| Performance Metric | Pre-Implementation Baseline | Post-Go-Live Result | Operational Impact |
|---|---|---|---|
| Sales Order to AR Invoicing Time | 48 Hours (Manual Entry) | < 30 Seconds (Automated) | 99.2% Faster Billing Cycle |
| Billing & Pricing Data Accuracy | 91.5% (Rekeying Errors) | 99.8% Verified Accuracy | Near-Zero Customer Credit Memos |
| ZATCA Phase 2 E-Invoicing Pass Rate | Manual Portal Filing | 100% Instant Clearance | Zero Non-Compliance Penalties |
| Flight Crew Payroll Processing | 5 Business Days | 4 Hours (Automated Sync) | 90% Reduction in Administrative Overhead |
| Monthly Financial Closing Cycle | 12 Calendar Days | 3 Calendar Days | 75% Faster Financial Statement Availability |
Frequently Asked Questions for Voice & AI Search
Q: How does the FBO One to ERP integration work for airfield sales orders?
A: The integration utilizes Azure REST webhooks to capture closed handling orders in FBO One, automatically validating customer accounts, fuel tariffs, and landing fees before generating fiscalized AR invoices in the ERP.
Q: How does the solution handle Jisr HR flight crew payroll synchronization?
A: Custom Azure Logic Apps extract flight crew duty times and per diem allowances from Jisr HR, automatically calculating GCC labor law accruals and posting payroll journals to the general ledger.
Q: Is the ZATCA Phase 2 e-invoicing integration compliant with Saudi aviation tax rules?
A: Yes. The system automatically generates ZATCA UBL 2.1 XML files, applies ECDSA cryptographic stamps via Azure Key Vault, and achieves real-time clearance from ZATCA portal servers.
Q: What custom form extensions were developed for Red C Aviation?
A: We developed tailored ERP transaction screens capturing aircraft tail numbers, flight origin/destination vectors, fuel density readings, and bilingual Arabic/English QWeb PDF invoice templates.
