Support Portal ContactGet in touch

Using DocMan to Track Quote Submissions to a Work Instruction

   Words by Paul McQuillan

   on 26/10/2018 13:00:00

Say we have a Property Management Scenario where we want to define and instruct a Job out to a Third-Party Contractor, but we want to issue out invitations to multiple potential Contractors so they can bid for the Work.

In this scenario, we may have a definition of the Work or a Work Instruction + alongside several Quote Requests from different Suppliers.

Each Supplier will submit one or more Documents and/or Photos as part of their Quote – and ideally we would want both:

1. Our User in CRM to view and upload Documents to an individual Quote

2. Our User to view all the Documents from the various Quotes at the Work Instruction Level.

Using this scenario, we can look at how we would configure DocMan for Dynamics to make this happen between Dynamics 365 and SharePoint:

We define the Rule that first looks up the parent Work Instruction as the level up to create the Document Location for a Quote – so here we define that the Lookup Field ‘cw_workinstructionid’ in Dynamics points us to the parent Work Instruction Record to use.


Rule defining how a Quote will ‘Look-up’ to the Parent Work Instruction for Document Storage

This Rule that fits into our definition of how Quotes in Dynamics will integrate into SharePoint for Document Storage


Defining the Integration Rules for the Quote Entity in DocMan

So we have the Parent Map rule that informs where Quotes fit into the Topology below Work Instruction, and the Dynamic Map that defines each Quote will be created as a Folder in SharePoint.


Rule defining that each Quote will be created as new Folder in SharePoint and inherit Permissions from the parent Work Instruction Folder or Document Library

This then defines our rules in CRM so each Quote added to a Work Instruction appears as a new Folder in SharePoint.

We can then see these Folders either directly from the Quote, or as a nested tree of Folders from the Work Instruction.


This structure then corresponds to the relationships in CRM:


This configuration of DocMan then allows us to define how new SharePoint Topologies should work between Dynamics and SharePoint – or mirror existing SharePoint Structures and visualise these into Dynamics.

As our next step – we can publish out some of these Document Locations to the 3rd Party Contractors via a Portal App and so allow them to submit their Quotes back to us online.

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

CRMCS Quick Start Guide: How To Produce a Microsoft Teams Live Event Dynamics 365 Marketing: Lead Scoring and Sales Acceptance Designing and Developing Microsoft Power Apps Portals Thank You for Attending CRMCS’ Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Thank You for Attending Our Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Webinar: Discover How CRMCS Have United Dynamics 365, SharePoint and Microsoft Teams To Create Sales Excellence Ignite your workflow by adding DocDrive365 to Office 365 The CRMCS guide to everything you need to know about integrating Teams with Dynamics 365 Saving Time By Keeping Documents In One Place TDE Database Encryption with On Premise Dynamics The Key to Successful Compliance in 2020 Part 2: Let’s get GDPR Compliant with Microsoft Power Automate Top 3 Essential Tips for Remote Working Dynamics 365 Marketing: Top 5 Best Features Dynamics Day in the Life - Puma Investments Can you use Teams to amplify collaboration in Dynamics? Part 1: Using a Scheduled Power Automate to Trigger Expiry Date Reminders The secrets of successful document collaboration in Dynamics CRMCS launches new AppSource approved DocDrive365 Dynamics Day in the Life - Moneypenny Release Management Add the App to Dynamics DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Building a New Scheduled Process using Flow
  • "Paul has made a real difference to how my team of 24 people record and store valuable customer data and sales opportunities. Highly recommended."

    James, Operations Director

  • "Understanding your business allows us to advise when to implement aspects of CRM and, likewise, when not to."

    Paul McQuillan, Managing Director

  • "Dynamics 365 and CRMCS have made a real lasting difference to our business, allowing us to replace older systems that were holding back our performance."

    Grahame, Chief Operating Officer

  • "James worked well with us to help connect CRM with Outlook and relate how this might benefit our team using CRM for Property Care."

    Natalie, Property Care Supervisor

  • "Matt was really good with helping us run User Testing on the new Compliance Module of our CRM System."

    Tom, Compliance Administrator

Prefer to go old-school?

Write to us using the below addresses.

Head Office
CRM Consultancy
61 Oxford Street
M1 6EQ

London Office
CRM Consultancy London
Grosvenor Avenue

Content © CRM Consultancy.