OFBiz › OFBiz - User

VAT problem

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

23 messages Options

Adrian Crum-3

Re: VAT problem

It should be fairly easy to set up an automated test for that - using
the existing test framework.

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 2/20/2015 6:00 AM, [hidden email] wrote:

> Adrian, Jacques,
>
> In fact it is important here to mention that at the moment this way of setting the VAT taxes is one thing, but the second thing is to verify that all taxes are in the right manner set up and to do such a verification is very difficult in Ofbiz.
> There are no tools to help you decide that in your e-shop taxes are now ok for every country (for example in Europe).
>
> It should be very useful if there should be an overview page with all VAT taxes applied on all tax categories for all countries. Then you have one look and you know you have set it up right.
>
> Until now, it is more via experience that you know , oh my VAT tax for this category for that country was not set. So I have to inform the possible e-shop customer that the calculation was done wrong and I have to correct it and ask the customer to pay more .
>
> Regards,
> Eric
>
> -----Original Message-----
> From: Adrian Crum [mailto:[hidden email]]
> Sent: Wednesday, March 13, 2013 3:36 PM
> To: [hidden email]
> Subject: Re: VAT problem
>
> I agree with Paul. Having tax-specific categories is the most reliable
> way to get VAT calculated correctly.
>
> -Adrian
>
> On 3/12/2013 2:42 AM, Paul Foxworthy wrote:
>> Hi Eric,
>>
>> You are quite right that there is a problem with the handling of Shipping
>> and Promotion tax in TaxAuthorityRateProduct, and the fix as I gather you
>> have discovered is to set those things to Y only once. Those two flags have
>> nothing to do with the ProductCategory and should be in a separate table.
>>
>> You may not have noticed that you can have many different product categories
>> within different catalogs, and a product can belong to more than one. I
>> would suggest that the categories for tax should be independent of the
>> categories for user searching. If you do have a separate category, it
>> probably doesn't need hierarchical rollup stuff. It might be as simple as a
>> category "TAXABLE" or "EU_VAT_TAXABLE".
>>
>> For instance in Australia, there are two sorts of food: basic unprocessed
>> food, which is GST exempt, and processed food, which attracts GST like most
>> other goods. Don't ask me what the difference is, or whether a specific food
>> product is taxable or not. To my customer, I would present categories that
>> actually make sense. I would have separate categories for taxability that
>> the customer doesn't see.
>>
>> Cheers
>>
>> Paul Foxworthy
>>
>>
>> Info Olagos wrote
>>> Yes, the empty category is for the rollup function.
>>> So that i can view in the ecommerce page in the rollup all my categories
>>> under this empty category in the rollup.
>>>
>>> Because the top category in the rollup is apparently not visible. So when
>>> i
>>> use a top category for the rollup with products in it, it should never see
>>> them in the page .
>>>
>>> Or i have to put it as "promotions category" perhaps.
>>>
>>> By the way: all this explanations are not for the www.olagos.eu . I am
>>> creating a new e-shop which i will make available when finished.
>>>
>>> Regards,
>>> Eric
>>>
>>> 2013/3/2 Jacques Le Roux <
>>> jacques.le.roux@
>>> >
>>>
>>>> Why do you have an empty categ?
>>>>
>>>> Jacques
>>>>
>>>> info.olagos wrote:
>>>>> Hello,
>>>>>
>>>>> I use ofbiz11.0.4 and found a real VAT problem.
>>>>>
>>>>>
>>>>> I have many categories residing under the catalog10000 type "browse
>>>> root".
>>>>> The first category is an empty category 10001 which via "rollup
>>>>> configuration" contains all the other categories like Puzzels 10001B,
>>>>> 180001, 180002B, and many more.
>>>>> Category 10001 is a empty category. It contains no products.
>>>>> All the other categories underneath it in the "rollup
>>>>> configuration" contain many products.
>>>>>
>>>>>
>>>>>
>>>>> All categories take part into the only one catalog 10000.
>>>>>
>>>>>
>>>>>
>>>>> For the VAT taxes:
>>>>> When i insert under "Accounting" "Tax Authorities" and then under
>>>>> "Belgium" which has tax authority party "_NA_ . I added for "product
>>>> rate"
>>>>> a VAT line from 21% for the category 10003 only at the moment.
>>>>>
>>>>> I buy via ecommerce a product 10001_0003 for example which is a
>>>> category
>>>>> 10001B member. (not a category 10003 member).
>>>>>
>>>>> So for category 10001B there is no VAT configured.
>>>>>
>>>>> The checkout review shows this:
>>>>>
>>>>> 10001_0003 Qty=1 Unit Price = "9.05€" Price Adjustment = "€0.00"
>>>>> Subtotal="€9.05" . (this is the price without VAT)
>>>>>
>>>>> Subtotal: €9.05
>>>>>
>>>>> Shipping and handling : 9.60€
>>>>>
>>>>> Sales Taks: 2.02€ (is then calculated on the 9.60€)
>>>>>
>>>>> Grand Total: 20.67€
>>>>>
>>>>> What i see , is that per VAT line i add for other categories than the
>>>> one
>>>>> of the product i buy in the "Accounting" ,"Tax Authorities" , "product
>>>>> rate" tab, there is added 2.02 € sales tax per category i add .
>>>>> So if i add all my categories from the other products in the store, i
>>>> come
>>>>> at the end up with a Sales Taks = 150 € added for any sale of any
>>>> product.
>>>>> What do i wrong ???? Or is there a bug in the system??
>>>>>
>>>>> REgards,
>>>>> ERic
>>>
>>>
>>> --
>>> Olagos bvba
>>> http://www.olagos.eu
>>> http://www.olagos.com
>>> http://www.olagos.be
>>> http://www.olagos.nl
>>> Olagos team
>>> Kerkstraat 34
>>> 2570 Duffel
>>> Belgium
>>
>>
>>
>>
>> -----
>> --
>> Coherent Software Australia Pty Ltd
>> http://www.coherentsoftware.com.au/
>>
>> Bonsai ERP, the all-inclusive ERP system
>> http://www.bonsaierp.com.au/
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.com/VAT-problem-tp4639645p4639810.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Eric.LENS

RE: VAT problem

You mean a selenium test?
Eric

-----Original Message-----
From: Adrian Crum [mailto:[hidden email]]
Sent: Friday, February 20, 2015 4:14 PM
To: [hidden email]
Subject: Re: VAT problem

It should be fairly easy to set up an automated test for that - using
the existing test framework.

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 2/20/2015 6:00 AM, [hidden email] wrote:

Heidi Dehaes - Olagos

Re: VAT problem

In reply to this post by Pierre Smits

Hello Pierre,

Yes i will create a jira issue.
Eric

Olagos bvba
Heidi Dehaes
Kerkstraat 34
2570 Duffel
Belgium
Tel. : 015/31 53 04
GSM : 0485/22 35 80
E-mail : [hidden email]
http://www.olagos.eu
http://www.olagos.com
http://www.olagos.be
http://www.olagos.nl

2015-02-20 15:24 GMT+01:00 Pierre Smits <[hidden email]>:

> HI Eric,
>
> How do you envision that such a solution/tool (set of functionalities)
> should look like with respect to VAT setup verification?
>
> Feel free to create a JIRA issue if you believe such an improvement would
> be to the benefit of all.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Fri, Feb 20, 2015 at 3:00 PM, <[hidden email]> wrote:
>
> > Adrian, Jacques,
> >
> > In fact it is important here to mention that at the moment this way of
> > setting the VAT taxes is one thing, but the second thing is to verify
> that
> > all taxes are in the right manner set up and to do such a verification is
> > very difficult in Ofbiz.
> > There are no tools to help you decide that in your e-shop taxes are now
> > ok for every country (for example in Europe).
> >
> > It should be very useful if there should be an overview page with all
> VAT
> > taxes applied on all tax categories for all countries. Then you have one
> > look and you know you have set it up right.
> >
> > Until now, it is more via experience that you know , oh my VAT tax for
> > this category for that country was not set. So I have to inform the
> > possible e-shop customer that the calculation was done wrong and I have
> to
> > correct it and ask the customer to pay more .
> >
> > Regards,
> > Eric
> >
> > -----Original Message-----
> > From: Adrian Crum [mailto:[hidden email]]
> > Sent: Wednesday, March 13, 2013 3:36 PM
> > To: [hidden email]
> > Subject: Re: VAT problem
> >
> > I agree with Paul. Having tax-specific categories is the most reliable
> > way to get VAT calculated correctly.
> >
> > -Adrian
> >
> > On 3/12/2013 2:42 AM, Paul Foxworthy wrote:
> > > Hi Eric,
> > >
> > > You are quite right that there is a problem with the handling of
> Shipping
> > > and Promotion tax in TaxAuthorityRateProduct, and the fix as I gather
> you
> > > have discovered is to set those things to Y only once. Those two flags
> > have
> > > nothing to do with the ProductCategory and should be in a separate
> table.
> > >
> > > You may not have noticed that you can have many different product
> > categories
> > > within different catalogs, and a product can belong to more than one. I
> > > would suggest that the categories for tax should be independent of the
> > > categories for user searching. If you do have a separate category, it
> > > probably doesn't need hierarchical rollup stuff. It might be as simple
> > as a
> > > category "TAXABLE" or "EU_VAT_TAXABLE".
> > >
> > > For instance in Australia, there are two sorts of food: basic
> unprocessed
> > > food, which is GST exempt, and processed food, which attracts GST like
> > most
> > > other goods. Don't ask me what the difference is, or whether a specific
> > food
> > > product is taxable or not. To my customer, I would present categories
> > that
> > > actually make sense. I would have separate categories for taxability
> that
> > > the customer doesn't see.
> > >
> > > Cheers
> > >
> > > Paul Foxworthy
> > >
> > >
> > > Info Olagos wrote
> > >> Yes, the empty category is for the rollup function.
> > >> So that i can view in the ecommerce page in the rollup all my
> categories
> > >> under this empty category in the rollup.
> > >>
> > >> Because the top category in the rollup is apparently not visible. So
> > when
> > >> i
> > >> use a top category for the rollup with products in it, it should never
> > see
> > >> them in the page .
> > >>
> > >> Or i have to put it as "promotions category" perhaps.
> > >>
> > >> By the way: all this explanations are not for the www.olagos.eu . I
> am
> > >> creating a new e-shop which i will make available when finished.
> > >>
> > >> Regards,
> > >> Eric
> > >>
> > >> 2013/3/2 Jacques Le Roux <
> > >> jacques.le.roux@
> > >> >
> > >>
> > >>> Why do you have an empty categ?
> > >>>
> > >>> Jacques
> > >>>
> > >>> info.olagos wrote:
> > >>>> Hello,
> > >>>>
> > >>>> I use ofbiz11.0.4 and found a real VAT problem.
> > >>>>
> > >>>>
> > >>>> I have many categories residing under the catalog10000 type "browse
> > >>> root".
> > >>>> The first category is an empty category 10001 which via "rollup
> > >>>> configuration" contains all the other categories like Puzzels
> 10001B,
> > >>>> 180001, 180002B, and many more.
> > >>>> Category 10001 is a empty category. It contains no products.
> > >>>> All the other categories underneath it in the "rollup
> > >>>> configuration" contain many products.
> > >>>>
> > >>>>
> > >>>>
> > >>>> All categories take part into the only one catalog 10000.
> > >>>>
> > >>>>
> > >>>>
> > >>>> For the VAT taxes:
> > >>>> When i insert under "Accounting" "Tax Authorities" and then under
> > >>>> "Belgium" which has tax authority party "_NA_ . I added for "product
> > >>> rate"
> > >>>> a VAT line from 21% for the category 10003 only at the moment.
> > >>>>
> > >>>> I buy via ecommerce a product 10001_0003 for example which is a
> > >>> category
> > >>>> 10001B member. (not a category 10003 member).
> > >>>>
> > >>>> So for category 10001B there is no VAT configured.
> > >>>>
> > >>>> The checkout review shows this:
> > >>>>
> > >>>> 10001_0003 Qty=1 Unit Price = "9.05€" Price Adjustment =
> "€0.00"
> > >>>> Subtotal="€9.05" . (this is the price without VAT)
> > >>>>
> > >>>> Subtotal: €9.05
> > >>>>
> > >>>> Shipping and handling : 9.60€
> > >>>>
> > >>>> Sales Taks: 2.02€ (is then calculated on the 9.60€)
> > >>>>
> > >>>> Grand Total: 20.67€
> > >>>>
> > >>>> What i see , is that per VAT line i add for other categories than
> the
> > >>> one
> > >>>> of the product i buy in the "Accounting" ,"Tax Authorities" ,
> > "product
> > >>>> rate" tab, there is added 2.02 € sales tax per category i add .
> > >>>> So if i add all my categories from the other products in the store,
> i
> > >>> come
> > >>>> at the end up with a Sales Taks = 150 € added for any sale of any
> > >>> product.
> > >>>> What do i wrong ???? Or is there a bug in the system??
> > >>>>
> > >>>> REgards,
> > >>>> ERic
> > >>
> > >>
> > >> --
> > >> Olagos bvba
> > >> http://www.olagos.eu
> > >> http://www.olagos.com
> > >> http://www.olagos.be
> > >> http://www.olagos.nl
> > >> Olagos team
> > >> Kerkstraat 34
> > >> 2570 Duffel
> > >> Belgium
> > >
> > >
> > >
> > >
> > > -----
> > > --
> > > Coherent Software Australia Pty Ltd
> > > http://www.coherentsoftware.com.au/
> > >
> > > Bonsai ERP, the all-inclusive ERP system
> > > http://www.bonsaierp.com.au/
> > >
> > > --
> > > View this message in context:
> > http://ofbiz.135035.n4.nabble.com/VAT-problem-tp4639645p4639810.html
> > > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
> >
>