InvoiceNETSIMPLIFYING DIGITAL BUSINESS Help Center
Open portal

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–E or VD. See Credit notes.
  • Foreign currency: Keep currency exchange rates current. The XML needs the rate and AED totals. See Foreign currency.

Before go-live

  1. Legal entity holds TRN and address with emirate code.
  2. Customers have TRN, Peppol ID and State filled.
  3. Sales tax codes and groups separate S, Z, E, O and AE.
  4. Units have external codes valid under Rec 20.
  5. Return reason codes mapped to approved credit note codes.
  6. Electronic invoicing feature and UAE format configured, or a connector in place.
  7. 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.