Advanced Bank Currency Rates
| Lines of Code | 769 |
| Technical name | to_bank_currency_rate |
| License | OPL-1 |
| Website | https://viindoo.com/apps/modules/17.0/to_bank_currency_rate |
| Read description for | v 12.0 v 13.0 v 14.0 v 15.0 v 16.0 v 18.0 v 19.0 |
| Required Apps | Invoicing (account) Discuss (mail) |
| Included Dependencies | Viindoo Base |
| Extensions | Foreign Trade & Logistics Currency Rate Bank Currency Rates - Purchase Stock Bank Currency Rates Update Bank Exchange Rate Application for Loans |
Buy, sell and transfer rates, per bank
Exchange rates that know which bank published them and whether it is a buy, transfer or sell rate - and a conversion engine that picks the right one for each document.
Advanced Bank Currency Rates (technical name to_bank_currency_rate) is an Odoo 17.0 app for Odoo Community and Odoo Enterprise and Viindoo Cloud, built for treasurer, accountant, auditor, developer.
At a Glance
The facts of Advanced Bank Currency Rates, version 0.2, in one place. Published by Viindoo.
How It Works
Set the main bank, enter rates by bank and type, and post as usual.
The rates
Three US banks, three rate types, two dates - one table.
The bank
Auto rate update switch and provider selector for modules that fetch rates.
The main bank
The bank used when a document does not name its own.
What You Get
Bank and Exchange Type on every currency rate; unique per currency, day, bank and type
Main Bank per company in Accounting settings
Invoices, payments, statement lines and the payment register convert at the bank rate of their direction
Fallback chain: document bank and type, then main bank, then the plain rate
Auto rate update switch per bank, with a provider hook for other modules
Extensible: modules declare which of their models use bank rates
More Screens
Everything below was taken on a database seeded with real business data, on this series - not a mock-up and not a screenshot from an older version.
A bank
What This App Does Not Do
Read this before you buy. Everything below is something the app deliberately leaves to another app or to you.
The provider selector is a hook; a bank-specific connector fills it.
Others keep the plain Odoo rate until a bridge adds them - purchase stock and loans have bridges.
Rates without a bank behave exactly as before.
Period-end revaluation uses the standard rate.
Works Well With
Apps from the same stack, built to fit this one:
Bank rates on loans
Selling rate for borrowings, buying rate for lendings.
Bank Exchange Rate Application for LoansWho Should Use Advanced Bank Currency Rates?
Treasurer
Enters the bank sheet as it is published.
Accountant
Gets the right rate on the right document without overriding.
Auditor
Sees which bank and which rate type a conversion used.
Developer
Adds a model to the supported list in one method.
Frequently Asked Questions
What does Advanced Bank Currency Rates do?
Exchange rates that know which bank published them and whether it is a buy, transfer or sell rate - and a conversion engine that picks the right one for each document.
What does Advanced Bank Currency Rates not do?
It does not fetch rates by itself. The provider selector is a hook; a bank-specific connector fills it. Only supported models use bank rates. Others keep the plain Odoo rate until a bridge adds them - purchase stock and loans have bridges. A rate type still needs a bank. Rates without a bank behave exactly as before. Currency revaluation is not changed. Period-end revaluation uses the standard rate.
Who is Advanced Bank Currency Rates for?
Treasurer: Enters the bank sheet as it is published. Accountant: Gets the right rate on the right document without overriding. Auditor: Sees which bank and which rate type a conversion used. Developer: Adds a model to the supported list in one method.
Which Odoo version and editions does it support?
Odoo 17.0 - Odoo Community, Odoo Enterprise, Viindoo Cloud. Upgrades to a newer Odoo series are a separate purchase for that series.
What does it depend on?
It installs on top of: account, to_base. Odoo installs them with it.
How do I set it up?
Set the main bank, enter rates by bank and type, and post as usual.
What works well with it?
Bank rates on receipts (to_bank_currency_rate_purchase_stock): Stock valuation at the buying rate. Bank rates on loans (viin_loan_management_bank_currency_rate): Selling rate for borrowings, buying rate for lendings. Automatic currency rates (viin_auto_currency_rate): Fetch rates on schedule.
Can I try it before buying?
Yes - the Live Preview button at the top of this page opens the module's own screen on a working database.
How do I get support?
Write to apps.support@viindoo.com with your Odoo version and the technical name to_bank_currency_rate; pre-sales questions go to sales@viindoo.com.
See Advanced Bank Currency Rates in Action
Buy, sell and transfer rates, per bank
Need help with Advanced Bank Currency Rates?
For questions, implementation support, or consulting services, contact Viindoo.
Pre-Sales & Partnership
sales@viindoo.comWhen contacting us, please include:
- Odoo/Viindoo version (Odoo CE / Viindoo Editions).
- Number of users and business scope.
- Other modules currently in use.
Technical Support
apps.support@viindoo.comFor faster troubleshooting, please provide:
- Order number or app reference.
- Odoo/Viindoo version & edition.
- Steps to reproduce the issue.
- Screenshots/logs if available.
Upgrades to a newer Odoo series are a separate purchase for that series.
Technical Requirement
Changes log
0.2 - Latest on the 17.0 line
- Aligned with the 17.0 models and views.
Installation
- Navigate to Apps.
- Search with keyword to_bank_currency_rate.
- Press Install.
Note:
- To view full features of the to_bank_currency_rate module, you need to install the Viindoo Accounting software.
- Install the Contacts app to be able to create bank information.
Instructions
Instruction video: Bank Currency Rates
Add currency rate
- Step 1: Create a bank account information.
- Step 3: Configure the main bank account used for the currency rate updates in the system.
Currency rates application on each operation
- Customer invoices and vendor bills: Journal entries created from vendor bills are automatically computed in the selling rates, and buying rates are applied to the ones created from customer invoices.
- Payment for vendor bills in foreign currencies: Accounting entries are recorded at the selling rate of the paying bank.
- Customer pays invoices in foreign currencies: Journal entries are recorded at the buying rates of the bank that receives the payment.
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.