Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Creating a sales Invoi...
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 BryLearnsBC 120
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?
 
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
  • Suggested answer
    BryLearnsBC Profile Picture
    BryLearnsBC 120 on at
    Creating a sales Invoice from POS sales (external system to BC) then imported to BC
    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?
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 81,910 Super User 2025 Season 1 on at
    Creating a sales Invoice from POS sales (external system to BC) then imported to BC
    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

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,349 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,029 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans