Batch
This table contains one row for each bundle of vouchers, which may be updated at once.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | WaBnd | The table name in the database. |
| API identifier | batch | The API identifier used in GraphQL. |
| Table no. | 44 | The table number in the data model. |
The following fields exist in this table:
Accounting document no.
Refers to the Accounting document table.
The field is populated when running the Process document processing in the 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 | 19539 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting document | IncomingAccountingDocument |
|
Active approval task no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Approval Task no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcAppTskNo | The database field name. |
| API identifier | activeApprovalTaskNo | The API identifier used in GraphQL. |
| Number | 18981 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Approval task | ApprovalTask |
|
Authorisation
The batch contains voucher(s) with authorisation of supplier invoice.
When checked you must also unhide the field Previous voucher no. in the Voucher table. If you enter a Previous voucher no. on the vouchers, Business NXT will retrieve the entry for the previous voucher and enter it against this voucher to reset the previous posting, so that you can post it on the definite account.
Example
To use the Authorisation field for the advance / definite entry of incoming invoices, you must first post a voucher for incoming invoices to an interim account. Let us assume that we are posting an incoming invoice in the journal entry for GBP 100.00 which is subject to VAT. In this case, one voucher for GBP 100.00 is credited to e.g. account 2410 (accounts payable), GBP 82.50 is debited from the interim account and GBP 17.50 is debited from account 2710 (incoming VAT). This means that the VAT can be deducted in the next VAT period.When you are ready to Approve the incoming invoice, you must select the Authorisation field in the Batch table. When you get down to the vouchers in the Voucher table, you enter the Voucher no. of the voucher that has been entered in advance in the Previous voucher no. Business NXT then credits the interim account with the amount 82.50. You must then debit the definite debit account, so that the interim account is settled and the purchase is posted to the correct debit account. If you have several accounts to which the purchase is to be posted, you can of course do this.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | Att | The database field name. |
| API identifier | authorisation | The API identifier used in GraphQL. |
| Number | 3661 |
Batch no.
A unique number identifying the Batch.
Can be entered manually. Next free Batch no. will be given by entering +, although omissions in the number series resulting from any deleted batches are not suggested. When you update the batch the Batch no. is released so that you can re-use numbers if you wish unless the Updated batch has a "x" in the Keep field.
| 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. |
| SQL name | BndNo | The database field name. |
| API identifier | batchNo | The API identifier used in GraphQL. |
| Number | 2248 |
Batch processing
Settings defining the behaviour of the batch.
- Copy description to new lines
- Selecting this, Business NXT copies the text in the Description field in the batch head to the Text field in new voucher lines instead of suggesting the text field from the Voucher type table.
- Exclude VAT when checking amount difference
- The debit-/ credit difference will be calculated from the column Amount excl. VAT in the Voucher table.
- Locked
- If selected, the Batch is locked for editing. No changes can be done in the Batch and its Voucher lines.
- Tentative - Do not assign voucher numbers
- If selected, no Voucher no. will be set for the voucher lines. The Tentative field in the Batch table will visualise this selection. Selection can be removed manually, either by clearing the value in the Tentative field, or via the Assign voucher numbers processing.
- Pre-registration
- This option is used by Visma Business Workflow. It is automatically set when Pre-registration for incoming invoices has been enabled in Workflow processing field in Company information table and batch has been created by Process document in Accounting document table.
- In Approval
- Reversal
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Batch processing | Integer |
| SQL name | BtPro | The database field name. |
| API identifier | batchProcessing | The API identifier used in GraphQL. |
| Number | 8503 |
Calculated CB bank
Shows OB bank + Calculated movem. bank.
| 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 | calculatedCbBankDomestic | The API identifier used in GraphQL. |
| Number | 6823 |
Calculated movem. bank
Shows the overall movement (the difference between debit and credit) in the batch for the account entered in the Gen. ledger acc. bank field.
The value is calculated continuously when you fill in, change or delete amounts or the debit/credit account number in the vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CpBankCh | The database field name. |
| API identifier | calculatedFlowBankDomestic | The API identifier used in GraphQL. |
| Number | 6822 |
CB bank
An outgoing balance from the bank account statement.
The amount is meant to be filled in manually from the bank account statement, to be compared to the Calculated CB bank.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | BankOB | The database field name. |
| API identifier | cbBankDomestic | The API identifier used in GraphQL. |
| Number | 6821 |
Check sum
A manually calculated total of the credit and debit entries.
The difference between this field and Total credit field appears in the Control diff. field.
You can enter a manually calculated check sum in this field to ensure that you have entered all the vouchers in the batch. This enables you to check that the sum Total debit/Total credit (see below) is equal to the Check sum before you update the batch. Alternatively, you can use the field as an information field for other users, for example, to record why the batch has not yet been updated.
If you decide to use the field for a particular piece of information, the lead text/column heading can be given a more appropriate designation, e.g. Check sum or Information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CtrlSm | The database field name. |
| API identifier | controlSumDomestic | The API identifier used in GraphQL. |
| Number | 4584 |
Control diff.
Shows the difference between the Check sum and Total debit fields.
You can enter a manually calculated Check sum in the field to ensure that you have entered all the vouchers in the batch. This enables you to check that the Total debit/Total credit fields are equal to the Check sum before you update the batch. Alternatively, you can use the field as an information field for other users, for example to record why the batch has not yet been updated.
If you decide to use the field for a particular piece of information, the lead text/column heading can be given a more appropriate designation, e.g. Check sum or Information.
| 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 | controlDifferenceDomestic | The API identifier used in GraphQL. |
| Number | 4585 |
Curr. diff.
Shows the difference between Sum curr. debit and Sum curr. credit fields.
This field is an information field, which is updated whenever you enter, change or delete an amount or an account number on the Vouchers.
The field has the same function as the Difference field but in the current currency. See the explanation under the Difference field.
| 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 | differenceInCurrency | The API identifier used in GraphQL. |
| Number | 12251 |
Curr. 2 diff.
Shows the difference between Sum curr. 2 debit and Sum curr. 2 credit fields.
This field is an information field, which is updated whenever you enter, change or delete an amount or an account number on the Vouchers.
The field has the same function as the Difference field but in the current currency 2. See the explanation under the Difference field.
| 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 | differenceInCurrency2 | The API identifier used in GraphQL. |
| Number | 15249 |
Currency no.
To follow the balance control for bank accounts in foreign currency.
If you want to use the function with calculated OB, Motion and CB on bank vouchers, even in the Currency account, you enter the Currency no. in this field. Then only entries to the bank account in the vouchers with this Currency no. will be accumulated in the batch head.
| 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 | 12248 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Currency no. 2
The value will be suggested on the vouchers.
Will be suggested on the vouchers (if the column is empty) when Debit account / Credit account fields are entered.
| 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 | 14347 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency2 |
|
Description
A brief description or additional information relating to the batch.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 846 |
Difference
Shows the difference between the Total debit and Total credit fields.
An information field, which is updated whenever you enter, change or delete an amount or an account number on the vouchers.
A negative difference means that a higher total amount has been posted to the Credit account than to the Debit account. If the Debit/credit control field is selected in the Company information table, you are not allowed to update batches containing a difference. There is no control to determine whether the Batch contains a difference when it is saved, because the batch is regarded as a draft until it is updated.
If a group voucher from the bank or Post Office is entered extending over several vouchers, it is a good idea to check that there are no differences in the Voucher (a Voucher can easily be overlooked).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | differenceDomestic | The API identifier used in GraphQL. |
| Number | 860 |
Difference CB bank
Shows CB bank - Calculated CB bank.
| 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 | differenceCbBankDomestic | The API identifier used in GraphQL. |
| Number | 6824 |
Difference excl. VAT
Shows the difference between Total Debit excl. VAT and Total Credit excl. VAT fields.
This field is an information field, which is updated whenever you enter, change or delete an amount or an account number on the Vouchers.
The field has the same function as the Difference field but with amounts excl. VAT. See the explanation under the Difference field.
| 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 | differenceExclusiveVatDomestic | The API identifier used in GraphQL. |
| Number | 16415 |
Gen. ledger acc. bank
The General ledger account number for the bank account you wish to control.
The account no. for the bank account that you want to follow in the entered vouchers by using the OB bank, CB bank, Calculated CB bank and Calculated movem. bank fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | BankAcNo | The database field name. |
| API identifier | generalLedgerAccountNoForBank | The API identifier used in GraphQL. |
| Number | 6819 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GeneralLedgerAccountBank |
|
Keep
If you select this field the Batch will remain in the Batch table even after it has been updated.
The Voucher no. and date are retained, which means that if you need to update the batch more than once, you should change these fields if necessary before the next update. The box is checked if any value other than 0 and blank is entered.
In the case of fixed, periodic vouchers such as rental and other fixed expenditure, you can create permanent batches, where you only update Voucher no. and date before updating. The Suspended field should also be checked for such periodically batches to make sure they are not updated by mistake. In order to avoid involuntary double updates of batches, a safer, recommended alternative is to create new batches of batches that have already been updated. To do this, select the Create new batch processing in the Updated batch table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | Keep | The database field name. |
| API identifier | keep | The API identifier used in GraphQL. |
| Number | 4722 |
Locked
This field indicates if a Batch is locked for editing or not.
The following Voucher processings are prevented from running when Batch is Locked:
- Processing Accrual accounting
- Processing Correct VAT variance
- Processing Document information
- Processing Document viewer
- Processing Expand automatic entries
- Processing Get open entries
- Processing Scan
- Processing Validate voucher
- Processing View payment details
- Processing Assign voucher numbers
The following Voucher commands are prevented from running when Batch is Locked:
- Command Insert before (Ctrl+I)
- Command Insert after (Shift+Ctrl+I)
| 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 | locked | The API identifier used in GraphQL. |
| Number | 18954 |
OB bank
An incoming balance from the bank printout.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | BankIB | The database field name. |
| API identifier | obBankDomestic | The API identifier used in GraphQL. |
| Number | 6820 |
Organisational unit 1
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 848 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 849 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 850 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 851 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 852 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 853 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 9624 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 9625 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 9626 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 9627 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 9628 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
The field is used to specify organisational unit.
Reference fields appear in the Batch window corresponding to the organisational unit classes you have defined in the Company information table. The fields might be called for example Department, Project or Object. You have one field per organisational unit, so that you can run the same Batch for both a department and a project, for example.
You enter the organisational units for which to run the batch. The organisational units are suggested in the vouchers when you post general ledger accounts for which you have not entered a permanent organisational unit, and only if the option of suggesting the organisational unit class is enabled. In the case of accounts for which permanent organisational units have been defined, these will continue to be suggested in preference to the organisational unit defined in the batch. You can change the organisational unit in each vouchers by returning to the Organisational unit field.
When an organisational unit is entered in the Batch head or the vouchers, other organisational units that you have entered for this organisational unit, are suggested.
Example
If you have created a project in the Project table with a set reference to a particular department, the department number from this project will be suggested in the Department field when you enter the project number in the Project field in the batch or the vouchers.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 | 9629 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Origin
The origin code.
The Origin and Original run no. fields in the Batch table are only information fields.
The first field indicates whether the batch was entered manually or it was generated in an automatic routine. The latter case applies, for example, to payment transfer, interest computation, reminders, closing VAT period, OCR payments, etc.
The other field indicates the run number allocated to the batch in question. The run number will only be filled out from relevant processes, e.g. invoicing (Order journal no) and VAT reports (VAT report no)
These fields are uneditable.
- 1 - Manually entered
- 2 - Automatically generated
- 13 - Automatic entry
- 3 - VAT report
- 41 - OSS VAT report
- 10 - Direct debiting
- 4 - Reminder
- 5 - Interest note
- 8 - OCR payment
- 21 - Write off payments
- 6 - Giro payment
- 7 - Direct payment
- 11 - Depreciation on capital assets
- 9 - Order processing
- 23 - Incoming invoice
- 12 - Import
- Normal text import.
- 14 - Previous batch
- 15 - Compressing transactions
- 16 - Posting of costs
- 18 - Internal invoicing
- 17 - Differences
- When you update a batch with this origin code debit/credit control is not carried out.
- 19 - EDI invoice import
- 20 - Payroll
- 22 - Visma Business Services
- 24 - Activate Capital asset
- 25 - Calculate client interest
- 26 - Document Center temporary batch
- 27 - Document Center finished batch
- 28 - Debt collector
- 29 - Split invoice
- 30 - Currency correction
- 31 - External application
- If this origin code is used, this value can be used by other applications that use BIG or SQL and create batches.
- 32 - Cash order document
- 33 - Sell or scrap capital asset
- 34 - Initializing capital asset
- 35 - EDI read dirdeb vouchers
- 37 - Accrual accounting
- 38 - Order processing with picking after invoicing
- 39 - Picked after invoicing
- 40 - Correction of costs
- 42 - Accounting document
- Batch was created from Accounting document table.
- 43 - Order match pre-registration
- 44 - Self billing invoice
- 45 - Split batch, supplier transactions
- Batch was created by Update supplier transactions processing for supplier transactions only.
- 46 - Split batch, cost transactions
- Batch was created by Update supplier transactions processing for cost and capital transactions to be adjusted after payment.
- 47 - Account statement vouchers
- Batch was created by Create voucher processing in the Account statement transaction table.
- 48 - WebFaktura
- 49 - Central
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Origin | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcTp | The database field name. |
| API identifier | origin | The API identifier used in GraphQL. |
| Number | 861 |
Original run no.
The run number is a sequence number which is allocated when batches are created from certain internal processes
The Origin and Original run no. fields in the Batch table are only information fields.
The first field indicates whether the batch was entered manually or it was generated in an automatic routine. The latter case applies, for example, to payment transfer, interest computation, reminders, closing VAT period, OCR payments, etc.
The other field indicates the run number allocated to the batch in question. The run number will only be filled out from relevant processes, e.g. invoicing (Order journal no) and VAT reports (VAT report no)
These fields are uneditable.
| 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 | SrcJNo | The database field name. |
| API identifier | originalRunNo | The API identifier used in GraphQL. |
| Number | 862 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order journal | OrderJournal |
|
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 | 17563 |
| 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. |
Period
The accounting period to use.
The Year and Period fields are the accounting year and period for which the batch is updated. The VAT year and VAT period fields are the VAT period and VAT year for which the batch is updated. If you complete the Value date field, Business NXT suggests the Year, Period, VAT year and VAT period within which the Value date falls. You can override the Period, Year, VAT year and VAT term fields yourself. If the Value date is not filled in, Business NXT sets it to the last date in the relevant period.
Example If accounting period 13 is used for year-end transactions, the end date for accounting periods 12 and 13 will be the same, i.e. 31.12. This means that if you post vouchers in period 13 and enter 31.12 in the Value date field, the value 12 is entered in the Period field. The value 13 must therefore override the Period field, to ensure that Business NXT updates the batch in the correct 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 to update the batch. Even if a company is not liable to pay tax, at least one VAT term must be defined to cover the entire accounting year.
The suspension date can be 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 | AcPr | The database field name. |
| API identifier | period | The API identifier used in GraphQL. |
| Number | 4509 |
Period batch no.
Shows the Period batch no. and the value is retrieved from the batch.
- General ledger transaction
- Customer transaction
- Supplier transaction
- Capital asset transaction
- Open customer entry
- Open supplier entry
| 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 | 10552 |
Previous batch no.
Shows the Batch no. from the original batch on batches that are created from the Updated batch table.
The no will show the original Batch no. for batches with the origin 14 - Previous batch.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Batch no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrvBndNo | The database field name. |
| API identifier | previousBatchNo | The API identifier used in GraphQL. |
| Number | 14861 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated batch | PreviousBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Previous voucher journal no.
Shows the Voucher jour. no. from the original batch on batches that are created from the Updated batch table.
Will be filled out only on batches with the origin 14 - Previous batch
| 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 | PrvJNo | The database field name. |
| API identifier | previousVoucherJournalNo | The API identifier used in GraphQL. |
| Number | 14860 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated batch | PreviousBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Reversal OSS VAT period
Derived from the Voucher reversal date field.
The Reversal VAT period, Reversal VAT year, Reversal period and Reversal year fields are filled in when you enter the reversal date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| SQL name | RevEsTxTrm | The database field name. |
| API identifier | reversalOssTaxTerm | The API identifier used in GraphQL. |
| Number | 17567 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| OSS VAT period | ReversalOssTaxTerm |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Reversal period
Derived from the Voucher reversal date field.
The Reversal VAT period, Reversal VAT year, Reversal period and Reversal year fields are filled in when you enter the reversal date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| SQL name | RevAcPr | The database field name. |
| API identifier | reversalPeriod | The API identifier used in GraphQL. |
| Number | 8506 |
Reversal VAT period
Derived from the Voucher reversal date field.
The Reversal VAT period, Reversal VAT year, Reversal period and Reversal year fields are filled in when you enter the reversal date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| SQL name | RevTxTrm | The database field name. |
| API identifier | reversalTaxTerm | The API identifier used in GraphQL. |
| Number | 8508 |
Reversal VAT year
Derived from the Voucher reversal date field.
The Reversal VAT period, Reversal VAT year, Reversal period and Reversal year fields are filled in when you enter the reversal date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| SQL name | RevTxYr | The database field name. |
| API identifier | reversalTaxYear | The API identifier used in GraphQL. |
| Number | 8507 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT period | ReversalTaxTerm |
| 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 | ReversalOssTaxTerm |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Reversal year
Derived from the Voucher reversal date field.
The Reversal VAT period, Reversal VAT year, Reversal period and Reversal year fields are filled in when you enter the reversal date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| SQL name | RevAcYr | The database field name. |
| API identifier | reversalYear | The API identifier used in GraphQL. |
| Number | 8505 |
Sum curr. 2 credit
An information field showing the total of all amounts that have been credited in currency 2.
Has the same function as the Total credit field, but in the relevant currency 2.
The field is updated each time you enter, change or delete an amount or account number in the Voucher table. You can also use the Sum curr. 2 debit and Sum curr. 2 credit fields to check against a manually calculated Check sum to ensure that all vouchers have been entered correctly. You then total the vouchers in the batch manually before you start posting them. The Check sum may be entered in the Description field (see previous section).
The field is uneditable.
| 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 | CSmCr2 | The database field name. |
| API identifier | sumCreditInCurrency2 | The API identifier used in GraphQL. |
| Number | 15248 |
Sum curr. 2 debit
An information field showing the total of all amounts that have been debited in currency 2.
Has the same function as the Total debit field, but in the current currency 2.
This field is updated each time you enter, change or delete an amount or account number in the Voucher table. You can also use the Sum curr. 2 debit and Sum curr. 2 credit fields to check against a manually calculated Check sum to ensure that all vouchers have been entered correctly. You then total the vouchers in the batch manually before you start posting them. You can enter the Check sum in the Description field.
The field is uneditable.
| 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 | CSmDb2 | The database field name. |
| API identifier | sumDebitInCurrency2 | The API identifier used in GraphQL. |
| Number | 15247 |
Sum curr. credit
An information field showing the total of all amounts that have been credited in currency.
Has the same function as the Total credit field, but in the current currency.
The field is updated every time you enter, change or delete an amount or an account number in the Voucher table. You can also use the Sum curr. debit and Sum curr. credit fields to check against a manually calculated Check sum to ensure that all vouchers have been entered correctly. You then total the vouchers in the batch manually before you start posting them. The Check sum may be entered in the Description field (see previous section).
The field is uneditable.
| 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 | CSmCr | The database field name. |
| API identifier | sumCreditInCurrency | The API identifier used in GraphQL. |
| Number | 12250 |
Sum curr. debit
An information field showing the total of all amounts that have been debited in currency.
Has the same function as the Total debit field, but in the current currency.
The field is updated every time you enter, change or delete an amount or an account number in the Voucher table. You can also use the Sum curr. debit and Sum curr. credit fields to check against a manually calculated Check sum to ensure that all vouchers have been entered correctly. You then total the vouchers in the batch manually before you start posting them. You can enter the Check sum in the Description field.
The field is uneditable.
| 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 | CSmDb | The database field name. |
| API identifier | sumDebitInCurrency | The API identifier used in GraphQL. |
| Number | 12249 |
Suspended
If you select the check box for this field, the Batch will be suspended for updates until the field is deselected.
The box is checked if any value other than 0 and blank is entered.
You should use this field if you close a Batch without completing Voucher entry, to prevent another user updating the batch by mistake. You can enter a comment in the Description field to explain why the batch must not be updated yet. If you try to update a suspended Batch, an error message will be displayed in the status bar and in a dialog and the update process will not be started.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | Susp | The database field name. |
| API identifier | suspended | The API identifier used in GraphQL. |
| Number | 863 |
Tentative
If selected, no Voucher no. will be set for the voucher lines.
This field is a visualisation of the Tentative - Do not assign voucher numbers flag in the Batch processing field. Used in import from Visma Business Workflow of incoming invoices that are still in the approval flow.
| 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 | tentative | The API identifier used in GraphQL. |
| Number | 18987 |
Total credit
An information field showing the total all amounts that have been credited.
The field is updated every time you enter, change or delete an amount or a credit account number in the Voucher window. You can also use the Total debit and Total credit fields to check against a manually calculated Check sum to ensure that all vouchers have been entered correctly. In that case You total the vouchers in the batch manually before you start posting them. The Check sum may for example be entered in the Description field (see previous section).
The field is uneditable.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SmCr | The database field name. |
| API identifier | sumCreditDomestic | The API identifier used in GraphQL. |
| Number | 859 |
Total Credit excl. VAT
An information field showing the total of all amounts that have been credited excl. VAT.
The field is updated every time you enter, change or delete an amount or an account number in the Voucher window. You can also use the Total Debit excl. VAT and Total Credit excl. VAT fields to check against a manually calculated Check sum to ensure that all vouchers have been entered correctly. You then total the vouchers in the Batch manually before you start posting them. The Check sum may be entered in the Description field (see previous section).
The field is uneditable.
| 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 | SmCrExVat | The database field name. |
| API identifier | sumCreditExclusiveVatDomestic | The API identifier used in GraphQL. |
| Number | 16414 |
Total debit
An information field showing the total of all amounts that have been debited.
The field is updated every time you enter, change or delete an amount or an account number in the Voucher window. You can also use the Total debit and Total credit fields to check against a manually calculated Check sum to ensure that all vouchers have been entered correctly. You then total the vouchers in the batch manually before you start posting them. You can enter the Check sum in the Description field.
The field is uneditable.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SmDb | The database field name. |
| API identifier | sumDebitDomestic | The API identifier used in GraphQL. |
| Number | 858 |
Total Debit excl. VAT
An information field showing the total of all amounts that have been debited excl. VAT.
The field is updated every time you enter, change or delete an amount or an account number in the Voucher window. You can also use the Total Debit excl. VAT and Total Credit excl. VAT fields to check against a manually calculated Check sum to ensure that all vouchers have been entered correctly. You then total the vouchers in the batch manually before you start posting them. You can enter the Check sum in the Description field.
The field is uneditable.
| 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 | SmDbExVat | The database field name. |
| API identifier | sumDebitExclusiveVatDomestic | The API identifier used in GraphQL. |
| Number | 16413 |
Value date
The Value date for the vouchers.
The Value date field completes the Period, Year, VAT period and VAT year 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 term and VAT year to the correct Period and Year manually.
If you type / in the field, the system copies the date from the previous batch. The field pointer 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 | Yes | This field is 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 | 847 |
VAT term
The VAT period to use.
The Year and Period fields are the accounting year and period for which the batch is updated. The VAT year and VAT period fields are the VAT period and VAT year for which the batch is updated. If you complete the Value date field, Business NXT suggests the Year, Period, VAT year and VAT period within which the Value date falls. You can override the Period, Year, VAT year and VAT term fields yourself. If the Value date is not filled in, Business NXT sets it to the last date in the relevant period.
Example If accounting period 13 is used for year-end transactions, the end date for accounting periods 12 and 13 will be the same, i.e. 31.12. This means that if you post vouchers in period 13 and enter 31.12 in the Value date field, the value 12 is entered in the Period field. The value 13 must therefore override the Period field, to ensure that Business NXT updates the batch in the correct 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 to update the batch. Even if a company is not liable to pay tax, at least one VAT term must be defined to cover the entire accounting year.
The suspension date can be 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 | 4511 |
VAT year
The VAT 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 period fields are the VAT period and VAT year for which the batch is updated. If you complete the Value date field, Business NXT suggests the Year, Period, VAT year and VAT period within which the Value date falls. You can override the Period, Year, VAT year and VAT term fields yourself. If the Value date is not filled in, Business NXT sets it to the last date in the relevant period.
Example If accounting period 13 is used for year-end transactions, the end date for accounting periods 12 and 13 will be the same, i.e. 31.12. This means that if you post vouchers in period 13 and enter 31.12 in the Value date field, the value 12 is entered in the Period field. The value 13 must therefore override the Period field, to ensure that Business NXT updates the batch in the correct 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 to update the batch. Even if a company is not liable to pay tax, at least one VAT term must be defined to cover the entire accounting year.
The suspension date can be 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 | 4510 |
| 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. |
Voucher reversal date
To be used if the batch is to be reversed at a later time, e.g. accruals at year-end etc.
You define the Voucher reversal date on which you wish to reverse the batch if necessary. If you enter + in this field, the first day of the next accounting period is entered. The Reversal VAT period, Reversal VAT year, Reversal period and Reversal year fields are filled in when you enter the reversal date.
If these fields are filled in when you update the batch, Business NXT updates the batch again after regular updating with the reversal date as the Value date, reversal year and period as the accounting year and period, Reversal VAT year and term as the VAT year and term, in the batch and in all vouchers, and with the values in the debit and credit fields reversed.
The reversal date is used as the Voucher date.
The transactions in the two rounds of updating are labelled in the Trans. status field with flags for temporary and reversal respectively. The flags are visualised with radio buttons in the Duration group in the look-up dialog box for this field. Regular transactions have a selection in the Permanent radio button. The fields are carried to the table of Updated batch (and if necessary back again using the Create new batch processing).
The tables with Updated batch, vouchers and cross-references are updated in the final round, and the rows in the tables with batches, vouchers and cross-references are deleted.
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 | RevDt | The database field name. |
| API identifier | voucherReversalDate | The API identifier used in GraphQL. |
| Number | 8504 |
Voucher series no.
The Voucher series to use.
If you specify a Voucher series for the batch, you can type + in the Voucher no. and Voucher type fields in the Voucher window. This causes Business NXT to suggest the next voucher no. in the specified Voucher series and the Voucher type defined for the Voucher series. This assumes that you have defined separate Voucher series for the major types of vouchers. You can change or even delete the Voucher series specified for the batch several times when entering vouchers in a batch. Changing the Voucher series only affects new vouchers.
Example If you specify the Voucher series for outgoing invoices for a Batch and then enter all the outgoing invoices, you can change the Voucher series for bank vouchers in the Batch window afterwards. The suggested number in the next vouchers of the Voucher window will relate to the bank vouchers series.
If the Voucher series is reserved, either because Business NXT is currently updating vouchers for another user or because another user has reserved the series, the following message will be shown: The voucher series is in use. If voucher number control is being used and an abnormal interruption occurs during Voucher entry, the voucher series in use will remain reserved until the system supervisor releases the lock.
If you prefer to register the vouchers unsorted, you can skip the Voucher series no. field in the batch. However, you must then keep track of the first free voucher no. yourself, because Business NXT only keeps track of voucher no. within the various voucher series defined in the Voucher series table.
You can also receive a message if the Voucher series is suspended. All Voucher series used by Business NXT in automated routines are blocked from manual use.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher series no. | Integer |
| SQL name | SrNo | The database field name. |
| API identifier | voucherSeriesNo | The API identifier used in GraphQL. |
| Number | 1928 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher series | VoucherSeries |
|
Workflow document ID
An identifier for a document, such as an invoice or a voucher, that is processed via Visma Business Workflow.
Workflow document ID is assigned when sending the document for approval. The identifier can be used to find the document for example in Visma.net Approval.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Workflow document ID | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WfDocId | The database field name. |
| API identifier | workflowDocumentId | The API identifier used in GraphQL. |
| Number | 18982 |
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 period fields are the VAT period and VAT year for which the batch is updated. If you complete the Value date field, Business NXT suggests the Year, Period, VAT year and VAT period within which the Value date falls. You can override the Period, Year, VAT year and VAT term fields yourself. If the Value date is not filled in, Business NXT sets it to the last date in the relevant period.
Example If accounting period 13 is used for year-end transactions, the end date for accounting periods 12 and 13 will be the same, i.e. 31.12. This means that if you post vouchers in period 13 and enter 31.12 in the Value date field, the value 12 is entered in the Period field. The value 13 must therefore override the Period field, to ensure that Business NXT updates the batch in the correct 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 to update the batch. Even if a company is not liable to pay tax, at least one VAT term must be defined to cover the entire accounting year.
The suspension date can be 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 | 4508 |
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. |