Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Document No. must have a value in Sales Line


I'm running into this issue for quite a while as i'm unable to get records into the sales line through MS Flow from Dynamics CRM Work Order to Dynamics NAV Sales Order. Attached is the screenshot below of the error from MS Flow:msflow_saleslines_docno_error.JPG


Would appreciate your help. Thanks in advance. 

Community Support Team
Community Support Team

Re: Document No. must have a value in Sales Line

Hi @NavBoy,


Could you please share a full screenshot of the configuration of your flow?


Please share more details so we would try to provide a proper workaround for you.


Best regards,



Level: Powered On

Re: Document No. must have a value in Sales Line


I have re-posted this message  

Level: Powered On

Re: Document No. must have a value in Sales Line



We are currently working to integrate data between the Field Service Module of CRM and Sales Order Module of NAV. The synchronization example has been taken from this( link. Accordingly, we have mapped the following entities: 

  1. (CRM)Account <---> Customer(NAV) 
  2. (CRM)Contact <----> Contact(NAV) 
  3. (CRM)Products <----> Items(NAV)
  4. (CRM)Work Order <---> Sales Order(NAV)

From the above, we are able to create the WO record in Sales Header whereas for Sales Line we are having issues with the primary keys(Doc No, Doc Type, Line No) in Sales Line which doesn't show in Flow for the NAV Create Item. For that, we added two additional fields, Document_No_CRM and Line_No_CRM, so that we could assign the values from CRM to these primary key fields in the OnInsert trigger on Sales Line table.


Let me know if you have any idea about this query. Thanks in advance!



Helpful resources


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (3,502)