GnuCash with SQL and remembering Payee addresses for printing checks

[Derek Atkins]

Some people are single-issue voters, some others are
single-issue-software-users.  *shrugs*

A quick history lesson.  GnuCash started as a personal finance app.
When the business features were added (which include the Customer/Vendor
database), it was added as a plugin.  The rest of the app (including
check printing) had no knowledge of the business features.  More
recently the business features were merged into the main code (no longer
a separate module), so down the road the check printing *could* know
about the vendor database.  But right now it's still not there, yet.

As for what you can do...  patches are always welcome  :)

-derek

Spencer Graves <spencer.graves at prodsyse.com> writes:

> Hi, Derek:
>
>
>       Thanks so much for your many contributions to helping others
> better manage their finances (and their lives) via GnuCash --
> including your answers to two other similar questions last January and
> April.  A friend recently asked me why I use MS Money 99 and not
> GnuCash.  When I explained that Money 99 remembered payee addresses
> and GnuCash didn't, he insisted I was wrong, pointing me to the
> article on SQL in the GnuCash Wiki.
>
>
>       Thanks again.
>       Spencer Graves
>
>
> On 10/25/2014 7:42 PM, Derek Atkins wrote:
>> 1.2
>>
>> -derek
>>
>> Sent on my mobile. Please forgive any typos.
>>
>> ----- Reply message -----
>> From: "Spencer Graves" <spencer.graves at prodsyse.com>
>> To: "GnuCash Users List" <gnucash-user at gnucash.org>
>> Subject: GnuCash with SQL and remembering Payee addresses for printing checks
>> Date: Sat, Oct 25, 2014 10:34 PM
>>
>> Hello:
>>
>>
>> Can someone help me understand the "SQL" page in the GnuCash Wiki
>> (http://wiki.gnucash.org/wiki/SQL)?
>>
>>
>> In particular, I'd like to know how this relates to current
>> versions of GnuCash and its ability to remember payee when printing
>> checks.  This "SQL" page includes an SQL specification for a table
>> "vendors", which includes lines for "addr".  However, a 21 Apr 2014
>> reply on this list reported that, 'GnuCash does not have a "Payee
>> Address Database" for checks.'
>> (http://comments.gmane.org/gmane.comp.gnome.apps.gnucash.user/54550).
>>
>>
>> "Vendors" sounds like "Payees" to me.
>>
>>
>> 1.  I can thing of two possible interpretations:
>>
>>
>> 1.1.  Was the 21 April 2014 reply mistaken?
>>
>>
>> 1.2.  Or does the current database for GnuCash
>> include space for vendor / payee addresses, but that's not currently
>> used when printing checks?
>>
>>
>> 2.  In either case, what might a user do to get GnuCash to
>> remember addresses for payees in printing checks?
>>
>>
>> Thanks,
>> Spencer Graves
>>
>>
>> p.s.  I have GnuCash 2.6.1, which is the default version for Ubuntu
>> 14.04 LTS, where it's installed.  I could upgrade to GnuCash 2.6.4 if
>> that would make a difference.  If needed I could also compile GnuCash
>> from source.  In a thread on this list around January 10, 2014, Derek
>> Atkins suggested I "could always code in the feature and donate it."
>> Some else said, "It is a feature I too would like.  But don’t know how
>> to make the necessary changes."
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at 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 at 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.

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available