This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Changing the transaction sequence

Tags: None
(comma "," separated)
jehoshua
Registered Member
Posts
100
Karma
0
OS

Changing the transaction sequence

Sun Jan 14, 2018 4:12 am
KMyMoney 4.6.6 on Kubuntu 16.04.3

Usually I enter all the transactions for the day in time sequence. It just makes it easier to reconcile. Is there any easy method to force the sequence in which transactions appear ?

I did uncompress the .KMY file with gunzip , renamed to .XML and opened in Firefox. I see there is an ID to each transaction ..

Code: Select all
<TRANSACTION postdate="2018-01-11" commodity="AUD" memo="" id="T000000000000008783" entrydate="2018-01-13">
<SPLITS>
<SPLIT payee=.....


It seems the id numbers don't position in the file exactly as the id number is defined, however that could be that some are reconciled and some are not. I'm assuming that if I move a complete 'set' to reposition and then also change the ID # 's , it may work ?? It seems those ID numbers are only used to identify each transaction, and there is no other reference to them.


Currently running Kubuntu 22.04, Plasma 5.24.4, Frameworks 5.92.0, Qt 5.15.3, kernel 5.15.0-46-generic (64-bit), GeForce 840M Graphics
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

Re: Changing the transaction sequence

Sun Jan 14, 2018 10:52 am
Newer versions of the application (4.8+) allow to sort the ledger by various parameters. I don't remember if this is already available in 4.6 .Entry order is one of them,and is based on the transaction ID you mention.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
jehoshua
Registered Member
Posts
100
Karma
0
OS
ipwizard wrote:Newer versions of the application (4.8+) allow to sort the ledger by various parameters. I don't remember if this is already available in 4.6 .Entry order is one of them,and is based on the transaction ID you mention.


Thanks for your reply. Considering I would have to upgrade to a newer version of Kubuntu to use KMyMoney version 4.8+ , can I simply modify those few ID numbers, save the XML file and then open it in KMyMoney ? Assuming I make backups and changing those ID's won't impact on any internal processing with KMM.


Currently running Kubuntu 22.04, Plasma 5.24.4, Frameworks 5.92.0, Qt 5.15.3, kernel 5.15.0-46-generic (64-bit), GeForce 840M Graphics
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
Assuming you make backups, this should be working (AFAIR). Please check for matched transactions (in case you have any): they contain a transaction inside a transaction. The ID of the included transaction must not be duplicated while changing the other ones.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
jehoshua
Registered Member
Posts
100
Karma
0
OS

Re: Changing the transaction sequence

Wed Jan 17, 2018 11:07 am
ipwizard wrote:Assuming you make backups, this should be working (AFAIR). Please check for matched transactions (in case you have any): they contain a transaction inside a transaction. The ID of the included transaction must not be duplicated while changing the other ones.


I'm not familiar with the term matched transactions in KMM. I searched through the XML file and noticed there is a setting for Payees - "Transaction Matching". I assume that is not set for all payees, as I just leave it to the default and don't use it. Thanks :)


Currently running Kubuntu 22.04, Plasma 5.24.4, Frameworks 5.92.0, Qt 5.15.3, kernel 5.15.0-46-generic (64-bit), GeForce 840M Graphics
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
jehoshua wrote:I'm not familiar with the term matched transactions in KMM.

Please feel free to consult the manual.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
jehoshua
Registered Member
Posts
100
Karma
0
OS
ipwizard wrote:
jehoshua wrote:I'm not familiar with the term matched transactions in KMM.

Please feel free to consult the manual.


Thanks, however that all seems to be related to importing transactions. What I wanted to do was the simply open the file (as an XML), change the transaction ID ensuring I don't use an ID# that is used elsewhere, then save the file.


Currently running Kubuntu 22.04, Plasma 5.24.4, Frameworks 5.92.0, Qt 5.15.3, kernel 5.15.0-46-generic (64-bit), GeForce 840M Graphics


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Yahoo [Bot]