v 16.0 Third Party 3
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Invoicing (account)
Purchase (purchase)
Sales (sale_management)
Discuss (mail)
Lines of code 1014
Technical Name tus_custom_currency_rate
LicenseOPL-1
Websitehttps://www.techultrasolutions.com
Versions 17.0 16.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Invoicing (account)
Purchase (purchase)
Sales (sale_management)
Discuss (mail)
Lines of code 1014
Technical Name tus_custom_currency_rate
LicenseOPL-1
Websitehttps://www.techultrasolutions.com
Versions 17.0 16.0

Custom Currency Rate

Consider the following scenario: You are trading with multiple countries, each with its own currency rate. Suppose, Currency of your company is INR and you are sending goods in USD, in that case you need to add the currency rate of USD and trade accordingly. As you know Currency rate is changing every day. In such cases, calculating and converting currency rate from one type to another is quite difficult and time consuming. The business will impact, and the error rate will be high.

To overcome this problem Techultra Solutions provides you a Currency rate app, It is a multi functionality app such as, add currency rate, calculate converted amount, exchange rate etc. this app is configured in all area where you need to use currency such as sale, purchase, invoice, bill, credit notes, debit notes, refund etc.

https://wa.me/message/VENRAJRHMSWEB1 OR
  • New currency rate button.
  • Calculate converted amount.
  • Calculate and show the exchange rate.
  • Journal entry of converted amount.
  • Can see currency amount difference after manual currency rate.
  • Display the exchange rate in currency rates.
  • See the currency amount converted
  • Can convert amounts of three different currencies.
  • Manual currency rate: Can re-enter or change currency rate in case of different register payment and purchase date/sales date.

1.Configuration

Configuration is very simple just go to General Setting and enable Allow new currency rate.After enabling it you will be able to see a new field “ new currency Rate ” such as add currency rate in quotation, SO, PO, RFQ, Refund, credit notes, debit notes.

2. New Currency rate field in Request for quotation

In the image below, you can see a field called “ New currency rate ”; in this field, you must enter the currency rate; this is a mandatory field, and you will not be able to proceed unless you fill it.

3. Converted Currency Amount

After adding the currency rate, you can see the converted currency amount below.It is computed internally.

4. Manual Currency Rate

After we have confirmed the bill, the next step is to register payment.

Consider the following example:

If our bill date was 28-08-2023, our currency rate was 80 at the time, and today's date is 31-08-2023, it is possible that the currency rate has changed, and if we register payment, it will be inaccurate; to deal with this issue, we have added a new field Manual currency rate, where you can enter the updated currency rate.

Currency Amount Difference

After the currency rate has been updated, you will be able to see the currency amount difference, which can be positive or negative.

5. Different payment currency and invoice currency and company currency

This is one of the best features of this app by which you can convert three different currency rates.
For example, if your company currency is INR and your invoice currency is USD, but your customer wants to pay in EUR, this app will allow you to enter two currency rates (USD and EUR) and calculate a custom amount (EUR).

In image

Currency rate for selected currency to invoice currency : It is Payment currency rate in which a customer wants to pay his bill. Here, it will be EUR.

Currency rate for invoice currency to company currency :It is Customer currency, here it will be USD.Custom amount-total amount in EUR

6. Exchange Difference

The Exchange Difference occurs when the currency rate changes between the invoice/bill date and the register payment date.

Example:

Suppose currency rate was 82 USD at the time of creating bill (Date:1-09-2023)so the total amount will be a= total converted amount at the time of invoice = 600x 82= ₹ 49200 But at the time of register payment(Date:5-09-2023) the currency rate changed to 85 USD so the total amount will be b = total converted amount after register payment= 600 x 85= ₹ 51000 So, Exchange difference = a-b = 51000 - 49200= ₹ 1800 Note: a and b is variable.

7. Click on view to see the exchange difference, as shown

8.Journal entry

Journal entry will post for the converted amount. Here you will see a journal entry for Bank(register payment), Exchange difference, and bill. Here, $600 is deducted from the customer's bank account and deposited to your account; the bill amount is ₹ 49200 (converted amount), and the exchange difference is ₹ 1800.

9. New Currency rate Field in Quotation(Sales Module)

We have configured this field in Quotation as you can see in below image,

10. Converted Currency Amount

After adding the currency rate, you can see the converted currency amount below. It is computed internally.

11. Register payment:

The amount shown below is the converted amount; you can also see the currency amount difference if it occurs.

12. New currency rate field in Refund

It is possible that the invoice and refund dates will differ; in this case, it is critical to compute the correct amount. We have configured this app with a refund so that you can calculate the exchange rate correctly.

13. New currency rate field in credit notes

We have configured this app with a credit notes so that you can calculate the exchange rate correctly.

  • We are provide 90 days bug free support related to our module.
  • The support team is availbale from Monday to Friday 10:00 AM to 07:00 PM (IST).
  • To create ticket send email to support@techultra.in.

What is the currency rate?

It is a rate in which one country can trade with another country.

What is the exchange difference?

Exchange difference is a difference between the transaction date and the date of settlement.

Can we use this currency rate app in the Odoo community version?

Yes

How will I find the currency rate of foreign countries?

Type currency rate (country name) in google. It will show you the current rate of currency.

Do I need to calculate the currency amount manually ?

No, after adding a new currency rate system will automatically calculate the converted amount in desired currency.

Can I update the currency rate at the time of settlement?

Yes you can update at the time of register payment.

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

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.