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

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

    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.

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

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

  • miva Profile Picture
    5 on at

    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
    37,166 Most Valuable Professional on at

    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.

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans