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

Creating a sales Invoice from POS sales (external system to BC) then imported to BC

(1) ShareShare
ReportReport
Posted on by 231
My company uses BC just for accounting and we are not utilizing most functions because of the accounting system and the fact that our POS(Point of Sale) is not Microsoft based.
We have 300 retail stores that we do not have visibility on the inventory thus we cannot use BC's planning functions.
We have a centralized DC (Distribution Center) and all the purchases are routed through here then shipped to individual stores.
 
Moving forward I am recommending that we treat each store as a location instead of customer.
Soo when we want to move inventory we can just Transfer Order to the store.
 
With this we will have visibility of how much inventory each store has.
How we take/ consume the inventory once a sale is created on the POS system is through importing a sales Invoice with the breakdown of the stores sales at end of day.
 
Now how do we go about importing that sales invoice/ sales data into BC?
 
I have the same question (0)
  • Verified answer
    YUN ZHU Profile Picture
    95,331 Super User 2025 Season 2 on at
    Hi, generally, it is connected through API.
    This can also be done through Power Automate, but it is also through the API. Here is a simple example.
     
     
    Of course, you can also import manually, such as through Excel.
    Microsoft Dynamics 365 Business Central: How to use Excel Buffer to Import data
    Microsoft Dynamics 365 Business Central: How to use Excel Buffer to Export data
     
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    BryLearnsBC Profile Picture
    231 on at
    Thank you. This answers most of my questions.
     
    Now we have 300 stores and the deployment of the POS for each might be different, like some cloud, some on premise, and each one of them might be hosting their data individually in a SQL db.
     
    How will the API interact with 300 SQL instances?
     
    Or a data warehouse to compile all 300 store sales then API the sales into BC?

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