Re: [GNC] Search and Replace

[David Carlson]

Regarding search and replace, I wouldn't want to get too aggressive with
that in existing transactions, especially reconciled transactions.   It
could easily overwrite intentional spelling choices.  However, I would also
like to only have a limited selection of choices for new transaction s,
preferably correctly spelled, unless I use a lot acronyms meaningful to
only a very select audience.
Not knowing how to decide which suggestion s would be good, I don't see a
good way prevent bad choices from being included unless the user creates a
custom dictionary. That could get very cumbersome.

On the second idea, I would love to have an undo/redo feature similar to
the one in the office suites.

On Fri, Apr 28, 2023, 7:19 PM Gyle McCollam  wrote:

> Now that V5.0 offers choices when you start typing in the description, I
> find errors in spelling and other differences in the way I've entered
> names.  I try to clean these up, but sometimes there are n excess of a
> hundred, because they were repeated when earlier versions showed
> suggestions.  In order to eliminate V5.0 offering this bad spelling along
> with the proper spelling the incorrect spelling needs to be changed.  It
> would be helpful if Gnucash offer a llokup and replace function.  I haven't
> found one, am I missing it or doesn't it exist.  If not I will suggest it
> for a future enhancement.
>
> While on the subject of enhancements, It would be helpful to have an undo
> and redo function as in Libre Office and many other spreadsheet programs.
> I have sometimes accidentally changed a transaction or eliminated what is
> in a field and would like to exit the transaction with no changes.  Is
> there a way to do that now?
>
>
> 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.

[GNC] Transactions in Placeholder

[Fred Tydeman]

My understanding is Placeholder accounts should have zero transactions in
them.

However, when I Import a QIF file, sometimes I end up with transactions in
a Placeholder account.

It would be nice if the importer would give a warning about putting
transactions into a Placeholder account.  That way, I could pick a
different account to import into.
___
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] Search and Replace

[Gyle McCollam]

Now that V5.0 offers choices when you start typing in the description, I find 
errors in spelling and other differences in the way I've entered names.  I try 
to clean these up, but sometimes there are n excess of a hundred, because they 
were repeated when earlier versions showed suggestions.  In order to eliminate 
V5.0 offering this bad spelling along with the proper spelling the incorrect 
spelling needs to be changed.  It would be helpful if Gnucash offer a llokup 
and replace function.  I haven't found one, am I missing it or doesn't it 
exist.  If not I will suggest it for a future enhancement.

While on the subject of enhancements, It would be helpful to have an undo and 
redo function as in Libre Office and many other spreadsheet programs.  I have 
sometimes accidentally changed a transaction or eliminated what is in a field 
and would like to exit the transaction with no changes.  Is there a way to do 
that now?


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.

Re: [GNC] Error message when opening file in 5.0

[John Ralls]

> On Mar 27, 2023, at 2:14 PM, figures...@outlook.com wrote:
> 
> I have been using Gnucash for many years now, latest version 4.14
> I successfully installed version 5.0 but when I attempt to open my main 
> account file I get the error message “User specified a ‘book currency’; cost 
> of other currencies/commodities tracked in terms of book-currency (requires 
> at least Gnucash 2.7.0)”
> As I said, I am currently using version 4.14 with no issues. I admit the 
> account file I am using dates back many years, but I have been updating 
> Gnucash regularly over the years.
> Is there a way to isolate and eliminate this error message?
> Thanks very much for an excellent program.
> 
> Sent from Mail for Windows

The book-currency feature was created 6 years ago as part of an ambitious 
project that never got finished. It added several hundred unused lines to the 
options code so I removed it as part of rewriting that options code in C++. I 
thought that it wouldn't have gotten set in any books.

I've restored the feature to 5.1 so you and anyone else with the feature set 
will be able to upgrade.

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.

Re: [GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Dr. David Kirkby]

On Sat, 28 Jan 2023 at 21:41, Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Thu, 26 Jan 2023 at 09:31, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> Fix:
>>
>> Delete the PorkBun payment and re-entered properly as a payment in USD
>> or if it were in GBP to a USD Vendor, turn on Trading Accounts, then
>> re-enter the payment in GBP with the FX as the fixed debit amount.
>>
>
> Based on the discussion at https://bugs.gnucash.org/show_bug.cgi?id=798734
>
> it seems to be a GnuCash bug, which will be fixed in the next release.
>

That does indeed to be the case. I just updated to version 5.0, and the
issues with some foreign currency transactions have now disappeared.
___
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 5 - Trial Balance

[Michael or Penny Novack]

On 4/28/2023 2:59 AM, Chris Bastock via gnucash-user wrote:

Thanks for all the input.
I am aware that both TB and Balance sheet are snapshots on a particular date 
and of the respective uses of both of them. Personally I’m happy with the TB 
report and I do it periodically throughout the year. I guess my reason for 
asking was only because my accountant had asked specifically for a TB covering 
only the financial year that they were auditing the accounts for.

The TB report options are misleading as it does offer a date range. Maybe the 
only solution to keeping my accountant happy is to close the books each year 
(although according to the GNUCash manual this isn’t necessary).

The zero balances I was referring to were more to do with accounts that I just 
don’t use. So the take home for me is that I need to clean up my account tree!


If you consider how "trial balance" used to be used, a "date range" sort 
of makes sense.


In the old days, after a trial balance, a double line was drawn under 
each account. The meaning of which was "in balance as of this point". 
When searching for an OOB error, you didn't need to search before a 
double line. It was in balance at that point, so any OOB now has to be 
an entry after that point. Is the date range offered perhaps trying to 
mimic that?


Like I said, I have not (bothered to) run a "trial balance" since BEFORE 
switching to gnucash. A computerized bookkeeping application simply 
isn't going to make the sort of errors a trial balance would disclose 
(and help us find*). If there is nothing in Imbalance or Orphan, the 
books are in balance. Yes, we could have made errors of the "put into 
wrong account" sort but that would not be disclosed by a trial balance. 
The errors a trial balance will disclose are things like the all too 
common transposition of digits during manual posting from the journal to 
the ledger. The computer simply won't make that sort of error.


Michael D Novack

* Examples (we had to learn all sorts of tricks like this) So the trial 
balance is out of balance? By how much? Is the difference divisible by 
9? Then look for transposed digits.



___
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 5 - Trial Balance

[Chris Bastock via gnucash-user]

Thanks for all the input. 
I am aware that both TB and Balance sheet are snapshots on a particular date 
and of the respective uses of both of them. Personally I’m happy with the TB 
report and I do it periodically throughout the year. I guess my reason for 
asking was only because my accountant had asked specifically for a TB covering 
only the financial year that they were auditing the accounts for. 

The TB report options are misleading as it does offer a date range. Maybe the 
only solution to keeping my accountant happy is to close the books each year 
(although according to the GNUCash manual this isn’t necessary).

The zero balances I was referring to were more to do with accounts that I just 
don’t use. So the take home for me is that I need to clean up my account tree!

Thanks everyone, appreciate the input and support. 
Cheers. 
Chris 

Sent from my iPhone

> On 28 Apr 2023, at 05:19, Liz  wrote:
> 
> On Thu, 27 Apr 2023 16:44:17 +0100
> Chris Bastock via gnucash-user  wrote:
> 
>> I also not that on the TB there is no way to filter for accounts with
>> a zero balance. This means manually removing them. 
> 
> Is this really desirable? If I was your auditor, I would want to see
> accounts with a zero balance. They may have had a balance in a previous
> period.
> 
> 
> Liz

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.