[SOLVED] Calculation error?

[marcottt]

Hi all, i moved a payment (a come in) from bank to contant but calculation is now wrong. Ho to refresh / ricalculate?

Attached image, total in the up left is wrong....

Thanks, sorry im new to mmex

[wolfsolver]

I didn't notice this before. Is one time issue or it is still present?
Just to understand if there is a refresh issue or something else..

[wolfsolver]

Btw which version do you use? (From menu-about)

[marcottt]

from F-Droid, ver 2025.01.03


just checked now after 6 hours, same issue present.

[marcottt]

issue is present also in the other direction, i mean also the bank account is wrong.

attached image, where i removed the 103,20 € but total "saldo in italian" is still 109.41

Total is very wrong because in the past days i moved also other funds but was small ammount so i did not notice it.

Seem when you change account to a single transaction, funds are not recalculated in the from and destination account.

[marcottt]

i find another issue, if i try to open this db with windows applicatio, windows app open it but after some second application hung.

If you need i can send my db (i just started, is pretty empty) but i made the checks inside android application and seem to be ok.

Some days ago i opened db from android app with windows application ver 1.8.1 without any issue.

[wolfsolver]

Yes, could be useful. Since I'm not able to reproduce.
I move some transaction from a account to another and never see this issue.

[marcottt]

Attached an db export

[Renato]

I tested briefly, if you select Reports/Categories/Monthly, then MMEX 1.9.0-RC 1 64 Bit hangs

[marcottt]

ok, any suggestion about? because now i also cannot edit with windows application when needed.

[Renato]

the hangup was caused by an incorrect assignment of a subcategory.
I have appended the subcategory 70 Cura della Persona = which pointed to itself, to the category 28 Altro.
Is this the solution to the other problems?
.

MMEX09.png

your_export_db.mmb

[marcottt]

i tried to use the mmb you attached, but i get this error on windows app.

Not tried into the android app

[Renato]

Which mmex version are you using ?

[marcottt]

Windows 64 1.8.1

[wolfsolver]

Hi guys. Two things from me:

1) Calculation error is not an issue. in your screen seems yes, but if you choose data --> all data (storico in italiano) you see all movement and the sum is correct. Keep in mind that "Saldo" means the actual amount present in the account. So is not influenced by selection different date range.
2) Category 70 that point itself is the main issue. From Android point of view this cause no issue (category 70 is exlcuded automatically from recursevie query), and since there is no record that use category 70 no issue.

On Android version we already implement a check in loadParentCategory by checking if parentID is equal ID

[wolfsolver]

BTW in attach fixed mmb with cat 70 manually set as unactive and binded to root.

Tested open on win 1.8.1

[marcottt]

i'm at work now, but a birf check now seem to be ok.

Thank you, now i must compare your db with actual db and recreate the newer moviment, or there is somethink i can do simple repair my actual db ?

If is not simple, i'm faster to add newer moviment (maybe 10 ors so).

[wolfsolver]

you can repair db manually:

1) using a SQLlite browser on PC (if you need it you can use any dbBrowser like https://sqlitebrowser.org/dl/)
2) Open your DB with sqllite browser
3) navigate to category_v1 table
4) scrool to your record 70, and set "PARENTID" field from "70" to "-1" (you cannot have a category with category id itself.
4.a) since you have category 71 with same name you can also set "active" field to 0 so old wrong cateogry is not more used.
5) save

this is a simple sql script
update CATEGORY_V1
set active = 0 ,
PARENTID = -1,
CATEGNAME = "OLD - " || CATEGNAME
where CATEGID = PARENTID;

[marcottt]

Thanks @Renato and @wolfsolver now seem good again.

Thanks for your support and patience.

Marco

[wolfsolver]

You are welcome....

Btw could be interesting to understand how the dirty record was created... Did you notice something? There was error that cause this? (Like reassign category...)

[marcottt]

hi, as ai say, i'm new to mmex, from 1 gen 2025, so after some days of use i for sure changed some category... but aways with android application not with sql tools, so everything i did, i did it with mmex application.

Do not remember for sure, i think renaming some sub-category and maybe a category.