--- title: How to distinguish between products with and without VAT in Visma Global description: BxLogistics does not handle VAT, but can choose to retrieve prices either with or without VAT and have separate fields on labels for prices with or without VAT --- [Skip to content](https://kb.bxsoftware.no/en/hjelp/hvordan-skille-på-varer-med-og-uten-mva-i-visma-global#main-content) - [English](https://kb.bxsoftware.no/en/hjelp/hvordan-skille-p%C3%A5-varer-med-og-uten-mva-i-visma-global) - [Norsk – Norge](https://kb.bxsoftware.no/hjelp/priser-med-uten-mva-fra-visma-global) English Show submenu for translations [![BxSoftware\_Logo\_Wordmark\_Color](https://kb.bxsoftware.no/hubfs/BxSoftware_Logo_Wordmark_Color.svg)](https://www.bxlogistics.no/) - [Henvendelser](https://kb.bxsoftware.no/tickets) - [Selvhjelp](https://kb.bxsoftware.no/hjelp) - [Logg ut](https://kb.bxsoftware.no/_hcms/mem/logout) Open main navigation Close main navigation - [Henvendelser](https://kb.bxsoftware.no/tickets) - [Selvhjelp](https://kb.bxsoftware.no/hjelp) - [Logg ut](https://kb.bxsoftware.no/_hcms/mem/logout) - - [English](https://kb.bxsoftware.no/en/hjelp/hvordan-skille-p%C3%A5-varer-med-og-uten-mva-i-visma-global) - [Norsk – Norge](https://kb.bxsoftware.no/hjelp/priser-med-uten-mva-fra-visma-global) English Show submenu for translations How can we help you? - There are no suggestions because the search field is empty. 1. [Selvhjelp](https://kb.bxsoftware.no/en/hjelp?hsLang=en) 2. [Technical Documentation](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en) 3. [Visma Global specific](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#visma-global-specific) # How to distinguish between products with and without VAT in Visma Global ## BxLogistics does not handle VAT, but can choose to retrieve prices either with or without VAT and have separate fields on labels for prices with or without VAT Most of our customers sell to businesses and only deal with net prices on the handheld terminal, labels, etc. For those who want prices including VAT, most choose the simplest solution: adding a SQL field based on the price and then multiplying it by 1.25. ``` select..A.Price1 as price,A.Price1 * 1.25 as priceincmva,.. ``` On the labels, you can then choose to print **priceincmva** instead of  **price**, while the value in **price** is displayed on the handheld terminals. If you want to display the price including VAT on the handheld terminal as well, you can choose to multiply this price too, but it is important not to let the handheld terminal control the price when sending data to the terminal (this is off by default) since Global expects to receive the price without VAT. If you have products without VAT (e.g., books) and want to display prices including VAT for all products, you cannot simply multiply everything by 1.25. Instead, you can differentiate the products based on the selected posting template. As a standard, Global has posting templates for several VAT rates, where template 2 is usually without VAT. Then, we can change the SQL to: ``` select..case a.PostingTemplateNowhen 2 then A.Price1elseA.Price1*1.25end AS priceincmva,.. ``` Note that the ID for the posting template may depend on the setup in Global. It is also possible to retrieve the actual VAT rate per posting template based on a given date, if necessary, but this solution is quick to set up and places less load on the SQL server. - [BxLogistics Installation](https://kb.bxsoftware.no/en/hjelp/bxlogistics-installation?hsLang=en#main-content) - [BxEngine and BxSmartPrintPro](https://kb.bxsoftware.no/en/hjelp/bxlogistics-installation?hsLang=en#bxengine-and-bxsmartprintpro) - [BxLogistics](https://kb.bxsoftware.no/en/hjelp/bxlogistics-installation?hsLang=en#bxlogistics) - [ERP Integrations and setup](https://kb.bxsoftware.no/en/hjelp/erp-integrations-and-setup?hsLang=en#main-content) - [Visma Business](https://kb.bxsoftware.no/en/hjelp/erp-integrations-and-setup?hsLang=en#visma-business) - [VBNxt](https://kb.bxsoftware.no/en/hjelp/erp-integrations-and-setup?hsLang=en#vbnxt) - [Visma Net](https://kb.bxsoftware.no/en/hjelp/erp-integrations-and-setup?hsLang=en#visma-net) - [Xledger](https://kb.bxsoftware.no/en/hjelp/erp-integrations-and-setup?hsLang=en#xledger) - [Transport integrations](https://kb.bxsoftware.no/en/hjelp/transport-integrations?hsLang=en#main-content) - [AxiaFrakt](https://kb.bxsoftware.no/en/hjelp/transport-integrations?hsLang=en#axiafrakt) - [Logistra Cargonizer](https://kb.bxsoftware.no/en/hjelp/transport-integrations?hsLang=en#logistra-cargonizer) - [ERP delivery methods](https://kb.bxsoftware.no/en/hjelp/transport-integrations?hsLang=en#erp-delivery-methods) - [nShift Shipment Server](https://kb.bxsoftware.no/en/hjelp/transport-integrations?hsLang=en#nshift-shipment-server) - [nShift/Unifaun Online](https://kb.bxsoftware.no/en/hjelp/transport-integrations?hsLang=en#nshift-unifaun-online) - [nShift/Consignor OnPrem](https://kb.bxsoftware.no/en/hjelp/transport-integrations?hsLang=en#nshift-consignor-onprem) - [User guides BxMobile](https://kb.bxsoftware.no/en/hjelp/user-guides-bxmobile?hsLang=en#main-content) - [General](https://kb.bxsoftware.no/en/hjelp/user-guides-bxmobile?hsLang=en#general) - [Stock transfer](https://kb.bxsoftware.no/en/hjelp/user-guides-bxmobile?hsLang=en#stock-transfer) - [Products](https://kb.bxsoftware.no/en/hjelp/user-guides-bxmobile?hsLang=en#products) - [Stock count](https://kb.bxsoftware.no/en/hjelp/user-guides-bxmobile?hsLang=en#stock-count) - [User Guides BxWebManager](https://kb.bxsoftware.no/en/hjelp/user-guides-bxwebmanager?hsLang=en#main-content) - [General](https://kb.bxsoftware.no/en/hjelp/user-guides-bxwebmanager?hsLang=en#general) - [Labels](https://kb.bxsoftware.no/en/hjelp/user-guides-bxwebmanager?hsLang=en#labels) - [Technical Documentation](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#main-content) - [BxAdmin - Client UI](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#bxadmin-client-ui) - [BxSmartPrintPro](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#bxsmartprintpro) - [Picking - Freight booking](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#picking-freight-booking) - [Infrastructure](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#infrastructure) - [Visma Global specific](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#visma-global-specific) - [Visma Business specific](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#visma-business-specific) - [VismaNet specific](https://kb.bxsoftware.no/en/hjelp/technical-documentation?hsLang=en#vismanet-specific) - [Stock count](https://kb.bxsoftware.no/en/hjelp/stock-count?hsLang=en#main-content) - [Visma Net](https://kb.bxsoftware.no/en/hjelp/stock-count?hsLang=en#visma-net) - [Logistics](https://kb.bxsoftware.no/en/hjelp/logistics?hsLang=en#main-content) - [Location](https://kb.bxsoftware.no/en/hjelp/logistics?hsLang=en#location) - [Troubleshooting](https://kb.bxsoftware.no/en/hjelp/troubleshooting?hsLang=en#main-content) - [Freight](https://kb.bxsoftware.no/en/hjelp/troubleshooting?hsLang=en#freight) - [Visma Net](https://kb.bxsoftware.no/en/hjelp/troubleshooting?hsLang=en#visma-net) - [BxMobile](https://kb.bxsoftware.no/en/hjelp/troubleshooting?hsLang=en#bxmobile) - [BxSmartPrintPro](https://kb.bxsoftware.no/en/hjelp/troubleshooting?hsLang=en#bxsmartprintpro) - [Visma Business](https://kb.bxsoftware.no/en/hjelp/troubleshooting?hsLang=en#visma-business) - [BxAdmin](https://kb.bxsoftware.no/en/hjelp/troubleshooting?hsLang=en#bxadmin) - [BxAPI](https://kb.bxsoftware.no/en/hjelp/bxapi?hsLang=en) - [Video archive](https://kb.bxsoftware.no/en/hjelp/video-archive?hsLang=en#main-content) - [Sales](https://kb.bxsoftware.no/en/hjelp/video-archive?hsLang=en#sales) - [Stock pick](https://kb.bxsoftware.no/en/hjelp/video-archive?hsLang=en#stock-pick) - [Stock count](https://kb.bxsoftware.no/en/hjelp/video-archive?hsLang=en#stock-count) - [General](https://kb.bxsoftware.no/en/hjelp/video-archive?hsLang=en#general) - [BxWebManager](https://kb.bxsoftware.no/en/hjelp/video-archive?hsLang=en#bxwebmanager) [![BxSoftware\_Logo\_Symbol\_Color](https://kb.bxsoftware.no/hubfs/BxSoftware_Logo_Symbol_Color.svg "BxSoftware_Logo_Symbol_Color")](https://www.bxlogistics.no/) Karihaugveien 89, Oslo, Norway [mailto:support@bxsoftware.no](mailto:support@bxsoftware.no) Copyright © 2025, BxSoftware AS