Web Service for Multi-Company Replenishment

In this article

To set up the web service connection between multiple companies

To publish Replenishment web services

Replenishment Item Quantity web service settings

See also

For organizations with multiple legal entities residing in several databases, to consolidate the Replenishment Item Quantity data into a single data warehouse (the central supply chain company), you will need to configure the web service for the central supply chain company to copy the pre-calculated Replenishment Item Quantity data from the sales companies. Web service connection will need to be set up in the central supply chain company, so that it can connect directly to the sales companies. On the other hand, the web service responsible for retrieving the calculated Replenishment Item Quantity data will need to be published in the sales companies.

To set up the web service connection between multiple companies

In the central supply chain company, for a location belonging to the sales company and residing in a separate database, some setup needs to be done in the Location Card and the Distribution Location Card.

  1. Click the icon, enter Locations, and select the relevant link.
  2. Create a new location or edit an existing one.
  3. In the Replenishment FastTab, select Other Database in the Data Source field.
  4. Under the Multi-Company Replenishment group, fill in the Distribution Location Code that belongs to the sales company. The Distribution Location defines the web service connection to the sales company's database.
  5. Click the icon, enter Distribution Location List, and select the relevant link.
  6. Open the existing Distribution Location Card by selecting the code that you have assigned in step 4.
  7. In the Replication FastTab, fill in the name of the sales company in the Company Name field.
  8. For Business Central on-premises, in the Web Server FastTab, to generate the Web Service URI value, appropriately fill in the following fields:
    9. Field Description
    Web Server Computer Name This field specifies the full device name of the sales company.
    Web Server Port This field specifies the web server port of the sales company. Example: 9047
    Web Server Name This field specifies the database name of the sales company.
  9. For Business Central SaaS, in the Web Server FastTab, to generate the Web Service URI value, select the Web SSL and Web Server SaaS check boxes and then appropriately fill in the following fields:
    10. Field Description
    Web Server Computer Name This field specifies the full device name of the sales company.
    Web Server Version This field specifies the web server version of the sales company. Example: v2.0
    Web Server Tenant This field specifies the SaaS tenant in which the sales company resides.
    Web Service Environment Name This field specifies the name of the production environment where the sales company resides.
  10. Fill in the login credentials for the web service, if needed.

Tip: You can test the LS Central web service by clicking the Test Web Connection action.

To publish Replenishment web services

For the central supply chain company to be able to copy the pre-calculated Replenishment Item Quantity data from the sales companies residing in another database, the web service to retrieve the calculated Replenishment Item Quantity data will need to be published in the sales companies.

In the sales company:

  1. Click the icon, enter Web Service Setup, and select the relevant link.
  2. In the General FastTab, activate the Web Service is Active field.
  3. For Business Central on-premises, in the Server FastTab, to generate the Web Service URI value, appropriately fill in the following fields:
    4. Field Description
    Server Computer Name This field specifies the full device name of the sales company.
    Company Name This field specifies the name of the sales company.
    Service Name This field specifies the database name of the sales company.
    Server Port This field specifies the web server port of the sales company. Example: 9047
  4. For Business Central SaaS, in the Server FastTab, to generate the Web Service URI value, select the SSL and SaaS check boxes and then appropriately fill in the following fields:
    5. Field Description
    Server Computer Name This field specifies the full device name of the sales company.
    Version This field specifies the web server version of the sales company. Example: v2.0
    Company Name This field specifies the name of the sales company.
    Tenant This field specifies the SaaS tenant in which the sales company resides.
    Environment Name This field specifies the name of the production environment that the sales company resides.
  5. In the Client Credentials FastTab, fill in the login credentials for the web service, if needed.
  6. Click the Web Requests 2.0 action to open Web Requests 2.0 page.
  7. In the Web Requests 2.0 page, click Related - Request and then select the Publish Replen. Web Services action in the menu to publish the Replenishment web services.
  8. Upon successful publishing, you should see the web service ReplenWebSevices (with codeunit 10012406 LSC Replen. Request Mgt) in the Web Services page.

Replenishment Item Quantity web service settings

In the central supply chain company, before we start copying the pre-calculated Replenishment Item Quantity data from the sales companies, there are specific parameters for the web service which need to be set up to determine the maximum number of records that will be retrieved per web service call, and also the number of connection retry.

In the central supply chain company:

  1. Click the icon, enter Replen. Setup, and select the relevant link.
  2. In the Integration FastTab, under the Multi-Company Replenishment group, fill in the relevant fields:
    3. Field Description
    Max No. of RIQ per WS Request This field specifies the maximum number of Replenishment Item Quantity records to retrieve per web service request. The default value for this field is 10,000 if you leave it as 0.
    No. of WS Request Attempts This field specifies the number of connection retry in case of web service connection failure, before logging the affected Replenishment Item Quantity data into the Replen. Item Quantity WS Failure Logs. Setting it as 0 indicates there will be no connection retry.

See also

Replen. Item Quantity Web Service Failure Logs