Use these data-model references to describe the records your connection needs. They are planning examples; connector availability and supported operations must be established before implementation.
Download the mapping worksheet · CSV, no email required
Record matching
Customers / Business partners
Compare whether Dynamics 365 F&O Customers and Infor LN Business partners describe the same customer in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Dynamics 365 F&O
- Object support to establish
- Infor LN
- Object support to establish
- Record identity
- Determine whether each customer represents an individual, a company, or a business-unit relationship before matching it to a contact or organization. Retain the source customer ID and destination ID; names and email alone are insufficient.
- Field ownership
- Separate the customer relationship from contact details, billing authority, and consent. Choose an owner for each field after identifying whether the customer is a person or company.
Fields to include
- Source customer ID
- Person/company classification
- Legal entity or business unit
- Destination identity reference
- Record dependencies
- Resolve person or company type, legal entity, business role, and any billing account before transactions.
- Validation
- Test an individual buyer, a company buyer, and one company with multiple billing relationships. Do not merge these into a single generic contact.
- Recovery
- Hold ambiguous customer matches for review and resolve customer type before retrying dependent records.
References: Dynamics 365 F&O: Customers documentation
Record matching
Vendor Invoices / Bills of material
Compare whether Dynamics 365 F&O Vendor Invoices and Infor LN Bills of material describe the same supplier bill in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Dynamics 365 F&O
- Object support to establish
- Infor LN
- Object support to establish
- Record identity
- Retain the supplier-bill ID, supplier, legal entity, and document reference; distinguish it from a customer invoice.
- Field ownership
- Accounts payable owns approval and posting; a supplier bill is not an accounts-receivable invoice.
Fields to include
- Source bill ID
- Supplier reference
- Entity
- Line amounts and currency
- Approval/posting state
- Record dependencies
- Resolve supplier, expense/account codes, entity, currency, and accounting period before bill lines.
- Validation
- Test a duplicate supplier document number in another entity, a partially paid bill, and a closed period.
- Recovery
- Verify whether the bill was approved or posted before retrying; use the approved adjustment process for posted bills.
References: Dynamics 365 F&O: Vendor Invoices documentation
Business process
Customer Invoices / Sales orders
Order-to-invoice handoff: Infor LN Sales orders provides context for Dynamics 365 F&O Customer Invoices. These are related records, not equivalent entities.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Dynamics 365 F&O
- Object support to establish
- Infor LN
- Object support to establish
- Record identity
- Link order and line IDs to invoice and line IDs; allow partial invoicing and multiple invoices per order.
- Field ownership
- Finance owns invoice posting; the order system supplies the approved commercial context.
Fields to include
- Source record reference
- Destination record reference
- Approved handoff state
- Duplicate-detection key
- Record dependencies
- Create or locate the customer and products first; resolve taxes, currency, and fulfillment references.
- Validation
- Test a partially invoiced order, tax rounding, and a repeated handoff without generating another invoice.
- Recovery
- Check for an existing destination order before retrying a timed-out create; reconcile line IDs to avoid duplicate fulfillment.
References: Dynamics 365 F&O: Customer Invoices documentation
Record matching
Sales Orders / Sales orders
Compare whether Dynamics 365 F&O Sales Orders and Infor LN Sales orders describe the same sales order in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Dynamics 365 F&O
- Object support to establish
- Infor LN
- Object support to establish
- Record identity
- Preserve both the order ID and stable line IDs. Allow one order to relate to several shipments or invoices.
- Field ownership
- Decide which system approves the order and which can cancel or amend it after fulfillment begins.
Fields to include
- Source order ID
- Customer reference
- Line references and quantities
- Order status
- Currency
- Record dependencies
- Create or locate the customer and products first; resolve taxes, currency, and fulfillment references.
- Validation
- Test a multi-line order, a partial cancellation, and two partial shipments. Compare line totals as well as the header.
- Recovery
- Check for an existing destination order before retrying a timed-out create; reconcile line IDs to avoid duplicate fulfillment.
References: Dynamics 365 F&O: Sales Orders documentation
Record matching
Released Products / Items
Compare whether Dynamics 365 F&O Released Products and Infor LN Items describe the same product or catalog item in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Dynamics 365 F&O
- Object support to establish
- Infor LN
- Object support to establish
- Record identity
- Distinguish the product ID, variant ID, SKU, and price-list entry; they are not interchangeable keys.
- Field ownership
- Assign ownership for catalog content, price, and stock separately.
Fields to include
- Source product ID
- SKU or variant reference
- Description
- Unit of measure
- Price-list reference
- Record dependencies
- Resolve units, variants, categories, and applicable price lists before order lines.
- Validation
- Test two variants of one product, a changed SKU, and a price that applies to only one market or currency.
- Recovery
- Repair the variant or price-list reference before retrying affected order lines; preserve existing transaction prices.
References: Dynamics 365 F&O: Released Products documentation
Record matching
On-hand Inventory / Warehouse / inventory
Compare whether Dynamics 365 F&O On-hand Inventory and Infor LN Warehouse / inventory describe the same inventory or stock position in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Dynamics 365 F&O
- Object support to establish
- Infor LN
- Object support to establish
- Record identity
- Identify stock by product/variant, location, and any lot or serial dimension; a product ID alone is insufficient.
- Field ownership
- Choose the stock authority and distinguish available, reserved, and physical quantities.
Fields to include
- Product reference
- Location reference
- Quantity type
- Quantity
- As-of time
- Record dependencies
- Resolve product, unit, warehouse/location, and lot/serial references.
- Validation
- Test the same SKU in two locations, a reservation, and an older snapshot arriving late.
- Recovery
- Reconcile the latest stock position before retrying; do not apply an old absolute quantity after new movements.
References: Dynamics 365 F&O: On-hand Inventory documentation