The Zetadocs Expenses service communicates with Business Central directly using a public web address (URL). This is typically used with a hosted system where it is not possible to install the Zetadocs Expenses Connector.
Use the Zetadocs Expenses Extension Direct Access to connect Zetadocs Expenses to Microsoft Dynamics 365 Business Central when deployed on-premises or privately hosted. Download the latest version of the Zetadocs Connector for Business Central and NAV from the Equisys website and then follow the steps below:
This section covers;- Registration Installation ▪Publishing the Extension app file ▪Running the Zetadocs Expenses Assisted Setup ▪Enabling access to the Web Services ▪Testing the Zetadocs Expenses Web Service Configuration ▪Setting up your Zetadocs Expenses Account Testing |
When you request a Zetadocs Expenses account for your company you will be sent an Account Registration email from the Zetadocs Expenses team. This email contains a Complete Registration link; it is used to activate your Account and allow you to access the system and complete the remaining setup steps.
This email will be sent from approvals@noreply.mail.zetadocs.com. Should you not receive your registration email as expected, please check your spam filter settings before raising a support request. This email address will also be used to send approval request notifications and reminders, as such it should be added to your list of safe or trusted senders to ensure that users throughout your organization receive Zetadocs Expenses emails.
Completing the registration requires the selection of some key account settings which cannot be changed later. If you are unsure of any of these settings then it is advised that you wait for the Zetadocs team member to assist you in this setup step.
1.Open the email and select the COMPLETE REGISTRATION button.
2.You will be taken to the Zetadocs Expenses site where you need to enter details about your account as well as your First and Last Names and chosen password. It is important to check the Account Name and email address fields before clicking REGISTER.
3.This will complete your account registration and display a confirmation screen which contains the Secure Connection Credentials for your Account. These should be copied to a safe location as they will be required to establish the connection between Zetadocs Expenses and your internal systems.
1.Internet facing web services have been configured with a genuine certificate issued by a Certificate Authority.
Note: Self-signed certificates are not supported by Zetadocs Expenses |
2.Firewall settings that allow SOAP port (typically 7047) calls through to Business Central web services unrestricted.
3.DNS entries have been created for the fully qualified domain name (FQDN) that corresponds to the server certificate name e.g. https://bcserver.domain.com
1.Ensure you locate the correct version of the [Zetadocs Expenses Extension] .app file for your version of Business Central from your product download.
2.Use the below script in Business Central Administration Shell (update the values in bold below to match your server instance and the Zetadocs Expenses Extension for your version of Business Central).
Publish-NavApp -serverInstance BC140 -path 'Equisys_Zetadocs Expenses_1.2.20319.14000_runtime.app' -skipVerification -packageType Extension
1.Go to the Extension Management page in the Business Central web client.
2.Select “Zetadocs Expenses” and click on Install.
3.Click Next and select the relevant language.
4.Accept the terms and conditions and click on Install.
1.Go to Assisted Setup in the Business Central web client.
2.Follow the "Set up Zetadocs Expenses connection" Assisted Setup to publish the web service.
3.Take a note of the web service URL.
1.Go to Users and select a user with SUPER permissions.
2.Click on the three dots of the Web Service Access Key, then “Yes”. Tick the Key Never Expires box and then click on OK.
3.Copy the Web Service Access Key.
1.Test access to the web service by opening the web service URL in a browser on a PC outside your internal network and entering the relevant Business Central user name and the web service key e.g.
https://<your_internet_facing_domain>/WS/CRONUS%20UK%20Ltd./Codeunit/ZetadocsExpenses
<YOUR_DOMAIN>\<WEBSERVICE_USER>
<WEB_SERVICE_KEY>
2.If successful, you will be shown a full page of XML data prefixed with the following message;-
“This XML file does not appear to have any style information associated with it. The document tree is shown below…..”
3.If not, then please reconfirm the Direct access pre-requisites at the beginning of this topic are true and confirm you are entering the access credentials in the format above before continuing.
Sign in to the Zetadocs Expenses website using your Zetadocs account details.
1.Choose the Integration option (top headings)
2.Set the following values;-
Field |
Value |
---|---|
ERP Integration |
Enabled |
ERP System Type |
Dynamics 365 Business Central / NAV |
Report Export |
Automatic |
Export Description Format |
Automatic |
3.Choose Save
1.Choose the Companies option (top headings)
2.Manage Companies via the icon located to the right of the list.
3.Configure the Connection section as follows;-
Field |
Value |
---|---|
System Type |
Business Central on-premises. |
Database Type |
Set to geographical location. |
Integration Method |
Extension direct access |
Web Service URL |
Zetadocs Expenses public web service address used to communicate with Business Central, ensuring https and FQDN is amended to the start of the one you copied after the Assisted Setup e.g. https://bcserver.domain.com:7047/BC140/WS/CRONUS%20UK%20Ltd./Codeunit/ZetadocsExpenses |
Web Service User Name |
The Business Central user enabling access to the Expenses web service. e.g. DOMAIN\ZetadocsConnector |
Web Service Access Key |
Web service access key for the Business Central user above. e.g. rEkv+s82fd/b8dfAk+xyqGNhXfMTz2m2b/vL7L6Y/NI= |
Custom Export Extensions |
Plus Edition only – Controls the export customizations installed on your system. |
4.Choose Save
1.Set up export codes for one of each of the below Zetadocs Expenses Settings tabs. Entry of additional export codes can be done after the testing has been completed.
oUsers > Manage (right pointing arrow to the far right) > Export Settings > Export Code (matching a Business Central Vendor number for the user account)
oExpense Types > Airfare > Manage >
▪Details > Export Description
▪Export Settings > Export Code (matching a relevant Business Central G/L account)
oSales Tax > Add New Rate button > Standard Rate (matching Business Central Sales Tax setup)
Field |
Value |
---|---|
TAX Business Posting Group UK |
e.g. DOMESTIC |
TAX Product Posting Group UK |
e.g. STANDARD and ZERO |
TAX Group Code US/CA |
e.g. NONTAXABLE |
TAX Area Code US/CA |
e.g. ATLANTA, GA/AB |
oSales Tax > Add New Rate button > Zero Rate
Field |
Value |
Zero Rate VAT Business Posting Group |
e.g. DOMESTIC |
Zero Rate VAT Product Posting Group |
e.g. ZERO |
You have now completed the base configuration required to test the Business Central integration.
1.Sign in to Zetadocs Expenses https://expenses.zetadocs.com using the Administrator user account.
2.Create a new expense ( Home page > New Expense tile) using the ‘Airfare’ Expense Type you modified earlier.
3.Create a new report ( Home page > New Report) and attach the expense you have created by choosing .
4.Submit the Expense Report, setting the Approver and Processor to the Administrator user account.
5.Choose the Tasks button and change Tasks to do to All of my tasks.
6.Open the expense report and approve it. You may need to refresh the page to see the new task.
7.Wait until the status of the Expense Report changes to Submitted then re-open it and click the Approve button again to finalize the Approval / Processed stage. Again, refreshing the page will speed up the testing.
8.Choose the Status button then click the ‘Tap here to retrieve submitted Reports’.
9.Place a tick to the left of the approved report, choose the action menu, then choose Export.
10.Wait until the status of the Expense Report changes to Done, or click the action menu and select Refresh.
11.The report status should show as ‘Done’. If not, any export errors will be logged in the History section of the View Export Report page and will highlight the nature of the export error.
12.Sign in to Business Central to verify a Purchase Invoice has been created matching your Zetadocs Expenses data.
You can now return to System Settings https://expenses.zetadocs.com/Settings to configure the rest of your Zetadocs Expenses Export Codes.
Quick start training materials for Zetadocs Expenses users can be found here: https://www.equisys.com/help/zetadocs/zetadocs-expenses/videos