Page 1 of 1

Can't search by numbers on All Transactions view

Posted: Wed Apr 28, 2021 2:57 am
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.

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

Posted: Wed Apr 28, 2021 10:06 am
by Renato
.
If you use the prefix symbol for the currency, then you must also enter this when searching.
.
MMEX9.png

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

Posted: Wed Apr 28, 2021 1:15 pm
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


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

MMEX2.png

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

Posted: Wed Apr 28, 2021 1:55 pm
by Renato
You're welcome, I also learn something every day thanks to your questions. :idea: ;)

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

Posted: Wed Apr 28, 2021 3:27 pm
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

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

Posted: Wed Apr 28, 2021 6:27 pm
by Nikolay
You can use 1?424?14 to find 1424.14 currency value.

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

Posted: Wed Apr 28, 2021 7:30 pm
by Nikolay