Create a new connection

  1. Click  Get Data.
  2. In the top right corner, click  New.
  3. Select from the list of available integrations (accounting system).
  4. In the Create new connection dialog box, enter:
  • Name: Enter a name for your connection.
  • Server: Enter server name or the IP address of your SQL server (name\instance) where your accounting database is stored.
  • User: Leave empty if you want to use Windows authentication or enter SQL user for accessing the accounting databases. This requires minimum read access rights to all databases, including the system database. However, if you plan to do budgeting with write-back to the ERP system, you need to have both read and write rights to all accounting databases.*
  • Password: Leave blank if you are using Windows authentication or enter the password for the SQL user.
  • System database: Enter the database for the accounting system.

5. Click Next.

Now, you get a list of available company databases.

6. Select company or companies from the list.

7. Click Next.

8. Select the voucher provider you use or click None. The picture shows an example where Visma Document Center is used.
NOTE: If you select None, you will not set up the voucher view option and you can go directly to step 9.
NOTE: This step is not visible for all integrations.

9. In the Document center path field, enter the path where the vouchers are stored. It is important that the portal or Voucher Service has access to this folder.

10. When you have added the document center path, click Finish.

 

Edit a connection

  1. Click  Get Data.
  2. Click the connection you want to edit.
  3. In the top right corner, click  Edit.
  4. Click Next to get to the step you want to edit.

 

Delete connection

  1. Click  Get Data.
  2. Click the connection you want to delete.
  3. In the top right corner, click https://help.onestopreporting.com/wp-content/uploads/2017/03/btn_delete.png Delete.
  4. Click Delete to confirm the deletion.

NOTE: When you delete a connection, you also delete the following related data:

  • Data access filters
  • Budget flows
  • Publisher jobs
  • Reports (not report templates)