Product Tax Category for organization

[Marco Longo]

Hi ,

We need to manage tax(vat) at organization level as the same product could be sold (or bought) by different organization with differente taxation rules.

Scenario

1) Consider 2 Organization of 2 country  (Italy + Germany )

2) Consider  2 Product   : Book  & Tablet

In Italy           Book are at  4% of tax-vat   and Tablet are at 22% of tax-vat

In Germany  Book are at 19% of Tax-vat  and  Tablet are at 7% of tax-vat

A Product could have only 1 TaxCategory  so  (for me) we are not able to achieve the goal

We are already customize tax/vat layer for localization  but this could

The idea is to add a sub tab in the product window (eg. M_Product_TaxCategory)

ORG1 Productcategory

ORG2 Productcaterory

This could work if enable as an extension if needed (and the orgininal taxcategory will be override

(as a Patch/Plugin or inside the core)

Any suggestion is welcome

Marco Longo

iDempiere Consulting

[Jesús Castillo]

Hi

 what about define tax with same category but different org?

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/5442fcc5-7ea5-4357-b262-77370c726854%40googlegroups.com.

[Carlos Antonio Ruiz Gomez]

Hi Marco, which is the tax configuration you're using?

I think the following could work:

Tax Category = Book

Tax Rate = 19% - Country = Germany - in the category Book
Tax Rate = 4% - Country = Italy - in the category Book

Regards,

Carlos Ruiz



El 29/04/20 a las 18:31, Marco Longo escribió:

[Marco Longo]

Hi Carlos,

That's was my first idea...Not enough unfortunately

Imagine that second product Pencil (near to book category but not equal) has 4% in italy but  4% also inGermany

So you need  all combination  TaxCategoryItaly * TaxCategoryGermany 

Tax Category :

Italy4/Gemany19

Italy4/Germany4

...

Italy22/Germay19

...

In our case we are testing with 3 org : USA + Italy + Romania

Test ongoing

Marco Longo

iDempiere Consuting

[Martin Schönbeck]

Hi Marco,

Am Donnerstag, 30. April 2020 19:02:43 UTC+2 schrieb Marco Longo:

Hi Carlos,

That's was my first idea...Not enough unfortunately

Imagine that second product Pencil (near to book category but not equal) has 4% in italy but  4% also inGermany

So you need  all combination  TaxCategoryItaly * TaxCategoryGermany 

Tax Category :

Italy4/Gemany19

Italy4/Germany4

...

Italy22/Germay19

...

In our case we are testing with 3 org : USA + Italy + Romania 

But what would be the alternative? With this solution you have to select the category which fits the product. With the possibility to assign several TaxCategory depending on the country you would have to add a bunch of category lines to each product, thus having the effort to combine them not once but on each product.

Regards,

Martin

[Marco Longo]

Hi Martin,

Out configuration for Italy is to have few TaxCategory   e.g 4% 10% 22% and few extra for no VAT / exempt VAT  for service

For Example  Book has TaxGroup4% 

but as Carlos wrote with differente rules

1) Tax (default)  from Italy to Italy is Real 4% (Sales/Purchase)

2) Tax  from Italy to UE   (Sales )

3) Tax from Italy to extraUE  (Sales)

4) Tax from UE to Italy  (Purchase  ) -> Reverse Charge

5) Tax to Public Government ( in italy we call Split Payment )

.... (more than 10 cases)

Same for 22% and 10 %

We customize also for Croatia as well in the same way  in another instance of idempiere

and as we are going to setup for Romania and it works for 1 org.

We would like to "merge" the logic  having a Tax category SUBTAB

ORG  -TAXCATEGORY

ORG - TAXCATAGORY

..

(Activate from SystemaConfig that overwrite the base TAXCATEGORY )

So we are able to add as many ORG for differente country

we have to change "only" how the system catch the correct tax category the second part to get the correct value and the correct account still remain the same

what do you think ?.. any suggestion is wellcome

Marco

[Martin Schönbeck]

Hi Marco,

Am Freitag, 1. Mai 2020 07:38:36 UTC+2 schrieb Marco Longo:

Out configuration for Italy is to have few TaxCategory   e.g 4% 10% 22% and few extra for no VAT / exempt VAT  for service

For Example  Book has TaxGroup4% 

but as Carlos wrote with differente rules

1) Tax (default)  from Italy to Italy is Real 4% (Sales/Purchase)

2) Tax  from Italy to UE   (Sales )

3) Tax from Italy to extraUE  (Sales)

4) Tax from UE to Italy  (Purchase  ) -> Reverse Charge

5) Tax to Public Government ( in italy we call Split Payment )

.... (more than 10 cases)

Same for 22% and 10 %

That's done with separate Tax Rate entries connected to the tax category, right?

We customize also for Croatia as well in the same way  in another instance of idempiere

and as we are going to setup for Romania and it works for 1 org.

We would like to "merge" the logic  having a Tax category SUBTAB

ORG  -TAXCATEGORY

ORG - TAXCATAGORY

..

(Activate from SystemaConfig that overwrite the base TAXCATEGORY )

So we are able to add as many ORG for differente country

I don't see the advantage. You would have to add such an entry to each product. Even though (I assume) books are in a given country always rated the same. So my solution would be, to create tax categories not by rate but by product type. Such as 'books'  or 'computer accessories'. Even if you find a country, where novels and technical books are rated different, you have to create a new category for novels (or technical books, whichever has less products) and change the category at this products. But even then it's less effort than to add a tax category entry to each product.

Regards,

Martin