Create and use predictive web service for cash flow forecasts

Completed

You can create your own predictive web service based on a public model named Forecasting Model for Microsoft Dynamics 365 Business Central. This predictive model is available online in the Azure AI Gallery.

To use this model, follow these steps:

  1. Open a browser and go to the Azure AI Gallery.

    Screenshot of the Azure AI Gallery Forecasting Model page.

  2. Search for Forecasting Model for Microsoft Dynamics 365 Business Central, and then open the model in Azure Machine Learning Studio.

    Screenshot of the Forecasting model for Azure machine learning studio.

  3. Use your Microsoft account to sign up for a workspace, and then copy the model.

    Screenshot of the copy experiment gallery page.

    The Forecasting Model for Microsoft Dynamics 365 Business Central should now be available in your workspace.

    Screenshot of the Forecasting Model for Microsoft Dynamics 365 Business Central.

  4. To run the model, select the Run button at the bottom of the screen.

    Screenshot of the Run button used to run the model.

    After the model has been run, the result should look similar to the following image.

    Screenshot of the results after the model has been run.

  5. To save the model, select the Save As button.

    Screenshot of the Save as feature to save the model.

  6. Publish the model as a web service by using the Deploy Web Service button.

    Screenshot of the model web service with deploy web service button.

  7. Select the New Web Services Experience link.

    Screenshot of the new web service experience link.

  8. Select Use endpoint.

    Screenshot of the Use Endpoint option on model page.

  9. Note the API URL and API Key information. You'll use these credentials for a cash flow setup. You'll use the Primary Key and the URL information in the Request-Response fields.

  10. Modify the URL in the Request-Response field to the following format: 'https://ussouthcentral.services.azureml.net/workspaces/xyz/services/xyz/execute?api-version=2.0'

  11. In Business Central, select the Search for page icon, which opens the Tell Me feature, enter Cash Flow Setup, and then select the related link.

  12. Expand the Azure AI FastTab, and then fill in the fields.

    Screenshot of the Azure AI FastTab fields.

  13. In the Accountant Role Center, select the Cash Flow Forecast chart and then select the Recalculate Forecast option.

    Screenshot of the Cash Flow Forecast Recalculate Forecast option.

  14. Select Yes.

The forecast is now recalculated by using your forecasting model for Microsoft Dynamics 365 Business Central.