Re: [GNC] reports: filter by number

2022-01-12 Thread Bregt - ICTgroup.be via gnucash-user
Hi Adrien, Your first suggestion works like a charm. The created report is exactly what I need. I'll have to work on the layout, as the options are more limited, but that's a minor detail. Your second suggestion, through the Transaction Report, indeed does not operate on the NUM field: what is av

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread xraive .
I changed [-5:EST] to [+2:EST] and the dates are working. But I don't know why that would work. From: gnucash-user on behalf of xraive . Sent: Wednesday, January 12, 2022 6:55 AM To: john Cc: Mark Sutton ; gnucash-user@gnucash.org Subject: Re: [GNC] Transac

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread Mattia Rizzolo
On Wed, Jan 12, 2022 at 5:46 PM xraive . wrote: > I changed [-5:EST] to [+2:EST] and the dates are working. But I don't know > why that would work. FWIW, +2:EST doesn't make sense. If you want UTC+2, that would be +2:EET (for example). (though TBH I'm not sure what are the actual parsing rule

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread David Carlson
Xraive, Your test proves that GnuCash in the release that you are using does not perform that import function correctly. You have found a work-around which will work for you temporarily. Now that the developers are aware of this, hopefully there should be a fix applied in the next update. Unfortu

Re: [GNC] reports: filter by number

2022-01-12 Thread Adrien Monteleone
Good to know, thanks for the follow-up! Regards, Adrien On 1/12/22 3:31 AM, Bregt - ICTgroup.be via gnucash-user wrote: Hi Adrien, Your first suggestion works like a charm. The created report is exactly what I need. I'll have to work on the layout, as the options are more limited, but that's a

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread Derek Atkins
Hi, On Wed, January 12, 2022 12:03 pm, David Carlson wrote: > Xraive, > Your test proves that GnuCash in the release that you are using does not > perform that import function correctly. You have found a work-around > which > will work for you temporarily. Now that the developers are aware of th

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread David Carlson
doing a little research I found this history, but no current bug. https://bugs.gnucash.org/show_bug.cgi?id=636340 On Wed, Jan 12, 2022 at 11:17 AM Derek Atkins wrote: > Hi, > > On Wed, January 12, 2022 12:03 pm, David Carlson wrote: > > Xraive, > > Your test proves that GnuCash in the release t

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread Derek Atkins
According to that bug it was fixed in LibOFX in June 2021... And the fix appears to be in 0.10.3 What version of LibOFX is in use? -derek On Wed, January 12, 2022 12:26 pm, David Carlson wrote: > doing a little research I found this history, but no current bug. > > https://bugs.gnucash.org/show_

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread Fred Bone
On 12 January 2022 at 17:53, Mattia Rizzolo said: > On Wed, Jan 12, 2022 at 5:46 PM xraive . wrote: > > I changed [-5:EST] to [+2:EST] and the dates are working. But I don't > > know why that would work. > > FWIW, +2:EST doesn't make sense. If you want UTC+2, that would be > +2:EET (for exampl

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread xraive .
Thanks for correcting me, I tried your suggestion and it came to the same result. I've looked at my other financial institution and download their transactions. They also have the same format the only difference being the transaction time. TD: 2021072202[-5:EST] RBC: 2021102512[-5:E

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread xraive .
I forgot to mention the file from RBC works fine. From: xraive . Sent: Wednesday, January 12, 2022 6:00 PM To: Mattia Rizzolo ; gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) Thanks for correcting me, I trie

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread David Carlson
The OFX standard is very complex but that should not be an excuse for some of the mistakes that sometimes happen. It could be worse. I have one credit card that reverses the sign on charges and payments or the names of charges and payments, so everything comes in backwards. I will probably tr

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread xraive .
I've never filled out a bug report. Can anyone confirm if need to submit one or are the developers aware of this issue. From: David Carlson Sent: Wednesday, January 12, 2022 8:25 PM To: xraive . Cc: Mattia Rizzolo ; Gnucash Users Subject: Re: [GNC] Transactio

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread Derek Atkins
If you feel there is still a bug, you should file a report in Bugzilla. Issues here are easily lost or forgotten, so it is not safe to assume developers are aware and will remember to explore and fix it. -derek Sent using my mobile device. Please excuse any typos. On January 12, 2022 3:43:08 P

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread David Carlson
You as a user have no way of knowing the history that the developers have already done on that problem. I would hope that one of them will look at it and get back to us with an answer whether the solution committed last year didn't work, never made it to release 4.9, or what happened. On We

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread David Carlson
Derek is a developer. Follow his advice On Wed, Jan 12, 2022, 2:56 PM David Carlson wrote: > You as a user have no way of knowing the history that the developers have > already done on that problem. I would hope that one of them will look at > it and get back to us with an answer whether th

[GNC] eBay Managed Payment

2022-01-12 Thread Dale Holden
Helo Guys I am new on here and just trying to move from Xero Accounts. I was wondering if any members on here use GC for eBay Managed Payments? Id so i would like to have a quick chat if possible [image: Mailtrack]

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread xraive .
There seems to be two reports already with somewhat similar issues but I could be mistaken. https://bugs.gnucash.org/show_bug.cgi?id=797848 and a much older one https://bugs.gnucash.org/show_bug.cgi?id=137017 If they aren't related then I can go ahead and submit a new bug. What do you think?

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread David Carlson
The most important thing is to report your own results with files from your banks and the rest of your details about the versions of Gnucash etc. If you start a new bug report you could even reference those other bug reports. Over the years there have been issues with daylight time adjustment s a

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-12 Thread xraive .
Thanks for the assistance. I submitted a bug report and included a link below. https://bugs.gnucash.org/show_bug.cgi?id=798419 From: David Carlson Sent: Thursday, January 13, 2022 12:45 AM To: xraive . Cc: Derek Atkins ; Mattia Rizzolo ; Gnucash Users Subject