Developer forum

Forum » Ecommerce - Standard features » Prices in the database Include VAT

Prices in the database Include VAT

Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Hi guys,

I have a solution running on DW 9.10.12. + Rapido (and some minor customizations)

I have set the "Prices in the database include VAT" option to True hoping that the tags will return the price as it is saved on the product.

On the product I have this price:

But the returned tag adds VAT to it:

Is this a bug? Or some setting I am missing?

Thank you,
Adrian


Replies

 
Nicolai Pedersen
Reply

You should never ever ever ever set prices in db include vat unles you want problems :-).

That said, this could be happening if you have set the prices on the website to show without vat. DW just removes system vat when retrieving the prices from the database and later add them again. Wether the price is shown with or with out vat is controlled by the website setting (or a user can also overwrite that setting).

If you want to add prices with vat you should do that on the price matric (EcomPrices table) - since 9.9 there is a flag to define that the product is including vat. You run that option along with the option "price in db include vat" turned off. (Yes confusing...)

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Hi Nicolai,

I usually avoid storing prices including VAT exactly because I don't want any headaches.

But in this case, I have only 2 products, no price integration, no complicated VAT calculation (products are sold only in Romania) and the Admins are getting the prices for these products with VAT. And I wanted to make their lives easier. I am aware of the option in PriceMatrix but it was too complicated for them to open a new dialog just to set one price.

But they can live with the usual setup where the prices are stored without VAT.

For consistency reasons, maybe the  "Prices in the database include VAT"  should be deprecated if it no longer has the same functionality as before.

Thank you,

Adrian

 
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Reply

Hi Adrian, In-country setup set country-level vat percentage as 0  in this case and try

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Hi Shiwanka,

I can try your suggestion but I have already advised the customer following Nicolai's suggestion.

If they want prices with VAT, they have to use the Price Matrix.

Thank you both for stepping in.

Adrian

 

You must be logged in to post in the forum