Can't search by numbers on All Transactions view

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
dbolton
MVP MMEX User
Posts: 70
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No

Can't search by numbers on All Transactions view

Post by dbolton »

The new All Transactions feature is very useful. Especially when going through receipts. I no longer have to pay special attention to which account they charged to.

I would love to use the search box at the bottom to type in an amount ("28.57") and it go to the transaction with that amount. This works on the individual accounts, but not in the All Transactions view.

As a workaround I can search for amounts by including the currency sign ("$28.57"), but this is less convenient than typing numbers one-handed on the numpad.
User avatar
Renato
MVP MMEX User
Posts: 299
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Can't search by numbers on All Transactions view

Post by Renato »

.
If you use the prefix symbol for the currency, then you must also enter this when searching.
.
MMEX9.png
MMEX9.png (35.76 KiB) Viewed 301 times
regards Renato use MMEX since 2009
MartinArmstrong
Super MMEX User
Posts: 29
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Can't search by numbers on All Transactions view

Post by MartinArmstrong »

Excellent advice. Thank you @Renato.

I hadn't discovered the Currency Manager dialog before.

Not only can I now remove the Prefix Symbol of £ (for UK Pound) from the All Transactions view, which I've been wanting to do for some time - but I can now also change the 1000s Grouping Char from the default (space) to , (comma).

MMEX1.png
MMEX1.png (108.13 KiB) Viewed 294 times


This enables me to select transactions in an account and copy & paste them into Excel and have the values recognized as numbers.

MMEX2.png
MMEX2.png (28.68 KiB) Viewed 294 times
User avatar
Renato
MVP MMEX User
Posts: 299
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Can't search by numbers on All Transactions view

Post by Renato »

You're welcome, I also learn something every day thanks to your questions. :idea: ;)
regards Renato use MMEX since 2009
dbolton
MVP MMEX User
Posts: 70
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No

Re: Can't search by numbers on All Transactions view

Post by dbolton »

Very useful! Thank you. I submitted a request to change the default group separator for USD from space to comma: https://github.com/moneymanagerex/database/pull/44
Nikolay
MMEX Developer
Posts: 1507
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Can't search by numbers on All Transactions view

Post by Nikolay »

You can use 1?424?14 to find 1424.14 currency value.
Nikolay
MMEX Developer
Posts: 1507
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Can't search by numbers on All Transactions view

Post by Nikolay »

Post Reply