Help for implementation of VAT for Germany

[benni23]

Hi,

I am writing to this list because I am searching for help with the implementation of valid VAT handling in Ofbiz according to German requirements.
I found that Ofbiz (I use the latest version in the trunk) can be configured to show prices including VAT but as far as I can tell there are open issues in the current implementation.

1. The ecommerce webapp shows different prices in the different screens (microcart, minicart, showcart and at the end of the ordering process). I also found a post that price calculation with included VAT does not work for configurable items (http://www.nabble.com/Creating-price-rules-for-a-country-with-VAT-value-td21954459.html#a22005169)
2. If the order contains products with different VAT rates, the amount of each rate needs to be shown separately and rounding should only be done on this group level and not on item basis
3. Discounts granted to the subtotal of the order miss to adjust VAT amount accordingly. Currently they are applied to the net subtotal (which would be OK, I guess, as long as the VAT would be recalculated based on the discounted net price) and nothing more is done. So the final amount of VAT does not comply to the actual net value of the order (but to the undiscounted net value instead)

So, the first point merely requires consistent use of the pricing methods of the shopping cart in the templates and should not require a change in the actual business logic.
For the second point I have currently no idea as I did not take a look into the related entities and/or invoice generation.
Regarding the third point, I think one might either recalculate the tax in the last step of the ordering process or include such a discount on the subtotal in the product price calculation. I don't know which is the better choice or if another option might even be better?

Long story short. I am willing to invest some time in implementing the required changes and contribute back to the community but I need some feedback on these issues. Maybe even someone is already working on such an implementation (I've seen quite some posts on this issue)? My employer is also willing to pay for some professional assistance in this subject.

I hope to receive some feedback from you and looking forward to leverage the capabilities of Ofbiz :)

Regards,
Benjamin

[Jacques Le Roux]

Please use rather user ML for such questions, see why here :
http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList:dev@...

Thanks

Jacques

From: "benni23" <[hidden email]>

>
> Hi,
>
> I am writing to this list because I am searching for help with the
> implementation of valid VAT handling in Ofbiz according to German
> requirements.
> I found that Ofbiz (I use the latest version in the trunk) can be configured
> to show prices including VAT but as far as I can tell there are open issues
> in the current implementation.
>
> 1. The ecommerce webapp shows different prices in the different screens
> (microcart, minicart, showcart and at the end of the ordering process). I
> also found a post that price calculation with included VAT does not work for
> configurable items
> (http://www.nabble.com/Creating-price-rules-for-a-country-with-VAT-value-td21954459.html#a22005169)
> 2. If the order contains products with different VAT rates, the amount of
> each rate needs to be shown separately and rounding should only be done on
> this group level and not on item basis
> 3. Discounts granted to the subtotal of the order miss to adjust VAT amount
> accordingly. Currently they are applied to the net subtotal (which would be
> OK, I guess, as long as the VAT would be recalculated based on the
> discounted net price) and nothing more is done. So the final amount of VAT
> does not comply to the actual net value of the order (but to the
> undiscounted net value instead)
>
> So, the first point merely requires consistent use of the pricing methods of
> the shopping cart in the templates and should not require a change in the
> actual business logic.
> For the second point I have currently no idea as I did not take a look into
> the related entities and/or invoice generation.
> Regarding the third point, I think one might either recalculate the tax in
> the last step of the ordering process or include such a discount on the
> subtotal in the product price calculation. I don't know which is the better
> choice or if another option might even be better?
>
> Long story short. I am willing to invest some time in implementing the
> required changes and contribute back to the community but I need some
> feedback on these issues. Maybe even someone is already working on such an
> implementation (I've seen quite some posts on this issue)? My employer is
> also willing to pay for some professional assistance in this subject.
>
> I hope to receive some feedback from you and looking forward to leverage the
> capabilities of Ofbiz :)
>
> Regards,
> Benjamin
>
> --
> View this message in context: http://www.nabble.com/Help-for-implementation-of-VAT-for-Germany-tp22604363p22604363.html
> Sent from the OFBiz - Dev mailing list archive at Nabble.com.
>

[benni23]

Hi Jacques,

since my goal was to talk directly to the Ofbiz developers and my question is about Ofbiz development, I thought that this would be the appropriate mailing list. However, I will repost my issue in the user ML then.

Regards,
Benni

jacques.le.roux wrote

Please use rather user ML for such questions, see why here :
http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList:[e-mail]

Thanks

Jacques

From: "benni23" <[e-mail]>
>
> Hi,
>
> I am writing to this list because I am searching for help with the
> implementation of valid VAT handling in Ofbiz according to German
> requirements.
> I found that Ofbiz (I use the latest version in the trunk) can be configured
> to show prices including VAT but as far as I can tell there are open issues
> in the current implementation.
>
> 1. The ecommerce webapp shows different prices in the different screens
> (microcart, minicart, showcart and at the end of the ordering process). I
> also found a post that price calculation with included VAT does not work for
> configurable items
> (http://www.nabble.com/Creating-price-rules-for-a-country-with-VAT-value-td21954459.html#a22005169)
> 2. If the order contains products with different VAT rates, the amount of
> each rate needs to be shown separately and rounding should only be done on
> this group level and not on item basis
> 3. Discounts granted to the subtotal of the order miss to adjust VAT amount
> accordingly. Currently they are applied to the net subtotal (which would be
> OK, I guess, as long as the VAT would be recalculated based on the
> discounted net price) and nothing more is done. So the final amount of VAT
> does not comply to the actual net value of the order (but to the
> undiscounted net value instead)
>
> So, the first point merely requires consistent use of the pricing methods of
> the shopping cart in the templates and should not require a change in the
> actual business logic.
> For the second point I have currently no idea as I did not take a look into
> the related entities and/or invoice generation.
> Regarding the third point, I think one might either recalculate the tax in
> the last step of the ordering process or include such a discount on the
> subtotal in the product price calculation. I don't know which is the better
> choice or if another option might even be better?
>
> Long story short. I am willing to invest some time in implementing the
> required changes and contribute back to the community but I need some
> feedback on these issues. Maybe even someone is already working on such an
> implementation (I've seen quite some posts on this issue)? My employer is
> also willing to pay for some professional assistance in this subject.
>
> I hope to receive some feedback from you and looking forward to leverage the
> capabilities of Ofbiz :)
>
> Regards,
> Benjamin
>
> --
> View this message in context: http://www.nabble.com/Help-for-implementation-of-VAT-for-Germany-tp22604363p22604363.html
> Sent from the OFBiz - Dev mailing list archive at Nabble.com.
>