wish: change order of same day transactions

Bug #1749457 reported by rugk
50
This bug affects 9 people
Affects Status Importance Assigned to Milestone
HomeBank
Fix Released
Wishlist
Maxime DOYEN

Bug Description

I'd like to change the order of transactions via drag and drop.

Or, maybe you find another solution, so let's tackle my problem here.

(In a new account)
1. Create a transaction "-5" (currency does not matter here).
2. Now you notice that you forgot to add the credit transfer (or, whatever) to this account, so add an item, which has a "+10" value.

You did both on the same day!

What happens:
You have a -5 saldo value in your history, which is incorrect, as you, of course, first transferred the money and then bought something. So

What should happen:
I should be able to change the order of transactions happened on the same day in oder to correct such things.

Current workaround:
Change the date of transaction 1 ("-5") into the future. Save. Change the date back to "today". -> Transaction 1 will be the listed below transaction 2.

Best solution IMHO:
Just allow drag and drop for that thing in general. It may automatically adjust the date if it is dragged over a newer/older transaction.

Tags: transaction
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

from a bank point of view, the bank balance will be the same no matter the order the txn are within a same day. The running balance will of course an reading it you might miss the changes order.

if you have a balance of 100.00 on Jan 1st then

             runbal bnkbal
20/01 -80.00 20.00 30.00
20/01 +10.00 30.00 30.00

Revision history for this message
rugk (48509946-3) wrote :

Yeah exactly. As said, it just looks ugly when you have e.g. a negative (red!) number in your log there, while you actually never had that account balance in real life.

Maxime DOYEN (mdoyen)
summary: - Change order of transactions via drag & drop
+ wish: change order of transactions
Revision history for this message
Jake Helbig (jhelbig) wrote : Re: wish: change order of transactions

I agree. Most of the imports that are consumed by HB already have either timestamps that declare order or a financial transaction ID or 'FITID'.

Revision history for this message
Sameera (sameerasmail) wrote :

I agree with Jake's comment #2. It looks ugly when you see negative balances during the day (when you forgot to input credit transactions first). That is why i made same request to allow re-order the day's transactions by adding a time to transactions or by numbering them or moving them up/down to adjust to the correct order.

Thanks.

Revision history for this message
GeoDot (hertzg) wrote :

This would also help when you are working with imports and would like to find one missing transaction by opening two account history and comparing side by side.

Currently its very hard when history is for a year and includes all transactions.

Revision history for this message
TonyIT (nc8430) wrote :

You can add an option to let the user decide if have the balance shown in every transactions or only when the date of transaction is <> from the previous.

TonyIT

Revision history for this message
kjdfofghdfrke (kjdfofghdfrke) wrote :

Not only it looks ugly, but it's very important to have this function because it's a mess to check many transactions if they are not in the same order, as displayed by the bank's website for example, having the budget not go below zero is very important to actually check and compare before reconciliation. This might be implemented via drag & drop, and also via up/down arrows, so bug #1814452 can be fixed in the same way.

Maxime DOYEN (mdoyen)
Changed in homebank:
importance: Undecided → Wishlist
assignee: nobody → Maxime DOYEN (mdoyen)
Maxime DOYEN (mdoyen)
tags: added: transaction
Maxime DOYEN (mdoyen)
summary: - wish: change order of transactions
+ wish: change order of same day transactions
Revision history for this message
rugk (48509946-3) wrote :

(UX) Suggestion: If they are not the same-day and the user tries to drag- and drop across a day, then you can just adjust the date manually. This would allow a user to quickly "correct" incorrect dates.

Revision history for this message
Jeff Fortin Tam (kiddo) wrote :

If you want to keep the implementation simpler (vs having to deal with drag & drop and such in a listview widget), a way to do it could be to have a "Move transaction up" and "Move transaction down" menu entries in the Transaction menu, and optionally a pair of toolbar buttons with up/down arrows for this purpose, maybe only showing those buttons when having selected a transaction that has other transactions on the same day. But already, even if it's just the menu entry, it would be a really good start.

Of course, the issue with that (reordering directly within the transactions list) is that the way this would work would depend on the sorting order of the listview, which is easy when you're sorted ascending/descending based on the transaction dates, but it would become nonsensical when you're sorted by some other column (ex: sorted by category), though in that case maybe you can just disable those menu/toolbar actions.

Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: none → 5.3
status: New → In Progress
Maxime DOYEN (mdoyen)
Changed in homebank:
status: In Progress → Fix Committed
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

DnD will not be intuitive here (no one can guess it exists, or the way it will work)

what was done is:
- 2 toolbar buttons: move up/down
- only available when the sort is by Date

Maxime DOYEN (mdoyen)
Changed in homebank:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.