Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-05 Thread GWB
David, Michael,

Yes to both of you, but see the other thread on this.  Mac's give you
modified, created and last opened in the finder window.  That can help
troubleshooting.  That's also why older unix systems used some version
of .lck .lnk files and core dumps; all three can be diagnostic.  And
Colin takes a different tack on this.

I like the philosophical question here.  Signifigance often assigns
itself well after events, or perhaps it is post attributive.  I like
the 4 category approach: "known knowns, known unknowns, unknown
knowns, and unknown unknowns".

GordonOn Mon, Nov 5, 2018 at 9:42 AM Michael or Penny Novack
 wrote:
>
> On 11/4/2018 9:10 PM, David T. via gnucash-user wrote:
> > As others explained, the lck and lnk files are created by gnucash to 
> > prevent users accidentally opening the data file on multiple machines. They 
> > are zero bytes in size and there is no point in trying to open them up. 
> > There is no there there.
> >
> Sometimes it can help people remember if they are told why.
>
> Why a file with no data? The lock file isn't intended to be OPENED. Only
> its EXISTENCE is being tested. That's what it is there for. If it
> exists, then some instance of the program has the corresponding data
> file open. When gnucash is about to open a data file, it creates a
> corresponding lock file, and when it closes that data file, it deletes
> the lock file. The existence of a lock file (for some data file) means
> that an instance of the program "owns" that data file, and no other
> instance of the program can touch it.
>
> Why this way? Because a program can check for the existence of a file
> even if not allowed to open that file.
>
> Of course if the program (or the system) crashes before the program
> closes a file and deletes the lock a lock file can get left behind.
>
> Michael D Novack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Accounting for Refund

2018-11-05 Thread Eric Rathhaus office
I do have a f/u question. When I create a credit note, the program only allows 
me to account for it as income and it appears as a positive number in my 
accounts receivable.  How can I account for this transaction so that gnu cash 
recognizes this transaction should be a debit against previously income?

Kind regards,

Eric W. Rathhaus
Law Office of Eric W. Rathhaus
484 Lake Park Avenue, Suite 50
Oakland, CA 94610
415.577.0920 tel
415.737.0603 fax

www.ewrlaw.com

Confidentiality : 

The information contained in this message is legally privileged and 
confidential information intended only for the use of the addressee(s) named 
above.  If the reader of this message is not the intended recipient, please be 
advised that any dissemination, distribution, or copy of the information in 
this message, and/or the name(s) of the person(s) it is addressed to, is 
prohibited.  If you have received this message in error, please notify us by 
returning this email to us.  If that is not possible, we will reimburse you for 
any costs in returning this message to us through other means.



> On Nov 5, 2018, at 12:34 PM, Eric Rathhaus office  wrote:
> 
> Thank you, Geert.
> 
> Kind regards,
> 
> Eric W. Rathhaus
> Law Office of Eric W. Rathhaus
> 484 Lake Park Avenue, Suite 50
> Oakland, CA 94610
> 415.577.0920 tel
> 415.737.0603 fax
> 
> www.ewrlaw.com
> 
> Confidentiality : 
> 
> The information contained in this message is legally privileged and 
> confidential information intended only for the use of the addressee(s) named 
> above.  If the reader of this message is not the intended recipient, please 
> be advised that any dissemination, distribution, or copy of the information 
> in this message, and/or the name(s) of the person(s) it is addressed to, is 
> prohibited.  If you have received this message in error, please notify us by 
> returning this email to us.  If that is not possible, we will reimburse you 
> for any costs in returning this message to us through other means.
> 
> 
> 
>> On Nov 5, 2018, at 12:27 PM, Geert Janssens  
>> wrote:
>> 
>> Op maandag 5 november 2018 20:00:54 CET schreef Eric Rathhaus office:
>>> Hello - I need to refund a client for pre-paid expenses I didn’t end up
>>> incurring.  I could just cut a check and account for it as an expense.  But
>>> as these payments came from multiple invoices and jobs, I would like to
>>> have some method for creating a note to identify the various expense
>>> payments I’m refunding.  Credit notes only exist for employees.
>> 
>> Credit notes exist for customers, vendors and employees. Unfortunately the 
>> menu names are a bit misleading.*
>> 
>> If you select Business->Customer->New Invoice you can choose to create 
>> either 
>> an invoice or a credit note.
>> 
>>> Would I go
>>> back to each invoice and revise the payments to account for refund from
>>> each invoice and send updated invoice along with the check?  Thanks.
>> 
>> That shouldn't be necessary as you can create a credit note for a customer.
>> 
>> Regards,
>> 
>> Geert
>> 
>> * This is a historical artifact. There has been some discussion when the 
>> credit note feature got added, but at the time no consensus was reached 
>> about 
>> how to organize the menus. And at some point it was forgotten. We really 
>> should fix this. Meanwhile a credit note can be created via New Invoice...
>> 
>> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fedora => Debian 3.2 => 2.1.15 Data Conversion Issues

2018-11-05 Thread Frank H. Ellenberger
Hello Wolfram,

Am 05.11.18 um 22:02 schrieb Wolfram Wagner:
> Hello Adrien,
> 
> Thanks for your help. I forgot flatpak at all.
> 
> As flatpak means (almost) no influence on the other packages, I try
> this first. I installed it already, found that all my needed features
> work (including banking data exchange). The only issue I see, is that
> gnucash came up in an US american locale. I have changed all settings
> to EUR, but found no way to enable the German translations.

Does
https://wiki.gnucash.org/wiki/De/Konfiguration#Lokalisierung_.28Einstellung_der_Sprache.2C_W.C3.A4hrung.2C_Formate_29
or
https://wiki.gnucash.org/wiki/Locale_Settings
help?

> I have to do half of my work in English, so this is not a big issue, as
> long as there is no issue with the reports... I need to check further.
> 
> Thank you!
> Wolfram

Regards
Frank

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash: Not able to get Online Quotes to work

2018-11-05 Thread John Ralls

Those both show catastrophic failure of GnuCash to even start, so there’s 
something wrong with the way you’re trying to start GnuCash from the command 
line. There may be a clue there: You can run gnc-fq-dump but not GnuCash, so 
GnuCash when launched the usual way must be getting a different environment, 
one that doesn’t get the same perl includes that your command-line one does.

Regards,
John Ralls


> On Nov 6, 2018, at 6:18 AM, Joe Peters  wrote:
> 
> Hello,
> Doing some further digging, trying to figure this problem out; why online 
> quotes will not work for me.  I ran gnucash --debug.  This is the .trace file 
> contents.  Would anyone know if these warning may be causing the issue?
> 
> * 13:52:54  INFO  [main] System locale returned en_CA.UTF-8
> * 13:52:54  INFO  [main] Effective locale set to en_CA.UTF-8.
> * 13:52:54  INFO  [gnc_hook_lookup] no hook lists
> * 13:52:54  WARN  Could not locate module gnucash/app-utils 
> interface v.0
> * 13:52:54  WARN  Could not locate module gnucash/engine 
> interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/register/ledger-core interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/register/register-core interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/register/register-gnome interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/import-export/qif-import interface v.0
> * 13:52:54 MESSG  Could not locate optional module 
> gnucash/import-export/ofx interface v.0
> * 13:52:54 MESSG  Could not locate optional module 
> gnucash/import-export/csv-import interface v.0
> * 13:52:54 MESSG  Could not locate optional module 
> gnucash/import-export/csv-export interface v.0
> * 13:52:54 MESSG  Could not locate optional module 
> gnucash/import-export/log-replay interface v.0
> * 13:52:54 MESSG  Could not locate optional module 
> gnucash/import-export/aqbanking interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/report/report-system interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/report/stylesheets interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/report/standard-reports interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/report/utility-reports interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/report/locale-specific/us interface v.0
> * 13:52:54  WARN  Could not locate module 
> gnucash/report/report-gnome interface v.0
> * 13:52:54 MESSG  Could not locate optional module 
> gnucash/business-gnome interface v.0
> * 13:52:54 MESSG  Could not locate optional module gnucash/gtkmm 
> interface v.0
> * 13:52:54 MESSG  Could not locate optional module gnucash/python 
> interface v.0
> * 13:52:54 MESSG  Could not locate optional module 
> gnucash/plugins/bi_import interface v.0
> * 13:52:54 MESSG  Could not locate optional module 
> gnucash/plugins/customer_import interface v.0
> * 13:52:54  WARN  GnuCash engine failed to initialize.  Exiting.
> 
> 
> 
> Also, when I run gnucash --debug --add-price-quotes HomeFinance.gnucash 
> In terminal these are the msg's I get (not sure I ran it correctly?).  I have 
> no idea what this means?
> 
> Backtrace:
> In ice-9/boot-9.scm:
> 160: 8 [catch #t # ...]
> In unknown file:
>   ?: 7 [apply-smob/1 #]
>   ?: 6 [call-with-input-string "(gnc:price-quotes-install-sources)" ...]
> In ice-9/boot-9.scm:
> 2404: 5 [save-module-excursion # ice-9/eval-string.scm:65:9 ()>]
> In ice-9/eval-string.scm:
>  44: 4 [read-and-eval # #:lang ...]
>  37: 3 [lp (gnc:price-quotes-install-sources)]
> In ice-9/eval.scm:
> 386: 2 [eval # ()]
> 393: 1 [eval # ()]
> In unknown file:
>   ?: 0 [memoize-variable-access! # #]
> 
> ERROR: In procedure memoize-variable-access!:
> ERROR: Unbound variable: gnc:price-quotes-install-sources
> 
> Any suggestions or help would be great.
> 
> Best regards,
> Joe
> 
> 
> From: gnucash-user 
>  on behalf of Joe 
> Peters 
> Sent: November 4, 2018 3:24 PM
> To: gnucash-user@gnucash.org
> Subject: [GNC] gnucash: Not able to get Online Quotes to work
> 
> When trying to edit a security, in the 'Edit Security' window, under 'Quote 
> Source Information', everything is grayed out and there is a warning: '> 
> Warning: Finance::Quote not installed properly. <.
> 
> 
> GnuCash Help|About
> Version: 3.2
> Build ID: 3.2+ (2018-06-24)
> Finance::Quote: -
> 
> 
>  *   I am running linux mint 19 cinnamon
> 
>  *   I have set ALPHAVANTAGE_API_KEY=*## in 
> /etc/gnucash/environment. Where ### is my actual key number.*
> 
>  *   I have the same key number entered in the preferences tab of gnucash.
>  *   I can run (in terminal window) (i exported the ALPHAVANTAGE_API_KEY in 
> the .bashrc file)
> 
> gnc-fq-dump alphavantage msft
> 
> Finance::Quote fields Gnucash uses:
> 
> symbol: msft <=== required
> 
> date: 11/01/2018 <=== recommended
> 
> currency: USD <=== required
> 
> last: 106.3700 <=\
> 
> nav: <=== one of these
> 
> price: 

Re: [GNC] gnucash 3.x corrupts data file

2018-11-05 Thread John Ralls


> On Nov 6, 2018, at 4:08 AM, Jörg Schaible  wrote:
> 
> Hi David,
> 
> On Mon, 05 Nov 2018 02:30:39 + David T. via gnucash-user wrote:
> 
>> Jörg,
>> Frank points you to the spurious date that is likely the source of your
>> trouble.
> 
> I guessed also.
> 
>> I believe that at some point, the developers put in a data
>> check into the upgrade process, to prevent errors from propagating
>> forward, which would explain the problem arising now.
> 
> That check seems not in place when a file from an older version is silently 
> converted and when the file is 
> written ... :-/
> 
>> Perhaps you could
>> manually add a '3' after '201' before reopening the file.
> 
> I already tried this (but with 2018) and gnucash 3.3 still failed to open the 
> file. But that was before I compared 
> the old and new file and recognized that the new version also removes the 
> date-posted element (at least 
> when the value seems to correlate with 0).
> 
> ...
> 
> 
> But you were right. After correcting the gdate to 2013-01-02 and adding a 
> matching date-posted element, I 
> could read the file with the latest version 3.3.

It’s failing to load because of the deleted date-posted element. It shouldn’t 
be deleted, 0 is now a perfectly valid date since 2.6.0. Slots aren’t evaluated 
at load time so that was just a distraction.

Can you file a bug about the XML backend eating  0 date-posted values?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Inaccurate balance on credit card account

2018-11-05 Thread John Ralls


> On Nov 6, 2018, at 4:00 AM, Gerry Starnes  wrote:
> 
> Hello,
> 
> Having just reconciled my credit card account, I see that I have a fairly
> wildly inaccurate balance shown. The actual balance of entries should be
> $204.81 but shows to be $1075.45. That's off by $870.64. I'm not sure how
> long this has been going on, but I don't remember a discrepancy like that
> in the past.
> 
> I'm not asking what happened, but rather what do I need to do to correct
> this?
> 
> I'm using version 2.6.18. I have 3.3-1 but have not updated since I want to
> make sure everything is lined up correctly first.

Do you mean the balance shown in the summary bar is wrong compared to the 
balance of the last transaction? That’s a bug that was fixed in IIRC 3.2.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Stephen M. Butler

On 11/5/18 11:09 AM, btrib wrote:

So, I'm just trying to understand, I deactivate compression and this makes
the file openable as xml?


After GNC has saved the file one more time.

--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash: Not able to get Online Quotes to work

2018-11-05 Thread Joe Peters
Hello,
Doing some further digging, trying to figure this problem out; why online 
quotes will not work for me.  I ran gnucash --debug.  This is the .trace file 
contents.  Would anyone know if these warning may be causing the issue?

* 13:52:54  INFO  [main] System locale returned en_CA.UTF-8
* 13:52:54  INFO  [main] Effective locale set to en_CA.UTF-8.
* 13:52:54  INFO  [gnc_hook_lookup] no hook lists
* 13:52:54  WARN  Could not locate module gnucash/app-utils 
interface v.0
* 13:52:54  WARN  Could not locate module gnucash/engine interface 
v.0
* 13:52:54  WARN  Could not locate module 
gnucash/register/ledger-core interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/register/register-core interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/register/register-gnome interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/import-export/qif-import interface v.0
* 13:52:54 MESSG  Could not locate optional module 
gnucash/import-export/ofx interface v.0
* 13:52:54 MESSG  Could not locate optional module 
gnucash/import-export/csv-import interface v.0
* 13:52:54 MESSG  Could not locate optional module 
gnucash/import-export/csv-export interface v.0
* 13:52:54 MESSG  Could not locate optional module 
gnucash/import-export/log-replay interface v.0
* 13:52:54 MESSG  Could not locate optional module 
gnucash/import-export/aqbanking interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/report/report-system interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/report/stylesheets interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/report/standard-reports interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/report/utility-reports interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/report/locale-specific/us interface v.0
* 13:52:54  WARN  Could not locate module 
gnucash/report/report-gnome interface v.0
* 13:52:54 MESSG  Could not locate optional module 
gnucash/business-gnome interface v.0
* 13:52:54 MESSG  Could not locate optional module gnucash/gtkmm 
interface v.0
* 13:52:54 MESSG  Could not locate optional module gnucash/python 
interface v.0
* 13:52:54 MESSG  Could not locate optional module 
gnucash/plugins/bi_import interface v.0
* 13:52:54 MESSG  Could not locate optional module 
gnucash/plugins/customer_import interface v.0
* 13:52:54  WARN  GnuCash engine failed to initialize.  Exiting.



Also, when I run gnucash --debug --add-price-quotes HomeFinance.gnucash In 
terminal these are the msg's I get (not sure I ran it correctly?).  I have no 
idea what this means?

Backtrace:
In ice-9/boot-9.scm:
 160: 8 [catch #t # ...]
In unknown file:
   ?: 7 [apply-smob/1 #]
   ?: 6 [call-with-input-string "(gnc:price-quotes-install-sources)" ...]
In ice-9/boot-9.scm:
2404: 5 [save-module-excursion #]
In ice-9/eval-string.scm:
  44: 4 [read-and-eval # #:lang ...]
  37: 3 [lp (gnc:price-quotes-install-sources)]
In ice-9/eval.scm:
 386: 2 [eval # ()]
 393: 1 [eval # ()]
In unknown file:
   ?: 0 [memoize-variable-access! # #]

ERROR: In procedure memoize-variable-access!:
ERROR: Unbound variable: gnc:price-quotes-install-sources

Any suggestions or help would be great.

Best regards,
Joe


From: gnucash-user  
on behalf of Joe Peters 
Sent: November 4, 2018 3:24 PM
To: gnucash-user@gnucash.org
Subject: [GNC] gnucash: Not able to get Online Quotes to work

When trying to edit a security, in the 'Edit Security' window, under 'Quote 
Source Information', everything is grayed out and there is a warning: '> 
Warning: Finance::Quote not installed properly. <.


GnuCash Help|About
Version: 3.2
Build ID: 3.2+ (2018-06-24)
Finance::Quote: -


  *   I am running linux mint 19 cinnamon

  *   I have set ALPHAVANTAGE_API_KEY=*## in 
/etc/gnucash/environment. Where ### is my actual key number.*

  *   I have the same key number entered in the preferences tab of gnucash.
  *   I can run (in terminal window) (i exported the ALPHAVANTAGE_API_KEY in 
the .bashrc file)

gnc-fq-dump alphavantage msft

Finance::Quote fields Gnucash uses:

symbol: msft <=== required

date: 11/01/2018 <=== recommended

currency: USD <=== required

last: 106.3700 <=\

nav: <=== one of these

price: <=/

timezone: <=== optional


Any help would be greatly appreciated. I have run out of ideas to solve this 
problem.


Thanks,

Joe

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Stephen M. Butler

On 11/5/18 7:42 AM, btrib wrote:

True! ...however, text editor is unable to open the main data file. How can
the main file be manually accessed?


Uncompress the file.  Your OS should have a utility that can do that.  
On Linux I would use gunzip.



--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Colin Law
On Mon, 5 Nov 2018 at 19:11, btrib  wrote:
>
> So, I'm just trying to understand, I deactivate compression and this makes
> the file openable as xml?

It would be quicker to try it than ask, but yes.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fedora => Debian 3.2 => 2.1.15 Data Conversion Issues

2018-11-05 Thread Wolfram Wagner
Hello Adrien,

Thanks for your help. I forgot flatpak at all.

As flatpak means (almost) no influence on the other packages, I try
this first. I installed it already, found that all my needed features
work (including banking data exchange). The only issue I see, is that
gnucash came up in an US american locale. I have changed all settings
to EUR, but found no way to enable the German translations.

I have to do half of my work in English, so this is not a big issue, as
long as there is no issue with the reports... I need to check further.

Thank you!
Wolfram

Am Sonntag, den 04.11.2018, 17:22 -0600 schrieb Adrien Monteleone:
> A slight correction to my earlier post...
> 
> You don’t need to build to obtain 3.3.
> 
> As you can see from the .deb files listed, Sid contains 3.3 already.
> 
> Regards,
> Adrien
> 
> > On Nov 4, 2018, at 3:33 PM, Adrien Monteleone  > sfiber.net> wrote:
> > 
> > I’m not sure I’m following completely.
> > 
> > Are you saying you switched from Fedora using GnuCash 3.x to Debian
> > running GnuCash 2.6.15? (hopefully not 2.1.15 as that is ancient)
> > 
> > And that you want to open those newer data files on 2.6.15?
> > 
> > If that is the case, no, you cannot as you’ve discovered. I don’t
> > know of any way to ‘downgrade’ the data file.
> > 
> > You then need to at least install 2.6.21 in Debian. (2.6.19 and
> > 2.6.20 had some bugs but both can open 3.x files)
> > 
> > Here are your options:
> > 
> > 1)Sid - Someone else recently reported here on the list they’ve
> > done just that with version 3.2. They also had to install a couple
> > of other packages. You don’t need to change the repo, just download
> > the .deb files and install those. (you *can* change the repo and
> > pin everything else, but that’s a mess to maintain) Here are the
> > files needed:
> > 
> > libboost-regex1.62.0_1.62.0+dfsg-8_amd64.deb
> > gnucash-common_3.3-2_all.deb
> > gnucash_3.3-2_amd64.deb
> > 
> > It’s probably best to install in that order.
> > 
> > 2)Build - really not that bad. There are several of us here on the
> > list that can help. This so far is the only way to get 3.3 or
> > later.
> > 
> > 3)Export-Import - won’t work. While the 3.x series can contemplate
> > and properly import its own exports, the older versions cannot.
> > 
> > 4)Flatpak - I think this is still at version 3.2, it is an option,
> > but there are some known issues dealing with storing your file on
> > an external or network drive. (due to how flatpak apps are
> > sandboxed) There are some work arounds, but the installing from Sid
> > or building yourself will likely provide less headaches.
> > 
> > Regards,
> > Adrien
> > 
> > 
> > > On Nov 4, 2018, at 12:09 PM, Wolfram Wagner 
> > > wrote:
> > > 
> > > Dear list,
> > > After a server break down and huge problems to save my data over
> > > the
> > > necessary re-install, I moved away from fedora to debian.
> > > 
> > > I am lucky here, but there is a big issue. One of my two gnucash
> > > databases cannot be opened in version 2.1.15 because of "use
> > > account
> > > GUID as key in bayesian filter and store KVP flat...min. 2.1.19"
> > > 
> > > I habe tried to solve it in several ways:
> > > (1) Install the compatible package from sid / instable:
> > > This would require to bring many packages to this new level and
> > > many
> > > updates as well as other issues.
> > > 
> > > (2) Build gnucash from source
> > > I have started and I am frightened to go on. Too many new steps
> > > for me.
> > > Maybe I try later, if I am forced to.
> > > 
> > > (3) Export and Import
> > > I exported the hierarchy and the transactions to csv and found
> > > that
> > > although I can export all transactions and all accounts in one
> > > step,
> > > the import asks for files, account by account. Additional it
> > > seems not
> > > to recognize its own export format.
> > > This disappoints me, but may have to do with the different
> > > software
> > > versions. In general, this is something to improve.
> > > 
> > > => Is there anything that I can do to make the database downgrade
> > > compatible? My other database can be opened. It does not use
> > > Online
> > > Banking.
> > > I still have fedora and the new version on one of my computers. I
> > > still
> > > can modify the database...
> > > 
> > > => Would it help to remove all traces of the online banking
> > > configuration from the file?
> > > 
> > > => Is my only chance to update the software somehow?
> > > 
> > > Thank you!
> > > Wolfram
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see https://wiki.gnucash
> > > .org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > > 

Re: [GNC] Accounting for Refund

2018-11-05 Thread Eric Rathhaus office
Thank you, Geert.

Kind regards,

Eric W. Rathhaus
Law Office of Eric W. Rathhaus
484 Lake Park Avenue, Suite 50
Oakland, CA 94610
415.577.0920 tel
415.737.0603 fax

www.ewrlaw.com

Confidentiality : 

The information contained in this message is legally privileged and 
confidential information intended only for the use of the addressee(s) named 
above.  If the reader of this message is not the intended recipient, please be 
advised that any dissemination, distribution, or copy of the information in 
this message, and/or the name(s) of the person(s) it is addressed to, is 
prohibited.  If you have received this message in error, please notify us by 
returning this email to us.  If that is not possible, we will reimburse you for 
any costs in returning this message to us through other means.



> On Nov 5, 2018, at 12:27 PM, Geert Janssens  
> wrote:
> 
> Op maandag 5 november 2018 20:00:54 CET schreef Eric Rathhaus office:
>> Hello - I need to refund a client for pre-paid expenses I didn’t end up
>> incurring.  I could just cut a check and account for it as an expense.  But
>> as these payments came from multiple invoices and jobs, I would like to
>> have some method for creating a note to identify the various expense
>> payments I’m refunding.  Credit notes only exist for employees.
> 
> Credit notes exist for customers, vendors and employees. Unfortunately the 
> menu names are a bit misleading.*
> 
> If you select Business->Customer->New Invoice you can choose to create either 
> an invoice or a credit note.
> 
>> Would I go
>> back to each invoice and revise the payments to account for refund from
>> each invoice and send updated invoice along with the check?  Thanks.
> 
> That shouldn't be necessary as you can create a credit note for a customer.
> 
> Regards,
> 
> Geert
> 
> * This is a historical artifact. There has been some discussion when the 
> credit note feature got added, but at the time no consensus was reached about 
> how to organize the menus. And at some point it was forgotten. We really 
> should fix this. Meanwhile a credit note can be created via New Invoice...
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting for Refund

2018-11-05 Thread Geert Janssens
Op maandag 5 november 2018 20:00:54 CET schreef Eric Rathhaus office:
> Hello - I need to refund a client for pre-paid expenses I didn’t end up
> incurring.  I could just cut a check and account for it as an expense.  But
> as these payments came from multiple invoices and jobs, I would like to
> have some method for creating a note to identify the various expense
> payments I’m refunding.  Credit notes only exist for employees.

Credit notes exist for customers, vendors and employees. Unfortunately the 
menu names are a bit misleading.*

If you select Business->Customer->New Invoice you can choose to create either 
an invoice or a credit note.

> Would I go
> back to each invoice and revise the payments to account for refund from
> each invoice and send updated invoice along with the check?  Thanks.

That shouldn't be necessary as you can create a credit note for a customer.

Regards,

Geert

* This is a historical artifact. There has been some discussion when the 
credit note feature got added, but at the time no consensus was reached about 
how to organize the menus. And at some point it was forgotten. We really 
should fix this. Meanwhile a credit note can be created via New Invoice...


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Geert Janssens
Op maandag 5 november 2018 20:15:00 CET schreef btrib:
> Update! The problem is restricted to a malfunction with the date format in
> the 2.6.16 version. Specifically, the program will allow the user to proceed
> with import in the default format /MM/DD despite the CSV transaction
> dates being formatted as MM/DD/. This is what causes the program to
> crash. In the new stable version 3.3 the importer provides user feedback to
> correct the date and does not allow the import to proceed until fixed.

I'm glad you found the issue and got it working.

Note the original reporter *was* using gnucash 3.3. So I assumed you did as 
well when you jumped in...

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread btrib
Update! The problem is restricted to a malfunction with the date format in
the 2.6.16 version. Specifically, the program will allow the user to proceed
with import in the default format /MM/DD despite the CSV transaction
dates being formatted as MM/DD/. This is what causes the program to
crash. In the new stable version 3.3 the importer provides user feedback to
correct the date and does not allow the import to proceed until fixed.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash 3.x corrupts data file

2018-11-05 Thread Jörg Schaible
Hi David,

On Mon, 05 Nov 2018 02:30:39 + David T. via gnucash-user wrote:

> Jörg,
> Frank points you to the spurious date that is likely the source of your
> trouble.

I guessed also.

> I believe that at some point, the developers put in a data
> check into the upgrade process, to prevent errors from propagating
> forward, which would explain the problem arising now.

That check seems not in place when a file from an older version is silently 
converted and when the file is 
written ... :-/

> Perhaps you could
> manually add a '3' after '201' before reopening the file.

I already tried this (but with 2018) and gnucash 3.3 still failed to open the 
file. But that was before I compared 
the old and new file and recognized that the new version also removes the 
date-posted element (at least 
when the value seems to correlate with 0).

...


But you were right. After correcting the gdate to 2013-01-02 and adding a 
matching date-posted element, I 
could read the file with the latest version 3.3.

Thanks,
Jörg

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread btrib
So, I'm just trying to understand, I deactivate compression and this makes
the file openable as xml?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Inaccurate balance on credit card account

2018-11-05 Thread Gerry Starnes
Hello,

Having just reconciled my credit card account, I see that I have a fairly
wildly inaccurate balance shown. The actual balance of entries should be
$204.81 but shows to be $1075.45. That's off by $870.64. I'm not sure how
long this has been going on, but I don't remember a discrepancy like that
in the past.

I'm not asking what happened, but rather what do I need to do to correct
this?

I'm using version 2.6.18. I have 3.3-1 but have not updated since I want to
make sure everything is lined up correctly first.

Thanks

Gerry
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Accounting for Refund

2018-11-05 Thread Eric Rathhaus office
Hello - I need to refund a client for pre-paid expenses I didn’t end up 
incurring.  I could just cut a check and account for it as an expense.  But as 
these payments came from multiple invoices and jobs, I would like to have some 
method for creating a note to identify the various expense payments I’m 
refunding.  Credit notes only exist for employees.  Would I go back to each 
invoice and revise the payments to account for refund from each invoice and 
send updated invoice along with the check?  Thanks.  

Kind regards,

Eric W. Rathhaus
Law Office of Eric W. Rathhaus
484 Lake Park Avenue, Suite 50
Oakland, CA 94610
415.577.0920 tel
415.737.0603 fax

www.ewrlaw.com

Confidentiality : 

The information contained in this message is legally privileged and 
confidential information intended only for the use of the addressee(s) named 
above.  If the reader of this message is not the intended recipient, please be 
advised that any dissemination, distribution, or copy of the information in 
this message, and/or the name(s) of the person(s) it is addressed to, is 
prohibited.  If you have received this message in error, please notify us by 
returning this email to us.  If that is not possible, we will reimburse you for 
any costs in returning this message to us through other means.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread btrib
Is there a setting to save and make backups automatically? I've looked but
cannot find.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash 3.x corrupts data file

2018-11-05 Thread Jörg Schaible
On Mon, 05 Nov 2018 03:04:29 +0100 Frank H. Ellenberger wrote:

> Hi Jörg,
> 
> Am 05.11.18 um 01:31 schrieb Jörg Schaible:
>> When I start gnucash from the console, it will print an entry of the
>> data file, when the dialog appears:
>> 
>>  
>>e1822daceb8b84988373e0df77f579cf
>>
>>  CURRENCY EUR
>>
>>
>>  2013-01-26 19:28:12 +0100
>>
>>
>>
>>  
>>date-posted
>>
>>  201-01-02
> Are you sure about this ^ date?

[snip]

Yes. I don't know how gnucash managed to add this, but one of the used versions 
from 1.7.x to 2.7.4 in the 
last decade must have been able to do so ;-)

Cheers,
Jörg

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql backend, second user (lock, for example)

2018-11-05 Thread Phil Longstaff
That may work fine for a single instance of gnucash. However, it this is 2
instances of gnucash on 2 separate computers, does libdbi provide any
notification mechanism to notify gnucash on computer #2 that computer #1
has written to the db?

On Mon, Nov 5, 2018 at 2:39 AM craigarno  wrote:

> Geert Janssens-4 wrote
> > Op zondag 4 november 2018 14:49:22 CET schreef craigarno:
> >> Geert Janssens-4 wrote
> >>
> > Whether it can work depends on
> > whether the db layer we rely on has a notification mechanism for db
> > changes we
> > can hook into. The current db layer is provided by libdbi, which is not
> > managed by the gnucash team and I haven't looked into this yet.
>
> If your call to libdbi is in the same thread and is a blocking call for
> synchronous operation, then there shouldn't be a problem with updating
> views
> after successful return from the libdbi call.  Otherwise you may have to
> look for semaphors to signal.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Expenses on Credit Card account do not appear on cash flow report

2018-11-05 Thread Derek Atkins
Felipe Ferri  writes:

> Hello all,
>
> I'm new to this forum, though I've been using GnuCash for several years
> now. I've learned how to use the Cash Flow report only recently, though.
>
> There is something weird happening. I have a Credit Card account, and I
> expected that all expenses from this appeared on the Cash Flow report as
> expenses on their respective categories, however instead on the section
> "Money out of selected accounts goes to" there is a row for the Credit Card
> with the total amount spent for that period.
>
> Any hints on how to solve or debug this?

Run a P report instead of a Cash Flow report.

> I tried creating a new account from scratch, created a credit card account
> and in this empty account the cash flow report worked as it should, showing
> the expenses categories.
>
> I'm using version 3.3 on macos.
>
> Thank you!

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Colin Law
n Mon, 5 Nov 2018 at 15:47, btrib  wrote:
>
> True! ...however, text editor is unable to open the main data file. How can
> the main file be manually accessed?

In Edit > Preferences > General under Files clear the Compress Files
checkbox.  Then save it as xml and you will be able to edit it.  That
setting only affects what happens when a file is saved.  Once you have
it all working then you tick the box and next time it is saved it will
be compressed again.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Below are my screen shots in .pdf format/previously they were .png files which did not go thru

2018-11-05 Thread Michael or Penny Novack

On 11/5/2018 5:08 AM, Colin Law wrote:

On Mon, 5 Nov 2018 at 09:40, Anita Graves via gnucash-user
 wrote:

Dear Geniuses,

I primarily want to know how to get rid of this .LNK file and unlock my gnucash 
program so that I can use it again.

You do not need to get rid of it.
 However . manually deleting it IS an option. But if you need help 
how to do that, far more basic than gnucash. You are asking, "given the 
operating system I am using, how do I find a file and how do I delete a 
file?"


BUT --- the existence of those .lck and .lnk files are NOT "locking 
gnucash" (not locking the PROGRAM). The are locking (from the program) 
the corresponding DATA file, not allowing the program to open THAT data 
file. You only perceive it as locking the program because you don't have 
OTHER gnucash data files (other sets of books).


Michael D Novack
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread btrib
True! ...however, text editor is unable to open the main data file. How can
the main file be manually accessed? 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-05 Thread Michael or Penny Novack

On 11/4/2018 9:10 PM, David T. via gnucash-user wrote:

As others explained, the lck and lnk files are created by gnucash to prevent 
users accidentally opening the data file on multiple machines. They are zero 
bytes in size and there is no point in trying to open them up. There is no 
there there.
  

Sometimes it can help people remember if they are told why.

Why a file with no data? The lock file isn't intended to be OPENED. Only 
its EXISTENCE is being tested. That's what it is there for. If it 
exists, then some instance of the program has the corresponding data 
file open. When gnucash is about to open a data file, it creates a 
corresponding lock file, and when it closes that data file, it deletes 
the lock file. The existence of a lock file (for some data file) means 
that an instance of the program "owns" that data file, and no other 
instance of the program can touch it.


Why this way? Because a program can check for the existence of a file 
even if not allowed to open that file.


Of course if the program (or the system) crashes before the program 
closes a file and deletes the lock a lock file can get left behind.


Michael D Novack
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Expenses on Credit Card account do not appear on cash flow report

2018-11-05 Thread Felipe Ferri
Hello all,

I'm new to this forum, though I've been using GnuCash for several years
now. I've learned how to use the Cash Flow report only recently, though.

There is something weird happening. I have a Credit Card account, and I
expected that all expenses from this appeared on the Cash Flow report as
expenses on their respective categories, however instead on the section
"Money out of selected accounts goes to" there is a row for the Credit Card
with the total amount spent for that period.

Any hints on how to solve or debug this?

I tried creating a new account from scratch, created a credit card account
and in this empty account the cash flow report worked as it should, showing
the expenses categories.

I'm using version 3.3 on macos.

Thank you!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Below are my screen shots in .pdf format/previously they were .png files which did not go thru

2018-11-05 Thread Geert Janssens
Op maandag 5 november 2018 12:54:19 CET schreef Flyeta via gnucash-user:
> From Anita’s screenshots, I believe she has inadvertently selected
> “View>Show Tab Bar”  and can remove that extraneous (because the active
> Gnucash file already displays in the window title bar) bar by selecting
> “View>Hide Tab Bar”.
> 
> I do note that for me, if the “Tab Bar”—which isn’t really a tab bar, just
> another title bar—is showing, it throws off the clicks clicks in the
> Accounts list. Double-click on the name of an account and the one that
> opens is the one immediately below the one you clicked on (just about the
> distance of the height of the tab bar). It’s very tricky, especially to
> open/close a parent account group.
> 
> Andrew

Indeed the Apple "Tab Bar" is known to cause coordinate issues in gnucash.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Below are my screen shots in .pdf format/previously they were .png files which did not go thru

2018-11-05 Thread Flyeta via gnucash-user
From Anita’s screenshots, I believe she has inadvertently selected “View>Show 
Tab Bar”  and can remove that extraneous (because the active Gnucash file 
already displays in the window title bar) bar by selecting “View>Hide Tab Bar”. 

I do note that for me, if the “Tab Bar”—which isn’t really a tab bar, just 
another title bar—is showing, it throws off the clicks clicks in the Accounts 
list. Double-click on the name of an account and the one that opens is the one 
immediately below the one you clicked on (just about the distance of the height 
of the tab bar). It’s very tricky, especially to open/close a parent account 
group.

Andrew


> On Nov 5, 2018, at 5:51 AM, Maf. King  wrote:
> 
> Anita said yesterday that she manually deleted the .LCK in her file manager 
> and 
> then GC was back to normal next time she started it.
> 
> I still don't understand what the problem was and why she had 2 
> "super-imposed 
> GC windows", but it seems to be solved...  
> 
> I think these emails with screenshots have been delayed somewhere getting 
> through the list.
> 
> Maf.
> 
> 
> 
> 
> On Monday, 5 November 2018 10:08:44 GMT Colin Law wrote:
>> On Mon, 5 Nov 2018 at 09:40, Anita Graves via gnucash-user
>> 
>>  wrote:
>>> Dear Geniuses,
>>> 
>>> I primarily want to know how to get rid of this .LNK file and unlock my
>>> gnucash program so that I can use it again.
>> You do not need to get rid of it.  Open Gnucash and close any warning
>> messages you get.  Then, inside Gnucash, use File > Open and double
>> click on the line above the one you have highlighted in the
>> attachment. I presume that double click works on a Mac in the file
>> open dialog.  If not then click it and then Open or similar.  Note -
>> very important - do it from *inside* gnucash after clearing any popups
>> that appear when you open gnucash.
>> 
>> If that does not work come back and tell us *exactly* what happened
>> when you followed these instructions.
>> 
>> Colin
> 
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Below are my screen shots in .pdf format/previously they were .png files which did not go thru

2018-11-05 Thread Maf. King
Anita said yesterday that she manually deleted the .LCK in her file manager and 
then GC was back to normal next time she started it.

I still don't understand what the problem was and why she had 2 "super-imposed 
GC windows", but it seems to be solved...  

I think these emails with screenshots have been delayed somewhere getting 
through the list.

Maf.




On Monday, 5 November 2018 10:08:44 GMT Colin Law wrote:
> On Mon, 5 Nov 2018 at 09:40, Anita Graves via gnucash-user
> 
>  wrote:
> > Dear Geniuses,
> > 
> > I primarily want to know how to get rid of this .LNK file and unlock my
> > gnucash program so that I can use it again.
> You do not need to get rid of it.  Open Gnucash and close any warning
> messages you get.  Then, inside Gnucash, use File > Open and double
> click on the line above the one you have highlighted in the
> attachment. I presume that double click works on a Mac in the file
> open dialog.  If not then click it and then Open or similar.  Note -
> very important - do it from *inside* gnucash after clearing any popups
> that appear when you open gnucash.
> 
> If that does not work come back and tell us *exactly* what happened
> when you followed these instructions.
> 
> Colin




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Below are my screen shots in .pdf format/previously they were .png files which did not go thru

2018-11-05 Thread Colin Law
On Mon, 5 Nov 2018 at 09:40, Anita Graves via gnucash-user
 wrote:
>
> Dear Geniuses,
>
> I primarily want to know how to get rid of this .LNK file and unlock my 
> gnucash program so that I can use it again.

You do not need to get rid of it.  Open Gnucash and close any warning
messages you get.  Then, inside Gnucash, use File > Open and double
click on the line above the one you have highlighted in the
attachment. I presume that double click works on a Mac in the file
open dialog.  If not then click it and then Open or similar.  Note -
very important - do it from *inside* gnucash after clearing any popups
that appear when you open gnucash.

If that does not work come back and tell us *exactly* what happened
when you followed these instructions.

Colin
>
> Anita
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Geert Janssens
Op zondag 4 november 2018 22:40:59 CET schreef btrib:
> Agreed. OFX/QIF works perfect. My CSV import did not only freeze but crashed
> the program and caused me to lose a large amount of data. Hundreds of asset
> transactions plus one entire liability account as well as several dozens of
> invoices -- all gone. CSV import has huge problems, stay away from any CSV
> importing at all costs. I wish there was a way to disable or remove it from
> the menu. It's by far the worst thing that's ever happened to my GnuCash
> data.

I'm sorry you had such a poor experience with the CSV importer and I'm glad 
you were able to recover most of your data (as I read in the remainder of the 
thread).

However none of this helps me in any way to improve the CSV importer. I 
completely agree it shouldn't crash or make you lose data. But I'll need more 
details to figure out why it crashed.

If you can consistently reproduce it, may I ask you to create a bug report in 
our Bugzilla instance [1] and supply the details needed for me to reproduce it 
as well ? Ideally, attach a simple test file and a small csv file that 
triggers the crash. Or a large csv file if that's what's needed to make it 
crash.

For the record, I can successfully run the csv importer with a csv file 
containing about 2000 transactions. It's a bit slow, but not out of the 
ordinary (15 to 20 seconds of delays). So clearly the size of the csv file 
itself is not the only factor and my test setup is not having what is needed 
to induce the crash.

Regards,

Geert

[1] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our bug 
tracker


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Hide Num Column in Basic Ledger

2018-11-05 Thread Geert Janssens
Op maandag 5 november 2018 01:10:08 CET schreef Rares Vernica:
> Hello,
> 
> Is it possible to hide the Num column in Basic Ledger. I can drag the Num
> column header and make it not show, but it is till there when I step from
> column to column with TAB. Is there a way to configure GnuCash so that it
> totally hides (or hides from TAB as well). Ideally, it would also be a
> global setting so I don't have to do it in each account.
> 
> Thanks!
> Rares

Unfortunately there isn't. Making the column very small is the closest work 
around I know.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.