[BUG] Reporting - THB symbol not formatted correctly

[shaneoreilly]

Setup

• Version: v5.7.54-C141
• Environment: Docker, self hosted

Interface

• Flutter: []
• React: []
• Both: [X]

Checklist

• Can you replicate the issue on our v5 demo site https://demo.invoiceninja.com or https://react.invoicing.co/demo? N
• Have you searched existing issues? X
• Have you reported this to Slack/forum before posting? N
• Have you inspected the logs in storage/logs/laravel.log for any errors? N

Describe the bug

My currency is set as THB
When exporting to Excel, the THB symbol (฿) is being exported as a character, so I cannot do any formula calculations on the data without manual modifications to remove the ฿ character first.

Steps To Reproduce

• Set Currency to THB
• Export Invoice/Payment reports

Expected Behavior

• The THB symbol (฿) should be exported correctly
  OR
• Option should be given to remove any currency symbol on export

Additional context

Screenshots

Logs

[hillelcoren]

Are you exporting the data from Settings > Import/Export or from the reports?

Can you confirm this problem affects both the Flutter and React apps?

[shaneoreilly]

@hillelcoren
The issue is there when exporting from "Reports", but I just validated the same issue is not there in the data exported via Settings -> Import/Export.
The values are numberic values without any ฿ currency string included.

I am using the Flutter UI on desktop. How can I switch back to React to test? I just assumed the export logic is independent of the UI being used

[hillelcoren]

There's a React button at the top of the dashboard.

[shaneoreilly]

Ah, simple. Thanks for that @hillelcoren!

I see the following:

No Issue:

• React: Reports Dasboard:
• React: Settings > Import/Export
• Flutter: Settings > Import/Export

Issue Exists:

• Flutter: Reports Dasboard:

[shrawank039]

Payment Reports Using,

Flutter Panel:

React Panel:

as we see in react export there is a separate column for 'Payment Currency' which displays the currency ISO/symbol. And in the flutter export, It's set with the price.

So creating a separate column like react will fix this?