Re: [GNC] Ledger-CLI

[david whiting]

On Wed, 3 Apr 2024 at 20:36, Art Chimes  wrote:
[...]

>
> 2.  Does anyone who has used Ledger, with or without Gnucash files,
> have anything to say about Ledger and whether they think it's worth
> looking into.
>

I've used piecash to convert gnucash files to ledger format (see
https://piecash.readthedocs.io/en/master/doc/doc.html?highlight=ledger#the-piecash-command-line-interface
).

There are pros and cons compared to gnucash, so it depends on what's
important to you. I've found that account matching when importing
transactions is better in gnucash than ledger-cli, the gnucash gui is
probably better for most users and the built-in reports in gnucash
help you to quickly get what most users need, maybe with a bit of
tweaking to set up local preferences/options. Gnucash has a number of
features, such as bills and invoices, built-in that you need to set-up
manually in ledger-cli (i.e. construct a way of doing it).

Where I've found ledger-cli to be useful is for automating parts of
processes that involve multiple people - in one context I have a
reasonably complex setting that involves lots of people submitting
expenses claims, and I have created a google form with some apps
script that automatically generates an email to provide a receipt for
the person and ledger-cli transactions that I can just copy and paste
quickly - this has saved me a lot of time. I use emacs ledger-mode to
interact with my ledger files, so editing is fast and easy because
emacs is good at that. I have a load of reports set up in an org-mode
file which means I can have lots of variations saved that are quick to
navigate to and can export them to nicely formatted HTML files. And
because it's all based on text files, I can use git (locally) for
version control. I can also log into my computer from my phone and run
ledger in a terminal to do things remotely (mostly querying, editing
is a bit fiddly).

I like them both, for different reasons and purposes.

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Find account

[david whiting]

Do you mean find all accounts with a given string in the account name?

Edit > Find Account (Ctrl+I) brings up a search window (it doesn't
work if you are in a report, so go to an account register or your
chart of accounts).

David


On Sat, 30 Mar 2024 at 01:36, Fred Tydeman  wrote:
>
> Is there a way to find all accounts that contain a given string?
> I am looking for *quote* somewhere in the account name.
>
> Gnucash 4.14 on Fedora Linux
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Liability Balances - All payments disappeared

[david whiting]

Also the database/XML file itself refers them as splits (i.e, each
transaction is made up of two or more splits), so if we start using
different terminology for what people on the frontend it could get
really confusing if we are trying to resolve a problem and have to
refer to what's in the data using one meaning for split and a
different meaning for the frontend.

David

On Thu, 18 Jan 2024 at 20:15, Adrien Monteleone
 wrote:
>
> Yes, this is an example where it isn't just the terminology of users,
> but rather that the UI uses the term 'split' for two different meanings.
>
> I too have memo transactions with only one split and no value.
>
> Regards,
> Adrien
>
> On 1/18/24 1:45 PM, Stan Brown (using GC 4.14) wrote:
> > Don't forget, changing "split" to a "new term" would mean program
> > changes. When I click on a line within a transaction and then click the
> > delete icon, a popup asks whether I want to delete "the split". And that
> > happens whether there are two splits in the transaction or more than two.
> >
> > (It is of course possible to have a transaction that has but one split,
> > with amount equal to zero. I do it as a way of making a memo that isn't
> > tied to any financial transaction, for instance the number of miles I
> > drove for charity in a given month. GnuCash has no problem with that.)
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Help with searching questions and problems

[david whiting]

Hi Gyle,

The list of mailing lists can be found here:
https://wiki.gnucash.org/wiki/Mailing_Lists

One listed is the English (USA) archive:
https://lists.gnucash.org/pipermail/gnucash-user/

There you can view each month by thread, subject, author, and date. I can
see four messages from you in December.

David

On Mon, 18 Dec 2023, 00:57 Gyle McCollam,  wrote:

> I sent an email 5 days ago, Titled "Import Issue" and have not seen any
> responses.  Where do I go to search questions submitted to see if it was
> received?
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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
To update your subscription preferences or to unsubscribe:
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: [GNC] Find what was in Accounts Payable some date in the past.

[david whiting]

Does setting the date in the report Options give you what you need?
You should be able to see where there are amounts payable for each
vendor and if you click on the value link it will take you to the
vendor report for that same date. Is that what you are looking for?

David

On Mon, 27 Nov 2023 at 18:03, David Kirkby
 wrote:
>
> I have given my accounts to my accountant, who has asked for a breakdown of
> the what transactions are in the accounts payable, as there's £353.90 shown
> on A/P at the end of the accounting period. Since whatever was owed has now
> been paid, I can't find what was owed on that date. There's no single
> transaction for that amount, so it must consist of multiple transactions.
>
> --
> Dr David Kirkby Ph.D
> Kirkby Microwave Ltd
> Email: drkir...@kirkbymicrowave.co.uk
> Web: https://www.kirkbymicrowave.co.uk/
> Telephone 07910 441670 (UK) or +44 7910 441670 (international)
> Registered in England and Wales, company number 08914892.
> Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Can I find transactions into an account that has only one split?

[david whiting]

Here's a link to the internet archive/wayback machine version:
https://web.archive.org/web/20210411043559/https://unicom.crosenthal.com/pw/reply-to-harmful.html
and here's a link to a different copy that is still live:
https://marc.merlins.org/netrants/reply-to-harmful.html

David

On Sat, 25 Nov 2023 at 08:46, Maf. King  wrote:
>
> On Saturday, 25 November 2023 04:44:42 GMT Liz wrote:
>
> >
> > The new subscriber welcome message says
> > "Note that this list is configured NOT to automatically send replies
> > back to the list (as per
> > <http://www.unicom.com/pw/reply-to-harmful.html> ).
> >
>
> That seems to be a dead link.
> Maf.
>
> > *** Please remember to CC All Replies back to the list! ***
> > "
> >
> > Liz
> > with Moderator Hat.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] keyboard shortcut - how to implement for open/close splits?

[david whiting]

And you could add

(gtk_accel_path
"/GncPluginPageRegisterActions/ViewStyleDoubleLineAction"
"4")

To toggle viewing the transaction notes.

David

David

On Tue, 12 Sept 2023 at 18:43, Michael Hendry  wrote:
>
>
> On 12 Sep 2023, at 18:17, George Riner  wrote:
>
> >
> > I really wish there was a keyboard shortcut to open/close the Splits on the 
> > transaction I'm in.
> >
> > Is there some edit I can make to a file somewhere in gnucash that would 
> > make this effect?
> >
> > :George
> >
> > GnuCash Version: 4.13
> > Build ID: 4.13+(2022-12-17)
> > Windows 10 22H2 (build 19045.3324)
>
> Hi, George.
>
> Have a look here:
>
> https://wiki.gnucash.org/wiki/Keyboard_Shortcuts
>
> I use a Mac, so the file I’ve edited is
> ~/Library/Application Settings/Gnucash/acclerator-map;
>
> and the necessary lines are:
>
> (gtk_accel_path 
> "/GncPluginPageRegisterActions/ViewStyleRadioAction/0" "1")
> (gtk_accel_path 
> "/GncPluginPageRegisterActions/ViewStyleRadioAction/1" "2")
> (gtk_accel_path 
> "/GncPluginPageRegisterActions/ViewStyleRadioAction/2" "3")
>
> which opens the Basic Ledger view with Cmd-1, AutoSplit Ledger with Cmd-2 and 
> Transaction Journal with Cmd-3.
>
> I think this should be enough to get you started.
>
> Regards,
>
> Michael
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] csv of invoice data

[david whiting]

I needed to play with the invoices data a while ago and used the query
below (gnucash file saved as an sqlite database). I didn't need the
full invoice details and only selected a few of the fields. This
should be enough to get you started. Note that the invoices are in one
table and the invoice items are in another table.

  SELECT invoices.date_posted, invoices.id, invoices.notes,
  accounts.name AS acct_name,
  entries.description,
  quantity_num, quantity_denom, b_price_num, b_price_denom,
  quantity_num / CAST(quantity_denom AS FLOAT) AS quantity,
  b_price_num / CAST(b_price_denom AS FLOAT) AS price
  FROM entries, accounts
  LEFT JOIN invoices ON entries.bill = invoices.guid

David

On Mon, 28 Aug 2023 at 16:24, Morgan Read via gnucash-user
 wrote:
>
> Hi again :)
>
> In addition to wanting to deal with some old invoices, I'm also wanting
> to generate a csv of invoice data.  There's this post a few years back,
> but I feel there must be better.  I've discovered the page on
> 'ledger-cli': https://wiki.gnucash.org/wiki/Ledger-CLI - which seems
> complicated (perhaps not) but, I'm using a sqlite as a back-end anyway.
>
> It says here:
> https://wiki.gnucash.org/wiki/Published_tools
> That bad things will happen if accessing the GnuCash data outside of
> GnuCash - but, one of the reasons for switching to sqlite a while back
> was accessing the db to pull things out - and no harm can be done if the
> db is accessed read-only, can it?  Further down the page there's some
> links to export invoice data under 'Export invoices' - the GIP invoice
> printer says something about a csv template:
> https://lists.gnucash.org/pipermail/gnucash-user/2008-June/025615.html
>
> I've set up access to the db via unixodbc and from there opened it in LO
> Base - but having got there, I got to wondering if there's an easier way
> to get a csv of invoice data?
>
> Thanks
> --
> Morgan Read
>
> Grande Bretagne
> Em: 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Adding Bank Account/Cash on Reports

[david whiting]

When viewing the report, does:

Options -> Display -> Other Account Name

give you what you want?

David

On Sun, 2 Jul 2023 at 04:17, Koshy Thomas  wrote:

> Hello there,
>
> On Invoice & Transaction report, how can I show the Bank Account or CASH
> to which the Customer has paid .
> On Transaction report, for each transaction wish to show to which account
> the money has been deposited.
>
> Please help.
>
> Regards,
> Koshy Thomas
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Transferring data from one set of books to another

[david whiting]

Ah, I sent this before I saw your other reply that got separated from this
thread.

David

On Tue, 18 Apr 2023 at 20:17, david whiting  wrote:

> You can import customers as csv file, so you just need to get a way of
> exporting customers. One way you can do this is to save your gnucash file
> in sqlite format (if you don't use that already) and then open the file in
> something like sqlitebrowser https://sqlitebrowser.org/ Here you can view
> the customers table ("Browse data" and select the customers table) which
> you can then export as a csv file. It won't be in the right format to
> import, so you'll need to open it in a spreadsheet program and move some
> columns around and delete some columns that aren't needed. You can see the
> import format here:
> https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-customer-vendor.html
>
> David
>
> On Tue, 18 Apr 2023 at 16:25, Rich Shepard 
> wrote:
>
>> On Tue, 18 Apr 2023, Gyle McCollam wrote:
>>
>> > I don't know if it is possible, but have you checked out whether you can
>> > export this information? Then you can import into your business system.
>> I
>> > don't use for business, but it seems like you should be able to do this.
>>
>> Gyle,
>>
>> Not according to the gnucash-guide.
>>
>> Rich
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
>>
>
>
> --
> David Whiting
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Transferring data from one set of books to another

[david whiting]

You can import customers as csv file, so you just need to get a way of
exporting customers. One way you can do this is to save your gnucash file
in sqlite format (if you don't use that already) and then open the file in
something like sqlitebrowser https://sqlitebrowser.org/ Here you can view
the customers table ("Browse data" and select the customers table) which
you can then export as a csv file. It won't be in the right format to
import, so you'll need to open it in a spreadsheet program and move some
columns around and delete some columns that aren't needed. You can see the
import format here:
https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-customer-vendor.html

David

On Tue, 18 Apr 2023 at 16:25, Rich Shepard  wrote:

> On Tue, 18 Apr 2023, Gyle McCollam wrote:
>
> > I don't know if it is possible, but have you checked out whether you can
> > export this information? Then you can import into your business system. I
> > don't use for business, but it seems like you should be able to do this.
>
> Gyle,
>
> Not according to the gnucash-guide.
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] CVS import over-writing transactions?

[david whiting]

Ah, PBCK. I should have read the docs before posting:
https://code.gnucash.org/docs/C/gnucash-help/trans-import.html#trans-import-matcher


Specifically:

"If there is a lower quality match to an existing transaction, the imported
transaction may be flagged for updating of non-matching information in the
GnuCash record of the matching transaction. These decisions can be
overridden by the user."

Apologies for the noise.

David

On Wed, 15 Mar 2023 at 07:48, david whiting  wrote:

> OS: Linux (NixOS)
> Gnucash: 4.12 Build ID: 4.12+(2022-09-24)
> Backend: sqlite
>
> This is a weird one, and I can't work out if it's me or gnucash. I import
> transactions from a cvs export from my bank. I check the date of the last
> transaction that I have imported and truncate the csv file so that I'm only
> importing new transactions.
>
> After the import, usually, but not always, I check to make sure that the
> ending balance on the bank account matches that in gnucash. A couple of
> times I have found that it isn't and I check through each date to see where
> I have missed a transaction. When this has happened I have assumed that I
> truncated the import file incorrectly. I then manually add the missing
> transaction(s).
>
> I'm using gnucash for a local football club. At the moment we are taking
> payments for a tournament that we are organising and for these transactions
> I have been writing a number in the num column. Each number is unique and
> identifies the team that has registered (it has the row number from the
> separate registration database and the age group). When I did an import
> today, I found that some transactions were missing again and so I started
> to enter them; then I noticed that some of the new transactions that I had
> imported already had numbers in the num column, but the numbers related to
> the teams where the transactions were missing.
>
> See attached screenshot. This shows a transaction on 14/03/2023 where the
> number is T-25-U8 but the reference contains T-89-VETS, and similarly for
> the transaction below it. The T-25-U8 payment was made on 01/03/2023 (1
> March 23), but was missing after the import. The transaction with T-89-VETS
> in the reference shouldn't have had a number yet, as I hadn't entered it.
> This looks like the transaction with T-89-VETS has overwritten the T-25-U8
> transaction, except for the num.
>
> I make daily backups, so I looked at a backup from a couple of days ago
> and the original T-25-U8 transaction on 01/03/23 (1 March 23) was there. So
> it looks like the cvs import sometimes overwrites some transactions.
>
> I have looked at https://bugs.gnucash.org/ for bugs with the word
> "import" covering the last year and can't see anything that looks like this
> and I have checked the release notes for 4.13 and see no mention of a bug
> fix for something like this.
>
> Has anyone else seen anything like this? Is there anything I could be
> doing wrong when importing the csv file?
>
> David
> --
> David Whiting
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] CVS import over-writing transactions?

[david whiting]

OS: Linux (NixOS)
Gnucash: 4.12 Build ID: 4.12+(2022-09-24)
Backend: sqlite

This is a weird one, and I can't work out if it's me or gnucash. I import
transactions from a cvs export from my bank. I check the date of the last
transaction that I have imported and truncate the csv file so that I'm only
importing new transactions.

After the import, usually, but not always, I check to make sure that the
ending balance on the bank account matches that in gnucash. A couple of
times I have found that it isn't and I check through each date to see where
I have missed a transaction. When this has happened I have assumed that I
truncated the import file incorrectly. I then manually add the missing
transaction(s).

I'm using gnucash for a local football club. At the moment we are taking
payments for a tournament that we are organising and for these transactions
I have been writing a number in the num column. Each number is unique and
identifies the team that has registered (it has the row number from the
separate registration database and the age group). When I did an import
today, I found that some transactions were missing again and so I started
to enter them; then I noticed that some of the new transactions that I had
imported already had numbers in the num column, but the numbers related to
the teams where the transactions were missing.

See attached screenshot. This shows a transaction on 14/03/2023 where the
number is T-25-U8 but the reference contains T-89-VETS, and similarly for
the transaction below it. The T-25-U8 payment was made on 01/03/2023 (1
March 23), but was missing after the import. The transaction with T-89-VETS
in the reference shouldn't have had a number yet, as I hadn't entered it.
This looks like the transaction with T-89-VETS has overwritten the T-25-U8
transaction, except for the num.

I make daily backups, so I looked at a backup from a couple of days ago and
the original T-25-U8 transaction on 01/03/23 (1 March 23) was there. So it
looks like the cvs import sometimes overwrites some transactions.

I have looked at https://bugs.gnucash.org/ for bugs with the word "import"
covering the last year and can't see anything that looks like this and I
have checked the release notes for 4.13 and see no mention of a bug fix for
something like this.

Has anyone else seen anything like this? Is there anything I could be doing
wrong when importing the csv file?

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Saved Report Configurations

[david whiting]

On Sat, 11 Feb 2023 at 11:28, Mahon Finbar  wrote:
[...]
> My issue is to establish which report is which, if possible, by
> re-creating the title with the dates of the periods covered. Then I can
> eliminate any dupes, etc.
>

Try this:

1. Open Reports -> Saved Report Configurations and select the first report.
2. If this report has the correct settings, go back to Reports ->
Saved Report Configurations and click on the middle icon on the right
(see attached image). You can then edit the report name to make it
clear which report it is, e.g. by adding the year or time period to
the report name
3. If the report doesn't have the correct settings, e.g. dates, choose
the correct settings, then click on Save Config on the menu bar (not
Save Config As). Then go back to Reports -> Saved Report
Configurations, and click on the middle icon on right (see attached)
to edit the report name
4. Then repeat the process with the next report, and so on until you
have named all of the reports.
5. Then review the reports and see which ones need to be deleted

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[david whiting]

In addition to what Michael said, if you have multiple splits, you
might want to view the splits and change it there. Here's a quick
video showing this: https://youtu.be/k3wS2lmR5VQ

David

On Wed, 18 Jan 2023 at 21:40, Fross, Michael  wrote:
>
> When I notice I've placed a transaction in the wrong spot, I "jump" to the
> matching transaction and correct the credit card.  For example:
>
> I put my Walmart grocery into the CreditCard1 account instead of the
> CreditCard2 account.  I noticed this in the CreditCard1 account.
>
> 1. "Jump" to the matching transaction.  So now I am in the Grocery account.
> 2. Change that transaction to be CreditCard2 instead of the incorrect
> CreditCard1 account.
> 3. Press enter.
>
> The transaction in Grocery is fine, but you'll find it's gone from
> CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
> friend.
>
> Michael
>
> On Wed, Jan 18, 2023 at 3:31 PM Xe Roy  wrote:
>
> > I asked this question earlier but initial responses made me realize more
> > detail was necessary.
> >
> > I am a newby to gnucash ... trying to switch from Quicken to gnucash.
> > A mistake I regularly make is to enter a transaction into the wrong
> > account.
> > I'll have several accounts open and I just forget to switch.
> > In Quicken, I just move the transaction (splits and all) to the new
> > account.
> > The Internet chatter I've found so far lead me to believe this feature is
> > missing from gnucash.
> > I hope that's not true because it would really cause me excessive hassle.
> > I hope there is a way to move a transaction (including any splits) to
> > another account.
> >
> > Here is an example which illustrates a typical situation:
> > Let's say I have two credit cards, VISA and MASTER CARD.
> > Each has their own top-level CREDIT CARD account in gnucash, and each has
> > its own tab in gnucash.
> > I meant to enter a transaction in VISA but accidently entered it in MASTER
> > CARD.
> > The transaction is for $10 with WALMART in the description.
> > So, the main entry shows $10 and the splits show $5 to the clothing
> > account and $5 to the food account.
> > I want to move the entire WALMART transaction, including the splits, from
> > the MASTER CARD top-level account to the VISA top-level account in one easy
> > step.
> > This is easily doable in Quicken by right-clicking anywhere in the
> > transaction, clicking MOVE, and selecting the new account VISA.
> > How is this done in gnucash?
> >
> >
> >
> > Sent from Outlook<http://aka.ms/weboutlook>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Trying to build 4.13 on Ubuntu 22.10 with Ninja

[david whiting]

You might want to try the build script on this page
https://wiki.gnucash.org/wiki/Building_On_Ubuntu

I recently added a build script for ubuntu 22.10

This will pull in whatever is needed.

David

On Wed, 11 Jan 2023, 03:54 Michoel via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Im trying to install  4.13 on Ubuntu 22.10 with Ninja, but I am running
> into this error which I have tried to find an answer to, but to no avail:
>
> ninja
> [1/495] Generating
> ../../lib/x86_64-li.../site-ccache/tests/unittest-support.go
> FAILED:
> lib/x86_64-linux-gnu/guile/3.0/site-ccache/tests/unittest-support.go
> /home/papa/gnucash-build/lib/x86_64-linux-gnu/guile/3.0/site-ccache/tests/unittest-support.go
> cd /home/papa/gnucash-build/common/test-core && /usr/bin/cmake -E env
> LD_LIBRARY_PATH=/home/papa/gnucash-build/lib:/home/papa/gnucash-build/lib/gnucash:
> GNC_UNINSTALLED=YES GNC_BUILDDIR=/home/papa/gnucash-build
> GUILE_LOAD_PATH=/home/papa/Desktop/gnucash-4.13/common/test-core:/home/papa/gnucash-build/common/test-core:/home/papa/gnucash-build/common/test-core/deprecated:/home/papa/gnucash-build/share/guile/site/3.0
> GUILE_LOAD_COMPILED_PATH=/home/papa/gnucash-build/common/test-core:/home/papa/gnucash-build/lib/x86_64-linux-gnu/guile/3.0/site-ccache:/home/papa/gnucash-build/lib/x86_64-linux-gnu/guile/3.0/site-ccache/gnucash/deprecated
> GNC_MODULE_PATH=/home/papa/gnucash-build/lib:/home/papa/gnucash-build/lib/gnucash:
> /usr/bin/guile -e "(@@ (guild) main)" -s /usr/bin/guild compile -o
> /home/papa/gnucash-build/lib/x86_64-linux-gnu/guile/3.0/site-ccache/tests/unittest-support.go
> /home/papa/Desktop/gnucash-4.13/common/test-core/unittest-support.scm
> Backtrace:
> In /usr/bin/guild:
> 72:17 19 (main _)
> In srfi/srfi-1.scm:
> 634:9 18 (for-each # …)
> In scripts/compile.scm:
>279:27 17 (_ _)
> In system/base/target.scm:
>  65:6 16 (with-target _ _)
> In system/base/compile.scm:
> 187:6 15 (compile-file "/home/papa/Desktop/gnucash-4.13/common/…" …)
>  53:4 14 (call-with-output-file/atomic _ _ _)
> In ice-9/boot-9.scm:
>   1752:10 13 (with-exception-handler _ _ #:unwind? _ # _)
> In system/base/compile.scm:
> 69:11 12 (_)
>190:11 11 (_ #)
>331:39 10 (read-and-compile # # _ …)
>261:27  9 (_ _ _)
> In ice-9/boot-9.scm:
>2836:4  8 (save-module-excursion #)
> In language/scheme/compile-tree-il.scm:
> 31:16  7 (_)
> In ice-9/psyntax.scm:
>   1218:36  6 (expand-top-sequence (#) …)
>   1210:19  5 (parse _ (("placeholder" placeholder)) ((top) #(# # …)) …)
>259:10  4 (parse _ (("placeholder" placeholder)) ((top) #(# # …)) …)
> In unknown file:
>3 (load-extension "libtest-core-guile" "scm_init_unittest…")
> In system/foreign-library.scm:
>190:25  2 (load-foreign-library _ #:extensions _ # _ #:search-path …)
> In unknown file:
>1 (dlopen "libtest-core-guile.so" 1)
> In ice-9/boot-9.scm:
>   1685:16  0 (raise-exception _ #:continuable? _)
>
> ice-9/boot-9.scm:1685:16: In procedure raise-exception:
> In procedure dlopen: file "libtest-core-guile.so", message
> "libtest-core-guile.so: cannot open shared object file: No such file or
> directory"
> [10/495] Building C object
> gnucash/gno...nc-gnome.dir/Debug/gnc-budget-view.c.o  ..nc-gnome.dir/Debug/gnc-budget-view.c.o>
> ninja: build stopped: subcommand failed.
>
> Thank you for any help you can provide.
>
> --
>  Sent with Tutanota, enjoy secure & ad-free emails.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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
To update your subscription preferences or to unsubscribe:
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: [GNC] [GNC-dev] GnuCash 4.900 Released

[david whiting]

Here's the original email:
https://lists.gnucash.org/pipermail/gnucash-user/2023-January/104905.html

First two lines for context:

The GnuCash development team announces GnuCash 4.900, the first
unstable release leading to GnuCash 5.0.
This is an unstable release for testing purposes. Do not use it with
production data! Make a copy of your book to test this release.

David

On Tue, 10 Jan 2023 at 08:29, Jeff  wrote:
>
> On 1/10/23 12:14 AM, Adrien Monteleone wrote:
> > Lots of great improvements already and I'm sure more to look forward
> > to. (some new reports too!)
> >
> > But of the list so far, my money is on this one getting the most sighs
> > of relief and smiles:
> >
> > "The description field quickfill in the register now displays a
> > drop-down list of possible completions instead of just one inline
> > completion."
> >
> > (of course, a Stock Assistant is majorly cool too...)
> >
> > Thanks to all!
> >
> > Regards,
> > Adrien
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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.
>
> I missed something here, not surprising with the last 48 hour days I
> have spent.  All of the messages I see are Re.[GNC] GnuCash 4.900
> Released.  I cannot find the original message in any of the e-mails I
> down loaded.  Is there a new version or not?
>
> And how do I find it under Ubuntu 22.04.1 LTS?
>
> --
> --JEffrey Black M.B.A.
>
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Invoice emailing?

[david whiting]

Gnucash can use SQLite and that works well. I set up what Cam Ellison
described for our football club, where I needed to send about 450
statements at the end of each month showing players how much they had paid
and how much they owed. Querying the SQLite database to create the
statements as pdf files was quite easy. I wasn't using the business
features for that, as each player was a sub-account in Assets, rather than
a customer, but I did some other queries with invoices and can see how you
can easily get what you need.

David



On Tue, 3 Jan 2023 at 03:54, Simon Roberts 
wrote:

> Also an interesting idea. I'll keep that in mind and in the meantime make a
> background task to investigate documentation on how one runs this against a
> DB, and what makes any given DB compatible or not. I would be happy to run
> it against something like Derby or MySQL. Well, any open source DB that I
> can reliably connect to from Java/Scala I guess.
>
> Thanks for the idea Cam, much appreciated.
>
> Cheers,
> Simon
>
>
> On Mon, Jan 2, 2023 at 8:24 PM Cam Ellison  wrote:
>
> > If you use GnuCash with a database, and have the coding skills, you
> > could generate whatever invoice you want, and convert and email it. This
> > would be straightforward in most cases, though not trivial. Access to
> > the database is not confined to GnuCash itself. Just the same, you'd
> > have to do it outside of GnuCash.
> >
> > Cheers
> >
> > Cam
> >
> > On 2023-01-02 17:48, Adrien Monteleone wrote:
> > > If by 'directly' you mean from 'within GnuCash', no, you can't.
> > >
> > > Since the customer's e-mail address can appear on the invoice in their
> > > info block, you might be able to set up a script, possibly combined
> > > with a folder 'watcher' that can automate e-mailing a resulting PDF
> > > from printing the invoice to that e-mail address and crafting a
> > > subject line perhaps with the invoice number taken from the document.
> > >
> > > You can of course do the same thing with HTML, via running the invoice
> > > report, then use the Export button rather than print-to-file.
> > >
> > > How much of this you want to automate to reduce clicks is up to you.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On 1/2/23 7:15 PM, Simon Roberts wrote:
> > >> Can I directly email PDF, or was Adrien correct?
> > >
> > >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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.
> >
>
>
> --
> Simon Roberts
> (303) 249 3613
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Feature request - prevent a transaction with todays date

[david whiting]

You *can* create a proforma invoice or quote and turn that into an invoice.
Just create an invoice, but instead of giving it a number, use the word
PROFORMA or QUOTE, and don't post it. Then use the invoice printing
facility to print it (to find the proforma or quote, you can search, e.g.
by customer name). Then when the proforma needs to become a real invoice,
you can find the invoice (Business -> Customer -> Find Invoice, and search
by customer name) and then select Edit Invoice to change the invoice ID
from PROFORMA to whatever invoice ID you want. If you want to know what the
next number should be, you can open up Accounts Receivable and use View ->
Sort to sort by Number (and reverse order, if you wish) to make sure that
the previous invoice with the highest number is at the bottom (or top, if
reversed).

David

On Wed, 28 Dec 2022 at 22:08, Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Wed, 28 Dec 2022 at 21:26, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > Consider as well, another software package entirely to handle quotes,
> > proformas, invoices, AR even.
> >
> > Then export the resulting accounting data to GnuCash to complete your
> > books.
> >
> > (the same goes for investment tracking)
> >
>
> I use a word processor - LibraOffice.  But it would be nice to generate a
> quote or proforma invoice and turn that into an invoice. Like you can with
>
> Quckbooks
>
> https://quickbooks.intuit.com/learn-support/en-za/help-article/job-estimates/create-send-estimates-quotes-quickbooks-online/L0kOXRjoP_ZA_en_ZA
>
> Sage
>
> https://help.accounting.sage.com/en-us/accounting/invoicing/extra-sales-quotes.html
>
> Kashflow
> https://www.kashflow.com/support/kb/settings-quote-settings/
>
> etc.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] gnucash in tandem with SuiteCRM or other CRMs

[david whiting]

I don't use a CRM with Gnucash, but you might be able to achieve what you
need - it depends on what you mean exactly by "keeping customer
contacts/accounts up to date". Do you mean:

   1. Adding customers to the CRM,
   2. Importing them into gnucash so that you have the same customers in
   your CRM and gnucash
   3. Using gnucash the handle the invoices and payments

I see that SuiteCRM can export info as csv files, and gnucash can import
customer details, so you might be able to have a workflow that accomplishes
this via csv files. See this page for info on the gnucash csv import
structure:
https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-customer-vendor.html

David

On Fri, 2 Dec 2022 at 09:02, slidinghorn via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I tried to join the IRC via the matrix bridge, but there's no way to speak
> in the room if you aren't registered on the server, and you can't register
> without an IRC client...
>
> Anyway, this isn't really a support request as much as it is a request for
> anyone who uses gnucash in tandem with a CRM (Customer Relationship
> Management) application - most specifically SuiteCRM. I wanted to know if
> anyone does this successfully, how they manage the workflow in terms of
> keeping customer contacts/accounts up to date, if they have to manually
> enter everything in both places, etc.
>
> I'm looking into starting my own small business, and while I think it's
> almost certain to remain small enough that entering that kind of
> information twice won't be *too* much of a hassle, it would definitely be
> nice if someone's figured out a way to not have to duplicate that work.
>
> Thanks in advance for any stories or input you can provide!
>
> P.S. If/when I get a reply, I assume I should "Reply All", correct? It's
> been years since I've used a mailing list, and I'm rusty on the practice,
> lol
>
>
> Sent with Proton Mail secure email.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS

[david whiting]

In terms of the conversion, I don't think there will be important
differences between the two versions you have listed.

Another approach to consider is using the 20.04 (focal) live ISO. Just
put the ISO on a USB and boot from that, then install gnucash in the
live environment, and using that to convert your gnucash data to
version 3. That way you don't have to try to install different
versions on either 18.04 or 22.04.

David

On Sat, 27 Aug 2022 at 09:55, rsbrux via gnucash-user
 wrote:
>
> P.S. I still have a working Ubuntu 18.04 installation, so I thought I might 
> find GnuCash 3.8 in a backport repository.
>
> However, I have only found it in focal (1:3.8b-1build4) and focal-updates 
> (1:3.8b-1ubuntu1).
>
> What is the difference between 3.8b-1build4 and 3.8b-1ubuntu1?
>
> Would it be safe to install either of these GC versions in either Ubuntu 
> 18.04 or 22.04?
>
>
>
>
>
> From: rsbrux 
> Sent: Friday, August 26, 2022 12:03 PM
> To: 'gnucash-user@gnucash.org' 
> Subject: GnuCash 3 for Ubuntu Studio 22.04 LTS
>
>
>
> According to https://wiki.gnucash.org/wiki/Ubuntu, “GnuCash 4.8 is included 
> in Ubuntu 22.04, released April 2022 
> https://packages.ubuntu.com/jammy/gnucash”.
>
> I was running GC 2.6.19 under Ubuntu Studio 18.04 and I have read on this 
> mailing list that I will need to migrate to GC v 3.x before I can migrate to 
> GC 4.
>
> I would therefore like to install GC 3.8b. What is the easiest way to do this?
>
> Is there a repository I can add to Discover that I can pull it (or at least 
> some stable 3.x version) from?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Build From Source Near Impossible

[david whiting]

I think we should remove the instructions from
https://wiki.gnucash.org/wiki/Building_On_Ubuntu for 21.10. Anyone
have any objections to that?

David

On Mon, 8 Aug 2022 at 16:26, Adrien Monteleone
 wrote:
>
> Ditto concerning Ubuntu versions.
>
> In my experience so far building on older versions of Ubuntu, you can
> stumble into a nasty nearly un-resolvable dependency hell. It *can* be
> resolved (best I have figured out so far) by pinning lots of packages,
> but that may not always be the best solution for everyone and is more of
> an exercise to determine if it 'can be done at all'. Save for the sheer
> satisfaction of having tackled it, there is little practical value.
> (more than likely, those held packages are used by other apps and you'll
> eventually have problems when you update them)
>
> As I understand, GnuCash supports whatever OS versions their respective
> vendors support. So if you're using anything EOL (even in between
> supported versions) you're on your own. If you can't upgrade to a
> supported OS, a Flatpak is now provided should you also need/want a
> newer GnuCash version than whatever is in your OS repos.
>
> Regards,
> Adrien
>
> On 8/6/22 8:07 AM, Robert Simmons wrote:
> > First of all, Impish is already EOL.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Change account in Transfer column - how?

[david whiting]

Yes, I seem to recall having an issue like that a while ago with an
older version, and it might have been version 4.4, but it has been
fixed for quite some time now. Chris, could you upgrade to a more
recent version? At the very least you should be able to test this by
installing the flatpak version. See this page
https://wiki.gnucash.org/wiki/Flatpak and go down to the section
called "Regular releases at flathub.org".

David W

On Tue, 3 May 2022 at 16:01, David Carlson  wrote:
>
> Sometime in the 4.x series of releases a new method of auto filling the
> account name was introduced where you just start typing part of the account
> name and when your text matches existing text it is supposed to autofill
> the name.  I think that was supposed to leave the old drop down list from
> typing letters and colons method in place. I do not have a release recent
> enough to test that, but there could be a bug, perhaps, if you happen to
> use certain special characters or an unusual font or character set.
>
> On Tue, May 3, 2022, 9:42 AM Chris Green  wrote:
>
> > On Tue, May 03, 2022 at 02:24:52PM +, Gyle McCollam wrote:
> > >Chris,
> > >
> > >Yes, you can.  On my GnuCash, if you click on the "^" (actually it
> > >points down) you get the chart of accounts from which you can choose a
> > >different account.  It's worked that way as long as I can remember,
> > but
> > >I will say that I am using windows 11 and GnuCash 4.10.
> > >
> > I thought so, it's a bug that I have reported before (27 Nov 2021).
> > When I click on the arrow-up or arrow-down nothing happens.
> >
> > My original problem (in November 2021) was that I didn't get the list
> > of accounts to select from when entering a new tranaction:-
> >
> > I've probably doing something silly somewhere but I can't spot what it
> > is at the moment.
> >
> > While entering transactions into GnuCash today it sometimes offers no
> > account in the 'Transfer' column so anything I do ends up in an
> > 'Imbalance' account.
> >
> > The up arrow and down arrow do nothing when it's in this state.
> >
> > The issue comes and goes and I can't see any pattern to it, I've never
> > seen this problem before though.
> >
> > I'm running GnuCash version 4.4 on xubuntu Linux version 21.10.
> >
> >
> >
> > What I am seeing now is essentially the same problem, the drop-down
> > list (or up) of accounts doesn't appear.
> >
> >
> > --
> > Chris Green
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reinstall GnuCash after Ubuntu upgrade to 22.04

[david whiting]

You have at least three options:

1) Install version 4.8a that ships with Ubuntu 22.04: sudo apt install gnucash

2) Use flatpack, this will get you a more recent version. See
https://wiki.gnucash.org/wiki/Flatpak

3) Build it yourself, and get 4.9 or the maintenance release (or other
releases). See 
https://wiki.gnucash.org/wiki/Building_On_Ubuntu#Build_Instructions

David

On Sun, 24 Apr 2022 at 17:59, Steve Cohen  wrote:
>
> I just upgraded my system to Ubuntu 22.04 (from 21.10). As a non-official
> application, GNUcash seems to have been removed from the system or rendered
> non-functional though a launch icon remains and does nothing.  Prior to
> install, I was running GNC 4.9.
>
> Can someone please point me in the right direction for building or
> installing the best version of GNUcash on my new system?
>
> Thanks.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

[david whiting]

Hi Jeff,

If you installed gnucash for a single user, then the icon file will be
at the path I showed in the previous email (but you'll have to change
the login name to yours):

/home/david/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico

If you installed gnucash as a system application for all users, then
you will find the icon file here:

/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico

For the exec line, you might want to put the full path to the gnucash file, e.g.

Exec=flatpak run org.gnucash.GnuCash /home/jeff/Documents/test-2.gnucash

So, with a *system* installation and assuming that your login is jeff,
then the desktop file might look like this:

[Desktop Entry]
Type=Application
Terminal=false
Exec=flatpak run org.gnucash.GnuCash /home/jeff/Documents/test-2.gnucash
Name=GnuCash 4.9 FLATPAK test-2
Comment=Manage home and small business accounts
Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico

(Note that the lines may be wrapped, if so, you'll need to unwrap them)

Remember to right-click on the file on the desktop and choose "Allow launching".

David

On Sat, 26 Mar 2022 at 08:25, Jeff  wrote:
>
>
> I tried this but I cannot locate the actual GNC icon file.  I do have
> one where I attempted, unsuccessfully, to build GNC 4.9 from source.
>
> I changed the path to the icon in the build directory.  And gave the
> exec the path to one of my .gnucash files but the desktop link still
> refuses to work.
>
>
> --
> --JEffrey Black M.B.A.
>
>
>
> On 3/25/22 3:45 AM, david whiting wrote:
> > Hi Jeff,
> >
> > The following works for me, with gnucash installed for a user:
> >
> > 1. Create a desktop file (using a text editor) with the entry shown below
> > 2. On the Exec line, change Documents/test-2.gnucash to the path to
> > your gnucash file
> > 3. On the Name line, change this to whatever you want to call it, i.e.
> > what you want to see on the desktop
> > 4. Change the path for the icon to the correct location (perhaps
> > changing /home/david to /home/jeff)
> > 5. Save the file as whatever-you-want-to-call-it.desktop
> > 6. Go to your desktop
> > 7. Right-click on the file on the desktop and select "Allow launching"
> > (this step is important)
> > 8. Repeat this process for other files, changing the Exec line and
> > Name lines accordingly
> >
> >
> > [Desktop Entry]
> > Type=Application
> > Terminal=false
> > Exec=flatpak run org.gnucash.GnuCash Documents/test-2.gnucash
> > Name=GnuCash 4.9 FLATPAK test-2
> > Comment=Manage home and small business accounts
> > Icon=/home/david/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico
> >
> >
> > David
> >
> >
> > On Fri, 25 Mar 2022 at 07:38, Jeff  wrote:
> >> I have never had a problem creating desktop icons for multiple books for
> >> GNC on Ubuntu 20.04 LTS prior to installing the FlatPak version for GNC 
> >> 4.9.
> >>
> >> Everything I have tried for the desktop icon has failed miserably on the
> >> Flatpak version of GNC 4.9.  Is there someone who can guide me on
> >> creating the desktop icons for this version on Ubuntu version 20.04
> >> LTS.  I have multiple sets of books to maintain for family members.
> >>
> >> --
> >> --JEffrey Black M.B.A.
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see 
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> >
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

[david whiting]

Hi Jeff,

The following works for me, with gnucash installed for a user:

1. Create a desktop file (using a text editor) with the entry shown below
2. On the Exec line, change Documents/test-2.gnucash to the path to
your gnucash file
3. On the Name line, change this to whatever you want to call it, i.e.
what you want to see on the desktop
4. Change the path for the icon to the correct location (perhaps
changing /home/david to /home/jeff)
5. Save the file as whatever-you-want-to-call-it.desktop
6. Go to your desktop
7. Right-click on the file on the desktop and select "Allow launching"
(this step is important)
8. Repeat this process for other files, changing the Exec line and
Name lines accordingly


[Desktop Entry]
Type=Application
Terminal=false
Exec=flatpak run org.gnucash.GnuCash Documents/test-2.gnucash
Name=GnuCash 4.9 FLATPAK test-2
Comment=Manage home and small business accounts
Icon=/home/david/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico


David


On Fri, 25 Mar 2022 at 07:38, Jeff  wrote:
>
> I have never had a problem creating desktop icons for multiple books for
> GNC on Ubuntu 20.04 LTS prior to installing the FlatPak version for GNC 4.9.
>
> Everything I have tried for the desktop icon has failed miserably on the
> Flatpak version of GNC 4.9.  Is there someone who can guide me on
> creating the desktop icons for this version on Ubuntu version 20.04
> LTS.  I have multiple sets of books to maintain for family members.
>
> --
> --JEffrey Black M.B.A.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS

[david whiting]

On Mon, 10 Jan 2022 at 04:40, Jeff  wrote:
>
> On 1/9/22 2:28 AM, david whiting wrote:
> > On Sun, 9 Jan 2022 at 07:57, Jeff  wrote:
> > [...]
> >> I however; cannot find a new PPA or solution to, when doing sudo apt-get
> >> update :
> >>
> >> Err:1 http://Community-maintained free InRelease
> >> Temporary failure resolving 'Community-maintained'
> >>
> >> -snip
> >>
> >> W: Failed to fetch http://Community-maintained/dists/free/InRelease
> >> Temporary failure resolving 'Community-maintained'
> >> W: Some index files failed to download. They have been ignored, or old
> >> ones used instead.
> >>
> > That URL can't be right. It suggests that you have added something to
> > your list of apt sources incorrectly in the past. Please can you post
> > the *full* output when you run the following in the terminal. This
> > should show where that incorrect entry is:
> >
> > sudo grep -rE ^deb /etc/apt/sources.list*
> >
> > David
> > .
>
> As per your request David see the attached txt file.
>
> --
> --JEffrey Black M.B.A.
>

Thanks. You will see at lines 13 and 14 the URL
http://Community-maintained and see that these lines are in the file
/etc/apt/sources.list. If you comment out the two lines in
/etc/apt/sources.list that have that URL and then run sudo apt update
this error will disappear. However, I note your next reply to David
Cousens about resetting your repositories and David's reply to that,
and that covers this and more, so at this point this branch in the
conversation probably ends here.

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS

[david whiting]

On Sun, 9 Jan 2022 at 07:57, Jeff  wrote:
>
[...]
>
> I however; cannot find a new PPA or solution to, when doing sudo apt-get
> update :
>
> Err:1 http://Community-maintained free InRelease
>Temporary failure resolving 'Community-maintained'
>
> -snip
>
> W: Failed to fetch http://Community-maintained/dists/free/InRelease
> Temporary failure resolving 'Community-maintained'
> W: Some index files failed to download. They have been ignored, or old
> ones used instead.
>

That URL can't be right. It suggests that you have added something to
your list of apt sources incorrectly in the past. Please can you post
the *full* output when you run the following in the terminal. This
should show where that incorrect entry is:

sudo grep -rE ^deb /etc/apt/sources.list*

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS

[david whiting]

On Sat, 8 Jan 2022 at 07:33, Jeff  wrote:
[...]

> Not sure if any of this is related or not to unsuccessful builds.  Side note: 
> your shell runs and completes but; now I'll be flipped if I can find where it 
> puts the executable now. Directory /opt is empty.

If it built and you used the defaults in the script, then it will be
in ~/Documents/gnucash/build/bin. Change to that directory and try
running it from there:

cd ~/Documents/gnucash/build/bin
./gnucash

If that works, but it isn't in /opt/ then change to the build
directory and run make install:

cd ~/Documents/gnucash/build/
sudo make install

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Build scripts for ubuntu added to the wiki

[david whiting]

Apologies, yes, that was sloppiness on my part. I was so focussed on
making sure that the scripts would reliably build on different
releases of ubuntu, I didn't add the last line to actually install it.
I rectified that in the scripts on the wiki. Note that in future to
build and install newer versions, you won't need to run the whole
script because the dependencies will already be there, and rather than
git clone, you will want to git pull. I'll add another script for that
to the wiki.

David

On Mon, 27 Dec 2021 at 01:10, David H  wrote:
>
> Thanks for your scripts David,
>
> I thought I'd give building on Ubuntu a shot using your scripts from a couple 
> of days ago as I usually just use the Flatpak version on linux and have never 
> built anything on linux :-)  I just entered each command one after another in 
> a terminal window so I could see what was happening which seemed to work ok 
> but looking at the build dir it built gnucash ok but never installed it.  I 
> noticed the "sudo make install" in your published versions on the wiki this 
> morning and went back into the build dir and ran the "sudo make install" and 
> it installed ok in /opt/gnucash.  I'm assuming from this I need to add the 
> "sudo make install" to the script for it to build and install in future?
>
> Cheers David H.
>
>
> On Mon, 27 Dec 2021 at 08:36, david whiting  wrote:
>>
>> I've added scripts for building gnucash in Ubuntu 20.04 LTS and 21.10
>> to the wiki https://wiki.gnucash.org/wiki/Building_On_Linux in the
>> section at the end called Distribution Specific Issues, which seemed
>> to fit in with what was already there. Let me know if you think it
>> should go elsewhere.
>>
>> I have decided to put in the whole script for each version of ubuntu,
>> even though they are very similar to make it easier for people to just
>> copy the whole script.
>>
>> David
>> --
>> David Whiting
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Build scripts for ubuntu added to the wiki

[david whiting]

Yes, git pull updates what you already have. There's a lot to git and
it can quickly become confusing, but to just build gnucash you don't
really need to know much about it. In simple terms, it is a database
that records changes to files/code. Making an analogy to gnucash, each
git commit is like a transaction. When you git clone you are getting a
copy of all of the transactions at that point in time; when you git
pull you download any new transactions; and git checkout takes you to
a certain point in the transactions (so you can see the "balance" of
the code at that point). This analogy will probably break very
quickly, so I won't go any further!

I'm glad you were able to build it OK.

David

On Mon, 27 Dec 2021 at 09:57, David H  wrote:
>
> David,
>
> Thanks for the heads up on the git pull, I guess that just updates what I've 
> already got?  Git is all new to me as well so I'll have to do some reading up 
> on it and I'll keep an eye out on the wiki for the details.
>
> Thanks again for doing this, it's actually nudged me enough to try building 
> something on linux which seems to have gone OK !!!
>
> Cheers David H.
>
>
> On Mon, 27 Dec 2021 at 18:18, david whiting  wrote:
>>
>> Apologies, yes, that was sloppiness on my part. I was so focussed on
>> making sure that the scripts would reliably build on different
>> releases of ubuntu, I didn't add the last line to actually install it.
>> I rectified that in the scripts on the wiki. Note that in future to
>> build and install newer versions, you won't need to run the whole
>> script because the dependencies will already be there, and rather than
>> git clone, you will want to git pull. I'll add another script for that
>> to the wiki.
>>
>> David
>>
>> On Mon, 27 Dec 2021 at 01:10, David H  wrote:
>> >
>> > Thanks for your scripts David,
>> >
>> > I thought I'd give building on Ubuntu a shot using your scripts from a 
>> > couple of days ago as I usually just use the Flatpak version on linux and 
>> > have never built anything on linux :-)  I just entered each command one 
>> > after another in a terminal window so I could see what was happening which 
>> > seemed to work ok but looking at the build dir it built gnucash ok but 
>> > never installed it.  I noticed the "sudo make install" in your published 
>> > versions on the wiki this morning and went back into the build dir and ran 
>> > the "sudo make install" and it installed ok in /opt/gnucash.  I'm assuming 
>> > from this I need to add the "sudo make install" to the script for it to 
>> > build and install in future?
>> >
>> > Cheers David H.
>> >
>> >
>> > On Mon, 27 Dec 2021 at 08:36, david whiting  
>> > wrote:
>> >>
>> >> I've added scripts for building gnucash in Ubuntu 20.04 LTS and 21.10
>> >> to the wiki https://wiki.gnucash.org/wiki/Building_On_Linux in the
>> >> section at the end called Distribution Specific Issues, which seemed
>> >> to fit in with what was already there. Let me know if you think it
>> >> should go elsewhere.
>> >>
>> >> I have decided to put in the whole script for each version of ubuntu,
>> >> even though they are very similar to make it easier for people to just
>> >> copy the whole script.
>> >>
>> >> David
>> >> --
>> >> David Whiting
>> >> ___________
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> To update your subscription preferences or to unsubscribe:
>> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >> If you are using Nabble or Gmane, please see 
>> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> >> -
>> >> Please remember to CC this list on all your replies.
>> >> You can do this by using Reply-To-List or Reply-All.
>>
>>
>>
>> --
>> David Whiting



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Build scripts for ubuntu added to the wiki

[david whiting]

I've added scripts for building gnucash in Ubuntu 20.04 LTS and 21.10
to the wiki https://wiki.gnucash.org/wiki/Building_On_Linux in the
section at the end called Distribution Specific Issues, which seemed
to fit in with what was already there. Let me know if you think it
should go elsewhere.

I have decided to put in the whole script for each version of ubuntu,
even though they are very similar to make it easier for people to just
copy the whole script.

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] how to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts

[david whiting]

On Fri, 24 Dec 2021 at 17:07, Stephen M. Butler
 wrote:

[...]

> I am on Ubuntu 21.10 and have been lagging way behind.  So tried this
> morning.  All was well until the libboost portion.
>
> *sudo apt -y update **
> **sudo apt -y upgrade **
> **sudo apt -y install git **
> **sudo apt -y build-dep gnucash *
>
[...]
>
> *sudo apt -y install libboost-program-options1.71-dev *
> Reading package lists... Done
> Building dependency tree... Done
> Reading state information... Done
> Package libboost-program-options1.71-dev is not available, but is
> referred to by another package.
> This may mean that the package is missing, has been obsoleted, or
> is only available from another source
>
> E: Package 'libboost-program-options1.71-dev' has no installation candidate

The previous script was to build on 20.04. You don't need to install
it if you are using Ubuntu 21.10. I have just built gnucash on a fresh
installation of Ubuntu 21.10 with the following script. Again, make
sure you check the "Source Code" box in "Software and Updates".
When I get around to it I want to add each script to the wiki so it is
clear what is needed for each recent version.

=== build.sh ===

## Ubuntu 21.10
## In "Software and Updates":
## Tick "Source code"
## Tick "Community-maintained free and open-source software (Universe)"

## Change this if you want to build it somewhere else.
SOURCEDIR="$HOME/Documents/gnucash/source"
BUILDDIR="$HOME/Documents/gnucash/build"

INSTALLDIR=/opt/gnucash

sudo apt -y update
sudo apt -y upgrade
sudo apt -y build-dep gnucash
sudo apt -y install git

mkdir -p $SOURCEDIR
mkdir -p $BUILDDIR

## Clone gnucash source from git, if it is not already there
git clone https://github.com/Gnucash/gnucash.git $SOURCEDIR

## Checkout version 4.9
cd $SOURCEDIR
git checkout -b 4.9 4.9

cd $BUILDDIR
cmake -DCMAKE_INSTALL_PREFIX=$INSTALLDIR $SOURCEDIR

make

=== End of build.sh ===

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] how to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts

[david whiting]

On Fri, 24 Dec 2021 at 09:11, Jeff  wrote:

[...]
> But it appears I am not even a day old computer programmer, after 40
> plus years of coding.  For the life of me I cannot get the 4.9 code and
> tools for Ubuntu to install.  I've followed every link I can find, even
> those that David Cousins provided and I still cannot get the source or
> dependencies to install or download.
>
> Would someone please list for me in baby steps howto download and build
> GNC 4.9 for Ubuntu?
>

Hi Jeff,

The script below will build version 4.9 on Ubuntu 20.04 LTS. I have
verified this on a clean installation of Ubuntu.
One thing that tripped me up a few times is remembering to tick
"Source Code" in the Software And Updates dialogue. If you don't do
this, it will fail.
Please note that I have used -y with apt install so it will install
and build without asking.

I will try to get around to putting this in the wiki to make it easier
for people to find.

=== build.sh ===

## Ubuntu 20.04
## In "Software and Updates":
## Tick "Source code"
## Tick "Community-maintained free and open-source software (Universe)"

## Change this if you want to build it somewhere else.
SOURCEDIR="$HOME/Documents/gnucash/source"
BUILDDIR="$HOME/Documents/gnucash/build"

## Change this if you want to install it somewhere else.
INSTALLDIR=/opt/gnucash

sudo apt -y update
sudo apt -y upgrade
sudo apt -y install git
sudo apt -y build-dep gnucash

## To build series 4 of gnucash on Ubuntu 20.04
sudo apt -y install libboost-program-options1.71-dev

mkdir -p $SOURCEDIR
mkdir -p $BUILDDIR

## Clone gnucash source from git
git clone https://github.com/Gnucash/gnucash.git $SOURCEDIR

## Checkout version 4.9
cd $SOURCEDIR
git checkout -b 4.9 4.9

cd $BUILDDIR
cmake -DCMAKE_INSTALL_PREFIX=$INSTALLDIR $SOURCEDIR

make

=== End of build.sh ===

Fingers-crossed this will work for you.


David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Newest version for Ubuntu 20.04 LTS

[david whiting]

Hi Brad,

Once you have the sources you can use git to checkout any previous
version you want. To see the tagged versions, in a terminal type:

git tag

The last 10 lines show:

4.2-post-string-freeze
4.3
4.3-string-freeze
4.4
4.5
4.6
4.7
4.8
4.8a
gnucash-1-9-0

So, if you want version 4.8a, you can do:

git checkout -b 4.8a 4.8a

This will checkout the version tagged 4.8a, and create a new branch
called 4.8a. Once you have that, you can just change to the build
directory and run the cmake and make commands. I have selected 4.8a,
if you want version 4.8 instead, just use 4.8 instead of 4.8a in the
git checkout. Note, once you have the source code, you don't need to
run the whole script again to get a new version. When there is a new
release, e.g. 4.9 or 5.0, or 5.1, or whatever, you can just:

git checkout maint
git pull

to get the latest commits, then:

git checkout -b 5.0 5.0

(for example) to get that version.

Here is the script again, with the git checkout command added (near the end):

 build-gnucash.sh  

## Change this if you want to build it somewhere else.
SOURCEDIR="$HOME/Documents/gnucash/source"
BUILDDIR="$HOME/Documents/gnucash/build"

sudo apt update
sudo apt upgrade

sudo apt-get install build-essential
## This is one long line
sudo apt install git make cmake libglib2.0-dev libxml2-dev
libxslt1-dev libwebkit2gtk-4.0-dev gettext swig guile-3.0-dev
libofx-dev xsltproc libboost-all-dev libdbi1 libdbi-dev libdbd-sqlite3
libsecret-1-0 libsecret-1-dev aqbanking-tools libaqbanking-dev
gwenhywfar-tools libgwengui-gtk3-dev

# Only use the next 2 lines if you have not installed [[Google_Test |
Google Test]] already.
sudo apt install libgtest-dev# >=1.7.0
sudo apt install google-mock # 1.8.0 installs
googlemock in a subdirectory of gtest

mkdir -p $SOURCEDIR
mkdir -p $BUILDDIR

## Clone gnucash source from git, if it is not already there
[ ! -d $SOURCEDIR/gnucash ] && git clone
https://github.com/Gnucash/gnucash.git $SOURCEDIR

## Checkout version 4.8a
git checkout -b 4.8a 4.8a

cd $BUILDDIR
cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt/gnucash $SOURCEDIR

make

 end of script 


David

On Thu, 18 Nov 2021 at 22:07, brad  wrote:
>
> David,  Will your script build the latest stable release?  If not what
> do I change to do that?
>
> On 10/2/21 11:48 AM, david whiting wrote:
> > Hi Jeff,
> >
> > On Wed, 29 Sept 2021 at 07:11, Jeff  wrote:
> > [...]
> >> I would settle for a copy of "Building the Newest Version of GNC for
> >> Dummies Course" book.
> > Others have shown you that you can use flatpak to get the latest
> > version, but if you do want to build from source I have found that the
> > following works on Ubuntu 20.04. I have also attached it as a script.
> > This clones the source from git and by default builds the maintenance
> > version. The versions are tagged, so you can use git to checkout a
> > different version and build that if you want, e.g. you could build 4.8
> > rather than maint.
> >
> >  build-gnucash.sh  
> >
> > ## Change this if you want to build it somewhere else.
> > SOURCEDIR="$HOME/Documents/gnucash/source"
> > BUILDDIR="$HOME/Documents/gnucash/build"
> >
> > sudo apt update
> > sudo apt upgrade
> >
> > sudo apt-get install build-essential
> > ## This is one long line
> > sudo apt install git make cmake libglib2.0-dev libxml2-dev
> > libxslt1-dev libwebkit2gtk-4.0-dev gettext swig guile-3.0-dev
> > libofx-dev xsltproc libboost-all-dev libdbi1 libdbi-dev libdbd-sqlite3
> > libsecret-1-0 libsecret-1-dev aqbanking-tools libaqbanking-dev
> > gwenhywfar-tools libgwengui-gtk3-dev
> >
> > # Only use the next 2 lines if you have not installed [[Google_Test |
> > Google Test]] already.
> > sudo apt install libgtest-dev# >=1.7.0
> > sudo apt install google-mock # 1.8.0 installs
> > googlemock in a subdirectory of gtest
> >
> > mkdir -p $SOURCEDIR
> > mkdir -p $BUILDDIR
> >
> > ## Clone gnucash source from git, if it is not already there
> > [ ! -d $SOURCEDIR/gnucash ] && git clone
> > https://github.com/Gnucash/gnucash.git $SOURCEDIR
> >
> > cd $BUILDDIR
> > cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt/gnucash $SOURCEDIR
> >
> > make
> >
> >  end of script 
> >
> > David
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> &g

Re: [GNC] difficulties with managing accounts with lots of split transactions

[david whiting]

I've set up hotkeys for the different views that gnucash has and I
find it helpful for this sort of thing. It allows me to quickly switch
between different views.

ctrl+1: basic view
ctrl+2: auto-split view (all splits for current transaction)
ctrl+3: transaction journal view (all splits for all transactions)
ctrl+4: toggle double line view (to see transaction notes)

Here's how to set it up:
https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092757.html

David

On Sun, 7 Nov 2021 at 12:09, Platon Pronko  wrote:
>
> Hi!
>
> I currently find it a bit difficult to handle multi-split transactions that 
> include several "splits" going to the same account. For example, if I'm 
> buying some computer hardware I want to record the prices of each part for 
> later reference, but all those parts are recorded in "Hardware" account - 
> thus several splits go into the same account.
>
> In default "Basic Ledger" view this is shown in a confusing way - each split 
> gets its own row, but each row displays the same transaction description (not 
> the name of the individual part).
>
> For the moment I explored several different solutions to this situation:
>
> 1. Record each item (hardware part in this example) as a separate 
> transaction. This solves the issue with display since I can now put each item 
> name into the description field. But now I have multiple transactions my 
> credit card account, which would make reliable reconciliation almost 
> impossible.
>
> 2. Use the "Transaction Journal" view. It handles this situation a bit better 
> than "Basic Ledger" - the rows are not duplicated. But it show all the 
> splits, even the ones not related to the currently viewed account, and the 
> simple two-split transactions start taking 3 rows each, which is too verbose, 
> especially since this is a global setting.
>
> 3. Show "memo" as a separate column in "Basic Ledger" view (I've attached the 
> code patch that does it, applies to version 4.8). This works quite nicely - 
> simple transactions keep using one row, complex transactions display only the 
> splits related to the current register and each split shows its memo right in 
> the register. However this is a code customization, won't help anybody else 
> with similar problems, and maintaining it is going to be more difficult than 
> built-in solutions.
>
> Do you have any suggestions about a better way of handling this?
>
> Best regards,
> Platon Pronko___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Searching issues

[david whiting]

I would add that the new search is really, really good. I have over
1,000 accounts and it is a breeze to get the account I want.

David

On Sun, 3 Oct 2021 at 15:29, David Carlson  wrote:
>
> I am using release 3.8 in Linux and the behavior in the account box is
> still the same as it has been for years.  You need to enter characters
> matching existing entries in the COA.
>
> The changed search behavior is more recent,  iirc that started in release
> 4.something.
>
> On Sun, Oct 3, 2021, 9:01 AM Mike via gnucash-user 
> wrote:
>
> > I'm using GNC v3.8 on Linux Mint 20.2. Until recently while entering a
> > transaction as I began typing in the account field GNC would begin
> > searching for the matching entry. For instance when I began typing
> > sal... the entries with sal in them (sales:tax) would appear and I could
> > click on the entry I wanted. That no longer happens and I cannot find a
> > setting to correct it. Any ideas on how to get this back?
> >
> > Mike
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Newest version for Ubuntu 20.04 LTS

[david whiting]

Create a desktop file on the desktop. To do this, open a text editor,
e.g. gedit, and paste the following into a file and save it on your
desktop with the name gnucash-maint.desktop (example file attached):

=== gnucash-maint.desktop ===

[Desktop Entry]
Type=Application
Terminal=false
Exec=/home/jeff/Documents/gnucash/build/bin/gnucash
Name=GnuCash (maint)
Comment=Manage home and small business accounts
Icon=/home/jeff/Documents/gnucash/build/share/gnucash/pixmaps/gnucash-icon.ico

=== End of gnucash-maint.desktop ===

Note that:

1) I am guessing your username and am assuming that you have used the
paths in the bash script. Change the Exec and Icon lines accordingly
if your username is different.
2) I am assuming here you want to run it from the build folder. If you
run make install after building it, you will find it in
/home/jeff/opt/gnucash/bin/gnucash and can use that path instead in
the Exec and Icon lines (assuming your home is /home/jeff)

Once you have saved the file on your desktop, right click it and
select "Allow launching". You should now see the GnuCash icon with the
name "GnuCash (maint)" and should be able to use it to launch gnucash.
Going forward, if you want to keep up with the maintenance release,
and ultimately the next release, you can just git pull in the source
folder and build it again.

David

On Sun, 3 Oct 2021 at 05:25, Jeff  wrote:
>
> On 9/29/21 6:48 AM, Jon Schewe wrote:
> > If you install from flatpak you will get the current version. However
> > note that there is currently a bug with 4.7 that prevents it from
> > opening, so you may want to wait on that.
> >
> > sudo apt install flatpak
> > sudo flatpak install org.gnucash.GnuCash
> >
> > flatpak run org.gnucash.GnuCash
> >
> > On Wed, 2021-09-29 at 01:10 -0500, Jeff wrote:
> >> Short of building from source, is there a link anywhere for upgrading
> >> from 4.2 to the next compatible stable version on Ubuntu 20.04 LTS?  The
> >> Debian list is too far behind since I run multiple O.S.'s.  I tried the
> >> suggested PPA, I think it was sicklylife something or other for 4.3.
> >> Totally screwed up a test set of books that I use just to test new
> >> versions before I turn it loose on my multiple sets of books for
> >> family.  It would be nice to run the same working versions on my Ubuntu
> >> Server (Micro$soft bricked my main server and had to replace it, so I am
> >> migrating everything I can to Ubuntu) and my dual boot laptop.
> >>
> >> I have tried several times to build from source but; I am too old school
> >> on my programming language list (i.e. Cobol, Pascal, forth) to get a
> >> build to work.  Every time I have tried it spits out in a foreign
> >> language some error list and fails to build.  My bad.
> >>
> >> You would think that someone who wrote over 100,000 lines of C++ code to
> >> handle up to 2 billion inventory items for a POS and parts ordering
> >> system at best cost could easily handle this, but the languages you use
> >> are all too new to me.
> >>
> >> I would settle for a copy of "Building the Newest Version of GNC for
> >> Dummies Course" book.
> >>
> > .
>
> So how do I get this to launch from a desktop icon like I had 4.2
> doing?  On Ubuntu. The desktop link still does 4.2 but the command line
> you listed does 4.8.
>
>
> --
> --JEffrey Black M.B.A.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting


gnucash-maint.desktop
Description: application/desktop
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Newest version for Ubuntu 20.04 LTS

[david whiting]

Hi Jeff,

On Wed, 29 Sept 2021 at 07:11, Jeff  wrote:
[...]
> I would settle for a copy of "Building the Newest Version of GNC for
> Dummies Course" book.

Others have shown you that you can use flatpak to get the latest
version, but if you do want to build from source I have found that the
following works on Ubuntu 20.04. I have also attached it as a script.
This clones the source from git and by default builds the maintenance
version. The versions are tagged, so you can use git to checkout a
different version and build that if you want, e.g. you could build 4.8
rather than maint.

 build-gnucash.sh  

## Change this if you want to build it somewhere else.
SOURCEDIR="$HOME/Documents/gnucash/source"
BUILDDIR="$HOME/Documents/gnucash/build"

sudo apt update
sudo apt upgrade

sudo apt-get install build-essential
## This is one long line
sudo apt install git make cmake libglib2.0-dev libxml2-dev
libxslt1-dev libwebkit2gtk-4.0-dev gettext swig guile-3.0-dev
libofx-dev xsltproc libboost-all-dev libdbi1 libdbi-dev libdbd-sqlite3
libsecret-1-0 libsecret-1-dev aqbanking-tools libaqbanking-dev
gwenhywfar-tools libgwengui-gtk3-dev

# Only use the next 2 lines if you have not installed [[Google_Test |
Google Test]] already.
sudo apt install libgtest-dev# >=1.7.0
sudo apt install google-mock # 1.8.0 installs
googlemock in a subdirectory of gtest

mkdir -p $SOURCEDIR
mkdir -p $BUILDDIR

## Clone gnucash source from git, if it is not already there
[ ! -d $SOURCEDIR/gnucash ] && git clone
https://github.com/Gnucash/gnucash.git $SOURCEDIR

cd $BUILDDIR
cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt/gnucash $SOURCEDIR

make

 end of script 

David


build-gnucash.sh
Description: application/shellscript
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Sorting client list

[david whiting]

In gnucash 4.6 you can click on the Customer Number heading to sort by
number. I think this has been around for a while so it should work on
the version you are using, too.

David

On Sat, 11 Sept 2021 at 14:36, Rich Shepard  wrote:
>
> I'm running gnucash-3.11-x86_64-1_SBo on Slackware-14.2/x86_64.
>
> Looking at Business -> Customer -> Customer Overview I can see a list of
> clients. I've put the client number at the left, followed by the client
> name. The list is in random order.
>
> Is there a way for me to order the list by ascending client number?
>
> TIA,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] One Job - Many Customers

[david whiting]

Hi Nora,

Do you need to be able to produce invoices to send to the students, or
is your main concern tracking how much each student owes and has paid?
If you don't need to produce invoices I think you could do this by
setting up each student as an asset account and have each course as an
income account. You would then have transactions from the course to
the student to charge them fees for the course. This then allows you
to see how much each student owes (their account balance) and how much
each course has/will generate. Then when they make payments you will
have transactions from your bank account (assuming they are paying
into your bank account) to the relevant student account.

You can create student accounts by importing a csv file of accounts,
then create the fees transactions again by importing a csv file of
transactions, and finally import your bank transactions. If they use a
consistent reference for the transaction the importer will learn which
account the transactions need to go to and the process can therefore
be quite quick.

David

On Thu, 2 Sept 2021 at 18:44, Derek Atkins  wrote:
>
> Hi,
>
> I'm afraid a Job is really misnamed -- it's really a "Puchase Order" -- a
> way to link multiple Invoices.
>
> GnuCash's invoicing system really doesn't do what you are asking for.
>
> -derek
>
> On Thu, September 2, 2021 1:31 pm, Nora wrote:
> > Hi User Group,
> >
> >
> >
> > I've just joined and set up my chart of accounts and am ready to process
> > jobs and customers etc.
> >
> > Currently you can have one customer to many jobs, But I want one job to
> > many
> > customers.
> >
> >
> >
> > My question:
> >
> > I run many different classes/programs/courses, each with several
> > students/customers attending.
> >
> > How do I set up the one  "program"/job  and then invoice or associate all
> > the customers to that "program/job"?
> >
> >
> >
> > When I used quick books - I had one invoice to represent the program
> > associated to an income account, and just typed the names in a description
> > field of the payees/attendees. The individual payments reduced the
> > invoice,
> > and I used the memo field to list who made the payment.  I want to get
> > away
> > from this as each person is only listed in the memo field and I can't
> > easily
> > reconcile with the bank by name.
> >
> >
> >
> > Thanks so much for your help!
> >
> > Nora
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Nora Zylstra-Savage
> >
> >
> >
> >
> >
> > Capturing Stories & Connecting Generations
> >
> > Writing Coach, Workshops & Content Editing
> >
> > www.story-lines.ca
> >
> > 519-853-1187
> >
> >
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com     www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Search/report by description

[david whiting]

The query I showed in the previous email will show you what you paid for
whatsits, and this code will show you what you charged for dinguses,
limiting to a customer called Mycustomer

SELECT invoices.date_posted, invoices.id, invoices.notes,
  customers.name AS customer,
  description, quantity_num, quantity_denom, i_price_num, i_price_denom,
  quantity_num / CAST(quantity_denom AS FLOAT) AS quantity,
  i_price_num / CAST(i_price_denom AS FLOAT) AS price
  FROM entries
  LEFT JOIN invoices ON entries.invoice = invoices.guid
  LEFT JOIN customers ON invoices.owner_guid = customers.guid
  WHERE description LIKE '%dingus%'
  AND customers.name LIKE '%mycustomer%'

David


On Wed, 25 Aug 2021 at 23:17, david whiting  wrote:

> While you can't do this directly from gnucash, if you use the sqlite
> backend (or other sql backend) you can write your own queries
> fairly easily. For example, you could save your gnucash file as an sqlite
> file and use sqlitebrowser to view it and write queries
> https://sqlitebrowser.org/dl/ (I'm suggesting sqlitebrowser because it is
> free and available for windows, mac and linux).
>
> This query, for example, will find whatsits:
>
> SELECT invoices.date_posted, invoices.id, invoices.notes,
> description, quantity_num, quantity_denom, b_price_num, b_price_denom,
> quantity_num / CAST(quantity_denom AS FLOAT) AS quantity,
> b_price_num / CAST(b_price_denom AS FLOAT) AS price
> FROM entries
> LEFT JOIN invoices ON entries.bill = invoices.guid
> WHERE description LIKE '%whatsits%'
>
> You can limit the dates posted in WHERE clause. I haven't tried to link to
> customers, but it should be possible.
>
> David
>
>
>
> On Wed, 25 Aug 2021 at 20:06, Derek Atkins  wrote:
>
>> Hi,
>> Sorry, there is no way to search Invoice Line-Item data.
>> Unclear if PieCash can do that or not.
>> -derek
>>
>> On Wed, August 25, 2021 2:51 pm, R. Victor Klassen wrote:
>> > I’m looking for a report or means of searching all bills/invoices for a
>> > specific pattern in the description field of any line.  I would further
>> > like to restrict it (optionally) by date range or customer/vendor.
>> >
>> > For example I might want to know what we paid for whatsits last year and
>> > from whom all we bought them.  They might be a small subset of what went
>> > in the account and they might have wound up in multiple accounts
>> depending
>> > on their intended end use.
>> >
>> > Similarly I might want to know what we charged for dinguses. And there
>> > might have been some that were accounted as greenhouse dinguses, while
>> > others were grown in the field, but just now I want to know what we
>> > charged customer x for them.
>> >
>> > I’m willing to use piecash if necessary but not write scheme.
>> >
>> > Sent from my iPhone
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > If you are using Nabble or Gmane, please see
>> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>>
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
> --
> David Whiting
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Search/report by description

[david whiting]

While you can't do this directly from gnucash, if you use the sqlite
backend (or other sql backend) you can write your own queries
fairly easily. For example, you could save your gnucash file as an sqlite
file and use sqlitebrowser to view it and write queries
https://sqlitebrowser.org/dl/ (I'm suggesting sqlitebrowser because it is
free and available for windows, mac and linux).

This query, for example, will find whatsits:

SELECT invoices.date_posted, invoices.id, invoices.notes,
description, quantity_num, quantity_denom, b_price_num, b_price_denom,
quantity_num / CAST(quantity_denom AS FLOAT) AS quantity,
b_price_num / CAST(b_price_denom AS FLOAT) AS price
FROM entries
LEFT JOIN invoices ON entries.bill = invoices.guid
WHERE description LIKE '%whatsits%'

You can limit the dates posted in WHERE clause. I haven't tried to link to
customers, but it should be possible.

David



On Wed, 25 Aug 2021 at 20:06, Derek Atkins  wrote:

> Hi,
> Sorry, there is no way to search Invoice Line-Item data.
> Unclear if PieCash can do that or not.
> -derek
>
> On Wed, August 25, 2021 2:51 pm, R. Victor Klassen wrote:
> > I’m looking for a report or means of searching all bills/invoices for a
> > specific pattern in the description field of any line.  I would further
> > like to restrict it (optionally) by date range or customer/vendor.
> >
> > For example I might want to know what we paid for whatsits last year and
> > from whom all we bought them.  They might be a small subset of what went
> > in the account and they might have wound up in multiple accounts
> depending
> > on their intended end use.
> >
> > Similarly I might want to know what we charged for dinguses. And there
> > might have been some that were accounted as greenhouse dinguses, while
> > others were grown in the field, but just now I want to know what we
> > charged customer x for them.
> >
> > I’m willing to use piecash if necessary but not write scheme.
> >
> > Sent from my iPhone
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recurring Monthly bills, How to Auto Post... TFN ?

[david whiting]

If you want to use Business -> Vendor Bill for multiple invoices you can
automate part of the process by importing a csv file, see
https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-bills-invoices.html
You would still have to post them, but that would be just two clicks per
invoice.

David

On Fri, 13 Aug 2021 at 19:43, Derek Atkins  wrote:

> Hi,
>
> On Fri, August 13, 2021 2:23 pm, Fran_3 via gnucash-user wrote:
> > Like many we have a number of regular monthly bills.
> > Is there a way to have these bills "auto posted" each month?
>
> This is exactly what the Scheduled Transaction system is for.. Assuming
> you want to just add a "bill payment transaction."  There is no way to
> automate a Business -> Vendor Bill.
>
> > And then have gnu cash add them to the reminders... say on the 1st of
> each
> > month... or what ever appropriate date for the bill?
> > Now, in order to have the bill show up in reminders we are...
> > Manually creating 12 bills for each monthly account with an estimated
> > "due" date and a simple 1-cent balance due.
> > Then when that date approaches the bill shows up in the reminders and we
> > open it, un-post it, change the amount due, and repost it again.
> > Thanks for any help on this.
> > PS - maybe this would be called an auto recurring bill... or whatever.
>
> If you really want a recurring Business -> Vendor Bill, see
> https://bugs.gnucash.org/show_bug.cgi?id=114421
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Liability Transactions to AP/Bills

[david whiting]

Hi Fran,

I import lots of bills and use File -> Import -> Import bills and
Invoices (not transactions). See this help page for details:
https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html
For my purposes I found it useful to create a spreadsheet for entering
details that has a structure that makes sense and then a second sheet
that I named "Export to csv" that has formula that take the values
from the structured form and formats it in the format needed for the
csv import. I then save the invoice in the spreadsheet and do Save As
on the second tab to create the csv file import.

David

On Mon, 14 Sep 2020 at 19:11, Fran_3 via gnucash-user
 wrote:
>
> Note: When I say "Bill" here I mean a Bill from a Vendor to us.
> I'm trying to import a CSV  file to AP and also have it create the 
> corresponding Bill.I have 100+ of these to import else a lot of labor to do 
> it by hand...
>
> So... to experiment I exported the Entities AP register as a CSV file.Then 
> deleted all transactions except one... just to keep it simple.So now I have 3 
> comma separated lines...- Column Title line- Transaction 1 line 1- 
> Transaction 1 line 2
> Now with the AP register still open I click...File > Import > Transactions 
> from a CSV fileI then...- select the file to import- tell the importer to 
> ignore line 1... the Column Title line- tell the importer the date format to 
> use
> Next I start telling the importer the titles of the columns...I leave some 
> column titles set to "none" like...Transaction-ID, Number, 
> Commodity/Currency, Void Reason, to name a fewI do choose titles for these 
> columns to import...Date, Description, Notes, Action, Memo,
>
> Now I'm stuck...The "Exported" sample shows the next four columns titled 
> as...- Full Account Name- Account Name- Amount with Symbol- and Amount Num
> BUT... the importer doesn't offer these column name options...
> My Question: Which Column Name do I choose from the Importer for the above 4 
> lines?
> I don't know, for instance, if the Amount with Symbol and the Amount Num 
> should have their columns named Withdrawal or Deposit... as those titles seem 
> to go with a checking account.
> I also don't know how to make the importer identify the double entry accounts 
> for each imported transaction... like...- Accounts Payable and Utilities... 
> or...- Accounts Payable and Office Supplies... etc
> Thanks for any help.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Short cuts for things

[david whiting]

I often use ctrl+i tab,tab to get to the entry box (it would be nice if it
defaulted to that) and then start typing. This quickly limits to matching
accounts, then it is easy to tab again and hit enter to go to the account.
Written out like this it sounds like a lot of work but in practice I find
it is quick.

David

On Wed, 9 Sep 2020, 19:37 Stan Brown,  wrote:

>
> On 2020-09-09 11:26, David Carlson wrote:
> > Another trick that I accidentally discovered is to hover in the account
> > tab bar then with the mouse wheel you can scroll quickly through the
> > open tabs.. I think down goes right and up goes left, but I have trouble
> > remembering that part when it is so easy to switch directions  I suppose
> > that might change if you put your tab bar on the side anyway.
>
> Presumably, then, up would go up and down would go down. :-)
>
> {pause to check}
>
> Yes, it does (or they do). That particular one isn't my fave because I
> try to do as much as possible on the keyboard, but it's still interesting.
>
> --
> Regards,
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How do I add notes to my columns?

[david whiting]

Not that I am aware of. I have setup a hotkey ctrl+4 to toggle
single/double view and that works quite nicely as it is quick. I now
have four hotkeys for changing register views quickly:

ctrl+1: basic view
ctrl+2: auto-split view (all splits for current transaction)
ctrl+3: transaction journal view (all splits for all transactions)
ctrl+4: toggle double line view (to see transaction notes)

You can use ctrl+4 with any of the other three. This is done by
editing the file accelerator-map and uncommenting and completing the
following lines:

(gtk_accel_path
"/GncPluginPageRegisterActions/ViewStyleDoubleLineAction"
"4")
(gtk_accel_path
"/GncPluginPageRegisterActions/ViewStyleJournalAction"
"3")
(gtk_accel_path
"/GncPluginPageRegisterActions/ViewStyleAutoSplitAction"
"2")
(gtk_accel_path
"/GncPluginPageRegisterActions/ViewStyleBasicAction"
"1")

This file is in ~/.local/share/gnucash on linux and I think it is in
C:\Users\{account name}\AppData\Roaming\GnuCash on Windows (not sure
about Mac).  means ctrl and you'll need to add that plus the
number.

David

On Fri, 21 Aug 2020 at 11:02, ToddAndMargo via gnucash-user
 wrote:
>
> >> On Fri, 21 Aug 2020 at 18:44, ToddAndMargo via gnucash-user
> >> mailto:gnucash-user@gnucash.org>> wrote:
> >>
> >> Hi All,
> >>
> >> gnucash-4.1-1.fc32.x86_64
> >>
> >> I see I can View->Sort by "Notes"
> >>
> >> How do I add a "notes" column to my accounts:
> >>
> >>
> >> Many thanks,
> >> -T
>
> On 2020-08-21 02:04, David H wrote:
> > Turn on Double line mode on the View menu and you'll see it shows up on
> > line 2 for each register transaction.
> >
> > Cheers David H.
>
> Any way to get it in single line mode?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash list: gmane

[david whiting]

You beat me to it! I was going to make the same reference. So here's
my contribution: In 1994 I was in Tanzania working at the main
hospital in the country. To send email I think I used a simple text
client and saved emails to a floppy disk. I would then take them over
to the library where the guy who ran the mailserver would copy them to
the server (a 386 running redhat). We would then wait for the Satelife
satellite to pass overhead. We normally had a 10 minute connection
window and he would have to adjust the dish to get the signal right.
Then there would be an agonising wait as we slowly watched each email
transfer. Then to get a reply I would come back the next day.

David

On Tue, 7 Jul 2020 at 18:26, Fred Bone  wrote:
>
> On 07 July 2020 at 12:09, David Carlson said:
>
> > Using a 300 baud modem, perhaps?  I had a Radio Shack model 100
>
> 
> Oooh, we used to *dream* of having 300 baud. We had to send our data one
> bit at a time using Morse code tapped out on an old drainpipe.
> 
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash - user: Google result

[david whiting]

It they are googling "gnucash forum" as noted in the other thread.

David


On Tue, 7 Jul 2020, 15:14 Frank H. Ellenberger, <
frank.h.ellenber...@gmail.com> wrote:

> Hi,
>
> Am 07.07.20 um 15:36 schrieb Derek Atkins:
> > This has *me* confused.  If you subscribe via any link at
> > https://lists.gnucash.org/ then I do not see how you could get an email
> > that would link to Nabble.  It sounds like you went in via Nabble the
> > first time and tried to "subscribe" via Nabble.
>
> If I google "user list gnucash" (the result depends on the LANGUAGE
> preference list in your browser settings, your google history, ...) I get:
>
> 1. https://wiki.gnucash.org/wiki/Mailing_Lists
> 2. https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 3. https://lists.gnucash.org/mailman/listinfo
>
> 4. http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> 5. http://gnucash.1415818.n4.nabble.com/GnuCash-user-list-td4695094.html
>
> Either some users are ignoring the first results or they get the result
> in a different order.
>
> Regards
> Frank
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Keyboard shortcut (or icon) to jump to COA

[david whiting]

I also find myself frequently wishing for this.

David

On Mon, 1 Jun 2020, 17:13 Art Chimes,  wrote:

> I usually have a dozen or more accounts open, and I frequently need to
> get back to the Chart of Accounts tab. It would be convenient to have
> an icon above the tabs — what is that row of icons called? — that I
> could just click on or a keyboard shortcut to get me instantly to the
> COA tab. In other words, I am looking for the same result as
> right-clicking an open tab and selecting "Accounts" at the top of the
> list, just a little easier, for me anyway.
>
> I searched without success for a solution.
>
> I did look at the accelerator-map file but couldn't find a solution
> there. (There may be one, but I don't know which line to edit, let
> alone how to do so.)
>
> Thanks,
> Art
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Adding Transactions From Another Program

[david whiting]

nvestigated Homebrew vs. MacPorts?
> >>
> >> Just curious if the Perl issues are the same.
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Apr 30, 2020 w18d121, at 12:29 AM, Hal Vaughan  wrote:
> >>>
> >>> I’ve checked out the bindings - as I mentioned in my original post, the 
> >>> problem is that using the bindings on a Mac requires MacPorts.  I’ve had 
> >>> issues before, since MacPorts (and other similar systems) usurp some of 
> >>> the normal paths for things like Perl and Python.  I don’t use Perl for 
> >>> coding anymore, but I have Perl scripts I’ve been using for over a decade 
> >>> that do some simple work for me.  I had an important Perl script I was 
> >>> using that used a specific Perl library.  I don’t remember which one it 
> >>> was, but when I added MacPorts and tried to run my script a week later, 
> >>> it crashed.
> >>>
> >>> I had no idea MacPorts, Fink, Homebrew, and similar systems usurped the 
> >>> normal system paths for scripting languages.  When I installed it, and it 
> >>> took over for Perl, it put in a system without all the libraries my 
> >>> scripts used and some of the libraries that were available to me with a 
> >>> standard Perl install (libraries I had installed from CPAN) would not 
> >>> install in the new system.  I had to completely remove MacPorts to get my 
> >>> old scripts to work.
> >>>
> >>> I’d love to use MacPorts, since it makes a lot available to me that I 
> >>> can’t easily add now (unless I start using a Linux VM), but that 
> >>> experience taught me never to trust such a system.
> >>>
> >>> I think it would be a lot easier for me to do this with Python bindings, 
> >>> but I still use older scripts for things I need to do once a month or 
> >>> once a year and I don’t want to risk breaking them again like they broke 
> >>> about a decade ago when I installed MacPorts.
> >>>
> >>>
> >>> Hal
> >>
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see 
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> 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
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account type by editing XML?

[david whiting]

On Thu, 30 Apr 2020 at 19:59, Adrien Monteleone
 wrote:

[snip]

> Are you experiencing some problems with GnuCash with the current setup? If 
> the reporting otherwise works, it may not be strictly necessary to change it. 
> If you aren’t using the business features at all, I don’t see why the member 
> accounts can’t stay where they are even as 'type' A/R.

I'm using the business features for our bills and have issued a few
invoices to some customers, e.g. some sponsors ask for an invoice. The
main problem I have is that accounts with type RECEIVABLE can't be
selected as an Expense Account when entering invoices; perhaps I
shouldn't even be trying to use an Asset account here, but as well as
handling subs for members I also need to handle 'fines' (misconduct
charges and admin fees) that are levied by the county football
association whenever a player is given a yellow or red card. The club
is invoiced and pays these fines, and then we get the player to
reimburse the club. I enter the invoices from the county FA into
gnucash and want to be able to assign them to the appropriate club
member account. As I can't do this using the invoice dialogue I have
created a spreadsheet for these bills that I then import. This method
allows me to assign the fines to one of the accounts that has type
RECEIVABLE. (You could argue that if it is not possible to do this
through the dialogue then it shouldn't be possible through the
import.) So importing this spreadsheet works, but it means extra work.

> On the editing front, have you tried doing a test edit of the account type to 
> see if something breaks? (on a copy of the file of course)
>

Yes, I have done that and run a few key reports on the before and
after versions and I get the same results, so, fingers-crossed, I
think it has worked OK.

Thanks for your help and that of others who have replied.

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account type by editing XML?

[david whiting]

Assuming I have understood correctly, this still doesn't allow me to
change the account type. See attached screenshot of the Edit Account
dialogue after having moved an account to the top level.

David

On Fri, 1 May 2020 at 17:57, Derek Atkins  wrote:
>
> "Stephen M. Butler"  writes:
>
> > On 4/29/20 11:25 AM, david whiting wrote:
> >> Hello,
> >>
> >> When I first set up my accounts (for a local club) I knew very little
> >> about accounting and misinterpreted some information I was given by an
> >> accountant and ended up creating some sub-accounts in Accounts Receivable.
> >> I now know that was not the correct thing to do, and I should have created
> >> these accounts as straight-forward asset accounts.
> >>
> >> Using gnucash I cannot change the account type for these accounts. When I
> >> use ctrl+e on these accounts I only see account type A/Receivable so I
> >> cannot change them through the GUI.
> >
> > When I've had problems changing the account type on an account, I found
> > that changing the parent first opens up the additional account types to
> > be used.
> >
> > Don't know if that will work for A/R (as I don't utilize them).
>
> Indeed, I was going to suggest that you re-parent to make it a top-level
> account, then you can change the type, and then you can re-parent it
> wherever you want in the hierarchy.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Adding Transactions From Another Program

[david whiting]

gt; >>>
> >>> Hal
> >>
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see 
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> 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
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account type by editing XML?

[david whiting]

On Thu, 30 Apr 2020 at 05:02, Adrien Monteleone
 wrote:
>
> That’s another valid and safe option.
>
> The OP noted 1000+ accounts to migrate though. So even 1 transaction per 
> account would not be fun.
>
> On the upside, I discovered that accounts with zero transactions can have 
> their type changed. So if the OP had some empty accounts, those could be done 
> rather painlessly. (if slowly via GUI)
>
> I’d recommend not to retain individual A/R accounts per customer. While there 
> are some advantages to doing so, I’m not sure GnuCash *needs* this treatment. 
> It would be wise to investigate the ‘why’ of the individual accounts before 
> the OP proceeds with a change.
>
> Some apps (and certainly paper books) almost necessitate sub-accounts per 
> customer. (and per Vendor under A/P) But GnuCash does not and can handle 
> tracking amounts owed or owed to with a single A/R and A/P account. One can 
> always employ special or other A/R or A/P, but they may not be as necessary 
> as one might think.
>
> Regards,
> Adrien
>

The "why" has two components: 1) what I am trying to model, and 2) the
circumstances and context around when I set things up.

1) What I'm trying to model

These are the accounts for a local football club that consists of
about 450 members playing for 25 teams. Each members pays annual subs,
the amount of which is different for each team because there are some
costs that are generic across the club and others that are options
selected by the different teams. Members pay a (re)sign-on fee at the
beginning of the season, then six monthly payments. I then spend the
rest of the season chasing those who have not kept up with payments.
Most members now pay by bank transfer.

Each year about 100 members leave (they stop playing or join another
club) and about 100 new members join.

Each team seeks sponsorship and has its own account within the
accounts and can spend that money how it likes (more kit, equipment,
BBQ, whatever). I have placed these accounts in Liabilities.

I need to be able to produce statements (transaction reports) for each
member each month and for each team, so each member needs to be
associated with a team. Grouping members by team in the chart of
accounts makes it easier to find the relevant accounts quickly because
I normally need to deal with issues team by team.

2) The context

The context for when I set this up was: I had just taken over as
treasurer after a year when the accounts had been managed very poorly.
There were many disagreements about what had been paid (at that time
many transactions were in cash, collected by team managers and passed
on to the treasurer). There was no formal list of members so it was
hard to know who should be paying. This was after six years where the
previous treasurer had produced no balance sheet or profit and loss
statement, just an annual listing of all cheques written and the bank
balance. I needed to set something up quickly to restore confidence. I
knew of gnucash but have no training in accounts. I met with the
parent of one player who was an accountant one evening over a few
beers and we talked about how to set things up (I suspect this is not
the standard way that accountants are trained). I made notes, and read
(some of) the gnucash manual but there were clearly many things I did
not fully understand, one of which was the correct way to set up the
members in gnucash.

I recognise now that the members are effectively customers, but I
don't think I could make gnucash work for me to deal with so many
customers each month. If I have to process payments for each customer
it would take too long. I need to be able to produce member and team
statements and I don't think I can do that for batch of customers.
Treating them as people who owe money and simply creating asset
accounts works because the import matching works well for matching
payments to members and I can create a transaction report that I can
then post-process into individual statements with a script.

So my fundamental mistake was creating these accounts under A/R when I
should have created them under assets. Getting them out is now my
mission.

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account type by editing XML?

[david whiting]

On Thu, 30 Apr 2020 at 11:05, Geert Janssens  wrote:
>
[snip]
>
> It could be called a bug. However business accounts (AR and AP) hold more 
> data than other accounts. Moving away from that account could hence result in 
> data loss that's not immediately obvious.
>
> As it turned out to be too complicated to isolate in which exact conditions 
> it is safe or possible, we have chosen to not allow it in any case for the 
> time being.
>
> Regards,
>
> Geert

That gives me some hints about what to look for when I examine the
file and structure of these accounts in more detail. I only have a
handful of invoices that I have issued and processed and I can compare
them with these accounts that shouldn't be in A/R. I haven't issued
any invoices for these accounts.

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account type by editing XML?

[david whiting]

On Wed, 29 Apr 2020 at 21:33, Stephen M. Butler  wrote:
>
> On 4/29/20 1:21 PM, david whiting wrote:
> > On Wed, 29 Apr 2020 at 20:48, Adrien Monteleone
> >  wrote:
> >> 1. Create new accounts as the proper type in the proper place in the tree.
> >>
> >> 2. Delete each of the current accounts, one at a time, you wish to change.
> >>
> >> 3. GnuCash will ask you, for each deletion, what you want to do with the 
> >> transactions the account currently contains.
> >>
> >> 4. Choose the option to re-assign them to the corresponding new account.
> >>
> >> Since they are both assets (A/R is an asset) this should go smoothly.
> >>
> >> Do a test with one account on a copy of the data file just to be sure 
> >> there are no unforseen issues.
> >>
> >> Regards,
> >> Adrien
> >>
> > Unfortunately the only accounts that show up in the "Move to" dialogue
> > are other A/R accounts, no other asset accounts are visible. I've
> > verified this by creating a new account outside of the A/R hierarchy
> > with type A/R. It was then visible in the list of accounts. I selected
> > it and deleted the transactions so they moved to this new A/R account
> > outside of the A/R hierarchy. But once that had been done, I could no
> > longer change the type of that account.
> Ouch!  Sounds like a bug or that the A/R account type is locked down too
> tight.

I'm hoping that directly editing the XML file will be the way to do it
because I have close to 1,000 accounts to move and doing them all by
clicking through the gui is not something I'm looking forward to (it's
why I haven't done it yet, having realised a year or so ago that they
are in the wrong place). I'm going to sleep on it and over the next
day or so I'll look more carefully at the XML file, see how the IDs
relate to each other etc. to see if there is any difference between
ASSETs and RECEIVABLEs in terms of how the data are stored.

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account type by editing XML?

[david whiting]

On Wed, 29 Apr 2020 at 21:31, Stephen M. Butler  wrote:
>
> On 4/29/20 1:14 PM, david whiting wrote:
> > On Wed, 29 Apr 2020 at 20:29, Maf. King  wrote:
> >> Just a thought - if you change the account parent away from A/R can you 
> >> then
> >> change the type?
> >>
> >> HTH,
> >> Maf.
> >>
> > No, unfortunately moving the parent account doesn't allow me to change it.
> >
> > David
>
>
> I think you misunderstood, or I'm not understanding what you did.  It
> sounds like you attempted to edit the parent account and change it's
> type.  What we are suggesting is that you edit the leaf account and
> change who it's parent is so that it shows up underneath a different
> (non-A/R) account.
>

Yes, I misunderstood, however, I just tried that and still can't
change the type. See attached image showing that the account is now in
Assets:Members but other types are still not available.

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account type by editing XML?

[david whiting]

On Wed, 29 Apr 2020 at 20:48, Adrien Monteleone
 wrote:
>
> 1. Create new accounts as the proper type in the proper place in the tree.
>
> 2. Delete each of the current accounts, one at a time, you wish to change.
>
> 3. GnuCash will ask you, for each deletion, what you want to do with the 
> transactions the account currently contains.
>
> 4. Choose the option to re-assign them to the corresponding new account.
>
> Since they are both assets (A/R is an asset) this should go smoothly.
>
> Do a test with one account on a copy of the data file just to be sure there 
> are no unforseen issues.
>
> Regards,
> Adrien
>

Unfortunately the only accounts that show up in the "Move to" dialogue
are other A/R accounts, no other asset accounts are visible. I've
verified this by creating a new account outside of the A/R hierarchy
with type A/R. It was then visible in the list of accounts. I selected
it and deleted the transactions so they moved to this new A/R account
outside of the A/R hierarchy. But once that had been done, I could no
longer change the type of that account.

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account type by editing XML?

[david whiting]

On Wed, 29 Apr 2020 at 20:29, Maf. King  wrote:
>
> Just a thought - if you change the account parent away from A/R can you then
> change the type?
>
> HTH,
> Maf.
>

No, unfortunately moving the parent account doesn't allow me to change it.

David


>
>
> On Wednesday, 29 April 2020 19:25:25 BST david whiting wrote:
> > Hello,
> >
> > When I first set up my accounts (for a local club) I knew very little
> > about accounting and misinterpreted some information I was given by an
> > accountant and ended up creating some sub-accounts in Accounts Receivable.
> > I now know that was not the correct thing to do, and I should have created
> > these accounts as straight-forward asset accounts.
> >
> > Using gnucash I cannot change the account type for these accounts. When I
> > use ctrl+e on these accounts I only see account type A/Receivable so I
> > cannot change them through the GUI.
> >
> > I've compared the XML structure of one of these accounts with another
> > simple asset account and they are the same except for the , i.e.:
> >
> > RECEIVABLE
> >
> > versus
> >
> > ASSET
> >
> > I've tried editing this (on a copy) and simply changing RECEIVABLE to ASSET
> > seems to work when I re-open the file. Once this is done I used gnucash to
> > move the account to the correct place in the accounts hierarchy and all
> > seemed well.
> >
> > Before I do this to all instances in my working file are there any
> > potential adverse consequences that doing this could cause that I am
> > not aware of?
> >
> > Thanks.
> >
> > David
>
>
> --
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
>
>
>
>
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Change account type by editing XML?

[david whiting]

Hello,

When I first set up my accounts (for a local club) I knew very little
about accounting and misinterpreted some information I was given by an
accountant and ended up creating some sub-accounts in Accounts Receivable.
I now know that was not the correct thing to do, and I should have created
these accounts as straight-forward asset accounts.

Using gnucash I cannot change the account type for these accounts. When I
use ctrl+e on these accounts I only see account type A/Receivable so I
cannot change them through the GUI.

I've compared the XML structure of one of these accounts with another
simple asset account and they are the same except for the , i.e.:

RECEIVABLE

versus

ASSET

I've tried editing this (on a copy) and simply changing RECEIVABLE to ASSET
seems to work when I re-open the file. Once this is done I used gnucash to
move the account to the correct place in the accounts hierarchy and all
seemed well.

Before I do this to all instances in my working file are there any
potential adverse consequences that doing this could cause that I am
not aware of?

Thanks.

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cycle between basic, autosplit, transaction views?

[david whiting]

Sure. As Geert said the file that needs to be changed is accelerator-map,
which on linux is located in $HOME/.local/share/gnucash. The exact steps I
followed are:

   1. Close gnucash
   2. Copy accelerator-map to accelerator-map.backup just in case something
   goes wrong
   3. Edit $HOME/.local/share/gnucash/accelerator-map using a text editor
   4. Look for a line that says:
   ; (gtk_accel_path
   "/GncPluginPageRegisterActions/ViewStyleJournalAction" "")
   Note that the line has a semi-colon at the beginning to comment it out
   so it is not currently used. At the end before the last closing parenthesis
   there is a pair of double quotes. The key combination will go there.
   5. Change that to:
   (gtk_accel_path
   "/GncPluginPageRegisterActions/ViewStyleJournalAction"
   "3")
   Note that as well as adding 3 you need to remove the leading
   semi-colon
   6. Repeat the process for the other two views (ViewStyleAutoSplitAction
   and ViewStyleBasicAction)
   7. Exit and save the accelerator-map file
   8. Start gnucash and check the menu to see that it now says Ctrl+1,
   Ctrl+2, Ctrl+3 by each of the relevant menu entries:

[image: image.png]

David

On Sun, 29 Mar 2020 at 17:02, Roderick Anderson 
wrote:

> Fantastic David.
>
> Would you be willing to share the code you used?
>
>
> \\||/
> Rod
> --
>
> On 3/29/20 4:52 AM, david whiting wrote:
> > Excellent. Thank you! I now have ctrl+1 for basic view, ctrl+2 for
> > autosplit and ctrl+3 for transaction journal view. All quick and easy.
> >
> > David
> >
> > On Sun, 29 Mar 2020 at 11:38, Geert Janssens  >
> > wrote:
> >
> >> Hi,
> >>
> >>
> >>
> >> You may be able to customize the hotkeys for the three menu functions.
> >>
> >>
> >>
> >> On Ubuntu there should be file named "accelerator-maps" in
> >>
> >> $HOME/.local/share/gnucash
> >>
> >>
> >>
> >> It's listing all hotkeys configured in gnucash. You can search for
> >>
> >> /GncPluginPageRegisterActions/ViewStyleJournalAction
> >> /GncPluginPageRegisterActions/ViewStyleAutoSplitAction
> >> /GncPluginPageRegisterActions/ViewStyleBasicAction
> >>
> >> and define your own hotkeys for these.
> >>
> >>
> >>
> >>  Stands for 
> >>
> >>  is self-explanatory
> >>
> >> I don't know what to use for the  key, though just that may work.
> >>
> >>
> >>
> >> Good luck!
> >>
> >>
> >>
> >> Geert
> >>
> >>
> >>
> >> Op zondag 29 maart 2020 12:09:12 CEST schreef david whiting:
> >>
> >>> Hi,
> >>
> >>>
> >>
> >>> OS: Ubuntu 19.10
> >>
> >>> Gnucash: Build ID: 3.7+(2019-09-07)
> >>
> >>>
> >>
> >>> Is there any way to set up a hotkey to cycle between the basic ledger,
> >>
> >>> autosplit ledger and transaction journal views? I find it useful to
> >> switch
> >>
> >>> between them depending on how much detail I need to see and although it
> >> is
> >>
> >>> not a huge number of clicks I find that I do it often enough to become
> a
> >>
> >>> drag to grab the mouse (I prefer the keyboard), move to the view menu,
> >>
> >>> select the option, and then go back to the keyboard. Being able to
> cycle
> >>
> >>> between the views using a key combination would help with my flow.
> >>
> >>>
> >>
> >>> Thanks for any suggestions.
> >>
> >>>
> >>
> >>> David
> >>
> >>
> >>
> >>
> >>
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cycle between basic, autosplit, transaction views?

[david whiting]

Excellent. Thank you! I now have ctrl+1 for basic view, ctrl+2 for
autosplit and ctrl+3 for transaction journal view. All quick and easy.

David

On Sun, 29 Mar 2020 at 11:38, Geert Janssens 
wrote:

> Hi,
>
>
>
> You may be able to customize the hotkeys for the three menu functions.
>
>
>
> On Ubuntu there should be file named "accelerator-maps" in
>
> $HOME/.local/share/gnucash
>
>
>
> It's listing all hotkeys configured in gnucash. You can search for
>
> /GncPluginPageRegisterActions/ViewStyleJournalAction
> /GncPluginPageRegisterActions/ViewStyleAutoSplitAction
> /GncPluginPageRegisterActions/ViewStyleBasicAction
>
> and define your own hotkeys for these.
>
>
>
>  Stands for 
>
>  is self-explanatory
>
> I don't know what to use for the  key, though just that may work.
>
>
>
> Good luck!
>
>
>
> Geert
>
>
>
> Op zondag 29 maart 2020 12:09:12 CEST schreef david whiting:
>
> > Hi,
>
> >
>
> > OS: Ubuntu 19.10
>
> > Gnucash: Build ID: 3.7+(2019-09-07)
>
> >
>
> > Is there any way to set up a hotkey to cycle between the basic ledger,
>
> > autosplit ledger and transaction journal views? I find it useful to
> switch
>
> > between them depending on how much detail I need to see and although it
> is
>
> > not a huge number of clicks I find that I do it often enough to become a
>
> > drag to grab the mouse (I prefer the keyboard), move to the view menu,
>
> > select the option, and then go back to the keyboard. Being able to cycle
>
> > between the views using a key combination would help with my flow.
>
> >
>
> > Thanks for any suggestions.
>
> >
>
> > David
>
>
>
>
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Cycle between basic, autosplit, transaction views?

[david whiting]

Hi,

OS: Ubuntu 19.10
Gnucash: Build ID: 3.7+(2019-09-07)

Is there any way to set up a hotkey to cycle between the basic ledger,
autosplit ledger and transaction journal views? I find it useful to switch
between them depending on how much detail I need to see and although it is
not a huge number of clicks I find that I do it often enough to become a
drag to grab the mouse (I prefer the keyboard), move to the view menu,
select the option, and then go back to the keyboard. Being able to cycle
between the views using a key combination would help with my flow.

Thanks for any suggestions.

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] import map editor takes a VERY long time to open

[david whiting]

Thanks. I do have a lot of transactions that have a unique reference.

I have one core (of eight) that is running at 100% processing this. It has
now been running for 3 and half hours and the trace file is 557 Mb and
growing...

David

On Sun, 1 Mar 2020 at 21:33, David Cousens  wrote:

> David,
>
> I have a 16.8 Mbyte uncompresseddata file which takes 3-4 sec at most to
> load at startup in V3.8 on Linux Mint 19.3 (Ubuntu 18.04). The Import Map
> Editor comes up almost immediately on selecting it from the menu. I
> possibly
> have fewer accounts than you have and have roughly half the transactions
> and
> splits.
>
> If you have a transaction source (or several of them) which uses a unique
> number each time in the transaction description you can get a lot of import
> matching data being stored with very low frequency of occurrence that
> effectively does little to help with matching. I have 6-8 transactions a
> month which regularly can't be matched because of this. Government
> departments/ pensionfunds  are becoming specialists at tagging UUIDs onto
> things. This of course has to be imported and sorted through during import
> and matching which is probably why you want to use the Import match Editor.
> Unfortunately as the match data is stored in the data file there is no
> simple way to remove it and start again with retraining. I have't yet taken
> the time out to prune the matching data but the ability to do this is
> obviously there for when there is a problem.
>
> If you upload the whole tracefile Geert or John may be able to spot
> something in it but if the excerpt is typical it would appear to be
> buidling
> up the tables of information that the import match editor uses. There may
> be
> nothing for it but to allow it to run to completion. You may ned to turn
> off
> any power saving measures in Ubuntu which automatically hibernate or
> suspend
> the system to allow this to occur.
>
> Linux has a sometimes annoying indexing process which seems to grab a lot
> of
> CPU time and runs with a high priority and can stop other programs from
> operating by denial of service until it is complete (has been several hours
> on a few occasions). This is usually accompanied by a lot of disk access.
> There are fixes on the various  Linux forums if this is the problem.
>
> I seem to remember there may be a bug or feature request around possibly
> parsing such numbers where there is a fixed component which would identify
> a
> specific account and a random component but this is not going to be easy
> unless there is a separator of some sort. I don't know if anyone has looked
> at this yet.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] import map editor takes a VERY long time to open

[david whiting]

al] matching
objects=0x55c564a57040 count=21
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c566cb4aa0 count=106
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c5661a4ac0 count=8
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c5667bff20 count=5016

-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Opening Balance on Reports

[david whiting]

What I do is add a transaction on the first date of the new period with the
transaction reference "Balance carried forward" with nothing in the
credit/debit columns. Then a transaction report with running balance has
"Balance carried forward" as the first transaction and the running balance
shows the amount carried forward. See attached example (our club financial
year runs from 1st August to 31st July).

David

On Thu, 2 Jan 2020, 23:17 Michael or Penny Novack, <
stepbystepf...@comcast.net> wrote:

> On 1/2/2020 5:33 PM, Christopher Lam wrote:
> > If it's a single-creditor liability account, you could try adding the
> > Display/Running Balance. However it doesn't quite give you the 'balance
> > brought forward' prior to the first printed transaction.
> >
> I will tell you how I would do this. It would be easy for me, because I
> don't insist that that the final printed version be printed from within
> gnucash.
>
> I would use the suggestion above, but set the date range to include the
> last transaction before. I would export the resulting report.. I would
> then edit the date of that last transaction to be the start date, change
> its description to "opening balance" and it's amount to zero/blank << it
> is the running balance after this transaction that is the starting
> balance >>
>
> I would then print THAT (or send THAT by electronic means
>
> Michael D Novack
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


Transaction Report--03_01_20.pdf
Description: Adobe PDF document
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Find Transaction Dialog Box, v3.7, ubuntu 18.04.3, Problem

[david whiting]

I've bookmarked it because I need to do it as well. See email from John
Rails on 29 October with this:

Edit /usr/share/gnucash/gtkbuilder/dialog-search.glade and change the value
in line 305 (the expand property) to True. When you're done it will look
like:

  
True
True
1
  

David


On Thu, 19 Dec 2019, 16:54 Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> Check the list archives from earlier this month or November. There is a
> thread on this containing a fix for the interim until the next version is
> released. (around the end of the year)
>
> Sorry I don’t recall the fix explicitly off-hand. Perhaps someone who does
> can chime in if you can’t find it.
>
> Regards,
> Adrien
>
> > On Dec 19, 2019 w51d353, at 10:48 AM, Michael A. Koerber <
> makoerb...@gmail.com> wrote:
> >
> > Just upgraded gnucash from v2.6 to v3.7 (and upgraded ubuntu).
> >
> > The geometry of the Find Transaction dialog box makes it virtually
> > impossible to enter a search.  See below image.  I can't find a way to
> > make text input boxes large enough to use.  Can anyone help with
> > this?  (I've tried to uninstall/reinstall with no improvements.)
> >
> > 
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bookkeeping for a club's charity account - use business features?

[david whiting]

 might be the better route because such
> information already has a place to be stored without having to shoe-horn it
> into individual transactions. (but even that would be possible, and
> auto-fill will greatly assist with data entry)
> >
> >
> > Regards,
> > Adrien
>
> Thanks, Adrien.
>
> Plenty of food for thought there!
>
> I’m not desperately keen on using free text in the Description and Notes
> fields because minor variations in spelling might well cause a transaction
> to be missed, but I can see that this would greatly speed up data entry.
>
> I’ve already set up an Asset account called “Members’ Commitments”, which
> will be populated (e.g.) as members commit to being paying guests at a
> Foundation Dinner, and then reduced to zero once a suitable date has been
> negotiated, the meal eaten and payment received.
>
> I can foresee a lot of revisions going on until I settle down on a
> workable method.
>
> Regards,
>
> Michael
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: how to copy "Customers Overview" table for spreadsheet.

[david whiting]

I'm a few pages into a book about xslt so I thought I'd give this a go. I'm
sure it's not the best xslt and anyone who knows how to use xslt properly
will probably feel unwell after looking at this, but it does seem to work,
i.e. produce a summary html table with the customers overview info (and a
few extra fields for extra points).

To use it gunzip your gnucash file or save it in uncompressed format (Edit
-> Preferences -> General) then you can run it using xsltproc like this
(assuming the name of your file is accounts.gnucash):

xsltproc customers.xslt accounts.gnucash > customers.html

(there's a version for windows called xsltproc.exe if you are using windows
and there are other ways of running xslt stylesheets)

Then you can view customers.html and copy and paste the info into a
spreadsheet or whatever.

David

On Tue, 30 Jul 2019 at 17:52, Geert Janssens 
wrote:

> Op maandag 8 juli 2019 21:46:23 CEST schreef Adrien Monteleone:
> > David,
> >
> > The OP was asking about the Customer Overview, not Customer Summary
> Report.
> >
> > The Customer Summary Report doesn’t show the same info as the Customer
> > Overview. Notably, customer ID, address, and phone#. The overview is
> > essentially a table of *some* of the data for each customer like what
> might
> > be found if there were a way to export customers. (the same problem
> exists
> > for vendors)
> >
> Hmm, I made the same mixup. Please ignore my reply (still catching up on a
> backlog of several weeks...).
>
> Regards,
>
> Geert
>
> > GnuCash can import this data, but can’t export it.
> >
> > Regards,
> > Adrien
> >
> > > From: 
> > > Date: Mon, Jul 8, 2019, 11:07
> > >
> > >
> > >
> > > Have you tried highlighting the report contents and pasting into a
> > > spreadsheet? In Windows, I can run the Customer Summary report, press
> > > CTRL-A, CTRL-C , open a spreadsheet, and press CTRL-V. The results are
> > > reasonably sane. I haven't tried on a Mac recently, but ISTR that it
> > > worked
> > > in a similar fashion there.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> > 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Whiting


customers.xslt
Description: application/xslt
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 8.1 Find (^F) set default search preferences?

[david whiting]

I do the same and have often wished there was a hot-key to jump to the
CoA, e.g. Ctrl-1. Then I could do Ctrl-1 Ctrl-f, but being able to do
it from the Find window would be better. It would be nice if selecting
the option to search across all accounts could be bound to ctrl-f when
in the Find window, so to search across all accounts from any register
you would do ctrl-f ctrl-f.

David

On Fri, 3 May 2019 at 05:32, Adrien Monteleone
 wrote:
>
> I agree, I find myself often having to face palm and then migrate to the the 
> CoA to conduct my search. In fact, I rarely can get any results even *for* 
> the register I’m in. But ‘finding’ from the CoA works every time.
>
> Regards,
> Adrien
>
> > On May 2, 2019, at 5:30 PM, David Carlson  
> > wrote:
> >
> > The part of the ^F search that I get most frustrated with is that it only 
> > searches the split lines belonging to the register that you start in, so I 
> > usually have to start by going to the CoA window or open a Ledger window 
> > before starting my search.  An option to search all transaction accounts 
> > without leaving the current account register would be very nice.
> >
> > David Carlson
> >
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Expense accounts in bills

[david whiting]

Derek,

Thanks for this. I have now had a play with my set-up (or rather a
copy of it) and see that I need to change my work flow.

I think I'm going to work on that and then close the books at the end
of the season and start afresh in the new season with what I hope will
be a better set-up.

Thanks for your guidance with this.

David


On Fri, 15 Mar 2019 at 19:31, Derek Atkins  wrote:
>
> David,
>
> You are doing it all wrong.
>
> You have two choices:  Use Business Features or Not.
>
> If you choose NOT to use the business features, then create a set of ASSET
> accounts of the form you have, one account for each member.  If you are
> NOT using the business features, then you MUST NOT use A/R and A/P type
> accounts.  When you invoice a member, it's a transfer from Income:Dues to
> the specific member Asset account.  Then when they pay, it's a transfer
> from their Asset to Assets:Checking.
>
> If you choose to use the business features, then you DO NOT need the whole
> hierarchy of accounts.  You only need pone A/R account.  You set up each
> member as a customer, and then to bill them create an invoice with a
> line-item to Income:Dues, and then post the invoice to your A/R account.
> Then when you're done, process payment to transfer from A/R to Checking.
>
> I suggest you revert to a backup before you set this up and start over.
> It'll be easier than trying to clean up.  Alternately, you can unpost all
> your invoices, then go through all your A/R accounts and remove all
> transactions, then delete all your A/R accounts except the top-level.
> Then you can re-post.
>
> Hope this helps.
>
> -derek
>
>
> On Fri, March 15, 2019 3:03 pm, david whiting wrote:
> > Thanks. Unfortunately I can't move transactions to an account that is
> > of a different type. If I create a new account with type Asset, it
> > doesn't show up in the list of accounts that I can move the
> > transactions to. If I change the type AR, it appears, but then once I
> > have moved the transactions, I can't change it back to type Asset. So
> > I think I'm stuck.
> >
> > David
> >
> > On Fri, 15 Mar 2019 at 09:54, Adrien Monteleone
> >  wrote:
> >>
> >> Probably because they contain transactions. You should be able to
> >> re-assign the type to any that are empty.
> >>
> >> Note, you shouldn’t need to manually migrate the transactions, as you
> >> delete the errant accounts, GnuCash should prompt on where to move the
> >> transactions. Simply select the proper account(s) in that dialog.
> >>
> >> Regards,
> >> Adrien
> >>
> >> > On Mar 15, 2019, at 2:47 AM, david whiting 
> >> wrote:
> >> >
> >> > Ah, yes, you are correct. The accounts I can see are assets and the
> >> > other are A/R. The problem I now have is that I don't seem to be able
> >> > to change the account type from A/R to asset now that they have been
> >> > created as A/R. Looks I might have to create new accounts and migrate
> >> > each transaction across, which is going to take some time.
> >> >
> >> > Thanks for your help.
> >> >
> >> > David
> >> >
> >> > On Thu, 14 Mar 2019 at 22:04, Adrien Monteleone
> >> >  wrote:
> >> >>
> >> >> When I’ve had issues in the past with accounts not showing up in the
> >> Business Features like this, it was due to their type not being
> >> correct.
> >> >>
> >> >> They should all be of type Asset, *not* type Accounts Receivable.
> >> (but you can certainly make them children of A/R or better yet,
> >> create an ‘Other A/R’ account and make them children of that. The
> >> main A/R account is special)
> >> >>
> >> >> Check the type on the ones that are showing up and a few that aren’t.
> >> This is likely the issue.
> >> >>
> >> >> Regards,
> >> >> Adrien
> >> >>
> >> >>> On Mar 14, 2019, at 4:11 PM, david whiting 
> >> wrote:
> >> >>>
> >> >>> Hi,
> >> >>>
> >> >>> Gnucash Version: 3.3
> >> >>> Build ID: 3.3+ (2018-09-29)
> >> >>> Ubuntu 18.10
> >> >>>
> >> >>> I'm using gnucash for a community club where we have members who I
> >> >>> represent in gnucash as Assets:Accounts Receivable:Members:Firstname
> >> >>> Lastname
> >> >>>
> >> >>> I need to create bills for 

Re: [GNC] Expense accounts in bills

[david whiting]

Thanks. Unfortunately I can't move transactions to an account that is
of a different type. If I create a new account with type Asset, it
doesn't show up in the list of accounts that I can move the
transactions to. If I change the type AR, it appears, but then once I
have moved the transactions, I can't change it back to type Asset. So
I think I'm stuck.

David

On Fri, 15 Mar 2019 at 09:54, Adrien Monteleone
 wrote:
>
> Probably because they contain transactions. You should be able to re-assign 
> the type to any that are empty.
>
> Note, you shouldn’t need to manually migrate the transactions, as you delete 
> the errant accounts, GnuCash should prompt on where to move the transactions. 
> Simply select the proper account(s) in that dialog.
>
> Regards,
> Adrien
>
> > On Mar 15, 2019, at 2:47 AM, david whiting  wrote:
> >
> > Ah, yes, you are correct. The accounts I can see are assets and the
> > other are A/R. The problem I now have is that I don't seem to be able
> > to change the account type from A/R to asset now that they have been
> > created as A/R. Looks I might have to create new accounts and migrate
> > each transaction across, which is going to take some time.
> >
> > Thanks for your help.
> >
> > David
> >
> > On Thu, 14 Mar 2019 at 22:04, Adrien Monteleone
> >  wrote:
> >>
> >> When I’ve had issues in the past with accounts not showing up in the 
> >> Business Features like this, it was due to their type not being correct.
> >>
> >> They should all be of type Asset, *not* type Accounts Receivable. (but you 
> >> can certainly make them children of A/R or better yet, create an ‘Other 
> >> A/R’ account and make them children of that. The main A/R account is 
> >> special)
> >>
> >> Check the type on the ones that are showing up and a few that aren’t. This 
> >> is likely the issue.
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Mar 14, 2019, at 4:11 PM, david whiting  
> >>> wrote:
> >>>
> >>> Hi,
> >>>
> >>> Gnucash Version: 3.3
> >>> Build ID: 3.3+ (2018-09-29)
> >>> Ubuntu 18.10
> >>>
> >>> I'm using gnucash for a community club where we have members who I
> >>> represent in gnucash as Assets:Accounts Receivable:Members:Firstname
> >>> Lastname
> >>>
> >>> I need to create bills for members and wish to select the relevent
> >>> account receivable in the Expense portion of the bill, i.e. it is an
> >>> expense for the member and not for the club. However, very few of the
> >>> accounts receivable show up in the selection box. I have got around
> >>> this by creating a spreadsheet that I then import to create the bills,
> >>> but it means that I need to do extra work to keep that spreadsheet up
> >>> to date when new members join.
> >>>
> >>> Is there a limit on the number of accounts that can appear in the
> >>> selection box? Is there any other reason why only a handful of the
> >>> 300+ members show up?
> >>>
> >>> Thanks.
> >>>
> >>> David
> >>> --
> >>> David Whiting
> >>
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see 
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> >
> >
> > --
> > David Whiting
> >
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Expense accounts in bills

[david whiting]

Ah, yes, you are correct. The accounts I can see are assets and the
other are A/R. The problem I now have is that I don't seem to be able
to change the account type from A/R to asset now that they have been
created as A/R. Looks I might have to create new accounts and migrate
each transaction across, which is going to take some time.

Thanks for your help.

David

On Thu, 14 Mar 2019 at 22:04, Adrien Monteleone
 wrote:
>
> When I’ve had issues in the past with accounts not showing up in the Business 
> Features like this, it was due to their type not being correct.
>
> They should all be of type Asset, *not* type Accounts Receivable. (but you 
> can certainly make them children of A/R or better yet, create an ‘Other A/R’ 
> account and make them children of that. The main A/R account is special)
>
> Check the type on the ones that are showing up and a few that aren’t. This is 
> likely the issue.
>
> Regards,
> Adrien
>
> > On Mar 14, 2019, at 4:11 PM, david whiting  wrote:
> >
> > Hi,
> >
> > Gnucash Version: 3.3
> > Build ID: 3.3+ (2018-09-29)
> > Ubuntu 18.10
> >
> > I'm using gnucash for a community club where we have members who I
> > represent in gnucash as Assets:Accounts Receivable:Members:Firstname
> > Lastname
> >
> > I need to create bills for members and wish to select the relevent
> > account receivable in the Expense portion of the bill, i.e. it is an
> > expense for the member and not for the club. However, very few of the
> > accounts receivable show up in the selection box. I have got around
> > this by creating a spreadsheet that I then import to create the bills,
> > but it means that I need to do extra work to keep that spreadsheet up
> > to date when new members join.
> >
> > Is there a limit on the number of accounts that can appear in the
> > selection box? Is there any other reason why only a handful of the
> > 300+ members show up?
> >
> > Thanks.
> >
> > David
> > --
> > David Whiting
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Expense accounts in bills

[david whiting]

Hi,

Gnucash Version: 3.3
Build ID: 3.3+ (2018-09-29)
Ubuntu 18.10

I'm using gnucash for a community club where we have members who I
represent in gnucash as Assets:Accounts Receivable:Members:Firstname
Lastname

I need to create bills for members and wish to select the relevent
account receivable in the Expense portion of the bill, i.e. it is an
expense for the member and not for the club. However, very few of the
accounts receivable show up in the selection box. I have got around
this by creating a spreadsheet that I then import to create the bills,
but it means that I need to do extra work to keep that spreadsheet up
to date when new members join.

Is there a limit on the number of accounts that can appear in the
selection box? Is there any other reason why only a handful of the
300+ members show up?

Thanks.

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Expense accounts in bills

[david whiting]

Hi,

Gnucash Version: 3.3
Build ID: 3.3+ (2018-09-29)
Ubuntu 18.10

I'm using gnucash for a community club where we have members who I
represent in gnucash as Assets:Accounts Receivable:Members:Firstname
Lastname

I need to create bills for members and wish to select the relevent
account receivable in the Expense portion of the bill, i.e. it is an
expense for the member and not for the club. However, very few of the
accounts receivable show up in the selection box. I have got around
this by creating a spreadsheet that I then import to create the bills,
but it means that I need to do extra work to keep that spreadsheet up
to date when new members join.

Is there a limit on the number of accounts that can appear in the
selection box? Is there any other reason why only a handful of the
300+ members show up?

Thanks.

David
-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.