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

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

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

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?

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

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

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?

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

Re: [GNC] Trivial feature - View zero accounts

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"

Re: [GNC] Report ROWS

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

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

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

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

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

Re: [GNC] Trivial feature - View zero accounts

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.."

[GNC] Trivial feature - View zero accounts

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

[GNC] Deleting an unused tax table (2.6.21)

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,

[GNC] Report ROWS

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

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.

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

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

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

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

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

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.

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

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) +

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

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

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

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