Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Seeking Advice on Handling Customs Duties in Odoo ERP for International Procurement in China

Archives

Contributors

Last chance to register to the OCA Days in-person training!

Sharepoint Integration

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

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

by feihu.zhang - 04:46 - 5 Sep 2025

Follow-Ups

  • Re: Seeking Advice on Handling Customs Duties in Odoo ERP for International Procurement in China
    If I'm not missing any details, this should be out of the box:
    • These duties can be configured as Taxes on the invoice.
    • Odoo does account for multicurrency. The USD invoice amount is converted to CNY. The duties would be computed in USD, but would then be converted to USD in your accounting records, and you will use those CNY amount to pay the taxes.
    • At best, you need a UX customization to also display the CNY converted amounts in your documents.

    --
    DANIEL REIS
    MANAGING PARTNER

    >> Schedule time on my calendar.
    M: +351 919 991 307
    E: dreis@OpenSourceIntegrators.com
    A: Avenida da República 3000, Estoril Office Center, 2649-517 Cascais

    [Logo OpenSourceIntegrators.com]


    On 9/5/2025 3:47 AM, 张 飞虎 wrote:

    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


    by Daniel Reis - 05:56 - 5 Sep 2025
  • Re: Seeking Advice on Handling Customs Duties in Odoo ERP for International Procurement in China
    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

    by DANIEL CARRION - 05:46 - 5 Sep 2025