Old PDF in wrong currency Issue

0
Hi, I have just upgraded invoice manager to V 3.0.1 (JOOMLA 3.8.3 - PHP 7.0.27) I had strange behaviour first, but after cleaning several times my cache, it went back to normal.
Actually what happen is : I'm using F CFP currency (this is the french New Caledonia currency). For new invoice or estimation, it works well. But when I edit old PDF (made before the update) they are all in € (but they all have been made in F CFP currency with the old version of Invoice Manager).
Is there anything i missed there ? No "routine" or something to do to find all my old PDF back in "MY" currency ?
Thanks in advance for any inforation about that...

Accepted Answer

Tuesday, June 19 2018, 01:34 AM - #Permalink
0
Hi Germinal,
I have finally (and at last) found the reason of the issu.

Actually I was doing mes quotes by duplicate an old one created BEFORE the update to IM 3.0.
And here is the point!
I have found also that repeatable invoices with invoices created BEFORE the update was in euros instead of F CFP i'm using.

I just had to stop using old quotes and stop reccurent invoices with old invoices, and start a new series with invoices or quotes created AFTER the update. Everything is fine now... Thanks for all.
The reply is currently minimized Show
Responses (6)
  • Accepted Answer

    Monday, January 29 2018, 07:51 PM - #Permalink
    0
    I have just noticed that if I open a n old invoice or estimation and save it (without doing anything else), the PDF is then in the good currency. Maybe there can be a php script to run so every item will be back in the good currency ?
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, January 30 2018, 11:38 AM - #Permalink
    0
    hmm.. probably what's happening is that the new currency system has not been applied to previous invoices.
    first, make sure you have set a "default currency" in your invoice manager OPTIONS.

    besides of that, if you have access to phpMyAdmin (mysql), there's a quick mysql query you can run to set the currency on all invoices.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, January 30 2018, 11:39 AM - #Permalink
    0
    oh, by the way, make sure that the invoice you're using (CFP) is PUBLISHED, on currency list.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, January 30 2018, 06:43 PM - #Permalink
    0
    Hi Germinal, thank a lot for your answer....

    Currency CFP is PUBLISHED (checked) - BTW, I unpublished all other currencies as I don't need them. Is that correct ?
    Default currency is CFP as needed (checked)

    When i create a new Quote, currency is good in the HTML template. But for PDF and Email template, I have to save it, close it. Re-open it, re-save it and the the good currency is then shown. This is thrue only in Quote. I don't have this issue with Invoice... weird, isn't ?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, January 31 2018, 10:02 AM - #Permalink
    0
    yep, it's weird... basically because, internally, invoice and quote are the same thing.. so if it works for one thing, should work for the other...
    really weird.
    would you mind sending me admin access so I can take a look?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, January 31 2018, 02:35 PM - #Permalink
    0
    Hi Germinal,
    I have re-tried this morning and still the same. No problemo with invoices, quote are first in euro, then, after re-save it, in CFP.

    Here's an access :
    URL : http://www.paoproduction.com/administrator?pao
    User : joomlathat

    This website is in production. I have made a backup MySQL and a backup full website, so there should be no problem.
    When you make test, I have created a customer called "Bob Test"...
    The reply is currently minimized Show
Your Reply