QuickStart for D365 Finance

This article will detail how to create an integration between Solver and your F&O data using the Solver QuickStart Process. It is required to install the Solver Extension first. For information on this, please review this article.

1. From the landing page, navigate to the Data Warehouse.
2. Open the Data dropdown menu and select Integrations.
3. Click on Add New at the top right corner of the Integrations menu.
4. Select the Dynamics 356 Finance & Operations connector from the marketplace.
   
5. Click on Create QuickStart button to being the QuickStart Process
6. You will first be prompted for your D365 Finance URL. This should be in the format https://<yourURL>.com
   
7. Click Authenticate. A login popup should appear. If this popup does not appear, check to make sure that you have not blocked popups in your browser settings.
8. In the popup that appears, type in the selected account to connect Solver to your F&O installation and the company within your F&O installation. The user that you are using should have these permissions configured within Finance.
   
   
   The Solver QuickStart process will load the last year to the current period of data for the selected company. This is done to achieve a quick data load process. You can change the filters after the QuickStart wizard is complete, described below, to load in multiple companies at once.
9. If the user credentials provided are valid, you will be successfully authenticated and can move to the next screen within QuickStart.
10. The next screen prompts for the data that you’ll want to bring into Solver. Select General Ledger and its respective dimensions and click Continue.
    
11. The next screen is the dimension mapper. Use this screen to create and/or map your selected finance dimensions to dimensions within Solver. You can map to existing dimensions, Solver “standard” dimensions, or create your own dimensions by just typing in a name.
    
12. The next screen is the Account Category mapper. Please map your account categories to the folders within Solver and click Continue.
    
13. Upload budget data from D365 Finance using one of the several options of the version of budget data.
14. The next screen allows you to configure the Job including setting the recurrence of the job and who should get notifications of success and failed data loads.
    
15. The final screen, confirms your configuration and by clicking Run Now, your configuration is saved and QuickStart will execute.
    

Modifying QuickStart for Finance and Operations.

As mentioned above, QuickStart for Finance is initially configured to load the selected company data into Solver. It is simple to update this to load in multiple companies. To make this modification.

1. Find the GL Detail Transactions data load via Data > Integrations and click Edit.
2. Modify step 2, “General Ledger Transactions”.
3. Click on Task Filter and remove the dataAreaId filter. By doing this, this integration will now load all data upon the next data load.
4. Click Save.
5. If you’d like Entity to be a parameter in the job step, this is recommended, allowing users to restrict data loads to select entities, on the Create Parameters menu, drag entity as a parameter and click Continue
6. Click Publish to save your changes.

Limitiatons and Need To Knows

The following are known limitations/restrictions when connecting Solver to your Finance system.

1. The Solver Extension is required and must be installed prior to using Solver within your Finance install. In many scenarios, you will be required to install the extension in the Dev > Sandbox > UAT > Production environments, in this order. Each installation does take some time, please coordinate with your Finance application administrator.
2. Solver’s QuickStart utilizes your OData service. Performance is based off the number of transactions that you have in your Finance system and the infrastructure you have allocated to the OData service on the finance side.
   
   For customers integrating more than 5 companies into Solver, it is recommended to reach out to your Partner or Solver consulting services (pmo@solverglobal.com) to discuss best practices on implementing Solver.