Business NXT documentation

Home
Accounting
The accounting functionality enables real-time visibility into financial health, enhances accuracy in financial reporting, and facilitates regulatory compliance. Relevant transactions for book keeping, such as payments, expenses and vouchers are automatically received from the services in the Visma.net platform.
Bank reconciliation
The purpose of bank reconciliation is to match accounting transactions with account statement transactions from the bank.
Bank reconciliation statement column
This table is a memory table, and doesn’t exist in the database. It is used in forms for the Bank reconciliation statement report.

Accounting
The accounting functionality enables real-time visibility into financial health, enhances accuracy in financial reporting, and facilitates regulatory compliance. Relevant transactions for book keeping, such as payments, expenses and vouchers are automatically received from the services in the Visma.net platform.
- Base data
  The tables in this section include base data for accounting.
- Budgeting
  You can create a single budget to be used during many years ahead, but you can also enter an unlimited number of budgets.
- Vouchers
  A voucher is an accounting document that serves as a record of a business transaction and verifies certain activities or expenses.
- Incoming documents and invoices
  Incoming documents and vouchers usually arrive from other systems. They can be, for example, new supplier invoices, expense claims or payroll vouchers.
- Customer ledger
  The customer ledger is a financial record that contains detailed information about transactions between a business and its customers.
- Supplier ledger
  The supplier ledger contains detailed information about purchases, payments made, outstanding balances, and any credits or adjustments related to the supplier.
- Payment transfer
- General ledger
  The general ledger is the central accounting record of a company.
- Bank reconciliation
  The purpose of bank reconciliation is to match accounting transactions with account statement transactions from the bank.
  - Importing account statements
    The account statement transactions are imported daily from Visma.net AutoPay, affecting the following tables in Business NXT:
  - Setting up bank reconciliation
    The following procedures are relevant when setting up bank reconciliation.
  - Running bank reconciliation
    The different steps of the bank reconciliation routine are described in this section.
  - Account statement transaction
    This table contains bank account transactions received from Visma.net AutoPay and is used for bank reconciliation.
  - Account statement transaction processings
    The following processings are available from the Account statement transaction table:
  - Account statement detail
    This table contains details for the bank account transactions received from Visma.net AutoPay.
  - Bank reconciliation statement column
    This table is a memory table, and doesn’t exist in the database. It is used in forms for the Bank reconciliation statement report.
  - Approved reconciliation
    This table contains information about approved reconciliation.
  - Approved reconciliation processings
    The following processings are available from the Approved reconciliation table:
  - Approved reconciliation attachment
    This table contains attachments connected to approved reconciliation.
  - Reconciled transaction
    This table serves as a link between reconciled transactions in the General ledger transaction and Account statement transaction tables.
  - Reconciled transaction processings
    The following processings are available from the Reconciled transaction table:
- Capital assets
  Capital assets are any kind of property for long-term use that belongs to a company.
- Electronic VAT reporting using Business NXT - Norway
  You can use Business NXT for electronic VAT reporting, either manually or automatically using the Visma.net AutoReport integration.
- Electronic VAT reporting - Denmark (new VAT structure)
  You can use Business NXT for electronic VAT reporting automatically using the connected service Visma.net AutoReport.
- Export of SIE files
  SIE files are used to exchange bookkeeping information between different systems, including the basis for financial statements.
- Import of SIE files
  SIE files are used to exchange bookkeeping information between different systems, including the basis for financial statements.

Bank reconciliation statement column

This table is a memory table, and doesn’t exist in the database. It is used in forms for the Bank reconciliation statement report.

A form for printing of the Bank reconciliation statement report must refer to a layout which contains the Bank partner table joined with the Bank reconciliation statement column table. The layout of the Bank reconciliation statement column table will then determine the format of the printed missing transactions on the report.

Property	Value	Description
Database	Company	This table is in the company databases.
SQL name		The table name in the database.
API identifier	bankReconciliationStatementColumn	The API identifier used in GraphQL.
Table no.	442	The table number in the data model.

The following fields exist in this table:

Account statement trans. no.

Value will be retrieved from the Account statement transaction table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	accountStatementTransactionNo	The API identifier used in GraphQL.
Number	18937

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Account statement transaction	AccountStatementTransaction	Account statement trans. no.	Account statement trans. no.

Audit no.

Value will be retrieved from the General ledger transaction table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Audit no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	auditNo	The API identifier used in GraphQL.
Number	18939

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger transaction	GeneralLedgerTransaction	Voucher jour. no. Audit no.	Voucher jour. no. Audit no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Bank partner no.

Primary key.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Bank partner no., Line no.
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	bankPartnerNo	The API identifier used in GraphQL.
Number	18935

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Bank partner	BankPartner	Bank partner no.	Bank partner no.

Bank reference

Value will be retrieved from the General ledger transaction/Account statement transaction table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Bank reference	Text (30)
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	bankReference	The API identifier used in GraphQL.
Number	18940

Booking date

Value will be retrieved from the General ledger transaction/Account statement transaction table.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	bookingDate	The API identifier used in GraphQL.
Number	18941

Currency no.

Value will be retrieved from the General ledger transaction/Account statement transaction table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Currency no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	currencyNo	The API identifier used in GraphQL.
Number	18945

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
Currency	Currency	Currency no.	Currency no.

Exchange rate

Value will be retrieved from the General ledger transaction/Account statement transaction table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Exchange rate	Decimal
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	exchangeRate	The API identifier used in GraphQL.
Number	18946

Line no.

Primary key.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Bank partner no., Line no.
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	lineNo	The API identifier used in GraphQL.
Number	18936

Reconciliation rest amount

Value will be retrieved from the General ledger transaction/Account statement transaction table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	reconciliationRestAmountDomestic	The API identifier used in GraphQL.
Number	18949

Reconciliation rest amount in currency

Value will be retrieved from the General ledger transaction/Account statement transaction table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	reconciliationRestAmountInCurrency	The API identifier used in GraphQL.
Number	18947

Reconciliation rest amount in EURO

Value will be retrieved from the General ledger transaction/Account statement transaction table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Amount	Decimal
Source column	Reconciliation rest amount in currency	Euro
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	reconciliationRestAmountInEuro	The API identifier used in GraphQL.
Number	18948

Text

Value will be retrieved from the General ledger transaction table. Default text shown for Account statement transaction rows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Text	Text (200)
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	text	The API identifier used in GraphQL.
Number	18944

Voucher jour. no.

Value will be retrieved from the General ledger transaction table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Journal no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	voucherJournalNo	The API identifier used in GraphQL.
Number	18938

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger transaction	GeneralLedgerTransaction	Voucher jour. no. Audit no.	Voucher jour. no. Audit no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Voucher no.

Value will be retrieved from the General ledger transaction table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Voucher no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	voucherNo	The API identifier used in GraphQL.
Number	18942

Voucher type

Value will be retrieved from the General ledger transaction table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Voucher type	Integer
Write Access	None	You are not allowed to modify the value in this field.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	voucherType	The API identifier used in GraphQL.
Number	18943

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
Voucher type	VoucherType	Voucher type	Voucher type