Re: [GNC] gnucash-user Digest, Vol 233, Issue 34
If I'm not mistaken, Mint has a backup utility. So you can just set it up and make sure the GnuCash locations noted in the Wiki and Guide are included in the paths to be backed up. Regards, Adrien On 8/10/22 9:29 PM, davidcousen...@gmail.com wrote: James https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html The info https://wiki.gnucash.org/wiki/Configuration_Locations is also useful for backing up user preferences and things like customized reports. To back up to a USB drive on Linux Mint, the drive should appear in the file manager (icon that looks like a filing cabinet folder in the LH panel of the Menu) once you have plugged it in and it is mounted. Navigate to andelect the folder containing the data file Ctr-c to copy it. Navigate to the USB hard drive and select a suitable directory to keep your backups in on the Hard drive and Ctrl-v to paste a copy there (or use the Edit items in the menu). How to do actually backups is an operating system issue and not really a GnuCash issue. Gnucash's internal backup, logfiles and restore capability are primarily about recovering from a datafile corrupted by a GnuCash program crash, rather than general computer failures like a hard disk failure. There are any number of articles on general computer backup strategies on the internet depending on the facilities you have available and how much you want to spend setting it up. A good practice is at least a backup to another local device in your home (USB disk, NAS, another computer) and a backup to an offsite facility to protect you if your house burns down for example (USB stick kept by a relative ot cloud facility) On Linux you can create "cron" jobs to schedule automatic backups if this is useful. For example I backup critical files to a cloud storage as well as local network storage on my LAN automatically daily and synchronize files between my laptop and desktop with Unison whenever they are connected so there are always multiple copies of my most recent datafile. My NAS is separately backedp up to cloud storage. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Possible Bug in Credit Note Display
Correct. You can register an account at bugs.gnucash.org. Regards, Adrien On 8/10/22 4:02 PM, Robert Simmons wrote: No Bugzilla account. Github account, but it looks like you all only handle PRs there, not issues. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] gnucash-user Digest, Vol 233, Issue 34
James https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html The info https://wiki.gnucash.org/wiki/Configuration_Locations is also useful for backing up user preferences and things like customized reports. To back up to a USB drive on Linux Mint, the drive should appear in the file manager (icon that looks like a filing cabinet folder in the LH panel of the Menu) once you have plugged it in and it is mounted. Navigate to andelect the folder containing the data file Ctr-c to copy it. Navigate to the USB hard drive and select a suitable directory to keep your backups in on the Hard drive and Ctrl-v to paste a copy there (or use the Edit items in the menu). How to do actually backups is an operating system issue and not really a GnuCash issue. Gnucash's internal backup, logfiles and restore capability are primarily about recovering from a datafile corrupted by a GnuCash program crash, rather than general computer failures like a hard disk failure. There are any number of articles on general computer backup strategies on the internet depending on the facilities you have available and how much you want to spend setting it up. A good practice is at least a backup to another local device in your home (USB disk, NAS, another computer) and a backup to an offsite facility to protect you if your house burns down for example (USB stick kept by a relative ot cloud facility) On Linux you can create "cron" jobs to schedule automatic backups if this is useful. For example I backup critical files to a cloud storage as well as local network storage on my LAN automatically daily and synchronize files between my laptop and desktop with Unison whenever they are connected so there are always multiple copies of my most recent datafile. My NAS is separately backedp up to cloud storage. David Cousens On Wed, 2022-08-10 at 23:07 +, James Baxter via gnucash-user wrote: > > Does anybody know how to make a backup of your hard drive. I am looking to > back up Gnucash for the most part. I have a drive that i can plug into the USB > port. > ThanksJames baxterkangaro...@yahoo.com > On Wednesday, August 10, 2022, 12:00:27 PM EDT, > gnucash-user-requ...@gnucash.org wrote: > > Send gnucash-user mailing list submissions to > gnucash-user@gnucash.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > gnucash-user-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@gnucash.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > > 1. Build From Source Near Impossible (flywire) > 2. Re: Banks with OFX or CSV account data downloads (Tom Browder) > 3. Possible Bug in Credit Note Display (Robert Simmons) > 4. Monthly period in charts should use end-of-month values, not > start (Colin Arndt) > > > -- > > Message: 1 > Date: Wed, 10 Aug 2022 16:58:46 +1000 > From: flywire > To: Gnucash Users > Subject: [GNC] Build From Source Near Impossible > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > Re: https://lists.gnucash.org/pipermail/gnucash-user/2022-July/102045.html > > You're correct that the Python bindings aren't included. > > I'd be happy with a non-standard download available that included the > bindings. It wouldn't need gui support. > > > -- > > Message: 2 > Date: Wed, 10 Aug 2022 05:19:27 -0500 > From: Tom Browder > To: Tracy > Cc: "gnucash-user@gnucash.org" > Subject: Re: [GNC] Banks with OFX or CSV account data downloads > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > On Wed, Aug 10, 2022 at 00:00 Tracy wrote: > > > As with so many things, your mileage may vary, but... > > Thanks so much, Tracy?that?s very helpful. Some of those banks are in my > area. > > -Tom > > > -- > > Message: 3 > Date: Wed, 10 Aug 2022 11:18:42 -0400 > From: Robert Simmons > To: Mailing List Gnucash > Subject: [GNC] Possible Bug in Credit Note Display > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > In the Entries part of an open credit note tab, the row focus can be > assigned by clicking on a row. This changes the selected row from green to > yellow. Also, it changes the value in the Subtotal column to zero. This > appears to just be a software defect in the display: there are no changes > made to the underlying data in the database. If you select a different row, > the previously selected row's subtotal returns to normal and the newly > selected row's subtotal changes to zero. > > > -- > > Message: 4 > Date: Wed, 10 Aug 2022 11:57:56 -0400 > From: Colin Arndt > To: gnucash-user@gnucash.org
Re: [GNC] Another Potential Software Defect
Also, if you're doing everything in JupyterLab like I am, you can use: %load_ext wurlitzer in the cell to suppress everything from C/C++ in that particular cell. https://pypi.org/project/wurlitzer/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Another Potential Software Defect
The following is, of course, not recommended. Those errors are pretty difficult to suppress because they're coming from C/C++ stdout. If you want to hide them, contextlib.suppress and contextlib.redirect_stdout both do not work. However, there is a python package called wurlitzer that does the trick. import wurlitzer with wurlitzer.pipes() as (out, err): job = gnucash.gnucash_business.Job(book, '1', cust, 'Build Deathstar') you can also just do: with wurlitzer.pipes(): job = gnucash.gnucash_business.Job(book, '1', cust, 'Build Deathstar') and just drop the error messages on the floor until the underlying software defect is fixed. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] How To Get Job Object?
gnucash.Query() looks like the real winner of the swiss army knife function.
Replacements for direct SQL queries. This one replaces SELECT max(id) FROM
jobs
def get_job_maxid():
query = gnucash.Query()
query.search_for('gncJob')
query.set_book(book)
job_ids = list()
for result in query.run():
job = gnucash.gnucash_business.Job(instance=result)
job_ids.append(int(job.GetID()))
if any(job_ids):
return max(job_ids)
return 0
Retrieve a customer by name:
def get_customer(name):
query = gnucash.Query()
query.search_for('gncCustomer')
query.set_book(book)
for result in query.run():
cust = gnucash.gnucash_business.Customer(instance=result)
if cust.GetName() == name:
break
else:
cust = None
query.destroy()
return cust
I still can't find a way to increment the Job ID without writing directly
to the DB however. But I've reduced DB interaction to that last one (it's a
mystery).
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] How To Get Job Object?
And that's pretty much the way the GUI works too.
BTW do you know about the Doxygen-generated docs for the C API? It's a bit
patchy in parts, but there's a ton of useful info. You can build it yourself or
use our nightly builds at https://code.gnucash.org/docs/MAINT.
Regards,
John Ralls
> On Aug 10, 2022, at 5:59 PM, Robert Simmons wrote:
>
> When I'm done with all this, I'm going to contribute new example scripts.
> The current documentation for the Python bindings is very excellent. It's
> some of the best documentation I've ever seen. It's a pleasure to use and
> saves a ton of time.
>
> Here is the only way that I can find of getting from zero to the job that I
> want and then associate that job with an invoice:
>
> import gnucash
> import gnucash.gnucash_business
>
> def get_jobs(book):
>query = gnucash.Query()
>query.search_for('gncJob')
>query.set_book(book)
>job_list = list()
>for result in query.run():
>job_list.append(gnucash.gnucash_business.Job(instance=result))
>query.destroy()
>return job_list
>
> The resulting list is objects with the expected methods. You then loop
> through them and find the one you're looking for.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] How To Get Job Object?
GUIDs belong to the parent class QofInstance, so you use qof_instance_get_guid(my_job) Regards, John Ralls > On Aug 10, 2022, at 5:42 PM, Robert Simmons wrote: > > I have created a number of Jobs. Now I want to associate an invoice with > one of the jobs. I can see there is a function "book.JobLookup()" but the > argument this takes is GncGUID. I don't know how to create this GUID > object, and the only way I can see to get the GUID is to just do a SQL > query directly to the DB. > > The other way that I have found to get to those job objects is to go from a > customer to the associated jobs using cust.GetJoblist(). This does return a > list of objects "". > Looking at the object's directory, there are not the expected methods for > showing the Job name or other attributes: > > ['__class__', > '__delattr__', > '__dir__', > '__doc__', > '__eq__', > '__format__', > '__ge__', > '__getattribute__', > '__gt__', > '__hash__', > '__init__', > '__init_subclass__', > '__int__', > '__le__', > '__lt__', > '__ne__', > '__new__', > '__reduce__', > '__reduce_ex__', > '__repr__', > '__setattr__', > '__sizeof__', > '__str__', > '__subclasshook__', > 'acquire', > 'append', > 'disown', > 'next', > 'own'] > > Can someone point out how to either make a GncGUID object or to get from > those GniJob objects to the job name? > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] How To Get Job Object?
When I'm done with all this, I'm going to contribute new example scripts.
The current documentation for the Python bindings is very excellent. It's
some of the best documentation I've ever seen. It's a pleasure to use and
saves a ton of time.
Here is the only way that I can find of getting from zero to the job that I
want and then associate that job with an invoice:
import gnucash
import gnucash.gnucash_business
def get_jobs(book):
query = gnucash.Query()
query.search_for('gncJob')
query.set_book(book)
job_list = list()
for result in query.run():
job_list.append(gnucash.gnucash_business.Job(instance=result))
query.destroy()
return job_list
The resulting list is objects with the expected methods. You then loop
through them and find the one you're looking for.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
[GNC] How To Get Job Object?
I have created a number of Jobs. Now I want to associate an invoice with one of the jobs. I can see there is a function "book.JobLookup()" but the argument this takes is GncGUID. I don't know how to create this GUID object, and the only way I can see to get the GUID is to just do a SQL query directly to the DB. The other way that I have found to get to those job objects is to go from a customer to the associated jobs using cust.GetJoblist(). This does return a list of objects "". Looking at the object's directory, there are not the expected methods for showing the Job name or other attributes: ['__class__', '__delattr__', '__dir__', '__doc__', '__eq__', '__format__', '__ge__', '__getattribute__', '__gt__', '__hash__', '__init__', '__init_subclass__', '__int__', '__le__', '__lt__', '__ne__', '__new__', '__reduce__', '__reduce_ex__', '__repr__', '__setattr__', '__sizeof__', '__str__', '__subclasshook__', 'acquire', 'append', 'disown', 'next', 'own'] Can someone point out how to either make a GncGUID object or to get from those GniJob objects to the job name? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] gnucash-user Digest, Vol 233, Issue 34
Hi, Backing up your whole hard drive would be out of scope for this mailing list, but if you want to backup your GnuCash book it's just a file. Just copy/paste it. On Wed, Aug 10, 2022 at 7:07 PM James Baxter via gnucash-user < gnucash-user@gnucash.org> wrote: > > Does anybody know how to make a backup of your hard drive. I am looking to > back up Gnucash for the most part. I have a drive that i can plug into the > USB port. > ThanksJames baxterkangaro...@yahoo.com > On Wednesday, August 10, 2022, 12:00:27 PM EDT, > gnucash-user-requ...@gnucash.org > wrote: > > Send gnucash-user mailing list submissions to > gnucash-user@gnucash.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > gnucash-user-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@gnucash.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > > 1. Build From Source Near Impossible (flywire) > 2. Re: Banks with OFX or CSV account data downloads (Tom Browder) > 3. Possible Bug in Credit Note Display (Robert Simmons) > 4. Monthly period in charts should use end-of-month values, not > start (Colin Arndt) > > > -- > > Message: 1 > Date: Wed, 10 Aug 2022 16:58:46 +1000 > From: flywire > To: Gnucash Users > Subject: [GNC] Build From Source Near Impossible > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > Re: https://lists.gnucash.org/pipermail/gnucash-user/2022-July/102045.html > > You're correct that the Python bindings aren't included. > > I'd be happy with a non-standard download available that included the > bindings. It wouldn't need gui support. > > > -- > > Message: 2 > Date: Wed, 10 Aug 2022 05:19:27 -0500 > From: Tom Browder > To: Tracy > Cc: "gnucash-user@gnucash.org" > Subject: Re: [GNC] Banks with OFX or CSV account data downloads > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > On Wed, Aug 10, 2022 at 00:00 Tracy wrote: > > > As with so many things, your mileage may vary, but... > > > Thanks so much, Tracy?that?s very helpful. Some of those banks are in my > area. > > -Tom > > > -- > > Message: 3 > Date: Wed, 10 Aug 2022 11:18:42 -0400 > From: Robert Simmons > To: Mailing List Gnucash > Subject: [GNC] Possible Bug in Credit Note Display > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > In the Entries part of an open credit note tab, the row focus can be > assigned by clicking on a row. This changes the selected row from green to > yellow. Also, it changes the value in the Subtotal column to zero. This > appears to just be a software defect in the display: there are no changes > made to the underlying data in the database. If you select a different row, > the previously selected row's subtotal returns to normal and the newly > selected row's subtotal changes to zero. > > > -- > > Message: 4 > Date: Wed, 10 Aug 2022 11:57:56 -0400 > From: Colin Arndt > To: gnucash-user@gnucash.org > Subject: [GNC] Monthly period in charts should use end-of-month > values, not start > Message-ID: <0f880b41-780d-49a5-957e-29c50c5ab...@gmail.com> > Content-Type: text/plain;charset=utf-8 > > Hello fellow GnuCashers, > > I?ve used GnuCash very happily the last few years - it?s a fantastic > application with superlative support from both the developers and fellow > users on this list. But here?s my issue. > > Today I created a bar chart report tracking my cash across bank accounts > over time. > > When using Month as the period (step size), the report returns the balance > at the start of the month, not the end. > > I was looking at the bar for January of this year, confused why it didn?t > include a bonus I got at work. It took me a moment to realize the report > used January 1st balances. Therefore, that deposit wasn?t reflected until > February. This means when interpreting the bar values, I have to mentally > shift them all back one month. > > Another example. If I want to see the cash balance at the end of 2021, I > have to look at the January 2022 bar, not the December 2021 one. > > Do you see my point? In some cases I can see this making sense, but not > for this use case. A period?s balance should be calculated from the end of > the period, not the start. > > Could an option be added to use the end of a period vs the start? > > Thanks for considering, > Colin > > -- > > Subject: Digest Footer > > ___ > > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: >
Re: [GNC] gnucash-user Digest, Vol 233, Issue 34
Does anybody know how to make a backup of your hard drive. I am looking to back up Gnucash for the most part. I have a drive that i can plug into the USB port. ThanksJames baxterkangaro...@yahoo.com On Wednesday, August 10, 2022, 12:00:27 PM EDT, gnucash-user-requ...@gnucash.org wrote: Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Build From Source Near Impossible (flywire) 2. Re: Banks with OFX or CSV account data downloads (Tom Browder) 3. Possible Bug in Credit Note Display (Robert Simmons) 4. Monthly period in charts should use end-of-month values, not start (Colin Arndt) -- Message: 1 Date: Wed, 10 Aug 2022 16:58:46 +1000 From: flywire To: Gnucash Users Subject: [GNC] Build From Source Near Impossible Message-ID: Content-Type: text/plain; charset="UTF-8" Re: https://lists.gnucash.org/pipermail/gnucash-user/2022-July/102045.html > You're correct that the Python bindings aren't included. I'd be happy with a non-standard download available that included the bindings. It wouldn't need gui support. -- Message: 2 Date: Wed, 10 Aug 2022 05:19:27 -0500 From: Tom Browder To: Tracy Cc: "gnucash-user@gnucash.org" Subject: Re: [GNC] Banks with OFX or CSV account data downloads Message-ID: Content-Type: text/plain; charset="UTF-8" On Wed, Aug 10, 2022 at 00:00 Tracy wrote: > As with so many things, your mileage may vary, but... Thanks so much, Tracy?that?s very helpful. Some of those banks are in my area. -Tom -- Message: 3 Date: Wed, 10 Aug 2022 11:18:42 -0400 From: Robert Simmons To: Mailing List Gnucash Subject: [GNC] Possible Bug in Credit Note Display Message-ID: Content-Type: text/plain; charset="UTF-8" In the Entries part of an open credit note tab, the row focus can be assigned by clicking on a row. This changes the selected row from green to yellow. Also, it changes the value in the Subtotal column to zero. This appears to just be a software defect in the display: there are no changes made to the underlying data in the database. If you select a different row, the previously selected row's subtotal returns to normal and the newly selected row's subtotal changes to zero. -- Message: 4 Date: Wed, 10 Aug 2022 11:57:56 -0400 From: Colin Arndt To: gnucash-user@gnucash.org Subject: [GNC] Monthly period in charts should use end-of-month values, not start Message-ID: <0f880b41-780d-49a5-957e-29c50c5ab...@gmail.com> Content-Type: text/plain; charset=utf-8 Hello fellow GnuCashers, I?ve used GnuCash very happily the last few years - it?s a fantastic application with superlative support from both the developers and fellow users on this list. But here?s my issue. Today I created a bar chart report tracking my cash across bank accounts over time. When using Month as the period (step size), the report returns the balance at the start of the month, not the end. I was looking at the bar for January of this year, confused why it didn?t include a bonus I got at work. It took me a moment to realize the report used January 1st balances. Therefore, that deposit wasn?t reflected until February. This means when interpreting the bar values, I have to mentally shift them all back one month. Another example. If I want to see the cash balance at the end of 2021, I have to look at the January 2022 bar, not the December 2021 one. Do you see my point? In some cases I can see this making sense, but not for this use case. A period?s balance should be calculated from the end of the period, not the start. Could an option be added to use the end of a period vs the start? Thanks for considering, Colin -- Subject: Digest Footer ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. -- End of gnucash-user Digest, Vol 233, Issue 34 * ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please
[GNC] Another Potential Software Defect
Lets see if I can go two for two:
Steps to reproduce (using a sqlite file):
1. Run code snippet below.
2. Observe raised exception "
[GncSqlColumnTableEntryImpl::add_to_query()] Invalid owner type: 0"
import gnucash
import gnucash.gnucash_business
s = gnucash.Session('sqlite3://test.gnucash',
gnucash.SessionOpenMode.SESSION_NORMAL_OPEN)
book = s.book
commod_table = book.get_table()
USD = commod_table.lookup('CURRENCY', 'USD')
cust = gnucash.gnucash_business.Customer(book, '1', USD, 'Darth Vader')
job = gnucash.gnucash_business.Job(book, '1', cust, 'Build Deathstar')
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Possible Bug in Credit Note Display
No Bugzilla account. Github account, but it looks like you all only handle PRs there, not issues. On Wed, Aug 10, 2022 at 4:54 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Indeed, I just created a test book and created a new Vendor Credit and I > can reproduce. > > Congratulations. You found a bug. > > Now, why is there different code here? This looks like an opportunity to > tidy that up and reduce divergence and complexity. > > Do you have a GnuCash Bugzilla account or do you need me to file it? > > Regards, > Adrien > > On 8/10/22 3:45 PM, Adrien Monteleone wrote: > > Nope, I already had a credit note that I ended up not using. (but since > > you can't delete them, it was available for testing) I had previously > > deleted the line items so I added some dummy data and couldn't reproduce > > the effect you described. > > > > However, this credit note is to a customer, not from a vendor. > > > > I don't think it is different code, but I will try to reproduce with > > your steps. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Possible Bug in Credit Note Display
Indeed, I just created a test book and created a new Vendor Credit and I can reproduce. Congratulations. You found a bug. Now, why is there different code here? This looks like an opportunity to tidy that up and reduce divergence and complexity. Do you have a GnuCash Bugzilla account or do you need me to file it? Regards, Adrien On 8/10/22 3:45 PM, Adrien Monteleone wrote: Nope, I already had a credit note that I ended up not using. (but since you can't delete them, it was available for testing) I had previously deleted the line items so I added some dummy data and couldn't reproduce the effect you described. However, this credit note is to a customer, not from a vendor. I don't think it is different code, but I will try to reproduce with your steps. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Possible Bug in Credit Note Display
Nope, I already had a credit note that I ended up not using. (but since you can't delete them, it was available for testing) I had previously deleted the line items so I added some dummy data and couldn't reproduce the effect you described. However, this credit note is to a customer, not from a vendor. I don't think it is different code, but I will try to reproduce with your steps. Regards, Adrien On 8/10/22 3:33 PM, Robert Simmons wrote: I cannot duplicate this on v4.11 running on BigSur. This happens in macOS and in Linux. Here are the steps to reproduce. You will need at least one vendor existing to do this. If you have no vendors, create one called "Acme". 1. Business menu > Vendor > New Bill... 2. Type: Credit Note 3. Vendor: Acme (or one of your existing vendors) 4. OK 5. Description: Widget (this doesn't matter) 6. Action: Material (this doesn't matter) 7. Expense Account: Expenses:Books (this doesn't matter) 8. Quantity: 1 9. Unit Price: 100 10. Hit enter to enter this row. If you are on linux, there are two rows drawn in the UI. One empty at the bottom and one populated with data. If you are on macOS, there is one row populated with data. Now, select the row populated with data and observe the subtotal column. BTW: I bet the reason you can't reproduce this is you didn't create a credit note. You probably created a bill where this software defect does not occur. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Possible Bug in Credit Note Display
> I cannot duplicate this on v4.11 running on BigSur. This happens in macOS and in Linux. Here are the steps to reproduce. You will need at least one vendor existing to do this. If you have no vendors, create one called "Acme". 1. Business menu > Vendor > New Bill... 2. Type: Credit Note 3. Vendor: Acme (or one of your existing vendors) 4. OK 5. Description: Widget (this doesn't matter) 6. Action: Material (this doesn't matter) 7. Expense Account: Expenses:Books (this doesn't matter) 8. Quantity: 1 9. Unit Price: 100 10. Hit enter to enter this row. If you are on linux, there are two rows drawn in the UI. One empty at the bottom and one populated with data. If you are on macOS, there is one row populated with data. Now, select the row populated with data and observe the subtotal column. BTW: I bet the reason you can't reproduce this is you didn't create a credit note. You probably created a bill where this software defect does not occur. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Possible Bug in Credit Note Display
I cannot duplicate this on v4.11 running on BigSur. The highlights change as they should, but the values remain correct and do not change to 0.00. (There is a Subtotal column, and a Subtotal 'total' at the top, neither change for me) What is your GnuCash & OS version? Regards, Adrien On 8/10/22 10:18 AM, Robert Simmons wrote: In the Entries part of an open credit note tab, the row focus can be assigned by clicking on a row. This changes the selected row from green to yellow. Also, it changes the value in the Subtotal column to zero. This appears to just be a software defect in the display: there are no changes made to the underlying data in the database. If you select a different row, the previously selected row's subtotal returns to normal and the newly selected row's subtotal changes to zero. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Monthly period in charts should use end-of-month values, not start
I guess I read the chart differently. It does make sense to know what you started a period with in regards to an asset like a bank account or cash on hand. (And I also see your point of wanting to know where you ended up.) Though I suppose an option could be added, clearly, your position on say April 1st is also your position on March 31st. (This is problematic for December in an annual chart though.) Maybe a Balance Sheet or Cash Flow report is more in-line with what you're after? On a whim, I checked out the Expense Chart. It correctly shows total expenses in a category for a period, but lists them as a full date as the 1st of each month, not just month/year. (so 1/1/22, 2/1/22, etc.) Of course, those are not 'balances' as of those dates, but rather sums for the period, so it is nonsensical to show the day part of the date. That for sure I would assert as a bug. Regards, Adrien On 8/10/22 10:57 AM, Colin Arndt wrote: Hello fellow GnuCashers, I’ve used GnuCash very happily the last few years - it’s a fantastic application with superlative support from both the developers and fellow users on this list. But here’s my issue. Today I created a bar chart report tracking my cash across bank accounts over time. When using Month as the period (step size), the report returns the balance at the start of the month, not the end. I was looking at the bar for January of this year, confused why it didn’t include a bonus I got at work. It took me a moment to realize the report used January 1st balances. Therefore, that deposit wasn’t reflected until February. This means when interpreting the bar values, I have to mentally shift them all back one month. Another example. If I want to see the cash balance at the end of 2021, I have to look at the January 2022 bar, not the December 2021 one. Do you see my point? In some cases I can see this making sense, but not for this use case. A period’s balance should be calculated from the end of the period, not the start. Could an option be added to use the end of a period vs the start? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Monthly period in charts should use end-of-month values, not start
Hello fellow GnuCashers, I’ve used GnuCash very happily the last few years - it’s a fantastic application with superlative support from both the developers and fellow users on this list. But here’s my issue. Today I created a bar chart report tracking my cash across bank accounts over time. When using Month as the period (step size), the report returns the balance at the start of the month, not the end. I was looking at the bar for January of this year, confused why it didn’t include a bonus I got at work. It took me a moment to realize the report used January 1st balances. Therefore, that deposit wasn’t reflected until February. This means when interpreting the bar values, I have to mentally shift them all back one month. Another example. If I want to see the cash balance at the end of 2021, I have to look at the January 2022 bar, not the December 2021 one. Do you see my point? In some cases I can see this making sense, but not for this use case. A period’s balance should be calculated from the end of the period, not the start. Could an option be added to use the end of a period vs the start? Thanks for considering, 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Possible Bug in Credit Note Display
In the Entries part of an open credit note tab, the row focus can be assigned by clicking on a row. This changes the selected row from green to yellow. Also, it changes the value in the Subtotal column to zero. This appears to just be a software defect in the display: there are no changes made to the underlying data in the database. If you select a different row, the previously selected row's subtotal returns to normal and the newly selected row's subtotal changes to zero. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Banks with OFX or CSV account data downloads
On Wed, Aug 10, 2022 at 00:00 Tracy wrote: > As with so many things, your mileage may vary, but... Thanks so much, Tracy—that’s very helpful. Some of those banks are in my area. -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Build From Source Near Impossible
Re: https://lists.gnucash.org/pipermail/gnucash-user/2022-July/102045.html > You're correct that the Python bindings aren't included. I'd be happy with a non-standard download available that included the bindings. It wouldn't need gui support. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Third party OFX/CVS providers
That never used to be the case but it's still pretty useless for a tax return: Please note that if you wish to download transactions that is more than the 12 month period, you must choose the 'View Statement' option. However, please be advised that it does not have the facility to transfer them in the abovementioned formats, it will on a PDF format per month. On Sun, Aug 7, 2022 at 12:14 PM Gyle McCollam wrote: > I have a Citibank credit card and I use the online banking tool to > download a QFX file, but I went to their website and to the activity (not > Statements) and selected the activity/statement month. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
