We are experiencing an issue in Odoo 18 where only one (foreign) VAT ID can be assigned per destination country. However, our company ships goods from multiple warehouse locations in different EU countries to the same destination country. Since different VAT IDs must be used depending on the country of origin, the current system logic is leading to incorrect tax calculations and reporting.

Specifically, we need a solution that allows us to use the correct VAT ID based on the country of origin (warehouse location) and properly reflect it in tax declarations, particularly in the ZM and UVA reports.

Is there a way in Odoo 18 to assign multiple VAT IDs based on the country of origin and use these for the corresponding tax calculations and reports?