Tax calculation for promotion with multiple tax rates involved

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Tax calculation for promotion with multiple tax rates involved

iwolf
Hi everybody,

I have a question regarding the following case:

Setup:
product_1:
10 € incl. 20% sales tax
productCategory: mwst20

product_2:
10 € incl. 10% sales tax
productCategory: mwst10

TaxRateProduct:
taxAuth with two taxrateproducts:
10% sales tax assigned to mwst10
20% sales tax assigned to mwst20

Promotion: 10% off cart amount

Everything is calculated fine until it comes to promotions, as the orderadjustment "PROMOTION_ADJUSTMENT" is a summed up value with no context to tax. Therefore the tax adjustments end up misscalculated.

Has anybody had a similay case and solved it somehow?

Best regards,
Ingo


Reply | Threaded
Open this post in threaded view
|

Re: Tax calculation for promotion with multiple tax rates involved

Jacques Le Roux
Administrator
Hi Ingo,

Is this for the US or the EU market (ie Sales tax or VAT)?

When you created the "Tax Authority Product Rates" did you set "Tax Promotions" to "Y"?

Please have a look at https://demo-trunk.ofbiz.apache.org/accounting/control/EditTaxAuthorityRateProducts?taxAuthPartyId=DEU_BZSt&taxAuthGeoId=DEU

This is related to https://issues.apache.org/jira/browse/OFBIZ-4160. Not all is in R16, but you might backport it. If you want to do so please reopen
OFBIZ-4160 and share your work, thanks.

IIRW the situation is that in TaxAuthorityRateProduct you can have only one line with Tax Ship = Y or/and Tax Promo =Y  you might read
https://markmail.org/message/qyyw6rarmzdeqcbl but it's from 2011...

HTH

Jacques

Le 01/10/2019 à 15:58, Ingo Wolfmayr a écrit :

> Hi everybody,
>
> I have a question regarding the following case:
>
> Setup:
> product_1:
> 10 € incl. 20% sales tax
> productCategory: mwst20
>
> product_2:
> 10 € incl. 10% sales tax
> productCategory: mwst10
>
> TaxRateProduct:
> taxAuth with two taxrateproducts:
> 10% sales tax assigned to mwst10
> 20% sales tax assigned to mwst20
>
> Promotion: 10% off cart amount
>
> Everything is calculated fine until it comes to promotions, as the orderadjustment "PROMOTION_ADJUSTMENT" is a summed up value with no context to tax. Therefore the tax adjustments end up misscalculated.
>
> Has anybody had a similay case and solved it somehow?
>
> Best regards,
> Ingo
>
>