European VAT TaxAuthority and show prices with VAT included

[Boris Hamanov]

Hi,

I would be grateful if somebody can share his EU VAT TaxAuthority or just
point me to an example of how this is done.
I found a thread with a lenghty discussion that talks about entering
product prices without VAT and showing products with VAT calculated.
http://markmail.org/message/gisfjrzqf3auxfgh#query:+page:1+mid:gc3tmnj4z6gj3yyi+state:results
I could not find a useful example of how is this configured in practise,
any help there, please?

Kind Regards,
Boris

[Jacques Le Roux]

Though it does not give you precise instructions you are looking for, did you read
https://cwiki.apache.org/confluence/display/OFBIZ/VAT ?

Jacques

From: "Boris Hamanov" <[hidden email]>

> Hi,
>
> I would be grateful if somebody can share his EU VAT TaxAuthority or just
> point me to an example of how this is done.
> I found a thread with a lenghty discussion that talks about entering
> product prices without VAT and showing products with VAT calculated.
> http://markmail.org/message/gisfjrzqf3auxfgh#query:+page:1+mid:gc3tmnj4z6gj3yyi+state:results
> I could not find a useful example of how is this configured in practise,
> any help there, please?
>
> Kind Regards,
> Boris
>

[Robert Gan]

In case you found it, please share it here. I did it the way, that I entered the price incl. vat, added the percentage (19%), and edited it, that Vat is included.

On my productdetail page, I check if the fields are not empty in database and added the percentage from database as a text just like...price xy "including 19% vat", where 19 is the database value.

I think you can also click there that price is not including vat...

kindly

Robert

[Boris Hamanov]

Thanks Jacques, Robert!

I did my VAT authority this way:

    <!-- EU VAT Authority -->
    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
includeTaxInPrice="Y"/>
    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
description="European VAT Tax"/>

    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
productStoreId="90000"
        productCategoryId="" titleTransferEnumId="" minItemPrice="0.00"
        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
taxPromotions="Y"
        fromDate="2001-01-01 00:00:00.001" thruDate=""
        description="European VAT Tax for Bulgaria" />

and in my product store I set showPricesWithVatTax="Y"
vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"

This works fine, except that I am hitting strange issues with the cart:

When past the 2) How shall we ship it? to 3) How shall you pay? page the
cart suddenly begins to calculate VAT and it does that on top of the
product VAT price already calculated. So, in practise it adds the VAT two
times! The final order review, the order confirmation and the order create
emails work fine, but cart and the related mini and micro carts are broken.

The cart keeps that behavior until I remove the products from it. When I
add them again they are fine. Until I go past this point in checkout again.

Any idea why is this happening? I am running apache-ofbiz-09.04.01


On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]> wrote:

> In case you found it, please share it here. I did it the way, that I
> entered
> the price incl. vat, added the percentage (19%), and edited it, that Vat is
> included.
>
> On my productdetail page, I check if the fields are not empty in database
> and added the percentage from database as a text just like...price xy
> "including 19% vat", where 19 is the database value.
>
> I think you can also click there that price is not including vat...
>
> kindly
>
> Robert
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Jacques Le Roux]

R09.04 has not the new way of handling VAT which was introduced in December 2010. I will consider using a more recent version if
possible

Jacques

From: "Boris Hamanov" <[hidden email]>

> Thanks Jacques, Robert!
>
> I did my VAT authority this way:
>
>    <!-- EU VAT Authority -->
>    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
> includeTaxInPrice="Y"/>
>    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
> description="European VAT Tax"/>
>
>    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
>        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
> productStoreId="90000"
>        productCategoryId="" titleTransferEnumId="" minItemPrice="0.00"
>        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
> taxPromotions="Y"
>        fromDate="2001-01-01 00:00:00.001" thruDate=""
>        description="European VAT Tax for Bulgaria" />
>
> and in my product store I set showPricesWithVatTax="Y"
> vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
>
> This works fine, except that I am hitting strange issues with the cart:
>
> When past the 2) How shall we ship it? to 3) How shall you pay? page the
> cart suddenly begins to calculate VAT and it does that on top of the
> product VAT price already calculated. So, in practise it adds the VAT two
> times! The final order review, the order confirmation and the order create
> emails work fine, but cart and the related mini and micro carts are broken.
>
> The cart keeps that behavior until I remove the products from it. When I
> add them again they are fine. Until I go past this point in checkout again.
>
> Any idea why is this happening? I am running apache-ofbiz-09.04.01
>
>
> On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]> wrote:
>
>> In case you found it, please share it here. I did it the way, that I
>> entered
>> the price incl. vat, added the percentage (19%), and edited it, that Vat is
>> included.
>>
>> On my productdetail page, I check if the fields are not empty in database
>> and added the percentage from database as a text just like...price xy
>> "including 19% vat", where 19 is the database value.
>>
>> I think you can also click there that price is not including vat...
>>
>> kindly
>>
>> Robert
>>
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>

[Boris Hamanov]

Well, upgrading to the new ofbiz 10.04.02 will happen in the future (if the
client chooses to pay for it) but for now I have to deal with 9.04.

I am hoping that the fix to that bug will not be a very complex one, will
see. I will post my progress here. Meanwhile if anybody has some
information on the topic, I will appreciate it.

On Wed, May 9, 2012 at 11:04 AM, Jacques Le Roux <
[hidden email]> wrote:

> R09.04 has not the new way of handling VAT which was introduced in
> December 2010. I will consider using a more recent version if possible
>
> Jacques
>
> From: "Boris Hamanov" <[hidden email]>
>
>> Thanks Jacques, Robert!
>>
>> I did my VAT authority this way:
>>
>>   <!-- EU VAT Authority -->
>>   <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
>> includeTaxInPrice="Y"/>
>>   <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
>> description="European VAT Tax"/>
>>
>>   <TaxAuthorityRateProduct taxAuthGeoId="BGR"
>>       taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
>> productStoreId="90000"
>>       productCategoryId="" titleTransferEnumId="" minItemPrice="0.00"
>>       minPurchase="0.00" taxShipping="Y" taxPercentage="20"
>> taxPromotions="Y"
>>       fromDate="2001-01-01 00:00:00.001" thruDate=""
>>       description="European VAT Tax for Bulgaria" />
>>
>> and in my product store I set showPricesWithVatTax="Y"
>> vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
>>
>> This works fine, except that I am hitting strange issues with the cart:
>>
>> When past the 2) How shall we ship it? to 3) How shall you pay? page the
>> cart suddenly begins to calculate VAT and it does that on top of the
>> product VAT price already calculated. So, in practise it adds the VAT two
>> times! The final order review, the order confirmation and the order create
>> emails work fine, but cart and the related mini and micro carts are
>> broken.
>>
>> The cart keeps that behavior until I remove the products from it. When I
>> add them again they are fine. Until I go past this point in checkout
>> again.
>>
>> Any idea why is this happening? I am running apache-ofbiz-09.04.01
>>
>>
>> On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]> wrote:
>>
>>  In case you found it, please share it here. I did it the way, that I
>>> entered
>>> the price incl. vat, added the percentage (19%), and edited it, that Vat
>>> is
>>> included.
>>>
>>> On my productdetail page, I check if the fields are not empty in database
>>> and added the percentage from database as a text just like...price xy
>>> "including 19% vat", where 19 is the database value.
>>>
>>> I think you can also click there that price is not including vat...
>>>
>>> kindly
>>>
>>> Robert
>>>
>>> --
>>> View this message in context:
>>> http://ofbiz.135035.n4.nabble.**com/European-VAT-TaxAuthority-**
>>> and-show-prices-with-VAT-**included-tp4615020p4616889.**html<http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html>
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>

[Pierre Smits]

Hi Boris,

I noticed that you have your TaxAuthority the same as your default Company.
Normally you would setup a different party to be the TaxAuthority. Did you
do it intentionally? Could that be generating the issues you have?

Regards,

Pierre

2012/5/8 Boris Hamanov <[hidden email]>

> Thanks Jacques, Robert!
>
> I did my VAT authority this way:
>
>    <!-- EU VAT Authority -->
>    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
> includeTaxInPrice="Y"/>
>    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
> description="European VAT Tax"/>
>
>    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
>        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
> productStoreId="90000"
>        productCategoryId="" titleTransferEnumId="" minItemPrice="0.00"
>        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
> taxPromotions="Y"
>        fromDate="2001-01-01 00:00:00.001" thruDate=""
>        description="European VAT Tax for Bulgaria" />
>
> and in my product store I set showPricesWithVatTax="Y"
> vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
>
> This works fine, except that I am hitting strange issues with the cart:
>
> When past the 2) How shall we ship it? to 3) How shall you pay? page the
> cart suddenly begins to calculate VAT and it does that on top of the
> product VAT price already calculated. So, in practise it adds the VAT two
> times! The final order review, the order confirmation and the order create
> emails work fine, but cart and the related mini and micro carts are broken.
>
> The cart keeps that behavior until I remove the products from it. When I
> add them again they are fine. Until I go past this point in checkout again.
>
> Any idea why is this happening? I am running apache-ofbiz-09.04.01
>
>
> On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]> wrote:
>
> > In case you found it, please share it here. I did it the way, that I
> > entered
> > the price incl. vat, added the percentage (19%), and edited it, that Vat
> is
> > included.
> >
> > On my productdetail page, I check if the fields are not empty in database
> > and added the percentage from database as a text just like...price xy
> > "including 19% vat", where 19 is the database value.
> >
> > I think you can also click there that price is not including vat...
> >
> > kindly
> >
> > Robert
> >
> > --
> > View this message in context:
> >
> http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
>

[Boris Hamanov]

Hi Perre,

Maybe I will define some other company later but I don't see how that can
relate to my problems. I will investigate further to see what is going on
in the code.


On Wed, May 9, 2012 at 12:15 PM, Pierre Smits <[hidden email]>wrote:

> Hi Boris,
>
> I noticed that you have your TaxAuthority the same as your default Company.
> Normally you would setup a different party to be the TaxAuthority. Did you
> do it intentionally? Could that be generating the issues you have?
>
> Regards,
>
> Pierre
>
> 2012/5/8 Boris Hamanov <[hidden email]>
>
> > Thanks Jacques, Robert!
> >
> > I did my VAT authority this way:
> >
> >    <!-- EU VAT Authority -->
> >    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
> > includeTaxInPrice="Y"/>
> >    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
> > description="European VAT Tax"/>
> >
> >    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
> >        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
> > productStoreId="90000"
> >        productCategoryId="" titleTransferEnumId="" minItemPrice="0.00"
> >        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
> > taxPromotions="Y"
> >        fromDate="2001-01-01 00:00:00.001" thruDate=""
> >        description="European VAT Tax for Bulgaria" />
> >
> > and in my product store I set showPricesWithVatTax="Y"
> > vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
> >
> > This works fine, except that I am hitting strange issues with the cart:
> >
> > When past the 2) How shall we ship it? to 3) How shall you pay? page the
> > cart suddenly begins to calculate VAT and it does that on top of the
> > product VAT price already calculated. So, in practise it adds the VAT two
> > times! The final order review, the order confirmation and the order
> create
> > emails work fine, but cart and the related mini and micro carts are
> broken.
> >
> > The cart keeps that behavior until I remove the products from it. When I
> > add them again they are fine. Until I go past this point in checkout
> again.
> >
> > Any idea why is this happening? I am running apache-ofbiz-09.04.01
> >
> >
> > On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]> wrote:
> >
> > > In case you found it, please share it here. I did it the way, that I
> > > entered
> > > the price incl. vat, added the percentage (19%), and edited it, that
> Vat
> > is
> > > included.
> > >
> > > On my productdetail page, I check if the fields are not empty in
> database
> > > and added the percentage from database as a text just like...price xy
> > > "including 19% vat", where 19 is the database value.
> > >
> > > I think you can also click there that price is not including vat...
> > >
> > > kindly
> > >
> > > Robert
> > >
> > > --
> > > View this message in context:
> > >
> >
> http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html
> > > Sent from the OFBiz - User mailing list archive at Nabble.com.
> > >
> >
>

[Nandani]

Hello All,

I have set tax included in price as true in Tax Authority and for each
product.Set Show prices with tax included as true in store.
I can display correct product price , subtotal and grand total (including
tax in price)  during checkout.But in final step order creation occurs then
again it adds tax to grand total which wrong due to which sales tax gets
included twice in shopping cart.

I think already there is thread in forum for this issue with last response
for  sales tax included twice in shopping cart , Feb 12, 2010
I want to know is this issue still exist?Do we have facility of placing an
order with tax already included in price.

Hope to get positive response soon.

Thanks
Nandani

On Wed, May 9, 2012 at 2:51 PM, Boris Hamanov <[hidden email]> wrote:

> Hi Perre,
>
> Maybe I will define some other company later but I don't see how that can
> relate to my problems. I will investigate further to see what is going on
> in the code.
>
>
> On Wed, May 9, 2012 at 12:15 PM, Pierre Smits <[hidden email]
> >wrote:
>
> > Hi Boris,
> >
> > I noticed that you have your TaxAuthority the same as your default
> Company.
> > Normally you would setup a different party to be the TaxAuthority. Did
> you
> > do it intentionally? Could that be generating the issues you have?
> >
> > Regards,
> >
> > Pierre
> >
> > 2012/5/8 Boris Hamanov <[hidden email]>
> >
> > > Thanks Jacques, Robert!
> > >
> > > I did my VAT authority this way:
> > >
> > >    <!-- EU VAT Authority -->
> > >    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
> > > includeTaxInPrice="Y"/>
> > >    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
> > > description="European VAT Tax"/>
> > >
> > >    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
> > >        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
> > > productStoreId="90000"
> > >        productCategoryId="" titleTransferEnumId="" minItemPrice="0.00"
> > >        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
> > > taxPromotions="Y"
> > >        fromDate="2001-01-01 00:00:00.001" thruDate=""
> > >        description="European VAT Tax for Bulgaria" />
> > >
> > > and in my product store I set showPricesWithVatTax="Y"
> > > vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
> > >
> > > This works fine, except that I am hitting strange issues with the cart:
> > >
> > > When past the 2) How shall we ship it? to 3) How shall you pay? page
> the
> > > cart suddenly begins to calculate VAT and it does that on top of the
> > > product VAT price already calculated. So, in practise it adds the VAT
> two
> > > times! The final order review, the order confirmation and the order
> > create
> > > emails work fine, but cart and the related mini and micro carts are
> > broken.
> > >
> > > The cart keeps that behavior until I remove the products from it. When
> I
> > > add them again they are fine. Until I go past this point in checkout
> > again.
> > >
> > > Any idea why is this happening? I am running apache-ofbiz-09.04.01
> > >
> > >
> > > On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]> wrote:
> > >
> > > > In case you found it, please share it here. I did it the way, that I
> > > > entered
> > > > the price incl. vat, added the percentage (19%), and edited it, that
> > Vat
> > > is
> > > > included.
> > > >
> > > > On my productdetail page, I check if the fields are not empty in
> > database
> > > > and added the percentage from database as a text just like...price xy
> > > > "including 19% vat", where 19 is the database value.
> > > >
> > > > I think you can also click there that price is not including vat...
> > > >
> > > > kindly
> > > >
> > > > Robert
> > > >
> > > > --
> > > > View this message in context:
> > > >
> > >
> >
> http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html
> > > > Sent from the OFBiz - User mailing list archive at Nabble.com.
> > > >
> > >
> >
>

[Jacques Le Roux]

Release.revision?

Jacques

From: "Nandani Aggarwal" <[hidden email]>

> Hello All,
>
> I have set tax included in price as true in Tax Authority and for each
> product.Set Show prices with tax included as true in store.
> I can display correct product price , subtotal and grand total (including
> tax in price)  during checkout.But in final step order creation occurs then
> again it adds tax to grand total which wrong due to which sales tax gets
> included twice in shopping cart.
>
> I think already there is thread in forum for this issue with last response
> for  sales tax included twice in shopping cart , Feb 12, 2010
> I want to know is this issue still exist?Do we have facility of placing an
> order with tax already included in price.
>
> Hope to get positive response soon.
>
> Thanks
> Nandani
>
> On Wed, May 9, 2012 at 2:51 PM, Boris Hamanov <[hidden email]> wrote:
>
>> Hi Perre,
>>
>> Maybe I will define some other company later but I don't see how that can
>> relate to my problems. I will investigate further to see what is going on
>> in the code.
>>
>>
>> On Wed, May 9, 2012 at 12:15 PM, Pierre Smits <[hidden email]
>> >wrote:
>>
>> > Hi Boris,
>> >
>> > I noticed that you have your TaxAuthority the same as your default
>> Company.
>> > Normally you would setup a different party to be the TaxAuthority. Did
>> you
>> > do it intentionally? Could that be generating the issues you have?
>> >
>> > Regards,
>> >
>> > Pierre
>> >
>> > 2012/5/8 Boris Hamanov <[hidden email]>
>> >
>> > > Thanks Jacques, Robert!
>> > >
>> > > I did my VAT authority this way:
>> > >
>> > >    <!-- EU VAT Authority -->
>> > >    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
>> > > includeTaxInPrice="Y"/>
>> > >    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
>> > > description="European VAT Tax"/>
>> > >
>> > >    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
>> > >        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
>> > > productStoreId="90000"
>> > >        productCategoryId="" titleTransferEnumId="" minItemPrice="0.00"
>> > >        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
>> > > taxPromotions="Y"
>> > >        fromDate="2001-01-01 00:00:00.001" thruDate=""
>> > >        description="European VAT Tax for Bulgaria" />
>> > >
>> > > and in my product store I set showPricesWithVatTax="Y"
>> > > vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
>> > >
>> > > This works fine, except that I am hitting strange issues with the cart:
>> > >
>> > > When past the 2) How shall we ship it? to 3) How shall you pay? page
>> the
>> > > cart suddenly begins to calculate VAT and it does that on top of the
>> > > product VAT price already calculated. So, in practise it adds the VAT
>> two
>> > > times! The final order review, the order confirmation and the order
>> > create
>> > > emails work fine, but cart and the related mini and micro carts are
>> > broken.
>> > >
>> > > The cart keeps that behavior until I remove the products from it. When
>> I
>> > > add them again they are fine. Until I go past this point in checkout
>> > again.
>> > >
>> > > Any idea why is this happening? I am running apache-ofbiz-09.04.01
>> > >
>> > >
>> > > On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]> wrote:
>> > >
>> > > > In case you found it, please share it here. I did it the way, that I
>> > > > entered
>> > > > the price incl. vat, added the percentage (19%), and edited it, that
>> > Vat
>> > > is
>> > > > included.
>> > > >
>> > > > On my productdetail page, I check if the fields are not empty in
>> > database
>> > > > and added the percentage from database as a text just like...price xy
>> > > > "including 19% vat", where 19 is the database value.
>> > > >
>> > > > I think you can also click there that price is not including vat...
>> > > >
>> > > > kindly
>> > > >
>> > > > Robert
>> > > >
>> > > > --
>> > > > View this message in context:
>> > > >
>> > >
>> >
>> http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html
>> > > > Sent from the OFBiz - User mailing list archive at Nabble.com.
>> > > >
>> > >
>> >
>>
>

[Nandani]

Thanks Jacques  , i got solution of my problem..

On Fri, May 11, 2012 at 12:17 AM, Jacques Le Roux <
[hidden email]> wrote:

> Release.revision?
>
> Jacques
>
> From: "Nandani Aggarwal" <[hidden email]>
>
>  Hello All,
>>
>> I have set tax included in price as true in Tax Authority and for each
>> product.Set Show prices with tax included as true in store.
>> I can display correct product price , subtotal and grand total (including
>> tax in price)  during checkout.But in final step order creation occurs
>> then
>> again it adds tax to grand total which wrong due to which sales tax gets
>> included twice in shopping cart.
>>
>> I think already there is thread in forum for this issue with last response
>> for  sales tax included twice in shopping cart , Feb 12, 2010
>> I want to know is this issue still exist?Do we have facility of placing an
>> order with tax already included in price.
>>
>> Hope to get positive response soon.
>>
>> Thanks
>> Nandani
>>
>> On Wed, May 9, 2012 at 2:51 PM, Boris Hamanov <[hidden email]> wrote:
>>
>>  Hi Perre,
>>>
>>> Maybe I will define some other company later but I don't see how that can
>>> relate to my problems. I will investigate further to see what is going on
>>> in the code.
>>>
>>>
>>> On Wed, May 9, 2012 at 12:15 PM, Pierre Smits <[hidden email]
>>> >wrote:
>>>
>>> > Hi Boris,
>>> >
>>> > I noticed that you have your TaxAuthority the same as your default
>>> Company.
>>> > Normally you would setup a different party to be the TaxAuthority. Did
>>> you
>>> > do it intentionally? Could that be generating the issues you have?
>>> >
>>> > Regards,
>>> >
>>> > Pierre
>>> >
>>> > 2012/5/8 Boris Hamanov <[hidden email]>
>>> >
>>> > > Thanks Jacques, Robert!
>>> > >
>>> > > I did my VAT authority this way:
>>> > >
>>> > >    <!-- EU VAT Authority -->
>>> > >    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
>>> > > includeTaxInPrice="Y"/>
>>> > >    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
>>> > > description="European VAT Tax"/>
>>> > >
>>> > >    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
>>> > >        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
>>> > > productStoreId="90000"
>>> > >        productCategoryId="" titleTransferEnumId=""
>>> minItemPrice="0.00"
>>> > >        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
>>> > > taxPromotions="Y"
>>> > >        fromDate="2001-01-01 00:00:00.001" thruDate=""
>>> > >        description="European VAT Tax for Bulgaria" />
>>> > >
>>> > > and in my product store I set showPricesWithVatTax="Y"
>>> > > vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
>>> > >
>>> > > This works fine, except that I am hitting strange issues with the
>>> cart:
>>> > >
>>> > > When past the 2) How shall we ship it? to 3) How shall you pay? page
>>> the
>>> > > cart suddenly begins to calculate VAT and it does that on top of the
>>> > > product VAT price already calculated. So, in practise it adds the VAT
>>> two
>>> > > times! The final order review, the order confirmation and the order
>>> > create
>>> > > emails work fine, but cart and the related mini and micro carts are
>>> > broken.
>>> > >
>>> > > The cart keeps that behavior until I remove the products from it.
>>> When
>>> I
>>> > > add them again they are fine. Until I go past this point in checkout
>>> > again.
>>> > >
>>> > > Any idea why is this happening? I am running apache-ofbiz-09.04.01
>>> > >
>>> > >
>>> > > On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]> wrote:
>>> > >
>>> > > > In case you found it, please share it here. I did it the way, that
>>> I
>>> > > > entered
>>> > > > the price incl. vat, added the percentage (19%), and edited it,
>>> that
>>> > Vat
>>> > > is
>>> > > > included.
>>> > > >
>>> > > > On my productdetail page, I check if the fields are not empty in
>>> > database
>>> > > > and added the percentage from database as a text just like...price
>>> xy
>>> > > > "including 19% vat", where 19 is the database value.
>>> > > >
>>> > > > I think you can also click there that price is not including vat...
>>> > > >
>>> > > > kindly
>>> > > >
>>> > > > Robert
>>> > > >
>>> > > > --
>>> > > > View this message in context:
>>> > > >
>>> > >
>>> >
>>> http://ofbiz.135035.n4.nabble.**com/European-VAT-TaxAuthority-**
>>> and-show-prices-with-VAT-**included-tp4615020p4616889.**html<http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html>
>>> > > > Sent from the OFBiz - User mailing list archive at Nabble.com.
>>> > > >
>>> > >
>>> >
>>>
>>>
>>

[Boris Hamanov]

I fixed my problem by modifying mini, micro and cart ftp to not use
GrandTotal method, but subtotal instead. However this is good for my
particular case only as I don't use any adjustments in my store. The
problem is that getDisplayGrandTotal also uses item getDipslayPirce (or
something along that lines) and that already contains the VAT. A better,
but more complex solution would be to exclude VAT from adjustment
calculations and hide it completely in cart if the user selected show
prices with VAT on the store. Unlike most sale taxes we don't want VAT
shown in the cart in most cases.

On Thu, May 10, 2012 at 10:02 PM, Nandani Aggarwal <
[hidden email]> wrote:

> Thanks Jacques  , i got solution of my problem..
>
> On Fri, May 11, 2012 at 12:17 AM, Jacques Le Roux <
> [hidden email]> wrote:
>
> > Release.revision?
> >
> > Jacques
> >
> > From: "Nandani Aggarwal" <[hidden email]>
> >
> >  Hello All,
> >>
> >> I have set tax included in price as true in Tax Authority and for each
> >> product.Set Show prices with tax included as true in store.
> >> I can display correct product price , subtotal and grand total
> (including
> >> tax in price)  during checkout.But in final step order creation occurs
> >> then
> >> again it adds tax to grand total which wrong due to which sales tax gets
> >> included twice in shopping cart.
> >>
> >> I think already there is thread in forum for this issue with last
> response
> >> for  sales tax included twice in shopping cart , Feb 12, 2010
> >> I want to know is this issue still exist?Do we have facility of placing
> an
> >> order with tax already included in price.
> >>
> >> Hope to get positive response soon.
> >>
> >> Thanks
> >> Nandani
> >>
> >> On Wed, May 9, 2012 at 2:51 PM, Boris Hamanov <[hidden email]> wrote:
> >>
> >>  Hi Perre,
> >>>
> >>> Maybe I will define some other company later but I don't see how that
> can
> >>> relate to my problems. I will investigate further to see what is going
> on
> >>> in the code.
> >>>
> >>>
> >>> On Wed, May 9, 2012 at 12:15 PM, Pierre Smits <[hidden email]
> >>> >wrote:
> >>>
> >>> > Hi Boris,
> >>> >
> >>> > I noticed that you have your TaxAuthority the same as your default
> >>> Company.
> >>> > Normally you would setup a different party to be the TaxAuthority.
> Did
> >>> you
> >>> > do it intentionally? Could that be generating the issues you have?
> >>> >
> >>> > Regards,
> >>> >
> >>> > Pierre
> >>> >
> >>> > 2012/5/8 Boris Hamanov <[hidden email]>
> >>> >
> >>> > > Thanks Jacques, Robert!
> >>> > >
> >>> > > I did my VAT authority this way:
> >>> > >
> >>> > >    <!-- EU VAT Authority -->
> >>> > >    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
> >>> > > includeTaxInPrice="Y"/>
> >>> > >    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
> >>> > > description="European VAT Tax"/>
> >>> > >
> >>> > >    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
> >>> > >        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
> >>> > > productStoreId="90000"
> >>> > >        productCategoryId="" titleTransferEnumId=""
> >>> minItemPrice="0.00"
> >>> > >        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
> >>> > > taxPromotions="Y"
> >>> > >        fromDate="2001-01-01 00:00:00.001" thruDate=""
> >>> > >        description="European VAT Tax for Bulgaria" />
> >>> > >
> >>> > > and in my product store I set showPricesWithVatTax="Y"
> >>> > > vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
> >>> > >
> >>> > > This works fine, except that I am hitting strange issues with the
> >>> cart:
> >>> > >
> >>> > > When past the 2) How shall we ship it? to 3) How shall you pay?
> page
> >>> the
> >>> > > cart suddenly begins to calculate VAT and it does that on top of
> the
> >>> > > product VAT price already calculated. So, in practise it adds the
> VAT
> >>> two
> >>> > > times! The final order review, the order confirmation and the order
> >>> > create
> >>> > > emails work fine, but cart and the related mini and micro carts are
> >>> > broken.
> >>> > >
> >>> > > The cart keeps that behavior until I remove the products from it.
> >>> When
> >>> I
> >>> > > add them again they are fine. Until I go past this point in
> checkout
> >>> > again.
> >>> > >
> >>> > > Any idea why is this happening? I am running apache-ofbiz-09.04.01
> >>> > >
> >>> > >
> >>> > > On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]>
> wrote:
> >>> > >
> >>> > > > In case you found it, please share it here. I did it the way,
> that
> >>> I
> >>> > > > entered
> >>> > > > the price incl. vat, added the percentage (19%), and edited it,
> >>> that
> >>> > Vat
> >>> > > is
> >>> > > > included.
> >>> > > >
> >>> > > > On my productdetail page, I check if the fields are not empty in
> >>> > database
> >>> > > > and added the percentage from database as a text just
> like...price
> >>> xy
> >>> > > > "including 19% vat", where 19 is the database value.
> >>> > > >
> >>> > > > I think you can also click there that price is not including
> vat...
> >>> > > >
> >>> > > > kindly
> >>> > > >
> >>> > > > Robert
> >>> > > >
> >>> > > > --
> >>> > > > View this message in context:
> >>> > > >
> >>> > >
> >>> >
> >>> http://ofbiz.135035.n4.nabble.**com/European-VAT-TaxAuthority-**
> >>> and-show-prices-with-VAT-**included-tp4615020p4616889.**html<
> http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html
> >
> >>> > > > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>> > > >
> >>> > >
> >>> >
> >>>
> >>>
> >>
>

[Jacques Le Roux]

We could have a parameters for that. But I think it's not a typical case.

Jacques

From: "Boris Hamanov" <[hidden email]>

>I fixed my problem by modifying mini, micro and cart ftp to not use
> GrandTotal method, but subtotal instead. However this is good for my
> particular case only as I don't use any adjustments in my store. The
> problem is that getDisplayGrandTotal also uses item getDipslayPirce (or
> something along that lines) and that already contains the VAT. A better,
> but more complex solution would be to exclude VAT from adjustment
> calculations and hide it completely in cart if the user selected show
> prices with VAT on the store. Unlike most sale taxes we don't want VAT
> shown in the cart in most cases.
>
> On Thu, May 10, 2012 at 10:02 PM, Nandani Aggarwal <
> [hidden email]> wrote:
>
>> Thanks Jacques  , i got solution of my problem..
>>
>> On Fri, May 11, 2012 at 12:17 AM, Jacques Le Roux <
>> [hidden email]> wrote:
>>
>> > Release.revision?
>> >
>> > Jacques
>> >
>> > From: "Nandani Aggarwal" <[hidden email]>
>> >
>> >  Hello All,
>> >>
>> >> I have set tax included in price as true in Tax Authority and for each
>> >> product.Set Show prices with tax included as true in store.
>> >> I can display correct product price , subtotal and grand total
>> (including
>> >> tax in price)  during checkout.But in final step order creation occurs
>> >> then
>> >> again it adds tax to grand total which wrong due to which sales tax gets
>> >> included twice in shopping cart.
>> >>
>> >> I think already there is thread in forum for this issue with last
>> response
>> >> for  sales tax included twice in shopping cart , Feb 12, 2010
>> >> I want to know is this issue still exist?Do we have facility of placing
>> an
>> >> order with tax already included in price.
>> >>
>> >> Hope to get positive response soon.
>> >>
>> >> Thanks
>> >> Nandani
>> >>
>> >> On Wed, May 9, 2012 at 2:51 PM, Boris Hamanov <[hidden email]> wrote:
>> >>
>> >>  Hi Perre,
>> >>>
>> >>> Maybe I will define some other company later but I don't see how that
>> can
>> >>> relate to my problems. I will investigate further to see what is going
>> on
>> >>> in the code.
>> >>>
>> >>>
>> >>> On Wed, May 9, 2012 at 12:15 PM, Pierre Smits <[hidden email]
>> >>> >wrote:
>> >>>
>> >>> > Hi Boris,
>> >>> >
>> >>> > I noticed that you have your TaxAuthority the same as your default
>> >>> Company.
>> >>> > Normally you would setup a different party to be the TaxAuthority.
>> Did
>> >>> you
>> >>> > do it intentionally? Could that be generating the issues you have?
>> >>> >
>> >>> > Regards,
>> >>> >
>> >>> > Pierre
>> >>> >
>> >>> > 2012/5/8 Boris Hamanov <[hidden email]>
>> >>> >
>> >>> > > Thanks Jacques, Robert!
>> >>> > >
>> >>> > > I did my VAT authority this way:
>> >>> > >
>> >>> > >    <!-- EU VAT Authority -->
>> >>> > >    <TaxAuthority taxAuthGeoId="BGR" taxAuthPartyId="Company"
>> >>> > > includeTaxInPrice="Y"/>
>> >>> > >    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT"
>> >>> > > description="European VAT Tax"/>
>> >>> > >
>> >>> > >    <TaxAuthorityRateProduct taxAuthGeoId="BGR"
>> >>> > >        taxAuthPartyId="Company" taxAuthorityRateTypeId="VAT"
>> >>> > > productStoreId="90000"
>> >>> > >        productCategoryId="" titleTransferEnumId=""
>> >>> minItemPrice="0.00"
>> >>> > >        minPurchase="0.00" taxShipping="Y" taxPercentage="20"
>> >>> > > taxPromotions="Y"
>> >>> > >        fromDate="2001-01-01 00:00:00.001" thruDate=""
>> >>> > >        description="European VAT Tax for Bulgaria" />
>> >>> > >
>> >>> > > and in my product store I set showPricesWithVatTax="Y"
>> >>> > > vatTaxAuthGeoId="BGR" vatTaxAuthPartyId="Company"
>> >>> > >
>> >>> > > This works fine, except that I am hitting strange issues with the
>> >>> cart:
>> >>> > >
>> >>> > > When past the 2) How shall we ship it? to 3) How shall you pay?
>> page
>> >>> the
>> >>> > > cart suddenly begins to calculate VAT and it does that on top of
>> the
>> >>> > > product VAT price already calculated. So, in practise it adds the
>> VAT
>> >>> two
>> >>> > > times! The final order review, the order confirmation and the order
>> >>> > create
>> >>> > > emails work fine, but cart and the related mini and micro carts are
>> >>> > broken.
>> >>> > >
>> >>> > > The cart keeps that behavior until I remove the products from it.
>> >>> When
>> >>> I
>> >>> > > add them again they are fine. Until I go past this point in
>> checkout
>> >>> > again.
>> >>> > >
>> >>> > > Any idea why is this happening? I am running apache-ofbiz-09.04.01
>> >>> > >
>> >>> > >
>> >>> > > On Tue, May 8, 2012 at 11:21 AM, Robert G. <[hidden email]>
>> wrote:
>> >>> > >
>> >>> > > > In case you found it, please share it here. I did it the way,
>> that
>> >>> I
>> >>> > > > entered
>> >>> > > > the price incl. vat, added the percentage (19%), and edited it,
>> >>> that
>> >>> > Vat
>> >>> > > is
>> >>> > > > included.
>> >>> > > >
>> >>> > > > On my productdetail page, I check if the fields are not empty in
>> >>> > database
>> >>> > > > and added the percentage from database as a text just
>> like...price
>> >>> xy
>> >>> > > > "including 19% vat", where 19 is the database value.
>> >>> > > >
>> >>> > > > I think you can also click there that price is not including
>> vat...
>> >>> > > >
>> >>> > > > kindly
>> >>> > > >
>> >>> > > > Robert
>> >>> > > >
>> >>> > > > --
>> >>> > > > View this message in context:
>> >>> > > >
>> >>> > >
>> >>> >
>> >>> http://ofbiz.135035.n4.nabble.**com/European-VAT-TaxAuthority-**
>> >>> and-show-prices-with-VAT-**included-tp4615020p4616889.**html<
>> http://ofbiz.135035.n4.nabble.com/European-VAT-TaxAuthority-and-show-prices-with-VAT-included-tp4615020p4616889.html
>> >
>> >>> > > > Sent from the OFBiz - User mailing list archive at Nabble.com.
>> >>> > > >
>> >>> > >
>> >>> >
>> >>>
>> >>>
>> >>
>>
>