web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Unable to create Sales...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Unable to create Sales order from Finance & operations after Prospect to Cash Integration

(3) ShareShare
ReportReport
Posted on by VS-12040547-0 7
I started the Prospect to Cash integration recently and tested everything from CRM to FnO. I create Sales quotation from opportunity and everything works well. I can reach till invoice and everything is synced between both systems.
Now when we create a Sales Order directly without a Sales Quotation. It send the Sales Order number in FnO with ordernumber as 'FFME-SO-06673' but to update the SO CRM is looking for FFMEFFME-SO-06673' and it doesn't exist. So Sales order creation fails. with error - Unable to write data to entity salesorders.Writes to SalesOrderHeaderD365SalesEntity failed with error message Request failed with status code BadRequest and CDS error code : 0x80040265 response message: Cannot find record to be updated.For information on troubleshooting see https://go.microsoft.com/fwlink/?linkid=2244045. Activity ID for troubleshooting {7BE07E24-2BEB-46B3-BF46-2B3C623D639B}For information on troubleshooting see https://go.microsoft.com/fwlink/?linkid=2244045..
 
It is the same for Sales Quotations. The Plugin Tracelogs from CRM - Microsoft.Dynamics.SCMExtended.Plugins.OrderNumberAssignment, Microsoft.Dynamics.SCMExtended.Plugins, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
 
In the Plugin tracelog in CRM shows this in exception message - Entered Microsoft.Dynamics.SCMExtended.Plugins.OrderNumberAssignment.Execute(), Correlation Id: 3163727c-9dbb-405c-baf1-685c224c5e27, Initiating User: 38ac2aaf-9cd8-ed11-a7c7-0022487fef11
OrderService: AssignOrderNumberOnPreCreate.
OrderService: AssignOrderNumber
Before update, OrderNumber = ORD-01914-X6H0F3
New OrderNumber = FFMEFFME-SO-006773
Feature: Dynamics.AX.Application.SalesD365SalesPriceMasterFeature; Enabled: True
QOICommonService: MaintainPriceFieldsForPriceMasterFeature, salesorder - Start.
Validate calling user $38ac2aaf-9cd8-ed11-a7c7-0022487fef11.
QOICommonService: MaintainPriceFieldsForPriceMasterFeature, salesorder - End.
ShipTo_Country = BT
msdyn_deliveryaddressdescription = Marvel Production India
pricelevelid = 2d4227be-d5f8-ef11-bae2-000d3a289707
Feature: Dynamics.AX.Application.SalesQuotationD365SalesFeature; Enabled: True
OrderService: link quotation.
StateCode = Active; StatusCode = Microsoft.Xrm.Sdk.OptionSetValue
Exiting Microsoft.Dynamics.SCMExtended.Plugins.OrderNumberAssignment.Execute()
 
Can I get some Help?
Categories:
Dynamics 365 general
Power Platform integration
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,522 Super User 2025 Season 2 on at
    Unable to create Sales order from Finance & operations after Prospect to Cash Integration
    Good morning, afternoon, or evening :) depending on your location!
     
    The issue seems to stem from a mismatch in the Sales Order number format between Dynamics 365 CRM and Finance & Operations (FnO) during the Prospect to Cash integration. Here are steps to diagnose and resolve the problem:
    1. Verify Number Sequence Configuration
    • Check the number sequence settings in both CRM and FnO to ensure they align.
    • In FnO, go to Organization Administration > Number Sequences and verify the format for Sales Orders.
    • In CRM, ensure the plugin responsible for assigning order numbers (e.g., OrderNumberAssignment) is configured to match the FnO format.
    2. Update Plugin Logic
    • The plugin Microsoft.Dynamics.SCMExtended.Plugins.OrderNumberAssignment appears to be appending an extra prefix (FFMEFFME) to the Sales Order number.
    • Review the plugin code and adjust the logic to ensure it generates the correct format (FFME-SO-06673) expected by FnO.
    3. Check Dual-Write Mapping
    • Verify the dual-write mappings for the Sales Order entity.
    • Go to Data Management > Dual-Write > Entity Mappings and ensure the mappings for SalesOrderHeaderD365SalesEntity are correctly configured.
    4. Test Sales Order Creation
    • After updating the number sequence and plugin logic, test creating a Sales Order directly in CRM.
    • Ensure the Sales Order number matches the expected format and syncs correctly with FnO.
    5. Enable Logging for Dual-Write
    • Enable detailed logging for dual-write integration to capture any errors during synchronization.
    • Use the Activity ID provided in the error message to trace the issue in the logs.
    6. Check for Updates
    • Ensure both CRM and FnO are running the latest versions and patches, as updates often resolve integration issues.
    For more details, you can explore Microsoft's documentation on Prospect-to-Cash integration and troubleshooting dual-write issues.
     
    Hope this helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 109

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 109

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 77 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans