Re: [GNC] GnuCash losing Notes, or just a display problem in the Register?

2018-05-23 Thread Adrien Monteleone
For anyone not watching this bug on Bugzilla and using sqlite, there is potential data loss involved when moving between sqlite and XML formats. Please see the bug for more info. (reported earlier in the thread) Regards, Adrien > On May 23, 2018, at 5:54 PM, Randy Orrison wrote: > > Thanks fo

Re: [GNC] GnuCash losing Notes, or just a display problem in the Register?

2018-05-23 Thread Randy Orrison
Thanks for telling me what to look for: I've used DB Browser for SQLite ( http://sqlitebrowser.org/) and there are plenty of records in the slots table with name=notes. Looks like it's just a display issue, so I'll hope they re-appear when the bug is fixed. Randy On 23 May 2018 at 23:39, Adrien

Re: [GNC] GnuCash losing Notes, or just a display problem in the Register?

2018-05-23 Thread Adrien Monteleone
For that sqlite search, look at the ‘slots’ table, specifically find all rows that have ’notes’ as the ’name’ value and then look at the ’string_val’ field for the actual note text. The following query would return all data in a row that contained a note with actual text. (but not return rows w

Re: [GNC] GnuCash losing Notes, or just a display problem in the Register?

2018-05-23 Thread Adrien Monteleone
First, be sure to view the newer file with an sqlite viewer and verify the notes are indeed missing. There are several free viewers around the web, including a Firefox plugin if that’s what you use.(not sure if Chrome/Chromium has one) If they are indeed gone, short of figuring out how to pull

Re: [GNC] GnuCash losing Notes, or just a display problem in the Register?

2018-05-23 Thread Randy Orrison
Hi, Thanks for the confirmation. I have created bug https://bugzilla.gnome.org/show_bug.cgi?id=796369. Unfortunately, saving as XML and reopening the file did not restore any of my missing notes. Newly created notes in the XML file are being saved and display correctly after re-opening the file

Re: [GNC] Trivial feature - View zero accounts

2018-05-23 Thread Adrien Monteleone
Keith, This might get lost on the mailing list. Please file a bug report and prefix the subject with: “RFE”. (Request For Enhancement) Regards, Adrien > On May 23, 2018, at 11:55 AM, Keith Bellairs wrote: > > Great idea. I did not know about the "right click filter by" on register > windows.

Re: [GNC] Report ROWS

2018-05-23 Thread Adrien Monteleone
Any report can either be opened in, or simply copied and pasted into, a spreadsheet where you can fine tune all aspects of printing. (particularly page breaks) This also gives you the benefit of being able to do additional analysis or include other calculations and likely create better charts u

Re: [GNC] Invoice tax rounding issue in 2.x

2018-05-23 Thread Adrien Monteleone
That PS highlights I think the biggest challenge with the Business Features. As long as they are a means to enter business transactions, no major issue arises. But start trying to use them (and GnuCash in general) as a substitute for a POS system... Regards, Adrien > On May 23, 2018, at 9:29 A

Re: [GNC] Invoice tax rounding issue in 2.x

2018-05-23 Thread Adrien Monteleone
Just out of curiosity, how many possible rounding rules can there be? I shouldn’t imagine more than a handful. I don’t remember where I saw it, but some application I used in the past had options to choose which of several rounding rules you wanted to use. (I also don’t recall if this was financ

Re: [GNC] Trivial feature - View zero accounts

2018-05-23 Thread Keith Bellairs
Great idea. I did not know about the "right click filter by" on register windows. Right click context menu for accounts window would be perfect. On Wed, May 23, 2018 at 12:19 PM, David Carlson wrote: > Keith, > > I did not know about the "View > Filter by.." options being different in > the Acco

Re: [GNC] Trivial feature - View zero accounts

2018-05-23 Thread David Carlson
Keith, I did not know about the "View > Filter by.." options being different in the Accounts window until I read your post. I think that it would make more sense to have the "View > Filter by..." appear as the first selection in the pop-up list when you right click in the page, similar to the way

[GNC] Trivial feature - View zero accounts

2018-05-23 Thread Keith Bellairs
I close accounts at year end. So if "view zero accounts" is not set, all my income and expense accounts disappear. To find them I have to go to "View->File By->Other" just to see them. Then when I want to turn them off again to get rid of historical clutter I have to go the same way. It would be c

[GNC] Deleting an unused tax table (2.6.21)

2018-05-23 Thread Matthew Pounsett
After setting up my tax tables I realized it would be best if I renamed one of the tables I had already created and used, but there is no rename function. So, I created a new table using the name I wanted, and went through each Vendor Bill that used the old table (there are only two) to unpost, ch

[GNC] Report ROWS

2018-05-23 Thread davidbrown.rdps
I note that when printing a report to a PDF file, the page set up is a bit hit and mis when multiple pages. Some lines of entries span into the footer on one page and header of the next giving a split table. Is there any method of having a complete row on one page and the start of a complete row

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Mike or Penny Novack
On 5/23/2018 9:17 AM, Nathanial Jones wrote: The "It can't be fixed," attitude is just wrong, since there is a conceptually simple fix. It may take a while to code, but why not just put a check box or option group into the tax rate setup that defines whether it is a "per item" or "total" rate. I

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Geert Janssens
Op woensdag 23 mei 2018 15:17:52 CEST schreef Nathanial Jones: > The "It can't be fixed," attitude is just wrong, since there is a > conceptually simple fix. > > It may take a while to code, but why not just put a check box or option > group into the tax rate setup that defines whether it is a "pe

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Nathanial Jones
The "It can't be fixed," attitude is just wrong, since there is a conceptually simple fix. It may take a while to code, but why not just put a check box or option group into the tax rate setup that defines whether it is a "per item" or "total" rate. On Wed, May 23, 2018 at 8:46 AM Matthew Pounset

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Matthew Pounsett
Thanks for all your replies. If just the people who have replied in the last 12 hours is any indication, then a lot of people are "living with" a fairly annoying bug. In my case, this is on an invoice I'm generating, not a bill, so I don't feel like I can mess with the data too much. Fortunately

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Mike or Penny Novack
There is no solution to this. Among other things, it would be dependent on the rules of the jurisdiction whether the tax is supposed to be figured per item or on the total of all taxable items. So what would fix it in one case would break it in the other. It simply is true that rounded(a) + rou

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Deva -
For rounding adjustments like these, I typically use the discount columns. In your example, you can do the following to get the final total right - Discount Type = “$" Discount How = “=“ Discount = 0.01 The Tax Invoice report allows you to change some column headers, so I just change the discou

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread R. Victor Klassen
I’ve been living with this for years. The occasional bill has two extra lines (since bills are only internal records it doesn’t matter that they don’t match). The one is called “Tax Error” and is taxable; containing just enough in its amount field to generate a penny of tax. The other is called

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Geert Janssens
Op woensdag 23 mei 2018 03:11:26 CEST schreef Matthew Pounsett: > I've got an off-by-a-cent error on an invoice due to the way taxes are > calculated. GnuCash (2.6.21) is calculating the tax on each individual > taxable item, then summing that up, and adding that value to the subtotal. > This caus

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Maf. King
On Wednesday, 23 May 2018 02:11:26 BST Matthew Pounsett wrote: > I've got an off-by-a-cent error on an invoice due to the way taxes are > calculated. GnuCash (2.6.21) is calculating the tax on each individual > taxable item, then summing that up, and adding that value to the subtotal. > This cause