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.