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.
