[GNC] Printing addresses on checks

[Sherman Yoder]

   Hello,

   I've started using GnuCash recently. I like the program, and would like
   to use it in my small business.

   I have not found how to save a vendor's address so it prints on a check
   without first creating a bill and then "paying" that bill. That does
   indeed work, though a bit of an inconvenience, but then the splits will
   not print on the check stubs--only the accounts payable account will
   print there.

   I need the splits to print on the checks, so I have been printing
   directly from the account register. But then I have to type the address
   into the print form every time I print a check.

   Is there a way to use the recorded address AND have the splits print on
   the check stubs?

   Thanks for your help!

   Sherman
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Why I like the way GnuCash determines column widths!

[David Carlson]

It took me several years to figure this out, but I finally understand why
it is designed as it is.

It turns out to be a trivial procedure to initially set register views up
to show a reasonable portion of text in nearly all the columns except the
'big' one, ie Description or Memo or Notes.  Then it also is easy to just
grab the column divider in the title bar on the right of that column when I
want to see more of it, move it to the right temporarily, and then slide it
back when I am done working in that column.  All the other columns can
remain as is.

This method, since I discovered it, has made it much easier to  work with
GnuCash on a monitor that isn't wide enough to completely show every column.

-- 
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] Seaking feedback on (potential) "Running Total" feature for transaction report

[Vincent Dawans]

Not directly but now that I have spent time understanding how the
transaction report code works, I was able to make a basic proof of concept
for that as well.
See https://github.com/Gnucash/gnucash/pull/1623 for more details. One can
try it by replacing the trep-engine.scm with the version in that new PR
(not to be confused with the one for the running totals).
The full file can be found here
https://github.com/dawansv/gnucash/blob/analytical-report/gnucash/report/trep-engine.scm

Sincerely,

Vincent Dawans


On Thu, Apr 27, 2023 at 4:58 PM flywire  wrote:

> Does this offer an opportunity to achieve the long-requested
> classification/category/dimension report:
> https://bugs.gnucash.org/show_bug.cgi?id=113772#c6 ? I'm thinking of
> grouping by the first tag in the memo split with the last group being
> untagged splits.
>
> Regards
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Any performance improvement in GnuCash 5.x?

[Lipp F.]

I am wondering if users can comment on performance for GnuCash 5.x. I
remember reading that  GnuCash 5.x is supposed to use proper SQL to query
the records and not load the entire history of records in memory on startup.

For the record, I am using pretty new hardware, sqlite database with about
20 years of transactions and GnuCash is not responsive at all. Takes like
tens of seconds for an action to happen after clicking a menu item.

TIA.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Changes to transaction entry, and quirks

[David T. via gnucash-user]

Hello, 

I am not sure exactly what changes have been implemented in the transaction 
entry logic, but I've begun seeing GnuCash offer me ancient transactions as 
templates for current data entry. So, instead of giving me a recent 
transaction, I end up with a transaction from 12 years ago. 

From the prompt, it's not possible to know that this is happening before 
accepting the suggestion; once accepted, I have to cancel the transaction and 
start over-- if I notice that the transaction is wrong! Moreover, since almost 
everything in my financial world has changed during my use of GnuCash, I am 
finding that I accidentally put transactions into unplanned and inappropriate 
accounts. This is even more troubling since I've found that GnuCash will add 
these transactions despite the destination accounts being placeholder accounts. 

I am pretty sure that this didn't happen in earlier versions, but I'm known to 
be wrong more often than not. 

Short of splitting my file apart (which I'm loath to do), is there any way to 
alter the suggestion list so that it doesn't offer me outdated transactions? 
Can I delete entries from the list? Can I tell it not to use transactions that 
involve placeholder accounts? 

And on a related note, I've found that the suggester does not always respect 
different character strings, and will conflate different strings into one 
transaction. What I mean is this: I previously entered a transaction with the 
description "Payment- Credit Card" (note the spacing with the hyphen).  This 
transaction transferred money to an account that is now a placeholder account. 
I now prefer "Payment - Credit Card" (again, note the spacing with the hyphen). 
When I type "Payment -" with the preceding space, I *should* get the new 
version of the transaction (and that is what displays in the prompt)-- but when 
I tab out of the field, the *old* transaction gets inserted instead of the new. 
I don't understand how this happens, but it has happened numerous times for me. 

⁣David T. ​
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 in Placeholder

[David T. via gnucash-user]

I'm going to follow up my own message to note that I have now found that 
GnuCash 4.13 under Windows 10 will add transactions to a placeholder account 
even while displaying a message stating that it cannot write transactions to 
placeholder accounts! 

I've just had GnuCash do this twice, when it used an ancient transaction as a 
template (I'll write about that in a different thread shortly) that has an 
account that I have since set as a placeholder account and hidden because it is 
closed. 

Something is clearly broken here.

⁣David T. ​

On Apr 29, 2023, 9:44 PM, at 9:44 PM, "David T. via gnucash-user" 
 wrote:
>Michael, 
>
>The OP problem had to do with the importer adding transactions to a
>placeholder account. So that's why I am discussing that, rather than
>bringing up the creation of new accounts in the process. I'm not even
>sure how that applies here; a newly-created account during the import
>process (if such is even achievable in the import process) would
>presumably not be set as a placeholder account. 
>
>GnuCash already prevents a user from entering transactions into a
>placeholder account-- and even prevents you from opening such accounts
>without an explicit (non standard) open mode. The only way I know of
>entering transactions into a placeholder account is to turn off the
>setting first. Of course, then, it's not a placeholder account...
>
>Again, in my example, you're missing the point. I'm not talking about
>the special case where a user has elevated rights and logs in specially
>to use them. I'm talking about a system allowing any user to change any
>file-- or worse, a system changing them as a result of some other
>action I took. If I, as a regular user, were to overwrite YOUR files,
>you'd be rather upset.
>
>I'll repeat: adding transactions to a placeholder account during an
>import should not be possible, since it violates the GnuCash definition
>of a placeholder account. 
>
>⁣David T. ​
>
>On Apr 29, 2023, 6:17 PM, at 6:17 PM, Michael or Penny Novack
> wrote:
>>On 4/29/2023 10:08 AM, David T. wrote:
>>> Michael,
>>>
>>> I disagree. The importer shouldn't put transacting into an account 
>>> that is--by definition-- write protected.
>>>
>>> My counter example would be a write-protected file folder. An 
>>> operating system that allowed a user to put data into a 
>>> write-protected folder would come in for serious criticism.
>>>
>>> Temporary records should go somewhere, for sure. It's been my 
>>> experience that GnuCash uses Imbalance-xxx for such transactions.
>Why
>>
>>> would you ever expect to put them in write-protected accounts?
>>>
>>You are talking about the  behavior of the IMPORTER.
>>
>>Your proposed solution would affect ANY entry of transactions.
>>
>>And an operating system SHOULD allow writing into a write protected 
>>folder whenever the person (or program) doing so has sufficient
>>"rights" 
>><< normally when I am logged in it is WITHOUT admin rights (even on my
>
>>home system) -- bear in mind decades in the cypher mines where I had
>to
>>
>>be very conscious of whether I was using my ordinary login or my
>>"prod*" 
>>log in. Like in the middle of the night emergency fix to a hanging 
>>production program -- doing this during the day I would walk over to
>>the 
>>desk of whoever normally handled "builds" and have them do the 
>>replacement of the program in the production library>>
>>
>>Michael
>>
>>PS --- By all means ask for a change to the behavior of the importer
>if
>>
>>you think that is in order. But actually what you want is that the 
>>importer verify that it isn't specifying an account that does not
>exist
>>
>>OR one that is a placeholder. We used to call something like the the 
>>"input editor" portion of a transaction handling program.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/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 5 - import transactions

[Geert Janssens]

That's good to hear! Thanks for the feedback.

Regards,

Geert

Op maandag 1 mei 2023 10:44:27 CEST schreef Christian Lynbech:
> I can confirm that automatching on import now has started to work again,
> in 5.1.
> 
>/Christian
> 
> 
> ---
> On Thu, Apr 27 2023, Geert Janssens wrote:
> 
> Ok, so the aqbanking log entries were just noise.
> 
> I have further experimented with your samples and that helped me to pinpoint
> the issue. It's effectively a regression that was introduced while
> improving the import of multi-currency data.
> 
> It should be fixed now, in either tomorrow's nightly Windows or Flatpak
> builds and the upcoming 5.1 release.
> 
> Regards,
> 
> Geert
> 
> Op woensdag 26 april 2023 18:29:25 CEST schreef Christian Lynbech:
> > Sure.
> > 
> > 
> > 
> > I am not using AqBanking, my problem is with CSV import. I did notice
> > 
> > those errors/warnings in the log but I could not immediately find
> > 
> > anywhere to turn aQbanking off. I know I had tried at one point to
> > 
> > experiment to see if my bank somehow showed up, it didn't, and I have
> > 
> > never used it for anything. It is of course possible something lingers
> > 
> > from that.
> > 
> > Attached are three files:
> >   test.gnucash - a very simple book (based on the simple check book
> > 
> > template)
> > 
> >   abc.csv - two transactions (already imported into test.gnucash)
> >   
> >   
> >   
> >   def.csv - two more transactions (not yet imported)
> > 
> > def.csv is formed from abc.csv, just with dates and amounts modified
> > 
> > such that gnucash would not think they can reconciled. It is therefore
> > 
> > otherwise the very same transactions and I would expect matching to
> > 
> > occur.
> > 
> > 
> > 
> > As abc.csv has been imported, test.gnucash contains the import settings
> > 
> > (named "test") that I am using.
> > 
> >/Christian
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] surprising glob() result on Windows

[Stan Brown]

My apologies -- this was intended for a different mailing list.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2023-05-01 05:46, Stan Brown wrote:
> On 2023-04-30 20:58, Enan Ajmain wrote:
>> On Sat, 29 Apr 2023 12:37:19 -0700
>> Stan Brown  wrote:
>>> Some time after that, I'm not sure when but certainly by the release of
>>> Windows 10, it became possible to disable SFNs for any particular disk
>>> partition. And sometime after that, "LFNs only" became the default. But
>>> your disk is obviously set to create SFNs from longer filenames.
>>
>> I donno if something changed in Windows 11, but it doesn't seem like
>> "LFN only" is the default anymore.  I didn't change any setting (didnt
>> even know about them) and I get the same behavior Mike describes.  It's
>> just that I never had multiple files where one's extension is a
>> substring of the other's, so I havent faced this issue.
> 
> On my Windows 10 Pro system, my boot partition "C:" had SFNs and LFNs,
> but the new partitions I created on the same physical drive had LFNs
> only. I don't know if it would have been the same on Windows 10 Home, or
> on Windows 11 Home and Pro. In any case, SFNs seem to be enabled on the
> partition where the OP is running.
> 
> 
> explains how to enable or disable SFNs on a partition. There are
> warnings about not disabling SFNs on a partition that already has them.
> 
> 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.

Re: [GNC] surprising glob() result on Windows

[Stan Brown]

On 2023-04-30 20:58, Enan Ajmain wrote:
> On Sat, 29 Apr 2023 12:37:19 -0700
> Stan Brown  wrote:
>> Some time after that, I'm not sure when but certainly by the release of
>> Windows 10, it became possible to disable SFNs for any particular disk
>> partition. And sometime after that, "LFNs only" became the default. But
>> your disk is obviously set to create SFNs from longer filenames.
> 
> I donno if something changed in Windows 11, but it doesn't seem like
> "LFN only" is the default anymore.  I didn't change any setting (didnt
> even know about them) and I get the same behavior Mike describes.  It's
> just that I never had multiple files where one's extension is a
> substring of the other's, so I havent faced this issue.

On my Windows 10 Pro system, my boot partition "C:" had SFNs and LFNs,
but the new partitions I created on the same physical drive had LFNs
only. I don't know if it would have been the same on Windows 10 Home, or
on Windows 11 Home and Pro. In any case, SFNs seem to be enabled on the
partition where the OP is running.


explains how to enable or disable SFNs on a partition. There are
warnings about not disabling SFNs on a partition that already has them.

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.

Re: [GNC] Turn of drop list when entering data in memo/description line

[Brad Morrison]

Hi Trevor,

What Linux distro & version # are you using? While I am assuming that 
you are updating/upgrading Gnucash via your Linux distro's package 
manager, are you using the flatpak/flathub version of Gnucash or the 
direct package?


I am using Linux Mint 20.3 (https://linuxmint.com/ with the most current 
version being 21.1) and the versions of Gnucash in the LM 20.3 software 
manager are "Version: 3.8, Build ID: 3.8b+(2019-12-29), Finance::Quote: 
1.49" for the direct package and "4.10+" for the Flathub/Flatpak version.


Brad


On 4/29/23 03:14, Trevor Dempsey via gnucash-user wrote:

Greetings,

I just upgraded to version 5.0 and I would like to know how to turn 
OFF the drop list when entering a description in the memo line.


I can only enter 3 letters before it seizes up and I must cancel my 
entry to continue. To enter new data into this memo line, I must first 
write it in a text file and then copy/paste it onto the line.


I would roll back this upgrade if I could but the version of linux I 
am using does not allow that.


Any help would be appreciated because at the moment Gnucash is unusable.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Atualização GnuCash versão 5.0

[Brad Morrison]

Hi Eduardo,

It looks like your message is in Portugese (Brazilian) according to the 
DuckDuckGo online translator that I copied & pasted your text into. Here 
is the list of the various GnuCash user mailing lists 
(https://lists.gnucash.org/mailman/listinfo) and the second one from the 
top, Gnucash-br (https://lists.gnucash.org/mailman/listinfo/gnucash-br), 
seems to be specifically for "brasileiros."


Good luck!

Brad


What Eduardo wrote in English (according to DuckDuckGo's translator): 
"Good morning. It normally used GnuCash until version 4.13, performing 
transaction imports." CSV", multisplit, linking the columns normally 
(DATE, DESCRIPTION, NUMBER, ACTION, DEBIT, ACCOUNT, COMMENT and NOTES). 
In this update, 5.0, I noticed several changes in the import format, 
with the replacement of the previously available CREDIT and DEBIT 
fields, intended for value information, by the fields AMOUNT, AMOUNT, 
AMOUNT(NEGAITVO), VALUE, VALUE(NEGATIVE), PRICE I've tried to change the 
". CSV" in various ways, including one column for positive values and 
another for negative values (this one with values "+" and "-"), but it 
always results in the msg "select a column of VALUE(NEGATIVE), and does 
not progress on import. Could someone provide a relationship table of 
the fields for correct formatting of ". CSV" in this new version? Thank 
you very much for the help Best regards Eduardo Key Matsudo"



What I wrote above in Portugese (according to DuckDuckGo's translator): 
"Oi Eduardo, Parece que sua mensagem está em português (brasileiro) de 
acordo com o tradutor online DuckDuckGo que eu copiei e colei seu texto. 
Aqui está a lista das várias listas de discussão de usuários do GnuCash 
(https://lists.gnucash.org/mailman/listinfo) e a segunda do topo, 
Gnucash-br (https://lists.gnucash.org/mailman/listinfo/gnucash-br), 
parece ser especificamente para "brasileiros". Boa sorte! Brad"



On 4/29/23 04:34, eduardo key matsudo wrote:

Bom dia.

Utilizava normalmente o GnuCash até a versão 4.13, realizando importações de transações 
".CSV", multisplit, vinculando as colunas normalmente (DATA, DESCRIÇÃO, NÚMERO, 
AÇÃO, DÉBITO, CONTA, COMENTÁRIO e NOTAS).
Nesta atualização, 5.0, notei várias alterações no formato da importação, com a 
substituição dos campos CRÉDITO e DÉBITO anteriormente disponíveis, destinados 
à informação do valor, pelos campos QUANTIA, MONTANTE, MONTANTE(NEGAITVO), 
VALOR, VALOR(NEGATIVO), PREÇO
Já tentei alterar o ".CSV" de várias formas, incluindo uma coluna para valores positivos e outra para 
negativos (esta com valores "+" e "-"), mas sempre resulta na msg "selecione uma coluna 
de VALOR(NEGATIVO), e não progride na importação.
Alguém poderia fornecer uma tabela de relacionamento dos campos para correta formatação 
do ".CSV" nesta nova versão?

Agradeço muito pela ajuda

Atenciosamente,

Eduardo Key Matsudo
(11) 967023407

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Turn of drop list when entering data in memo/description line

[Trevor Dempsey via gnucash-user]

Greetings,

I just upgraded to version 5.0 and I would like to know how to turn OFF 
the drop list when entering a description in the memo line.


I can only enter 3 letters before it seizes up and I must cancel my 
entry to continue. To enter new data into this memo line, I must first 
write it in a text file and then copy/paste it onto the line.


I would roll back this upgrade if I could but the version of linux I am 
using does not allow that.


Any help would be appreciated because at the moment Gnucash is unusable.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Atualização GnuCash versão 5.0

[eduardo key matsudo]

Bom dia.

Utilizava normalmente o GnuCash até a versão 4.13, realizando importações de 
transações ".CSV", multisplit, vinculando as colunas normalmente (DATA, 
DESCRIÇÃO, NÚMERO, AÇÃO, DÉBITO, CONTA, COMENTÁRIO e NOTAS).
Nesta atualização, 5.0, notei várias alterações no formato da importação, com a 
substituição dos campos CRÉDITO e DÉBITO anteriormente disponíveis, destinados 
à informação do valor, pelos campos QUANTIA, MONTANTE, MONTANTE(NEGAITVO), 
VALOR, VALOR(NEGATIVO), PREÇO
Já tentei alterar o ".CSV" de várias formas, incluindo uma coluna para valores 
positivos e outra para negativos (esta com valores "+" e "-"), mas sempre 
resulta na msg "selecione uma coluna de VALOR(NEGATIVO), e não progride na 
importação.
Alguém poderia fornecer uma tabela de relacionamento dos campos para correta 
formatação do ".CSV" nesta nova versão?

Agradeço muito pela ajuda

Atenciosamente,

Eduardo Key Matsudo
(11) 967023407

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

[Christian Lynbech]

I can confirm that automatching on import now has started to work again,
in 5.1.

   /Christian


---
On Thu, Apr 27 2023, Geert Janssens wrote:

Ok, so the aqbanking log entries were just noise.

I have further experimented with your samples and that helped me to pinpoint 
the issue. It's
effectively a regression that was introduced while improving the import of 
multi-currency data.

It should be fixed now, in either tomorrow's nightly Windows or Flatpak builds 
and the upcoming 5.1
release.

Regards,

Geert

Op woensdag 26 april 2023 18:29:25 CEST schreef Christian Lynbech:

> Sure.

> 

> I am not using AqBanking, my problem is with CSV import. I did notice

> those errors/warnings in the log but I could not immediately find

> anywhere to turn aQbanking off. I know I had tried at one point to

> experiment to see if my bank somehow showed up, it didn't, and I have

> never used it for anything. It is of course possible something lingers

> from that.

> 

> Attached are three files:

> 

>   test.gnucash - a very simple book (based on the simple check book

> template)

> 

>   abc.csv - two transactions (already imported into test.gnucash)

> 

>   def.csv - two more transactions (not yet imported)

> 

> def.csv is formed from abc.csv, just with dates and amounts modified

> such that gnucash would not think they can reconciled. It is therefore

> otherwise the very same transactions and I would expect matching to

> occur.

> 

> As abc.csv has been imported, test.gnucash contains the import settings

> (named "test") that I am using.

> 

> 

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