IntegrationHTTP-methodResourceDTDSchemaExample
Get accounting dataGETaccountingledger.nv  Download 
Import accounting dataPOSTaccounting.nvDownload Download
Edit accounting dataPOSTaccountingedit.nv
Download
Import budgetPOSTaccountingbudget.nvDownload Download
Import dimension budgetPOSTaccountingbudgetdimensionbudget.nvDownload Download 
Import accounting budgetPOSTaccountingbudgetaccountbudget.nvDownload Download 
Get budget by account groupGETaccountingbudgetyearbudget.nv

 

 Download
Get budget by year, account group and dimension nameGETaccountingbudgetdimensionyearbudget.nv

 

 Download 
Get budget's accounts and account groupsGETaccountingbudgetaccountlist.nv  Download 
Get whole account listGETaccountlist.nv  Download
Get accounting periodsGETaccountingperiodlist.nv  Download 
Get voucher typeGETvouchertypelist.nv

Download

Get accounting data

Resource: accountingledger.nv

Parameter nameOccursDescriptionExample
startdate1Finds vouchers that are added after given date (inclusive)
2012-10-23
enddate1Finds vouchers that are added before given date(inclusive)
2013-10-24
accountnumberstart0...1Finds vouchers which account number is equal or greater than given value
3000
accountnumberend0...1Finds vouchers which account number is equal or less than given value
3500
changedsince0...1Finds vouchers that are modified or added after given date
2013-01-01
lastmodifiedstart0...1Finds vouchers that are modified after given date
2012-10-23
lastmodifiedend0...1Finds vouchers that are modified before given date
2013-10-24
showgenerator0...1Returns the creator of the voucher (eg. user or system)1
voucherstatus0...1Finds all, only valid or invalidated and deleted vouchers. Status -attribute shows which status voucher is: "valid", "invalidated" or "deleted"1 = All
2 = Valid
3 = Invalidated and deleted

Response:

LevelElement nameType and lengthOccursDescriptionExample
rootrootAggr.1  
1vouchersAggr.1  
2voucherAggr.0...n  
Attr.statusText0...1Status of the Voucher
valid, invalidated or deleted
netvisorkeyNumeric1Netvisor key of the Voucher
15
voucherdateDate 1Date of the Voucher
2013-12-05
vouchernumberNumeric 1Voucher's reference number
515144
voucherdescriptionText 1Free description text 
voucherclassText 1Class of voucher
Myyntilasku
linkedsourcenetvisorkeyNumeric1Netvisor key of the sales- or purchaseinvoice
123
Attr. typeText 1"purchaseinvoice" or "salesinvoice"purchaseinvoice
vouchernetvisoruriText 1URI to the voucher in Netvisor 
voucherlineAggr.0...n  
4netvisorkeyNumeric1Voucher lines Netvisor key6
4linesumNumeric 1Sum of the voucher line
150,22
descriptionText 1Free description text 
accountnumberNumeric 1Account number
1701 
vatpercentNumeric 1VAT percent
24 
vatcodeTextVAT code  
4accountdimensionText0...1 Seurantakohde 1 
Attr.typeNumeric1 netvisorkey
dimensionAggr.0...1  
5dimensionnameText 1Dimension name 
dimensionitemText 1Dimension 

Import accounting data

Resource: accounting.nv

Note! A transaction payment for web invoice will be charged for each voucher attachment imported to Netvisor via interface.

Vouchers, voucher lines, the lines' dimensions and attachments can be imported into accounting materials. The request must be directed to Accounting.nv resource without parameters. One request can only carry one voucher. If voucher's id is not given, the system automatically assigns a new id for it.

Allowed types of vouchers are (Finnish names must be used in voucherclass field when importing data):

  • Sales invoice (myyntilasku)
  • Sales payment (myyntisuoritus)
  • Bank (pankki)
  • Treasury (kassa)
  • Imported events (tuodut tapahtumat)
  • Automatic financial statements (automaattiset tilinpäätöskirjaukset)
  • Vouchers formed by the system (Järjestelmän muodostamat)
  • Purchase invoice (ostolasku)
  • Purchase payment (ostosuoritus)
  • Others (muut)
  • Accruals (jaksotukset)
  • Salaries (Palkka, PA)

Voucher line's sum's type, net or gross, is chosen for each voucher. If the type is net, the system will not automatically calculate VAT lines and rounding difference lines, and the voucher will be exactly as the imported material. When type is gross, VAT and rounding difference lines will be automatically calculated by the system.

The account chosen for the voucher must be found from the system, otherwise an INVALID_DATA error with further information is returned. VAT code is retrieved from the chosen account if it has not been specified. If the user enters a VAT code that conflicts with the VAT rate entered for the line, an error is returned with further information.

Negative sum is recorded as credit and positive sum as debit.

One voucher line can relate to several dimensions. If the "Dimension Name" or "Dimension Item" values are not found in the system, it will create new ones.

While importing a voucher, several attachments can be included. The attachments need to be base64 encoded and included in the XML message.

Request:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1voucherAggr.1  
2calculationmodeText1net (vat lines are not calculated automatically) or gross (vat lines are calculated automatically)net
2voucherdateDate 1Date of the voucher
2013-10-20
Attr.formatText 1Date format, always ansi
ansi
numberNumeric 0...1Number of voucher. If not given, system automatically picks next number
42
descriptionText, max. 2550...1Description of the voucher 
voucherclassText1Myyntilasku, Myyntisuoritus, Pankki, Kassa, Tuodut tapahtumat, Automaattiset tilinpäätöskirjaukset, Järjestelmän muodostamat, Ostolasku, Ostosuoritus or Muut
Myyntilasku
voucherlineAggr.0...n  
3linesumNumeric1Negative value is recorded to credit side and positive value on debit side. Two decimal maximum.
-100,00
Attr.typeText 0...1net or gross
net
 3descriptionText, max. 255 0...1Description text 
accountnumberNumeric1Accounting account number, must be found or an error is returned
1701
vatpercentNumeric1Must not be in conflict with vatcode attribute
24
Attr.vatcodeText0...1If not given, value behind account number is used. Valid values are: NONE, KOOS, EUOS, EUUO, EUPO, 100, KOMY, EUMY, EUUM, EUPM312, EUPM309, MUUL, EVTO, EVPO, RAMY, RAOS, EVRO, EVKV
KOMY
3accountdimensionText0...1Voucher's follow-up object.Seurantakohde 1
Attr.typeText1name or netvisorkey (shown only in Netvisor)name
dimensionAggr.0...n  
4dimensionnameText1Dimension name. If dimension is not found from system, it is created
Project 1
 4dimensionitemText1Dimension. If item in dimension is not found from system, it is created
Payroll
voucherattachmentsAggr.0...1  
3voucherattachmentAggr.1...n  
4mimetypeText1MIME-type of the attachment
application/pdf
attachmentdescriptionText1Description text for the attachment
Example attachment
filenameText1File name of the attachment
Attachment.pdf
documentdataBase641Data of the attachment as base64 encoded string 

Edit accounting data

Resource: accountingedit.nv

Accounting edit can be used for editing existing voucher, voucher lines, voucher line dimensions and voucher attachments. The request doesn't have parameters. One request can include only one voucher. Accounting edit can be used for editing voucher's basic info and voucher lines. Basic info is not compulsory if only voucher lines are being edited. Accounting edit invalidates existing voucher lines and imports requests voucher lines as new voucher lines. If voucher lines are not imported in the request, no changes are made to the existing vouher lines.

The data to be imported must be included in the request as an XML with the following structure:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1voucherAggr.1

2netvisorkeyNumeric1Netvisor key of the voucher being edited. Netvisor key can be retreived with the resource accountingledger.nv123
2calculationmondeString0...1Calculation mode for the voucher. Net (vat lines are not calculated automatically) or gross (vat lines are calculated automatically).gross
2voucherdateDate0...1Voucher date2009-1-1
Attr.formatString1Date format, always ansiandi
2numberNumeric, max. 90...1Voucher number. If not given, the system automatically picks next number from the chosen voucher class1
2descriptionString, max. 2550...1Voucher descriptionDescription
2voucherclassString0...1Voucher class. See possible voucher classes above. It is also possible to create own voucher classes.Myyntilasku
2voucherlineAggr.0...n

3linesumNumeric1Line sum. Negative value is recorded to credit side and positive value on debet side. Two decimal maximum.
-100,00
Attr.typeString0...1net or grossnet
3descriptionString, max. 2550...1Voucher line descriptionDescription
3accountnumberNumeric1Accounting account number, must be found or an error is returned.3000
3vatpercentNumeric1Vat percent. Must not be in conflict with vatcode attribute.
24
Attr.vatcodeString0...1VAT code. If not given, value behind account number is used. Valid values are: NONE, KOOS, EUOS, EUUO, EUPO, 100, KOMY, EUMY, EUUM, EUPM312, EUPM309, MUUL, EVTO, EVPO, RAMY, RAOS, EVRO, EVKV
KOMY
3accountdimensionString0...1Voucher line's follow-up object.Seurantakohde 1
Attr.typeString1name or netvisorkey (shown only in Netvisor)name
3dimesionAggr.0...1

4dimensionnameString, max. 501Dimension name. If dimension is not found from system, it is created.Project
4dimensionitemString, max. 2001Dimension item. If item in dimension is not found from system, it is created.Project x
2voucherattachmentsAggr.0...1

3voucherattachmentAggr.1...n

4mimetypeString1MIME-type of the attachmentapplication/pdf
4attachmentdescriptionString1Description text for the attachmentExample attachment
4filenameString1File name of the attachmentAttachment.pdf
4documentdataString1Data of the attachment as base64 encoded string

Import dimension budget

Resource: accountingbudgetdimensionbudget.nv

Importing a a dimension budget into Netvisor. The data to be imported must be included in the request as an XML with the following structure:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1accountingbudgetdimensionbudgetAggr.1  
2methodText1Type of import, change or replace change
2lockeddimensionAggr.0...n  
3dimensionnameText1Dimension name Example project
3dimensionitemnameText1Dimension Payroll
2accountidentifierAggr.1  
3accountnumberNumeric1Accounting account1233
3accountnameText1Account nameSalary
3accountgroupNumeric1Account group number3
2budgetdimensionAggr.1...n  
3dimensionnameText 1Dimension name Example budget
3dimensionitemnameText 1Dimension Budget 1
3budgetmonthAggr.1...n  
4sumNumeric 1Sum of the budget 151200
4vatNumeric 1VAT 24
4monthNumeric 1Budget month 10
4yearNumeric 1Budget year 2014

Import accounting budget

Resource: accountingbudgetaccountbudget.nv

Importing an accounting budget into Netvisor.

The data to be imported must be included in the request as an XML with the following structure:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1accountingbudgetaccountbudgetAggr.1  
2methodText1change or replacechange
2lockeddimensionAggr.0...n  
3dimensionnameText1Dimension name Example project
3dimensionitemText1Dimension Payroll
2budgetaccountAggr.1...n  
3accountidentifierAggr.1  
4accountnumberNumeric1Account number 331
4accountnameText 1Account name  
4accountgroupNumeric 1Account group number 
3budgetmonthAggr.1...n  
4sumNumeric1Sum of the budget 151,25
4vatNumeric1VAT 24
4monthNumeric1Month of the budget 12
4yearNumeric1Year of the budget 2013

Get budget by account group

Resource: accountingbudgetyearbudget.nv

Returns budget from chosen year by account group.

ParameterOccursDescriptionExample
year1Year of the budget2018
lockeddimensionitemid 0...1Limits the the information that it contains the  dimension items given in the parameter. Separated by comma (,).accountingbudgetyearbudget.nv?year=2018&lockeddimensionitemid=1

You can get DimensionItemID by using resource dimensionlist.nv

From that response:
<DimensionDetails>
<DimensionDetail>
  <Netvisorkey>xxx</Netvisorkey> is the DimensionItemID

Response:

LevelElement nameTypeOccursDescriptionExample
1RootAggr.1  
2AccountingBudgetAccountBudgetAggr.1  
3BudgetAccountText1  
4AccountNameText1Name of account group 
4AccountNumberText1Account number 
4AccountGroupAggr.1Number of account group 
4BudgetMonthText12  
5SumText1Budgeted amount 
5VatText1VAT % 
5YearText1Yeat 
5MonthText1Month 

Get budget by year, account group and dimension name

Resourse: accountingbudgetdimensionyearbudget.nv

Returns company's default budget by desired year, account group and dimension name.

ParameterOccursDescriptionExample
Year1Budgeted year2018
AccountID1ID of the budgeted account group549
DimensionHeaderId1ID of the budgeted dimension name1
LockedDimensionItemId 0...1Limits the the information that it contains the dimension items given in the parameter. Separated with comma (,).accountingbudgetyearbudget.nv?year=2018&lockeddimensionitemid=1

You can get AccountID by using resource accountlist.nv

From that response:
<Account>
 <NetvisorKey>xxx</NetvisorKey> is the AccountID.

You can get DimensionHeaderID and DimensionItemID by using resource dimensionlist.nv

From that response:
<DimensionName>
  <Netvisorkey>xxx</Netvisorkey> is the DimensionHeaderId

<DimensionDetails>
<DimensionDetail>
  <Netvisorkey>xxx</Netvisorkey> is the DimensionItemID

Response:

LevelElement nameTypeOccursDescriptionExample
1RootAggr.1  
2AccountingBudgetDimensionBudgetAggr.1  
3AccountNumberText1  
3AccountNameText1Name of account group 
4AccountGroupText1Account group number 
4BudgetDimensionAggr.1  
5DimensionItemNameText1Dimension item name 
5DimensionNameText1Dimension header name 
5BudgetMonthAggr.12  
6SumText1Budgeted amount 
6VatText1VAT % 
6YearText1Year 
6MonthText1Month 

Get budget's accounts and account groups

Resource: accountingbudgetaccountlist.nv

Returns current budget's account groups and accounts for making the budget.

ParametersOccursDescriptionExample
year1Year has to be between 1950-20502018

Response:

LevelElement nameTypeOccursDescriptionExample
RootRootAggr.1  
1AccountingBudgetAccountListAggr.

1

  
2AccountAggr.0...n  
4NetvisorKeyNumeric1ID of account123
4NameText1Name of accountMyynti
4NumberAggr.1Account number3003
4GroupText12ID of account group300
5TypeText1ID of account type6

Get whole account list

Resource: accountlist.nv

Used for fetching whole account list and default accounts used in default accounting.
Response:

LevelElementTypeOccursDescriptionExample
RootRootAggr.1  
1AccountListAggr.1  
2CompanyDefaultAccountsAggr.1  
3TradePayablesNumeric1  
3PurchaseVATReceivableNumeric1  
3RoundingOffDifferenceNumeric1  
3VATpayableNumeric1  
3TaxAccountNumeric1  
3AdvancePaymentsNumeric1  
3SalesReceivablesNumeric1  
3SalesVATdebtNumeric1  
3InventoryNumeric1  
3SalesDiscountNumeric1  
3SalesExchangeRateDifferecesNumeric1  
3CollectionNumeric1  
3PurchaseDiscountsNumeric1  
3PurchasesExchangeRateDifferencesNumeric1  
3PurchaseInvoiceAccrualNumeric1  
3SalesInvoiceAccrualNumeric1  
3PurchaseDomesticDefaultNumeric1  
3PurchaseEUDefaultNumeric1  
3PurchaseOutsideEuDefaultNumeric1  
3SalesDomesticDefaultNumeric1  
3SalesEUDefaultNumeric1  
3SalesOutsideEUDefaultNumeric1  
3AccountsAggr.1  
4AccountAggr.1...n  
5NetvisorKeyNumeric1 Database ID 
5NumberNumeric1 Account number 
5NameNumeric1  
5ForeignNameText0...3Account in Swedish or in English 
Attr.ISO-3166Text1 fi|en|se 
5AccountTypeText1Type of the account, account or accountgroup 
5FatherNetvisorKeyNumeric1Under which account, account belongs
ie. account 3000 father is group 300
 
5IsActiveNumeric1  
5IsCumulativeNumeric1Is the calculation cumulative. Balance sheet 
5SortNumeric1  
5EndSortNumeric1  
5IsNaturalNegativeNumeric1  

Import budget

Resource: accountingbudget.nv

Importing a budget into Netvisor.

The data to be imported must be included in the request as an XML with the following structure:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1accountingbudgetAggr.1  
2ratioText1Account or account group number where budgeting is targeted5000
Attr.typeText0...1Type of the element in ratio field. account for account, ratio for group. For now, only account is supportedaccount
2sumNumeric 1Budget for the given month and year50000
2yearNumeric 1Year of budget. Only one months budget can be in one message.2013
2monthNumeric 1Month of budget. Only one months budget can be in one message.12 
2versionText 1Version of the budget. If given version is not found, it is created. If budget version for the month determined in the imported material already exists, it is deleted and replaced with the imported dataBudget 2009, version 1
2vatclassNumeric 0...1VAT-percent24
2combinationsAggr.1  
3combinationAggr.1...n  
4combinationsumNumeric1Dimension or dimension combination sum 
4dimensionAggr.1...n  
5dimensionNameText 1If dimension does not exists on system, it is createdProject 1
5dimensionItemText 1if item is not found from dimension, it is createdPayroll
Attr.fatheridNumeric0...1Netvisor id of the dimension that the budget is to be added. If the dimension is not found for the id, an INVALID_DATA error is returned with further information 15

Get accounting periods

Resource: accountingperiodlist.nv

Used for getting accounting periods and possible lockdowns.
Doesn't return which period is active. Lists all possible periods in ascending order.

Querystring parameters:
(No parameters)

Response:

LevelElement nameType and lengthOccursDescriptionExample
RootRootAggr.1  
1AccountingPeriodListAggr.1  
2PeriodLockInformationAggr.1  
3AccountingPeriodLockDateDate1Lock period2014-12-31
Attr.formatText1Date format, always ansiansi
3VatPeriodLockDateDate1VAT-lock date
2014-12-31
Attr.formatText1Date format, always ansiansi
3PurchaseLockDateDate1Accounts payable lock date2014-12-31
Attr.formatText1Date format, always ansiansi
3PeriodAggr.1...n  
4NetvisorKeyNumeric1Period NetvisorID123
4NameText1Name 
4BeginDateDate1Period start date 
Attr.formatText1Date format, always ansiansi
4EndDateDate1Period end date 
Attr.formatText1Date format, always ansiansi

Get voucher types

Resource: vouchertypelist.nv

The resource returns company's voucher types and default voucher types

Response: 

Level
Element nameType and lengthOccursDescription
Example
RootRootAggr.1  
1VoucherTypeListAggr.1  
2DefaultVoucherTypesAggr.1 Default voucher type 
3SalesInvoicesAggr.1

4NetvisorKeyNumeric1Sales invoice -Netvisor key of the delauft voucher type123
3SalesInvoicePaymentsAggr.1

4NetvisorKeyNumeric1Sales invoice payment -Netvisor key of the default voucher type125
3PurchaseInvoicesAggr.1

4NetvisorkeyNumeric1Purchase invoice -Netvisor key of the default voucher type128
3PurchaseInvoicePaymentsAggr.1

4NetvisorKeyNumeric1Purchase invoice payment -Netvisor key of the default voucher type126
3OtherSystemGeneratedVouchersAggr.1

4NetvisorKeyNumeric1Other vouchers generated by the system -Netvisor key of the default voucher type129
3BankStatementViewVouchersAggr.1

4NetvisorkeyNumeric1Vouchers generated from bank statement view -Netvisor key of the default voucher type122
3AccrualsAggr.1

4NetvisorKeyNumeric1Accruals -Netvisor key of the default voucher type127
2VoucherTypesAggr.1Voucher types

3VoucherTypeAggr.1...n

4NetvisorKeyNumeric1Netvisor key of the voucher type121
4AbbreviationText1Abbreviation of the voucher typeML
4NameText1Name of the voucher typeMyyntilasku
4ForeignNameText
0...3Voucher type in Swedish or in English
Attr.ISO-639-1Text
1fi|en|sv



xml
xml
xml
(738 Bytes)
xml
(775 Bytes)
xml
(551 Bytes)
xml
xml
xml
(105 KB)
xml
xml
xml

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.