Steps to Set Up SharePoint for Document Management in Dynamics 365 Finance

By Jackie Olson | December 2, 2019

Steps to set up sharepoint for document management in dynamics 365 finance

SharePoint is a valuable resource when it comes to storing, managing, and sharing documents. Follow the steps below to:

  • Successfully set up a SharePoint site specifically for files related to Dynamics 365 Finance
  • Setup Print management for Customer statement to use SharePoint
  • Attach a document to a Sales Order header that will be stored in SharePoint

1) Create a new SharePoint Site (document library) in SharePoint online

2) In D365 Finance, go to Organization administration> Document management> Document management parameters> select SharePoint on the left. Enter your organization’s SharePoint server name –

Note: You will receive an access error if you do you have the proper SharePoint permission. Work with your SharePoint administrator to get access.

3) In document types (Organization admin> Document management> Document types, select File on the left, enter a name under the Name field (eg: File_JackieSP), fill in the rest of the fields like below:

Note: You may create different File types for different SharePoint document libraries. Example above, FILE_AP is using a different SharePoint document site.

Click on edit (pencil icon), next the SharePoint Address field and select the SharePoint site and folder you would like your document saved to.

4) User Options – make sure document handling is enabled

  • Click on the gear icon in your D365 Finance session, on the top right and select User options

  • Select Preferences on the left and under Miscellaneous, make sure Document Handling is set to Yes.

Set Up Print Management for Customer Statement to Use SharePoint:

1) AR > Setup> Form setup, click on Print Management link –

Print Management

2) Select Customer account statement then Original<Default> (or you can right-click and create a new one), click on the left arrow on the Destination field, and select Printer Setup)

Print Management Setup

3) In printer setup, select File on the left, set “Save in print archive” to Yes, give the file a name, set format to PDF.

Print Destination Settings

Note: Save in print archive must be set to Yes here.  Otherwise, the document will not get created in SharePoint. You only the File for the file type option in printer management. If you have created different file types for different SharePoint document libraries, they will not show up here.

To test the above setup, run a statement for customer Contoso – select the customer Contoso from All customers, click on the Collect tab, select Statements in the customer balances group.

The customer statement will show up on screen after it’s been created. You can turn it off by going to Document management parameters, then select File types on the left, then find the document type you are interested in and change the “Natively web Renderable” to No.

Now in your SharePoint site, and you will see the new customer statement pdf file there as well.

Attaching a Document to a Sales Order Header That Will Be Stored in SharePoint

Open a Sales order header then click on the paper clip on the top right.  Note the number on the paper clip indicate the number of documents attached to the sales order header.

At this form, click on New, then select File in the drop-down to attach a document –

Note: You will see the different file types you’ve set up here. So, if you have set up different file types for different SharePoint document libraries, it will be listed in the dropdown (eg. File_AP)

Next, browse to the file you would like attached to this SO header –

Click on Save and close the Form. Now you will see the number 1 on the paper clip.

Finance and Operations

If you navigate to your SharePoint Document library, you will also see the document/file you’ve just attached to your SO header.

 

If you have questions or run into any issues, please reach out to the team at Stoneridge Software for guidance.

 

Related Posts

Recommended Reading:

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X