NAV Web Service Setup (General Journal)
Gorilla Expense integrates with NAV using web services provided by NAV. The first step is to create the “General Journal” web service in NAV. Web service setup can be accessed in NAV by going to Administration - > General - > Web Services. (And under Administration -> IT Administration->Services -> Web Services for NAV 2016)
Create a new service, by selecting Object Type as “Page” and Object Id as “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, go to the following URL and ensure the page loads up. Replace <Company_Name> with the name of company catalog name in NAV and replace localhost with the IP address of the NAV server. This URL will be used within Gorilla Expense Integration Manager to connect to NAV.
http://localhost:7047/DynamicsNAV/WS/<Company_Name>/Page/GLEntry
On opening on the URL in web browser, the following page should show up –
If the URL does not open, please check if the default port 7047 is changed in your environment and/or also restart “Microsoft Dynamics NAV Server” Service, by going to Administrative tools ->Services
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 NAV radio button on 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
Once logged in, select File - > Export Expense Reports. All the expenses available for exporting to NAV (Manager Approved Expenses) will show up (if any). Click on settings button available on the right top corner – a new window called “NAV 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 NAV Connection URL mentioned in the NAV Web Service Setup section -
http://localhost:7047/DynamicsNAV/WS/<Company_Name>/Page/GLEntry
Uncheck the “Post To Purchase Invoice” checkbox and if applicable, map the desired dimensions after consulting with Gorilla Expense team. You need not enter the user/password information. You have to make sure the user using Integration App is setup in NAV as Super Accounting User using the users Windows ID (Not NAV ID). Enter the desired batch name under with transactions will be posted within NAV and the click save. Once the settings are saved, you can are ready to push expenses to NAV. Before pushing expenses to NAV, ensure the batch name exists in NAV – On instructions on creating a batch in NAV, please refer to the next section
Creating a Batch in NAV
Go to Departments - > Financial Management - > General Ledger - > General Journals 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 NAV
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”