Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Avatar

Re: Seeking Advice on Handling Customs Duties in Odoo ERP for International Procurement in China

by
DANIEL CARRION
- 05/09/2025 17:42:52
Hello:

I understand that the goal is to automate the calculation of customs duties and properly manage multi-currency scenarios, which involves a dynamic daily update of the exchange rates between currencies. This update would generate automatic accounting adjustments for each transaction, which seems like a suitable solution. Furthermore, each customs-related transaction should be customized based on specific duty rules, which can vary by customs type (price or quantity).

This customization should also be dynamic, as duties can change over time, which means customs configurations must be flexible and adaptable. It is essential that this customs payment process be properly validated to ensure accuracy in the accounting records.

My question is whether it would be best to include customs duties within a single document or invoice, or if it would be preferable to do so separately to ensure better traceability and control of each customs transaction. Since in this case the import payment is made in dollars, I would suggest reflecting the import payment in a separate document, and a separate document for the customs duty payment, which is made in yuan. This would be my suggestion, as separating both payments into separate documents would facilitate traceability and control of each transaction, allowing for clear monitoring of the costs associated with the import and customs duties.

If I recall correctly. I haven't seen a dedicated module that provides this required functionality.

Regards

El jue, 4 sept 2025 a las 21:47, 张 飞虎 (<notifications@odoo-community.org>) escribió:

Dear OCA Community,

I hope this message finds you well. I am writing to seek your guidance and advice regarding the handling of customs duties in Odoo ERP for international procurement operations in China.

Here is a brief overview of our business scenario:

Customs Duties in China

We encounter two types of customs duties, both denominated in CNY (Chinese Yuan):

  1. Price-based duty: Calculated as unit price × exchange rate × duty rate (e.g., 10%).

  2. Quantity-based duty: Calculated as a fixed amount per unit, such as ¥800 per ton.

International Procurement

We import goods from other countries into China. The procurement currency is USD, but customs duties must be paid in CNY.

Sales Operations

For some sales orders, we quote prices in USD and collect both the(product value) and(customs duties and VAT) from customers separately.

Challenges We Face

  • Odoo’s tax calculation does not account for multi-currency scenarios, so we have not configured customs duties as taxes on products.

  • Since customs duties are collected in CNY while our procurement and sales are in USD, we are unable to reflect duties accurately on purchase or sales orders.

  • In procurement, we make payments to suppliers (in USD) and to customs (in CNY). Currently, we manually create bills for customs duties and calculate the amounts.

  • In sales, we need to collect both the product value and duties from customers in CNY, and we also manually calculate the duty amounts on invoices.

We would greatly appreciate any suggestions or insights from the community on how to effectively handle these challenges in Odoo. Specifically:

  1. Is there a recommended way to configure customs duties in Odoo to support multi-currency scenarios?

  2. How can we automate the calculation and recording of customs duties for both procurement and sales operations?

  3. Are there any existing modules or workflows within Odoo or the OCA ecosystem that could address these requirements?

Thank you in advance for your time and support. We look forward to your valuable feedback and ideas.

Best regards,



feihu.zhang

feihu.zhang@live.com

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