cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NavBoy
New Member

Document No. must have a value in Sales Line

Hi,

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. 

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

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,

Alice

 

 

I have re-posted this message  

Hi,

 

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(https://www.youtube.com/watch?v=hAB4TDVMjxU) 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!

 

Regards

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,816)