Re: [GNC] Fwd: Bonus share entry

[Chris Good]

-Original Message-
From: D  
Sent: Thursday, 7 March 2019 12:26 PM
To: Chris Good ; Gnucash Users 
Subject: Re: [GNC] Fwd: Bonus share entry

Chris,

That's a bad idea. It messes up the lots as you note, it screws up the 
acquisition dates (important for tax purposes in the US), and ultimately it's 
not what happened. Since it is possible to add zero cost shares using tab 
(instead of enter), there is no reason to use this approach. You certainly 
don't *have* to use it.

David

On March 7, 2019, at 2:29 AM, Chris Good  wrote:

Message: 6
> Date: Wed, 6 Mar 2019 22:00:16 +1030
> From: Gnucash Xboxboy Mageia 
> To: Derek Atkins 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Fwd: Bonus share entry
> Message-ID:
>
> 
> Content-Type: text/plain; charset="utf-8"
> 
>> On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins  wrote:
>> 
>> The cost may be zero, but the value is not.
>> Maybe just enter them as 0.01?
>> 
>> -derek
>> Sent using my mobile device. Please excuse any typos.
>> On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia 
>>  wrote:
>> 
>>> Hi all,
>>> I have some bonus shares that were issued with no cost to me:
>>> 
>>> I am having trouble entering them without a cost. When I put 0 as 
>>> the
>> cost,
>>> on the next line 1 appears, and I am unable to get rid of it.
>>> 
>>> Perhaps I'm doing this the wrong way, and need to be entering them 
>>> as a share split?
>>> 
>>> In this case, I had 100 shares, and got issued 16 for no cost: so I 
>>> have
>>> 116 in total.
>>> 
>>> Any ideas?
>>> 
>>> Thanks,
>>> Xboxboy
>>> ___
>>> 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.
> Hi Derek,
> 
> I've attached a picture, I don't think I'm explaining very well.
> 
> Please see attached.
> 
> What can I do about that imbalance line?
> Many thanks,
> Xboxboy
> -- next part -- A non-text attachment was 
> scrubbed...
> Name: Screenshot_20190306_215426.png
> Type: image/png
> Size: 34424 bytes
> Desc: not available
> URL: 
>  8a2c7c73/attachment.png>
> 

Hi XBoxBoy,

If the tax authorities have agreed that you are getting these bonus shares for 
zero cost, then to keep the cost correct in GnuCash you will have to do a dummy 
sell of all your existing shares at cost, and then in another transaction, buy 
them, including the bonus qty, at the same cost. Assuming this is for your 
personal accounting, it probably doesn't matter which account you use for the 
other side in each transaction - you could probably use either a bank account 
(and if you reconcile that bank account, flag the transactions as reconciled 
even though they never appear on a bank statement) or an Equity:Opening 
Balances account - you should check with your accountant.

Doing this will mean manually keeping track of lots bought and sold when 
determining costs of future sales.

Regards, Chris Good

Hi David,

You're right, I was confusing this with the problem where the Advanced 
Portfolio Report doesn't handle Return Of Capital transactions, but it seems to 
handle zero cost and price transactions OK. Sorry for the bad advice XBoxBoy.

Regards,
Chris Good

___
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] Problems Accessing GnuCash Files on my D:\

[brob2684]

Ronal B Morse-2 wrote
> Could this be an ACL (access control list) related? 

Thanks for the thoughts, but it turns out it the problem was "controlled
folder access".

If it turns out you can't save to a whole bunch of Windows special folders
(or subfolders therein), but you can to all other directories, you might
have this feature switched on. 

This was the link that saved me:
https://superuser.com/questions/1293897/cannot-save-files-to-desktop-in-windows-10

Everything is working normally again now.

Thanks everyone for their assistance and ideas.

Regards,
brob2684



--
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] Monthly Income V Expense Report (Not Chart)

[Adrien Monteleone]

Good news indeed!

Regards,
Adrien

> On Mar 8, 2019, at 10:27 PM, Christopher Lam  
> wrote:
> 
> 
> 
> On Fri, 8 Mar 2019 at 23:34, Adrien Monteleone 
>  wrote:
> (snip)
> This option will get you the monthly figures all in neat columns along with a 
> total and average column as well as account names for each row. You’ll just 
> need to add total lines for Expenses and Income, but it also provides a ’net 
> income/loss’ labeled as “Grand Total” - adjust as desired. You’ll also need 
> to delete all of those boldface ’total for’ lines as I can’t seem to get rid 
> of them and only get the account summary portion.
> 
> 
> The good news is 3.5 will omit these redundant total lines, only when 
> display/subtotal-table=true and sorting/hide-transactions=true
> https://github.com/Gnucash/gnucash/commit/8f2776dabda54e82f9ff592d78ffa9380a14b757


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

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] Monthly Income V Expense Report (Not Chart)

[Christopher Lam]

On Fri, 8 Mar 2019 at 23:34, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> (snip)
> This option will get you the monthly figures all in neat columns along
> with a total and average column as well as account names for each row.
> You’ll just need to add total lines for Expenses and Income, but it also
> provides a ’net income/loss’ labeled as “Grand Total” - adjust as desired. 
> *You’ll
> also need to delete all of those boldface ’total for’ lines as I can’t seem
> to get rid of them and only get the account summary portion.*
>
>
The good news is 3.5 will omit these redundant total lines, only when
display/subtotal-table=true and sorting/hide-transactions=true
https://github.com/Gnucash/gnucash/commit/8f2776dabda54e82f9ff592d78ffa9380a14b757
___
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] Problems Accessing GnuCash Files on my D:\

[Ronal B Morse]

Thanks for the correction. I (obviously) didn't know that. 

RBM


On Fri, 2019-03-08 at 20:24 -0500, Kenneth Schneider wrote:
> Most filesystems in Linux support ACL’s.
> 
> Ken Schneider 
> 
> > On Mar 8, 2019, at 7:09 PM, Ronal B Morse <
> > r...@morsehouse.com> wrote:
> > 
> > Could this be an ACL (access control list) related? 
> > 
> > Linux doesn't use them (nor does the Mac, as far as I
> > know)
> > but Windows does and from what I understand a broken or
> > incorrect ACL config could cause this kind of behavior. 
> > 
> > Totally clueless about how to check or what to do, but
> > since
> > no one mentioned the possibility...
> > 
> > RBM 
> > 
> > 
> > > On Fri, 2019-03-08 at 13:41 -0600, brob2684 wrote:
> > > Hi Colin and David,
> > > 
> > > I've done a bit more digging and it began to looks like
> > > there was a small
> > > chance the issue is linked to the special Windows
> > > folders.
> > > 
> > > If I move a copy of my gnucash file to an existing
> > > directory on D:\ that is
> > > not a special Windows folder (e.g. D:\Filing or D:\Tmp)
> > > then gnucash opens
> > > the file without issue.
> > > 
> > > On the other hand, if I move the file to a special
> > > Windows
> > > folder (e.g.
> > > D:\Documents or D:\Favorites or D:\Desktop or
> > > D:\Pictures).
> > > Surprisingly,
> > > D:\Downloads works without issue.
> > > 
> > > I haven't made any changes to this setup in the past
> > > fortnight.
> > > 
> > > A fair bit of further random, seemingly aimless
> > > Googling
> > > along the above
> > > lines kept turning up recommendations about
> > > permissions,
> > > none of which
> > > worked.
> > > 
> > > 
> > > 
> > > However, I eventually turned up this little chestnut:
> > > 
> > > https://superuser.com/questions/1293897/cannot-save-files-to-desktop-in-windows-10
> > > 
> > > It seems "Controlled folder access" was switched on.
> > > From
> > > what I've read,
> > > it's supposed to be an opt-in feature, and when
> > > enabled, it
> > > uses a mechanism
> > > to track apps trying to make changes to files in the
> > > protected folders. If
> > > the app is malicious, or it's not recognized, the
> > > feature
> > > will in real-time
> > > block the attempt, and you'll get a notification of the
> > > suspicious activity.
> > > 
> > > So it looks like my problem stems from opting in
> > > (sorry, I
> > > have no
> > > recollection of doing so) but I've also received no
> > > notifications of
> > > suspicious activity either.
> > > 
> > > Disabling this means I can open/save/edit files in
> > > GnuCash
> > > that are written
> > > to my D:\Documents folder again.
> > > 
> > > Thanks both for your help,
> > > brob2684
> > > 
> > > 
> > > 
> > > --
> > > 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.
> > 
> > ___
> > 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] Problems Accessing GnuCash Files on my D:\

[Kenneth Schneider]

Most filesystems in Linux support ACL’s.

Ken Schneider 

> On Mar 8, 2019, at 7:09 PM, Ronal B Morse  wrote:
> 
> Could this be an ACL (access control list) related? 
> 
> Linux doesn't use them (nor does the Mac, as far as I know)
> but Windows does and from what I understand a broken or
> incorrect ACL config could cause this kind of behavior. 
> 
> Totally clueless about how to check or what to do, but since
> no one mentioned the possibility...
> 
> RBM 
> 
> 
>> On Fri, 2019-03-08 at 13:41 -0600, brob2684 wrote:
>> Hi Colin and David,
>> 
>> I've done a bit more digging and it began to looks like
>> there was a small
>> chance the issue is linked to the special Windows folders.
>> 
>> If I move a copy of my gnucash file to an existing
>> directory on D:\ that is
>> not a special Windows folder (e.g. D:\Filing or D:\Tmp)
>> then gnucash opens
>> the file without issue.
>> 
>> On the other hand, if I move the file to a special Windows
>> folder (e.g.
>> D:\Documents or D:\Favorites or D:\Desktop or D:\Pictures).
>> Surprisingly,
>> D:\Downloads works without issue.
>> 
>> I haven't made any changes to this setup in the past
>> fortnight.
>> 
>> A fair bit of further random, seemingly aimless Googling
>> along the above
>> lines kept turning up recommendations about permissions,
>> none of which
>> worked.
>> 
>> 
>> 
>> However, I eventually turned up this little chestnut:
>> 
>> https://superuser.com/questions/1293897/cannot-save-files-to-desktop-in-windows-10
>> 
>> It seems "Controlled folder access" was switched on. From
>> what I've read,
>> it's supposed to be an opt-in feature, and when enabled, it
>> uses a mechanism
>> to track apps trying to make changes to files in the
>> protected folders. If
>> the app is malicious, or it's not recognized, the feature
>> will in real-time
>> block the attempt, and you'll get a notification of the
>> suspicious activity.
>> 
>> So it looks like my problem stems from opting in (sorry, I
>> have no
>> recollection of doing so) but I've also received no
>> notifications of
>> suspicious activity either.
>> 
>> Disabling this means I can open/save/edit files in GnuCash
>> that are written
>> to my D:\Documents folder again.
>> 
>> Thanks both for your help,
>> brob2684
>> 
>> 
>> 
>> --
>> 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.
> 
> ___
> 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] Problems Accessing GnuCash Files on my D:\

[Ronal B Morse]

Could this be an ACL (access control list) related? 

Linux doesn't use them (nor does the Mac, as far as I know)
but Windows does and from what I understand a broken or
incorrect ACL config could cause this kind of behavior. 

Totally clueless about how to check or what to do, but since
no one mentioned the possibility...

RBM 


On Fri, 2019-03-08 at 13:41 -0600, brob2684 wrote:
> Hi Colin and David,
> 
> I've done a bit more digging and it began to looks like
> there was a small
> chance the issue is linked to the special Windows folders.
> 
> If I move a copy of my gnucash file to an existing
> directory on D:\ that is
> not a special Windows folder (e.g. D:\Filing or D:\Tmp)
> then gnucash opens
> the file without issue.
> 
> On the other hand, if I move the file to a special Windows
> folder (e.g.
> D:\Documents or D:\Favorites or D:\Desktop or D:\Pictures).
> Surprisingly,
> D:\Downloads works without issue.
> 
> I haven't made any changes to this setup in the past
> fortnight.
> 
> A fair bit of further random, seemingly aimless Googling
> along the above
> lines kept turning up recommendations about permissions,
> none of which
> worked.
> 
> 
> 
> However, I eventually turned up this little chestnut:
> 
> https://superuser.com/questions/1293897/cannot-save-files-to-desktop-in-windows-10
> 
> It seems "Controlled folder access" was switched on. From
> what I've read,
> it's supposed to be an opt-in feature, and when enabled, it
> uses a mechanism
> to track apps trying to make changes to files in the
> protected folders. If
> the app is malicious, or it's not recognized, the feature
> will in real-time
> block the attempt, and you'll get a notification of the
> suspicious activity.
> 
> So it looks like my problem stems from opting in (sorry, I
> have no
> recollection of doing so) but I've also received no
> notifications of
> suspicious activity either.
> 
> Disabling this means I can open/save/edit files in GnuCash
> that are written
> to my D:\Documents folder again.
> 
> Thanks both for your help,
> brob2684
> 
> 
> 
> --
> 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.

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

Teresa,

If you don’t need the exact aging info and just want to start from ’today’ you 
can create ‘invoices’ for each customer with their aged balance, with today’s 
due date.

If this is more like a ‘uncollectable’ or ‘allowance for doubtful accounts’ 
tracking you can simply make this a child account of A/R.

But the more complete option would be as David suggested and import the actual 
aged invoices with actual due dates and let GnuCash do the lifting. You may not 
need line-item detail unless you are transitioning away from the current 
invoicing process. You could just post a single line item to an income account. 
I’d go with whatever was easier to export from the current invoice system 
keeping in mind what level of detail you need to retain.

Regards,
Adrien

> On Mar 8, 2019, at 3:00 PM, Teresa  wrote:
> 
> I have loaded all balances for a business that was doing their accounting on 
> excel
> 
> The balances go through Dec 2018
> 
> The issue I have is they had 3 receivable accounts
> 
> Receivable = Asset
> 
> Paid = Income
> 
> Aged = ??
> 
> I'm not sure where to put the aged amount, retained earnings?
> 
> Thank you
> 
> -- 
> 
> Teresa Slack


___
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] Order of transactions

[Adrien Monteleone]

I understood that already, but thanks for the detail.

What doesn’t work is sorting off the  part, because the sorting stops at 
“.”, correct?

That’s why you can’t use “:” in the faux timestamp as the sorting will stop 
before it gets to the minutes portion, and why you have to use a 24 hour 
notation because “a/am” or “p/pm” will be ignored.

Regards,
Adrien

> On Mar 8, 2019, at 1:55 PM, Derek Atkins  wrote:
> 
> Adrien,
> 
> On Fri, March 8, 2019 2:41 pm, Adrien Monteleone wrote:
>> I didn’t mean to still be able to sort by the real transaction number, but
>> if you have one, and you’ve repurposed the NUM field, you’ll likely want a
>> place to put it just for reference. I simply offered an overview of the
>> remaining options. Overloading NUM as a time field is pretty much giving
>> up on using it to hold a real transaction number. (though one user piped
>> in they used a . format that seems to work, though I don’t see how
>> with the intervening “.”)
> 
> As I said, the string field is converted to an integer using the
> C-language atoi() function and then the sort happens using the numerical
> value.  So the string . with be converted into the number  and
> that will be used to sort.  If  is 0001, this would be sorted before a
>  of 2.  Basically, the conversion for sorting will stop at the first
> non-numeral character.  That's why using . works.  Or -. 
> Even A will work (this is all assuming the  and  are all
> numerals).
> 
> So 00011.16298462 will come before 2.294362.   If it were a pure string
> compare, then this would not be the case.
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 
> 


___
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] Monthly Income V Expense Report (Not Chart)

[Adrien Monteleone]

Dan,

What you are looking for (per your screenshot) is a multi-period Income 
Statement.(P)

GnuCash doesn’t have this yet. (it is under development, but work has hit a 
roadblock, so don’t expect it soon)

For now, you have three options:

1. Run the Transaction Report that Chris offered, export or copy/paste to a 
spreadsheet and massage from there. 

This option will get you the monthly figures all in neat columns along with a 
total and average column as well as account names for each row. You’ll just 
need to add total lines for Expenses and Income, but it also provides a ’net 
income/loss’ labeled as “Grand Total” - adjust as desired. You’ll also need to 
delete all of those boldface ’total for’ lines as I can’t seem to get rid of 
them and only get the account summary portion.

2. Run an Income Statement/P for each desired period, export or copy/paste to 
a spreadsheet and massage from there.

I’ve been using this option. I save the report, open it in LibreOffice calc via 
the “Insert Sheet from File” function in the Insert menu, and then copy only 
the data column over. You’ll have to always 'include zero balance accounts' so 
everything lines up as some periods may not have transactions in all accounts. 
I then copy over columns which calculate percentages and a variance for each 
period for further analysis. I also have a YTD column. (I think I’ll add an 
‘average’ column now as that would be useful for budgeting)

3. Run a Multi-Column report and make each desired column an Income/P report, 
each configured to a different period.

The downside here is each column will repeat the account labels which takes up 
unnecessary space and clutters the report. (which is why a proper version is in 
development) You can use this as-is, or export or copy/paste to a spreadsheet 
to remove the extraneous labels and add a ’YTD’ or other columns as needed.

I would say Chris’s options on the Transaction Report seem to be the least 
amount of work and that is probably the better option if you ever edit 
transactions in a prior period as that will get you the most up-to-date data 
where my method-2 would require re-exporting the prior periods each time. (I 
think I’ll switch, using this as a source to pull data into my custom sheet 
that has percentages and variances)

Regards,
Adrien

> On Mar 8, 2019, at 9:28 AM, Dan Carmona via gnucash-user 
>  wrote:
> 
> Hi,
> 
> 
> 
> Tried this but this is not Income V Expenses.  It is more account/category 
> transaction summary by month.
> 
> 
> 
> 
> 
> From: Christopher Lam  
> Sent: Friday, March 8, 2019 9:11 AM
> Cc: Dan Carmona ; Gnucash Users 
> 
> Subject: Re: [GNC] Monthly Income V Expense Report (Not Chart)
> 
> 
> 
> Run the Transaction Report
> 
> 
> 
> Accounts/Accounts select Income and Expense accounts
> 
> Display/Subtotal table: enabled
> 
> Sorting/Primary Sortkey: account-name
> 
> Sorting/Primary Subtotal: true
> 
> Sorting/Secondary Sortkey: date
> 
> Sorting/Secondary Subtotal: monthly
> 
> Sorting/Hide transactions: enabled
> 
> 
> 
> 
> 
> On Fri, 8 Mar 2019 at 13:49, David Carlson 
> mailto:david.carlson@gmail.com> > wrote:
> 
> Dan,
> 
> The image you included appears to be from a different program, not from
> GnuCash.  GnuCash, to my knowledge, does not have a similar report at this
> time.
> 
> On Fri, Mar 8, 2019 at 6:34 AM Dan Carmona via gnucash-user <
> gnucash-user@gnucash.org  > wrote:
> 
>> I can't seem to find how to perform a monthly Income/Expense Report (not
>> chart).
>> 
>> For example:
>> 
>> 
>> 
>> ___
>> 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.
> 
> ___
> 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 

[GNC] can't print to paper since upgrade to version 3.2

[Chris Roy-Smith]

Hi All.

I was running version 2.6. Printing offered a choice of printers. Linux 
Mint updated GnuCash to version 3.2. Now I don't get a list of printers. 
Only "lpr"and "file" is offered. Other programs still offer the normal 
list of printers. I can still print to file, but that is awkward. How do 
I print to paper now?


Thanks

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

[David Cousens]

Teresa

The best option is to use the business features and create dummy invoices to
match the original invoices. This should create the aging  entries.

You will need to add the business accounts Accounts receivable and Accounts
Payable using the Action->New Account Heirarchy and select Business
Accounts.

Then Use Business->Customers->New Invoice to create invoices and predate
them to the dates of the original invoices. You can add customers from the
new invoice dialog after hitting the Select button for the customer.

See
https://wiki.gnucash.org/wiki/GnuCash_Quick_Start_Guide_For_Business_Users
https://wiki.gnucash.org/wiki/Business_Features_Issues
https://www.gnucash.org/docs/v3/C/gnucash-guide/pt03.html

for more detail.

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] gnucash 3.4 help needed

[David Cousens]

Devlin

OK that error means that cmake is unable to locate the source directory from
the build directory. You would use it in this form if the directory
structure is
   
Applications
   |
   
--
  | 
   
|
gnucash-3.4  
gnucash-3.4-build
 |
 source code

however your directory structure appears to be:
   Applications
   |
gnucash-3.4
   |
   
--
|   

| 
   sources 
gnucash-3.4-build

the relative path from gnucash-3.4-build to gnucash-3.4 in this case is 
".." not  "../gnucash-3.4".
try
$cmake  -DCMAKE_INSTALL_PREFIX=$HOME/.local  ..

Apologies I should have picked that up earlier but I wasn't looking past the
unneeded directive for the libraries.

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.

[GNC] New user beginning balances receivables

[Teresa]

I have loaded all balances for a business that was doing their 
accounting on excel


The balances go through Dec 2018

The issue I have is they had 3 receivable accounts

Receivable = Asset

Paid = Income

Aged = ??

I'm not sure where to put the aged amount, retained earnings?

Thank you

--

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.

Re: [GNC] Order of transactions

[Derek Atkins]

Adrien,

On Fri, March 8, 2019 2:41 pm, Adrien Monteleone wrote:
> I didn’t mean to still be able to sort by the real transaction number, but
> if you have one, and you’ve repurposed the NUM field, you’ll likely want a
> place to put it just for reference. I simply offered an overview of the
> remaining options. Overloading NUM as a time field is pretty much giving
> up on using it to hold a real transaction number. (though one user piped
> in they used a . format that seems to work, though I don’t see how
> with the intervening “.”)

As I said, the string field is converted to an integer using the
C-language atoi() function and then the sort happens using the numerical
value.  So the string . with be converted into the number  and
that will be used to sort.  If  is 0001, this would be sorted before a
 of 2.  Basically, the conversion for sorting will stop at the first
non-numeral character.  That's why using . works.  Or -. 
Even A will work (this is all assuming the  and  are all
numerals).

So 00011.16298462 will come before 2.294362.   If it were a pure string
compare, then this would not be the case.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Order of transactions

[Adrien Monteleone]

I didn’t mean to still be able to sort by the real transaction number, but if 
you have one, and you’ve repurposed the NUM field, you’ll likely want a place 
to put it just for reference. I simply offered an overview of the remaining 
options. Overloading NUM as a time field is pretty much giving up on using it 
to hold a real transaction number. (though one user piped in they used a 
. format that seems to work, though I don’t see how with the 
intervening “.”)

The ideal would be to edit the time portion of the transaction's entry but of 
course, that means more code and maintenance for a non-widespread use case. The 
occurrence of negative balances is rare unless you extensively use a cash 
account (where it is impossible in the real world) or you frequently have just 
the right types of transactions in some other asset so that the GnuCash 
ordering produces this condition.

Regards,
Adrien


> On Mar 8, 2019, at 8:54 AM, Derek Atkins  wrote:
> 
> Adrien Monteleone  writes:
> 
>> Yes, that is why I was explaining the abuse of the NUM field as a time
>> field for sorting and how to do it in a way that works. If you are
>> doing this, (or instead using 1,2,3,4 ) *and* you want to keep track
>> of a transaction number, then you’ll have to put it somewhere else so
>> you can still sort that transaction in the order you want. One obvious
>> choice for an alternative would be the Action field for that
>> particular split line. Another would be the Note field. (especially if
>> the Action field is also otherwise utilized) Another option would be
>> the Memo field for the split.
> 
> Yes, if you want to order your transactions in a specific order but then
> also be able to sort by a transaction number then yes, you would need to
> do what you suggest and put the default-sort-order into Num, and the
> transaction number into another field.
> 
> But why would you want to do that?
> 
> You could still SEARCH for transaction number even if you overload num
> with ..  But yes, you couldn't sort on the 
> portion -- I just don't see the use case for that.
> 
> *shrugs*
> 
>> Regards,
>> Adrien
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 


___
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] Problems Accessing GnuCash Files on my D:\

[brob2684]

Hi Colin and David,

I've done a bit more digging and it began to looks like there was a small
chance the issue is linked to the special Windows folders.

If I move a copy of my gnucash file to an existing directory on D:\ that is
not a special Windows folder (e.g. D:\Filing or D:\Tmp) then gnucash opens
the file without issue.

On the other hand, if I move the file to a special Windows folder (e.g.
D:\Documents or D:\Favorites or D:\Desktop or D:\Pictures). Surprisingly,
D:\Downloads works without issue.

I haven't made any changes to this setup in the past fortnight.

A fair bit of further random, seemingly aimless Googling along the above
lines kept turning up recommendations about permissions, none of which
worked.



However, I eventually turned up this little chestnut:

https://superuser.com/questions/1293897/cannot-save-files-to-desktop-in-windows-10

It seems "Controlled folder access" was switched on. From what I've read,
it's supposed to be an opt-in feature, and when enabled, it uses a mechanism
to track apps trying to make changes to files in the protected folders. If
the app is malicious, or it's not recognized, the feature will in real-time
block the attempt, and you'll get a notification of the suspicious activity.

So it looks like my problem stems from opting in (sorry, I have no
recollection of doing so) but I've also received no notifications of
suspicious activity either.

Disabling this means I can open/save/edit files in GnuCash that are written
to my D:\Documents folder again.

Thanks both for your help,
brob2684



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

[Adrien Monteleone]

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] Uploading Invoices

[Adrien Monteleone]

I don’t see any reason you can’t use the same invoice number rather than having 
to maintain two numbering systems. GnuCash lets you make up just about any 
numbering scheme you want, so certainly, you use the same original number from 
the external system.

Regards,
Adrien

> On Mar 8, 2019, at 12:02 PM, Justin Haynes  wrote:
> 
> Oh, also, have you looked in File -> Properties?  Notice under book options
> in "Business" and "Counters".  In Counters, those are for internal
> numbering, but there is also a field in invoices
> 
> 
> And one more thing - if the external invoicing system has its own invoice
> numbers, you should be able to import those as the "Billing ID".  That's
> separate from GNUCash's internal InvoicID.  So for example, if you don't
> have any invoices, and you manually created a new customer and created a
> new invoice, you could rely on GNUCash to autonumber teh invoice, and you
> can fill in the external invoice systems id as "Billing ID" Like I show
> here.  I would think importing works the same but I have not tested it
> becaus I don't use an external invoicing system.
> 


___
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] Uploading Invoices

[Adrien Monteleone]

This is covered in the Tutorial & Concepts Guide - Chapter 18 Import Business 
Data. (http://www.gnucash.org/viewdoc.phtml?rev=3=C=guide)

The format you need is CSV and the column headings (fields) are described at 
the end of the chapter in 18.1.2

Note, the beginning of the chapter focuses on Python scripts to accomplish 
converting data to the needed format. This may or may not be useful to you.

Regards,
Adrien

> On Mar 8, 2019, at 11:38 AM, Teresa  wrote:
> 
> I am using an external invoicing system, and I am a new user. I need to 
> import 30 monthly and individual invoices from my invoicing system into Gnu 
> Cash.
> 
> I also need to import invoices YTD, paid and open.
> 
> Is there a template?
> 
> -- 
> 
> Teresa Slack


___
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 3.4 help needed

[devlin]

Nope.

No matter what I try, I get the error that the "gnucash3.4 directory 
does not exist."



On 3/7/19 11:51 PM, David Cousens wrote:

cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local  ../gnucash-3.4

___
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] Problems Accessing GnuCash Files on my D:\

[brob2684]

Hi Colin and David

Thanks very much for your replies.


Colin Law wrote
> Are you using File > Open to open the file?  If so are you able to
> browse the folders on D: ok and see all the files there?

It makes no difference whether I double click on the file, or go file open.


If you copy the file that you can't open from D: to a different drive
are you able to open it from there?


Yes, if I copy the file off the D: drive to my backup drive, I can open it
there. No need to change permissions, or anything, it just works. The
problem seems to be restricted to my D:.


What happens if you open the file from the backup folder and then use
File > Save As to save it to D:?


I get the following message if I try to save the database in XML format as a
new file:
Gnucash could not obtain the lock file for
D:\Documents\\Data\GnuCash\Balsheet-new.gnucash. That database may be
in
use by another user, in which case you should not save the database. Do you
want to proceed with saving the database?
Selecting "Save" results in no file being saved. 

And if I try to save the database in sqlite3 format, I get the following
message:
Can't parse the URL
D:\Documents\\Data\GnuCash\Balsheet-new.gnucash
Again, no file is saved.

If I try to save the file as an XML file overwriting an existing file in the
directory, I get the following message:
Could not make a backup of the file
D:\Documents\\Data\GnuCash\Balsheet.gnucash

If I try to save the file as a sqlite3 file overwriting an existing file in
the directory, I get the following message:
The server at URL D:\Documents\\Data\GnuCash\Balsheet.gnucash
experienced an error or encountered bad or corrupt data.

I am no longer getting the lock error message this morning when attempting
to overwrite. I did this step before attempting to open a file on my D:, so
as David Carlson suggested, it is quite likely I may have had a copy of the
original file open yesterday when I was trying to save as and overwrite it.


If you try to open something like a .doc file from the same folder on
D: in Word or whatever you use is that ok?  Are you able to save it
again.  That may tell you if it is a system problem rather than a
GnuCash problem.


As I said in my initial message, I have no problems saving to the same
directory from Microsoft Word. Also, being explicit this time round, I can
open, edit and save the same file in Word without issue.


When you get the " Gnucash could not obtain the lock file for..." message,
it appears that you actually have the copy on your D: drive open rather
than your backup.  Have you checked the file dates of each copy and the
most recent Gnucash backups (with the .2019.gnucash suffix in the
name)  in each location?

It's quite possible a version I had attempted to open may have been open in
the background yesterday as I am no longer receiving that specific error
message this morning after rebooting my PC. However, as shown by the saving
tests I conducted for Colin above, I still cannot save to the D: location.
Nor can I open a guncash file from that location without error.


What version of GnuCash are you using, what version of Windows are you
using, and how is your drive D: connected to your computer?  When you tried
editing a document on your D: drive per Colin's suggestion, did that work?
How do you address your backup and how is it connected?  How and when do
you back up your D; drive? Have you been diligent about updating Windows OS
and the OS on your D: server?


GnuCash 3.4 from December 2018. This hasn't changed in the past two weeks
(it was installed back in January). I have uninstalled and reinstalled
GnuCash to no avail.

My primary hard drive is split into two partitions, the C: where Windows
resides and the D: where I save my data. The My Documents folder has been
moved to the D:, but it's been this way since the computer was set up, so
again this hasn't changed. GnuCash has no issues saving or opening a file to
C:\Users\.

The backup question was a good one. I have two backups - one saved to a WD
MyBook Elite drive that is directly connected to the PC and accessed via the
L: (I have no idea why Windows gave it that letter, I do not have that many
drives). The files saved here have no issues. The WD backup software hasn't
been updated in years (but it's the latest version on issue). This backup
has not changed.

My NAS also takes a backup of the D: periodically and saves it in read-only
format. I am experiencing the same access errors here. However, I must admit
I have never before tried to open a GnuCash backup file off the NAS. Copying
this file to my WD Backup and unticking the read-only flag sees GnuCash
again work correctly. As far as I can tell, the NAS hasn't been updated
recently - it tends to run and not give me any grief so it's been left
alone. 

Windows 10 updates get downloaded and installed automatically. The Windows
version is 1809 and the OS build is 17763.316 (no idea what the difference
between the two 

Re: [GNC] Still can't update price quotes

[D via gnucash-user]

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 Ralls <
> > jra...@ceridwen.fremont.ca.us> wrote:
> > Make sure that you have no securities using any yahoo source except
> > yahoo_json (which BTW still works well and unlike alphavantage
> > doesn't throttle). Any attempt to use the other yahoo sources will
> > cause the entire retrieval to fail.
> > 
> > Regards,
> > John Ralls
> > 
> > 
> > > On Mar 7, 2019, at 7:34 AM, Elias K Gardner 
> > > wrote:
> > > 
> > > My apologies I left out the error, its:  "
> > > 
> > > On Thu, Mar 7, 2019 at 10:32 AM Elias K Gardner <
> > > zork...@gmail.com> wrote:
> > > 
> > > > I'm still getting the"" error when trying to update my price
> > > > database. I
> > > > got an alpha advantage key, put it in gnucash, and updated my
> > > > Finance::Quote perl module to 1.47. At one point that seemed to
> > > > sort of
> > > > work but now I just get the "" error. Most of my quotes are
> > > > approaching a
> > > > year old. The absolute newest is from November 2018.
> > > > 
> > > > Any suggestions on what I can do? I've searched this list
> > > > multiple times
> > > > already without luck. I fear that I broke something in one of
> > > > my many
> > > > attempts to fix this over the past year. Maybe I should start
> > > > fresh. I've
> > > > attempted to purge gnucash and reinstall but this does not seem
> > > > to start
> > > > everything fresh and frankly purging perl is a little over my
> > > > head without
> > > > clear guidance. Someday I'll reinstall ubuntu entirely (using
> > > > 18.10 now, no
> > > > fresh install for a few years) but thats become a bigger and
> > > > bigger chore.
> > > > 
> > > > I'm open to any suggestions. Much appreciated.
> > > > 
> > > > 
> > > ___
> > > 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] Uploading Invoices

[Justin Haynes]

File -> Import -> Import Bills and Invoices.

Can you export as a csv from your invoicing system?You may want to play
with, say, 1-3 at a time, and then play with the options.

Notice the "Open not yet posted documents in tabs" option which can be
useful, so that you can see how things will import *before* you decide to
post them.

[image: image.png]


Oh, also, have you looked in File -> Properties?  Notice under book options
in "Business" and "Counters".  In Counters, those are for internal
numbering, but there is also a field in invoices


And one more thing - if the external invoicing system has its own invoice
numbers, you should be able to import those as the "Billing ID".  That's
separate from GNUCash's internal InvoicID.  So for example, if you don't
have any invoices, and you manually created a new customer and created a
new invoice, you could rely on GNUCash to autonumber teh invoice, and you
can fill in the external invoice systems id as "Billing ID" Like I show
here.  I would think importing works the same but I have not tested it
becaus I don't use an external invoicing system.

[image: image.png]

On Fri, Mar 8, 2019 at 11:41 AM Teresa  wrote:

> I am using an external invoicing system, and I am a new user. I need to
> import 30 monthly and individual invoices from my invoicing system into
> Gnu Cash.
>
> I also need to import invoices YTD, paid and open.
>
> Is there a template?
>
> --
>
> 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.
>
___
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] Setting up chart of accounts

[Justin Haynes]

Teresa, At the risk of going off topic, hang in there.  :-)   I am not an
accountant and only learned bookkeeping by having the title of "Treasurer"
fall upon me for a non-profit I am involved in.  We needed to use
Quickbooks Online.  Around the same time, I started doing my own finances
in GNUCash.

My experience has been that it is really difficult to start books, and once
you have it nailed down it is much much easier.

On top of that, my opinion is that it is harder to get started with
GNUCash, and much much easier to keep using GNUCash.  Harder because not
many programs work like GNUCash does anymore, but so much easer to keep
using because it is so consistent from version to version.  You can learn
these skills now and you won't have to worry about some company changing
everything ever 3 years and dragging you in a new direction.  GNUCAsh is as
consistent as accounting should be, and it uses *real accounting concepts*,
so it is really universal.

Lastly, the user community is wonderful.  The knowledge is out there, and
the typical user (seems to me) has been using it for years.

Let us know how it goes. Liz experience is in line with mine.  When you
start the account you have an opportunity to transfer from opening
balance.  IT's been a while for me as well.

My opinion is that it is better to have more accounts and more structure
than too little.  You can always delete a subaccounts like
"Expenses:Victuals:Coffee:Retail"  "Expenses:Victuals:Food" and be prompted
to move *all* the transactions into "Expenses:Victuals".  Then you can
rename "Expenses:Victuals" to "Expenses:Food".  But it is much harder to
decide later that you want to split "Expenses:Food" into
"Expenses:Food:Restaurant" and "Expenses:Food:Grocery", becuase you'll have
to redo the transactions to file them into the separate new accounts.

Is your billing taken care of or are you setting up A/P and A/R?  There are
quite a few business owners on the list as well who have experience with
that.  I use A/P for my own personal finances because I love being able to
find all my invoices in one place, and so I can quickly find out if a line
item in checking means I actually paide the whole bill or over paid, etc...

Good luck!,

Justin

On Fri, Mar 8, 2019 at 3:17 AM Liz  wrote:

> On Thu, 07 Mar 2019 14:40:28 -0500
> Michael or Penny Novack  wrote:
>
> > Since you say you are experienced in accounting (but new to gnucash I
> > think what you are asking is "if I have an account A and I want it to
> > be a child of account B, how do I do this (in gnucash)?"
> >
> > Yes?
> >
> > If so, what you want to do is "edit" account A which will give you a
> > chance to specify account B is its parent.
> >
> > Try it where it is easy. For example, under the main parent Assets
> > you probably want children "current assets" and "fixed assets". Then
> > under "current assets" you probably want "checking account",
> > "undeposited cash", etc.
>
> What isn't clear is that you can change things - you can move accounts
> and give them new parents, and so on.
> If you don't get it quite right at first, you can edit it and fix it.
>
> 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.
>
___
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] Uploading Invoices

[Teresa]

I am using an external invoicing system, and I am a new user. I need to 
import 30 monthly and individual invoices from my invoicing system into 
Gnu Cash.


I also need to import invoices YTD, paid and open.

Is there a template?

--

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.

Re: [GNC] Still can't update price quotes

[John Ralls]

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 Ralls  
> wrote:
> Make sure that you have no securities using any yahoo source except 
> yahoo_json (which BTW still works well and unlike alphavantage doesn't 
> throttle). Any attempt to use the other yahoo sources will cause the entire 
> retrieval to fail.
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 7, 2019, at 7:34 AM, Elias K Gardner  wrote:
> > 
> > My apologies I left out the error, its:  "There was an unknown error while
> > retrieving the price quotes"
> > 
> > On Thu, Mar 7, 2019 at 10:32 AM Elias K Gardner  wrote:
> > 
> >> I'm still getting the"" error when trying to update my price database. I
> >> got an alpha advantage key, put it in gnucash, and updated my
> >> Finance::Quote perl module to 1.47. At one point that seemed to sort of
> >> work but now I just get the "" error. Most of my quotes are approaching a
> >> year old. The absolute newest is from November 2018.
> >> 
> >> Any suggestions on what I can do? I've searched this list multiple times
> >> already without luck. I fear that I broke something in one of my many
> >> attempts to fix this over the past year. Maybe I should start fresh. I've
> >> attempted to purge gnucash and reinstall but this does not seem to start
> >> everything fresh and frankly purging perl is a little over my head without
> >> clear guidance. Someday I'll reinstall ubuntu entirely (using 18.10 now, no
> >> fresh install for a few years) but thats become a bigger and bigger chore.
> >> 
> >> I'm open to any suggestions. Much appreciated.
> >> 
> >> 
> > ___
> > 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] Monthly Income V Expense Report (Not Chart)

[Dan Carmona via gnucash-user]

Hi,

 

Tried this but this is not Income V Expenses.  It is more account/category 
transaction summary by month.

 

 

From: Christopher Lam  
Sent: Friday, March 8, 2019 9:11 AM
Cc: Dan Carmona ; Gnucash Users 
Subject: Re: [GNC] Monthly Income V Expense Report (Not Chart)

 

Run the Transaction Report

 

Accounts/Accounts select Income and Expense accounts

Display/Subtotal table: enabled

Sorting/Primary Sortkey: account-name

Sorting/Primary Subtotal: true

Sorting/Secondary Sortkey: date

Sorting/Secondary Subtotal: monthly

Sorting/Hide transactions: enabled

 

 

On Fri, 8 Mar 2019 at 13:49, David Carlson mailto:david.carlson@gmail.com> > wrote:

Dan,

The image you included appears to be from a different program, not from
GnuCash.  GnuCash, to my knowledge, does not have a similar report at this
time.

On Fri, Mar 8, 2019 at 6:34 AM Dan Carmona via gnucash-user <
gnucash-user@gnucash.org  > wrote:

> I can't seem to find how to perform a monthly Income/Expense Report (not
> chart).
>
> For example:
>
>
>
> ___
> 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.

___
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] Order of transactions

[Derek Atkins]

Adrien Monteleone  writes:

> Yes, that is why I was explaining the abuse of the NUM field as a time
> field for sorting and how to do it in a way that works. If you are
> doing this, (or instead using 1,2,3,4 ) *and* you want to keep track
> of a transaction number, then you’ll have to put it somewhere else so
> you can still sort that transaction in the order you want. One obvious
> choice for an alternative would be the Action field for that
> particular split line. Another would be the Note field. (especially if
> the Action field is also otherwise utilized) Another option would be
> the Memo field for the split.

Yes, if you want to order your transactions in a specific order but then
also be able to sort by a transaction number then yes, you would need to
do what you suggest and put the default-sort-order into Num, and the
transaction number into another field.

But why would you want to do that?

You could still SEARCH for transaction number even if you overload num
with ..  But yes, you couldn't sort on the 
portion -- I just don't see the use case for that.

*shrugs*

> Regards,
> Adrien

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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

[Derek Atkins]

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
-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] Monthly Income V Expense Report (Not Chart)

[Christopher Lam]

Run the Transaction Report

Accounts/Accounts select Income and Expense accounts
Display/Subtotal table: enabled
Sorting/Primary Sortkey: account-name
Sorting/Primary Subtotal: true
Sorting/Secondary Sortkey: date
Sorting/Secondary Subtotal: monthly
Sorting/Hide transactions: enabled


On Fri, 8 Mar 2019 at 13:49, David Carlson 
wrote:

> Dan,
>
> The image you included appears to be from a different program, not from
> GnuCash.  GnuCash, to my knowledge, does not have a similar report at this
> time.
>
> On Fri, Mar 8, 2019 at 6:34 AM Dan Carmona via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > I can't seem to find how to perform a monthly Income/Expense Report (not
> > chart).
> >
> > For example:
> >
> >
> >
> > ___
> > 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.
>
___
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

[rmomxtx]

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

Roger 

-Original Message-
From: Derek Atkins  
Sent: Thursday, March 7, 2019 11:18 AM
To: Roger Oliver 
Cc: Gnucash 
Subject: Re: [GNC] Default invoice/statement

Hi,

Roger Oliver  writes:

> Is there a way to move the Fancy invoice/statement layout up to 
> replace the default?

Edit -> Preferences -> Business
   Report for Printing:  ...

> The default layout does not allow putting a logo on the masthead. I'm 
> using the last update of version 2 of GnuCash. It's stable and working 
> for us so haven't seen the need to update.

3.x is current.  I'm running 3.4 and verified the preference is there.
I don't recall when it was added.

> Thanks much,
> Roger Oliver

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Monthly Income V Expense Report (Not Chart)

[David Carlson]

Dan,

The image you included appears to be from a different program, not from
GnuCash.  GnuCash, to my knowledge, does not have a similar report at this
time.

On Fri, Mar 8, 2019 at 6:34 AM Dan Carmona via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I can't seem to find how to perform a monthly Income/Expense Report (not
> chart).
>
> For example:
>
>
>
> ___
> 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.

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

[David Carlson]

 brob268,

When you get the " Gnucash could not obtain the lock file for..." message,
it appears that you actually have the copy on your D: drive open rather
than your backup.  Have you checked the file dates of each copy and the
most recent Gnucash backups (with the .2019.gnucash suffix in the
name)  in each location?

What version of GnuCash are you using, what version of Windows are you
using, and how is your drive D: connected to your computer?  When you tried
editing a document on your D: drive per Colin's suggestion, did that work?
How do you address your backup and how is it connected?  How and when do
you back up your D; drive? Have you been diligent about updating Windows OS
and the OS on your D: server?

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

Re: [GNC] Still can't update price quotes

[David Carlson]

Elias,

Set the source to Single Yahoo as JSON.

That works for me.

David Carlson

On Thu, Mar 7, 2019, 11:18 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 Ralls 
> wrote:
>
> > Make sure that you have no securities using any yahoo source except
> > yahoo_json (which BTW still works well and unlike alphavantage doesn't
> > throttle). Any attempt to use the other yahoo sources will cause the
> entire
> > retrieval to fail.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 7, 2019, at 7:34 AM, Elias K Gardner  wrote:
> > >
> > > My apologies I left out the error, its:  "There was an unknown error
> > while
> > > retrieving the price quotes"
> > >
> > > On Thu, Mar 7, 2019 at 10:32 AM Elias K Gardner 
> > wrote:
> > >
> > >> I'm still getting the"" error when trying to update my price
> database. I
> > >> got an alpha advantage key, put it in gnucash, and updated my
> > >> Finance::Quote perl module to 1.47. At one point that seemed to sort
> of
> > >> work but now I just get the "" error. Most of my quotes are
> approaching
> > a
> > >> year old. The absolute newest is from November 2018.
> > >>
> > >> Any suggestions on what I can do? I've searched this list multiple
> times
> > >> already without luck. I fear that I broke something in one of my many
> > >> attempts to fix this over the past year. Maybe I should start fresh.
> > I've
> > >> attempted to purge gnucash and reinstall but this does not seem to
> start
> > >> everything fresh and frankly purging perl is a little over my head
> > without
> > >> clear guidance. Someday I'll reinstall ubuntu entirely (using 18.10
> > now, no
> > >> fresh install for a few years) but thats become a bigger and bigger
> > chore.
> > >>
> > >> I'm open to any suggestions. Much appreciated.
> > >> 
> > >>
> > > ___
> > > 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] Monthly Income V Expense Report (Not Chart)

[Dan Carmona via gnucash-user]

I can't seem to find how to perform a monthly Income/Expense Report (not
chart). 

For example:



___
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] Setting up chart of accounts

[Liz]

On Thu, 07 Mar 2019 14:40:28 -0500
Michael or Penny Novack  wrote:

> Since you say you are experienced in accounting (but new to gnucash I 
> think what you are asking is "if I have an account A and I want it to
> be a child of account B, how do I do this (in gnucash)?"
> 
> Yes?
> 
> If so, what you want to do is "edit" account A which will give you a 
> chance to specify account B is its parent.
> 
> Try it where it is easy. For example, under the main parent Assets
> you probably want children "current assets" and "fixed assets". Then
> under "current assets" you probably want "checking account",
> "undeposited cash", etc.

What isn't clear is that you can change things - you can move accounts
and give them new parents, and so on.
If you don't get it quite right at first, you can edit it and fix it.

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.

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

[Colin Law]

On Fri, 8 Mar 2019 at 08:41, brob2684  wrote:
>
> I've been saving my gnucash files to
> D:\Documents\\Data\GnuCash\Balsheet.gnucash for a very long time, and
> never had any issues.
>
> Unfortunately, sometime in the past fortnight (not sure when, but that's the
> last time I used GnuCash) something odd has gone on.
>
> I can no longer open GnuCash files off my D:\ (or save files). However, if I
> open the same file off my backup drive, it works flawlessly.
>
> If I copy the file from my backup drive to my D:\, GnuCash doesn't work, but
> it will continue to open files on my backup drive.

Are you using File > Open to open the file?  If so are you able to
browse the folders on D: ok and see all the files there?

If you copy the file that you can't open from D: to a different drive
are you able to open it from there?

What happens if you open the file from the backup folder and then use
File > Save As to save it to D:?

If you try to open something like a .doc file from the same folder on
D: in Word or whatever you use is that ok?  Are you able to save it
again.  That may tell you if it is a system problem rather than a
GnuCash problem.

Colin
___
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] Problems Accessing GnuCash Files on my D:\

[brob2684]

I've been saving my gnucash files to
D:\Documents\\Data\GnuCash\Balsheet.gnucash for a very long time, and
never had any issues.

Unfortunately, sometime in the past fortnight (not sure when, but that's the
last time I used GnuCash) something odd has gone on.

I can no longer open GnuCash files off my D:\ (or save files). However, if I
open the same file off my backup drive, it works flawlessly.

If I copy the file from my backup drive to my D:\, GnuCash doesn't work, but
it will continue to open files on my backup drive.

The error message I receive when opening a file from my D:\ is:
The server at URL D:\Documents\\Data\GnuCash\Balsheet.gnucash
experienced an error or encountered bad or corrupt data.

A previous post suggested that it might be a permissions issue, but I have
given Everyone write permission to that folder on my D:\ and there's no
change in behaviour.

When attempting to save an opened file from my backup drive to my D:\
results in the following message:
Gnucash could not obtain the lock file for
D:\Documents\\Data\GnuCash\Balsheet.gnucash. That database may be in
use by another user, in which case you should not save the database. Do you
want to proceed with saving the database?
Selecting "Save" results in no file being saved.

The trace file doesn't seem to be helpful either. When opening I get:
* 19:05:47  WARN  Could not spawn perl: Failed 
to execute
child process (No such file or directory)
* 19:05:47  CRIT  [error_handler()] DBI error: 
14: unable
to open database file

When saving a file to the D:\, the trace contens are:
* 18:44:23  WARN  Could not spawn perl: Failed 
to execute
child process (No such file or directory)
* 18:57:19  WARN  [GncXmlBackend::check_path()] 
Couldn't find
D:\Documents\\Data\GnuCash\Balsheet.gnucash

There haven't been any new programs installed in the past three weeks, only
the standard Microsoft updates to Maps, Voice Recorder, et al, and an update
to Acrobat Reader.

I have no issues saving Microsoft Word files to the above path. Does anyone
have any suggestions as to what I might be able to try in order to rectify
the issue between GnuCash and my D:\ as it is really baffling me?

Thanks in advance,
brob2684



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