Hi
I was trying to delete a transaction and had this error
Any Help appreciated
Thanks !
Error Deleting Transaction
Moderator: Renato
Error Deleting Transaction
- Attachments
-
- Error.jpg (6.02 KiB) Viewed 2187 times
-
- New User
- Posts: 1
- Joined: Fri Dec 11, 2020 8:05 am
- Are you a spam bot?: No
Re: Error Deleting Transaction
A fix has been provided for this issue in GitHub: https://github.com/moneymanagerex/money ... /pull/1121
This disables the Duplicate button. The duplicate option on the popup menu was disabled.
As for removing the error, this requires removal of the entry by using sql commands.
We need to determine the share account ID
select ACCOUNTNAME, ACCOUNTID from ACCOUNTLIST_V1
where ACCOUNTTYPE = "Shares";
This tells us the correct linkages
select ca.TRANSID, ca.ACCOUNTID, ca.TOACCOUNTID
from CHECKINGACCOUNT_V1 ca, SHAREINFO_V1 si
where ca.TRANSID = si.CHECKINGACCOUNTID;
With this we can determine the extra transaction that needs to be deleted
select ACCOUNTID, TRANSID, TOACCOUNTID from CHECKINGACCOUNT_V1
where ACCOUNTID = ?;
We can then create a database debug command to fix the error.
This disables the Duplicate button. The duplicate option on the popup menu was disabled.
As for removing the error, this requires removal of the entry by using sql commands.
We need to determine the share account ID
select ACCOUNTNAME, ACCOUNTID from ACCOUNTLIST_V1
where ACCOUNTTYPE = "Shares";
This tells us the correct linkages
select ca.TRANSID, ca.ACCOUNTID, ca.TOACCOUNTID
from CHECKINGACCOUNT_V1 ca, SHAREINFO_V1 si
where ca.TRANSID = si.CHECKINGACCOUNTID;
With this we can determine the extra transaction that needs to be deleted
select ACCOUNTID, TRANSID, TOACCOUNTID from CHECKINGACCOUNT_V1
where ACCOUNTID = ?;
We can then create a database debug command to fix the error.