Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Where attached files a...
Small and medium business | Business Central, N...
Answered

Where attached files are stored in Business Central Online?

(0) ShareShare
ReportReport
Posted on by yohi2020 245

Hi,

Regarding attached file in Sales/Purchase documents in Business Central, I have some questions.

  1. Where the files are stored in Business Central?
  2. Can I get/post the attached file directly, not in Sales/Purchase documents?
  3. Is it possible not to delete the attached files with AL coding?
  4. I want to update the attached files when I upload the same name files in the document. The file contents and its attributed information, such as upload user name, timestamps, etc. are updated.

I want to use the attached files as proof documents for Sales and Purchase document creation. 

Thank you

Categories:
Dynamics 365 Business Central
  • kevinrhee Profile Picture
    kevinrhee 15 on at
    RE: Where attached files are stored in Business Central Online?

    I'd also like to know if Power Automate can do this.  I've been frustrated trying to get this to work with Document Attachments 1173.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Where attached files are stored in Business Central Online?

    Hi yohi

    Thanks for sharing more info. My suggestion is that look into 3rd party app or to utilize SharePoint or Azure for that. This way you will have

    1) More storage space and you will not use your database storage.

    2) You will have more control over deleting

    3) Even you will have more control over who sees what document.

    We use the following app which has some cool functionality. This is just to give you an idea. But you can do many of these through development.

    appsource.microsoft.com/.../PUBID.efoqus-5058796|AID.sharepoint|PAPPID.23ebd065-b289-4a68-85e3-b8410e360157

  • yohi2020 Profile Picture
    yohi2020 245 on at
    RE: Where attached files are stored in Business Central Online?

    Thank you, ZHU!

    The link is very understadable.

    I am not sure if Power Automate can get the attached files from Business Central.

    Is it possible to get attached files from Business Central by Power Automate/Apps?

    Thanks!

  • yohi2020 Profile Picture
    yohi2020 245 on at
    RE: Where attached files are stored in Business Central Online?

    Thank you MahGah,

    The business requirement is to prohibit the users delete uploaded documents and to keep those documents in Business Central with historical records: create and update.

    Users can delete the attached documents from posted Sales/Purchase Invoice in standard BC functionality.  I need to stop the users to delete the attached/uploaded documents from Business Central.

    Thank you.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,595 Super User 2024 Season 2 on at
    RE: Where attached files are stored in Business Central Online?

    Hi, Maybe the link below can give you some inspiration.

    https://yzhums.com/11177/

    And if you are concerned about the capacity of the Business Central SaaS, you can refer to the link below.

    https://yzhums.com/15246/

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Where attached files are stored in Business Central Online?

    Hi

    1) Files attached in your database and goes against in your database size. docs.microsoft.com/.../tenant-admin-center-capacity

      a) Of course you can use onedrive as well. See this  https://yzhums.com/17888/

    2) it depends on scenario but in new release it will have more function docs.microsoft.com/.../outlook-add-in-add-attachments-emails-directly-business-central-documents

    3) I do not think this is possible out of box. Unless you make a coding that require specific permission to delete files. Then not assign that permission to developers.

    4) You may need development for that.  

    What is a business need for that? I mean you have document creation date, email log, etc.

    In addition, they are some apps (free) that let you do drag and drop and use Sharepoint storage such https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.insight-works%7CAID.d50afbbf-aff3-4dac-bce7-8686b375b994%7CPAPPID.d50afbbf-aff3-4dac-bce7-8686b375b994?tab=Overview

    appsource.microsoft.com/.../apps

    Thanks

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans