Re: [GNC] Ideas and recommendations for community project

[Jim DeLaHunt]

Hello, Sebastian:

Welcome to GnuCash! I hope it works well for you.

On 2023-07-30 22:28, gibel...@gmx.net wrote:

I have recently started using gnuCash and am trying to figure out if I
can use gnuCash in a meaningful way to map the cash flows in a community
project. I think I understand the basic concepts through the tutorial
and with a test project, but am still looking for ideas and
recommendations for some specific circumstances. …[details elided]…


How about this as a first thought: do you understand the accounting 
aspect of your questions, separate from how to use GnuCash to perform 
the accounting?  Do you have an idea of which of these things you want 
to track are assets, liabilities, income, or expenses?  Do you have an 
idea of how you would track these if doing bookkeeping on paper sheets 
with lots of columns?


If you do not, then you will probably be greatly helped by learning some 
basic accounting. For instance, you could read this textbook, 
/Principles of Accounting/, Vol 1 
, 
which is free to read online. Once you understand the accounting aspect 
of these things you want to track, it will be easier to understand how 
to use GnuCash.


Best regards,
    —Jim DeLaHunt
___
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] Ideas and recommendations for community project

[gibel...@gmx.net]

I have recently started using gnuCash and am trying to figure out if I
can use gnuCash in a meaningful way to map the cash flows in a community
project. I think I understand the basic concepts through the tutorial
and with a test project, but am still looking for ideas and
recommendations for some specific circumstances.

## Membership fee
The membership fee with which a member 'buys in' to the community is to
be paid in by a certain date. With the contribution a member acquires
shares in the community assets and buys a private plot of land. The
total amount can be paid in full, flexibly with several installments or
with monthly transfers.
How do you map the community's outstanding claims against a member who
has not yet paid the contribution in full?
It would also be useful to have an overview of which payments are due
from whom and when, so that payments received can be compared with them.
Reports that show the current status of deposits for all members and
list the deposits made for each member would certainly also be helpful.

## Community assets & shares
The community assets (land, machinery, buildings, etc.) are 'divided'
proportionally among the members, i.e. each member 'owns' a certain
share (1 / number of members) of the community assets. In the case of a
company, this would be comparable to the shares of several shareholders,
who (in this case) all own the same share in the company. In the case of
a corporation, it would be shares owned by the investors.
This is interesting for cases where the community generates income that
can be paid out to the members, if necessary. How can this scenario be
mapped in gnuCash and illustrated in reports?

## System boundaries
How to map cash flows between accounts inside and outside the system
boundaries?
An example: A member buys something for the community with his private
cash (outside the system boundary). When the invoice is submitted, the
amount is paid to the member from a community account (inside the system
boundary). The member's cash account basically lives outside the system
boundary and is not mapped into gnuCash, right? How does such a scenario
work in double-entry accounting?

Many thanks for the help and recommendations,
Sebastian

___
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] Cannot write to file a new wrinkle

[Adrien Monteleone]

Thanks Michael, those are fair caveats to my recommendation. I shall 
endeavor to remember that and not assume folks only keep GnuCash data 
and nothing else in a particular folder.


Regards,
Adrien

On 7/30/23 9:37 AM, Michael or Penny Novack wrote:
BE CAREFUL --- this control of a resource by having the existence of a 
lock file indicate "resource in use" is a VERY common solution to 
restricting use to "a single concurrent user" (allow multiple sequential 
access but not multiple simultaneous access). OTHER applications might 
be creating .lck files besides gnucash. So...


1) Delete "any" .lck files only if you have your gnucash files in a 
directory reserved for just the.


2) Otherwise --- before deleting a .lck file make sure it is not a lock 
file from some other application.


___
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] Currency conversion

[john]

Not really. That happens because sometimes you make or request prices in one 
direction and sometimes the other. The only case where it would matter is if 
one of them hadn't been updated in a while. The price-retrieval code looks 
first in the direction it wants, then in the other direction, then for an 
indirect (e.g. if you need COP->EUR and don't have that in the pricedb but you 
have COP->USD and USD->EUR it will use the combination) quote. The first one it 
finds wins, not the most recent. So suppose you need USD->COP for some report 
but the latest such quote is two months old. Your report will use that even 
though there's a COP->USD quote from yesterday. That will make your report 
appear to be off.

Regards,
John Ralls


> On Jul 30, 2023, at 13:09, Fred Tydeman  wrote:
> 
> I have noticed that my Price Database has both
> COP -> USD
> and
> USD -> COP
> conversion rates.
> Does it matter?
> ___
> 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] Currency conversion

[Fred Tydeman]

I have noticed that my Price Database has both
 COP -> USD
and
 USD -> COP
conversion rates.
Does it matter?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to enter data in "Description" field of a Transaction

[john]

Following up on that, since you're on macOS there's a diagnostic option that's 
not readily available on other platforms:
1. Open /Applications/Utilities/Activity Monitor. Find GnuCash in the process 
list and select it.
2. Type a character in the description field of  a new transaction to make 
GnuCash Freeze.
3. Back in Activity Monitor, click the gear icon and select "Sample Process" 
from the resulting menu. 
4. Attach the resulting file to a reply.

Regards,
John Ralls



> On Jul 29, 2023, at 14:03, John Ralls  wrote:
> 
> That's interesting, yours is the first report of this on macOS.
> 
> Regards,
> John Ralls
> 
>> On Jul 29, 2023, at 12:59 PM, G R Hewitt  wrote:
>> 
>> Hi John, I am using MacOS High Sierra 10.13.6 2010 MacPro 5.1
>> 
>> On Sat, 29 Jul 2023 at 18:00, john  wrote:
>> 
>>> For bug-filing instructions see
>>> https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones
>>> .
>>> 
>>> Chris Green and G R Hewitt, what OS/distro are you running and how did you
>>> install GnuCash?
>>> 
>>> For all three of you, what Window Manager (e.g. Gnome, XFCE, Mate, etc.)
>>> are you using?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
 On Jul 29, 2023, at 05:29, AgedLace  wrote:
 
 Can you point me in the direction needed in order to file the bug-report?
 
 Thank you!
 
 
 On 7/29/23 08:26, Adrien Monteleone wrote:
> Sorry, indeed, I missed that.
> 
> Consider stepping back to 4.14 in that case.
> 
> But also consider filing a bug report for sure so it can be addressed.
> 
> Regards,
> Adrien
> 
> On 7/29/23 7:09 AM, AgedLace wrote:
>> As i mentioned, my repository has version 5.3-1.  This is the version
>>> I am using.
> 
> ___
> 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] Cannot write to file a new wrinkle

[Michael or Penny Novack]

On 7/30/2023 8:13 AM, Adrien Monteleone wrote:
Also, verify that GnuCash is not running, then check to see if you 
have any files ending with a '.lck' extension in that data folder and 
delete those. (but reply back with their file names first) 


BE CAREFUL --- this control of a resource by having the existence of a 
lock file indicate "resource in use" is a VERY common solution to 
restricting use to "a single concurrent user" (allow multiple sequential 
access but not multiple simultaneous access). OTHER applications might 
be creating .lck files besides gnucash. So...


1) Delete "any" .lck files only if you have your gnucash files in a 
directory reserved for just the.


2) Otherwise --- before deleting a .lck file make sure it is not a lock 
file from some other application.



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] Cannot write to file a new wrinkle

[Adrien Monteleone]

Also, verify that GnuCash is not running, then check to see if you have 
any files ending with a '.lck' extension in that data folder and delete 
those. (but reply back with their file names first)


Regards,
Adrien

On 7/30/23 7:06 AM, Adrien Monteleone wrote:

That means you have opened GnuCash with a new blank file.

I'd go recover that 'offending file' pronto!

(note, the one you gave a file name for ended in .gnucash which is a 
book file, and it might have been your current active file)


Once you've resolved that, please report back the full name of the file. 
(file path not needed)


And while you're doing that, do you have any other '.gnucash' files in 
that folder/directory?


If so, can you provide a screenshot of Windows Explorer showing the list 
of files? (be sure to use the 'full details' view so we can see file 
creation and modification dates. You might need to 'turn on' one or both 
of those columns')


___
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] Cannot write to file a new wrinkle

[Adrien Monteleone]

That means you have opened GnuCash with a new blank file.

I'd go recover that 'offending file' pronto!

(note, the one you gave a file name for ended in .gnucash which is a 
book file, and it might have been your current active file)


Once you've resolved that, please report back the full name of the file. 
(file path not needed)


And while you're doing that, do you have any other '.gnucash' files in 
that folder/directory?


If so, can you provide a screenshot of Windows Explorer showing the list 
of files? (be sure to use the 'full details' view so we can see file 
creation and modification dates. You might need to 'turn on' one or both 
of those columns')


Regards,
Adrien

On 7/30/23 5:35 AM, Mahon Finbar via gnucash-user wrote:

Hello again,

After removing, renaming etc. the "offending file" as described, I now 
have a screen with 'unsaved book' which doesn't react to the 'close' 
option.


This appeared after a text box which said that the original offending 
file was not available, it was in the 'history' did I want to keep it, I 
said 'no' and then the screen I mentioned appeared.


I tried 'saving as' but it still won't go away.

Does anybody know what an 'unsaved book' is?

BTW, the same problem I have had all along (cannot save) is still there.


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

Re: [GNC] Unable to enter data in "Description" field of a Transaction

[Adrien Monteleone]

Make sure your time zone and clock are correct on your system. Though if 
they weren't, I'd think more than one site wouldn't resolve correctly.


If they are far off, you can get resolution errors like what you've seen.

Regards,
Adrien

On 7/29/23 3:44 PM, AgedLace wrote:
That didn't work for me either.  I have no idea what it could be.  And 
I'm not able to spend any more time on it right now.


___
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] Issue with Finance::Quote

[bern...@deprez.biz]

Hi Bruce,

Confirmed it's back up and running - my quota reset overnight and now 
I'm able to pull quotes again!


Again, thank you so much for your help!
Bernard

On 29/07/2023 15:21, Bruce Schuck wrote:

On 7/29/23 05:06, bern...@deprez.biz wrote:

I wasn't aware of the IP tracking and that may be the explanation - 
without my knowledge, somebody else in my household was playing

around with a Node-RED flow that was pulling a request from
Alphavantage each minute with a third API key :-)  We've now tuned
that flow back to once every 4 hours (which is totally adequate for
our use case)


Bernard,

Cool, glad I can help. Your issue did expose a minor issue in the 
AlphaVantage module. It was not properly catching the message returned 
when the daily limit has been reached. I did address that and the fix 
will be included in the next release.


If you would like to test a pre-release while you are still having the 
issue, please try installing BPSCHUCK/Finance-Quote-1.57_03.tar.gz 
from CPAN.


I'll have to give it another try tomorrow (the flow has been up and 
running overnight) and see if all is back to normal.


Good luck, looking forward to the result.


I'm super thankful for your help & mentioning the below!!!


You're welcome.

Bruce S.


___
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] Description field, freezes

[Steve Miller]

Just noticed that someone else here reported (see below) the exact same
problem I experienced after installing 5.3 GnuCash in Windows, weeks ago.
And I thought I was the only one (I posted my frustration here several
weeks ago)

Subject: Re: [GNC] Unable to enter data in "Description" field of a
Transaction
My issue is that, yes, I can retreat and go back, but it still freezes
after adding 1 character.  I have to retreat and go back for nearly ever
single character in my description ... REALLY annoying!!

If I opt to manually enter a description (by opting out of the
autocomplete) in the description field, it FREEZES after entering a single
character.  If I'm trying to enter a 10 character word for a new entry, I
enter the first character, it freezes, I then save it by clicking outside
that entry, then go back and enter the 2nd character, it freezes I save it
by clicking outside the entry, etc etc etc.  It is, frustrating.to say the
least.  Why I previously asked if there was a way to just turn off the
entire auto-field description feature (I understand there is not).
___
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] Cannot write to file a new wrinkle

[Mahon Finbar via gnucash-user]

Hello again,

After removing, renaming etc. the "offending file" as described, I now 
have a screen with 'unsaved book' which doesn't react to the 'close' option.


This appeared after a text box which said that the original offending 
file was not available, it was in the 'history' did I want to keep it, I 
said 'no' and then the screen I mentioned appeared.


I tried 'saving as' but it still won't go away.

Does anybody know what an 'unsaved book' is?

BTW, the same problem I have had all along (cannot save) is still there.

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