External Program

Mark Mercer markm at woodjoint.ca
Fri Jun 10 23:00:50 EDT 2016


So yup, that fixed it!  So happy now.

The only issue that comes to mind now is how do I make sure I don't 
generate duplicate guid's.  How does gnucash do it?  it cant be as 
simple as generate random ones and assume that the set is so large that 
there would never be a duplicate.


On 10/06/2016 11:22 PM, Adrien Monteleone wrote:
> Mark, I'd say right off that since the letter 'M' is not a valid hex number, GC is probably choking on it. I'm not familiar with generating guid's but since the ones generated by GC itself are hex values, I'd suspect you'd need to stick to that numbering system. If it would work, perhaps the ASCII value for 'M' as a hex would suffice, though I'm not sure if this creates any other issues with guid's.  (thus "M" which is '77' ASCII is '4d' Hex)
>
> -Adrien
>
>
>
>> From: Mark Mercer <markm at woodjoint.ca>
>> Date: June 10, 2016 7:34:32 PM CDT
>> To: Aaron Laws <dartme18 at gmail.com>
>> Cc: gnucash-user at gnucash.org
>> Subject: Re: External Program
>>
>>
>> Hi Aaron, I've tried exporting to sqlite but the file always comes out blank.  I've also tried a csv file but it's also blank.
>>
>> I'll give you a more detailed explanation here now.  From what I can see there are only three tables in the database that have records in them (other than the "version" table).  I've listed them below along with the records that are relevant to what I'm doing.
>>
>> Accounts
>> guid, name, type, commodity_guid, commodity_scu, non_std_scu, parent_guid... etc...
>> '5e5acaea00cf48203a8b44d58f96ffad', 'Sales', 'INCOME', 'f845d29aff6356d67df273c864277df2', '100', '0', '94d60e0b5a702628676e7791c2e019a5', '', 'Sales', '0', '0'
>>
>>
>> Transactions
>> guid, currency_guid, num, post_date, enter_date, description
>> 'b3fae0a5fd1b5fbe6aac4ae840f38d3c', 'f845d29aff6356d67df273c864277df2', '3', '2016-06-08 02:30:00', '2016-06-09 01:55:55', 'Test'
>>
>>
>> Splits
>> guid, tx_guid, account_guid, memo, action, reconcile_state, reconcile_date, value_num, value_denom, quantity_num, quantity_denom, lot_guid
>> '4ba293ddd80a04ed8510e61e6e3d40c2', 'b3fae0a5fd1b5fbe6aac4ae840f38d3c', '5e5acaea00cf48203a8b44d58f96ffad', '', '', 'n', NULL, '-1000', '100', '-1000', '100', NULL
>> 'abd191aa748822fdac2112b629708ee5', 'b3fae0a5fd1b5fbe6aac4ae840f38d3c', '7d0fd461835281509cf260e8a1baa272', '', '', 'n', NULL, '1000', '100', '1000', '100', NULL
>>
>> So, its easy to see that the split table tx_guid refers to the transaction record and that the split table account_guid refers to the account record.  The split table links it all together.  And it uses two records of opposing values because they have to be reconciled or something.  I don't know enough about accounting to know what a split is or exactly why we need to do all this reconciling business but I'm willing to live with it if that's the way it's supposed to be done.
>> The denom field represents basically the number of cents in a dollar and the value field when divided by the denom shows the amount of the transaction (so I've entered a $10 sale).
>> Then I manually duplicated the three records and replaced the first character in the guid's with M so I know I made them and changed the value of the copy to $22.22.  The records I created are shown below but gnucash doesn't display them at all.
>>
>> New Transactions (I created)
>> 'M3fae0a5fd1b5fbe6aac4ae840f38d3c', 'f845d29aff6356d67df273c864277df2', '4', '2016-06-08 02:30:00', '2016-06-09 01:55:55', 'Test2'
>>
>> New Splits (I created)
>> 'Mba293ddd80a04ed8510e61e6e3d40c2', 'M3fae0a5fd1b5fbe6aac4ae840f38d3c', '5e5acaea00cf48203a8b44d58f96ffad', '', '', 'n', NULL, '-2222', '100', '-2222', '100', NULL
>> 'Mbd191aa748822fdac2112b629708ee5', 'M3fae0a5fd1b5fbe6aac4ae840f38d3c', '7d0fd461835281509cf260e8a1baa272', '', '', 'n', NULL, '2222', '100', '2222', '100', NULL
>>
>>
>> For this reason I just suspected gnucash does some sort of checksum on the guid's and it could identify the ones I inserted as bogus. But if not this method SHOULD work.  Ideas?
>>
>>
>> On 10/06/2016 11:30 AM, Aaron Laws wrote:
>>> On Thu, Jun 9, 2016 at 6:34 PM, Mark Mercer <markm at woodjoint.ca <mailto:markm at woodjoint.ca>> wrote:
>>>
>>>     Thank you both for your replies.
>>>
>>>     What I actually did was I went into gnucash and created a record
>>>     in one of the sections and then I opened up SQL workbench and
>>>     looked through the tables.  The record I created actually made
>>>     entries in three or four tables so I studied what each table was
>>>     for which guid's pointed to where and then duplicated the records
>>>     in the database and assigned new guid's that I made up.  I opened
>>>     gnucash and it did not display the new records that I created. Any
>>>     idea's?  I must be missing something.
>>>
>>>     I will use gnucash to enter most records but for these sales
>>>     receipts I think it will be a bit clunky.  I would rather create a
>>>     robust app on my own that can enter the data in a few clicks and
>>>     selecting stuff from dropdows etc.
>>>
>>>     If you could help me a little further to get this working it would
>>>     make everything so much simpler for me.
>>>
>>>     Thanks again.
>>>
>>>
>>> I'll be happy to dig into this with you and help you more, but I really need to know what you've found and what you're doing. Perhaps a minimal sqlite .gnucash file? I'm not sure how to generate a customer receipt.
>>
>>
>>
>>
>> From: Miranda Lee <miranda.lee at hkban.org>
>> Date: June 10, 2016 5:16:05 AM CDT
>> To: "Maf. King" <maf at chilwell.net>
>> Cc: gnucash-user at gnucash.org
>> Subject: GNUCash issues
>>
>>
>> Dear Maf,
>>
>> If you still have time for my questions.. I would appreciate your further
>> advice*!*
>>
>> How can I correct the record showed at 'Company registration' after I have
>> setting up one already?
>> (it actually wasn't the Account name i wanted to change but the initial
>> account name i have setup for a new account).
>> Even though I can easily change the file name, when I print a report it
>> till showed the name I have initial set up.
>>
>> For printing Profit & lost report, although I have selected all account and
>> the date range (then hit 'apply', then 'okay), there is no figures showing
>> at the report! Do you know the reason?
>>
>> Thanks a million*!*
>>
>>
>> Miranda  Lee
>>
>> Hong Kong Business Angel Network Ltd.
>> Unit 201, 2/F, Enterprise Place
>> No. 5 Science Park West Avenue
>> Hong Kong Science Park
>> Shatin, New Territories
>>
>> Tel. +852 2629-6728
>> miranda.lee at hkban.org
>>
>> ** Disclaimer **
>> This email and it's attachment(s) are intended solely for the use of the
>> individual to whom it is addressed and may contain information which is
>> privileged, confidential, proprietary or exempt from disclosure under
>> applicable law. If you are not the intended recipient or the person
>> responsible for delivering the message to the intended recipient, you are
>> strictly prohibited from disclosing, distributing, copying or in any way
>> using this message. If you have received this email in error, please notify
>> the sender and destroy / delete any copies you may have received.
>>
>>
>>
>> On 8 June 2016 at 17:50, Maf. King <maf at chilwell.net> wrote:
>>
>>> On Wednesday, 8 June 2016 10:42:56 BST Miranda Lee wrote:
>>>> Dear Sir/ Madam,
>>>>
>>>> I would need to seek help regarding the use of GNUCash and have two
>>>> questions below:
>>>>
>>>> Can I change the account name after it is created since I have mistakenly
>>>> input all transaction at a wrong account. (the accounts in question are
>>>> highlighted as below, I wish to swap the name so I don't need to input
>>>> everything again).
>>>>
>>>> How can I stop the auto save? Whenever I use it lots of different files
>>>> will be created (as the image below).
>>>>
>>> Hi Miranda,
>>>
>>> You can easily change an account name at any time - from the account tree
>>> view, just right click and "Edit Account"
>>>
>>> -BUT-
>>> If you've put transactions into the wrong account, then renaming the
>>> account
>>> is not what you want to do.  If all the transactions in the account are
>>> wrong,
>>> then just delete that account, and GC will ask you if you want to delete
>>> the
>>> transactions or put them in a different account...
>>>
>>> If it is only some transactions, then you'll have to hand edit the transfer
>>> account in each one manually.  (hint: copy & paste the correct account name
>>> from your first edit)
>>>
>>> The auto-save interval can be set in Edit->Preferences->General.
>>>
>>> HTH,
>>> Maf.
>>>
>>>
>>>
>>>
>>
>>
>>
>> From: Wm <tcnw81 at tarrcity.demon.co.uk>
>> Date: June 10, 2016 3:51:58 PM CDT
>> To: gnucash-user at lists.gnucash.org
>> Subject: Re: External Program
>>
>>
>> On Thu, 9 Jun 2016 20:04:53 -0230, in gmane.comp.gnome.apps.gnucash.user,
>> Mark Mercer <markm at woodjoint.ca> wrote:
>>
>>> Thank you both for your replies.
>>>
>>> What I actually did was I went into gnucash and created a record in one
>>> of the sections and then I opened up SQL workbench and looked through
>>> the tables.  The record I created actually made entries in three or four
>>> tables so I studied what each table was for which guid's pointed to
>>> where and then duplicated the records in the database and assigned new
>>> guid's that I made up.  I opened gnucash and it did not display the new
>>> records that I created. Any idea's?  I must be missing something.
>>>
>>> I will use gnucash to enter most records but for these sales receipts I
>>> think it will be a bit clunky.  I would rather create a robust app on my
>>> own that can enter the data in a few clicks and selecting stuff from
>>> dropdows etc.
>>>
>>> If you could help me a little further to get this working it would make
>>> everything so much simpler for me.
>>>
>>> Thanks again.
>> If you've an immediate business problem to solve get your external prog to
>> create perfectly formed gnc import files, that way you can get on with
>> doing the important stuff and solve any API issues at your leisure.
>> Imports are only fiddly if you are doing them as a one off, done regularly
>> they are efficient.
>>
>> Meanwhile if you're familiar with relational databases
>> https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
>> can be a good starting point.
>>
>> I strongly recommend looking at Sebastien's work if you are going to be
>> looking at gnc from an sql POV in a non-trivial way, start here:
>>
>> http://piecash.readthedocs.io/en/latest/tutorial/index_existing.html#other-objects
>>
>> Warning: discussion of writing to a gnc database in an unapproved way may
>> result in tears.
>>
>> -- 
>> Wm
>>
>>
>>
>>
>>
>> From: Wm <tcnw81 at tarrcity.demon.co.uk>
>> Date: June 10, 2016 4:36:57 PM CDT
>> To: gnucash-user at lists.gnucash.org
>> Subject: Re: Unable to create new Namespace in Price Editor
>>
>>
>> On Thu, 09 Jun 2016 23:33:51 +0000, in gmane.comp.gnome.apps.gnucash.user,
>> Jonathan Wells <jon.wells at yakka.ca> wrote:
>>
>>> Thanks for that info.
>>>
>>> That works for creating the Namespace, a Security, and subsequently for
>>> creating a Price.
>>>
>>> But my idea will not work as the only account type that can be
>>> denominated using the new MILEAGE commodity is "Stock" or "Mutual Fund".
>>>   Ideally I want to enter MILEAGE directly from the vehicle log into an
>>> expense account transaction as if it was a currency worth 55c per unit.
>>> I will do the calculation manually and enter it as a normal expense.
>> I'm not entirely sure I understand how you were expecting things to work
>> but the currency
>> XXX No Currency
>> is normally involved and intended for just this purpose by ISO_4217
>>
>> if you set the expense account up as XXX an xfer from an asset a/c to the
>> expense a/c will ask you for an exchange rate.
>>
>> as an alternative do you know you can do sums inside gnc money amount
>> fields ?
>>
>> e.g. from an Asset a/c like Bank
>>
>> Dt: 		2016-06-10
>> Desc: 		mileage to Jun 10
>> Transfer: 	Exp:MileageCosts
>> Cr:		123*0.55
>>
>> where 123 is the mileage you want to be expensed at .55 each, you'll end up
>> with 67.65 in money being knocked off the asset and recorded in the expense
>> account.
>>
>> If your main point was to record miles per month rather than the monetary
>> result of miles then gnc is not well suited to the task.  The main reason
>> for this is that you don't actually have any miles, i.e. there isn't an
>> asset to increase or decrease if you think about it :)  gnc is best at
>> recording the monetary effect of real world stuff rather than real world
>> stuff itself, which is, for a modest program, as many of us think it should
>> be.
>>
>> If this is a "just thinking about it" issue let the list know, someone else
>> may have another approach.
>>
>> -- 
>> Wm
>>
>>
>>
>>
>>
>>
>> From: Wm <tcnw81 at tarrcity.demon.co.uk>
>> Date: June 10, 2016 5:32:43 PM CDT
>> To: gnucash-user at lists.gnucash.org
>> Subject: Re: My Messages Go to Spam
>>
>>
>> On Fri, 10 Jun 2016 18:22:56 +0100, in gmane.comp.gnome.apps.gnucash.user,
>> Fred Bone <Fred.Bone at dial.pipex.com> wrote:
>>
>>> On 10 June 2016 at 9:34, John Ralls said:
>>>> Not exactly. When replying to a digest one should change the subject and
>>>> edit the quoted text to match the one message in the digest to which one
>>>> is replying.
>>> Wrong. The whole point is that one is reading a single message at a time,
>>> and replying to it is therefore no different from what it would be if
>>> receiving non-digested messages. With the sole exception that most
>>> digestifiers fail to include the References: header, which can mess up
>>> threading ... but then many mail readers can't cope with it anyway.
>>>
>>> You may be thinking of plaintext digests.
>> and *you*, Fred, are talking about the way one application may deal with
>> multi-part digests not all.
>>
>> -- 
>> Wm
>>
>>
>>
>>
>>
>> From: Wm <tcnw81 at tarrcity.demon.co.uk>
>> Date: June 10, 2016 5:44:33 PM CDT
>> To: gnucash-user at lists.gnucash.org
>> Subject: Re: OFX Connection Troubles with Fifth Third
>>
>>
>> On Tue, 7 Jun 2016 19:31:50 -0400, in gmane.comp.gnome.apps.gnucash.user,
>> Ben Hopple <nebabon at gmail.com> wrote:
>>
>>> Hi All
>>>
>>> I'm attempting to move over to GnuCash from Quicken and I'm having
>>> difficulty getting the online part to work correctly.  I've set up the
>>> account correctly (I think) and can connected and discover what accounts I
>>> have with Fifth Third (they all show up correctly).  When I attempt to
>>> connect directly and pull down a balance or transaction info, I get the
>>> following message:
>>>
>>> "AqBanking v5.5.1.0stable
>> [snip]
>>
>>> Any ideas on what's happening?
>> AqBanking wasn't made for the USA-ian banking system.  Essentially
>> FifthThird is, like Donald Trump, a small minded foreigner that doesn't
>> want to play with the rest of the world :)
>>
>> -- 
>> Wm
>>
>>
>>
>>
>>
>> From: Jack Cahn <jcahn at ls.net>
>> Date: June 10, 2016 7:58:31 PM CDT
>> To: gnucash-user at gnucash.org
>> Subject: Re: gnucash-user Digest, Vol 159, Issue 17
>>
>>
>> Thank you.  Maybe next spring.    Jack
>>
>> On 06/10/2016 07:40 PM, gnucash-user-request at gnucash.org wrote:
>>> Send gnucash-user mailing list submissions to
>>> 	gnucash-user at gnucash.org
>>>
>>> To subscribe or unsubscribe via the World Wide Web, visit
>>> 	https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> or, via email, send a message with subject or body 'help' to
>>> 	gnucash-user-request at gnucash.org
>>>
>>> You can reach the person managing the list at
>>> 	gnucash-user-owner at gnucash.org
>>>
>>> When replying, please edit your Subject line so it is more specific
>>> than "Re: Contents of gnucash-user digest..."
>>>
>>>
>>> Today's Topics:
>>>
>>>     1. Re: API questions (John Ralls)
>>>     2. Re: My Messages Go to Spam (Fred Bone)
>>>     3. Re: API questions (John Ralls)
>>>     4. Re: My Messages Go to Spam (John Ralls)
>>>     5. Re: API questions (David Goodenough)
>>>     6. Re: My Messages Go to Spam (Fred Bone)
>>>     7. Re: API questions (Art)
>>>     8. fixed assets (Elmar Schmeisser)
>>>     9. Re: Advance portfolio (Mike Alexander)
>>>    10. Re: fixed assets (John Ralls)
>>>    11. Re: External Program (Mark Mercer)
>>>    12. Re: fixed assets (Elmar Schmeisser)
>>>    13. Re: fixed assets (John Ralls)
>>>
>>>
>>> ----------------------------------------------------------------------
>>>
>>> Message: 1
>>> Date: Fri, 10 Jun 2016 09:24:58 -0700
>>> From: John Ralls <jralls at ceridwen.us>
>>> To: David Goodenough <david.goodenough at linkchoose.co.uk>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: API questions
>>> Message-ID: <436A6E56-5F73-4E4B-AA1A-AF3396B586BF at ceridwen.us>
>>> Content-Type: text/plain; charset=us-ascii
>>>
>>>
>>>> On Jun 10, 2016, at 8:43 AM, David Goodenough <david.goodenough at linkchoose.co.uk> wrote:
>>>>
>>>> On Friday 10 June 2016 08:29:01 John Ralls wrote:
>>>>>> On Jun 10, 2016, at 7:06 AM, David Goodenough
>>>>>> <david.goodenough at linkchoose.co.uk> wrote:>
>>>>>> On Friday 10 June 2016 06:59:38 John Ralls wrote:
>>>>>>>> On Jun 10, 2016, at 2:05 AM, David Goodenough
>>>>>>>> <david.goodenough at linkchoose.co.uk> wrote:
>>>>>>>>
>>>>>>>> I notice when looking at the API pages that a method is defined as
>>>>>>>> starting
>>>>>>>> at a given line, and then the code below always starts on the next line,
>>>>>>>> i.e. missing out the prototype.  For example:-
>>>>>>>>
>>>>>>>> Definition at line 116 of file print-session.c.
>>>>>>>>
>>>>>>>> 117 {
>>>>>>>> 118     return print_settings;
>>>>>>>> 119 }
>>>>>>>>
>>>>>>>> Would it not be possible to show line 116 as well?  This seems to be a
>>>>>>>> consistent problem throughout the docs.
>>>>>>> The prototype is in very large print above the description. Repeating it
>>>>>>> in
>>>>>>> the listing would be redundant.
>>>>>> OK, missed that.  It just looked odd at first glance that the line number
>>>>>> immedately before the code was not in the code that was shown.
>>>>>>
>>>>>>>> The reason I was looking was to generate customer reports via the API.
>>>>>>>> I would like to be able to generate a report for each customer who
>>>>>>>> either
>>>>>>>> has a non-zero balance or where some transaction (invoice or receipt of
>>>>>>>> payment) happened last month (or since rather since I last ran the
>>>>>>>> program). I then want to export the report as a PDF.  I have looked my
>>>>>>>> way through the API docs but could not see how to generate reports, or
>>>>>>>> to
>>>>>>>> check for the balance or the presence of transactions since a date.
>>>>>>>>
>>>>>>>> I found docs on how to create invoices, but also need to be able to
>>>>>>>> export them as PDFs and could not locate the API for that either.  I
>>>>>>>> notice
>>>>>>>> in the gnucash XML files that the last direcorty to which invoices ( and
>>>>>>>> I
>>>>>>>> guess customer reports ) were exported is stored, is this available from
>>>>>>>> the API.
>>>>>> I think having read a bit further that this is in the customer dictionary?
>>>>>>
>>>>>>>> What I want to be able to write is a program that will generate reports
>>>>>>>> for all relevant customers, and then send an email to each customer who
>>>>>>>> has either an invoice and/or a report containing both.
>>>>>>>>
>>>>>>>> Any pointers gratefully received.
>>>>>>> PDF generation is provided by (IIRC) libgtk as part of printing support.
>>>>>>> You won't find the code for that in GnuCash itself.
>>>>>> OK, but I still need to tell it to generate the customer report, and to
>>>>>> check whether I need to do so?
>>>>> Sorry, neither of those questions make sense.
>>>> I will try to restate them:-
>>>>
>>>> 1) From the UI I can request a customer report and tell the UI to export it as
>>>> a PDF.  How do I achieve the same from the API?
>>> The reports module is written in Scheme, so anything having to do with reports must use Scheme. That API isn't documented via Doxygen (Doxygen doesn't know how to parse Scheme), so you'll have to study the code in src/reports. You may find http://wiki.gnucash.org/wiki/Custom_Reports helpful.
>>>
>>> I already told you that GnuCash's API doesn't know how to export PDFs. It knows how to write HTML. You'll have to find an external library or utility to convert the HTML to PDF.
>>>
>>>>   
>>>> 2) Looking at the customer report I can see if the report shows a non-zero
>>>> balance or has transactions in the last month.  How can I check the balance
>>>> and see if there are invoices or receipts for a given customer in the last
>>>> month though the API?
>>> You will have to extract the logic of the report to replicate its query and calculations and test the results.
>>>
>>>> Obviously I would like to have dataset format independance rather than going
>>>> direct to the data, so I want to do as much as possible through the API.
>>>>
>>>> David
>>>>> Regards,
>>>>> John Ralls
>>>
>>>
>>> ------------------------------
>>>
>>> Message: 2
>>> Date: Fri, 10 Jun 2016 17:26:11 +0100
>>> From: "Fred Bone" <Fred.Bone at dial.pipex.com>
>>> To: gnucash-user at gnucash.org
>>> Subject: Re: My Messages Go to Spam
>>> Message-ID: <575AEA23.23125.11942C6F at Fred.Bone.dial.pipex.com>
>>> Content-Type: text/plain; charset=UTF-8
>>>
>>> On 10 June 2016 at 11:55, Oon-Ee Ng said:
>>>
>>>> On Thu, Jun 9, 2016 at 11:52 PM, Fred Bone <Fred.Bone at dial.pipex.com>
>>>> wrote: > On 8 June 2016 at 10:52, David T. said: > >> Indeed. Thanks for
>>>> the confirmation. I see that when this came up in 2014, >> Derek had
>>>> indicated that the appropriate Mailman patches would need to be >>
>>>> installed. >> >> I don?t plan to change my subscription at
>>>> Gnucash-users, so let this be >> an alert to gmail subscribers: if you
>>>> want to see all the messages from >> gnucash-users, add a whitelist entry
>>>> for the list. > > Or switch to MIME-Digest mode.
>>>>
>>>> Not a satisfactory solution both for the recipient and for the list,
>>>> replies to digests tend to be troublesome to parse.
>>> Why? They are no different from responses to single messages. That is the
>>> whole point.
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> Message: 3
>>> Date: Fri, 10 Jun 2016 09:32:46 -0700
>>> From: John Ralls <jralls at ceridwen.us>
>>> To: David Goodenough <david.goodenough at linkchoose.co.uk>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: API questions
>>> Message-ID: <35BBA6E9-6CD4-47E0-9137-8A8DFE7DA8BA at ceridwen.us>
>>> Content-Type: text/plain; charset=us-ascii
>>>
>>>
>>>> On Jun 10, 2016, at 9:24 AM, John Ralls <jralls at ceridwen.us> wrote:
>>>>
>>>>> On Jun 10, 2016, at 8:43 AM, David Goodenough <david.goodenough at linkchoose.co.uk> wrote:
>>>>>
>>>>>
>>>>> 1) From the UI I can request a customer report and tell the UI to export it as
>>>>> a PDF.  How do I achieve the same from the API?
>>>> The reports module is written in Scheme, so anything having to do with reports must use Scheme. That API isn't documented via Doxygen (Doxygen doesn't know how to parse Scheme), so you'll have to study the code in src/reports. You may find http://wiki.gnucash.org/wiki/Custom_Reports helpful.
>>> I should have added that the query API that the reports use is in C and are documented at http://code.gnucash.org/docs/MAINT/group__Query.html, so once you've figured out from the Customer Report what queries to run you can use C or Python to extract the data and then use other libraries to perform whatever calculations you like and to format it the way you need it.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> Message: 4
>>> Date: Fri, 10 Jun 2016 09:34:09 -0700
>>> From: John Ralls <jralls at ceridwen.us>
>>> To: Fred.Bone at dial.pipex.com
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: My Messages Go to Spam
>>> Message-ID: <6BF3D677-D711-486C-9D6A-0F268F392762 at ceridwen.us>
>>> Content-Type: text/plain; charset=utf-8
>>>
>>>
>>>> On Jun 10, 2016, at 9:26 AM, Fred Bone <Fred.Bone at dial.pipex.com> wrote:
>>>>
>>>> On 10 June 2016 at 11:55, Oon-Ee Ng said:
>>>>
>>>>> On Thu, Jun 9, 2016 at 11:52 PM, Fred Bone <Fred.Bone at dial.pipex.com>
>>>>> wrote: > On 8 June 2016 at 10:52, David T. said: > >> Indeed. Thanks for
>>>>> the confirmation. I see that when this came up in 2014, >> Derek had
>>>>> indicated that the appropriate Mailman patches would need to be >>
>>>>> installed. >> >> I don?t plan to change my subscription at
>>>>> Gnucash-users, so let this be >> an alert to gmail subscribers: if you
>>>>> want to see all the messages from >> gnucash-users, add a whitelist entry
>>>>> for the list. > > Or switch to MIME-Digest mode.
>>>>>
>>>>> Not a satisfactory solution both for the recipient and for the list,
>>>>> replies to digests tend to be troublesome to parse.
>>>> Why? They are no different from responses to single messages. That is the
>>>> whole point.
>>> Not exactly. When replying to a digest one should change the subject and edit the quoted text to match the one message in the digest to which one is replying.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> Message: 5
>>> Date: Fri, 10 Jun 2016 17:34:26 +0100
>>> From: David Goodenough <david.goodenough at linkchoose.co.uk>
>>> To: gnucash-user at gnucash.org
>>> Subject: Re: API questions
>>> Message-ID: <3415511.fZeOJaVnJ8 at stargate>
>>> Content-Type: text/plain; charset="us-ascii"
>>>
>>> On Friday 10 June 2016 09:24:58 John Ralls wrote:
>>>>> On Jun 10, 2016, at 8:43 AM, David Goodenough
>>>>> <david.goodenough at linkchoose.co.uk> wrote:>
>>>>> On Friday 10 June 2016 08:29:01 John Ralls wrote:
>>>>>>> On Jun 10, 2016, at 7:06 AM, David Goodenough
>>>>>>> <david.goodenough at linkchoose.co.uk> wrote:>
>>>>>>>
>>>>>>> On Friday 10 June 2016 06:59:38 John Ralls wrote:
>>>>>>>>> On Jun 10, 2016, at 2:05 AM, David Goodenough
>>>>>>>>> <david.goodenough at linkchoose.co.uk> wrote:
>>>>>>>>>
>>>>>>>>> I notice when looking at the API pages that a method is defined as
>>>>>>>>> starting
>>>>>>>>> at a given line, and then the code below always starts on the next
>>>>>>>>> line,
>>>>>>>>> i.e. missing out the prototype.  For example:-
>>>>>>>>>
>>>>>>>>> Definition at line 116 of file print-session.c.
>>>>>>>>>
>>>>>>>>> 117 {
>>>>>>>>> 118     return print_settings;
>>>>>>>>> 119 }
>>>>>>>>>
>>>>>>>>> Would it not be possible to show line 116 as well?  This seems to be a
>>>>>>>>> consistent problem throughout the docs.
>>>>>>>> The prototype is in very large print above the description. Repeating
>>>>>>>> it
>>>>>>>> in
>>>>>>>> the listing would be redundant.
>>>>>>> OK, missed that.  It just looked odd at first glance that the line
>>>>>>> number
>>>>>>> immedately before the code was not in the code that was shown.
>>>>>>>
>>>>>>>>> The reason I was looking was to generate customer reports via the API.
>>>>>>>>> I would like to be able to generate a report for each customer who
>>>>>>>>> either
>>>>>>>>> has a non-zero balance or where some transaction (invoice or receipt
>>>>>>>>> of
>>>>>>>>> payment) happened last month (or since rather since I last ran the
>>>>>>>>> program). I then want to export the report as a PDF.  I have looked my
>>>>>>>>> way through the API docs but could not see how to generate reports, or
>>>>>>>>> to
>>>>>>>>> check for the balance or the presence of transactions since a date.
>>>>>>>>>
>>>>>>>>> I found docs on how to create invoices, but also need to be able to
>>>>>>>>> export them as PDFs and could not locate the API for that either.  I
>>>>>>>>> notice
>>>>>>>>> in the gnucash XML files that the last direcorty to which invoices (
>>>>>>>>> and
>>>>>>>>> I
>>>>>>>>> guess customer reports ) were exported is stored, is this available
>>>>>>>>> from
>>>>>>>>> the API.
>>>>>>> I think having read a bit further that this is in the customer
>>>>>>> dictionary?
>>>>>>>
>>>>>>>>> What I want to be able to write is a program that will generate
>>>>>>>>> reports
>>>>>>>>> for all relevant customers, and then send an email to each customer
>>>>>>>>> who
>>>>>>>>> has either an invoice and/or a report containing both.
>>>>>>>>>
>>>>>>>>> Any pointers gratefully received.
>>>>>>>> PDF generation is provided by (IIRC) libgtk as part of printing
>>>>>>>> support.
>>>>>>>> You won't find the code for that in GnuCash itself.
>>>>>>> OK, but I still need to tell it to generate the customer report, and to
>>>>>>> check whether I need to do so?
>>>>>> Sorry, neither of those questions make sense.
>>>>> I will try to restate them:-
>>>>>
>>>>> 1) From the UI I can request a customer report and tell the UI to export
>>>>> it as a PDF.  How do I achieve the same from the API?
>>>> The reports module is written in Scheme, so anything having to do with
>>>> reports must use Scheme. That API isn't documented via Doxygen (Doxygen
>>>> doesn't know how to parse Scheme), so you'll have to study the code in
>>>> src/reports. You may find http://wiki.gnucash.org/wiki/Custom_Reports
>>>> helpful
>>> Great, I will have a look and see what is there.
>>>> .
>>>>
>>>> I already told you that GnuCash's API doesn't know how to export PDFs. It
>>>> knows how to write HTML. You'll have to find an external library or utility
>>>> to convert the HTML to PDF.
>>> Yes I know how to convert HTML toPDF, so that is no problem.
>>>>> 2) Looking at the customer report I can see if the report shows a non-zero
>>>>> balance or has transactions in the last month.  How can I check the
>>>>> balance
>>>>> and see if there are invoices or receipts for a given customer in the last
>>>>> month though the API?
>>>> You will have to extract the logic of the report to replicate its query and
>>>> calculations and test the results.
>>> WIll do,
>>>
>>> Thank you
>>>
>>> David
>>>>> Obviously I would like to have dataset format independance rather than
>>>>> going direct to the data, so I want to do as much as possible through the
>>>>> API.
>>>>>
>>>>> David
>>>>>
>>>>>> Regards,
>>>>>> John Ralls
>>>
>>> ------------------------------
>>>
>>> Message: 6
>>> Date: Fri, 10 Jun 2016 18:22:56 +0100
>>> From: "Fred Bone" <Fred.Bone at dial.pipex.com>
>>> To: John Ralls <jralls at ceridwen.us>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: My Messages Go to Spam
>>> Message-ID: <575AF770.848.11C8207B at Fred.Bone.dial.pipex.com>
>>> Content-Type: text/plain; charset=UTF-8
>>>
>>> On 10 June 2016 at 9:34, John Ralls said:
>>>
>>>>> On Jun 10, 2016, at 9:26 AM, Fred Bone <Fred.Bone at dial.pipex.com> wrote:
>>>>>
>>>>> On 10 June 2016 at 11:55, Oon-Ee Ng said:
>>>>>
>>>>>> On Thu, Jun 9, 2016 at 11:52 PM, Fred Bone <Fred.Bone at dial.pipex.com>
>>>>>> wrote: > On 8 June 2016 at 10:52, David T. said: > >> Indeed. Thanks
>>>>>> for the confirmation. I see that when this came up in 2014, >> Derek
>>>>>> had indicated that the appropriate Mailman patches would need to be >>
>>>>>> installed. >> >> I don?t plan to change my subscription at
>>>>>> Gnucash-users, so let this be >> an alert to gmail subscribers: if you
>>>>>> want to see all the messages from >> gnucash-users, add a whitelist
>>>>>> entry for the list. > > Or switch to MIME-Digest mode.
>>>>>>
>>>>>> Not a satisfactory solution both for the recipient and for the list,
>>>>>> replies to digests tend to be troublesome to parse.
>>>>> Why? They are no different from responses to single messages. That is
>>>>> the whole point.
>>>> Not exactly. When replying to a digest one should change the subject and
>>>> edit the quoted text to match the one message in the digest to which one
>>>> is replying.
>>> Wrong. The whole point is that one is reading a single message at a time,
>>> and replying to it is therefore no different from what it would be if
>>> receiving non-digested messages. With the sole exception that most
>>> digestifiers fail to include the References: header, which can mess up
>>> threading ... but then many mail readers can't cope with it anyway.
>>>
>>> You may be thinking of plaintext digests.
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> Message: 7
>>> Date: Fri, 10 Jun 2016 19:42:19 +0000 (UTC)
>>> From: Art <pinaart at yahoo.com>
>>> To: David Goodenough <david.goodenough at linkchoose.co.uk>
>>> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
>>> Subject: Re: API questions
>>> Message-ID:
>>> 	<457821586.1111123.1465587739247.JavaMail.yahoo at mail.yahoo.com>
>>> Content-Type: text/plain; charset=UTF-8
>>>
>>> If I were writing a program to do things, I'd be looking at the source code, though it would be nice if the API stood alone. (I haven't used the API, so I am not familiar with what you're trying to do specifically. I usually just tweak GC and rebuild it to make it do what I want or access the SQL database directly, carefully if I am writing to it.)
>>> On exporting to PDF, I always use a PDF printer driver (in Windows and Linux). I've seen some apps that do export to PDF, but I never do that with my code - it's not worth bloating it (my software apps do create ASCII text files and write to the clipboard). I can also see where you may want to export v. print programmatically (avoid modal printer dialogs, if you need to change the default printer).
>>>
>>>        From: David Goodenough <david.goodenough at linkchoose.co.uk>
>>>   To: gnucash-user at gnucash.org
>>>   Sent: Friday, June 10, 2016 2:05 AM
>>>   Subject: API questions
>>>     I notice when looking at the API pages that a method is defined as starting
>>> at a given line, and then the code below always starts on the next line, i.e.
>>> missing out the prototype.? For example:-
>>>
>>> Definition at line 116 of file print-session.c.
>>>
>>> ? 117 {
>>> ? 118? ? return print_settings;
>>> ? 119 }
>>>
>>> Would it not be possible to show line 116 as well?? This seems to be a
>>> consistent problem throughout the docs.
>>>
>>> The reason I was looking was to generate customer reports via the API.
>>> I would like to be able to generate a report for each customer who either
>>> has a non-zero balance or where some transaction (invoice or receipt of
>>> payment) happened last month (or since rather since I last ran the program).
>>> I then want to export the report as a PDF.? I have looked my way through
>>> the API docs but could not see how to generate reports, or to check for
>>> the balance or the presence of transactions since a date.
>>>
>>> I found docs on how to create invoices, but also need to be able to
>>> export them as PDFs and could not locate the API for that either.? I notice
>>> in the gnucash XML files that the last direcorty to which invoices ( and I
>>> guess customer reports ) were exported is stored, is this available from
>>> the API.
>>>
>>> What I want to be able to write is a program that will generate reports
>>> for all relevant customers, and then send an email to each customer who
>>> has either an invoice and/or a report containing both.
>>>
>>> Any pointers gratefully received.
>>>
>>> David
>>> _______________________________________________
>>> 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.
>>>
>>>
>>>    
>>> ------------------------------
>>>
>>> Message: 8
>>> Date: Fri, 10 Jun 2016 18:42:16 -0400
>>> From: Elmar Schmeisser <eschmeisser at nc.rr.com>
>>> To: gnucash-user at gnucash.org
>>> Subject: fixed assets
>>> Message-ID: <c4a76225-c40b-5f08-c145-3b0cda59a2ce at nc.rr.com>
>>> Content-Type: text/plain; charset=utf-8
>>>
>>> I have a question on how to update the value of fixed assets (car,
>>> house, etc.).  One can of course assign a value when the asset is
>>> created in GC, but what account does the appreciation/depreciation come
>>> from? - Elmar
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> Message: 9
>>> Date: Fri, 10 Jun 2016 19:02:43 -0400
>>> From: Mike Alexander <mta at umich.edu>
>>> To: Roy Hammerstr?m <roy.hammerstrom at outlook.com>
>>> Cc: gnucash-user <gnucash-user at gnucash.org>
>>> Subject: Re: Advance portfolio
>>> Message-ID: <60E1CBA8-0171-481F-822D-D7056ED4C093 at umich.edu>
>>> Content-Type: text/plain;	charset=utf-8
>>>
>>> Sorry fir the delay replying.  I?ve inserted some comments in the text below.
>>>
>>>> On Jun 2, 2016, at 9:20 AM, Roy Hammerstr?m <roy.hammerstrom at outlook.com> wrote:
>>>>
>>>> In "price source" I did try them both to see if that helped, but as far as I can tell, it didn't.
>>>> Can it maybe be something that I've done, or should have done to connect the price list database and the shares?
>>>> Or should that not matter?
>>> They are connected automatically, there is nothing you need to do except make sure you enter (or download) prices for the correct stock.
>>>
>>>> It looks weird that the report don't take the prices from the database. I've tried to look at all the options I could find to see if that had anything to do with it. When I go "accounts" and then click on the "edit" button to change the share, one of the thing there is "smallest subdivision" (or what it is called in English, the one where you select "use product value", "1/10", "1/100", "1/1000" etc), what is the best one to select there?
>>> I don?t think the report cares what you select for that option.  It determines the smallest fraction of a share you can record, but dowsn?t affect the price.
>>>
>>>> I just had at the "investment portfolio" report and in that one, it looks like the report uses the correct numbers.
>>>> In fact, I just did double check the numbers in the investment portfolio, and the total value for each share is correct.
>>>> And the total value for all my shares according to the investment portfolio, is the same as it is in the advanced portfolio.
>>>> So I also did check the total value for my share when I bought them, and that amount is also correct in the advanced portfolio.
>>>> So it then looks like the buying price and value in the advance portfolio is correct, but not the price.
>>>> Therefore, since so much is correct, with the exception of the price, I wonder how much more we should put in to this.
>>>>
>>> So you?re saying that the current value doesn?t equal the number of shares times the price?  Is that correct?  This seems odd.  Perhaps it is a currency exchange rate problem.  You probably said before, but I can?t recall the answer.  Is the currency of the report the same as the currency in the price database for the stocks in question?  The price fields in the report should be links.  If you click on one of them it should open the price DB entry from which the price was taken.  Does this work and if so what do you find?   Is the currency what you expect?  Is it the same as the report?s currency?  Is the price the same as shown in the report?
>>>
>>>               Mike
>>>   
>>> ------------------------------
>>>
>>> Message: 10
>>> Date: Fri, 10 Jun 2016 16:11:38 -0700
>>> From: John Ralls <jralls at ceridwen.us>
>>> To: Elmar Schmeisser <eschmeisser at nc.rr.com>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: fixed assets
>>> Message-ID: <479DE104-C514-4ABE-9108-670D3D3C929A at ceridwen.us>
>>> Content-Type: text/plain; charset=us-ascii
>>>
>>>
>>>> On Jun 10, 2016, at 3:42 PM, Elmar Schmeisser <eschmeisser at nc.rr.com> wrote:
>>>>
>>>> I have a question on how to update the value of fixed assets (car,
>>>> house, etc.).  One can of course assign a value when the asset is
>>>> created in GC, but what account does the appreciation/depreciation come
>>>> from? - Elmar
>>> That's more of an accounting question than a GnuCash one, and if this is for a business you should consult a licensed accountant for advice. In the USA depreciation is normally an expense. Change in market value is not normally entered into accounts until the asset is sold unless one is a bank large enough to be subject to Dodd-Frank which requires those banks to "mark to market" certain liabilities. In GnuCash one could create a security representing the asset and add prices for it in the price editor; its "market value" will then show on the Accounts page without affecting its "book value" in the register.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> Message: 11
>>> Date: Fri, 10 Jun 2016 20:41:45 -0230
>>> From: Mark Mercer <markm at woodjoint.ca>
>>> To: Wm <tcnw81 at tarrcity.demon.co.uk>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: External Program
>>> Message-ID: <6f54109e-5086-6965-4cdf-0790118ab069 at woodjoint.ca>
>>> Content-Type: text/plain; charset=windows-1252; format=flowed
>>>
>>> thanks Wm,
>>>
>>> Lol yes I'm aware that if I go writing to the gnc db with an external
>>> prog it could result in tears.  My hope is I get it right from the
>>> beginning and its smooth sailing.  This is a brand new business startup
>>> so I don't have any old data to screw up.  As such I also don't have any
>>> "immediate" business to get done (that is unless I cant figure this out
>>> by Monday).  I did consider using the import files and I will likely go
>>> that route if this method doesn't work but it adds that extra step and a
>>> whole lot of shenanigans with remembering to import and having your code
>>> remember which records have already been exported.  It would be much
>>> simpler to bypass all that.
>>>
>>> I'll read up on the links you gave me.  I'm just in the process now of
>>> putting together the gnucash file that aaron suggested so that he can
>>> help me out.
>>>
>>> Thanks again.
>>>
>>> Mark
>>>
>>> On 10/06/2016 6:21 PM, Wm wrote:
>>>> [FYI: This is a copy of a message posted to <news:gmane.comp.gnome.apps.gnucash.user> Message-ID: <1wl0ubhhw5w4r.dlg at tcnw81.tarrcity.invalid>]
>>>>
>>>> On Thu, 9 Jun 2016 20:04:53 -0230, in gmane.comp.gnome.apps.gnucash.user,
>>>> Mark Mercer <markm at woodjoint.ca> wrote:
>>>>
>>>>> Thank you both for your replies.
>>>>>
>>>>> What I actually did was I went into gnucash and created a record in one
>>>>> of the sections and then I opened up SQL workbench and looked through
>>>>> the tables.  The record I created actually made entries in three or four
>>>>> tables so I studied what each table was for which guid's pointed to
>>>>> where and then duplicated the records in the database and assigned new
>>>>> guid's that I made up.  I opened gnucash and it did not display the new
>>>>> records that I created. Any idea's?  I must be missing something.
>>>>>
>>>>> I will use gnucash to enter most records but for these sales receipts I
>>>>> think it will be a bit clunky.  I would rather create a robust app on my
>>>>> own that can enter the data in a few clicks and selecting stuff from
>>>>> dropdows etc.
>>>>>
>>>>> If you could help me a little further to get this working it would make
>>>>> everything so much simpler for me.
>>>>>
>>>>> Thanks again.
>>>> If you've an immediate business problem to solve get your external prog to
>>>> create perfectly formed gnc import files, that way you can get on with
>>>> doing the important stuff and solve any API issues at your leisure.
>>>> Imports are only fiddly if you are doing them as a one off, done regularly
>>>> they are efficient.
>>>>
>>>> Meanwhile if you're familiar with relational databases
>>>> https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
>>>> can be a good starting point.
>>>>
>>>> I strongly recommend looking at Sebastien's work if you are going to be
>>>> looking at gnc from an sql POV in a non-trivial way, start here:
>>>>
>>>> http://piecash.readthedocs.io/en/latest/tutorial/index_existing.html#other-objects
>>>>
>>>> Warning: discussion of writing to a gnc database in an unapproved way may
>>>> result in tears.
>>>>
>>>
>>> ------------------------------
>>>
>>> Message: 12
>>> Date: Fri, 10 Jun 2016 19:30:46 -0400
>>> From: Elmar Schmeisser <eschmeisser at nc.rr.com>
>>> To: gnucash-user at gnucash.org
>>> Subject: Re: fixed assets
>>> Message-ID: <1238ac07-4027-befc-099e-3e71bc2df4f3 at nc.rr.com>
>>> Content-Type: text/plain; charset=windows-1252
>>>
>>> This is strictly non-business :)  MY house, MY car - I want to get GC to
>>> calculate my "net worth" in essence.  So I have the purchase price of my
>>> house (paid off btw if that matters), and Zillow will every so often
>>> give me an updated value on my house.  Likewise, Kelly Blue Book (among
>>> others) will give me updated (lower of course) values on my (paid off)
>>> car.  How can I handle this in GC? - Elmar
>>>
>>> On 6/10/2016 7:11 PM, John Ralls wrote:
>>>>> On Jun 10, 2016, at 3:42 PM, Elmar Schmeisser
>>>>> <eschmeisser at nc.rr.com> wrote:
>>>>>
>>>>> I have a question on how to update the value of fixed assets (car,
>>>>> house, etc.).  One can of course assign a value when the asset is
>>>>> created in GC, but what account does the appreciation/depreciation
>>>>> come from? - Elmar
>>>> That's more of an accounting question than a GnuCash one, and if this
>>>> is for a business you should consult a licensed accountant for
>>>> advice. In the USA depreciation is normally an expense. Change in
>>>> market value is not normally entered into accounts until the asset is
>>>> sold unless one is a bank large enough to be subject to Dodd-Frank
>>>> which requires those banks to "mark to market" certain liabilities.
>>>> In GnuCash one could create a security representing the asset and add
>>>> prices for it in the price editor; its "market value" will then show
>>>> on the Accounts page without affecting its "book value" in the
>>>> register.
>>>>
>>>> Regards, John Ralls
>>>>
>>>>
>>>>
>>>>
>>>
>>> ------------------------------
>>>
>>> Message: 13
>>> Date: Fri, 10 Jun 2016 16:38:03 -0700
>>> From: John Ralls <jralls at ceridwen.us>
>>> To: Elmar Schmeisser <eschmeisser at nc.rr.com>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: fixed assets
>>> Message-ID: <CA8F77C8-4A75-4E4A-8CD3-E9607779B34E at ceridwen.us>
>>> Content-Type: text/plain; charset=us-ascii
>>>
>>>
>>>> On Jun 10, 2016, at 4:30 PM, Elmar Schmeisser <eschmeisser at nc.rr.com> wrote:
>>>>
>>>> This is strictly non-business :)  MY house, MY car - I want to get GC to
>>>> calculate my "net worth" in essence.  So I have the purchase price of my
>>>> house (paid off btw if that matters), and Zillow will every so often
>>>> give me an updated value on my house.  Likewise, Kelly Blue Book (among
>>>> others) will give me updated (lower of course) values on my (paid off)
>>>> car.  How can I handle this in GC? - Elmar
>>>>
>>>> On 6/10/2016 7:11 PM, John Ralls wrote:
>>>>> In GnuCash one could create a security representing the asset and add
>>>>> prices for it in the price editor; its "market value" will then show
>>>>> on the Accounts page without affecting its "book value" in the
>>>>> register.
>>> Just as I said. That will also reflect in the Net Worth reports.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> Subject: Digest Footer
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>
>>>
>>> ------------------------------
>>>
>>> End of gnucash-user Digest, Vol 159, Issue 17
>>> *********************************************
>>
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> _______________________________________________
> 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.
>



More information about the gnucash-user mailing list