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

Community site session details

Session Id :
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
I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,307 Super User 2025 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

  • 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.

  • 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!

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 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

  • 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.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans