What's new or changed in dual-write

Dual-write is an out-of-box infrastructure that provides near-real-time interaction between customer engagement apps in Microsoft Dynamics 365 and Finance and Operations apps. To get started with dual-write, see the Dual-write home page.

Check out the latest information about dual-write features and changes in the release plans.

August 2021 release

The August 2021 release of Dual-write application orchestration solution version 2.3.0.15 is based on Dual-write core solution version 1.0.29.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Bug fix Fixes the case where dual-write alerts fail to send. General availability
System tables Adds support for enabling dual-write for system tables. General availability
Bug fix Some client APIs have been deprecated and replaced with new APIs. The JavaScript code in the dual-write orchestration package has been upgraded to use the new client APIs. General availability
Bug fix Because dual-write doesn’t support offline mode, the company name does not automatically contain a default value. You must select the company manually. General availability
Bug fix The Vendor group field on the Accounts form does not filter values based on the selected company. General availability
Bug fix Saving a Vendor record in a Finance and Operations app fails with the error message Cannot convert the literal '' to the expected type 'Edm.Int32'. General availability
Bug fix The transformation on the Vendor payment method map required an update. The enumeration on the PAYMENTSTATUS field is incorrect resulting in error message Cannot convert the literal 'Confirmed' to expected type 'Edm.Int32'. General availability
Bug fix Sales order header and Sales order line maps conflict with Project contract header and Project contract line maps. You couldn't enable both at once. General availability
Bug fix Create an error message to state that Ship To Country/Region is a mandatory field on Sales order and Purchase order. General availability
Bug fix Whenever a sales order is created in Dynamics 365 Sales, the default value of the Invoice Customer is based on Billing Account value of the Potential Customer. General availability
Bug fix Ability to toggle Price override field to true or false. General availability

This release includes following map changes.

  • [CDS sales quotation lines] - [quotedetails] map version 1.0.0.1
  • [CDS sales order lines] - [salesorderdetails] map version 1.0.0.1
  • [Vendors V2] - [msdyn_vendors] map version 1.0.0.3
  • [Vendor payment method] - [msdyn_vendorpaymentmethods] map version 1.0.0.1

August 2021 release of party and global address book

The August 2021 release of the Dual-write Party and Global Address Book Solutions 3.1.0.2 is based on Dual-write core solution version 1.0.29.

This release contains features and bug fixes listed in the following table.

Feature Description Status
Bug fix Improved performance when more than 20 legal entities are enabled for dual-write. General availability
Bug fix Fixed issue with Is primary setting on postal address. General availability
Bug fix Fill the contact information on Contact for customer or vendor upon party association on main form. General availability
Bug fix Full name of contact with IsCustomer=Yes or IsVendor=Yes is blank during initial sync and live sync. General availability
Bug fix Make the country/region field required on both postal address table and customer address table. General availability
Bug fix Identify a phone number as mobile. General availability
Bug fix Update the display name from Parties Electronic Addresses table to Party Electronic Addresses table. General availability
Party Electronic Address Synchronize primary electronic address data from lead qualification process, account, and contact creation process to Party Electronic Addresses, and vice versa. General availability

July 2021 release

The July 2021 hotfix release of Dual-write application orchestration solution version is based on Dual-write core solution version 1.0.28.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Tracing Logs basic transaction properties to a remote database for use in analytics and error detection. General availability

June 2021 release

The June 2021 hotfix release of Dual-write application orchestration solution version 2.2.2.98 is based on Dual-write core solution version 1.0.27.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Bug fix Implements rollback of transactions that exceed a 2-minute time limit. General availability
Bug fix Fixes processing of datetime fields during a catch-up sync. General availability
Tracing Limits nonessential plugin trace logs for medium-size transactions (5 or more records). General availability
Bug fix Added storage and tracking dimension group lookup fields to the Shared Product Details table. Added these lookup fields to the Released products V2" -> msdyn_sharedproductdetails dual-write map. General availability
Bug fix In a sales order, when you select an existing product, the Sales product category value defaults to a value that comes from the Product Category Assignments table. But when the defaulted value is not part of sales hierarchy, the line-item addition throws an error message. To prevent the error and allow assignment inside finance and operations apps, the sales product category field can be left blank. General availability
Bug fix In a sales order, when you select an existing product, the Sales Product Category is read-only. It is editable when the product is set to write-in. General availability
Bug fix The Total Tax field in a sales quotation and sales order are read-only. When the Price per unit field is changed in the sales quotation line or sales order line in finance and operations apps, it must sync back to the respective sales quotation or sales order line in customer engagement apps. General availability
Bug fix Updating the Warehouse name field in finance and operations apps caused the Name field in Dataverse to be blanked out. General availability
Bug fix Localization fixes for Ukraine. General availability

May 2021 release

The May 2021 hotfix release of Dual-write application orchestration solution version 2.2.2.60 is based on Dual-write core solution version 1.0.26.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Government Community Cloud support Dual-write runtime on the Government Community Cloud region is supported. General availability
User-friendly error messages Enables user-friendly error messages for some of the live sync failures. General availability

May 2021 release of party and global address book

The May 2021 hotfix release of the Dual-write Party and Global Address Book Solutions 3.0.0.26 is based on Dual-write core solution version 1.0.24.

This release contains the bug fixes listed in the following table.

Feature Description Status
Bug fix In customer engagement apps, when a lead contains postal address and is qualified, the postal address is associated with the account. It doesn't flow to Finance and Operations apps, however. General availability
Bug fix In customer engagement apps, when you add an address to an existing account or contact, the address doesn't flow to Finance and Operations apps. General availability
Bug fix More address fields are added to the Customer Address table. General availability
Bug fix In Dataverse, we changed the display name of msdyn_contactforparties table to Contact for Customer or Vendor General availability
Bug fix We fixed a language transformation in the Contacts V2 (msdyn_contactforparties) mapping. General availability
Bug fix We fixed an issue in initial sync in the CDS Party postal address locations (msdyn_partypostaladdresses) mapping to avoid loss of some records in Customer Address table. General availability

Solution details

Solution name Has new changes? Previous version New version
Party Yes 3.0.0.1 3.0.0.26
Dynamics365GABExtended Yes 3.0.0.1 3.0.0.26
Dynamics365GABDualWriteEntityMaps Yes 3.0.0.1 3.0.0.26
Dynamics365GABPartyAnchor Yes 3.0.0.1 3.0.0.26
Dynamics365GABPartyCommon Yes 3.0.0.1 3.0.0.26

Map instructions

Follow these steps to apply the new maps:

  1. Apply the latest map version 1.0.0.2 for CDS Postal address history V2 (msdyn_postaladdresses) mapping.
  2. Apply the latest map version for Contacts V2 (msdyn_contactforparties) mapping.
  3. Run the initial sync of the CDS Party postal address locations (msdyn_partypostaladdresses) mapping twice to make sure that there is no loss of address records in Customer Address table due to concurrent address updates.

April 2021 release

The April 2021 hotfix release of the Dual-write application orchestration solution version 2.2.2.60 is based on Dual-write core solution version 1.0.25.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Record deletion Handle record deletion during transactions with multiple entities. General availability
Bug fix Handle conflict resolution during catch-up sync. General availability
Bug fix Issues related to solution import on environments. General availability
Bug fix The Notes table now understands the Null value. General availability
Bug fix Dual write orchestration package 2.2.2.50 does not replace the existing key (msdyn_locationid field) on the Address table with the new key which is a combination of the msdyn_locationid and parentid fields. Instead it shows both keys. This has been fixed with the new version 2.2.2.60. This new version is applicable only when you are using the party and global address book solution. General availability

March 2021 release

The March 2021 release of the Dual-write application orchestration solution version 2.2.2.50 is based on Dual-write core solution version 1.0.24.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Party and Global Address Book Brings schema parity with Finance and Operations apps, and gives you the ability to solve complex business problems on Dataverse related to customers, vendors, and contact persons. To use this feature, install Dual-write Party and Global Address Book Solutions.
Supported Finance and Operations versions are 10.0.605.30025 (platform update 14), 10.0.644.20031 (platform update15), 10.0.689.10027 (platform update 16), and 10.0.761.1 (platform update 17)
General availability
Bug fix Product category name is part of the natural/integration key of the Product Categories table. Updating the name using a Finance and Operations app cause an insert in Dataverse instead of an update. Please use the new map for msdyn_productcategories - Product categories with version 1.0.0.1. The supported Finance and Operations version is 10.0.778.0 (platform update 42) General availability
Bug fix Localization bug fixes and updates. General availability
Bug fix A note without a description throws error. General availability
Bug fix In Finance and Operations apps, running the "Calculate Sales Totals" batch job updates all orders modified within last 24 hours and fixes the totals regardless of the status of the order for example, canceled or fulfilled. That action triggers a re-cancellation or re-fulfillment causing a conflict error. General availability

February 2021 release

The February 2021 release of the Dual-write application orchestration solution version 2.2.2.23 is based on Dual-write core solution version 1.0.24 and version 10.0.16 (10.0.689.10004) or newer of Finance and Operations apps and version 9.1.0000.11732 or newer of Dataverse.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Commerce price engine for sales quotations Get pricing for sales quotations using commerce price engine. General availability
Notes integration Notes are integrated between customer engagement apps and Finance and Operations applications for customers, vendors, sales orders, and purchase orders. General availability

Important

If you don't need notes integration, do not install or upgrade to Dual-write application orchestration solution version 2.2.2.23 or later. If you install the update, you won't be able to uninstall the notes feature.

January 2021 release

The January 2021 release of the Dual-write application orchestration solution version 2.2.1.30 is based on Dual-write core solution version 1.0.24 and version 10.0.14 of Finance and Operations apps.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Bug fix French-localized strings in the user interface exceeded the maximum limit of 100 characters. General availability
Bug fix Error while starting the Dataverse released distinct products map. General availability

The January 2021 release of the Dual-write application orchestration solution version 2.2.1.23 is based on Dual-write core solution version 1.0.24 and version 10.0.14 of Finance and Operations apps.

This release contains the features and bug fixes listed in the following table.

Feature Description Status
Purchase order integration Integrates purchase order functionality between Dynamics 365 Field Service and Dynamics 365 Supply Chain Management. General availability
Bug fix Localization updates. General availability
Bug fix In customer engagement apps, on the Contact form, after you set Is Sellable to Yes and save the record, the contact is considered a customer who can transact. Because customers are associated with transactions, Is Sellable becomes read-only after saving. You can't change it back to No. General availability

December 2020 release

The December 2020 release of the Dual-write core solution (1.0.24) contains the features and bug fixes listed in the following table.

Feature Description Status
Signal repeater service Enables the dual-write runtime plugin to communicate with the Finance and Operations signal repeater service with authentication support. General availability

November 2020 release

The November 2020 release of the Dual-write core solution (1.0.23) contains the features and bug fixes listed in the following table.

Feature Description Status
Authentication Support for new authentication certificate to ensure security. General availability

October 2020 release

The October 2020 release of the Dual-write application orchestration solution and the Dual-write core solution contains the features and bug fixes listed in the following table.

Feature Description Status
Camel-cased column mappings Adds support for column mappings with camel-cased navigation properties. General availability
Bug fix Fixes the bug where an unrecognized tag configuration would cause dual-write execution to be skipped General availability

September 2020 release

The September 2020 release of the Dual-write application orchestration solution version 2.0.777.493 is based on Dual-write core solution version 1.0.21.

The September 2020 release contains the features and bug fixes listed in the following table.

Feature Description Status
Lead qualification process in Sales is now company striped Dynamics 365 Sales users can create a lead, qualify the lead to an opportunity, convert an opportunity into a quote, activate a quote, and create an order. This process was broken in dual-write due to lack of company striping on the Lead entity. We implemented company striping on the Lead entity, which cascades the company to the underlying Account and Opportunity tables. Thus the application behavior is restored to support the process. During the Lead qualification process, the Contact entity isn't company striped. This design supports the Party entity model that is due in October 2020. To learn about the Party and GlobalAddressBook model for dual-write, join the dual-write Yammer group. General availability
Map state transitions from Order to SalesOrder The Order form in Dynamics 365 Sales is always set to Active. To create state transitions from Order in Dynamics 365 Sales to SalesOrder in Dynamics 365 Supply Chain Management, we introduced the ProcessingStatus column. General availability
Money to decimal data type conversion Dataverse environments are limited to 4 decimal places for currency and 10 decimal places for exchange rates. Finance and Operations apps support more decimal places than Dataverse. You can now opt in to extend the decimal support in Dataverse to help ensure there's no loss of decimal place data when using dual-write. General availability
Security role for company and currency exchange Company and currency exchange tables are global in nature and all dual-write users require read access to these 2 tables. To simplify the experience, we've added a new security role named dual-write app user. Each dual-write user must be added to this security role. General availability
Security role for setup Adds the Dual-write Runtime User security role. This role allows non-administrator users to create rows that are set up for dual-write. This feature is part of Dual-write core solution 10.0.21. General availability
Tracing Internal column added for use in tracing. This feature is part of Dual-write core solution 10.0.21. General availability
Bug fix Fixes issues where dual-write fails because of a mismatch between the plugin and the destination environments. This fix is part of Dual-write core solution 10.0.21. General availability
Bug fix Support to ensure that unused plugins are deleted. This fix is part of Dual-write core solution 10.0.21. General availability

August 2020 release

The August 2020 release of the dual-write orchestration package contains the features and bug fixes listed in the following table.

Feature Description Status
Manage multiple table maps As part of day-to-day operations, you might need to bulk handle table maps. For example, you might want to simultaneously enable or pause a set of table maps. Instead of doing this one-by-one, which is cumbersome and time consuming, you can now enable, pause, resume, or stop more than one table map at the same time in the dual-write list page. General availability
Bug fix Fixes issues where rows would be skipped in certain cases during project execution. This fix is part of Dual-write core solution version 10.0.19. General availability

June 2020 release

The June 2020 release of the dual-write orchestration package contains the features and bug fixes listed in the following table.

Feature Description Status
Edit legal entity after setup The company or legal entity list isn't static and is constantly changing. You might need to add new companies, for example, during a phased rollout or acquisition. Previously, you couldn't add a company or legal entity without system downtime. During this downtime, you would have to unlink and relink your environment. That can be expensive, especially if you have pre-existing data. With this feature, you can add a company in a live environment without having to unlink and relink. General availability

May 2020 release

The May 2020 release of the dual-write orchestration package (version 2.0.777.353) contains the features and bug fixes listed in the following table.

Feature Description Status
Look up on-hand inventory Ability to look up on-hand inventory and available-to-promise dates on forms in customer engagement apps. General availability
Unit conversions When unit conversions occur in a Finance and Operations app at the quote line and order line, the customer engagement app honors the unit conversions and reflects the respective changes to unit and price in the customer engagement app quote detail and order detail. General availability
Currency change restriction When you try to change the currency in a Finance and Operations app for an existing quote or order, the change fails. General availability
Parity in Account and Contact forms Bring attribute parity in Account and Contact forms in customer engagement apps for B2B and B2C customers. General availability
No address duplication Don’t duplicate an address in a Finance and Operations app when there's a create or update action on a customer engagement app quote or order. General availability
SalesTaxGroup support Support for SalesTaxGroup in Account and Contact forms for business-to-business (B2B) and business-to-consumer (B2C) customers. General availability
Create sellable contacts Allow creation of a sellable contact using the Quick Create: Contact form in customer engagement apps. General availability
Quote and order creation Enable quote and order creation for B2C customers. General availability
Removal of tenant admin-level consent requirement Until now, before you could enable dual-write, a tenant admin needed to explicitly give consent to the applications. This wasn't always practical and required additional approval, which can be time consuming. With this feature, we removed this prerequisite and the need for explicitly giving consent to the applications. General availability
Force unlink dual-write environment Previously, while testing dual-write, you had to disable all the table maps before unlinking a dual-write environment. This seemed cumbersome and sometimes not possible if one of the environments wasn't available. This new feature provides a quick way to unlink your test and trial environments. General availability