Hello,
Here is the situation:After contacting supplier he answers with new prices for the quotation.
I fill the new values and validate the quote so that I can emit an order from it.
If my vendor has a different currency than Euro then all my product values in the order are calculated at the most current currency rate and because the prices on the order that drive the other than the base system currency are newly calculated my order comes out useless. I have to edit all line to reflect the right amount of vendor currency amounts.
In other words. If my supplier works in USD and he replied to my request for quotation in that currency then sure as hell he is expecting an order from me with the same values he proposed and with the same currency.
See the images below to understand what I am saying:
- Here is my Quotation request all filled up and nice with the suppliers’ prices. Counter value in Euros at the date of this quotation receival is just informative for now, nothing more. As you can see the total amount of the order of $2459.25 is the proposed value from the vendor. This is what he will expect me orther the products for.
- When I press the place order button there is a new display representing an intermediate step in the process. Here I am in an instant just before creating the Draft of the order. As you can see the values of the line items in the vendor’s currency are all ok. At this time they are shown based on the rate at the time of the proposal validation.
- As soon as I press Create Draft all hell brakes loose. As you can see from the display, the currency rate reverts back to the present rate which makes some sense but all the prices com affected from it. In effect the supplier’s prices are now calculated from the base currency (Euro) that came from the proposal (it shouldn’t if the vendor uses another currency) and the difference renders the order to my supplier useless. See both the totals and the line values in the order draft.
The way I see it the Euro prices should be reflected by the current currency rate, yes, but the vendor currency prices should be the driving numbers in this instance. Currently I can never validate this order and send it to the supplier without any line by line editing. It’s very cumbersome.
Also even when updating the lines manually the discounted total is calculated with an error. 31,21019*0,9=28,089171. This cannot be rounded up to 28.10.
Even when I take the discount out!!! That was a surprise! The line transforms 31,21019 into 31,20 instead of 31,21
I went to have a look into the code of /fourn/commande/card.php and the logic does not follow this process I suggest at all.
Is there any way this could be altered in terms of behaviour? It seems to me to be a potential show stopper for wannabe users of Dolibarr.
I would appreciate any help or opinions! I admit I might be seeing this thing from the wrong perspective.
Dolibarr is version 15.0.1
BR
P
