Report/export Report/csv

Hello,

I have a Problem... again.

So if you want to enter the currency in an invoice, it is always mandatory that euro always has a “€. ” Is it possible to change this? Because if you want to draw a report, csv (excel table) is specified as a special character.

Thank you and best regards,

L.S

Parents

0 Lydia Manger over 2 years ago
I'm not familiar with how to do this, but from a search of SugarClub, it looks like others have created two calculated fields, one for the currency symbol and one for the value. They then use those fields for reporting so that the value is exported as a number in the CSV.

Check out these posts and see if they can help!

https://sugarclub.sugarcrm.com/explore/help-forums/enterprise-professional/f/enterprise-professional-questions/4776/report-export-to-csv-currencies

https://sugarclub.sugarcrm.com/explore/help-forums/enterprise-professional/f/enterprise-professional-questions/5494/csv-extraction-of-currency-field

https://sugarclub.sugarcrm.com/explore/help-forums/enterprise-professional/f/enterprise-professional-questions/4564/in-reports-disable-currency-in-price-field
Lydia Manger

Product Manager — Sugar Discover
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

0 Lydia Manger over 2 years ago
I'm not familiar with how to do this, but from a search of SugarClub, it looks like others have created two calculated fields, one for the currency symbol and one for the value. They then use those fields for reporting so that the value is exported as a number in the CSV.

Check out these posts and see if they can help!

https://sugarclub.sugarcrm.com/explore/help-forums/enterprise-professional/f/enterprise-professional-questions/4776/report-export-to-csv-currencies

https://sugarclub.sugarcrm.com/explore/help-forums/enterprise-professional/f/enterprise-professional-questions/5494/csv-extraction-of-currency-field

https://sugarclub.sugarcrm.com/explore/help-forums/enterprise-professional/f/enterprise-professional-questions/4564/in-reports-disable-currency-in-price-field
Lydia Manger

Product Manager — Sugar Discover
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

0 Tonja Clasen over 2 years ago in reply to Lydia Manger

Thank you very much!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel