[GNC] Importfunktion geändert? Herkunftskonto

[Paul Neuwirth via gnucash-user]

Hallo,

ich habe ein Problem beim Import von CSV-Buchungen.

Ich war es gewohnt über "Datei->Importieren->Buchungen importieren aus 
CSV..." und der Angabe des Formats (Datu, Beschreibung, Buchungstext, 
Einzahlung, Buchungswährung,Konto) und klick auf Weiter für jede Buchung 
das Gegenkonto manuell auswählen zu können.


Nun verlangt der Importassistent zwingend ein Herkunftskonto in der CSV?
"Weiter" ist ausgegraut, "- Bitte wählen Sie eine Herkunftskonto-Spalte 
oder entfernen Sie die anderen Spalten."


Habe zum Test als Herkunftskonto ein Ausgleichskonto gewählt, beim 
Import-Schritt "Buchungen zuordnen" später, kann ich aber nicht, wie 
früher gewohnt, das Gegenkonto zu wählen..


Mache ich etwas falsch? Oder ist die Änderung so tatsächlich gewollt?
Ich habe das Problem nach einer Neuinstallation von gnuCash 3.7. Zuvor 
war, wenn ich mich nicht täusche 3.0 im Einsatz.



Vielen Dank für Tipps/Hinweise


Paul Neuwirth
___
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] Migration from 2.6 to 3.0 with mysql/mariadb

[Paul Neuwirth via gnucash-user]

Hello,
I "accidently" upgraded to 3.0 and on startup, I got the message,
database was errernous or corrupted.
Could not see any corrosponding messages on console.
Using mariadb, working great with 2.6. 
I thought, when running 3.0 the first time database would be converted?

switching to 3.0 is planned after finishing some tax stuff this month.

maybe best way is backing up database, saving to xml, import to 3.0 and
save in (new) database again?

Thank you

Paul
___
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] switched to mariadb

[Paul Neuwirth]

Hi,
I think this is a bug. where to report? anyone knows a
workaround/config for that? Or shall I create and suggest a patch on my
own?

I made a transfer and saving to database failed:
mysql error: Incorrect datetime value: '1970010100' for column
'timespec_val' at row 1 mysql error: Incorrect datetime value:
'1970010100' for column 'reconcile_date' at row 1

I think the function STR_TO_DATE in the query is missing.


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: MySQL Server connection timeout or keep-alive

[Paul Neuwirth]

On Tuesday 2018-04-03 22:06, Colin Law wrote:


Date: Tue, 3 Apr 2018 22:06:08
From: Colin Law <clan...@gmail.com>
To: Paul Neuwirth <m...@paul-neuwirth.nl>
Cc: John Ralls <jra...@ceridwen.us>, gnucash-user <gnucash-user@gnucash.org>
Subject: Re: MySQL Server connection timeout or keep-alive

On 3 April 2018 at 19:40, Paul Neuwirth <m...@paul-neuwirth.nl> wrote:


...

I am wondering, if no keep-alive is going to be implemented, if a
connection loss could be catched and connect again..
the error message is:
"Unable to save to database."



That is not unreasonable on connection loss. What happens after that?

Colin



Indeed, I did not try yet. I always restarted gnucash when it happened.
___
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: MySQL Server connection timeout or keep-alive

[Paul Neuwirth]

> >> Hello,
> >> is it possible to change somewhere the connection timeout to a
> >> MySQL server on the client side?
> >> Or could it be possible to implement a keep-alive?
> >> Everytime the connection is lost, I need to restart gnucash.  
> >
> > I don't think that it's possible from the client. IIUC (and I'm not
> > a MySQL expert, but if you're using it you should be or you should
> > hire one) it's a server-side parameter called wait_timeout.
> >
> > No, we're not going to add a keep-alive.
> > https://stackoverflow.com/questions/23399111/safely-keeping-mysql-connections-alive
> > says that a connection pool is the right way to handle this, but
> > the database abstraction library we use doesn't support that so
> > it's not going to get added any time soon.  
> 
> However if GnuCash fails in a non-recoverable way when you lose the
> connection I would have thought that would be a bug.  What exact
> symptom are you seeing?
> 
> Colin

I am wondering, if no keep-alive is going to be implemented, if a
connection loss could be catched and connect again..
the error message is:
"Unable to save to database."

regards,
paul
___
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.

MySQL Server connection timeout or keep-alive

[Paul Neuwirth]

Hello,
is it possible to change somewhere the connection timeout to a MySQL
server on the client side?
Or could it be possible to implement a keep-alive?
Everytime the connection is lost, I need to restart gnucash.
Thank you
Paul
___
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: How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

[Paul Neuwirth]

On Thu, 4 Jan 2018 06:05:02 +0100
Paul Neuwirth <m...@paul-neuwirth.nl> wrote:

> On Wed, 03 Jan 2018 13:45:46 -0500
> Derek Atkins <warl...@mit.edu> wrote:
> 
> > Hi,
> > 
> > Paul Neuwirth <m...@paul-neuwirth.nl> writes:
> >   
> > > Hello,
> > > I always get "Could not determine the account currency. Using the
> > > default currency provided by your system." when opening an account
> > > since upgrade to 2.6.19.
> > > according to SQL 
> > > SELECT * FROM gnucash.accounts a left join gnucash.commodities c
> > > on c.guid = a.commodity_guid;
> > > all accounts have a currency set.
> > >
> > > Book Option "Use Trading Accounts" is off
> > > Preferences Accounts, Default Currency is set (choose: EUR)
> > >
> > > what am I missing?
> > 
> > What type of account is it?
> > Specifically, is it a stock/mutual fund account?
> > If so, is it a top-level account?
> > 
> > Stock/Mutual accounts need to be children of an Asset with a
> > currency.  
> 
> Thank you.
> it was any account, any type and everywhere was Euro (EUR) set (not
> changable in dialog).. I saw in the mysql table commodities, EUR
> defined twice. when I imported transactions duplicate accounts where
> made with the "other EUR currency". I replaced old commodity-guids in
> all tables by the new guid..
> 
> update gnucash.transactions set
> currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.accounts set
> commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
> = 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.customers set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.invoices set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
> currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
> commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
> = 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.vendors set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; 
> 
> and deleted the old EUR currency... 
> now everything is fine.. 
> 
Now I have the same issue with all foreign currency accounts...

Execute:
> SELECT * FROM gnucash.commodities

+ - + -- + - + - + -- + 
- + --- + - + - +
| guid  | namespace  | mnemonic  | fullname  | cusip  | 
fraction  | quote_flag  | quote_source  | quote_tz  |
+ - + -- + - + - + -- + 
- + --- + - + - +
| 090f9175bf272d914fc77cf8990ddde8 | CURRENCY   | USD   | US-Dollar 
| 840| 100   | 1   | currency  |
   |
| 1669bedf79e858ba5ec3358346eee9b1 | CURRENCY   | ZWL   | 
Simbabwe-Dollar | 716| 100   | 0   | currency   
   |   |
| 2d24b3b5c4ac803f1ef048f43801905c | CURRENCY   | GBP   | Pfund 
Sterling | 826| 100   | 1   | currency  |   
|
| 2e2395017967d7799120dc8585cf4080 | CURRENCY   | EUR   | Euro  
| 978| 100   | 1   | currency  |
   |
| 4636ac6477efed452967bdb61c4a46ff | CURRENCY   | PLN   | Zloty 
| 985| 100   | 1   | currency  |
   |
| aad29cfc8037ac37b0a30fb16fad538a | template   | template  | template  
| template   | 1 | 0   |   |
   |
| bc7184bbbdac77765e615d7a3e2547d3 | CURRENCY   | USD   | US-Dollar 
| 840| 100   | 1   | currency  |
   |
| NULL  | NULL   | NULL  | NULL  | NULL   | 
NULL  | NULL| NULL  | NULL  |
+ - + -- + - + - + -- + 
- + --- + - + - + 8 rows

what is bad at first entry for USD (old accounts), but new want the
last line's USD...
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

[Paul Neuwirth]

On Wed, 03 Jan 2018 13:45:46 -0500
Derek Atkins <warl...@mit.edu> wrote:

> Hi,
> 
> Paul Neuwirth <m...@paul-neuwirth.nl> writes:
> 
> > Hello,
> > I always get "Could not determine the account currency. Using the
> > default currency provided by your system." when opening an account
> > since upgrade to 2.6.19.
> > according to SQL 
> > SELECT * FROM gnucash.accounts a left join gnucash.commodities c on
> > c.guid = a.commodity_guid;
> > all accounts have a currency set.
> >
> > Book Option "Use Trading Accounts" is off
> > Preferences Accounts, Default Currency is set (choose: EUR)
> >
> > what am I missing?  
> 
> What type of account is it?
> Specifically, is it a stock/mutual fund account?
> If so, is it a top-level account?
> 
> Stock/Mutual accounts need to be children of an Asset with a currency.

Thank you.
it was any account, any type and everywhere was Euro (EUR) set (not
changable in dialog).. I saw in the mysql table commodities, EUR defined
twice. when I imported transactions duplicate accounts where made with
the "other EUR currency". I replaced old commodity-guids in all tables
by the new guid..

update gnucash.transactions set
currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.accounts set
commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
= 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.customers set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.invoices set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
= 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.vendors set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; 

and deleted the old EUR currency... 
now everything is fine.. 

> 
> > Any help appreciated.
> >
> > Happy new year,
> >
> > Paul  
> 
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.  
> 
> -derek
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: import transactions from CSV with mutiple accounts

[Paul Neuwirth]

On Wed, 3 Jan 2018 12:40:13 +0100
Paul Neuwirth <m...@paul-neuwirth.nl> wrote:

> On Sat, 30 Dec 2017 17:03:13 +0100
> Geert Janssens <geert.gnuc...@kobaltwit.be> wrote:
> 
> > Op zaterdag 30 december 2017 16:20:53 CET schreef Paul Neuwirth:  
> > > Hi List,
> > > 
> > > I hope someone can give me a hint. Is it a bug of the importer or
> > > am I doing something wrong? Or is there a tool which converts csv
> > > to qif or other advanced format?
> > > I have a CSV file with transactions of different bank accounts
> > > (ca. 12 bank accounts, export from banking software moneyplex).
> > > If I import csv files with only transactions of one account,
> > > gnucash selects (automatically) the correct account (slot
> > > 'online-id' of account is identically to account number in csv).
> > > But if I do import transactions belonging to different accounts,
> > > all transactions are being imported into the account of the first
> > > line in the csv.
> > > This does not make any sense for me, as you can select account as
> > > a column...
> > > 
> > > It would be quiet unconvinient to do seperate imports for every
> > > account. On the other side (moneyplex) does have advanced export
> > > functions, but not for transactions of multiple accounts (therefor
> > > only search results can be exported to csv or xml)..
> > 
> > Hi Paul,
> > 
> > I don't think the csv importer was designed with your use case in
> > mind. I believe it was written to import transactions one bank
> > account at the time.
> > 
> > So for the 2.6 series unfortunately you will have to live with this 
> > limitation. There are some tools floating around on the net for
> > converting csv files to qif, or more exactly LibreOffice Calc to qif
> > or Excel to qif (but both applications should be able to open csv
> > files just fine).
> > 
> > For gnucash 3.0 (to be released in a couple of months) the csv
> > importer has been rewritten and the new one should be able to handle
> > csv files in your format just fine.
> > 
> > Regards,
> > 
> > Geert  
> 
> thank you very much for the hints. I am about gnucash 3.0..
> Just wrote a script to generate a QIF file from moneyplex search
> result csvs.. pretty simple and working :)
> 
> I whis you a prosperous new year 
> 
> Paul

exasperating...
glad qif import works.. but (compared to csv import, with very helfull
aditional screen..) correlation is not done.. bunch of duplicates now.. 
but i do not give up hope.. best way right now is doing csv
import account by account.. :-/
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: import transactions from CSV with mutiple accounts

[Paul Neuwirth]

On Sat, 30 Dec 2017 17:03:13 +0100
Geert Janssens <geert.gnuc...@kobaltwit.be> wrote:

> Op zaterdag 30 december 2017 16:20:53 CET schreef Paul Neuwirth:
> > Hi List,
> > 
> > I hope someone can give me a hint. Is it a bug of the importer or
> > am I doing something wrong? Or is there a tool which converts csv
> > to qif or other advanced format?
> > I have a CSV file with transactions of different bank accounts (ca.
> > 12 bank accounts, export from banking software moneyplex).
> > If I import csv files with only transactions of one account, gnucash
> > selects (automatically) the correct account (slot 'online-id' of
> > account is identically to account number in csv).
> > But if I do import transactions belonging to different accounts, all
> > transactions are being imported into the account of the first line
> > in the csv.
> > This does not make any sense for me, as you can select account as a
> > column...
> > 
> > It would be quiet unconvinient to do seperate imports for every
> > account. On the other side (moneyplex) does have advanced export
> > functions, but not for transactions of multiple accounts (therefor
> > only search results can be exported to csv or xml)..  
> 
> Hi Paul,
> 
> I don't think the csv importer was designed with your use case in
> mind. I believe it was written to import transactions one bank
> account at the time.
> 
> So for the 2.6 series unfortunately you will have to live with this 
> limitation. There are some tools floating around on the net for
> converting csv files to qif, or more exactly LibreOffice Calc to qif
> or Excel to qif (but both applications should be able to open csv
> files just fine).
> 
> For gnucash 3.0 (to be released in a couple of months) the csv
> importer has been rewritten and the new one should be able to handle
> csv files in your format just fine.
> 
> Regards,
> 
> Geert

thank you very much for the hints. I am about gnucash 3.0..
Just wrote a script to generate a QIF file from moneyplex search result
csvs.. pretty simple and working :)

I whis you a prosperous new year 

Paul
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: bug (?) assigning payment to foreign current account

[Paul Neuwirth]

On Fri, 22 Dec 2017 12:35:47 +0100
Paul Neuwirth <m...@paul-neuwirth.nl> wrote:

> Hello,
> is it worth an official bug report, or am I doing something wrong?
> Everything worked, until I changed the type of a place holder account
> from A/Payable to Liability, it is the parent of the Account I was
> trying to book to. (but reverting the change does not fix)
> 
> Here are the screenshots, and description:
> (just noticed, the problem exists anywhere, where the corresponding
> dialog is used).
> right click on booking in bank account, assign as
> payment, select vendor, change amount from EUR (EUR 27.43) to value in
> GBP (GBP 23.99). https://www.swabian.net/extern/gncml/gnucash9.png
> 
> next dialog:
> message, that the currencies differ. that's ok
> https://www.swabian.net/extern/gncml/gnucash10.png
> 
> after clicking ok, it gets unnormal:
> https://www.swabian.net/extern/gncml/gnucash11.png
> the normally editable exchange rate fields are disabled.
> I can only press cancel (then nothing is being done) or click ok:
> 
> error, that It could not save to database
> https://www.swabian.net/extern/gncml/gnucash12.png
> the database error is:
> mysql error: Column 'commodity_guid' cannot be null
> 
> the entries become inconsistent:
> no values on the left side,
> on the other side the booking shows up normal (with correct value GBP
> 23.99).
> 
> 
> 
> It is reproducable, also using other currencies, like USD.
> the concerned accounts are configured as following:
> > SELECT
> > a.name,a.account_type,c.mnemonic,a.hidden,a.placeholder,p.name
> > parent FROM gnucash.accounts a join gnucash.commodities c 
>  on a.commodity_guid = c.guid 
>   left join gnucash.accounts p on p.guid=a.parent_guid
> where a.name IN ('Verbindlichkeiten','Passiva','1601 Verbindlichkeiten
> GBP','1602 Verbindlichkeiten USD','Privatkonten
> 1','Privatentnahmen/-einlagen','1802 private Mastercard') order by
> a.code
> 
>  1. row *
> name: Passiva
> account_type: LIABILITY
> mnemonic: EUR
>   hidden: 0
>  placeholder: 1
>   parent: Root Account
>  2. row *
> name: Verbindlichkeiten
> account_type: LIABILITY
> mnemonic: EUR
>   hidden: 1
>  placeholder: 1
>   parent: Passiva
>  3. row *
> name: Privatentnahmen/-einlagen
> account_type: BANK
> mnemonic: EUR
>   hidden: 0
>  placeholder: 0
>   parent: Privatkonten 1
>  4. row *
> name: Privatkonten 1
> account_type: BANK
> mnemonic: EUR
>   hidden: 0
>  placeholder: 1
>   parent: Root Account
>  5. row *
> name: 1601 Verbindlichkeiten GBP
> account_type: PAYABLE
> mnemonic: GBP
>   hidden: 0
>  placeholder: 0
>   parent: Verbindlichkeiten
>  6. row *
> name: 1602 Verbindlichkeiten USD
> account_type: PAYABLE
> mnemonic: USD
>   hidden: 0
>  placeholder: 0
>   parent: Verbindlichkeiten
>  7. row *
> name: 1802 private Mastercard
> account_type: BANK
> mnemonic: EUR
>   hidden: 0
>  placeholder: 0
>   parent: Privatentnahmen/-einlagen
> 7 rows in set
> 
> as I mentioned previously, all I did to let this not work anymore is
> changing account_type of "Verbindlichkeiten" (2nd row) from PAYABLE to
> LIABILITY - to avoid getting payments on this place holder account. I
> have now set it back (and restarted), but the misbehaviour stays.
> 
> installed gnucash (on openSUSE Leap 42.2)
> > zypper info gnucash
> Information for package gnucash:
> 
> Repository : Main Update Repository  
> Name   : gnucash 
> Version: 2.6.16-3.3.1
> Arch   : x86_64  
> Vendor : openSUSE
> Installed Size : 25.6 MiB
> Installed  : Yes 
> Status : up-to-date  
> Source package : gnucash-2.6.16-3.3.1.src
> Summary: Personal Finance Manager
> 
> can anyone reproduce? or understand?
> 
> Thank you
> 
> 

just remember, what I did change also...
to get rid of this damn german comma decimal seperator, i changed the
locale from de_DE to de_CH, system uses en_us, data is safed in
database.
I am wondering if, and how this could affect above?

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

bug (?) assigning payment to foreign current account

[Paul Neuwirth]

Hello,
is it worth an official bug report, or am I doing something wrong?
Everything worked, until I changed the type of a place holder account
from A/Payable to Liability, it is the parent of the Account I was
trying to book to. (but reverting the change does not fix)

Here are the screenshots, and description:
(just noticed, the problem exists anywhere, where the corresponding
dialog is used).
right click on booking in bank account, assign as
payment, select vendor, change amount from EUR (EUR 27.43) to value in
GBP (GBP 23.99). https://www.swabian.net/extern/gncml/gnucash9.png

next dialog:
message, that the currencies differ. that's ok
https://www.swabian.net/extern/gncml/gnucash10.png

after clicking ok, it gets unnormal:
https://www.swabian.net/extern/gncml/gnucash11.png
the normally editable exchange rate fields are disabled.
I can only press cancel (then nothing is being done) or click ok:

error, that It could not save to database
https://www.swabian.net/extern/gncml/gnucash12.png
the database error is:
mysql error: Column 'commodity_guid' cannot be null

the entries become inconsistent:
no values on the left side,
on the other side the booking shows up normal (with correct value GBP
23.99).



It is reproducable, also using other currencies, like USD.
the concerned accounts are configured as following:
> SELECT a.name,a.account_type,c.mnemonic,a.hidden,a.placeholder,p.name
> parent FROM gnucash.accounts a join gnucash.commodities c   
 on a.commodity_guid = c.guid 
  left join gnucash.accounts p on p.guid=a.parent_guid
where a.name IN ('Verbindlichkeiten','Passiva','1601 Verbindlichkeiten
GBP','1602 Verbindlichkeiten USD','Privatkonten
1','Privatentnahmen/-einlagen','1802 private Mastercard') order by
a.code

 1. row *
name: Passiva
account_type: LIABILITY
mnemonic: EUR
  hidden: 0
 placeholder: 1
  parent: Root Account
 2. row *
name: Verbindlichkeiten
account_type: LIABILITY
mnemonic: EUR
  hidden: 1
 placeholder: 1
  parent: Passiva
 3. row *
name: Privatentnahmen/-einlagen
account_type: BANK
mnemonic: EUR
  hidden: 0
 placeholder: 0
  parent: Privatkonten 1
 4. row *
name: Privatkonten 1
account_type: BANK
mnemonic: EUR
  hidden: 0
 placeholder: 1
  parent: Root Account
 5. row *
name: 1601 Verbindlichkeiten GBP
account_type: PAYABLE
mnemonic: GBP
  hidden: 0
 placeholder: 0
  parent: Verbindlichkeiten
 6. row *
name: 1602 Verbindlichkeiten USD
account_type: PAYABLE
mnemonic: USD
  hidden: 0
 placeholder: 0
  parent: Verbindlichkeiten
 7. row *
name: 1802 private Mastercard
account_type: BANK
mnemonic: EUR
  hidden: 0
 placeholder: 0
  parent: Privatentnahmen/-einlagen
7 rows in set

as I mentioned previously, all I did to let this not work anymore is
changing account_type of "Verbindlichkeiten" (2nd row) from PAYABLE to
LIABILITY - to avoid getting payments on this place holder account. I
have now set it back (and restarted), but the misbehaviour stays.

installed gnucash (on openSUSE Leap 42.2)
> zypper info gnucash  
Information for package gnucash:

Repository : Main Update Repository  
Name   : gnucash 
Version: 2.6.16-3.3.1
Arch   : x86_64  
Vendor : openSUSE
Installed Size : 25.6 MiB
Installed  : Yes 
Status : up-to-date  
Source package : gnucash-2.6.16-3.3.1.src
Summary: Personal Finance Manager

can anyone reproduce? or understand?

Thank you


-- 
PaNe Foto
Paul Neuwirth
Postfach 45 04 54
80904 MÜNCHEN
DEUTSCHLAND

Fax: +49 89 35819624
https://www.swabian.net/

UST-IdNr. (VAT):
DE123456789
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Newbie needs help ( bills and payments)

[Paul Neuwirth]

On Thu, 21 Dec 2017 09:50:31 +0100
Geert Janssens <geert.gnuc...@kobaltwit.be> wrote:

> Op donderdag 21 december 2017 08:46:57 CET schreef Paul Neuwirth:
> > On Tue, 19 Dec 2017 16:32:13 +0100
> > 
> > Geert Janssens <geert.gnuc...@kobaltwit.be> wrote:  
> > > Op dinsdag 19 december 2017 12:18:11 CET schreef Paul Neuwirth:  
> > > > Hi Geert,
> > > > 
> > > > hartelijk bedankt. Thank you, that was exactly what I missed.
> > > > Would be very nice If open bills would be shown after selecting
> > > > vendor..
> > > > 
> > > > groetjes
> > > > 
> > > > Paul  
> > > 
> > > Dag Paul,
> > > 
> > > (I readded your reply to the list as the remainder of this
> > > conversation may also be of interest to others. Please use
> > > reply-all in the future)
> > > 
> > > I'm not sure I understand what you mean or would like. Can you
> > > explain in some more detail what happened and what you would have
> > > liked instead ?
> > > 
> > > Groeten,
> > > 
> > > Geert  
> > 
> > Hi,
> > (thank you... new to this e-mail client)
> > 
> > Semms as I cheered too soon.
> > https://www.swabian.net/extern/gncml/gnucash7.png
> > If I process as payment, (entering the bill no. manually, as on
> > documents bill is not selectable - this is what behaviour I miss),
> > the bill stays due (see top screen of screenshot)
> > https://www.swabian.net/extern/gncml/gnucash8.png
> > if I click process payment from bill-side, I see the bill and a new
> > transaction, identically to the real one is being created, if I
> > confirm.
> > 
> > Thank you (all) for help  
> 
> Ah, your bill is not posted to the same account as the one you are
> trying to post your payment to.
> 
> After "Assign as payment", set both vendor and post-to account
> appropriately and your open bill will appear.
> 
> Regards,
> 
> Geert

got it :) thank you again... too long account names..
(Passiva:Verbindlichkeiten:1600 Verblk aus Lieferungen und Leistungen.
so I did not notice.
Now it seems to work as espected. Great :)

Regards

Paul
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Newbie needs help ( bills and payments)

[Paul Neuwirth]

On Tue, 19 Dec 2017 16:32:13 +0100
Geert Janssens <geert.gnuc...@kobaltwit.be> wrote:

> Op dinsdag 19 december 2017 12:18:11 CET schreef Paul Neuwirth:
> > Hi Geert,
> > 
> > hartelijk bedankt. Thank you, that was exactly what I missed.
> > Would be very nice If open bills would be shown after selecting
> > vendor..
> > 
> > groetjes
> > 
> > Paul  
> 
> Dag Paul,
> 
> (I readded your reply to the list as the remainder of this
> conversation may also be of interest to others. Please use reply-all
> in the future)
> 
> I'm not sure I understand what you mean or would like. Can you
> explain in some more detail what happened and what you would have
> liked instead ?
> 
> Groeten,
> 
> Geert

Hi,
(thank you... new to this e-mail client)

Semms as I cheered too soon. 
https://www.swabian.net/extern/gncml/gnucash7.png
If I process as payment, (entering the bill no. manually, as on
documents bill is not selectable - this is what behaviour I miss), the
bill stays due (see top screen of screenshot)
https://www.swabian.net/extern/gncml/gnucash8.png
if I click process payment from bill-side, I see the bill and a new
transaction, identically to the real one is being created, if I confirm.

Thank you (all) for help



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnucash coredump gnome

[Paul Neuwirth]

On Tue, 19 Dec 2017 20:20:06 +0100
"Cliff McDiarmid"  wrote:

> Hi
>  
> Just joined.  i have been using Quicken for 24years running under
> Wine!  It's now time to change, problems with older versions of it. 
> I'm running Gnome 16.04LTS.  But I have problems with my first foray
> into Gnucash.  It is coredumping without starting, version
> 1:2.6.12-1.  Other versions also dump.  I've run it with Strace and
> the log is attached.  AFAIK all dependencies are satisfied.
> 
> Can anyone help here?
> 
> Many thanks

could you repeat the strace using longer strings (using e.g. strace -s
200)

the whole error message get's cut:

write(3, "* 19:18:00 OTHER  Sett"..., 83) = 83
--- SIGTRAP {si_signo=SIGTRAP, si_code=SI_KERNEL} ---
+++ killed by SIGTRAP (core dumped) +++

seems to be related to GLib-GIO.. 
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Newbie needs help ( bills and payments)

[Paul Neuwirth]

Hello list,

I am not sure, if I understood everything about book keeping and
gnucash's functionalities. I asked previously on German language list,
and got the tip to ask here.

What I already did:

imported extended accounts (according to German standard SKR03) and
laboriously typed in all vendors and bills. But not the
according payments yet.
I hoped, I am able to import the bookings from my bank account
(aqbanking or csv import) und link it to the bills or reconcile.

Doing this import gnucash does'nt find potential splits matching or
creates many balance splits. I also tried to process payments before
import but also these (same looking) splits cannot be reconciled by
import.

What is the correct method?

I would appreciate any help.

Here I got some screenshots, how I proceed. (If German translation
matters, I can make new ones using English translation):


1) https://www.swabian.net/extern/gncml/gnucash1.png
importing CSV, seperator, date, account etc. are ok.
amount marked as "Deposit" (minus signed ones are withdrawals)
2) https://www.swabian.net/extern/gncml/gnucash2.png
account matching is also ok
3) https://www.swabian.net/extern/gncml/gnucash3.png
from last tries gnucash learned to book to
"Verbindlichkeiten" (Account/Payable)
3a) https://www.swabian.net/extern/gncml/gnucash4.png
If I try to "R+U" (reconcile + update?), gnucash doesn't find matching
splits.
4) https://www.swabian.net/extern/gncml/gnucash5.png
if I import the bookings as "new", Gnucash correctly books from
e.g. credit card to payable account

actually ok.. but:

my basic question
6) https://www.swabian.net/extern/gncml/gnucash6.png
How do I link the bookings to the bills/payments?
The bills stay due, if I click "process payment" I only can create a
new split, which would look identical to imported ones.


regards

Paul Neuwirth
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.