Exported Finance Info 'name' column problem
When I export data from the Finance area, WA puts the members names in one column (John Doe). I need the name to be in two columns so I can alphabetize by last name. I went to the WA support/help people and was told that's the way it is and I will need to do a 'text to columns' procedure as a 'workaround'. This is what I've been doing and, because I export frequently, it's an additional timely and frustrating problem when reformatting the Exports.
I would like WA to consider changing the way the names are exported in the Finance section.
If this can't be done, I'd like an explanation as to why it has to be this way? For the life of me, I can't see the logic in how it is now.
If anyone who reads this request knows of a solution (besides what I'm already doing), please pass on your information.
Thanks in advance, Susan Porter, National Button Society Secretary/Membership
Released in 5.2
[Deleted User] commented
I second this and add a request.
I, too, was shocked to find my Excel file could not be alpha sorted. I'm ignorant of what a 'text to columns' procedure is; maybe I'll have to look that up. My only saving grace is my reports are very short. I am exporting from Payments and Refunds, filtering first by Tender-Check to create a bank deposit report. A long result would be unusable for me if not able to alpha sort.
The amounts fields are also useless as exported. They are configured as "Numbers stored as text" and do not total. When I want to total the Settled Amount field, I have to highlight the column and use Excel's Error Check feature to convert to number. Then I highlight again and change the format to currency, for a better, more accurate appearance.
Would it be possible for the exported numbers fields to be stored as numbers?
Evgeny Zaritovskiy commented
Thanks for sharing - I see your point. This will require the product change and cannot be done right away - I will add this in our (quite long) backlog.