Voucher type

This table contains one row for each voucher type.

It's used to suggest text and behaviour on vouchers.

The following fields exist in this table:

Accrual accounting

Controls if accrual accounting is to happen automatically when entering an amount on a voucher of this voucher type.

See the Accrual accounting processing on the Voucher table for details.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL namePerThe database field name.
API identifieraccrualAccountingThe API identifier used in GraphQL.
Number5797 

Additional text definition

A macro that generates a text in the Additional text field in the Voucher table during manual registration.

This also works if the Additional text field is empty and the Additional text definition field is in use for:
  • Updating vouchers.
  • Batches generated by other subsystems.
  • Batches that have been imported.
A lookup in the field leads to the following macro functions:
  • @System (Field name)
  • @Firm (Field name)
  • @Voucher (Field name)

You select the field name under the Field button.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAdditional text definitionText (128)
SQL nameTxt2DefThe database field name.
API identifieradditionalTextDefinitionThe API identifier used in GraphQL.
Number12371 

Affects turn./purch.

Determines if voucher type will be used for producing invoices or credit notes (not payments).

When this option is selected the vouchers of this type will have the turnover class set based on information from either the referred supplier or customer. The actual turnover class is determined on basis of the Trade area, VAT code cust. and VAT code sup. fields in the Associate table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameAffTrnThe database field name.
API identifieraffectsTurnoverOrPurchaseThe API identifier used in GraphQL.
Number540 

Calculate cur.rate

Controls if exchange rate will be calculated when entering an amount on a voucher of this voucher type.

If this option is selected, the exchange rate fields on the voucher of this voucher type will be adjusted when the domestic amount field is changed. If not selected, the amount in currency field will be recalculated instead, and the exchange rate field will not change.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameCompExRtThe database field name.
API identifiercalculateExchangeRateThe API identifier used in GraphQL.
Number6591 

Capital asset proc.

The default value to be set in the Capital asset proc. field when the Voucher type field is set on a new voucher.

The field determines how fields will be set in the Capital asset balance table, when the voucher is updated.

Note:
Entering a valid value in this field is mandatory, when a voucher line is entered, where the debit account or credit account contains a capital asset no. If not, the voucher line will not be possible to update. On capital asset transactions, therefore the field will always contain a valid value.
The capital asset processing determines which fields in the Capital asset balance table that will be updated and is essential to achieve correct depreciations.
A look-up in this field gives you the following list of possible values:
1 - Acquisition
To be used on records concerning the main acquisition of capital assets. E.g. cars, or buildings.
2 - Addition
To be used on records concerning additions. The definition of an "addition" is e.g. winter tyres for a car or marquises on a building. Additions can be given a lifetime, that differs from the main acquisition.
3 - Revaluation
To be used on records meant to adjust the total value of a capital asset. An example when a revaluation can be performed is when a very old real estate has a much higher market value, than the book value.
Note:
Revaluation shall NOT be performed when a capital asset has a lower value than expected due to under-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.
Note:
Revaluation of capital assets is in most countries surrounded by legal restrictions and shall be performed only after accurate consideration.
4 - Devaluation
To be used on records meant to adjust the total value of a capital asset. An example when a devaluation can be performed is when the value of a real estate falls under the book value due to a financial crisis or another extraordinary occurrence.
Note:
Devaluation shall NOT be performed when a capital asset has a higher value than expected due to over-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.
Note:
Devaluation of capital assets might be surrounded by legal restrictions in your country and shall be performed only after accurate consideration.
5 - Sale
To be used on records concerning sales of capital assets.
6 - Discarded
To be used on records concerning discard of capital assets.
7 - (Not in use)
Not in use.
8 - Back transfer
Resets depreciation when capital assets are sold or discarded.
9 - Depreciation on investment
10 - Depreciation on addition
11 - Depreciation on revaluation
12 - Depreciation on devaluation
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCapital asset proc.Integer
SQL namePropPrcThe database field name.
API identifiercapitalAssetProcessingThe API identifier used in GraphQL.
Number5416 

Client processing

The default value to be set in the Client processing field when the Voucher type field is set on a voucher.

This field is used in Business NXT Lawyer solution to enable automatic customer entries to be posted to an alternative general ledger account.

This means that you can post ledger entries for the same customer to up to four different accounts without having to use several customer numbers. You enter default accounts in the Expense account and Client interest account (2,3 and 4) fields in the Company information table. These default accounts can be overridden for specific customers in the Associate table, or for specific account intervals in the Account no. series table.

A look-up in this field gives you the following list of possible values:
1 - Outlay
2 - Client responsibility 1
3 - Client responsibility 2
4 - Client responsibility 3
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainClient processingInteger
SQL nameClPrcThe database field name.
API identifierclientProcessingThe API identifier used in GraphQL.
Number8432 

Credit account

The default value to be suggested in the Credit account field.

The account will be suggested when the Voucher type field is filled in on the voucher.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameCrAcThe database field name.
API identifiercreditAccountNoThe API identifier used in GraphQL.
Number2276 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountCreditAccount
  • Credit account

Debit account

The default value to be suggested in the Debit account field on a new voucher of this voucher type.

The account will be suggested when the Voucher type field is filled in on the voucher.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameDbAcThe database field name.
API identifierdebitAccountNoThe API identifier used in GraphQL.
Number2275 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountDebitAccount
  • Debit account

Debt collection voucher type

A look-up opens the dialog box where you can see the following check boxes and options:
Payment
Credit
Interest and fee
Settlement / Loss / Correction
Invoice
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDebt collection voucher typeInteger
SQL nameDColVoTpThe database field name.
API identifierdebtCollectionVoucherTypeThe API identifier used in GraphQL.
Number18875 

Default text

The default value to be suggested in the Text field.

The text will be filled in when the Voucher type field is filled in the Voucher table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTextText (200)
SQL nameStdTxtThe database field name.
API identifierdefaultTextThe API identifier used in GraphQL.
Number537 

Do not create aut.gen. transactions

Determines that vouchers of this voucher type should not create automatically generated transactions.

When this option is selected, automatically generated transactions will not be produced for customers, suppliers or capital assets, when the voucher of this voucher type is updated.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdontCreateAutomaticallyGeneratedTransactionsThe API identifier used in GraphQL.
Number7891 

Enter currency

Determines if cursor stops at the currency fields when editing a voucher.

If this option is selected, the cursor will enter the currency fields during voucher entry, so that values can be entered in the Cust. no. and Amount in currency fields. If this option is off, the cursor will skip both currency fields.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameInpCurThe database field name.
API identifierenterCurrencyThe API identifier used in GraphQL.
Number539 

Enter exchange rate

Determines if cursor stops at the Exchange rate field when editing a voucher.

If this option is selected, the cursor will enter the Exchange rate field in the voucher. Otherwise it will be skipped.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierenterExchangeRateThe API identifier used in GraphQL.
Number8319 

Enter text

Determines if cursor stops at the Text field when editing a voucher.

If this option is selected, the cursor enters the Text field when editing the Voucher table, otherwise the cursor skips the field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameInpTxtThe database field name.
API identifierenterTextThe API identifier used in GraphQL.
Number538 

Exempt from auto entry

The default value to be suggested in the Exempt from auto entry field when the Voucher type field is filled in on a voucher.

If the field is checked, the voucher is not accumulated in the fields for automatic entry movements in the General ledger account table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameExAutThe database field name.
API identifierexemptFromAutomaticEntryThe API identifier used in GraphQL.
Number6626 

Fill in outstanding amount

Determines if the outstanding amount on the batch should be suggested as the default value in the Amount field in the voucher.

The amount is calculated and suggested when the Voucher type field in the voucher is filled in.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameSugAmThe database field name.
API identifierfillInOutstandingAmountThe API identifier used in GraphQL.
Number2277 

Ignore VAT code

Determines if an option should be set on the voucher to skip tax code related functionality.

When this option is selected:
  • No values will be automatically suggested in the Debit VAT code and Credit VAT code fields on the voucher.
  • The cursor will skip the Debit VAT code and Credit VAT code field when registering a voucher.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameIgnTxCdThe database field name.
API identifierignoreTaxCodeThe API identifier used in GraphQL.
Number541 

Move payment to weekday

Determines if payment-free days should be calculated for vouchers with of this voucher type.

The calculation of payment-free days uses the settings in the Days without payment field in the Company information table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiermovePaymentToWorkdayThe API identifier used in GraphQL.
Number9267 

Organisational unit 1

Omitted

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number3703 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

Omitted

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number3704 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

Omitted

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number3705 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

Omitted

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number3706 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

Omitted

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number3707 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

Organisational unit 6

Omitted

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number3708 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

Omitted

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainLong alphanumeric organisational unit no.Text (40)
SQL nameR7The database field name.
API identifierorgUnit7The API identifier used in GraphQL.
Number9636 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

Omitted

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR8The database field name.
API identifierorgUnit8The API identifier used in GraphQL.
Number9637 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

Omitted

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR9The database field name.
API identifierorgUnit9The API identifier used in GraphQL.
Number9638 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

Omitted

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR10The database field name.
API identifierorgUnit10The API identifier used in GraphQL.
Number9639 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

Omitted

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR11The database field name.
API identifierorgUnit11The API identifier used in GraphQL.
Number9640 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

Omitted

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR12The database field name.
API identifierorgUnit12The API identifier used in GraphQL.
Number9641 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Page elem. no.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL namePgElNoThe database field name.
API identifierpageElementNoThe API identifier used in GraphQL.
Number8758 

Priority

The default value to be suggested in the Priority field when the Voucher type field is filled in on a voucher.

See the description for the Priority field in the Voucher table for details.

Payment priority texts for different languages can be defined in the Text table. These texts has text type 67.
Note:
If you double-click or press * in this field, you can look up a Payment priority in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPayment priorityInteger
SQL namePriThe database field name.
API identifierpriorityThe API identifier used in GraphQL.
Number4777 

Product no.

The default value to be suggested in the Product no. field when the Voucher type field is filled in on a voucher.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct no.Text (40)
SQL nameProdNoThe database field name.
API identifierproductNoThe API identifier used in GraphQL.
Number13808 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
ProductProduct
  • Product no.
Search productSearchProduct
  • Product no.

Repeat info.

Controls if values on certain fields should be automatically copied from the previous voucher of a voucher of this voucher type.

This option causes the values in the Order no., Cust. no., Sup. no., Cap. asset no., Empl. no., Product no., Invoice no. and Previous voucher no. fields to be copied from the previous voucher to the current voucher. This only happens if they have the same value in the Voucher no. field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameRepInfThe database field name.
API identifierrepeatInformationThe API identifier used in GraphQL.
Number6658 

Standard voucher type

Not in use.

A look-up in this field gives you the following list of possible values:
1 - Incoming invoice
2 - Outbound invoice
3 - Payment
4 - Automated
5 - Incoming credit note
6 - Outbound credit note
7 - Cash
8 - Post
9 - Salary
10 - Periodic accrual
11 - Cost
12 - Currency gain/loss
13 - Discounts
14 - Correction or rollback
15 - Sale
16 - Transfer
17 - Miscellaneous
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStandard voucher typeInteger
SQL nameVsVoTpThe database field name.
API identifierstandardVoucherTypeThe API identifier used in GraphQL.
Number18360 

Turnover class

The default value suggested in the Debit turnover cl. and the Credit turnover cl. fields when the Voucher type field is filled in on a voucher.

If not specified, the turnover class will be suggested from the Turnover class field in the General ledger account table for the account selected in the Debit account or Credit account fields.

On vouchers with general ledger entries for sales and purchases that are generated on the basis of orders, the turnover class is defined on the basis of the Transaction type, Trade area and Service type fields.

A look-up in this field gives you the following list of possible values:
1 - Taxable sales
Is used for sales of taxable products. I.e. when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code
2 - Non-taxable domestic sales
Is used for sales of non-taxable products. I.e. when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 1 - Non-taxable domestic
10 - Transfer of goods to EU countries
Used when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 4 - Subsidiary in another EU country
  • Service type1 - Services is not selected
5 - Sale of goods to EU countries
Used when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 2 - Within other EU country
  • Service type1 - Services is not selected
3 - Sale of goods outside EU/Abroad
Used when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 3 - Outside EU/Abroad
  • Service type1 - Services is not selected
9 - Sale of services abroad
Used when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 2 - Within other EU country, 3 - Outside EU/Abroad or 4 - Subsidiary in another EU country
  • Service type1 - Services is selected
13 - Non-taxable sales
16 - Sales outside tax area
18 - Sales, taxable for purchaser
20 - Agent sales to third party
22 - Sales of services to EU countries
26 - Rent income voluntary
27 - OSS union scheme services
28 - OSS union scheme goods
29 - OSS import scheme
4 - Taxable purchases
Is used for purchases of taxable products. I.e. when
  • the Transaction type is 6 - Purchase
  • the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code
7 - Non-taxable domestic purchases
Is used for purchases of non-taxable products. I.e. when
  • the Transaction type is 6 - Purchase
  • the Trade area is 1 - Non-taxable domestic
15 - Domestic purchases with reversed VAT deduction
11 - Transfer of goods between other EU countries
Used when
  • the Transaction type is 6 - Purchase
  • the Trade area is 5 - Transfer between other EU countries
  • Service type1 - Services is not selected
6 - Purchase of goods from EU countries
Used when
  • the Transaction type is 6 - Purchase
  • the Trade area is 2 - Within other EU country
  • Service type1 - Services is not selected
8 - Purchase of goods outside EU/Abroad
Used when
  • the Transaction type is 6 - Purchase
  • the Trade area is 3 - Outside EU/Abroad
  • Service type1 - Services is not selected
12 - Purchase of services abroad
Used when
  • the Transaction type is 6 - Purchase
  • the Trade area is 2 - Within other EU country or 5 - Transfer between other EU countries
  • Service type1 - Services is selected
14 - Non-taxable purchases
17 - Purchase outside tax area
19 - Purchase, taxable by purchaser
21 - Purchase of services from EU countries
23 - Domestic purchase of services
24 - Taxable product consumption
25 - Domestic purchases with reversed VAT liability
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTurnover classInteger
SQL nameTrnClThe database field name.
API identifierturnoverClassThe API identifier used in GraphQL.
Number6892 

Update order

Controls how orders will be updated when a voucher of this voucher type is updated.

When values have been entered in the Order no., Product no. fields on the voucher and are entered in the Voucher, and the value selected option 1 - Update order in this field, an order line will be added to the specified order when updating the voucher.

The order is updated as follows:

  • The quantity on the new order line is set as equal to the value in the Quantity field on the voucher, or 1 as the default value.
  • The price in default currency is set as equal to the amount after VAT divided by the quantity. The prices will be increased by the percentage entered in the Sales price addition % field for the specified product, if necessary in the order. Amounts and prices in the current currency are calculated on the basis of the Exchange rate field in the Order table.
  • The values in the Sup. no. and Empl. no. fields on the voucher are copied to the specified order.
  • The value in the Cust. no. is copied from the specified order to the Cust. no. field in the voucher.
  • The value in the Voucher date field on the voucher is copied to the Trans. date field on the new order line.

A look-up in this field gives you the following list of possible values:
1 - Update order
2 - Update prepayment status
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainUpdate orderInteger
SQL nameUpdOrdThe database field name.
API identifierupdateOrderThe API identifier used in GraphQL.
Number5737 

Voucher series no.

Selects the record in the Voucher series table to be used to suggest value in the Voucher no. field when the Voucher type is filled in on a voucher.

Note:
If there is a difference in the batch that the voucher belongs to, the value in the Voucher no. field is copied from the previous voucher.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVoucher series no.Integer
SQL nameSrNoThe database field name.
API identifiervoucherSeriesNoThe API identifier used in GraphQL.
Number6223 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
Voucher seriesVoucherSeries
  • Voucher series no.

Voucher type

A unique number identifying Voucher type.

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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVoucher typeInteger
Primary keyYesVoucher type
SQL nameVoTpNoThe database field name.
API identifiervoucherTypeThe API identifier used in GraphQL.
Number536 

Voucher type processing

Controls the processing of vouchers of this voucher type.

A look-up opens the dialog box where you can see the following check boxes and options:
Do not produce aut. gen. trans.
This selection field will be suggested on the voucher lines. If you select this field, the voucher lines will not be accumulated in the fields for automatic entry movements in the General ledger balance table. They will then not be included when you execute the Automatic entries processing in the General ledger account table.
Enter exchange rate
The cursor will stop in the Exchange rate field on the voucher line so that you can enter an exchange rate.
Move payment to workday
Business NXT will move the planned payment date to the previous/next working day for supplier transactions, depending of the Move to earlier date option under the Days without payment field in the Company information table.
Reverse invoice fee
This field is not currently in use.
Process write off
This field is not currently in use.
Always new voucher no. on '+'
Business NXT will always give a new voucher number even if the voucher does not go to 0.
Copy case no. to order no.
If you have selected the Case organisational units field in the Company information table and you enter an organisational unit on a voucher line, this value will be copied to the Order no. field on the voucher line. This requires an order number to have been entered. The selection field is mostly used by customers who use Visma Business Lawyer.
Voucher text to order line
The voucher text will be copied to the Description field on the order line. The selection requires you to have also selected the Update order field for the voucher type and entered a product number and order number on the voucher line.
Copy voucher no. to order line
If you have selected this field and selected 1 - Update order in the Update order field in the Voucher type table, the voucher number is copied to the Description field in the Order line table. The voucher number is placed at the beginning of the Description field in brackets.
Lock amounts on row
You will not be able to edit the Amount and Amount in currency fields on voucher lines when matching invoices against payments.
Update exchange rate from voucher date
Business NXT will update the voucher line’s exchange rate from the Currency rate or Currency rate 2 table when you change the voucher date. You can override this by selecting the Do not update exchange rate from voucher date field under Trans. status in the voucher line.
Note:
This selection may mean that the Exchange rate and Exchange rate 2 fields are changed on copied vouchers, and if there is a reversal there may be a difference.
Copy open entries on lookup
Business NXT will copy the open entries to the field for cross references so that you can see them when you perform a lookup in the field. This requires the Cross reference table to be linked to the Voucher table.
Note:
There are restrictions as to how many tables and fields you can include data from, when you are using the "Copy open entries from open entries to cross references on lookup field" matching method, as the data is only imported into one memory, and is not in the rows in the Cross reference table before saving. This also means that included fields disappear if you search or refresh before saving. All the entries that are not selected for payment in the Payment reg. field from the Cross reference table will disappear when you save.
Ignore cross account no.
If you select this field for a voucher type, the customer/supplier cross-account will not be retrieved for transactions with this voucher type during voucher entry.
Do not update amount
The amount will not be updated with the accounting transactions.

You can select this check box if you want to make currency adjustments and there is no need for double entries.

Note:
If you have selected the Do not update amount check box under Voucher type processing in the Voucher type table, you do not need to have Amount in the voucher line, even if you have selected Voucher must have amount in the Company information table.
Do not update currency amount
The amount in currency will not be updated with the accounting transactions.

You can select this check box if you want to make currency adjustments and there is no need for double entries.

Note:
If you have selected the Do not update currency amount check box under Voucher type processing in the Voucher type table, you do not need to have Amount in the voucher line, even if you have selected Voucher must have amount in the Company information table.
Do not update currency amount 2
The amount in currency 2 will not be updated with the accounting transactions.

You can select this check box if you want to make currency adjustments and there is no need for double entries.

Note:
If you have selected the Do not update currency amount 2 check box under Voucher type processing in the Voucher type table, you do not need to have Amount in the voucher line, even if you have selected Voucher must have amount in the Company information table.
Use VAT amount from voucher line
The VAT amount from the voucher line is used instead of the amount being calculated on the basis of the VAT code in the general ledger account. This selection is only used if you have the value 2 - VAT of amount after cash discount in the Cash discount processing field in the Company information table. This field is only used in the UK.
Obligatory CID from supplier
The voucher types where there will be a mandatory CID code when you enter voucher lines for selected suppliers. This means the suppliers for whom the Supplier options/Obligatory CID for defined voucher types check box is selected.

When you enter a voucher type with "Mandatory CID from supplier" selected in the voucher line, Business NXT checks whether Obligatory CID for defined voucher types is selected under Supplier options in the Associate table. If Obligatory CID for defined voucher types is selected, the CID code field in the voucher line is marked with a red "?" if the field is not filled in. You will not be able to execute the Update batch processing for the voucher if the CID code is marked with a red "?".

Note:
This control is not implemented in the Received invoice dialog box in the Order table, but the voucher will have a red "?" in the CID code field.
Exempt from expanding on voucher lines
Automatic entries are exempted from expanding on voucher lines when you have the value 1 - Expand on voucher lines in the Auto.entry processing dialog box in the General ledger account table or the Automatic entry table.
Use for rule suggestions
When enabled, updated vouchers of this voucher type will be used for creating rule suggestions by the Suggest rules processing in the Accounting rule criteria table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVoucher type processingInteger
SQL nameVoTpPrcThe database field name.
API identifiervoucherTypeProcessingThe API identifier used in GraphQL.
Number7892 

W/off variance cash discount %

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
SQL namePmVCshPThe database field name.
API identifierwriteOffVarianceCashDiscountPercentThe API identifier used in GraphQL.
Number11079 

W/off variance misc. %

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
SQL namePmVOtPThe database field name.
API identifierwriteOffVarianceMiscPercentThe API identifier used in GraphQL.
Number11080 

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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA 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. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA 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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA 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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 17. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.