Re: [GNC] Accounts Payable payment entry is marked as an Invoice

[Derek Atkins]

Hi,

On Mon, November 22, 2021 10:43 pm, D. via gnucash-user wrote:
> Seems to me a bad design decision to allow a user to have UI access to
> change things one way, but not the other. It is also bad user design to
> allow users to change things in an account that will always break when the
> user changes anything, something that's been true for as long as I've used
> gnucash.

The issue is that there are real valid reasons to ensure a user can still
modify the AR/AP accounts (specifically, there are reasons to allow them
to delete Payment and, more importantly, INTER-LOT transactions (the
latter being solely between lots within AR/AP, so they don't exist outside
AR/AP).

This means you can't just make the account a placeholder, because there
are valid reasons to be able to "edit" the account.

Cross that with the lack of a display-only cell type.  There is data we
want to show (I/P/?) but really don't want to allow the user to edit it --
but there's not a data cell that *does* that.

At the time, when I implemented this nearly 20 years ago, I decided to
just go with the same cell used for the reconcile flag because it was the
*closest* to what I wanted. You cannot tab into the cell.  It only changes
if you *mouse-click* in the cell.  So the chance of someone accidentally
doing so was (and I maintain still is) relatively low.

The "real" fix would be to create a new, read-only label cell that could
be used.

I suppose another way to fix it would be to change the logic of when a
transaction is read-only, but I am sure I had reasons for doing it the way
I did -- I just don't recall them all right now.

> It would be better to make the account a placeholder account by default,
> and rewrite the business logic to push the changes into the account
> despite the placeholder setting, but I imagine that's a lot of work, and
> the people who know how to do the work will explain why my ideas are no
> good.

See above for why this is a bad idea.  I tried it (making the whole
register read-only) and it made more problems than it solved.

> David

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

[Geert Janssens]

Op dinsdag 23 november 2021 14:27:49 CET schreef Derek Atkins:
> Cross that with the lack of a display-only cell type.  There is data we
> want to show (I/P/?) but really don't want to allow the user to edit it --
> but there's not a data cell that *does* that.
> 
Probably we're closer to that cell type these days. Bob Fewell created a new 
cell type a 
while ago to indicate whether a transaction has a file association or not. This 
cell can't be 
edited directly. It gets its first content by clicking on a menu. Once set, you 
can click on the 
field to run a default action.

I think this cell type can probably mostly be reused for the I/P/? field. If 
the cell is used 
without a default clickable action set, clicking won't do anything and you 
couldn't change 
the cell directly in any way.

Regards,

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Data load from CSV files - duplicates

[Kalpesh Patel]

Work flow using  two pass for the CSV importer (for that fact any importer)
yields better result for me as well, generally speaking. This is probably
best way to handle double-entry accounting. In the first pass I import new
or update existing transactions into register for one side of the transfers
and then run it again for the other side of the transaction. During second
run, in the 'Match Transactions' windows I adjust the import of the
transaction from either 'A' or 'C' column in the window to 'U+C' column -
this can be toggled in that 'Match Transactions' window freely for any
transaction - and you won't have to do anything with the first pass
transactions as they all will all be matched correctly in the second pass so
only ones that will be in play are the transfers transactions only needing
review.

 

By clicking the 'Show Account column' and 'Show matched information' at the
bottom of the 'Match Transactions' window before importing any transaction,
you will get very good idea how the import will be done for that
transaction. Not sure if that settings to Show Account column and Show
matched information can be made sticky settings or not, though.

 

Only drawback with this two pass workflow is that 'Description' of
transaction in required to import CSV and it will be set to the one that was
last imported one when you select 'U+C'. I would love to see a setting to
use single column for multiple fields during import or better yet make
Description requirements optional which would give me method to cross link
transactions using my generic description and then allowing financial
institution specific details in the memo field for both side of the
transaction. But I imagine that this will complicated matcher mechanism so
it is reasonable that this is not implemented.

 

--

 

Message: 2

Date: Tue, 23 Nov 2021 15:46:27 +1000

From: davidcousen...@gmail.com  

To: gnucash-user@gnucash.org  

Subject: Re: [GNC] Data load from CSV files - duplicates

Message-ID: mailto:d2e2be17cadceb8c57924ce17d5ffdece1bd7e3a.ca...@gmail.com> >

Content-Type: text/plain; charset="UTF-8"

 

Leo,

 

You can always manually override GnuCash's matching in the Import Matcher
window by checking the "C" ("R" in older GnuCash versions) column if Gnucash
has selected the "A" column to import the transaction and you do know it
matches a transaction you have imported to another account. This will avoid
having to delete the duplicate transactions. I usually import my bank
account data first so when I import the credit card data I know any credit
card payments should already have been entered from my bank statement.

 

David Cousens

 

On Tue, 2021-11-23 at 01:46 +, Leo Vaccaneo wrote:

> Thanks to David T and David Carlson -

> 

> to David T (and David Carlson) -

> yes - I believe you have hit what I am looking for - so, trying to say 

> it again in a hopefully helpful way -

> 

> being able to assign / match (the term in the CSV importer process) 

> the second split of the transaction being loaded -

> 

> to an existing transaction in the 'destination' 'other side / end of 

> the transaction' account -

> 

> instead of creating a replica of the trans being loaded - as the 

> second split -in the 'destination' 'other side / end of the 

> transaction' account

> ---

> 

> to David Carlson -

> 

> I will work my way through each of your suggestions, and give an 

> update -

> 

> The GNU installer was downloaded yesterday.

> 

> The rest - I will need to work through.

> 

> Sounds like it will be well worth my while to try the QIF import if I 

> can get that format export from my bank (have to check).

> 

> Thanks again to all

> 

> Leo Vaccaneo

> 

> 

> 

> From: D. mailto:sunfis...@yahoo.com> >

> Sent: Monday, 22 November 2021 9:47 PM

> To: David Carlson mailto:david.carlson@gmail.com> >

> Cc: Leo Vaccaneo mailto:leovp...@outlook.com> >;
Gnucash Users < 

> gnucash-user@gnucash.org  >

> Subject: Re: [GNC] Data load from CSV files - duplicates

> 

> ...Fifth, I think Leo is using the term "match" to refer to the 

> process of

> *assigning* the second split to an account. ISTR that there is a step 

> in the process where the user can actually match imported transactions 

> to existing ones, along with the option to use the existing 

> description or replace it, which would eliminate that occurrence of a 

> second transaction. Or perhaps I'm just getting senile.

> 

> David T.

> 

> From: David Carlson

> Sent: Mon Nov 22 05:21:16 EST 2021

> To: Leo Vaccaneo

> Cc: "gnucash-user@gnucash.org  "

> Subject: Re: [GNC] Data load from CSV files - duplicates

> 

> 

> There are a number of things that may be impacting your results.

> 

> First, check Edit > Preferences > Onl

[GNC] A How-to question for new user of GNUCash

[Chris Trueman]

Hello

I've just installed GNUCash to use instead of Quickbooks. Their
intransigence about not being able to verify an installation of QuickBooks
2010 on a different computer when the old one has crashed has forced me to
move.

I use Quickbooks to do the accounts for a very small not-for-profit
community organisation in suburban Melbourne, Australia.

With Quickbooks I could print a receipt when members paid their annual
membership fees.

I can't see a way to print a receipt with GNUCash.

Am I missing something?

Many thanks

Chris Trueman 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] A How-to question for new user of GNUCash

[Liz Dodd]

On Tue, 23 Nov 2021 12:01:35 +1100
"Chris Trueman"  wrote:

> I can't see a way to print a receipt with GNUCash.
> 
> Am I missing something?

I used to print out a customer report, which while not purely a
receipt, indicated the amount of the bill, the amount paid, and the
amount owing.
Others may have more ideas.


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.