Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : lX2hMaSrjySG9KVuiaQNfl
Finance | Project Operations, Human Resources, ...
Suggested answer

D365 on-prem document management setup and migration

Like (0) ShareShare
ReportReport
Posted on 17 Mar 2020 21:07:46 by

Hello,

I have a couple questions regarding document management/attachments on a D365 F&O on-prem implementation:

  1. In Organization Administration -> Document Types, when setting the Location to Database for any Group type, I get an error saying "The database is not a supported storage location for files. Use a different location". What is database location used for if it doesn't work with any group type?
  2. When setting the location to "Azure storage" in an on-prem implementation, where are the physical files actually being stored since there is no cloud storage involved in our on-prem implemention? If we look into the ACCESSINFORMATION field of the DocuValue table, the data looks like that 127.0.0.1:10000/.../2BC8912E-3D72-442F-8DD6-22088F8EAA90 but the URL isn't accessible directly through a browser. Can you please explain where is the actual file stored?
  3. How can we store files on disk in a specific folder? The 3 possible locations are Azure Storage, Database, and SharePoint only.
  4. What is the best practice for migrating documents/files into D365 F&O? If you refer to Microsoft's document configuration page (https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/organization-administration/configure-document-management#frequently-asked-questions), the last question under FAQ is about exporting documents/files. It states that we can check out the Attachment data entity in AOT as an example but this data entity is nonexistent on my environment. I have downloaded a pre-configured D365 VM from LCS.  

Any help on this topic is highly appreciated.

Thanks

  • zhifeng Profile Picture
    on 20 Mar 2020 at 05:50:05
    RE: D365 on-prem document management setup and migration

    You may need to review code logic behind or customization to migrate these files. But normally we don't migrate history records to D365F&O.

  • Goloknath Profile Picture
    on 18 Mar 2020 at 10:14:08
    RE: D365 on-prem document management setup and migration

    The migrate files button is just a button without any associated configuration or setup. Can you please explain how it works? How does it know the source and destination of the documents? In our case, we have an in house built database with the documents that we need to migrate to D365 F&O. How will the Migrate map our in house database with D365 document management?

  • zhifeng Profile Picture
    on 18 Mar 2020 at 09:35:41
    RE: D365 on-prem document management setup and migration

    You can also refer below thread if you upgrade from AX2012:community.dynamics.com/.../how-to-move-attached-files-from-2012-to-d365

  • zhifeng Profile Picture
    on 18 Mar 2020 at 09:33:47
    RE: D365 on-prem document management setup and migration

    Document management

    If you use document management, existing documents or attachments that are stored in the database should be migrated to Microsoft Azure Blob storage. To complete this migration, use the Migrate files button on the Migrate files tab on the Document management parameters page. This operation is not critical as document management can still access file stored in the database, but the files can take considerable database storage and the retrieval is less efficient. The file migration process will migrate all possible database files to Microsoft Azure Blob storage, reporting on any failures and continuing. If any errors are reported, attempt running the file migration process again.

    If the file migration process isn’t able to complete without failure, this may be that the files stored in the database are corrupt, which Microsoft is unable to repair. If this is the case, you can request a non-business critical support case be opened to enable conversion of the attachments into note records, which will retain any previous notes as well as the names of the files that were stored in the database. Note that the files themselves cannot be recovered.

    docs.microsoft.com/.../app-validation-process

  • WillWU Profile Picture
    22,352 on 18 Mar 2020 at 09:31:56
    RE: D365 on-prem document management setup and migration

    Hi George,

    You can upload files to D365FO:

    docs.microsoft.com/.../file-upload-control

    After uploading a file using file control, the file will be uploaded to the Blob and you can use a URL to get the file stream.

    Hope this helps.

  • Goloknath Profile Picture
    on 18 Mar 2020 at 09:19:58
    RE: D365 on-prem document management setup and migration

    Thank you Kevin

    I believe this answers my first 3 questions. What about data migration? How can we migrate data to a shared data storage location? Can data entities be used?

  • Suggested answer
    zhifeng Profile Picture
    on 18 Mar 2020 at 01:31:54
    RE: D365 on-prem document management setup and migration

    12. Set up file storage

    You must set up the following SMB 3.0 file shares:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,727 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,716 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete