Re: [GNC] Can I export a list of vendors and customers?

[Liz]

On Fri, 18 Nov 2022 14:58:56 -0800
Cam Ellison  wrote:

> On 2022-11-18 13:55, Adrien Monteleone wrote:
> > Unfortunately no.
> >
> > Regards,
> > Adrien
> >
> > On 11/18/22 12:11 PM, Dr. David Kirkby wrote:  
> >> Is it possible to export the customers as a .csv file in a
> >> database, and also I'd like to export the vendors. There are no
> >> transactions with these
> >> yet.  
> >
> >  
> If you store your transactions in a database instead of the standard 
> flat file, it's actually quite straightforward, especially with a 
> web-based database manager. Trying to work from the command line may
> be a little more complicated.
> 
> Cheers
> 
> Cam
> 

You could save once only in a suitable database format to get the data,
then immediately save in compressed xml again if you don't want to use
the database again.

Liz
___
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] Account structure for tracking trip expenses

[flywire]

See first part of
https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099811.html
re tags for most practical workaround. You could use multiple tags on one
split to get all or particular trips, eg: #trip #cruise. As noted, there is
no support for grouping (ie display all transactions in tag groups).
___
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] Tracking Travel expenses

[flywire]

https://wiki.gnucash.org/wiki/Using_GnuCash#Tracking_Reimbursable_Expenses

>
___
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] Account structure for tracking trip expenses

[David T. via gnucash-user]

This question has a long history (the earliest I've seen is from 2001, 
https://lists.gnucash.org/pipermail/gnucash-user/2001-October/002612.html). If 
you Google "cost center site:lists.gnucash.org/pipermail", you can find a 
number of these. 

Interestingly, that early thread neatly (if tersely) summarizes your options: 
create separate accounts for each center (with the acknowledged overhead that 
this approach entails), or use the Action field to insert codes that can be 
used to create necessary reports. 

⁣David T. ​

On Nov 19, 2022, 5:31 AM, at 5:31 AM, Peter West  wrote:
>I would like to have the trip fuel expenses, for example, also
>accumulate into the overall fuel expenses if possible.
>
>Thanks
>
>> On 19 Nov 2022, at 12:24 pm, Peter West  wrote:
>> 
>> How do folks here keep track of expenses for a particular event? For
>example, a road trip with fuel, food and accommodation expenses, where
>I have a CoA which has accounts for “normal” fuel, food and
>accommodation?
>> 
>> 
>> —
>> Peter West
>> p...@pbw.id.au
>> And he entered the temple and began to drive out those who sold,
>saying to them, “It is written, My house shall be a house of prayer,’
>but you have made it a den of robbers.”
>> 
>> ___
>> 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.
___
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] Account structure for tracking trip expenses

[Peter West]

I would like to have the trip fuel expenses, for example, also accumulate into 
the overall fuel expenses if possible.

Thanks

> On 19 Nov 2022, at 12:24 pm, Peter West  wrote:
> 
> How do folks here keep track of expenses for a particular event? For example, 
> a road trip with fuel, food and accommodation expenses, where I have a CoA 
> which has accounts for “normal” fuel, food and accommodation?
> 
> 
> —
> Peter West
> p...@pbw.id.au
> And he entered the temple and began to drive out those who sold, saying to 
> them, “It is written, My house shall be a house of prayer,’ but you have made 
> it a den of robbers.”
> 
> ___
> 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.

[GNC] Account structure for tracking trip expenses

[Peter West]

How do folks here keep track of expenses for a particular event? For example, a 
road trip with fuel, food and accommodation expenses, where I have a CoA which 
has accounts for “normal” fuel, food and accommodation?


—
Peter West
p...@pbw.id.au
And he entered the temple and began to drive out those who sold, saying to 
them, “It is written, My house shall be a house of prayer,’ but you have made 
it a den of robbers.”

___
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] Reusing old invoices?

[Morgan Read via gnucash-user]

Hi Geert,

Thanks for the pointers, answers inline :-

On 18/11/2022 4:46 pm, Geert Janssens wrote:
Op vrijdag 18 november 2022 16:54:01 CET schreef Morgan Read via 
gnucash-user:

...


 > > I recall an issue not long ago with an uneditable, unposted invoice.

 > > I'll check to see if I resolved it and if so, how. (this was an issue

 > > with the line-items, the details were editable)

 >

 > Yes, those are my symptoms - on one particular invoice the line-items

 > are uneditable whereas the details are editable.  Any pointers would be

 > great, thanks.


Is this an invoice tab you keep permanently open across gnucash restarts 
? In rare cases this may lead to gnucash becoming confused on the posted 
status of the invoice, which could lead to the symptoms you see.



You can try to close the invoice tab and use any the common methods to 
reopen it (Business->Customer->Find Invoice..., clicking on an invoice 
link in some report,...). That should fix the gnucash confusion.



If it's still not editable at that point, something else may be happening.
I'm not keeping it open - certainly not since it was originally created 
in March 2021 - it's certainly possible I kept it open across a few 
restarts when I originally created it, but I can't remember.  I have 
recently posted it and unposted it in the hope that might help to 
'loosen' things up, but it hasn't.

...

If you manually (had to) set the number on an invoice, you can 
afterwards update the invoice counter under File->Properties->Counters 
so the the next invoice will have the right number assigned 
automatically again.

Thanks, that'll help!

Morgan.

--
Morgan Read (It/Its)

Grande Bretagne
Em: 

Confused about DRM?
Get all the info you need at:



OpenPGP_signature
Description: OpenPGP digital signature
___
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 export a list of vendors and customers?

[Cam Ellison]

On 2022-11-18 13:55, Adrien Monteleone wrote:

Unfortunately no.

Regards,
Adrien

On 11/18/22 12:11 PM, Dr. David Kirkby wrote:

Is it possible to export the customers as a .csv file in a database, and
also I'd like to export the vendors. There are no transactions with 
these

yet.



If you store your transactions in a database instead of the standard 
flat file, it's actually quite straightforward, especially with a 
web-based database manager. Trying to work from the command line may be 
a little more complicated.


Cheers

Cam


___
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 export a list of vendors and customers?

[Adrien Monteleone]

Unfortunately no.

Regards,
Adrien

On 11/18/22 12:11 PM, Dr. David Kirkby wrote:

Is it possible to export the customers as a .csv file in a database, and
also I'd like to export the vendors. There are no transactions with these
yet.


___
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] Can I export a list of vendors and customers?

[Dr. David Kirkby]

Is it possible to export the customers as a .csv file in a database, and
also I'd like to export the vendors. There are no transactions with these
yet.

Dr David Kirkby Ph.D
Email: drkir...@kirkbymicrowave.co.uk Web:
https://www.kirkbymicrowave.co.uk/
Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100)
Stokes Hall Lodge, Burnham Rd, Chelmsford, 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.

Re: [GNC] Gnucash on macOS Ventura

[john]

There is no such thing, read the rest of the thread.

One more thing: There can never be a 4.12.anything, we use only two parts for 
GnuCash releases. Flathub, macOS, and Win32 *packages* get suffixes, e.g. 
4.12-1, 4.12-2, etc. when necessary to fix packaging problems, usually because 
I screwed something up but sometimes for updates in dependencies to fix 
significant bugs. macOS at present always starts off with -1. I suppose I 
should stop that with 4.900 to be consistent with the other two. Those 
packaging changes are always built from the same released GnuCash tag/tarball. 
If there's a bug in GnuCash itself that's so bad that we decide it needs a new 
release that release will get a new two-part number. 4.4 in December 2020 and 
4.8 in September 2021 are examples of that.

Regards,
John Ralls


> On Nov 18, 2022, at 4:43 AM, Christian Lynbech  wrote:
> 
> I am running:
> 
>Build ID: 4.12+(2022-09-24)
> 
> I think I checked and it seemed no new version was available on the
> gnucash site, where can I download 4.12.2?
> 
>   /Christian
> 
> ---
> On Mon, Nov 14 2022, William Prescott wrote:
> 
> Christian,
> 
> Are your running 4-12.1 or 4-12.2
> 
> I am running 4-12.1 (Build ID: 4.12+(2022-09-24)) on MacOS Ventura
> 13.0.1 (22A400) with no problems. I have 4-12.2 installed as well but
> I haven't switched to it.
> 
> Will
> 
> On Nov 14, 2022, at 17:56, R Losey  wrote:
> 
> Thanks for that update.
> 
> I think I'll hold off on doing the update for the time being.
> 
> 
> On Mon, Nov 14, 2022 at 1:06 PM john  wrote:
> 
>> It is indeed a Gtk bug,
>> https://gitlab.gnome.org/GNOME/gtk/-/issues/5305#note_1592320.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Nov 14, 2022, at 7:50 AM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>> 
>>> I'm forever locked on Monterey so I can't test, and I don't see that
>> problem with GnuCash, but, I do see it running Firefox on Monterey and
>> Win10, and I get it all over the UI in *buntu based VMs starting with the
>> 22.04 release.
>>> 
>>> I don't know if Firefox uses GTK+ code, but if so (and considering
>> GnuCash & the *buntu distros I tried do so as well) then I'd say it is
>> possibly a GTK bug, not GnuCash.
>>> 
>>> Regards,
>>> Adrien
>>> 
>>> On 11/14/22 2:54 AM, Christian Lynbech wrote:
 Anybody here who has experience running Gnucash (4.12) on the newest
 macOS Ventura?
 It basically works, but the UI is a bit wonky. The cursor does not
 update correctly, sometimes you need to click twice or be very carefull
 ot hit the text inside buttons.
>>> 
>>> ___
>>> 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.
>> 
> 
> 
> -- 
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> 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.
> ___
> 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] Reusing old invoices?

[Geert Janssens]

Op vrijdag 18 november 2022 16:54:01 CET schreef Morgan Read via gnucash-user:
> Hi Adrian,
> 
> 
> > I recall an issue not long ago with an uneditable, unposted invoice. 
> > I'll check to see if I resolved it and if so, how. (this was an issue 
> > with the line-items, the details were editable)
> 
> Yes, those are my symptoms - on one particular invoice the line-items 
> are uneditable whereas the details are editable.  Any pointers would be 
> great, thanks.

Is this an invoice tab you keep permanently open across gnucash restarts ? In 
rare cases this 
may lead to gnucash becoming confused on the posted status of the invoice, 
which could 
lead to the symptoms you see.

You can try to close the invoice tab and use any the common methods to reopen 
it (Business-
>Customer->Find Invoice..., clicking on an invoice link in some report,...). 
>That should fix the 
gnucash confusion.

If it's still not editable at that point, something else may be happening.

> > You should be able to simply renumber the Note/Invoice to avoid 
> > duplication confusion.
> 
> Yes, but then I've found that the numbering goes out - that is, the 
> auto-numbering creates invoices with a number that was created last time 
> (iirc) and so duplicates...

If you manually (had to) set the number on an invoice, you can afterwards 
update the invoice 
counter under File->Properties->Counters so the the next invoice will have the 
right number 
assigned automatically again.

Regards,

Geert
___
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] Reusing old invoices?

[Morgan Read via gnucash-user]

Hi Adrian,

I recall an issue not long ago with an uneditable, unposted invoice. 
I'll check to see if I resolved it and if so, how. (this was an issue 
with the line-items, the details were editable)
Yes, those are my symptoms - on one particular invoice the line-items 
are uneditable whereas the details are editable.  Any pointers would be 
great, thanks.


Be sure you aren't trying to edit the details directly in the fields on 
the invoice tab. (I know, that is confusing UI/UX) You have to use the 
Edit button on the toolbar and make changes there. (or use the Edit 
Bill/Invoice entry in the Edit menu)
Yes, the [Edit Invoice] button is functional - as is the 'Edit' menu > 
'Edit Invoice' menu item - and allows me to edit the details, but none 
of the buttons [Entre] [Cancel] [Delete] [Duplicate] [Up] [Down] [Blank] 
work, nor their equivalent entries under the 'Actions' menu.


I don't think you can change a Credit Note to an Invoice. (I recall 
wanting to do this once, and couldn't figure out how)

It may just have to languish until I need to issue a credit note again

You should be able to simply renumber the Note/Invoice to avoid 
duplication confusion.
Yes, but then I've found that the numbering goes out - that is, the 
auto-numbering creates invoices with a number that was created last time 
(iirc) and so duplicates...


I usually 'number' my need-to-be-reused bills/invoices as "Use Next" and 
then edit as needed later and post.
Hmm, interesting.  So, I can 'number' invoices with letters...?  (It 
seems so, I've just done it!)


Thank you.
btw, could you copy me in please


Regards,
Adrien

On 17/11/2022 6:31 pm, Morgan Read via gnucash-user wrote:

Hi Folks,

I'm trying to re-use an old invoice that was never sent out - but, the entries 
seem to be locked.  The invoice hasn't been posted and I can 'Edit Invoice' 
details, but when I come to entre a line item it's uneditable.  I've been able 
to do the same with other invoices that were created but not posted.  (I've 
been clearing out some old redundant invoices by reusing them.)

Also, I have a 'duplicate' invoice - two invoices with the same invoice number 
- but no way to 'delete' the invoice.  One was posted and sent, the other is 
only partially complete - the partially complete one is actually a credit note. 
 So, I figure I need to change it to a invoice (from a credit note) and change 
the invoice number and probably reset the invoice numbering so I can reuse it 
as an invoice and get rid of it and then have the invoice numbering run 
properly.

Any ideas on the above?

Thanks

--
Morgan Read (It/Its)

Grande Bretagne
Em: 

Confused about DRM?
Get all the info you need at:



OpenPGP_signature
Description: OpenPGP digital signature
___
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 on macOS Ventura

[Christian Lynbech]

I am running:

Build ID: 4.12+(2022-09-24)

I think I checked and it seemed no new version was available on the
gnucash site, where can I download 4.12.2?

   /Christian

---
On Mon, Nov 14 2022, William Prescott wrote:

Christian,

Are your running 4-12.1 or 4-12.2

I am running 4-12.1 (Build ID: 4.12+(2022-09-24)) on MacOS Ventura
13.0.1 (22A400) with no problems. I have 4-12.2 installed as well but
I haven't switched to it.

Will

On Nov 14, 2022, at 17:56, R Losey  wrote:

Thanks for that update.

I think I'll hold off on doing the update for the time being.


On Mon, Nov 14, 2022 at 1:06 PM john  wrote:

> It is indeed a Gtk bug,
> https://gitlab.gnome.org/GNOME/gtk/-/issues/5305#note_1592320.
> 
> Regards,
> John Ralls
> 
> 
>> On Nov 14, 2022, at 7:50 AM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>> 
>> I'm forever locked on Monterey so I can't test, and I don't see that
> problem with GnuCash, but, I do see it running Firefox on Monterey and
> Win10, and I get it all over the UI in *buntu based VMs starting with the
> 22.04 release.
>> 
>> I don't know if Firefox uses GTK+ code, but if so (and considering
> GnuCash & the *buntu distros I tried do so as well) then I'd say it is
> possibly a GTK bug, not GnuCash.
>> 
>> Regards,
>> Adrien
>> 
>> On 11/14/22 2:54 AM, Christian Lynbech wrote:
>>> Anybody here who has experience running Gnucash (4.12) on the newest
>>> macOS Ventura?
>>> It basically works, but the UI is a bit wonky. The cursor does not
>>> update correctly, sometimes you need to click twice or be very carefull
>>> ot hit the text inside buttons.
>> 
>> ___
>> 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.
> 


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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.
___
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.