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... / BC ONPREMISE : Where I...
Small and medium business | Business Central, N...
Suggested answer

BC ONPREMISE : Where Images, PDF... attachment files are stored

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I would like to know, on Business Central V14 On Premise, where the attached files (pictures, pdf...) are stored for a document or an item, a customer...?

And if we can choose if we want to save the attached documents (maybe I must say incoming document) in the data base or on another storage area (on the server, on a sharepoint...) ?

I'm not talking about SaaS version. My question is for On Premise. 

Can you help me please ?

Thanks

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 408 on at
    RE: BC ONPREMISE : Where Images, PDF... attachment files are stored

    Hi,

    You have asked about multiple things together. I will try to share what I know.

    Display Pictures:

    To keep Display Pictures of Items, Customers and Vendors etc. Media Set table is used that then keeps them in Media table in BLOB.

    Attachments:

    To attach different files i.e. images, pdfs etc. on Customers, Vendors, Sales/Purchase Documents etc. Document Attachment table is used which also keep that file in binary format in Media table.

    The options we discussed above both store data inside Business Central.

    Links:

    If you want to only store the link of file then you can use Link action available on all Document and card pages. Here you can store the link of files that is actually placed outside of Business Central.

    Incoming Documents:

    Incoming Document is completely different. It is used to import documents, scanned images, pdf etc. and then convert them to Business Central Documents using OCR service. Incoming Document is attached to the document that is created inside Business Central using it.

  • Community Member Profile Picture
    Community Member on at
    RE: BC ONPREMISE : Where Images, PDF... attachment files are stored

    Thanks a lot Bilal.

    I'll try to precise what I've understand and what I want.

    Since BC (maybe before), images are no longer saved in a blob in the principal table for items, customers, vendors... but now it's stored in a BLOB in Media table (2000000181) and the link with the principal table is stored in "Media Set" table.

    And this is the same concept on "Attachments" for the documents (quotes, order...) but with a link on the table 1173 (Document Attachment) that link the Media table to store the file in a blob.

    What I want : I want that no users could save pictures or pdf... anywhere (items, customers, quotes, orders, invoices...) if this files are stored in the databases.

    So all of the concept is ok but not for the Media table. I don't want to store the files in a BLOB in this table. I would like to store the files on the disk server or on another storage space (sharepoint...)

    Is it possible ?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: BC ONPREMISE : Where Images, PDF... attachment files are stored

    Hello,

    Looking forward to hear as well if there are third party extensions created that can fulfill this business requirements.

    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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,275

#2
Sumit Singh Profile Picture

Sumit Singh 2,677

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,526

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans