We installed the system on one of our servers and the system looks very promising.
But when we tested and attempted to make a test invoice in a different currency (DKK, SEK or EUR) than our base currency (GBP), it doesn´t seem possible even though you can choose a multitude of currencies in the list for your company; plus you can also live update of the currencies from the exchange?
I dont think this multicurrency issue has ever been properly addressed. I have clients in various countries all utilising standard services and i base the pricing on my home currency, for example, my home product sale price would be 150, then a customer in country B would then be charged this price x6 (exchange rate) so the invoice would be 900; customer C has the same service and is charged x0.4 so should be charged 60. This should be simple, as the products should be in the company default currency, and as is supposedly possible, the invoice shows the clients home currency, thus the amount should be the product price x the exchange rate. Why is this not possible, even IN says they support multiple currencies. Really is a pointless effort as I have to create duplicate products with prices set to the currency i would be billing in.
This also fundamentally affects bills i receive from vendors in other countries, as again, these expenses only convert 1:1, not in accordance with their echange rates.
Is there also an easier way to update exchange rates without editing the database directly (I have fixed exchange rates, and do not use any integrations for regular updates)?
Really hope there will be some detailed responses on how to get invoices to properly reflect currencies.
As a test, on the IN hosted service, this update to invoices (conversion to local exchange rates) works, but not on the self hosted system. It is also possible to change the exchange rate in the settings on the invoice, thus there must be some bug between the self host version and the hosted service, or there is an issue with the use of the currency database table.
just as a follow up on this; in the self-hosted IN, setting the exchange rate in the invoice settings section before adding any products, DOES change the product amount, but there seems to be the missing link to a standard table of currency exchange rates unlike the hosted service.
I appreciate there is the option to synch currency exchange rates, but I want to fix them (I have done this in the database currency table), but this doesnt automatically synch when adding a product to the customers invoice, it keeps the rate at 1 unless I set the exchange rate in the invoice "settings"tab. in the cloud version this all works as expected, but not in the self hosted version so maybe there is some fail to link to the currency table somewhere. Can you suggest where to look for this link reference in the application files, specifically for incvoices (I am not a coder, but can follow some of the coding references)
As a practice, whilst getting things fully functional, I do the artisan optimize, system healthcheck/clear cache/refresh data and the refresh in the device settings to make sure everything clears and is refreshed, but still no luck.
I do not use any API to update the currency exchange rates as I want to have fixed exchange rates. the web application doesnt seem to reference the exchange rates in this table and only updates product prices when I set the exchange rate on the individual invoice in the settings option, where i can select the project etc.
Have been monitoring this for the past few days with no joy in the currency issue resolving itself. the system still shows the product cost the same in each currency and does not convert according to the database rates. I built a second site from scratch with everything working and the same result.
When creating a new invoice, if i set the exchange rate in the settings part for the Invoice everything works as expected, but if the exchange rate is not set here, the default when adding a product is 1. For some reason the web app is not checking the database table for the exchange rates, or for some reason the cache is not updating properly.
Can anyone point me where to look to see if there is a broken connection somewhere? The crone jobs are running perfectly and this is the only glitch (Note that this is not a problem on the Invoice Ninja hosted version)