Last updated: 2024-03-08
Applies from: Opter 2023.12.00
Settlement export to Netvisor (API)
You can link Opter to the Netvisor financial system. Then it is possible to:
-
Export settlements from Opter to Netvisor. For instructions, see below.
-
Export invoices from Opter to Netvisor. Instructions can be found in Invoice export to Netvisor (API).
You can export settlement invoices and postings to the Netvisor financial system. Supplier bill and account coding amounts are sent including VAT.
Every time you export settlements, Opter checks whether there is anything to update in hauliers or subcontractors. Opter only exports settlements that do not yet exist in Netvisor.
Settlement data sent from Opter to Netvisor
The following information is sent to Netvisor in the settlement export:
-
Supplier bill number.
-
Supplier bill date.
-
Due date of supplier bill.
-
Supplier bill account coding. (Settlement and posting amounts are sent including VAT).
-
The haulier's/subcontractor's ledger number, name, address, country, e-mail address, reference (name of contact person), telephone number, fax number, IBAN, BIC, bank account number and organisation number.
Conditions
Licens
You need to have a licence for Netvisor with an integration option. Contact Netvisor if you need more information about your licence.
Currency
In order to use Netvisor with Opter, the default currency in Opter must be Euro ( Pricing tab in the office settings).
Accounts payable, input VAT and accrual accounts
For Netvisor and Opter to work well together, make sure you have the same account numbers for accounts payable, input VAT and penny rounding in Opter and Netvisor.
Profit centres
Result units in Opter are called "dimensions" in Netvisor. In Opter, you can find the profit centres on the Economy tab in the office settings.
If you use profit centres, the dimensions are automatically created in Netvisor during the settlement export, if they do not already exist in Netvisor. Make sure that each profit centre you use has a code in the field Code in the windows Economic Units 1-Economic Units 5 in Opter, under Economy > Economic units.
Information in the registers of hauliers and subcontractors
During settlement export to Netvisor, information on hauliers and subcontractors is transferred from the haulier and subcontractor registers in Opter. To check that you have the correct information in the registers, click on Register > Supplier or Register > Subcontractors, select the haulier/subcontractor from the list on the left and then click on the tabs General, Details and Pricing and Billing.
Opter creates vendor in Netvisor by haulier/subcontractor if it does not already exist. If the haulier/subcontractor is already in Netvisor, Opter updates the information in Netvisor. (There is no link in the other direction, i.e. Netvisor does not update any information on hauliers or subcontractors in Opter).
The link between the systems is made via the "vendor code" in Netvisor and the rider's or subcontractor's Ledger number in Opter. Check that all hauliers and subcontractors in your Opter have Ledger number on the tab Pricing and Billing.
Step 1: Create an API user account in Netvisor
If you have not already created an API user account in Netvisor, follow the instructions in Invoice export to Netvisor (API).
Step 2: Create a supplier bill export in Opter
Click on Economy > Supplier bills > Supplier bill export to create a new supplier bill export.
The following fields must be filled in on the General tab:
-
Name: For example, "Netvisor API".
-
Type: Netvisor API
-
Encoding: UTF-8
-
Extra settings: In this field, you must enter the username and API key of your Netvisor user account, as well as your organisation number.
Copy the following into the Extra settings field and replace "<api user>" with the username, "<api users password>" with the API key and "<company identity (Finnish OrgNo)>" with your organisation number:
Copy codeExtra settings
UserId=<api user>
Password=<api users password>
OrgId=<company identity (Finnish OrgNo)>
Click on to save all changes.
Step 3: Rename product and product group (optional)
When the settlement is created in Netvisor when exporting from Opter, the coding rows that are on the settlement in Opter are created. The account rows in Netvisor must be linked to a product. The name of the product is by default "Opter" but can be changed in the terminology tag SES_NetvisorAPIProductName.
The product in turn belongs to a product group. The name of the product group is by default "OpterKontering - Group" but can be changed in the terminology tag SES_NetvisorAPIProductGroup.
To change the names, proceed as follows:
-
Click on Settings > Terminology.
-
If you want to change the name of the product, type "SES_NetvisorAPIProductName" in the Keyword field and click on Search. Type "Opter" in the field Search for. In the Replace with field, type what you want the product to be called, for example, "Opter Accounting Line". Select the language for which you want to make the terminology change in the drop-down menu Language. Click on Replace.
-
If you want to change the name of the product group, type "SES_NetvisorAPIProductGroup" in the Keyword field and click on Search. Type "OpterKontering - Group" in the field Search for. In the Replace with field, type what you want the product to be called, for example "Account group from Opter". Select the language for which you want to make the terminology change in the drop-down menu Language. Click on Replace.
-
Click on the Save button at the bottom to save your changes.
Step 4: Adding the settlement export to a settlement export group
Click on Economy > Supplier bills > Supplier bill export settings and tick "Netvisor" (or the name you gave to the settlement export) for the groups that should be able to generate an export to Netvisor. A new export group can also be created.
-
Click on Settings > Offices and go to the Crediting tab.
-
Select an export group from the Supplier bill export drop-down list. Click on to save all changes.
-
Click on to check the new default group.
Step 5: Export to Netvisor
Supplier bill information can be exported from Opter when closing a supplier bill period, or subsequently when it is possible to export entire supplier bill periods but not individual supplier bills. Settlement information and account assignment are exported to Netvisor according to the settings.
-
Click on Economy > Supplier bills > Supplier bills.
-
Right-click on a supplier bill period and select Export.
-
Click on Export and send.
The number of supplier bills to be exported and the number of supplier bills exported are displayed, as well as a progress bar. Individual supplier bills cannot be exported retrospectively.
Troubleshooting
If the transfer to Netvisor does not work, a message appears in the settlement export log. If a settlement cannot be exported in its entirety, any remaining settlement is automatically removed from Netvisor. The errors are usually due to one of the following:
-
The traveller/subcontractor's current account number or other details are missing in Opter. See the information in the registers of hauliers and subcontractors above.
-
The account numbers that appear in the posting for the settlement period to which the exported settlement belongs must exist in Netvisor. For more information, see Accounts payable, input VAT and rounding above.
If an account number is missing, an error message will be displayed with information about what is missing.
-
The Netvisor web service is down.
See also