Invoice currency display on PDFs do not match admin panel currency display (v5.2.11-C53)

[charles]

Hello,

Recently, my invoices started displaying monetary values differently from my currency settings are (custom CA_Fr CAD). In the admin panel, everything displays fine as per my settings, for instance:

→ space thousand separator, OK
→ comma decimal separator, OK
→ space before $ sign on the right, OK

Well, here is how my PDFs now render the monetary values:

→ comma thousand separator, not OK
→ period decimal separator, not OK
→ space before $ sign on the right, OK - that’s what makes it weird: it’s a mix and match of different settings. In default (EN) CAD, the dollar sign is on the left with no space before the numbers.

What is even weirder is that the PDF renders the currencies without a problem in the design preview, as shown here with random data:

I thus seems that something happens with my actual invoices, whereas the seeded data from the html designer works fine…

Any ideas about what might be happening under the hood?

Thanks

EDIT:

Two new invoices created minutes apart differ in the way they render the currencies:

Invoice 1, wrong:

Invoice 2, as intended:

I have no idea what is going on!

[hillel]

@david @ben do you any thoughts?

[charles]

UPDATE:

I tried purging all my IN files (besides the database) and then I did a clean install. I also flushed my browser cache. My PDFs still don’t match my currency settings, whereas the admin UI does.

[charles]

Hello @hillel @david and @ben,

I could reproduce the issue on demo.invoiceninja.com.

Since my edited fr_CAD is not available there I created a new client for which I selected at random the Polish currency. Then I created an invoice with random data.

Here is the currency display in the admin panel for that invoice:

And here it is in the generated PDF:

In the PDF:
“,” → “.”
“zł” → " zł"
sign on the left → sign on the right

Now if I switch the main company currency to the Polish Zloty, it’s not even the same in the admin panel as the invoice in that currency:

This time, the zł sign is on the right with a space before… with a comma and not a period, which is the correct value BTW according to the default currencies tab in my database.

So basically for a single currency we have three different displays, only one of which is right according to my database (v5.2.11-C53).

Thanks in advance for looking into that

[charles]

Hello,

This issue appears fixed in v5.2.13-C56, at least for new invoices, thank you.

However, my invoices created prior to v5.2.13-C56 still show the wrong currency format. Is there anything I can do to update them? I tried opening and saving them (without making other changes, as those invoices are sent), but it didn’t fix the PDFs. It’s not a big deal since further invoices look like they will be displaying monetary values correctly and that’s what matters, but if possible my archives would match the proper format, too.

Thanks!

[charles]

Hi @hillel and @david,

Actually the issue is still there in v5.2.14-C56: currency formats do not always match between admin panel and PDFs.

As evidence, here is the admin panel invoice summary (from the public demo - once again tried with the Polish currency) :

Generated PDF (from public demo):

Notice how the currency sign is on the left in the admin panel and on the right on the PDF.

Now here is my own data:

Admin panel:

And the PDF (space is now a comma and comma is now a period):

The issue does not always happen though (some invoices print perfectly fine), and I can’t figure what triggers it.

Any help would be appreciated please!

[hillel]

Thank you for the screenshots, they’re very helpful!

cc @david @ben