Re: [GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread David T. via gnucash-user
Stephen, > On Aug 14, 2018, at 4:50 PM, Stephen M. Butler wrote: > > On 08/14/2018 04:24 PM, David T. wrote: >> Steve, >> >> Thanks for your input. I believe we’re in agreement here; I wasn’t trying to >> suggest that GC become a DBMS, but rather it would learn to utilize DBMS >> features

Re: [GNC] Disconnect between balance on client list and account statement

2018-08-14 Thread Roger Oliver
Adrien, A challenge here is that the GnuCash I am using is in Spanish, that is the accounting terms and reports and in Spanish so I’m guessing at what the names are in English. I couldn’t figure out which report was the aging report because of that. The best I can guess is the following:

Re: [GNC] Disconnect between balance on client list and account statement

2018-08-14 Thread Adrien Monteleone
That is a challenge. I don’t speak Spanish, but those translations via translate.google seem to check out, though I’m a little fuzzy on the first two, but since the first one has Clientes as plural and that report indeed does report on all customers, and the second as Estado does transalate to

[GNC] Disconnect between balance on client list and account statement

2018-08-14 Thread rmomxtx
I have a customer who ended the last fiscal year (school year) with a zero balance owed but still shows owing $1500 in the customer overview but her statement shows zero balance. I use the customer overview to manage overdue accounts by sorting according to the balance due. In her case it should

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread Stephen M. Butler
On 08/14/2018 04:24 PM, David T. wrote: > Steve, > > Thanks for your input. I believe we’re in agreement here; I wasn’t trying to > suggest that GC become a DBMS, but rather it would learn to utilize DBMS > features that many seem to expect. > > I’m not great with the appropriate terminology to

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread David T. via gnucash-user
Steve, Thanks for your input. I believe we’re in agreement here; I wasn’t trying to suggest that GC become a DBMS, but rather it would learn to utilize DBMS features that many seem to expect. I’m not great with the appropriate terminology to use. Do you have language I could use that would

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread Stephen M. Butler
On 08/14/2018 03:05 PM, David T. via gnucash-user wrote: > Hello, > > In response to Bug 777893 (https://bugs.gnucash.org/show_bug.cgi?id=777893 > ), I have written a more > detailed description of the storage choices available to users for

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread Adrien Monteleone
David, Here are a few things I noticed. They’re really personal preferences, but making these changes should help this read a little more clearly. -- The second sentence of 2.5.1 is superfluous. > “The default file storage format is XML, while a number of flavors of SQL > storage are

[GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread David T. via gnucash-user
Hello, In response to Bug 777893 (https://bugs.gnucash.org/show_bug.cgi?id=777893 ), I have written a more detailed description of the storage choices available to users for insertion into the Tutorial & Concepts Guide at section 2.5. Given the

[GNC] Tips & CSS rule for navigating the Budget window with the keyboard

2018-08-14 Thread Adrien Monteleone
While investigating bug 760194: https://bugs.gnucash.org/show_bug.cgi?id=760194 I figured this out: With a cell in focus, enter a value. If you want to move right or left, first press TAB to set the value, then use left/right arrow keys to move the focus. If you want to move up or down,

Re: [GNC] keeping entities separate

2018-08-14 Thread Stephen M. Butler
On 08/13/2018 10:28 PM, patrushkha via gnucash-user wrote: > Thanks for responding. I am clear that I want to have all the entities > separate- I thought I had set them up that way, but cannot discern how to > access them individually, and that's why I think I might have missed > something in

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2018-08-14 Thread Mike or Penny Novack
On 8/13/2018 11:29 AM, azalea4va wrote: I addressed this in the file I provided. There is one and only one correct answer mathematically. I am surprised the moderators have not stepped in. If you want to continue this, I suggest off list. Michael D Novack

Re: [GNC] Trial Balance report error

2018-08-14 Thread James Thorpe
Thanks, bugfix edit to html-utilities.scm seems to have worked! On 14/08/2018 15:00, Christopher Lam wrote: https://bugs.gnucash.org/show_bug.cgi?id=796696 Known bug, fixed for next release. This bug report has instructions for fixing in interim. On Tue, 14 Aug 2018, 19:52 James Thorpe

Re: [GNC] keeping entities separate

2018-08-14 Thread Mike or Penny Novack
On 8/14/2018 1:28 AM, patrush...@aol.com wrote: Thanks for responding. I am clear that I want to have all the entities separate- I thought I had set them up that way, but cannot discern how to access them individually, and that's why I think I might have missed something in the initial set up

Re: [GNC] Column widths again

2018-08-14 Thread Graham Balin
Thanks. doesn't work for me. However, I have discovered that closing Gnucash and re-opening re-sets things, so as long as I leave the column widths alone, all is well. The moment I try to re-size, bang. Masterly inactivity is called for, I think! -- Cheerio, Graham On Mon, 13 Aug 2018 at

Re: [GNC] Trial Balance report error

2018-08-14 Thread Christopher Lam
https://bugs.gnucash.org/show_bug.cgi?id=796696 Known bug, fixed for next release. This bug report has instructions for fixing in interim. On Tue, 14 Aug 2018, 19:52 James Thorpe wrote: > Dear List > > I just upgraded to the latest version on Windows (3.2) and now it seems > the Trial Balance

[GNC] Trial Balance report error

2018-08-14 Thread James Thorpe
Dear List I just upgraded to the latest version on Windows (3.2) and now it seems the Trial Balance report is not working (no matter what options I choose, it just returns "Report error"). I was previously on a version around 2.6 I think. Can anyone give me guidelines as to how to trace the

Re: [GNC] Unable to save to database. Build ID: 3.2+ (2018-06-24)

2018-08-14 Thread mike
On Mon, 2018-08-13 at 12:05 -0700, John Ralls wrote: > > On Aug 13, 2018, at 11:20 AM, mike wrote: > > > > Look in the trace file [1] and your MySQL logs for error messages. > > Regards, > John Ralls > > [1] https://wiki.gnucash.org/wiki/Tracefile > Thanks, that was the sort of information

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-14 Thread Deva -
Can you please share a screenshot? Of both CSV import setting screen and the definition of the security in the security editor. The CSV import price screen should also allow settings for date formats, locale, delimiters and such. Once I look at your whole import screen, I may be able to help

Re: [GNC] GnuCash Theme Library

2018-08-14 Thread Peter Jackson
Michael, I think this is a good idea. There certainly is much more to be discovered, and there are conflicts and associations that could be unravelled. It's a matter of time and inclination, and needs the participation of someone like Adrien who knows his way around the code. As for me, I can