27 Mar’17

BIIntegrating Sales Order line items of Dynamics 365 Financials using Scribe Online


In Dynamics 365 Financials, Sales order line items cannot be integrated in a single step. As, it takes only item number in a create () and rest all the fields are considered as an Update.


  1. Dynamics 365 Financials.
  2. Scribe Online Subscription.

Purpose of the Setup:

Our goal is to integrate Sales Order Line item from Microsoft Dynamics CRM Online to D365 Financials through Scribe Online.


  1. Configure a connection for your Microsoft Dynamics CRM Online by providing the required information.
  2. Configure a connection for your D365 Financials by providing the required information.
  3. Create a new Solution and specify the Solution name and the Agent.
    Note: Here, we are using a Cloud Agent.
  4. Now create an Integration Map for integrating Sales Order Header and its Line items from CRM Online to Dynamics 365 Financials.

    1. Sales Order Header:
      Use Create Block and create Sales Order Header by mapping required fields.
    2. Sales Order Lines:
      Use For each child Block for looping the Sales Order Lines.

      1. Use Create Block to Create Sales Order Line by mapping primary fields like Document_No,Document_Type,No
      2. Use Update Merge Block to map rest of the fields of Sales Order Lines like quantity,Unit_price etc along with ETag and ETagConcurrencyBehavior

      Note: (As specified by Scribe Software)

      The OData Protocol uses Entity Tags (ETag) to determine how to update or delete data.

      The Dynamics NAV/Financials Connector exposes these ETags as fields:

      ETag — Available as a source and target field, contains the ETag value provided by the Dynamics NAV/Financials OData service.

      ETagConcurrencyBehavior — Available as a target field, used to determine how data conflicts are handled. Possible values for this field are:

      • Always Overwrite (default)
      • Overwrite If Match
      • Overwrite If Not Match


Written by

Anjali Hemmadi

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Managing mailbox through Email Archiving

    20 March’ 2018

    Introduction: Email can fill your Outlook Inbox quickly – new messages, replies, and forwards. Before you know it, yo...

    Read more
  • Workaround to Report.SAVEASPDF in NAV 2018

    20 March’ 2018

    Objective: In NAV 2017 Emailing the PDF by running the report using Report.SAVEASPDF is now not allowed in NAV 2018. Th...

    Read more
  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more