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 SAP 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
- SAP
- 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
Business process
Customer Invoices / Sales Orders
Order-to-invoice handoff: SAP 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
- SAP
- 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 SAP 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
- SAP
- 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
General Journal Entries / GL Accounts and Journal Entries
Compare whether Dynamics 365 F&O General Journal Entries and SAP GL Accounts and Journal Entries describe the same journal or ledger entry 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
- SAP
- Object support to establish
- Record identity
- Retain journal ID and line IDs within the legal entity and accounting period.
- Field ownership
- The ledger owns posting approval and period controls; an integration should not treat a posted journal as an ordinary editable row.
Fields to include
- Source journal ID
- Account references
- Debit/credit amounts
- Entity
- Accounting period
- Record dependencies
- Resolve chart-of-account, currency, entity, and dimension references before lines.
- Validation
- Verify balanced debits and credits, dimension requirements, and rejection for a closed period.
- Recovery
- Reconcile posting status and use the finance-approved reversal or adjustment process instead of replaying a posted entry.
References: Dynamics 365 F&O: General Journal Entries documentation
Record matching
Released Products / Materials (Products)
Compare whether Dynamics 365 F&O Released Products and SAP Materials (Products) 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
- SAP
- 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 / Inventory / Stock
Compare whether Dynamics 365 F&O On-hand Inventory and SAP Inventory / Stock 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
- SAP
- 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