General ledger transaction

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.

Details about the payment can be seen using the View payment details processing.

The field is used for VAT control, to reveal any manual changes in VAT amounts that have been made before updating.

The field is mainly used to track the capital asset no on General ledger transactions concerning automatically generated postings on capital asset General ledger account.

Shows the fraction of the VAT percentage that is not deductible. Occurs only on transactions with a VAT code that has Cost % defined in the VAT code table. Occurs in companies with a mix of VAT-liable and non-VAT-liable activities.

Shows the fraction of the VAT amount that is not deductible. Occurs only on transactions with a VAT code that has Cost % defined in the VAT code table. Occurs in companies with a mix of VAT-liable and non-VAT-liable activities.

The field can be used for selection of credit amounts. Eg for reporting and analysis purposes

In general ledger transactions, Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any investment tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.

Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any investment tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.

If postings are made to both debit and credit accounts in the same voucher line, the Cross-account no. and Cross-account type fields indicate the customer, supplier, Capital assetor General ledger accountaccount relating to the other transaction generated from the voucher line.

If the Posting errors account from the Company information table has been used, because the original account is non-existent, the Cross-account no. and Cross-account type fields indicate instead the customer, supplier, Capital asset or General ledger account to which you attempted to post the voucher.

If postings are made to both debit and credit accounts in the same voucher line, the Cross-account no. and Cross-account type fields indicate the customer, supplier, Capital asset or General ledger account account relating to the other transaction.

If the Posting errors account from the Company information table has been used, because the original account is non-existent, the Cross-account no. and Cross-account type fields indicate instead the customer, supplier, Capital asset or General ledger account to which you attempted to post the voucher.

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.

The field originally contains the same value as the Outstanding amount, or the Posted amount field if the correction is run on General ledger transaction or Capital asset transaction.

Each time the Currency correction processing is run, the field will be updated with the product of Curr. corr. exch. rate and Outstanding amount in currency or the Amount in currency if the correction is run on General ledger transaction or Capital asset transaction.

If no exchange rate adjustment has been performed, the field shows the same value as the Value date field.

The date is validated using the regional settings in Windows.

The field is updated when you run the Transfer corrections to table processing from the Currency correction data table. If no exchange rate adjustment has ever been performed, the field shows the same value as the Exchange rate field, which is inherited from the voucher.

The currency number is normally inherited from the voucher. If no currency number was entered on the voucher, the field will anyway be updated with the Currency no. from the Company information table.

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.

The date is validated using the regional settings in Windows.

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.

The date is validated using the regional settings in Windows.

In general ledger transactions, Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any investment tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.

Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any investment tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.

The Empl. no. is a unique number identifying one specific Employee.

In general ledger transactions, Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.

If several errors are detected, they are listed with a comma separating them.

Illegal value date

Unknown organisational unit 1

Unknown organisational unit 2

Unknown organisational unit 3

Unknown organisational unit 4

Unknown organisational unit 5

Unknown organisational unit 6

Unknown debit account, Cust. no., Account no. or Cap. asset no.

Unknown credit account, Cust. no., Account no. or Cap. asset no.

Unknown debit VAT code or VAT code

Unknown credit VAT code or VAT code

Unknown debit VAT rate

Unknown credit VAT rate

Unknown debit investment tax

Unknown credit investment tax

Unknown debit payment terms

Unknown credit payment terms

Unknown distribution key

Illegal debit turnover cl. or Turnover class

Illegal credit turnover cl. or Turnover class

Missing credit turnover cl. or Turnover class

The grace period for the debit has exceeded

The grace period for the credit has exceeded

Unknown organisational unit 7

Unknown organisational unit 8

Unknown organisational unit 9

Unknown organisational unit 10

Unknown organisational unit 11

Unknown organisational unit 12

Missing accounting period

Is updated from the Voucher table.

Is updated from the Voucher table.

If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.

If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.

If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.

If the Invoice no. field is empty on the Voucher, this field will be updated with the Voucher no. field instead. This requires that Affects turn./purch. is selected in the Voucher type table.

The field will equal the Amount field if no Currency correction processing has been performed.

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.

The actual memo is stored in the Memo table.

The number of the Order from which the transaction has its origin.

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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.

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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.

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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.

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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.

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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.

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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.

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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

It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.

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

The automatically generated transactions are labelled as to their origin (for example reminder, interest note or payment).

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

The number can be used to trace the transactions generated from orders.

The period batch number is included in automatic entries. On normal transactions, the value is taken from the Batch unless it is given on vouchers.

The amount posted shows the amount as it is posted, regardless of if another amount, eg an amount incl VAT was entered on the voucher line. Business NXT deducts any input or output VAT from the amount entered on voucher line, using the result as the base amount for the taxes. The amount posted is equal to this base amount.

Used for bank reconciliation of bank accounts in domestic currency.

Filled out when the Account no. on the transactions is found in the Bank partner table, and Update general ledger transactions with reconciliation amount is selected under the EFT processing field on the relevant bank partner.

Can be edited manually. The value must be between 0 and the Posted amount. The Reconciliation rest amount in currency field will then be calculated automatically.

Used for bank reconciliation of bank accounts in foreign currency.

Filled out when the Account no. on the transactions is found in the Bank partner table, and Update general ledger transactions with reconciliation amount is selected under the EFT processing field on the relevant bank partner.

Can be edited manually. The value must be between 0 and the Amount in currency. The Reconciliation rest amount field will then be calculated automatically.

Status is set when the Disable reconciliation or the Enable reconciliation processing is executed for the row.

0 - None

1 - Reconciliation disabled

2 - Reconciliation enabled

Is used in connection with Visma Document Center.

Is used in connection with Visma Document Center.

1 - Scanned document

2 - Document on flow

4 - Document finished

If the original voucher line contained a supplier no in the debit account field or in the credit account field, the supplier no will be automatically entered and inherited to the general ledger transaction.

For automatically generated transactions Visma Business takes the Voucher type from the Voucher series for automatically generated transactions and the text field is filled in with the default text for this Voucher type.

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

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

The reference is important for the case when it is demanded to withdraw the record with the Create new voucher processing in the Updated voucher table.

The reference is important for the case when it is demanded to withdraw the record with the Create new voucher processing in the Updated voucher table.