prices with taxes for B2C endusers

[Heidi Dehaes - Olagos]

Hello,

A point of interest:

If the ecommerce platform of Ofbiz is used for B2B it is , in Europe, the
case that prices are published without taxes. For that Ofbiz is perfect.

But

If the ecommerce platform of Ofbiz is used for B2C it is, in Europe, the
case that prices are published inclusive taxes (VAT). For that it becomes,
to my view, a little bit difficult in Ofbiz to calculate the price.
The price is always rounded in this way: the product price is not f.e.
30,00 € but always 29,90 € for example. Then in Ofbiz we should enter the
price without tax, so we have to calculate 29,90 / 1,21 (VAT is 21% f.e.).
That is 24.71074380165289256198347107438 € .
If i have to enter this in Ofbiz, i should round it to 24,71 € f.e. . The
outcome with tax (VAT) is then: 24,71 * 1,21 =  29.8991 € or probably on
the screen: 29,89 €.
Now in Europe there is no person who is comfortable to pay with 1 eurocent
coins. However they exist.

But all this to show that for B2C it should be better if Ofbiz had a system
where the price with tax is given in as 29,90 € f.e. and that the price
without tax is then calculated automatically for the products.

I hope this is clear.

Anyone experience with this psychological rounding of cents for B2C ?

Regards,
Heidi


--
Olagos bvba
http://www.olagos.eu <http://www.olagos.eu/>
http://www.olagos.com
http://www.olagos.be
http://www.olagos.nl
Olagos team
Heesterbos 5
2570 Duffel
Belgium

[Deepak Agarwal-2]

We are experiencing/struggling similar problem.

On Fri, Jun 8, 2012 at 7:55 PM, Info Olagos <[hidden email]> wrote:

> Hello,
>
> A point of interest:
>
> If the ecommerce platform of Ofbiz is used for B2B it is , in Europe, the
> case that prices are published without taxes. For that Ofbiz is perfect.
>
> But
>
> If the ecommerce platform of Ofbiz is used for B2C it is, in Europe, the
> case that prices are published inclusive taxes (VAT). For that it becomes,
> to my view, a little bit difficult in Ofbiz to calculate the price.
> The price is always rounded in this way: the product price is not f.e.
> 30,00 € but always 29,90 € for example. Then in Ofbiz we should enter the
> price without tax, so we have to calculate 29,90 / 1,21 (VAT is 21% f.e.).
> That is 24.71074380165289256198347107438 € .
> If i have to enter this in Ofbiz, i should round it to 24,71 € f.e. . The
> outcome with tax (VAT) is then: 24,71 * 1,21 =  29.8991 € or probably on
> the screen: 29,89 €.
> Now in Europe there is no person who is comfortable to pay with 1 eurocent
> coins. However they exist.
>
> But all this to show that for B2C it should be better if Ofbiz had a system
> where the price with tax is given in as 29,90 € f.e. and that the price
> without tax is then calculated automatically for the products.
>
> I hope this is clear.
>
> Anyone experience with this psychological rounding of cents for B2C ?
>
> Regards,
> Heidi
>
>
> --
> Olagos bvba
> http://www.olagos.eu <http://www.olagos.eu/>
> http://www.olagos.com
> http://www.olagos.be
> http://www.olagos.nl
> Olagos team
> Heesterbos 5
> 2570 Duffel
> Belgium
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: [hidden email]
> Mobile: [phone]
>
>

[Mike Z]

Just a guess, but have you tried to add "rounding=XX" to  @ofbizCurrency?

old: <@ofbizCurrency amount=price.specialPromoPrice
isoCode=price.currencyUsed />
new: <@ofbizCurrency amount=price.specialPromoPrice
isoCode=price.currencyUsed rounding=2 />

On Fri, Jun 8, 2012 at 8:16 AM, Deepak Agarwal <[hidden email]> wrote:

> We are experiencing/struggling similar problem.
>
> On Fri, Jun 8, 2012 at 7:55 PM, Info Olagos <[hidden email]> wrote:
>
> > Hello,
> >
> > A point of interest:
> >
> > If the ecommerce platform of Ofbiz is used for B2B it is , in Europe, the
> > case that prices are published without taxes. For that Ofbiz is perfect.
> >
> > But
> >
> > If the ecommerce platform of Ofbiz is used for B2C it is, in Europe, the
> > case that prices are published inclusive taxes (VAT). For that it
> becomes,
> > to my view, a little bit difficult in Ofbiz to calculate the price.
> > The price is always rounded in this way: the product price is not f.e.
> > 30,00 € but always 29,90 € for example. Then in Ofbiz we should enter the
> > price without tax, so we have to calculate 29,90 / 1,21 (VAT is 21%
> f.e.).
> > That is 24.71074380165289256198347107438 € .
> > If i have to enter this in Ofbiz, i should round it to 24,71 € f.e. . The
> > outcome with tax (VAT) is then: 24,71 * 1,21 =  29.8991 € or probably on
> > the screen: 29,89 €.
> > Now in Europe there is no person who is comfortable to pay with 1
> eurocent
> > coins. However they exist.
> >
> > But all this to show that for B2C it should be better if Ofbiz had a
> system
> > where the price with tax is given in as 29,90 € f.e. and that the price
> > without tax is then calculated automatically for the products.
> >
> > I hope this is clear.
> >
> > Anyone experience with this psychological rounding of cents for B2C ?
> >
> > Regards,
> > Heidi
> >
> >
> > --
> > Olagos bvba
> > http://www.olagos.eu <http://www.olagos.eu/>
> > http://www.olagos.com
> > http://www.olagos.be
> > http://www.olagos.nl
> > Olagos team
> > Heesterbos 5
> > 2570 Duffel
> > Belgium
> >
> > --
> > Thanks,
> > Deepak Agarwal,
> >
> > Paxcel Technologies Pvt Ltd.
> > Hartron Complex, Sector 18, Gurgaon, India.
> > E-Mail: [hidden email]
> > Mobile: [phone]
> >
> >
>

[Rajbir Saini]

Hello Heidi,

David Jones added the VAT support few years ago. There is a
ProductPrice#taxInPrice entity field and I think if you set this field
to Yes, you should be able to add prices with tax (VAT). There is also a
tax correction adjustment and I think this is created to adjust the
rounding variation when calculating the VAT.   I got this working with
some changes to product calcTax service as I needed to calculate the VAT
for each quantity to get the rounding right.

Thanks,

Raj

On Friday 08 June 2012 07:55 PM, Info Olagos wrote:

> Hello,
>
> A point of interest:
>
> If the ecommerce platform of Ofbiz is used for B2B it is , in Europe, the
> case that prices are published without taxes. For that Ofbiz is perfect.
>
> But
>
> If the ecommerce platform of Ofbiz is used for B2C it is, in Europe, the
> case that prices are published inclusive taxes (VAT). For that it becomes,
> to my view, a little bit difficult in Ofbiz to calculate the price.
> The price is always rounded in this way: the product price is not f.e.
> 30,00 € but always 29,90 € for example. Then in Ofbiz we should enter the
> price without tax, so we have to calculate 29,90 / 1,21 (VAT is 21% f.e.).
> That is 24.71074380165289256198347107438 € .
> If i have to enter this in Ofbiz, i should round it to 24,71 € f.e. . The
> outcome with tax (VAT) is then: 24,71 * 1,21 =  29.8991 € or probably on
> the screen: 29,89 €.
> Now in Europe there is no person who is comfortable to pay with 1 eurocent
> coins. However they exist.
>
> But all this to show that for B2C it should be better if Ofbiz had a system
> where the price with tax is given in as 29,90 € f.e. and that the price
> without tax is then calculated automatically for the products.
>
> I hope this is clear.
>
> Anyone experience with this psychological rounding of cents for B2C ?
>
> Regards,
> Heidi
>
>

[iwolf]

Hi,

has this issue been solved (with ofbiz standard) or does one have to make changes to the tax service? When I use "tax_in_price" = "Y" the price is displayed & calculated without tax. It would be great to show prices as presented by Heidi.

Thanks for any hint.
Ingo

[Jacques Le Roux-2-2]

This works in OFBiz OOTB since Feb. 2010.
You need to correctly set your tax authorities.
You might need to tweak the "tax correction adjustment" in some specific cases as Raj explained (only seen in Nabble :/ )

Jacques

Le 23/04/2014 10:40, iwolf a écrit :

> Hi,
>
> has this issue been solved (with ofbiz standard) or does one have to make
> changes to the tax service? When I use "tax_in_price" = "Y" the price is
> displayed & calculated without tax. It would be great to show prices as
> presented by Heidi.
>
> Thanks for any hint.
> Ingo
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/prices-with-taxes-for-B2C-endusers-tp4633365p4650613.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>