Hello all, I’m new in Dolibarr and I use version 19.0.2.
I buy from european vendor in Euro and sell to Bulgarian company in BGN.
The seller (my company) and buyer (bulgarian company) have both BGN currency set.
I’ve configured Multicurrency module as 1 BGN = 0,51129 EUR
Everything is fine in product management, prices correct in EUR and BGN.
When I make a sales order, everything is fine in the order page, every number is correct but it write:
Currency conversion rate 1.95583 (1.95583 BGN = 1 BGN)
At the end, all document generated (pdf) is multiplied almost by 2 (1.95583).
Can someone help me and point me where I made a mistake?
Sorry for my bad bad english.
Thanks
what do you mean by 1.95583 BGN = 1 BGN?
Ah now i see, you should edit the Limits and accuracy, play with it and generate new pdf invoices. go to Home → setup → Limits and accuracy
Hi Hawre, thank you for reading me problem and for your reply. Sorry but I don’t understand. The problem is between the amounts in order (first image) and amounts in pdf (second image) generate by Dolibarr.
In pdf all amounts are multiply almost by 2 (exactly 1.95583) that is the currency rate between EUR and BGN (1 EUR = 1.95583BGN). But the order is between 2 company that use BGN both, so no needs any conversion. Moreover in order there is the nonsense 1.95583 BGN = 1 BGN.
The only needs in conversion is in product module (buy and sell costs) but it’s managed perfectly. I hope I’ve better explain now. Thank you again.
Hi @Paolo
The currency rate shows up in the invoice creation card only in case the client is using another currency
Can you check that your client default currency is BGN?
Hi Sonikf, thank you for your reply. The two companies have both set BGN as currency. All data in order and products are fine in every page. Only the operation of “GENERATE” create a draft document with wrong amounts. My company sell 2 products in BGN (buyed from company that works in EUR) to another bulgarian company that work in BGN. The order page present the nonsense 1.95583 BGN = 1 BGN, That means, in my opinion, that it try to convert BGN to BGN between seller (me) and buyer (the other bulgarian company) using BGN/EUR ratio because I buyed that product in EUR. I don’t know if this hypothesis could be true.
Is it possible that is related to a wrong template of “proforma” and in opposite it will works fine in “invoice” template? In Bulgaria we use proforma first and then invoice after receive money. I never try invoice template as I’m blocked on wrong proforma.
What is the path to proforma for me to try, as i don’t use it? Maybe there is a bug there.
Really I don’t know. I set “Proforma” in module “Sales Orders” management setup, and the system generate me the proforma invoice.
I tried proforma and it works, still the odd thing about your screenshot is the currency conversion rate that shouldn’t be there. Since i can’t replicate in 19.02, there could be either a misconfiguration on your part or corrupted db.
Can you post a screenshot of your multi-currency setup page?
I’ll try to reset everything ad insert again all products.
You are a genius!!! DB problem.
I connected wuth the database and delete records in the tables llx_multicurrency and llx_multicurrency_rate.
Then I’ve recreated the currency rate and everything in ok now.
Thank you for your patience with my problem.
Sorry this forum says I’ve made to much reply, so I edit this message.
I don’t think this issue is related to products