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

Announcements

News and Announcements icon
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
    102,608 Super User 2026 Season 1 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 580 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 480 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 261 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans