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.
