Microsoft Dynamics. Create and send PandaDoc documents

Availability: Business and Enterprise plans

This integration will allow you to create, send, and track documents from Opportunity, Account, Contact, Quotes, and custom entities from Microsoft Dynamics CRM.

Visit our integration page to learn more

Learn how to install the integration here.

Watch a short video overview:

Set up PandaDoc Templates to use with Microsoft Dynamics CRM

Set up the templates and what data you would like to pull from Microsoft Dynamics CRM. In the following sections, we will discuss the setup of roles and variables.

Use PandaDoc Roles to import Contact information

With template roles, you can import contact information (first name, last name, email address, company, phone, job title, street address, city, postal code, country, state/region) from Microsoft Dynamics CRM Opportunity object

In case you pre-assign a recipient on the template level, they will be automatically assigned to the role when the document is created.

1. Open your template, then click on +Add roles at the top and add a role
2. Click Variables in the right panel, next find the default role variables by the role name at the beginning, e.g. Client.FirstName
3. Copy a variable and paste it where you need it in the template.

Set up your variables to pre-populate your documents with opportunity data

Variables will save your time with auto-filling information from an entity into a document.

Here's how to view data that you can send from Microsoft Dynamics CRM entity to PandaDoc documents. Click on the gear icon in the top right corner and select Advanced Settings. Under Settings, go to Extensions, then click on PandaDoc Settings.

Here you can pre-set the data to pass from Microsoft Dynamics CRM. Please note, the data must be set up for each entity separately (in case you are going to create documents from more than one entity) and the data will not cross-populate.

1. Under Configure tokens, you will see the entities in which you installed PandaDoc iFrame, for example, Opportunity, Account, Quote, or Contact
2. Click +Add entity to set up data flow for your custom entity
3. Each entity has its own list of fields that can be sent to PandaDoc. Select an entity you would like to configure, e.g. Opportunity
4. On the left, check the box next to each field you want to pass, it will be added to the variables/tokens list on the right. Then click on the green button Save mapping.

Now, add variables/tokens to your template. 

1. Go to a Microsoft Dynamics entity, find the PandaDoc panel, click the gear icon, then Variables, and copy a variable name with the square brackets
2. Open your PandaDoc template and add the variable on the template.

Passing information from Microsoft Dynamics into PandaDoc (via fields)

You can pass data into PandaDoc fields similarly to how variables operate. Unlike with variables, however, you don’t need to include square brackets.

In the list of tokens, copy the token without square brackets into Merge field.

Once the document has been sent, the recipient will see the pre-filled data and be able to update this field, provided the field has been assigned to them.

Send product information from an Opportunity or a Quote to a pricing table 

To do this, add a pricing table to your template by clicking on the block at the right panel. The Data merge will be automatically enabled.

If you have a pricing table in your template and it doesn’t have blue placeholders for column mapping, you can access the data merge either in pricing table properties on the right or below the pricing table by selecting +Product > Set up data merge from CRM/API. Finally, click Enable.

When you create a document from Microsoft Dynamics CRM (Opportunity or Quote) using this template, product information will be sent to the document (Item name, Description, Price, Discount, Tax, Currency, SKU, Quantity, and custom fields.)

To display custom product fields, click the plus sign on the right side of the pricing table and select your custom product fields under Add Hidden.

Send product information from Microsoft Dynamics to quote builder

You can send product information from a quote or an opportunity in Microsoft Dynamics. To do this, add the quote builder block to your template first, then create a document from a quote or an opportunity in Microsoft Dynamics. 

Once you create a document using this template, the product information (item name, description, price, discount, tax, currency, SKU, quantity, and custom fields) will be sent to the quote block. 

To unhide custom fields in the created document click on the quote builder block > select Edit quote on the floating panel, select Add column at the top right of a section > and select your custom column from the dropdown under “Show hidden”.  

Sending and Tracking your documents

1. Open your entity, go to the PandaDoc module, then click Create new document
2. Choose a template or select the templates you’d like to bundle, then select Add items and assign recipients to roles, if applicable
3. Go back to the record > PandaDoc module and review your document status there.