Re: [GNC] Make PDF from reports
Nice to know about the htmltopdf package. On Ubuntu, the closest I found was wkhtmltopdf. But Ubuntu does have Print to PDF built in, and it works great. I'll be using my Ubuntu system more often than the Windows 7 in the long run anyway. Thanks Derek On 2020-10-20 9:45 p.m., Adrien Monteleone wrote: Yes, but I think it is the Draw application of the suite that handles PDF editing. However, since Writer is the app associated to open HTML (exported by GnuCash), most likely that would be used initially for the 'printing to PDF' function. If I recall correctly, LO's PDF generation at one time was superior to Adobe with respect to the standard, but it has been many years since I've read that. So if the OP is already using LO, no need for Bullzip as LO can export/print to PDF directly. Also, if a user has a *nix system on their network, they can easily set up a cups-pdf printer on that system as a shared printer for anyone else on the network to use. This still doesn't get around the GnuCash Webkit issue though. You'd still need to export as HTML and go from there. Also, if on a *nix system, and you don't sweat the command line, there is an htmltopdf package most likely available to you for install as well, so you can skip the clicks of a browser or LO. Regards, Adrien On 10/20/20 1:42 PM, Michael or Penny Novack wrote: For still using Windows 7. Can't you still get LibreOffice for 7? I'm pretty sure if you have a document open under "Writer" you can export as PDF. The point is, I used to be under Win 7 and used the LibreOffice Suite (instead of MS Office) Michael ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "Unrealized Losses" in Trial Balance Report
Hi all I mentioned the following workaround the other day but have seen no response. Am I correct in thinking the workaround is necessitated by a bug i.e. the Trial Balance report uses "Unrealized Losses" (which results in the report not balancing) instead of "Trading Gains/Losses" (which does). Should I log this as a bug? Regards Phil Diacono On 18/10/20 11:49 am, Phil Diacono wrote: > Hi all, > > I searched on this and found an email thread with the above title, > initiated thusly: > > "On Mar 22, 2018, at 1:02 AM, Richard " > > where Richard reports the lack of balance in his Trial Balance report. > The responses to his email seemed to be put it down to rounding errors > and/or Check > > I also use Trading Accounts and I've had this problem for a few years. > > My workaround has been to > -1- export Trial Balance report to html > -2- open report in spreadsheet > -3- replace report's totals with sum() functions of above rows (the > sum() and report totals numbers should match) > -4- do the same for the Balance Sheet report of the same date > -5- Note: the gnucash Trial Balance report always has a positive number > but changes the line description from Trading Gains to Trading Losses if > it would otherwise be negative. In the spreadsheet, make this number > negative for Trading Losses (or keep as positive for Trading Gains), and > change the line description to "Trading Gains/Losses" > -6- Back in the Trial Balance spreadsheet, move the "Unrealized Losses" > line out of the items being summed > -7- insert a new line copied from the "Trading Gains/Losses" line of > the Balance Sheet > -8- move the "Trading Gains/Losses" value over to the Credit column and > ensure the Totals include it. > -9- possibly add a line: "Rounding 0.01" to Debit or Credit column. > -10- hey presto, the numbers in the Trial Balance balance! > > Perhaps this just works for my setup (my only "commodities" are > currencies). But it would appear that wherever the "Unrealized Losses" > value comes from, it is not of much use whereas the "Trading > Gains/Losses" value is just the job. > > And perhaps I am violating some rule about not having negative numbers > in Balance Sheets or Trial Balances. > > Anyway, I would be interested in comments from others on how they > approach this problem and whether they have a workaround. > > Regards > > Phil > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Button1 & Button2
Paul, The confusion there possibly arises from an attempt to provide a description which is both OS independent and specific device independent. The documenters have to cover single button mice in MacOSX, and a huge variety of mouse devices in the Windows and Linux environments as well as trying be LH/RH independent for those of us with other handedness. Two of my mice have 5 buttons and two scroll wheels and their functions are totally reprogrammable at the OS level and in some cases at the individual application level, The button1 normally refers to the LH button and button 2 to the RH button. The following thread in the developer forum archives may help https://lists.gnucash.org/pipermail/gnucash-devel/2019-October/044293.html. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] ASX price lookup failing
Thanks Geoff - worked a treat My only problem was finding the right folder. Flatpak made an interesting directory - it was about three pages long. Thanks, Mark On Thu, Oct 22, 2020 at 8:27 PM Geoff wrote: > Hi Mark > > See this thread: > > http://gnucash.1415818.n4.nabble.com/GNC-ASX-quotes-not-working-tc4722167.html > > Temporary fix attached towards the end. > > Regards > > Geoff > = > > On 21/10/2020 4:45 pm, Mark Walters wrote: > > Hi, > > Is anyone else having trouble with price lookups to the Australian stock > > exchange? > > > > Looks like they updated their website and all price queries now fail. > > > > Gnucash v 4.2, finance::quote 1.49 > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Button1 & Button2
I was under the impression that "Button1" refers to the primary button, and "Button2" refers to the secondary one. Those were typically called the left mouse and right mouse buttons, respectively, but with customizable hardware, directional references were discouraged. But, I'm not any sort of expert. Original Message From: Adrien Monteleone Sent: Thu Oct 22 12:46:08 EDT 2020 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Button1 & Button2 Looks like a documentation error where a translatable string 'placeholder' was literally placed in the text rather than the proper language-specific label for the buttons. A bug should probably be filed for this. Regards, Adrien On 10/22/20 11:05 AM, Paul Konnersman wrote: > On pages 75 & 76 (87 & 88 of the printer dialog) of the Help Manual there > are references to "Button1" and "Button.2" I have not been able to > identify either of these buttons. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 4.2 on Windows 10 keeps randomly crashing
> On Oct 22, 2020, at 9:56 AM, simongarrett > wrote: > > I also get crashes when editing numeric values in deposit/withdrawl or > payment/charge fields. W10 20H2 (latest build), gnucash 4.2. These all sound like https://bugs.gnucash.org/show_bug.cgi?id=797959 which has been fixed for GnuCash 4.3. Windows and flatpak users can use a recent nightly build. The workaround is to make sure that numbers have no thousands separators when you're entering or editing them. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 4.2 on Windows 10 keeps randomly crashing
I also get crashes when editing numeric values in deposit/withdrawl or payment/charge fields. W10 20H2 (latest build), gnucash 4.2. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Button1 & Button2
Looks like a documentation error where a translatable string 'placeholder' was literally placed in the text rather than the proper language-specific label for the buttons. A bug should probably be filed for this. Regards, Adrien On 10/22/20 11:05 AM, Paul Konnersman wrote: On pages 75 & 76 (87 & 88 of the printer dialog) of the Help Manual there are references to "Button1" and "Button.2" I have not been able to identify either of these buttons. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Button1 & Button2
On pages 75 & 76 (87 & 88 of the printer dialog) of the Help Manual there are references to "Button1" and "Button.2" I have not been able to identify either of these buttons. Paul *Paul M. Konnersman* *konners...@gmail.com * *781-639-0616* ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] cash basis and accrual basis
And further, if you’re working with the business features, you will need to post invoices with a post date matching the period in which payment is received. This may involve unposting and reposting. They have to be posted to print without the “invoice in progress…” notation, but then if you want strict cash accounting you get to change the posted date to a period in which you expect to receive payment, and possibly again when your expectations turn out to be wrong. With bills it’s easier, as you have control over when you pay them. > On Oct 22, 2020, at 5:14 AM, Adrien Monteleone > wrote: > > It isn't a 'view'. If you want to work on cash basis, you record the > transaction when money physically (or digitally) changes hands. If you want > to work on an accrual basis, you record the transaction when the expense is > incurred or the income is earned without regards to actual exchanges. > > > Regards, > Adrien > > On 10/21/20 5:34 AM, HaxNet wrote: >> Hi, >> Is there a way to choose which basis I want to view? Right now, it's >> defaulted to Accrual. >> When I pick the Income Statement, and income hasn't been received yet, I >> don't want it to show that there's revenue. >> Thank you in advance. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] ASX price lookup failing
Hi Mark See this thread: http://gnucash.1415818.n4.nabble.com/GNC-ASX-quotes-not-working-tc4722167.html Temporary fix attached towards the end. Regards Geoff = On 21/10/2020 4:45 pm, Mark Walters wrote: Hi, Is anyone else having trouble with price lookups to the Australian stock exchange? Looks like they updated their website and all price queries now fail. Gnucash v 4.2, finance::quote 1.49 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] cash basis and accrual basis
It isn't a 'view'. If you want to work on cash basis, you record the transaction when money physically (or digitally) changes hands. If you want to work on an accrual basis, you record the transaction when the expense is incurred or the income is earned without regards to actual exchanges. Regards, Adrien On 10/21/20 5:34 AM, HaxNet wrote: Hi, Is there a way to choose which basis I want to view? Right now, it's defaulted to Accrual. When I pick the Income Statement, and income hasn't been received yet, I don't want it to show that there's revenue. Thank you in advance. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] ASX price lookup failing
Hi, Is anyone else having trouble with price lookups to the Australian stock exchange? Looks like they updated their website and all price queries now fail. Gnucash v 4.2, finance::quote 1.49 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] cash basis and accrual basis
Hi, Is there a way to choose which basis I want to view? Right now, it's defaulted to Accrual. When I pick the Income Statement, and income hasn't been received yet, I don't want it to show that there's revenue. Thank you in advance. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Make PDF from reports
I’ve had a similar problem. Saving to PDF directly from Gnucash (3.x in my experience) doesn’t do the paging, titles, headers correctly. It’s been that way for a long time. Best workaround is to use the print-to-pdf pseudo-printer in your operating system. That way, the PDF is generated as if it were being actually printed. Windows 10, for instance, has a “Microsoft Print to PDF” printer selection that works, unless it’s been removed by somebody. On Tue, 20 Oct 2020 14:20:27 Fran_3 mailbox0...@yahoo.com wrote: > It looks to me like a printer problem and not a GnuCash problem. > If you are on a Windows PC open Notepad and see if you can print a? test > document from there.If > you are on Linux open your text editor and to the > same thing.Ditto for other's like Apple... I guess. > Alternately make sure you have the correct printer selected when you try to > print from GnuCash. > Try opening one of the built in reports and printing it. > If none of the above works maybe someone else here on the list can pitch in. > >> On Tuesday, October 20, 2020, 12:56:19 AM EDT, Derek Zehr >> wrote: >> >> Hello, >> >> I just created my first-ever report in GnuCash, to report some finances with >> a forum I'm involved with. This is the window I get when I hit Make PDF, and >> specify a valid file name in my documents folder. GnuCash Version: 4.1 Build >> ID: 4.1+(2020-07-25) on Windows 7. >> >> Hope it something simple. Not sure what to do to resolve something like >> this. >> >> Thanks, >> >> Derek Zehr ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.