Focus Integration with UAE FTA E-Invoicing via TrustBill

Overview

What is Focus?

Focus (Focus Softnet) is a UAE-headquartered ERP and business management suite. The product lines most used for e-invoicing are:

• Focus RT — real-time ERP with a web layer and SData / REST endpoints
• Focus 9 — desktop + web hybrid ERP with SData and web-service integration
• Focus Cloud — SaaS ERP with a public REST API and webhooks
• Focus MRP — manufacturing-focused ERP based on the Focus stack

Supported Versions

Prerequisites

• Focus company with UAE VAT, TRN and customer tax IDs configured
• Customer records with 15-digit UAE TRN for B2B invoices
• User / service account with permission to read posted invoices and customers
• Active TrustBill SME account with API credentials
• Network egress from the Focus host or middleware to TrustBill API endpoints
• For on-premise editions: the SData servlet or web services endpoint must be enabled

Integration Architecture

Focus stays the source of record. A middleware agent or scheduled job reads invoices and pushes them to TrustBill.

1. Invoice posted in Focus.
2. Connector / agent reads the invoice via REST, SData or database.
3. Payload normalised into TrustBill's PINT-AE JSON.
4. POST to TrustBill /api/v1/invoices with API key authentication.
5. TrustBill validates, renders PINT-AE XML and delivers over Peppol.
6. Acknowledgement written back to Focus custom fields.

Connection Methods

Authentication

TrustBill API uses Bearer tokens. Focus-side authentication depends on the edition.

POST https://trustbill.ae/api/v1/invoices
Authorization: Bearer tb_your_api_key_here
Content-Type: application/json

Focus product auth:

• Focus Cloud: OAuth 2.0 client credentials or authorization code from the Focus admin portal
• Focus RT / 9: SData user credentials or Windows service account for the Desktop Agent
• Focus MRP: Same SData / REST credentials as the core Focus application

Focus RT

Focus RT exposes SData and REST endpoints. The standard pattern is to query the sales invoice feed, transform the payload and post to TrustBill.

GET https://focusrtserver/sdata/FOCUS/{company}/salesInvoices
  ?startIndex=1&count=50
  &where=status%20eq%20'Posted'

For a deeper Focus RT guide, see the Focus RT integration page.

Focus 9

Focus 9 ships with SData and SOAP web services. Enable the web services layer in the Focus 9 application manager, then generate an invoice query service for TrustBill.

POST https://focus9server/Focus9WS/InvoiceService.asmx
Content-Type: text/xml; charset=utf-8
SOAPAction: "http://focussoftnet.com/GetPostedInvoices"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope ...>
  <soap:Body>
    <GetPostedInvoices xmlns="http://focussoftnet.com/">
      <CompanyCode>UAE01</CompanyCode>
      <FromDate>2026-09-01</FromDate>
      <ToDate>2026-09-08</ToDate>
    </GetPostedInvoices>
  </soap:Body>
</soap:Envelope>

Focus Cloud

Focus Cloud provides a JSON REST API. Register a developer app, obtain an OAuth token and poll the sales invoice endpoint.

GET https://api.focuscloud.ae/v1/sales_invoices
  ?status=posted&from=2026-09-01&to=2026-09-08
Authorization: Bearer {focus_cloud_token}

Webhooks are also available: configure Focus Cloud to call your middleware when a new invoice is posted, and the middleware pushes to TrustBill.

Focus → TrustBill Field Mapping

UAE VAT / Tax Mapping

Map Focus tax codes to FTA tax category codes.

Credit Notes

Focus credit notes are mapped to the TrustBill credit-note endpoint. Include the original invoice number.

POST https://trustbill.ae/api/v1/credit-notes
{
  "originalInvoiceNumber": "SI-001",
  "issueDate": "2026-09-08",
  "creditNoteNumber": "CN-001",
  "reason": "Product return",
  "totals": {
    "grossAmount": -1050.00
  }
}

Status Tracking

TrustBill posts status updates to a webhook URL. The middleware writes the values back to Focus custom fields or a status table.

POST https://your-middleware.example.com/webhook/trustbill
Content-Type: application/json

{
  "invoiceNumber": "SI-001",
  "status": "Acknowledged",
  "ackRef": "FDA-ACK-123456789",
  "uuid": "a1b2c3d4-...",
  "reason": null
}

Bulk Migration

Export historical invoices from Focus reports or SData with the columns from the field mapping table, then upload to TrustBill.

POST https://trustbill.ae/api/v1/invoices/bulk
Authorization: Bearer tb_your_api_key
Content-Type: multipart/form-data

file: focus_invoices.csv
options: {"mode":"sandbox","skipErrors":true}

Sandbox & Live Modes

Test the full flow without touching the FTA. Switch to live once FTA registration and ASP assignment are complete.

Multi-Company & Multi-Currency

Focus RT, Focus 9 and Focus Cloud all support multiple companies under one install or subscription — common for UAE groups running a mainland trading entity alongside a free-zone entity. TrustBill treats each Focus company as an independent seller with its own TRN.

Error Handling & API Errors

Handle every non-2xx TrustBill response deterministically in the Desktop Agent or middleware — separate retryable errors from permanent validation errors.

Setup Checklist

Troubleshooting

• 422 validation error: Confirm customer TRN is 15 digits and seller TRN is set.
• SData 401: Check the SData user credentials and that the company is enabled for web access.
• Focus Cloud token expired: Refresh the OAuth token before the one-hour expiry.
• Desktop agent not seeing invoices: Verify the agent is running under a user with Focus company access and that the DSN is correct.
• Missing Arabic names: Use a custom field for the Arabic legal name and include it in the mapping.

Support

Need help with the Focus integration? Our team can review your SData setup, Focus Cloud app, Desktop Agent configuration or CSV mapping.