Summary
When a Microsoft Dynamics NAV sales order is posted as an invoice, it can be captured into iPaaS.com through the Invoice To iPaaS.com mapping collections. The posted invoice is read from the SalesInvoices endpoint, converted to a transaction, and used to update the existing iPaaS.com transaction, along with its invoice line items and tracking numbers.
ID Format
Manual Sync ID Format. To capture a single invoice on demand, open the subscription's Manual Sync page in the iPaaS.com portal, select the Invoice To iPaaS.com transfer, and enter the Microsoft Dynamics NAV order number the invoice was posted from.
Pattern: the NAV order number
Example:
SO002970326
External ID Format. The iPaaS.com transaction is matched on the NAV order number; the transaction retains its existing external ID.
Deleted Record Support
Not supported. The integration captures posted invoices into iPaaS.com only; deleting an invoice in Microsoft Dynamics NAV is not captured.
Custom Field Support
This collection supports custom fields, allowing additional Microsoft Dynamics NAV invoice fields to be captured into iPaaS.com transaction custom fields beyond the standard mappings.
Mapping Collection Status
Status: Enabled
Trigger Events: Automatic transfers are activated by the subscriber in the iPaaS.com subscription configuration's Inbound Data Flows section, by enabling this collection's events (Poll, Create, and Update). No automatic transfer runs until they are enabled there. Manual Sync (see ID Format) is available at any time regardless.
Duplicate or Conflicting Mappings
Other collections that affect the same record. The Invoice To iPaaS.com collection updates the same iPaaS.com transaction created/updated by the Sales Order To iPaaS.com collections — once an order is posted as an invoice in NAV, it is no longer available at the SalesOrders endpoint and is read from SalesInvoices instead. The invoice line and tracking child collections write the same transaction's lines and tracking.
Collision handling. Not applicable (configurable collision handling applies only to the Sales Order From iPaaS.com collections).
Duplicate Matching
The invoice updates the existing iPaaS.com transaction matched on the NAV order number; it does not create a second transaction.
Supported Child Collections
Update Microsoft Dynamics NAV Invoice Line Item TO iPaaS.com — captures invoice item lines.
Update Microsoft Dynamics NAV Invoice Tracking Number TO iPaaS.com — captures invoice shipment tracking.
System Caveats
Microsoft Dynamics NAV Caveats
The SalesInvoices OData web service must be published in Microsoft Dynamics NAV with the service name exactly
SalesInvoices, or posted invoices cannot be polled. This endpoint is in addition toSalesOrdersand may be missing from older installation instructions — confirm it is configured.Invoices are read-only in Microsoft Dynamics NAV; the integration does not create or modify invoices in NAV.
iPaaS.com Caveats
The transaction the invoice updates must already exist in iPaaS.com (created by the order transfer), matched on the NAV order number.
Setup Requirements
Microsoft Dynamics NAV Configuration
Publish the SalesInvoices OData web service (Web Services), service name exactly
SalesInvoices. See the Installation Instructions.
Subscription Settings — Polling
Transaction Poll Search Days and Poll Time UTC Adjustment govern the invoice poll window and the NAV UTC date-filtering compensation. See the Connections and Settings documentation.
Authentication
The integration authenticates using the connection credentials in the subscription settings.
Integration Flow
The scheduled poll reads posted invoices from the Microsoft Dynamics NAV
SalesInvoicesendpoint.Each invoice is converted to a transaction; the integration locates the matching iPaaS.com transaction by NAV order number.
The transaction header, invoice line items, and tracking numbers are updated in iPaaS.com.
Mappings
Update Microsoft Dynamics NAV Invoice TO iPaaS.com (Header)
iPaaS.com data type: Transaction
Mapping Filter
IsInvoice == true;
Filter Description. Only records that originate as posted invoices are processed — the integration sets IsInvoice to true for posted invoices. Non-invoice records are skipped.
Description. Updates the existing iPaaS.com transaction from the converted invoice. Every field carries over the value already computed on the converted transaction (DestinationValue.<Field>).
Mapping Type | Source Field (Microsoft Dynamics NAV) | Destination Field (iPaaS.com) | Description |
Dynamic Formula |
| CompanyId | Required (customer/company linkage). Carried over from the converted invoice transaction; the linkage is inherited from the originating order. |
Dynamic Formula |
| SystemId | Required (automatic). Carried over. |
Dynamic Formula |
| TransactionNumber | Required. Carried over. |
Dynamic Formula |
| ParentId | Recommended. Carried over. |
Dynamic Formula |
| CustomerId | Required (customer/company linkage). Carried over; the linkage is inherited from the originating order. |
Dynamic Formula |
| Type | Required. Carried over. |
Dynamic Formula |
| Status | Required. Carried over. |
Dynamic Formula |
| EmailAddress | Recommended. Carried over. |
Dynamic Formula |
| DiscountAmount | Recommended. Carried over. |
Dynamic Formula |
| TaxAmount | Recommended. Carried over. |
Dynamic Formula |
| ShippingAmount | Recommended. Carried over. |
Dynamic Formula |
| Subtotal | Recommended. Carried over. |
Dynamic Formula |
| Total | Recommended. Carried over. |
Dynamic Formula |
| TotalQty | Recommended. Carried over. |
Update Microsoft Dynamics NAV Invoice Line Item TO iPaaS.com
iPaaS.com data type: Transaction Line
Mapping Filter
Type == "Item" && No != ""
Filter Description. Only item-type invoice lines that have an item number are captured; other line types are skipped.
Description. Captures the posted invoice's item lines into the iPaaS.com transaction line items.
Mapping Type | Source Field (Microsoft Dynamics NAV) | Destination Field (iPaaS.com) | Description |
Static |
| Type | Required. Fixed line type. |
Static |
| Status | Required. Fixed line status. |
Field |
| Sku | Required. Line SKU, from the NAV invoice line item number; must resolve to an existing iPaaS.com product/variant when Type is Product. |
Field |
| Description | Recommended. Line description. |
Field |
| Qty | Recommended. Ordered quantity. |
Field |
| QtyShipped | Recommended. Invoiced/shipped quantity. |
Field |
| UnitPrice | Recommended. Line unit price. |
Field |
| ExtendedPrice | Recommended. Line extended price. |
Update Microsoft Dynamics NAV Invoice Tracking Number TO iPaaS.com
iPaaS.com data type: Transaction Tracking Number
Mapping Filter
!string.IsNullOrEmpty(PackageTrackingNo_SalesShipment)
Filter Description. Only lines that have a package tracking number are captured.
Description. Captures shipment tracking detail for the posted invoice into the iPaaS.com transaction tracking number.
Mapping Type | Source Field (Microsoft Dynamics NAV) | Destination Field (iPaaS.com) | Description |
Field |
| TrackingNumber | Recommended. Package tracking number. |
Field |
| ShippingMethod | Required. Shipping method (shipping agent code); must match a Shipping Method configured in iPaaS.com. |
Field |
| ShippingMethodDescription | Recommended. Shipping method description. |
Field |
| Description | Recommended. Line description. |
Field |
| Quantity_Invoiced | Recommended. Invoiced quantity. |
Field |
| Line Item Id | Recommended. Shipment line number. |
Dynamic Formula | combines quantity, shipping agent code, and tracking number when all present | Partial Deliveries | Recommended. Pipe-delimited partial-delivery descriptor built from quantity, shipping agent code, and tracking number (see mapping notes for the formula). |
Error Handling
For the catalog of subscriber-visible errors, see the Microsoft Dynamics NAV Error Messages article.
Testing & Validation
Test Scenarios
Post an order as an invoice in Microsoft Dynamics NAV and run the poll; confirm the matching iPaaS.com transaction is updated with invoice totals, lines, and tracking.
Confirm an order with no invoice is not affected by this collection (filter requires IsInvoice).
Confirm a line without a tracking number does not produce a tracking record.
Validation Checklist
The SalesInvoices web service is published in NAV with the exact service name
SalesInvoices.The order's transaction already exists in iPaaS.com before the invoice posts.
Additional Notes
The order form of these transactions is documented in the Sales Order To iPaaS.com mapping documentation.
For directionality, required web services, and environment-specific behaviors, see the Microsoft Dynamics NAV Known Limitations article.