[GNC] Cant get online quotes to work

2019-01-18 Thread Thornes on the Go
OS: Win 10 GnuCash 3.4 F:Q 1.47 Perl 5 v26.1 Have set the Alphavantage key in GnuCash under preferences Trying to get stock updates from Australia and USA ANZ.AX - ASX BRK-B - NYSE I have tried to follow all suggestions but cant get this working, is anyone able to assist? Thanks you

[GNC] Need help setting up OFX. Getting Signer not found on 2 different banking entities? Do I need a certificate?

2019-01-18 Thread socaldood04
Hi all, I see this issue from GNUCash. The same accounts are downloading fine on Quicken 2017. Both fidelity and vanguard returned the same error. It appears there's something wrong in my setup. Is there a missing certificate I need to get? AqBanking v5.7.8.0stable Sending jobs to the bank(s)

Re: [GNC] Reports in whole currency units

2019-01-18 Thread Richard Gaede
Thanks Adrien. I have been the export/spreadsheet route before. Reports get exported as .html files which read into Excel OK except that the column widths are all over the place and its far more time consuming to format them satisfactorily than to surrender and accept 2 decimal place reports.

Re: [GNC] Date Completion - sliding 12 month window

2019-01-18 Thread David Carlson
Parke, I can tell you that I am using release 2.6.17 in Ubuntu 16.04 with Unity desktop and that setting works for me, but all preferences are very slw to respond, just as file saves are too. When I hover over the radio buttons the text background changes, and If I click the button

[GNC] Date Completion - sliding 12 month window

2019-01-18 Thread Parke
Hello, I have used GnuCash since 2003. Today I discovered the Edit -> Preferences -> Date/Time -> Date Completion option. This is an option I have wanted almost every year in January when I am entering data from the preceding December. Unfortunately, I am unable to activate this option. When

Re: [GNC] Windows/Ubuntu Transportable Data File?

2019-01-18 Thread David Cousens
Larry, As Steve and Adrien hav pointed out v3.3 is supported by Ubuntu 18.10 i.e. available from the software centre and Windows has downloads for 3.4 (and previous versions https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/). If you want to stay right up to date buidling

Re: [GNC] Reports in whole currency units

2019-01-18 Thread Adrien Monteleone
Richard, You can also select-all and copy/paste from the report without exporting first, that *should* get you some sane column widths. I don’t use Excel, but I know this works rather well in LibreOffice. Others on here may have some better experience with Excel. (note, as with LibreOffice,

Re: [GNC] Windows/Ubuntu Transportable Data File?

2019-01-18 Thread Adrien Monteleone
#1 as well as any other platform I suppose. Recent reports show 3.4 (as well as 3.3) runs successfully on at least as far back as Bionic. (18.04) So you could opt for the LTS release if you like. #2 as Stephen noted, you can easily pull files off a common drive with little to no issue. (just

Re: [GNC] Copying settings, layout, and colors to another computer

2019-01-18 Thread Adrien Monteleone
You should have copied: ~/your_data_files ~/.local/share/gnucash ~/.local/share/gtk-3.0 ~/.config/gnucash ~/.config/gtk-3.0 If that 2nd directory did not exist, then your GTK3 installation probably hadn’t a need to create it yet. Your custom CSS file (if you made one) should reside in the 4th

Re: [GNC] Treating tax authority as a vendor

2019-01-18 Thread Adrien Monteleone
No, it is one or the other, either use an SX or use the Business Features. You can’t at this time, schedule a recurring invoice, bill, or payment. (Technically, you can schedule the payment, but then you have to manually assign it as a payment to a particular bill when it gets created to make

Re: [GNC] Windows/Ubuntu Transportable Data File?

2019-01-18 Thread Stephen M. Butler
I am running Ubuntu 18.04 on my laptop.  (Dell XPS-13).  My wife runs Windows 10 on her Asus EeePC 1201N.  We move the GnC data files (multiple books) back and forth via a shared drive that sits on the main home PC (also Windows 10). When one wants to work on one set of the books, they grab the

[GNC] Windows/Ubuntu Transportable Data File?

2019-01-18 Thread Larry Long
I have two general questions. - How well supported is GnuCash on the Ubuntu OS? - How transportable would the GnuCash DB be between a computer running Ubuntu and another one that is running Windows 10? I am currently using GnuCash v3.4 on a Windows 10 computer at home.  However, I

[GNC] dpkg-builder

2019-01-18 Thread Stephen M. Butler
Anybody a wizard with dpkg-builder?  Still trying to get a debian package ready for folks.  I'm in over my head. Private mail me -- so we don't use up the bandwidth on either of these mailing lists. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166

Re: [GNC] Tax Issues

2019-01-18 Thread Mike stagl
Thanks! I found the bug fix you mentioned and build gnucash on my Debian 9 machine with the corrected code. It works perfectly! Thank you! Mike From: Alex Aycinena Sent: Thursday, January 17, 2019 12:15:29 AM To: gnucash-user@gnucash.org; m_st...@hotmail.com

Re: [GNC] Copying settings, layout, and colors to another computer

2019-01-18 Thread Tim Kallmer
Thanks everyone. I copied all the referenced files and folders, but the account colors did not come across. I'm copying from Ubuntu 18.10 to 18.10. One missing directory that I did not have compared to the FAQ was HOME/.local/share/gtk-3.0. It doesn't exist. (I did copy HOME/.config/gtk-3.0

Re: [GNC] Treating tax authority as a vendor

2019-01-18 Thread gnucash . dgr9z
Thanks for this. Seems the date issue should be OK if I post and pay the tax bill on the date of the actual transaction. I don't see a way to use scheduled transactions to create/post/pay invoices/bills. If I used a scheduled transaction instead of a bill, what would the implications be,

[GNC] Check for negative amount in scheduled transaction formula

2019-01-18 Thread gnucash . dgr9z
Hi, Is it possible to convert negative numbers to 0 in a formula? something like: a-b < 0 ? 0 : a-b If this needs to be defined as a function someplace, what would it look like, where would it go, and how would it be called from the template? Many thanks, Ron

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

2019-01-18 Thread Adrien Monteleone
In Character Viewer, look up the rupee symbol via a search. Click the glyph for it in the middle pane. You’ll then see a list of font variations on the bottom right. As you click each one, at the top right you’ll get an enlarged version and just below that, you’ll see the name of the font it

Re: [GNC] Copying settings, layout, and colors to another computer

2019-01-18 Thread Michael or Penny Novack
On 1/17/2019 6:31 PM, Adrien Monteleone wrote: I have sometimes wanted to migrate my data and my desired configs without carrying over configs from no longer used apps, thus trimming cruft for a *fresh* start. Yes indeed, that is a time when I also might want to do such "clean up". BUT

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

2019-01-18 Thread Deva -
Geert is probably right. As I mentioned in my previous post, I did try to change the default stylesheet fonts to a few commonly used fonts in documents (Arial/Helvetica/MS Sans Serif), but rupee symbol didn’t come up for any of them. I can see from the character viewer on my Mac that there are

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

2019-01-18 Thread Geert Janssens
Op donderdag 17 januari 2019 15:49:26 CET schreef David T. via gnucash-user: > Not that I am an expert on these issues, but your observation suggests that > the font that the Tax Invoice uses lacks a valid INR symbol. I believe > there are style sheets for that report which can be used to change

[GNC] Trouble entering Fund sale transaction

2019-01-18 Thread Steve Kelem
I have an account that is set up as a Mutual Fund, using Commodity Value. I transferred some $ into the account when the price was $10.00, and converted it to the proper number of shares. I then tried to sell some shares. I entered -1943.2136 shares at a price of $10.02, with a transaction