atom feed35 messages in org.apache.ofbiz.userRe: VAT is not applied for the shipping
FromSent OnAttachments
biletnikovJan 24, 2011 10:55 am 
Jacques Le RouxJan 24, 2011 2:22 pm 
biletnikovJan 24, 2011 2:26 pm 
Jacques Le RouxJan 24, 2011 2:29 pm 
biletnikovJan 24, 2011 2:55 pm 
biletnikovJan 24, 2011 3:15 pm 
Jacques Le RouxJan 25, 2011 1:12 am 
biletnikovJan 25, 2011 12:11 pm 
biletnikovJan 28, 2011 3:48 am 
Jacques Le RouxJan 30, 2011 11:17 am 
Paul FoxworthyJan 31, 2011 11:50 pm 
Jacques Le RouxFeb 1, 2011 3:33 am 
biletnikovFeb 1, 2011 5:27 am 
Paul FoxworthyFeb 1, 2011 10:57 pm 
biletnikovFeb 1, 2011 11:49 pm 
Jacques Le RouxFeb 2, 2011 1:21 am 
Jacques Le RouxFeb 2, 2011 1:52 am 
biletnikovFeb 2, 2011 4:34 am 
Paul FoxworthyFeb 2, 2011 4:12 pm 
Paul FoxworthyFeb 2, 2011 4:29 pm 
Paul FoxworthyFeb 2, 2011 4:35 pm 
c.sc...@googlemail.comFeb 10, 2011 11:06 pm 
Jacques Le RouxFeb 11, 2011 1:38 am 
Paul FoxworthyFeb 11, 2011 6:48 pm 
Jacques Le RouxFeb 12, 2011 1:52 am 
Paul FoxworthyFeb 12, 2011 7:15 pm 
Jacques Le RouxFeb 13, 2011 1:12 am 
Jacques Le RouxFeb 15, 2011 2:39 am 
Ankit AroraFeb 15, 2011 8:03 pm 
BJ FreemanFeb 15, 2011 8:35 pm 
Ankit AroraFeb 15, 2011 8:42 pm 
BJ FreemanFeb 15, 2011 9:13 pm 
Jacques Le RouxFeb 16, 2011 12:26 am 
Ankit AroraFeb 16, 2011 2:28 am 
BJ FreemanFeb 16, 2011 2:54 am 
Subject:Re: VAT is not applied for the shipping
From:biletnikov (bile@gmail.com)
Date:Feb 2, 2011 4:34:36 am
List:org.apache.ofbiz.user

Yes, that is understandable.

However, the shipping tax is not working for the standard use cases (without any hack solutions) and it seems the situation is not going to be changed in the next release, is it?

On Wed, Feb 2, 2011 at 11:53 AM, Jacques Le Roux [via OFBiz] < ml-node+3253@n4.nabble.com<ml-n@n4.nabble.com>

wrote:

To be more clear, what have changed in trunk is the possibilit to have prices with VAT included and code was changed accordingly. So the ProductPrice and OrderAdjustment entities have changed but not The TaxAuthority data model, see http://svn.apache.org/viewvc?view=revision&revision=1042542

IIRW there have been some code amendements after

Jacques

From: "Jacques Le Roux" <[hidden
email]<http://user/SendEmail.jtp?type=node&node=3253694&i=0>>

It's the same in trunk

From: "biletnikov" <[hidden
email]<http://user/SendEmail.jtp?type=node&node=3253694&i=1>>

Hello Paul,

thank you very much for your detailed explanation and solutions. I think the first way is the more appropriate for us for the first time,

but I'm confused what we should do if we had in an order some items with

shippable tax and some with free shipping tax? Also the each our product

relates to the appropriate category.

Is this problem actual only for 9.04 release, or the current trunk has it too?

Best regards, Sergei

On Wed, Feb 2, 2011 at 8:57 AM, Paul Foxworthy [via OFBiz] < [hidden email] <http://user/SendEmail.jtp?type=node&node=3253694&i=2><[hidden

email] <http://user/SendEmail.jtp?type=node&node=3253694&i=3>>

wrote:

Hi Sergei,

The trouble is that in the rateProductTaxCalc method, getTaxAdjustments is called once per product, plus once for shipping and once for adjustments. In trunk these are lines 218, 244 and 228 in

https://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/accounting/src/org/ofbiz/accounting/tax/TaxAuthorityServices.java?hb=true

When we call getTaxAdjustments for shipping and promotion, there's no product, so the product category matching won't work. My change was to look for rows with taxShipping of Y when there's no product.

If your shipping is always calculated for an order and not by individual order items, you could set taxShipping to Y for one row in TaxAuthorityRateProduct (TARP) and N for the others. A bit of a hack, but it would work.

Another possibility is to define a new TAXABLE product category independent of any other, so you only need one row in TARP. The problem with this is you need to assign a product to the TAXABLE category as you create the product. For me in Australia, pretty well everything is taxed, so most products would need the category set.

A third way, again a hack, is to create a dummy product category that no product has, and add a row to TARP with taxShipping of Y. All other TARP rows would have taxShipping of N.

A better fix would need more consideration and more work.

Some possibilities I can think of:

- Add a new column to TARP, perhaps called something like taxRuleType or taxScope. It would have values PRODUCT, SHIPPING, PROMOTION. You would add separate rows for tax rules for shipping and promotion. Each of the three calls to getTaxAdjustment would supply a parameter to say which taxRuleType to search for.

- Define entirely separate entities for tax rules for shipping and promotions rather than overload TARP

Cheers

Paul Foxworthy

------------------------------ If you reply to this email, your message will be added to the discussion below:

http://ofbiz.135035.n4.nabble.com/VAT-is-not-applied-for-the-shipping-tp3234699p3253480.html<http://ofbiz.135035.n4.nabble.com/VAT-is-not-applied-for-the-shipping-tp3234699p3253480.html?by-user=t>

To unsubscribe from VAT is not applied for the shipping, click here<

http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3234699&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MzIzNDY5OXwyMDcwNzk3NDQ4<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3234699&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MzIzNDY5OXwyMDcwNzk3NDQ4&by-user=t>>.

------------------------------ If you reply to this email, your message will be added to the discussion below:

http://ofbiz.135035.n4.nabble.com/VAT-is-not-applied-for-the-shipping-tp3234699p3253694.html To unsubscribe from VAT is not applied for the shipping, click
here<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3234699&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MzIzNDY5OXwyMDcwNzk3NDQ4>.