| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 210 |
| Technical Name |
account_field_to_force_exchange_rate |
| License | OPL-1 |
| Website | https://www.ganemo.co |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 210 |
| Technical Name |
account_field_to_force_exchange_rate |
| License | OPL-1 |
| Website | https://www.ganemo.co |
Force Exchange Rate
Precise Currency Control
Manually define the exact exchange rate for your Payments and Journal Entries. Override system defaults to ensure tax compliance and accurate valuation.
What We're Solving
----------------
Exact Rate Precision
Odoo defaults to a daily average rate. However, real-world banking and tax scenarios often require a specific "Spot Rate" or "Invoice Rate" (e.g., Detractions). This module gives you the power to type exactly the rate you need.
Logic Safeguard
Creating a manual journal entry often leaves the exchange rate purely to the system (or zero). We've added intelligence so that if you force a rate, it propagates down to every debit/credit line instantly. No more "0.00" confusion.
Setup & User Manual
Step-by-Step implementation
1. Configuration & Prerequisites
Before starting, ensure your environment is ready:
Prerequisites
- Multi-Currency: Enabled in Accounting Settings.
- Exchange Rates: At least one rate defined for your secondary currencies.
Access Rights
- Visibility: The "Force Exchange Rate" field is visible to users with "Billing" or "Accountant" rights.
- Security: Read-only for closed periods or locked entries.
2. Operating Manual (Use Cases)
Common scenarios where this module is essential:
Case A: Tax Detractions (Spot Rate)
In countries like Peru, tax payments (Detractions) must often use the rate of the Invoice Date, not the payment date.
Workflow: When registering payment for a Detraction, the wizard automatically pre-fills the rate from the Invoice Date. Confirm it, and the accounting moves will match the tax authority's requirement exactly.
Case B: Negotiated Rates
You agreed with a supplier to pay an invoice at a fixed rate of 4.00 (Price), regardless of the bank's daily rate.
Workflow: Enter "0.25" (1/4.00) in the force field. Odoo post the payment using this Native Rate, generating an "Exchange Difference" entry purely based on the difference between the forced rate and the invoice's original rate.
Global Ready | Multi-Language Support
This module is fully translated into English and Spanish (en_US, es_ES, es_PE, es_MX).
Why Choose Ganemo?
----------------
Ganemo is the world's leading Odoo App developer and a multi-award-winning Gold Partner. For over 5 years, we have been recognized as the #1 seller of high-quality apps on the Odoo App Store. Trusted as the "Best Partner" in USA, Mexico, Chile, Spain, Colombia, Ecuador, and Peru, we deliver robust, secure, and localization-compliant solutions for global businesses.
Get a Quote & Resolve Commercial Doubts
Join thousands of satisfied clients on Odoo. Contact our sales team directly.
Official WhatsApp
Fastest response time.
LINK
+1 (828) 672-6150
Book a Demo
Let's explore your needs.
LINK
Schedule Meeting
QA / User Testing Scenarios
Enterprise Validation Plan
Scenario 1: Invoice Payment (Wizard)
- Open a Vendor Bill or Invoice in USD (Company Currency: PEN).
- Click Register Payment.
- Verification: The field "Force Exchange Rate" should pre-fill with the Invoice's native rate (e.g., 0.263 for 3.80).
- Action: Change it to 0.25 (to force 4.00 Price) and validate.
- Result: Check the generated Journal Entry. The Debit/Credit amounts in PEN should reflect the 4.00 Price (Amount USD / 0.25).
Scenario 2: Manual Payment (Auto-Complete)
- Go to Payments -> Create New. Select USD.
- Verification: "Force Exchange Rate" should auto-fill with today's system rate (e.g., 0.26).
- Action: Change the Payment Date to last month.
- Result: The rate field should update automatically to last month's rate.
- Action: Manually type 0.2857 (to force 3.50) and save.
- Result: The system honors 0.2857, ignoring the date.
Scenario 3: Manual Journal Entry (Safeguard)
- Create a Journal Entry manually (Move Type: Entry).
- Select Currency: USD.
- Verification: The "Invoice Currency Rate" field should show the Market Rate (e.g. 0.26) instead of 0.00.
- Action: Add lines for 100 USD.
- Result: The lines convert to ~385 PEN automatically (100 / 0.26).
FAQ & Troubleshooting
Common Resolutions
Why is the rate empty (0.00)?
Reason: If the transaction is in the Company Currency, or if no rate could be found for the selected date.
Fix: Ensure "Multi-Currency" is active and you are selecting a foreign currency.
Does this affect Exchange Difference entries?
Answer: Yes, correctly.
Detail: If the Invoice was 3.80 and you force Payment at 4.00, Odoo will generate an FX Difference entry for the 0.20 gap. This is standard and desired behavior.
I cleared the field, what happens?
Answer: It reverts to Auto-mode.
Detail: If you delete the value (set to 0.00), the system will re-calculate the rate based on the Date selected, ensuring you never perform a transaction with "zero" value.
Is this compatible with Payment Batches?
Answer: Yes.
Detail: When paying multiple invoices, the wizard suggests a rate (usually from the first invoice). The forced rate you define applies to the entire batch payment.
Commercial & Sales
For inquiries about licenses, demos, or partnerships.
Official WhatsApp
Fastest response time.
LINK
+1 (828) 672-6150
Book a Demo
Let's explore your needs.
LINK
Technical Support
Existing customers regarding module functionality.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module