-Original Message-
From: David T.
Sent: Wednesday, 29 April 2020 4:11 PM
To: Chris Good ; 'David H'
Cc: 'Gnucash Users'
Subject: Re: [GNC] Gnucash logs
If the setting were per book and user-configurable, then a user could choose to
set each data file to use a different set of folders,
Chris,
No doubt I agree that your approach is easier, but... users aren't going to
follow that. As I am not going to be the one coding, I can only offer
observations. If you build out, you get to decide how it works.
David T.
Original Message
From: Chris Good
Sent: Wed Ap
Right, you can buy extended support for Windows 7.
In the same spirit you may find a developer that's willing to keep gnucash
running on Windows
7 for you as well for a price. We won't do it in our volunteer free time as we
don't get enough
return on investment on it (in non-currency terms, li
Dear John,
Thank you for your response.
I have collected some statistics from my DB.
My DB has 1724 records - transactions.
This is my SQL query, it is pretty simple and shows all the combinations
of times in posted_date timestamps in transactions table, number of
repetitions for that time
Hi,
For the file based books (xml and sqlite) there are several approaches:
1. Have a book.gnucash and a book.dir side by side, per book you create.
book.gnucash is your actual data file.
book.dir is a directory containing extra files related to this data file. These
include log files,
backup f
I would like GnuCah to retrieve prices automatically each time I open it.
The documentation describes the "Get Quotes" feature as "automatic", but
I still have to remember to open the Price Editor and click "Get Quotes".
Is there a way to make price retrieval fully automatic?
Hi,
There is a bug in the current version of Ovirt I'm using that causes a
periodic (like once a quarter) ABRT of one of the management services.
Therefore, I am planning to upgrade to a new patch release, but that
will require rebooting the VM server (and as a result, rebooting code).
I plan to
On Wed, 29 Apr 2020, Derek Atkins wrote:
PS: I wonder if it makes sense to get a second CPU server (and a third
system to act as an "arbiter") in order to allow real-time VM migration
and allow host system upgrades without affecting VM uptime? *ponders*
Derek,
If system upgrades are infrequen
> On Apr 29, 2020, at 2:18 AM, finf...@gmail.com wrote:
>
> Dear John,
>
> Thank you for your response.
>
>
> I have collected some statistics from my DB.
>
> My DB has 1724 records - transactions.
>
> This is my SQL query, it is pretty simple and shows all the combinations of
> times in
> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user
> wrote:
>
> I would like GnuCah to retrieve prices automatically each time I open it.
>
> The documentation describes the "Get Quotes" feature as "automatic", but I
> still have to remember to open the Price Editor and click "Get Quote
> On Apr 29, 2020, at 9:54 AM, John Ralls wrote:
>
>
>
>> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user
>> wrote:
>>
>> I would like GnuCah to retrieve prices automatically each time I open it.
>>
>> The documentation describes the "Get Quotes" feature as "automatic", but I
>> st
Hi John!
You are here finally!
Waiting for you all the day :)
All my data I have entered inside Gnucash 3.7,Ubuntu. No imports! Scheduled
are ok!
Just simple invoices inside the program!
The SQL type conversions inside Postgres give better results with 22:00 but
21:00 s
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
It is a good idea to automatically split (in settings options) all the
accounts receivable and accounts payable by customers and vendors having
separate accounts for the reports usable by the owner and auditors!
>
> On Apr 29, 2020 at 21:28, mailto:d...@davidwhiting.me.
I have the same question. I hope someone can answer.
I'd put it more basically. I am a novice to GnuCash with no formal
accountancy training other than reading the (really good!) introduction in
the GnuCash documents, plus 10 years struggling with accounts in Excel. What
I wonder is, is there a "r
Just a thought - if you change the account parent away from A/R can you then
change the type?
HTH,
Maf.
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 i
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-
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 d
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
> trans
Dimon,
I'm in Silicon Valley, so 10 hours behind you.
By "simple invoices" do you mean that some of the transactions are created
using business invoices?
My book goes back to 1993 and entry_dates begin in 2001. We changed the
transaction time from local midnight in early 2011 so `select distin
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 no
On 4/29/20 12:21 PM, Ruaraidh wrote:
> I have the same question. I hope someone can answer.
>
> I'd put it more basically. I am a novice to GnuCash with no formal
> accountancy training other than reading the (really good!) introduction in
> the GnuCash documents, plus 10 years struggling with acco
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
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
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
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
David,
I was not talking from URLs in comments, but the URL field in the header
of the bugzilla form. That would be much faster found in longer reports.
Stay healthy
Frank
Am 28.04.20 um 09:19 schrieb D.:
> Frank,
>
> I don't understand; comment number 2 on
> https://bugs.gnucash.org/show_bug
Please remember to copy the list on all replies.
I take it that that means that you do in fact use the business invoice
features. Let's see if that's the source of the problem. Run this query:
select t.post_date::TIME count(t.post_date::TIME) from transactions as t inner
join invoices as i on i
Having more than one account of type A/R or A/P might cause problems. They are
special types used just for the business features. Manual entries should be
normal asset and liability accounts but they can be children of the special A/R
and A/P types.
If editing the XML directly is an issue, perh
On 4/29/2020 3:21 PM, Guardrail wrote:
I find it kind of weird that the law allows couples to have joint assets,
liabilities, income and expenses, but doesn't allow them to report jointly
for tax purposes (unless, I guess, they go into proper business partnerships
and maintain formal business ac
On 4/29/20 1:37 PM, david whiting wrote:
> 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
Create a new account in the desired location, & then delete the old
account. When you attempt to delete it, there will be a prompt asking
what to do with the transactions. Select "Move to new account" (or
similar verbiage), & then delete the account.
On 2020-04-29 15:03, Stephen M. Butler wr
I'm in the UK where married couples are taxed separately and have to file
separately. I'm not a tax expert, but I've just googled it and find
confirmation on both government and accountants' web sites: husbands and
wives (the words used on the web sites - I'm not sure about other types of
couple) h
Already reported earlier today, that doesn’t work.
I suggested it earlier, and then tested it on my own book. Indeed, once there
are transactions in the errant account, it cannot be changed. This must be
something specific to type A/R and/or A/P accounts.
Regards,
Adrien
> On Apr 29, 2020 w18d
If the number of transactions involved is small enough to consider fixing
one at time, one could set up the proper tree, perhaps append _bad to the
incorrect account name, then, from a transfer account change transaction s
one at a time.
On Wed, Apr 29, 2020, 7:56 PM Adrien Monteleone <
adrien.mo
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
Hi Geert,
I think options 2-5 are too disruptive and more work than the benefits deserve.
Re option 1,
I’d prefer to put logs and backups in separate folders. Maybe (going with your
name) book.dir/backup and book.dir/log. Many people seem to be confused about
what all these long filename
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
CVS works fine. I can still read the data I need to by opening the GC file
with my script, checking to see what entries I’ve already added, and add the
ones that are still needed to a temporary CSV file I import.
That works fine.
I just want don’t want to have to do the math.
Eventually, afte
Interesting!
Did you consider having GC use XML in your save file instead of SQL?
If I do pursue this, I’ll be glad to make the code available and let people
know what happens.
Hal
> On Apr 28, 2020, at 5:41 PM, Stu Perlman wrote:
>
> Hal,
>
> I'm sort of doing a liter version of what you
40 matches
Mail list logo
