[GNC] Cant get online quotes to work

[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 

Kevin

Sent from Mail for Windows 10

___
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] Need help setting up OFX. Getting Signer not found on 2 different banking entities? Do I need a certificate?

[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)
Locking user 
Sending request...
Connecting to server...
Resolving hostname "vesnc.vanguard.com" ...
IP address is "192.175.192.161"
Connecting to "vesnc.vanguard.com"
Connected to "vesnc.vanguard.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-128-CBC:SHA1
TLS: Warning - The server has chosen unsafe SSL-Ciphers!
Signer not found
Certificate is not trusted
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 400 (Bad Request)
Error parsing server response
Unlocking user xx
Postprocessing jobs
Job Get Transactions: finished
Resetting provider queues
___
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] Reports in whole currency units

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


Thanks & regards

Richard

On 18/01/2019 12:24, Adrien Monteleone wrote:

Other than entering your transactions in whole dollars, no.

An option would be to export or copy/paste to a spreadsheet and format those 
cells to truncate or round the amounts. There you can also show amounts as 
multiples of any value you like, for example, reporting in K’s or M’s of 
dollars.

Regards,
Adrien


On Jan 17, 2019, at 6:39 PM, Richard Gaede  wrote:

Hi,

I have explored every avenue I could see to get reports to use whole dollar 
amounts rather than dollars and cents. Is there some way I have missed to 
configure reports to display whole dollars only?

Any input welcomed.

Thanks & regards

--

Richard Gaede

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





--

Richard Gaede

Trustee

___
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] Date Completion - sliding 12 month window

[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 it
takes 10-15 seconds for the main GnuCash window in the background to 'wink'
to black and white, and revert to color then the setting finally changes.

David C

On Fri, Jan 18, 2019 at 7:01 PM Parke  wrote:

> 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 I click on the "In a sliding 12-month window ..." option, the
> corresponding radio button turns solid grey for slightly more than one
> second.  Then the radio button reverts to a solid white color.  (The
> "In the current calendar year" option remains selected [i.e. with a
> small black circle] the entire time.)
>
> I also tried selecting the "sliding" option in a new set of books.  I
> was still unable to activate the "sliding" option.  However, with a
> new, empty set of books, the solid grey circle appeared only for a
> tiny fraction of a second.
>
> Is there something I am missing?  Or is the sliding date window option
> non-functional?
>
> I am running on Ubuntu 18.04, running GnuCash 2.6.19.  I am using the
> Openbox window manager.  (In other words, I am using neither Unity nor
> Gnome.)  No messages are written to stdout / stderr.
>
> Thank you,
>
> Parke
> ___
> 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.

[GNC] Date Completion - sliding 12 month window

[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 I click on the "In a sliding 12-month window ..." option, the
corresponding radio button turns solid grey for slightly more than one
second.  Then the radio button reverts to a solid white color.  (The
"In the current calendar year" option remains selected [i.e. with a
small black circle] the entire time.)

I also tried selecting the "sliding" option in a new set of books.  I
was still unable to activate the "sliding" option.  However, with a
new, empty set of books, the solid grey circle appeared only for a
tiny fraction of a second.

Is there something I am missing?  Or is the sliding date window option
non-functional?

I am running on Ubuntu 18.04, running GnuCash 2.6.19.  I am using the
Openbox window manager.  (In other words, I am using neither Unity nor
Gnome.)  No messages are written to stdout / stderr.

Thank you,

Parke
___
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] Windows/Ubuntu Transportable Data File?

[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 GnuCash on Ubuntu is not too 
difficult. I usually runmy own build the
current stable release as a production version and have the master and/or  
maint branches of development version
available for testing (but never on my production data files only copies of 
them).

Another option for transporting files between computers on a local network is 
to install samba (network access to
Microsoft File system) on your ubuntu system and setup samba shares between 
your windows and ubuntu systems. Getting the
permissions sorted can be fun. There are plenty of tutorials/instructions 
online for Ubuntu systems. Once up and working
access can be pretty seamless.

I use a copy of my datafile in my Dropbox account for portability between 
computers and use cron jobs to maintain
separate backups on all my computers and an NAS. Need to be careful not to have 
it open from two machines at once  and
give it time to synchronize after closing the file on one machine and opening 
it on another (usually < 1min) but other
than that it is seamless.

David Cousens




On Fri, 2019-01-18 at 20:34 +, Larry Long wrote:
> 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 recently purchased a small notebook
> that came with Windows 10, but that I am considering reworking to Ubuntu.  I 
> would like to take the small notebook
> with me on trips and have my GnuCash file available for access.
> If I interpret this webpage correctly, it appears that a GnuCash v3.3 edition 
> is supported on Ubuntu Cosmic (18.10) 
> https://packages.ubuntu.com/cosmic/gnucash
> I realize that having both PCs on Windows 10 would eliminate potential 
> transport issues.  However, the SSD storage
> (non-upgradeable) on the notebook is only 30GB, which Windows eats for lunch.
> Another possible option I've thought of is reserving the builtin SSD for 
> Windows OS and attempting to use a 128GB SD
> card for installation and running of all applications (such as GnuCash, 
> LibreOffice, etc.).
> Thank you for suggestions and recommendations.
> Larry
> 
> ___
> 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] Reports in whole currency units

[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, 
Excel might have multiple ways to bring in data. Other than just trying to open 
an HTML file, see if there is an ‘insert sheet from file’ or similar option)

Regards,
Adrien

> On Jan 18, 2019, at 5:03 PM, Richard Gaede  wrote:
> 
> 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.
> 
> Thanks & regards
> 
> Richard
> 
> On 18/01/2019 12:24, Adrien Monteleone wrote:
>> Other than entering your transactions in whole dollars, no.
>> 
>> An option would be to export or copy/paste to a spreadsheet and format those 
>> cells to truncate or round the amounts. There you can also show amounts as 
>> multiples of any value you like, for example, reporting in K’s or M’s of 
>> dollars.
>> 
>> Regards,
>> Adrien
>> 
>> 
>>> On Jan 17, 2019, at 6:39 PM, Richard Gaede 
>>>  wrote:
>>> 
>>> Hi,
>>> 
>>> I have explored every avenue I could see to get reports to use whole dollar 
>>> amounts rather than dollars and cents. Is there some way I have missed to 
>>> configure reports to display whole dollars only?
>>> 
>>> Any input welcomed.
>>> 
>>> Thanks & regards
>>> 
>>> -- 
>>> 
>>> Richard Gaede
> 


___
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] Windows/Ubuntu Transportable Data File?

[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 don’t have two people simultaneously try to access it)

Some people have a bit of success keeping their data file in the cloud via 
Dropbox or other service. I’ve seen some threads here on hiccups now and then, 
so if you want to go that route, best to do a list search for those topics to 
avoid any pitfalls.

A likely simple and relatively painless method would be a USB thumbdrive to 
swap between the machines.

Regards,
Adrien

> On Jan 18, 2019, at 2:34 PM, Larry Long  wrote:
> 
> 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 recently purchased a small notebook that came with Windows 10, but that I 
> am considering reworking to Ubuntu.  I would like to take the small notebook 
> with me on trips and have my GnuCash file available for access.
> If I interpret this webpage correctly, it appears that a GnuCash v3.3 edition 
> is supported on Ubuntu Cosmic (18.10) 
> https://packages.ubuntu.com/cosmic/gnucash
> I realize that having both PCs on Windows 10 would eliminate potential 
> transport issues.  However, the SSD storage (non-upgradeable) on the notebook 
> is only 30GB, which Windows eats for lunch.
> Another possible option I've thought of is reserving the builtin SSD for 
> Windows OS and attempting to use a 128GB SD card for installation and running 
> of all applications (such as GnuCash, LibreOffice, etc.).
> Thank you for suggestions and recommendations.
> Larry
> 
> ___
> 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] Copying settings, layout, and colors to another computer

[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 location above. If you were concerned with *cleaning* your 
installation as I noted in an earlier reply, then I would have left this one 
out anyway.

As for account colors, I’m not sure on that one. Those should be stored with 
the book itself. Did you double check all of your preference settings and do 
they match on both machines? Perhaps one machine has the custom account colors 
preference turned off. (that should have migrated properly though, odd only one 
preference is different)

Finally, when replying to a digest message, *please* strip out the parts of the 
digest that aren’t relevant to your topic. I just had to delete about 6 feet of 
text before sending this.

Regards,
Adrien

> On Jan 18, 2019, at 11:25 AM, Tim Kallmer  wrote:
> 
> 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 however.)
> 
> On Fri, Jan 18, 2019 at 6:11 AM  wrote:
> 


___
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] Treating tax authority as a vendor

[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 the 
Business Features cognizant of it.)

You don’t want to manually edit or create any transaction directly in either 
the A/R or A/P accounts that were created when you activated the Business 
Features, those are special accounts. If you go the SX route you won’t be 
involving the standard A/P account. You’d need to make a generic Liability 
account and label it ‘Other Accounts Payable’ or something similar. It *can* be 
set as a child of the main A/P account though so the balances roll up on the 
Accounts Tab and in reports. (if you choose that report option)

The SX route would also not tie anything to a Vendor because the Business 
Features won’t ’see’ those transactions. But you can still run some reports 
(like the Transaction Report) which could key off the Description(Payee) in 
multiple accounts. Where you’d lose something reporting-wise would be with 
respect to the Vendor Report and Payables Report. (at least as they are 
presently designed)

If you have no issue forgoing the Due Reminder and posting/paying the same day, 
I’d say just stick with the Business Features. If your bills are similar each 
period, you can simply duplicate the last one and adjust amounts for each line 
item. I do this with most all of my bills as many of them have recurring line 
items each month/year, etc. It saves me lots of typing time.

Regards,
Adrien



> On Jan 18, 2019, at 11:21 AM, gnucash.dg...@ncf.ca wrote:
> 
> 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, other than loosing the association with a vendor? 
> Would it gum anything up (reports etc) to post directly to AP?
> 
> Ron
> 
> - Original Message -
> From: "Adrien Monteleone" 
> To: "Gnucash Users" 
> Sent: Thursday, January 17, 2019 3:48:08 PM
> Subject: Re: [GNC] Treating tax authority as a vendor
> 
> Ron,
> 
> I do this for property taxes with no issues that I can think of.
> 
> If you want to do this with pass through payments like sales taxes/VAT you 
> might need to think carefully.
> 
> In such cases, you’d likely post via the invoice the tax charged/collected to 
> a "Liability:Sales Tax Due" account or something similar.
> 
> Entering a bill for the amount would ‘pay’ this upon posting and transfer the 
> amount to A/P. You may be fine with this, but if you’re expecting to use that 
> special liability account as a reference to what is owing or helping you to 
> track collections vs. remittances, you’ll run into some mental gymnastics on 
> the dates.
> 
> If you wait to post the tax bill till its actual payment date, you’ll forgo 
> the Bills Due Reminder feature for it.
> 
> Instead, you might want to just use a Scheduled Transaction for whatever day 
> of the month/quarter and be sure to set it for manual review so you can 
> tailor the amounts. With this, you might also be able to use a variable to 
> assist with the manual entry. It will prompt you for the variable’s value 
> when you agree to post the transaction. (such as the total sales you are 
> reporting and then the SX will have formulas to calculate the tax owed based 
> on those sales, if that is how you file, you’ll have to tailor that to your 
> local laws/methods) I know my local jurisdictions will collect for several 
> authorities with one payment, and then they let you deduct a “Vendor’s 
> Compensation” from that. (usually something small like 1 or 2% of the tax 
> owed) That could be broken out in two or more splits. That Vendor 
> Compensation is technically a non-operations revenue stream, not just a 
> reduction of liability. (depending on your jurisdiction) The SX could 
> calculate all of this based on the Total Sales variable you are reporting.
> 
> There might be some other considerations. Perhaps someone else who does or 
> has tried this can chime in.
> 
> Regards,
> Adrien
> 
>> On Jan 17, 2019, at 6:24 AM, gnucash.dg...@ncf.ca wrote:
>> 
>> Hi all,
>> 
>> Is it recommended/not recommended to set up your local tax authority/ies as 
>> vendors and pay taxes against bills? Are there advantages or disadvantages 
>> to doing this from an accounting perspective? Similarly, are their design 
>> assumptions in Gnucash that would make it a good/bad way to set up tax 
>> payments?
>> 
>> Thanks in advance!
>> 
>> Ron
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

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

[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 copy off
the shared drive and put it where GnC wants to find it.  Make the
changes and copy the file back to the shared drive.  So far, we both
haven't been updating at the same time!   

On 1/18/19 12:34 PM, Larry Long wrote:
> 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 recently purchased a small notebook that came with Windows 10, but that I 
> am considering reworking to Ubuntu.  I would like to take the small notebook 
> with me on trips and have my GnuCash file available for access.
> If I interpret this webpage correctly, it appears that a GnuCash v3.3 edition 
> is supported on Ubuntu Cosmic (18.10) 
> https://packages.ubuntu.com/cosmic/gnucash
> I realize that having both PCs on Windows 10 would eliminate potential 
> transport issues.  However, the SSD storage (non-upgradeable) on the notebook 
> is only 30GB, which Windows eats for lunch.
> Another possible option I've thought of is reserving the builtin SSD for 
> Windows OS and attempting to use a 128GB SD card for installation and running 
> of all applications (such as GnuCash, LibreOffice, etc.).
> Thank you for suggestions and recommendations.
> Larry
>
> ___
> 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.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8


___
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] Windows/Ubuntu Transportable Data File?

[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 
recently purchased a small notebook that came with Windows 10, but that I am 
considering reworking to Ubuntu.  I would like to take the small notebook with 
me on trips and have my GnuCash file available for access.
If I interpret this webpage correctly, it appears that a GnuCash v3.3 edition 
is supported on Ubuntu Cosmic (18.10) https://packages.ubuntu.com/cosmic/gnucash
I realize that having both PCs on Windows 10 would eliminate potential 
transport issues.  However, the SSD storage (non-upgradeable) on the notebook 
is only 30GB, which Windows eats for lunch.
Another possible option I've thought of is reserving the builtin SSD for 
Windows OS and attempting to use a 128GB SD card for installation and running 
of all applications (such as GnuCash, LibreOffice, etc.).
Thank you for suggestions and recommendations.
Larry

___
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] dpkg-builder

[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
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Tax Issues

[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
Subject: Re: Tax Issues

Mike,

- Forwarded message --
From: Mike stagl mailto:m_st...@hotmail.com>>
To: "gnucash-user@gnucash.org" 
mailto:gnucash-user@gnucash.org>>
Cc:
Bcc:
Date: Wed, 16 Jan 2019 17:51:04 +
Subject: [GNC] Tax Issues
I'm using GnuCash 3.3 on Debian 9.

I have an existing GnuCash file from 2018 that I would like to modify
to start using the the Tax Reporting features of GnuCash.  It doesn't
appear to be working.  Here is what I have tried.

Edit -> Tax Reporting Options
I EDIT Income Tax Identity to Individual (U.S. Form 1040) and enter a
name like "Tax"; select an expense account; click Tax Related checkbox;
 I pick a form from Schedule E on the list; and I click OK.

When I view the accounts tab, the Tax Info column displays "Tax Entity
Type Not Specified".  Also, the Tax Report from the Reports menu comes
up with no data (it says I need to enter the Tax Report Options dialog
to set up tax Entity Types).

I see a few comments about the tax stuff not working from time to time,
I am wondering what the latest is in version 3.3.

Any ideas?  Thanks everyone!

Mike

-- Forwarded message --
From: Adrien Monteleone 
mailto:adrien.montele...@lusfiber.net>>
To: "gnucash-user@gnucash.org" 
mailto:gnucash-user@gnucash.org>>
Cc:
Bcc:
Date: Wed, 16 Jan 2019 14:45:43 -0600
Subject: Re: [GNC] Tax Issues
Sorry I don’t have a copy of 3.3 handy to test, but on 3.4 it works as 
expected. (I’m using MacOS)

As a side note, I did notice how annoying it is that one can’t assign multiple 
accounts to be tax related without exiting the dialog. Clicking ‘OK’ closes the 
dialog and the user has to go back to Edit > Tax Reporting Options, find the 
next account, mark it tax related, choose a form, click ‘OK’, rinse repeat. It 
seems to me there should be an ‘Apply’ button that is missing.

Regards,
Adrien


This is a known issue.

If you entered Tax Name and Tax Type in an earlier version, the data persists. 
There was a problem in the generation of the Tax Report but that was fixed in 
the latest release. So if you had already entered the Tax Name and Tax Type 
earlier, you can generate the Tax Report.

However, if you hadn't previously entered the Tax Name and Tax Type, the 
current release won't save it (it's a bug). The fix for the bug will be 
available in the next release.

Regards,

Alex
___
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] Copying settings, layout, and colors to another computer

[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 however.)

On Fri, Jan 18, 2019 at 6:11 AM  wrote:

> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>1. Re:  Features (Stephen M. Butler)
>2. Re:  Tax Issues (Adrien Monteleone)
>3. Re:  Treating tax authority as a vendor (Adrien Monteleone)
>4. Re:  Currency symbol (INR) not showing on Tax Invoice report
>   (Adrien Monteleone)
>5.  Copying settings, layout, and colors to another computer
>   (Tim Kallmer)
>6. Re:  Copying settings, layout, and colors to another computer
>   (Adrien Monteleone)
>7. Re:  Copying settings, layout, and colors to another computer
>   (Michael or Penny Novack)
>8. Re:  Copying settings, layout, and colors to another computer
>   (Adrien Monteleone)
>9. Re:  Copying settings, layout, and colors to another computer
>   (David Cousens)
>   10.  Reports in whole currency units (Richard Gaede)
>   11. Re:  Reports in whole currency units (Adrien Monteleone)
>   12.  Trouble entering Fund sale transaction (Steve Kelem)
>   13. Re:  Currency symbol (INR) not showing on Tax Invoice report
>   (Geert Janssens)
>   14. Re:  Currency symbol (INR) not showing on Tax Invoice report
>   (Deva -)
>
>
> --
>
> Message: 1
> Date: Thu, 17 Jan 2019 09:34:47 -0800
> From: "Stephen M. Butler" 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Features
> Message-ID: 
> Content-Type: text/plain; charset=utf-8
>
> On 1/16/19 11:27 AM, Kevin Kelly wrote:
> > I?ve used Mondeydance for a long time. Unfortunately, updates to Mac OS
> have impacted mouse actions and it is difficult now to navigate. I have no
> complaints, it is free and I?ve gotten good use. Now, I need a replacement
> and I?m considering GNUCASH. Can it:
> >
> > 1. Import transactions from banking accounts using QFX?
> Yes.? I use that feature for both my bank and credit card transactions.
> > 2. Does it allow for backup/recovery?
> Yes.? But you need to ensure that you have a system-wide backup/recovery
> strategy in place.? It will write the pre-changed file as a backup
> before overwriting it with the changed data.? But, you need to get it
> off the system to a safe place in case you lose your hard drive (or house).
> > 3. Can I import data from Moneydance or do I start all over?
> Google search indicates that Moneydance can do a QIF export.? GnuCash
> (GnC or GC) can import from QIF or QFX or CSV type files.
> > 4. Does it have some sort of budget?
> Yes.? But I don't use.
> >
> >
> > If I have to start over, it is no big deal but I do need to be able to
> import using a downloaded transaction file.
> >
> >
> > Thanks for any help,
> >
> > Kevin
> > ___
> > 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.
>
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
>
>
> --
>
> Message: 2
> Date: Thu, 17 Jan 2019 14:35:45 -0600
> From: Adrien Monteleone 
> To: "gnucash-user@gnucash.org" 
> Subject: Re: [GNC] Tax Issues
> Message-ID: 
> Content-Type: text/plain;   charset=utf-8
>
> Thanks David,
>
> That is helpful to know.
>
> I?ll check the list archives for discussion and then Bugzilla to see if
> this has been reported. That workflow is quite cumbersome.
>
> Regards,
> Adrien
>
> > On Jan 17, 2019, at 6:21 AM, David T.  wrote:
> >
> > Adrien,
> >
> > Your observations about the limiting aspects of the interface on this
> feature have been raised before; I will note that there is one exception to
> the single account tax option rule: you can designate an account and its
> children to the same tax option setting in one 

Re: [GNC] Treating tax authority as a vendor

[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, other than loosing the association with a vendor? Would it 
gum anything up (reports etc) to post directly to AP?

Ron

- Original Message -
From: "Adrien Monteleone" 
To: "Gnucash Users" 
Sent: Thursday, January 17, 2019 3:48:08 PM
Subject: Re: [GNC] Treating tax authority as a vendor

Ron,

I do this for property taxes with no issues that I can think of.

If you want to do this with pass through payments like sales taxes/VAT you 
might need to think carefully.

In such cases, you’d likely post via the invoice the tax charged/collected to a 
"Liability:Sales Tax Due" account or something similar.

Entering a bill for the amount would ‘pay’ this upon posting and transfer the 
amount to A/P. You may be fine with this, but if you’re expecting to use that 
special liability account as a reference to what is owing or helping you to 
track collections vs. remittances, you’ll run into some mental gymnastics on 
the dates.

If you wait to post the tax bill till its actual payment date, you’ll forgo the 
Bills Due Reminder feature for it.

Instead, you might want to just use a Scheduled Transaction for whatever day of 
the month/quarter and be sure to set it for manual review so you can tailor the 
amounts. With this, you might also be able to use a variable to assist with the 
manual entry. It will prompt you for the variable’s value when you agree to 
post the transaction. (such as the total sales you are reporting and then the 
SX will have formulas to calculate the tax owed based on those sales, if that 
is how you file, you’ll have to tailor that to your local laws/methods) I know 
my local jurisdictions will collect for several authorities with one payment, 
and then they let you deduct a “Vendor’s Compensation” from that. (usually 
something small like 1 or 2% of the tax owed) That could be broken out in two 
or more splits. That Vendor Compensation is technically a non-operations 
revenue stream, not just a reduction of liability. (depending on your 
jurisdiction) The SX could calculate all of this based on the Total Sales 
variable you are reporting.

There might be some other considerations. Perhaps someone else who does or has 
tried this can chime in.

Regards,
Adrien

> On Jan 17, 2019, at 6:24 AM, gnucash.dg...@ncf.ca wrote:
> 
> Hi all,
> 
> Is it recommended/not recommended to set up your local tax authority/ies as 
> vendors and pay taxes against bills? Are there advantages or disadvantages to 
> doing this from an accounting perspective? Similarly, are their design 
> assumptions in Gnucash that would make it a good/bad way to set up tax 
> payments?
> 
> Thanks in advance!
> 
> Ron
> ___
> 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.
___
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] Check for negative amount in scheduled transaction formula

[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 
___
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] Currency symbol (INR) not showing on Tax Invoice report

[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 belongs to.

Regards,
Adrien

> On Jan 18, 2019, at 6:06 AM, Deva -  wrote:
> 
> 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 a number of 
> variations of the rupee symbol available, but I can’t figure out which font 
> is used on each of those variations. So for the time being I have changed the 
> symbol to text (INR) in the currency editor.
> 
> Cheers.


___
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] Copying settings, layout, and colors to another computer

[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 (and this might be my background as a professional) I would find 
doing things like that SAFER not trying to combine operations.


In other words, I would NOT want to combine "get data over" and "clean 
up" << and during "clean up", if done in stages, I would be wanting to 
make a backup between each stage and test all apps where data had been 
cleaned before moving on.


It is experience having drilled home "mistakes will be made" and so I 
want it isolated, if mistake made must have been between two known 
"fixed points".


Michael D Novack

PS: Where user data is put (high level directory for each user) is not 
different between linux distros.

___
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] Currency symbol (INR) not showing on Tax Invoice report

[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 a number of 
variations of the rupee symbol available, but I can’t figure out which font is 
used on each of those variations. So for the time being I have changed the 
symbol to text (INR) in the currency editor.

Cheers.

> On 18-Jan-2019, at 4:21 PM, Geert Janssens  wrote:
> 
> 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 the font
>> and remedy the problem (provided the newly-selected font has a Rupee
>> symbol).
> The other possible issue is that the eguile  based reports (like the Tax 
> Invoice one) may not be handling non-ascii characters properly.
> 
> That would be a problem with the code and not something the end user could 
> remedy unfortunately.
> 
> Regards,
> 
> Geert
> 
> 

___
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] Currency symbol (INR) not showing on Tax Invoice report

[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 the font
> and remedy the problem (provided the newly-selected font has a Rupee
> symbol).
The other possible issue is that the eguile  based reports (like the Tax 
Invoice one) may not be handling non-ascii characters properly.

That would be a problem with the code and not something the end user could 
remedy unfortunately.

Regards,

Geert


___
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] Trouble entering Fund sale transaction

[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 amount of $19,471.00. I hit enter and it says "The values entered for 
this transaction are inconsistent. Which value would you like to have recalculated? 
Shares, Price, or Value." The $ amount is accurate as is the # of shares. I don't 
care if the price is off by a few decimals, so I opt for Price.

It then changes the price to 1.00, and the number of shares to -19,471! 
This is 1/10 the Price and 10x the number of shares!

I looked up the price in the database and it shows a price of $10.02 on the 
date of the transaction.

Why can't I represent the transaction correctly?

Thanks for any help you can give,
Steve Kelem

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