Visma.net ERP

General ledger transactions with VAT (TX40500S)

This topic gives you information about the elements that you find in this window in Visma.net ERP, such as fields, field values, buttons, and check boxes.

This window shows a details summary per account of all general ledger transactions with VAT information for each account that has a link to a document containing VAT.

Note! If you have selected the Post summary when updating the general ledger check box on the General information tab in the Supplier ledger preferences (AP101000), the Customer ledger preferences (AR101000) or the Inventory preferences (IN101000)windows, the VAT information will be missing because the general ledger transactions are missing the link to the original document line containing the VAT information.

The top part

Element	Description
Company	The company to whose general ledger the transactions belong. This field is available only if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.
Branch	The branch to whose general ledger the transactions belong. You will only see branches for the selected company. This field is available only if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.
Ledger	Only ledgers with ledger type Actual are valid.
From period	The financial period from which the transactions are posted. This field is mandatory.
To period	The financial period to which the transactions are posted. This field is mandatory.
Subaccount	Filtering for the subaccount. It is not possible to filter on separate segments in this inquiry.
Workspace	The drop-down with the different workspaces.
Transaction type	The drop-down with all transactions types.
From VAT period	The filter for from VAT period and will limit to show only transactions that have been processed by VAT report. If from VAT period is used, you have to select to VAT period.
To VAT period	The filter for to VAT period and will limit to show only transactions that have been processed by VAT report. If to VAT period is used, you have to select from VAT period.
Include unposted transactions	If the check box is selected, unreleased transactions will be included in the result.
From account	The filter for from account. If from account is selected, you have to select to account.
To account	The filter for to account. If to account is selected, you have to select from account.
From date	The filter for from date that will filter on transaction date.
To date	The filter for to date that will filter on transaction date.

The table

This table lists the reporting lines with the amounts for the period.

Column	Description
Company	The company ID is only visible if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.
Branch	The branch ID is only visible if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.
Account	The general ledger account for the line.
Account name	The name of the account.
Account type	One of the following account types: Asset Liability Income Expense
Batch no.	The batch number for posting.
Calculated VAT rate (%)	The calculated tax rate based on taxable amount and VAT amount.
Credit amount	The posted amount of credit.
Currency	The currency ISO code for the transaction.
Customer/supplier	The name of the customer or the supplier from the Customer no./Supplier no. column
Customer no./Supplier no.	The customer or the supplier number. Only for the supplier ledger or the customer ledger account.
Debit amount	The posted amount of debit.
Deductible VAT rate	Shows the deductible VAT rate. Normally it is 100%, but if the rate is a partially deductible rate, this will show the rate that is the base for the taxable amount.
Expense amount	Shows the deductible VAT rate. Normally it is 100%, but if the rate is a partially deductible rate, this will show the rate that is the base for the Taxable amount.
Financial period ID	The financial period.
Internal record ID	The calculated ID used in the SAF-T report.
Ledger	The ledger for the posting
Line no.	The line number in the Batch.
Line type	Line types from Purchase orders: DN = Description GI = Goods for warehouse GM = Goods for manufacturing GP = Goods for drop-ship GR = Goods for replenishment GS = Goods for sales order MC = Misc. charges NM = Non-stock for manufacturing NO = Non-stock for sales order NP = Non-stock for drop-ship NS = Non-stock SV = Service Line types from Sales orders: DS = Discount FR = Freight GN = Non-stock MI = Misc. charge RA = Reallocation
Original taxable amount	This show the VAT amount for the whole document for this VAT ID.
Posted	This means that the status is Posted.
Period	The financial period.
Project	The project number.
Posted credit amount in currency	The posted amount credit in currency.
Posted debit amount in currency	The posted amount debit in currency.
Posted VAT amount	The posted VAT amount for the transactions.
Record ID	Same as Internal ID.
Voucher no.	The document number or the voucher number for the transaction.
Released	Checked if the transaction is released.
Revision ID	The Revision ID of the VAT report.
Subaccount	The subaccount for the transaction.
Subaccount description	The description for the Subaccount. You can maintain it in the Subaccounts (GL203000)window.
Sum post	The status if the post is a sum post, as the supplier or supplier accounts.
Taxable amount	The taxable amount in currency.
Total taxable amount	The total taxable amount for the document for this VAT ID.
Total VAT amount	The total VAT amount for the document for this VAT ID.
Transaction class	The transaction classes: B = Write-off C = Consolidation D = Discount S = Shipped not invoiced E = Retainage withheld F = Retainage released G = Unrealized and revaluation GOL N = Normal P = Payment R = Realised and rounding GOL T = VAT U = Charge W = Withholding VAT
Transaction date	The date of the transaction.
Transaction description	The transaction description from the batch line.
Transaction period	The transaction period.
Transaction type ID	This is the original transaction type or document type for the transaction type.
Transaction line no.	The line number from the original document.
Transaction type	The transaction/document type of the voucher.
VAT amount	The VAT amount for this transaction .
VAT amount in the currency	The VAT amount for this transaction in currency.
VAT bucket ID	The VAT bucket ID that is the number of the tax report group.
VAT category description	The description of the VAT category.
VAT category ID	The VAT category for the transaction.
VAT ID	The VAT ID for the transaction.
VAT period	The VAT reporting period.
VAT rate %	The VAT rate for the VAT ID.
Tax agency	The name for the tax agency
Tax agency ID	The tax agency supplier.
VAT transaction type	The transaction/document type for the VAT transaction.
VAT zone ID	The VAT zone of the transaction.
Workspace	The origin workspace of the transaction.