After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 712515 - Billing Terms Recreated with Every Bill
Billing Terms Recreated with Every Bill
Status: RESOLVED INCOMPLETE
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.4.x
Other All
: Normal normal
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2013-11-16 15:40 UTC by John Ralls
Modified: 2018-06-29 23:21 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Small datafile with traces of this bug (122.00 KB, application/octet-stream)
2013-12-11 15:53 UTC, Geert Janssens
Details

Description John Ralls 2013-11-16 15:40:54 UTC
Neil night <nakinigit@gmail.com> reported:

Using gnucash 2.4.11 windows, 2.4.7 on ubuntu oneiric writing to mysql database. All seems well, except for the billing terms editor.

Added:
due on receipt
net 14
net 30

So far, whenever I add a new vendor bill, select 'net 30' from the drop-down, a new entry in the billing terms editor is created for each invoice. So, if I enter 30 new vendor invoices, each time selecting 'net 30' in the billing terms dropdown, I will end up with 30 new 'net 30' entries in the billing terms editor, none of which is deletable (error: term "net 30" is in use. you cannot delete it). And of course, the billing terms drop-down gets populated with all of these duplicate entries.

Oddly, the problem only seems to exist with 'net 30'
Comment 1 John Ralls 2013-12-11 00:30:07 UTC
I'm unable to replicate this, and neither the original reporter nor another reporter on the list are sure of how exactly to make it happen. No KVP is involved, so it isn't the usual reason for problems like this.

If more information comes to light we can reopen the bug.
Comment 2 Geert Janssens 2013-12-11 15:53:25 UTC
Created attachment 263992 [details]
Small datafile with traces of this bug

I have definitely hit this issue in the past, but can't reproduce it in either 2.4.13 or the most recent trunk.

Just for reference I have attached a small sample file that still shows traces from the problem. It has 5 billing terms titled "14 dagen". Only one was explicitly created. The others appeared as the result of creating or duplicating bills. I'm not sure anymore how this happened exactly as I can't reproduce this anymore.

What may still be relevant is how to fix such a file ?

There should only be one billing term visible while this file shows 5. But I still haven't grasped the code that deals with billing terms. There is some parent/child relationship between billing terms, but I haven't figured out yet when the parent should be used and when a child.
Comment 3 John Ralls 2017-09-24 22:48:03 UTC
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
Comment 4 John Ralls 2018-06-29 23:21:32 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=712515. Please update any external references or bookmarks.