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 / Customers
Compare whether Dynamics 365 F&O Customers and Microsoft Dynamics GP Customers 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
- Microsoft Dynamics GP
- 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
Vendors / Vendors
Compare whether Dynamics 365 F&O Vendors and Microsoft Dynamics GP Vendors describe the same supplier or vendor 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
- Microsoft Dynamics GP
- Object support to establish
- Record identity
- Use the supplier ID within its business entity; a supplier name may occur in several subsidiaries.
- Field ownership
- Assign responsibility for approved supplier details; restrict changes to payment instructions to the business approval process.
Fields to include
- Source supplier ID
- Legal name
- Entity reference
- Payment terms
- Active status
- Record dependencies
- Resolve business-unit and payment-term references before purchasing transactions.
- Validation
- Test a supplier shared across subsidiaries and an inactive supplier referenced by an open bill.
- Recovery
- Review rejected supplier changes before retrying dependent bills; do not reactivate a supplier merely to make a write pass.
References: Dynamics 365 F&O: Vendors documentation
Record matching
General Journal Entries / GL Accounts & Journal Entries
Compare whether Dynamics 365 F&O General Journal Entries and Microsoft Dynamics GP GL Accounts & 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
- Microsoft Dynamics GP
- 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
On-hand Inventory / Inventory Items (IV)
Compare whether Dynamics 365 F&O On-hand Inventory and Microsoft Dynamics GP Inventory Items (IV) 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
- Microsoft Dynamics GP
- 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
Record matching
Purchase Orders / Purchase Orders (POP)
Compare whether Dynamics 365 F&O Purchase Orders and Microsoft Dynamics GP Purchase Orders (POP) describe the same purchase 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
- Microsoft Dynamics GP
- Object support to establish
- Record identity
- Retain purchase-order and line IDs together with the supplier and legal-entity context.
- Field ownership
- Keep procurement approval separate from receipt and payment states.
Fields to include
- Source purchase-order ID
- Supplier reference
- Line references
- Quantity
- Approval status
- Record dependencies
- Resolve supplier, product, business unit, and delivery-location references before lines.
- Validation
- Test a partially received purchase order and an amendment after approval.
- Recovery
- Reconcile receipts already recorded before resubmitting an amended order.
References: Dynamics 365 F&O: Purchase Orders documentation