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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | Per | The database field name. |
| API identifier | accrualAccounting | The API identifier used in GraphQL. |
| Number | 5797 |
Additional text definition
A macro that generates a text in the Additional text field in the Voucher table during manual registration.
- Updating vouchers.
- Batches generated by other subsystems.
- Batches that have been imported.
- @System (Field name)
- @Firm (Field name)
- @Voucher (Field name)
You select the field name under the Field button.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Additional text definition | Text (128) |
| SQL name | Txt2Def | The database field name. |
| API identifier | additionalTextDefinition | The API identifier used in GraphQL. |
| Number | 12371 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | AffTrn | The database field name. |
| API identifier | affectsTurnoverOrPurchase | The API identifier used in GraphQL. |
| Number | 540 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | CompExRt | The database field name. |
| API identifier | calculateExchangeRate | The API identifier used in GraphQL. |
| Number | 6591 |
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.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Capital asset proc. | Integer |
| SQL name | PropPrc | The database field name. |
| API identifier | capitalAssetProcessing | The API identifier used in GraphQL. |
| Number | 5416 |
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.
- 1 - Outlay
- 2 - Client responsibility 1
- 3 - Client responsibility 2
- 4 - Client responsibility 3
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Client processing | Integer |
| SQL name | ClPrc | The database field name. |
| API identifier | clientProcessing | The API identifier used in GraphQL. |
| Number | 8432 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | CrAc | The database field name. |
| API identifier | creditAccountNo | The API identifier used in GraphQL. |
| Number | 2276 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | CreditAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | DbAc | The database field name. |
| API identifier | debitAccountNo | The API identifier used in GraphQL. |
| Number | 2275 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | DebitAccount |
|
Debt collection voucher type
- Payment
- Credit
- Interest and fee
- Settlement / Loss / Correction
- Invoice
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Debt collection voucher type | Integer |
| SQL name | DColVoTp | The database field name. |
| API identifier | debtCollectionVoucherType | The API identifier used in GraphQL. |
| Number | 18875 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | StdTxt | The database field name. |
| API identifier | defaultText | The API identifier used in GraphQL. |
| Number | 537 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | dontCreateAutomaticallyGeneratedTransactions | The API identifier used in GraphQL. |
| Number | 7891 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | InpCur | The database field name. |
| API identifier | enterCurrency | The API identifier used in GraphQL. |
| Number | 539 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | enterExchangeRate | The API identifier used in GraphQL. |
| Number | 8319 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | InpTxt | The database field name. |
| API identifier | enterText | The API identifier used in GraphQL. |
| Number | 538 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | ExAut | The database field name. |
| API identifier | exemptFromAutomaticEntry | The API identifier used in GraphQL. |
| Number | 6626 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | SugAm | The database field name. |
| API identifier | fillInOutstandingAmount | The API identifier used in GraphQL. |
| Number | 2277 |
Ignore VAT code
Determines if an option should be set on the voucher to skip tax code related functionality.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | IgnTxCd | The database field name. |
| API identifier | ignoreTaxCode | The API identifier used in GraphQL. |
| Number | 541 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | movePaymentToWorkday | The API identifier used in GraphQL. |
| Number | 9267 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 3703 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 3704 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 3705 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 3706 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 3707 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 3708 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
Omitted
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 9636 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
Omitted
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 9637 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
Omitted
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 9638 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
Omitted
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 9639 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
Omitted
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 9640 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
Omitted
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 9641 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Page elem. no.
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 | PgElNo | The database field name. |
| API identifier | pageElementNo | The API identifier used in GraphQL. |
| Number | 8758 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment priority | Integer |
| SQL name | Pri | The database field name. |
| API identifier | priority | The API identifier used in GraphQL. |
| Number | 4777 |
Product no.
The default value to be suggested in the Product no. field when the Voucher type field is filled in on a voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product no. | Text (40) |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 13808 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | RepInf | The database field name. |
| API identifier | repeatInformation | The API identifier used in GraphQL. |
| Number | 6658 |
Standard voucher type
Not in use.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Standard voucher type | Integer |
| SQL name | VsVoTp | The database field name. |
| API identifier | standardVoucherType | The API identifier used in GraphQL. |
| Number | 18360 |
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.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Turnover class | Integer |
| SQL name | TrnCl | The database field name. |
| API identifier | turnoverClass | The API identifier used in GraphQL. |
| Number | 6892 |
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.
- 1 - Update order
- 2 - Update prepayment status
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Update order | Integer |
| SQL name | UpdOrd | The database field name. |
| API identifier | updateOrder | The API identifier used in GraphQL. |
| Number | 5737 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher series no. | Integer |
| SQL name | SrNo | The database field name. |
| API identifier | voucherSeriesNo | The API identifier used in GraphQL. |
| Number | 6223 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher series | VoucherSeries |
|
Voucher type
A unique number identifying Voucher type.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher type | Integer |
| Primary key | Yes | Voucher type |
| SQL name | VoTpNo | The database field name. |
| API identifier | voucherType | The API identifier used in GraphQL. |
| Number | 536 |
Voucher type processing
Controls the processing of vouchers of this voucher type.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher type processing | Integer |
| SQL name | VoTpPrc | The database field name. |
| API identifier | voucherTypeProcessing | The API identifier used in GraphQL. |
| Number | 7892 |
W/off variance cash discount %
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 | Percent | Decimal |
| SQL name | PmVCshP | The database field name. |
| API identifier | writeOffVarianceCashDiscountPercent | The API identifier used in GraphQL. |
| Number | 11079 |
W/off variance misc. %
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 | Percent | Decimal |
| SQL name | PmVOtP | The database field name. |
| API identifier | writeOffVarianceMiscPercent | The API identifier used in GraphQL. |
| Number | 11080 |
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.
| 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. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |