I would like to see a feature of being able to automatically display a secondary currency on an invoice which is required in several countries.
When issuing an invoice in a currency that is not the local currency in a country like United Arab Emirates then we need to mention the equivalent amount in the local currency with the currency exchange rate of the day, ideally just below the foreign currency total amount.
We have until now used a template for that but when the currency exchange rate changes then we need to change the template every time.
Please consider adding this feature for us.
You can enter the exchange rate in a custom field without using a custom theme.
True, but wouldn’t that require an entry per item? I think it is much better to offer this option in the system and secure all invoices to be according to the exchange rates of Manager.
One thing in regards to custom themes is that there is no way to format the output number…
No. Just as you have shown in your screen shot (which I presume is from your custom theme), you would enter it once. Custom fields are normally shown just below the totals section, unless you place them elsewhere using a custom theme.
The program already offers it. That is what custom fields are intended to provide—special needs for specific circumstances. Most countries do not require what you want.
That is up to you and how you program a theme. Using a custom field, you can specify text and enter whatever you want.
That is not correct, I would say MOST countries do indeed require this.
A short summary:
Must show equivalent amount on Invoice:
United Arab Emirates: https://www.tax.gov.ae/pdf/Cabinet-Decision-52-of-2017.pdf
Must show only the used exchange rate:
European Union: https://www.avalara.com/vatlive/en/eu-vat-rules/eu-vat-returns/invoice-requirements-eu-vat.html
I think we have to agree to disagree. I prefer automatic calculations where possible in order to minimize the room for human errors.
I am well aware of the custom field and calculations etc but I find that solution unsatisfactory.
What happens if the currency exchange changes from day to day… you enter the exchange rate for the custom field manually every day (per each invoice even!) and then how is that represented in the booking system? It is just a display dummy for the invoices etc and is not recorded in the system, which means it could allow errors in VAT returns for countries that have different base currency than the invoice currency.
This is a serious matter that I hope @lubos will take seriously into consideration to implement it…
Now, to the issue of formatting the manually calculated number… does ANYONE have a format solution that puts a value to xx,xxx.xx format? I have only been able to get xxxxx.xx without the thousand and million seperator… as seen on my example above…
It is stored as the content of the custom field where you entered it. It will not affect any accounting information entered unless you write a custom theme that includes calculations with custom fields. You need to explain and illustrate your concern about VAT returns. Conversions to base currency are unrelated in the program to custom field content. So it is not clear what you are worried about.
Yes, the program has this built in. If you create a custom field of number type, its format responds to changes of your number format preference. And, as I said before, if you select a text-type custom field, you can enter anything you want into it.
When custom field is used, no info is affecting the stored VAT.
This means when I invoice 1000 USD to a company abroad with 10% VAT included, the VAT should be 100 USD (simplified example). But since my accounting system us set to AED currency with a dummy exchange rate of the day to be 5 AED per 1 USD, the system would put the equivalent of 100 USD into the VAT account but the conversion is based on the exchange rate set in the system and NOT the one entered in a custom field for example. Then I am invoicing an amount to a client and I am not returning the same equivalent amount to the authorities which is a serious offence in most countries if not all… Therefore it is ESSENTIAL that this is implemented the soonest.
Bottom line: Dual currency invoices need the exchange rate of the day to be fixed and used in the invoice issued that day and all the derived calculations need to be professionally stored and documented in the Manager system. The displayed values and the stored values must always be the same… That can only be achieved with an integrated currency exchange system… No other way.
That is not working. First of all, in order to display any calculated value on an invoice then you need the custom field option “Show custom field on printed documents” to be enabled. It can’t be hidden if you want to use it for any calculations. Secondly, if you format the number in the custom field to “3.6725” then the calculated value is still on the format “xxxxxxx.xx” and there is no way to display a calculated value with the thousands seperator. I urge you to try it yourself before replying and saying that you can. I have tried everything!
The displayed summary below is the results from a formatted currency value but the answer does not reflect the formatting, contradicting your answer that the calculated value would inherit the formatting of the custom field… (I made the XE value in thousands in the below example in order to try to get it formatted with thousands seperator…)