Re: Gnucash coredump

2017-12-19 Thread Tommy Trussell
On Tue, Dec 19, 2017 at 5:24 PM, Cliff McDiarmid 
wrote:

> Just found this here 'https://lists.gnucash.org/wiki/Slackware'
>
> /usr/bin/glib-compile-schemas usr/share/glib-2.0/schemas >/dev/null 2>&1
>
>
> Please execute the last command after installation or you will receive
> error like:  Settings schema 'org.gnucash.general' is not
> installed
>
> Maybe this is not a fault.  At a terminal all I get is : Trace/breakpoint
> trap (core dumped)
>
> Cliff
>
>
>From what you said in the other thread, Slackware isn't your distribution.
If you are running Slackware, installing an Ubuntu package would explain
your trouble, because they don't use the same package system.

You mentioned using dpkg in the other thread, and that's the Debian or
Ubuntu command to use when you have either downloaded or compiled
individual packages, but it can be a crude implement -- you may have
accidentally overrode the package manager's recommendations. You will find
apt is much more helpful about making sure all the pieces are in place.

Did you try installing gnucash using the apt command as mentioned in the
other thread? Using the Ubuntu Software tool would work, too.



> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


US tax with foreign stocks advance portfolio

2017-12-19 Thread Ignacio Fernandez Ortega
Hi,

Question about how Gnucash handles the foreign stocks. My Gnucah main
currency is dollar but I have some stocks in EUR.
Gnucash is updating the basis cost in dollar every time I update the EUR/$
exchange rate in the Advance Portfolio report.
However, IRS requires comparing the selling price with cost basis with the
exchange rate at each specific date.

https://www.irs.gov/individuals/international-taxpayers/foreign-currency-and-currency-exchange-rates

Is there a way to keep the cost basis with fixed exchange rate?

Thanks
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Gnucash coredump

2017-12-19 Thread Cliff McDiarmid
Just found this here 'https://lists.gnucash.org/wiki/Slackware'
 
/usr/bin/glib-compile-schemas usr/share/glib-2.0/schemas >/dev/null 2>&1

 
Please execute the last command after installation or you will receive error 
like:  Settings schema 'org.gnucash.general' is not installed
 
Maybe this is not a fault.  At a terminal all I get is : Trace/breakpoint trap 
(core dumped)

Cliff
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnucash coredump gnome

2017-12-19 Thread Tommy Trussell
Hi -- you must mean Ubuntu.

If you used dpkg you probably didn't install all the dependencies.

I suggest these two terminal commands first

sudo apt update
sudo apt upgrade

Watch the output of those for errors. If you see any, you'll want to
correct them.

Then to get all of gnucash installed, you might try

sudo apt install gnucash

When that gets all the dependencies in, the application should work.

You might also want the documentation and python bindings:

sudo apt install gnucash-docs python-gnucash


On Tue, Dec 19, 2017 at 4:19 PM, cliffhan...@gardener.com <
cliffhan...@gardener.com> wrote:

>Using Linux with gnome see message for ver. Gnucash was installed with
>dpkg.
>
> Original Message 
>Subject: Re: gnucash coredump gnome
>From: Colin Law
>To: Cliff McDiarmid
>CC: gnucash-user@gnucash.org
>
>  On 19 December 2017 at 19:20, Cliff McDiarmid wrote:
>  >
>  > Hi
>  >
>  > Just joined. i have been using Quicken for 24years running under
>  Wine! It's now time to change, problems with older versions of it.
>  >
>  > I'm running Gnome 16.04LTS. But I have problems with my first
>  foray into Gnucash. It is coredumping without starting, version
>  1:2.6.12-1. Other versions also dump. I've run it with Strace and
>  the log is attached. AFAIK all dependencies are satisfied.
>  Which OS are you using and how did you install gnucash?
>  Colin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: gnucash coredump gnome

2017-12-19 Thread John Ralls


> On Dec 19, 2017, at 11:20 AM, Cliff McDiarmid  
> wrote:
> 
> 
> Hi
>  
> Just joined.  i have been using Quicken for 24years running under Wine!  It's 
> now time to change, problems with older versions of it. 
>  
> I'm running Gnome 16.04LTS.  But I have problems with my first foray into 
> Gnucash.  It is coredumping without starting, version 1:2.6.12-1.  Other 
> versions also dump.  I've run it with Strace and the log is attached.  AFAIK 
> all dependencies are satisfied.
> 
> Can anyone help here?
> 

Welcome.

At the end of your log is a tantalizing start of an error message from GIO, 
"Sett...".
Can you look at the tail of the trace file [1] and see if the whole thing is 
there?
If not, start GnuCash from a terminal, it should show up there.

Regards,
John Ralls

[1] https://wiki.gnucash.org/wiki/Trace_File

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: gnucash coredump gnome

2017-12-19 Thread cliffhan...@gardener.com
   Using Linux with gnome see message for ver. Gnucash was installed with
   dpkg.

    Original Message 
   Subject: Re: gnucash coredump gnome
   From: Colin Law
   To: Cliff McDiarmid
   CC: gnucash-user@gnucash.org

 On 19 December 2017 at 19:20, Cliff McDiarmid wrote:
 >
 > Hi
 >
 > Just joined. i have been using Quicken for 24years running under
 Wine! It's now time to change, problems with older versions of it.
 >
 > I'm running Gnome 16.04LTS. But I have problems with my first
 foray into Gnucash. It is coredumping without starting, version
 1:2.6.12-1. Other versions also dump. I've run it with Strace and
 the log is attached. AFAIK all dependencies are satisfied.
 Which OS are you using and how did you install gnucash?
 Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: gnucash coredump gnome

2017-12-19 Thread Paul Neuwirth
On Tue, 19 Dec 2017 20:20:06 +0100
"Cliff McDiarmid"  wrote:

> Hi
>  
> Just joined.  i have been using Quicken for 24years running under
> Wine!  It's now time to change, problems with older versions of it. 
> I'm running Gnome 16.04LTS.  But I have problems with my first foray
> into Gnucash.  It is coredumping without starting, version
> 1:2.6.12-1.  Other versions also dump.  I've run it with Strace and
> the log is attached.  AFAIK all dependencies are satisfied.
> 
> Can anyone help here?
> 
> Many thanks

could you repeat the strace using longer strings (using e.g. strace -s
200)

the whole error message get's cut:

write(3, "* 19:18:00 OTHER  Sett"..., 83) = 83
--- SIGTRAP {si_signo=SIGTRAP, si_code=SI_KERNEL} ---
+++ killed by SIGTRAP (core dumped) +++

seems to be related to GLib-GIO.. 
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Newbie needs help ( bills and payments)

2017-12-19 Thread Geert Janssens
Op dinsdag 19 december 2017 12:18:11 CET schreef Paul Neuwirth:
> Hi Geert,
> 
> hartelijk bedankt. Thank you, that was exactly what I missed.
> Would be very nice If open bills would be shown after selecting vendor..
> 
> groetjes
> 
> Paul

Dag Paul,

(I readded your reply to the list as the remainder of this conversation may 
also be of interest to others. Please use reply-all in the future)

I'm not sure I understand what you mean or would like. Can you explain in some 
more detail what happened and what you would have liked instead ?

Groeten,

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: Can't use AR type accounts with invoices

2017-12-19 Thread Geert Janssens
Op dinsdag 19 december 2017 16:09:59 CET schreef Adrien Monteleone:
> Thanks again Geert,
> 
> Indeed, the type alone was the issue. I placed the desired accounts back
> under their A/R & A/P parents and everything still works the way I want.
> 
> As far as I can tell, the customer and vendor reports still work properly
> because I still use invoices and bills at some point in the process. The
> special accounts are just for accruals. If I notice any other report issues
> I’ll be sure to post an addendum.
> 
Great!

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: export general ledger

2017-12-19 Thread Geert Janssens
Op dinsdag 19 december 2017 15:58:38 CET schreef Adrien Monteleone:
> Thanks Geert,
> 
> Good to know if I ever need this, export is not the way to go.
> 
> Out of curiosity, could you shed light on why the limitation to export only
> one account type at a time?
> 
> Regards,
> Adrien

I believe this stems from the state of import/export at the time this feature 
was added. Csv import was primarily intended to import bank statements and 
with that limited scope had limited functionality. The csv export was written 
as an inverse operation for this csv import, and in that mindset it was never 
considered to export the GL as the csv import wouldn't be able to import it 
anyway (support for roundtrip export-import was taken in consideration but not 
properly implemented).

In 2.7 the csv importer has been made much more flexible and I believe it 
would even be able to import GL like transaction data now.

The csv exporter has not (yet) gotten the same attention in 2.7 so GL export 
is still not available. It would make more sense now though to line it up with 
the improved csv importer.

Is there an enhancement request for this ? If not, feel free to file one.

Regards,

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: Can't use AR type accounts with invoices

2017-12-19 Thread Adrien Monteleone
Thanks again Geert,

Indeed, the type alone was the issue. I placed the desired accounts back under 
their A/R & A/P parents and everything still works the way I want.

As far as I can tell, the customer and vendor reports still work properly 
because I still use invoices and bills at some point in the process. The 
special accounts are just for accruals. If I notice any other report issues 
I’ll be sure to post an addendum.

Regards,
Adrien

> On Dec 19, 2017, at 2:38 AM, Geert Janssens  
> wrote:
> 
> Adrien,
> 
> To clarify your experience: the limiting  factor is indeed the account type. 
> A/R and A/P type accounts can only be used to post invoices/bills/vouchers to 
> and to assign payments to customers/vendors/employees. This is a limitation 
> embedded deeply into the design and can't be easily changed unfortunately.
> 
> As you found you can create an account of type Asset instead of A/R to do 
> what 
> you want. What is not clear in your report is that you can add this Asset 
> account under your A/R account as a subaccount so at least your chart of 
> accounts continues to make sense.
> 
> Similarly for A/P you can create subaccounts of type Liability. You can 
> *name* 
> them A/P-something if you prefer, but the account *type* must not be A/P.
> 
> To be complete, I haven't verified if all reports will be able to handle this 
> unusual arrangement of accounts though.
> 
> Regards,
> 
> Geert
> 
> Op dinsdag 19 december 2017 06:11:10 CET schreef Adrien Monteleone:
>> So, trying to work around the multi-period posting date issue in another
>> thread, I opted to bring in a vestige of paper accounting and utilize an
>> Accrued Revenue account. (otherwise known as ‘unbilled revenue’ or
>> ‘unbilled work’)
>> 
>> The guidance I found online suggested this should be a Current Asset,
>> generally of type A/R.
>> 
>> I tried to create an A/R sub-account. This worked until I tried to adjust an
>> invoice so it’s line items hit this Accrued Revenue account instead of an
>> Income account. The invoice feature won’t let me see it in the list to
>> select it.
>> 
>> So, I moved the account out of the parent A/R and placed it under Current
>> Assets. Still no dice.
>> 
>> Apparently, the account ‘type’ was ‘A/Receivable’ and the business features
>> look at this when deciding what to allow you to use in an invoice and bill.
>> This type is apparently not allowed, even though it isn’t the main A/R
>> account created by the Business Features and to which I do not manually
>> post.
>> 
>> Note, I can *post* the invoice to the standard A/R account (or likely any
>> other A/R type I create) but I can’t use other A/R types for the line
>> items. This means contra-accounts are not allowed.
>> 
>> The solution was to delete the Accrued Revenue account I just created, and
>> re-create it with the parent Current Assets and give it type Asset. Now
>> everything works, but instead of being able to roll this under A/R where it
>> belongs, I have a flatter account tree. Now I recall a similar issue trying
>> to create A/P sub-accounts some months ago. There’s no point. The business
>> features won’t let you use them. (except to post to, you can’t use it for
>> bill line-items)
>> 
>> I suppose this behavior is intended and I understand the urge to prevent
>> people from using accounts that make a mess of things, but it requires yet
>> another work around.
>> 
>> Just passing this on in case anyone else runs into this.
>> 
>> Regards,
>> Adrien
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: export general ledger

2017-12-19 Thread Adrien Monteleone
Thanks Geert,

Good to know if I ever need this, export is not the way to go.

Out of curiosity, could you shed light on why the limitation to export only one 
account type at a time?

Regards,
Adrien

> On Dec 19, 2017, at 2:16 AM, Geert Janssens  
> wrote:
> 
> Op dinsdag 19 december 2017 02:55:14 CET schreef Adrien Monteleone:
>> Sorry if my understanding of the GC General Ledger was off.
>> 
>> By combining the files, I meant the exported csv files. So a simple: “cat *
>>> gnucash.csv” after those 4 exports would do the trick.
>> 
> You'd probably end up with lots of duplicate transactions rather than a 
> properly exported general ledger...
> 
> Geert

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Newbie needs help ( bills and payments)

2017-12-19 Thread Geert Janssens
Hi Paul,

You're almost there :)

The gnucash importers are not aware of the business features of gnucash 
unfortunately. So for the importer there are only transactions. It won't be 
able to offer bills for transaction matching.

So after the import (as you did correctly) you still have to manually tell 
gnucash which payment belongs to which bill.

The way to do this is to right-click on the payment in the account register 
for your bank and then choose "Assign as payment...". This will open up the 
payment window with all the details gnucash can already extract from the 
payment transaction. Fill in the missing pieces (at a bare minimum the vendor 
and the bill you're about to pay) and hit Ok. This needs to be repeated for 
each imported payment.

Regards,

Geert

Op dinsdag 19 december 2017 10:47:00 CET schreef Paul Neuwirth:
> Hello list,
> 
> I am not sure, if I understood everything about book keeping and
> gnucash's functionalities. I asked previously on German language list,
> and got the tip to ask here.
> 
> What I already did:
> 
> imported extended accounts (according to German standard SKR03) and
> laboriously typed in all vendors and bills. But not the
> according payments yet.
> I hoped, I am able to import the bookings from my bank account
> (aqbanking or csv import) und link it to the bills or reconcile.
> 
> Doing this import gnucash does'nt find potential splits matching or
> creates many balance splits. I also tried to process payments before
> import but also these (same looking) splits cannot be reconciled by
> import.
> 
> What is the correct method?
> 
> I would appreciate any help.
> 
> Here I got some screenshots, how I proceed. (If German translation
> matters, I can make new ones using English translation):
> 
> 
> 1) https://www.swabian.net/extern/gncml/gnucash1.png
> importing CSV, seperator, date, account etc. are ok.
> amount marked as "Deposit" (minus signed ones are withdrawals)
> 2) https://www.swabian.net/extern/gncml/gnucash2.png
> account matching is also ok
> 3) https://www.swabian.net/extern/gncml/gnucash3.png
> from last tries gnucash learned to book to
> "Verbindlichkeiten" (Account/Payable)
> 3a) https://www.swabian.net/extern/gncml/gnucash4.png
> If I try to "R+U" (reconcile + update?), gnucash doesn't find matching
> splits.
> 4) https://www.swabian.net/extern/gncml/gnucash5.png
> if I import the bookings as "new", Gnucash correctly books from
> e.g. credit card to payable account
> 
> actually ok.. but:
> 
> my basic question
> 6) https://www.swabian.net/extern/gncml/gnucash6.png
> How do I link the bookings to the bills/payments?
> The bills stay due, if I click "process payment" I only can create a
> new split, which would look identical to imported ones.
> 
> 
> regards
> 
> Paul Neuwirth
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Newbie needs help ( bills and payments)

2017-12-19 Thread Paul Neuwirth
Hello list,

I am not sure, if I understood everything about book keeping and
gnucash's functionalities. I asked previously on German language list,
and got the tip to ask here.

What I already did:

imported extended accounts (according to German standard SKR03) and
laboriously typed in all vendors and bills. But not the
according payments yet.
I hoped, I am able to import the bookings from my bank account
(aqbanking or csv import) und link it to the bills or reconcile.

Doing this import gnucash does'nt find potential splits matching or
creates many balance splits. I also tried to process payments before
import but also these (same looking) splits cannot be reconciled by
import.

What is the correct method?

I would appreciate any help.

Here I got some screenshots, how I proceed. (If German translation
matters, I can make new ones using English translation):


1) https://www.swabian.net/extern/gncml/gnucash1.png
importing CSV, seperator, date, account etc. are ok.
amount marked as "Deposit" (minus signed ones are withdrawals)
2) https://www.swabian.net/extern/gncml/gnucash2.png
account matching is also ok
3) https://www.swabian.net/extern/gncml/gnucash3.png
from last tries gnucash learned to book to
"Verbindlichkeiten" (Account/Payable)
3a) https://www.swabian.net/extern/gncml/gnucash4.png
If I try to "R+U" (reconcile + update?), gnucash doesn't find matching
splits.
4) https://www.swabian.net/extern/gncml/gnucash5.png
if I import the bookings as "new", Gnucash correctly books from
e.g. credit card to payable account

actually ok.. but:

my basic question
6) https://www.swabian.net/extern/gncml/gnucash6.png
How do I link the bookings to the bills/payments?
The bills stay due, if I click "process payment" I only can create a
new split, which would look identical to imported ones.


regards

Paul Neuwirth
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: Can't use AR type accounts with invoices

2017-12-19 Thread Geert Janssens
Adrien,

To clarify your experience: the limiting  factor is indeed the account type. 
A/R and A/P type accounts can only be used to post invoices/bills/vouchers to 
and to assign payments to customers/vendors/employees. This is a limitation 
embedded deeply into the design and can't be easily changed unfortunately.

As you found you can create an account of type Asset instead of A/R to do what 
you want. What is not clear in your report is that you can add this Asset 
account under your A/R account as a subaccount so at least your chart of 
accounts continues to make sense.

Similarly for A/P you can create subaccounts of type Liability. You can *name* 
them A/P-something if you prefer, but the account *type* must not be A/P.

To be complete, I haven't verified if all reports will be able to handle this 
unusual arrangement of accounts though.

Regards,

Geert

Op dinsdag 19 december 2017 06:11:10 CET schreef Adrien Monteleone:
> So, trying to work around the multi-period posting date issue in another
> thread, I opted to bring in a vestige of paper accounting and utilize an
> Accrued Revenue account. (otherwise known as ‘unbilled revenue’ or
> ‘unbilled work’)
> 
> The guidance I found online suggested this should be a Current Asset,
> generally of type A/R.
> 
> I tried to create an A/R sub-account. This worked until I tried to adjust an
> invoice so it’s line items hit this Accrued Revenue account instead of an
> Income account. The invoice feature won’t let me see it in the list to
> select it.
> 
> So, I moved the account out of the parent A/R and placed it under Current
> Assets. Still no dice.
> 
> Apparently, the account ‘type’ was ‘A/Receivable’ and the business features
> look at this when deciding what to allow you to use in an invoice and bill.
> This type is apparently not allowed, even though it isn’t the main A/R
> account created by the Business Features and to which I do not manually
> post.
> 
> Note, I can *post* the invoice to the standard A/R account (or likely any
> other A/R type I create) but I can’t use other A/R types for the line
> items. This means contra-accounts are not allowed.
> 
> The solution was to delete the Accrued Revenue account I just created, and
> re-create it with the parent Current Assets and give it type Asset. Now
> everything works, but instead of being able to roll this under A/R where it
> belongs, I have a flatter account tree. Now I recall a similar issue trying
> to create A/P sub-accounts some months ago. There’s no point. The business
> features won’t let you use them. (except to post to, you can’t use it for
> bill line-items)
> 
> I suppose this behavior is intended and I understand the urge to prevent
> people from using accounts that make a mess of things, but it requires yet
> another work around.
> 
> Just passing this on in case anyone else runs into this.
> 
> Regards,
> Adrien
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: export general ledger

2017-12-19 Thread Geert Janssens
Op dinsdag 19 december 2017 02:55:14 CET schreef Adrien Monteleone:
> Sorry if my understanding of the GC General Ledger was off.
> 
> By combining the files, I meant the exported csv files. So a simple: “cat *
> > gnucash.csv” after those 4 exports would do the trick.
> 
You'd probably end up with lots of duplicate transactions rather than a 
properly exported general ledger...

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.