Thursday, October 15, 2020

What are Distribution Location? Microsoft Dynamics LS Central/LS Retail



Distribution Locations

This blog i am writing, remembering the time when i commenced the learning of LS Central(Earlier LS Retail). First question which popped in my mind was what are distribution locations and how are the different from the Normal Navision/Business central locations? 

LS Retail/LS Central has distributed architecture, it means one company who is using the LS Central/LS Retail may have more than 1 database depending on the number of stores they have. Let us take example that there is Fashion Store which sells items like Fashion accessories, Fashion clothes, Shoes etc. 

Company Name:- Fashion House LLC.

Number of Fashion Stores:- 2

No of Head Office:- 1

Fashion House LLC wants to implement the LS Central as the ERP system for their company. Fashion House LLC are into retail operations. In Order to implement the LS Central they need to have in total 3 databases. 

Store 1:- Store 1 DB

Store 2:- Store 2 DB

Head Office:- HO DB

Distributed Architecture looks like below



If you refer to the above figure you would understand that data needs to be transferred between different databases. In Order to know the details of the Databases, their IP address etc are defined in the distribution locations in HO database. Distribution Location holds the database name, company name, IP address and user ID, pwassword where data transfer would happen.

Refer to the below screen shot of the distribution location in the business central


 

Conclusion

Distribution locations is nothing but the place where we define the Company name, Database name, User ID and password to exchange data with store or Head office.

LS Central Website says:- https://help.lscentral.lsretail.com/Content/Fields/T_99001512.htm

 

Kindly leave comment and subscribe


Regards

Sameer Virmani

 

Posted by at

5 comments:

  1. FarhanOctober 21, 2020 at 7:15 PM

    Really Helpful. I have a question. In your example there are three databases HO, Store1 and Store2. Do we need to define distribution locations on all databases or only on HO level.

    ReplyDelete
    Replies
    1. Sameer VirmaniOctober 30, 2020 at 11:48 PM

      It depends where Data Pull and data push is happening, Distribution location should be provided on the HO DB for all the Store locations as well as HO. HO database will pull records from the Store DB and push master data to Store DB. I hope this answer your question.

      Delete
  2. FarhanOctober 21, 2020 at 7:19 PM

    Second, if I have four databases which are STORE-01, STORE-02, STORE-03 and HO. Then Do I need to open all stores on all Transaction databases or All stores on HO Level and single store on Transaction database level. Please help. Thanks in advance.

    ReplyDelete
    Replies
    1. Sameer VirmaniOctober 30, 2020 at 11:49 PM

      Store DB can have only one store but two store code cannnot have same store code. HO will have all the store code

      Delete
  3. Enabling no stock posting fieldJune 30, 2022 at 1:59 AM

    Actually i configured a distribution location on a pos (offline pos) and i tested the connection and it worked successfully, but when i added the same distribution location of this pos into the ho database, i got an error when i tested the connect, (Cannot connect to initial catalog.......etc)
    could u help?

    ReplyDelete

Subscribe to: Post Comments (Atom)