Re: [GNC] GnuCash with Interactive Brokers
Understood. My point was more around whether there is a specific field in the GnuCash securities setup which if matched with a specific field in the OFX xml would result in the manual click-based becoming unnecessary? I have dozens of bonds in the portfolio which are painful to manually match. But they all have unique identifiers (CUSIPs and IBKR contract ids) which I wish GnuCash could leverage in the matching stage. As of now it does not seem to attempt any type of best guess when a new security is being imported from the OFX. Thanks, Ken > On 7 Feb 2024, at 02:57, Kalpesh Patel wrote: > > Yap, one time deal. It remembers for next time and it won't ask unless it > encounters something new. > > It is similar to us learning to walk in our childhood ... > > -Original Message- > From: Steve Butler > Sent: Tuesday, February 06, 2024 1:21 AM > To: km22 > Cc: Kalpesh Patel ; Gyle McCollam > ; GnuCash Users > Subject: Re: [GNC] GnuCash with Interactive Brokers > > That is true for the first time. After that it will learn the matches you > make and only ask for new ones. > >> On Tue, Feb 6, 2024, 16:35 km22 via gnucash-user >> wrote: >> >> Thanks. >> >> >> Upon importing the OFX I am prompted to match the different bonds in >> the statement with the relevant asset in GnuCash: >> >> This is quite a manual process having to match these manually >> one-by-one. Do you know whether there is a way for me to define the >> assets in GnuCash so this mapping is more automated? (Or at least >> where GnuCash is able to select the best match for me to review?) >> >> >> Since it reads "Please note that the exchange code of the commodity >> you select will be overwritten" does this mean that if I set the >> ISIN/CUSIP correctly in GnuCash the mapping would be more seamless? >> >> >> >> >> >> >>> On 2024-02-05 22:17, Kalpesh Patel wrote: >>> >>> Ken, as Gyle mentioned, they are sibling to each other. In terms of >>> technical specs, QFX is modified OFX format which contains >>> additional Intuit’s non-XML header but GNC treats them both equal as >>> it simply ignores that header. From the transaction wise they both >>> will contain identical data. >>> >>> *From:*Gyle McCollam >>> *Sent:* Monday, February 05, 2024 8:59 AM >>> *To:* Kalpesh Patel ; km22 >>> *Cc:* gnucash-user@gnucash.org >>> *Subject:* Re: [GNC] GnuCash with Interactive Brokers >>> >>> It doesn't "prefer" either, in fact the import is OFX/QFX. >>> >>> Thank You, >>> >>> *Gyle McCollam* >>> >>> Gyle McCollam >>> >>> gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email >>> >>> >>> >>> >>> *From:*gnucash-user >>> on behalf of >>> km22 via gnucash-user >>> *Sent:* Monday, February 5, 2024 4:54 AM >>> *To:* Kalpesh Patel >>> *Cc:* gnucash-user@gnucash.org >>> *Subject:* Re: [GNC] GnuCash with Interactive Brokers >>> >>> Hi Kalpesh, >>> >>> Thanks for your reply. IBKR offers these "Third-party Downloads": >>> >>> 1. Quicken Web Connect -> which generate a QFX file >>> >>> 2. GainsKeeper >>> >>> 3. TradeLog >>> >>> 4. MS Money -> which generates a OFX file >>> >>> >>> Do you know whether GnuCash prefers OFX or QFX? >>> >>> I have downloaded both and will experiment with them. >>> >>> Thanks, >>> >>> Ken >>> >>> >>> >>> On 2024-02-05 10:27, Kalpesh Patel wrote: >>>> While I am NOT with Interactive Broker, your best bet is to see if >>> you can download transactions in OFX (Open Financial Exchange) or >>> QFX (Quicken Financial Exchange) format. That would be the best >>> format and I believe most broker-dealers support that format as a >>> download method from their web portal. >>>> >>>> -Original Message- >>>> From: km22 >>>> Sent: Sunday, February 04, 2024 4:57 AM >>>> To:gnucash-user@gnucash.org >>>> Subject: [GNC] GnuCash with Interactive Brokers >>>> >>>> Hi Gnucash Users, >>>> >>>> Does anyone on this mailing list have a method for importing >>> transactions
Re: [GNC] GnuCash with Interactive Brokers
Thanks. This can be a very tedious process, especially where there might be dozens of securities to match one by one through a gui that requires many clicks through different drop down lists. It would be nice if there was a way to ensure much better matching suggestions and then the user simply needs to click to accept (in most instances). I’ll continue to experiment with importing IBKR ofx transactions into a dummy test file. Thanks for the guidance so far. On 6 Feb 2024, at 13:21, Steve Butler wrote: That is true for the first time. After that it will learn the matches you make and only ask for new ones. On Tue, Feb 6, 2024, 16:35 km22 via gnucash-user <[1]gnucash-user@gnucash.org> wrote: Thanks. Upon importing the OFX I am prompted to match the different bonds in the statement with the relevant asset in GnuCash: This is quite a manual process having to match these manually one-by-one. Do you know whether there is a way for me to define the assets in GnuCash so this mapping is more automated? (Or at least where GnuCash is able to select the best match for me to review?) Since it reads "Please note that the exchange code of the commodity you select will be overwritten" does this mean that if I set the ISIN/CUSIP correctly in GnuCash the mapping would be more seamless? On 2024-02-05 22:17, Kalpesh Patel wrote: > > Ken, as Gyle mentioned, they are sibling to each other. In terms of > technical specs, QFX is modified OFX format which contains additional > Intuit’s non-XML header but GNC treats them both equal as it simply > ignores that header. From the transaction wise they both will contain > identical data. > > *From:*Gyle McCollam <[2]gmccol...@live.com> > *Sent:* Monday, February 05, 2024 8:59 AM > *To:* Kalpesh Patel <[3]kalpesh.pa...@usa.net>; km22 <[4]k...@gmx.com> > *Cc:* [5]gnucash-user@gnucash.org > *Subject:* Re: [GNC] GnuCash with Interactive Brokers > > It doesn't "prefer" either, in fact the import is OFX/QFX. > > Thank You, > > *Gyle McCollam* > > Gyle McCollam > > [6]gmccol...@live.com <mailto:[7]gmccol...@gyleshomes.com>email > > > > *From:*gnucash-user > on behalf of km22 > via gnucash-user <[9]gnucash-user@gnucash.org> > *Sent:* Monday, February 5, 2024 4:54 AM > *To:* Kalpesh Patel <[10]kalpesh.pa...@usa.net> > *Cc:* [11]gnucash-user@gnucash.org <[12]gnucash-user@gnucash.org> > *Subject:* Re: [GNC] GnuCash with Interactive Brokers > > Hi Kalpesh, > > Thanks for your reply. IBKR offers these "Third-party Downloads": > > 1. Quicken Web Connect -> which generate a QFX file > > 2. GainsKeeper > > 3. TradeLog > > 4. MS Money -> which generates a OFX file > > > Do you know whether GnuCash prefers OFX or QFX? > > I have downloaded both and will experiment with them. > > Thanks, > > Ken > > > > On 2024-02-05 10:27, Kalpesh Patel wrote: > > While I am NOT with Interactive Broker, your best bet is to see if > you can download transactions in OFX (Open Financial Exchange) or QFX > (Quicken Financial Exchange) format. That would be the best format and > I believe most broker-dealers support that format as a download method > from their web portal. > > > > -Original Message- > > From: km22<[13]k...@gmx.com> > > Sent: Sunday, February 04, 2024 4:57 AM > > [14]To:gnucash-user@gnucash.org > > Subject: [GNC] GnuCash with Interactive Brokers > > > > Hi Gnucash Users, > > > > Does anyone on this mailing list have a method for importing > transactions from Interactive Brokers (IBKR) to GnuCash? (Especially > multi-currency users.) > > > > I currently enter all transactions manually but would like to > explore ways of importing transactions. > > > > Please share your approach if so. > > > > Thanks, > > > > Ken > > > > > > > > > ___ > gnucash-user mailing list > [15]gnucash-user@gnucash.org > To update your subs
Re: [GNC] GnuCash with Interactive Brokers
Thanks. Upon importing the OFX I am prompted to match the different bonds in the statement with the relevant asset in GnuCash: This is quite a manual process having to match these manually one-by-one. Do you know whether there is a way for me to define the assets in GnuCash so this mapping is more automated? (Or at least where GnuCash is able to select the best match for me to review?) Since it reads "Please note that the exchange code of the commodity you select will be overwritten" does this mean that if I set the ISIN/CUSIP correctly in GnuCash the mapping would be more seamless? On 2024-02-05 22:17, Kalpesh Patel wrote: Ken, as Gyle mentioned, they are sibling to each other. In terms of technical specs, QFX is modified OFX format which contains additional Intuit’s non-XML header but GNC treats them both equal as it simply ignores that header. From the transaction wise they both will contain identical data. *From:*Gyle McCollam *Sent:* Monday, February 05, 2024 8:59 AM *To:* Kalpesh Patel ; km22 *Cc:* gnucash-user@gnucash.org *Subject:* Re: [GNC] GnuCash with Interactive Brokers It doesn't "prefer" either, in fact the import is OFX/QFX. Thank You, *Gyle McCollam* Gyle McCollam gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email *From:*gnucash-user on behalf of km22 via gnucash-user *Sent:* Monday, February 5, 2024 4:54 AM *To:* Kalpesh Patel *Cc:* gnucash-user@gnucash.org *Subject:* Re: [GNC] GnuCash with Interactive Brokers Hi Kalpesh, Thanks for your reply. IBKR offers these "Third-party Downloads": 1. Quicken Web Connect -> which generate a QFX file 2. GainsKeeper 3. TradeLog 4. MS Money -> which generates a OFX file Do you know whether GnuCash prefers OFX or QFX? I have downloaded both and will experiment with them. Thanks, Ken On 2024-02-05 10:27, Kalpesh Patel wrote: > While I am NOT with Interactive Broker, your best bet is to see if you can download transactions in OFX (Open Financial Exchange) or QFX (Quicken Financial Exchange) format. That would be the best format and I believe most broker-dealers support that format as a download method from their web portal. > > -Original Message- > From: km22 > Sent: Sunday, February 04, 2024 4:57 AM > To:gnucash-user@gnucash.org > Subject: [GNC] GnuCash with Interactive Brokers > > Hi Gnucash Users, > > Does anyone on this mailing list have a method for importing transactions from Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency users.) > > I currently enter all transactions manually but would like to explore ways of importing transactions. > > Please share your approach if so. > > Thanks, > > Ken > > > > ___ 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 with Interactive Brokers
Hi Kalpesh, Thanks for your reply. IBKR offers these "Third-party Downloads": 1. Quicken Web Connect -> which generate a QFX file 2. GainsKeeper 3. TradeLog 4. MS Money -> which generates a OFX file Do you know whether GnuCash prefers OFX or QFX? I have downloaded both and will experiment with them. Thanks, Ken On 2024-02-05 10:27, Kalpesh Patel wrote: While I am NOT with Interactive Broker, your best bet is to see if you can download transactions in OFX (Open Financial Exchange) or QFX (Quicken Financial Exchange) format. That would be the best format and I believe most broker-dealers support that format as a download method from their web portal. -Original Message- From: km22 Sent: Sunday, February 04, 2024 4:57 AM To:gnucash-user@gnucash.org Subject: [GNC] GnuCash with Interactive Brokers Hi Gnucash Users, Does anyone on this mailing list have a method for importing transactions from Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency users.) I currently enter all transactions manually but would like to explore ways of importing transactions. Please share your approach if so. Thanks, Ken ___ 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 with Interactive Brokers
Hi Gnucash Users, Does anyone on this mailing list have a method for importing transactions from Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency users.) I currently enter all transactions manually but would like to explore ways of importing transactions. Please share your approach if so. Thanks, Ken ___ 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] MacOS - could not complete critical test of libdbi
I have downloaded DB Browser for Sqlite and have been trying different combinations of opening the file and remounting the drive and/or rebooting the system. As best as I can tell, after I open and close the file in Gnucash once, I cannot then re-open it with Gnucash nor DBBrowser. It seems the first time I open the file in Gnucash causes there to be a lock. I need to reboot the machine to open it again. I’ll experiment more but any ideas are welcome. Thanks, Ken > On 2 Aug 2022, at 23:15, km22 wrote: > > Hi, > > I am a new user of MacOS having recently bought a MacBook Air (after many > years of being a Gnucash user on Windows and Linux). > > I was able to open my existing GnuCash file and add some transactions. But > after closing GnuCash and trying to re-open the file I get the following > error: > > GnuCash could not complete a critical test for the presence of a bug in the > "libdbi" library. This may be caused by a permissions misconfiguration of > your SQL database. Please see https://bugs.gnucash.org/show_bug.cgi?id=645216 > <https://bugs.gnucash.org/show_bug.cgi?id=645216> for more information. > > This looks like a very old bug that was resolved long ago. I see comment #19 > suggests to copy the file but that did not work for me. > > Any other advice I should consider? > > My system is: > MacOS Monterey version 12.5. > GnuCash Version: 4.11, Build ID: 4.11+(2022-06-25) > > Thanks, > Ken > > ___ 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] MacOS - could not complete critical test of libdbi
Hi, I am a new user of MacOS having recently bought a MacBook Air (after many years of being a Gnucash user on Windows and Linux). I was able to open my existing GnuCash file and add some transactions. But after closing GnuCash and trying to re-open the file I get the following error: GnuCash could not complete a critical test for the presence of a bug in the "libdbi" library. This may be caused by a permissions misconfiguration of your SQL database. Please see https://bugs.gnucash.org/show_bug.cgi?id=645216 for more information. This looks like a very old bug that was resolved long ago. I see comment #19 suggests to copy the file but that did not work for me. Any other advice I should consider? My system is: MacOS Monterey version 12.5. GnuCash Version: 4.11, Build ID: 4.11+(2022-06-25) Thanks, Ken ___ 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] Why does an Equity account have to be of Currency type?
Hi Michael, I agree - I could change the definition of $ for the purposes of the Robinson Crusoe case. But let me ask the question a different way: It seems that when trying to create an account of type Asset, Bank, Cash, Credit Card, Liability, A/Receivable, A/Payable, Equity selecting the denominated "Security/currency" only allows the user to select a Currency Type. For account types Stock and Mutual Fund the "Security/currency" is only allowed to be of a Non-Currency Type. Why is that restriction necessary? Why can't you have a Bank account that is denominated in silver taels*? Or a cash account denominated in "Disney Dollars"? Or contribute Equity to a business in the form of yards of lumber? Perhaps the answer is to simply use a "Stock" account type for my asset examples? But there is no workaround for the equity example. And it seems like an artificial limitation within the software - unless I am missing the reason this should not be permitted (either from an software implementation or accounting perspective). Thanks, Ken * Yes, I could use this ISO currency XAG but that price typically refers to troy ounces and it might be that I want to mark the bid price of a silver savings account at a premium or discount to the XAG price. P.S. For some reason I am not receiving replies direct to my email so I am copying and pasting from the GnuCash archive below. Date: Mon, 25 Apr 2022 13:17:08 -0400 From: Michael or Penny Novack To:gnucash-user@gnucash.org Subject: Re: [GNC] Why does an Equity account have to be of Currency type? Message-ID:<521f2821-4532-0ac2-81a2-4a4f9400c...@comcast.net> Content-Type: text/plain; charset=UTF-8; format=flowed But question is more general.? Let's say I join Robinson Crusoe on a remote island and we decide our economy will be denominated in silver coins (of which I had 12 in my pocket when I washed ashore on his island).? If I were to do my accounting in GnuCash I would need to start with an Opening Balance of 12 coins (my first transaction would need to be Assets:Coins 12, Equity:Opening Balance 12), Gnucash does not let me do this.? The software will only allow the Equity accounts to be of ISO currency type.? Why not let the user denominate an Equity account in any asset they like - silver coins if that is what they want? It DOES allow this if you refuse to accept the magical meaning of "$" (or any other symbol). Declare a law on the island, "$ is the symbol for a silver coin".? The fact that other people in other lands understand $ to stand for USD is irrelevant to island life. You are acting as if it made a difference in algebra whether you used "X"or "Y" to stand for an unknown variable. But you are actually wanting something else. You are wanting in one set of books more than one type of currency? at the same time. That gnucash does not support, but that is more a limitation of accounting than of gnucash. You CAN be accounting for more than one sort of :currency" at the same time, but if not exchangeable, not in the same set of books << guncash will let you have any number of books >> Michael D Novack On 25/4/2022 22:24, km22 wrote: Hi Jim, In the end, I have decided to simply treat my mock trust or mock company with a cash equity injection. But question is more general. Let's say I join Robinson Crusoe on a remote island and we decide our economy will be denominated in silver coins (of which I had 12 in my pocket when I washed ashore on his island). If I were to do my accounting in GnuCash I would need to start with an Opening Balance of 12 coins (my first transaction would need to be Assets:Coins 12, Equity:Opening Balance 12), Gnucash does not let me do this. The software will only allow the Equity accounts to be of ISO currency type. Why not let the user denominate an Equity account in any asset they like - silver coins if that is what they want? Thanks, Ken P.S. Please excuse this badly formatted email - I had to copy and paste your text from the Archive as I seem to have deleted the original reply. -- Message: 8 Date: Sat, 23 Apr 2022 13:05:04 -0700 From: Jim DeLaHunt To:gnucash-user@gnucash.org Subject: Re: [GNC] Why does an Equity account have to be of Currency type? Message-ID:<29e7cc91-fdb1-ccb9-daf2-f5e177392...@jdlh.com> Content-Type: text/plain; charset=UTF-8; format=flowed On 2022-04-23 02:46, km22 wrote: ?I am starting a new Gnucash file for a simple "mock" trust.? The trust holds physical assets (like stamps and coins and other collectibles).? I want to represent the contributions to this trust in the form of these assets.? However, when I try to create new Equity accounts for the contributions it only allows me to use "Currency" type assets.? Your Gnucash usage question leads me to an accounting question.
Re: [GNC] Why does an Equity account have to be of Currency type?
Hi Jim, In the end, I have decided to simply treat my mock trust or mock company with a cash equity injection. But question is more general. Let's say I join Robinson Crusoe on a remote island and we decide our economy will be denominated in silver coins (of which I had 12 in my pocket when I washed ashore on his island). If I were to do my accounting in GnuCash I would need to start with an Opening Balance of 12 coins (my first transaction would need to be Assets:Coins 12, Equity:Opening Balance 12), Gnucash does not let me do this. The software will only allow the Equity accounts to be of ISO currency type. Why not let the user denominate an Equity account in any asset they like - silver coins if that is what they want? Thanks, Ken P.S. Please excuse this badly formatted email - I had to copy and paste your text from the Archive as I seem to have deleted the original reply. -- Message: 8 Date: Sat, 23 Apr 2022 13:05:04 -0700 From: Jim DeLaHunt To:gnucash-user@gnucash.org Subject: Re: [GNC] Why does an Equity account have to be of Currency type? Message-ID:<29e7cc91-fdb1-ccb9-daf2-f5e177392...@jdlh.com> Content-Type: text/plain; charset=UTF-8; format=flowed On 2022-04-23 02:46, km22 wrote: ?I am starting a new Gnucash file for a simple "mock" trust.? The trust holds physical assets (like stamps and coins and other collectibles).? I want to represent the contributions to this trust in the form of these assets.? However, when I try to create new Equity accounts for the contributions it only allows me to use "Currency" type assets.? Your Gnucash usage question leads me to an accounting question. And I am not an accountant, so my ignorance is likely vast. However? Why should the accounts which track the physical assets be Equity accounts?? Why not make them Asset accounts? And then, David Cousens points out that what you need to track physical assets is an inventory application, and GnuCash is not an inventory application. How does that inform your use of GnuCash? ------ On 23/4/2022 17:46, km22 wrote: Hi, I am starting a new Gnucash file for a simple "mock" trust. The trust holds physical assets (like stamps and coins and other collectibles). I want to represent the contributions to this trust in the form of these assets. However, when I try to create new Equity accounts for the contributions it only allows me to use "Currency" type assets. I don't understand why Gnucash would force this limitation. Why wouldn't a user be allowed to use any asset type they wish (stocks, bitcoin, collectables) and not solely the ISO cash types? A screenshot of the issue is attached. Thanks, Ken ___ 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.
[GNC] Why does an Equity account have to be of Currency type?
Hi, I am starting a new Gnucash file for a simple "mock" trust. The trust holds physical assets (like stamps and coins and other collectibles). I want to represent the contributions to this trust in the form of these assets. However, when I try to create new Equity accounts for the contributions it only allows me to use "Currency" type assets. I don't understand why Gnucash would force this limitation. Why wouldn't a user be allowed to use any asset type they wish (stocks, bitcoin, collectables) and not solely the ISO cash types? A screenshot of the issue is attached. Thanks, Ken ___ 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] Why does the balance sheet report list positions with zero balances?
Hi Derek, Who are the experts in terms of the report coding/development? Is it worth me trying to learn the report coding language and trying to fix this myself? Or are there plans to migrate the report coding to a different language (like SQL) in which case I should focus my efforts elsewhere? Alternatively, are GnuCash developers open to the idea of bounties to encourage specific fixes/enhancements? Thanks, Ken On 20/2/2022 22:20, km22 wrote: Thank you. Submitted here: https://bugs.gnucash.org/show_bug.cgi?id=798461 On 20/2/2022 22:10, Derek Atkins wrote: Hi, I just opened the account file you sent, ran the balance sheet, and then expanded the default account depth from to 4. When I did that I noticed that the two lines you sent: 2,000 UST2 $1,960.00 0 UST1 $0.00 are BOTH from the same account, USD Bonds. The fact they are from the "same" account is why both are showing up, even when you have "Omit zero balance figures". There is an embedded assumption of "one figure per account" which happens especially if sub-accounts get rolled up into the parent account. If you increase the level of subaccounts to 6 then that UST1 goes away. I agree, this is probably a bug. If you are rolling up subaccounts and have "omit zero balance figures" selected, it should, well, omit zero-balance figures, even if the rolled-up data contains non-zero-balance numbers. Please file a bug report in Bugzilla and attach the data file, screen shot, and this email exchange. Thanks, -derek On Sun, February 20, 2022 7:48 am, km22 wrote: Thanks Derek. Adding the screenshot here as an attachment. On 20/2/2022 20:45, Derek Atkins wrote: The example file made it through. The photo didn't. The reason is that the list strips html. So embedded images get stripped. Attachments do make it. -derek Sent using my mobile device. Please excuse any typos. On February 20, 2022 7:31:59 AM km22 wrote: P.S. I see that neither my screenshot nor example gnucash file seem to be accessible to the mailing list. Pls let me know how best to share both of these. Thanks ___ 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. ___ 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] Why does the balance sheet report list positions with zero balances?
Thank you. Submitted here: https://bugs.gnucash.org/show_bug.cgi?id=798461 On 20/2/2022 22:10, Derek Atkins wrote: Hi, I just opened the account file you sent, ran the balance sheet, and then expanded the default account depth from to 4. When I did that I noticed that the two lines you sent: 2,000 UST2 $1,960.00 0 UST1 $0.00 are BOTH from the same account, USD Bonds. The fact they are from the "same" account is why both are showing up, even when you have "Omit zero balance figures". There is an embedded assumption of "one figure per account" which happens especially if sub-accounts get rolled up into the parent account. If you increase the level of subaccounts to 6 then that UST1 goes away. I agree, this is probably a bug. If you are rolling up subaccounts and have "omit zero balance figures" selected, it should, well, omit zero-balance figures, even if the rolled-up data contains non-zero-balance numbers. Please file a bug report in Bugzilla and attach the data file, screen shot, and this email exchange. Thanks, -derek On Sun, February 20, 2022 7:48 am, km22 wrote: Thanks Derek. Adding the screenshot here as an attachment. On 20/2/2022 20:45, Derek Atkins wrote: The example file made it through. The photo didn't. The reason is that the list strips html. So embedded images get stripped. Attachments do make it. -derek Sent using my mobile device. Please excuse any typos. On February 20, 2022 7:31:59 AM km22 wrote: P.S. I see that neither my screenshot nor example gnucash file seem to be accessible to the mailing list. Pls let me know how best to share both of these. Thanks ___ 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. ___ 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] Why does the balance sheet report list positions with zero balances?
Thanks Derek. Adding the screenshot here as an attachment. On 20/2/2022 20:45, Derek Atkins wrote: The example file made it through. The photo didn't. The reason is that the list strips html. So embedded images get stripped. Attachments do make it. -derek Sent using my mobile device. Please excuse any typos. On February 20, 2022 7:31:59 AM km22 wrote: P.S. I see that neither my screenshot nor example gnucash file seem to be accessible to the mailing list. Pls let me know how best to share both of these. Thanks ___ 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. ___ 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] Why does the balance sheet report list positions with zero balances?
P.S. I see that neither my screenshot nor example gnucash file seem to be accessible to the mailing list. Pls let me know how best to share both of these. Thanks ___ 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.
[GNC] Why does the balance sheet report list positions with zero balances?
Hi, Following up on a post made here: https://money.stackexchange.com/questions/146779/gnucash-why-does-the-balance-sheet-report-list-positions-with-zero-balances It reads: I am using GnuCash 4.8. I have opened the "Balance Sheet" report and in Options deselected "Include accounts with zero total balances". I have a brokerage account that hold some stocks currently but has also held other stocks previously. The report is showing the previous stocks with a zero position. The expected behavior would be for the stocks with no holdings to not be displayed. Why is the report showing stocks with zero holdings - and how can I fix this? Attached is a simple example file. In the screenshot below you can see I have de-selected to "Include accounts with zero total balances" but the example security "UST1" still appears in the balance sheet with zero position size. How do I get the balance sheet report to not show securities with no position? Thanks, Ken balancesheet_zeros_example2.xml.gnucash Description: application/gnucash ___ 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] Convincing the balance sheet report to not show sold stocks...
I am also having this issue. I have a brokerage account and for each stock or bond I have set up a security and a "stock" account type for that security. Many of the positions have long been closed and reflect a zero balance in the register. However the "Balance Sheet" report is showing the row with 0 position despite me deselecting the option "Include accounts with zero total balances". I have chosen to select "Levels of subaccounts" to 4. When I change this number to 6 (the maximum) then some of the accounts with zero balances are no longer displayed (while some accounts more than 6 levels deep are still displayed with the zero balance). I therefore suspect the issue has to do with how the report chooses to show accounts that are deeper than the "Levels of subaccounts" selected. It would be nice if this issue could be fixed in the report logic. (I have no idea how to try to do this myself.) Thanks, Ken Maybe you're not managing your entries so that there is no residual value after all the shares are sold. The way I handle my capital gains/losses the stock asset accounts have no residual value. HTH Paul -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
[GNC] Lost all settings after Flatpak update
Hi, I am a Debian user and install Gnucash using Flatpak. I think Flatpak is setup to update automatically and the latest version of Gnucash seems to have been installed as of March 28th. When I started Gnucash I was presented with the typical popup tips and dialogs to set up a new user file from scratch. The system did not remember any of my recently used files. When I opened a recent gnucash file it loaded but all my settings are gone. For instance my tabs are all horizontal at the top of the screen rather than vertically to the left. Do you know whether it is normal for Flatpak updates to case user settings to be lost? Is there a way to restore my previous settings? Thanks, Ken ___ 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] How to install Gnucash 3.8 on Debian 10 "buster"?
Hi Frank, Thanks for the link to backports. I was not aware of this and it appears more appropriate than the testing repo. Much appreciated! Thanks, Ken On 27/4/2020 9:34 am, Frank H. Ellenberger wrote: Hi, Am 26.04.20 um 17:33 schrieb John Ralls: GnuCash doesn't care what python it's linked against as long as it's >= 3.2.0. The Debian packager linked GnuCash 3.10 against python 3.8 and set it as a requirement in the .deb because that's what's on a fully up to date Debian testing. If you're fearful of updates breaking your system you should use only Debian stable. The whole point of testing is to try out version upgrades to see what breaks. Regards, John Ralls a compromise would be to use backports: https://wiki.gnucash.org/wiki/Debian#About_Debian_Releases_and_Release_Names HTH Frank ___ 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] How to install Gnucash 3.8 on Debian 10 "buster"?
As a follow up I have been running Gnucash 3.8 from the Debian testing repo for a few months now. I recently tried to update but get these results: [Quote1] $ sudo apt list --upgradable ... gnucash-common/testing 1:3.10-1 all [upgradable from: 1:3.8b-1] gnucash/testing 1:3.10-1 amd64 [upgradable from: 1:3.8b-1+b1] ... [/Quote1] [Quote2] $ sudo apt install gnucash Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: gnucash : Depends: libpython3.8 (>= 3.8.2) but it is not going to be installed E: Unable to correct problems, you have held broken packages. [/Quote2] Question: Is it normal for gnucash to change its Python version (here to version 3.8) within a maintenance update (here to gnucash version 3.10)? I ask because I am hesitant to update my python version for fear of breaking my system - but just wanted to highlight whether this increase in Python version is expected within the Gnucash version guidelines? Thanks, Ken On 12/3/2020 10:48 pm, km22 wrote: As a follow up, what I did is the following to update to 3.8 on my Debian 10 system: 1) Created a file /etc/apt/apt.conf with the line: APT::Default-Release "buster"; 2) Ran sudo apt update. Then ran apt -t testing install gnucash From the /var/log/apt/history.log file these were the packages that were installed/updated: Start-Date: 2020-03-10 00:14:47 Commandline: apt -t testing install gnucash Requested-By: ken (1000) Install: libgwenhywfar79:amd64 (5.1.3-1, automatic), gcc-10-base:amd64 (10-20200222-1, automatic), libhogweed5:amd64 (3.5.1+really3.5.1-2, automatic), libgcc-s1:amd64 (10-20200222-1, automatic), libnettle7:amd64 (3.5.1+really3.5.1-2, automatic), libffi7:amd64 (3.3-3, automatic), libaqbanking44:amd64 (6.0.1-2, automatic), libgwengui-gtk3-0:amd64 (5.1.3-1, automatic) Upgrade: cryptsetup-initramfs:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3), libgwenhywfar-data:amd64 (4.20.0-9, 5.1.3-1), cryptsetup-run:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3), p11-kit-modules:amd64 (0.23.15-2, 0.23.20-1), gnucash:amd64 (1:3.4-1+b10, 1:3.8b-1+b1), libboost-regex1.67.0:amd64 (1.67.0-13+deb10u1, 1.67.0-17), libaqbanking-data:amd64 (5.7.8-3, 6.0.1-2), libgnutls30:amd64 (3.6.7-4+deb10u2, 3.6.12-2), libp11-kit0:amd64 (0.23.15-2, 0.23.20-1), gnucash-common:amd64 (1:3.4-1, 1:3.8b-1), libtasn1-6:amd64 (4.13-3, 4.16.0-2), libstdc++6:amd64 (8.3.0-6, 10-20200222-1), cryptsetup:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3), libxmlsec1:amd64 (1.2.27-2, 1.2.28-2) End-Date: 2020-03-10 00:15:13 Question I have is why was it necessary for gnucash to install packages from the testing repo for packages such as cryptsetup (various) or gcc-10-base? Are these really necessary for gnucash? I want to maintain a system as close to the base Debian 10 as possible so curious to understand why these other packages were required? Thanks, Ken On 8/3/2020 11:09 pm, km22 wrote: Hi all, Can anyone advise a very simple and safe way of install gnucash 3.8 in Debian 10? I've read posts like this: https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debian-testing-or-unstable-on-stable But I am very reluctant to start messing with things like pinning or temporarily enabling testing repo entirely for fear of breaking my system. Is there a simple way to install just gnucash 3.8 and dependencies as a one-off without making riskier changes to my system? Thanks, Ken On 2/3/2020 11:29 pm, km22 wrote: Hi Andrea, Thanks for the message. Do you know whether there is a simple command line operation I can run to install Gnucash 3.8 from Debian 10 testing repo? I tried to google the solution but what I found seemed to suggest a lot of modifications to the sources file or introducing a pinning concept. I only want to install this one package (and the necessary dependencies) from testing, ideally without messing with the /etc/ files. Thanks, Ken On 2/3/2020 2:08 am, Andrea Borgia wrote: Il 01/03/20 16:39, km22 ha scritto: I recently moved from Windows 7 (due to end of life) to Debian 10. I have gnucash 3.4 installed from the standard repo. However I think this version contains a bug as I cannot see any of the historical FX prices I stored in the Price Database. I think I need to move to a more recent version. I saw this wiki article: https://wiki.gnucash.org/wiki/Debian but no clues there on how to install the latest version 3.8. Can anyone here advise? Hi, Ken. If you're comfortable with using the "testing" distribution, then GC 3.8 is already included, I am using it now. If you prefer to continue using the "stable" dis
Re: [GNC] How to install Gnucash 3.8 on Debian 10 "buster"?
As a follow up, what I did is the following to update to 3.8 on my Debian 10 system: 1) Created a file /etc/apt/apt.conf with the line: APT::Default-Release "buster"; 2) Ran sudo apt update. Then ran apt -t testing install gnucash From the /var/log/apt/history.log file these were the packages that were installed/updated: Start-Date: 2020-03-10 00:14:47 Commandline: apt -t testing install gnucash Requested-By: ken (1000) Install: libgwenhywfar79:amd64 (5.1.3-1, automatic), gcc-10-base:amd64 (10-20200222-1, automatic), libhogweed5:amd64 (3.5.1+really3.5.1-2, automatic), libgcc-s1:amd64 (10-20200222-1, automatic), libnettle7:amd64 (3.5.1+really3.5.1-2, automatic), libffi7:amd64 (3.3-3, automatic), libaqbanking44:amd64 (6.0.1-2, automatic), libgwengui-gtk3-0:amd64 (5.1.3-1, automatic) Upgrade: cryptsetup-initramfs:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3), libgwenhywfar-data:amd64 (4.20.0-9, 5.1.3-1), cryptsetup-run:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3), p11-kit-modules:amd64 (0.23.15-2, 0.23.20-1), gnucash:amd64 (1:3.4-1+b10, 1:3.8b-1+b1), libboost-regex1.67.0:amd64 (1.67.0-13+deb10u1, 1.67.0-17), libaqbanking-data:amd64 (5.7.8-3, 6.0.1-2), libgnutls30:amd64 (3.6.7-4+deb10u2, 3.6.12-2), libp11-kit0:amd64 (0.23.15-2, 0.23.20-1), gnucash-common:amd64 (1:3.4-1, 1:3.8b-1), libtasn1-6:amd64 (4.13-3, 4.16.0-2), libstdc++6:amd64 (8.3.0-6, 10-20200222-1), cryptsetup:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3), libxmlsec1:amd64 (1.2.27-2, 1.2.28-2) End-Date: 2020-03-10 00:15:13 Question I have is why was it necessary for gnucash to install packages from the testing repo for packages such as cryptsetup (various) or gcc-10-base? Are these really necessary for gnucash? I want to maintain a system as close to the base Debian 10 as possible so curious to understand why these other packages were required? Thanks, Ken On 8/3/2020 11:09 pm, km22 wrote: Hi all, Can anyone advise a very simple and safe way of install gnucash 3.8 in Debian 10? I've read posts like this: https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debian-testing-or-unstable-on-stable But I am very reluctant to start messing with things like pinning or temporarily enabling testing repo entirely for fear of breaking my system. Is there a simple way to install just gnucash 3.8 and dependencies as a one-off without making riskier changes to my system? Thanks, Ken On 2/3/2020 11:29 pm, km22 wrote: Hi Andrea, Thanks for the message. Do you know whether there is a simple command line operation I can run to install Gnucash 3.8 from Debian 10 testing repo? I tried to google the solution but what I found seemed to suggest a lot of modifications to the sources file or introducing a pinning concept. I only want to install this one package (and the necessary dependencies) from testing, ideally without messing with the /etc/ files. Thanks, Ken On 2/3/2020 2:08 am, Andrea Borgia wrote: Il 01/03/20 16:39, km22 ha scritto: I recently moved from Windows 7 (due to end of life) to Debian 10. I have gnucash 3.4 installed from the standard repo. However I think this version contains a bug as I cannot see any of the historical FX prices I stored in the Price Database. I think I need to move to a more recent version. I saw this wiki article: https://wiki.gnucash.org/wiki/Debian but no clues there on how to install the latest version 3.8. Can anyone here advise? Hi, Ken. If you're comfortable with using the "testing" distribution, then GC 3.8 is already included, I am using it now. If you prefer to continue using the "stable" distribution of Debian, then you could try the "flatpak" version of GC, available here: https://flathub.org/apps/details/org.gnucash.GnuCash How to use Flatpak on Debian: https://flatpak.org/setup/Debian/ Regards, Andrea. ___ 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] How to install Gnucash 3.8 on Debian 10 "buster"?
Hi all, Can anyone advise a very simple and safe way of install gnucash 3.8 in Debian 10? I've read posts like this: https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debian-testing-or-unstable-on-stable But I am very reluctant to start messing with things like pinning or temporarily enabling testing repo entirely for fear of breaking my system. Is there a simple way to install just gnucash 3.8 and dependencies as a one-off without making riskier changes to my system? Thanks, Ken On 2/3/2020 11:29 pm, km22 wrote: Hi Andrea, Thanks for the message. Do you know whether there is a simple command line operation I can run to install Gnucash 3.8 from Debian 10 testing repo? I tried to google the solution but what I found seemed to suggest a lot of modifications to the sources file or introducing a pinning concept. I only want to install this one package (and the necessary dependencies) from testing, ideally without messing with the /etc/ files. Thanks, Ken On 2/3/2020 2:08 am, Andrea Borgia wrote: Il 01/03/20 16:39, km22 ha scritto: I recently moved from Windows 7 (due to end of life) to Debian 10. I have gnucash 3.4 installed from the standard repo. However I think this version contains a bug as I cannot see any of the historical FX prices I stored in the Price Database. I think I need to move to a more recent version. I saw this wiki article: https://wiki.gnucash.org/wiki/Debian but no clues there on how to install the latest version 3.8. Can anyone here advise? Hi, Ken. If you're comfortable with using the "testing" distribution, then GC 3.8 is already included, I am using it now. If you prefer to continue using the "stable" distribution of Debian, then you could try the "flatpak" version of GC, available here: https://flathub.org/apps/details/org.gnucash.GnuCash How to use Flatpak on Debian: https://flatpak.org/setup/Debian/ Regards, Andrea. ___ 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] How to install Gnucash 3.8 on Debian 10 "buster"?
P.S. I believe this is the bug in 3.4: https://bugs.gnucash.org/show_bug.cgi?id=797046 It is too bad there isn't a way for Debian's stable release to get bug fixes so that the stable version in the repo remains the most reliable version. Seems the current model means that users are stuck with whichever version is baked into the stable repo - warts and all. On 2/3/2020 11:29 pm, km22 wrote: Hi Andrea, Thanks for the message. Do you know whether there is a simple command line operation I can run to install Gnucash 3.8 from Debian 10 testing repo? I tried to google the solution but what I found seemed to suggest a lot of modifications to the sources file or introducing a pinning concept. I only want to install this one package (and the necessary dependencies) from testing, ideally without messing with the /etc/ files. Thanks, Ken On 2/3/2020 2:08 am, Andrea Borgia wrote: Il 01/03/20 16:39, km22 ha scritto: I recently moved from Windows 7 (due to end of life) to Debian 10. I have gnucash 3.4 installed from the standard repo. However I think this version contains a bug as I cannot see any of the historical FX prices I stored in the Price Database. I think I need to move to a more recent version. I saw this wiki article: https://wiki.gnucash.org/wiki/Debian but no clues there on how to install the latest version 3.8. Can anyone here advise? Hi, Ken. If you're comfortable with using the "testing" distribution, then GC 3.8 is already included, I am using it now. If you prefer to continue using the "stable" distribution of Debian, then you could try the "flatpak" version of GC, available here: https://flathub.org/apps/details/org.gnucash.GnuCash How to use Flatpak on Debian: https://flatpak.org/setup/Debian/ Regards, Andrea. ___ 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] How to install Gnucash 3.8 on Debian 10 "buster"?
Hi Andrea, Thanks for the message. Do you know whether there is a simple command line operation I can run to install Gnucash 3.8 from Debian 10 testing repo? I tried to google the solution but what I found seemed to suggest a lot of modifications to the sources file or introducing a pinning concept. I only want to install this one package (and the necessary dependencies) from testing, ideally without messing with the /etc/ files. Thanks, Ken On 2/3/2020 2:08 am, Andrea Borgia wrote: Il 01/03/20 16:39, km22 ha scritto: I recently moved from Windows 7 (due to end of life) to Debian 10. I have gnucash 3.4 installed from the standard repo. However I think this version contains a bug as I cannot see any of the historical FX prices I stored in the Price Database. I think I need to move to a more recent version. I saw this wiki article: https://wiki.gnucash.org/wiki/Debian but no clues there on how to install the latest version 3.8. Can anyone here advise? Hi, Ken. If you're comfortable with using the "testing" distribution, then GC 3.8 is already included, I am using it now. If you prefer to continue using the "stable" distribution of Debian, then you could try the "flatpak" version of GC, available here: https://flathub.org/apps/details/org.gnucash.GnuCash How to use Flatpak on Debian: https://flatpak.org/setup/Debian/ Regards, Andrea. ___ 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.
[GNC] How to install Gnucash 3.8 on Debian 10 "buster"?
Hi, I recently moved from Windows 7 (due to end of life) to Debian 10. I have gnucash 3.4 installed from the standard repo. However I think this version contains a bug as I cannot see any of the historical FX prices I stored in the Price Database. I think I need to move to a more recent version. I saw this wiki article: https://wiki.gnucash.org/wiki/Debian but no clues there on how to install the latest version 3.8. Can anyone here advise? Thanks, Ken ___ 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] Custom Reports in GnuCash 3.x on Windows
Hi Tim, I saw that filename in the wiki and tried it too but unfortunately it didn't solve the issue of my custom report being added to the reports menu. Thanks, Ken On October 21, 2018 1:10:54 PM UTC, Tim Quinn wrote: >I believe the file name changed from config.user to config-user.scm, >maybe back in 2.6 but I’m not sure of the specific version. > >- Tim > >> On Oct 21, 2018, at 6:27 AM, km22 wrote: >> >> Hi GnuCash Community, >> >> Is the wiki on Custom Reports >> (https://wiki.gnucash.org/wiki/Custom_Reports) up-to-date for GnuCash >> version 3.x series? >> I tried making custom reports back in the 2.6 series and was able to >> load my custom report saved to C:\Users\Ken\.gnucash. I am >revisiting >> this now but cannot seem to get my report to load in the 3.x series. >> Note: I have a config.user file with the line (load >> (gnc-build-userdata-path "balsheet-egken.scm")) in it -- but I cannot >> tell whether this file is being parsed and/or whether the report is >> being loaded. >> Please advise if anything has changed which makes the wiki no longer >> relevant for the 3.x version or any tips on how I can debug this on >Windows. >> >> Thanks, >> Ken >> >> >> ___ >> 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. ___ 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.
[GNC] Custom Reports in GnuCash 3.x on Windows
Hi GnuCash Community, Is the wiki on Custom Reports (https://wiki.gnucash.org/wiki/Custom_Reports) up-to-date for GnuCash version 3.x series? I tried making custom reports back in the 2.6 series and was able to load my custom report saved to C:\Users\Ken\.gnucash. I am revisiting this now but cannot seem to get my report to load in the 3.x series. Note: I have a config.user file with the line (load (gnc-build-userdata-path "balsheet-egken.scm")) in it -- but I cannot tell whether this file is being parsed and/or whether the report is being loaded. Please advise if anything has changed which makes the wiki no longer relevant for the 3.x version or any tips on how I can debug this on Windows. Thanks, Ken ___ 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: Gnucash 3.0 Microsoft Security Essentials Threat Detected
Thanks David C. And I see this topic is already being discussed in a separate thread: http://gnucash.1415818.n4.nabble.com/virus-download-version-3-0-tp4698720p4698799.html Thanks, Ken On 2018-04-04 22:02, David Carlson wrote: > This has been reported to Microsoft. > > David C > > On Wed, Apr 4, 2018 at 7:53 AM, km22 <mailto:k...@gmx.com>> wrote: > > Hi, > > When I try to download Gnucash 3.0 I get a Microsoft Security > Essentials > (MSE) threat detection which then deletes the file. > > Screenshot: > > Is there a way for the developers to have this file correctly > categorized/assessed by MSE? It is worrying to see these pop-ups (and > probably the first time I have seen one and hence why I want to be > very > careful.) What is the best way for a user to self-assess (i.e. confirm > the file is not a real threat) and proceed with the > download/installation? > > Thanks, > > Ken > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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. > > ___ 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.
Gnucash 3.0 Microsoft Security Essentials Threat Detected
Hi, When I try to download Gnucash 3.0 I get a Microsoft Security Essentials (MSE) threat detection which then deletes the file. Screenshot: Is there a way for the developers to have this file correctly categorized/assessed by MSE? It is worrying to see these pop-ups (and probably the first time I have seen one and hence why I want to be very careful.) What is the best way for a user to self-assess (i.e. confirm the file is not a real threat) and proceed with the download/installation? Thanks, Ken ___ 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.
Reports with Month-end rather that Month-start
Hi Gnucash community, I want to start editing -- and eventually creating -- my own reports and figures. I think one place for me to start learning is by playing with some existing report settings -- such as the report date functionality. Currently when I run a report with a "monthly" period I get the 1st day of each month. How could I edit the report settings so I get the last day of each month instead? (I am a Windows 7 user if that makes a difference on where to find/edit files.) Thanks, Ken ___ gnucash-user mailing list gnucash-user@gnucash.org 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.