Re: [GNC] Reversing a finished credit card reconciliation

2023-06-25 Thread edodd
On Sun, 25 Jun 2023 11:00:53 -0500
David Carlson  wrote:

> David T., et alia,
> 
> Somewhere in the nether regions of my pea brain I have a recollection
> of a 'feature' to automatically add an adjustment transaction to
> bring a reconciliation into balance without  finding the 'error'.
> 
> That was probably in one of the other programs that I used before I
> started using Gnucash, but it might be a feature that some GnuCash
> users might want.


It is there, left hand end of the toolbar. I used it once, and won't
ever again.

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


Re: [GNC] GnuCash 5.2 Released - Can't save in xml format

2023-06-25 Thread Vincent Dawans
Mike: A new little bug sneaked in 5.2. It's being worked on and hopefully
an update should be out soon.
https://bugs.gnucash.org/show_bug.cgi?id=798967 ;
You might need to revert back to 5.1 for now but the update should be out
quickly. For those that haven't upgraded yet, it's best to hold on until an
update is released.

On Sun, Jun 25, 2023 at 4:43 PM Mike Commissaris 
wrote:

> Running Asus laptop with MX-Linux 21
>
> I normally wait for a while before building a new release but this time I
> jumped in.
> I downloaded and built 5.2 without error. Added some transactions but could
> not save them in xml.
>
> Error:
> "Could not write to file.check that you have permission to write 
> and there is space etc.
>
> I seem to be able to save / work in sqlite3 data file.  I also experimented
> by starting a new data file but could not save in xml.
>
> Hope I didn't overlook something.
>
> Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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] "Easy" way to revert to default Gnucash?

2023-06-25 Thread Ken Farley
I am running Gnucash on MacOS, but presumably the philosophy behind 
customizing the look if the interface is the same. The way things look 
as far as "themes" go is dictated by a file called "gtk.css". I don't 
know where this particular file is saved on a Windows system, but you 
could probably find out by looking in the Wiki, or checking past mailing 
list messages and searching for GTK or something like that. Once you 
find the file, you could try renaming it to something like 
"gtk.css-old", start up Gnucash, and see what things look like.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Bank reconcile

2023-06-25 Thread David Cousens
James

The usual information on a bank statement for a credit card willusually be an
summary statement with the Opening balance, the total charges to the account for
the period, total payments during the period and the closing balance at the end
of the period. You normally have to reconcile from the date of the opening
balance to the date of the closing balance.

This will be followed by the transaction records for the period. The usual
columns are Date, Details, Amount of the transaction and a Balance (after the
transaction), the latter is sometimes optional. The amount may be two columns
one for debits and the other for credits to the account My bank records charges
to the account as positive amounts and payments as negative but you will have to
work out how your bank records them A credit card in the banks accounts is an
asset account so if they are using debit/credit columns, charges added to the
account will be debits and payments by you will be credits on the statement.

When you use the reconciliation dialogue, first you have to check that the
opening balance GnuCash calculates matches the Opening Balance on the statement
and enter the closing date of the statement and the closing balance.  You can
choose to add any interest amounts also at this time using the button on the
setup dialogue If the Opening balance doesn't match, then you likely have an
error in the reconciliation of the previous period. You need to correctly
reconcile any previous periods before reconciling the current period. 

When the dialogue comes up the charges you have recorded normally appear in the
RH pane and the payments in the LH pane of the window. Gnucash will normally
have checked by default all the amounts which you have reorded between the start
date. You can clear the check marks by clicking in one of the panes, pressing
Ctrl-A, and selecting Unreconcile Selection from the dialogue toolbar. If you
then match the transactions one by one with the statement checking off the
matching entries, you will possible identify transactions which you have not
entered into Gnucash.  You can enterr any unentered transactions into GnuCash
and correct any incorrect ones without closing the reconciliation dialogue in
the appropriate account register and they should then automatically appear in
the appropriate pane of the dialog and you can check them off. I mark the
matched transactions both with the check boxes in the dialogue and with a mark
against the mark on the statement (if a paper copy) so I don't miss anything. If
you only have a pdf copy of the statement either print it out or copy it into a
spreadsheet where you can mark off the transactions as you match them.

 Once you have matched all the transactions in the statement to those in GnuCash
(including the interest amounts), your closing balance in GnuCash should match
the closing balance on the statement. If not then check the difference and make
sure any transactions for that amount (or multiple transactions summing to the
difference) are marked off on both the statement and the checkboxes in the
dialogue. When you have a mismatch in the closing balance, the sign can tell you
whether you are missing a transaction or have checked off one which wasn't on
the statement.

David Cousens

On Sun, 2023-06-25 at 23:44 +, James Baxter via gnucash-user wrote:
> I have spent the afternoon looking to reconcile my credit card account. The
> bank is listing two set of numbers. One is a 4 digit number. The other is 3
> digit. But there are pennies after that. 
> They are also changing me a interest as well. I have tried to balance it. All
> items on the statement are in GnuCash. Not the bank charges. But I still can't
> work it our. I have the starting amount. But the ending balance after 6
> months, don't work.
> I have tried to reconcile all of it in one go. Then looked at it one month at
> a time. So I am at the end.
> ThanksJames Baxter kangaro...@yahoo.com 
> 
> Sent from Yahoo Mail on Android
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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] Can not resize GnuCash Preferences window

2023-06-25 Thread David Carlson
Well, I am running GnuCash 4.8 usually in Ubuntu 22.04, and I see that the
Preferences window fills the vertical space where my display is set to 1366
x 768.  There is no need for the window to be that tall and fixed in size
without a scrollbar.  I would file an enhancement bug report to give that
window a scrollbar, if nobody else beats you to it.

On Sun, Jun 25, 2023 at 7:07 PM NoobAlice  wrote:

> Default User hunguponcontent,
>
> This is probably a Wayland windowing system problem, not a GnuCash
> problem.  On Xorg, the window is easily resizable and movable.
>
> What have you tried besides changing the display resolution back and forth?
>
> If you were on Xorg, I would say try these individual solutions on the
> Preferences window:
> * dragging the grabbable titlebar of the window down, then using your
> mouse to resize the window shorter, then dragging it up so you can see
> the bottom
> * holding down your Alt key and then click-holding your normal (left)
> mouse button and dragging the window with your mouse
> * hitting Alt+F7, then using your arrow keys to move the window and
> hitting Enter when you have it where you want it
> * hitting Alt+F8, then using your arrow keys to resize the sides of the
> window and hitting Enter when you have it where you want it
>
> And then I would tell you that, if this window is appearing in the wrong
> place all the time, you could install and set up devilspie to fix it
> permanently.  :)
>
> Surely Wayland has some similar way to manipulate windows.  My quick
> search says that shortcuts are handled by the compositor in Wayland [1].
>   You might get much better answers if you ask in the Gnome support
> channels.
>
> Good luck!  This is a frustrating problem to have. :(
>
> [1]
>
> https://wiki.archlinux.org/title/Wayland#Input_grabbing_in_games,_remote_desktop_and_VM_windows
>
>
> On 2023-06-25 03:08 PM, Default User wrote:
> > Hello!
> >
> > I am trying to set up GnuCash:
> >
> > Version: 4.13
> > Build ID: 4.13+(2022-12-17)
> > Finance::Quote: 1.54
> >
> > on Debian 12 (bookworm), 64-bit, using Gnome 43.4, wayland windowing
> > system (not xorg).
> >
> > This is a .deb package, "GnuCash Version: 1:4.13-1, Built-Using:
> > googletest (= 1.12.1-0.2)", from the Debian Stable repositories, NOT a
> > flatpak, snap, or appimage.
> >
> > When I do Edit --> Preferences, the Preferences window opens, but the
> > bottom part is cut off.  No matter what I try, I can am not able to
> > resize it to fit the screen. Nor can I even move it past the top edge
> > of the screen.  I even tried reducing the display resolution, to no
> > avail.
> >
> > So, is there a solution, or even a viable workaround?
> >
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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


Re: [GNC] gnucash-user Digest, Vol 243, Issue 37

2023-06-25 Thread Mike Commissaris
Removed compression and file now saves.
Thanks for all the hard work. Greatly appreciated.

Message: 7
Date: Sun, 25 Jun 2023 16:29:45 -0700
From: John Ralls 
To: gnucash-annou...@lists.gnucash.org
Cc: gnucash-devel , Gnucash Users

Subject: Re: [GNC] ANNOUNCE: GnuCash 5.2 File Save bug
Message-ID: <5526a72f-26e3-440b-93d7-6b2d9ceed...@ceridwen.us>
Content-Type: text/plain;   charset=us-ascii

There is a bug in GnuCash 5.2 that prevents saving compressed files, see
https://bugs.gnucash.org/show_bug.cgi?id=798967.

If you don't compress your XML files or you use a SQL backend you're not
affected, and that provides an obvious work-around.

We'll get a snap release of GnuCash 5.3 out in a day or so once the cause
has been isolated and fixed.

Regards,
John Ralls

On Sun, Jun 25, 2023 at 4:55 PM  wrote:

> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>1. Re:  Can not resize GnuCash Preferences window (David Carlson)
>2.  "Easy" way to revert to default Gnucash? (Steve Miller)
>3. Re:  SQLite slow to load on macOS but not Linux (Colin Arndt)
>4. Re:  Standard Report - Equity Statement (Michael or Penny Novack)
>5. Re:  "Easy" way to revert to default Gnucash?
>   (Michael or Penny Novack)
>6. Re:  [Gnucash/gnucash] Release 5.2 - GnuCash 5.2 Released
>   (John Ralls)
>7. Re:  ANNOUNCE: GnuCash 5.2 File Save bug (John Ralls)
>8.  GnuCash 5.2 Released - Can't save in xml format
>   (Mike Commissaris)
>9.  Bank reconcile (James Baxter)
>   10. Re:  Can not resize GnuCash Preferences window (Default User)
>
>
> --
>
> Message: 1
> Date: Sun, 25 Jun 2023 16:19:28 -0500
> From: David Carlson 
> To: Default User 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Can not resize GnuCash Preferences window
> Message-ID:
>  xgk2o3gx4aug_4kzan3r...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Do you have a friend or neighbor that could loan you a high resolution
> monitor for a few hours?
>
> On Sun, Jun 25, 2023, 2:09 PM Default User 
> wrote:
>
> > Hello!
> >
> > I am trying to set up GnuCash:
> >
> > Version: 4.13
> > Build ID: 4.13+(2022-12-17)
> > Finance::Quote: 1.54
> >
> > on Debian 12 (bookworm), 64-bit, using Gnome 43.4, wayland windowing
> > system (not xorg).
> >
> > This is a .deb package, "GnuCash Version: 1:4.13-1, Built-Using:
> > googletest (= 1.12.1-0.2)", from the Debian Stable repositories, NOT a
> > flatpak, snap, or appimage.
> >
> > When I do Edit --> Preferences, the Preferences window opens, but the
> > bottom part is cut off.  No matter what I try, I can am not able to
> > resize it to fit the screen. Nor can I even move it past the top edge
> > of the screen.  I even tried reducing the display resolution, to no
> > avail.
> >
> > So, is there a solution, or even a viable workaround?
> >
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/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: 2
> Date: Sun, 25 Jun 2023 14:19:03 -0700
> From: Steve Miller 
> To: Gnucash 
> Subject: [GNC] "Easy" way to revert to default Gnucash?
> Message-ID:
> <
> cakkxngo+h5dv4wz3zarxo8u-jmjguwnbngaspukpnnkr6x1...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> I'm currently using Windows 11 and GnuCash 4.14.
>
> Several years ago I installed a theme, something like leather dark, I
> really don't remember which one or where I got it, it took me seemingly
> forever to install it, I have zero memory of what I did.
>
> *Is there any easy way to go back to a "clean" default install of GnuCash
> using my current datafile?*
>
>
> --
>
> Message: 3
> Date: Sun, 25 Jun 2023 17:35:45 -0400
> From: Colin Arndt 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] SQLite slow to load on macOS but not Linux
> Message-ID: <4ed2c182-cb58-4f60-822a-1a5534e2d...@gmail.com>
> Content-Type: text/plain;   charset=utf-8
>
> To the Gnucash development team,
>
> This issue has been significantly improved in the latest 5.2 release!
>
> As noted below, GnuCash 5.1 on my Mac took about 30 seconds to load. This
> issue did not happen 

Re: [GNC] Can not resize GnuCash Preferences window

2023-06-25 Thread NoobAlice

Default User hunguponcontent,

This is probably a Wayland windowing system problem, not a GnuCash 
problem.  On Xorg, the window is easily resizable and movable.


What have you tried besides changing the display resolution back and forth?

If you were on Xorg, I would say try these individual solutions on the 
Preferences window:
* dragging the grabbable titlebar of the window down, then using your 
mouse to resize the window shorter, then dragging it up so you can see 
the bottom
* holding down your Alt key and then click-holding your normal (left) 
mouse button and dragging the window with your mouse
* hitting Alt+F7, then using your arrow keys to move the window and 
hitting Enter when you have it where you want it
* hitting Alt+F8, then using your arrow keys to resize the sides of the 
window and hitting Enter when you have it where you want it


And then I would tell you that, if this window is appearing in the wrong 
place all the time, you could install and set up devilspie to fix it 
permanently.  :)


Surely Wayland has some similar way to manipulate windows.  My quick 
search says that shortcuts are handled by the compositor in Wayland [1]. 
 You might get much better answers if you ask in the Gnome support 
channels.


Good luck!  This is a frustrating problem to have. :(

[1] 
https://wiki.archlinux.org/title/Wayland#Input_grabbing_in_games,_remote_desktop_and_VM_windows



On 2023-06-25 03:08 PM, Default User wrote:

Hello!

I am trying to set up GnuCash:

Version: 4.13
Build ID: 4.13+(2022-12-17)
Finance::Quote: 1.54

on Debian 12 (bookworm), 64-bit, using Gnome 43.4, wayland windowing
system (not xorg).

This is a .deb package, "GnuCash Version: 1:4.13-1, Built-Using:
googletest (= 1.12.1-0.2)", from the Debian Stable repositories, NOT a
flatpak, snap, or appimage.

When I do Edit --> Preferences, the Preferences window opens, but the
bottom part is cut off.  No matter what I try, I can am not able to
resize it to fit the screen. Nor can I even move it past the top edge
of the screen.  I even tried reducing the display resolution, to no
avail.

So, is there a solution, or even a viable workaround?




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Can not resize GnuCash Preferences window

2023-06-25 Thread Default User
On Sun, 2023-06-25 at 16:19 -0500, David Carlson wrote:
> Do you have a friend or neighbor that could loan you a high
> resolution monitor for a few hours?
> 
> On Sun, Jun 25, 2023, 2:09 PM Default User
>  wrote:
> > Hello!
> > 
> > I am trying to set up GnuCash:
> > 
> > Version: 4.13
> > Build ID: 4.13+(2022-12-17)
> > Finance::Quote: 1.54
> > 
> > on Debian 12 (bookworm), 64-bit, using Gnome 43.4, wayland
> > windowing
> > system (not xorg).  
> > 
> > This is a .deb package, "GnuCash Version: 1:4.13-1, Built-Using:
> > googletest (= 1.12.1-0.2)", from the Debian Stable repositories,
> > NOT a
> > flatpak, snap, or appimage.
> > 
> > When I do Edit --> Preferences, the Preferences window opens, but
> > the
> > bottom part is cut off.  No matter what I try, I can am not able to
> > resize it to fit the screen. Nor can I even move it past the top
> > edge
> > of the screen.  I even tried reducing the display resolution, to no
> > avail. 
> > 
> > So, is there a solution, or even a viable workaround?
> > 
> > 
> > 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.


Hi David.

Here's what I did:
I actually INCREASED the resolution from 1360 x 768 to 1920 x 1080 
(MY EYES! MY EYES!!) long enough to edit the Preferences window, then
decreased to resolution back to 1360 x 768 (I CAN SEE AGAIN! I CAN
SEE!!)

Not a real solution, but a just barely effective, half-donkeyed, duct
tape work-around.

Note: this is an old problem that has been around for YEARS. 
Previously, I was able to work around it by moving the top of the
preferences window above the top of the screen, but apparently that
(and a lot of other things) don't work in "modern" Gnome.  

[Note: there seems to be enough blank space near the bottom of the
Preferences window to shrink its height enough to fit the screen. Or,
the window could always be made resizeable, with a scroll bar . . .  )]

Anyway, thanks for the reply!

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Bank reconcile

2023-06-25 Thread James Baxter via gnucash-user
I have spent the afternoon looking to reconcile my credit card account. The 
bank is listing two set of numbers. One is a 4 digit number. The other is 3 
digit. But there are pennies after that. 
They are also changing me a interest as well. I have tried to balance it. All 
items on the statement are in GnuCash. Not the bank charges. But I still can't 
work it our. I have the starting amount. But the ending balance after 6 months, 
don't work.
I have tried to reconcile all of it in one go. Then looked at it one month at a 
time. So I am at the end.
ThanksJames Baxter kangaro...@yahoo.com 

Sent from Yahoo Mail on Android
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] GnuCash 5.2 Released - Can't save in xml format

2023-06-25 Thread Mike Commissaris
Running Asus laptop with MX-Linux 21

I normally wait for a while before building a new release but this time I
jumped in.
I downloaded and built 5.2 without error. Added some transactions but could
not save them in xml.

Error:
"Could not write to file.check that you have permission to write 
and there is space etc.

I seem to be able to save / work in sqlite3 data file.  I also experimented
by starting a new data file but could not save in xml.

Hope I didn't overlook something.

Mike
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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: GnuCash 5.2 File Save bug

2023-06-25 Thread John Ralls
There is a bug in GnuCash 5.2 that prevents saving compressed files, see 
https://bugs.gnucash.org/show_bug.cgi?id=798967.

If you don't compress your XML files or you use a SQL backend you're not 
affected, and that provides an obvious work-around.

We'll get a snap release of GnuCash 5.3 out in a day or so once the cause has 
been isolated and fixed.

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] [Gnucash/gnucash] Release 5.2 - GnuCash 5.2 Released

2023-06-25 Thread John Ralls
Glen,
Thanks, I noticed it earlier and fixed it.

Regards,
John Ralls

> On Jun 25, 2023, at 1:31 PM, Glenn Fowler  wrote:
> 
> Hi John - thank you and the team for the 5.2 release! Just letting you know 
> on GitHub the windows build has gnucash-5.0.setup.exe instead of 5.2
> 
> On Sun, Jun 25, 2023 at 2:42 PM John Ralls  wrote:
> 
> GnuCash 5.2 Released
> 
> Repository: Gnucash/gnucash · Tag: 5.2 · Commit: 4bba182 · Released by: jralls
> 
> The GnuCash development team announces GnuCash 5.2, the third release in the 
> stable 5.x series
> 
> Between 5.1 and 5.2, the following bugfixes were accomplished:
> 
>   • Bug 777472 - reconcile does not work if transaction selected
> Check that there's no outstanding activity in the current register page 
> before starting a reconciliation. It is still possible to start modifying a 
> transaction after the reconciliation window is open but this will stop the 
> most common issue with the process. Starting a reconciliation from the 
> account tree is left unprotected.
> 
>   • Bug 798564 - GnuCash is slow when there are a lot of open 
> tabs/registers (37)
> Lazily load registers as is already done with reports.
> 
>   • Bug 798597 - The word "Separators" needs two separate versions
> Use "Character-separated" when it's a choice between that and fixed field 
> width and "Select Separator Character" when it's a heading.
> 
>   • Bug 798695 - Deleting everything from the "Transfer" cell after 
> suggestions pop-up restricts search to the first 30 accounts
> Skip the search on an empty value and return all accounts in the combo box as 
> it normally does if the account list is opened without searching for 
> something.
> 
>   • Bug 798796 - Account list incomplete in report options
> Allow stock/fund accounts that are descendants of Bank accounts to be 
> selected for the Advanced Portfolio, Investment Lots and Investment Portfolio 
> reports.
> 
>   • Bug 798809 - Multicolumn report error when reopened after saving.
>   • Bug 798839 - Edit -> Preferences string not translatable (reopened)
>   • Bug 798862 - Merge identical strings (reopened)
> Ensure similar strings are identical and use double line view instead of 
> double line mode.
> 
>   • Bug 798879 - RFE: [Transaction Report] add Running Total option
>   • Bug 798885 - Accented character in folder name on Account Export 
> (reopened)
>   • Bug 798899 - Gnucash crashes during CSV import when using a template 
> if the destination account is changed from one used in the template
>   • Bug 798901 - Wrong value for very small prices from Finance::Quote.
>   • Bug 798916 - Exchange rates fetched from openexchange off by factor 
> of 10
>   • Bug 798919 - Inconsistent signs in creating budget
>   • Bug 798923 - OFX import is no longer matching security nor asking for 
> stock account.
>   • Bug 798930 - invoices won't sequence to the next number
>   • Bug 798948 - XML file corrupted by saving twice in extremely short 
> period
>   • Bug 798952 - Unable to set day threshold or counters in properties.
>   • Bug 798960 - Transaction completion horizontal scrolling opens 
> without the new text being visible and remembers previous position/width
>   • Bug 798966 - Uninitialised variable used in 
> dialog-account-picker.c:dialog_response_cb()
> The following fixes and improvements were not associated with bug reports:
> 
>   • The type-ahead selection of transaction descriptions has been 
> substantially overhauled based on extensive user feedback. Matches are now 
> only on the beginning of words and are now sorted by age since last use. This 
> both substantially reduces the number of matches and prioritizes the most 
> recently used as being the most likely candidates for re-use. To help 
> distinguish cases of long descriptions where the match would be outside the 
> popup's viewport the viewport is automatically scrolled horizontally so that 
> the end of the left-most (right-most in rtl languages) matches is centered in 
> the view. Completion can be aborted with the  key or a new Don't 
> autocomplete selection that's the first entry in the popup.
>   • Fix lockup on Windows in type-ahead selection of transaction 
> descriptions.
>   • More budget-module sign fixes and improvements.
>   • Lots of memory-leak fixes, GLib modernization, and code cleanup by 
> Richard Cohen, Simon Arlott, & Chris Lam.
>   • bugfix xaccTransGetTxnType: avoid returning TXN_TYPE_LINK 
> incorrectly: A TXN_TYPE_PAYMENT will have non-APAR splits; a TXN_TYPE_LINK 
> will not have non-APAR splits. This bug manifests as a regular 
> TXN_TYPE_PAYMENT transaction being later voided being incorrectly changed to 
> TXN_TYPE_LINK.
>   • Including brokerage fees in Money Out calculation (if not ignoring 
> them) in advanced-portfolio.scm report and updating the "advanced" tests to 
> reflect selling fees being included into the money out value

Re: [GNC] "Easy" way to revert to default Gnucash?

2023-06-25 Thread Michael or Penny Novack

On 6/25/2023 5:19 PM, Steve Miller wrote:

I'm currently using Windows 11 and GnuCash 4.14.

Several years ago I installed a theme, something like leather dark, I
really don't remember which one or where I got it, it took me seemingly
forever to install it, I have zero memory of what I did.

*Is there any easy way to go back to a "clean" default install of GnuCash
using my current datafile?*



The data file is independent of the program. Just make sure that you 
don't delete the data file when you uninstall and reinstall gnucash if 
that's the way you want to go (could combine with migrating to a newer 
version). HINT --- Always back up immediately before doing something 
like this.


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.


Re: [GNC] Standard Report - Equity Statement

2023-06-25 Thread Michael or Penny Novack
Might I sort of explain my question to Ismael ... what expecting to see 
on an "equity statement" if PERSONAL books. In other words, what 
(useful) information expecting to see. I do understand why you would 
want a report/statement of equity if (for example)


a) The entity is a partnership.
b) A sole proprietorship BUT there are outside "ownership accounts" << 
would be liabilities ordinarily BUT * >>

c) The entity is a corporation

Michael D Novack

* How those with certain religious beliefs get around prohibitions of 
usury, "iron sheep contracts", etc.     It's not a violation if the 
"lender" shares the risks. Essentially the "lender" is (temporarily) 
buying an interest/share and the borrower might have an option to buy 
back for more. But until then, the :lender" shares in the profits (or 
losses).



On 6/25/2023 4:28 PM, NoobAlice wrote:

Hi Ismael,

"Equity Statement" as a report is the net of your total assets and 
liabilities, your personal equity.  You reach it via

Reports > Income and Expense > Equity Statement
The "Investments" are amounts that you add directly to 
personal-equity-type accounts.  So if I have an account named "Opening 
Balance" that on the Accounts page is Type: Equity, changes to that 
account show up on the Equity Statement report.


You probably want to use "Advanced Portfolio" from
Reports > Assets & Labilities > Advanced Portfolio
which will show you the stocks you own in companies and your 
investments in them.  These are Type: Stock on your Accounts page.  
These stocks are your equity in these companies, but they are just a 
part of your personal equity.
* The total you have invested in each stock through the report date is 
shown in the "Money In" column.

* The total sales are the "Money Out" column.

To make an investment in a stock, money comes out of your checking 
account (an Asset) and goes into the stock (another Asset).  So your 
personal equity does not change at this time, and there is no change 
to the Equity Statement.  But the Advanced Portfolio will show the 
stock investment.


I hope I didn't over-explain anything, but I'm trying to make this 
clear for you and anyone else who has a similar question in the future 
and finds this mailing list post.


NoobAlice

On 2023-06-23 11:08 PM, Ismael via gnucash-user wrote:

Hello
I use V5.1 & Win11

My Standard Report - 'Equity Statement' does not show any amount for 
'Investments for Period'.


I am sure that I have made investments and recorded them in the 
respective Asset account (Stock).


Gnucash HELP is not really helpful for 10.3.5.2. Equity Statement.

Any idea what to do to see 'Investments for Period' in Standard 
Report - 'Equity Statement'


Regards
Ismael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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.



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] SQLite slow to load on macOS but not Linux

2023-06-25 Thread Colin Arndt
To the Gnucash development team,

This issue has been significantly improved in the latest 5.2 release! 

As noted below, GnuCash 5.1 on my Mac took about 30 seconds to load. This issue 
did not happen on my Fedora box - it loaded instantly.

It’s now almost 2x faster (18 seconds). A big win!

Thanks for all your work. If you have any sense of why it would have sped up so 
much, I’d love to hear.
Colin

> On Jun 3, 2023, at 2:50 PM, Colin Arndt  wrote:
> 
> Hi all,
> 
> I set up Gnucash a few years ago on Linux and have since switched to using it 
> on Mac (Ventura 13.4 on a MacBook Air M1 2020). 
> 
> I’ve mainly run it with the XML file, but wanted to take advantage of some 
> add-ons that require a SQL database. After saving as an sqlite3 file on Mac, 
> it now take 30 seconds to load. The XML file opens instantly. (XML file is 
> 18MB, SQLite DB is 12MB, including 9000 transactions and 6000 prices).
> 
> Out of curiosity I opened the same SQLite file on an Intel Linux box of 
> similar age to my MacBook Air. GnuCash opened instantly. The issue is only on 
> my Mac.
> 
> I’ve taken the following steps time without any difference:
> 
> 1. Checked and Repaired all accounts
> 2. Saved file back to an XML then back to an SQLite file, on both my Mac and 
> Linux box
> 3. Ran sqlite3 database_name 'VACUUM;’ from the Terminal
> 4. Deleted all price data
> 
> Reports of this issue mention 1 CPU spinning up to 100% while the file is 
> loaded into memory - and I see the same behavior.
> 
> Any advice on this?
> 
> Thanks,
> Colin

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] "Easy" way to revert to default Gnucash?

2023-06-25 Thread Steve Miller
I'm currently using Windows 11 and GnuCash 4.14.

Several years ago I installed a theme, something like leather dark, I
really don't remember which one or where I got it, it took me seemingly
forever to install it, I have zero memory of what I did.

*Is there any easy way to go back to a "clean" default install of GnuCash
using my current datafile?*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 not resize GnuCash Preferences window

2023-06-25 Thread David Carlson
Do you have a friend or neighbor that could loan you a high resolution
monitor for a few hours?

On Sun, Jun 25, 2023, 2:09 PM Default User 
wrote:

> Hello!
>
> I am trying to set up GnuCash:
>
> Version: 4.13
> Build ID: 4.13+(2022-12-17)
> Finance::Quote: 1.54
>
> on Debian 12 (bookworm), 64-bit, using Gnome 43.4, wayland windowing
> system (not xorg).
>
> This is a .deb package, "GnuCash Version: 1:4.13-1, Built-Using:
> googletest (= 1.12.1-0.2)", from the Debian Stable repositories, NOT a
> flatpak, snap, or appimage.
>
> When I do Edit --> Preferences, the Preferences window opens, but the
> bottom part is cut off.  No matter what I try, I can am not able to
> resize it to fit the screen. Nor can I even move it past the top edge
> of the screen.  I even tried reducing the display resolution, to no
> avail.
>
> So, is there a solution, or even a viable workaround?
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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/gnucash] Release 5.2 - GnuCash 5.2 Released

2023-06-25 Thread Glenn Fowler
Hi John - thank you and the team for the 5.2 release! Just letting you know
on GitHub the windows build has gnucash-5.0.setup.exe

instead of 5.2


On Sun, Jun 25, 2023 at 2:42 PM John Ralls  wrote:

> GnuCash 5.2 Released 
>
> Repository: Gnucash/gnucash  · Tag:
> 5.2  · Commit: 4bba182
> 
> · Released by: jralls 
>
> The GnuCash development team announces GnuCash 5.2, the third release in
> the stable 5.x series
> Between 5.1 and 5.2, the following bugfixes were accomplished:
>
>- Bug 777472 - reconcile does not work if transaction selected
>
>
>Check that there's no outstanding activity in the current register
>page before starting a reconciliation. It is still possible to start
>modifying a transaction after the reconciliation window is open but this
>will stop the most common issue with the process. Starting a reconciliation
>from the account tree is left unprotected.
>- Bug 798564 - GnuCash is slow when there are a lot of open
>tabs/registers (37) 
>
>Lazily load registers as is already done with reports.
>- Bug 798597 - The word "Separators" needs two separate versions
>
>
>Use "Character-separated" when it's a choice between that and fixed
>field width and "Select Separator Character" when it's a heading.
>- Bug 798695 - Deleting everything from the "Transfer" cell after
>suggestions pop-up restricts search to the first 30 accounts
>
>
>Skip the search on an empty value and return all accounts in the combo
>box as it normally does if the account list is opened without searching for
>something.
>- Bug 798796 - Account list incomplete in report options
>
>
>Allow stock/fund accounts that are descendants of Bank accounts to be
>selected for the Advanced Portfolio, Investment Lots and Investment
>Portfolio reports.
>- Bug 798809 - Multicolumn report error when reopened after saving.
>
>- Bug 798839 - Edit -> Preferences string not translatable (reopened)
>
>- Bug 798862 - Merge identical strings (reopened)
>
>
>Ensure similar strings are identical and use double line view instead
>of double line mode.
>- Bug 798879 - RFE: [Transaction Report] add Running Total option
>
>- Bug 798885 - Accented character in folder name on Account Export
>(reopened) 
>- Bug 798899 - Gnucash crashes during CSV import when using a template
>if the destination account is changed from one used in the template
>
>- Bug 798901 - Wrong value for very small prices from Finance::Quote.
>
>- Bug 798916 - Exchange rates fetched from openexchange off by factor
>of 10 
>- Bug 798919 - Inconsistent signs in creating budget
>
>- Bug 798923 - OFX import is no longer matching security nor asking
>for stock account. 
>- Bug 798930 - invoices won't sequence to the next number
>
>- Bug 798948 - XML file corrupted by saving twice in extremely short
>period 
>- Bug 798952 - Unable to set day threshold or counters in properties.
>
>- Bug 798960 - Transaction completion horizontal scrolling opens
>without the new text being visible and remembers previous position/width
>
>- Bug 798966 - Uninitialised variable used in
>dialog-account-picker.c:dialog_response_cb()
>
>
> The following fixes and improvements were not associated with bug reports:
>
>- The type-ahead selection of transaction descriptions has been
>substantially overhauled based on extensive user feedback. Matches are now
>only on the beginning of words and are now sorted by age 

Re: [GNC] Standard Report - Equity Statement

2023-06-25 Thread NoobAlice

Hi Ismael,

"Equity Statement" as a report is the net of your total assets and 
liabilities, your personal equity.  You reach it via

Reports > Income and Expense > Equity Statement
The "Investments" are amounts that you add directly to 
personal-equity-type accounts.  So if I have an account named "Opening 
Balance" that on the Accounts page is Type: Equity, changes to that 
account show up on the Equity Statement report.


You probably want to use "Advanced Portfolio" from
Reports > Assets & Labilities > Advanced Portfolio
which will show you the stocks you own in companies and your investments 
in them.  These are Type: Stock on your Accounts page.  These stocks are 
your equity in these companies, but they are just a part of your 
personal equity.
* The total you have invested in each stock through the report date is 
shown in the "Money In" column.

* The total sales are the "Money Out" column.

To make an investment in a stock, money comes out of your checking 
account (an Asset) and goes into the stock (another Asset).  So your 
personal equity does not change at this time, and there is no change to 
the Equity Statement.  But the Advanced Portfolio will show the stock 
investment.


I hope I didn't over-explain anything, but I'm trying to make this clear 
for you and anyone else who has a similar question in the future and 
finds this mailing list post.


NoobAlice

On 2023-06-23 11:08 PM, Ismael via gnucash-user wrote:

Hello
I use V5.1 & Win11

My Standard Report - 'Equity Statement' does not show any amount for 
'Investments for Period'.

I am sure that I have made investments and recorded them in the respective 
Asset account (Stock).

Gnucash HELP is not really helpful for 10.3.5.2. Equity Statement.

Any idea what to do to see 'Investments for Period' in Standard Report - 
'Equity Statement'

Regards
Ismael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Writing off Stock - More an Accounting Question than a GnuCash one

2023-06-25 Thread David Cousens
Jeff,

The following treatments are generic from a basic accounting textbook and should
not be taken as accounting advice that is relevant to your specific
circumstances.

This is the direct write off method:
You  write it off as an expense to the COGS account i.e credit the
Asset:Inventory account and debit the Expense:COGS account. This would usually
be used if the write off amounts are small and irregular. (Using this method can
distort the gross margin where writeoffs are significant and is not recommended
for significant writeoffs

You can also create an Expense:WriteOffs account rather than using COGS if the
amount of the write offs is significant and needs to appear as a line item in
your reports. 

In the allowance method, rather than crediting the inventory account directly
you set up a contra sub account of the Asset :Inventory account usually named
something like Asset:Inventory:InventoryReserve and credit that and again debit
the expense account. This is the usual method where the inventory may have lost
value but isn't being disposed of immediately. 

At actual disposal of the asset the Reserve account is debited and the Inventory
account is credited.

If the value of inventory falls below its cost, it is usually written down
rather than written off and a separate expense account Expense:Write Downs is
used instead of the Expense:Write Offs account.

David Cousens





On Sun, 2023-06-25 at 15:42 +1000, Jeff wrote:
> Hi List,
> 
> This is more a general accounting question than specifically a GnuCash 
> one, but thought there might be better help on the list for it.
> 
> Background:
> I use GnuCash for business use, and track the purchase of inventory.
> This goes into an Inventory Account
> When sold, the sale gets recorded against the Income Sales, and the cost 
> of the goods gets recorded in COG's.
> 
> Issue:
> I have some stock that is either obsolete, or otherwise no longer fit 
> for sale.  Just wondering what is the "correct" way to write this stock 
> off. (In case it matters, I am located in Australia).
> My thoughts were:
> - Have an Account called Write-offs to record the transfer of the dollar 
> amount from Inventory to Write-Offs.
> - Also, record the cost of goods in the COG's account, just like it was 
> sold.  This is the main bit I am unsure of.
> 
> Any other suggestions, or am I looking at this completely wrong?
> 
> Regards,
> Jeff,
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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] Can not resize GnuCash Preferences window

2023-06-25 Thread Default User
Hello!

I am trying to set up GnuCash:

Version: 4.13
Build ID: 4.13+(2022-12-17)
Finance::Quote: 1.54

on Debian 12 (bookworm), 64-bit, using Gnome 43.4, wayland windowing
system (not xorg).  

This is a .deb package, "GnuCash Version: 1:4.13-1, Built-Using:
googletest (= 1.12.1-0.2)", from the Debian Stable repositories, NOT a
flatpak, snap, or appimage.

When I do Edit --> Preferences, the Preferences window opens, but the
bottom part is cut off.  No matter what I try, I can am not able to
resize it to fit the screen. Nor can I even move it past the top edge
of the screen.  I even tried reducing the display resolution, to no
avail. 

So, is there a solution, or even a viable workaround?




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Writing off Stock - More an Accounting Question than a GnuCash one

2023-06-25 Thread Michael or Penny Novack

On 6/25/2023 1:42 AM, Jeff wrote:

Hi List,

This is more a general accounting question than specifically a GnuCash 
one, but thought there might be better help on the list for it.






Issue:
I have some stock that is either obsolete, or otherwise no longer fit 
for sale.  Just wondering what is the "correct" way to write this 
stock off. (In case it matters, I am located in Australia).

My thoughts were:
- Have an Account called Write-offs to record the transfer of the 
dollar amount from Inventory to Write-Offs.
- Also, record the cost of goods in the COG's account, just like it 
was sold.  This is the main bit I am unsure of.


Any other suggestions, or am I looking at this completely wrong? 


Right it is a general accounting question, not a gnucash question. I 
suggest a standard 101 text for Australia to find out what expense 
account to charge. NOT likely going to be "cost of goods sold". Might be 
something like "inventory obsolete, lost, stolen, damaged, etc." << you 
need to consider far more possibilities than becoming valueless because 
obsolete >>


Michael FD Novack

PS -- I am not "qualified" to give accounting advice here let alone for 
Australia



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Maintain two accounts in same machine

2023-06-25 Thread Michael or Penny Novack



However, all the customised 'reports' are saved in one place if a single user.
Giving each customised report a clear name will help here.

Liz


IF A SINGLE USER  (from the point of view of the machine).

If desired, a single human can be more than one user as far as the 
machine is concerned. Back in my working days I had TWO logins to the 
mainframe. The normal one (development) and a second one (production) 
for use in emergencies when I didn't have a production team person on 
hand to tell to submit this or that job for me << one that required 
"production" permissions >>


LOL -- because I am used to working with this level of security pour 
home machines are set up that way too. As I am writing this my log in 
would not allow me to install software << like a modern linux with an 
"su" command, would prompt me to enter the "administrator" password >> 
Of course for a planned "build" I would have logged in as administrator 
from the start.


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.


Re: [GNC] ANNOUNCE: GnuCash 5.2 Released

2023-06-25 Thread Stan Brown
On 2023-06-25 11:40, John Ralls wrote:
>   • The type-ahead selection of transaction descriptions has been 
> substantially overhauled based on extensive user feedback. Matches are now 
> only on the beginning of words and are now sorted by age since last use. This 
> both substantially reduces the number of matches and prioritizes the most 
> recently used as being the most likely candidates for re-use. To help 
> distinguish cases of long descriptions where the match would be outside the 
> popup's viewport the viewport is automatically scrolled horizontally so that 
> the end of the left-most (right-most in rtl languages) matches is centered in 
> the view. Completion can be aborted with the  key or a new Don't 
> autocomplete selection that's the first entry in the popup.

Thanks as always for the fixes, John. The above looks like it was a lot
of work, but I think it will greatly improve the usability of GC 5.

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.


[GNC] ANNOUNCE: GnuCash 5.2 Released

2023-06-25 Thread John Ralls
The GnuCash development team announces GnuCash 5.2, the third release in the 
stable 5.x series

Between 5.1 and 5.2, the following bugfixes were accomplished:

• Bug 777472 - reconcile does not work if transaction selected
Check that there's no outstanding activity in the current register page before 
starting a reconciliation. It is still possible to start modifying a 
transaction after the reconciliation window is open but this will stop the most 
common issue with the process. Starting a reconciliation from the account tree 
is left unprotected.

• Bug 798564 - GnuCash is slow when there are a lot of open 
tabs/registers (37)
Lazily load registers as is already done with reports.

• Bug 798597 - The word "Separators" needs two separate versions
Use "Character-separated" when it's a choice between that and fixed field width 
and "Select Separator Character" when it's a heading.

• Bug 798695 - Deleting everything from the "Transfer" cell after 
suggestions pop-up restricts search to the first 30 accounts
Skip the search on an empty value and return all accounts in the combo box as 
it normally does if the account list is opened without searching for something.

• Bug 798796 - Account list incomplete in report options
Allow stock/fund accounts that are descendants of Bank accounts to be selected 
for the Advanced Portfolio, Investment Lots and Investment Portfolio reports.

• Bug 798809 - Multicolumn report error when reopened after saving.
• Bug 798839 - Edit -> Preferences string not translatable (reopened)
• Bug 798862 - Merge identical strings (reopened)
Ensure similar strings are identical and use double line view instead of double 
line mode.

• Bug 798879 - RFE: [Transaction Report] add Running Total option
• Bug 798885 - Accented character in folder name on Account Export 
(reopened)
• Bug 798899 - Gnucash crashes during CSV import when using a template 
if the destination account is changed from one used in the template
• Bug 798901 - Wrong value for very small prices from Finance::Quote.
• Bug 798916 - Exchange rates fetched from openexchange off by factor 
of 10
• Bug 798919 - Inconsistent signs in creating budget
• Bug 798923 - OFX import is no longer matching security nor asking for 
stock account.
• Bug 798930 - invoices won't sequence to the next number
• Bug 798948 - XML file corrupted by saving twice in extremely short 
period
• Bug 798952 - Unable to set day threshold or counters in properties.
• Bug 798960 - Transaction completion horizontal scrolling opens 
without the new text being visible and remembers previous position/width
• Bug 798966 - Uninitialised variable used in 
dialog-account-picker.c:dialog_response_cb()
The following fixes and improvements were not associated with bug reports:

• The type-ahead selection of transaction descriptions has been 
substantially overhauled based on extensive user feedback. Matches are now only 
on the beginning of words and are now sorted by age since last use. This both 
substantially reduces the number of matches and prioritizes the most recently 
used as being the most likely candidates for re-use. To help distinguish cases 
of long descriptions where the match would be outside the popup's viewport the 
viewport is automatically scrolled horizontally so that the end of the 
left-most (right-most in rtl languages) matches is centered in the view. 
Completion can be aborted with the  key or a new Don't autocomplete 
selection that's the first entry in the popup.
• Fix lockup on Windows in type-ahead selection of transaction 
descriptions.
• More budget-module sign fixes and improvements.
• Lots of memory-leak fixes, GLib modernization, and code cleanup by 
Richard Cohen, Simon Arlott, & Chris Lam.
• bugfix xaccTransGetTxnType: avoid returning TXN_TYPE_LINK 
incorrectly: A TXN_TYPE_PAYMENT will have non-APAR splits; a TXN_TYPE_LINK will 
not have non-APAR splits. This bug manifests as a regular TXN_TYPE_PAYMENT 
transaction being later voided being incorrectly changed to TXN_TYPE_LINK.
• Including brokerage fees in Money Out calculation (if not ignoring 
them) in advanced-portfolio.scm report and updating the "advanced" tests to 
reflect selling fees being included into the money out value
• [stock-txn-asst] Don't use the initial value in amount edit widgets 
unless they're valid. Otherwise the invalid value will log an error that will 
prevent later valid input from working.
• BUGFIX: Actions > Online Actions > Show log Window does not open when 
it is first clicked.
• cmake: check gdk only when building GUI
• Get the tooltip working on "Online Banking Setup"
New and Updated Translations: Chinese (Simplified), Chinese (Traditional), 
Croatian, English (Australia), English (New Zealand), English (United 

Re: [GNC] Reversing a finished credit card reconciliation

2023-06-25 Thread Maf. King
On Sunday, 25 June 2023 14:52:50 BST David T. wrote:
> Both previous replies were on target-- but, I do wonder how you finished the
> first reconciliation, since GnuCash won't activate the finish button until
> the Difference value is zero. If the transaction was wrong, the balance
> would be non-zero?
> 

.. Just a suggestion,  ISTR that the "ending balance" is auto-filled to a 
calculated balance at date.

If the txns are wrong, so will the "suggested" end balance.  If the step 
Gregory OP missed was to correctly set the end balance, _I Think_ the 
reconcile would permit a finish to a bogus total.

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


Re: [GNC] Reversing a finished credit card reconciliation

2023-06-25 Thread David Carlson
David T., et alia,

Somewhere in the nether regions of my pea brain I have a recollection of a
'feature' to automatically add an adjustment transaction to bring a
reconciliation into balance without  finding the 'error'.

That was probably in one of the other programs that I used before I started
using Gnucash, but it might be a feature that some GnuCash users might want.

Of course this brings a risk that GnuCash might erroneously reconcile a few
transactions that were correctly unposted by the financial institution,
possibly because they were simply normal 'float' that is not cleared as of
the statement date,  but a savvy user could identify those transactions
during the reconciliation.

I think this idea 'floated' to the surface because at this moment I just
happened to be halfway through reconciling a very troublesome statement
from a credit card company that often fails to post transactions in a
timely manner and commits other fiscal sins that cause normal accountants
to tear their hair out.



On Sun, Jun 25, 2023 at 8:54 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Both previous replies were on target-- but, I do wonder how you finished
> the first reconciliation, since GnuCash won't activate the finish button
> until the Difference value is zero. If the transaction was wrong, the
> balance would be non-zero?
>
> ⁣David T. ​
>
> On Jun 25, 2023, 12:26 PM, at 12:26 PM, "Maf. King" 
> wrote:
> >Hi Gregory,
> >
> >welcome to the list and Gnucash.
> >
> >
> >Just ignore that the starting balance is wrong, go through the
> >reconcilliation
> >as normal aiming for the correct ending balance.
> >
> >should sort itself out.
> >HTH,
> >Maf
> >
> >
> >On Thursday, 22 June 2023 01:08:01 BST Gregory Donavon wrote:
> >>  I hope you can help me unwind an error I made after not following
> >one of
> >> the steps in a busybee post video on youtube: I transposed a couple
> >of
> >> numbers on one transaction, this resulted in there being a difference
> >of a
> >> few dollars. Rather than hitting "postpone," I hit "finished" with
> >the plan
> >> of coming back later to figure out the location of the error. When I
> >> changed the transposed entry to the correct amount, that didn't
> >correct the
> >> problem because when I went back in to reconcile , the starting
> >balance was
> >> wrong and I could not change it or bring up the original
> >reconciliation
> >> page. Is there anything I can do - this is my first month using
> >gnucash.
> >> Any suggestions you have for reversing the transactions would be
> >> appreciated.
> >>
> >> Thanks for your help,
> >> Gregory Donavon
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/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.
>


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


Re: [GNC] Reversing a finished credit card reconciliation

2023-06-25 Thread David T. via gnucash-user
Both previous replies were on target-- but, I do wonder how you finished the 
first reconciliation, since GnuCash won't activate the finish button until the 
Difference value is zero. If the transaction was wrong, the balance would be 
non-zero?

⁣David T. ​

On Jun 25, 2023, 12:26 PM, at 12:26 PM, "Maf. King"  wrote:
>Hi Gregory,
>
>welcome to the list and Gnucash.
>
>
>Just ignore that the starting balance is wrong, go through the
>reconcilliation 
>as normal aiming for the correct ending balance.
>
>should sort itself out.
>HTH,
>Maf
>
>
>On Thursday, 22 June 2023 01:08:01 BST Gregory Donavon wrote:
>>  I hope you can help me unwind an error I made after not following
>one of
>> the steps in a busybee post video on youtube: I transposed a couple
>of
>> numbers on one transaction, this resulted in there being a difference
>of a
>> few dollars. Rather than hitting "postpone," I hit "finished" with
>the plan
>> of coming back later to figure out the location of the error. When I
>> changed the transposed entry to the correct amount, that didn't
>correct the
>> problem because when I went back in to reconcile , the starting
>balance was
>> wrong and I could not change it or bring up the original
>reconciliation
>> page. Is there anything I can do - this is my first month using
>gnucash.
>> Any suggestions you have for reversing the transactions would be
>> appreciated.
>> 
>> Thanks for your help,
>> Gregory Donavon
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/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] Reversing a finished credit card reconciliation

2023-06-25 Thread Maf. King
Hi Gregory,

welcome to the list and Gnucash.


Just ignore that the starting balance is wrong, go through the reconcilliation 
as normal aiming for the correct ending balance.

should sort itself out.
HTH,
Maf


On Thursday, 22 June 2023 01:08:01 BST Gregory Donavon wrote:
>  I hope you can help me unwind an error I made after not following one of
> the steps in a busybee post video on youtube: I transposed a couple of
> numbers on one transaction, this resulted in there being a difference of a
> few dollars. Rather than hitting "postpone," I hit "finished" with the plan
> of coming back later to figure out the location of the error. When I
> changed the transposed entry to the correct amount, that didn't correct the
> problem because when I went back in to reconcile , the starting balance was
> wrong and I could not change it or bring up the original reconciliation
> page. Is there anything I can do - this is my first month using gnucash.
> Any suggestions you have for reversing the transactions would be
> appreciated.
> 
> Thanks for your help,
> Gregory Donavon
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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.