Voucher series

This table contains one row for each voucher series.

Other tables, such as the Company information table, contain references to voucher series in order to determine voucher numbers and voucher types on vouchers and transactions.

If Business NXT runs out of numbers in a voucher series, the Reserve voucher number defined using the Change counters processing in the Company information table will be applied. When entering vouchers manually, an error message will be displayed instead, if the voucher series is exceeded.

Via the Voucher no. control field in the Company information table, you can prevent multiple concurrent users from using the same voucher series.

First voucher no.

Used by some EFT systems.

If you use advance payment or CID code for reminders in the Voucher table, you must update this field manually.

Note:

Due to technical limitation, maximum allowed value in voucher number is 2147483647.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Voucher no.	Integer
SQL name	FstVoNo	The database field name.
API identifier	firstVoucherNo	The API identifier used in GraphQL.
Number	13015

Last voucher no.

An upper limit for the voucher series, e.g. to prevent overlapping with another series.

Note:

When the voucher series runs out, for vouchers that are automatically allocated, e.g. for invoicing series, i.e. when the Next voucher no. has passed the Last voucher no. field, the reserve voucher series will be used, which you can define via the Change counters processing in the Company information table.

If this happens when using a voucher and document series during manual voucher entry, you will receive an error message instead of a new voucher number.

Note:

Due to technical limitation, maximum allowed value in voucher number is 2147483647.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Voucher no.	Integer
SQL name	LstVoNo	The database field name.
API identifier	lastVoucherNo	The API identifier used in GraphQL.
Number	4583

Name

The name of the voucher series.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Name	Text (80)
SQL name	Nm	The database field name.
API identifier	name	The API identifier used in GraphQL.
Number	1919

Next voucher no.

The next vacant voucher number.

The value is calculated, but you can change it manually.

Note:

If you delete a voucher number on the last voucher in the batch or delete the whole last voucher, the Next voucher no. field will be reset, unless the second last voucher has the same voucher number as the one that has been deleted.

Note:

If the Credit note number is not filled in in the voucher series for credit notes in the Company information table, the Next voucher no. and credit note number from the voucher series for invoices will be retrieved, but still use the voucher type (and text) for the credit note series.

Note:

Due to technical limitation, maximum allowed value in voucher number is 2147483647.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Voucher no.	Integer
SQL name	NxtVoNo	The database field name.
API identifier	nextVoucherNo	The API identifier used in GraphQL.
Number	1920

Serial type

This field is no longer in use. Be aware the field may be removed in later versions.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
SQL name	SrTp	The database field name.
API identifier	serialType	The API identifier used in GraphQL.
Number	8868

Suspended

Entering the voucher series manually in the Batch table is not allowed.

The voucher series can be used for automatically generated batches, e.g. from order processing, VAT reports etc.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
Write Access	System supervisor user	Only users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL name	Susp	The database field name.
API identifier	suspended	The API identifier used in GraphQL.
Number	2212

Voucher series no.

A unique number identifying the voucher series.

Note:

If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Voucher series no.	Integer
Primary key	Yes	Voucher series no.
SQL name	VoSrNo	The database field name.
API identifier	voucherSeriesNo	The API identifier used in GraphQL.
Number	1918

Voucher series processing

Settings for how batches containing the voucher series will be processed.

A look-up opens the dialog box where you can see the following check boxes and options:

Include VAT when checking amount difference: The debit/credit difference of the vouchers included in the batch, will be calculated from the Amount excl. VAT field instead of from the Amount field in the Voucher table.
Used in bank reconciliation: The voucher series is available for bank reconciliation, and can be selected when running the Create voucher processing from the Account statement transaction table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Voucher series processing	Integer
SQL name	VoSrProc	The database field name.
API identifier	voucherSeriesProcessing	The API identifier used in GraphQL.
Number	16420

Voucher type

The voucher type that will be entered on vouchers when the voucher series is used.

Note:

It will not be calculated interest for entries using the interest voucher type unless compound interest is to be calculated for the customer.

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	Voucher type	Integer
SQL name	VoTp	The database field name.
API identifier	voucherType	The API identifier used in GraphQL.
Number	1963

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

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by user

The name of the user that changed the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChUsr	The database field name.
API identifier	changedByUser	The API identifier used in GraphQL.
Number	A unique column number.

Changed date

The date when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChDt	The database field name.
API identifier	changedDate	The API identifier used in GraphQL.
Number	A unique column number.

Changed time

The time when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTm	The database field name.
API identifier	changedTime	The API identifier used in GraphQL.
Number	A unique column number.

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTs	The database field name.
API identifier	changedTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Created by user

The name of the user that created the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreUsr	The database field name.
API identifier	createdByUser	The API identifier used in GraphQL.
Number	A unique column number.

Created date

The date when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreDt	The database field name.
API identifier	createdDate	The API identifier used in GraphQL.
Number	A unique column number.

Created time

The time when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTm	The database field name.
API identifier	createdTime	The API identifier used in GraphQL.
Number	A unique column number.

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTs	The database field name.
API identifier	createdTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Edit status	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	LckSt	The database field name.
API identifier	editStatus	The API identifier used in GraphQL.
Number	A unique column number.

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

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	Process no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChPrc	The database field name.
API identifier	lockedByProcessNo	The API identifier used in GraphQL.
Number	A unique column number.

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.