Dynamics 365 Finance & Operations: mapping your data
How customers, sales tax codes and invoices in Dynamics 365 Finance & Operations map to PINT AE fields.
In Dynamics 365 Finance & Operations, e-invoices come from sales order invoices, free text invoices and project invoices. Microsoft uses the Electronic invoicing feature to produce country formats.
Microsoft has announced UAE e-invoicing support for Finance & Operations (Message Center MC1478757), with general availability planned for 1 December 2026. Check Microsoft's latest release plan before you design your solution.
Where each e-invoice field comes from
| E-invoice field | Where it lives in D365 F&O | What to check |
|---|---|---|
| IBT-031 Seller TRN | Legal entity › tax registration / Registration IDs | 15 digits, starts 1, ends 03 |
| IBT-034 Seller Peppol ID | Electronic invoicing setup or registration ID | 0235: + 10-digit TIN |
| IBT-039 Seller emirate | Legal entity address › State | Emirate code |
| IBT-048 Buyer TRN | Customer › Invoice and delivery › Tax exempt number, or Registration IDs | Present for VAT-registered buyers |
| IBT-049 Buyer Peppol ID | Customer registration ID or electronic address | Buyer TIN, or a 99000000xx receiver |
| IBT-047 / BTAE-11 Licence and authority | Customer Registration IDs | Authority filled with licence |
| IBT-054 Buyer emirate | Customer address › State | Emirate code |
| IBT-001 Invoice number | Invoice number sequence | Unique per legal entity |
| IBT-009 Due date | From terms of payment | Present when amount is payable |
| IBT-154 Item description | Released product name or line text | Not blank on free text lines |
| IBT-130 Unit code | Units with external codes | Map to Rec 20 (H87, EA, XBX) |
| IBT-157 GTIN | Released product barcode / GTIN code | Valid GTIN for reverse-charge goods |
| IBT-151 Tax category | Sales tax code on the line | One code per category |
| IBT-121 Exemption reason | Sales tax exempt codes | DL8.46.1–DL8.46.4 |
Tax category mapping
Tax is set in Tax › Indirect taxes › Sales tax. The line's sales tax code is the intersection of the sales tax group (from the customer) and the item sales tax group (from the product or line).
| Category | Sales tax code | Rate | Groups |
|---|---|---|---|
| S | VAT5 |
5% | Domestic customer group + standard item group |
| Z | VAT0Z |
0% | Zero-rated item group or export customer group |
| E | VAT0E |
0% | Exempt item group with exempt code |
| O | VATOS |
0% | Out-of-scope item group |
| AE | VATRC5 |
5% | Reverse-charge setup; buyer TRN, GTIN, goods type |
Never let one 0% code serve both zero-rated and exempt items.
Special scenarios
- Exports: Transaction type
00000001; delivery address outside AE. See Exports. - Deemed supply: A dedicated customer with Peppol ID
9900000097. See Deemed supply. - Credit notes: Create from the original invoice (return order or credit note function) so the reference carries over. Map return reason codes to
DL8.61.1.A–EorVD. See Credit notes. - Foreign currency: Keep currency exchange rates current. The XML needs the rate and AED totals. See Foreign currency.
Before go-live
- Legal entity holds TRN and address with emirate code.
- Customers have TRN, Peppol ID and State filled.
- Sales tax codes and groups separate S, Z, E, O and AE.
- Units have external codes valid under Rec 20.
- Return reason codes mapped to approved credit note codes.
- Electronic invoicing feature and UAE format configured, or a connector in place.
- Test sales order, free text and project invoices in a sandbox.
Field names vary by version and configuration; confirm the mapping with your implementation partner.