Re: [GNC] flatpak 4.4 reports anomaly

2021-02-11 Thread Christopher Lam
You normally specify the name when Saving a report. What name did you use? On Fri, 12 Feb 2021, 12:36 am Elmar, wrote: > Running "/usr/bin/flatpak run --branch=stable --arch=x86_64 > --command=gnucash --file-forwarding org.gnucash.GnuCash > --logto=$HOME/gnucash.trace" in a terminal window invok

Re: [GNC] Reverse all transactions

2021-02-11 Thread Jim DeLaHunt
On 2021-02-11 12:26, Anton Gladky wrote: …all entries in "Expenses" are in "Rebate" column, and all entries in "Income" are in "Charge" column. So I believe all of them need to be reversed. Anton, one option you have is to go through each transaction in the register, by hand, and reverse eac

Re: [GNC] Non-Scheduled Transaction ???/Scheduled Transaction Mystery

2021-02-11 Thread Christina Martin
I tried to send this response to the list 2 days ago, but I haven't seen it come in on the digest, so I must have done something wrong. I finally had time to sit down and do some testing and I'm covering things raised and suggested in a variety of digests up to Wed 10/2. This odd behaviour st

Re: [GNC] foreign currency bank account import

2021-02-11 Thread David Carlson
There have been issues in the past with certain releases of GnuCash. If you tell us which version of GnuCash you are using and your operating system you will get a better answer. On Thu, Feb 11, 2021 at 7:36 PM Public Address wrote: > Hi - > > I import a USD bank csv file where GBP is my base c

[GNC] Gnucash xml file ope error

2021-02-11 Thread pellico
Please help: I've been using Gnucash for years.  This problem started late last year.  I open my file and add a transaction, then the next time I try to open it I get the attached error. Seems that when I can open it, if I save it as a new file, it will open and I can update.  Then the next open,

[GNC] foreign currency bank account import

2021-02-11 Thread Public Address
Hi - I import a USD bank csv file where GBP is my base currency All transactions are properly linked to a transfer account, some of these are USD some are GBP. GNU Cash makes the transactions which are linked to a GBP transfer account a split transaction and tries to link to [consistently the

Re: [GNC] How to get invoices to appear in the Reports|Tax schedule report?

2021-02-11 Thread Paul Kinzelman
Thanks for the quick reply! I looked and the invoice shows Income:Sales as you said it should. So then I did another Report|TaxSchedReport and now it's working, I can see that income. Science lurches onward. :-) I think what might have happened was that I was running 4.2, couldn't get it to work

Re: [GNC] Reverse all transactions

2021-02-11 Thread Stephen M. Butler
Do you have a backup of the database from before these entries?  If so, can you restore that database to that state and start over? Note:  if there have been a lot of other transactions entered in the interim, then the above may not be an option. If you have a file holding the original transa

Re: [GNC] Reverse all transactions

2021-02-11 Thread Anton Gladky
> You can TRY to export it to CSV, manipulate it there, and then import. That was my idea as well, just wanted to check, maybe there is a more elegant way. Thanks again! Anton Am Do., 11. Feb. 2021 um 21:33 Uhr schrieb Derek Atkins : > Hi, > > On Thu, February 11, 2021 3:26 pm, Anton Gladky w

Re: [GNC] Non-Scheduled Transaction ???

2021-02-11 Thread Stephen M. Butler
Did some additional testing as requested. 1.  If the Create Automatically is not checked, and it is time to fire (or past time in my tests) then user is presented the option to review the transactions (including the ones that were auto-created=Y).  If you click CANCEL then the one not auto-cre

Re: [GNC] Reverse all transactions

2021-02-11 Thread Derek Atkins
Hi, On Thu, February 11, 2021 3:26 pm, Anton Gladky wrote: > Hi Derek, > > Thanks for a quick reply! > >> How did the entries get input into GnuCash? > Manually, but in a reverse order. > >> Why do you believe they are incorrect (reversed)? > Well all entries in "Expenses" are in "Rebate" column,

Re: [GNC] Reverse all transactions

2021-02-11 Thread Anton Gladky
Hi Derek, Thanks for a quick reply! > How did the entries get input into GnuCash? Manually, but in a reverse order. > Why do you believe they are incorrect (reversed)? Well all entries in "Expenses" are in "Rebate" column, and all entries in "Income" are in "Charge" column. So I believe all of

Re: [GNC] Reverse all transactions

2021-02-11 Thread Derek Atkins
Hi, On Thu, February 11, 2021 3:12 pm, Anton Gladky wrote: > Dear all, > > I need to reverse all transactions in a relatively large database. > Something like "Increase <-> Decrease" for all entries. > > Is there any effective way to do it? Maybe, is it possible to > operate on sqlte-database dire

[GNC] Reverse all transactions

2021-02-11 Thread Anton Gladky
Dear all, I need to reverse all transactions in a relatively large database. Something like "Increase <-> Decrease" for all entries. Is there any effective way to do it? Maybe, is it possible to operate on sqlte-database directly? Thanks Anton ___ gnu

[GNC] [MAINT] Unplanned network outage

2021-02-11 Thread Derek Atkins
Hi, Some of you may have noticed that code went offline around 2:30am US/ET this morning. My ISP made a change which caused my "magic box" (a device I use to work around a NAT table limit) to stop working. I manually corrected the issue at 7:15am and have written some code to attempt to do that

Re: [GNC] How to get invoices to appear in the Reports|Tax schedule report?

2021-02-11 Thread Derek Atkins
Hi, On Thu, February 11, 2021 1:28 pm, Paul Kinzelman wrote: > I'm running GC 4.4 > > I'm having trouble generating a tax report that includes paid invoices. > I'm not an accounting heavy-weight so I'm likely doing something wrong, > but I don't know what it is. > > I created an invoice for a cust

[GNC] How to get invoices to appear in the Reports|Tax schedule report?

2021-02-11 Thread Paul Kinzelman
I'm running GC 4.4 I'm having trouble generating a tax report that includes paid invoices. I'm not an accounting heavy-weight so I'm likely doing something wrong, but I don't know what it is. I created an invoice for a customer and posted it. What I see is the money went into AccountsReceivable

Re: [GNC] Non-Scheduled Transaction ???

2021-02-11 Thread Adrien Monteleone
Could be, but definitely something particular to your transaction, your book, or your computer. I just created another test SX transferring $1 from my wallet to savings set to auto-create 3 days in advance, and notify me on creation. I set it for 2/14/21. I then closed GnuCash and restarted.

Re: [GNC] Transaction Report Question

2021-02-11 Thread Adrien Monteleone
Gareth, Can you provide a screenshot of the incorrect report? Can you describe *exactly* how you want it to look? That report has lots of options. The default sorting is by Account Name, then by Register Date for the current accounting period. (default for which is 'This Year') Also, please

Re: [GNC] Non-Scheduled Transaction ???

2021-02-11 Thread Jack Slater
I think its all in the timing. I ran GNC on 2/5. The transaction read created 2/5 - but didn't appear. The setting was enter 3 days in advance which it seems it can't/didn't do. Shut GNC down and reopen days later and it was there. Its not that big a deal but its a bug for sure. On Thu, Feb 11, 2

Re: [GNC] Filtering reports on contents of Memo field

2021-02-11 Thread Adrien Monteleone
Good to hear that works for you! Regards, Adrien On 2/11/21 5:32 AM, Michael Hendry wrote: On 11 Feb 2021, at 00:36, Adrien Monteleone wrote: Transaction Report, not Account Report. Regards, Adrien Thanks, Adrian. D’oh! I don’t know why I’ve never used the Transaction Report before, it

Re: [GNC] gnucash-user Digest, Vol 215, Issue 26

2021-02-11 Thread E. Nick Henery
To all of you that responded. Thanks and your time and instructions are most appreciated. Stay safe and Healthy. Nick > On Feb 11, 2021, at 8:16 AM, gnucash-user-requ...@gnucash.org wrote: > > Send gnucash-user mailing list submissions to > gnucash-user@gnucash.org > > To subscribe or

Re: [GNC] Non-Scheduled Transaction ???

2021-02-11 Thread Adrien Monteleone
I haven't checked. I'd be happy to file one for you, but I can't reproduce the problem. All of my SXs show up when they are supposed to and appear in the register as they are supposed to. I've also created some test transactions and they also worked correctly. Something is either specific to

Re: [GNC] flatpak 4.4 reports anomaly

2021-02-11 Thread Elmar
Running "/usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash --file-forwarding org.gnucash.GnuCash --logto=$HOME/gnucash.trace" in a terminal window invoked GC fine. Opening the saved reports item, then trying to delete a report results in this output in the terminal window:

Re: [GNC] flatpak 4.4 reports anomaly

2021-02-11 Thread Geert Janssens
Ok, the branch specification is probably important. You can try as follows: /usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash --file- forwarding org.gnucash.GnuCash --logto="path-to-log-to-or-stdout" My mail client splits this line up, but the command should be all on one line.

Re: [GNC] flatpak 4.4 reports anomaly

2021-02-11 Thread Elmar
The menu item cals GC via "/usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash --file-forwarding org.gnucash.GnuCash @@ %f @@" And this is the first (and only) flatpak I have ever installed.  I installed Flatseal so GC could find my data files as well, of course. On 2/11/21

Re: [GNC] Non-Scheduled Transaction ???

2021-02-11 Thread Jack Slater
Adrien - Did a bug filing occur on my original (and others subsequent) problem? Jack On Wed, Feb 10, 2021 at 9:13 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > That indeed appears confusing. > > I'm going to hazard a guess that it means there are none for you to > review prior

Re: [GNC] flatpak 4.4 reports anomaly

2021-02-11 Thread Geert Janssens
In that case the first thing to do is to figure out how exactly your system calls the flatpak version of gnucash. There are quite a few subtle details that may affect this. You can examine the menu entry to figure out what command is being run exactly. Out of curiosity have you been removing i

Re: [GNC] flatpak 4.4 reports anomaly

2021-02-11 Thread Elmar
Trying "flatpak run org.GnuCash.gnucash --logto=$HOME/gnucash.trace" does not invoke the program and instead gives me "error: app/org.GnuCash.gnucash/x86_64/master not installed" Which is very odd, since it runs from the menu system fine. - Elmar On 2/11/21 3:59 AM, Geert Janssens wrote: The

[GNC] FOLLOW-UP Re: Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile

2021-02-11 Thread Robert Stocker
One of four statements has reconciled WITH the expected payment pop-up. Alas, I never managed to keep track of which ones behaved correctly and which didn't, so I'll have to wait until the first of the month to be 100% sure, but we're off to a good start. ___

Re: [GNC] flatpak 4.4 reports anomaly

2021-02-11 Thread Geert Janssens
Op donderdag 11 februari 2021 03:42:52 CET schreef Christopher Lam: > Scheme backtraces are usually found at > https://wiki.gnucash.org/wiki/Tracefile but if flatpak hides them somewhere > obscure you can dump onto console via "gnucash --logto=stdout". See > https://wiki.gnucash.org/wiki/Logging >

Re: [GNC] Transaction Report Question

2021-02-11 Thread Gareth Davies via gnucash-user
Thanks, for the reply Adrien, I think I have tried every tick box without having any luck. It looks like I will have to accept it as it is for now, but I will keep on trying. Regards, Gareth -Original Message- From: gnucash-user On Behalf Of Adrien Monteleone Sent: 29 January 2021

Re: [GNC] Filtering reports on contents of Memo field

2021-02-11 Thread Michael Hendry
> On 11 Feb 2021, at 00:36, Adrien Monteleone > wrote: > > Transaction Report, not Account Report. > > Regards, > Adrien Thanks, Adrian. D’oh! I don’t know why I’ve never used the Transaction Report before, it provides all the sorting and totalling I need (by intended destination for report

Re: [GNC] Transaction Report Question

2021-02-11 Thread Gareth Davies via gnucash-user
Thanks, for the reply Adrien, I think I have tried every tick box without having any luck. It looks like I will have to accept it as it is for now, but I will keep on trying. Regards, Gareth -Original Message- From: gnucash-user On Behalf Of Adrien Monteleone Sent: 29 January 202