Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Business Central SaaS integration with on-prem environment or with SharePoint

(0) ShareShare
ReportReport
Posted on by 5

Hi,

We are finalizing our setup with Business Central SaaS, but have other internal warehouse management software that we use to match purchase invoices to our bookings and also for creating sales invoices. Sales invoice image is created on our on-prem folder and this image should be available for Business Central. How could this be achieved? We have API integration to put header and line text-level information to BC, but how about the actual image files? I know there is Attachment API available, but are there any other possibilities? Could we for example use SharePoint? Save the file from WMS to SharePoint-folder and BC could access the invoice image from there? That way no files would have to be moved, only link to the file.

Also as for our purchase invoices, we have an operator who uploads our purchase invoices to our FTP. From there they are uploaded to BC via ExFlow (finvoice transformation tool). The purchase invoice is then forwarded from BC to our WMS for matching adn approval. If we use attachment API to forward the actual pdf-image, it would grow amount of storage eventually needed as the files are stored on multiple locations.  

So therefore i am wondering how would be the best way to integrate SaaS version with our on-prem environment? SharePoint would be one possibility, but there is not much information available.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Business Central SaaS integration with on-prem environment or with SharePoint

    Absolutely yes. Azure Files is suitable if you need a real file system in the cloud and you can also map this online container as a shared local drive for your users.

    Integration with D365BC is the same as using Blob Storage. You can use REST APIs or (solution that I suggest and that we use in production on different customers) call an Azure Function from BC that takes the file stream and uploads it into file share.

  • miva Profile Picture
    miva 5 on at
    RE: Business Central SaaS integration with on-prem environment or with SharePoint

    Hi. Azure cloud storage is a solutions that i would like to use. But i don't think that Blob Storage is exactly meant for this as there is gonna be thousands of small files. I was actually thinking about Azure Files. It would also use cloud storage and it is easily integrable to our on-prem environment and ftp-usage. But is it integrable with Business Central?

    Has anybody integrated Azure Files with business Central? how could it be done?

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Business Central SaaS integration with on-prem environment or with SharePoint

    Why not use Azure Blob Storage, save the files on it and then in BC just saving the URLs of that files? Cheaper and efficient way...

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Business Central SaaS integration with on-prem environment or with SharePoint

    Hello,

    Sharepoint integration can be enabled from within Business Central. There may be third party extension on App Source that can meet business requirements you are looking for.

    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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans