VAT rate

This table contains one row for each VAT, with rates and accounts.

The entries are used in the VAT code and Tax code automatic entry tables.

If the company is eligible for VAT compensation, you specify this in the VAT processing, Debit withh. tax and Credit withh. tax fields.

The following fields exist in this table:

Cost account

The account used for posting the non-deductible share of received taxes.

If the company is not eligible for received taxes to be deducted in full, the share that is non-deductible is entered in the Cost % field in the VAT code table. If you want to separate this cost from the purchase account and post it to a separate general ledger account, enter the account no. in this field.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	CstAcNo	The database field name.
API identifier	costAccountNo	The API identifier used in GraphQL.
Number	3339

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	CostAccount	Cost account	Account no.

Credit Rev. VAT acc. no.

The credit account used for posting reversed VAT on transactions where the Turnover class is set to 25 - Domestic purchases with reversed VAT liability.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	CrRevAc	The database field name.
API identifier	creditReversedVatAccountNo	The API identifier used in GraphQL.
Number	15259

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	CreditReversedVatAccount	Credit Rev. VAT acc. no.	Account no.

Credit withh. tax

The cost account used for posting compensation for VAT or for credit posting of source tax.

Note:

The value will be used as cost account for posting VAT compensation if you follow the Norwegian accounting rules. If you follow the Lithuanian accounting rules the value will be used as credit account for posting source tax.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	CrWthAc	The database field name.
API identifier	creditWithholdingTaxAccountNo	The API identifier used in GraphQL.
Number	4818

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	CreditWithholdingTaxAccount	Credit withh. tax	Account no.

Debit Rev. VAT acc. no.

The debit account used for posting reversed VAT on transactions where the Turnover class is set to 25 - Domestic purchases with reversed VAT liability.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	DbRevAc	The database field name.
API identifier	debitReversedVatAccountNo	The API identifier used in GraphQL.
Number	15258

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	DebitReversedVatAccount	Debit Rev. VAT acc. no.	Account no.

Debit withh. tax

The cost account used for posting the compensation for VAT or for the debit posting of the source tax.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	DbWthAc	The database field name.
API identifier	debitWithholdingTaxAccountNo	The API identifier used in GraphQL.
Number	4817

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	DebitWithholdingTaxAccount	Debit withh. tax	Account no.

Description

Description for the VAT rate.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Name	Text (80)
SQL name	Descr	The database field name.
API identifier	description	The API identifier used in GraphQL.
Number	17973

EU-VAT account

The general ledger account used for posting the reversed VAT from purchases within EU and from non-EU foreign countries.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	CrEUAc	The database field name.
API identifier	euVatAccountNo	The API identifier used in GraphQL.
Number	4816

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	EuVatAccount	EU-VAT account	Account no.

From date

The date the New rate is effective from.

In connection with transition to a New rate, you can retain both rates in the table. The correct rate is selected by comparing the Value date on the Voucher and the Doc. date on the Order document with the date in this field.

When the old rate is no longer valid, the New rate can be moved over to the ordinary Rate field and this date deleted.

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	AfterDt	The database field name.
API identifier	fromDate	The API identifier used in GraphQL.
Number	619

Input VAT suspense A/C

The general ledger account used for posting input VAT.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	IncAcNo	The database field name.
API identifier	inputVatSuspenseAccountNo	The API identifier used in GraphQL.
Number	613

Table 7. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	InputVatSuspenseAccount	Input VAT suspense A/C	Account no.

New rate

The future VAT rate announced by the tax authorities.

The field shall only be used in addition to the From date field.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Percent	Decimal
SQL name	NewRt	The database field name.
API identifier	newRate	The API identifier used in GraphQL.
Number	620

OSS VAT account

To be used on VAT code used for MOSS (Mobile One Stop Shop) sales only.

The corresponding VAT code also needs to have the value 2 - OSS union service scheme in the Service type field.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	EsVatAc	The database field name.
API identifier	ossVatAccountNo	The API identifier used in GraphQL.
Number	17545

Table 8. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	OssVatAccount	OSS VAT account	Account no.

Output VAT suspense A/C

The general ledger account used for posting output VAT.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	OutwAcNo	The database field name.
API identifier	outputVatSuspenseAccountNo	The API identifier used in GraphQL.
Number	614

Table 9. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	OutputVatSuspenseAccount	Output VAT suspense A/C	Account no.

Rate

The VAT rate that will be used.

If the rules change, you can easily change the rate in this field or use the From date and New rate fields.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Percent	Decimal
SQL name	Rt	The database field name.
API identifier	rate	The API identifier used in GraphQL.
Number	612

Reverse charge VAT

The general ledger account used for posting reverse charge VAT if you follow the British accounting rules.

A similar process applies to reversing VAT as on purchases from other EU member states. Direct posting to accounts entered in this field is given turnover class 15. The turnover class reduces the input VAT. The turnover class is covered by code 3 (Purchase only) in the VAT control field in the General ledger account table.

You can use the macro function @ReverseChargeVAT () in tax statement forms to display the total reversed VAT for the VAT period in question.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	WdrAcNo	The database field name.
API identifier	reverseChargeVatAccountNo	The API identifier used in GraphQL.
Number	8585

Table 10. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	ReverseChargeVatAccount	Reverse charge VAT	Account no.

VAT no.

A unique number identifying the VAT rate.

Note:

If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	VAT code	Integer
Primary key	Yes	VAT no.
SQL name	VatNo	The database field name.
API identifier	vatNo	The API identifier used in GraphQL.
Number	611

Table 11. Table relations
To table	Purpose	From columns	To columns	Comments
VAT code	TaxCode	VAT no.	VAT no.

VAT processing

Settings defining the behaviour of the VAT rate.

If you do not enter anything in the VAT processing field, VAT is calculated in the usual way.

A look-up in this field gives you the following list of possible values:

1 - Compute on gross amount: VAT is calculated on the gross amount.
2 - Use VAT compensation: VAT is calculated for the accounts that you specified in the Debit withh. tax and Credit withh. tax fields. Input VAT is then posted to debit and credit in these accounts.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	VAT processing	Integer
SQL name	Gross	The database field name.
API identifier	vatProcessing	The API identifier used in GraphQL.
Number	6729

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by user

The name of the user that changed the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChUsr	The database field name.
API identifier	changedByUser	The API identifier used in GraphQL.
Number	A unique column number.

Changed date

The date when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChDt	The database field name.
API identifier	changedDate	The API identifier used in GraphQL.
Number	A unique column number.

Changed time

The time when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTm	The database field name.
API identifier	changedTime	The API identifier used in GraphQL.
Number	A unique column number.

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTs	The database field name.
API identifier	changedTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Created by user

The name of the user that created the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreUsr	The database field name.
API identifier	createdByUser	The API identifier used in GraphQL.
Number	A unique column number.

Created date

The date when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreDt	The database field name.
API identifier	createdDate	The API identifier used in GraphQL.
Number	A unique column number.

Created time

The time when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTm	The database field name.
API identifier	createdTime	The API identifier used in GraphQL.
Number	A unique column number.

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTs	The database field name.
API identifier	createdTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Edit status	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	LckSt	The database field name.
API identifier	editStatus	The API identifier used in GraphQL.
Number	A unique column number.

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

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.

Table 12. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.