VAT problem
Locked
12
12
 
|
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 |
|
|
So if i configure two VAT lines in "Accounting" "Tax Authorities" and
then under "Belgium" which has tax authority party "_NA_ . Two VAT lines : - one for category 10003 - one for category 10004 These are not the categories from the product i buy via ecommerce. The product i buy is: 10001_0003 which is part of the category 10003B. I see now in the checkout : 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: 4.03€ (is then calculated on two times 21% on the 9.60€) Grand Total: 22.68€ It seems for me to be a bug. Or do i configure something wrong? And it is mentioned as Sales Taks, and not VAT tax. Eric 2013/3/1 info.olagos <[hidden email]> > 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 > > > -- 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 |
|
|
In reply to this post by Heidi Dehaes - Olagos
What happens , is that "taks shipping" is set for a certain category in
Taks Authorities, Rate Products. Even if the taks shipping is set on another category than the category which contains the product i want to buy via ecommerce, this taks shipping is calculated however. And this as many times there are lines in the taks authorities , rate products for that country. The taks shipping is not taking into account the category group of the product. Not normal i think???? Eric 2013/3/1 info.olagos <[hidden email]> > 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 > > > -- 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 |
|
|
anyone who can give me a hint?
ERic 2013/3/1 info.olagos <[hidden email]> > What happens , is that "taks shipping" is set for a certain category in > Taks Authorities, Rate Products. > Even if the taks shipping is set on another category than the category > which contains the product i want to buy via ecommerce, this taks shipping > is calculated however. > And this as many times there are lines in the taks authorities , rate > products for that country. > > The taks shipping is not taking into account the category group of the > product. > > Not normal i think???? > > Eric > > 2013/3/1 info.olagos <[hidden email]> > > 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 >> >> >> > > > > -- > 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 > > > -- 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 |
|
|
i don't find it in the JIRA issues.
ERic 2013/3/2 info.olagos <[hidden email]> > anyone who can give me a hint? > > ERic > > 2013/3/1 info.olagos <[hidden email]> > > What happens , is that "taks shipping" is set for a certain category in >> Taks Authorities, Rate Products. >> Even if the taks shipping is set on another category than the category >> which contains the product i want to buy via ecommerce, this taks shipping >> is calculated however. >> And this as many times there are lines in the taks authorities , rate >> products for that country. >> >> The taks shipping is not taking into account the category group of the >> product. >> >> Not normal i think???? >> >> Eric >> >> 2013/3/1 info.olagos <[hidden email]> >> >> 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 >>> >>> >>> >> >> >> >> -- >> 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 >> >> >> > > > > -- > 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 > > > -- 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 |
|
|
I couldn't read the whole question because of the time constraint but in my
experience the VAT calculation in TaxAuthorityServices works in such a way that the VAT becomes a sum of multiple categories it's member of. You may require some customization in this class file to meet your requirement. On Sat, Mar 2, 2013 at 8:33 PM, info.olagos <[hidden email]> wrote: > i don't find it in the JIRA issues. > > ERic > > 2013/3/2 info.olagos <[hidden email]> > > > anyone who can give me a hint? > > > > ERic > > > > 2013/3/1 info.olagos <[hidden email]> > > > > What happens , is that "taks shipping" is set for a certain category in > >> Taks Authorities, Rate Products. > >> Even if the taks shipping is set on another category than the category > >> which contains the product i want to buy via ecommerce, this taks > shipping > >> is calculated however. > >> And this as many times there are lines in the taks authorities , rate > >> products for that country. > >> > >> The taks shipping is not taking into account the category group of the > >> product. > >> > >> Not normal i think???? > >> > >> Eric > >> > >> 2013/3/1 info.olagos <[hidden email]> > >> > >> 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 > >>> > >>> > >>> > >> > >> > >> > >> -- > >> 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 > >> > >> > >> > > > > > > > > -- > > 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 > > > > > > > > > > -- > 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 > -- Thanks, Deepak Agarwal, Mobile: +91 9501190044 |
|
|
Yes thanks Deepak.
It is especially about the shipping amount on which VAT Tax is calculated. But it calculates not one time the VAT tax on the shipping amount but many times. (which are then all added) As many times as there are categories defined in the TaxAuthorityProductCategory screen . That is rather a big bug i think. Eric 2013/3/2 Deepak Agarwal <[hidden email]> > I couldn't read the whole question because of the time constraint but in my > experience the VAT calculation in TaxAuthorityServices works in such a way > that the VAT becomes a sum of multiple categories it's member of. You may > require some customization in this class file to meet your requirement. > > On Sat, Mar 2, 2013 at 8:33 PM, info.olagos <[hidden email]> wrote: > > > i don't find it in the JIRA issues. > > > > ERic > > > > 2013/3/2 info.olagos <[hidden email]> > > > > > anyone who can give me a hint? > > > > > > ERic > > > > > > 2013/3/1 info.olagos <[hidden email]> > > > > > > What happens , is that "taks shipping" is set for a certain category in > > >> Taks Authorities, Rate Products. > > >> Even if the taks shipping is set on another category than the category > > >> which contains the product i want to buy via ecommerce, this taks > > shipping > > >> is calculated however. > > >> And this as many times there are lines in the taks authorities , rate > > >> products for that country. > > >> > > >> The taks shipping is not taking into account the category group of the > > >> product. > > >> > > >> Not normal i think???? > > >> > > >> Eric > > >> > > >> 2013/3/1 info.olagos <[hidden email]> > > >> > > >> 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 > > >>> > > >>> > > >>> > > >> > > >> > > >> > > >> -- > > >> 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 > > >> > > >> > > >> > > > > > > > > > > > > -- > > > 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 > > > > > > > > > > > > > > > > > -- > > 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 > > > > > > -- > Thanks, > Deepak Agarwal, > > Mobile: +91 9501190044 > -- 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 |
Administrator
|
Hi Eric,
Can you reproduce in trunk (demo if you want)? Thanks Jacques info.olagos wrote: > Yes thanks Deepak. > > It is especially about the shipping amount on which VAT Tax is calculated. > But it calculates not one time the VAT tax on the shipping amount but many > times. (which are then all added) > > As many times as there are categories defined in the > TaxAuthorityProductCategory screen . > > That is rather a big bug i think. > > > Eric > > 2013/3/2 Deepak Agarwal <[hidden email]> > >> I couldn't read the whole question because of the time constraint but in my >> experience the VAT calculation in TaxAuthorityServices works in such a way >> that the VAT becomes a sum of multiple categories it's member of. You may >> require some customization in this class file to meet your requirement. >> >> On Sat, Mar 2, 2013 at 8:33 PM, info.olagos <[hidden email]> wrote: >> >>> i don't find it in the JIRA issues. >>> >>> ERic >>> >>> 2013/3/2 info.olagos <[hidden email]> >>> >>>> anyone who can give me a hint? >>>> >>>> ERic >>>> >>>> 2013/3/1 info.olagos <[hidden email]> >>>> >>>> What happens , is that "taks shipping" is set for a certain category in >>>>> Taks Authorities, Rate Products. >>>>> Even if the taks shipping is set on another category than the category >>>>> which contains the product i want to buy via ecommerce, this taks shipping >>>>> is calculated however. >>>>> And this as many times there are lines in the taks authorities , rate >>>>> products for that country. >>>>> >>>>> The taks shipping is not taking into account the category group of the >>>>> product. >>>>> >>>>> Not normal i think???? >>>>> >>>>> Eric >>>>> >>>>> 2013/3/1 info.olagos <[hidden email]> >>>>> >>>>> 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 >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> 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 >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> 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 >>>> >>>> >>>> >>> >>> >>> >>> -- >>> 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 >>> >> >> >> >> -- >> Thanks, >> Deepak Agarwal, >> >> Mobile: +91 9501190044 |
|
Administrator
|
In reply to this post by Heidi Dehaes - Olagos
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 |
|
Administrator
|
In reply to this post by Heidi Dehaes - Olagos
OK found it: http://svn.apache.org/viewvc?view=revision&revision=1070830
Of course I forgot it (no needs) so never wrote the enforcing js script For now you have to follow the explicit advice I put there <<Beware: don't use more than one line with "Tax Shipping" and/or "Tax Promotions" value = "Y">> Example https://demo-trunk.ofbiz.apache.org/accounting/control/EditTaxAuthorityRateProducts?taxAuthPartyId=_NA_&taxAuthGeoId=_NA_ Jacques info.olagos wrote: > Yes thanks Deepak. > > It is especially about the shipping amount on which VAT Tax is calculated. > But it calculates not one time the VAT tax on the shipping amount but many > times. (which are then all added) > > As many times as there are categories defined in the > TaxAuthorityProductCategory screen . > > That is rather a big bug i think. > > > Eric > > 2013/3/2 Deepak Agarwal <[hidden email]> > >> I couldn't read the whole question because of the time constraint but in my >> experience the VAT calculation in TaxAuthorityServices works in such a way >> that the VAT becomes a sum of multiple categories it's member of. You may >> require some customization in this class file to meet your requirement. >> >> On Sat, Mar 2, 2013 at 8:33 PM, info.olagos <[hidden email]> wrote: >> >>> i don't find it in the JIRA issues. >>> >>> ERic >>> >>> 2013/3/2 info.olagos <[hidden email]> >>> >>>> anyone who can give me a hint? >>>> >>>> ERic >>>> >>>> 2013/3/1 info.olagos <[hidden email]> >>>> >>>> What happens , is that "taks shipping" is set for a certain category in >>>>> Taks Authorities, Rate Products. >>>>> Even if the taks shipping is set on another category than the category >>>>> which contains the product i want to buy via ecommerce, this taks shipping >>>>> is calculated however. >>>>> And this as many times there are lines in the taks authorities , rate >>>>> products for that country. >>>>> >>>>> The taks shipping is not taking into account the category group of the >>>>> product. >>>>> >>>>> Not normal i think???? >>>>> >>>>> Eric >>>>> >>>>> 2013/3/1 info.olagos <[hidden email]> >>>>> >>>>> 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 >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> 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 >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> 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 >>>> >>>> >>>> >>> >>> >>> >>> -- >>> 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 >>> >> >> >> >> -- >> Thanks, >> Deepak Agarwal, >> >> Mobile: +91 9501190044 |
|
|
Hello Jacques,
Yes, thanks for your information. Just before reading your emails i found also the temporary solution mentionned in the JIRA. So i implemented what you also wrote about Taks Shipping and Taks Promotions = Y just for one line and then it works fine. So i had also a look to the proposed more complete solutions. I will try to think also on a solution but need deeper investigation in the problem then. Thanks for your information, Regards, Eric 2013/3/2 Jacques Le Roux <[hidden email]> > OK found it: http://svn.apache.org/viewvc?view=revision&revision=1070830 > Of course I forgot it (no needs) so never wrote the enforcing js script > > For now you have to follow the explicit advice I put there > <<Beware: don't use more than one line with "Tax Shipping" and/or "Tax > Promotions" value = "Y">> > Example > > https://demo-trunk.ofbiz.apache.org/accounting/control/EditTaxAuthorityRateProducts?taxAuthPartyId=_NA_&taxAuthGeoId=_NA_ > > Jacques > > info.olagos wrote: > > Yes thanks Deepak. > > > > It is especially about the shipping amount on which VAT Tax is > calculated. > > But it calculates not one time the VAT tax on the shipping amount but > many > > times. (which are then all added) > > > > As many times as there are categories defined in the > > TaxAuthorityProductCategory screen . > > > > That is rather a big bug i think. > > > > > > Eric > > > > 2013/3/2 Deepak Agarwal <[hidden email]> > > > >> I couldn't read the whole question because of the time constraint but > in my > >> experience the VAT calculation in TaxAuthorityServices works in such a > way > >> that the VAT becomes a sum of multiple categories it's member of. You > may > >> require some customization in this class file to meet your requirement. > >> > >> On Sat, Mar 2, 2013 at 8:33 PM, info.olagos <[hidden email]> > wrote: > >> > >>> i don't find it in the JIRA issues. > >>> > >>> ERic > >>> > >>> 2013/3/2 info.olagos <[hidden email]> > >>> > >>>> anyone who can give me a hint? > >>>> > >>>> ERic > >>>> > >>>> 2013/3/1 info.olagos <[hidden email]> > >>>> > >>>> What happens , is that "taks shipping" is set for a certain category > in > >>>>> Taks Authorities, Rate Products. > >>>>> Even if the taks shipping is set on another category than the > category > >>>>> which contains the product i want to buy via ecommerce, this taks > shipping > >>>>> is calculated however. > >>>>> And this as many times there are lines in the taks authorities , rate > >>>>> products for that country. > >>>>> > >>>>> The taks shipping is not taking into account the category group of > the > >>>>> product. > >>>>> > >>>>> Not normal i think???? > >>>>> > >>>>> Eric > >>>>> > >>>>> 2013/3/1 info.olagos <[hidden email]> > >>>>> > >>>>> 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 > >>>>>> > >>>>>> > >>>>>> > >>>>> > >>>>> > >>>>> > >>>>> -- > >>>>> 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 > >>>>> > >>>>> > >>>>> > >>>> > >>>> > >>>> > >>>> -- > >>>> 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 > >>>> > >>>> > >>>> > >>> > >>> > >>> > >>> -- > >>> 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 > >>> > >> > >> > >> > >> -- > >> Thanks, > >> Deepak Agarwal, > >> > >> Mobile: +91 9501190044 > -- 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 |
|
|
In reply to this post by Jacques Le Roux
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 <[hidden email]> > 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 |
|
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
--
Coherent Software Australia Pty Ltd http://www.coherentsoftware.com.au/ Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/ |
|
|
Hello Paul,
Just a first reaction. As said i use version ofbiz 11.04.1 but also in the former versions , there is the following problem related to VAT problem: If you make a product member of more than one category , for example two categories, it will calculate tax or VAT two times for the product in place of one time. Because the tax is calculated for each category from which it is member from. So that is also something which needs to be solved. By the way: what stands the abreviation "GST" for? Regards, Eric 2013/3/12 Paul Foxworthy <[hidden email]> > 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. > -- 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 |
|
|
Eric,
I saw that the browse root category and other category in hierarchy all should be of type CATALOG_CATEGORY. If you are using some of those categories for applying tax is not accurate. What you need to do is; Say you have 3 type of taxes to apply; 10%, 20% and 30% for a region they will be 5%, 15% and 25%. For this you need to create 6 categories which are not of type CATALOG_CATEGORY but should be type of TAX_CATEGORY. Prepare rules (that means create records in TaxAuthorityCategory and TaxAuthorityRateProduct) on them and associate products to them to see the tax calculation. It will be bit tricky but after doing this you do not need to do any customization for calculating the tax. I would say do not mess the CATALOG_CATEGORY and TAX_CATEOGRY with each other and njoy the ootb support. It will work for sure. -- Rishi Solanki Manager, Enterprise Software Development HotWax Media Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxmedia.com On Tue, Mar 12, 2013 at 3:24 PM, info.olagos <[hidden email]> wrote: > Hello Paul, > > Just a first reaction. > > As said i use version ofbiz 11.04.1 but also in the former versions , there > is the following problem related to VAT problem: > > If you make a product member of more than one category , for example two > categories, it will calculate tax or VAT two times for the product in place > of one time. > Because the tax is calculated for each category from which it is member > from. > > So that is also something which needs to be solved. > > > By the way: what stands the abreviation "GST" for? > > Regards, > Eric > > 2013/3/12 Paul Foxworthy <[hidden email]> > > > 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. > > > > > > -- > 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 > |
|
|
In reply to this post by Paul Foxworthy
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. |
|
|
In reply to this post by Heidi Dehaes - Olagos
Hi Eric,
No. If a product category is not mentioned in TaxAuthorityRateProduct, it isn't relevant to tax. So create separate categories for tax, and don't mention categories that are for searching, not for tax, in TaxAuthorityRateProduct. GST is Goods and Services Tax, a value added tax in Australia, New Zealand and Canada. Cheers Paul Foxworthy
--
Coherent Software Australia Pty Ltd http://www.coherentsoftware.com.au/ Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/ |
Re: VAT problem / sources of new e-shop
|
|
In reply to this post by Heidi Dehaes - Olagos
Hello Eric,
Am 03.03.2013 00:07, schrieb info.olagos: > 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. available? It would be a great help for a lot of people new to OFBiz eCommerce when learning how to create own shops. I have bought and read some (recommended) OFBiz books and even they are OK for better understanding of OFBiz they don't really help to create own shops. BigFish is a very nice solution but it is rather difficult to follow it's source code at the beginning. Some interesting statistics: # --- apache-*ofbiz*-*10.04.05*/specialpurpose/ecommerce$ find . | awk -F. '/\.[a-zA-Z][a-zA-Z]*$/ {print "*."$NF}' | sort -n | uniq -c 1 *.css 142 *.ftl 60 *.groovy 1 *.java 1 *.jpg 4 *.js 5 *.jsp 1 *.png 1 *.properties 62 *.xml # --- # --- apache-*ofbiz-11.04.02*/specialpurpose/ecommerce$ find . | awk -F. '/\.[a-zA-Z][a-zA-Z]*$/ {print "*."$NF}' | sort -n | uniq -c 1 *.css 146 *.ftl 61 *.groovy 1 *.java 1 *.jpg 4 *.js 6 *.jsp 1 *.png 1 *.properties 63 *.xml # --- # --- *BigFish-eCommerce-v1.10*$ find . | awk -F. '/\.[a-zA-Z][a-zA-Z]*$/ {print "*."$NF}' | sort -n | uniq -c 1 *.conf 9 *.css 9 *.db 594 *.ftl 173 *.gif 188 *.groovy 141 *.htm 1 *.html 2 *.ico 43 *.jar 70 *.java 2 *.jpeg 50 *.jpg 47 *.js 24 *.jsp 1 *.patch 184 *.png 2 *.properties 1 *.sql 26 *.template 20 *.txt 1 *.xjb 3 *.xls 130 *.xml 1 *.xsd 11 *.xsl # --- # --- *BigFish-eCommerce-v1.10-FashionDemo*$ find . | awk -F. '/\.[a-zA-Z][a-zA-Z]*$/ {print "*."$NF}' | sort -n | uniq -c 1 *.avi 1 *.bmp 10 *.css 18 *.db 197 *.gif 141 *.htm 2 *.jar 1 *.java 343 *.jpeg 4003 *.jpg 46 *.js 191 *.png 2 *.properties 4 *.scc 8 *.swf 26 *.template 1 *.txt 35 *.xml # --- Thank you in advance for any hints. regards, Mark -- [hidden email] http://rsync.it-infrastrukturen.org |
|
|
In reply to this post by Adrian Crum-3
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. |
|
|
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. > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |