Zetadocs Expenses Extension with Connector
Use the Zetadocs Expenses Extension with Connector to connect Zetadocs Expenses to Microsoft Dynamics 365 Business Central when deployed on premises. Download the latest version of the Zetadocs Connector for Business Central and NAV from the Equisys website and then follow the steps below:
Registering your Account
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.
Publishing the Extension app file
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
Installing the 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.
Run the Zetadocs Expenses Assisted Setup
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.
Configuring your Zetadocs Expenses account for ERP integration
Sign in to the Zetadocs Expenses website using your Zetadocs account details.
Configure ERP integration
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
Configure your Connector and the Zetadocs Expenses Service
The Zetadocs Expenses service communicates with Business Central using the Zetadocs Expenses Connector, a Windows application which you install on a server computer.
The Zetadocs Connector needs to be setup and running to enable a connection between your Business Central system and the Zetadocs Expenses service. The Zetadocs Connector service can be configured to run as its own user on your network and in Business Central, or the Zetadocs Connecter service can be configured to run as a local service and connect to the Web Service using the Web Service Access Key of a Business Central user.
Zetadocs Expenses supports Windows Authentication or Web Service Access Key Authentication. Choose the authentication method that matches your Business Central setup:
 | Windows authentication - Uses the Windows user account for the Zetadocs Expenses Connector service for Web Service authentication. |
Configure Zetadocs Expenses for use with Business Central.
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
|
Expenses Extension with connector.
|
Connector Connection ID
|
Enter this unique ID in the Zetadocs Expenses Connector Settings configuration tool to enable the connector to communicate with the Zetadocs Expenses service.
|
Web Service URL
|
Zetadocs Expenses internal web service address used to communicate with Business Central.
|
Authentication Method
|
Windows Authentication.
|
Custom Export Extensions
|
Plus Edition only – Controls the export customizations installed on your system.
|
4.Choose Save
Creating a Windows user for the Connector
You need to create a specific Windows user account for the connector to run as. This should be done as per your standard network user generation policy.
Creating a Business Central user for the Connector
1.In the search bar, search for Users and open the Users page. 2.Click the New button and add a User Name and Full Name of Zetadocs Connector. 3.Select the License Type drop down menu and select Limited User. 4.Assign the user SUPER permissions. 5.Next in the Windows Authentication section select the Windows User Name option and select the Windows user account you created above and click OK.
Installing the Connector Components
1.Run ZetadocsExpensesConnector.exe from your product download. This will require administrator privileges. 2.Select Next, accept the end user license agreement and click install. 3.After successfully installing ensure the option to launch the Zetadocs Expenses Connector Settings tool is checked and click Finish.
If for whatever reason the Zetadocs Expenses Connector Settings tool does not open; open the start menu and run Zetadocs Expenses Connector Settings.
Configuring the Connector Connection
Use the Zetadocs Expenses Connector Settings tool allows you to configure your Zetadocs Account settings to enable the export to Business Central.
Edit Account - To edit the default account to match your Zetadocs Expenses account settings, select it from the left-side panel, make the desired alterations to its configuration and finally click the Save button to commit the changes.
Field
|
Value
|
Account ID
|
Enter the Account ID from the Zetadocs System Settings tab.
|
Account Display Name
|
Enter the Account Name from the Zetadocs System Settings tab.
|
Connection ID
|
Enter the Connector Connection ID from the Zetadocs System Settings Company details screen.
|
Connector Service Name
|
The service instance name assigned to the account, typically Zetadocs Expenses Connector (Account ID).
|
Connector Service User Name
|
The Windows User created to run the service instance.
|
Testing the Zetadocs Expenses Web Service
Test access to the web service by opening the web service URL in a browser on a PC inside your internal network e.g.
http://<Server>:<WebServicePort>/<ServerInstance>/WS/<CompanyName>/CodeUnit/ZetadocsExpenses.
Example link: http://localhost:7047/BC140/WS/CRONUS%20UK%20Ltd./Codeunit/ZetadocsExpenses
If successful, you will be shown a 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…..”
If you don’t receive this message, please return to Run the Assisted Setup and confirm you are logged in with a Windows users that will run the Zetadocs Expenses Connector Service before continuing.
|
Creating a Business Central user for the Connector
1.In the search bar, search for Users and open the Users page. 2.Click the New button and add a User Name and Full Name of Zetadocs Connector. 3.Select the License Type drop down menu and select Limited User. 4.Assign the user SUPER permissions. 5.Click on the three dots of the Web Service Access Key, then “Yes”. Tick the Key Never Expires box and then click on OK. 6.Copy the Web Service Access Key.
Installing the Connector Components
1.Run ZetadocsExpensesConnector.exe from your product download. This will require administrator privileges. 2.Select Next, accept the end user license agreement and click install. 3.After successfully installing ensure the option to launch the Zetadocs Expenses Connector Settings tool is checked and click Finish.
If for whatever reason the Zetadocs Expenses Connector Settings tool does not open; open the start menu and run Zetadocs Expenses Connector Settings.
Configuring the Connector Connection
Use the Zetadocs Expenses Connector Settings tool allows you to configure your Zetadocs Account settings to enable the export to Business Central.
1.Edit Account - To edit the default account to match your Zetadocs Expenses account settings, select it from the left-side panel, make the desired alterations to its configuration and finally click the Save button to commit the changes.
Field
|
Value
|
Account ID
|
Enter the Account ID from the Zetadocs System Settings tab.
|
Account Display Name
|
Enter the Account Name from the Zetadocs System Settings tab.
|
Connection ID
|
Enter the Connector Connection ID from the Zetadocs System Settings Company details screen.
|
Connector Service Name
|
The service instance name assigned to the account, typically Zetadocs Expenses Connector (Account ID).
|
Connector Service User Name
|
Service account that will run the service instance.
|
Configure Zetadocs Expenses for use with Business Central.
1.Sign in to the Zetadocs Expenses website using your Microsoft or Zetadocs account details. 2.Choose the Companies option (top headings). 3.Manage Companies via the icon located to the right of the list. 4.Configure the Connection section as follows;-
Field
|
Value
|
System Type
|
Business Central on-premises.
|
Database Type
|
Set to geographical location.
|
Integration Method
|
Expenses Extension with connector.
|
Connector Connection ID
|
Enter this unique ID in the Zetadocs Expenses Connector settings configuration app to enable the connector to communicate with the Zetadocs Expenses service.
|
Web Service URL
|
Zetadocs Expenses internal web service address used to communicate with Business Central.
|
Authentication Method
|
Web Service Access Key.
|
Web Service User Name
|
The Business Central user enabling access to the Expenses web service.
|
Web Service Access Key
|
Web service access key for the Business Central user above.
|
Custom Export Extensions
|
Plus Edition only – Controls the export customizations installed on your system.
|
5.Choose Save
Testing the Zetadocs Expenses Web Service
1.Test access to the web service by opening the web service URL in a browser on a PC inside your internal network and entering the relevant Business Central user name and the web service key e.g. http://<Server>:<WebServicePort>/<ServerInstance>/WS/<CompanyName>/CodeUnit/ZetadocsExpenses.
<YOUR_DOMAIN>\<WEBSERVICE_USER>
<WEB_SERVICE_KEY>
Example link: http://localhost:7047/BC140/WS/CRONUS%20UK%20Ltd./Codeunit/ZetadocsExpensesBCSERVER\WSUSERrDkv+s92fd/e9dfAk+xyfGNhXfBTz2m2b/vL7L6Y/NI=
If successful, you will be shown a 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…..”
If you don’t receive this message, please return to Run the Assisted Setup and confirm you are entering the full web serivce access key before continuing
|
Starting the Connector Service
Now that you have configured each of the individual elements of the Zetadocs Expenses Connector configuration file you are ready to start the service.
1.Run View Local Services.
2.Locate Zetadocs Expenses Connector.
3.Start the service.
Note: The service user must have sufficient rights to make outgoing Internet calls. Prior to starting the connector it is advised to log in to the server hosting the Zetadocs Expenses Connector and check internet access.
|
The connector should now be operational, if you have problems starting your connector please review each topic above.
Configuring the Zetadocs Expense Export Codes
Configure the Export Codes
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.
Testing the Export to Business Central
Creating test data in Zetadocs Expenses
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