Re: [GNC] Unable to Refine Existing Search

[Derek Atkins]

Hi,

On Fri, May 17, 2024 2:43 am, Patrick Skelton wrote:
> Hi Derek,
>
> In the absence of tags in GnuCash, I thought I would use the *Number
> *field
> as a pseudo tag since I am not using it for anything else.
>
> So my search would be along the lines of *AFTER-dd/mm/yy AND
> BEFORE-dd/yy/mm AND CONTAINS-STRING-[tag]*. Then what I'd want to do it
> run
> the search again with the same date constraints but a different tag. So,
> it
> appears your answer means I will simply have to re-enter the date range
> every time.

Correct, you cannot change the existing query, you can only augment it.
So yes, you will need to re-enter the whole query in order to change the
"contains string".

>
> I am an absolute amateur when it comes to accounts, but it does seem to me
> that the GnuCash could be improved in this area. Tags would be great, as
> would a bit more flexibility on custom reports.

You need to keep in mind that GnuCash is implemented by volunteers who all
have real Day Jobs, so GnuCash is only done in their free time.  Nobody is
paid to work on GnuCash.  As a result, features can sometimes take a long
time to get implemented, and in general the features that the devs need
get implemented first.

With that in mind, the current query interfaces were written 20 years ago.
 The UI gets translated into QofQuery predicates, which is (unfortunately)
a one-way transform.  It MAY be possible to take a QofQuery and rebuild
the UI, but it would not necessarily map to what you input (because the
structure of the QofQuery gets manipulated based on ANDs and ORs getting
unrolled).

Having said all that, yes, Tags would be a great addition.  Patches always
welcome!  :)

> Thank you for your answer.
>
> Kind wishes - Patrick

-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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Simultaneous access

[Derek Atkins]

Hi,

On Wed, May 15, 2024 7:14 pm, Chris Miller wrote:
>  The application gnucash does NOT support multiple simultaneous
>  access.
>  That would require a DBM (database manager)
>
>Apparently there are a variety of DBM "back-ends". If I configure
>Postgress, for example, do I get simultaneous access?

No.  The DBM is just used as a storage system.  GnuCash is not a DB App,
which is what would be required to actually support simultaneous usage. 
It's on the roadmap to get there, but at the current rate I expect to see
it somewhere in the 2030s.

>Thanks for the help,
>Chris.
>Laboriously sent to you from my ... do you really care?

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to Refine Existing Search

[Derek Atkins]

David,

On Wed, May 15, 2024 12:07 pm, David Carlson wrote:
> I vaguely recall asking for an enhancement a few years ago to show the
> search criteria along with the results but I have forgotten whether that
> was in Bugzilla or in that other place which I now cannot even remember
> the
> name of.

UserVoice?

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to Refine Existing Search

[Derek Atkins]

Hi,

On Tue, May 14, 2024 3:24 am, Patrick Skelton wrote:
> Hi,
>
> If I do a *Find* in GnuCash using a handful of criteria, it does what I'd
> expect.
>
> If I then want to modify this existing *Find*, I cannot see how to do
> this.
> If I select the same operation again from the menu while the currently
> active tab contains my current find results, and then I click on either
> 'Refine current search' or 'Add results to current search', the original
> criteria I set are gone, so basically I am just doing a new search and
> have
> to enter all the criteria again.

No, the initial criteria are still there -- just inaccessible.  You're
just appending to them with an additional AND statement (refine) or OR
statement (add results).

>
> Is there a way to modify the search criteria already used or perhaps even
> save a set of criteria so they can be re-run.

No.

> I realise what I am really wanting here is a custom report but I need it
> to
> contain only records containing a certain string and I can't see how to
> get
> the reporting to do this.

Could you go into more details about what it is, exactly, you're trying to
do?

> Kind wishes - Patrick

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] [ERR-MAINT] GnuCash-Devel list config (and sub list) reverted to OLD config

[Derek Atkins]

Hi GnuCashers-

TL;DR:

As some of you may have noticed, email to GnuCash-Devel has been, well,
wonky.  The short version is that due to a cascade of issues and failures,
the list configuration was reverted to an old config, including the
subscription list.  This caused several hundred old subscriptions to
re-appear, and several hundred newer subscriptions to disappear. 
Unfortunately the only remedy is to re-subscribe to the list.

LONG VERSION

The GnuCash server is set up for a daily backup.  This backup creates an
LVM snapshot so the backup has a stable dataset during the ~4-hour backup
process.  When the backup finishes, the snapshots are removed.  All well
and good.

Unfortunately, at some point (unknown) there was a system failure during
that backup window which caused the snapshots to remain, and not get
cleaned up.  System failures like this happen frequently (mostly due to
the VM host spontaneously rebooting, which happens a couple times a year).
 However usually the system cleans up after the failure.  This time, for
some reason, that cleanup did not occur.

Simultaneously, the backup server email system wedged and stopped sending
out status emails, so I didn't get notified of the backup failures.

The leftover snapshot eventually filled up, which caused the gnucash-devel
list to fail to write out its config file in a catastrophic way.  This
resulted in a corrupted config.pck.  Mailman, "helpfully", reverted back
to its config.db, which was its configuration back in 2002.  This caused
the list to disappear, due to old old changes.

So why not revert to another backup?  Two reasons:

1. It's unclear exactly when this failure occurred, so there's not a good
way to know which backup to revert to.
2. Due to the snapshot failure, the backups were not running for way too
long.  The previous backup was from October 2023!

I apologize for all the inconveniences if you unsubscribed in the past and
somehow found yourself receiving gnucash-devel mail again.  I also
apologize for those who will have to re-subscribe because your
subscription was lost.

Going forward, I've made additional changes to recover if there is a
leftover snapshot to attempt to prevent this kind of failure.  I've also
been paying much closer attention to the daily log emails and backup logs
to keep this from happening again.

Thanks,

-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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bill total does not match real total

[Derek Atkins]

Hi,

On Wed, March 6, 2024 12:20 pm, Carl Linkletter via gnucash-user wrote:
> I am entering a bill. I have 2 entries (65.62 and 374.10). It says that
> the total is 493.73. I am sorry, but the total should be 439.72. The issue
> is persistent and appears to be related to the 65.62 number. If I remove
> it and put another entry in, the total is correct. I have Taxable? and Tax
> Included both checked.

This last part is the key to the issue.  It's a rounding error.  The issue
is that each line-item is rounded, but the invoice sums the natural number
and rounds at the end.  So what's happening here is that you have 374.1x
which rounds to 374.10, and you have 65.6y which rounds to 65.62, but when
you add x + y you get a sum that rounds up to the next penny.

E.g., 65.624 + 372.104 = 437.728 which rounds to 437.73

> GnuCash 5.5 on Ubuntu 22.04.3
>
> Peter Carl Linkletter
> VMware Consultant and VMware Certified Instructor

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Inconsistent MySQL databases

[Derek Atkins]

Hi,

On Fri, March 1, 2024 9:21 am, Ira Fuchs wrote:
> My MySQL client shows tables sizes.

I would never trust that different versions of databases would store it
the same way..

Use a Query to see how much data is in the table.  For example:

  select count(*) from XXX;

This will tell you how many rows are in the table, which will be MUCH more
accurate that looking at "table size."

-derek

>
>> On Mar 1, 2024, at 9:02 AM, Derek Atkins  wrote:
>>
>> What queries are you running to compare the two databases?
>>
>> -derek
>>
>> On Fri, March 1, 2024 8:53 am, Ira Fuchs wrote:
>>> They are precisely the same. No changes have been made during this
>>> test.
>>> One difference is that one MySQL is running 8.0.22 and the other is
>>> 8.0.36
>>> but that should not affect the gnucash data table row numbers.
>>>
>>>> On Mar 1, 2024, at 8:38 AM, Derek Atkins  wrote:
>>>>
>>>> Hi
>>>>
>>>> On Fri, March 1, 2024 8:30 am, Ira Fuchs wrote:
>>>>> I have 2 instances of MySQL to which I save copies of my Gnucash
>>>>> data.
>>>>> I
>>>>> have gnucash open with an xml file and I do a save to the first
>>>>> instance
>>>>> and then I reopen the XML file and Save again, this time to another
>>>>> MySQL.
>>>>> In both cases the save proceeds normally after warning the file will
>>>>> be
>>>>> overwritten. I then examine the 2 files and in particular the number
>>>>> of
>>>>> records in the transactions, slots, and splits tables and find that
>>>>> they
>>>>> are different by 1000s of rows. (It doesn’t matter if I do the save
>>>>> from
>>>>> xml->MySQL(1)-MySQL(2) or xml->MySQL(1)-XML->MYSQL(2).
>>>>> Can anyone explain to me why there would be any difference in these 2
>>>>> SQL
>>>>> files?
>>>>
>>>> I cannot explain why they are different, however, in case #2 have you
>>>> compared the two XML files to ensure they are the same?
>>>>
>>>> -derek
>>>>
>>>>> 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
>>>>
>>>
>>>
>>
>>
>> --
>>   Derek Atkins 617-623-3745
>>   de...@ihtfp.com www.ihtfp.com
>>   Computer and Internet Security Consultant
>>
>
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Inconsistent MySQL databases

[Derek Atkins]

What queries are you running to compare the two databases?

-derek

On Fri, March 1, 2024 8:53 am, Ira Fuchs wrote:
> They are precisely the same. No changes have been made during this test.
> One difference is that one MySQL is running 8.0.22 and the other is 8.0.36
> but that should not affect the gnucash data table row numbers.
>
>> On Mar 1, 2024, at 8:38 AM, Derek Atkins  wrote:
>>
>> Hi
>>
>> On Fri, March 1, 2024 8:30 am, Ira Fuchs wrote:
>>> I have 2 instances of MySQL to which I save copies of my Gnucash data.
>>> I
>>> have gnucash open with an xml file and I do a save to the first
>>> instance
>>> and then I reopen the XML file and Save again, this time to another
>>> MySQL.
>>> In both cases the save proceeds normally after warning the file will be
>>> overwritten. I then examine the 2 files and in particular the number of
>>> records in the transactions, slots, and splits tables and find that
>>> they
>>> are different by 1000s of rows. (It doesn’t matter if I do the save
>>> from
>>> xml->MySQL(1)-MySQL(2) or xml->MySQL(1)-XML->MYSQL(2).
>>> Can anyone explain to me why there would be any difference in these 2
>>> SQL
>>> files?
>>
>> I cannot explain why they are different, however, in case #2 have you
>> compared the two XML files to ensure they are the same?
>>
>> -derek
>>
>>> 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
>>
>
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Inconsistent MySQL databases

[Derek Atkins]

Hi

On Fri, March 1, 2024 8:30 am, Ira Fuchs wrote:
> I have 2 instances of MySQL to which I save copies of my Gnucash data. I
> have gnucash open with an xml file and I do a save to the first instance
> and then I reopen the XML file and Save again, this time to another MySQL.
> In both cases the save proceeds normally after warning the file will be
> overwritten. I then examine the 2 files and in particular the number of
> records in the transactions, slots, and splits tables and find that they
> are different by 1000s of rows. (It doesn’t matter if I do the save from
> xml->MySQL(1)-MySQL(2) or xml->MySQL(1)-XML->MYSQL(2).
> Can anyone explain to me why there would be any difference in these 2 SQL
> files?

I cannot explain why they are different, however, in case #2 have you
compared the two XML files to ensure they are the same?

-derek

> 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
-
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 more than one government tx to client invoice

[Derek Atkins]

You can make a combined tax table that includes all of the taxes.
Please RTFM for how to encode the tax rates. There are examples for a 
PST+GST use case.

-derek
Sent using my mobile device. Please excuse any typos.
On February 25, 2024 20:57:42 Jediator  wrote:


I don't see including multiple tax tables in one invoice item is
possible.  But if you don't need to itemize your taxes, you can create a
combined tax table.  Another option would be to create separate invoice
items as tax items, and specify the tax rate in the Quantity field
(e.g., 8% = 0.08), and map the taxes to appropriate expense accounts.
This way (preferred in your case), you can have an itemized invoice with
individual tax items.  -- JC

On 2/25/24 7:43 PM, Bill McGuire wrote:
Hi. I live in B.C., Canada, the land of the taxed.  I am required to charge 
my clients 2 provincial taxes, Prov. Sales tax and Muncipal Regional 
District tax, as well as the federal Goods and Services Tax (GST). I can 
create tax tables for all three, but can only see a way to add one of the 
taxes (tx tables) to the invoice.  Is there a way that I can incorporate 
all three taxes on the invoice (other than Just lumping them all together 
in one tx table and manually figuring out how much of the lumped taxes get 
remitted to each gov. department)?

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
-
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] New user error

[Derek Atkins]

I presume you mean Tools -> General Journal ?

-derek

On Thu, February 8, 2024 9:58 am, Michael or Penny Novack wrote:
> On 2/7/2024 11:11 PM, Adrien Monteleone wrote:
>> Michael,
>>
>> Transaction Journal View is simply the same full transaction
>> accessible via either 'Split' or 'Auto-Split' but for all transactions
>> - *not* one at a time.
>
> Yes of course, can have on your screen "journal view" for all
> transactions affecting the account. But that is NOT "full journal view".
> Gnucash is "virtual journal" but you can get gnucash to show you that
> (full journal).
>
> By "full journal" I mean something looking like what would have been
> used in old pen and ink on paper days. The entries in date order no
> matter what accounts were involved.
>
> See what the report "General Journal" gives you.
>
>
> 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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] No such file or directory error finding libgnc-expressions-guile.so

[Derek Atkins]

Correct, it would say something like that.
Now, it could be that there is a sub-library missing.  I.e. this library
looks for libfoo.so (which it finds), but libfoo.so depends on libbar.so,
and THAT is missing.  ldd would not show that.

So, question for you:  did you do a full system update, or did you JUST
update the gnucash packages?  I only ask because I am running F38 and I
have GnuCash 5.5 running just fine.

-derek

On Thu, January 25, 2024 11:33 am, John Haiducek wrote:
> Here's the output from ldd. IIRC, missing dependencies would show up here
> as something like "=> Not found". It looks like everything here points to
> a
> specific file.
>
> $ ldd /usr/lib64/gnucash/libgnc-expressions-guile.so
> linux-vdso.so.1 (0x7ffe3cf5a000)
> libgnc-expressions.so => /usr/lib64/gnucash/libgnc-expressions.so
> (0x7ff5df86a000)
> libguile-3.0.so.1 => /lib64/libguile-3.0.so.1 (0x7ff5df6e3000)
> libgnc-engine.so => /usr/lib64/gnucash/libgnc-engine.so
> (0x7ff5df20)
> libglib-2.0.so.0 => /lib64/libglib-2.0.so.0 (0x7ff5df59a000)
> libc.so.6 => /lib64/libc.so.6 (0x7ff5df022000)
> libgnucash-guile.so => /usr/lib64/gnucash/libgnucash-guile.so
> (0x7ff5def0a000)
> libgnc-app-utils.so => /usr/lib64/gnucash/libgnc-app-utils.so
> (0x7ff5df504000)
> libgobject-2.0.so.0 => /lib64/libgobject-2.0.so.0 (0x7ff5deeaa000)
> libgnc-core-utils.so => /usr/lib64/gnucash/libgnc-core-utils.so
> (0x7ff5dee6e000)
> libgc.so.1 => /lib64/libgc.so.1 (0x7ff5ded2c000)
> libffi.so.8 => /lib64/libffi.so.8 (0x7ff5df4f8000)
> libunistring.so.2 => /lib64/libunistring.so.2 (0x7ff5deb7e000)
> libgmp.so.10 => /lib64/libgmp.so.10 (0x7ff5dead9000)
> libcrypt.so.2 => /lib64/libcrypt.so.2 (0x7ff5deaa)
> libm.so.6 => /lib64/libm.so.6 (0x7ff5de9bf000)
> /lib64/ld-linux-x86-64.so.2 (0x7ff5df88a000)
> libicui18n.so.72 => /lib64/libicui18n.so.72 (0x7ff5de60)
> libicuuc.so.72 => /lib64/libicuuc.so.72 (0x7ff5de20)
> libgmodule-2.0.so.0 => /lib64/libgmodule-2.0.so.0 (0x7ff5df4ed000)
> libstdc++.so.6 => /lib64/libstdc++.so.6 (0x7ff5dde0)
> libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x7ff5de99b000)
> libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x7ff5de566000)
> libgio-2.0.so.0 => /lib64/libgio-2.0.so.0 (0x7ff5ddc2d000)
> libboost_filesystem.so.1.78.0 => /lib64/libboost_filesystem.so.1.78.0
> (0x7ff5de979000)
> libboost_locale.so.1.78.0 => /lib64/libboost_locale.so.1.78.0
> (0x7ff5de4c4000)
> libicudata.so.72 => /lib64/libicudata.so.72 (0x7ff5dbe0)
> libz.so.1 => /lib64/libz.so.1 (0x7ff5de95f000)
> libmount.so.1 => /lib64/libmount.so.1 (0x7ff5de47e000)
> libselinux.so.1 => /lib64/libselinux.so.1 (0x7ff5de451000)
> libboost_atomic.so.1.78.0 => /lib64/libboost_atomic.so.1.78.0
> (0x7ff5de955000)
> libboost_system.so.1.78.0 => /lib64/libboost_system.so.1.78.0
> (0x7ff5de95)
> libboost_thread.so.1.78.0 => /lib64/libboost_thread.so.1.78.0
> (0x7ff5de431000)
> libboost_chrono.so.1.78.0 => /lib64/libboost_chrono.so.1.78.0
> (0x7ff5de945000)
> libblkid.so.1 => /lib64/libblkid.so.1 (0x7ff5de1c8000)
>
> On Thu, Jan 25, 2024 at 11:15 AM Derek Atkins  wrote:
>
>> Run:
>>   ldd /usr/lib64/gnucash/libgnc-expressions-guile.so
>>
>> And see if perhaps it is missing a dependency?
>>
>> -derek
>>
>> On Thu, January 25, 2024 11:07 am, John Haiducek wrote:
>> > The file and its parent directory are both world-readable
>> >
>> > On Thu, Jan 25, 2024 at 10:46 AM R Losey  wrote:
>> >
>> >> This is probably a silly question, but does the .so file have
>> >> permissions
>> >> that let it be read by your account? And/or what about the
>> >> containing directory?
>> >>
>> >>
>> >> On Thu, Jan 25, 2024 at 9:19 AM John Haiducek 
>> >> wrote:
>> >>
>> >>> After upgrading to gnucash 5.5 on Fedora 38 (using the rpm package
>> for
>> >>> gnucash from the Fedora repos), I get the following error trying to
>> >>> start
>> >>> gnucash:
>> >>>
>> >>> $ gnucash
>> >>> Backtrace:
>> >>> In ice-9/boot-9.scm:
>> >>>   3536:20 19 (_)
>> >>>2835:4 18 (save-module-excursion #> ice-…>)
>> >>>   3556:26 17 (_)
>> >>> In unknown file:
>> >>>   16 (primitive-load-path "gnucash/report/html-utilities"
>> #<…>)
>> >>> In html-utilities.s

Re: [GNC] No such file or directory error finding libgnc-expressions-guile.so

[Derek Atkins]

Run:
  ldd /usr/lib64/gnucash/libgnc-expressions-guile.so

And see if perhaps it is missing a dependency?

-derek

On Thu, January 25, 2024 11:07 am, John Haiducek wrote:
> The file and its parent directory are both world-readable
>
> On Thu, Jan 25, 2024 at 10:46 AM R Losey  wrote:
>
>> This is probably a silly question, but does the .so file have
>> permissions
>> that let it be read by your account? And/or what about the
>> containing directory?
>>
>>
>> On Thu, Jan 25, 2024 at 9:19 AM John Haiducek 
>> wrote:
>>
>>> After upgrading to gnucash 5.5 on Fedora 38 (using the rpm package for
>>> gnucash from the Fedora repos), I get the following error trying to
>>> start
>>> gnucash:
>>>
>>> $ gnucash
>>> Backtrace:
>>> In ice-9/boot-9.scm:
>>>   3536:20 19 (_)
>>>2835:4 18 (save-module-excursion #)
>>>   3556:26 17 (_)
>>> In unknown file:
>>>   16 (primitive-load-path "gnucash/report/html-utilities" #<…>)
>>> In html-utilities.scm:
>>>  32:0 15 (_)
>>> In ice-9/boot-9.scm:
>>>   3927:20 14 (process-use-modules _)
>>>222:17 13 (map1 (((gnucash report report-core
>>>   3928:31 12 (_ ((gnucash report report-core)))
>>>   3326:17 11 (resolve-interface (gnucash report report-core) #:select
>>> …)
>>> In ice-9/threads.scm:
>>> 390:8 10 (_ _)
>>> In ice-9/boot-9.scm:
>>>   3252:13  9 (_)
>>> In ice-9/threads.scm:
>>> 390:8  8 (_ _)
>>> In ice-9/boot-9.scm:
>>>   3536:20  7 (_)
>>>2835:4  6 (save-module-excursion #)
>>>   3556:26  5 (_)
>>> In unknown file:
>>>4 (primitive-load-path "gnucash/report/report-core" #)
>>> In report-core.scm:
>>>  26:2  3 (_)
>>> In unknown file:
>>>2 (load-extension "libgnc-expressions-guile" "scm_init_sw…")
>>> In system/foreign-library.scm:
>>>190:25  1 (load-foreign-library _ #:extensions _ # _ #:search-path
>>> …)
>>> In unknown file:
>>>0 (dlopen "libgnc-expressions-guile.so" 1)
>>>
>>> ERROR: In procedure dlopen:
>>> In procedure dlopen: file "libgnc-expressions-guile.so", message
>>> "libgnc-expressions-guile.so: cannot open shared object file: No such
>>> file
>>> or directory"
>>>
>>> I can confirm that /usr/lib64/gnucash/libgnc-expressions-guile.so
>>> exists.
>>> Obviously this looks like a bug, but I'm not sure if it's a gnucash bug
>>> or
>>> a packaging problem on the Fedora side. Can anyone help me figure out
>>> which
>>> it is? Any possible workarounds to try?
>>> ___
>>> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] I did not know this (was: Windows x64 release builds are missing)

[Derek Atkins]

One thing to consider is the ability to run a 64-bit Win-11 build server,
or, rather, HOW we will create a 64-bit windows build server.

-derek

On Fri, January 19, 2024 12:36 pm, Dean Gibson wrote:
> However, I think there were later, technically 64-bit processors that
> did not include a few required 64-bit instructions (eg, "Compare and
> Swap"), so that Win-64 would not install on them.
>
> I think the original Intel & Lenovo "compute sticks" fell into that
> category, circa 2015?
>
> A trip down memory lane.
>
> -- Dean
>
>
>
> On 2024-01-19 09:06, john wrote:
>> Considering that the last 32-bit processor from Intel was the Pentium 4E
>> released in 2004 and the last AMD one was 2005's K5 it's a tiny
>> minority. Regardless of Win11's ability to run 32-bit programs, it
>> requires a 64-bit processor
>> (https://www.microsoft.com/en-us/windows/windows-11-specifications) so
>> when Win10 goes out of support so does the need for 32-bit GnuCash
>> builds.
>> We're scheduled to release GnuCash 6 in January 2026 so that seems like
>> the right time to make the switch.
>>
>> Regards,
>> John Ralls
>>
> ___
> 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.
>


-- 
   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
-
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: Import assistant, room for big improvements

[Derek Atkins]

No, I would call that the description.
-derek
Sent using my mobile device. Please excuse any typos.
On January 15, 2024 23:06:07 Phyllis Bruce  wrote:


Thanks, David.  I think I am being unclear.  My research provides what you
call the transfer account for unmatched items.  That's all good.  It is the
memo field which I use to remind me of what I did that is not available in
the reconciliation screen.  For instance I want to remember that I paid
Amazon for *smart plugs*, or Sandi paid me $70 for *her share of groceries
at Christmas*.  Would you call that the "action"?

On Mon, Jan 15, 2024 at 3:21 PM David Cousens 
wrote:


Ulrich,

There is nothing to stop you supplying the transfer account information in
an
import record if it is available. There is a header which can be assigned
to the
appropriate column of your input file for the transfer account.

The first time you import with a given account name in he record you will
be
asked to specify the internal GnuCash account to which it corresponds.
After
that it will be matched to that account.

The Bayesian process only assigns a probable account in cases where the
import
record does not specify the  transfer account.

David Cousens

On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> Hello fellow GnuCash users,
>
> I wonder if there are plans on improving the import filter, for importing
> bank transfers.
> The situation now is, that some hidden engine tries to learn from doing.
> But the truth is, that even after one year of importing bank transfers, I
> have to check every single transaction, since errors keep occurring. If I
> miss an error, this transaction is put in the wrong ledger account.
>
> E-boekhouden.nl uses an import assistant where you can specify a ledger
> account number, other keywords and/or amounts of money. The import
> assistant puts the transactions into the right ledger account, with far
> less errors than with GnuCash. In fact, only where a specific keyword,
> leger number or amount is missing, or where no import rule is made for a
> specific payment, the transaction has to be placed into the right general
> ledger by hand.
>
> Have a nice day!
>
> --
> नमस्ते (Namasté),
> Ulrich
>
>
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> ¤º°`°º¤ø
>
> " Can't talk to you without talking to me; we're guilty of the same old
> thing.
> Thinking a lot about less and less, and forgetting the Love we
> bring "
>  [Grateful Dead, in: 'Althea']
>
>
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> ¤º°`°º¤ø
>Mijn blog: ✡ theskepticaltheist.eu ✡
> ___
> 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] how to encode ATM withdrawals with fees

[Derek Atkins]

I just do it simply by taking the amount in the foreign currency and the
TOTAL amount that affects my bank, and roll any fees into the exchange
rate.  So in your case, a simple transaction of 10,000 JPY to 4282.49 PHP.

Unless there is really some required reason to keep track of the fees?

-derek

On Sun, January 14, 2024 11:04 am, Gio Bacareza wrote:
> when withdrawing at a foreign location, most of the time you get charged a
> fee. So, for example, your bank is in PHP, then when you're in Japan, you
> withdraw in JPY.
>
> Here are the facts:
> 1. You receive JPY10,000.00
> 2. ATM charges JPY110.00
> 3. Your local bank shows a withdrawal of PHP4282.49
> 4. At the time of this transaction the exchange rate was: JPY1 = PHP0.3928
> or PHP1 = JPY2.5456
>
> in GNUCASH, the splits I have are:
>
> Account Deposit Withdrawal
> JPYCash JPY1 0
> Fee PHP PHP43.21 0
> Imbalance PHP PHP311.28 0
> Trading:CURRENCY:PHP PHP3928 0
> Local Bank PHP 0 PHP4282.49
> Trading:CURRENCY:JPY 0 JPY1
>
>
> Questions:
> 1. What is the easiest way to do this? I find this one transaction to be
> of
> so many steps. Perhaps there's a way that I don't know of?
> 2. Is there an easier way to specify the 110JPY fee if my base currency is
> PHP? I had to manually convert it using the date's exchange rate to come
> up
> with the equivalent PHP43.21.
> 3. The imbalance-PHP was automatically calculated by GNUCASH. Is this
> considered to be my loss from the difference between the bank's exchange
> rates and the one I used which I got from
> https://www.exchange-rates.org/exchange-rate-history/jpy-php?
>
> Thanks
>
> gio
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnu-cash users to meet in person?

[Derek Atkins]

Amusingly I happen to be in Shelton for the next couple days...

-derek

On Sun, January 7, 2024 9:28 pm, Steve Freeman wrote:
> Do any gnu-cash user groups meet in person? I'd like to meet and perhaps
> occasionally work with other gnu-cash users.
>
> If no groups exist, but any of you might care to meet with another user,
> please direct reply.
>
> I live in central Connecticut and would be happy to host a group.
>
> I travel occasionally to New York (especially Westchester), New Jersey,
> Philadelphia, Vermont and Boston and would be happy to meet with any users
> in any of these areas.
>
> Thanks, Steve
>
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF import Failed

[Derek Atkins]

This isn't a GnuCash thing. It's a QIf thing.
-derek
Sent using my mobile device. Please excuse any typos.
On January 7, 2024 19:58:30 Fred Tydeman  wrote:

Thank you.

Is that documented somewhere in Gnucash?

On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins  wrote:
Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
Income/Expense account (Category).
-derek


___
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] QIF import Failed

[Derek Atkins]

Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
Income/Expense account (Category).
-derek

On Sun, January 7, 2024 6:53 pm, Geoff wrote:
> Hi Fred
>
> At a guess I think the problem is the square brackets "[]" surrounding
> the Account Names - try removing them.
>
> This:
>  > L[Expenses:fees]
>
> Should be:
>  > LExpenses:fees
>
>
> Regards
>
> Geoff
> =
>
> On 7/01/2024 2:01 pm, Fred Tydeman wrote:
>> Running GC 4.14 on Linux
>> During an import of a QIF file, I am getting "Failed" on the QIF Import
>> screen.
>> The message at the top of the box says there should be details shown
>> below
>> for my review.  However, there are no details about the failure.
>>
>> Suggestions on where I should look for the details of the failure?
>>
>> The entire QIF file is:
>>
>> !Account
>> NAssets:Investments
>> TInvst
>> ^
>> !Type:Invst
>> ^
>> D02/26/2021
>> NMiscExp
>> CX
>> T0.12
>> Mfee
>> L[Expenses:fees]
>> ^
>> D03/31/2021
>> NMiscExp
>> CX
>> T0.24
>> Mfee
>> L[Expenses:fees]
>> ^
>> D04/30/2021
>> NMiscExp
>> CX
>> T0.38
>> Mfee
>> L[Expenses:fees]
>> ^
>> D05/28/2021
>> NMiscExp
>> CX
>> T0.51
>> Mfee
>> L[Expenses:fees]
>> ^
>> D06/30/2021
>> NMiscExp
>> CX
>> T0.64
>> Mfee
>> L[Expenses:fees]
>> ^
>>
>> As an experiment,
>> I changed
>>   L[Expenses:fees]
>> to
>>   LFees
>>
>> and that imported just fine (although I had to pick the mapping of Fees
>> to
>> Expenses:Fees during the import process).
>> ___
>> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Discount / Coupon question - How to apply?

[Derek Atkins]

On Tue, January 2, 2024 12:31 pm, Alan Johnson via gnucash-user wrote:
> Thanks, that worked. 
>
> Perhaps a future feature to add a coupon/discount mechanism to the
> customer invoice interface would be in order?

Patches always welcome!  :)
>
> Alan

> 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
-
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 for multiple users

[Derek Atkins]

Sorry. no.
-derek

On Wed, December 27, 2023 1:33 pm, Martijn Heuts wrote:
> Hello, I have been an active user for a decade now but I have been out of
> the loop for updates.
>
> Are there any options for having GNU on multiple computers to where GNU
> can be used at the same time?
>
> Thanks!
>
> Martijn
> usadutch...@bellsouth.net
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] IRC access

[Derek Atkins]

Hi,

On Tue, December 19, 2023 1:13 pm, Mark at Lorimark wrote:
> When I try to 'join' #gnucash on libera.chat I get;
>
>> Cannot join #gnucash (Channel is invite only).

We are not on libera.chat -- we are at irc.gimp.net.

-derek

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Nice to Have?

[Derek Atkins]

The "Since Last Run" dialog is what you want -- it will display all the
SXes that are being processed "today".

-derek

On Thu, December 14, 2023 11:19 am, Grace wrote:
> I don't know if this is the correct place to ask for a "Nice to Have".
>
> My request is that the window that displays scheduled transactions to be
> posted today, could only display those transactions being posted today.
> At the moment it displays all the scheduled transactions. For me it
> would be nice if it just showed those being processed today.
>
> Grace
>
> ___
> 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.
>


-- 
   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
-
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 delete unposted invoice?

[Derek Atkins]

Hi,

On Wed, December 13, 2023 2:46 pm, Eric Chapman wrote:
> I accidentally put in an invoice dated 01/01/2023 for a customer. There
> are no amounts in it (i.e., it's zero). I can't figure out how to delete
> it.
>
> Attached is a screenshot of the invoice. I've tried "Delete" and
> "Cancel", but don't know what else to try.

There is no way to delete it.  Just make sure it is unposted and then
re-use it..  Assign it to another customer and move on.

>
> Thank you!

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Have I got my USD accounts set up wrong?

[Derek Atkins]

Hi,

GnuCash stores the exchange rates in two ways:

1) In the transaction, it lets you record the exact conversion.
2) In the priceDB, it lets you input one price per day.

When you enter a transaction like #1, gnucash will automatically create a
pricedb entry for you.  In other words, you do NOT need manually enter
prices, you just need to manually enter a cross-currency transaction, and
gnucash will add the pricedb.

This could be a problem, if you enter in the wrong exchange rate -- it
will enter incorrect data into the pricedb.

Even more, the REPORTS only use #2, not #1, to figure out the "value" of
an account in another currency.

Therefore, I suggest you look in the PriceDB at a date similar to the date
of the transaction itself, and ensure you don't have some other exchange
rate listed.

-derek

On Thu, November 30, 2023 7:02 pm, David Kirkby wrote:
> On Thu, 30 Nov 2023 at 20:50, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> As Derek noted, this is likely not a bug, but an issue with your pricedb
>> in your main file.
>>
>> I too lost the plot, and forgot that those reports can target which
>> price to use for such cases.
>>
>> Your options then are to:
>>
>> 1. Play with the price target option
>> 2. Edit, or delete the offending price(s) in the pricedb if not needed
>> elsewhere.
>>
>> Regards,
>> Adrien
>
>
> I am in bed now using my mobile phone so don’t have access to GnuCash to
> look at anything.
>
> I was  unaware of the price db, and have not *knowingly* set anything up
> like I see described here
>
> https://wiki.gnucash.org/wiki/Online_Quotes
>
> Maybe at some time I did mess around and set something up, and that’s what
> it is using.
>
> However, I have noticed sometimes that GnuCash does suggest a number of
> GBP
> to enter for a  USD transaction, and it’s “guess” is not wildly out.  I
> have not taken much notice of the values, but they seem to imply £1 is
> worth more than a USD, but not twice as much.
>
> I am not sure how GnuCash will ever be able to make a meaningful report
> that includes any conversion from pounds to dollars, particularly when
> each
> transaction will have a different exchange rate.
>
> I have tried to keep things simple when USD or EUR payments are made by
> bank transfer, by recording only amount in pounds received. I am not going
> to itemise the bank charge, as it is not recorded in any statement. But
> with PayPal the transaction fee is always recorded in the statements from
> PayPal. There’s a fee even on GBP transactions.
>
> Dave
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Have I got my USD accounts set up wrong?

[Derek Atkins]

In this data file there is a transaction that converts from 540 to 424. 
It sounds like that is correct.  My only guess as to the reporting is that
there are PriceDB entries in your real data file that are "incorrect" for
the actual transaction days.  In the data file you posted, there is only a
single PriceDB entry for USD to GBP with a value of 106/135..  And Lo! and
Behold, 540 * 106 / 135 = 424.

I think this explains why the reports work for the test data.

And you are correct, you cannot remove an INVOICE transaction from AR/AP
directly, you need to unpost the invoice to remove it.  This is by design.

-derek

On Thu, November 30, 2023 9:04 am, David Kirkby wrote:
> This was the message I was thinking of - you can't delete from accounts
> receivable without unposting.
>
> [image: image.png]
>
>
> On Thu, 30 Nov 2023 at 13:37, David Kirkby
> 
> wrote:
>
>> The attached has the single USD/GBP transaction that I'm having problems
>> with the reporting with. But the reporting is fine on this demo.
>>
>> On Thu, 30 Nov 2023 at 13:20, David Kirkby
>> 
>> wrote:
>>
>>> On Thu, 30 Nov 2023 at 12:13, Adrien Monteleone <
>>> adrien.montele...@lusfiber.net> wrote:
>>>
>>>> Apparently so!
>>>>
>>>
>>> I have lost the plot I think.
>>>
>>> I think there's a bug in the reporting.
>>>
>>> Here's a demo account, with the GBP shown correctly for USD sales, but
>>> the value of the USD sales is not given. I don't know if that's
>>> intentional
>>> or not, but having both the GBP and USD would seem nice.
>>>
>>> [image: image.png]
>>>
>>>
>>> But the ones I produced for my accountant have the foreign currency
>>> too,
>>> which is nice. I have not blanked out the $540 transaction, but left
>>> that.
>>> The GBP amount is wrong. But I'm not sure what the intended behavior of
>>> the
>>> report is.
>>>
>>> [image: image.png]
>>>
>>> Looking in the bank account for that transaction I see
>>> [image: image.png]
>>> In the trial balance
>>>
>>> [image: image.png]
>>>
>>> So there are 3 different GBP figures for these reports.
>>> 1) $540 was converted by the bank into £424.00. It shown as that in the
>>> bank account.
>>> 2) P shows $540 and £441.67. The £441.67 is wrong (£17.67 too high).
>>> 3) Trial balance shows £434.98 which is also wrong. (£10.98 too low)
>>>
>>> I suppose it's worth reporting this as a bug, despite the fact I can't
>>> reproduce it in a test case, which would obviously be most helpful to
>>> the
>>> developers.
>>>
>>
> ___
> 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.
>


-- 
   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
-
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?

[Derek Atkins]

Keep in mind that, GENERALLY, the search is on a SPLIT basis, not a
TRANSACTION basis.  So if you do a search on "Account == X AND Account ==
Y" you will get an empty set, because it is impossible to find anything
where Split.account == X and Split.account ALSO equals Y.

-derek

On Tue, November 21, 2023 11:35 pm, Adrien Monteleone wrote:
> Maybe. That's a trial and error sort of situation.
>
> Certainly, you can craft a Find from the Accounts tab with multiple
> criteria, the first should likely find all transactions matching
> Assets:PayPal, then the next might exclude all other accounts, or
> specific accounts. (since it is most likely you would have had an extra
> split to Expenses:PayPal Fees, just exclude that match from the results)
>
> An alternative is to run the first find to get a list. Then with that
> resulting register list open, run another find to narrow it down as
> needed.
>
> Which is the best or shortest route - I have no idea. You'll have to try
> and then see what works best for you.
>
> -
> for the record, all transactions have at least two splits—a debit and a
> credit. I know why you used the terminology you chose, but I put this
> here for clarification. That will be important for you in the future.
>
> Regards,
> Adrien
>
> On 11/21/23 7:43 PM, David Kirkby wrote:
>> I often receive PayPal transactions, which get put into the PayPal
>> account
>> as
>>
>> Credit: Assets: Accounts Receivable (£720.00)
>> Debit: Assets:PayPal  (£720.00)
>>
>> What I should then do is edit the PayPal account so the fees are put in
>> the
>> correct place - for one example transaction
>>
>> Credit: Assets: Accounts Receivable (£720)
>> Debit: Assets:PayPal  (£705.62)
>> Debit: Expenses:PayPal Fees (£21.38)
>>
>> But I quite often forget to do this, so the PayPal account will not
>> reconcile.
>>
>> Is there any way to search to find transactions going into accounts that
>> don't have a second split, or some other way to weed out the ones that
>> have
>> gone into the PayPal account, but don't have an entry in PayPal
>> 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.
>


-- 
   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
-
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 the default "Find" from "Description" to "Value"?

[Derek Atkins]

I think if you ask 100 people what their default "search" is, you'll get
120 different answers.  I don't think any solution is going to work for
everyone.

IMHO, the most reasonable solution would be remembering the last used
search criteria and default to that next time.

-derek

On Wed, November 15, 2023 4:03 pm, Adrien Monteleone wrote:
> Probably 99.23% of my searches, 96.81% of the time, are the same.
>
> Regards,
> Adrien
>
> On 11/15/23 2:57 PM, David H wrote:
>> Good suggestion, I'd like that as well, every time I do a Find I always
>> change it to "Description, Notes or Memo" to cover all the bases :-)
>
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bill allocated to the wrong account

[Derek Atkins]

When you unpost, the payment gets detached.
After you re-post it, you will need to re-attach the payment.
-derek

On Wed, November 15, 2023 8:36 am, David Kirkby wrote:
> I have received a couple of bills from an electronics component supplier.
> These should be allocated as "Stock" but I must have accidentally clicked
> "Travel" instead.(I noticed this after doing a trial balance, and seeing
> some travel there, when I knew there was no travel).
>
> One has been reconciled against the bank account, the other one has not.
>
> I thought the one that had not been reconciled would be easy to correct by
> just unposting, changing the account from Travel to Stock. I did that, and
> it was okay. However, at that point is was shown as unpaid. What's the
> best
> way of paying it?
>
> The more tricky one is the one that has been reconciled to the bank
> account. Can that be corrected easily? If not, I could just leave it as
> Travel and let my accountant know. The amount is quite small - under £10,
> but I would like to get it right if possible.
>
>
>
>
> --
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciling Accounts, Month 6, but not Months 1-5?

[Derek Atkins]

In short, no.
reconciliation is always "from the beginning of time to "
-derek

On Sun, November 12, 2023 6:06 pm, Tom Balazs wrote:
> Is it possible to reconcile April-May if I have not reconciled March-April
> or February-March?
>
> I guess I'm asking because I used the GnuCash Reconcile featurer and it
> appears to me that I can't. That seems strange to me. I just want GnuCash
> to give me a kind of a worksheet where it shows me transactions between my
> chosen BeginDate and EndDate. And it uses "Bank Said Balance Began At",
> and
> "Bank Said Balance Ended At". I enter (or confirm) transactions. I can
> mark
> them as cleared. And then there is "My Bookkeeping Says My Balance Ended
> At" and that is compared to "Bank Said Balance Ended At".
>
> What if in June I imported all transactions to date, but right now all I
> can handle is confirming the May-June transactions.
> What is the best way to confirm transactions. Should I just mark them as
> "cleared"?
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bad date not caught

[Derek Atkins]

Hi,

On Thu, October 12, 2023 10:40 am, Fred Tydeman wrote:
> In an account, I clicked on Duplicate of a transaction.
> I got a small popup with the date field highlighted.
> I typed in 5.19.21  (instead of the correct 5/19/21) and pressed enter.
> That got me the transaction duplicated, but with the
> date of 12/31/1969.
> Seems like the code should warn me about bad date.

What is "bad" about 12/31/1969?  Do you have something against the 60s? 
Something against new year's eve?  Or just don't like the coming 1970s?  A
"Bad Date" (in this context -- not some nightmarish dinner-and-a-movie
horror) would be "12/32/1969".

In all seriousness, GnuCash can't necessarily know if you MEANT to type
12/31/1969 or if it's due to the parsing of your input that results in
'0'.  Clearly, 12/31/1969 is not what you INTENDED, but I wouldn't
necessarily say it is a "bad date".

Having said that, there IS code in GnuCash that prevents adding new
transactions earlier than some specified historic period (e.g. 90 days
ago).  If you have that feature turned on (it is NOT turned on by default)
and this happened, then that would absolutely be a bug.

> I am running GnuCash 4.14
> on Linux Fedora 37

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation of accounts is not permanent

[Derek Atkins]

HI,

One piece of data you don't provide:  what OS/Distro are you using?

For example, if you are on a Mac, there is a known behavior that GnuCash
on Mac ALWAYS opens the last-used gnucash file, regardless of how you open
it.  Even if you double-click on a GnuCash data file, GnuCash on Mac will
still open the LAST USED file, not the one you clicked on.

This behavior has caused many people to think there's a data issue.

-derek

On Tue, September 26, 2023 12:05 pm, Mark Truelove wrote:
> Hi all, I just joined the list. I thought I'd give this a try before
> moving
> to a bug report, because I can't believe this happens to me and no one
> else
> has experienced it.  I did try searching list history as suggested with
> google, but didn't find anything referring to this specifically.
>
> Also, this is not the first time experiencing this phenomenon, probably
> the
> third.
>
> I use gnucash for personal finances, so I have a checking or cash account
> and a number of credit card accounts.  All of these are reconciled several
> times a year as I receive statements, although not always on time every
> month.  However I don't go three months without catching up on all my
> accounts in any case.
>
> Today (and on previous occasions), I started my periodic reconciliations
> because I had statement notifications in email.  I opened my credit card
> to
> reconcile and had the month's statement in a browser window.  At first I
> was unable to match the "beginning of month" figures to fill out the small
> prompt window when reconciling.  After a few glances I realized that it
> was
> trying to match the beginning balance to September of LAST YEAR instead of
> last month.  I have reconciled this account to its statements 9 or10 times
> in the last year, including last month.
>
> In previous months, I reconciled this account and saved it normally, and
> that information was retained for the following months' reconciliations.
> Now when it forgets, it is losing/ignoring several months of previous
> reconciliations, but not all of them (since this account is at least 20
> years old).  When I checked them all, it has forgotten reconciliation data
> for three other accounts as well (while another six accounts in the same
> file are fully up-to date).
>
> I have backups of my files, both through GC's own backup system and my own
> rotating backups.  Loss of data files is not an issue here.  This got me
> thinking, and I went back and reloaded some of these backup files
> directly.  When loaded, they are all missing the same information as my
> current file.
>
> So, one could say, user error - he actually didn't reconcile for months,
> and the files show that.  Unfortunately, I DID reconcile all of these
> accounts, and the program is treating some aspect of the data as if it
> doesn't exist beyond that point, regardless of the source file.
>
> I'm a retired IT pro, an IT Manager and other roles over 40 years.  I know
> how this looks at first glance.  If this hadn't happened to me twice
> previously I wouldn't be taking the time to report this in detail today.
>
> I'm currently running v5.3.  I downloaded 5.4 but haven't upgraded yet bc
> I
> didn't want to compound the problem.  If this is a known issue and 5.4
> fixes it, then great, I'll just upgrade.
>
> I hope this scenario seems familiar to one of the users out there.
>
> __
>
> *Mark Truelove*true9...@gmail.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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Upcoming/future invoices not visible on vendor report

[Derek Atkins]

There are two dates ... The POST date, and the DUE date.
You should set the POST date to when you actually post the bill, and the
DUE date to when you need to pay it.
If the POST date is in the future, then yeah, I wouldn't expect you to see
it.

-derek

On Wed, September 20, 2023 11:00 am, Jediator wrote:
> Hi GC users, I created some invoices for vendors with future dates (e.g.
> 10/16/2023), so I can plan ahead to see what bills are coming.  The
> invoices were created correctly and clearly visible under account
> payable, but they won't show up on vendor report.  Is this a normal
> behavior of GC (designed on purpose) or a software bug?
>
> Thanks a lot! -- JC
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Inventory

[Derek Atkins]

If you are handling a handful of items you could make the stock types work 
for you, but it is not a true inventory system.

-derek
Sent using my mobile device. Please excuse any typos.
On September 12, 2023 20:03:51 "David G. Pickett via gnucash-user" 
 wrote:


Does GNUCash do inventory at least on a small scale?  It seems like a 
security or stock, you could define a price for sales or a recent/current 
cost for supplies, and when you sell or order it might be like a stock sale 
or order.

___
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] Some questions about the Account Summary Report

[Derek Atkins]

HI,

On Thu, August 31, 2023 7:04 am, Chris Green wrote:
> I have just started using the Account Summary Report as an easy way to
> give an overview of the church finances to the PCC members.
>
> There's a couple of things I can't quite understand though, especially
> about the alignment of the columns and the values that appear in them.
>
> The following depends on fixed width fonts to show correctly.
>
> I see, for example. at the top of the report:-
>
>
>
>
> Account CodeAccount title   Balance
>
> Assets�0.00
>Current Assets   �0.00
>   Lloyds   �9,999.60
>
>
> Income�0.00
>Collections  �1,111.11
>Fees �2,222.22
>... ..
>
>
>
> Why is the amount for 'Lloyds' further left than the other amounts? Is
> it simply because it's a lower level sub-account?

Yes.

> What is the meaning of the �0.00 against Assets, Income, etc.  One
> would have expected that the value against Income would be the total
> of all the Income sub-accounts.
>
> Have I got something wrongly configured?

By default it shows the actual account balance, not the rolled-up balance.
There MAY be a report option to roll up balances.

> Chris Green

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reply convention

[Derek Atkins]

It's all about the sender. The list can't do anything about it.
-derek
Sent using my mobile device. Please excuse any typos.
On August 22, 2023 18:22:43 Brad Morrison  wrote:


I know that GnuCash (https://lists.gnucash.org/mailman/listinfo) does
not use the current version of the Mailman mailing list software (now 3,
not 2 - https://www.gnu.org/software/mailman/), but does anyone know if
the various email formatting conventions
(https://wiki.openstack.org/wiki/MailingListEtiquette) can be adjusted
by the mailing list user at the email client level?

Thanks,

Brad


On 7/19/23 14:10, R Losey wrote:

On Wed, Jul 19, 2023 at 5:05 AM Chris Green  wrote:


On Tue, Jul 18, 2023 at 03:28:34PM -0500, R Losey wrote:

On Mon, Jul 17, 2023 at 3:37 AM Paul Feakins  wrote:


On 15/07/2023 01:56, R Losey wrote:

Is there really a convention for replies?

Indeed there is:
https://wiki.openstack.org/wiki/MailingListEtiquette#Replies



Thanks for the link; it isn't specific to GnuCash, but that's okay.

However, it does seem outdated - limiting a line to 72 characters when

most

browsers and email clients are capable of doing line wrap?


Yes, but eyes aren't!  Something around 80 characters (i.e. 72 plus a
bit) is the best line length for our eyes to read.



And plain text only?


What else are you going to do?  Anything more is likely to be
differently interpreted by different users' software so the result you
intend is likely to be lost on many users.  There are standard ways of
indicating emphasis and such using just plain text.



This doesn't appear to be plain text... perhaps I'm associating plain text
with fixed-width fonts.
But if this works, that's fine.

Regarding line length, I thought you could set your browser or email client
to wrap at whatever length one wishes.


_
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.

Re: [GNC] Will GNU CASH work on a Chromebook

[Derek Atkins]

I wouldn't think so.  It's not an app like that.
-derek
Sent using my mobile device. Please excuse any typos.
On August 10, 2023 20:21:33 "Floyd Beck Jr. via gnucash-user" 
 wrote:



Running Version 115.0.5790.160
___
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] Addition to basis

[Derek Atkins]

Hi,

On Tue, August 8, 2023 4:12 pm, Fred Tydeman wrote:
> How does one record an Addition to basis for a stock?
>
> The splits involved are:
>   Income: qualified div
>   Income:  non-qualified div
>   Expense: foreign tax
>   Asset: cash
>   Imbalance -- should be addition to basis
>
> I have tried changing the Imbalance to
>   Asset: stock
> with a price of 0.00, but gnucash adds shares with a price of 1.00

ISTR there are "issues" with this...  Keep in mind, when entering data in
the stock account, you need to enter TWO of the three values (#shares,
price, and value), and GnuCash will compute the third.  Note that it's the
#shares and total value that is stored, the price is always computed.  In
THIS particular case, you can TRY to enter 0 shares and the change in
value, but I'm not 100% sure GnuCash will like that.  It's been a while
since I played in the stock accounts.

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Use again GnuCash

[Derek Atkins]

Sorry, that's beyond my Mac knowledge.
Hopefully a Mac user will be able to answer that for you.
My GUESS is that you just need to File -> Save As and select your iCloud
Drive Folder.  And then on the other computer File -> Open and select it.

Just be careful that only ONE computer has the file open at a time, and
that you shut down GnuCash every time before you open it on another
computer.

Also, I don't know what the cache coherency delay is on iCloud Drive, so
you may need to wait for the files to sync every time you use them.

If you fail to wait, or if you fail to use it one-at-a-time, you can
overwrite and lose data.

-derek

On Sat, August 5, 2023 9:34 am, Emma Larose wrote:
> Thanks, I could open it.
> How to save it on iCloud drive to be able to pen it from different
> computers ?
>
> Emma
>
>
> Le 5 août 2023 à 15:23:02, Derek Atkins (de...@ihtfp.com) a écrit:
>
> Hi,
>
> On the Mac, you cannot double-click a file to get it to open. GnuCash
> will always open the last file it used, regardless of what you click. On
> a Mac, you need to open GnuCash and THEN you can use File -> Open to open
> a desired file. Then, when you exit GnuCash, next time you restart it
> will re-open that file (regardless of what you click on).
>
> If you File -> Open and it says it cannot open the file, please tell us
> what the error is.
>
> -derek
>
> On Sat, August 5, 2023 9:13 am, Emma Larose wrote:
>> Hello,
>>
>> I use again Gnucash after a no use of 3 years.
>> When I open a file.gnucash it doesn’t open in Gnucash either on Mac 2,6
>> version or a Mac 5,3 version.
>> What dit I miss ? What would you suggest ?
>>
>> Best regards,
>>
>> Emma Larose
>> ___
>> 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.
>>
>
>
> --
> Derek Atkins 617-623-3745
> de...@ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Use again GnuCash

[Derek Atkins]

Hi,

On the Mac, you cannot double-click a file to get it to open.  GnuCash
will always open the last file it used, regardless of what you click.  On
a Mac, you need to open GnuCash and THEN you can use File -> Open to open
a desired file.  Then, when you exit GnuCash, next time you restart it
will re-open that file (regardless of what you click on).

If you File -> Open and it says it cannot open the file, please tell us
what the error is.

-derek

On Sat, August 5, 2023 9:13 am, Emma Larose wrote:
> Hello,
>
> I use again Gnucash after a no use of 3 years.
> When I open a file.gnucash it doesn’t open in Gnucash either on Mac 2,6
> version or a Mac 5,3 version.
> What dit I miss ? What would you suggest ?
>
> Best regards,
>
> Emma Larose
> ___
> 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.
>


-- 
   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
-
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 Tabs

[Derek Atkins]

You could find a transaction that touches the zero balance account and then 
click "jump" to open it..  But the off/select/on us probably faster.


-derek
Sent using my mobile device. Please excuse any typos.
On July 26, 2023 18:43:20 Gyle McCollam  wrote:

If my accounts page view does not show zero balance accounts, but I want to 
open a zero-balance account is there a way to do this without changing the 
view, opening, and the changing the view back?




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] Scheduled Transaction - Loan Amortization

[Derek Atkins]

There are pmt, ppmt, and ipmt functions.
-derek
Sent using my mobile device. Please excuse any typos.
On July 25, 2023 15:41:01 Gyle McCollam  wrote:

Is there a formula I can enter in SX that will automatically calculate the 
principal or interest payment on a car loan?  Then is there a way to deduct 
that from the total payment to get the other value, other than TOTAL 
PAYMENT-the formula used  above?



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] Another try at "How to record payments for several items paid with a single transaction?"

[Derek Atkins]

A quick edit..  When you say "enter all transactions from the source 
account" I would say "source asset or liability account".
It can be very confusing entering data from an income, liability, or equity 
account.

-derek
Sent using my mobile device. Please excuse any typos.
On July 24, 2023 07:58:57 Adrien Monteleone 
 wrote:



Chris,

First,

I'd highly recommend while you are getting started to turn on View >
Transaction Journal View.

That way, you see all splits at all times and you don't have to fiddle
with the split function or have things jump around with auto-split view.
It also doesn't hide anything from your view.

While learning double-entry accounting, it is helpful to see what is
going on, just as if you were doing this on paper.

Of course, switch back to Basic or Auto-split at any time, but I found I
prefer the Transaction Journal view at all times. A high percentage of
my transactions have more than 2 splits, and I had to keep expanding
them to view the full info. (rather than see the less than informative
'split' every time)

Second,

I'd recommend if at all possible to form the habit of entering all
transactions from the source account. That is, transactions describe
money moving from one account to another. You'll find errors are greatly
reduced if you always enter transactions from the source, with the first
split as the source side, and then the other splits are the
'destination' accounts. (you can have more than one source or
destination of course)

When you first start a new transaction, GnuCash helpfully creates the
first split using the account that is open. (your source account in this
case) Just enter the amount of funds being paid as a Credit. (right
column, regardless of terminology) Note, that is the same for expenses
and income. (or charges)

See the attached screenshot using your example of snacks.

Of course, once you commit the transaction, GnuCash will re-order the
splits show Debits appear before Credits.

Regards,
Adrien

On 7/24/23 6:49 AM, Chris Green wrote:

Thanks both for the 'how to do it' for split transactions.  I'm
getting there slowly!  :-)




--
___
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] Gnucash IRC

[Derek Atkins]

HI,

On Thu, July 13, 2023 12:59 am, Alex Dorsch wrote:
> On Sun, 2023-07-09 at 23:01 -0400, Derek Atkins wrote:
>> Hi,
>>
>> On Sun, July 9, 2023 2:55 pm, Alex Dorsch wrote:
>> > Hi,
>> >
>> > I'm continuing to having troubles posting to the gnucash IRC:
>> >
>> >  hi
>> > * #gnucash :You need voice (+v) (#gnucash)
>> > > NickServ< register  alex.dor...@posteo.net
>> > -NickServ- Nickname sunyibo is already registered!
>>
>> Is this YOUR registration?  Or does someone else have the
>> registration?
>> If it is your registration then you need to identify as the user to
>> gain
>> voice.  If it is someone else's then you need to choose a new name.
>
> Yes, it's my registration and I'm identified as the user.
>
> Still no luck connecting to the channel. As it had worked before, I'm
> guessing it has something to do with the gnome->libera migration.
>
> Best,
>
> Alex

Maybe -- but we are at irc.gimp.org, not irc.gnome.org (== libera).

Once you /msg nickserv identify then you should be able to /join #gnucash
and have a voice.

-derek

>
>>
>> >  hi
>> > * #gnucash :You need voice (+v) (#gnucash)
>> > * You have left channel #gnucash
>> > * Now talking on #gnucash
>> > * Topic for #gnucash is: Free GPL Personal and Small Business
>> > Accounting || Moderated mode: To get a voice, register with
>> > NickServ
>> > and then re-join. || Please don't ask to ask, just ask and wait!
>> > (Possibly a few hours!!) || publicly-logged channel
>> > https://code.gnucash.org/logs || latest stable: 5.3 ||
>> > https://www.gnucash.org/ || https://wiki.gnucash.org/wiki/
>> > * Topic for #gnucash set by jralls (Mon Jun 26 22:37:10 2023)
>> >  hi
>> > * #gnucash :You need voice (+v) (#gnucash)
>> >
>> > I just can't voice. Please help,
>> >
>> > Best,
>> >
>> > Alex
>>
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>>
>> -derek
>>
>
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Why is balance always zero in search results?

[Derek Atkins]

Hi,

On Mon, July 10, 2023 4:51 am, Adam Mackler via gnucash-user wrote:
> Hello:
>
> I am using GnuCash version 4.4.
>
> When I use the "Find" option under the "Edit" menu while viewing an
> account register, the "Search Results" I get seem to be a filtered version
> of the account register that I was looking at when applying the "Find".

This is correct.

If you want to find from everything, then initiate the find from the Chart
of Accounts.

> There are two differences between the account register and the Search
> Results that I don't understand:
>
> 1. In the "Search Results" there are no amounts on each transaction line
> in the "Tot Debit" or "Tot Credit" columns, as there are when viewing the
> account register.  There are amounts on the split lines, but not on the
> first line for each transaction.
>
> 2. The "Balance" column on each transaction line shows "0.00" for each
> transaction, whereas in the account register that column shows the balance
> of the account after each transaction.
>
> Why is value in the "Balance" column zero on every transaction line when
> viewing Search Results, or put another way, what is the point of that
> column if it shows no useful information?  Is there a setting I can change
> so that the values shown in the "Balance" column are a running total of
> debits and credits on the account to which I applied the Edit → Find tool?
>
> I’m guessing it has something to do with the Find tool forgetting what
> account I’m interested in, and so not knowing which account’s running
> total it should be showing.  What I’m trying to do is to limit the date
> range for the account register so I can generate an Account Report limited
> to that date range.  The problem is that an Account Report generated from
> the Search Results shows a running total ("Balance" column) of zero after
> every transaction.

It's also the fact that the running balance amounts are not computed on
the fly, so it would be odd to display a balance.

> Alternatively, is there a way to generate an Account Report directly from
> an account register but for a limited date range?

Yes! Filter by date under:   View -> Filter

Then from there, run the Account Report.

>
> -- 
> Adam Mackler

> 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
-
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 IRC

[Derek Atkins]

Hi,

On Sun, July 9, 2023 2:55 pm, Alex Dorsch wrote:
> Hi,
>
> I'm continuing to having troubles posting to the gnucash IRC:
>
>  hi
> * #gnucash :You need voice (+v) (#gnucash)
>>NickServ< register  alex.dor...@posteo.net
> -NickServ- Nickname sunyibo is already registered!

Is this YOUR registration?  Or does someone else have the registration?
If it is your registration then you need to identify as the user to gain
voice.  If it is someone else's then you need to choose a new name.

>  hi
> * #gnucash :You need voice (+v) (#gnucash)
> * You have left channel #gnucash
> * Now talking on #gnucash
> * Topic for #gnucash is: Free GPL Personal and Small Business
> Accounting || Moderated mode: To get a voice, register with NickServ
> and then re-join. || Please don't ask to ask, just ask and wait!
> (Possibly a few hours!!) || publicly-logged channel
> https://code.gnucash.org/logs || latest stable: 5.3 ||
> https://www.gnucash.org/ || https://wiki.gnucash.org/wiki/
> * Topic for #gnucash set by jralls (Mon Jun 26 22:37:10 2023)
>  hi
> * #gnucash :You need voice (+v) (#gnucash)
>
> I just can't voice. Please help,
>
> Best,
>
> Alex

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gunzip test.gnucash fails

[Derek Atkins]

For the record, yes, you can use gunzip, but you have to manually rename it 
first.
Having said that, the name space is used throughout the file, so you might 
have a large editing job to do... And such editing is not supported. Make 
sure you have a good backup.

-derek
Sent using my mobile device. Please excuse any typos.
On May 28, 2023 07:21:46 Ken Farley  wrote:


Where did you get the impression that you could use gunzip to uncompress
the files?

To "uncompress" the file you need to change your preferences in Gnucash
to turn off "Compress Files", then save your file. This will make the
file uncompressed.

Best practice would be to copy the uncompressed file to another file
before doing any sort of manual editing. That's a delicate thing that
could cause problems.

By the way, the file extensions of a file that is passed to any sort of
uncompression software is usually how the program determines how it will
handle the file. ".gnucash" is not a standard compressed file extension.
gunzip most likely is expecting ".gz". That being said, unless it's
explicitly stated in the Gnucash documentation somewhere, I wouldn't
assume the Gnucash compression algorithm is compatible with any
uncompression software.
___
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] IRC Invite

[Derek Atkins]

Hi,

On Wed, May 24, 2023 10:25 am, Mark at Lorimark wrote:
> Hi,
>
> I was wondering what I need to get an invitation to #gnucash in libera?

Nothing -- that's not our IRC Channel.
Go to irc.gimp.net

>
>
>> Cannot join #gnucash (Channel is invite only)

-derek

>
>
> --
> ~mark petryk
> ~c:469-556-5075
> ~t:4695565...@mms.att.net
> ~w:http://www.lorimarksolutions.com
> ~h:KG5OBY
> ~q:might as well... it's not getting any cheaper
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting Help - Credit Card transfer

[Derek Atkins]

Hi,



On Thu, May 18, 2023 5:38 pm, Chris Ledbetter via gnucash-user wrote:
> Hi,
> Currently using GnuCash 4.14.  I have Credit Card A with an opening
> balance (transfer Equity:Opening Balances) and subsequent transactions.  I
> set up Credit Card B.  I transfer the majority of the balance to Credit
> Card B but still keep Credit Card A.  How do I set up Credit Card B
> transactions?  In Credit Card A is move the balance as a transaction
> (transfer Liabilities:Credit Card:Credit Card B) and in Credit Card B the
> initial transaction is (transfer Liabilities:Credit Card:Credit Card A).
> Is this the correct way to transfer?  Should Credit Card B have on
> Equity:Opening Balance?

Equity:Opening Balance is only used when you start GnuCash.
If you open an account after that, then no, you don't use Eq:O-B

What you suggest is correct.  If you are transferring a balance from A to
B, then it's just a regular transaction from A to B.

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Status of SourceForge tip jar

[Derek Atkins]

It is still working; I am the manager of the target paypal account, and I
report periodically to the core devs and act on their (our?) consensus on
disbursement.

Thank you in advance for your donation/contribution.

-derek

On Wed, May 3, 2023 2:57 pm, Wally Hackenslacker via gnucash-user wrote:
> Hello all.
>
> I wanted to ask what is the status of the SourceForge tip jar for GnuCash.
> I'm looking to make a donation and the method that works for me is making
> a Paypal donation through the tip jar but I wanted to make sure that it's
> still working, if it is trustworthy and that the money will reach the devs
> of the project.
>
> 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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Starting balance of new account is not $0

[Derek Atkins]

Hi,

On Wed, April 26, 2023 10:09 am, Phyllis Bruce wrote:
> Derek, when you *first came into Gnucash* did you enter current balances
> as
> equity?  Any balance on a credit card would be negative to equity.  Your
> cash accounts would be positive.  It's not too late to do that.  Enter the
> beginning balance on the statement you are trying to reconcile as equity
> for that account.  Use help to get to the tutorials and best practices.

I think you meant to direct that to Rich, not to me.

(For the record, yes, when I started my accounts in.. 2002.. I did indeed
put in starting balances.)

BUT, you must put them in prior to reconciling.  And even so, the first
time you reconcile you will get a starting balance of 0.

-derek

> On Wed, Apr 26, 2023 at 8:21 AM Derek Atkins  wrote:
>
>> Hi,
>>
>> On Wed, April 26, 2023 9:09 am, Rich James wrote:
>> > I'm trying to resolve some reconciliation issues and decided to go
>> back
>> to
>> > my first statement from last year when I opened the account to
>> establish
>> > that everything is balanced.  However, when I start to reconcile and
>> put
>> > in
>> > the statement date and ending balance, the reconciliation window shows
>> a
>> > Starting Balance of several hundred dollars instead of $0.  This gives
>> me
>> > an incorrect difference that I can't properly clear.
>> >
>> > Is there a known issue where this can occur?  Or can anyone suggest a
>> way
>> > to resolve this?  I'm seeing similar behavior with another account as
>> > well.
>>
>> You cannot go "back in time" to reconcile.  When you reconcile an
>> account
>> at date X, you are reconciling from "the beginning of time" to date X.
>> You cannot then go back to a date earlier than X to (re)reconcile.
>>
>> Hope this helps,
>>
>> >
>> > Thanks,
>> > Rich
>>
>> > 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
>> -
>> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Starting balance of new account is not $0

[Derek Atkins]

Hi,

On Wed, April 26, 2023 9:09 am, Rich James wrote:
> I'm trying to resolve some reconciliation issues and decided to go back to
> my first statement from last year when I opened the account to establish
> that everything is balanced.  However, when I start to reconcile and put
> in
> the statement date and ending balance, the reconciliation window shows a
> Starting Balance of several hundred dollars instead of $0.  This gives me
> an incorrect difference that I can't properly clear.
>
> Is there a known issue where this can occur?  Or can anyone suggest a way
> to resolve this?  I'm seeing similar behavior with another account as
> well.

You cannot go "back in time" to reconcile.  When you reconcile an account
at date X, you are reconciling from "the beginning of time" to date X. 
You cannot then go back to a date earlier than X to (re)reconcile.

Hope this helps,

>
> Thanks,
> Rich

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Should I upgrade or update?

[Derek Atkins]

Version 5 was just released this weekend.
It is the new major stable series.
-derek

On Mon, March 27, 2023 9:37 am, Dr. David Kirkby wrote:
> On Mon, 27 Mar 2023 at 14:27, Kalpesh Patel  wrote:
>
>> The million dollar question: Should I upgrade to GNC 5.0 or update to
>> 4.14?
>> I am predominately on Windows 11 platform but I am NOT a business user.
>>
>
> I don't see version 5. That might not be a stable release if it exists, so
> I don't know what you should do about that.
>
> But I know what you should do - trim posts when replying to a digest. You
> have included 1000's of lines of irrelevant stuff.
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Site certificate expiry warning

[Derek Atkins]

Point them to https://code.gnucash.org/website/

The maintainer of www.gnucash.org has been having issues since a major
power outage in February and has been fighting with his system ever since.

-derek

On Fri, March 24, 2023 7:16 am, Michael Hendry wrote:
> I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve
> just been informed that www.gnucash.org is being flagged up as dangerous
> because its site certificate expired recently.
>
> I can get through by overriding the warnings, but I don’t think I should
> be advising others to do so.
>
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] [MAINT] Unplanned network outage

[Derek Atkins]

Hi,

My ISP had an unplanned network outage starting around 2am this morning
that took all connectivity offline -- their router ran out of memory and
took out all BGP routes.  Their router has since been rebooted and packets
are now flowing again.

Sorry for any inconvenience this may have caused.

-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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] credit account negative balance increases with payment

[Derek Atkins]

Are you sure you have all your CC Charges entered correctly?
It sounds like something is being entered backwards.

-derek

On Sat, March 4, 2023 2:28 pm, Custom Shots wrote:
> That's exactly what I'm saying.  I owe $500. That's a negative balance in
> my credit card account, showing in red with a minus sign. I enter a
> payment
> of $200 and the negative balance increases to -$700. The negative balance
> should decrease to -$300. Yet the other half of the transaction correctly
> withdraws $200 from cash.
> I did play with the settings when I decided I liked seeing what I owed as
> red negative numbers.
>
> On Sat, Mar 4, 2023, 11:54 AM Stan Brown 
> wrote:
>
>> On 2023-03-04 10:26, Custom Shots wrote:
>> > I just noticed this. Something has changed. I keep 30 day backups and
>> this
>> > has been going on in all my backups. When I add a payment transaction
>> to
>> my
>> > credit card account the negative balance increases instead of
>> decreasing.
>> > Any clues to what is happening? I am using GnuCash Version: 4.8 Build
>> ID:
>> > 4.8a+(2021-09-28) on Ubuntu 2022.04.2. The second half of the double
>> entry
>> > transaction, the withdrawal from my checking account, works correctly.
>>
>> Presumably by "correctly" you mean that the positive balance of the cash
>> or checking account goes down? If so, I agree with you that it's
>> correct: a credit to an asset account reduces the balance of that
>> account. (Paying someone is a credit to cash, and getting money from
>> someone is a debit to cash.)
>>
>> You might take a look in Edit » Preferences » Accounts, under "Reverse
>> Balanced Accounts". I can't remember the details from when I set up my
>> data file a few years ago, but I do remember that on experimenting with
>> those settings the only one that _didn't_ give nonsensical results was
>> "Credit accounts".  (I mean nonsensical to me; I'm sure the developers
>> must have had some good reason for those other settings.)
>>
>> Are you saying something like: the balance on your Visa account was
>> minus $200, and you paid $65, and now the balance is minus $265 instead
>> of the expected minus $135? That would be wrong under any circumstances,
>> as far as I can understand. Or did you mean it literally that the
>> account balance "increases", since minus $135 is greater than minus
>> $200? If that's what you meant, then everything is correct except that
>> the credit-card account is showing a minus sign in front of correct
>> balances, and for that I'd definitely have a look at "Reverse Balanced
>> Accounts".
>>
>> Stan Brown
>> Tehachapi, CA, USA
>> https://BrownMath.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
>> -
>> 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.
>


-- 
   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
-
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,org url is now working

[Derek Atkins]

Hi.
Indeed, it does appear that www.gnucash.org lost its brain and, although
responding, is not the gnucash website.  I will notify Linas to ask what's
up.
As for # subscribers, we have a dozen lists with some overlapping
subscriptions, but there are over 2000 subscribers to gnucash-user.

-derek

On Fri, March 3, 2023 7:13 am, Brad Morrison wrote:
> Hi Ken, John, & all,
>
> I just tried the link that Ken provided and it took me to some "Apache2
> Ubuntu Default Page," but not the GnuCash homepage...?
>
> I also tried the link that John provided and that seems to work fine for
> the GnuCash homepage for me.
>
> Is anyone else having similar results?
>
> I would attach screenshots, but I don't know if the Mailman2 mailing
> list software allows for that - ? I am on the board of the North Bay
> Linux Users Group (NBLUG - https://nblug.org/) and we have gone through
> some transition difficulties in our recent upgrade from MailMan2 to
> MailMan3 (https://www.gnu.org/software/mailman/index.html), so when I
> saw that these GnuCash mailing lists are still using MailMan2
> (https://lists.gnucash.org/mailman/listinfo) I made a mental note of
> that. Although with the amount of email traffic /volume that I have seen
> on this list, I am willing to bet that this list has far more
> subscribers than all of our NBLUG lists combined (we have about 250 on
> the 'talk' list and about 450 on the 'announce' list).
>
> Thanks,
>
> Brad
>
> On 2/21/23 21:00, Ken Pyzik wrote:
>> Tested it this evening - 9:00PM PST in the
>> US.www.gnucash.org<http://www.gnucash.org>  now appears to be working.
>> FYI.
>>
>> Ken
>>
>>
>> ___
>> 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.
>>
>
>
> On 2/19/23 15:40, John Ralls wrote:
>> As most everyone already knowswww.gnucash.org  has been offline since 11
>> February because Linas Vepstas lost internet access and his ISP, Grande
>> Networks in Austin, TX, has not fixed it.
>>
>> To provide replacement service until Linas gets back online we've set up
>> an alternate site,https://code.gnucash.org/website/.
>>
>> Regards,
>> John Ralls
>>
>> ___
>> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New Bill: way to change default "Date Opened"?

[Derek Atkins]

Hi,

On Thu, March 2, 2023 4:20 pm, Eric Chapman wrote:
> When entering a new bill, is there a way to change the default "Date
> Opened"? (Screenshot attached.) It defaults to today's date, but I'm
> entering old data. I would like it if it would default to the last
> entered date.

No.

> Also … is there a way to change this date after it's been entered? It is
> grayed out later in the "Edit Bill" pane.

Yes.  Click on the "Edit Bill" button so it pops up the dialog where you
can edit that field.

-derek

> Thanks!
>
> --
> Eric Chapman
> GnuCash 4.13 on MacOS 13.1 Ventura running on 2018 Mac Mini (3.2 GHz
> 6-Core Intel Core i7)
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Any way to "unpay" (reverse payment of bill)?

[Derek Atkins]

Two options:

1) correct the date on the payment transaction, or
2) just delete the payment transaction

-derek

On Thu, March 2, 2023 4:42 pm, Eric Chapman wrote:
> One can unpost a bill from vendor, but if one has already clicked the
> "Pay" button and followed through with that, the bill still looks as if
> it is "paid" in the vendor report. Can I "unpay" a bill?
>
> I'm paying by credit card, so it's really not that I'm unpaying (which
> one could never do if a check were already issued or a wire transfer
> initiated).
>
> My problem has to do with GnuCash's aggravating default dates. I enter a
> bill from January 2022, and when I click "Pay", GnuCash automatically
> inserts today's date, even though it was paid via credit card months ago.
>
> Thanks for your advice!
>
> --
> Eric Chapman
> GnuCash 4.13 on MacOS 13.1 Ventura running on 2018 Mac Mini (3.2 GHz
> 6-Core Intel Core i7)
>
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] File locked ?

[Derek Atkins]

are you sure another GnuCash isn't running? If you are sure then Open anyways
Generally this happens because GnuCash was not shut down cleanly.  Either 
that or there is a permission problem.

-derek
Sent using my mobile device. Please excuse any typos.
On March 1, 2023 15:00:35 TimR via gnucash-user  
wrote:



I am a new user having just switched to GnuCash by importing from a Quicken
QIF file. All seemed to be going well for several sessions. Today in trying
to open Gnucash I have received the following error message:

"GnuCash could not obtain the lock for D:\Raymond.Current.gnucash."

How do I solve this?

___
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] No longer receiving the e-mail from the user group

[Derek Atkins]

Hi,

The server failure was www.gnucash.org.
Mail has always been at code, so 204.107.200.65 is the correct (permanent)
email server address.
If there is a DKIM or SPF failure, it would be useful to know.
We do not have DMARC configured at gnucash.org.

-derek

On Fri, February 24, 2023 7:56 pm, Peter West wrote:
> I have been getting a flood of dmarc reports regarding messages to me
> through my mail server that originate from 204.107.200.65 code.gnucash.org
> <http://code.gnucash.org/>. I'm not really au fait with dmarc reports, but
> there is a dkim failure and possibly an spf failure on the originating
> server.
>
> There was a server problem recently, which is expected to be temporary, so
> I expect the mail server function was shifted to the stopgap server, and
> set up hurriedly. The mail to those of us who are still receiving gnucash
> messages is passing through a lenient server, while I suspect Ken’s server
> takes a dim view of mail without correct dkim, or possibly spf.
>
> When the original server is bak online, the problem will probably go away.
>
>
> —
> Peter West
> p...@pbw.id.au
> “Blessed are the peacemakers, for they shall be called sons of God.”
>
>> On 25 Feb 2023, at 9:41 am, Ken Pyzik  wrote:
>>
>> It appears that as of earlier this week, I stopped receiving e-mail from
>> the group e-mail list.  Not sure what it is – but my suspicion is that
>> is may be getting rejected at the Microsoft server side of things (since
>> I am an outlook.com domain user).
>>
>> Can anyone see if my suspicion is correct or if there are any other
>> e-mail servers affected?  Thanks to all.
>>
>> Ken
>>
>> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for
>> Windows
>>
>> ___
>> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] No longer receiving the e-mail from the user group

[Derek Atkins]

Hi,
I just looked at the mail logs on code and your email is definitely being
sent and accepted by outlook-com.olc.protection.outlook.com -- so if
you're not receiving it the issue is on your end, not ours.  Check your
junk folder?

-derek

On Fri, February 24, 2023 7:05 pm, Ken Pyzik wrote:
> Thanks David.  Received your message and checked the subscription.  It
> said I was already subscribed.  Today only received your e-mail, my own,
> an one other.  Will keep checking – thanks for the assistance.  – Ken
>
> From: David H 
> Sent: Friday, February 24, 2023 3:47 PM
> To: Ken Pyzik 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] No longer receiving the e-mail from the user group
>
> Ken,
>
> Have you checked your subscription settings at
> https://lists.gnucash.org/mailman/listinfo/gnucash-user ?
>
> Cheers David H.
>
>
> On Sat, 25 Feb 2023 at 09:42, Ken Pyzik
> mailto:py...@outlook.com>> wrote:
> It appears that as of earlier this week, I stopped receiving e-mail from
> the group e-mail list.  Not sure what it is – but my suspicion is that is
> may be getting rejected at the Microsoft server side of things (since I am
> an outlook.com<http://outlook.com> domain user).
>
> Can anyone see if my suspicion is correct or if there are any other e-mail
> servers affected?  Thanks to all.
>
> Ken
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org<mailto: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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] View/Filter by & Edit/Find

[Derek Atkins]

Hi,

This is not a bug.  The "Find" function, when started from an open
register, will always filter on the register contents.  So if you have the
register limited to 90 days, the Find will only search there.

If you want to start from a "scratch" find then you need to go to the
Chart of Accounts page.

The Find function is completely unrelated to autocompletion.

-derek

On Thu, February 16, 2023 12:21 pm, Gyle McCollam wrote:
> When entering a new transaction in an account the auto complete works even
> if the transaction is older than the limit set in "View/Filter by", which
> is great and how I think it should work.  However, when you do an
> "Edit/Find", it only finds transactions within the date range of
> View/Filter by.  I think both the Auto Complete and Find should work the
> same way.
>
> Since they don't, I had to change the View /Filter by from the 90 days I
> had set on the account to All, but I didn't save the filter because I
> wanted it to go back to the 90 days when I finished.  I really don't think
> i should have had to change it all.  Anyway, this brought another problem
> to my attention.  How do you get the view back to 90 days without setting
> the "Filter by" again.  I tried closing and reopening the account, that
> didn't work.  So, I tried closing Gnu Cash and reopening, that didn't work
> either.  It appears that even though I didn't "save" the filter it saved
> it anyway.
>
> It would be best if we didn't have to change the filter just to do a find.
>  Is this a bug or bugs that should be reported when the Gnu Cash website
> comes back up?
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.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.
>


-- 
   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
-
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 force y in reconcile field

[Derek Atkins]

Correct, you need a 0 ending balance.  But the starting balance is
irrelevant.
Why can't you re-reconcile with the last statement?
-derek

On Thu, February 2, 2023 4:40 pm, Xe Roy wrote:
> It looks like the FINISH button only is active if there is zero
> difference.
> I will have to wait for the next statement in order to reconcile and get a
> zero difference.
>
>
> Sent from Outlook<http://aka.ms/weboutlook>
>
> ____
> From: Derek Atkins 
> Sent: Thursday, February 2, 2023 10:21 AM
> To: Xe Roy 
> Cc: Phyllis Bruce ; Derek Atkins ;
> gnucash-u...@lists.gnucash.org 
> Subject: Re: [GNC] How to force y in reconcile field
>
> Did you set the correct ending balance?
>
> -derek
>
> On Thu, February 2, 2023 2:13 pm, Xe Roy wrote:
>> I tried reconcile again per derek suggestion.
>> I set the date to the same date as before.
>> I clicked the two transactions that need to be reconciled.
>> I clicked RECONCILE SELECTION but the FINISH button is grayed preventing
>> this process to complete.
>>
>>
>> Sent from Outlook<http://aka.ms/weboutlook>
>>
>> 
>> From: Phyllis Bruce 
>> Sent: Thursday, February 2, 2023 9:32 AM
>> To: Derek Atkins 
>> Cc: Xe Roy ; gnucash-u...@lists.gnucash.org
>> 
>> Subject: Re: [GNC] How to force y in reconcile field
>>
>> Derek, I like your solution best.  I've made the mistake of reconciling
>> to
>> the balance in my account without waiting for the statement.  It really
>> took some head scratching to figure how to correct it later when I did
>> receive the statement.  But can you change either the date or the ending
>> balance?  In my case, I had an ending balance that was different on the
>> official statement.  Hope that's not too convoluted to be understood.
>>
>> On Thu, Feb 2, 2023 at 12:27 PM Derek Atkins
>> mailto:de...@ihtfp.com>> wrote:
>> Hi,
>>
>> On Thu, February 2, 2023 1:14 pm, Xe Roy wrote:
>>> I am new user who made a mistake in a previous reconcile.
>>> To correct the mistake, I need to change 2 transactions from n to y in
>>> the
>>> reconcile field.
>>> I see that is not possible via the program, so do I have to edit the
>>> .gnucash file or is there a better way?
>>
>> Just re-run the reconcile with the same ending date and balance as the
>> previous time, so you can re-reconcile those transactions.
>>
>>> 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<mailto:de...@ihtfp.com>
>> www.ihtfp.com<http://www.ihtfp.com>
>>Computer and Internet Security Consultant
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org<mailto: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.
>>
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com<http://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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Website Down?

[Derek Atkins]

You can get to the docs through the wiki (which IS up).

-derek

On Thu, February 2, 2023 3:12 pm, m...@tgr66.me wrote:
> Thanks! I was just trying to get to the docs to understand the account
> types, but I pulled them from the app which is close enough for now.
>
> I appreciate you and Linas.
>
>> On Feb 2, 2023, at 14:10, Derek Atkins  wrote:
>>
>> Hi,
>>
>> The www.gnucash.org server is hosted out of Austin, TX.
>> With the Ice Storms the other day, the hosting location had a power
>> outage, and unfortunately the machine did not boot up when the power
>> came
>> back.
>>
>> Linas is working on the issue.
>>
>> -derek
>>
>> On Thu, February 2, 2023 2:59 pm, m...@tgr66.me wrote:
>>> Here in the US, Texas, I’m not able to reach the gnucash.org. I’m able
>>> to
>>> reach other websites.
>>>
>>> Anyone else experience this?
>>>
>>> Tim
>>> ___
>>> 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.
>>>
>>
>>
>> --
>>   Derek Atkins 617-623-3745
>>   de...@ihtfp.com www.ihtfp.com
>>   Computer and Internet Security Consultant
>>
>
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Website Down?

[Derek Atkins]

Hi,

The www.gnucash.org server is hosted out of Austin, TX.
With the Ice Storms the other day, the hosting location had a power
outage, and unfortunately the machine did not boot up when the power came
back.

Linas is working on the issue.

-derek

On Thu, February 2, 2023 2:59 pm, m...@tgr66.me wrote:
> Here in the US, Texas, I’m not able to reach the gnucash.org. I’m able to
> reach other websites.
>
> Anyone else experience this?
>
> Tim
> ___
> 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.
>


-- 
   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
-
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 force y in reconcile field

[Derek Atkins]

Hi,

On Thu, February 2, 2023 1:32 pm, Phyllis Bruce wrote:
> Derek, I like your solution best.  I've made the mistake of reconciling to
> the balance in my account without waiting for the statement.  It really
> took some head scratching to figure how to correct it later when I did
> receive the statement.  But can you change either the date or the ending
> balance?  In my case, I had an ending balance that was different on the
> official statement.  Hope that's not too convoluted to be understood.

Yes, when you start the reconcile dialog you can enter in the closing date
AND closing balance.  GnuCash tries to give you an option, but you can
(and SHOULD) ensure it is the correct balance for the day.

-derek

>
> On Thu, Feb 2, 2023 at 12:27 PM Derek Atkins  wrote:
>
>> Hi,
>>
>> On Thu, February 2, 2023 1:14 pm, Xe Roy wrote:
>> > I am new user who made a mistake in a previous reconcile.
>> > To correct the mistake, I need to change 2 transactions from n to y in
>> the
>> > reconcile field.
>> > I see that is not possible via the program, so do I have to edit the
>> > .gnucash file or is there a better way?
>>
>> Just re-run the reconcile with the same ending date and balance as the
>> previous time, so you can re-reconcile those transactions.
>>
>> > 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
>> -
>> 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
-
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 force y in reconcile field

[Derek Atkins]

Did you set the correct ending balance?

-derek

On Thu, February 2, 2023 2:13 pm, Xe Roy wrote:
> I tried reconcile again per derek suggestion.
> I set the date to the same date as before.
> I clicked the two transactions that need to be reconciled.
> I clicked RECONCILE SELECTION but the FINISH button is grayed preventing
> this process to complete.
>
>
> Sent from Outlook<http://aka.ms/weboutlook>
>
> 
> From: Phyllis Bruce 
> Sent: Thursday, February 2, 2023 9:32 AM
> To: Derek Atkins 
> Cc: Xe Roy ; gnucash-u...@lists.gnucash.org
> 
> Subject: Re: [GNC] How to force y in reconcile field
>
> Derek, I like your solution best.  I've made the mistake of reconciling to
> the balance in my account without waiting for the statement.  It really
> took some head scratching to figure how to correct it later when I did
> receive the statement.  But can you change either the date or the ending
> balance?  In my case, I had an ending balance that was different on the
> official statement.  Hope that's not too convoluted to be understood.
>
> On Thu, Feb 2, 2023 at 12:27 PM Derek Atkins
> mailto:de...@ihtfp.com>> wrote:
> Hi,
>
> On Thu, February 2, 2023 1:14 pm, Xe Roy wrote:
>> I am new user who made a mistake in a previous reconcile.
>> To correct the mistake, I need to change 2 transactions from n to y in
>> the
>> reconcile field.
>> I see that is not possible via the program, so do I have to edit the
>> .gnucash file or is there a better way?
>
> Just re-run the reconcile with the same ending date and balance as the
> previous time, so you can re-reconcile those transactions.
>
>> 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<mailto:de...@ihtfp.com>
> www.ihtfp.com<http://www.ihtfp.com>
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org<mailto: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.
>


-- 
   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
-
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 force y in reconcile field

[Derek Atkins]

Hi,

On Thu, February 2, 2023 1:14 pm, Xe Roy wrote:
> I am new user who made a mistake in a previous reconcile.
> To correct the mistake, I need to change 2 transactions from n to y in the
> reconcile field.
> I see that is not possible via the program, so do I have to edit the
> .gnucash file or is there a better way?

Just re-run the reconcile with the same ending date and balance as the
previous time, so you can re-reconcile those transactions.

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] add note to transaction

[Derek Atkins]

You have to do each one individually, however you can copy-and-paste the
note into each of them (one at a time) in a register in double-line mode. 
So it should be pretty fast (once you have a register with only the
transactions you need to modify).

-derek

On Sat, January 28, 2023 5:18 pm, Gary Holtum wrote:
> I have several (dozens) of transactions that I would like to add a note
> to.
> The same note.
>
> Is there a way to do it all at once or do I have to do each one
> individually?
>
>
>
> Gary Holtum
>
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entering Dividend Confusion

[Derek Atkins]

Hi,

On Fri, January 27, 2023 9:46 am, xboxboy.mageia+GnuCash wrote:

> I really wish I had access to a FREE, OPEN SOURCE accounting package
> like this 20 years ago!

For the record, GnuCash was around 20 years ago...  :)
Indeed, GnuCash was even around last century!

> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entering Dividend Confusion

[Derek Atkins]

Hi,

On Sun, January 22, 2023 7:31 am, xboxboy.mageia+GnuCash wrote:
> Thank you to all who have replied.
>
> I attempted to enter a split transaction in the 'dividend' income page,
> and then it vanished: I found it had transferred to the company stock
> tab: It appeared to be correct, and the amounts ending up in the correct
> accounts :)

The reason it "vanished" was because you had no splits tied to the open
account.  So there was nothing holding it to the current view.

>
> So I was able to enter ALL the data for that stock, and then I was even
> able to enter the final sale and scrub the account correctly.
>
> I can not express how WILD, FRUSTRATED and angry I was with myself. But
> it's now done, and I can always refer to that as a template/transaction
> to copy.
>
> Is there a function to 'lock' an account so it can no longer be edited
> accidentally?

Yes.  Mark the account as "placeholder" and you won't be able to add any
transactions or otherwise edit the contents of the account.

>
> Thank you everyone, I really, really appreciate your patience and help.

You're welcome.

Happy Gnucashing!

-derek


> On 22/1/23 18:57, Maf. King wrote:
>> On Sunday, 22 January 2023 04:50:47 GMT xboxboy.mageia+GnuCash wrote:
>>
>>> Thanks: Now which page/account/ledger do I do this on? The dividend
>>> income one? the company dividend income one? the company stock one??
>>>
>> When the dividends are being reinvested automatically, I enter the
>> transaction
>> in the relevant stock account.  I just find it easier to see with the
>> number/
>> price/value boxes in front of me.
>>
>> Instead of the usual approach of the cash to buy the shares being
>> transferred
>> from Assets:Bank, just transfer from Income:dividend[:etc] and also if
>> requited ensure you have the split to show the tax credit too.
>>
>> HTH,
>> Maf.
>>
>>
>>
>> ___
>> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF upload ends abruptly at import step, last message "Transaction with no or only one associated account"

[Derek Atkins]

On windows you might not get console output, which might make it harder to
debug this.

See https://wiki.gnucash.org/wiki/Tracefile about the Trace File.

-derek

On Sat, January 21, 2023 9:40 am, jhoe...@googlemail.com wrote:
> Thanks, Derek.
>
>
>
> I'm using a brand new laptop on Windows 10 with all updates and GnuCash
> 4.13. I’ve copied below the last screenshot (but it may not come through).
>
>
>
>
>
> The only files with “trace” in my GnuCash Folders are from June 2020 – so
> won’t have anything to do with my problem. I currently have zero data in
> GnuCash  - didn’t even go past the initial three options screen (set up
> account …).
>
> Can you provide more details what to look for where or any suggestions
> regarding below three questions?
>
>
>
> Thanks again, Jan
>
>
>
> -Original Message-
> From: Derek Atkins 
> Sent: Saturday, January 21, 2023 9:20 AM
> To: jhoe...@googlemail.com
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] QIF upload ends abruptly at import step, last message
> "Transaction with no or only one associated account"
>
>
>
> Hi,
>
>
>
> What OS/Distro are you using?
>
> What version of GnuCash?
>
>
>
> There are two places to look for output:  the command-line (stdout) and
> your GnuCash Trace file.  I would look in both places for signs of a stack
> trace.
>
>
>
> -derek
>
>
>
> On Sat, January 21, 2023 9:12 am, Jan via gnucash-user wrote:
>
>> Happy Weekend, guys!
>
>>
>
>>
>
>>
>
>> I do have 20+ years of Quicken 2002 data (German Version), but only
>
>> tried to upload 2022 to GnuCash via a QIF down-/upload. It ends
>
>> abruptly (program vanishes completely) at the import step. The last
>
>> message I see on the screen is "Transaction with no or only one
>
>> associated account". This may be related to an earlier message
>
>> "Investment action: Unrecognized action 'XAus'" which comes from an
>
>> unusual way to post some stock transfers in Quicken.
>
>>
>
>>
>
>>
>
>> Questions:
>
>>
>
>> 1.Should I work on eliminating / changing the transactions in
>> Quicken
>
>> so that they don't lead to an error in GnuCash - or is that just
>
>> likely a wasted effort as the upload will probably continue to fail?
>
>> 2.I exported everything (accounts, categories = subaccounts,
>
>> transactions, scheduled transactions .) to the QIF file. Should I
>
>> import one after the other?
>
>> 3.Any other suggestions? (Maybe also regarding Quicken 2002
>> German
>
>> Version - there seems to be some Windows update that makes Quicken not
>
>> start any more. It happened to me on two separate laptops and I now
>
>> only have Quicken running on one single machine that I disconnected
>
>> from the internet
>
>> ;-)
>
>>
>
>>
>
>>
>
>> Thanks for any help, Jan
>
>>
>
>> ___
>
>> gnucash-user mailing list
>
>>  <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org
>
>> To update your subscription preferences or to unsubscribe:
>
>>  <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>> -
>
>> Please remember to CC this list on all your replies.
>
>> You can do this by using Reply-To-List or Reply-All.
>
>>
>
>
>
>
>
> --
>
>Derek Atkins 617-623-3745
>
> <mailto:de...@ihtfp.com> de...@ihtfp.com
> <http://www.ihtfp.com> www.ihtfp.com
>
>Computer and Internet Security Consultant
>
>
>
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF upload ends abruptly at import step, last message "Transaction with no or only one associated account"

[Derek Atkins]

Hi,

What OS/Distro are you using?
What version of GnuCash?

There are two places to look for output:  the command-line (stdout) and
your GnuCash Trace file.  I would look in both places for signs of a stack
trace.

-derek

On Sat, January 21, 2023 9:12 am, Jan via gnucash-user wrote:
> Happy Weekend, guys!
>
>
>
> I do have 20+ years of Quicken 2002 data (German Version), but only tried
> to
> upload 2022 to GnuCash via a QIF down-/upload. It ends abruptly (program
> vanishes completely) at the import step. The last message I see on the
> screen is "Transaction with no or only one associated account". This may
> be
> related to an earlier message "Investment action: Unrecognized action
> 'XAus'" which comes from an unusual way to post some stock transfers in
> Quicken.
>
>
>
> Questions:
>
> 1.Should I work on eliminating / changing the transactions in Quicken
> so that they don't lead to an error in GnuCash - or is that just likely a
> wasted effort as the upload will probably continue to fail?
> 2.I exported everything (accounts, categories = subaccounts,
> transactions, scheduled transactions .) to the QIF file. Should I import
> one
> after the other?
> 3.Any other suggestions? (Maybe also regarding Quicken 2002 German
> Version - there seems to be some Windows update that makes Quicken not
> start
> any more. It happened to me on two separate laptops and I now only have
> Quicken running on one single machine that I disconnected from the
> internet
> ;-)
>
>
>
> Thanks for any help, Jan
>
> ___
> 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.
>


-- 
   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
-
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 payment covering multiple invoices

[Derek Atkins]

David,

On Sun, January 8, 2023 6:35 pm, Dr. David Kirkby wrote:
> On Sun, 8 Jan 2023 at 23:16, Derek Atkins  wrote:
>
>> Just apply the 300£ payment split between the two invoices.  In the
>> process payment, just select both.
>> -derek
>>
>
> I am using my phone now, not near the computer, so this is from memory.
>
> On the business features there is a way to list who needs paying. Two were
> listed as needing paying, but it was not obvious how to select both. I
> will
> havé to look again tomorrow.

As I said, you need to do it from the Process Payment window.  You don't
do it from a "search".

>
> Dave

-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
-
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 payment covering multiple invoices

[Derek Atkins]

Just apply the 300£ payment split between the two invoices.  In the process 
payment, just select both.

-derek
Sent using my mobile device. Please excuse any typos.
On January 8, 2023 18:04:28 "Dr. David Kirkby" 
 wrote:



I have an account with an electronics company RS. I get invoiced on the
20th of each month. Anything brought up to the 20th then needs to be paid
by the 20th of next month. So depending on when I place the order, I can
get from roughly 30 to 60 days credit.

So I buy something for £100 one day, and another day I buy something for
£200.  So I created two bills. But when I pay, I just pay a single invoice
of £300. How should this be handled in GnuCash?

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.


___
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] another beginner question

[Derek Atkins]

Well, if you put your O-B on all your Assets and Liabilities, then yes,
that *IS* your current equity in the company.

If you think the balance is too big, then most likely you haven't added
all your liabilities.

Keep in mind that Income and Expense are actually Equity-type accounts, in
the sense that In & Ex affect your instantaneous equity.  So when you
restart, you are rolling up a decade of equity built via Income (-
Expense).

Hope this helps,

-derek

On Thu, January 5, 2023 7:28 pm, Simon Roberts wrote:
> Right now I have set up my transition from quickbucks to Gnc such that all
> the bank accounts have an opening balance, which is drawn from
> "Equity:Opening Balances". However, I think that's ... wrong/misleading,
> in
> that this is most definitely not money I just handed over to create the
> business. It's been running 18 year, and it's just that the transition to
> this software is happening now. it makes the balance sheet look like I
> have
> a bunch more equity in there than perhaps I really do (although I'm a
> single-owner LLC, so I'm not really sure!)
>
> Is there a better way to create those opening balances that makes better
> sense, or is this really the right way to do it?
>
> Thanks for any guidance/suggestions!
> Simon
>
> --
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Missing "Buy" action after import of QIF file

[Derek Atkins]

Looking at the code, you are correct; the importer never calls
xaccSplitSetAction.

It USES the action to figure out how to process the transaction, but it
never actually saves it.

Feel free to file an RFE in Bugzilla.

-derek

On Tue, January 3, 2023 8:14 pm, m...@tgr66.me wrote:
> This is what I would expect to see. Note the “Buy” in the Action field.
>
>
>
> However, I had to add that as the QIF import process doesn’t appear to be
> doing it.
>
>
>
> Thank you.
>
>> On Jan 3, 2023, at 18:50, Derek Atkins  wrote:
>>
>> Screen cap came through (at least to me) -- but you cut out too much
>> info
>> so I can't tell what I'm supposed to be seeing or not.
>>
>> -derek
>>
>> On Tue, January 3, 2023 7:35 pm, m...@tgr66.me wrote:
>>> Yes. Trying again to paste a screen cap.
>>>
>>>
>>>
>>> I also tried on my Linux box and got the same result. No action
>>> showing.
>>>
>>>
>>>> On Jan 3, 2023, at 18:27, Derek Atkins  wrote:
>>>>
>>>> Are you in double-line mode?  If not, try turning that on..
>>>>
>>>> -derek
>>>>
>>>> On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote:
>>>>> I only included the snippet relevant to the question; my real file
>>>>> has
>>>>> the
>>>>> header lines and carets. The back ticks were included because I’m
>>>>> used
>>>>> to
>>>>> using those to show a code block :-) They’re not in the real file.
>>>>> I’ll
>>>>> include the entire test file at the end of this message.
>>>>>
>>>>> So I just double checked, and the Buy action is not selected in
>>>>> either
>>>>> the
>>>>> `XYZ` account or in “Joint Brokerage” account. I don’t know where
>>>>> else
>>>>> I
>>>>> should be looking.
>>>>>
>>>>> I’m on Mac with GnuCash v4.13.
>>>>>
>>>>> I can also try on a Linux box.
>>>>>
>>>>> !Account
>>>>> NAssets:Investments:Brokerage Account:Joint Brokerage
>>>>> TInvst
>>>>> ^
>>>>> !Type:Bank
>>>>> D01/11/2020
>>>>> NPayment/Deposit
>>>>> PTrf My Bank
>>>>> CX
>>>>> T1,000.00
>>>>> MDeposit
>>>>> LAssets:Current Assets:My Bank
>>>>> ^
>>>>> !Type:Invst
>>>>> D12/2/2022
>>>>> NBuy
>>>>> PXYZ, INC
>>>>> YXYZ
>>>>> I150
>>>>> T450
>>>>> Q3
>>>>> CR
>>>>> M3 shares @ 150; Nothing to see here
>>>>> ^
>>>>> !Type:Invst
>>>>> D1/1/2023
>>>>> NDiv
>>>>> PXYZ, INC
>>>>> YXYZ
>>>>> T16.23
>>>>> CR
>>>>> MInvestments:Dividend Income; Still nothing
>>>>> ^
>>>>>
>>>>>
>>>>>> On Jan 3, 2023, at 16:09, Kalpesh Patel 
>>>>>> wrote:
>>>>>>
>>>>>> Your QIF may not be complete. I believe it is not documented but
>>>>>> need
>>>>>> first
>>>>>> four lines and the last line as shown in the below example; carets
>>>>>> are
>>>>>> important in qif format as well! This would be the minimal example:
>>>>>>
>>>>>> !Account
>>>>>> NTest
>>>>>> TInvst
>>>>>> ^
>>>>>> !Type:Invst
>>>>>> D12/2/2022
>>>>>> NBuy
>>>>>> PXYZ, INC
>>>>>> YXYZ
>>>>>> I150
>>>>>> T450
>>>>>> Q3
>>>>>> CR
>>>>>> M3 shares @ 150; Nothing to see here
>>>>>> ^
>>>>>>
>>>>>>
>>>>>> With that qif file contents, a top level 'Test' account created,
>>>>>> child
>>>>>> account called 'XYZ' created under 'Test' account, a buy entry for 3
>>>>>> shares
>>>>>> created and a new security called XYZ under NONCURRENCY namespace
>>>>>> created. I
>>>>>> also think back ticks at beginning and end of the one you provided
>>>>>> in
>>>>>> the
>

Re: [GNC] Missing "Buy" action after import of QIF file

[Derek Atkins]

Screen cap came through (at least to me) -- but you cut out too much info
so I can't tell what I'm supposed to be seeing or not.

-derek

On Tue, January 3, 2023 7:35 pm, m...@tgr66.me wrote:
> Yes. Trying again to paste a screen cap.
>
>
>
> I also tried on my Linux box and got the same result. No action showing.
>
>
>> On Jan 3, 2023, at 18:27, Derek Atkins  wrote:
>>
>> Are you in double-line mode?  If not, try turning that on..
>>
>> -derek
>>
>> On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote:
>>> I only included the snippet relevant to the question; my real file has
>>> the
>>> header lines and carets. The back ticks were included because I’m used
>>> to
>>> using those to show a code block :-) They’re not in the real file. I’ll
>>> include the entire test file at the end of this message.
>>>
>>> So I just double checked, and the Buy action is not selected in either
>>> the
>>> `XYZ` account or in “Joint Brokerage” account. I don’t know where else
>>> I
>>> should be looking.
>>>
>>> I’m on Mac with GnuCash v4.13.
>>>
>>> I can also try on a Linux box.
>>>
>>> !Account
>>> NAssets:Investments:Brokerage Account:Joint Brokerage
>>> TInvst
>>> ^
>>> !Type:Bank
>>> D01/11/2020
>>> NPayment/Deposit
>>> PTrf My Bank
>>> CX
>>> T1,000.00
>>> MDeposit
>>> LAssets:Current Assets:My Bank
>>> ^
>>> !Type:Invst
>>> D12/2/2022
>>> NBuy
>>> PXYZ, INC
>>> YXYZ
>>> I150
>>> T450
>>> Q3
>>> CR
>>> M3 shares @ 150; Nothing to see here
>>> ^
>>> !Type:Invst
>>> D1/1/2023
>>> NDiv
>>> PXYZ, INC
>>> YXYZ
>>> T16.23
>>> CR
>>> MInvestments:Dividend Income; Still nothing
>>> ^
>>>
>>>
>>>> On Jan 3, 2023, at 16:09, Kalpesh Patel  wrote:
>>>>
>>>> Your QIF may not be complete. I believe it is not documented but need
>>>> first
>>>> four lines and the last line as shown in the below example; carets are
>>>> important in qif format as well! This would be the minimal example:
>>>>
>>>> !Account
>>>> NTest
>>>> TInvst
>>>> ^
>>>> !Type:Invst
>>>> D12/2/2022
>>>> NBuy
>>>> PXYZ, INC
>>>> YXYZ
>>>> I150
>>>> T450
>>>> Q3
>>>> CR
>>>> M3 shares @ 150; Nothing to see here
>>>> ^
>>>>
>>>>
>>>> With that qif file contents, a top level 'Test' account created, child
>>>> account called 'XYZ' created under 'Test' account, a buy entry for 3
>>>> shares
>>>> created and a new security called XYZ under NONCURRENCY namespace
>>>> created. I
>>>> also think back ticks at beginning and end of the one you provided in
>>>> the
>>>> message are extraneous when included.
>>>>
>>>> I am on Windows 11 running GNC v4.11.
>>>>
>>>> --
>>>>
>>>> Message: 2
>>>> Date: Tue, 3 Jan 2023 09:37:05 -0600
>>>> From: m...@tgr66.me
>>>> To: gnucash-user@gnucash.org
>>>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
>>>> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me>
>>>> Content-Type: text/plain;  charset=utf-8
>>>>
>>>> Oops, I guess the mailing list doesn?t show attached images.
>>>>
>>>>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>>>>
>>>>> In my import file:
>>>>>
>>>>> ```
>>>>> !Type:Invst
>>>>> D12/2/2022
>>>>> NBuy
>>>>> PXYZ, INC
>>>>> YXYZ
>>>>> I150
>>>>> T450
>>>>> Q3
>>>>> CR
>>>>> M3 shares @ 150; Nothing to see here
>>>>> ```
>>>>>
>>>>> Import and GnuCash creates the correct account, but notice the lack
>>>>> of
>>>>> a
>>>> ?Buy? action:
>>>>>
>>>>>
>>>>>
>>>>> Is this a known issue or am I misunderstanding the need for the
>>>>> action
>>>>> to
>>>> be shown there?
>>&

Re: [GNC] Missing "Buy" action after import of QIF file

[Derek Atkins]

Are you in double-line mode?  If not, try turning that on..

-derek

On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote:
> I only included the snippet relevant to the question; my real file has the
> header lines and carets. The back ticks were included because I’m used to
> using those to show a code block :-) They’re not in the real file. I’ll
> include the entire test file at the end of this message.
>
> So I just double checked, and the Buy action is not selected in either the
> `XYZ` account or in “Joint Brokerage” account. I don’t know where else I
> should be looking.
>
> I’m on Mac with GnuCash v4.13.
>
> I can also try on a Linux box.
>
> !Account
> NAssets:Investments:Brokerage Account:Joint Brokerage
> TInvst
> ^
> !Type:Bank
> D01/11/2020
> NPayment/Deposit
> PTrf My Bank
> CX
> T1,000.00
> MDeposit
> LAssets:Current Assets:My Bank
> ^
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ^
> !Type:Invst
> D1/1/2023
> NDiv
> PXYZ, INC
> YXYZ
> T16.23
> CR
> MInvestments:Dividend Income; Still nothing
> ^
>
>
>> On Jan 3, 2023, at 16:09, Kalpesh Patel  wrote:
>>
>> Your QIF may not be complete. I believe it is not documented but need
>> first
>> four lines and the last line as shown in the below example; carets are
>> important in qif format as well! This would be the minimal example:
>>
>> !Account
>> NTest
>> TInvst
>> ^
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ^
>>
>>
>> With that qif file contents, a top level 'Test' account created, child
>> account called 'XYZ' created under 'Test' account, a buy entry for 3
>> shares
>> created and a new security called XYZ under NONCURRENCY namespace
>> created. I
>> also think back ticks at beginning and end of the one you provided in
>> the
>> message are extraneous when included.
>>
>> I am on Windows 11 running GNC v4.11.
>>
>> --
>>
>> Message: 2
>> Date: Tue, 3 Jan 2023 09:37:05 -0600
>> From: m...@tgr66.me
>> To: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
>> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me>
>> Content-Type: text/plain;charset=utf-8
>>
>> Oops, I guess the mailing list doesn?t show attached images.
>>
>>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>>
>>> In my import file:
>>>
>>> ```
>>> !Type:Invst
>>> D12/2/2022
>>> NBuy
>>> PXYZ, INC
>>> YXYZ
>>> I150
>>> T450
>>> Q3
>>> CR
>>> M3 shares @ 150; Nothing to see here
>>> ```
>>>
>>> Import and GnuCash creates the correct account, but notice the lack of
>>> a
>> ?Buy? action:
>>>
>>>
>>>
>>> Is this a known issue or am I misunderstanding the need for the action
>>> to
>> be shown 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
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>>
>> --
>>
>> Message: 3
>> Date: Tue, 3 Jan 2023 10:46:56 -0500
>> From: "Derek Atkins" 
>> To: m...@tgr66.me
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
>> Message-ID: <9a802229f90f37a850599830d27ce46a.squir...@mail.ihtfp.org>
>> Content-Type: text/plain;charset=utf-8
>>
>> Hi,
>>
>> On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
>>> Oops, I guess the mailing list doesn?t show attached images.
>>
>> You need to attach it as a file, not embed it in HTML.
>>
>>>
>>>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>>>
>>>> In my import file:
>>>>
>>>> ```
>>>> !Type:Invst
>>>> D12/2/2022
>>>> NBuy
>>>> PXYZ, INC
>>>> YXYZ
>>>> I150
>>>> T450
>>>> Q3
>>

Re: [GNC] Delete / Edit invoice doesn't?

[Derek Atkins]

Hi,

On Tue, January 3, 2023 12:33 pm, Simon Roberts wrote:
> Back again, and very grateful for your ongoing tolerance and help!
>
> We just created an erroneous invoice, specifically it was assigned to the
> wrong customer. Now we're finding two problems and I'm not sure if it's
> user error, or something else.
>
> 1) If we try to edit the invoice, and use the pop-up dialog to change the
> customer, it creates a *new* customer. This actually creates a duplicate,
> as we've given it the customer number and the name. We can see two
> customers side by side (well one on top of the other :) when we go for a
> customer list.

First, you need to ensure the Invoice is not posted.
Second, you need to click "Edit Invoice" to get the popup.
>From there, you should be able to [SELECT] the Customer.  (If it says
[EDIT] and not [Select] then you've probably not unposted the invoice
properly).

It should not create a new Customer.


> 2) If we try to delete the invoice, it seems to half-succeed. The entry
> goes blank in the pane it was showing on, but if we do Customers->Find
> Invoice, it still finds it, and that Find window shows its details. If we
> click on it, it brings up the blank entry in the main tab that lists
> invoices.

There is no way to "delete" an invoice.  How are you attempting to do this?

The two things you can do if you make an erroneous invoice is:

1) You make mark it inactive.  This will hide if from the searches, or
2) You can re-use it by selecting a new customer.

>
> We've patched round this by re-opening the saved gnucash file that
> preceded
> this mistake, but how should we do this, that obviously isn't what's
> intended.
>
> Cheers,
> Simon

-derek

>
>
> --
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Missing "Buy" action after import of QIF file

[Derek Atkins]

Hi,

On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
> Oops, I guess the mailing list doesn’t show attached images.

You need to attach it as a file, not embed it in HTML.

>
>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>
>> In my import file:
>>
>> ```
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ```
>>
>> Import and GnuCash creates the correct account, but notice the lack of a
>> “Buy” action:

The QIF Importer should set the Action field, but it's possible it only
sets it on "one side" (which may not be the side you're looking at).

-derek

>>
>>
>>
>> Is this a known issue or am I misunderstanding the need for the action
>> to be shown 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
>> -
>> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scary moment

[Derek Atkins]

The UI locks up while the Save happens, so saving every minute might be...
annoying..  Even on a fast SSD.

I would recommend you don't go below 5.

-derek

On Fri, December 30, 2022 1:50 pm, Simon Roberts wrote:
> New user (refugee from Intuit, finally) question on this topic:
>
> Given that these days we tend to have vast disks, and they're often very
> fast SSDs, I'm inclined to enable auto-save and set a relatively short
> interval (perhaps as little as a minute?)
>
> Are there issues with doing this that I've not thought of? If my file gets
> to several years worth, will it get large enough that this actually takes
> a
> non-trivial amount of time? Will it be unmanageable for other reasons?
>
> Thanks for your wisdom,
> Simon
>
>
> On Fri, Dec 30, 2022 at 11:16 AM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
>> On 12/30/2022 1:02 PM, Derek Atkins wrote:
>> > I suppose there could have been a bug..
>> >
>> > GnuCash is supposed to prevent you from exiting if there is unsaved
>> data.
>>
>> > However, I suppose there COULD be a way for you to shut down / close
>> > GnuCash in a way that prevents it from popping up that dialog box.
>> >
>> > -derek
>>
>> Of course there is. Simply shut down the computer over riding an "there
>> are apps still open" warnings.
>>
>>
>> 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
>> -
>> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scary moment

[Derek Atkins]

I suppose there could have been a bug..

GnuCash is supposed to prevent you from exiting if there is unsaved data. 
However, I suppose there COULD be a way for you to shut down / close
GnuCash in a way that prevents it from popping up that dialog box.

-derek

On Fri, December 30, 2022 12:46 pm, R Losey wrote:
> Yes, I'm well aware of that... I NEVER double-click on the GnuCash files;
> I
> just bring up GnuCash itself and it uses (I presume) the last file I used,
> which is the only one I have.
>
> So, it wasn't that.  On Wed, I did the open on the Mac and they were
> missing (I thought that I may have forgotten to enter them, but that's
> never happened before for me).  Today, I opened GnuCash on Windows and the
> transactions were definitely missing.
>
> The only thing I've done differently is that I've started running the
> gnucash command line updater more frequently. I have been running it on
> Friday nights, but this week I started running it Tue, Wed, and Thu.  Wed
> (I think) I ran the update program and went to the latest version.
>
>
> On Fri, Dec 30, 2022 at 11:03 AM Derek Atkins  wrote:
>
>> Unlikely..
>>
>> HOWEVER, one IMPORTANT thing to keep in mind on the Mac is that GnuCash
>> does not honor double-clicking on a data file to open /that/ file.  When
>> you double-click on ANY data file, GnuCash will start and ALWAYS open
>> the
>> last file you had used..  It doesn't matter WHAT file you clicked on...
>>
>> If you File -> Save As, then that becomes your new "last used file".
>> If you File -> Open, then THAT becomes your new "last used file".
>>
>> If you need to open a specific file on a Mac, you must ALWAYS use File
>> ->
>> Open.  And then you need to be aware that that is the new "last used
>> file"
>> and is what GnuCash will open the next time you start it.
>>
>> -derek
>>
>> On Fri, December 30, 2022 11:47 am, R Losey wrote:
>> > I just had a thought about what may be the cause... I was fooling
>> around
>> > with the financial quote program on Ubuntu and had run it multiple
>> times.
>> > Maybe that somehow erased the changes.
>> >
>> > On Fri, Dec 30, 2022 at 10:43 AM R Losey  wrote:
>> >
>> >> I was doing preliminary tax workup earlier this week, and (to my
>> >> surprise), there were some transactions mentioned that I thought I'd
>> >> entered last Friday... (I only noticed because they weren't there in
>> the
>> >> report I was using). Anyway, I entered them, verified that they
>> showed
>> >> up
>> >> on the report, and went my way.
>> >>
>> >> This morning, I opened GnuCash to do regular data entry for the week,
>> >> and
>> >> those same transactions were missing again.
>> >>
>> >> It was scary... possibly even scarey.
>> >>
>> >> My first thought was that I had accidentally opened an old version of
>> >> the
>> >> data file, but it did not appear to be so.  My next was that there
>> was a
>> >> problem between 4.12 and 4.13... I had entered the transactions on
>> 4.12
>> >> under MacOs, and was on 4.13 on Windows 10 earlier.
>> >>
>> >> I re-entered the missing transactions again and closed and
>> >> re-opened GnuCash, and they were there, so I'm not sure what
>> happened.
>> >>
>> >> But it was frightening to ponder how many transactions that I didn't
>> >> catch
>> >> may be missing.
>> >>
>> >> I'm hoping that I just forgot to save the data file the other day,
>> but
>> >> that is pretty rare for me.
>> >>
>> >> I just updated my MacOS GnuCash version to 4.13 and I ran a file
>> >> check
>> >> that completed without problems.
>> >>
>> >> --
>> >> _
>> >> Richard Losey
>> >> rlo...@gmail.com
>> >> Micah 6:8
>> >>
>> >
>> >
>> > --
>> > _
>> > 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.
>> >
>>
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scary moment

[Derek Atkins]

Unlikely..

HOWEVER, one IMPORTANT thing to keep in mind on the Mac is that GnuCash
does not honor double-clicking on a data file to open /that/ file.  When
you double-click on ANY data file, GnuCash will start and ALWAYS open the
last file you had used..  It doesn't matter WHAT file you clicked on...

If you File -> Save As, then that becomes your new "last used file".
If you File -> Open, then THAT becomes your new "last used file".

If you need to open a specific file on a Mac, you must ALWAYS use File ->
Open.  And then you need to be aware that that is the new "last used file"
and is what GnuCash will open the next time you start it.

-derek

On Fri, December 30, 2022 11:47 am, R Losey wrote:
> I just had a thought about what may be the cause... I was fooling around
> with the financial quote program on Ubuntu and had run it multiple times.
> Maybe that somehow erased the changes.
>
> On Fri, Dec 30, 2022 at 10:43 AM R Losey  wrote:
>
>> I was doing preliminary tax workup earlier this week, and (to my
>> surprise), there were some transactions mentioned that I thought I'd
>> entered last Friday... (I only noticed because they weren't there in the
>> report I was using). Anyway, I entered them, verified that they showed
>> up
>> on the report, and went my way.
>>
>> This morning, I opened GnuCash to do regular data entry for the week,
>> and
>> those same transactions were missing again.
>>
>> It was scary... possibly even scarey.
>>
>> My first thought was that I had accidentally opened an old version of
>> the
>> data file, but it did not appear to be so.  My next was that there was a
>> problem between 4.12 and 4.13... I had entered the transactions on 4.12
>> under MacOs, and was on 4.13 on Windows 10 earlier.
>>
>> I re-entered the missing transactions again and closed and
>> re-opened GnuCash, and they were there, so I'm not sure what happened.
>>
>> But it was frightening to ponder how many transactions that I didn't
>> catch
>> may be missing.
>>
>> I'm hoping that I just forgot to save the data file the other day, but
>> that is pretty rare for me.
>>
>> I just updated my MacOS GnuCash version to 4.13 and I ran a file
>> check
>> that completed without problems.
>>
>> --
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>>
>
>
> --
> _
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Date format for QIF file

[Derek Atkins]

The supported formats are, IIRC:
y-m-d
y-d-m
d-m-y
m-d-y

Every time you start an import it will begin with the full list and use
the dates in the file to rule out from the list; if there remains more
than one once all the file is loaded, then it asks you.  If the set is
empty once the file is loaded, then it raises an error.

-derek

On Thu, December 29, 2022 3:30 pm, Peter West wrote:
> I did. My question remains. What are the formats? For example, is
> /MM/DD supported? What, exactly, does NN/NN/(NN)NN mean? In my corner
> of the world, NN/NN/(NN)NN is taken to mean DD/MM/(YY)YY. In the US, it
> means MM/DD/(YY)YY, apparently. It is surprising to me that an unambiguous
> QIF date spec like dd monthname year is not supported.
> —
> Peter West
> p...@pbw.id.au
> And the angel said to them, “Fear not, for behold, I bring you good news
> of great joy that will be for all the people. For unto you is born this
> day in the city of David a Saviour, who is Christ the Lord. And this will
> be a sign for you: you will find a baby wrapped in swaddling cloths and
> lying in a manger.”
>
>> On 30 Dec 2022, at 6:18 am, Dan Black  wrote:
>>
>> If you read Derek's reply again, he stated that you must use numbers
>> only; month names are not acceptable.
>>
>> Dan
>>
>> On December 29, 2022 3:14:02 PM Peter West  wrote:
>>
>>> What date formats ARE supported by the GNC QIF import process? 29
>>> December 2022 is unambiguous, but apparently unsupported by GNC.
>>>
>>> Happy 6th day of Christmas!
>>>
>>> —
>>> Peter West
>>> p...@pbw.id.au
>>> And the angel said to them, “Fear not, for behold, I bring you good
>>> news of great joy that will be for all the people. For unto you is born
>>> this day in the city of David a Saviour, who is Christ the Lord. And
>>> this will be a sign for you: you will find a baby wrapped in swaddling
>>> cloths and lying in a manger.”
>>>
>>>> On 30 Dec 2022, at 4:55 am, Derek Atkins  wrote:
>>>>
>>>> Not particularly.
>>>> The issue is that 11/12 is ambiguous.  Is it November 12 or December
>>>> 11?  Using a 2-digit year doesn't help.
>>>> The best way is to ensure you have a day > 12 in the mix (and a year >
>>>> 31). So using 12/29/2022 should give you a unique format.
>>>> You cannot use month names, only numbers.
>>>> -derek
>>>> Sent using my mobile device. Please excuse any typos.
>>>> On December 29, 2022 14:35:09 m...@tgr66.me wrote:
>>>>
>>>>> I’m developing QIF files to import my old investments. I get asked
>>>>> every time to confirm the date format (the entire import process is a
>>>>> bit long imo). The QIF specification says I ought to be able to enter
>>>>> a date using `dd month year`; for example: 29 December 2022. However,
>>>>> this results in an error in GnuCash.
>>>>>
>>>>> Is there a format I can use in the files that GnuCash will accurately
>>>>> autodetect the correct format?
>>>>>
>>>>> Thanks.
>>>>>
>>>>> Tim
>>>>> ___
>>>>> 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.
>>
>>
>
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Date format for QIF file

[Derek Atkins]

Not particularly.
The issue is that 11/12 is ambiguous.  Is it November 12 or December 11?  
Using a 2-digit year doesn't help.
The best way is to ensure you have a day > 12 in the mix (and a year > 31). 
So using 12/29/2022 should give you a unique format.

You cannot use month names, only numbers.
-derek
Sent using my mobile device. Please excuse any typos.
On December 29, 2022 14:35:09 m...@tgr66.me wrote:

I’m developing QIF files to import my old investments. I get asked every 
time to confirm the date format (the entire import process is a bit long 
imo). The QIF specification says I ought to be able to enter a date using 
`dd month year`; for example: 29 December 2022. However, this results in an 
error in GnuCash.


Is there a format I can use in the files that GnuCash will accurately 
autodetect the correct format?


Thanks.

Tim
___
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] GNUCash - Total Assets <> Total Liabilities + Equity

[Derek Atkins]

Hi,

I don't see any "snip" so not sure what you are referring to...
But yes, my guess is yes, it's an exchange-rate issue and not accounting
for the change in value from Time_0 to Time_1 when you have a
cross-currency transaction.
My first guess would be what the exchange rate was on the 1000€ on the
date you created the transaction, and see if that helps answer the
discrepancy.
The other places to look would be exchange rate differences at any other
exchanges.
Good Luck,
-derek

On Wed, December 28, 2022 4:53 pm, Sebastian Naumann wrote:
> Hi everyone,
>
> I have a small issue here arising, from what I believe, the Exchange
> rates.
>
> Background:
>
>   * The entity I am working on received a Loan in EUR and decided to set
> their Common Stock Capital to 1000 EUR instead of 1000 USD.
>   * The entity operated for one year only and will be closed as of
> 12/31/2022
>   * All outstanding loans were already reclassed (as part of closing the
> accounts) to other Income as "Cancellation of Debt Income". This is
> approved by the CPA.
>
> The situation at this point:
>
>   * *All Invoices and bills have been paid in full!!!*
>   * *Trial Balance is good -> Debits = Credits
> *
>   * I closed out all the accounts, including the Bank Account which was
> closed yesterday -> Hence there are $0.00 Assets.
>   * On the other side of the Balance Sheet, we only have
>   o the Common Stock for 1000 EUR, which is converted to 1062.15 USD
> as of the latest exchange rate used -> *SO FAR SO GOOD.*
>   o The Retained Earnings, which are the loss for the current year
> -> *All good here too*.
>   o "*Unrealized Losses"* of $116.52, which, from a logical
> standpoint can only come from the FX Adjustment on Common Stock
> (see snip below)
>   o Equity + Liabilites is now $21.55 vs Total Assets of $0.00
>
> However, how come this does not balance? Anyone have this issue before?
>
> Mit freundlichen Grüßen
>
> Sebastian Naumann
> *US Compliance Manager*
>
>
>
> *MERCATORZ INTERNATIONAL GmbH & Co. KG*
> Klingholzstr. 7
> 65189 Wiesbaden
>
> Web: www.mercatorz.com <https://www.mercatorz.com>
> E-Mail: naum...@mercatorz.com
> PGP Fingerprint: DBCF ED37 6B00 25DE C469 5E0B E6B0 15C4 E292 430E
> Tel. (direkt): +49 (0) 611 95 00 96-11
> Tel.: +49 (0) 611 95 00 96-00
>
> *Buchen Sie Ihr Erstgespräch
> <https://outlook.office365.com/owa/calendar/kundenterm...@mercatorz.com/bookings/>*
>
> Sitz: DE-65189 Wiesbaden
> Handelsregister: Amtsgericht Wiesbaden, HRA 11324
>
> Vertreten durch: MERCATORZ Verwaltungs GmbH
> Geschäftsführer: Michael Kempe
> Sitz: DE-65189 Wiesbaden
> Handelsregister: Amtsgericht Wiesbaden, HRB 32973
>
> /Vertraulichkeitserklärung / Legal Notice
> Diese E-Mail enthält Informationen, die rechtlich geschützt oder
> vertraulich sein können. Sie ist ausschließlich für den angegebenen
> Empfänger bestimmt. Sollten Sie nicht der richtige Adressat sein oder
> diese E-Mail irrtümlich erhalten haben, informieren Sie bitte
> unverzüglich den Absender und vernichten Sie diese E-Mail. Das
> unerlaubte Kopieren oder Offenlegen sowie die unbefugte Weitergabe
> dieser E-Mail ist nicht gestattet.
>
> This e-mail contains information that may be privileged or confidential.
> It is intended only for the person to whom it is addressed. If you are
> not the intended recipient or have received this e-mail in error please
> notify the sender immediately and destroy this e-mail. Any unauthorized
> copying, disclosure or distribution of the material in this e-mail is
> strictly forbidden.
>
> Schützen Sie den Wald und die Umwelt! Bitte drucken Sie diese E-Mail nur
> aus, wenn es nötig ist./
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transactions Buy/Sell

[Derek Atkins]

There is no requirement to fill in that field.  It's just informational.
-derek
Sent using my mobile device. Please excuse any typos.
On December 24, 2022 15:05:21 Charles Gagnon via gnucash-user 
 wrote:



I run GnuCash using a MySQL DB backend.

According to the schema docs, the "action" (Buy/Sell) in splits for
stocks/ETFs/funds should always include a "Buy" or "Sell" value. I noticed
that in my database, there are many transactions with that field empty. I'm
confused as to how this impacts other reports. In the DB, the price and
quantity are unchanged, so this value is needed to build a portfolio view.

Interestingly, if I quickly edit and re-save the transaction, it often
fills that value.

Should I fill out a bug, or has this a known behavior?

Tks

--
Charles Gagnon
charlesg at unixrealm.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
-
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] Best practice to change name of GnuCash file ("book")?

[Derek Atkins]

File —> Save As
And choose a different name.
-derek
Sent using my mobile device. Please excuse any typos.
On December 20, 2022 10:24:46 Eric Chapman  wrote:


Hi,

I named my file incorrectly. I guess in GnuCash the data file is called
a "book". I'm using .xml.

Should I export and import with a new name (as discussed here in issue
tracker: https://github.com/codinguser/gnucash-android/issues/634)?

I'm attaching what I see as the types of files I can export from v. 4.13.

I tried to export "Accounts", but I am not sure that's what I want,
since the exported file is called *.gnucash, but that type of import is
not listed on the "Import" dialog (see attached).

Also, when I exported "Accounts", I also got a .log file which Finder
shows as having zero bytes. What is it for?

Thanks!
Eric



--
___
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] How to use Vendors & Accts Payable, but pay via Credit card?

[Derek Atkins]

Why don't you make the column wider?  Your description column is HUGE.
Try double-clicking on the "Bil" header to make it wider -- or grab the
right side and drag to the right --- and then reduce the description
column.

I believe that is the "Billable?" column, which says that the line-item is
billable back to a customer.

-derek

On Tue, December 20, 2022 9:08 am, Eric Chapman wrote:
> If I can get a screenshot to go through to the GnuCash e-mail list,
> attached is what I was talking about (when "Edit Bill" is chosen).
>
> Thanks,
>
> Eric
>
> On 12/19/22 22:23, Adrien Monteleone wrote:
>> Not sure what you mean, I've attached a screenshot of my Edit Bill
>> window.
>>
>> Is this what you are seeing?
>>
>> Regards,
>> Adrien
>>
>> On 12/19/22 9:17 PM, Eric Chapman wrote:
>>> Adrien,
>>>
>>> I appreciate your help. For whatever reason I did not see the "Post"
>>> button at the top :)
>>>
>>> What does the "BIL" column at the end of the "Edit Bill" window do? I
>>> can put an X in it or leave it
>>> blank.___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] "Edit Bill": How do "Bill ID" and "Billing ID" differ?

[Derek Atkins]

At the time it was written, screens were much smaller so phrases were
abbreviated otherwise you'd need a 3k-wide screen due to all the extra
verbiage.  I DO believe there is a tooltip that pops up that explains what
the field is for, and it is DEFINITELY explained in the documentation.

-derek

On Tue, December 20, 2022 9:10 am, Eric Chapman wrote:
> Thank you for that info!
>
> Suggestion to developers: One could say "Our Billing ID", and the other
> could say "Their Billing ID". Then I think it might be easier to
> understand.
>
> Thanks,
> Eric
>
> On 12/20/22 09:08, Derek Atkins wrote:
>> Hi,
>>
>> One is your reference to the bill.  The other is the vendor's reference
>> to
>> the bill (e.g. their invoice number).
>>
>> -derek
>>
>> On Tue, December 20, 2022 9:04 am, Eric Chapman wrote:
>>> Hi, all,
>>>
>>> I'll try to attach a 49.9KB screen shot to this email, but not inline.
>>> I
>>> noticed another new-to-the-list person seemed successful in attaching
>>> images that way. My in-the-body-of-the-email ones don't seem to go
>>> through.
>>>
>>> What I'm wondering is how do "Bill ID" and "Billing ID" differ in the
>>> "Edit Bill" area?
>>>
>>> Thank you!
>>> Eric Chapman
>


-- 
   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
-
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 get screenshots to go through to the e-mail list?

[Derek Atkins]

You need to attach it as an attachment.  Inline does not work -- they get
stripped from the list.
Your attachment made it through just fine in your question (after this)
about Bill ID vs Billing ID.

-derek

On Tue, December 20, 2022 8:54 am, Eric Chapman wrote:
> Hi,
>
> I'm rather a newbie both to GnuCash and the list. I try to attach
> screenshots and they do not go through. Can I do anything to get
> approved for them? Or do I just need to wait? Maybe it's a function of
> time or the number of emails sent to the list? (I realize the need to
> not let first time posters include images.)
>
> Thanks,
> Eric Chapman
>
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] "Edit Bill": How do "Bill ID" and "Billing ID" differ?

[Derek Atkins]

Hi,

One is your reference to the bill.  The other is the vendor's reference to
the bill (e.g. their invoice number).

-derek

On Tue, December 20, 2022 9:04 am, Eric Chapman wrote:
> Hi, all,
>
> I'll try to attach a 49.9KB screen shot to this email, but not inline. I
> noticed another new-to-the-list person seemed successful in attaching
> images that way. My in-the-body-of-the-email ones don't seem to go
> through.
>
> What I'm wondering is how do "Bill ID" and "Billing ID" differ in the
> "Edit Bill" area?
>
> Thank you!
> Eric Chapman
>
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Does it matter the other transactions are entered?

[Derek Atkins]

Hi,

Yes, you can enter transactions in whatever order you like.

However you can you only RECONCILE in date-order, because reconciliation
is always "from the beginning of time".  So once you reconcile, you cannot
(easily) add transactions earlier than the latest reconcile date, and you
cannot reconcile backwards (newest to oldest).

Hope this helps,

-derek

On Tue, December 13, 2022 12:19 pm, Dr. David Kirkby wrote:
> I am starting to enter into GnuCash the transactions starting late
> February
> this year. That’s going to be a slow painful process. However, I have had
> a
> few transactions today, which I would like to enter too. Does the order
> the
> transactions are entered matter, as long as the dates are correct?
>
> In the case of bills,  but not invoices, I have never kept any number
> associated with them - only with invoices. So it would mean that the
> number
> on bills are pretty much random, as I would be entering transactions in
> December before some of those of March.
>
> I could simply start bills in December with the lowest number being 1000,
> and bills from late February starting with number 1. (There would be less
> than 1000 transactions, so they would not overlap.) But since I have never
> associated a number with them, a number being out of order doesn’t matter
> to me.
>
> Will exported CVS files be in date order, or the order the transactions
> were entered? Will the transactions in GnuCash windows be shown in date
> order, or the order the transactions are entered? (I am on my mobile phone
> now, so can not actually test this, but people might know of things that I
> am overlooking.
>
> I could make a backup of the file, add in a spurious entry to get the bank
> balance right, then check that the would reconcile, but obviously I can’t
> reconcile today until all historical transactions are entered.
>
> Dave
> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
>
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT,
> United
> Kingdom
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] accounts list

[Derek Atkins]

Hi,

What happens if you run Actions -> New Account Hierarchy ??

Although this begs the question:  why can't you File -> Export -> Export
Accounts and re-use your existing Account Hierarchy?  Why rebuild it from
scratch?

Which begs the next question:  Why restart at all?  GnuCash has no
requirement for you to restart the data file, and will happily keep going.
 You can archive each year to refer back (or for posterity).  But I'm
curious why you go through the tremendous effort to restart every year?

-derek

On Mon, December 12, 2022 3:10 pm, David Carlson wrote:
> Orinth,
>
> I am assuming that you are using a computer that has a Windows 10 or 11
> operating system.  GnuCash works somewhat like Word or LibreOffice.  You
> create one data file. You need to save it with a unique name in a
> subfolder
> under your user data folder.  It will have all the accounts that the
> GnuCash setup assistant provides when you select the best account tree for
> your use.  Then you may add some accounts and/or rename some.  Save it
> again.  Now you can quit GnuCash and the next time you start GnuCash it
> will open that same data file.
>
> In Linux it works in a similar way,   but on a Mac it is a little
> different,  but someone else can describe the difference.
>
> On Mon, Dec 12, 2022, 10:09 AM Orith  wrote:
>
>> I have to enter and create each file on its on.  there is no tree.
>> OrithC
>>
>> On Mon, 12 Dec 2022 at 17:56, Maf. King  wrote:
>>
>> > On Monday, 12 December 2022 15:42:40 GMT Orith wrote:
>> > > It seems I missed explaining myself. It is not the data files that I
>> > > am looking for. It's a new year and I can start from scratch to fill
>> the
>> > > files.  When I downloaded GnuCash from the beginning it did not give
>> me
>> > the
>> > > opportunity to build a new accounting files tree. It always did
>> before.
>> > > This time I have to do it one by one on my own.
>> > > Is that the new format of GnuCash 4.12?
>> > > OrithC
>> >
>> > What happens if you choose File -> New File ?
>> >
>> > Maf.
>> >
>> >
>> >
>> >
>> ___
>> 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.
>


-- 
   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
-
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 someone confirm if this split transaction is correct?

[Derek Atkins]

Hi,

On Mon, December 12, 2022 1:56 pm, Mark Penner via gnucash-user wrote:
>
> Dec 12, 2022 10:26:24 Dr. David Kirkby :
>
[snip]
>> I can only select one transfer account, which is not what I want to do.
>>
>> What item(s) on the menu should I be using to make the correct debits
>> and
>> credits to move the money into the PayPal account and the expenses
>> account
>> from the Accounts Receivable -> PayPal (GPB)?
>
> When I process payment, I choose my PayPal account, then edit the
> transaction by adding a split for the fee and subtracting the fee from
> the debit to PayPal. Don't change the Accounts Receivable split.
> If someone has a better solution, I would like to hear it too.

That is the officially supported method.  Process the payment and then
edit the splits, making sure not to touch the A/R or A/P split.

> Mark

> 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
-
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 someone confirm if this split transaction is correct?

[Derek Atkins]

You should have three splits.  You entered 4 splits (two splits into
Assets:PayPal:GBP).  That's why it's showing up twice.

Instead, you should merge those into a single split of 906-38.26, because
your Asset account really only increased by 867.74

-derek

On Mon, December 12, 2022 8:21 am, Dr. David Kirkby wrote:
> I am finally getting to understand this program a bit better, and are
> entering my company accounts. I just want to check if this looks right for
> a PayPal transaction for £906, where fees were £38.26. I'm a bit puzzled
> where there seems to be two split transactions, both showing the same
> information. Is this to be expected? The result looks right
>
> Assets -> PayPal -> GBP  shows  the expected £906 - £38.26  =  £867.74
> and
> Expenses -> Fees -> PayPal fees
> shows the expected  £38.26
>
> Given a simple transaction has two splits, how many should this have?
>
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions.

[Derek Atkins]

Did you copy your data file?
Did you File -> Open your data file?

-derek
Sent using my mobile device. Please excuse any typos.
On December 11, 2022 11:26:21 Orith  wrote:


1. I got a New computer - Lenovo. no gnu-cash from previous computers, i
cleaned it out to make sure the viruses did not come to the new laptop.
Thus, I need to download the new version 4/11. When it is opened, no list
of accounts are available, I need them. tried to delete and restore and
tried again, still no accounts.

2.  I have used Gnu for over 10 years. always happy. This time, when I
tried to make my own accounts and save them, they were on the desktop. I
tried to change the settings, and it gave me a new window,  I'm just
getting confused.

thanks for your help in advance
orith c.
___
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] ANNOUNCE: IRC: irc.gnome.org Alias Changed

[Derek Atkins]

There are literally dozens of IRC clients out there to choose from.

If you care about Matrix, then I suggest you contact them about it; it was
working before, so I'm sure they can make it work again.  We have no
control over such third-party integrations.

While we do have a channel registered over at libera, it is not actively
monitored, logged, or maintained at this time, so using it is completely
at your own risk.

-derek

On Fri, December 9, 2022 9:20 am, JokerGermany wrote:
> Looks like you can join as Matrix user anymore because irc.gimp.org
> isn't bridged to matrix? =(
>
> Am Dienstag, dem 29.11.2022 um 15:47 -0800 schrieb John Ralls:
>> The Gnome infrastructure team has changed the alias for irc.gnome.org
>> from irc.gimp.org to irc.libera.chat. That means that the #gnucash
>> IRC channel on irc.gnome.org is no longer the one monitored by the
>> GnuCash team. If you have configured an IRC client to connect to
>> #gnucash on irc.gnome.org you need to reconfigure it to connect on
>> irc.gimp.org.
>>
>> Regards,
>> John Ralls
>> ___
>> gnucash-announce mailing list
>> gnucash-annou...@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-announce
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.