Re: "Unrealized Losses" in Trial Balance Report

2018-03-22 Thread Richard
HI all, Thanks everyone for your thoughts. Once I see what my accountant does with these foreign currency transactions, I will try entering them back into GnuCash and see what happens. A message from Christopher mentioned stocks and capital gains. I don't have any stocks in my books, but as

Re: Compiling -DWITH_GNUCASH=NO

2018-03-22 Thread Geert Janssens
Op vrijdag 23 maart 2018 06:27:07 WIB schreef Christopher Lam: > Hi Potuz > > This is clever- would you mind documenting the process to run reports > from command line? > > C It's one of my long term goals to separate report generation from report display. That would allow to generate reports

Re: Compiling -DWITH_GNUCASH=NO

2018-03-22 Thread Geert Janssens
Op donderdag 22 maart 2018 21:20:19 WIB schreef Potuz: > Hello, I have a number of scripts that parse my .gnucash sqlite dbase and > produce reports. I'd like to be able to compile and run those programs in a > linux system without gtk+ (in particular no gnome and no webkit-gtk). > However when I

Re: Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread Geert Janssens
Op vrijdag 23 maart 2018 00:01:05 WIB schreef Adrien Monteleone: > Personally, I reply-to-list. I do not ‘reply-all’. Reply-all will send to > the list AND each sender (depending on the message you are replying to) > which then means those people get multiple copies. I doubt this. I believe

Re: Check Printing

2018-03-22 Thread David Reiser
> On Mar 22, 2018, at 9:54 PM, Robert Lewis wrote: > > Hi. I'm looking for a good example of how to specify the font and size of > a line to be printed in a custom .chk file. I know it is specified with > "font_n" ("n" being the line number) but the format of what

Check Printing

2018-03-22 Thread Robert Lewis
Hi. I'm looking for a good example of how to specify the font and size of a line to be printed in a custom .chk file. I know it is specified with "font_n" ("n" being the line number) but the format of what follows is what I cannot find any reference to or an example of. Thanks -- *<<

Re: Compiling -DWITH_GNUCASH=NO

2018-03-22 Thread Potuz
On Mar 23, Christopher Lam wrote: Hi Potuz This is clever- would you mind documenting the process to run reports from command line? I am not running gnucash reports, I wrote my own set of C programs to write tax returns and portfolio performance related reports specialized for Brazilian tax

Re: Compiling -DWITH_GNUCASH=NO

2018-03-22 Thread Christopher Lam
Hi Potuz This is clever- would you mind documenting the process to run reports from command line? C On 23/03/18 04:57, Potuz wrote: On Mar 22, Potuz wrote: Hello, I have a number of scripts that parse my .gnucash sqlite dbase and produce reports. I'd like to be able to compile and run

Default style sheets default setting

2018-03-22 Thread subscriptions
Hello all, I am new to the mailing list and have tried GNUC many years ago. Now I am looking to replace QB with GNUC and running into some issues. To preference this, I am not an accountant or anything near. In fact, My accounting skills are somewhat basic. I have a question on setting the

Re: Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread Adrien Monteleone
Unfortunately, this *is* true for the Gmail web interface. (this has no bearing if you use a different client to view your gmail account) This does not affect the actual thread on the Gnucash Mailman server, or any client that uses the message-id, in-reply-to, or references headers. It only

Re: Compiling -DWITH_GNUCASH=NO

2018-03-22 Thread Potuz
On Mar 22, Potuz wrote: Hello, I have a number of scripts that parse my .gnucash sqlite dbase and produce reports. I'd like to be able to compile and run those programs in a linux system without gtk+ (in particular no gnome and no webkit-gtk). However when I try to compile with

Re: Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread Adrien Monteleone
Note, you can change the default behavior to ‘reply-all’ instead of 'reply' in your settings if you find it a pain to have to switch. Regards, Adrien > On Mar 22, 2018, at 1:50 PM, David Carlson > wrote: > > In Gmail I do not see an option to reply-To-List. > >

Re: Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread Adrien Monteleone
What would really be sweet is for a mail client to offer to allow you to add a message to a thread, or split messages off of a thread. I understand that can be a mess with IDs, but it would just be for your own viewing/use/organization. So far, I’ve not seen any that can do it. (I think some

Re: Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread Adrien Monteleone
As noted, I don’t use the Gmail web interface. But macOS Mail doesn’t have it either. (I do miss Thunderbird for that reason) I simply hit reply-all and then delete the individuals’ emails, leaving only the list e-mail. It is annoying as I’d certainly prefer if Mail offered a reply-list option.

Re: Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread Adonay Felipe Nogueira
> I have noticed an issue on my computer recently that Gmail is not always > correctly displaying threads from the GnuCash user maillists. I have I'm not a Gmail user but I saw a similar thing happening in other situations, not now. a) In case your webmail or email client has the message you

Re: Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread David Carlson
In Gmail I do not see an option to reply-To-List. That does seem to be logical if I could figure out how to do it. David C On Thu, Mar 22, 2018 at 12:01 PM, Adrien Monteleone < adrien.montele...@gmail.com> wrote: > I too noticed a change about a month or two ago. Perhaps it was happening >

Re: "Unrealized Losses" in Trial Balance Report

2018-03-22 Thread Adrien Monteleone
The rounding error I found can be very large depending on the variance between the exchange rate for each transaction and the date of the report. But, I don’t think it affects anything else, because it’s a function of the report, not any math Gnucash otherwise performs. And I’ve never seen this

Re: incorrect starting balance in reconcile

2018-03-22 Thread John Ralls
> On Mar 21, 2018, at 12:22 PM, darrylctx wrote: > > I am trying to reconcile a Bank account. > Everything has been working fine since I opened the account, but recently I > tried to reconcile a statement, and the starting balance of the reconcile is > incorrect. > At

Re: Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread Adrien Monteleone
I too noticed a change about a month or two ago. Perhaps it was happening before, but it seems more frequent lately. My subscribed address is Gmail, but I use macOS mail client on my desktop so it’s not a web vs. client issue. So far that I can tell, it appears though that the issue may not be

GST / HST / VAT on Employee Vouchers

2018-03-22 Thread farside268
Is it possible to add a section for value added tax in employee vouchers? Right now I'm just adding it as a separate line item, but it makes things look awful in my books. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: incorrect starting balance in reconcile

2018-03-22 Thread John C
You can use the Edit->Find menu item to search for entries by their reconcile status. It might help you find an accidentally-inserted transaction. On 3/22/2018 8:43 AM, Colin Law wrote: On 21 March 2018 at 19:22, darrylctx wrote: I am trying to reconcile a Bank

Compiling -DWITH_GNUCASH=NO

2018-03-22 Thread Potuz
Hello, I have a number of scripts that parse my .gnucash sqlite dbase and produce reports. I'd like to be able to compile and run those programs in a linux system without gtk+ (in particular no gnome and no webkit-gtk). However when I try to compile with -DWITH_GNUCASH=NO I pick errors since

Re: "Unrealized Losses" in Trial Balance Report

2018-03-22 Thread Christopher Lam
Hi Richard If I understand 'unrealised gains', this is a known issue. I think any double-entry accounting system will have this issue when currencies or stocks are converted without accounting for capital gains. With stocks we expect to receive capital gains and are usually taxed on these

Re: Save to MySQL

2018-03-22 Thread Colin Law
On 22 March 2018 at 11:33, daniel wrote: > Hello Colin, > > More information: > > - The save didn't succeed, all the tables are empty (Error is: The Server at > URL:// experienced an >> error or encountered bad or corrupt data) > - I'm using root user for MySQL (at least

Re: Finally ready to move from Windoze to Unix, suggestions of flavor of Unix to use **[solved]**

2018-03-22 Thread Mike or Penny Novack
On 3/21/2018 6:05 PM, David Carlson wrote: Linux is not Unix. Nor is BSD. Very few users are interested either of the other two, but they both are very important in the grand scheme of things. David C True about linux and the unixes not being the SAME operating system, but users do not

Re: incorrect starting balance in reconcile

2018-03-22 Thread Colin Law
On 21 March 2018 at 19:22, darrylctx wrote: > I am trying to reconcile a Bank account. > Everything has been working fine since I opened the account, but recently I > tried to reconcile a statement, and the starting balance of the reconcile is > incorrect. > At the end of

Recent posts and replies missing issues in several GnuCash user threads

2018-03-22 Thread David Carlson
I have noticed an issue on my computer recently that Gmail is not always correctly displaying threads from the GnuCash user maillists. I have usually been able to find the missing items by scrolling through the threads, but then I see all the duplicated text in the replies and I get even more

Re: Save to MySQL

2018-03-22 Thread David Carlson
Daniel, Have you tried using your file manager on your local computer to see if you can access the folder containing the data db on the other computer just before trying the GnuCash action? I have sometimes had problems with network discovery working rather slowly. David C On Thu, Mar 22, 2018

Re: Save to MySQL

2018-03-22 Thread daniel
Hello Colin, More information: - The save didn't succeed, all the tables are empty (Error is: The Server at URL:// experienced an > error or encountered bad or corrupt data) - I'm using root user for MySQL (at least for now), DB and tables were created - GnuCash version 2.6.19 (built from

Re: incorrect starting balance in reconcile

2018-03-22 Thread Maf. King
On Wednesday, 21 March 2018 19:22:10 GMT darrylctx wrote: > I am trying to reconcile a Bank account. > Everything has been working fine since I opened the account, but recently I > tried to reconcile a statement, and the starting balance of the reconcile is > incorrect. > At the end of every

Re: incorrect starting balance in reconcile

2018-03-22 Thread Dave H
Sounds like you entered a transaction with a date prior to your last reconciled date or perhaps even before the opening balance of the particular account you're looking at. Check the View >> Filter By... options to ensure you're seeing all the transactions in the account you're trying to

Re: "Unrealized Losses" in Trial Balance Report

2018-03-22 Thread Richard
Thanks for your thoughts, Adrien. Yes, I do have losses from changes in exchange rates between when I booked a currency and the date of the report. However, these changes were tiny compared to the "Unrealized Losses" figure that appeared in the Trial Balance report. So, while I agree that this

incorrect starting balance in reconcile

2018-03-22 Thread darrylctx
I am trying to reconcile a Bank account. Everything has been working fine since I opened the account, but recently I tried to reconcile a statement, and the starting balance of the reconcile is incorrect. At the end of every statement, I put in a trxn with 0 value and the correct ending balance

Re: Save to MySQL

2018-03-22 Thread Colin Law
On 22 March 2018 at 07:39, daniel wrote: > Hello, > > I'm using two machines (both are Ubuntu 16.04) and trying to use MySQL to > save GnuCash data. > In one machine the GnuCash application in the second one MySQL. > > While trying to save the data (with Save As, MySQL

Re: Preferences - Online Banking

2018-03-22 Thread Liz
On Wed, 21 Mar 2018 07:58:01 -0400 R Winstead wrote: > I guess I'm just sending this to the moderator for this group. I > never saw this come across in email so I'm wondering if this was not > released to the group by the moderator, or was there some other > reason?

Re: Save to MySQL

2018-03-22 Thread daniel
Hello, I'm using two machines (both are Ubuntu 16.04) and trying to use MySQL to save GnuCash data. In one machine the GnuCash application in the second one MySQL. While trying to save the data (with Save As, MySQL option) I provide the MySQL information (Host, DB, User and Pass). In MySQL I

Re: Avoid linking 3.parties;was: Unable to download stock quotes

2018-03-22 Thread Adrien Monteleone
> I know about the GnuCash mailman archives thanks. > Is it is possible to see all messages in a thread in 1 tab like you can on > Nabble? I prefer that. > > Regards, Chris Good You could always open the archive by Thread in one tab and open each message as you want to read them in another.

Re: "Unrealized Losses" in Trial Balance Report

2018-03-22 Thread Adrien Monteleone
You might see unrealized losses with multiple currencies to account for the change in value between the time you booked a currency and the date of the report. So if you converted some SGD to USD at some particular exchange rate, and that rate has since changed (very likely) then you will

RE: Avoid linking 3.parties;was: Unable to download stock quotes

2018-03-22 Thread Chris Good
> -Original Message- > From: Frank H. Ellenberger > Sent: Wednesday, 21 March 2018 11:55 PM > To: Chris Good > Cc: gnucash-user@gnucash.org > Subject: Avoid linking 3.parties;was: Unable to download stock quotes > > Hi Chris, > > Am

"Unrealized Losses" in Trial Balance Report

2018-03-22 Thread Richard
Hi there, I’ve been using GnuCash for about a year to run a small business in Singapore. I’m thrilled that it has worked so well, since I have no accounting experience, but I’m trying to create a Trial Balance report for my accountant, and I can’t get it to work right. At the bottom of the