Re: [GNC] no printer to select in print dialog

[David Cousens]

Chris,

You possibly have installed the flatpak version of GnuCash in which case it
is possibly settings in the flathub support which restrict GnuCash from
accessing the printer. Flatpak is a sandbox which isolates the application
from the OS. One of the developers has been working on getting a flatpak
version downloadable from the GnuCash website but I don't know what the
status is.

This reference from an earlier thread
http://docs.flatpak.org/en/latest/sandbox-permissions-reference.html

may be of some assistance.

The original thread dealt with access to mysql
http://gnucash.1415818.n4.nabble.com/GNC-Gnucash-Flatpak-3-2-Mysql-issue-tt4703430.html.
There may be some info in some of the other posts in the thread.

I installed the flatpack GnuCash when I first moved to LM19, had problems
and quicklywent back to building my own from sources.  There is also a
repository which has a build of  the latest release of GnuCash (3.4) at 
https://launchpad.net/~sicklylife/+archive/ubuntu/gnucash. It is not
officially part of the GnuCash team but works. After installing the ppa with
the instructions shown there just use 
sudo apt install gnucash 
in a terminal.

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] Problem reconciling after canceling

[Colin Law]

Is the starting balance correct when you restart the reconciliation?

Colin

On Sun, 10 Mar 2019, 01:53 Keith N. McKenna, 
wrote:

> At the time gnucash was the only application open and no other window
> was there.
> Keith
>
> On 3/9/2019 7:28 PM, Adrien Monteleone wrote:
> > Double check you don’t have an open reconciliation window hiding in the
> background.
> >
> > Regards,
> > Adrien
> >
> >> On Mar 9, 2019, at 3:22 PM, Keith N. McKenna 
> wrote:
> >>
> >> After canceling the reconciliation of my checking account and restarting
> >> it the reconcile window showed that I had already reconciled more than
> >> the closing balance I entered from my statement. I then canceled the
> >> reconciliation again and went into the account register and and reset
> >> all entries that had a c in the reconcile field back to n and tried the
> >> reconciliation again. The reconciliation window still shows I have
> >> reconciled a dollar amount instead of 0.
> >>
> >> Is there a way I can convince gnucash that nothing for the month has
> >> been reconciled?
> >>
> >> Regards
> >> Keith N. McKenna
> >>
> > ___
> > 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] no printer to select in print dialog

[Chris Roy-Smith]

Hi

I was running ver 2.6, Printing offered a list of printers that the 
computer "knew about". This was updated to 3.2 (via Linux mint updates). 
Now the only printing options offered in the print dialogue is "file" 
and "lpr". Print to file works as expected, but printing to lpr does 
nothing. Printing to file generates a PDF file which I can print, but 
this is a bit clumsy, having to jump to a PDF capable program to print, 
and then switch back to GnuCash again. Is there some other way that the 
user is expected to use? Is this a bug? It occurs in both Linux Mint 19, 
and Ubuntu 18.04.


Any info as to how I'm supposed to print gratefully received.

Regards,

Chris Roy-Smith

___
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] Problem reconciling after canceling

[Keith N. McKenna]

At the time gnucash was the only application open and no other window
was there.
Keith

On 3/9/2019 7:28 PM, Adrien Monteleone wrote:
> Double check you don’t have an open reconciliation window hiding in the 
> background.
>
> Regards,
> Adrien
>
>> On Mar 9, 2019, at 3:22 PM, Keith N. McKenna  
>> wrote:
>>
>> After canceling the reconciliation of my checking account and restarting
>> it the reconcile window showed that I had already reconciled more than
>> the closing balance I entered from my statement. I then canceled the
>> reconciliation again and went into the account register and and reset
>> all entries that had a c in the reconcile field back to n and tried the
>> reconciliation again. The reconciliation window still shows I have
>> reconciled a dollar amount instead of 0.
>>
>> Is there a way I can convince gnucash that nothing for the month has
>> been reconciled?
>>
>> Regards
>> Keith N. McKenna
>>
> ___
> 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.




signature.asc
Description: OpenPGP digital signature
___
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] where did it go

[David Cousens]

Teresa,

When you created your new book and account heirarchy you have to save the
file to do that so it will be on your disk somewhere. You just need to find
where in your files it was saved. It will have the name .gnucash 
where  is the name you originally gave it. It will also have in
the same directory, backup and log files with the format:
.gnucash..gnucash
.gnucash..log 
where  is a string with format MMDDHHMMSS.

If you main data file truly has no data in it then the backups may be your
saviour as you can open a previous backup and then import the log files
created after that if necessary

There is in the Edit->Preferences General tab a preference for an autosave
time. Setting this means any work is automatically saved to your file.

I generally create a directory for each book  to contain the gnucash data
file and its backup and log files so they are all kept together and not
mixed up with other files. You can also set how many of the log and backup
files are retained in the preferences.


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] New user beginning balances receivables

[Adrien Monteleone]

> On Mar 9, 2019, at 3:45 AM, Teresa  wrote:
> 
> I didn't see a reply from David.. I'm not invoicing from here, the program 
> she was using up until now has so many issues, we don't have a good upload. 
> She has tracked everything in excel.I just need to plug in a number.

You can either plug in the same number used on the invoice sent to the client 
(my recommendation) or let GnuCash start counting from “1”. (or alternatively, 
make up a numbering scheme, but unless you really need it, that is not 
necessary)


> 
> My biggest problem, I closed the program and a ll data is lost. I've never 
> worked in  program where I had to save externally.. guess I'm starting over

In my 30+ years of using computers, I’ve never encountered software that kept 
the user data *in* the application, but always in a file I saved somewhere. 
(some apps like e-mail clients ‘appear’ that way, but the data is really in a 
file somewhere) Even the Excel spreadsheet your working from has to be saved 
each time you make a change...

I highly doubt the data is entirely lost, the problem is finding it if you 
didn’t intentionally save it somewhere you remember. GnuCash auto-saves a copy 
of the file as you work. (unless you’ve told it not to) Do a file search on all 
files ending in .gnucash.

Regards,
Adrien

___
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] Calculate medical expenses for 2019

[Adrien Monteleone]

If your medical expenses span more than one account, you can use either the 
Transaction Report, or alternatively, an Income Statement/P&L and only choose 
those medical expense accounts. (no Income or other accounts)

In both cases, set your period to Start of year/End of year (or specify exact 
dates) in the General Tab.

There is no need to keep separate accounts for each year. (and that will get 
quite cumbersome)

Regards,
Adrien

> On Mar 9, 2019, at 9:48 AM, Clair Garman  wrote:
> 
>   I desire to use gnucash to work on an account showing all my medical
>   expenses:
> 
>   1. extract the year 2019 into a new account
> 
>   2. set the Expense value on the first entry on the new account to 0
>   (zero).
> 
>   3. have gnucash recalculate the appropriate values for Expense and
>   Balance to all lines.
> 
>   Obviously I want gnucash to show the total of all my medical expenses
>   for 2019.


___
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] Problem reconciling after canceling

[Adrien Monteleone]

Double check you don’t have an open reconciliation window hiding in the 
background.

Regards,
Adrien

> On Mar 9, 2019, at 3:22 PM, Keith N. McKenna  
> wrote:
> 
> After canceling the reconciliation of my checking account and restarting
> it the reconcile window showed that I had already reconciled more than
> the closing balance I entered from my statement. I then canceled the
> reconciliation again and went into the account register and and reset
> all entries that had a c in the reconcile field back to n and tried the
> reconciliation again. The reconciliation window still shows I have
> reconciled a dollar amount instead of 0.
> 
> Is there a way I can convince gnucash that nothing for the month has
> been reconciled?
> 
> Regards
> Keith N. McKenna
> 

___
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] Default invoice/statement

[Adrien Monteleone]

Roger,

CSS is an acronym for Cascading Style Sheets. It is a web language used to 
describe presentation and appearance. Since reports are output in HTML (a web 
document language) CSS is used to ’style’ the reports. (fonts, colors, padding, 
lines, etc.)

Custom reports are saved in their own data location. See the Wiki about file 
locations for more info.(The wiki will also have some info on CSS for you)

If I’m not mistaken, the saved report directory was renamed between 2.6 and 
3.0, (as ‘2.4’ to ‘2.8’) so you may need to find the old versions and copy 
them. Be warned, you should open each report and make sure it works properly 
after doing so because the underlying code for some reports is different and 
you may need to adjust your preferences for them. If you have a particularly 
uncooperative report, you might just need to re-create it.

Regards,
Adrien

> On Mar 9, 2019, at 10:50 AM, Roger Oliver  wrote:
> 
> Very helpful, thanks. Pardon my ignorance, CSS?
> 
> Do I understand correctly that the customized reports are saved in the data
> file so should be there when you open the file in the update?
> 
> Roger
> 
> 
> On Sat, Mar 9, 2019, 9:25 AM Christopher Lam 
> 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] retained earnings in balance sheet: where does it come from?

[Adrien Monteleone]

Retained Earnings is posted when you perform a close book operation. (or 
manually zero your income/expense accounts to Equity)

If you didn’t do this for 2015, there would be no entry.

If you performed the 2016 close book operation in Jan 2017, you’ll have a 
retained earnings entry in that month for the net income-expenses for 2016. If 
you were a non-individual entity, that amount would be the entity’s taxable 
income for the year, hence the tax flag. You probably want to fix that date to 
12/31/16.

Regards,
Adrien

> On Mar 9, 2019, at 10:44 AM, Andrea Borgia  wrote:
> 
> Hi.
> 
> While splitting a multi-year book, I saw that the (end of) 2016 balance sheet 
> has an entry called "retained earnings" with a value of 54.10.
> 
> A find-by-value gives me an entry in jan.2017 from an account which has a 
> tax-related flag set (and can't be changed, too): am I correct in assuming 
> the report is referring to this one? Also, why don't I see a similar entry in 
> the 2015 balance sheet for the corresponding 53.80 entry involving the same 
> accounts?
> 
> More to the point: can I just safely ignore it?
> After all, the total assets and the total equity match.
> 
> Thanks,
> Andrea.


___
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] Calculate medical expenses for 2019

[John Ralls]

> On Mar 9, 2019, at 7:48 AM, Clair Garman  wrote:
> 
>   I desire to use gnucash to work on an account showing all my medical
>   expenses:
> 
>   1. extract the year 2019 into a new account
> 
>   2. set the Expense value on the first entry on the new account to 0
>   (zero).
> 
>   3. have gnucash recalculate the appropriate values for Expense and
>   Balance to all lines.
> 
>   Obviously I want gnucash to show the total of all my medical expenses
>   for 2019.

Ok. Do you have a question?

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] Calculate medical expenses for 2019

[Liz]

Clair Garman wrote:
>I desire to use gnucash to work on an account showing all my medical
>expenses:
>
>1. extract the year 2019 into a new account
>
>2. set the Expense value on the first entry on the new account to 0
>(zero).
>
>3. have gnucash recalculate the appropriate values for Expense and
>Balance to all lines.
>
>Obviously I want gnucash to show the total of all my medical expenses
>for 2019.
>
>--

I would do this by way of making a report.
[I do not have Gnucash on this computer, so you are now dependent on my
memory]
Open the Expenses:Medical account
Use the Filter option to show 1st Jan 2019 to today
Make an Account Report for the displayed account.
If this is exactly what I want, save the report, for which it needs its
own name.
When I need 2020, change the dates in the saved report and save with yet
another name.

Liz

___
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] Problem reconciling after canceling

[Keith N. McKenna]

After canceling the reconciliation of my checking account and restarting
it the reconcile window showed that I had already reconciled more than
the closing balance I entered from my statement. I then canceled the
reconciliation again and went into the account register and and reset
all entries that had a c in the reconcile field back to n and tried the
reconciliation again. The reconciliation window still shows I have
reconciled a dollar amount instead of 0.

Is there a way I can convince gnucash that nothing for the month has
been reconciled?

Regards
Keith N. McKenna




signature.asc
Description: OpenPGP digital signature
___
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] Fail to import .QIF file

[KenWA]

I created QIF files from Quicken and went through all the procedures down to
the final IMPORT.  After the third file (of 13) was completed it came up
with a message "Failed" but with no further information.
I reloaded the offending file and tried again but without success.
All this was done on the same desktop computer running Windows 7.
How do I proceed now.



--
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] Default invoice/statement

[Roger Oliver]

Very helpful, thanks. Pardon my ignorance, CSS?

Do I understand correctly that the customized reports are saved in the data
file so should be there when you open the file in the update?

Roger


On Sat, Mar 9, 2019, 9:25 AM Christopher Lam 
wrote:

> Like everything in Gnucash, backward compatibility is always the golden
> rule, but this is not always possible.
> Invoices have been merged i.e. easy/fancy/printable now share a common
> base and options. Styles can be customized via CSS and layout of header via
> other options.
> You shouldn't need to change your report options but you should definitely
> verify they produce satisfactory output.
>
>
> On Sat, 9 Mar 2019 at 14:56, Roger Oliver  wrote:
>
>> Thanks Christopher,
>>
>> By merged, do you mean the style sheets have been merged? Same options
>> for all of them or just one style sheet you can customize?
>>
>> When you upgrade, do you have to re-establish your saved report formats?
>>
>> Roger
>>
>>
>> On Fri, Mar 8, 2019, 10:39 PM Christopher Lam 
>> wrote:
>>
>>> On Fri, 8 Mar 2019 at 14:04,  wrote:
>>>
 Thanks Derek,

 Good to know the feature has been added to Version 3.x. I take it by
 current
 you mean stable? Still a little reluctant to upgrade as version 2.6.17
 is
 working for us. If it ain't broke...

>>>
>>> fwiw invoicing in 3.3 onwards has been merged; it is more flexible but
>>> awaiting bug reports...
>>>
>>
___
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] Test of new email group

[Michael via gnucash-user]

Welcome.  Your email seems to work.  Mike

On Sat, 9 Mar 2019 11:13:35
-0500 Clair Garman  wrote:

>--
>  __
> 
>Mr. Clair Garman 301-273-9380 Riderwood, WC-321, Silver Spring, MD
> 
>"He loves nature in spite of what it did to him."
>-- Forrest Tucker
> ___
> 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] retained earnings in balance sheet: where does it come from?

[Andrea Borgia]

Hi.

While splitting a multi-year book, I saw that the (end of) 2016 balance 
sheet has an entry called "retained earnings" with a value of 54.10.


A find-by-value gives me an entry in jan.2017 from an account which has 
a tax-related flag set (and can't be changed, too): am I correct in 
assuming the report is referring to this one? Also, why don't I see a 
similar entry in the 2015 balance sheet for the corresponding 53.80 
entry involving the same accounts?


More to the point: can I just safely ignore it?
After all, the total assets and the total equity match.

Thanks,
Andrea.
___
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] gnucash-user Digest, Vol 192, Issue 23

[Mike Commissaris]

Subject: Re: [GNC] Problems Accessing GnuCash Files on my D:\

Your symptoms sound different, but I fought a similar situation where I
share a NTFS data drive between windows and LinuxMint 18.3.
It seems that windows does not release any disk it uses because it helps
windows boot faster. I first proved this by holding the shift key while
shutting down windows. This supposedly causes windows to fully shut down
and release the disk. I was then able to access my data drive from Linux. I
am new to linux and struggle with the learning curve, but my ultimate cure
(so far) was to install an Linux NTFS driver via my grub boot file.

Dont know if this will help, but it is at least a redirection - sound like
you have tried most other options.


On Fri, Mar 8, 2019 at 3:36 PM  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:  Still can't update price quotes (D)
>2. Re:  Problems Accessing GnuCash Files on my D:\ (brob2684)
>3. Re:  gnucash 3.4 help needed (devlin)
>4. Re:  Uploading Invoices (Adrien Monteleone)
>5. Re:  Uploading Invoices (Adrien Monteleone)
>6. Re:  Default invoice/statement (Adrien Monteleone)
>7. Re:  Problems Accessing GnuCash Files on my D:\ (brob2684)
>8. Re:  Order of transactions (Adrien Monteleone)
>9. Re:  Order of transactions (Derek Atkins)
>   10.  New user beginning balances receivables (Teresa)
>   11. Re:  gnucash 3.4 help needed (David Cousens)
>   12. Re:  New user beginning balances receivables (David Cousens)
>   13.  can't print to paper since upgrade to version 3.2
>   (Chris Roy-Smith)
>   14. Re:  Monthly Income V Expense Report (Not Chart)
>   (Adrien Monteleone)
>
>
> --
>
> Message: 1
> Date: Fri, 08 Mar 2019 23:48:09 +0530
> From: D 
> To: "rmcas...@gmail.com" , John Ralls
> , Elias K Gardner <
> zork...@gmail.com>
> Cc: Gnucash Users 
> Subject: Re: [GNC] Still can't update price quotes
> Message-ID: 
> Content-Type: text/plain; charset=utf-8
>
> How many quotes are you attempting to retrieve? If it's more than five,
> you're likely to run into Alphavantage's throttling. That is a major reason
> why many users switched onward to Yahoo-json.
>
> David
>
> On March 8, 2019, at 11:25 PM, rmcas...@gmail.com wrote:
>
> Hi,
>
> I'm having the same problem. All source works with 'gnc-fq-dump', but
> gnucash still giving error message "Unable to retrieve quotes for these
> items:".
>
> The last time I update the price quotes was 01st March, after that my
> linux system update perl5 packages and I couldn't update any price
> quotes anymore. I don't know with have some relation, but it was only
> thing I saw different.
>
> I hope it's helps to find out the problem.
>
> Rafael Casali
>
>
> On Fri, 2019-03-08 at 07:57 -0800, John Ralls wrote:
> > Unfortunately there are no logs.
> >
> > Have you triple-checked that you have the Alphavantage API key set
> > correctly?
> >
> > To troubleshoot further first check that quote retrieval works at
> > all: Try
> >   gnc-fq-dump alphavantage AAPL
> > from the command line. You'll probably need to specify a full path to
> > gnc-fq-dump, and you'll need to set ALPHAVANTAGE_API_KEY in the
> > environment. If that works try one of your own stocks (unless you
> > hold Apple in which case you already have). If that works then
> > disable quote retrieval on all but that stock inside of GnuCash and
> > try to get prices. If that works then there's some security that's
> > causing F::Q to blow up and you need to figure out which one.
> >
> > The best way to do that is called "binary search": You disable half
> > of the active ones and try. If that fails, disable half of the rest
> > and try again. Keep doing that until it succeeds. At that
> > point  reenable the most recent set that you disabled and disable the
> > others. Keep doing that until you've found one security that fails.
> > Re-enable all of the rest and try. If it fails then you need to
> > repeat the process, perhaps several times, to find all of the
> > securities that fail.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 7, 2019, at 9:15 PM, Elias K Gardner 
> > > wrote:
> > >
> > > Thanks John I just double checked all of my securities. They all
> > > either have online quotes disabled or are set to alphavantage, no
> > > Yahoo left. Is there a log or something to get more details about
> > > the error?
> > >
> > > On Thu, Mar 7, 2019 at 10:59 AM John R

Re: [GNC] Getting security prices - Funnies

[Eric Coates]

John

Thank you for your patience, I've had a number of problems over the past 
few days and I've only Just been able to get to dealing with this problem.


Short report: I've now got F::Q to successfully update the prices all my 
securities.


Somewhat longer report in case it can help others:

Of the four directories you mentioned only one existed on my system and 
that one was empty! Working on a hunch prompted by your note I went 
*really* looking for copies of AlphaVantage.pm and found (amongst 
several others) a copy in the directory


/usr/local/share/perl/5.22.1/Finance/Quote

After (taking precautions that nothing I did was irreversible and) 
modding the AlphaVantage.pm file there, it all worked.


Thanks again

Best wishes

Eric

PS: That "*really* looking": Previously I was using the file search 
offered in the Ubuntu GUI to find instances. This time I used the locate 
command in the Terminal and that revealed (a lot) more instances. Trying 
to undersatnd that is a problem for another day. There are other 
"puzzles" as well but they are not GnuCash issues so I'll not mention 
them here.


=


On 06/03/2019 15:42, John Ralls wrote:

After installation all of the files are copied to one of the directories in perl's 
@INC include list. What those directories are depends on the way perl is configured, 
but if you ran cpan as root then I'd expect them to be in 
/usr/lib/perl/ or /usr/lib/per5. For non-root installations ~/perl5 or 
~/lib/perl5 are common.

Regards,
John Ralls



On Mar 6, 2019, at 2:23 AM, Eric Coates  wrote:


John
Thanks for the explanations - and the bonus of explaining what the padlock 
means, the directory belongs (in this case) to root.
But, in my ignorance, I don't follow your comment that none of the directories 
of the form
Finance-Quote-1.44-0
are needed after F::Q is installed.
Ameer Sengar and nvsoar have said that the file
AlphaVantage.pm
needs to be slightly modified to overcome the throttling. The only copies of 
that file I can find on my system reside in the Finance-Quote directories 
(albeit several subdirectories down). I would have thought that deleting the 
Finance-Quote directories would negate the effect of changing the 
AlphaVantage.pm file.
What am I missing?
On your comment about using yahoo-json instead of AlphaVantage it's worth 
noting that the London Stock Exchange (where many of my securities are listed) 
quotes prices in pennies but yahoo-json interprets the numbers as pounds. Using 
yahoo-json makes one (appear to be) very rich! (However, it does work correctly 
to get European stocks - at least on the Frankfurt and Paris bourses - and I 
use it for those securities.)
Best wishes
Eric
===

On 05/03/2019 19:54, John Ralls wrote:

On Mar 5, 2019, at 9:36 AM, Eric Coates 
  wrote:

I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04.

In the course of some fairly standard (for me) work I have come across a couple of 
"funnies" and I'm wondering whether they are deliberate, "features" (from 
Microsoft's vocabulary meaning a bug that won't be fixed), bugs or me doing something wrong.

On the last day of the month I need to revalue my share portfolio. Like others, 
I have been a victim of Alphvantage's throttling of their service but unlike 
others I have not (yet) screwed up my courage and updated the the related file 
to incorporate the delays suggested.

I open the Securities Editor, make sure that the Get Quote column is shown 
(and, for simplicity at this stage, I'll assume no securities are ticked) and 
then, by double clicking on a security I get to the Security Information window 
and select Get Online Quotes, click Unknown and select Alphavantage from the 
drop down. I do this for five securities (no point in doing it for more because 
of the Alphavantage limitation). In the Price Editor I click Get Quotes and, 
after a wait, I get the prices for the five securities I selected.

Having got those five prices I need to select a second batch of securities. But 
(*first funny*) I cannot deselect the previously selected securities by 
clicking on the tick - I have to go back to the Security Information to do 
that. Is that intended?

Having deselected the Get Quote for a security, I have noted that if, in the 
same session of working with GnuCash, I return to the same security the Get 
Online Quotes option is not selected but the associated options are still 
intact. However (*second funny*), if I exit GnuCash (after saving of course) 
and then restart it and re-enter the Security Editor only those securities that 
were left ticked as Get Quotes retain the option information, all others are 
reset to the defaults.

These two funnies make getting security prices (using this method) somewhat 
tedious and may mean that I have to really screw up my courage and make the 
changes to the file.

Anticipating that one day I will screw up enough courage I ha

[GNC] Test of new email group

[Clair Garman]

   --
 __

   Mr. Clair Garman 301-273-9380 Riderwood, WC-321, Silver Spring, MD

   "He loves nature in spite of what it did to him."
   -- Forrest Tucker
___
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] Calculate medical expenses for 2019

[Clair Garman]

   I desire to use gnucash to work on an account showing all my medical
   expenses:

   1. extract the year 2019 into a new account

   2. set the Expense value on the first entry on the new account to 0
   (zero).

   3. have gnucash recalculate the appropriate values for Expense and
   Balance to all lines.

   Obviously I want gnucash to show the total of all my medical expenses
   for 2019.

   --
 __

   Mr. Clair Garman 301-273-9380 Riderwood, WC-321, Silver Spring, MD

   Why is the letter W, in English, called double U?
   Shouldn't it be called double V?
___
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] Default invoice/statement

[Christopher Lam]

Like everything in Gnucash, backward compatibility is always the golden
rule, but this is not always possible.
Invoices have been merged i.e. easy/fancy/printable now share a common base
and options. Styles can be customized via CSS and layout of header via
other options.
You shouldn't need to change your report options but you should definitely
verify they produce satisfactory output.


On Sat, 9 Mar 2019 at 14:56, Roger Oliver  wrote:

> Thanks Christopher,
>
> By merged, do you mean the style sheets have been merged? Same options for
> all of them or just one style sheet you can customize?
>
> When you upgrade, do you have to re-establish your saved report formats?
>
> Roger
>
>
> On Fri, Mar 8, 2019, 10:39 PM Christopher Lam 
> wrote:
>
>> On Fri, 8 Mar 2019 at 14:04,  wrote:
>>
>>> Thanks Derek,
>>>
>>> Good to know the feature has been added to Version 3.x. I take it by
>>> current
>>> you mean stable? Still a little reluctant to upgrade as version 2.6.17 is
>>> working for us. If it ain't broke...
>>>
>>
>> fwiw invoicing in 3.3 onwards has been merged; it is more flexible but
>> awaiting bug reports...
>>
>
___
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] Splitting a multi-year file

[Andrea Borgia]

Hello, David.


Thanks for the explanation. Rest of the comments are inline.




To export the account tree use File->Export->Export Accounts to export the
account structure into a new book file directly. It works fine with GnuCash
V3.4. What version of GnuCash are you using and on what operating system?
Using the export of the account Tree to CSV will also work but the direct
export into a new file is simpler.


Yup, thanks for confirming. I'm using v3.4 on Debian, "testing" branch.



To import , open GnuCash in the new book file. File->Import->Import
Transactions from CSV. Select the file you have just exported. Select the
GnuCash Export Format. Make sure Multisplit is selected. If the data line
comes up as pink (or other colour) this is a warning that a format doesn't
match usually the data format. Set the date format to whatever is used in
your locale (or whatever format has been exported) and ensure that Skip 1
leading line is selected.  You will then see the data headings in the first
import record have a line through them and the pink or other color shading
in the data lines should clear. The column headers should correspnd with the
headers in the first skipped lines.


I used the "Gnucash Export format" in the "Load settings" and all lines 
are now white with no "stop" sign on the left side, after changing the 
date to match. Now I understand what was wrong in my earlier attempt.




In the next window you need to map the accounts specified in the file to be
imported onto the accounts in the account tree that you imported. As yet
there is no matching procedure so it is laborious but only has to be done
for those accounts that transactions being imported will have splits to.  In
your case the mapped accounts should be the same as the imported account
names when you have finished.


Automatching would be a great addition, surely, but at least I got 
through to saving the imported entries.




At present the import is not working correctly when the transactions involve
accounts with multiple currencies and I suspect trading accounts although I
have not checked these yet. You will have to edit any transactions between
accounts in different currencies. At present the import appears to create a
spurious split ot splits for an unrlated amount and appears to create an
additional transaction in each non-book currency. Hopefully you don't have
multicurrency transactions.


Hmm, I do have some old shares in investment funds and also have used 
multiple currencies over the years (EUR, ITL, GBP, FIM, EEK, NOK and I'm 
probably forgetting a couple). I used intermediate accounts to handle 
the money exchange then created separate income & expenses accounts for 
each currency as appropriate. Should I keep an eye on those? Or perhaps 
you are talking about something even fancier than I have in my books.




As Christian recommended it is probably a good idea to create balance sheet
reports however that may be of limited usefulness as the Balance sheet at a
given date will not be the same in the new file unless you have copied all
records up to that date and as you are splitting up into annual books that
will not be the case. More useful may be Income Statements (also contains
expenses)for each period from the original book. that should then agree with
an Income Statement created for the same period from the new book


I think I'm going to stick with the balance sheet, since I already have 
the closing balances even if I did not create a new file each year. The 
income statement for 2015, for example, is mostly zeros except for a 
single mistake which I just discovered (bank interests for 2015 were 
lumped together with 2016, oh well...)




Thanks again,
Andrea.


___
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] Default invoice/statement

[Roger Oliver]

Thanks Christopher,

By merged, do you mean the style sheets have been merged? Same options for
all of them or just one style sheet you can customize?

When you upgrade, do you have to re-establish your saved report formats?

Roger


On Fri, Mar 8, 2019, 10:39 PM Christopher Lam 
wrote:

> On Fri, 8 Mar 2019 at 14:04,  wrote:
>
>> Thanks Derek,
>>
>> Good to know the feature has been added to Version 3.x. I take it by
>> current
>> you mean stable? Still a little reluctant to upgrade as version 2.6.17 is
>> working for us. If it ain't broke...
>>
>
> fwiw invoicing in 3.3 onwards has been merged; it is more flexible but
> awaiting bug reports...
>
___
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] Default invoice/statement

[Roger Oliver]

Adrian,

Good to know. May try the intermediate step of upgrading to 2.6.21 first. I
understand 3.5 should be out by the end of this month. I have a separate
computer I can experiment with first.

Thanks,
Roger

Message: 6
Date: Fri, 8 Mar 2019 13:30:46 -0600
From: Adrien Monteleone 
To: GnuCash 
Subject: Re: [GNC] Default invoice/statement
Message-ID: 
Content-Type: text/plain;   charset=utf-8

Roger,

If for some reason you just had to stick with the 2.6.x series for a while
longer, I?d recommend 2.6.21 as many bugs were fixed between it and 2.6.17.
It is the last stable release of the 2.6 series. But 3.4 is the current
release. (3.5 is due out at the end of the month I believe)

Regards,
Adrien

> On Mar 8, 2019, at 8:33 AM, Derek Atkins  wrote:
>
> Hi,
>
>  writes:
>
>> Thanks Derek,
>>
>> Good to know the feature has been added to Version 3.x. I take it by
current
>> you mean stable? Still a little reluctant to upgrade as version 2.6.17 is
>> working for us. If it ain't broke...
>
> Version 2.6.17 was released Q3 2017.  It is now Q1 (almost Q2) 2019, so
> it's almost two years old.  And yes, 3.4 is the current stable release.
>
>> Roger
>
> -derek
___
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] where did it go

[Michael or Penny Novack]

On 3/9/2019 7:52 AM, David Carlson wrote:

GnuCash is like your document editor or spreadsheet program.  When you
close it the first time, it asks you where to save it and what to call it.
Then, when you re-start it, it opens the same file automatically.  If you
skip that step, you have a problem.  I am not sure what happens if you
never named and saved your file.

David Carlson

 That's the problem. Assuming that the file was saved (you did some 
sort of save before closing the program) the problem is that you don't 
know the name of the file or where (what directory -- aka "file folder")


But PROBABLY your operating system includes a "find" tool, and probably 
that has options not just to search for by partial name (for example, 
ending with the extension .gnucash) but things like "changed yesterday".


If you didn't do ANY save . (But please note that this would not 
be a gnucash specific problem. For example, if you created a document 
with your word processor but NEVER saved it, would you expect it to be 
there?)


Michael D Novack
___
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] where did it go

[David Carlson]

GnuCash is like your document editor or spreadsheet program.  When you
close it the first time, it asks you where to save it and what to call it.
Then, when you re-start it, it opens the same file automatically.  If you
skip that step, you have a problem.  I am not sure what happens if you
never named and saved your file.

David Carlson

On Sat, Mar 9, 2019 at 2:51 AM Teresa  wrote:

> I just want to make sure, I had to run out of a meeting, closed
> everything after working for days to get 3 plus years of data in and
> balancing. It's gone!!
>
> I need to save the data outside GnuCash??
>
> --
>
> Teresa Slack
>
> Senior Client Manager
>
> *_Coba Enterprise Management, LLC_*
>
> 3620 Pelham Road, PMB 107
>
> Greenville, SC 29615
>
> Office: 864.343.8017 x 5
>
> Cell:864.525.3633
>
> ter...@coba-em.com 
> Coba-EM.com 
>
> /NOTICE TO RECIPIENTS: The information contained in and accompanying
> this communication may be confidential, subject to legal privilege, or
> otherwise protected from disclosure, and is intended solely for the use
> of the intended recipient(s). If you are not the intended recipient of
> this communication, please delete and destroy all copies in your
> possession, notify sender that you have received this communication in
> error, and note that any review or dissemination of, or the taking of
> any action in reliance on, this communication is expressly prohibited.
> Email messages may contain computer viruses or other defects, may not be
> accurately replicated on other systems, or may be intercepted, deleted
> or interfered with without the knowledge of the sender or the intended
> recipient. Coba Enterprise Management, LLC makes no warranties in
> relation to these matters. Please note that Coba Enterprise Management,
> LLC reserves the right to intercept, monitor, and retain email messages
> to and from its systems as permitted by applicable law. If you are not
> comfortable with the risks associated with e-mail messages, you may
> decide not to use email to communicate with Coba Enterprise Management,
> LLC. /
>
> ___
> 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.
>


-- 
David Carlson
___
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] where did it go

[Teresa]

I just want to make sure, I had to run out of a meeting, closed 
everything after working for days to get 3 plus years of data in and 
balancing. It's gone!!


I need to save the data outside GnuCash??

--

Teresa Slack

Senior Client Manager

*_Coba Enterprise Management, LLC_*

3620 Pelham Road, PMB 107

Greenville, SC 29615

Office: 864.343.8017 x 5

Cell:    864.525.3633

ter...@coba-em.com 
Coba-EM.com 

/NOTICE TO RECIPIENTS: The information contained in and accompanying 
this communication may be confidential, subject to legal privilege, or 
otherwise protected from disclosure, and is intended solely for the use 
of the intended recipient(s). If you are not the intended recipient of 
this communication, please delete and destroy all copies in your 
possession, notify sender that you have received this communication in 
error, and note that any review or dissemination of, or the taking of 
any action in reliance on, this communication is expressly prohibited. 
Email messages may contain computer viruses or other defects, may not be 
accurately replicated on other systems, or may be intercepted, deleted 
or interfered with without the knowledge of the sender or the intended 
recipient. Coba Enterprise Management, LLC makes no warranties in 
relation to these matters. Please note that Coba Enterprise Management, 
LLC reserves the right to intercept, monitor, and retain email messages 
to and from its systems as permitted by applicable law. If you are not 
comfortable with the risks associated with e-mail messages, you may 
decide not to use email to communicate with Coba Enterprise Management, 
LLC. /


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