Skip to Content
  2. Mailing Lists
  3. Contributors
  4. RE: Tax and account mapping depending of the product/category

Archives

Contributors

Re: Tax and account mapping depending of the product/category

RE: Tax and account mapping depending of the product/category

Hi,

 

Can this not been tackled with fiscal position ? In Belgium we have 4 TVA regimes when building product are installed : 21 % ( normal ), TVA compensated ( for companies ), 6 % ( private customers with houses older than 10 years ) and 12 % ( social housing ). So we create 4 fiscal positions and choose the right one on sales order. You could use a same approach. I guess the TVA rates are at least for groups of products. Because when you have 200.000 products ( and that’s not that much ) it become unmaintainable when you have to apply a different TVA to every product…

 

With kind regards,

 

Van Hirtum Johan

 

Van: Sebastien Beau [mailto:notifications@odoo-community.org]
Verzonden: maandag 11 juli 2022 23:02
Aan: Contributors
Onderwerp: Re: Tax and account mapping depending of the product/category

 

Hi Thorsten

 

We already think about it, but the issue is that we do not have only one case, so at the end I fear that we end with something like

20% (standard rate france / special foreign tax 16% / other location foreign tax 18%)

With a big list of taxe that match all the possible combinations

 

Thanks for your feedback

 

 

Le lun. 11 juil. 2022 à 11:02, Thorsten Vocks <notifications@odoo-community.org> a écrit :

Hi,

 

as ugly workaround: 

 

Wouldn't it be possible to duplicate the standard tax as you mentioned "20% (standard rate france)" 

to "20% (standard rate france / special foreign tax 16%)" and ...

 

a.) assign this duplicated standard tax to the product (product "B" in your example)

b.) add this tax in the fiscal position on the tax mapping tab (20% -> 16% ) after the regular tax mapping of the fiscal position (20% -> 13%).

 

 

Best regards

 

Thorsten Vocks

openBIG.org
Dipl. Kaufmann (FH)
Porscheweg 4-6
49661 Cloppenburg

Phone: +49 4471 8409000
Fax: +49 4471 84090009
Mail: thorsten.vocks@openbig.org

 

              

 

 

Am Mo., 11. Juli 2022 um 10:42 Uhr schrieb Sebastien Beau <notifications@odoo-community.org>:

Thanks Pedro for your feedback, but it's not the same issue.

 

This great module helps to easily configure the tax mapping (it generates all the fiscal position and tax mapping and save us a lot of time).

 

Here the case is more complexe sometime depending on the product you can not map a normal tax to a normal tax but sometime for legal reasons the tax in the dest country is a Reduce one or a Super Reduced Tax.

 

We need to handle this case

 

 

 

Le lun. 11 juil. 2022 à 09:56, Pedro M. Baeza (Tecnativa) <notifications@odoo-community.org> a écrit :

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

by johan - 02:20 - 12 Jul 2022

Reference

  • Tax and account mapping depending of the product/category

    Hi all I have created a discussion on github here (maybe easier to discuss and to keep an history)

    https://github.com/OCA/account-fiscal-rule/discussions/298


    I copy/paste the description of the discussion


    Issue

    When selling in Europe (or only in France but with some special dom-tom case), you need to apply local tax when reaching a certain amount. And sometime you need to map the tax (and also the account) depending of the product.

    For example you sell products A and B with the tax 20% in France
    But you need to sell it with a tax 13% for product A and 16% for product B in some fiscal position.

    Right now it's impossible to do it



    Solution

    I would like to introduce a new module account_fiscal_product_rule

    That will have the following data models

    
class AccountFiscalPositionProductRule():

    name = fields.Char()
    fiscal_position_id = fields.Many2one("account.fiscal.position")
    product_tmpl_ids = fields.Many2many("product.template")
    category_ids = fields.Many2many("product.category")
    account_income_id = fields.Many2one("account.account")
    account_expense_id = fields.Many2one("account.account")
    seller_tax_ids = fields.Many2Many("account.tax")
    supplier_tax_ids = fields.Many2Many("account.tax")


class ProductCategory():

    fiscal_position_product_rule_ids = fields.Many2many("account.fiscal.position.product.rule")


class ProductTemplate():

    fiscal_position_product_rule_ids = fields.Many2many("account.fiscal.position.product.rule")

    Then we can inherit the mapping logic (tax and account) to apply first this "specific rule" and if not rule match apply native rules

    Describe alternatives you've considered

    I had thinking about adding product_ids and category_ids on "account.fiscal.position.account" and "account.fiscal.position.tax". But the UI not really good for end user (too much configuration), and code will be not so easy to inherit.



    Thanks for your feedback (please put it in github)

    by Sébastien Beau - 09:45 - 11 Jul 2022