Dynamics 365 Web Service Setup (General Journal)
Publish GL Entry Web Service
Gorilla Expense integrates with DYNAMICS 365 using web services provided by Dynamics 365. The first step is to create the “General Journal” web service in Dynamics 365. Web service setup can be accessed in Dynamics 365 by going to Search by clicking on the square (as per the screenshot) - > Search - > Web Services.
Create a new service, by selecting Object Type as “Page” and Object Id as “39 General Journal” -
Make sure the new web service is called GLEntry and published checkbox is checked as shown below –
Once the above steps are completed, copy the URL from the field called “SOAP URL”. And provide it to Gorilla Expense team. Repeat this on for all companies. Example SOAP URL will look like mentioned below
On opening on the URL in a web browser, the following page should show up.
Enter your web service credentials. Refer the link here to find how you can get your Web Service Credentials. Upon entering the credentials, verify that this page opens on all PCs (in Accounts Payable department) that will be used to export expense reports to Dynamics 365 using Integration Manager 
Web Service Credentials
When you try to open the above URL, it will ask you to enter credentials. Here is how you find the credentials –
- Go to Users -> open your user card
- Generate Web Service Keys by clicking on the three dots shown below
- Set the key expiration as per your company policy. In this case, we have set it to not expire.
- Click OK. A key will be generated and placed in the Web Service Key field shown in step 1. Copy it - This will be your password. Copy the username from the username field shown in step 1.
Gorilla Expense Integration Manager Setup
Download and install Integration Manager from the following URL –
https://www.gorillaexpense.info/install/publish.htm
Once installed, select MS Dynamics 365 from the Type dropdown in the top section on the login page and login using Gorilla Expense Admin username and password. Enter the following URL of Gorilla Expense Service in the Login URL field. For non-USA based customers, this value can be found in the Admin Application Access Instructions Document (Integration App Section) provided to you after the Gorilla Expense setup is completed.
https://www.gorillaexpense.info/Gorillapro/service (This link will not open in the browser and that is OK)
Once logged in, select File - > Export Expense Reports. All the expenses available for exporting to Dynamics 365 (Manager Approved Expenses) will show up (if any). Click on settings button available on the right top corner – a new window called “Dynamics 365 Mappings” shows up. On this window, you can define what fields are to be mapped to the GL Entry Description field. Also, on this screen you have to enter the Dynamics 365 Connection URL mentioned in the Dynamics 365 Web Service Setup section -
Customers with multiple company databases - If you check the “Get Connection URL from Company Profile”, then it is not required to enter the above URL on the “NAV Mappings” screen, but you will instead have to login to the web application and enter it on the company master (Masters->Company) when logged in as admin – if you have provided the URL to Gorilla Expense team, they will take care of this for you. This provision is provided especially for customers who have multiple Dynamics 365 company databases. However, this setting can be used for single Dynamics 365 DB as well.
Uncheck the “Post To Purchase Invoice” checkbox and if applicable, map the desired dimensions after consulting with the Gorilla Expense team. You need to enter the Dynamics BC user/password information – refer to the “Web Service Credentials” section for your username and password. Check the radio button ‘Dynamics 365’ and radio button ‘SOAP’ in the Integration Type section. Enter the desired batch name under with transactions that will be posted within Dynamics 365 and then click Save. Once the settings are saved, you can are ready to push expenses to Dynamics 365. Before pushing expenses to Dynamics 365, ensure the batch name exists in Dynamics 365 – On instructions on creating a batch in Dynamics 365, please refer to the next section
Creating a Batch in DYNAMICS 365
Go to Search by clicking on the square (as per the screenshot) - > Search General Journals - > In Batch Name click on the selection as marked in the following screenshot -> Click on New and create a new batch called GORILLA as shown below –
Vendor Setup - Typical Errors
- Vendor XYZ does not exist – Make sure the vendor exists in Dynamics 365
- There is no Currency Exchange Rate within the filter – On the vendor card, please make sure the currency code field under “Foreign” tab is empty. Also, make sure the posting date field under “Payables Setup” is set to “Work Day”