Voucher
This table contains one row for each line in a batch of vouchers.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | WaVo | The table name in the database. |
| API identifier | voucher | The API identifier used in GraphQL. |
| Table no. | 45 | The table number in the data model. |
The following fields exist in this table:
Account statement trans. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | AcStmtTrNo | The database field name. |
| API identifier | accountStatementTransactionNo | The API identifier used in GraphQL. |
| Number | 18965 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Account statement transaction | AccountStatementTransaction |
|
Accounting document no.
The accounting document no refers to Accounting document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | InAcDocNo | The database field name. |
| API identifier | incomingAccountingDocumentNo | The API identifier used in GraphQL. |
| Number | 17921 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting document | IncomingAccountingDocument |
|
Accounting rule no.
Accounting rule no. coming from Accounting rule criteria table.
It is possible to manually select an accounting rule on the voucher line.
Values on the voucher line will be filled from the accounting rule. It is possible to discard changes from the rule, and then roll back to the previously saved state.
It is possible to change what rule is applied by selecting another rule.
When accounting rule is selected manually, any rule can be selected and no validation is done against Accounting rule criteria.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | AcRuleNo | The database field name. |
| API identifier | accountingRuleNo | The API identifier used in GraphQL. |
| Number | 19018 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting rule criteria | AccountingRuleCriteria |
|
Accrual accounting end year/period
The date on which the accrual accounting of the Voucher is to end.
- Using the Accrual accounting processing.
- Using the Period key field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| SQL name | PEnYrPr | The database field name. |
| API identifier | accrualAccountingEndYearAndPeriod | The API identifier used in GraphQL. |
| Number | 11992 |
Accrual accounting start year/period
The date on which the accrual accounting of the Voucher is to start.
- Using the Accrual accounting processing.
- Using the Period key field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| SQL name | PStYrPr | The database field name. |
| API identifier | accrualAccountingStartYearAndPeriod | The API identifier used in GraphQL. |
| Number | 11991 |
Additional text
A supplementary description of the voucher.
An extra text to describe the voucher and its content can be entered in this field
If you have entered a macro in Additional text definition field in the Voucher type table, the field is filled in during manual Voucher registration. It will also be filled in in connection with:
- Updating Voucher lines.
- Batches generated by other subsystems.
- Batches that have been imported.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Txt2 | The database field name. |
| API identifier | additionalText | The API identifier used in GraphQL. |
| Number | 5815 |
Amount
The amount of the current voucher.
If you use tax codes to post taxes during voucher updates, you must enter the gross amount, i.e. the amount inclusive of any VAT in this field, since the Amount excl. VAT and the VAT amount will be calculated from the gross amount
If you want to post the same amounts to the Debit account and Credit account, you can enter both accounts in the same voucher line with the same amount. If a group voucher is being entered, e.g. from the bank or Post Office, and the amount is to be divided between several general ledger accounts, the voucher must be entered over several lines. If you enter + in the Amount field, the difference between the Total debit and the Total credit fields in the batch will be suggested. If the difference is 0, the amount from the voucher line above will be copied, as when entering / in the field. The cursor moves to the next field, which means that you do not have to press Enter.
Accrual accounting
If you have a Voucher type record where the Accrual accounting field is selected or where the reference to the General ledger account table from the Debit account/Credit account field have Accrual accounting selected. Then a flag is placed in the Voucher to tell you that the accrual accounting dialog box will appear when you enter something in the Amount or Amount in currency field.
See also: Accrual accounting
Expanding automatic entries
If you select 1 - Expand on voucher lines in the Auto. entry processing field for the General ledger account table or in the Automatic entry table the automatic entries will be expanded in the entry window. The automatic entries appear when you enter values in the Amount field or in the Amount in currency field.
See also: Expand automatic entries
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | Am | The database field name. |
| API identifier | amountDomestic | The API identifier used in GraphQL. |
| Number | 889 |
Amount excl. VAT
The amount excl. VAT of the voucher.
The Amount excl. VAT check box in the Trans. status field is selected to show you that you have value in the Amount excl. VAT field. You can see this in the dialog box that appears when you double-click or press * in the Trans. status field. If you complete the Amount field afterwards, the check box is cleared.
If you complete this field, the Amount field is calculated and then the VAT amount field will be calculated.
If you override the VAT amount, the Amount excl. VAT field is recalculated if the flag in the Trans. status is not set, otherwise the value in the Amount field is recalculated.
If you update the Debit VAT code/Credit VAT code fields, the program will not recalculate the VAT amount or Amount fields, unless the Amount excl. VAT is re-entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | AmExVAT | The database field name. |
| API identifier | amountExclusiveVatDomestic | The API identifier used in GraphQL. |
| Number | 8520 |
Amount excl. VAT in currency
The amount excl. VAT in currency of the voucher
When you fill this field, the Amount in currency field is calculated and then the VAT amount in currency field will be calculated.
If you update the Debit VAT code/Credit VAT code fields, the program will not recalculate the VAT amount in currency or Amount in currency fields, unless the Amount excl. VAT in currency is re-typed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CurAmExVat | The database field name. |
| API identifier | amountExclusiveVatInCurrency | The API identifier used in GraphQL. |
| Number | 18158 |
Amount in currency
The amount in currency of the voucher.
- The Sales rate field in the Currency rate table where the From date equals or is less than the Voucher date on the Voucher line.
- The Sales rate field from the Currency table.
If Enter currency field is selected for the Voucher type that is used, the cursor pauses in the Currency no. field and the Amount in currency field and skips the Amount field. The Amount field is calculated as soon as the Amount in currency field is entered, or if the Currency no., Exchange rate or Amount in currency fields are updated.
If you update the Amount field, the Amount in currency field is calculated immediately and the Exchange rate remains unchanged. However, if you want the Exchange rate field to be updated when you update the Amount in currency field or the Amount field, you must select the Calculate cur. rate field in the Voucher type table.
In the same way as the Amount field, the Amount in currency field is added up for general ledger accounts, customers and suppliers, and you can print out these on account statements and balance lists. The balance tables only store the balance for the currency defined for the particular general ledger account, as well as the balance in the domestic currency.
If the domestic amount is entered, the balance for the customer is not accumulated in the foreign currency when the voucher line is updated, even if the Currency no. is entered for the customer. Similarly, if no currency is defined for the sales account in the General ledger account table, no general ledger balance will be calculated in foreign currency.
If you enter + in the Amount in currency field the cursor skips to the next field without entering a value. It is then easier for you to load the outstanding amount when using currency, and you also avoid differences.
Amount in currency without VAT.
The Amount in currency fields for General ledger transactions and Capital asset transactions is calculated on the basis of the amount posted, i.e. after the deduction of VAT. The amount is reduced by the same percentage as the Posted amount in relation to the Entered amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CurAm | The database field name. |
| API identifier | amountInCurrency | The API identifier used in GraphQL. |
| Number | 888 |
Amount in currency 2
The amount in currency 2 of the voucher.
If you change the value in the Exchange rate 2 field or the Amount field in the base currency in a voucher line, these values will be used as a basis for calculating the Amount in currency 2 field. If you override the Amount in currency 2 field then the Exchange rate 2 field is recalculated, unless you leave the field blank or the Amount in the base currency is not entered.
The amount in base currency is:
- Amount in currency, if you have selected the Calculate "Amount in currency 2" from "Currency amount" check box in the Accounting processing field in the Company information table, and the Amount in currency field is filled in on the Voucher line.
and if not the base currency is:
- Amount
Amount in currency 2 without VAT.
Amount in currency 2 for General ledger transaction and Capital asset transaction is calculated on the basis of the Amount posted, i.e. after the deduction of VAT. The amount is reduced by the same percentage as the Posted amount in relation to the Entered amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CurAm2 | The database field name. |
| API identifier | amountInCurrency2 | The API identifier used in GraphQL. |
| Number | 14350 |
Amount in EURO
The Amount field converted to EURO.
If the standard currency, given in the Company information table is defined as Currency type 2 or 3 in the Currency table, the Amount in EURO will be calculated with the exchange rate given for Euro in Sales rate field in the Currency table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | amountInEuro | The API identifier used in GraphQL. |
| Number | 7766 |
Approval token
Token for payment pre-approved in Visma.net AutoPay.
The transaction has been approved for payment in Visma.net Approval. When this token follows the payment, approval of the payment in Visma.net AutoPay should not be required.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Approval token | Text (40) |
| SQL name | ApTk | The database field name. |
| API identifier | approvalToken | The API identifier used in GraphQL. |
| Number | 18562 |
Approval workflow handle
Reference to a workflow in Visma.net Approval.
Used in Visma.net AutoPay for viewing of invoices.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Approval workflow handle | Text (36) |
| SQL name | ApWfH | The database field name. |
| API identifier | approvalWorkflowHandle | The API identifier used in GraphQL. |
| Number | 18819 |
Auth. responsible
If you are entering an incoming invoice that shall be authorised, the employee number of the authorisation official must be entered here.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | Att | The database field name. |
| API identifier | approvalOfficial | The API identifier used in GraphQL. |
| Number | 904 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ApprovalOfficial |
|
AutoPay log seq. no.
Reference to the Identifier column in Visma.net AutoPay log table, where the actual incoming payment file is stored.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | ApLSeqNo | The database field name. |
| API identifier | autopayLogEntryNo | The API identifier used in GraphQL. |
| Number | 19624 |
AutoPay payment reference
Reference to an incoming payment imported from Visma.net AutoPay.
Details about the payment can be seen using the View payment details processing.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | AutoPay payment reference | Text (100) |
| SQL name | ApPmtRef | The database field name. |
| API identifier | autopayPaymentReference | The API identifier used in GraphQL. |
| Number | 18212 |
Bank account
This field overrides the bank account from the Associate table when creating a payment from an incoming invoice.
When you transfer Customer transactions and Supplier transactions to the Payment line table, this bank account for the transactions will override the Bank account field from the Associate table. You can later override or delete the Bank account in the Payment line table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | BankG | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 5816 |
Bank account line no.
The reference to the Bank account table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | BankAcLn | The database field name. |
| API identifier | bankAccountLineNo | The API identifier used in GraphQL. |
| Number | 11463 |
Bank amount
The amount on the bank voucher relating to a deposit from the customer or a payment to the supplier.
The field is to be filled out manually with the amount from a bank statement and is used to reconciliate the amount when it is filled out by accumulating amounts from the Cross reference table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | BankAm | The database field name. |
| API identifier | bankAmountDomestic | The API identifier used in GraphQL. |
| Number | 12355 |
Bank no.
A unique number identifying the bank in the Bank table.
The field has no function in electronic funds transfer.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank no. | Integer |
| SQL name | BankCon | The database field name. |
| API identifier | bankNo | The API identifier used in GraphQL. |
| Number | 11462 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Bank | Bank |
|
Bank reference
The bank's reference for the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank reference | Text (30) |
| SQL name | BankRef | The database field name. |
| API identifier | bankReference | The API identifier used in GraphQL. |
| Number | 18778 |
Batch no.
The batch to which the Voucher belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Batch no. | Integer |
| Primary key | Yes | Batch no., Line no. |
| SQL name | BndNo | The database field name. |
| API identifier | batchNo | The API identifier used in GraphQL. |
| Number | 873 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Batch | Batch |
| ||
| Voucher | Voucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Cap. asset no.
Filled out automatically when a Capital asset no is entered in the Debit account or Credit account fields.
If you have selected the Repeat info. check box in the Voucher type table, the value in this field is copied to the subsequent voucher line that have the same voucher no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| SQL name | PropNo | The database field name. |
| API identifier | capitalAssetNo | The API identifier used in GraphQL. |
| Number | 5774 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | CapitalAsset |
|
Capital asset proc.
The type of processing for the capital asset.
It is mandatory to fill out the field if the Debit account type field or the Credit account type field have the value 4 (Capital asset account) otherwise it will not be possible to update the Batch record
The field can be suggested on the basis of the Voucher type field in the Voucher table.
- 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 | No | This field is not 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 | 5417 |
Cash amount
The domestic cash amount of the current voucher.
When you complete the Amount field in a voucher line, the cash amount is displayed in the Cash amount and Cash amount in currency fields. You can override the value in these fields. If you only enter the Cash amount, the value in the Amount field is assigned the same value as the one in the Cash amount field. This is done when posting invoices, i.e. debiting customers or crediting suppliers. The calculated amount is dependent on settings in the Cash discount processing in the Company information table. Depending on settings in the Accounting processing in the Company information table, it might also be calculated on payment vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CshAm | The database field name. |
| API identifier | cashAmountDomestic | The API identifier used in GraphQL. |
| Number | 6233 |
Cash amount in currency
The cash amount in currency of the voucher line.
When you complete the Amount field in a voucher line, the cash amount is displayed in the Cash amount and Cash amount in currency fields. You can override the value in these fields. If you only enter the Cash amount, the value in the Amount field is assigned the same value as the one in the Cash amount field. This is done when posting invoices, i.e. debiting customers or crediting suppliers. The calculated amount is dependent on settings in the Cash discount processing in the Company information table. Depending on settings in the Accounting processing in the Company information table, it might also be calculated on payment vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CshCurAm | The database field name. |
| API identifier | cashAmountInCurrency | The API identifier used in GraphQL. |
| Number | 6232 |
Cash amount in EURO
The Cash amount in currency value converted into EURO.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Cash amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | cashAmountInEuro | The API identifier used in GraphQL. |
| Number | 7820 |
Cash due date
The cash due date.
The Cash due date is derived from Payment terms and the Voucher date field. If no Payment terms have been specified, the Cash due date field will be empty, and the Due date field is calculated on the basis of the Voucher date + 30 days. The Cash due date field is also empty if no credit days or months are specified for the Payment terms.
If the Cash due date field is empty when the Voucher is updated, it is assigned the same value as the Due date of the transactions.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | CshDueDt | The database field name. |
| API identifier | cashDueDate | The API identifier used in GraphQL. |
| Number | 6231 |
CID code
The CID code for the voucher.
On incoming invoices you can enter a CID code (customer identification code) for use in the context of automatic funds transfers.
If the supplier uses giros with its own CID field, it is strongly recommended to quote the CID code when transferring payment. The CID code is normally made up of the invoice number, customer number and/or the due date.
For outgoing invoices from the order module, this field will be filled in with the CID code of the printed invoice.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | CID code | Text (30) |
| SQL name | CID | The database field name. |
| API identifier | cid | The API identifier used in GraphQL. |
| Number | 909 |
Client processing
The field is used to manage vouchers related to client accounts.
The field shall only be used in combination with a Debit account or Credit account concerning customers and is to be used in businesses where one possesses and manage cash on a clients account, eg law firms.
- 1 - Outlay
- 2 - Client responsibility 1
- 3 - Client responsibility 2
- 4 - Client responsibility 3
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | 8433 |
Cost amount
Non-deductible input VAT.
The value is derived from the VAT amount and an eventual Cost % given in the VAT code table for the Debit VAT code or Credit VAT code given on the voucher.
The Cost amount will only be filled out on voucher lines with a Turnover class that produces both input and output VAT. It will not be filled out on voucher lines with a Turnover class that produces only input vat, for these voucher lines, the Cost amount will be calculated when updating the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CstAm | The database field name. |
| API identifier | costAmountDomestic | The API identifier used in GraphQL. |
| Number | 9003 |
Country no.
Used for OSS VAT handling.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Country no. | Integer |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 17539 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | Country |
|
Credit account
The credit account no.
Business NXT differentiates between general ledger accounts, capital asset accounts and customer / supplier ledger accounts on the basis of the account number ranges defined in the Account no. series table, or via the associated Account type field. When you enter an account number, the name of the customer, supplier, general ledger account or capital asset appears in the Status bar. This enables you to check that you have entered the correct number. You can decide whether to post a voucher on a single line containing both the debit account and credit account, or to use separate voucher lines for the debit and credit entries.
If you enter + in one of the fields for Debit account or Credit account and you have already filled in the Cust. no. or Sup. no. field, a cross-account is suggested. You define the cross-account for each individual customer and supplier in the Associate table. If a customer no. or a supplier no. is entered as debit account or credit account the cross account will be filled out automatically if given in the Associate table.
If you enter an account number in this field and it falls within the number series for customers, suppliers or capital assets, and then perform a look-up in the field, you call up a list of customers, suppliers or capital assets that have been entered.
You can edit the look-up window as a normal page element if you want to change the details for an existing customer, supplier, general ledger account or capital asset. The same applies if you want to create new ones. This requires that the look-up window has not been stored in the layout as non-editable.
When you enter a general ledger account number, the currency no., tax code and/or organisational unit will be suggested. When you enter a capital asset number, the tax code will be suggested if you have entered this for the capital asset. When you enter a customer / supplier number, the Currency no. field will be suggested if you have entered this for the customer or the supplier. If the Debit account and Credit account specify different codes, the account entered first is suggested. If you delete or change an account number once it is entered, the corresponding tax code field is deleted or changed accordingly.
When you enter a customer number or a supplier number in the Debit account or the Credit account field then the Cust. no. field or the Sup. no. field is updated with the same value. The same applies when you enter an Order no.
The customer number or supplier number is also included in the General ledger transaction record for sales/purchases.
If the value in the Debit account or the Credit account field is deleted, the values in the organisational units fields from that voucher are removed as well.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | CrAcNo | The database field name. |
| API identifier | creditAccountNo | The API identifier used in GraphQL. |
| Number | 884 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | CreditCustomer |
| ||
| Associate | CreditSupplier |
| ||
| General ledger account | CreditGeneralLedgerAccount |
| ||
| Capital asset | CreditCapitalAsset |
| ||
| All accounts | CreditAllAccounts |
| ||
| Open customer entry | CreditCustomerCrossReference |
| ||
| Open supplier entry | CreditSupplierCrossReference |
|
Credit account type
Indicates whether the Debit account or Credit account field refers to a customer, a supplier, a capital asset or a general ledger account.
If you adhere to the account ranges defined in the Account no. series table, it is a good idea to hide the Debit account type and Credit account type fields. In this case, all account numbers are unique, and the account type is derived from the account number. The account type codes are defined permanently by the system.
- 1 - Customer
- The account number refer to a customer.
- 2 - Supplier
- The account number refer to a supplier.
- 3 - General ledger account
- The account number refer to a general ledger account.
- 4 - Capital asset
- The account number refer to a capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account type | Integer |
| SQL name | CrAcCl | The database field name. |
| API identifier | creditAccountType | The API identifier used in GraphQL. |
| Number | 883 |
Credit auto. st.
If you have posted vouchers to a general ledger account for which Auto. entry processing are defined, you can call up a status field for the automatic posting process.
- 1 - Unexpanded automatic entry head
- An automatic entry is defined for the general ledger account, but it is not expanded. You can expand it by selecting the processing Expand automatic entries in the Voucher table.
- 2 - Expanded automatic entry head
- The voucher line has been expanded in one or more automatic entry lines, either automatically or using the processing Expand automatic entries.
- 3 - Automatic entry line
- The voucher line is an automatic entry line defined for the relevant general ledger account in the Automatic entry table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Aut. entry status | Integer |
| SQL name | CrAutSt | The database field name. |
| API identifier | creditAutomaticStatus | The API identifier used in GraphQL. |
| Number | 3681 |
Credit turnover cl.
Form the basis for printing tax statements.
If a Turnover class has been entered for a Voucher type record, this turnover class is suggested when you enter a value in the Voucher type field on the Voucher line. The value in the Credit turnover cl. field is not overwritten when you fill in the Debit account or the Credit account field.
If Turnover class has not been entered on the Voucher type record, the Credit turnover cl. field is suggested when the following is entered in the Debit account or Credit account fields:
- a customer no. or supplier no., and VAT code cust. or VAT code sup. field and area have been entered for the customer/supplier.
- a number and turnover class has been entered for the general ledger account.
If you enter a value both in the Debit account and the Credit account field, the turnover class for the relevant general ledger account is used.
The General ledger transaction are entered for the turnover class, and form the basis for printing tax statements.
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 | No | This field is not visible by default in the table display. |
| Domain | Turnover class | Integer |
| SQL name | CrTrnCl | The database field name. |
| API identifier | creditTurnoverClass | The API identifier used in GraphQL. |
| Number | 6893 |
Credit VAT code
Determines whether Business NXT calculates input or output VAT for the voucher.
Tax computation is performed when the vouchers are updated. You enter the gross amounts in the vouchers. Business NXT subtracts any VAT and posts it to the specified tax accounts. You can neglect entering a value in the Credit VAT code field and post the taxes manually to the tax account on a separate voucher if you wish. This is however not recommended, since you will not be able to use the standard VAT report form distributed with the program.
If you enter vouchers for a general ledger account or capital asset account with a defined VAT code, this VAT code is suggested. The cursor will move to the next field. You can return to the Credit VAT code field and change the code even if the cursor does not pause there.
If you enter a value in the Cust. no. or Sup. no. field, the customers/suppliers tax code will be suggested. This applies if you have selected Suggest VAT code in the Customer options field and in the Supplier options field respectively in the Associate table.
Exception 1 If you have selected Enter VAT code in the General ledger account table for the Account no. for which you are posting the voucher, the cursor will always pause in the Credit VAT code field.
Exception 2 If you have selected Ignore VAT code in the Voucher type table for the Voucher type used to post the voucher then the Credit VAT code is not suggested, even if one is defined for the General ledger account.
If there is no Turnover class on the General ledger account, it will be retrieved from the VAT code.
If you delete the value in the Credit VAT code field, the VAT amount will be removed in the voucher. This does not apply if you have overridden the VAT amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | CrTxCd | The database field name. |
| API identifier | creditTaxCode | The API identifier used in GraphQL. |
| Number | 885 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | CreditTaxCode |
|
Cross reference
The cross reference when matching payment voucher against open customer / supplier entries.
The Reference field on open customer / supplier entries will be matched against the Cross reference on payment vouchers if 4 - Entered references is chosen as the Matching method in the Company information table.
Normally the voucher is filled in with Customer no or a Supplier no in the Credit account or Debit account field. If a Cross reference thereafter is entered that matches the Reference on an open entry for the entered Customer no or Supplier no, the Outstanding amount and Outstanding amount in currency fields from the Open customer entry/Open supplier entry tables will be copied to the Amount and Amount in currency fields. If the vouchers Voucher date is within the open entries Cash due date, the Rest cash amount and Rest cash amount in currency will update the Amount and Amount in currency fields.
A look-up can be performed to get an overview over the open entries. If <Ctrl>+<Enter> is pressed, the Outstanding amount in currency and Outstanding amount in currency fields from the focused open entry will be copied into the voucher line. (Or the Rest cash amount and Rest cash amount in currency fields if the Voucher date falls within the Cash due date. The Reference will be copied to the voucher line`s Cross reference field.
If the open entry in the look-up is highlighted, and <Ctrl>+<Enter> is pressed only the amounts will be copied and the Cross reference will be reflected on a new line in the Cross reference table instead of in the Cross reference field.
If more than one open entry in the look-up is highlighted, and <Ctrl>+<Enter> is pressed, the sum of the open entries will be copied to the amount fields and all the open entries Cross reference will be reflected on new lines in the Cross reference table.
If a voucher type with the option Copy voucher no. to order line has been used on the voucher and a look-up is performed, the open entries related to the customer no / supplier no entered as Credit account or Debit account will be copied to the Cross reference. In the Cross reference table, the field Payment reg. can be ticked, to distribute the invoice amount to the Amount and the Amount in currency fields in the voucher. A part payment can also be registered in the Part payment or Part payment in currency field in the Cross reference table, this will only distribute the part payment amount to the Amount and the Amount in currency fields in the Voucher table.
If no Customer no or Supplier no is entered as Credit account or Debit account on the voucher and a value is entered in the Cross reference field, a search for an open entry with a matching reference will be performed, where the Open customer entry will be searched prior to the Open supplier entry. If a match is found, the amount will be filled in from the open entry and the Customer no / supplier no will be filled in as Credit account or Debit account.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| SQL name | AgRef | The database field name. |
| API identifier | crossReference | The API identifier used in GraphQL. |
| Number | 899 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Open customer entry | CustomerCrossReferenceDebit |
| ||
| Open supplier entry | SupplierCrossReferenceDebit |
| ||
| Open customer entry | CustomerCrossReferenceCredit |
| ||
| Open supplier entry | SupplierCrossReferenceCredit |
| ||
| Open customer entry | CustomerCrossReferenceBlank |
|
Currency no.
A currency for the voucher.
When you enter an account number, a Currency no. with its associated Calculate rate is suggested if one is defined for the general ledger account, customer, supplier or capital asset in question. If a voucher is posted to two accounts with references to different currency codes, the currency is determined by the account entered first. The cursor can be forced to stop in the field by the option Enter currency in the Voucher type.
When you enter vouchers in the currency defined for the account, a separate currency balance is maintained in the Customer balance, Supplier balance or General ledger balance tables after updating the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 886 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Currency no. 2
A currency number two for the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur2 | The database field name. |
| API identifier | currencyNo2 | The API identifier used in GraphQL. |
| Number | 14348 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency2 |
|
Cust. no.
The customer number the voucher applies to.
The field is filled out automatically if a customer no is used in the Debit account or the Credit account field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cust. no. | Integer |
| SQL name | Cust | The database field name. |
| API identifier | customerNo | The API identifier used in GraphQL. |
| Number | 906 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Customer |
|
Date 1
This field is used by some bank reconciliation systems to assign a date to processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. If bank reconciliation is not in use the field can be used manually, or an external application can use the field via BIG.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | Dt1 | The database field name. |
| API identifier | date1 | The API identifier used in GraphQL. |
| Number | 11254 |
Date 2
This field is used by some bank reconciliation systems to assign a date to processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. If bank reconciliation is not in use the field can be used manually, or an external application can use the field via BIG.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | Dt2 | The database field name. |
| API identifier | date2 | The API identifier used in GraphQL. |
| Number | 11255 |
Debit account
The debit account no.
Business NXT differentiates between general ledger accounts, capital asset accounts and customer / supplier ledger accounts on the basis of the account number ranges defined in the Account no. series table, or via the associated Account type field. When you enter an account number, the name of the customer, supplier, general ledger account or capital asset appears in the Status bar. This enables you to check that you have entered the correct number. You can decide whether to post a voucher on a single line containing both the debit account and credit account, or to use separate voucher lines for the debit and credit entries.
If you enter + in one of the fields for Debit account or Credit account and you have already filled in the Cust. no. or Sup. no. field, a cross-account is suggested. You define the cross-account for each individual customer and supplier in the Associate table. If a customer no. or a supplier no. is entered as debit account or credit account the cross account will be filled out automatically if given in the Associate table.
If you enter an account number in this field and it falls within the number series for customers, suppliers or capital assets, and then perform a look-up in the field, you call up a list of customers, suppliers or capital assets that have been entered.
You can edit the look-up window as a normal page element if you want to change the details for an existing customer, supplier, general ledger account or capital asset. The same applies if you want to create new ones. This requires that the look-up window has not been stored in the layout as non-editable.
When you enter a general ledger account number, the currency no., tax code and/or organisational unit will be suggested. When you enter a capital asset number, the tax code will be suggested if you have entered this for the capital asset. When you enter a customer / supplier number, the Currency no. field will be suggested if you have entered this for the customer or the supplier. If the Debit account and Credit account specify different codes, the account entered first is suggested. If you delete or change an account number once it is entered, the corresponding tax code field is deleted or changed accordingly.
When you enter a customer number or a supplier number in the Debit account or the Credit account field then the Cust. no. field or the Sup. no. field is updated with the same value. The same applies when you enter an Order no.
The customer number or supplier number is also included in the General ledger transaction record for sales/purchases.
If the value in the Debit account or the Credit account field is deleted, the values in the organisational units fields from that voucher are removed as well.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | DbAcNo | The database field name. |
| API identifier | debitAccountNo | The API identifier used in GraphQL. |
| Number | 881 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | DebitCustomer |
| ||
| Associate | DebitSupplier |
| ||
| General ledger account | DebitGeneralLedgerAccount |
| ||
| Capital asset | DebitCapitalAsset |
| ||
| All accounts | DebitAllAccounts |
| ||
| Open customer entry | DebitCustomerCrossReference |
| ||
| Open supplier entry | DebitSupplierCrossReference |
|
Debit account type
The account type indicates whether the account number refers to a customer, a supplier, a capital asset or a general ledger account.
If you adhere to the account ranges defined in the Account no. series table, it is a good idea to hide the Debit account type and Credit account type fields. In this case, all account numbers are unique, and the Debit account type is derived from the account number.
- 1 - Customer
- The account number refer to a customer.
- 2 - Supplier
- The account number refer to a supplier.
- 3 - General ledger account
- The account number refer to a general ledger account.
- 4 - Capital asset
- The account number refer to a capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account type | Integer |
| SQL name | DbAcCl | The database field name. |
| API identifier | debitAccountType | The API identifier used in GraphQL. |
| Number | 880 |
Debit auto. st.
If you have posted vouchers to a general ledger account for which Auto. entry processing are defined, you can call up a status field for the automatic posting process.
- 1 - Unexpanded automatic entry head
- An automatic entry is defined for the general ledger account, but it is not expanded. You can expand it by selecting the processing Expand automatic entries in the Voucher table.
- 2 - Expanded automatic entry head
- The voucher line has been expanded in one or more automatic entry lines, either automatically or using the processing Expand automatic entries.
- 3 - Automatic entry line
- The voucher line is an automatic entry line defined for the relevant general ledger account in the Automatic entry table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Aut. entry status | Integer |
| SQL name | DbAutSt | The database field name. |
| API identifier | debitAutomaticStatus | The API identifier used in GraphQL. |
| Number | 3680 |
Debit turnover cl.
Form the basis for printing tax statements.
If a Turnover class has been entered for a Voucher type record, this turnover class is suggested when you enter a value in the Voucher type field on the Voucher line. The value in the Credit turnover cl. field is not overwritten when you fill in the Debit account or the Credit account field.
If Turnover class has not been entered on the Voucher type record, the Credit turnover cl. field is suggested when the following is entered in the Debit account or Credit account fields:
- a customer no. or supplier no., and VAT code cust. or VAT code sup. field and area have been entered for the customer/supplier.
- a number and turnover class has been entered for the general ledger account.
If you enter a value both in the Debit account and the Credit account field, the turnover class for the relevant general ledger account is used.
The General ledger transaction are entered for the turnover class, and form the basis for printing tax statements.
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 | No | This field is not visible by default in the table display. |
| Domain | Turnover class | Integer |
| SQL name | DbTrnCl | The database field name. |
| API identifier | debitTurnoverClass | The API identifier used in GraphQL. |
| Number | 6890 |
Debit VAT code
The Debit VAT code field determines whether Business NXT calculates input or output VAT and/or investment tax for the voucher.
Tax computation is performed when the vouchers are updated. You enter the gross amounts in the vouchers. Business NXT subtracts any VAT and posts it to the specified tax accounts. In the case of investment tax, Business NXT calculates both the tax basis and the tax itself, and posts them to the specified general ledger account. You can set the Debit VAT code field to 0 and post the taxes manually to the tax account if you wish.
If you enter vouchers for a general ledger account or capital asset account with a defined VAT code, this VAT code is suggested. The cursor will move to the next field. You can return to the Debit VAT code field and change the code even if the cursor does not pause there.
If you enter a customer no. or supplier no., the customers/suppliers tax code will be suggested. This applies if you have selected Suggest VAT code in the Customer options field and in the Supplier options field respectively in the Associate table.
Exception 1 If you have selected Enter VAT code in the General ledger account table for the account no. for which you are posting the voucher, the cursor will always pause in the Debit VAT code field.
Exception 2 If you have selected Ignore VAT code in the Voucher type table for the voucher type used to post the voucher, the Debit VAT code field is not suggested, even if one is defined for the general ledger account.
A general ledger account that is taxable (defined as Turnover class 1 - Taxable sales or 4 - Taxable purchases) must have a Debit VAT code that calculates output or input VAT. The turnover class determines the general ledger accounts to be added up in the total taxable purchases and sales for the tax statement. These figures will not correspond with the taxes posted if vouchers have been posted with a debit VAT code that does not correspond to the turnover class.
If there is no turnover class in the general ledger account, it will be retrieved from the VAT code table.
If you delete the VAT code, the VAT amount will be removed in the voucher. This does not apply if you have overridden the VAT amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | DbTxCd | The database field name. |
| API identifier | debitTaxCode | The API identifier used in GraphQL. |
| Number | 882 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | DebitTaxCode |
|
Debt collection amount
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | DColAm | The database field name. |
| API identifier | debtCollectionAmountDomestic | The API identifier used in GraphQL. |
| Number | 18869 |
Debt collection ID
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | GUID | Text (40) |
| SQL name | DColId | The database field name. |
| API identifier | debtCollectId | The API identifier used in GraphQL. |
| Number | 18993 |
Debt collection response status
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | DColRSt | The database field name. |
| API identifier | debtCollectionResponseStatus | The API identifier used in GraphQL. |
| Number | 18870 |
Debt collection sent date
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | DColSDt | The database field name. |
| API identifier | debtCollectionSentDate | The API identifier used in GraphQL. |
| Number | 18867 |
Debt collection sent time
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| SQL name | DColSTm | The database field name. |
| API identifier | debtCollectionSentTime | The API identifier used in GraphQL. |
| Number | 18868 |
Delivery associate no.
Is filled in on supplier ledger vouchers produced on the basis of orders.
The value in this field is transferred to Updated voucher, Open supplier entry and Supplier transaction tables when voucher lines are updated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| SQL name | DelActNo | The database field name. |
| API identifier | deliveryAssociateNo | The API identifier used in GraphQL. |
| Number | 8897 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | DeliveryAssociate |
|
Difference
Shows the difference between the Bank amount field and the certain entries.
Shows the difference between the Bank amount field and the total of the entries which have a cross in the Payment reg. field in the linked Cross reference table. This functionality is to be used only when entering payment vouchers and only when using a voucher type with the option Copy open entries on lookup.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | difference | The API identifier used in GraphQL. |
| Number | 12354 |
Distribution key
The Amount, Amount in currency and Quantity fields in the voucher can be distributed proportionally between one or more organisational units by referring to a predefined distribution key.
The distribution key can combine a number of organisational units.
If a voucher is entered for two general ledger accounts with different distribution key, the distribution key is determined by the general ledger account entered first. If an organisational unit is defined in the same voucher line (see previous field), the distribution key only applies to any other organisational unit classes. A distribution key does not need to add up to 100 %.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Distribution key | Integer |
| SQL name | DstGr | The database field name. |
| API identifier | distributionKeyNo | The API identifier used in GraphQL. |
| Number | 2233 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Distribution key | DistributionKey |
|
Document product no.
Incoming document product identification processed from Accounting document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document product no. | Text (40) |
| SQL name | DocProdNo | The database field name. |
| API identifier | documentProductNo | The API identifier used in GraphQL. |
| Number | 19688 |
Document quantity
Incoming document line quantity processed from Accounting document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | DocQty | The database field name. |
| API identifier | documentQuantity | The API identifier used in GraphQL. |
| Number | 19724 |
Document VAT rate
Incoming document VAT rate (on invoice/credit note) processed from Accounting document table
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| SQL name | DocVatRt | The database field name. |
| API identifier | documentVatRate | The API identifier used in GraphQL. |
| Number | 19083 |
Due date
The due date is crucial for the routines associated with reminders, interest computation and payment suggestions.
The date is suggested on the basis of the Voucher date and Payment terms fields. In the case of payments and credit notes with no due date defined, Business NXT sets the Due date field equal to the Voucher date field. The due date for credit notes is normally set as the same as the due date for the invoice to prevent interest computation.
You can override the Due date field in the voucher line, or after the voucher has been updated, in the Open customer entry and Open supplier entry tables.
The Due date field is a date field, which you must enter in the format defined in the regional settings in Windows. You only need to enter the dates and month number for dates in the current year. A check is performed to ensure the date entered is valid.
If you enter + in the field, the system copies the date from the Voucher date. If you enter / in the field, the system copies the date from the last voucher. The cursor moves to the next field which means you do not have to press Enter.
If no payment terms is given on the voucher, the value from the Standard payment terms. field in the Company information table will be used.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | DueDt | The database field name. |
| API identifier | dueDate | The API identifier used in GraphQL. |
| Number | 897 |
EFT bank fee code
Used in connection with electronic funds transfer.
You define valid values and related texts in the Text table. The values are included in open supplier entries and transactions and then to payment lines in connection with payment suggestions. You can enter help and valid values in the Text table. This text can be made mandatory in the function Mandatory text types in the Company information table. The field is not overwritten by the value in the corresponding field in the Associate table if it is filled in, but retains the original value. The field is in use for Swedish payment formats.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT bank fee | Integer |
| SQL name | EFT2 | The database field name. |
| API identifier | eftBankFeeCode | The API identifier used in GraphQL. |
| Number | 6641 |
EFT currency code
Used in connection with electronic funds transfer.
You define valid values and related texts in the Text table. The values are included in open supplier entries and transactions and then to payment lines in connection with payment suggestions. You can enter help and valid values in the Text table. This text can be made mandatory in the function Mandatory text types in the Company information table. The field is not overwritten by the value in the corresponding field in the Associate table if it is filled in, but retains the original value. The field is in use for Swedish payment formats.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT Currency code | Integer |
| SQL name | EFT1 | The database field name. |
| API identifier | eftCurrencyCode | The API identifier used in GraphQL. |
| Number | 6640 |
EFT decl. code
Used in connection with electronic funds transfer.
You define valid values and related texts in the Declaration code table. The values are included in open supplier entries and transactions and then to payment lines in connection with payment suggestions. This text can be made mandatory in the function Mandatory text types in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT declaration code | Integer |
| SQL name | EFT3 | The database field name. |
| API identifier | eftDeclarationCode | The API identifier used in GraphQL. |
| Number | 6642 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Declaration code | EftDeclarationCode |
|
EFT form type
The form type for Danish payment formats, or for other payment formats which must state the form type in the payment file.
- 1 = giro transfer with notification without payment ID
- 4 = giro transfer without notification with payment ID
- 15 = giro transfer with notification and payment ID
- 71 = money order without notification with payment ID
- 73 = money order with notification without payment ID
- 75 = money order with notification and payment ID
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT form type | Integer |
| SQL name | EftFrmTp | The database field name. |
| API identifier | eftFormType | The API identifier used in GraphQL. |
| Number | 15468 |
EFT paym. method
Used in connection with electronic funds transfer.
You define valid values and related texts in the Text table. The values are included in open supplier entries and transactions and then to payment lines in connection with payment suggestions. You can enter help and valid values in the Text table. This text can be made mandatory in the function Mandatory text types in the Company information table. The field is in use for Swedish payment formats.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT payment method | Integer |
| SQL name | EFT4 | The database field name. |
| API identifier | eftPaymentMethod | The API identifier used in GraphQL. |
| Number | 6643 |
Empl. no.
An employee number.
- For follow-up of open supplier entries for authorisation, it is recommended to use the Auth. responsible field.
- For follow-up on accounting reports it is recommended to establish an organisational unit for employees
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | Emp | The database field name. |
| API identifier | employeeNo | The API identifier used in GraphQL. |
| Number | 907 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Employee |
|
Exchange rate
The exchange rate for currency.
- Currency rate, Sales rate from the line that matches the vouchers Voucher date
- Currency, Sales rate
If Enter currency is checked for the voucher type used, the cursor pauses in the Currency no. and Amount in currency fields and skips the (domestic currency) Amount field. The value in the Amount field is calculated as soon as the Amount in currency field is entered, or if the Currency no., Exchange rate or Amount in currency fields are changed. If the Amount field is changed, the Amount in currency is amended accordingly, with the rate remaining unchanged. However, if you want the Exchange rate field to change when you change the Amount in currency or Amount, you must check the Calculate cur. rate field in the Voucher type table.
In the same way as amounts in the domestic currency, the foreign currency amounts are added up for general ledger accounts, customers and suppliers, and you can print out these on account statements and balance lists. Business NXT only stores the balance in the balance tables for the currency code defined for the particular account, as well as the balance in the domestic currency.
If the amount is entered in the domestic currency, the balance for the customer is not accumulated in the foreign currency when the voucher is updated, even if the Currency no. is entered for the customer. Similarly, if no currency no. is defined for the sales account in the General ledger account, no general ledger balance will be calculated in foreign currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 887 |
Exchange rate 2
The exchange rate for currency 2.
When you enter a value in the Currency no. 2 field in the voucher line, Exchange rate 2 is suggested from the Currency rate 2 table. If you have selected the Update exchange rate from voucher date field under Voucher type processing in the Voucher type field and change the value in the Voucher date, Value date and Currency no. fields in the voucher line, Exchange rate 2 is retrieved from the first row that has From date >= Voucher date. If the voucher date is not entered in the voucher line, the Value date field is used. If the Value date field in the voucher line is not entered, the Value date field in the batch head or the current date is used.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | ExRt2 | The database field name. |
| API identifier | exchangeRate2 | The API identifier used in GraphQL. |
| Number | 14349 |
Exempt
A code that controls if the voucher should be exempt from reminders and/or interest computation.
In the Associate table you can specify that one or more customers/suppliers are exempt from reminders and/or interest computation/payment suggestions. These settings can be changed for each invoice voucher by entering a code in the Exempt field. You can exempt an invoice from reminders, payment suggestions and/or interest computation, even after a voucher has been updated, in the Open customer entry and Open supplier entry tables.
All of the codes are relevant for outgoing invoices. Only code 1 - No reminders/payment is relevant for incoming invoices. This exempts the invoice from payment suggestions. You can also use this code to enter an incoming invoice that you know has already been paid, to avoid paying twice.
- 1 - No reminders/payment
- 2 - No interest
- 3 - No reminders or interest
- 4 - No debt collection
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exempt | Integer |
| SQL name | Exc | The database field name. |
| API identifier | exempt | The API identifier used in GraphQL. |
| Number | 902 |
Exempt from auto entry
If the field is checked, the voucher is not accumulated in the fields for automatic entry movements in the General ledger account table.
This check box is suggested when you enter the Voucher type field in the voucher. Vouchers with a check from expanding automatic entries on the manual entry of vouchers are also exempted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | 5799 |
External reference 1
Used by some bank reconciliation systems to show processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. The field is updated from vouchers. If bank reconciliation is not in use the field can be used manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef1 | The database field name. |
| API identifier | externalReference1 | The API identifier used in GraphQL. |
| Number | 11252 |
External reference 2
Used by some bank reconciliation systems to show processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. The field is updated from vouchers. If bank reconciliation is not in use the field can be used manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef2 | The database field name. |
| API identifier | externalReference2 | The API identifier used in GraphQL. |
| Number | 11253 |
External reference 3
Used by some bank reconciliation systems to show processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. The field is updated from vouchers. If bank reconciliation is not in use the field can be used manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef3 | The database field name. |
| API identifier | externalReference3 | The API identifier used in GraphQL. |
| Number | 12799 |
Fixed amount
An amount which Business NXT may not use when calculating cash discounts.
This could be for example freight and customs. If you have entered the current currency in the field, Business NXT suggests the field in the default currency, provided that the exchange rate is in the voucher. The Fixed amount in EURO field displays the value in the Fixed amount in currency field converted into EURO.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FixAm | The database field name. |
| API identifier | fixedAmountDomestic | The API identifier used in GraphQL. |
| Number | 6230 |
Fixed amount in currency
An amount in currency which Business NXT may not use when calculating cash discounts.
See explanation of the field in the text under Fixed amount field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FixCurAm | The database field name. |
| API identifier | fixedAmountInCurrency | The API identifier used in GraphQL. |
| Number | 6229 |
Fixed amount in EURO
Shows the amount in EURO which Business NXT may not use when calculating cash discounts.
See explanation of the field in the text under Fixed amount field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Fixed amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | fixedAmountInEuro | The API identifier used in GraphQL. |
| Number | 7819 |
Free 1
Additional numeric information about the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 9175 |
Free 2
Additional numeric information about the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 9176 |
Free 3
Additional numeric information about the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 9177 |
Free 4
Additional numeric information about the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 9178 |
Giro no. check sum
When you use a bank giro number, Business NXT checks, via BIG, that the check sum stated agrees with the giro number on the same line.
The field is transferred from the Voucher table to the Updated voucher, Supplier transaction and Open supplier entry tables. The field is subsequently transferred from Open supplier entry to the Payment line table.
When you generate new batches on the basis of updated batches/vouchers, the field is also transferred back from updated batches to vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | GiroChSm | The database field name. |
| API identifier | giroNoCheckSum | The API identifier used in GraphQL. |
| Number | 10499 |
Incm. doc. no.
Reference to the corresponding Document comment table entry.
This field is used for order match functionality.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | InDocNo | The database field name. |
| API identifier | incomingDocumentNo | The API identifier used in GraphQL. |
| Number | 17824 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Incoming document | IncomingDocument |
|
Interest free amount
An amount which is exempt from interest calculation in the default currency.
The field is to be used only on voucher with customer invoices. In case of late payment and interest invoicing, this amount will be deducted from the invoice amount before interest calculation.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FreeAm | The database field name. |
| API identifier | interestFreeAmountDomestic | The API identifier used in GraphQL. |
| Number | 11609 |
Interest free amount in currency
An amount which is exempt from interest calculation in the current currency.
The field is to be used only on vouchers with customer invoices. In case of late payment and interest invoicing, this amount will be deducted from the invoice amount before interest calculation.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FreeCurA | The database field name. |
| API identifier | interestFreeAmountInCurrency | The API identifier used in GraphQL. |
| Number | 11610 |
Interest free amount in EURO
An amount which is exempt from interest calculation converted to EURO.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Interest free amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | interestFreeAmountInEuro | The API identifier used in GraphQL. |
| Number | 11608 |
Interest rate
An interest rate for customer entries.
The cursor only pauses in the Interest rate field when a customer account number is entered in the voucher. The interest rate specified for the customer in the Associate table is suggested. If the customer's Interest rate field is blank, the default interest rate for the customer's country number, as defined in the Country table, is suggested. If you want to apply another interest rate to an outgoing invoice, you can enter it in this field. You will then be able to use different interest rates when printing out interest notes for a single customer.
This field is intended for decimal figures. The field will only accept figures, full stops and commas. The decimal separator will be the one you have defined in Windows for each workstation.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| SQL name | IntRt | The database field name. |
| API identifier | interestRate | The API identifier used in GraphQL. |
| Number | 900 |
Invoice no.
The invoice number.
The Invoice no. field is crucial on vouchers regarding customer invoices or supplier invoices. If it is not filled in manually, it will be updated with the same value as the Voucher no. field when the voucher is updated. The Invoice no. field will also be copied to the Reference field, when the voucher is updated, unless the Reference field has been filled in manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 896 |
Line no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Batch no., Line no. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 874 |
Memo file name
If you link a memo to the voucher, this field will refer a file name.
If you do not specify a file name yourself, a file name will be suggested.
On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.
Double-click or press * to open the Select file dialog box to manually select a memo file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 4363 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Memo no. | Integer |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19245 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
No. of periods
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 |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | noOfPeriods | The API identifier used in GraphQL. |
| Number | 11999 |
Order no.
Order no on vouchers produced from order processing or order no for recharge of manually posted outlays.
- To get the order no filled out on the non-customer/supplier ledger voucher from processed orders with transaction type 1 - Sales, 2 - Hire,3 - Loan or 6 - Purchase, the option GL trans. per invoice (Recommended) in Company information must be enabled.
- To get the order no filled out on the vouchers from processed orders with another transaction type than mentioned above, the option GL trans. per order, when posting from product trans. in Company information must be enabled.
If both Order no. and Product no. fields are filled in in a line, you can make Business NXT update the order with a new order line when you update the batch. This assumes that you use a Voucher type which has the value 1 - Update order in the Update order field and that a product number is entered in the Product no. field.
If the Order no. field has been filled in and you are using a Voucher type which has the value 2 - Update prepayment status in the Update order field, the specified order will be updated so that the barred advance order is released for further processing. A test will be performed to determine whether the amount on the voucher line is as large or larger in order for the order to be released. The voucher number will be transferred to the order's Invoice reference so that the invoice for this order will be matched against this payment.
When the Order no. field is entered in the Voucher table you can link to the Order line table to see the order lines on receipt of invoice/authorisation.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| SQL name | Task | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 905 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
|
Org. unit errors
Flags for deficiencies in connection with the vouchers.
It keeps flags for fields that are lacking mandatory values, in accordance with the selections made in the fields for Organisational unit processing in the General ledger account table. (This forms the basis of the red question marks in the fields.)
The field can also be processed further in BIG for example. Further processing of the field has not been implemented.
It is not possible to edit in this field.
- Organisational unit 1
- Organisational unit 2
- Organisational unit 3
- Organisational unit 4
- Organisational unit 5
- Organisational unit 6
- Organisational unit 7
- Organisational unit 8
- Organisational unit 9
- Organisational unit 10
- Organisational unit 11
- Organisational unit 12
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Org. unit errors | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Obl | The database field name. |
| API identifier | missingObligatoricValues | The API identifier used in GraphQL. |
| Number | 5005 |
Organisational unit 1
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 890 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 891 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 892 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 893 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 894 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 895 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 9492 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 9493 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 9494 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 9495 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 9496 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
The field is used to specify organisational unit.
The Voucher window includes one field for each organisational unit class defined in the Company information table. These fields may for example be named "Department" or "Project", and refer to the relevant organisational unit tables. You can therefore post the same voucher for both a department and a project, for example.
If you distribute vouchers by organisational unit, you can print separate reports for one or more organisational units without dividing them between different general ledger accounts. If you create hierarchies of organisational units, for example to divide a project into a main project and a sub-project, you can produce detailed reports on two levels. You choose you own subtotal level and the information/selection to be included. For example, you can print PL and balance sheet reports, balance lists and account statements for one or more organisational units.
Business NXT suggests the organisational unit where a permanent link is defined to the relevant general ledger account. If the general ledger account indicates that the organisational unit class should be entered, the organisational unit defined for the batch is suggested. If you enter a voucher for two general ledger accounts with different organisational units, the organisational unit is determined by the account entered first. If you enter an organisational unit, this will be used in preference to any distribution key for the same organisational unit class.
When you enter a customer/supplier number in the fields for debit/credit when entering a voucher, the organisational unit is retrieved from the Associate table.
The cursor only pauses in the organisational unit field if you have selected the Organisational unit processing box for the Debit account or Credit account. Even if the cursor skips the organisational unit field in a voucher line, you can always use the arrow keys to return to the field and edit it. When you enter an organisational unit number, the name of the organisational unit is displayed in the Status bar, so that you can check that you have entered the right number.
If neither debit account or credit account is entered with the value 1-3 in Organisational unit processing, you will be warned and you will not be able to enter an organisational unit in the voucher.
You will also receive messages if you use incorrect combinations of accounts and organisational units which you have defined in the Combination group, User combination group and Combination matrix tables.
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 | 9497 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Original voucher no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | OrVoNo | The database field name. |
| API identifier | originalVoucherNo | The API identifier used in GraphQL. |
| Number | 18628 |
OSS VAT term
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| SQL name | EsTxTrm | The database field name. |
| API identifier | ossTaxTerm | The API identifier used in GraphQL. |
| Number | 17564 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| OSS VAT period | OssTaxTerm |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Part payment
The amount to match (obsolete functionality).
If invoices are payed only partly, it is strongly recommended to use a Voucher type with the option Copy open entries on lookup enabled and enter the part payments in the joined Cross reference table instead. This will give the user a better overview of the matched part payments.
This is because the Part payment field forms the basis when you match the entry. The part payment amount is reduced when you match the entry, the entry matching is completed with the part payment amount is zero.
In Open supplier entry table the fields are also used for payment suggestions.)
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PrtAm | The database field name. |
| API identifier | partPaymentDomestic | The API identifier used in GraphQL. |
| Number | 7990 |
Part payment in currency
An amount in currency to match.
If invoices are payed only partly, it is strongly recommended to use a Voucher type with the option Copy open entries on lookup enabled and enter the part payments in the joined Cross reference table instead. This will give the user a better overview of the matched part payments
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PrtCurAm | The database field name. |
| API identifier | partPaymentInCurrency | The API identifier used in GraphQL. |
| Number | 7988 |
Part payment in EURO
An amount in EURO to match.
This field is not contained in the database, but displays the Part payment in currency field converted to EURO.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Part payment in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | partPaymentInEuro | The API identifier used in GraphQL. |
| Number | 7989 |
Payment element index
Reference to the relevant <Payment> element in the incoming payment file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PayIdx | The database field name. |
| API identifier | paymentIndex | The API identifier used in GraphQL. |
| Number | 19625 |
Payment line element index
Reference to the relevant <PaymentLine> element in the incoming payment file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PayLnIdx | The database field name. |
| API identifier | paymentLineIndex | The API identifier used in GraphQL. |
| Number | 19626 |
Payment method
The payment method.
The field is used to control the automatic posting that is executed when a voucher concerning customer or supplier transactions is updated. The Payment method is defined in the Payment method table. The field is to be used mainly for vouchers reflecting cash sales / purchases and for voucher generated by POS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment method | Integer |
| SQL name | PmtMt | The database field name. |
| API identifier | paymentMethod | The API identifier used in GraphQL. |
| Number | 10553 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment method | PaymentMethod |
|
Payment supplier no.
Supplier used as the payee when creating payment suggestions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| SQL name | RmtSup | The database field name. |
| API identifier | remittanceSupplierNo | The API identifier used in GraphQL. |
| Number | 17877 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | RemittanceSupplier |
|
Payment terms
The payment terms.
When you enter invoices for either customers or suppliers, the Payment terms field is suggested on the basis of what is in the Associate table for the relevant customer or supplier. Also the due date and cash due date are suggested on the basis of the payment terms.
The Payment terms forms together with the Voucher date field the basis for calculation of the Due date and Cash due date fields.
If the payment terms are to be retrieved for the customer or supplier in connection with opposite entry, you must check the Use payment terms on credit notes field under Accounting processing in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment terms | Integer |
| SQL name | PmtTrm | The database field name. |
| API identifier | paymentTerms | The API identifier used in GraphQL. |
| Number | 4943 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment term | PaymentTerms |
|
Per. Credit
Make the Credit account field subject to accrual accounting.
When the field is selected, the Credit account field will be subject to accrual accounting instead of the Debit account field that is default subject to accrual accounting. The field is to be used only in combination with Accrual accounting start year/period and Accrual accounting end year/period or in combination with Period key on the Voucher record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | accrualCredit | The API identifier used in GraphQL. |
| Number | 11990 |
Period
The accounting period to use.
The year and period are the accounting year and period for which the voucher will be updated. The VAT year and VAT term fields are the VAT period and VAT year for which the voucher will be updated. If you complete the Value date field, Business NXT suggests the values in the Year, Period, VAT year and VAT term fields within which the Value date falls. You can override the period, year, VAT year and VAT period yourself. If the Value date field is not filled in, it is set to the last date in the relevant period.
The period, year, VAT year and VAT period must be later than the Suspension date in the dialog box for the Move suspension date processing in the Company information table, and must fall within a defined accounting period and VAT period for the voucher to be updated. Even if a company is not liable to pay tax, at least one VAT period must be defined to cover the entire financial year. The suspension date can be updated whenever a VAT statement is approved, which means that vouchers cannot be posted for periods that have been finished. You can enter vouchers for the next accounting year before you have finished the current year, provided that the periods for the next year have been defined in the Accounting period and VAT period tables.
If you type + in one of the fields, the system enters the next period that has not been opened.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| SQL name | AcPr | The database field name. |
| API identifier | period | The API identifier used in GraphQL. |
| Number | 4501 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting period | AccountingPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Batch | PeriodBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Period batch no.
The period batch number and the value is retrieved from the batch head.
The period batch number is included in all entries that are produced when updating. On normal transactions, the value is taken from the batch head unless it is given on the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PrBt | The database field name. |
| API identifier | periodBatchNo | The API identifier used in GraphQL. |
| Number | 10555 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Batch | PeriodBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Period key
A distribution key for accrual accounting.
If the voucher shall be splitted and amounts distributed over several accounting periods, a Period key can be used if the processing Accrual accounting is unwanted by the user.
The processing Accrual accounting will create and expand a new voucher for each accrued period, which might give the user a less good overview of the vouchers, while the use of a Period key will expand the accrual accounting during the update.
The period keys are defined in the Period key table.
The Period line table will not be regarded when using the field Period key on the voucher line, only the No. of periods field in the Period key table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period key | Integer |
| SQL name | PrK | The database field name. |
| API identifier | periodKeyNo | The API identifier used in GraphQL. |
| Number | 15522 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Period key | PeriodKey |
|
Picture file name
If, for example, you want to scan in or link to a picture of one of your vouchers, you can enter the file name for the picture in this field.
The value in the field is transferred from the voucher lines to updated vouchers and on to the transactions and open entries. If you use the Design/Add/Visualise menu item, the contents in this field is used.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Picture file name | Text (260) |
| SQL name | PictNo | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 9173 |
Pre-approved
Pre-approved for payment in Visma.net AutoPay.
The transaction has been approved for payment in Visma.net Approval. Approval of the payment in Visma.net AutoPay should not be required. This value can be removed, but not be set.
| 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 | preapproved | The API identifier used in GraphQL. |
| Number | 18574 |
Previous voucher no.
When you fill in this field in a voucher line and you have checked the Authorisation box in the batch to which the voucher is joined, the General ledger transaction with this voucher number are reversed.
This only applies to transactions that are not automatically generated. Business NXT rejects voucher numbers for which there are no general ledger transactions.
The following fields are filled in in the voucher line:
- The fields for debit/credit account number are filled in reversed.
- The Amount field is filled in with the amount excluding VAT.
- The Currency no., Exchange rate, Amount in currency and Quantity fields and organisational units are copied from the arrival voucher. If the currency is the same as the default currency, the currency amount is set as equal to the amount in default currency.
- The Order no. field from the Open supplier entry is filled in.
At the same time, Business NXT displays the Open supplier entry in a separate Open supplier entry page element that has to be joined to the Voucher table. The following fields in this window are filled in:
- The Att. voucher no. field in the supplier entry is set as equal to the Voucher no. field on the voucher line, if the Voucher no. in the entry is the same as the Previous voucher no. in the voucher line.
- The Auth. date 1 field is set to the current date in the Open supplier entry table.
- When the Priority field is filled in in the voucher line, this value is copied to the supplier entry.
Business NXT prevents authorisation of the same transaction several times. When you authorise a general ledger transaction, Business NXT checks the Authorised option in the dialog box for the Trans. status field.
If you delete or overwrite the Previous voucher no. field or delete the entire voucher line, this check is removed. If there is no value in the Voucher no. field when Previous voucher no. is filled in, the value in the Previous voucher no. field is copied to the Voucher no. field. If the contents of the Previous voucher no. field are deleted, the contents of the Voucher no. field are also deleted.
The previous voucher number is copied to subsequent voucher lines with the same voucher number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | PrevVoNo | The database field name. |
| API identifier | previousVoucherNo | The API identifier used in GraphQL. |
| Number | 6259 |
Priority
Group incoming and outgoing invoices according to priority, e.g. to select invoices for payment suggestions.
The different voucher types can be assigned a fixed priority in the Voucher type table. The priority specified for the voucher type will be suggested in the voucher line. The Priority field is included in the Open supplier entry table when the vouchers are updated, and the value can be overridden. If you choose to use the Priority field as a status indicator, the vouchers may pass through a number of different stages before the entry is settled.
If you double click or enter * in the field, you bring up the Payment priority dialog box with all the priorities that have been entered for default language, if any texts have been defined in terms of priority. This could be:
- 1. Payment priority 1
- 2. Payment priority 2
- 8. For authorisation
- 9. Do not remit
You can start using the Priority field after Business NXT has been in use a while, if you find that you need more opportunities to select invoice vouchers.
The cursor pauses in the Priority field when you enter customer and supplier account and you have enabled authorisation in the batch head.
| 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 | 901 |
Product no.
The product number for an invoice.
If both Order no. and Product no. fields are filled in in the voucher, a new order line will be added to the order when you update the batch. This is provided you have the value 1 - Update order in the Update order field in the Voucher type table.
The Quantity field on the Order line will when updating be set as equal to the value in the Quantity field on the Voucher row, or to 1 if no quantity has been entered on the voucher. Cust. no., Sup. no. and Empl. no. are copied from the voucher table to the new order line. The information in the order head in the order lines is updated as during ordinary order entry. When order lines are added on the basis of vouchers, the posted amount excl VAT is transferred to the order lines and divided by the Quantity to calculate the Price and Price (dom.) on the Order line. If the product is exempt from warehousing, the same amount is also set as the Cost price and Cost price (dom.) on the order line. This is particularly useful for further invoicing of expenses in connection with projects and assignments. The incoming invoice is entered once only, and is re-invoiced directly.
| 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 | Act | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 908 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
|
Quantity
A quantity for the voucher.
The cursor only pauses in the Quantity field if you have checked the Enter quantity box in the General ledger account table for the Debit account or Credit account in the voucher. Even if the cursor skips the field, you can of course use the arrow keys to return to the field and enter a quantity.
You do not define the type of unit of the quantity, and all the quantities entered are added together in the General ledger balance for the account. You should therefore only use one quantity unit per account to produce a meaningful balance (so that you do not add up boxes and metres). This means that there must be a separate sales account for each unit for which you want a balance.
You must not post the Quantity field with a preceding sign. A volume posted to a credit account number is interpreted as a negative quantity. It is up to you to decide whether to use the quantity term as a PL or balance sheet figure.
If you include quantities both in invoices and on payment, the quantity balance for the ledger number will be zero. As with the amount and currency amount fields, the quantity balances for General ledger account and customers/suppliers are totalled. You can print the quantity balances in account statements and balance lists. The quantity is regarded as turnover, and is reset at the start of a new financial year unless you have posted the quantity to an organisational unit class defined with an accumulated result.
This field is intended for decimal figures. The field will only accept figures, full stops and commas. The decimal separator will be the one you have defined in Windows for each workstation.
The Quantity field cannot be printed on profit and loss reports and balance sheet reports.
See also the description for Product no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Qty | The database field name. |
| API identifier | quantity | The API identifier used in GraphQL. |
| Number | 903 |
Realisation journal no.
Reflects the Realisation journal from realisation of orders.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RealJNo | The database field name. |
| API identifier | realisationJournalNo | The API identifier used in GraphQL. |
| Number | 15275 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal | RealisationJournal |
| ||
| Realisation journal line | RealisationJournalLine |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Reference
The reference for matching.
The Reference field on open customer / supplier entries will be matched against the Cross reference on payment vouchers if 4 - Entered references is chosen as the Matching method in the Company information table.
If the Reference field is not filled in, it will be copied from the Invoice no. field when updating the voucher. If this field is not filled in either, it will in turn be copied from the Voucher no. field.
The field will update the Reference field in the Open customer entry and Open supplier entry tables from vouchers containing customer / supplier invoices. This field will be used to match the open entries against Cross reference entered on payment vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| SQL name | Ref | The database field name. |
| API identifier | reference | The API identifier used in GraphQL. |
| Number | 898 |
Scan doc. no.
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PLDNo | The database field name. |
| API identifier | scanDocumentNo | The API identifier used in GraphQL. |
| Number | 11196 |
Scan status
The status of the scanned document.
Is used in connection with Visma Document Center.
- 1 - Scanned document
- 2 - Document on flow
- 4 - Document finished
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Scan status | Integer |
| SQL name | PLDFlow | The database field name. |
| API identifier | scanStatus | The API identifier used in GraphQL. |
| Number | 11197 |
Sort seq. no.
The order of the lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort seq. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Srt | The database field name. |
| API identifier | sortSequenceNo | The API identifier used in GraphQL. |
| Number | 2092 |
Structured element index
Reference to the relevant <Structured> element within the <PaymentLine> element in the incoming payment file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | StrElIdx | The database field name. |
| API identifier | structuredElementIndex | The API identifier used in GraphQL. |
| Number | 19627 |
Sup. no.
The supplier number the voucher applies to.
The field is filled out automatically if the Debit account or the Credit account is filled out with a supplier no (2 - Supplier)
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| SQL name | Sup | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 4944 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Text
A text for the voucher.
Business NXT retrieves the voucher text from the Voucher type table, which is filled in when you enter a voucher type. If you have checked the Enter text box for the voucher type, the cursor pauses in the Text field in the Voucher table to allow you to change the text if necessary. This is useful for invoice vouchers, for example, if you want to enter the invoice number in the voucher text. You can call up the voucher text in all transaction lists. Even if the cursor does not pause on a field, you can return to the field using the arrow keys and edit the voucher text.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Txt | The database field name. |
| API identifier | text | The API identifier used in GraphQL. |
| Number | 879 |
Total credit
The sum of credit amounts.
The value is updated with a negative value from the Bank amount field and with values from positive entries which have a cross in the Payment reg. field in the linked Cross reference table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SmCr | The database field name. |
| API identifier | sumCreditDomestic | The API identifier used in GraphQL. |
| Number | 12353 |
Total debit
The sum of debit amounts.
The value is updated with a positive value from the Bank amount field and with values from negative entries which have a cross in the Payment reg. field in the linked Cross reference table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SmDb | The database field name. |
| API identifier | sumDebitDomestic | The API identifier used in GraphQL. |
| Number | 12352 |
Trans. status
The status of the transaction.
Overwritten
- Amount excl. VAT
- When you complete the Amount excl. VAT field in the Voucher table, this check box is selected.
- VAT amount
- This field is checked if you have overridden the VAT amount in the voucher line.
- Org. unit
- If organisational units are overridden in the General ledger transaction table, Business NXT defines a value here that indicates that the organisational unit has been corrected after updating.
Debt collector
- Transferred to debt collector
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the Transfer to debt collection processing.
- Returned from debt collector
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the Return from debt collection processing.
- Added during debt collection
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the List debt collection related transactions processing.
Duration
- Permanent
- All regular transactions.
- Temporary
- Business NXT uses this field in connection with reversal of transactions.
- Reversing
- Business NXT uses this field in connection with reversal of transactions.
Accounting rule
- Created by an accounting rule
- The option is automatically enabled when a voucher line is created by
an accounting rule.The field is greyed out in the following tables:
- Customer transaction
- Supplier transaction
- General ledger transaction
- Capital asset transaction
- Open customer entry
- Open supplier entry
- Do not apply accounting rule
Per.
- Per. Debit acc.
- Per. Credit acc.
____
- Do not create open entries
- Business NXT does not produce open entries for the voucher line. This field overrides the
Matching method
parameter in the Company information table and
Matching method cust./Matching method sup.
in the Associate table. You can use this parameter, for example, when converting from other systems
in which you want to refer to earlier transactions. You can also increase the speed
when updating a batch if you define this flag for vouchers that you know are fully
matched.The field is greyed out in the following tables:
- Customer transaction
- Supplier transaction
- General ledger transaction
- Capital asset transaction
- Open customer entry
- Open supplier entry
- Ref. Entry Free of interest
- This comes from the order module and will exempt this entry and the cross-reference from interest computation in connection with updating.
- Ref. Entry Free of reminder fee
- If you in the Order table have selected the Ref. Entry Free of interest check box in Order options, this check box is selected. When you update the batch the post and the cross-references are exempted from interest calculation.
- Credit note
- Business NXT checks for credit note if the transaction is a credit entry for a customer or a
debit entry for a supplier. Business NXT assumes that you have checked the Affects turn./purch. box in the Voucher type
table for the relevant voucher type.
This field is used for customer transactions and supplier transactions, and is therefore greyed out in the voucher line.
- Authorised
- This field is checked if you have authorised a general ledger transaction. You can also check the field manually if the transaction has already been authorised.
- Factoring performed
- You only use this check box for open customer entries, and it is therefore greyed out in the voucher lines.
- Period flow processed
- Business NXT will select this field when you execute the Automatic entries processing in the General ledger account table.
- Paid
- Business NXT will select this field when you transfer the open entry to payment lines. You
cannot select the field manually.
Business NXT inserts a cross in this field when you save a cross reference line which has a cross in the Payment reg. field. When you delete a voucher line, transaction status Paid is deleted if you press Delete in the cross reference line or the voucher line, and not in the batch head.
- Partly paid in AutoPay
- Automatically set when an open customer/supplier entry is updated as a partial payment, i.e. when an approver has overridden the payment amount in Visma.net AutoPay.
- Cancelled/Rejected payment
- This check box is selected when a payment line is cancelled or rejected. The Paid and Payment no. fields are then deleted, so that you can create payment for the entry once more. This requires that the parameter Set to "Cancelled" for payments not transferred in the EFT processing field of the Bank partner table has been checked.
- Prepayment
- This check box is selected when OCR transactions are imported containing advance payment. The routine enters the order number in the voucher line. This requires that you have selected the parameter Prepayment in Payment processing in the Company information or Factoring company tables.
- Accept transactions with amount 0
- If you select this field in a voucher line, transactions are produced
even if both the amount and quantity are 0 (zero) in the voucher line.
In these voucher lines and updated voucher lines, 0 (zero) is shown instead of a blank Amount field (in default currency).
The Accept transactions with amount 0 field are greyed out when you open the dialog box in the Trans. status field from tables other than the Voucher table.
- Direct debit from order
- When posting invoices from the order system, Business NXT checks whether the customer has a direct debiting agreement, and whether the voucher date is within the applicable from and to dates for this. If so, the flag from Direct debit from order is placed in the Trans. status field in the voucher line. If this amount exceeds a maximum amount specified by the customer, the Exceeded max amount flag is inserted.
- Exceeded max amount
- When posting invoices from the order system, Business NXT checks whether the customer has a direct debiting agreement, and whether the voucher date is within the applicable from and to dates for this. If so, the flag from Direct debit from order is placed in the Trans. status field in the voucher line. If this amount exceeds a maximum amount specified by the customer, the Exceeded max amount flag is inserted.
- Do not update exchange rate from voucher date
- The voucher line’s exchange rate from the Currency rate or Currency rate 2 table will not be updated when you change the voucher date.
- Debt collection voucher lines already expanded
- Value date overridden
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. status | Integer |
| SQL name | TransSt | The database field name. |
| API identifier | transactionStatus | The API identifier used in GraphQL. |
| Number | 6270 |
Unit
A unit for the voucher.
The field refers to the Unit table and can be used to define the unit if a quantity has been entered in the Quantity field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Unit | Integer |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 10554 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | Unit |
|
Updated batch no.
The updated batch number.
When batches are updated, a reference to the voucher line from which the voucher is produced is stored in this field.
This makes it possible to withdraw updated vouchers and to correct vouchers. In addition, you can join the Customer transaction, Supplier transaction, General ledger transaction, Capital asset transaction, Open customer entry and Open supplier entry tables to the Updated voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Batch no. | Integer |
| SQL name | UpdBndNo | The database field name. |
| API identifier | updatedBatchNo | The API identifier used in GraphQL. |
| Number | 10946 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated batch | UpdatedBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Updated voucher line no.
The updated voucher line number.
When batches are updated, a reference to the voucher line from which the voucher is produced is stored in this field.
This makes it possible to withdraw updated vouchers and to correct vouchers. In addition, you can join the Customer transaction, Supplier transaction, General ledger transaction, Capital asset transaction, Open customer entry and Open supplier entry tables to the Updated voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | UpdLnNo | The database field name. |
| API identifier | updatedVoucherLineNo | The API identifier used in GraphQL. |
| Number | 10947 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Validation status 1
The status of the voucher validation.
____
- Missing voucher no.
- Invalid voucher no.
- Missing voucher date
- Invalid voucher date
- Missing value date
- Invalid value date
- Missing voucher type
- Invalid voucher type
- Missing amount
- Invalid amount
- Missing amount in currency
- Invalid amount in currency
- Missing amount in currency 2
- Invalid amount in currency 2
- Missing VAT term
- Invalid VAT term
- Missing VAT year
- Invalid VAT year
- Missing period
- Invalid period
- Missing currency code
- Invalid currency code
- Missing currency code 2
- Invalid currency code 2
- Missing year
- Invalid year
____
- Missing debit account
- Invalid debit account
- Missing credit account
- Invalid credit account
- Missing debit currency code
- Invalid debit currency code
- Missing credit currency code
- Invalid credit currency code
- Missing debit turnover class
- Invalid debit turnover class
- Missing distribution key
- Invalid distribution key
- Missing capital asset processing
- Invalid capital asset processing
- Missing capital asset no.
- Invalid capital asset no.
- Missing credit turnover class
- Invalid credit turnover class
- Missing organisational units
- Invalid organisational units
____
- Missing payment terms
- Invalid payment terms
- Missing employee no.
- Invalid employee no.
- Missing authorization
- Invalid authorization
- Missing bank no.
- Invalid bank no.
- Missing method of payment
- Invalid method of payment
- Missing declaration code
- Invalid declaration code
- Missing customer no.
- Invalid customer no.
- Missing supplier no.
- Invalid supplier no.
- Missing deliver to associate no.
- Invalid deliver to associate no.
____
- Missing unit
- Invalid unit
- Missing order no.
- Invalid order no.
- Missing product no.
- Invalid product no.
- Missing period start year and period
- Invalid period start year and period
- Missing period end year and period
- Invalid period end year and period
- Missing period batch no.
- Invalid period batch no.
- Missing period key
- Invalid period key
- Missing corporate company no.
- Invalid corporate company no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Validation status 1 | Integer |
| SQL name | ValSt1 | The database field name. |
| API identifier | validationStatus1 | The API identifier used in GraphQL. |
| Number | 15277 |
Validation status 2
The status of the voucher validation.
____
- Missing voucher no.
- Invalid voucher no.
- Missing voucher date
- Invalid voucher date
- Missing value date
- Invalid value date
- Missing voucher type
- Invalid voucher type
- Missing amount
- Invalid amount
- Missing amount in currency
- Invalid amount in currency
- Missing amount in currency 2
- Invalid amount in currency 2
- Missing VAT term
- Invalid VAT term
- Missing VAT year
- Invalid VAT year
- Missing period
- Invalid period
- Missing currency code
- Invalid currency code
- Missing currency code 2
- Invalid currency code 2
- Missing year
- Invalid year
____
- Missing debit account
- Invalid debit account
- Missing credit account
- Invalid credit account
- Missing debit currency code
- Invalid debit currency code
- Missing credit currency code
- Invalid credit currency code
- Missing debit turnover class
- Invalid debit turnover class
- Missing distribution key
- Invalid distribution key
- Missing capital asset processing
- Invalid capital asset processing
- Missing capital asset no.
- Invalid capital asset no.
- Missing credit turnover class
- Invalid credit turnover class
- Missing organisational units
- Invalid organisational units
____
- Missing payment terms
- Invalid payment terms
- Missing employee no.
- Invalid employee no.
- Missing authorization
- Invalid authorization
- Missing bank no.
- Invalid bank no.
- Missing method of payment
- Invalid method of payment
- Missing declaration code
- Invalid declaration code
- Missing customer no.
- Invalid customer no.
- Missing supplier no.
- Invalid supplier no.
- Missing deliver to associate no.
- Invalid deliver to associate no.
____
- Missing unit
- Invalid unit
- Missing order no.
- Invalid order no.
- Missing product no.
- Invalid product no.
- Missing period start year and period
- Invalid period start year and period
- Missing period end year and period
- Invalid period end year and period
- Missing period batch no.
- Invalid period batch no.
- Missing period key
- Invalid period key
- Missing corporate company no.
- Invalid corporate company no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Validation status 2 | Integer |
| SQL name | ValSt2 | The database field name. |
| API identifier | validationStatus2 | The API identifier used in GraphQL. |
| Number | 15278 |
Validation status 3
The status of the voucher validation.
____
- Missing voucher no.
- Invalid voucher no.
- Missing voucher date
- Invalid voucher date
- Missing value date
- Invalid value date
- Missing voucher type
- Invalid voucher type
- Missing amount
- Invalid amount
- Missing amount in currency
- Invalid amount in currency
- Missing amount in currency 2
- Invalid amount in currency 2
- Missing VAT term
- Invalid VAT term
- Missing VAT year
- Invalid VAT year
- Missing period
- Invalid period
- Missing currency code
- Invalid currency code
- Missing currency code 2
- Invalid currency code 2
- Missing year
- Invalid year
____
- Missing debit account
- Invalid debit account
- Missing credit account
- Invalid credit account
- Missing debit currency code
- Invalid debit currency code
- Missing credit currency code
- Invalid credit currency code
- Missing debit turnover class
- Invalid debit turnover class
- Missing distribution key
- Invalid distribution key
- Missing capital asset processing
- Invalid capital asset processing
- Missing capital asset no.
- Invalid capital asset no.
- Missing credit turnover class
- Invalid credit turnover class
- Missing organisational units
- Invalid organisational units
____
- Missing payment terms
- Invalid payment terms
- Missing employee no.
- Invalid employee no.
- Missing authorization
- Invalid authorization
- Missing bank no.
- Invalid bank no.
- Missing method of payment
- Invalid method of payment
- Missing declaration code
- Invalid declaration code
- Missing customer no.
- Invalid customer no.
- Missing supplier no.
- Invalid supplier no.
- Missing deliver to associate no.
- Invalid deliver to associate no.
____
- Missing unit
- Invalid unit
- Missing order no.
- Invalid order no.
- Missing product no.
- Invalid product no.
- Missing period start year and period
- Invalid period start year and period
- Missing period end year and period
- Invalid period end year and period
- Missing period batch no.
- Invalid period batch no.
- Missing period key
- Invalid period key
- Missing corporate company no.
- Invalid corporate company no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Validation status 3 | Integer |
| SQL name | ValSt3 | The database field name. |
| API identifier | validationStatus3 | The API identifier used in GraphQL. |
| Number | 15279 |
Validation status 4
The status of the voucher validation.
____
- Missing voucher no.
- Invalid voucher no.
- Missing voucher date
- Invalid voucher date
- Missing value date
- Invalid value date
- Missing voucher type
- Invalid voucher type
- Missing amount
- Invalid amount
- Missing amount in currency
- Invalid amount in currency
- Missing amount in currency 2
- Invalid amount in currency 2
- Missing VAT term
- Invalid VAT term
- Missing VAT year
- Invalid VAT year
- Missing period
- Invalid period
- Missing currency code
- Invalid currency code
- Missing currency code 2
- Invalid currency code 2
- Missing year
- Invalid year
____
- Missing debit account
- Invalid debit account
- Missing credit account
- Invalid credit account
- Missing debit currency code
- Invalid debit currency code
- Missing credit currency code
- Invalid credit currency code
- Missing debit turnover class
- Invalid debit turnover class
- Missing distribution key
- Invalid distribution key
- Missing capital asset processing
- Invalid capital asset processing
- Missing capital asset no.
- Invalid capital asset no.
- Missing credit turnover class
- Invalid credit turnover class
- Missing organisational units
- Invalid organisational units
____
- Missing payment terms
- Invalid payment terms
- Missing employee no.
- Invalid employee no.
- Missing authorization
- Invalid authorization
- Missing bank no.
- Invalid bank no.
- Missing method of payment
- Invalid method of payment
- Missing declaration code
- Invalid declaration code
- Missing customer no.
- Invalid customer no.
- Missing supplier no.
- Invalid supplier no.
- Missing deliver to associate no.
- Invalid deliver to associate no.
____
- Missing unit
- Invalid unit
- Missing order no.
- Invalid order no.
- Missing product no.
- Invalid product no.
- Missing period start year and period
- Invalid period start year and period
- Missing period end year and period
- Invalid period end year and period
- Missing period batch no.
- Invalid period batch no.
- Missing period key
- Invalid period key
- Missing corporate company no.
- Invalid corporate company no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Validation status 4 | Integer |
| SQL name | ValSt4 | The database field name. |
| API identifier | validationStatus4 | The API identifier used in GraphQL. |
| Number | 15280 |
Value date
The value date.
The Value date field completes the Period, Year, VAT year and VAT term fields. These are the fields that determine the periods and years for which the vouchers are posted. You should therefore ensure that the current date falls within the accounting period for which you want the voucher to be updated. If it does not, you must remember to enter the accounting period, accounting year, VAT period and VAT year to the correct periods and years manually.
Value date is a date field, which you must enter in the format as defined in the regional settings in Windows. You only need to enter the dates and month number for dates in the current year. A check is performed to ensure the date entered is valid.
If you enter / in the field, the system copies the date from the previous voucher. If you enter + in the field, the system copies the date from the batch. The cursor moves to the next field which means you do not have to press Enter.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | ValDt | The database field name. |
| API identifier | valueDate | The API identifier used in GraphQL. |
| Number | 877 |
VAT amount
The VAT amount.
When you complete the Amount field in a voucher line, where a Debit VAT code or a Credit VAT code exists, Business NXT calculates the VAT amount and suggests it in the VAT amount field. If you make a change in the Amount field, the VAT amount will be recalculated.
You can override the value in the VAT amount field if it differs from the invoice or other document you are posting. If this field is empty, for example after importing data, the VAT amount will be calculated when the batch is updated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | VatAm | The database field name. |
| API identifier | vatAmountDomestic | The API identifier used in GraphQL. |
| Number | 6228 |
VAT amount in currency
The VAT amount in currency of the voucher.
When you fill in the Amount in currency field in a voucher line, where a Debit VAT code or a Credit VAT code exists, Business NXT calculates the VAT amount and suggests it in the VAT amount in currency field. If you make a change in the Amount in currency field, the VAT amount will be recalculated.
You can override the value in the VAT amount in currency field if it differs from the invoice or other document you are posting. If this field is empty, for example after importing data, the VAT amount will be calculated when the batch is updated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CurVatAm | The database field name. |
| API identifier | vatAmountInCurrency | The API identifier used in GraphQL. |
| Number | 18157 |
VAT term
The VAT period to use.
The VAT year and VAT term fields show the VAT year and VAT term in which the batch is updated. If you enter the Value date, Business NXT suggests the Year, Period, VAT year and VAT term within which the Value date falls. You can override the Period, Year, VAT year and VAT term yourself. If the Value date is not filled in, it is set to the last date in the relevant period.
The Year, Period, VAT year and VAT term must be later than the Suspension date in the dialog box for the Move suspension date processing in the Company information table, and must fall within a defined accounting period and VAT period for the batch to be updated. Even if a company is not liable to pay tax, at least one VAT period must be defined to cover the entire financial year. The suspension date is updated whenever a VAT statement is approved, which means that vouchers cannot be posted for periods that have finished. You can enter vouchers for the next accounting year before you have finished the current year, provided that the periods for the next year have been defined in the Accounting period and VAT period tables.
If you type + in one of the fields, the system enters the next period that has not been opened.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| SQL name | TxTrm | The database field name. |
| API identifier | taxTerm | The API identifier used in GraphQL. |
| Number | 4503 |
VAT year
The VAT year to use.
The VAT year and VAT term fields show the VAT year and VAT term in which the batch is updated. If you enter the Value date, Business NXT suggests the Year, Period, VAT year and VAT term within which the Value date falls. You can override the Period, Year, VAT year and VAT term yourself. If the Value date is not filled in, it is set to the last date in the relevant period.
The Year, Period, VAT year and VAT term must be later than the Suspension date in the dialog box for the Move suspension date processing in the Company information table, and must fall within a defined accounting period and VAT period for the batch to be updated. Even if a company is not liable to pay tax, at least one VAT period must be defined to cover the entire financial year. The suspension date is updated whenever a VAT statement is approved, which means that vouchers cannot be posted for periods that have finished. You can enter vouchers for the next accounting year before you have finished the current year, provided that the periods for the next year have been defined in the Accounting period and VAT period tables.
If you type + in one of the fields, the system enters the next period that has not been opened.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| SQL name | TxYr | The database field name. |
| API identifier | taxYear | The API identifier used in GraphQL. |
| Number | 4502 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT period | TaxTerm |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| OSS VAT period | OssTaxTerm |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Visma ID
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WfId | The database field name. |
| API identifier | vismaId | The API identifier used in GraphQL. |
| Number | 11195 |
Voucher date
The actual date of the voucher, e.g. the invoice date.
The Voucher date field is a date field, which you enter in the format as defined in the regional settings in Windows. You only need to enter the date and month number for dates in the same year as the Value date of the batch. A check is performed to ensure the date entered is valid. A warning or an error message is given if the voucher date is further away from the current date than the number of days as defined in the No. of days +/- warning or No. of days +/- rejection fields in the Company information table.
If you enter + in this field, the Value date defined for the batch is entered. If you enter / in the field, the Voucher date from the previous voucher line is repeated. The cursor moves to the next field which means you do not have to press Enter.
Updating of currency in amount
Updating of currency in amount requires you to have selected the Update exchange rate from voucher date field in the Voucher type processing field in the Voucher type table.
You have various currencies (ISO codes) in the Currency table. There is a sales rate for each currency here. In the Exchange rate table, you can enter several sales rates for one currency with a different from date.
It is also possible with daily automatically update of the Exchange rate table, if you have integration with Visma.net AutoPay.
- From date = 01/02/2018 and Sales rate = 7.5
- From date = 01/04/2018 and Sales rate = 8
When you have entered a voucher with a voucher date of 01.01.2018, the exchange rate will be 7 and the amount will be NOK 700.
If you enter a voucher with a voucher date of 01.02.2018, the exchange rate will be 7.5 and the amount will be NOK 750.
If you enter a voucher a with a voucher date of 01.04.2018, the exchange rate will be 8 and the amount will be NOK 800.
If you change the voucher date to 01.01.2018, the exchange rate will change to 7 and the amount will become NOK 700.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | VoDt | The database field name. |
| API identifier | voucherDate | The API identifier used in GraphQL. |
| Number | 876 |
Voucher group 1
Grouping value for sorting or selecting vouchers.
You define the codes you want to use and what they should represent. You can also change the description/column heading for the fields. You can define valid values for these fields in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher group 1 | Integer |
| SQL name | VoGr1 | The database field name. |
| API identifier | voucherGroup1 | The API identifier used in GraphQL. |
| Number | 6150 |
Voucher group 2
Grouping value for sorting or selecting vouchers.
You define the codes you want to use and what they should represent. You can also change the description/column heading for the fields. You can define valid values for these fields in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher group 2 | Integer |
| SQL name | VoGr2 | The database field name. |
| API identifier | voucherGroup2 | The API identifier used in GraphQL. |
| Number | 6151 |
Voucher jour. no.
The original voucher journal number.
Is stamped on voucher lines that are created with the Create new batch processing in the Updated batch table or the Create new voucher processing in the Updated voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| SQL name | JNo | The database field name. |
| API identifier | voucherJournalNo | The API identifier used in GraphQL. |
| Number | 10945 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated journal | UpdatedJournal |
| ||
| Updated batch | UpdatedBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Voucher no.
A unique number identifying the voucher line.
This number identifies the vouchers from the time they are entered in the update tables and in the transaction and open entry tables.
If a voucher series has been specified for the batch, you can enter + in the Voucher no. field in the first row of the voucher for a new batch. The next voucher number for the current voucher series will then be retrieved from the Voucher series table. At the same time the counter is incremented by one. If you are not using voucher series, you must know the starting voucher number.
After you have entered the first voucher line of the batch, you can enter + in the Voucher no. field to obtain the next voucher number. If the voucher is not balanced, i.e. if the same amounts have not been posted to credit and debit accounts, entering + in the Voucher no. field will produce the same voucher number as the line above. The cursor moves to the next field in the table.
If you delete a voucher in the batch, the voucher number is not suggested again. Unless you enter the deleted voucher number manually, there will therefore be a gap in the number series.
If you delete the voucher number in the last voucher, the Next voucher no. field in the Voucher series table is reset, and when you enter + in the Voucher no. field the next time you bring up the voucher number that you deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | VoNo | The database field name. |
| API identifier | voucherNo | The API identifier used in GraphQL. |
| Number | 875 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher | Voucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Voucher processing
Options for processing of vouchers.
- Locked
- Enabling this option restricts manual editing of fields in a voucher
line. This function is specifically designed for Swedish companies working with
pre-registration. When running the Update supplier transactions processing in the Batch table, the Locked option will be automatically set on voucher lines in the Voucher table, if the following conditions are met:
- The voucher line contains the general ledger account specified in the Interim cost account field in the Company information table
- Pre-registration for incoming invoices is selected for Workflow processing in the Company information table
This function restricts manual editing of fields in the affected voucher lines while allowing all processing activities to continue operating without regards to this setting. You can also enable and disable the Locked option manually in the Voucher processing field.
- Ledger adjustment
- Proposed accounting rule
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher processing | Integer |
| SQL name | VoPro | The database field name. |
| API identifier | voucherProcessing | The API identifier used in GraphQL. |
| Number | 20577 |
Voucher type
The voucher type controls several aspects of how the voucher is processed, both before and during update.
The voucher type determines the voucher text to be posted with the voucher, and how the voucher is processed. The voucher type determines whether the cursor pauses in the Text field and Currency fields, whether the amount posted for customers and suppliers is included in accumulated turnover/purchases, and whether any tax codes are ignored. Even if the cursor does not pause in a field when you press the Enter or Tab keys, you can still return to the field using the arrow keys or the mouse.
Invoices/credit notes are not included in the total turnover/purchases in the customers/suppliers balance tables if you post them to a voucher type for which you have not checked the Affects turn./purch. box in the Voucher type table. In the Voucher type table supplied with the standard table structure -xxxfirm.txt-, this field is checked for voucher types 11 to 15 (outgoing invoices/credit note), and voucher types 21 to 25 (incoming invoices/credit note). In order to reverse an updated voucher using these voucher types, the same voucher type must also be used for the correction voucher to ensure that the turnover/purchases are correct. Receipts must not be included in total turnover/total purchases, and must therefore be posted using a voucher types other than invoices.
If a voucher series has been defined for the batch, entering + in the Voucher type field causes the Voucher type to be linked to the voucher series. Entering / in the field causes the Voucher type from the previous voucher line to be copied. The cursor moves to the next field which means you do not have to press Enter.
| 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 | 878 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher type | VoucherType |
|
W/off variance cash discount
The W/off variance cash discount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PmVaAmCD | The database field name. |
| API identifier | writeOffVarianceCashDiscountDomestic | The API identifier used in GraphQL. |
| Number | 11058 |
W/off variance cash discount in currency
The W/off variance cash discount in currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 11056 |
W/off variance cash discount in EURO
The W/off variance cash discount in EURO.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | W/off variance cash discount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountInEuro | The API identifier used in GraphQL. |
| Number | 11057 |
W/off variance difference
The W/off variance difference.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceDifference | The API identifier used in GraphQL. |
| Number | 11491 |
W/off variance misc.
The W/off variance misc.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PmVaAm | The database field name. |
| API identifier | writeOffVarianceMiscDomestic | The API identifier used in GraphQL. |
| Number | 11061 |
W/off variance misc. in currency
The W/off variance misc. in currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PmVaCAm | The database field name. |
| API identifier | writeOffVarianceMiscInCurrency | The API identifier used in GraphQL. |
| Number | 11059 |
W/off variance misc. in EURO
The W/off variance misc. in EURO.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | W/off variance misc. in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceMiscInEuro | The API identifier used in GraphQL. |
| Number | 11060 |
W/off variance total
The W/off variance total.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceTotalDomestic | The API identifier used in GraphQL. |
| Number | 11055 |
W/off variance total in currency
The W/off variance total in currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceTotalInCurrency | The API identifier used in GraphQL. |
| Number | 11053 |
W/off variance total in EURO
The W/off variance total in EURO.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | W/off variance total in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceTotalInEuro | The API identifier used in GraphQL. |
| Number | 11054 |
Web page
If, for example, you want to link a special web page to one of your vouchers, you can enter the address here.
You can, for example, use the field to link to scanned documents which are a copy of the voucher so that you can later perform look-ups from the transactions in order to see the voucher electronically. The value in the field is transferred from the voucher lines to updated vouchers and on to the transactions and open entries.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | WebPg | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 9174 |
Year
The accounting year to use.
The Year and Period fields are the accounting year and period for which the batch is updated. The VAT year and VAT term are the VAT year and VAT term for which the batch is updated. If you complete the Value date field, Business NXT suggests the year, period, VAT year and VAT term within which the Value date falls. You can override the period, year, VAT year and VAT term yourself. If the Value date is not filled in, it is set to the last date in the relevant period.
The period, year, VAT year and VAT term must be later than the Suspension date in the dialog box for the Move suspension date processing in the Company information table, and must fall within a defined accounting period and VAT term for the batch to be updated. Even if a company is not liable to pay tax, at least one VAT period must be defined to cover the entire financial year. The suspension date is updated whenever a VAT statement is approved, which means that vouchers cannot be posted for periods that have finished. You can enter vouchers for the next accounting year before you have finished the current year, provided that the periods for the next year have been defined in the Accounting period and VAT period tables.
If you type + in one of the fields, the system enters the next period that has not been opened.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| SQL name | AcYr | The database field name. |
| API identifier | year | The API identifier used in GraphQL. |
| Number | 4500 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting period | AccountingPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Batch | PeriodBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
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 provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
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 provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | 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. |