Re: [GNC] Project and Design Documentation

2024-09-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-September/113205.html John Ralls wrote: > ... Posts with links can be opened directly if there is clear space around the link. Would commodity Wheat be Type Stock? While this is raised in the context of Managed Funds https://www.gnucash.org

Re: [GNC] Australian Mutual Funds

2024-09-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-September/113205.html John Ralls wrote: > ... Posts with links can be opened directly if there is clear space around the link. Would commodity Wheat be Type Stock? While this is raised in the context of Managed Funds https://www.gnucash.org

Re: [GNC] Database storage

2024-09-20 Thread David Cousens
Hi Chris, Sorry I didn't reply earlier but your email ended up in my spam folder. The transaction report should do it if you select all accounts but that will double up as most transactions will affect at least two accounts but there is no count of them provided in the report.  It may be possible

Re: [GNC] Australian Mutual Funds

2024-09-20 Thread Megan Tilley
Thank you, Bruce - I guess I will add as Mutuals and track individually... -- Regards, Megan Tilley megan.til...@gmail.com 0409 949 717 --- "He who laughs last probably made a backup." --- On Sat, 21 Sept 2024 at 12:06, Bruce Schuck wrote: > On Sat, 21 Sep 2024 11:52:40 +1000 Me

Re: [GNC] Australian Mutual Funds

2024-09-20 Thread John Ralls
That’s not correct. You can create a commodity for anything you like, and BTW you can create any number of namespaces to categorize your commodities. Yes, “commodity” is an overloaded word in English. To market traders it means futures in some physical product: Sow bellies, wheat, steel. In GnuC

Re: [GNC] Project and Design Documentation

2024-09-20 Thread sunfish62--- via gnucash-user
Fair point, but you never answered the initial question: were users on the list referring to that page, or were you implying that their requests for enhancements could have been addressed by this page which they don't know about and which developers haven't updated? It wasn't clear to me what

Re: [GNC] Database storage

2024-09-20 Thread Mark Penner
Sep 20, 2024 03:51:56 Jim DeLaHunt : > Then when you tell GnuCash to store a single "accounting record of an > exchange of value" entry, GnuCash updates the data it has in memory. In > simple terms, it does not make any change to data stored in the database at > that moment.  When you tell GnuC

[GNC] Australian Mutual Funds

2024-09-20 Thread Megan Tilley
Hi, I'm trying to create an Australian Mutual Fund entry for my investments. It is a combination Fund with a primary focus on Property. When I create the Mutual Fund under my Broker Parent Account, I keep getting asked for a "Commodity" but I can not find where to input that, which would be my "

Re: [GNC] Database storage

2024-09-20 Thread Chris Miller via gnucash-user
Hi Jim, > Beware of confusion: the word "transaction" is already used on this list > to mean an "accounting record of an exchange of value". But I suspect > that here you use the word "transaction" to mean a "controlled and > reliable change to data stored in a database". Yes. They are similar. B

Re: [GNC] Database storage

2024-09-20 Thread Chris Miller via gnucash-user
Hi Robert, > One thing that all of the *SQL backends do provide over the flat XML file > storage: accessing the data (*read-only!*) between runs of GnuCash is easier. > Instead of either trying to parse the XML or using Python bindings to the > GnuCash API, one can write code using SQL (in any la

Re: [GNC] Database storage

2024-09-20 Thread Mark at Lorimark
~mark petryk ~w:http://www.lorimarksolutions.com On 9/18/24 22:30, Chris Miller via gnucash-user wrote: Hi David, I don't suppose GnuCash has a transaction list report that could tell us that quickly? A simple way to answer this question would be to save the file as SQL, open the SQL wit

Re: [GNC] Database storage

2024-09-20 Thread Michael or Penny Novack via gnucash-user
On 9/19/2024 3:53 PM, Steve Butler wrote: My first job out of college had a Honeywell 115 Mod 2 box.  Hard drive (singular) was 10 MB.  RAM was 32K of magnetic core.  6 bit CPU and 7 track 556 bpi tape (3 of them). Thought we were going to heaven when it was replaced by an HP 3000 with 7 hard

Re: [GNC] Database storage

2024-09-20 Thread Chris Miller via gnucash-user
Hi Mark, > I have ~some~ knowledge. > In SQL, these are the 'tables' used for storage; >> sqlite> .tables >> accounts employees orders taxtables >> billterms entries prices transactions >> books gnclock recurrences vendors >> budget_amounts gnucashew_vars schedxactions versions >> budgets invoic

Re: [GNC] Database storage

2024-09-20 Thread Mark at Lorimark
Hi Chris, I have ~some~ knowledge. In SQL, these are the 'tables' used for storage; sqlite> .tables accounts employees orderstaxtables billterms entries pricestransactions books gnclock recurrences

Re: [GNC] dollar signs in reports

2024-09-20 Thread sunfish62--- via gnucash-user
I'm not certain, but I think that a user can edit the symbol for a currency and set it to blank. ⁣David T.​ On Sep 20, 2024, 3:19 AM, at 3:19 AM, Murugan Mariappan wrote: >You cannot remove the sign altogether. Can you explain the use case > > > > >Saludos Cordiales > > >Murugan > >_

Re: [GNC] dollar signs in reports

2024-09-20 Thread Murugan Mariappan
If you want to register and track non standard ISO currency , create it as a security and register and track. Saludos Cordiales Murugan From: gnucash-user on behalf of Michael or Penny Novack via gnucash-user Sent: 20 September 2024 12:18 To: gnucash-use

Re: [GNC] How to treat a sale which involves more accounts?

2024-09-20 Thread Michael or Penny Novack via gnucash-user
This IS the way should have started. With the problem descried in "business" terms, for the moment leaving gnucash out of it << at this level, the answers would app;y equally to old fashioned keeping the books pen and ink on paper >> a) The income or loss from sale of part of your collection i

Re: [GNC] Database storage

2024-09-20 Thread Mark at Lorimark
~mark petryk ~w:http://www.lorimarksolutions.com On 9/19/24 11:27, Chris Miller via gnucash-user wrote: Hi Roberts, * Transactional database updates implies multiple user concurrency, but everywhere I hear that multiple users is "problematic". Certainly this is true with the XML storag

Re: [GNC] TXF

2024-09-20 Thread John Ralls
Yes, but only for users in the US. Alex Aycinena updates the US report every year to reflect the TXF changes for the previous year. See https://www.gnucash.org/docs/v5/C/gnucash-guide/rpt_standardrpts.html#rpt_grp_miscrpts amd https://www.gnucash.org/docs/v5/C/gnucash-manual/report-classes.htm

[GNC] Australian Mutual Funds

2024-09-20 Thread flywire
> an Australian Mutual Fund... It is a combination Fund with a primary focus on Property. Mutual fund is a very American term. Can you give an example fund? I assume you are referring to a managed fund that is not directly traded on the ASX, unlike an ETF (Exchange Traded Fund). Regards

Re: [GNC] dollar signs in reports

2024-09-20 Thread Michael or Penny Novack via gnucash-user
On 9/20/2024 12:26 PM, Murugan Mariappan wrote: If you want to register and track non standard ISO currency , create it as a security and register and track. I was assuming that what was wanted was full accounting in this other unit of exchange. The fact that "rules" might make it not exchange

Re: [GNC] Project and Design Documentation

2024-09-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-September/112961.html sunfish62 wrote: > As I understand it, the developers focus on entries in bugzilla ( bugs.gnucash.org) to address problems and proposals. It is better advice to suggest that users with specific suggestions for improvement s

Re: [GNC] Database storage

2024-09-20 Thread Jim DeLaHunt
Chris: On 2024-09-20 06:32, Chris Miller via gnucash-user wrote: Hi Jim, Beware of confusion: the word "transaction" is already used on this list to mean an "accounting record of an exchange of value". But I suspect that here you use the word "transaction" to mean a "controlled and reliable ch

Re: [GNC] Australian Mutual Funds

2024-09-20 Thread Megan Tilley
The fund in question is under one entity (Australian Unity Healthcare Property) but two different funds: - Australian Unity Healthcare Property Trust AUS0112AU - Australian Unity Health Care Property Trust Wholesale AUS0037AU My Financial Advisor has stated that it is a managed fund not lis

Re: [GNC] Database storage

2024-09-20 Thread Jim DeLaHunt
Chris: On 2024-09-19 09:27, Chris Miller via gnucash-user wrote: I had already come to the same conclusion. And I have also already posed questions to myself: * Does SQLite support transactions? -- Yes. Beware of confusion: the word "transaction" is already used on this list to mean an "

Re: [GNC] Database storage

2024-09-20 Thread Robert Heller
At Fri, 20 Sep 2024 06:32:13 -0700 (PDT) Chris Miller wrote: > > Hi Jim, > > > Beware of confusion: the word "transaction" is already used on this list > > to mean an "accounting record of an exchange of value". But I suspect > > that here you use the word "transaction" to mean a "controlled

Re: [GNC] dollar signs in reports

2024-09-20 Thread Michael or Penny Novack via gnucash-user
On 9/19/2024 8:17 PM, Murugan Mariappan wrote: You cannot remove the sign altogether. Can you explain the use case The main legitimate reason would be the accounting unit is not any generally accepted "currency" but some special unit. Nor a commodity, because by rules, not allowed to be exch

[GNC] TXF

2024-09-20 Thread Chris Miller via gnucash-user
Hi Folks, Does GnuCash export data in TXF format for inclusion in tax preparation software? This would require that I could label accounts according to their IRS form and form line number. Thanks for the help, -- Chris. V:916.799.9461 F:916.974.0428 A: Because we read from top to bottom

Re: [GNC] Australian Mutual Funds

2024-09-20 Thread John Ralls
You must first create the commodity in Tools>Security Editor. Regards, John Ralls > On Sep 20, 2024, at 03:16, Megan Tilley wrote: > > Hi, I'm trying to create an Australian Mutual Fund entry for my > investments. > > It is a combination Fund with a primary focus on Property. > > When I crea

Re: [GNC] Australian Mutual Funds

2024-09-20 Thread Megan Tilley
I have done so (created the commodity in Tools>Security Editor) however, that process only allows "Stocks" and not a Fund... so - confusion on my part. I have obviously done the creation incorrectly as the 'new' list still does not show the additions - snip of Security list and also Account list.

Re: [GNC] Australian Mutual Funds

2024-09-20 Thread Bruce Schuck
On Sat, 21 Sep 2024 11:52:40 +1000 Megan Tilley wrote: I have done so (created the commodity in Tools>Security Editor) however, that process only allows "Stocks" and not a Fund... so - confusion on my part. I have obviously done the creation incorrectly as the 'new' list still does not show