Re: errir in SQL syntax

2017-12-17 Thread Colin Law 
Does that happen when you try to save from within gnucash?

Colin

On 18 Dec 2017 7:19 a.m., "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_guidCHAR(32) NOT NULL,
nametext(4096) NOT NULL,
slot_type   integer NOT NULL,
int64_val   integer,
string_val  text(4096),
double_val  real,
timespec_valCHAR(14),
guid_valCHAR(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_guidCHAR(32) NOT NULL,
nametex' at line 2


Thansk for your help


--

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

2017-12-17 Thread Colin Law 
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.
___
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: errir in SQL syntax

2017-12-17 Thread AC 
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_guidCHAR(32) NOT NULL,
> nametext(4096) NOT NULL,
> slot_type   integer NOT NULL,
> int64_val   integer,
> string_val  text(4096),
> double_val  real,
> timespec_valCHAR(14),
> guid_valCHAR(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_guidCHAR(32) NOT NULL,
> nametex' 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.

Re: MacOS 10.13.2 won't work with Gnucash

2017-12-17 Thread its...@gmail.com 
No, 2.6.18 didn't work either. I looked for the update when my existing
version of Gnucash (2.6.17) just crashed. I admit I haven't used Gnucash for
some time.

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

2017-12-17 Thread wp.rauchholz 
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

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.

Re: export general ledger

2017-12-17 Thread Wm via gnucash-user 

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.


--
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: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-17 Thread Dale Alspach 
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 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.

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.

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
> 
> There is usually a one-week gap between 1 & 3. 3,4 & 5 usually happen on the 
> same day. There is usually a 4-5 week gap between 3 & 7. The period boundary 
> usually happens between 5 & 6, but sometimes between 6 & 7.
> 
> The pre-paid expense should not appear until 6 is complete, but is currently 
> happening at 5. The date of 6 is unknown until it happens, so I can’t ‘fudge’ 
> and choose it as the posting date beforehand.
> 
> 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. So I’ve opted to bypass the Business 
> Features entirely for this special case and forego the bill reminder as well 
> as any ability to see this activity in a vendor report.
> 
> 
> Regards,
> Adrien
> 
>> On Dec 16, 2017, at 4:36 PM, Dale Alspach  wrote:
>>
>> Adrien,
>>
>> I do not use the business features but it seems from what you have
>> written that something like the following may do what you want.
>>
>> Create a new liability account named Unbilled Payables (or whatever you
>> like).
>> Replace
>>> Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
>>> Cr. Liabilities:Accounts_Payable
>> by
>> Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
>> Cr. Liabilities:Unbilled Payables
>>
>> There is no change in the Balance Sheet net. The entry in Unbilled
>> Payables should be tagged so that an audit trail could be constructed.
>>
>> When the bill arrives, post the bill so that you effect a transfer
>> between the liabilities
>> Dr. Liabilities:Unbilled Payables
>> Cr. Liabilities:Accounts_Payable
>>
>> Again there is no change in the Balance Sheet net. At this point the
>> normal flow of the business features should generate your reminder and,
>> upon payment, zero the liability for the pre-paid insurance. The asset
>> becomes real.
>>
>> Dale
>>
>> On 12/15/2017 02:57 PM, Adrien Monteleone wrote:
>>> Yes, I can explain. And the example of insurance is just that. A pre-paid 
>>> expense IS an asset. (in accrual accounting)
>>>
>>> I pay in advance for auto insurance. The policy renews every 6 months. (for 
>>> me, this is in December and June)
>>>
>>> Paying in advance is a pre-paid expense. This is an asset. I have not yet 
>>> received ‘service’ from the insurance company.
>>>
>>> Here’s what the entry should be twice a year:
>>>
>>> Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
>>> Cr. Assets:Current_Assets:Cash
>>>
>>> As I receive ‘service’ each month, or ‘use’ the asset, I credit the 
>>> pre-paid expense account and debit the actual expense account for one-sixth 
>>> of the asset (as this is a 6-month policy):
>>>
>>> Dr. Expenses:Auto:Auto_Insurance
>>> Cr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
>>>
>>> The original question was trying to resolve the issue of posting the bill 
>>> from the insurer for each renewal and how that affects recognition of the 
>>> acquisition of the pre-paid expense asset.
>>>
>>> My current entry from the bill is:
>>>
>>> Dr.

Re: GnuCash 2.6.19 released

2017-12-17 Thread John Ralls 


> On Dec 17, 2017, at 7:59 PM, Ken Pyzik  wrote:
> 
> John -- Have installed the new 2.6.19 version on Windows 10 (64-bit) - as 
> production.  No issues to report.  Thanks! 

Thanks. It’s always nice to get good news!

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

2017-12-17 Thread John Ralls 


> On Dec 17, 2017, at 7:32 PM, its...@gmail.com wrote:
> 
> Hi,
> 
> I have just installed Gnucash 2.16.19 on my Mac that is running High Sierra.
> In spite of all my efforts, I cannot get Gnucash to load or even open
> properly. I understand from previous posts about High Sierra issues that
> when the latest stable version of Gnucash is installed, the libraries are
> updated. I'm not quite sure how that happens when it is a case of copying
> the application from the DMG file to the Mac Applications folder.
> 
> Any others with this problem? I need to find a fix asap since I have a set
> of financial reports to prepare for a meeting in two days! Thanks.


Starts right up for me on both of my Macs, both running 10.13. One of them 
probably doesn’t count because it’s the machine that GnuCash is built on, but 
the other doesn’t have a Gnucash-2.6 build tree on it.

GnuCash.app, like every other Mac app, is really a directory tree with most 
everything the app needs inside. You can see what’s inside by control-clicking 
on it in Finder and selection “Show Contents” from the context menu.

So, what’s going wrong? What have you tried to resolve it?

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

2017-12-17 Thread Ken Pyzik 
John -- Have installed the new 2.6.19 version on Windows 10 (64-bit) - as 
production.  No issues to report.  Thanks! 

-Original Message-
From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org] On 
Behalf Of John Ralls
Sent: Sunday, December 17, 2017 2:54 PM
To: Gnucash Users 
Subject: GnuCash 2.6.19 released

Announcement: GnuCash 2.6.19 Release 2017-12-16 GnuCash 2.6.19 released

The GnuCash development team announces GnuCash 2.6.19, the nineteenth 
maintenance release in the 2.6-stable series.
Changes

Between 2.6.18 and 2.6.19, the following bugfixes were accomplished:

Bug 787497 - Disabling OFX, AqBanking or python-bindings support cripples 
the dist build target. (Partial: The requisite files for AQB and OFX are 
provided. There remain ways to break the distribution.)
Bug 789928 - FTBFS with libdbi 0.9.0-5 on Debian
Failed to create file 
"/usr/share/glib-2.0/schemas/gschemas.compiled.XY789Y".

Some other fixes not associated with reported bugs:

A better way to handle MySQL's -00-00 invalid date indicator.
Fix python build and test errors on Mac.
Add translator hint comments to C and glade files.
Improve type of bank accounts in SKR03
Stop testing GObject's handling of invalid parameters

Translation Updates: Dutch, German, Serbian Important update notification

If you are updating from gnucash 2.6.0-2.6.4 on linux, you are advised to 
remove the guile user cache or several parts of gnucash may fail to work 
properly. This user cache can be found in .cache/guile/ccache/2.0-LE-8-2.0/ in 
your home directory. It's safe to remove the whole contents of this directory.

Note .cache is a hidden folder in your home directory. You may have to change 
your file manager's settings in order to view hidden files and folders.
Documentation

Concurrent with the release of Gnucash 2.6.19 we're pleased to also release a 
new version 2.6.19 of the companion Help and Tutorial and Concepts Guide.

Bug 782423 - Help 10.2. Setting Preferences is outdated #105
Changing text in Help to reflect changes in Preferences dialogs.
Translation of the german guides metafile

Getting GnuCash for Windows and MacOS X

GnuCash is provided for both Microsoft Windows XP® and later and MacOS X 10.5 
(Leopard)® and later in pre-built, all-in-one packages. An installer is 
provided for Microsoft Windows® while the MacOS X® package is a disk image 
containing a drag-and-drop application bundle.

The SHA256 Hashes for the downloadable files are:

50b89367246ec2d51e9765bd6bd8c669e35ceb4ac5ab92636f76758a9f3f7fd1  
gnucash-2.6.19.tar.bz2
758adf10a75abfabc0b0d9a4858c0b79438c3e2157f4240e1a84a6b93dc3  
gnucash-2.6.19.tar.gz
1fa83d9578e8c62bd7dcef3b953e0e7610bf03bed9c1a037a72a6eee1ac79e37  
gnucash-2.6.19-3.setup.exe
d40de55c75fdb754c717ae37e25de5e411fce4ce1f7684f071fc492f939408d2  
Gnucash-Intel-2.6.19-1.dmg
0b9d7e80d4887b70f027d6bdd552b6ffa4a6f299df3cfb1860eae5bad207ae2d  
Gnucash-PPC-2.6.19-1.dmg
268415157d80ea70f339e74d1bd05e4550d36f77b22aa98aadeadec04a4ba9c7  
gnucash-docs-2.6.19.tar.gz

SourceForge:
   Win32: 
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.19-3.setup.exe
   Mac Intel: 
http://downloads.sourceforge.net/sourceforge/gnucash/Gnucash-Intel-2.6.19-1.dmg
   Mac PPC:   
http://downloads.sourceforge.net/sourceforge/gnucash/Gnucash-PPC-2.6.19-1.dmg

Github
   Win32  
https://github.com/Gnucash/gnucash/releases/download/2.6.19/gnucash-2.6.19-3.setup.exe
   Mac Intel: 
https://github.com/Gnucash/gnucash/releases/download/2.6.19/Gnucash-Intel-2.6.19-1.dmg
   Mac PPC:   
https://github.com/Gnucash/gnucash/releases/download/2.6.19/Gnucash-PPC-2.6.19-1.dmg

Getting GnuCash as source code

If you want to compile GnuCash 2.6.19 for yourself, the source code can be 
downloaded from:
   Sourceforge: 
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.19-1.tar.bz2
   Github: 
https://github.com/Gnucash/gnucash/releases/download/2.6.19/gnucash-2.6.19-1.tar.bz2
   WARNING Do not try to use the github-generated files labelled 
"Source Code". They have not been
   processed with swig and will not build.
You can also checkout the sources directly from the git repository as described 
at https://wiki.gnucash.org/wiki/Git.

To compile GnuCash from the source code by yourself, you will need at least 
Gnome 2, Guile, and slib. In addition you will need swig if compiling from git. 
Please consult the README file in the sources for the exact list of 
dependencies and versions.

Getting the documentation

The documentation is available at Documentation page of the GnuCash website, 
https://www.gnucash.org. The 2.6.19 documentation can be found under "GnuCash 
v2.6 (current stable release)" in multiple languages both for reading online 
and for download in pdf, epub, and mobi formats.

If you want to compile the GnuCash Documentation 2.6.19 for yourself, the

Re: Has the Treasury Direct interface changed?

2017-12-17 Thread farleykj 
I'm using the bond quote grabbing code I wrote in 2012 which has been serving
me faithfully since 2016-04-04. I am using https in the url, here's the full
contents I get from the post request:

Can't connect to www.treasurydirect.gov:443 (Connection refused)

LWP::Protocol::https::Socket: connect: Connection refused at
/Library/Perl/5.18/LWP/Protocol/http.pm line 49.

I don't know if the requirements of the site have changed and I'm sending it
a poorly formatted "form" in the post. I am still able to manually pop onto
the site, and enter the necessary data to get prices in their tabulated
format. I even took a look at the resultant page via the "Inspect Element"
capabilities of my browser. The data field names are the same as they always
were, I just can't see any reason for it failing.

P.S. I don't get any useful data from the "official" Perl module,
USFedBonds.pm, either.



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

MacOS 10.13.2 won't work with Gnucash

2017-12-17 Thread its...@gmail.com 
Hi,

I have just installed Gnucash 2.16.19 on my Mac that is running High Sierra.
In spite of all my efforts, I cannot get Gnucash to load or even open
properly. I understand from previous posts about High Sierra issues that
when the latest stable version of Gnucash is installed, the libraries are
updated. I'm not quite sure how that happens when it is a case of copying
the application from the DMG file to the Mac Applications folder.

Any others with this problem? I need to find a fix asap since I have a set
of financial reports to prepare for a meeting in two days! Thanks.

regards,
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: Has the Treasury Direct interface changed?

2017-12-17 Thread John Ralls 


> On Dec 17, 2017, at 3:17 PM, farleykj  wrote:
> 
> Well, it appears that the only data being returned by quote requests is:
> 
> "Can't connect to www.treasurydirect.gov:80 (Connection refused)"
> 
> Don't have any idea why - my Perl experience is rather limited. Definitely
> throws a wrench into the works for me, though.

It's probably because they only respond on https nowadays. If you can figure 
out where Finance Quote is installed on your system you can edit the url in 
USFedBonds.pm.

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: Has the Treasury Direct interface changed?

2017-12-17 Thread farleykj 
Well, it appears that the only data being returned by quote requests is:

"Can't connect to www.treasurydirect.gov:80 (Connection refused)"

Don't have any idea why - my Perl experience is rather limited. Definitely
throws a wrench into the works for me, though.



-
Ken Farley
--
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 2.6.19 released

2017-12-17 Thread John Ralls 
Announcement: GnuCash 2.6.19 Release 2017-12-16
GnuCash 2.6.19 released

The GnuCash development team announces GnuCash 2.6.19, the nineteenth 
maintenance release in the 2.6-stable series.
Changes

Between 2.6.18 and 2.6.19, the following bugfixes were accomplished:

Bug 787497 - Disabling OFX, AqBanking or python-bindings support cripples 
the dist build target. (Partial: The requisite files for AQB and OFX are 
provided. There remain ways to break the distribution.)
Bug 789928 - FTBFS with libdbi 0.9.0-5 on Debian
Failed to create file 
"/usr/share/glib-2.0/schemas/gschemas.compiled.XY789Y".

Some other fixes not associated with reported bugs:

A better way to handle MySQL's -00-00 invalid date indicator.
Fix python build and test errors on Mac.
Add translator hint comments to C and glade files.
Improve type of bank accounts in SKR03
Stop testing GObject's handling of invalid parameters

Translation Updates: Dutch, German, Serbian
Important update notification

If you are updating from gnucash 2.6.0-2.6.4 on linux, you are advised to 
remove the guile user cache or several parts of gnucash may fail to work 
properly. This user cache can be found in .cache/guile/ccache/2.0-LE-8-2.0/ in 
your home directory. It's safe to remove the whole contents of this directory.

Note .cache is a hidden folder in your home directory. You may have to change 
your file manager's settings in order to view hidden files and folders.
Documentation

Concurrent with the release of Gnucash 2.6.19 we're pleased to also release a 
new version 2.6.19 of the companion Help and Tutorial and Concepts Guide.

Bug 782423 - Help 10.2. Setting Preferences is outdated #105
Changing text in Help to reflect changes in Preferences dialogs.
Translation of the german guides metafile

Getting GnuCash for Windows and MacOS X

GnuCash is provided for both Microsoft Windows XP® and later and MacOS X 10.5 
(Leopard)® and later in pre-built, all-in-one packages. An installer is 
provided for Microsoft Windows® while the MacOS X® package is a disk image 
containing a drag-and-drop application bundle.

The SHA256 Hashes for the downloadable files are:

50b89367246ec2d51e9765bd6bd8c669e35ceb4ac5ab92636f76758a9f3f7fd1  
gnucash-2.6.19.tar.bz2
758adf10a75abfabc0b0d9a4858c0b79438c3e2157f4240e1a84a6b93dc3  
gnucash-2.6.19.tar.gz
1fa83d9578e8c62bd7dcef3b953e0e7610bf03bed9c1a037a72a6eee1ac79e37  
gnucash-2.6.19-3.setup.exe
d40de55c75fdb754c717ae37e25de5e411fce4ce1f7684f071fc492f939408d2  
Gnucash-Intel-2.6.19-1.dmg
0b9d7e80d4887b70f027d6bdd552b6ffa4a6f299df3cfb1860eae5bad207ae2d  
Gnucash-PPC-2.6.19-1.dmg
268415157d80ea70f339e74d1bd05e4550d36f77b22aa98aadeadec04a4ba9c7  
gnucash-docs-2.6.19.tar.gz

SourceForge:
   Win32: 
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.19-3.setup.exe
   Mac Intel: 
http://downloads.sourceforge.net/sourceforge/gnucash/Gnucash-Intel-2.6.19-1.dmg
   Mac PPC:   
http://downloads.sourceforge.net/sourceforge/gnucash/Gnucash-PPC-2.6.19-1.dmg

Github
   Win32  
https://github.com/Gnucash/gnucash/releases/download/2.6.19/gnucash-2.6.19-3.setup.exe
   Mac Intel: 
https://github.com/Gnucash/gnucash/releases/download/2.6.19/Gnucash-Intel-2.6.19-1.dmg
   Mac PPC:   
https://github.com/Gnucash/gnucash/releases/download/2.6.19/Gnucash-PPC-2.6.19-1.dmg

Getting GnuCash as source code

If you want to compile GnuCash 2.6.19 for yourself, the source code can be 
downloaded from:
   Sourceforge: 
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.19-1.tar.bz2
   Github: 
https://github.com/Gnucash/gnucash/releases/download/2.6.19/gnucash-2.6.19-1.tar.bz2
   WARNING Do not try to use the github-generated files labelled 
"Source Code". They have not been
   processed with swig and will not build.
You can also checkout the sources directly from the git repository as described 
at https://wiki.gnucash.org/wiki/Git.

To compile GnuCash from the source code by yourself, you will need at least 
Gnome 2, Guile, and slib. In addition you will need swig if compiling from git. 
Please consult the README file in the sources for the exact list of 
dependencies and versions.

Getting the documentation

The documentation is available at Documentation page of the GnuCash website, 
https://www.gnucash.org. The 2.6.19 documentation can be found under "GnuCash 
v2.6 (current stable release)" in multiple languages both for reading online 
and for download in pdf, epub, and mobi formats.

If you want to compile the GnuCash Documentation 2.6.19 for yourself, the 
source code can be downloaded from:
   Sourceforge: 
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-docs-2.6.19.tar.gz
   GitHub:  
https://github.com/Gnucash/gnucash/releases/download/2.6.19/gnucash-docs-2.6.19.tar.gz
   You can also checkout the sources directly from the git repository.

About the Program

GnuCash is a free, open source

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-17 Thread Adrien Monteleone 
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

There is usually a one-week gap between 1 & 3. 3,4 & 5 usually happen on the 
same day. There is usually a 4-5 week gap between 3 & 7. The period boundary 
usually happens between 5 & 6, but sometimes between 6 & 7.

The pre-paid expense should not appear until 6 is complete, but is currently 
happening at 5. The date of 6 is unknown until it happens, so I can’t ‘fudge’ 
and choose it as the posting date beforehand.

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. So I’ve opted to bypass the Business 
Features entirely for this special case and forego the bill reminder as well as 
any ability to see this activity in a vendor report.


Regards,
Adrien

> On Dec 16, 2017, at 4:36 PM, Dale Alspach  wrote:
> 
> Adrien,
> 
> I do not use the business features but it seems from what you have
> written that something like the following may do what you want.
> 
> Create a new liability account named Unbilled Payables (or whatever you
> like).
> Replace
>> Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
>> Cr. Liabilities:Accounts_Payable
> by
> Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
> Cr. Liabilities:Unbilled Payables
> 
> There is no change in the Balance Sheet net. The entry in Unbilled
> Payables should be tagged so that an audit trail could be constructed.
> 
> When the bill arrives, post the bill so that you effect a transfer
> between the liabilities
> Dr. Liabilities:Unbilled Payables
> Cr. Liabilities:Accounts_Payable
> 
> Again there is no change in the Balance Sheet net. At this point the
> normal flow of the business features should generate your reminder and,
> upon payment, zero the liability for the pre-paid insurance. The asset
> becomes real.
> 
> Dale
> 
> On 12/15/2017 02:57 PM, Adrien Monteleone wrote:
>> Yes, I can explain. And the example of insurance is just that. A pre-paid 
>> expense IS an asset. (in accrual accounting)
>> 
>> I pay in advance for auto insurance. The policy renews every 6 months. (for 
>> me, this is in December and June)
>> 
>> Paying in advance is a pre-paid expense. This is an asset. I have not yet 
>> received ‘service’ from the insurance company.
>> 
>> Here’s what the entry should be twice a year:
>> 
>> Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
>> Cr. Assets:Current_Assets:Cash
>> 
>> As I receive ‘service’ each month, or ‘use’ the asset, I credit the pre-paid 
>> expense account and debit the actual expense account for one-sixth of the 
>> asset (as this is a 6-month policy):
>> 
>> Dr. Expenses:Auto:Auto_Insurance
>> Cr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
>> 
>> The original question was trying to resolve the issue of posting the bill 
>> from the insurer for each renewal and how that affects recognition of the 
>> acquisition of the pre-paid expense asset.
>> 
>> My current entry from the bill is:
>> 
>> Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
>> Cr. Liabilities:Accounts_Payable
>> 
>> and then when I pay it:
>> 
>> Dr. Liabilities:Accounts_Payable
>> Cr. Assets:Current_Assets:Cash
>> 
>> Technically, legally, I don’t have this asset until I actually pre-pay. The 
>> generation of a paper bill from the insurer is not an activity that either 
>> is the earning of income on their part, the incurring of an expense on mine, 
>> or even the assumption of a liability on the part of either of us. If I 
>> decline to pay the bill, the policy never goes into effect, I never receive 
>> anything of value and the insurer earns nothing, owes me nothing, and has no 
>> claim against me. (I don’t owe them anything)
>> 
>> Posting the bill on any date other than the actual payment date creates the 
>> problem of properly recognizing the asset. This is even more problematic if 
>> the bill for renewal is received and posted into GnuCash in the period prior 
>> to the renewal and payment date. (frequently the case - the bill usually 
>> arrives in mid November/May)
>> 
>> Note, I can’t find any guidance online on posting a ‘bill' for pre-paid 
>> insurance. ALL examples I find state to make the above entry—effective on 
>> the date of payment. I suspect this is because it is a shift in assets that 
>> cannot occur until it actually does. This is not a cash vs. accrual problem. 
>> The very use of the pre-paid expense account is a practice of accrual 
>> accounting and NOT cash basis accounting. (on a cash basis, the

export general ledger

2017-12-17 Thread Jeff Abrahamson 
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.

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-17 Thread Adrien Monteleone 
Mike,

There are several dates at issue, but the main one I’m concerned with is ‘a’ or 
‘when work done’.

The problem is that this date infrequently occurs in the same period as either 
the real or effective date of the invoice/bill, or the date you open/post it in 
GnuCash.

Receiving, creating and posting a bill in December, for work done in November, 
should show up on reports in November as that was when the work was done. But 
it doesn’t. It shows up in December. One can enter the November dates on the 
line items in the bill, but that seems to be informational only and has no 
effect.

This is even more pronounced when a single bill has line items for work done in 
multiple periods. Only one period will show those expenses, and likely, it will 
be the period the bill was entered in, not any of the periods when the work was 
done.

(the same is equally true for income/invoices)

To fix this, I have to make correcting entries. I’m only having to make a 
correction because GnuCash didn’t use the data I put into it so that the 
expenses/income hit their proper periods of when the activity actually took 
place and instead used one of the artificial dates of document exchange/data 
entry.

Certainly, I can ‘post’ to any date I like, so for single-period 
bills/invoices, this can mitigated somewhat, but there is no easy solution for 
multi-period documents. With the case of pre-paid expenses, I really shouldn’t 
post until the pre-billing is paid. (loosing the Bills Due Reminder in the 
process)


Regards,
Adrien

> On Dec 15, 2017, at 4:20 PM, Mike or Penny Novack 
>  wrote:
> 
> I have zero experience with gnucash's invoicing system. Nevertheless I think 
> in this conversation dates may be confused. When I receive an invoice, say 
> for a visit to the doctor, there are SEVERAL dates involved.
> 
> a) The date the service was performed.
> b) The effective date of the invoice prepared by the doctor's billing service.
> c) The real time date when the invoice was prepared by the billing service
> 
> Which of these dates are we talking about? And from the doctor's point of 
> view, which of these dates (were we using gnucash) would be used for the date 
> of the transaction? << when affecting AR >>
> 
> When people are talking about periods being crossed "when work done" vs "when 
> invoice prepared" I wonder whether all are talking about the same date. And 
> if gnucash IS using the real time date when somebody gets around to entering 
> data, there may be a different sort of problem.
> 
> Michael D Novack
> ___
> 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 not updating mutual funds

2017-12-17 Thread Derek Atkins 
Make sure you are running F::Q 1.45 or higher. Then change to yahoo json or 
alphavantage quote source.


-derek
Sent using my mobile device. Please excuse any typos.



On December 17, 2017 11:20:27 AM david amaral via gnucash-user 
 wrote:




gnucash was working fine and now has stopped updating my investments in 
mutual funds.i am getting the error message:there was an unknown errorwhile 
receiving the price quote
These are the version numbers i am working with.Ubuntu 16.04 LTSGnucash 
2.6.12Perl5 v5.22.1


I have looked thru some posts and tried different things.
gnc-fq-dump nyse FCNTXno results found for FCNTX
gnc-fq-dump alphavantage FCNTXFinance::Quote fields Gnucash uses:        
 symbol: FCNTX (deduced)  <===required             date:  ** missing **    
   currency: ** missing **        etcAs I stated earlier it was working 
fine and now has stopped. any help with this would be greatly appreciated. 
I run quicken on my windows machine and gnucash on ubuntu. i am thinking of 
going to moneydance for both machines if i cant get this fixed.

___
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 not updating mutual funds

2017-12-17 Thread david amaral via gnucash-user 

gnucash was working fine and now has stopped updating my investments in mutual 
funds.i am getting the error message:there was an unknown errorwhile receiving 
the price quote
These are the version numbers i am working with.Ubuntu 16.04 LTSGnucash 
2.6.12Perl5 v5.22.1

I have looked thru some posts and tried different things.
gnc-fq-dump nyse FCNTXno results found for FCNTX
gnc-fq-dump alphavantage FCNTXFinance::Quote fields Gnucash uses:         
symbol: FCNTX (deduced)  <===required             date:  ** missing **       
currency: ** missing **        etcAs I stated earlier it was working fine and 
now has stopped. any help with this would be greatly appreciated. 
I run quicken on my windows machine and gnucash on ubuntu. i am thinking of 
going to moneydance for both machines if i cant get this fixed.
___
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.