ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pierre Smits <pierre.sm...@gmail.com>
Subject Re: VAT problem
Date Fri, 20 Feb 2015 14:24:53 GMT
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, <Eric.LENS@ec.europa.eu> 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:adrian.crum@sandglass-software.com]
> Sent: Wednesday, March 13, 2013 3:36 PM
> To: user@ofbiz.apache.org
> 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 &lt;
> >> jacques.le.roux@
> >> &gt;
> >>
> >>> 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.
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message