web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

D365 on-prem document management setup and migration

(0) ShareShare
ReportReport
Posted on 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

I have the same question (0)
  • Suggested answer
    zhifeng Profile Picture
    on at

    12. Set up file storage

    You must set up the following SMB 3.0 file shares:

  • Community Member Profile Picture
    on at

    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?

  • WillWU Profile Picture
    22,361 on at

    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.

  • zhifeng Profile Picture
    on at

    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

  • zhifeng Profile Picture
    on at

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

  • Community Member Profile Picture
    on at

    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 at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 672 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 534 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 289 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans