Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

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

Posted on by 11
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?
 
  • Suggested answer
    BryLearnsBC Profile Picture
    BryLearnsBC 11 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 64,237 Super User 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans