'Balance' column makes no sense anymore

[jpweaving]

Hi.
The 'Balance' column makes no sense anymore, it no longer gives a running total. I think that it is now just freezing the figure at the balance shown when the transaction was entered into the account, then when listed in Date order, the closing balance for any particular day appears at the bottom entry, not the top. If this is a deliberate change, I may get used to it but it is of no use to me.
Thanks.
Please do not remove information attached below this text.

---

Version: 1.5.21 64-bit
• Build: Sep 21 2022 09:27:42
• db 7 • (aes128cbc)
• git cb708cc (2022-09-21)

Libs:
• wxWidgets 3.2.0 (wxMSW 10.0)
• wxSQLite3 4.6.0 (SQLite 3.31.1)
• RapidJSON 1.1.0
• Lua 5.3.5
• lunasvg v2.3.1
• libcurl/7.82.0-DEV Schannel
• gettext 0.19.8.1
• apexcharts.js

Build using:
• CMake 3.16.2
• MSBuild 15.9.21.664
• MSVS15.0
• MSVSC 19.16.27035.0
• Windows SDK 10.0.14393.0

OS:
• Windows 10 (build 19044), 64-bit edition
• English (United Kingdom) (windows-1252)
• 1920x1080 32bit 96x96ppi 

[vomikan]

Please note that the sorting algorithm has changed.
#5108

[n-stein]

Also #5122

[PMaff]

I do think that the balance column is an important feature.
Please keep it.
Although there is a bug in 1.5.20, 1.5.21 .
Will open an issue.

Edit: opened issue:
#5136

[jpweaving]

It's not fixed. It still displays the Balance incorrectly for multiple transactions on the same day if those transactions were entered in random order.

[whalley]

It's not fixed. It still displays the Balance incorrectly for multiple transactions on the same day if those transactions were entered in random order.

That has always been the case, we currently only have Date and order it was entered. We need #2729 to improve this.

[jpweaving]

The sort order is not the problem in any way. In 1.5.20 the balance column always makes sense. each entry in the balance column accurately reflects the account balance after that transaction is taken into account. So the balance at the last transaction shown for any day accurately reflects the account balance at the end of that banking day, so the top figure in the balance column always matches the actual balance of that account. In 1.5.21 the balance doesn't make any sense unless you always enter transactions in the order that they occurred. You can end up with a situation where a transaction for a £1.00 withdrawal can result in a balance figure that is higher than the previous one. There is no point in that at all.

[whalley]

You refer to v1.5.21 as having an issue. We have made some fixes in the latest beta release to address this. You will either have to revert back to v1.5.20, take the latest beta, or wait for the next release.

[jpweaving]

Thanks

…

On Fri, 30 Sept 2022 at 17:46, Mark Whalley ***@***.***> wrote: You refer to v1.5.21 as having an issue. We have made some fixes in the latest beta release to address this. You will either have to revert back to v1.5.20, take the latest beta, or wait for the next release. — Reply to this email directly, view it on GitHub <#5123 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AP7TTWIUW7Q5EPWH4RRDKY3WA4KM5ANCNFSM6AAAAAAQT3A72Q> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[jpweaving]

I know I am probably being thick but can you give me a link to 1.5.22 beta please.

…

On Sat, 1 Oct 2022 at 00:46, Phil Weaving ***@***.***> wrote: Thanks On Fri, 30 Sept 2022 at 17:46, Mark Whalley ***@***.***> wrote: > You refer to v1.5.21 as having an issue. We have made some fixes in the > latest beta release to address this. You will either have to revert back to > v1.5.20, take the latest beta, or wait for the next release. > > — > Reply to this email directly, view it on GitHub > <#5123 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AP7TTWIUW7Q5EPWH4RRDKY3WA4KM5ANCNFSM6AAAAAAQT3A72Q> > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> >

[whalley]

For win64 - https://ci.appveyor.com/project/moneymanagerex/moneymanagerex/build/job/qp8sa43blbsx4nwk/artifacts

Note - the next build will be v1.6.0, please take a copy/backup of your database before trying beta builds. In particular for this release as it upgrades the database.

[jpweaving]

That's great. Thanks Mark

…

On Sat, 1 Oct 2022 at 01:31, Mark Whalley ***@***.***> wrote: For win64 - https://ci.appveyor.com/project/moneymanagerex/moneymanagerex/build/job/qp8sa43blbsx4nwk/artifacts Note - the next build will be v1.6.0, please take a copy/backup of your database before trying beta builds. In particular for this release as it upgrades the database. — Reply to this email directly, view it on GitHub <#5123 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AP7TTWJIZR3BB4RL3BTQVSDWA6A75ANCNFSM6AAAAAAQT3A72Q> . You are receiving this because you authored the thread.Message ID: ***@***.***>