Please enable JavaScript to view this site.

 

Zetdocs Expenses Extension Direct Access

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:


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.

 

Direct Access Pre-requisites

1.Internet facing web services have been configured with a genuine certificate issued by a Certificate Authority.

note_image 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

 

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.

 

Enabling Access to the Web Service

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.

 

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 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>

 

 e.g. https://bcserver.domain.com:7047/BC140/WS/CRONUS%20UK%20Ltd./Codeunit/ZetadocsExpensesBCSERVER\WSUSERrDkv+s92fd/e9dfAk+xyfGNhXfBTz2m2b/vL7L6Y/NI=

 

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.

 

Configuring your Zetadocs Expenses account

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 Zetadocs Expenses to use the published Web Service

1.Choose the Companies option (top headings)

2.Manage Companies via the manage_icon 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

 

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 (home1 Home page > new_expense1 New Expense tile) using the ‘Airfare’ Expense Type you modified earlier.

3.Create a new report (home1 Home page > new_report1 New Report) and attach the expense you have created by choosing new_item1.

4.Submit the Expense Report, setting the Approver and Processor to the Administrator user account.

5.Choose the tasks1 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 status1 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_menu1 action menu, then choose Export.

10.Wait until the status of the Expense Report changes to Done, or click the action_menu1 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