Can't use AR type accounts with invoices

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

Re: Gnucash on Linux Mint

[Tommy Trussell]

On Mon, Dec 18, 2017 at 5:15 PM, Robert Heller  wrote:

> At Mon, 18 Dec 2017 15:50:29 -0600 Les  wrote:
>
> >
> > I have been using Linux Mint Mate for several years, updating with each
> > incremental release.  Currently at 18.2, planning to upgrade to 18.3
> > shortly.  I get a .deb package from getdeb.net. The latest is 2.6.17
> > which has not been updated for some time.
> >
> > Is any Linux Mint users finding newer packages anywhere.  I would like
> > to update to the last 2.6.19.
>
> You will likely have to download the source and build it yourself.  You
> could
> ask the distro maintainers if they will be pushing a newer version into the
> repo.
>
>
A couple of years ago, when I was learning how to test GnuCash packages for
inclusion in Ubuntu 16.04 LTS, I had some email exchanges with a volunteer
at getdeb.net, and he encouraged me to help them test GnuCash getdeb
packages, implying they would get into getdeb.net much quicker that way.

I found the process to be fairly easy, though they use a build environment
different from the official Ubuntu process so I got bogged down trying to
understand the technical differences (and my focus at the time was making
sure the LTS package was good). Other projects have distracted me since
then, I'm sorry to say.

In any case, if you find yourself dependent upon getdeb.net, consider
sending them a monetary donation to pay for bandwidth, and also consider
contacting them to see if you can help keep your favorite package(s)
updated.

I believe it's a very small organization, but in my experience they respond
well to kind messages.



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

[Adrien Monteleone]

Jeff,

If you have piles of invoices, and you like data entry spreadsheet/text style, 
you can set up an import csv for them instead and bring them in all at once.

There’s a few threads here about the format not too long ago. (within the year)

Regards,
Adrien

> On Dec 18, 2017, at 1:06 PM, Jeff Abrahamson  wrote:
> 
> Thanks, Adrien.  In the end, as long as I can automate this, I'll be
> happy.  (I haven't fully followed on on the python solution, but it sure
> looks like it will work fine, so I've chalked it up as future work for
> me rather than potential workflow blocking today.  Always good to have a
> project over Christmas.)
> 
> Ultimately, it's a user experience issue, and I don't have any vision at
> all of what gnucash users expect.  The accounting software I've used
> previously was geared towards professional accountants, and some of the
> features (like journal entry rather than account entry) I found really
> convenient once I got used to them.  Faced with a pile of bills, for
> example, it was great to be able to enter them all from their respective
> a/p to their respective expense accounts without a single mouse click,
> just a steady stream of typing bill numbers, descriptions, amounts, and
> debit and credit account numbers.
> 
> Again, my perspective is keeping the books for a rowing club.  I'm sure
> that matters in terms of what I find convenient or not.
> 
> Jeff
> 
> 
> On 18/12/17 19:13, Adrien Monteleone wrote:
>> Jeff,
>> 
>> If I recall correctly from other discussion, the General Ledger is not it’s 
>> own entity. It’s a ‘view’ of the separate account ledgers all rolled into 
>> one. This is probably why there is no export option for it.
>> 
>> GnuCash takes the opposite approach from paper books.
>> 
>> With paper, you enter everything in a General Journal and then later post 
>> the proper amounts to T-accounts.
>> 
>> With GnuCash, you skip the Journal and enter directly to the accounts.
>> 
>> The General Ledger was provided for the benefit of those who were used to 
>> the paper method and wanted the option to see all transactions in 
>> chronological order regardless of accounts used.
>> 
>> But I don’t see why you can’t combine the files after the fact. That’s an 
>> easy concatenation command.
>> 
>> It is curious that you can’t export ‘all’ transactions and have to choose 
>> only one hierarchy at a time.
>> 
>> Regards,
>> Adrien
>> 
>>> On Dec 17, 2017, at 1:31 PM, Jeff Abrahamson  wrote:
>>> 
>>> I'd like to export the general ledger to a csv file.  When I use File ->
>>> Export, however, I'm offered a choice of exporting income, expenses,
>>> assets, or liabilities.  But I'd like to have all transactions in the
>>> csv file.
>>> 
>>> I think I see how to do this using python (the example script
>>> account_analysis.py in the examples is instructive).  But this seems so
>>> basic I suspect I'm missing something.
>>> 
>>> Many thanks for any pointers.
>>> 
>>> -- 
>>> 
>>> Jeff Abrahamson
>>> +33 6 24 40 01 57
>>> +44 7920 594 255
>>> 
>>> http://p27.eu/jeff/
>>> 
>>> 
>>> ___
>>> 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.
> 
> -- 
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> http://p27.eu/jeff/
> 
> 

___
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

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

Regards,
Adrien

> On Dec 18, 2017, at 1:17 PM, Wm via gnucash-user  
> wrote:
> 
> On 18/12/2017 18:13, Adrien Monteleone wrote:
>> Jeff,
>> If I recall correctly from other discussion, the General Ledger is not it’s 
>> own entity. It’s a ‘view’ of the separate account ledgers all rolled into 
>> one. This is probably why there is no export option for it.
> 
> You recall incorrectly.  The general ledger is (as the name suggests) 
> actually about as pure a view as the UI gives of the entirety of a gnc set of 
> accounts as is available.
> 
> gnc does not actually have separate account ledgers at all, it belongs to the 
> stream of transactions accounting family.
> 
>> GnuCash takes the opposite approach from paper books.
> 
> that may be correct or incorrect, depending on where you learned accounting.
> 
>> With paper, you enter everything in a General Journal and then later post 
>> the proper amounts to T-accounts.
> 
> Not in UK accounting you don't.  In UK accounting you do it the other way :)
> 
>> With GnuCash, you skip the Journal and enter directly to the accounts.
>> The General Ledger was provided for the benefit of those who were used to 
>> the paper method and wanted the option to see all transactions in 
>> chronological order regardless of accounts used.
> 
> 
> Bollocks.
> 
>> But I don’t see why you can’t combine the files after the fact. That’s an 
>> easy concatenation command.
> 
> Oh, for fuck's sake.  There are no separate files, it is a stream of 
> transactions.
> 
>> It is curious that you can’t export ‘all’ transactions and have to choose 
>> only one hierarchy at a time.
> 
> Yes, that is a bit weird, but it is probably like that because someone had 
> the same misunderstanding as you about separate account ledgers 15 or more 
> years ago.
> 
> -- 
> Wm
> 
> ___
> 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

[Wm via gnucash-user]

On 18/12/2017 18:13, Adrien Monteleone wrote:

Jeff,

If I recall correctly from other discussion, the General Ledger is not it’s own 
entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This 
is probably why there is no export option for it.



You recall incorrectly.  The general ledger is (as the name suggests) 
actually about as pure a view as the UI gives of the entirety of a gnc 
set of accounts as is available.


gnc does not actually have separate account ledgers at all, it belongs 
to the stream of transactions accounting family.



GnuCash takes the opposite approach from paper books.


that may be correct or incorrect, depending on where you learned accounting.


With paper, you enter everything in a General Journal and then later post the 
proper amounts to T-accounts.


Not in UK accounting you don't.  In UK accounting you do it the other way :)


With GnuCash, you skip the Journal and enter directly to the accounts.

The General Ledger was provided for the benefit of those who were used to the 
paper method and wanted the option to see all transactions in chronological 
order regardless of accounts used.



Bollocks.


But I don’t see why you can’t combine the files after the fact. That’s an easy 
concatenation command.


Oh, for fuck's sake.  There are no separate files, it is a stream of 
transactions.



It is curious that you can’t export ‘all’ transactions and have to choose only 
one hierarchy at a time.


Yes, that is a bit weird, but it is probably like that because someone 
had the same misunderstanding as you about separate account ledgers 15 
or more years ago.


--
Wm

___
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

[Wm via gnucash-user]

On 18/12/2017 13:16, Sébastien de Menten wrote:

To export a gnucash book to a ledger-cli output, you may be interested by
the piecash python module and the related script
https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py


I already said that, you just have to wait longer for my messages while 
someone checks if I have said something that one person in a faraway 
land of innocence might consider rude :)


--
Wm

___
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

[Wm via gnucash-user]

On 18/12/2017 10:32, Jeff Abrahamson wrote:

On 18/12/17 03:26, Wm via gnucash-user wrote:

On 17/12/2017 19:31, Jeff Abrahamson wrote:

I'd like to export the general ledger to a csv file.  When I use File ->
Export, however, I'm offered a choice of exporting income, expenses,
assets, or liabilities.  But I'd like to have all transactions in the
csv file.

I think I see how to do this using python (the example script
account_analysis.py in the examples is instructive).  But this seems so
basic I suspect I'm missing something.

Many thanks for any pointers.

May be easier to do a transaction report or similar and copy and paste
that into a spreadsheet.

Alternatively there are a number of scripts that can take gnc files of
some flavour and produce ledger-cli / beancount compatible files which
are generally mores useful than csv files for accounting data anyway.


Ah, ledger-cli and beancount are neat, thanks for the pointer.

This sort of export is something I want to be able to do frequently.
I'll have a look around for scripts to automate it.


The database formats of both gnc and the text accounting tools are 
pretty stable so once you get an export that works you won't have to 
fiddle with it much.  Only major decision is that you might have to 
switch to an sqlite backend if you are using xml at the moment (but the 
long term plan is for sqlite to be the default store anyway).


I've probably used most of the conversion scripts over time, let me know 
the gist of what you're trying to achieve and I'll dig through the ones 
I've used.


If you can read python it'll be plain sailing and the best place to 
start is probably Sebastien's work

https://piecash.readthedocs.io/en/latest/
he has a ledger-cli conversion and ledger-cli to csv (or gnc to csv if 
that is what you really want) is simple.


The point about using text accounting as an intermediary is that damn 
near everyone has had a kick at it so there is little you can't make it 
do or get out of (or into) it.


As an e.g. of frequent use (but probably in the opposite direction) I 
used ledger-cli to black box per month everything that happens for one 
of my p2p accounts that produces hundreds of transactions of less than a 
few pennies and with more than 2 decimal significance and just isn't 
worth replicating in gnc; ledger-cli produces a summary journal per 
month and I put *that* into gnc


--
Wm

___
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: MacOS 10.13.2 won't work with Gnucash

[its...@gmail.com]

Hi Everyone,

I just can't believe it! That was indeed the problem - I had downloaded the
MacOS-PPC file instead of the Intel one. Not the sort of mistake I usually
make! Gnucash 2.6.19 is now running, after a few hiccups, the working
none-the-less. I'll be a damn sight more careful in future.

Thank you for all your efforts in resolving this for me - I know I'm getting
old...

===
Pat. Mitchell



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 on Linux Mint

[Robert Heller]

At Mon, 18 Dec 2017 15:50:29 -0600 Les  wrote:

> 
> I have been using Linux Mint Mate for several years, updating with each 
> incremental release.  Currently at 18.2, planning to upgrade to 18.3 
> shortly.  I get a .deb package from getdeb.net. The latest is 2.6.17 
> which has not been updated for some time.
> 
> Is any Linux Mint users finding newer packages anywhere.  I would like 
> to update to the last 2.6.19.

You will likely have to download the source and build it yourself.  You could 
ask the distro maintainers if they will be pushing a newer version into the 
repo.

> 
> Thanks,
> 
> Les
> 
> ___
> 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.
> 
>   

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

  
___
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 on Linux Mint

[Les]

I have been using Linux Mint Mate for several years, updating with each 
incremental release.  Currently at 18.2, planning to upgrade to 18.3 
shortly.  I get a .deb package from getdeb.net. The latest is 2.6.17 
which has not been updated for some time.


Is any Linux Mint users finding newer packages anywhere.  I would like 
to update to the last 2.6.19.


Thanks,

Les

___
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

[Aaron Laws]

>
> Alternatively there are a number of scripts that can take gnc files of
> some flavour and produce ledger-cli / beancount compatible files which are
> generally mores useful than csv files for accounting data anyway.


It looks like ledger-cli dropped gnucash import support in 2009?

https://github.com/ledger/ledger/commit/71642d98

Also

https://github.com/ledger/ledger/commit/aece6339, and
https://github.com/ledger/ledger/commit/d56f9c4032
___
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: MacOS 10.13.2 won't work with Gnucash

[its...@gmail.com]

Hi Everyone,

I just can't believe it! That was indeed the problem - I had downloaded the
MacOS-PPC file instead of the Intel one. Not the sort of mistake I usually
make! Gnucash 2.6.19 is now running, after a few hiccups, the working
none-the-less. I'll be a damn sight more careful in future.

Thank you for all your efforts in resolving this for me - I know I'm getting
old...

===
Pat. Mitchell



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: MacOS 10.13.2 won't work with Gnucash

[Dave H]

Hi Pat,

I thought I'd already seen a message to the effect that you'd downloaded
the wrong Mac executable - you need to download the Mac OSX Intel bundle
NOT the Power PC bundle ?

What is the name of the dmg you downloaded - should have Intel in the name
NOT PPC.

Cheers Dave H.


On 19 December 2017 at 05:30, its...@gmail.com  wrote:

> I did what was suggested with Terminal, although it didn't seem to work
> initially. After I removed the % sign from the command and tried again,
> this
> is what came up:
>  Gnucash_at_Dec_18_23-52-10.png>
> I'm still not sure I got the command right as I rarely use Terminal. Does
> it
> mean anything to you?Pat.M
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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: MacOS 10.13.2 won't work with Gnucash

[its...@gmail.com]

I did what was suggested with Terminal, although it didn't seem to work
initially. After I removed the % sign from the command and tried again, this
is what came up:

I'm still not sure I got the command right as I rarely use Terminal. Does it
mean anything to you?Pat.M



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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

[Jeff Abrahamson]

Thanks, Adrien.  In the end, as long as I can automate this, I'll be
happy.  (I haven't fully followed on on the python solution, but it sure
looks like it will work fine, so I've chalked it up as future work for
me rather than potential workflow blocking today.  Always good to have a
project over Christmas.)

Ultimately, it's a user experience issue, and I don't have any vision at
all of what gnucash users expect.  The accounting software I've used
previously was geared towards professional accountants, and some of the
features (like journal entry rather than account entry) I found really
convenient once I got used to them.  Faced with a pile of bills, for
example, it was great to be able to enter them all from their respective
a/p to their respective expense accounts without a single mouse click,
just a steady stream of typing bill numbers, descriptions, amounts, and
debit and credit account numbers.

Again, my perspective is keeping the books for a rowing club.  I'm sure
that matters in terms of what I find convenient or not.

Jeff


On 18/12/17 19:13, Adrien Monteleone wrote:
> Jeff,
>
> If I recall correctly from other discussion, the General Ledger is not it’s 
> own entity. It’s a ‘view’ of the separate account ledgers all rolled into 
> one. This is probably why there is no export option for it.
>
> GnuCash takes the opposite approach from paper books.
>
> With paper, you enter everything in a General Journal and then later post the 
> proper amounts to T-accounts.
>
> With GnuCash, you skip the Journal and enter directly to the accounts.
>
> The General Ledger was provided for the benefit of those who were used to the 
> paper method and wanted the option to see all transactions in chronological 
> order regardless of accounts used.
>
> But I don’t see why you can’t combine the files after the fact. That’s an 
> easy concatenation command.
>
> It is curious that you can’t export ‘all’ transactions and have to choose 
> only one hierarchy at a time.
>
> Regards,
> Adrien
>
>> On Dec 17, 2017, at 1:31 PM, Jeff Abrahamson  wrote:
>>
>> I'd like to export the general ledger to a csv file.  When I use File ->
>> Export, however, I'm offered a choice of exporting income, expenses,
>> assets, or liabilities.  But I'd like to have all transactions in the
>> csv file.
>>
>> I think I see how to do this using python (the example script
>> account_analysis.py in the examples is instructive).  But this seems so
>> basic I suspect I'm missing something.
>>
>> Many thanks for any pointers.
>>
>> -- 
>>
>> Jeff Abrahamson
>> +33 6 24 40 01 57
>> +44 7920 594 255
>>
>> http://p27.eu/jeff/
>>
>>
>> ___
>> 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.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/


___
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

[Adrien Monteleone]

Jeff,

If I recall correctly from other discussion, the General Ledger is not it’s own 
entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This 
is probably why there is no export option for it.

GnuCash takes the opposite approach from paper books.

With paper, you enter everything in a General Journal and then later post the 
proper amounts to T-accounts.

With GnuCash, you skip the Journal and enter directly to the accounts.

The General Ledger was provided for the benefit of those who were used to the 
paper method and wanted the option to see all transactions in chronological 
order regardless of accounts used.

But I don’t see why you can’t combine the files after the fact. That’s an easy 
concatenation command.

It is curious that you can’t export ‘all’ transactions and have to choose only 
one hierarchy at a time.

Regards,
Adrien

> On Dec 17, 2017, at 1:31 PM, Jeff Abrahamson  wrote:
> 
> I'd like to export the general ledger to a csv file.  When I use File ->
> Export, however, I'm offered a choice of exporting income, expenses,
> assets, or liabilities.  But I'd like to have all transactions in the
> csv file.
> 
> I think I see how to do this using python (the example script
> account_analysis.py in the examples is instructive).  But this seems so
> basic I suspect I'm missing something.
> 
> Many thanks for any pointers.
> 
> -- 
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> http://p27.eu/jeff/
> 
> 
> ___
> 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: Invoice & Bill Posting Date Issues Across Multiple Periods

[Adrien Monteleone]

> On Dec 17, 2017, at 11:07 PM, Dale Alspach  wrote:
> 
> Adrien,
> 
> It seems to me that what you want is not an accounting solution but a
> software enhancement. I believe that you need to say exactly what you
> want in a bugzilla RFE. For the issue you describe below what seems to
> be required is a special version of scheduled transactions which will
> post a bill. Your purpose seems to be to delay the  increase in assets
> and liabilities until a time period near to the date that the bill will
> be paid.
> 
I outlined it in the very first post of the thread. There are two separate 
issues here really. The pre-paid issue is one that requires special treatment. 
I’d have to think it through more and look at the code to see how it might work.

As a first stab at it, perhaps a checkbox in the posting dialog, or the 
bill/invoice creation dialog that this is for a "pre-payment." The result would 
be for GnuCash to treat this similar to an ‘open but not posted’ bill/invoice, 
thus it won’t enter any accounts yet, but it will still trigger the Bills Due 
Reminder and still show up in vendor/customer reports. OR change how the Bills 
Due Reminder works and have it operate on any ‘active’ open bill, not just 
posted ones. (you can mark a bill ‘inactive’, this might be useful in this 
case) I suspect the first option would be less disruptive, however not as clean.

Note, I don’t want to ‘delay' the increase in assets and liabilities at all. 
There is no increase in assets in this case and there is never a liability that 
enters the picture. This is a shift in assets - from Cash to Pre-Paid Expense.

What is happening right now is that there IS an increase in assets and 
liabilities. (until the bill is paid) This is an error.

This is more like a transfer that involves a line-item bill from a vendor for 
services not yet rendered. (a deferred expense)

> I believe that you wrote something incorrect here:
>> Additionally, as noted in another reply, ‘bills’ for pre-paid expenses
>> should never hit AP at all. They aren’t ever liabilities. They are (as
>> yet unpaid) deferred expenses, not accrued expenses.
> 
> It is not the pre-paid expenses that are being entered into AP it is the
> obligation to pay for them that is in AP and that is a liability. From
> an accounting perspective this is exactly what is required. The not yet
> existing asset pre-paid expense is being offset by a corresponding
> liability so that the net on the balance sheet is 0. Once the bill is
> paid the liability is 0 and the pre-paid expense becomes real.

I understand the pre-paid expenses aren’t being entered into AP, but they are 
balanced by it until paid. They should not. They are NOT a liability. If I 
don’t pay them, I don’t owe them. The insurer has no legal claim against me. 
They have yet to provide me anything of value.

Acquiring a pre-paid asset is the result of an asset shift. AP or other 
Liabilities never enter the equation. That’s probably why every example of this 
transaction I can find never show anything but the actual pre-payment. Anything 
else is simply not contemplated. It’s possible, nothing at all is entered in 
paper books until the payment is made. But then with paper, your managing your 
payment calendars in a system separate from your books anyway. The issue is 
that GnuCash offers payment date managing with the Bills Due Reminder feature 
but it only works on posted bills. This is a bill that technically, you can’t 
post till it’s paid. (It’s not really a bill)

So the solution would be either treat it as a special case for posting, or 
change how the payment reminder works.

> 
> One other note is that this question of when to recognize an obligation
> to pay is a subtle one and really requires an accounting expert familiar
> with the type of business. A cash flow problem could be hidden by
> manipulating recognition dates.

I agree, but again, there is no obligation here at all. This is a pre-payment. 
This is not a bill for services rendered. It is a bill for services TO BE 
rendered. AP liabilities are known as ‘accrued expenses.’ They are recognized 
in the period incurred and paid later. This is the opposite. This is paid now, 
and recognized when incurred. But the Business Features don’t contemplate this 
at all, even though it is very common. (most ALL insurance is pre-paid, rent is 
another example though that is usually more important for businesses to track)

> 
> Dale
> 
> On 12/17/2017 01:46 PM, Adrien Monteleone wrote:
>> Dale,
>> 
>> Thank you, but in my case the first event to happen (for me) is the bill 
>> arriving.
>> 
>> Here is the sequence:
>> 
>> 1) Renewal bill is generated
>> 2) Renewal bill is mailed
>> 3) Renewal bill arrives in the mailbox
>> 4) Renewal bill is entered in GnuCash with date of #1 as ‘opening date'
>> 5) Renewal bill is ‘posted’ in GnuCash with current date as ‘posting date'
>> 6) Renewal bill is paid
>> 7) Renewal policy goes into effect
>> 

Re: errir in SQL syntax

[John Ralls]

> On Dec 18, 2017, at 8:29 AM, AC  wrote:
> 
> You need to reply to all to make this back to the mailing list.
> Forwarding for the list.
> 
> 
> 
> 
> 
> Thanks for hint. This is form the webpage https://wiki.gnucash.org/wiki/SQL
> Maybe somebody can correct this?

That page documents the SQL schema for developers and users who might want to 
query the database from outside of GnuCash. The actual table definitions were 
retrieved from SQLite3 and there may be some dialect differences between it and 
MySQL or Postgresql.

Regards,
John Ralls



___
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: MacOS 10.13.2 won't work with Gnucash

[John Ralls]

Sorry, you're talking through your hat.

GnuCash isn't built as a universal binary, it's 32-bit only. 32-bit programs 
run just fine on all 64-bit OSes supported by Gtk+. We (meaning I) provide two 
such, one for PPC built on an actual PPC Mac Mini and one Intel, built on a 
MacPro running MacOS 10.13.2, but using Xcode 3 and MacOSX-10.5.sdk to provide 
backward compatibility.

Most likely Patricia downloaded the wrong one.

Regards,
John Ralls


> On Dec 18, 2017, at 8:08 AM, Robert Heller  wrote:
> 
> At Mon, 18 Dec 2017 08:15:56 -0500 "R. Victor Klassen"  
> wrote:
> 
>> 
>> Looks like you somehow got the build for an x86 machine (on PowerPC machine)
>> or (more likely) the build for a PowerPC machine on an x86 machine.
> 
> More likely 32 vs 64 bit x86 (ix86 vs x86_64).
> 
>> 
>> It's complaining about the CPU.
> 
> Not exactly -- it is more likely universal [shared] library support or
> universal binary support. Or 32-bit support of any sort.
> 
> It is really unlikely to build for something other than x86 on a Mac these 
> days -- requires some serious hackery to get the PowerPC and/or M68K 
> compilers 
> installed and get things configured to compile that way on a really modern 
> Mac 
> (I guess it can be done, but it is not going to be something done by 
> mistake). 
> Messing up between 32 and 64 bit or not getting the universal binary thing is 
> an easy mistake.  And it is entirely possible that if you create a proper 
> universal binary for both 32 and 64 bit, you land on a 64-bit only Mac 
> without 
> universal shared libraries...
> 
> I don't believe modern / current MacOSX versions are even available for 
> PowerPC machines and Apple has not made PowerPC machines in some time (over a 
> decade or two).
> 
>> 
>>> On Dec 18, 2017, at 7:56 AM, its...@gmail.com wrote:
>>> 
>>> I did what was suggested with Terminal, although it didn't seem to work
>>> initially. After I removed the % sign from the command and tried again, this
>>> is what came up:
>>> 
>>> I'm still not sure I got the command right as I rarely use Terminal. Does it
>>> mean anything to you?Pat.M
>>> 
>>> 
>>> 
>>> --
>>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>> ___
>>> 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.
>> 
>> 
> 
> -- 
> Robert Heller -- 978-544-6933
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services
> 
> ___
> 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.

Fwd: Re: errir in SQL syntax

[AC]

You need to reply to all to make this back to the mailing list.
Forwarding for the list.





Thanks for hint. This is form the webpage https://wiki.gnucash.org/wiki/SQL
Maybe somebody can correct this?

Wolfgang

On Mon, Dec 18, 2017 at 8:30 AM, AC > wrote:

You misspelled AUTO_INCREMENT (note the underscore character).


On 2017-12-17 23:03, Wolfgang Paul Rauchholz wrote:
> My config:
> Linux CENTOS 7, mariadb-5.5.56-2.el7.x86_64
>
> Setting up the database on my home server. Will connect fomr
laptops in the
> network onto mariadb.
>
> When trying to execute this command.
>
> CREATE TABLE slots (
>     id integer PRIMARY KEY AUTOINCREMENT NOT NULL,
>     obj_guid            CHAR(32) NOT NULL,
>     name                text(4096) NOT NULL,
>     slot_type           integer NOT NULL,
>     int64_val           integer,
>     string_val          text(4096),
>     double_val          real,
>     timespec_val        CHAR(14),
>     guid_val            CHAR(32),
>     numeric_val_num     integer,
>     numeric_val_denom   integer
> );
>
> I get this error. I can't find anything in google, so I'd hoped I
get some
> help here. Thank you
>
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check
the manual
> that corresponds to your MariaDB server version for the right
syntax to use
> near 'NOT NULL,
>     obj_guid            CHAR(32) NOT NULL,
>     name                tex' at line 2
>
>
> Thansk for your help
>
>

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




-- 

Wolfgang Rauchholz



___
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: MacOS 10.13.2 won't work with Gnucash

[Robert Heller]

At Mon, 18 Dec 2017 07:19:16 -0800 John Ralls  wrote:

> 
> It is indeed complaining about the CPU. To be absolutely sure that that’s 
> the problem, you can run
>   file /Users/patriciamitchell/Desktop/Gnucash.app/Contents/MacOS/Gnucash-bin
> 
> in Terminal. Note the "-bin" on the end. For an Intel machine it should say 
> "Mach-O executable i386~. 

Wondering: is this an "universal" binary (i686 & x86_64) or a i686 only?  Is 
the OP's machine 64-bit only?

> 
> If it says "Mach-O executable ppc_7400” you downloaded the wrong one.
> 
> Regards,
> John Ralls
> 
> > On Dec 18, 2017, at 5:15 AM, R. Victor Klassen  wrote:
> > 
> > Looks like you somehow got the build for an x86 machine (on PowerPC 
> > machine) or (more likely) the build for a PowerPC machine on an x86 machine.
> > 
> > It’s complaining about the CPU.
> > 
> >> On Dec 18, 2017, at 7:56 AM, its...@gmail.com wrote:
> >> 
> >> I did what was suggested with Terminal, although it didn't seem to work
> >> initially. After I removed the % sign from the command and tried again, 
> >> this
> >> is what came up:
> >> 
> >> I'm still not sure I got the command right as I rarely use Terminal. Does 
> >> it
> >> mean anything to you?Pat.M
> >> 
> >> 
> >> 
> >> --
> >> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> >> ___
> >> 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.
> 
> ___
> 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.
> 
>   
> 

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

 
___
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: MacOS 10.13.2 won't work with Gnucash

[Robert Heller]

At Mon, 18 Dec 2017 05:56:46 -0700 (MST) "its...@gmail.com"  
wrote:

> 
> I did what was suggested with Terminal, although it didn't seem to work
> initially. After I removed the % sign from the command and tried again, this

The '%' is the bash (typical) command prompt.

> is what came up:
> 
> I'm still not sure I got the command right as I rarely use Terminal. Does it
> mean anything to you?Pat.M

OK, this suggests that there is a processor arch. mismatch.  Is the GnuCash 
executable a "universal" binary for both i686 and x86_64?  Does MacOS 10.13.2 
still support universal binaries?  Does it drop support for i686?  I presume 
that MacOS 10.13.2 supports at least x86_64, and I assume GnuCash has NOT been 
compiled for PowerPC or M68K or something like that.

One other thing to try in Terminal:

file Desktop/gnucash/Content/MacOS/gnucash-bin

This will tell us what "flavor" of executable gnucash-bin is (ix86 [32-bit], 
x86_65 [64-bit], or a universal binary for both).

And

ldd Desktop/gnucash/Content/MacOS/gnucash-bin

(I am not sure if ldd exists under *BSD [Darwin/MacOSX] -- ldd will tell us
what shared libraries gnucash-bin wants to link with.)

It is also possible that it IS a universal binary for both 32 and 64 bit, but
that your Mac does not have the universal shared binaries it needs, and only
has 64-bit only binaries. It is possible Apple is dropping 32-bit support,
since 32-bit ix86 processors (for laptops and desktops anyway) are not being
made anymore and 64-bit processors are now the norm for laptops and desktops.  
(There might be some 32-bit processors being made for low-end embedded device 
use -- eg "smart" appliances, etc.  Even ARM chips are mostly 64-bit these 
days.)

> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
> 
>   
>

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

  
___
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: MacOS 10.13.2 won't work with Gnucash

[Robert Heller]

At Mon, 18 Dec 2017 08:15:56 -0500 "R. Victor Klassen"  
wrote:

> 
> Looks like you somehow got the build for an x86 machine (on PowerPC machine)
> or (more likely) the build for a PowerPC machine on an x86 machine.

More likely 32 vs 64 bit x86 (ix86 vs x86_64).

> 
> It's complaining about the CPU.

Not exactly -- it is more likely universal [shared] library support or
universal binary support. Or 32-bit support of any sort.

It is really unlikely to build for something other than x86 on a Mac these 
days -- requires some serious hackery to get the PowerPC and/or M68K compilers 
installed and get things configured to compile that way on a really modern Mac 
(I guess it can be done, but it is not going to be something done by mistake). 
Messing up between 32 and 64 bit or not getting the universal binary thing is 
an easy mistake.  And it is entirely possible that if you create a proper 
universal binary for both 32 and 64 bit, you land on a 64-bit only Mac without 
universal shared libraries...

I don't believe modern / current MacOSX versions are even available for 
PowerPC machines and Apple has not made PowerPC machines in some time (over a 
decade or two).

> 
> > On Dec 18, 2017, at 7:56 AM, its...@gmail.com wrote:
> > 
> > I did what was suggested with Terminal, although it didn't seem to work
> > initially. After I removed the % sign from the command and tried again, this
> > is what came up:
> > 
> > I'm still not sure I got the command right as I rarely use Terminal. Does it
> > mean anything to you?Pat.M
> > 
> > 
> > 
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > 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.
> 
>   
>

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services


___
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: MacOS 10.13.2 won't work with Gnucash

[John Ralls]

It is indeed complaining about the CPU. To be absolutely sure that that’s the 
problem, you can run
  file /Users/patriciamitchell/Desktop/Gnucash.app/Contents/MacOS/Gnucash-bin

in Terminal. Note the “-bin” on the end. For an Intel machine it should say 
"Mach-O executable i386”.

If it says "Mach-O executable ppc_7400” you downloaded the wrong one.

Regards,
John Ralls

> On Dec 18, 2017, at 5:15 AM, R. Victor Klassen  wrote:
> 
> Looks like you somehow got the build for an x86 machine (on PowerPC machine) 
> or (more likely) the build for a PowerPC machine on an x86 machine.
> 
> It’s complaining about the CPU.
> 
>> On Dec 18, 2017, at 7:56 AM, its...@gmail.com wrote:
>> 
>> I did what was suggested with Terminal, although it didn't seem to work
>> initially. After I removed the % sign from the command and tried again, this
>> is what came up:
>> 
>> I'm still not sure I got the command right as I rarely use Terminal. Does it
>> mean anything to you?Pat.M
>> 
>> 
>> 
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> ___
>> 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.

___
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 + mysql

[John Ralls]

> On Dec 18, 2017, at 6:29 AM, Wolfgang Paul Rauchholz  
> wrote:
> 
> Didn't think about that possibility.
> Let me try this out too.
> 
> Do you know whether there are plans to extend usage of mysql in gnucash?
> 


Not MySQL per se, but we do intend to make GnuCash a proper database 
application eventually. It’s a major change in the design and there’s a ton of 
preparation work that must happen first so it will take several years to 
accomplish.

In the meantime, there’s no cookbook, but if you already know how to manage a 
MySQL installation it shouldn’t be too difficult. Create a user with CREATE 
DATABASE privilege in MySQL.
Open GnuCash, create a new book, and when the save dialog comes up select 
“MySQL” from the list-box at the top. You’ll get a new dialog prompting for the 
server’s address, a name for the database (which defaults to “gnucash” but you 
probably want something more descriptive, and a userid and password. Fill those 
in, click save, and GnuCash takes care of the rest.

Do *not* try to pre-create a database. GnuCash needs to do that itself.

Regards,
John Ralls


___
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 + mysql

[Wolfgang Paul Rauchholz]

Didn't think about that possibility.
Let me try this out too.

Do you know whether there are plans to extend usage of mysql in gnucash?

Thanks. Wolfgang

On Mon, Dec 18, 2017 at 2:46 PM, Colin Law  wrote:

> You don't need to use mysql to do that, provided you have access to a
> share on the server where the xml file is. That is what I do.  Then I
> can access it from any machine on my local network, or from anywhere
> in the world using my home VPN.
>
> However if that is what you want to do, just setup the mysql server
> and use File > Save As with type mysql.
>
> Colin
>
>
> On 18 December 2017 at 13:41, Wolfgang Paul Rauchholz
>  wrote:
> > Several reasons for mysql:
> > Several reasons:
> > - I have  backup procedure on my home server
> > - I can access (hopefully) form several laptops to the database (not
> > concurrent)
> >
> >
> > On Mon, Dec 18, 2017 at 1:15 PM, Colin Law  wrote:
> >>
> >> On this list when replying you have to use Reply All (or similar)
> >> otherwise your reply just goes to the previous poster (as yours did to
> >> me). I am copying in the list so others will see it.
> >>
> >> Once you have installed mysql then you should be able to use Save As
> >> and select mysql as the type.
> >>
> >> I have to ask why you want to use mysql rather than the default xml.
> >> Currently there is not much point for the average user.
> >>
> >> Colin
> >>
> >> On 18 December 2017 at 11:55, Wolfgang Paul Rauchholz
> >>  wrote:
> >> > Ho Colin.
> >> > I plan to install mysql on my home-server (CENTOS 7) and access from
> >> > laptop
> >> > (CENTOS and WINDOWS) tot he database.
> >> >
> >> >
> >> > On Mon, Dec 18, 2017 at 8:42 AM, Colin Law  wrote:
> >> >>
> >> >>
> >> >>
> >> >> On 18 Dec 2017 7:04 a.m., "wp.rauchholz" 
> >> >> wrote:
> >> >>
> >> >> Is am trying to setup gnucash and access mysql on my homeserver.
> >> >> Is there a \cookbook' how to do this?
> >> >> I googled and there does not seem to be a lot
> >> >>
> >> >>
> >> >> Assuming you have setup your mysql server then check whether the
> File,
> >> >> Save As dialog has the option to save as mysql. If not then you need
> to
> >> >> tell
> >> >> us which operating system you are using and how you installed
> gnucash.
> >> >>
> >> >> Colin
> >> >>
> >> >>
> >> >>
> >> >> Wolfgang
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> Sent from:
> >> >> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> >> >> ___
> >> >> 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.
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >> > --
> >> >
> >> > Wolfgang Rauchholz
> >> >
> >> >
> >> >
> >
> >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
> >
> >
>



-- 

Wolfgang Rauchholz
___
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 + mysql

[Colin Law]

You don't need to use mysql to do that, provided you have access to a
share on the server where the xml file is. That is what I do.  Then I
can access it from any machine on my local network, or from anywhere
in the world using my home VPN.

However if that is what you want to do, just setup the mysql server
and use File > Save As with type mysql.

Colin


On 18 December 2017 at 13:41, Wolfgang Paul Rauchholz
 wrote:
> Several reasons for mysql:
> Several reasons:
> - I have  backup procedure on my home server
> - I can access (hopefully) form several laptops to the database (not
> concurrent)
>
>
> On Mon, Dec 18, 2017 at 1:15 PM, Colin Law  wrote:
>>
>> On this list when replying you have to use Reply All (or similar)
>> otherwise your reply just goes to the previous poster (as yours did to
>> me). I am copying in the list so others will see it.
>>
>> Once you have installed mysql then you should be able to use Save As
>> and select mysql as the type.
>>
>> I have to ask why you want to use mysql rather than the default xml.
>> Currently there is not much point for the average user.
>>
>> Colin
>>
>> On 18 December 2017 at 11:55, Wolfgang Paul Rauchholz
>>  wrote:
>> > Ho Colin.
>> > I plan to install mysql on my home-server (CENTOS 7) and access from
>> > laptop
>> > (CENTOS and WINDOWS) tot he database.
>> >
>> >
>> > On Mon, Dec 18, 2017 at 8:42 AM, Colin Law  wrote:
>> >>
>> >>
>> >>
>> >> On 18 Dec 2017 7:04 a.m., "wp.rauchholz" 
>> >> wrote:
>> >>
>> >> Is am trying to setup gnucash and access mysql on my homeserver.
>> >> Is there a \cookbook' how to do this?
>> >> I googled and there does not seem to be a lot
>> >>
>> >>
>> >> Assuming you have setup your mysql server then check whether the File,
>> >> Save As dialog has the option to save as mysql. If not then you need to
>> >> tell
>> >> us which operating system you are using and how you installed gnucash.
>> >>
>> >> Colin
>> >>
>> >>
>> >>
>> >> Wolfgang
>> >>
>> >>
>> >>
>> >> --
>> >> Sent from:
>> >> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> >> ___
>> >> 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.
>> >>
>> >>
>> >
>> >
>> >
>> > --
>> >
>> > Wolfgang Rauchholz
>> >
>> >
>> >
>
>
>
>
> --
>
> Wolfgang Rauchholz
>
>
>
___
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 + mysql

[Wolfgang Paul Rauchholz]

Several reasons for mysql:
Several reasons:
- I have  backup procedure on my home server
- I can access (hopefully) form several laptops to the database (not
concurrent)


On Mon, Dec 18, 2017 at 1:15 PM, Colin Law  wrote:

> On this list when replying you have to use Reply All (or similar)
> otherwise your reply just goes to the previous poster (as yours did to
> me). I am copying in the list so others will see it.
>
> Once you have installed mysql then you should be able to use Save As
> and select mysql as the type.
>
> I have to ask why you want to use mysql rather than the default xml.
> Currently there is not much point for the average user.
>
> Colin
>
> On 18 December 2017 at 11:55, Wolfgang Paul Rauchholz
>  wrote:
> > Ho Colin.
> > I plan to install mysql on my home-server (CENTOS 7) and access from
> laptop
> > (CENTOS and WINDOWS) tot he database.
> >
> >
> > On Mon, Dec 18, 2017 at 8:42 AM, Colin Law  wrote:
> >>
> >>
> >>
> >> On 18 Dec 2017 7:04 a.m., "wp.rauchholz" 
> wrote:
> >>
> >> Is am trying to setup gnucash and access mysql on my homeserver.
> >> Is there a \cookbook' how to do this?
> >> I googled and there does not seem to be a lot
> >>
> >>
> >> Assuming you have setup your mysql server then check whether the File,
> >> Save As dialog has the option to save as mysql. If not then you need to
> tell
> >> us which operating system you are using and how you installed gnucash.
> >>
> >> Colin
> >>
> >>
> >>
> >> Wolfgang
> >>
> >>
> >>
> >> --
> >> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> >> ___
> >> 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.
> >>
> >>
> >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
> >
> >
>



-- 

Wolfgang Rauchholz
___
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

[Sébastien de Menten]

To export a gnucash book to a ledger-cli output, you may be interested by
the piecash python module and the related script
https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py


On Mon, Dec 18, 2017 at 11:32 AM, Jeff Abrahamson  wrote:

> On 18/12/17 03:26, Wm via gnucash-user wrote:
> > On 17/12/2017 19:31, Jeff Abrahamson wrote:
> >> I'd like to export the general ledger to a csv file.  When I use File ->
> >> Export, however, I'm offered a choice of exporting income, expenses,
> >> assets, or liabilities.  But I'd like to have all transactions in the
> >> csv file.
> >>
> >> I think I see how to do this using python (the example script
> >> account_analysis.py in the examples is instructive).  But this seems so
> >> basic I suspect I'm missing something.
> >>
> >> Many thanks for any pointers.
> > May be easier to do a transaction report or similar and copy and paste
> > that into a spreadsheet.
> >
> > Alternatively there are a number of scripts that can take gnc files of
> > some flavour and produce ledger-cli / beancount compatible files which
> > are generally mores useful than csv files for accounting data anyway.
>
> Ah, ledger-cli and beancount are neat, thanks for the pointer.
>
> This sort of export is something I want to be able to do frequently.
> I'll have a look around for scripts to automate it.
>
> --
>
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
>
> http://p27.eu/jeff/
>
> ___
> 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: MacOS 10.13.2 won't work with Gnucash

[R. Victor Klassen]

Looks like you somehow got the build for an x86 machine (on PowerPC machine) or 
(more likely) the build for a PowerPC machine on an x86 machine.

It’s complaining about the CPU.

> On Dec 18, 2017, at 7:56 AM, its...@gmail.com wrote:
> 
> I did what was suggested with Terminal, although it didn't seem to work
> initially. After I removed the % sign from the command and tried again, this
> is what came up:
> 
> I'm still not sure I got the command right as I rarely use Terminal. Does it
> mean anything to you?Pat.M
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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: MacOS 10.13.2 won't work with Gnucash

[its...@gmail.com]

I did what was suggested with Terminal, although it didn't seem to work
initially. After I removed the % sign from the command and tried again, this
is what came up:

I'm still not sure I got the command right as I rarely use Terminal. Does it
mean anything to you?Pat.M



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 + mysql

[Colin Law]

On this list when replying you have to use Reply All (or similar)
otherwise your reply just goes to the previous poster (as yours did to
me). I am copying in the list so others will see it.

Once you have installed mysql then you should be able to use Save As
and select mysql as the type.

I have to ask why you want to use mysql rather than the default xml.
Currently there is not much point for the average user.

Colin

On 18 December 2017 at 11:55, Wolfgang Paul Rauchholz
 wrote:
> Ho Colin.
> I plan to install mysql on my home-server (CENTOS 7) and access from laptop
> (CENTOS and WINDOWS) tot he database.
>
>
> On Mon, Dec 18, 2017 at 8:42 AM, Colin Law  wrote:
>>
>>
>>
>> On 18 Dec 2017 7:04 a.m., "wp.rauchholz"  wrote:
>>
>> Is am trying to setup gnucash and access mysql on my homeserver.
>> Is there a \cookbook' how to do this?
>> I googled and there does not seem to be a lot
>>
>>
>> Assuming you have setup your mysql server then check whether the File,
>> Save As dialog has the option to save as mysql. If not then you need to tell
>> us which operating system you are using and how you installed gnucash.
>>
>> Colin
>>
>>
>>
>> Wolfgang
>>
>>
>>
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> ___
>> 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.
>>
>>
>
>
>
> --
>
> Wolfgang Rauchholz
>
>
>
___
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: MacOS 10.13.2 won't work with Gnucash

[Robert Heller]

At Mon, 18 Dec 2017 00:52:49 -0700 (MST) "its...@gmail.com"  
wrote:

> 
> Hi John,
> 
> I have done a complete uninstall of the program. Restarted in Safe Mode,
> then downloaded a fresh copy of an earlier version and installed. Nothing
> happened.
> 
> I reinstalled version 2.16.19 and attempted to launch the program. It went
> through the 'verification' process, then asked if I wanted to open it
> (downloaded from the internet), I said yes, then there was nothing more.
> 
> Clicking on the app in the dock gives a single bounce, then nothing more.
> Not sure what else to do. The Contents of the package seems to be the most
> recent version.
>

What *I* would try is this: open up a Terminal and try to run the program from 
the command line.  That would be (assumes gnucash is on the desktop):

% Desktop/gnucash.app/Contents/MacOS/gnucash

Or you can try (again assumes gnucash is on the desktop):

% open Desktop/gnucash.app

You might get an "interesting" or helpful error message, which might explain 
the problem.



 
> ===
> Pat. M
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
> 
> 

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
  
___
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

[Jeff Abrahamson]

On 18/12/17 03:26, Wm via gnucash-user wrote:
> On 17/12/2017 19:31, Jeff Abrahamson wrote:
>> I'd like to export the general ledger to a csv file.  When I use File ->
>> Export, however, I'm offered a choice of exporting income, expenses,
>> assets, or liabilities.  But I'd like to have all transactions in the
>> csv file.
>>
>> I think I see how to do this using python (the example script
>> account_analysis.py in the examples is instructive).  But this seems so
>> basic I suspect I'm missing something.
>>
>> Many thanks for any pointers.
> May be easier to do a transaction report or similar and copy and paste
> that into a spreadsheet.
>
> Alternatively there are a number of scripts that can take gnc files of
> some flavour and produce ledger-cli / beancount compatible files which
> are generally mores useful than csv files for accounting data anyway.

Ah, ledger-cli and beancount are neat, thanks for the pointer.

This sort of export is something I want to be able to do frequently. 
I'll have a look around for scripts to automate it.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/

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