Re: [GNC] Billing Terms Editor not "sticky"
I am running release 4.8 on Windows 10 and that is precisely how it works. [I say 'precisely' but the date calculation is off by one in my reckoning. Net 45 terms for an invoice dated 10 Oct should have a due date of 24 Nov according to most date calculators, but GnuCash calculates the 23rd.] If you've double-checked that the billing terms are correctly set in the client's record, then it may be that the terms have been incorrectly defined. It won't matter what the terms description reads if the 'due days' entry is wrong. -Original Message- From: Benjamin Soffer Sent: Friday, October 8, 2021 5:44 PM To: john.lay...@laymanandlayman.com; gnucash-user@gnucash.org Subject: RE: [GNC] Billing Terms Editor not "sticky" Yes, you would think that's how it would work. But, in fact, it does now. When I post the invoice, it ignores the entry in the Billing Terms table. Benjamin E. Soffer | THE SOFFER LAW FIRM PC T 818.963.8998 21550 Oxnard Street, Suite 300 Woodland Hills, CA 91367-7109 www.soffer-law.com ___ NOTICE: This communication may contain privileged or other confidential information. If you have received it in error, please advise me, the sender, by reply email and immediately delete the message and any attachments (including from your "Deleted Items" or "Trash" folder) without copying or disclosing the contents. Thank you. -----Original Message- From: John Layman [mailto:john.lay...@laymanandlayman.com] Sent: 10/04/2021 11:55 AM To: Benjamin Soffer ; gnucash-user@gnucash.org Subject: RE: [GNC] Billing Terms Editor not "sticky" The Billing Terms Editor merely allows you to maintain a table of differing terms. When an invoice is posted, the applicable terms are those specified in the Customer (or Vendor) record, which refers to an entry in the Billing Terms table. -Original Message- From: gnucash-user On Behalf Of Benjamin Soffer Sent: Monday, October 4, 2021 1:10 PM To: gnucash-user@gnucash.org Subject: [GNC] Billing Terms Editor not "sticky" Hello, I am using version 3.8 for Windows. When I set the invoice "due" period in the Billing Terms Editor (for example 15 days), the system does not "remember" this setting when I post a new invoice. The due date remains the same as the post date, by default. Any suggestions? Ben ___ 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] Cannot restore backup from mobile app
> On Oct 5, 2021, at 8:06 AM, Eric H. Bowen via gnucash-user > wrote: > > I began making restaurant deliveries last night and I was using the > GnuCash mobile app to record cash transactions. This morning I wanted to > export them to the main GnuCash program as a .qif file. Well, there was > a download glitch and the .qif file was lost. I had selected the "delete > transactions after export" option so they're now erased from the mobile app. > > I've tried to go back into the "Backup and Restore" menu on the app and > selected "Restore most recent backup", but I get the error message, "An > error occurred while importing the GnuCash accounts: At line 1, column > 0, not well formed (invalid token)." > > So far it's just one day's lost data, but how should I proceed in future? Don't use the delete after export option, I suppose. But maybe reconsider using GnuCash for Android at all because it hasn't been maintained for 3 years or so, its author having moved on to other interests. Regards, John Ralls ___ 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] Billing Terms Editor not "sticky"
The Billing Terms Editor merely allows you to maintain a table of differing terms. When an invoice is posted, the applicable terms are those specified in the Customer (or Vendor) record, which refers to an entry in the Billing Terms table. -Original Message- From: gnucash-user On Behalf Of Benjamin Soffer Sent: Monday, October 4, 2021 1:10 PM To: gnucash-user@gnucash.org Subject: [GNC] Billing Terms Editor not "sticky" Hello, I am using version 3.8 for Windows. When I set the invoice "due" period in the Billing Terms Editor (for example 15 days), the system does not "remember" this setting when I post a new invoice. The due date remains the same as the post date, by default. Any suggestions? Ben ___ 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] Upgrade installation question
> On Oct 4, 2021, at 5:03 PM, Gerry Starnes wrote: > > Re: Gnucash on Mac OS Big Sur > I recently upgraded from 3.7 to 4.7. I downloaded the DMG, opened it and > there were several files, including the Gnucash program. I dragged the > program file directly into the Go > Applications directory and it ran. The > problem is that it is still connected to the Gnucash-4.7 volume. If I put > that in the trash, Gnucash won't run. > > When I restarted the computer due to another unrelated issue, I had to dig > the Gnucash DMG out of the Downloads folder and run it again or the program > can't be found. > > There must be a step I'm missing, but I can't figure it out. Your help is > appreciated. Dunno what you mean by Go > Applications, but if it runs immediately it's not copying. Open another Finder window, navigate to Applications in that, and drag Gnucash from the dmg window to that window. It should pause for a couple of beats then put up a little box showing progress as it copies the app bundle to the Applications folder. When that finishes, eject the dmg and launch GnuCash from the other Finder window. Regards, John Ralls ___ 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] Cannot get current version from Flathub on Raspbian OS
> On Oct 4, 2021, at 3:51 PM, Tommy Trussell wrote: > > On Sun, Sep 26, 2021 at 9:13 PM Colin <mailto:colinfar...@gmail.com>> wrote: > >> I apologize if I’m adding (yet another) newbie flatpak question to this >> list, but… >> >> I’ve got GnuCash installed on my Raspberry Pi 4 running the latest >> updates. I installed GnuCash, via Flathub, following the instructions on >> the GnuCash Wiki page. BUT I only got version 4.4. >> >> Running 'flatpack update’ does not help, as it shows no available updates. >> >> What am I missing? >> >> Thanks, >> Colin >> > > I think it's a great question! > > The short answer is GnuCash might not currently be being built for the Pi, > probably since version 4.4. (Unless it has appeared in the flatpak > repository since you asked.) > > Unfortunately I can't find an easy way to tell without digging out a Pi and > looking for myself. The flatpak commands only show what's available for the > host's architecture, which for me is x86_64, so I cannot see the Pi > packages at all. > > If there's a way to see all the architectures the repository contains > for GnuCash, that would make it much easier, but I don't know how. > > I hope someone sees this and can say what is getting built! If you look at the top commit at https://github.com/flathub/org.gnucash.GnuCash/ <https://github.com/flathub/org.gnucash.GnuCash/> you'll see a little green check next to it. Hover on that check and it shows the three GitHub Actions that drive flathub publishing. They're build-aarch64, build-x86_64, and download-sources. All passed, meaning that there's an aarch64 build floating around somewhere, but all of the steps past pushing to that repo are automatic and somewhat opaque. Regards, John Ralls ___ 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] Scheduled transactions do not appear in the register until is pressed
> On Oct 4, 2021, at 2:18 PM, David H wrote: > > The only thing I'm not sure about is what the difference is between clicking > Cancel and clicking OK on the popup as I get the txns regardless :-) Probably because all of your transactions are set to create automatically, so the SLR is just telling you that they've been created. Regards, John Ralls ___ 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] Scheduled transactions do not appear in the register until is pressed
Sure, it will help me not forget. Do a good search first to make sure there isn't one already. If you find one put a comment on it that it's still a problem with 4.8. Regards, John Ralls > On Oct 4, 2021, at 6:34 AM, Glenn Fowler wrote: > > Everyone, > > Should I open a bug report? I would think that looking at an incorrect > register would be deemed a bug and not a feature request. > > On Sun, Oct 3, 2021 at 8:03 PM Christina Martin > wrote: > >> I agree Glenn. It used to do so. >> >> Regards, >> Christina >> >> *Christina Martin* >> Sent from my device, please excuse any typo's. >> >> On 4 October 2021 1:27:12 am Glenn Fowler wrote: >> >>> Hi Christina, >>> >>> What you described is the same issue. The only difference is I am >>> pressing and you are closing and reopening the register for the >>> scheduled transactions to appear. >>> >>> The expected behaviour should be for the scheduled transactions to appear >>> without user input in the register. >>> >>> On Sat, Oct 2, 2021 at 10:17 PM Christina Martin < >>> christ...@airgeadstudio.net> wrote: >>> >>>> I have a similar problem, although I haven't tried entering a blank txn. >>>> Another user reported something similar back in February and I tried to >>>> add >>>> my $0.02 worth at the time, but two messages I sent didn't get through. >>>> >>>> In a nutshell, I save the registry, close and reopen it and the txns >>>> show up. >>>> >>>> Below is a copy of the information I tried to send in Feb, setting out >>>> the >>>> testing I had done. >>>> >>>> "I tried to send this response to the list 2 days ago, but I haven't >>>> seen >>>> it come in on the digest, so I must have done something wrong. >>>> >>>> >>>> >>>> >>>> I finally had time to sit down and do some testing and I'm covering >>>> things >>>> raised and suggested in a variety of digests up to Wed 10/2. >>>> >>>> >>>> >>>> >>>> This odd behaviour started when I was using the previous version, and I >>>> hoped that the upgrade to the 4.x series would fix it. I *think* I was >>>> still on 2.x when I upgraded last year, but I can't be certain of that >>>> (the >>>> manual update process means I tend to leave it for a while). For a >>>> variety >>>> of reasons that I don't wish to get into now, I decided to start a new >>>> file >>>> for the start of the Australian financial year on 1 July 2020. I can't >>>> remember exactly what I did except that it involved a blank copy of the >>>> original account tree. I then manually created all my scheduled >>>> transactions to match the original file. I don't know if that means that >>>> I've somehow imported an old error. >>>> >>>> >>>> >>>> >>>> I'm running GC 4.2 (build 4.2+(2020-09-26) on Windows 10 Home 64 bit OS >>>> (build 19041.746). The only filters I have set are to hide reconciled >>>> txns >>>> in each register, and the financial year for Australia. >>>> >>>> >>>> >>>> >>>> The first thing I've noticed is that I don't need to fully close GC to >>>> get >>>> the scheduled txns to display - closing and reopening the account is >>>> sufficient. I tend to keep all 4 personal accounts open all the time >>>> inside >>>> GC, so I guess I'd potentially have to close and reopen all 4, in which >>>> case, closing and reopening the entire file is easier. >>>> >>>> >>>> >>>> >>>> I have created a new scheduled txn from a dummy txn in my register. I >>>> left >>>> "Notify me when created ticked". I saved the file and then ran Actions >>>> -> >>>> Scheduled Txns -> Since Last Run... I cancelled the Since Last Run >>>> window >>>> that popped up. The txns did not display until I closed and reopened the >>>> account register although I could see that the balance in the register >>>> changed where the next txn should be showing up. When I click on OK at >>>> the >>>> Since Last Run window, the full details of the scheduled txns >&g
Re: [GNC] Build 4.8 docs issue
That seems to be about the formats that are accepted through their KDP publishing service, not the readers themselves, and that if one wants one's book to be usable on e-ink Kindles like Arthur's the choices are now plain text or PDF. We don't use that service so it's a bit irrelevant, isn't it? Regards, John Ralls > On Oct 4, 2021, at 8:16 AM, Dale Alspach wrote: > > An explanation of the *conversion process* used by Amazon for kindle is > given here https://kdp.amazon.com/en_US/help/topic/G200634390. > Note that MOBI is not supported for new documents. > > Dale > > > On Sun, Oct 3, 2021 at 9:32 PM A Harvey wrote: > >> Addressing the messages in reverse order. >> I should have been more precise. All my comments have assumed the user has >> an Kindle e-reader, i.e. "Kindle", "Kindle Paperwhite" or "Kindle Oasis". >> I thought the "Kindle Fire" was or is a tablet, not just an e-reader. I >> know very little about the Fire. I think it has a color display and does >> stuff one might expect a tablet to do including download and run apps. >> >> With respect to how to get documents onto a Kindle, either of the methods I >> briefly described will work for any format supported by the Kindle. I have >> a bunch of books I bought from a non-Amazon site that lets one download a >> purchased book in multiple formats. This site offers PDF, ePub and MOBI. >> I uploaded books in all 3 formats (including ePub) from my PC to my Amazon >> account by emailing the books, as attachments, to the email address >> supplied by Amazon for that purpose. My Kindle will display all of these >> in the list of documents for my personal library. WiFi connection >> required, of course. If I want to read them, I can download them from my >> library at Amazon to my Kindle device over the network. They remain stored >> on the device until I decide to remove them. I can read the PDF version, >> with some pain as I mentioned. I can read the MOBI version without any >> trouble. If I try to read the ePub, I get an error essentially telling me >> it can't decipher that. >> >> I have also loaded various format docs from my PC to my Kindle via a USB >> cable. I find the email method to be much easier and faster than >> connecting the device to my PC. Also, I can load the books from my library >> to the Android Kindle app and to the Windows app in the same way as I do >> for the Kindle device. >> >> With respect to handling HTML as a document, it works fine if there is only >> a *single* HTML file with no other files required. I don't think this >> would work very well for the GNC documentation if it requires any other >> files of any type including HTML or a directory structure. I think >> Amazon has a section on its web site with information for authors. I have >> not looked at this and don't know if it has suggestions that would help for >> the GNC documentation. >> >> Regarding Amazon dropping MOBI, I hadn't heard about Amazon dropping MOBI >> support from their readers. There would be a large number of pissed-off >> people who bought content from Amazon in MOBI years ago. I'm guessing they >> require any new books that are sold through Amazon to be one of the AZW >> formats as I think they have better formatting capabilities and make it >> harder to remove DRM. I haven't investigated that carefully so don't quote >> me. >> >> I tried the link from flywire >> https://gnucash-docs-rst.readthedocs.io/en/latest/index.html >> in the "Experimental Browser" (I'm thinking that the browser has been >> around maybe 10 or more years. An endless experiment). I was happy that >> it loaded more quickly than I expected. Most of my time was spent trying >> to correctly type the url. Using links to navigate worked fine. One must >> remember that the Kindle display is black and white only so everything is >> grayscale. Also, it has the same size issue as does PDF. The entire page >> is loaded and the only way to enlarge text is by zooming in. No reflow of >> that document. >> >> I also loaded a single HTML document to the device and displayed it as I >> would any other book . It works fine. Text reflows and it follows links to >> locations that are within the document. >> >> Hope some of this information proves useful. >> -Arthur >> >> >> >> On Sun, Oct 3, 2021 at 7:24 PM D. wrote: >> >>> The app question depends on the type of Kindle you're using. The Fire has >>> supported apps in the past, but more bare bones Kindles don
[GNC] Invoicing
I have not used the invoice sections of GnuCash for some time. The work done since that time up to version 4.8 has been astounding and of course caused me to go through quite a learning curve. I have a few questions: I believe the only header images that are appropriate for stylesheets are 100dpi png formats up to 15cm wide. Is this correct? I experienced quite a few adventures working this out. Is there a better method available for working with images in stylesheets besides trial and error? I was able to make up a custom stylesheet and get a satisfactory invoice template. However, it did not save when I shut down Gnucash. What am I doing wrong? Is there any documentation concerning the CSS-based stylesheet (experimental)? Is this an area a mug punter like myself should be playing with? Cheers John ___ 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] Build 4.8 docs issue
Don't you have to connect your Kindle to a PC in order to install the docs in MOBI format too? How would we package the html, which is a few dozen files with a directory structure, so that it's easy to install into the Kindle? That question is mostly from curiosity. It seems that we got bad information and we should continue to provide MOBI downloads. Regards, John Ralls > On Oct 3, 2021, at 12:30 PM, A Harvey wrote: > > Flywire and D. > Thanks for the suggestions. I will try them tonight and report back. > > The Kindle has what Amazon calls the "Experimental Browser". I have tried > it a few times in the past just to see what it's like. What it's like is > pouring molasses, but it works. I will try entering the link in the Kindle > browser. I will also try to display an HTML document loaded to my Kindle > to compare the speed. I assume that would be much faster. To get an HTML > document to a Kindle, I either have to email it to an address that is > unique to my account which will store it with the rest of my docs on an > Amazon server, or plug my Kindle into a PC and copy the document from the > PC to the Kindle. > > With respect to downloading an app, I don't think the Kindle supports apps > of any kind. I should say I have never seen any downloadable apps on Amazon > or on the web. I have seen a few grumbles about Kindle not having > downloadable games. > -Arthur > > On Sun, Oct 3, 2021 at 9:29 AM D. via gnucash-user > wrote: > >> If Arthur can load the html in your link on his Kindle, he could install >> an epub app (such as Overdrive) and get his flow going using that. >> >> >> Original Message >> From: flywire >> Sent: Sun Oct 03 07:25:44 EDT 2021 >> To: Gnucash Users >> Subject: [GNC] Build 4.8 docs issue >> >> Arthur, that's a nice summary of a >> https://en.wikipedia.org/wiki/Reflowable_document >> >> The issue has been raised and >> https://gnucash-docs-rst.readthedocs.io/en/latest/index.html was >> offered as a format. Does it work on a Kindle? >> ___ >> 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. >> > ___ > 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] OFX Import with Investment Transactions
That sounds like https://bugs.gnucash.org/show_bug.cgi?id=798208 <https://bugs.gnucash.org/show_bug.cgi?id=798208>, which is fixed in GnuCash 4.8. Regards, John Ralls > On Oct 3, 2021, at 9:19 AM, Robin Chattopadhyay wrote: > > Yes, I'm familiar with that issue as well as my spouse's 401K OFX has fee > transactions where shares are sold to pay plan expenses, but those > transactions appear only as cash withdrawals and the sale transactions do > not get imported. > > That one doesn't bother me as much because it's one transaction per month > vs 9 every two weeks. > > On Sun, Oct 3, 2021 at 11:04 AM Kalpesh Patel wrote: > >> The issues that you are seeing I believe has to do with changes that OFX >> introduced in libofx which has been included since 4.5 and above version of >> GnuCash. FWIW, I am running on Windows 10 Pro desktop but that likely >> doesn't matter when it comes to core functionality. >> >> I also had problems where some of transactions would not get imported in >> from an OFX file and these transactions I deduced from trial and error are >> specifically if they are related to deposit and withdrawal of cash in Stock >> or Mutual Fund account. I am not sure if this is the behavior on your end >> or >> not but it sounds like it. This might be because libofx author may have >> changed philosophy and its implementation where cash in and out are not >> considered investment transactions such as buy and sell of a stock, bond, >> mutual fund, etc. >> >> Because of that I have stayed at GnuCash 4.4 (specifically Build ID: >> 4.4+(2020-12-28) for Windows) which I have known to properly import >> brokerage created OFX files for import. I've reached out to the author of >> libofx for understanding and I am still waiting to hear back from them. >> >> It may be worth a shot to install that version and see if it imports OFX >> correctly. If you have a blank file then it should ask for appropriate >> input >> via dialogue box such as creation of "securities", corresponding >> "brokerage" >> account, etc. You can then go back and edit those "security" and enable >> download of prices using Finance::Quote Perl module with yahoo_jason as the >> source for it if you want to automate it. >> >> For FWIW, GnuCash 4.5 on windows used to crash when 'Actions' --> 'Check & >> Repair' --> 'Check & Repair All' would be selected to run which I do now >> and >> then to make sure that my xml based file is in good shape (this is carry >> over habit from Quicken as it was known to corrupt files). >> >> This may not be the answer you are looking for but hope this helps a bit. >> >> Kalpesh... >> >> -- >> >> Message: 2 >> Date: Sat, 2 Oct 2021 10:58:44 -0500 >> From: Robin Chattopadhyay >> To: Gnucash Users >> Subject: [GNC] OFX Import with Investment Transactions >> Message-ID: >>> 7jjed1oqxw_jpqssxjx...@mail.gmail.com> >> Content-Type: text/plain; charset="UTF-8" >> >> Ubuntu 20.04 LTS (VMWare virtual machine in case that matters) Gnucash 4.8 >> libofx 0.9.15 >> >> I tried importing an OFX file from my 401K provider this morning and I got >> a >> message box that said it had imported 2 transactions for a single security >> in the file and there were no additional transactions to process. >> This was incorrect as there were 18 new transactions across nine securities >> (along with a number of other transactions that had already been imported >> previously). >> >> I tried a number of things to resolve (after taking a backup, of course): >> 1 - Tools > Import Map Editor and deleted all of the associations for this >> file. When I re-imported, I was prompted to map each security in the file >> to >> the correct account. No issues there. But when importing the OFX file >> again, >> I had the same experience as described above >> 2 - Created a blank file and attempted to import the file there. Through >> the >> import process, I created new securities and new accounts, nothing >> unexpected there. Then the generic transaction importer dialog popped up, >> but with just the two transactions for the same security cited in the >> original problem dialog. I imported those, clicked OK and then the generic >> transaction importer dialog came up *again* but only with transactions for >> a >> single, different security. I imported those and repeated the process for >> each security with transactions in the file. Eac
Re: [GNC] Build 4.8 docs issue
Interesting, thanks. Do you know if there's a discernible difference between how a Kindle displays a PDF and a MOBI? Regards, John Ralls > On Oct 2, 2021, at 7:55 PM, A Harvey wrote: > > Just a nit. I don't think Kindle devices support ePub, at least not in > recent models. I'm not sure whether the apps they have for PCs and phones. > I have a book in LPR format (whatever that is) that works on Kindle for PC > and Phone but not Kindle devices. > From the Amazon site: > Content Formats Supported > Kindle Format 8 (AZW3), Kindle (AZW), TXT, PDF, unprotected MOBI, PRC > natively; HTML DOC, DOCX, JPEG, GIF, PNG, PMP through conversion; Audible > audio format (AAX). > > > On Sat, Oct 2, 2021 at 6:07 PM john <mailto:jra...@ceridwen.us>> wrote: > It hasn't been a while since I last built mobi-formatted documents with Cmake > because I do so with every release and we just did one on Tuesday. It works > fine. > *However* the mobi format was a proprietary format devised by Amazon.com > <http://amazon.com/ <http://amazon.com/>> for their Kindle-branded readers > that they deprecated in 2019. We're planning to remove it from the build > system soon. You should be able to load the ePub documents into your Kindle. > > Regards, > John Ralls > > > On Oct 2, 2021, at 1:26 PM, Geert Janssens > <mailto:geert.gnuc...@kobaltwit.be>> wrote: > > > > Please remember to send replies to the list rather than individual users. > > Particularly if you are soliciting for answers from "anyone" ;) > > > > As to your problems, can you provide more details ? > > > > It's been a while since I tested the mobi format. Back then it worked > > fine, > > also with cmake. You have to enable it explicitly though by passing > > '-DWITH_MOBI=ON' to the cmake call. > > > > I wouldn't spend too much effort on it though. We're currently considering > > to > > drop that format. It has been abandoned by Amazon as well. > > > > Regards, > > > > Geert > > > > Op zaterdag 2 oktober 2021 19:40:30 CEST schreef Giuseppe Foti: > >> I am fighting with it too, trying to create a gentoo ebuild for it. > >> > >> At now I can build, html and epub. > >> > >> With pdf I have a sandbox access violation issue, > >> > >> Can anyone confirm that "mobi" can be built both for "help" and "guide" ? > >> > >> > >> > >> > >> Il 02/10/21 18:51, Geert Janssens ha scritto: > >> > >> Op zaterdag 2 oktober 2021 18:14:02 CEST schreef Mike Commissaris: > >> > >> Installing past versions of docs (ver 4.4) went smoothly. > >> With ver 4.8 docs build, starting the install from my script file ./ > >> gnucash-docs-4.8.sh <http://gnucash-docs-4.8.sh/> > >> I get an error at line 11: ./configure: No such file or directory > >> Sure enough, there is no configure script file in my 4.8 docs build > >> directory. > >> I have searched for answers but have not figured out how to build docs in > >> ver 4.8. > >> Any suggestions or pointer to documentation? > >> > >> The autotools based build system for gnucash-docs has been deprecated in > >> favor of the cmake based build system. > >> > >> In gnucash-docs 4.8, the bits to use autotools have been fully removed. > >> > >> The new way of building is summarized as follows: > >> > >> - create a build directory (eg 'build') next to your source directory > >> - cd build > >> - cmake ../ > >> - make > >> > >> If you used to set an installation prefix while running configure you may > >> want do to the equivalent for your cmake run. > >> The syntax is "-DCMAKE_INSTALL_PREFIX=" > >> > >> Regards, > >> > >> Geert > >> > >> > >> ___ > >> 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. > >> Y
Re: [GNC] Build 4.8 docs issue
It hasn't been a while since I last built mobi-formatted documents with Cmake because I do so with every release and we just did one on Tuesday. It works fine. *However* the mobi format was a proprietary format devised by Amazon.com <http://amazon.com/> for their Kindle-branded readers that they deprecated in 2019. We're planning to remove it from the build system soon. You should be able to load the ePub documents into your Kindle. Regards, John Ralls > On Oct 2, 2021, at 1:26 PM, Geert Janssens wrote: > > Please remember to send replies to the list rather than individual users. > Particularly if you are soliciting for answers from "anyone" ;) > > As to your problems, can you provide more details ? > > It's been a while since I tested the mobi format. Back then it worked fine, > also with cmake. You have to enable it explicitly though by passing > '-DWITH_MOBI=ON' to the cmake call. > > I wouldn't spend too much effort on it though. We're currently considering to > drop that format. It has been abandoned by Amazon as well. > > Regards, > > Geert > > Op zaterdag 2 oktober 2021 19:40:30 CEST schreef Giuseppe Foti: >> I am fighting with it too, trying to create a gentoo ebuild for it. >> >> At now I can build, html and epub. >> >> With pdf I have a sandbox access violation issue, >> >> Can anyone confirm that "mobi" can be built both for "help" and "guide" ? >> >> >> >> >> Il 02/10/21 18:51, Geert Janssens ha scritto: >> >> Op zaterdag 2 oktober 2021 18:14:02 CEST schreef Mike Commissaris: >> >> Installing past versions of docs (ver 4.4) went smoothly. >> With ver 4.8 docs build, starting the install from my script file ./ >> gnucash-docs-4.8.sh >> I get an error at line 11: ./configure: No such file or directory >> Sure enough, there is no configure script file in my 4.8 docs build >> directory. >> I have searched for answers but have not figured out how to build docs in >> ver 4.8. >> Any suggestions or pointer to documentation? >> >> The autotools based build system for gnucash-docs has been deprecated in >> favor of the cmake based build system. >> >> In gnucash-docs 4.8, the bits to use autotools have been fully removed. >> >> The new way of building is summarized as follows: >> >> - create a build directory (eg 'build') next to your source directory >> - cd build >> - cmake ../ >> - make >> >> If you used to set an installation prefix while running configure you may >> want do to the equivalent for your cmake run. >> The syntax is "-DCMAKE_INSTALL_PREFIX=" >> >> 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. > > > > > ___ > 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] Scheduled transactions do not appear in the register until is pressed
> On Oct 1, 2021, at 2:58 PM, Glenn Fowler wrote: > > Hello all, > > I have numerous scheduled transactions in multiple books and in settings > have them "run when the data file is opened". The transactions do run as > expected but do not appear in the register until you press . > With them not appearing, I am not looking at an out of date register until > I enter a transaction or press . Wouldn't it make sense for them to > appear without user input so we are looking at up-to-date books instead of > trying to create a habit for myself to click on every open? That's already possible, just set "create automatically" on the Overview page of the Scheduled Transactions Editor. Regards, John Ralls ___ 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] Monterey
> On Sep 29, 2021, at 4:18 PM, Alan Magnus wrote: > > > Will the latest build of Gnucash run on the forthcoming Apple Monterey? I just tested it on my M1 mini/macOS 12beta7 and it seems to work OK. Regards, John Ralls ___ 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] Gnucash 4.8 Build Fail
David Cousens reported that on the Devel list a few minutes ago. The
work-around is
edit gnucash/gschemas/CMakeLists.txt and change line 32 from
COMMAND ${CMAKE_COMMAND} -E cat ${gschema_migration_files} >
${DATADIR_BUILD}/${PROJECT_NAME}/migratable-prefs.xml
to
COMMAND cat ${gschema_migration_files} >
${DATADIR_BUILD}/${PROJECT_NAME}/migratable-prefs.xml
Regards,
John Ralls
> On Sep 28, 2021, at 4:57 PM, Harry G McGavran Jr via gnucash-user
> wrote:
>
> I have the same problem that David reported on this list, but
> with Ubuntu 20.04:
>
> Gnucash 4.8 won't build --
>
> .
> .
> .
> [ 97%] Built target org.gnucash.GnuCash.dialogs.sxs.gschema.valid-target
> [ 97%] Built target
> org.gnucash.GnuCash.dialogs.import.csv.gschema.valid-target
> [ 98%] Built target compiled-schemas
> [ 98%] Generating ../../share/gnucash/migratable-prefs.xml
> CMake Error: cmake version 3.16.3
> Usage: /usr/bin/cmake -E [arguments...]
> Available commands:
> capabilities - Report capabilities built into cmake in JSON
> format
> chdir dir cmd [args...] - run command in a given directory
> .
> .
> .
>
> I tried chasing this a bit, but I'm not a cmake expert by any means...
> So hopefully there will be a work around...
>
>
> ___
> 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] [GNC-dev] GnuCash 4.8 Released
> On Sep 28, 2021, at 1:55 PM, John Ralls wrote: > > The GnuCash development team announces GnuCash 4.8, the ninth release in the > stable 4.x series > > This is a snap release to fix crashes during migration. The macOS and Win32 > GnuCash bundles were not affected; if you use either of those you do not need > this release. > Between 4.7 and 4.8, the following bugfixes were accomplished: > > None > The following fixes and improvements were not associated with bug reports: > >[gsettings] Avoid crash from settings schema not being registered. >Rethink how gsettings migration file is constructed >GSettings hotfix - resolve crash due to bad schema reference >[gnc-plugin-page-register] call invoice editor with parent window >[assistant-stock-split] set parent window properly > > New API > > None > Deprecations > > None > > New and Updated Translations: None. > Known Problems > > > Complete list of all open bugs: > https://bugs.gnucash.org/buglist.cgi?bug_severity=blockerbug_severity=criticalbug_severity=majorbug_severity=normalbug_severity=minorbug_severity=trivialbug_status=NEWbug_status=ASSIGNEDbug_status=NEEDINFObug_status=REOPENEDlimit=0list_id=8149order=priority%2Cbug_severityquery_format=advanced > > Documentation > > Concurrent with the release of GnuCash 4.8 we're pleased to also release a > new version of the companion Help and Tutorial and Concepts Guide > Between 4.7 and 4.8, the following bugfixes were accomplished: > > None > The following fixes and improvements were not associated with bug reports: > >Remove obsolete files. >Remove autotools. > > New and Updated Translations: None > Getting GnuCash for Windows and MacOS > > GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 > (High Sierra)® and later in pre-built, all-in-one packages. An installer is > provided for Microsoft Windows® while the MacOS® package is a disk image > containing a drag-and-drop application bundle. > > The SHA256 Hashes for the downloadable files are: > >15b8e4ff8336168eba88ef2faade377e5c5ff08e48b4660da1a33a8a407feb12 > gnucash-4.8.tar.bz2 >37e6fbdee7e2ac41299cdb4ffef189c160b03f992ab30e823369df90ebb0d61f > gnucash-4.8.tar.gz >b8c4a4bad5a073f53ea07ad46d4c13096a5d26d906ceda8c049842a8362d0a86 > gnucash-4.8.setup.exe >abb6a0bc433207c1f31fee33aa7f0c63774217b2675e5fab78062c4cd862f975 > Gnucash-Intel-4.8-2.dmg >988011168a3ab2c3601a5af75f5caad89fb18a4e880311f3538b8fc7c9a068d3 > gnucash-docs-4.8.tar.gz > > Microsoft Windows: > https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.setup.exe > > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.setup.exe > > Apple macOS: > https://github.com/Gnucash/gnucash/releases/download/4.8/Gnucash-Intel-4.8-1.dmg > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/Gnucash-Intel-4.8-1.dmg > > GnuCash is now available as a flatpak from Flathub.org. Instructions for > installing and running may be found at https://wiki.gnucash.org/wiki/Flatpak. > > Getting GnuCash as source code > If you want to compile GnuCash 4.8 for yourself, the source code can be > downloaded from: > https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.tar.bz2 > https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.tar.gz > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.tar.bz2 > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.tar.gz > > You can also checkout the sources directly from the git repository, see > https://wiki.gnucash.org/wiki/Git for instructions. > > To compile GnuCash from the source code by yourself, you will need at least > Gtk+ 3.24, Guile 2.0, Boost 1.54, WebKitGtk 2.4, GoogleTest 1.7.0, cmake 3.10 > and SWIG 2.0.12. Please consult the README.dependencies file in the sources > for the exact list of dependencies and versions. > > Getting the documentation > > If you want to compile the GnuCash Documentation 4.8 for yourself, the source > code can be downloaded from: > https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-docs-4.8.tar.gz > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-docs-4.8.tar.gz > > The documentation is included in the MacOS and Windows application bundles. > > About the Program > > GnuCash is a free, open source accounting program released under the GNU > General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, > MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its > first stable
[GNC] GnuCash 4.7 Released
The GnuCash development team announces GnuCash 4.8, the ninth release in the stable 4.x series This is a snap release to fix crashes during migration. The macOS and Win32 GnuCash bundles were not affected; if you use either of those you do not need this release. Between 4.7 and 4.8, the following bugfixes were accomplished: None The following fixes and improvements were not associated with bug reports: [gsettings] Avoid crash from settings schema not being registered. Rethink how gsettings migration file is constructed GSettings hotfix - resolve crash due to bad schema reference [gnc-plugin-page-register] call invoice editor with parent window [assistant-stock-split] set parent window properly New API None Deprecations None New and Updated Translations: None. Known Problems Complete list of all open bugs: https://bugs.gnucash.org/buglist.cgi?bug_severity=blockerbug_severity=criticalbug_severity=majorbug_severity=normalbug_severity=minorbug_severity=trivialbug_status=NEWbug_status=ASSIGNEDbug_status=NEEDINFObug_status=REOPENEDlimit=0list_id=8149order=priority%2Cbug_severityquery_format=advanced Documentation Concurrent with the release of GnuCash 4.8 we're pleased to also release a new version of the companion Help and Tutorial and Concepts Guide Between 4.7 and 4.8, the following bugfixes were accomplished: None The following fixes and improvements were not associated with bug reports: Remove obsolete files. Remove autotools. New and Updated Translations: None Getting GnuCash for Windows and MacOS GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS® package is a disk image containing a drag-and-drop application bundle. The SHA256 Hashes for the downloadable files are: 15b8e4ff8336168eba88ef2faade377e5c5ff08e48b4660da1a33a8a407feb12 gnucash-4.8.tar.bz2 37e6fbdee7e2ac41299cdb4ffef189c160b03f992ab30e823369df90ebb0d61f gnucash-4.8.tar.gz b8c4a4bad5a073f53ea07ad46d4c13096a5d26d906ceda8c049842a8362d0a86 gnucash-4.8.setup.exe abb6a0bc433207c1f31fee33aa7f0c63774217b2675e5fab78062c4cd862f975 Gnucash-Intel-4.8-2.dmg 988011168a3ab2c3601a5af75f5caad89fb18a4e880311f3538b8fc7c9a068d3 gnucash-docs-4.8.tar.gz Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.setup.exe Apple macOS: https://github.com/Gnucash/gnucash/releases/download/4.8/Gnucash-Intel-4.8-1.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/Gnucash-Intel-4.8-1.dmg GnuCash is now available as a flatpak from Flathub.org. Instructions for installing and running may be found at https://wiki.gnucash.org/wiki/Flatpak. Getting GnuCash as source code If you want to compile GnuCash 4.8 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.tar.gz You can also checkout the sources directly from the git repository, see https://wiki.gnucash.org/wiki/Git for instructions. To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.24, Guile 2.0, Boost 1.54, WebKitGtk 2.4, GoogleTest 1.7.0, cmake 3.10 and SWIG 2.0.12. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions. Getting the documentation If you want to compile the GnuCash Documentation 4.8 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-docs-4.8.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-docs-4.8.tar.gz The documentation is included in the MacOS and Windows application bundles. About the Program GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998. ___ 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] Crash on exit in Gnucash 4.7-2 in macOS Big Sur
Another user has filed https://bugs.gnucash.org/show_bug.cgi?id=798320 <https://bugs.gnucash.org/show_bug.cgi?id=798320> with the same stack trace so let's move the discussion there. Regards, John Ralls > On Sep 27, 2021, at 11:35 PM, William Prescott wrote: > > For what it's worth, I'm not seeing any problem with 4.7-2 on my 2017 Intel > iMac OS Big Sur 11.6. > > Will > > On 2021 Sep 28, at 09-28 00:16:07, prl wrote: > > Thanks, John. > > Here's the thread 0 (the crashed thread) stack trace, machine registers and > instruction stream from the crash report. I think that's probably everything > relevant in the report. > > Cheers, > Peter > > Thread 0 Crashed:: Dispatch queue: com.apple.main-thread > 0 libgnc-engine.dylib 0x0001020079ad > qof_instance_get_destroying + 77 > 1 libgnc-engine.dylib 0x000101f53c8b xaccSplitDestroy + 43 > 2 libgnc-engine.dylib 0x000101f5966c do_destroy + 300 > 3 libgnc-engine.dylib 0x000102009030 > qof_commit_edit_part2 + 272 > 4 libgnc-engine.dylib 0x000101f56e43 xaccTransCommitEdit > + 339 > 5 libglib-2.0.0.dylib 0x000100561d2d g_list_foreach + 45 > 6 libgnc-engine.dylib 0x000102006231 > qof_collection_foreach + 161 > 7 libgnc-engine.dylib 0x00010201019a qof_object_book_end > + 138 > 8 libgnc-engine.dylib 0x000101ffec21 qof_book_destroy + > 145 > 9 libgnc-engine.dylib 0x000102017bc6 > QofSessionImpl::~QofSessionImpl() + 150 > 10 libgnc-engine.dylib 0x000102017ea3 qof_session_destroy > + 19 > 11 libgnc-engine.dylib 0x000101fd751f > gnc_clear_current_session + 31 > 12 libgnc-gnome-utils.dylib 0x0001009bf29c gnc_file_quit + 76 > 13 libgnc-engine.dylib 0x000101fbf322 call_hook + 114 > 14 libglib-2.0.0.dylib 0x000100556fed g_hook_list_marshal > + 125 > 15 libgnc-engine.dylib 0x000101fbf222 gnc_hook_run + 146 > 16 libgnc-gnome-utils.dylib 0x0001009c3b2b gnc_shutdown + 59 > 17 libgnc-gnome-utils.dylib 0x0001009cd69d > gnc_main_window_timed_quit + 29 > 18 libglib-2.0.0.dylib 0x000100562be4 g_timeout_dispatch + > 20 > 19 libglib-2.0.0.dylib 0x000100566cec > g_main_context_dispatch + 348 > 20 libglib-2.0.0.dylib 0x00010056705d > g_main_context_iterate + 525 > 21 libglib-2.0.0.dylib 0x00010056737a g_main_loop_run + 218 > 22 libgtk-3.0.dylib 0x000100c3b11a gtk_main + 74 > 23 libgnc-gnome-utils.dylib 0x0001009c36fc > gnc_ui_start_event_loop + 76 > 24 org.gnucash.Gnucash 0x000100160a86 > scm_run_gnucash(void*, int, char**) + 1078 > 25 libguile-2.2.1.dylib 0x000100398932 invoke_main_func + 34 > 26 libguile-2.2.1.dylib 0x000100377b3f c_body + 15 > 27 libguile-2.2.1.dylib 0x00010040534b vm_regular_engine + > 1467 > 28 libguile-2.2.1.dylib 0x000100403ef5 scm_call_n + 773 > 29 libguile-2.2.1.dylib 0x000100400922 catch + 498 > 30 libguile-2.2.1.dylib 0x000100377b09 > scm_c_with_continuation_barrier + 137 > 31 libguile-2.2.1.dylib 0x00010040048f with_guile + 63 > 32 libgc.1.dylib 0x0001004d4ef6 > GC_call_with_stack_base + 22 > 33 libguile-2.2.1.dylib 0x0001003fe4ab scm_with_guile + 43 > 34 libguile-2.2.1.dylib 0x0001003988f5 scm_boot_guile + 69 > 35 org.gnucash.Gnucash 0x0001001605f9 > Gnucash::Gnucash::start(int, char**) + 617 > 36 org.gnucash.Gnucash 0x000100161191 main + 1009 > 37 libdyld.dylib 0x7fff204aef3d start + 1 > > Thread 0 crashed with X86 Thread State (64-bit): > rax: 0x rbx: 0x7f85fad8d190 rcx: 0x0001 > rdx: 0x > rdi: 0x7f85fad8d190 rsi: 0x7f85fbe99490 rbp: 0x7ffeefab3a90 > rsp: 0x7ffeefab3a80 > r8: 0x7f85f9d0a7d0 r9: 0x7f85f9ea0c80 r10: 0x033755c0 > r11: 0xffd4a001 > r12: 0x000101f59320 r13: 0x7f85fad8c430 r14: 0x7f85fad8c430 > r15: 0x > rip: 0x0001020079ad rfl: 0x00010286 cr2: 0x72ecdff8 > > Logical CPU: 2 > Error Code: 0x > Trap Number: 13 > > Thread 0 instruction stream: > 48 20 0f 9f c2 b8 ff ff-ff ff 0f 4d c2 5b 41 5e H .M.[A^ > 5d c3 90 55 48 89 e5 53-50 4
Re: [GNC] Crash on exit in Gnucash 4.7-2 in macOS Big Sur
> On Sep 27, 2021, at 6:47 PM, prl wrote: > > I seem to be consistently getting a Gnucash crash when I exit (using either > Gnucash>Quit or command-Q) from Gnucash 4.7-2 on my Big Sur MacBook Pro. > Caused by a Segmentation Violation. > > Here's a snippet from the macOS log of the crash: > Process: Gnucash [4025] > Path: /Applications/Gnucash.app/Contents/MacOS/Gnucash > Identifier:org.gnucash.Gnucash > Version: 4.7-2 (4.7-2) > Code Type: X86-64 (Native) > Parent Process:zsh [4019] > Responsible: Terminal [4017] > User ID: 501 > > Date/Time: 2021-09-28 11:28:31.262 +1000 > OS Version:macOS 11.6 (20G165) > Report Version:12 > Bridge OS Version: 5.5 (18P4759a) > Anonymous UUID:CA0735A3-3879-5356-BA71-4D9410666AF2 > > Sleep/Wake UUID: 9E59B9B4-5345-4236-BD83-17C01E85C186 > > Time Awake Since Boot: 8400 seconds > Time Since Wake: 7700 seconds > > System Integrity Protection: enabled > > Crashed Thread:0 Dispatch queue: com.apple.main-thread > > Exception Type:EXC_BAD_ACCESS (SIGSEGV) > Exception Codes: EXC_I386_GPFLT > Exception Note:EXC_CORPSE_NOTIFY > > Termination Signal:Segmentation fault: 11 > Termination Reason:Namespace SIGNAL, Code 0xb > Terminating Process: exc handler [4025] > > I can post a full crash log as an attachment if it helps. > > Any ideas, anyone? > > System details: > Gnucash 4.7-2 for Intel MacOS >= 10.13, Build ID: 4.7+(2021-09-25) > macOS Big Sur 11.6 > MacBook Pro (13-inch, 2019, Four Thunderbolt 3 ports), MacBookPro15,2 Please post the bit with the address and the first few lines of the stack trace, enough to show at least 2 gnc_ functions. Regards, John Ralls ___ 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] Gnucash 4.7 Problem
Yeah, we're going to do a snap release tomorrow. I've already tagged it and built the tarballs. Regards, John Ralls > On Sep 27, 2021, at 6:03 PM, Jon Schewe wrote: > > The flatpak apears to be broken as well. I run it and nothing appears. > > jpschewe@jon-2019:~ >> flatpak run org.gnucash.GnuCash > F: Ignoring D-Conf migrate-path setting /org/gnucash/GnuCash > > ~ > jpschewe@jon-2019:~ >> echo $? > 133 > > > On Mon, 2021-09-27 at 09:44 +0200, Geert Janssens wrote: >> Unfortunately this is a bug. I missed a name change in the conversion >> code for >> gnucash preferences. >> >> The fix is in the patch attached. >> >> As this is a crasher we may have to do a hotfix release. What do you >> think >> John ? >> >> Regards, >> >> Geert >> >> Op maandag 27 september 2021 06:43:26 CEST schreef John Ralls: >>> Please remember to copy the list on all replies. >>> >>> Removing /usr/local/lib/gnucash isn't enough. You'd also need to >>> remove at >>> least /usr/local/lib/libgnc* and /usr/local/share/gnucash. >>> >>> You don't need the whole build directory. There's a single file, >>> install-manifest.txt, that contains all of the files that were >>> installed. >>> With that one file you can do `xargs rm < install-manifest.txt` to >>> uninstall GnuCash. You might consider saving it off somewhere >>> before you >>> delete the build directory. >>> >>> Regards, >>> John Ralls >>> >>>> On Sep 26, 2021, at 9:08 PM, Harry G McGavran Jr < >>>> w5...@w5pny.com >>>>> wrote: >>>> >>>> That did fix the problem! I guess I will have to be sure >>>> to keep the old build directory around, so I can do a "make >>>> uninstall" >>>> before building the next release! Thanks for the fix -- but I >>>> must >>>> say it would be nice to not have to do the "make uninstall" on >>>> the >>>> old release. Many packages don't even have uninstall in their >>>> Makefiles... (although it would be nice if every one did include >>>> an >>>> uninstall in their Makefiles). >>>> >>>> Thanks, John! >>>> >>>> Harry >>>> >>>> On 9/26/21 9:41 PM, Harry G McGavran Jr wrote: >>>>> I think I figured out what you mean -- >>>>> you must mean either do "make uninstall" or "ninja uninstall" >>>>> with 4.6 >>>>> before building 4.7 ... >>>>> With I build gnucash and always remove /usr/local/lib/gnucash >>>>> before doing "make install" which might be the same thing. >>>>> If it does, then I'll still have the problem. I'll give >>>>> it a try though and if it doesn't work, I'll post a tracefile >>>>> to >>>>> the bug reports... >>>>> >>>>> On 9/26/21 9:34 PM, Harry G McGavran Jr wrote: >>>>>> I don't have the ninja package installed, so I'm not sure >>>>>> what >>>>>> "make/ninja uninstall" means...>>> >>>>>> On 9/26/21 9:20 PM, john wrote: >>>>>>> If you didn't already, run make/ninja uninstall in the 4.6 >>>>>>> build >>>>>>> directory. Configure and build GnuCash 4.7 in an empty >>>>>>> directory, then >>>>>>> install. >>>>>>> >>>>>>> If that doesn't correct the problem get a stack trace of >>>>>>> the crash and >>>>>>> attach it and the trracefile to a new bug report. >>>>>>> >>>>>>> Regards, >>>>>>> John Ralls >>>>>>> >>>>>>>> On Sep 26, 2021, at 7:26 PM, Harry G McGavran Jr via >>>>>>>> gnucash-user >>>>>>>> < >>>>>>>> gnucash-user@gnucash.org >>>>>>>>> wrote: >>>>>>>> >>>>>>>> This was with Ubuntu 20.04... >>>>>>>> >>>>>>>> On 9/26/21 8:25 PM, Harry G McGavran Jr wrote: >>>>>>>>> I just built Gnucash 4.7 from the release page. >>>>>>>>> It built fine, and it runs fine from the build >>>>>>>>> dir
Re: [GNC] I need to recover my files for the 4.7 upgrade
Your book is probably right where you left it. GnuCash 4.7 changes the preferences--see the top of the release notes for details--and it sounds like the migration failed in your case. The last file and file history are kept in preferences so that's very likely why it didn't open your file automatically. Just use File>Open's file chooser to open the file. Regards, John Ralls > On Sep 27, 2021, at 10:19 AM, Stumpie wrote: > > Hi all, > I upgraded my gnucash to ver. 4.7 The uninstall of ver 4.5 went smoothly as > did the installation. . . until the end. My computer froze and I had to do a > cold reboot. So I reinstalled ver 4.7 and opened gnucash, it thought that I > was a new user. > > So where is the data file and what is the name and how do I get ver 4.7 to > recognize it. The data file hopefully will be on my main drive but I know it > is on my backup drive, so if guncash trashed the data on the main drive I can > always get it from the backup. > > Any help is greatly appreciated. > Regards, > Paul > ___ > 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] Gnucash 4.7 Problem
Please remember to copy the list on all replies. Removing /usr/local/lib/gnucash isn't enough. You'd also need to remove at least /usr/local/lib/libgnc* and /usr/local/share/gnucash. You don't need the whole build directory. There's a single file, install-manifest.txt, that contains all of the files that were installed. With that one file you can do `xargs rm < install-manifest.txt` to uninstall GnuCash. You might consider saving it off somewhere before you delete the build directory. Regards, John Ralls > On Sep 26, 2021, at 9:08 PM, Harry G McGavran Jr wrote: > > That did fix the problem! I guess I will have to be sure > to keep the old build directory around, so I can do a "make uninstall" > before building the next release! Thanks for the fix -- but I must > say it would be nice to not have to do the "make uninstall" on the > old release. Many packages don't even have uninstall in their Makefiles... > (although it would be nice if every one did include an > uninstall in their Makefiles). > > Thanks, John! > > Harry > > On 9/26/21 9:41 PM, Harry G McGavran Jr wrote: >> I think I figured out what you mean -- >> you must mean either do "make uninstall" or "ninja uninstall" with 4.6 >> before building 4.7 ... >> With I build gnucash and always remove /usr/local/lib/gnucash >> before doing "make install" which might be the same thing. >> If it does, then I'll still have the problem. I'll give >> it a try though and if it doesn't work, I'll post a tracefile to >> the bug reports... >> On 9/26/21 9:34 PM, Harry G McGavran Jr wrote: >>> I don't have the ninja package installed, so I'm not sure what "make/ninja >>> uninstall" means... >>> >>> On 9/26/21 9:20 PM, john wrote: >>>> If you didn't already, run make/ninja uninstall in the 4.6 build >>>> directory. Configure and build GnuCash 4.7 in an empty directory, then >>>> install. >>>> >>>> If that doesn't correct the problem get a stack trace of the crash and >>>> attach it and the trracefile to a new bug report. >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>>> On Sep 26, 2021, at 7:26 PM, Harry G McGavran Jr via gnucash-user >>>>> wrote: >>>>> >>>>> This was with Ubuntu 20.04... >>>>> >>>>> On 9/26/21 8:25 PM, Harry G McGavran Jr wrote: >>>>>> I just built Gnucash 4.7 from the release page. >>>>>> It built fine, and it runs fine from the build directory, >>>>>> but the installed gnucash binary in /usr/local/bin >>>>>> fails with: >>>>>> Trace/breakpoint trap (core dumped) >>>>>> It only seems to run without error when run from the bin >>>>>> directory where the build is actually done. >>>>>> So I rebuilt Gnucash 4.6 and it's installed binary in /usr/local/bin >>>>>> runs fine. >>>>>> There was no core file even though "core dumped" was displayed with 4.7 >>>>> ___ >>>>> 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] Gnucash 4.7 Problem
If you didn't already, run make/ninja uninstall in the 4.6 build directory. Configure and build GnuCash 4.7 in an empty directory, then install. If that doesn't correct the problem get a stack trace of the crash and attach it and the trracefile to a new bug report. Regards, John Ralls > On Sep 26, 2021, at 7:26 PM, Harry G McGavran Jr via gnucash-user > wrote: > > This was with Ubuntu 20.04... > > On 9/26/21 8:25 PM, Harry G McGavran Jr wrote: >> I just built Gnucash 4.7 from the release page. >> It built fine, and it runs fine from the build directory, >> but the installed gnucash binary in /usr/local/bin >> fails with: >> Trace/breakpoint trap (core dumped) >> It only seems to run without error when run from the bin >> directory where the build is actually done. >> So I rebuilt Gnucash 4.6 and it's installed binary in /usr/local/bin >> runs fine. >> There was no core file even though "core dumped" was displayed with 4.7 > ___ > 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] Gnucash 4.7 dmg for Mac
No, Tim was right: I screwed up and put GnuCaah 4.6 in the 4.7-1 dmg. I've build a new 4.7-2 dmg and that's what you downloaded. Regards, John Ralls > On Sep 26, 2021, at 7:03 PM, Colin wrote: > > Tim, > > I just downloaded the .dmg from Gnucash.org and it is version 4.7. > > My guess is you didn’t correctly replace the GnuCash app bundle in your > /Applications folder with the new one. > > Best, > Colin > >> On Sep 26, 2021, at 4:56 PM, gnucash-user-requ...@gnucash.org wrote: >> >> >> -- >> >> Message: 5 >> Date: Sun, 26 Sep 2021 18:18:48 -0400 >> From: Tim LeMaster >> To: gnucash-user@gnucash.org >> Subject: [GNC] Gnucash 4.7 dmg for Mac >> Message-ID: >> >> Content-Type: text/plain; charset="UTF-8" >> >> Is it just me or does the disk image for Mac contain Gnucash 4.6 not 4.7? >> When I launch it, it still says 4.6. I was checking to see if the Monterey >> fix from GTK got in the release. >> >> About GnuCash says >> Version 4.6 >> Build ID: 4.6+ (2021-06-26) >> >> >> -- >> >> Message: 6 >> Date: Sun, 26 Sep 2021 15:37:36 -0700 >> From: John Ralls >> To: Alton Brantley >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] Equity account changed to Trading Account >> Message-ID: >> Content-Type: text/plain;charset=utf-8 >> >> Alton, >> >> You missed the key element of David's suggestion: Change the type of the >> account back. You can do that by selecting the account on the Accounts page >> and clicking the Edit button in the toolbar or using control-E or selecting >> Edit>Edit Account from the menu. The last will also work from the account >> register. >> >> Once you have the account edit window open look in the bottom left corner >> for the Account Type list box. Select Equity from that list and click OK to >> commit the action. >> >> Regards, >> John Ralls >> >> >>> On Sep 26, 2021, at 11:38 AM, Alton Brantley via gnucash-user >>> wrote: >>> >>> I recognize that I can use that mechanism ((Menu-.Transaction->Manage >>> Document >>> Links and Transaction->Open Linked Document in V4.6). However, I use >>> scheduled transactions and template transactions (model transactions with >>> all the split accounts with amounts set to zero) so that all I do is fill >>> in the values. That way, I never have to take my hands off the keyboard to >>> enter data. >>> >>> I double-checked, and the account marked as Trading is already a top-level >>> account. If I try to move it under any other account, it shows the possible >>> types of accounts as blank, so there?s nothing for me to select that >>> enables me to move the account. >>> >>> Also, I looked under File->Properties->Accounts and the ?Use Trading >>> accounts? checkbox is not marked. >>> >>> For the time being, I created a new ?Assets? account and moved the current >>> year?s transactions using the trading account split from the ?Trading >>> account? by editing the account in the splits of a search on the ?trading? >>> account name for the current year. Now I have all previous year?s >>> transactions in the ?trading? account, and the current year in an ?assets? >>> account, and I will enter future lines in the new account. >>> >>> I am at a loss as to what made the account become identified as a ?trading? >>> account, as all my accounts are in USD. I did discover that in one of my >>> current year transactions, I had entered a non-zero value in the account >>> that had switched from ?asset? to ?trading.? I wonder if that somehow >>> triggered the software to convert the account. I think I?ll take a look at >>> the code around accounts and see what I can find. >>> >>> Thanks for your suggestions. >>> >>> >>> >>>> Date: Sun, 26 Sep 2021 08:11:01 +1000 >>>> From: davidcousen...@gmail.com >>>> To: gnucash-user@gnucash.org >>>> Subject: Re: [GNC] Equity account changed to Trading Account >>>> Message-ID: <21626e93bbfcba5046a6b18f15c6917b29fe6ad9.ca...@gmail.com> >>>> Content-Type: text/plain; charset="UTF-8" >>>> >>>> Alton >>>> >>>>> From your description it would appear you are using the notes field to >>
Re: [GNC] Gnucash 4.7 dmg for Mac
Yeah, I missed a step. Actually a couple of steps. I've uploaded a new dmg: 91597ccd19e31f8ecc454d1a1e5f891c98e60efb28d2a78d2497caf2103a7c55 Gnucash-Intel-4.7-2.dmg Regards, John Ralls > On Sep 26, 2021, at 3:18 PM, Tim LeMaster wrote: > > Is it just me or does the disk image for Mac contain Gnucash 4.6 not 4.7? > When I launch it, it still says 4.6. I was checking to see if the Monterey > fix from GTK got in the release. > > About GnuCash says > Version 4.6 > Build ID: 4.6+ (2021-06-26) > ___ > 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] Equity account changed to Trading Account
Alton, You missed the key element of David's suggestion: Change the type of the account back. You can do that by selecting the account on the Accounts page and clicking the Edit button in the toolbar or using control-E or selecting Edit>Edit Account from the menu. The last will also work from the account register. Once you have the account edit window open look in the bottom left corner for the Account Type list box. Select Equity from that list and click OK to commit the action. Regards, John Ralls > On Sep 26, 2021, at 11:38 AM, Alton Brantley via gnucash-user > wrote: > > I recognize that I can use that mechanism ((Menu-.Transaction->Manage Document > Links and Transaction->Open Linked Document in V4.6). However, I use > scheduled transactions and template transactions (model transactions with all > the split accounts with amounts set to zero) so that all I do is fill in the > values. That way, I never have to take my hands off the keyboard to enter > data. > > I double-checked, and the account marked as Trading is already a top-level > account. If I try to move it under any other account, it shows the possible > types of accounts as blank, so there’s nothing for me to select that enables > me to move the account. > > Also, I looked under File->Properties->Accounts and the “Use Trading > accounts” checkbox is not marked. > > For the time being, I created a new “Assets” account and moved the current > year’s transactions using the trading account split from the “Trading > account” by editing the account in the splits of a search on the “trading” > account name for the current year. Now I have all previous year’s > transactions in the “trading” account, and the current year in an “assets” > account, and I will enter future lines in the new account. > > I am at a loss as to what made the account become identified as a “trading” > account, as all my accounts are in USD. I did discover that in one of my > current year transactions, I had entered a non-zero value in the account that > had switched from “asset” to “trading.” I wonder if that somehow triggered > the software to convert the account. I think I’ll take a look at the code > around accounts and see what I can find. > > Thanks for your suggestions. > > > >> Date: Sun, 26 Sep 2021 08:11:01 +1000 >> From: davidcousen...@gmail.com >> To: gnucash-user@gnucash.org >> Subject: Re: [GNC] Equity account changed to Trading Account >> Message-ID: <21626e93bbfcba5046a6b18f15c6917b29fe6ad9.ca...@gmail.com> >> Content-Type: text/plain; charset="UTF-8" >> >> Alton >> >>> From your description it would appear you are using the notes field to stor >>> a >> link to an external file descriptor. GnuCash has had a facility to associate >> a >> URL for an external file to a transaction (Menu-.Transaction->Manage Document >> Links and Transaction->Open Linked Document in V4.6). This allows you to >> link a >> file (PDF or image of e receipt for example) to a specific transaction and >> open >> it from within GnuCash). You can also set a path header in the preferences >> so >> all your linked files are stored in a single directory (can be a >> subdirectory of >> a folder with your data files in it ) >> >> >> Not sure if this will work on your retyped Equity account but may be worth a >> try. The range of the available account types displayed in the edit >> procedure is >> set by the account type of the parent account in the edit account process >> Can't >> guarantee it will work but worth a try. In the Edit Account process try >> setting >> the Parent Account for the trading account to "New top level account" and >> then >> try changing the account type back to Equity and then reset the parent >> account >> to Equity. >> >> David Cousens >> >> On Sat, 2021-09-25 at 17:17 -0400, Alton Brantley wrote: >>> I have an equity account which I use to record notes about purchases by >>> storing the file name as the note in the split and it always has a zero >>> value >>> so it sorts to the middle of the splits. >>> Sometime in the past couple months, this account became tagged as a >>> ?Trading? >>> account even though it and all of the transaction splits are in USD. >>> >>> I tried to create a new tracking account, and to delete the Trading account >>> by >>> moving the transactions over, but that wasn?t allowed. >>> >>> At this point, I cannot add transactions to the acco
[GNC] GnuCash 4.7 Released
The GnuCash development team announces GnuCash 4.7, the eighth release in the stable 4.x series Compatibility Notice In order to allow flatpak users to share preferences with installations outside of the sandbox we need to change the preference path from /org/gnucash to /org/gnucash/GnuCash. This release of GnuCash does that and it will automatically migrate existing preferences. It does not, however, continue to write preferences to the old path and it runs the migration only once. If you go back and forth between GnuCash 4.7 and an older versions you'll have two sets of preferences, one for GnuCash 4.7 and later and another for GnuCash 4.6 and earlier. This includes the file history list and last-opened file. Between 4.6 and 4.7, the following bugfixes were accomplished: Bug 87847 - RFE: Create a 'checkbox' cell type Bug 766052 - Job report payments wrong when payment contains splits Bug 797596 - New-owner - improved representation of payments with multiple non-APAR splits Bug 798142 - Tax rate appears as a fraction Bug 798180 - Update to macOS Big Sur 11.3 breaks Finance Quote Bug 798205 - Some transactions dropped with no apparent cause or warnings for credit card ofx import Do not exclude from import a transaction that has an FITID which matches an already existing split. This is because it (1) may be a coincidence and therefore the transaction needs to be added or (2) could be on a transfer from the account being imported to another bank account which has already been imported, and so needs to be matched, not added. Bug 798208 - management fee transactions are ignored on OFX import Bug 798211 - Equity statement double calculates unrealized gain Bug 798219 - apply/OK truncates exchange rates from 4 to 2 decimal places; enter doesn't Bug 798221 - Transfer funds between accounts with different currencies crashes Gnucash on macOS Bug 798224 - Scheduled transactions are created with date-entered copied from the template transaction. Bug 798229 - GncDate::c_formats is being created and destroyed twice resulting in a double free crash on every exit. Bug 798234 - Cut Transaction discards the reference to the description/memo strings so that Paste Transaction will paste uninitialised data (or other strings) Bug 798235 - Reconciliation Ending Balance not recalculated the 2nd and subsequent times Statement Date is updated. Bug 798237 - Logging during XML file loading degrades performance significantly Bug 798238 - "New security" dialog doesn't save the "Display symbol" Bug 798250 - Gnucash permanent hang on save while loading report Bug 798256 - Crash in recnFinishCB Bug 798298 - Re-imported transactions no longer ignored Bug 798303 - account list is sorted wrong by amount Bug 798312 - Opening the help for dialogues in the wrong language. The following fixes and improvements were not associated with bug reports: Lots of memory-leaks plugged Change the preferences path to org.gnucash.GnuCash to comply with flatpak requirements and migrate existing preferences to the new paths. This won't provide for automatic sync between a system-installed GnuCash and a flatpak one unless the system-installed one is GnuCash 4.7 or later. Please see the Wiki for more information and a procedure to convert your existing preferences. Cleanup - minimal glib=2.56.1 - drop all conditionals on older versions Add code to handle ofx files that include transfers between accounts During transaction import, ignore splits whose account is not the destination account Do not drop a potential match just because it has an online_id. Now that we don't exclude from import a transaction with an FITID that matches an already existing transaction, if one accidentally re-imports a transaction, this allows it to be automatically matched against the previously imported transaction. Add test for Transaction GetDate() in python bindings, pursuant to Bug 798284. In find customer dialog, add a column for "Shipping Contact" parameter Prep early splash screen messages for translation Change text for SX preference option 'Review created transactions' to better align with existing SX text. Fixed an XML backend problem where trying to open a locked file would clear the lock even if one didn't ask to, so the next attempt would find the file unlocked even if still open in another instance. Fix 2 crashes in Generic Transaction Matcher Handle very large denominators from Finance::Quote's OpenExchange source Update file extension in man pages per mailing list post. Changed some option names: From "Show Accounts until level" to "Levels of Subaccounts" From "Extra notes" to "Extra Notes" from "Report title" to "Report Title" From "Invoice number" to "Invoice Number" to ensure it matches all other invoice reports. Fix missing mnemonic keys
Re: [GNC] Set up GnuCash to track monthly net income considering taxes and pension fund contributions
That is an *excellent* tip! Care to add it to the wiki? Regards, John Ralls > On Sep 25, 2021, at 7:06 AM, Robin Chattopadhyay wrote: > > You can achieve the ad-hoc nature of a templated transaction by setting the > frequency of the scheduled transaction to 'Once'. > > Set up your scheduled transaction, set the frequency to 'Once', run the > scheduled transactions/Since Last Run option, fill in the variables, then > proceed. > > The next time you want to run that specific template, edit the scheduled > transaction by changing the start date and running the scheduled > transaction process again. > > Robin > > On Sat, Sep 25, 2021 at 5:12 AM Christopher Lam > wrote: > >> The only mechanism that really exists to have "templated arbitrary >> formulas" is to use the periodic Scheduled Transactions. It would be nice >> to have them created ad-hoc (ie menu item Create Transaction from Template >> which pops up a list of available templates) instead of periodically... >> >> On Sat, 25 Sep 2021, 5:34 pm Simone Gaiarin, wrote: >> >>> Thanks for the reply Rich. >>> >>> My main question is: is there a way to automate these calculations in >>> GNUCash or for each transaction I need to compute and input each >> component >>> of the income by hand? >>> I have read the GNUCash documentation but I was not able to figure out if >>> this is possible or not. >>> >>> On Sun, Sep 19, 2021 at 8:32 AM Simone Gaiarin >> wrote: >>> >>>> Hi all, >>>> I need help in setting up GnuCash to achieve the following goal: >>>> - Track my monthly net income (after taxes and pension fund >> contribution) >>>> >>>> Situation: >>>> I give a service that I invoice per hour and the cost paid by the >>> customer >>>> consists of the following components: >>>> >>>> x: Cash payment = y + p1 >>>> y: Service gross cost >>>> p1: 1st pension fund contribution = 0,02 * y >>>> >>>> On y I have to pay also: >>>> t1: tax I have to pay = 0,05 * y >>>> p2: 2nd pension fund contribution = 0,10 * (y - t1) >>>> >>>> Accounts: >>>> >>>> - Income >>>> >>>> - Bank Account >>>> >>>> - Tax >>>> - Pension fund >>>> >>>> Given that I pay out of my bank account the taxes twice a year and the >>>> contribution to the pension fund twice a year, the 'Income chart' >> report >>>> does not give me a clear view of my net income over the month. >>>> >>>> I tried to set up a tax table where I used some equivalent coefficients >>> in >>>> order to automatically assign t1 to Tax account and p1, p2 to the >> Pension >>>> fund account (rather difficult given that here the tax and pension fund >>> are >>>> computed in cascade), but I wonder if this is the correct strategy (the >>>> Pension fund account goes negative instead of positive for example). >>>> >>>> What is the correct way to proceed in order to obtain a monthly net >>> income >>>> chart considering the taxes and pension fund contribution percent over >>> each >>>> customer payment? >>>> >>>> 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. >> > ___ > 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] Is Additional Action Necessary After Filing A Bug Report?
> On Sep 24, 2021, at 9:46 AM, Derek Atkins wrote: > > Nope. > It'll remain NEW until it is resolved. Well, when one of us gets to it if he has questions he'll change it to NEEDINFO. When you answer the questions please change it back to NEW. Regards, John Ralls ___ 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] Investment Portfolio Reports Question
I just got a reply that this issue is being corrected in gnuCash 4.7 to be released in a few days. Thanks all for your replies. John On 2021-09-22 5:27 p.m., Gyle McCollam wrote: I've had the same issue it rounding my 5 decimal holdings to 2 decimals. I was told that if you select OK, it rounds to 2 decimals in v4.6, but if you just hit enter it leaves it as you entered it. That works for me, although I do think that needs to be fixed. Thank You, *Gyle McCollam* Gyle McCollam 609.680.2326Mobile gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email *From:* gnucash-user on behalf of John Edgar *Sent:* Wednesday, September 22, 2021 5:51 PM *To:* gnucash-user@gnucash.org *Subject:* [GNC] Investment Portfolio Reports Question Using GNUCash 4.6 I manually update my mutual fund closing price daily for the investment/advanced portfolio reports. My report preference is set to a 4 decimal number, as that is the format my bank supplies. However, when I update the price, these reports round the price value to 2 decimal value, causing the report to display a much different value of my fund holding than is reported by my bank. Is there a preference or option I am missing to ensure the report remains as non-rounded 4 decimal value ? I am unable to find a reference in the help guide. Thank you for your help. -- This email has been checked for viruses by AVG. https://www.avg.com <https://www.avg.com> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <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.
Re: [GNC] Investment Portfolio Reports Question
Great !!! Thank you !!! On 2021-09-22 5:16 p.m., John Ralls wrote: That sounds like https://bugs.gnucash.org/show_bug.cgi?id=798219 and it's fixed for GnuCash 4.7 that we'll release this weekend. Regards, John Ralls On Sep 22, 2021, at 2:51 PM, John Edgar wrote: Using GNUCash 4.6 I manually update my mutual fund closing price daily for the investment/advanced portfolio reports. My report preference is set to a 4 decimal number, as that is the format my bank supplies. However, when I update the price, these reports round the price value to 2 decimal value, causing the report to display a much different value of my fund holding than is reported by my bank. Is there a preference or option I am missing to ensure the report remains as non-rounded 4 decimal value ? I am unable to find a reference in the help guide. Thank you for your help. -- This email has been checked for viruses by AVG. https://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] Investment Portfolio Reports Question
Thanks for the reply, David. The report displays on the screen as a 4 decimal value, however that value is rounded as if it is a 2 decimal place value. For example: if the value entered is $45.6789 , it is immediately switched to $45.6800. That becomes the new value and throws the fund value way off. On 2021-09-22 3:00 p.m., David Carlson wrote: I am still using release 3.8, but as far as I can remember in the past, price displays defaulted to four decimal places. In fact, right now I cannot find where that decimal count is determined. If release 4.6 only shows two decimal places, I would consider that to be a bug. On the other hand if there is a setting for that, I hope someone can point us to it. On Wed, Sep 22, 2021 at 4:52 PM John Edgar <mailto:jsedga...@gmail.com>> wrote: Using GNUCash 4.6 I manually update my mutual fund closing price daily for the investment/advanced portfolio reports. My report preference is set to a 4 decimal number, as that is the format my bank supplies. However, when I update the price, these reports round the price value to 2 decimal value, causing the report to display a much different value of my fund holding than is reported by my bank. Is there a preference or option I am missing to ensure the report remains as non-rounded 4 decimal value ? I am unable to find a reference in the help guide. Thank you for your help. -- This email has been checked for viruses by AVG. https://www.avg.com <https://www.avg.com> ___ 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. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] Investment Portfolio Reports Question
That sounds like https://bugs.gnucash.org/show_bug.cgi?id=798219 and it's fixed for GnuCash 4.7 that we'll release this weekend. Regards, John Ralls > On Sep 22, 2021, at 2:51 PM, John Edgar wrote: > > Using GNUCash 4.6 > > I manually update my mutual fund closing price daily for the > investment/advanced portfolio reports. My report preference is set to a 4 > decimal number, as that is the format my bank supplies. However, when I > update the price, these reports round the price value to 2 decimal value, > causing the report to display a much different value of my fund holding than > is reported by my bank. > > Is there a preference or option I am missing to ensure the report remains as > non-rounded 4 decimal value ? I am unable to find a reference in the help > guide. > > Thank you for your help. > > > > -- > This email has been checked for viruses by AVG. > https://www.avg.com > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > 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] Investment Portfolio Reports Question
Using GNUCash 4.6 I manually update my mutual fund closing price daily for the investment/advanced portfolio reports. My report preference is set to a 4 decimal number, as that is the format my bank supplies. However, when I update the price, these reports round the price value to 2 decimal value, causing the report to display a much different value of my fund holding than is reported by my bank. Is there a preference or option I am missing to ensure the report remains as non-rounded 4 decimal value ? I am unable to find a reference in the help guide. Thank you for your help. -- This email has been checked for viruses by AVG. https://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] Account setup
No, you don't want Imbalance-USD to have a balance. That's a safety-valve account that GnuCash uses when you make an unbalanced transaction by mistake. Opening Balances is for personal books. For a business you have two kinds of Equity: Paid in Capital, which is the money that you and any partners have invested in the business, and Retained Earnings, which is the net profit or loss from prior years. In the simplest case those will be the only two Equity accounts and should balance the difference between Assets and Liabilities. To create an opening transaction open the retained earnings register and start a new transaction in split mode. You can use Opening Balances as the transaction description if you like. Create a split for each asset and liability account with a balance. Don't forget to carry over contra accounts (e.g. depreciation) too. GnuCash will keep a running total in the blank split. When you're done with the assets and liabilities create Equity:Paid in Capital and credit however much that was. The remaining balance should match your carried over retained earnings, so you can just assign the split to Equity:Retained Earnings and you're done. If you're going to use GnuCash's billing and invoicing features, do *not* create splits for carried-over accounts payable and receivable in the Accounts Payable or Accounts Receivable accounts. Instead recreate the outstanding bills and invoices and close the income and expenses accounts into Retained Earnings before you start on the opening balances transaction. Be sure to use the Balance Sheet and Trial Balance Sheet reports to check your work before you start entering regular transactions. If you're going to be keying in 2020 and 2021 transactions refresh those reports often as you input so that you can catch mistakes when you have a small number of new transactions to hunt in. It can be really frustrating to hunt for a 0.03 error in 2 years of transactions. Regards, John Ralls > On Sep 22, 2021, at 1:28 PM, Rogier F. van Vlissingen > wrote: > > I guess that goes to Imbalance-USD, but then how does that balance out? Or > is it that once all the amounts are correct, it will balance and the > imbalance must revert to zero? How does that happen if some of the opening > balances were non-zero out of thin air? > > > On Wed, Sep 22, 2021 at 4:21 PM Rogier F. van Vlissingen > wrote: > >> OH, thanks >> >> Yeah, I already proceeded, I filled in the opening balances where I could, >> and am now starting to create the other accounts which did not exist in the >> standard chart of accounts, but trying to go and edit "retained earnings" I >> do not see how I can add the opening balance. >> >> it's not too many accounts in all, probably 25 total. >> >> So, if I create that opening balance as a transaction e.g. for retained >> earnings, where does the balancing transaction go? I guess I am not God's >> greatest gift to the bookkeeping profession ;-) >> >> >> <http://rogierfentenervanvlissingen.me?promo=email_sig_source=product_medium=email_sig_campaign=gmail_api_content=thumb> >> Rogier Fentener van Vlissingen <http://rogierfentenervanvlissingen.me> >> >> >> <http://rogierfentenervanvlissingen.me?promo=email_sig_source=product_medium=email_sig_campaign=gmail_api_content=thumb> >> >> >> On Wed, Sep 22, 2021 at 4:00 PM Stephen M. Butler < >> stephen.m.butle...@gmail.com> wrote: >> >>> Roger, >>> >>> I found it easier to leave all the opening balances at zero while >>> setting up the chart of accounts (COA). Then I create one massive >>> opening transaction dated (in your case) 12/31/2019. >>> >>> That way, if I find I forgot one account, I can add it later then go >>> back and adjust the opening transaction to include an entry for that new >>> account (I know the purist will have nightmares and would prefer you add >>> a new transaction). >>> >>> --Steve >>> >>> On 9/22/21 12:43 PM, Rogier F. van Vlissingen wrote: >>>> I am struggling to move an existing business into gnucash. >>>> >>>> Have a closing trial balance @ year end 2019 >>>> >>>> In the setup screen I don't necessarily have all the accounts, so I >>> imagine >>>> I can set them up later, but some accounts that area available do not >>> let >>>> me put in an opening balance. >>>> >>>> E.g. "retained earnings" has a balance, but in the set up screen there >>> is a >>>> greyed out "zero" and I cannot set up the opening balance. Can I edit >>> that
Re: [GNC] Price showing formula in security register
> On Sep 21, 2021, at 11:47 AM, Don wrote: > > (I am using ver 4.6 flatpak) > > In the securities register for one of my mutual fund accounts I > double-clicked on the "Price" column expecting it to resize that column > to fit the prices shown. Instead it changed the contents of the price > entries to show a formula > > 10 + 170200/704349 > > I want to change it back but cannot find a way to do that. > > Oddly, if I select one of the price fields that one changes to show the > decimal price to 9 decimal places but when I leave that field it goes back > to showing the formula. That's not a formula, it is the exact representation of the price, a value that cannot be expressed as a decimal without rounding. You can force decimal display of prices with the checkbox at the top of the page on Preferences>Numbers, Date, Time. The number of decimal places is hard-coded to 2 more than the currency's smallest currency unit (or the smaller of the two in the case of an exchange rate between two currencies). That's 2 in most currencies. Note that while that price was probably created from a split and is the exact ratio of the amount and value of the split, changing it won't affect the price of the split itself: The pricedb is used for reporting, not for balancing. Note as well that if you enter a price to nine decimals by hand it will either display as a fraction or rounded to the number of decimals according to the smallest-currency-unit =2 rule. Internally it's always the exact fraction. Regards, John Ralls ___ 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] macOS: Scrollbar of accounts not working
> On Sep 16, 2021, at 4:35 AM, Eugen und Imelda Hegglin Casanova > wrote: > > Dear GnuCash community, > I am trying to use GnuCash version 4.6+(2021-06-26) which I installed on a > MacBook Air (M1, 2020) running macOS Big Sur 11.6 using the archive > 'Gnucash-Intel-4.6-1.dmg'. > Unfortunately, the scrollbar of an arbitrary account does not work as > expected (see https://imgur.com/a/W4XJ6w4): Instead of allowing for scrolling > through the whole list of transactions, only 7 transactions are shown on > screen and the scrollbar cannot be moved. On windows the same xml file and > all its transactions can be viewed without any problem. I tried to adjust the > filter settings (View > Filter By > Select Range) but the transactions shown > remain unaffected. > I suspect it is a bug which causes these viewing issues, but would happily be > advised otherwise. Thank you for your suggestions. It's not about the scrollbar, your image clearly shows that the register window contains only those transactions. Check the other tab of the Filter dialog and make sure that all of the boxes are checked and check Preferences>Register Defaults and make sure that Number of Transactions is 0. Regards, John Ralls ___ 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] Calculating interest rates
> On Sep 13, 2021, at 7:46 AM, Steve Hill wrote: > > > Despite much Googling I haven't been able to find anything explaining how to > calculate this... > > I know: > - The balance of a savings account at the start of the year; > - The amounts and dates of payments into the account; and > - The amount of interest paid at the end of the year. > > I want to calculate the percent of interest received, assuming that the > account compounds daily. > > If there were no payments into the account it would be easy > (interest_amount/start_balance=interest_percent), but I can't figure out how > to take account of irregular payments into the account throughout the year. You're looking for internal rate of return. Most spreadsheets have an XIRR function that takes an array of dates and cash flows along with a starting guess and calculates the actual daily rate. The documentation for LibreOffice's version is at https://wiki.documentfoundation.org/Documentation/Calc_Functions/XIRR <https://wiki.documentfoundation.org/Documentation/Calc_Functions/XIRR> Regards, John Ralls ___ 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] Redo account reconciliations
> On Sep 6, 2021, at 12:35 PM, Borden via gnucash-user > wrote: > > My professional advice Just curious, where are you licensed and what's the focus of your practice? Regards, John Ralls ___ 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] Redo account reconciliations
Oops, that'w wrong: You can't use the February statement's balance, you have to use the July statement balance (assuming that you haven't yet reconciled August) because the reconcile window doesn't know how to use xaccAccountGetReconciledBalanceAsOfDate. Regards, John Ralls > On Sep 4, 2021, at 7:59 AM, john wrote: > > He said the February reconcile. > > So tell the reconcile info dialog 28 Feb and type in the balance from the > February statement as usual. Click OK. As long as you haven't messed up > anything else you'll be able to check the one unreconciled split from > February and the finish button and you're done. > > Regards, > John Ralls > > >> On Sep 4, 2021, at 7:18 AM, Derek Atkins wrote: >> >> Ah... But that's NOT how you are supposed to recover from that. >> If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction, >> it doesn't matter what date the transaction has -- you should re-reconcile >> 31 August! You just need to re-check the February transaction. >> >> -derek >> >> On Sat, September 4, 2021 9:10 am, Christopher Lam wrote: >>> Derek, >>> Consider a well-used bank account. You reconcile every end of the month >>> successfully up to 31 Aug 2021. >>> Accidentally you unreconcile a Feb 2021 split. >>> You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail >>> because the reconciliation end balance also tallies splits from March 2021 >>> onwards. >>> C >>> >>> On Sat, 4 Sept 2021 at 13:01, Derek Atkins wrote: >>> >>>> Chris, >>>> >>>> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote: >>>>> I agree that if an account reconciliation is done periodically >>>> correctly >>>>> every time, then it works well. If an old reconciled split is >>>> unreconciled >>>>> and we need to re-reconcile a previous reconciliation date, then the >>>> code >>>>> falls apart. >>>> >>>> I'm curious why you say it falls apart? >>>> >>>>> It may be an idea to allow batch unreconciliation of all splits whose >>>>> reconcile date is after the reconciliation date in the Reconciliation >>>>> dialog, thereby allowing the user to re-do reconciles. >>>> >>>> That could be a good idea. >>>> >>>> -derek >>>> >>>>> On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user < >>>>> gnucash-user@gnucash.org> wrote: >>>>> >>>>>> >>>>>> >>>>>>> The starting balance is computed from all the reconciled >>>> transactions >>>>>> "to >>>>>>> date". It *can* be safe to ignore the starting balance if, for >>>>>> example, >>>>>> a >>>>>>> transaction became unreconciled. For example, let's say you >>>> reconcile >>>>>>> from some starting balance X to a final balance of $1000. Then you >>>>>>> accidentally unreconcile a $100 transactions. If you try to >>>>>> re-reconcile >>>>>>> that same statement/date/ending-balance of $1000, it won't show X >>>> as >>>>>> the >>>>>>> starting balance, but something else (PROBABLY $900, but I'm not >>>> 100% >>>>>>> sure). But that's okay -- just ensure the ending balance is >>>> correct >>>>>> and >>>>>>> all the transactions that SHOULD be reconciled ARE reconciled. >>>>>>> >>>>>>> There is no way to get a transaction to reconciled status (y) >>>> manually >>>>>> -- >>>>>>> the only way is through a reconcile process. So if you have >>>>>> reconciled >>>>>>> transactions, that must've happened through a reconcile. >>>>>>> >>>>>>> I would recommend you just go ahead with March, ignore the starting >>>>>>> balance, enter the correct March ending balance, and see if the >>>>>>> reconciliation works (ensure you re-reconcile anything from earlier >>>>>> that >>>>>>> might have become unreconciled). >>>>>>> >>>>>> So I just want to build a bit on this answer. GNUCash doesn't have >>>> QBs >>>>>>
Re: [GNC] Redo account reconciliations
He said the February reconcile. So tell the reconcile info dialog 28 Feb and type in the balance from the February statement as usual. Click OK. As long as you haven't messed up anything else you'll be able to check the one unreconciled split from February and the finish button and you're done. Regards, John Ralls > On Sep 4, 2021, at 7:18 AM, Derek Atkins wrote: > > Ah... But that's NOT how you are supposed to recover from that. > If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction, > it doesn't matter what date the transaction has -- you should re-reconcile > 31 August! You just need to re-check the February transaction. > > -derek > > On Sat, September 4, 2021 9:10 am, Christopher Lam wrote: >> Derek, >> Consider a well-used bank account. You reconcile every end of the month >> successfully up to 31 Aug 2021. >> Accidentally you unreconcile a Feb 2021 split. >> You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail >> because the reconciliation end balance also tallies splits from March 2021 >> onwards. >> C >> >> On Sat, 4 Sept 2021 at 13:01, Derek Atkins wrote: >> >>> Chris, >>> >>> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote: >>>> I agree that if an account reconciliation is done periodically >>> correctly >>>> every time, then it works well. If an old reconciled split is >>> unreconciled >>>> and we need to re-reconcile a previous reconciliation date, then the >>> code >>>> falls apart. >>> >>> I'm curious why you say it falls apart? >>> >>>> It may be an idea to allow batch unreconciliation of all splits whose >>>> reconcile date is after the reconciliation date in the Reconciliation >>>> dialog, thereby allowing the user to re-do reconciles. >>> >>> That could be a good idea. >>> >>> -derek >>> >>>> On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user < >>>> gnucash-user@gnucash.org> wrote: >>>> >>>>> >>>>> >>>>>> The starting balance is computed from all the reconciled >>> transactions >>>>> "to >>>>>> date". It *can* be safe to ignore the starting balance if, for >>>>> example, >>>>> a >>>>>> transaction became unreconciled. For example, let's say you >>> reconcile >>>>>> from some starting balance X to a final balance of $1000. Then you >>>>>> accidentally unreconcile a $100 transactions. If you try to >>>>> re-reconcile >>>>>> that same statement/date/ending-balance of $1000, it won't show X >>> as >>>>> the >>>>>> starting balance, but something else (PROBABLY $900, but I'm not >>> 100% >>>>>> sure). But that's okay -- just ensure the ending balance is >>> correct >>>>> and >>>>>> all the transactions that SHOULD be reconciled ARE reconciled. >>>>>> >>>>>> There is no way to get a transaction to reconciled status (y) >>> manually >>>>> -- >>>>>> the only way is through a reconcile process. So if you have >>>>> reconciled >>>>>> transactions, that must've happened through a reconcile. >>>>>> >>>>>> I would recommend you just go ahead with March, ignore the starting >>>>>> balance, enter the correct March ending balance, and see if the >>>>>> reconciliation works (ensure you re-reconcile anything from earlier >>>>> that >>>>>> might have become unreconciled). >>>>>> >>>>> So I just want to build a bit on this answer. GNUCash doesn't have >>> QBs >>>>> reconciliation system - so don't equate the two. As an accountant who >>>>> doesn't need to be handheld or leashed, I find GNUCash's system >>> better >>>>> than QBs - albeit there is room for improvement. However, I wouldn't >>>>> recommend GNUCash to someone less comfortable with bare-ledger >>>>> accounting - >>>>> controls exist for a reason. >>>>> >>>>> I don't know how the backend works, but my experience is that the >>>>> "Opening >>>>> balance" is basically a running total of all the transactions marked >>>>> "Reconciled" in that acc
Re: [GNC] Deleting Scheduled Transactions
The checkbox in the scheduled transactions list is just for display. Edit the scheduled transaction and uncheck enabled on the Frequency tab, then click OK to complete the edit. Regards, John Ralls > On Sep 3, 2021, at 7:33 AM, Jack Frillman via gnucash-user > wrote: > > Your last suggestion got me what I wanted. > Thanks. > > BTW: I'm not able to uncheck the Enabled check box for some reason. Running > Version 4.4 on a Mac. I thought I did that before but I can't now for some > odd reason. > > > > On 9/3/21 9:03 AM, Derek Atkins wrote: >> HI, >> >> On Fri, September 3, 2021 8:54 am, Jack Frillman via gnucash-user wrote: >>> How do you delete/remove a scheduled transaction from the list of >>> scheduled transactions under the scheduled transaction tab? >> So just to be clear, you are trying to remove the full schedule (not >> existing, fired-off transactions from your CoA), right? You just want it >> to stop firing off in the future... >> >>> I tried unchecking the Enabled check box but that didn't do anything. I >>> tried the Delete button in the transaction editor and that didn't do >>> anything. I tried doing it from the calendar and had no luck. I checked >>> the GNUC documentation and didn't find anything on how to remove/delete >>> a scheduled transaction. >> Unchecking the Enabled box will cause the SX never to fire again, so it >> won't create new transactions in the future. >> >>> So how can I remove/delete a scheduled transaction? >> If you go to Actions -> Scheduled Transactions -> Scheduled Transaction >> Editor it brings up the SX page. From there you can click on the SX you >> want to delete and then click on the "Delete" toolbar item to delete the >> SX. >> >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> -derek >> > > -- > Old Unix programmers never die, they just mv to /dev/null > - Anonymous > > ___ > 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] Trial Balance Issue with Fund Merger
> On Sep 1, 2021, at 12:16 PM, John Ralls wrote: > > > >> On Sep 1, 2021, at 11:15 AM, Lisa Rowell wrote: >> >> >> On 9/1/2021 5:27 AM, Lisa Rowell wrote: >>> >>> On 8/31/2021 9:41 PM, John Ralls wrote: >>>> >>>>> On Aug 31, 2021, at 8:32 PM, Lisa Rowell wrote: >>>>> >>>>> I'm working my way through my account history after a massive GnuCash >>>>> import, straightening out issues with missing realized capital >>>>> gains/losses and came across an event that I can't figure out how to >>>>> properly handle. >>>>> >>>>> I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) >>>>> which merged with Spartan US Equity Index Investor Class (FUSEX) at some >>>>> odd rate around 1:0.513. When I did the import, I ended up with an >>>>> account for FSMKX and an account for FUSEX and a manually entered >>>>> exchange transaction which did a sell of FSMKX shares and a buy of FUSEX >>>>> shares with no share price. This got everything balanced out as far as >>>>> share counts go, but now I'm finding it's showing up as being not correct >>>>> in the Trial Balance. It looks to me like the exchange is being >>>>> interpreted as if an actual sell event had taken place. >>>>> >>>>> Can GnuCash properly account for this? The case in the manual's More >>>>> Complex Merger example is a bit different because the example stock >>>>> continued to trade under the same symbol, so that solution doesn't map >>>>> well. I found a past mailing list thread that said that the proper way to >>>>> account for this is as a sell transaction of the going away fund and a >>>>> buy transaction of the fund that lives on with an accompanying Realized >>>>> Gain transaction. This doesn't seem right to me though since I didn't >>>>> sell the shares and did not realize a gain and I don't even have prices >>>>> for the time of the merger. In my way of looking at it, the gain >>>>> calculation should come at the time of sale and be based on purchase >>>>> price of the various share amounts, and not at the time of the merger, >>>>> since that maps to the tax view of things where I live. >>>>> >>>>> I understand that GnuCash wouldn't be able to calculate the realized >>>>> gains post merger, and I'm ok with doing that in a side spreadsheet, but >>>>> am more looking for a way around the bogus realized gain entry at the >>>>> time of merger just to make the Trial Balance happy. >>>> If you're not too compulsive and since this is presumably ancient history >>>> in a personal book one simple way to deal with it would be to pretend that >>>> you bought the FUSEX in the first place and ignore the FSMKX, but that >>>> might be a little painful if you have a bunch of reinvested FSMKX dividend >>>> transactions that you'd also need to change. >>>> >>>> I've handled similar situations in the past by doing a simple transfer >>>> transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX >>>> 1000. As long as there's no currency component to the transaction it >>>> shouldn't create a trading imbalance in the book currency. >>>> >>>> Regards, >>>> John Ralls >>> >>> That solution was what worked for me for share transfers between >>> brokerages, where the commodity was the same, but when I changed >>> commodities it somehow shows up as a mismatch in the Trial Balance. I don't >>> have a share price for the shares in either split so, in theory it >>> shouldn't involve the book currency at all. I don't get it at all. >>> >>> I'm sure it's this transaction since the balances match on the previous day >>> and the only other transaction on this date is a paycheck deposit in the >>> book currency that's no where near the amount of the imbalance. The >>> transaction is in the image attached, that's what you're advocating, right? >>> >>> Thanks. >>> >>> Lisa R. >>> >> Additional information: >> >> Removing the cross commodity sell/buy transaction does remove the Trial >> Balance discrepancy. Additionally I added up all of the purchase prices of >> shares of the fund being merged away
Re: [GNC] Trial Balance Issue with Fund Merger
> On Sep 1, 2021, at 11:15 AM, Lisa Rowell wrote: > > > On 9/1/2021 5:27 AM, Lisa Rowell wrote: >> >> On 8/31/2021 9:41 PM, John Ralls wrote: >>> >>>> On Aug 31, 2021, at 8:32 PM, Lisa Rowell wrote: >>>> >>>> I'm working my way through my account history after a massive GnuCash >>>> import, straightening out issues with missing realized capital >>>> gains/losses and came across an event that I can't figure out how to >>>> properly handle. >>>> >>>> I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) >>>> which merged with Spartan US Equity Index Investor Class (FUSEX) at some >>>> odd rate around 1:0.513. When I did the import, I ended up with an account >>>> for FSMKX and an account for FUSEX and a manually entered exchange >>>> transaction which did a sell of FSMKX shares and a buy of FUSEX shares >>>> with no share price. This got everything balanced out as far as share >>>> counts go, but now I'm finding it's showing up as being not correct in the >>>> Trial Balance. It looks to me like the exchange is being interpreted as if >>>> an actual sell event had taken place. >>>> >>>> Can GnuCash properly account for this? The case in the manual's More >>>> Complex Merger example is a bit different because the example stock >>>> continued to trade under the same symbol, so that solution doesn't map >>>> well. I found a past mailing list thread that said that the proper way to >>>> account for this is as a sell transaction of the going away fund and a buy >>>> transaction of the fund that lives on with an accompanying Realized Gain >>>> transaction. This doesn't seem right to me though since I didn't sell the >>>> shares and did not realize a gain and I don't even have prices for the >>>> time of the merger. In my way of looking at it, the gain calculation >>>> should come at the time of sale and be based on purchase price of the >>>> various share amounts, and not at the time of the merger, since that maps >>>> to the tax view of things where I live. >>>> >>>> I understand that GnuCash wouldn't be able to calculate the realized gains >>>> post merger, and I'm ok with doing that in a side spreadsheet, but am more >>>> looking for a way around the bogus realized gain entry at the time of >>>> merger just to make the Trial Balance happy. >>> If you're not too compulsive and since this is presumably ancient history >>> in a personal book one simple way to deal with it would be to pretend that >>> you bought the FUSEX in the first place and ignore the FSMKX, but that >>> might be a little painful if you have a bunch of reinvested FSMKX dividend >>> transactions that you'd also need to change. >>> >>> I've handled similar situations in the past by doing a simple transfer >>> transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 1000. >>> As long as there's no currency component to the transaction it shouldn't >>> create a trading imbalance in the book currency. >>> >>> Regards, >>> John Ralls >> >> That solution was what worked for me for share transfers between brokerages, >> where the commodity was the same, but when I changed commodities it somehow >> shows up as a mismatch in the Trial Balance. I don't have a share price for >> the shares in either split so, in theory it shouldn't involve the book >> currency at all. I don't get it at all. >> >> I'm sure it's this transaction since the balances match on the previous day >> and the only other transaction on this date is a paycheck deposit in the >> book currency that's no where near the amount of the imbalance. The >> transaction is in the image attached, that's what you're advocating, right? >> >> Thanks. >> >> Lisa R. >> > Additional information: > > Removing the cross commodity sell/buy transaction does remove the Trial > Balance discrepancy. Additionally I added up all of the purchase prices of > shares of the fund being merged away and that amount does equal to the credit > / debit difference in the report. > It is, but that doesn't quite work. Here's a sample that does: If you don't price the share transfer to the currency (USD in both examples) the trial balance logic assumes 0 and calculates a loss. To avoid that enter the book value of the shares you're transferring as a sell (credit) amount in the source split and a buy (debit) amount in the destination split: ___ 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] Information
It can, but it has a rendering issue on Retina screens set to something other than the default scaling, see https://bugs.gnucash.org/show_bug.cgi?id=798207. Regards, John Ralls > On Sep 1, 2021, at 11:31 AM, Chris Green wrote: > > On Wed, Sep 01, 2021 at 12:02:42PM -0500, alanmagnus wrote: >> Is Gnucash yet compatible with the upcoming Mac OSX Monterey? > > Or, to put it another way, can the new Mac OSX Monterey run GnuCash? > > -- > Chris Green > ___ > 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] Trial Balance Issue with Fund Merger
> On Aug 31, 2021, at 8:32 PM, Lisa Rowell wrote: > > I'm working my way through my account history after a massive GnuCash import, > straightening out issues with missing realized capital gains/losses and came > across an event that I can't figure out how to properly handle. > > I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) which > merged with Spartan US Equity Index Investor Class (FUSEX) at some odd rate > around 1:0.513. When I did the import, I ended up with an account for FSMKX > and an account for FUSEX and a manually entered exchange transaction which > did a sell of FSMKX shares and a buy of FUSEX shares with no share price. > This got everything balanced out as far as share counts go, but now I'm > finding it's showing up as being not correct in the Trial Balance. It looks > to me like the exchange is being interpreted as if an actual sell event had > taken place. > > Can GnuCash properly account for this? The case in the manual's More Complex > Merger example is a bit different because the example stock continued to > trade under the same symbol, so that solution doesn't map well. I found a > past mailing list thread that said that the proper way to account for this is > as a sell transaction of the going away fund and a buy transaction of the > fund that lives on with an accompanying Realized Gain transaction. This > doesn't seem right to me though since I didn't sell the shares and did not > realize a gain and I don't even have prices for the time of the merger. In my > way of looking at it, the gain calculation should come at the time of sale > and be based on purchase price of the various share amounts, and not at the > time of the merger, since that maps to the tax view of things where I live. > > I understand that GnuCash wouldn't be able to calculate the realized gains > post merger, and I'm ok with doing that in a side spreadsheet, but am more > looking for a way around the bogus realized gain entry at the time of merger > just to make the Trial Balance happy. If you're not too compulsive and since this is presumably ancient history in a personal book one simple way to deal with it would be to pretend that you bought the FUSEX in the first place and ignore the FSMKX, but that might be a little painful if you have a bunch of reinvested FSMKX dividend transactions that you'd also need to change. I've handled similar situations in the past by doing a simple transfer transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 1000. As long as there's no currency component to the transaction it shouldn't create a trading imbalance in the book currency. Regards, John Ralls ___ 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] Transaction Entry Confirmation
> On Aug 31, 2021, at 8:06 AM, Jack Frillman via gnucash-user > wrote: > > > Is there any way to have GNU Cash make an audio confirmation when a manual > transaction has been entered? > > When I manually enter a transaction by mashing ENTER there is no feedback > that the transaction was entered and I keep hitting ENTER to be sure I didn't > fat finger it. > Just a little beep would suffice. No, sorry. Regards, John Ralls ___ 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] Can GnuCash compute income from foreign exchange transactions using the first in first out method?
GnuCash does have that built in, see Actions>View Lots. It is however a bit cumbersome and isn't likely to scale well for your use case. You might try using trading accounts and creating a balancing G/L transaction at the end of each day, but I think that will come out closer to average cost than to fifo. Regards, John Ralls > On Aug 30, 2021, at 5:04 PM, Tim Hume via gnucash-user > wrote: > > Hi everyone, > > I'm using GnuCash for a small money transfer business. There are lots of > transactions from Australia to Tonga, and transactions going the other way > (Tonga to Australia) too. Transactions are of varying amounts and happen > frequently. > > From day to day GnuCash handles this fine (though the database is getting > rather large). In fact, one reason for using GnuCash is that it handles > foreign currencies (and it's free). For tax, it is necessary to compute > income using the first in first out method (FIFO). The way I've been doing > this to date is to dump the transactions going through the trading accounts > into CSV format, and then using a small program I wrote to compute the income > using the FIFO method (the program is written in awk for anyone curious). > > However, it would be really nice if GnuCash could do this computation itself. > Is this possible? > > Cheers, > > Tim. > > Sent with ProtonMail Secure Email. > ___ > 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] Alternate Language (Again)
> On Aug 27, 2021, at 2:59 PM, wrote: > > I should be following up an earlier thread of two weeks ago, but I find I've > deleted the messages from my Inbox and can't see any way to "Reply To" > something I only have in the archives. So I'm creating a new thread > (Apologies: I'm no longer used to using true mailing lists instead of > wrappers like nabble that make it all child's play). > > Here's that prior thread: > >> On Aug 20, 2021, at 10:29 AM, > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> wrote: >> >> Hello all. This may have already been covered, but after the death of > Nabble >> I can't see how to do searches throughout the archive. >> >> I need to produce accounting reports in a different language (French), but > I >> would prefer to use a single installation of Gnucash (all my other sets of >> books are English). >> >> 1. Can I switch languages just for printing the reports? If yes, how? I >> understand that the Account Names, Descriptions, and so on are all going > to >> need to be recorded in French in this set of books. >> >> 2. If that's not possible, how can I install two versions of GnuCash on >> Windows? Can I open the books in English Gnucash, work on them, then close >> and reopen the same books in the French GnuCash? > > Most search engines can search the list archives, just say > site:lists.gnucash.org/pipermail/gnucash-user followed by your search terms. > > There's no such thing as English or French versions of GnuCash, every > installation on Windows and macOS includes all of the translations. Some > Linux distros try to save a few kB of space by separating out the > translations, but that's not your concern. > > What you want to do is make a shortcut to GnuCash with the LANG environment > variable set to "fr_FR" as explained by this blog post: > https://netlicensing.io/blog/2012/06/15/set-environment-variables-in-windows > -shortcut/ > > Regards, > John Ralls > > = > > That seemed to fully answer the basic question, but now that I try it out, I > find it doesn't work. I still get everything (except the creation of the > Chart of Accounts, for which the language selection is working) in English. > > Here is the shortcut target I'm using, as per the link suggested: > > C:\Windows\System32\cmd.exe /c "SET LANG=fr_FR && START /D ^"C:\Program > Files (x86)\gnucash\bin^" gnucash.exe" > > Compare with the webpage text, which is: > C:\Windows\System32\cmd.exe /c "SET LANG=en && START /D ^"C:\Program Files > (x86)\Inkscape^" inkscape.exe" > > As these are as close to identical as can be achieved, I am at a loss as to > why it doesn't work. GnuCash has another layer to it's localization. Try C:\Windows\System32\cmd.exe /c "SET LANG=fr_FR && SET LANGUAGE=fr_FR && START /D ^"C:\Program Files (x86)\gnucash\bin^" gnucash.exe" Regards, John Ralls ___ 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] windows 10 and v4.6 possible system language vs appliation language
> On Aug 27, 2021, at 12:37 PM, Karin Lagesen wrote: > > Hi! > > I just started using v4.6 on a new machine running windows 10. For > various reasons, despite being in Norway, I prefer having US language on my > main computer, including date formats. However, I prefer having numbers on > gnucash being in Norwegian format. > > Is there any way to run gnucash in Norwegian on a otherwise US region > computer? > https://wiki.gnucash.org/wiki/FAQ#Q:_I_want_to_use_GnuCash_in_a_different_language_than_my_monetary.2Fdecimal_separator Regards, John Ralls ___ 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] Paying expenses with cryptocurrency
> On Aug 27, 2021, at 10:25 AM, David G. Pickett via gnucash-user > wrote: > > I am sure the accountants would not like the idea, but it opens the subject > of having different accounts in different currencies. This seems less > revolutionary in an international commerce world, like having a London > account in Pounds Sterling. You could buy with any account in the currency > of that account, rather than a book/default currency. I wonder if that would > hide any capital appreciation in the currency, perhaps legally, somewhat like > barter? I guess it would be an enhancement suggestion. I guess you mean to allow Equity accounts in foreign--meaning not the book's--currencies. You can already have Asset and Liability accounts in any commodity you like. Legality aside, why would you want to hide trading G/L from yourself? Why go to the trouble of keeping your books in GnuCash if you don't want an accurate model of your financial condition? Regards, John Ralls ___ 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] Paying expenses with cryptocurrency
> On Aug 25, 2021, at 10:29 PM, Peter West wrote: > > The recommended mode of dealing with crypto seems to be to record your crypto > as a stock, and handle fluctuation in prices as you would for a stock. When > you are investing crypto that makes sense. But what if you are using crypto > for purchases? That is, if you are using cryptocurrency for the originally > intended purpose? > > Any ideas on how to record this? Aside from the way GnuCash presents assets in registers the only difference between currencies and non-currency commodities is that you can't have Equity or Payable/Receivable accounts denominated in non-currency commodities. We've been told by a licensed accountant that one shouldn't have those accounts in anything other than the book currency anyway. So the answer is that that's how you account for transactions in all currencies, crypto or national, other than the book currency: You price them back to the book currency on the day of the transaction and record any resulting trading gains or losses. Do it any other way and you'll make yourself crazy trying to get your book to balance. Regards, John Ralls ___ 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] Job Costing as now available
I'll respond now: No, nothing like that has been contributed nor is it being
contemplated by any of the core devs AFAIK. Well designed and written pull
requests welcome.
Regards,
John Ralls
> On Aug 21, 2021, at 9:42 AM, Mike Butcher wrote:
>
> Don, have you seen any response to this message or find a solution
> otherwise? I too need this function in a big way. Making a new account for
> every order is horribly messy and cumbersome. It's been a year and a half
> and I was hoping someone on the development team might have an answer. I
> love GNUcash for my personal life but cannot use it for business without
> some form of jobcosting. I have to reenter info into a database I
> assembled for that.
>
> Take care,
> ~Mike Butcher
>
> On Sat, May 23, 2020 at 4:04 PM doncram wrote:
>
>> Hi, I recently installed and am using GnuCash (Version: 3.10 / Build ID:
>> 3.10+(2020-04-11), on Windows). I am happy to see some functionality for
>> Job Costing has been added in recent years. This is very important to
>> develop so that many more small businesses could possibly use GnuCash. But
>> what is available vs. what is missing and critically needed?
>>
>> Job Costing allows for projects to be defined for, say, construction firms
>> building individual houses, or catering firms doing catering jobs, or
>> manufacturing firms building batches of product. Or it allows a nonprofit
>> or business to define a job for a specific grant or other restricted
>> funding source. And then to track and match the revenues and expenses
>> specific to each project.
>>
>> This is terribly important so that management can attempt to figure out
>> which jobs have been more profitable and why. And I have seen arriving
>> users turned away from GnuCash (e.g. a catering firm a few years ago)
>> because it has been so clear that GnuCash can't serve them. The catering
>> firm needed to do separate accounting & reports for each job, but if i
>> recall correctly was told that it should do it by creating new accounts
>> specific to each job. So its Chart of Accounts would grow longer and
>> longer as its Sales and various Expense types of accounts would have to be
>> duplicated for each repetitive client/job. It would need to create a new
>> account, e.g. Sales-Job#013 for the payments it received for job number 13,
>> and a new Food purchases-Job#13 and a new Labor-Job#13 etc. for each of its
>> standard type of expenses. This would rapidly become totally unworkable,
>> and it does not allow for side-by-side comparison of
>> revenues/expenses/profitability of jobs, so of course the catering person
>> went away. And for existing firms that do use GnuCash but have not tracked
>> separate projects/jobs to date, many of them could benefit if they could be
>> allowed to start doing so.
>>
>> In the current stable version of GnuCash, it is now possible to create
>> jobs. For example, I created a "test b company" with several expense
>> transactions, and created a "job1" underneath "customer A". I can't see
>> yet how to assign job codes to any specific revenue or expense item. In
>> any account register, a new Customer:Job column needs to appear, where I
>> would enter the relevant job for each line ("split"). I should not be
>> _required_ to enter anything into the Customer:Job column, but for any
>> split where I do want to assign the expense or revenue to a specific job, I
>> should be able to do so. And, say if I pay $200 to one contractor for work
>> done on two jobs, I would create two splits, one for each job, and record,
>> say $120 of contractor expense for job#13 and $80 for job #14.
>>
>> Then I want/need an Income Statement By Job report, which would be a
>> regular Income Statement in its first columns, and would report
>> job-specific income statements for each job in following columns. So this
>> would possibly become a very wide report, but that is okay by me, as long
>> as I can scroll over to see any specific job. And like for other reports,
>> I should be able to set Options / Display to show only the rows where there
>> is any non-zero data, and also only the columns where there is any non-zero
>> data (so in a report for Fiscal Year 2020, I don't have to see a column for
>> a job completed in 2018).
>>
>> The only report I find, though, is the one at Reports/Business/Job, which
>> turns out to be some kind of Aging of Receivables report for just one job.
>> Instead of allowing me to run this report for all jobs (like should be
>> available in a general Aging of Receivables r
Re: [GNC] Reports in Alternate Language
> On Aug 20, 2021, at 10:29 AM, wrote: > > Hello all. This may have already been covered, but after the death of Nabble > I can't see how to do searches throughout the archive. > > > > I need to produce accounting reports in a different language (French), but I > would prefer to use a single installation of Gnucash (all my other sets of > books are English). > > > > 1.Can I switch languages just for printing the reports? If yes, how? I > understand that the Account Names, Descriptions, and so on are all going to > need to be recorded in French in this set of books. > > > > 2.If that's not possible, how can I install two versions of GnuCash on > Windows? Can I open the books in English Gnucash, work on them, then close > and reopen the same books in the French GnuCash? > Most search engines can search the list archives, just say site:lists.gnucash.org/pipermail/gnucash-user followed by your search terms. There's no such thing as English or French versions of GnuCash, every installation on Windows and macOS includes all of the translations. Some Linux distros try to save a few kB of space by separating out the translations, but that's not your concern. What you want to do is make a shortcut to GnuCash with the LANG environment variable set to "fr_FR" as explained by this blog post: https://netlicensing.io/blog/2012/06/15/set-environment-variables-in-windows-shortcut/ Regards, John Ralls ___ 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] Finance::Quote on Mac M1
That's what "Perl from other sources may or may not work and will regardless require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path and @INC so that GnuCash can find the right F::Q. If you insist on that you're on your own." is about. The issue is that when you launch from Finder there's no shell so GnuCash can't see your MacPorts environment changes. Try launching GnuCash from a shell window that does have the MacPorts environment. Regards, John Ralls > On Aug 20, 2021, at 3:55 AM, Peter West wrote: > > Doesn’t work for me. > > Note: I’m assuming that the message Finance::Quote not installed properly, > when Add is invoked in the security editor, means that it’s not installed > properly. > > I depend a lot on MacPorts. I’ve tried forcing the installation with MacPorts > perl 5.34 foremost in my path, and with it (and all other perl binaries) > relegated in my path. It makes no difference to the appearance of that > message. > > In each case I have checked the installation paths of perl. In the first the > installation paths are in /opt/local, in the latter they are in /usr, > /Library, /System, /Network and /usr/local. > > Peter > — > Peter West > p...@ehealth.id.au > “On these two commandments depend all the Law and the Prophets.” > >> On 20 Aug 2021, at 2:21 pm, Colin wrote: >> >> Thank you John! I ran the commands you provided and Finance::Quote works for >> the first time since I got my M1 MacBook Air! I’ve been watching the >> Finance::Quote threads on the list the last few months, always hoping for a >> solution I could manage to I implement to fix the issue. No doubt I could >> have missed this if it was posted before, regardless you just made my day. >> >> For what it’s worth, my install of GnuCash was done the standard way - >> downloading the DMG from the website. >> >> Also, to make the solution crystal clear to those who are not as good on the >> command line, there was a typo in John’s most recent advice of the commands >> to run. It is B::Keywords (capital K): >> >> sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i Finance::Quote >> >> Very gratefully, >> Colin >> >>> On Aug 19, 2021, at 8:36 PM, gnucash-user-requ...@gnucash.org wrote: >>> >>> Message: 5 >>> Date: Thu, 19 Aug 2021 20:36:28 -0700 >>> From: John Ralls mailto:jra...@ceridwen.us>> >>> To: davel...@mac.com <mailto:davel...@mac.com> >>> Cc: Mailing List Gnucash >> <mailto:gnucash-user@gnucash.org>> >>> Subject: Re: [GNC] Finance::Quote on Mac M1 >>> Message-ID: <4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us >>> <mailto:4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us>> >>> Content-Type: text/plain; charset=utf-8 >>> >>> You didn't read my letter very carefully: You should be able to get quotes >>> now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; sudo cpan >>> -i Finance::Quote`. The system perl is a universal binary and works in both >>> native and Rosetta2 environments. Perl from other sources may or may not >>> work and will regardless require modifying >>> Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path >>> and @INC so that GnuCash can find the right F::Q. If you insist on that >>> you're on your own. >>> >>> As for a native M1 build, I haven't decided yet whether to do that before >>> the next major nettle release. I really don't like pushing development >>> software at ordinary users, it tends to make for unpleasant surprises. >>> Meanwhile GnuCash seems to work well under Rosetta2 so there's not a strong >>> argument for doing a native build until nettle's ARM64 implementation is in >>> a stable release. >>> >>> Regards, >>> John Ralls >> >> ___ >> 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.o
Re: [GNC] Finance::Quote on Mac M1
You didn't read my letter very carefully: You should be able to get quotes now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; sudo cpan -i Finance::Quote`. The system perl is a universal binary and works in both native and Rosetta2 environments. Perl from other sources may or may not work and will regardless require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path and @INC so that GnuCash can find the right F::Q. If you insist on that you're on your own. As for a native M1 build, I haven't decided yet whether to do that before the next major nettle release. I really don't like pushing development software at ordinary users, it tends to make for unpleasant surprises. Meanwhile GnuCash seems to work well under Rosetta2 so there's not a strong argument for doing a native build until nettle's ARM64 implementation is in a stable release. Regards, John Ralls > On Aug 19, 2021, at 3:12 PM, davelist--- via gnucash-user > wrote: > > So does this mean a future official build of gnucash will have an ARM version > and we'll be able to get quotes again? That would be great! > > Thanks, > Dave > >> On Aug 19, 2021, at 5:43 PM, John Ralls wrote: >> >> You can't escape the problems. ;-) >> >> FWIW I just completed building on an M1 with Monterey. Amazingly, there were >> only a few minor problems, one of which has nothing to do with M1 or >> Monterey: Boost's download site changed. >> >> Libdbi and libdbi-drivers last release tarballs were made in 2013 and >> include linker arguments that aren't supported. I switched the build to git >> clones so that the build can be regenerated from scratch. Both that and the >> Boost change are committed to gnucash-on-osx. >> >> The other problem, and perhaps the one that stopped you on MacPorts, is that >> even the latest release of Nettle from last month doesn't support ARM64. It >> tries to compile ARM32 and fails noisily for hundreds of unrecognized >> assembler instructions. The solution is to clone the master branch from >> http://git.lysator.liu.se/nettle/nettle and build that instead. >> >> BTW, on Finance::Quote I force-installed B::Keywords and installed Test2, >> after which everything else built correctly. Once F::Q was installed in >> /Library/Perl GnuCash was able to recognize it and enable the Get Quotes >> button. >> >> Regards, >> John Ralls >> >> >> >> >>> On Aug 19, 2021, at 1:40 AM, Peter West wrote: >>> >>> Hi John, >>> >>> I had already run into problems trying to build GnuCash on MacPorts. I was >>> encouraged to try to build by reading >>> <https://wiki.gnucash.org/wiki/MacOS/Quartz>. >>> >>> Peter >>> — >>> Peter West >>> p...@ehealth.id.au >>> “For behold, when the sound of your greeting came to my ears, the baby in >>> my womb leaped for joy.” >>> >>>> On 17 Aug 2021, at 1:02 am, John Ralls wrote: >>>> >>>> >>>> Support for gtk-osx is on its mailing list, >>>> https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you >>>> go there I'll remind you that one of gtk-osx's basic requirements is that >>>> you must not have Homebrew or MacPorts visible to it. >>>> >>>> Since you have MacPorts installed already the simplest way forward is to >>>> use that to build GnuCash. >>>> >>>> That said there's no shared code between anything to do with GnuCash and >>>> perl or any CPAN modules beyond the macOS SDK. Building GnuCash from >>>> source won't help you get Finance::Quote going. >>>> >>>> Regards, >>>> John Ralls >>>> >>>>> On Aug 16, 2021, at 7:18 AM, Peter West wrote: >>>>> >>>>> I removed the offending PREFIX line from jhbuildrc-custom, and >>>>> immediately ran into a similar problem. >>>>> >>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load >>>>> execfile(filename, config) >>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in >>>>> execfile >>>>> exec(code, globals, locals) >>>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in >>>>> exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec')) >>>>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in >>>>
[GNC] Creating Custom Reports
Good Day to you all! I have just set up my family finances with GnuCash (version 4.6) and am looking into the various reports. What I need, and have yet to find, is a simply report my wife and I can access to see how well me are doing with our budget each day. Specifically I am looking for the following: Checking Acct #1 Today's Balance + Checking Acct #2 Today's Balance = Daily Balance Subtotal - Budgeted Total amount budgeted for the current pay period. This would include All Budgeted Expenses & Amounts Transferred to holding accounts for later payments. This could also be expandable to the various sub accounts I have set up + Paid Amounts already paid out for all expenses and transfers to Holding Accounts. These cold also be expandable to include sub accounts. = Available Balance What is left for discretionary spending. This is the big one that I would like to see spelled out for us. Each of the reports I have seen and played with will do some of this but I haven't seen any that will give me all of the above. If there is something out there or if I am missing something, I would really like to know. Anyone who could help me out with this, I would really appreciate. Thank you very much. John ___ 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] Finance::Quote on Mac M1
You can't escape the problems. ;-)
FWIW I just completed building on an M1 with Monterey. Amazingly, there were
only a few minor problems, one of which has nothing to do with M1 or Monterey:
Boost's download site changed.
Libdbi and libdbi-drivers last release tarballs were made in 2013 and include
linker arguments that aren't supported. I switched the build to git clones so
that the build can be regenerated from scratch. Both that and the Boost change
are committed to gnucash-on-osx.
The other problem, and perhaps the one that stopped you on MacPorts, is that
even the latest release of Nettle from last month doesn't support ARM64. It
tries to compile ARM32 and fails noisily for hundreds of unrecognized assembler
instructions. The solution is to clone the master branch from
http://git.lysator.liu.se/nettle/nettle and build that instead.
BTW, on Finance::Quote I force-installed B::Keywords and installed Test2, after
which everything else built correctly. Once F::Q was installed in /Library/Perl
GnuCash was able to recognize it and enable the Get Quotes button.
Regards,
John Ralls
> On Aug 19, 2021, at 1:40 AM, Peter West wrote:
>
> Hi John,
>
> I had already run into problems trying to build GnuCash on MacPorts. I was
> encouraged to try to build by reading
> <https://wiki.gnucash.org/wiki/MacOS/Quartz>.
>
> Peter
> —
> Peter West
> p...@ehealth.id.au
> “For behold, when the sound of your greeting came to my ears, the baby in my
> womb leaped for joy.”
>
>> On 17 Aug 2021, at 1:02 am, John Ralls wrote:
>>
>>
>> Support for gtk-osx is on its mailing list,
>> https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you
>> go there I'll remind you that one of gtk-osx's basic requirements is that
>> you must not have Homebrew or MacPorts visible to it.
>>
>> Since you have MacPorts installed already the simplest way forward is to use
>> that to build GnuCash.
>>
>> That said there's no shared code between anything to do with GnuCash and
>> perl or any CPAN modules beyond the macOS SDK. Building GnuCash from source
>> won't help you get Finance::Quote going.
>>
>> Regards,
>> John Ralls
>>
>>> On Aug 16, 2021, at 7:18 AM, Peter West wrote:
>>>
>>> I removed the offending PREFIX line from jhbuildrc-custom, and immediately
>>> ran into a similar problem.
>>>
>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>>> execfile(filename, config)
>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in
>>> execfile
>>> exec(code, globals, locals)
>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in
>>> exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
>>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in
>>> module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + '
>>> -std=c++17'}
>>> File
>>> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
>>> line 675, in __getitem__
>>> raise KeyError(key) from None
>>> KeyError: 'CXXFLAGS'
>>> jhbuild: could not load config file
>>>
>>> In this one, there is obviously a default value, but the Error is
>>> propagating all the way up.
>>>
>>> Peter
>>>
>>>
>>> —
>>> Peter West
>>> p...@ehealth.id.au
>>> “For behold, when the sound of your greeting came to my ears, the baby in
>>> my womb leaped for joy.”
>>>
>>>> On 16 Aug 2021, at 8:21 pm, Peter West wrote:
>>>>
>>>> I’ve decided to go the whole hog and build GNC. Hopefully, I can get
>>>> M1-specific GNC and Finance::Quote working together without any mysterious
>>>> issues.
>>>>
>>>> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it
>>>> fails immediately.
>>>>
>>>> ~ 20:14:24$ jhbuild bootstrap-gtk-osx
>>>> Loading .env environment variables...
>>>> Traceback (most recent call last):
>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>>>> execfile(filename, config)
>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in
>>>> execfile
>>>> exec(code, globals, locals)
>>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in
>>>> exec(compile(open(_user_rc, "rb").re
Re: [GNC] Finance::Quote on Mac M1
Support for gtk-osx is on its mailing list,
https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you go
there I'll remind you that one of gtk-osx's basic requirements is that you must
not have Homebrew or MacPorts visible to it.
Since you have MacPorts installed already the simplest way forward is to use
that to build GnuCash.
That said there's no shared code between anything to do with GnuCash and perl
or any CPAN modules beyond the macOS SDK. Building GnuCash from source won't
help you get Finance::Quote going.
Regards,
John Ralls
> On Aug 16, 2021, at 7:18 AM, Peter West wrote:
>
> I removed the offending PREFIX line from jhbuildrc-custom, and immediately
> ran into a similar problem.
>
> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>execfile(filename, config)
> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in
> execfile
>exec(code, globals, locals)
> File "/Users/gtkdev/.config/jhbuildrc", line 470, in
>exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in
>module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + '
> -std=c++17'}
> File
> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
> line 675, in __getitem__
>raise KeyError(key) from None
> KeyError: 'CXXFLAGS'
> jhbuild: could not load config file
>
> In this one, there is obviously a default value, but the Error is propagating
> all the way up.
>
> Peter
>
>
> —
> Peter West
> p...@ehealth.id.au
> “For behold, when the sound of your greeting came to my ears, the baby in my
> womb leaped for joy.”
>
>> On 16 Aug 2021, at 8:21 pm, Peter West wrote:
>>
>> I’ve decided to go the whole hog and build GNC. Hopefully, I can get
>> M1-specific GNC and Finance::Quote working together without any mysterious
>> issues.
>>
>> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it fails
>> immediately.
>>
>> ~ 20:14:24$ jhbuild bootstrap-gtk-osx
>> Loading .env environment variables...
>> Traceback (most recent call last):
>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>>execfile(filename, config)
>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in
>> execfile
>>exec(code, globals, locals)
>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in
>>exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 3, in
>>prefix = os.environ['PREFIX']
>> File
>> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
>> line 675, in __getitem__
>>raise KeyError(key) from None
>> KeyError: 'PREFIX'
>> jhbuild: could not load config file
>>
>>
>> I'
>>
>> The first thing in .config/jhbuildrc-custom is
>> prefix = os.environ['PREFIX’]
>>
>> So there is no envar PREFIX defined in my environment. That’s easy enough to
>> fix, but what is it supposed to be? Should this Error jusst be caught and
>> defaulted?
>>
>> I don’t do python, so I don’t know how the error/exception process works.
>>
>> Peter
>>
>> —
>> Peter West
>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>> “For behold, when the sound of your greeting came to my ears, the baby in my
>> womb leaped for joy.”
>>
>>> On 4 Aug 2021, at 7:39 pm, Geoff >> <mailto:cleanoutmys...@gmail.com>> wrote:
>>>
>>> Yes, I don't like doing forced installations either, but this particular
>>> module isn't very important in the overall Finance::Quote scheme of events.
>>>
>>> Here are two suggestions.
>>>
>>> (1) Hack. I'm not familiar with MAC directory structures, but I had a look
>>> at the particular test that is failing, and I reckon that if you create an
>>> empty file here it might just trick it into passing:
>>>
>>> /System/Library/Perl/5.30/darwin-thread-multi-2level/CORE/keywords.h
>>>
>>>
>>> (2) Manual install of B::Keywords without using CPAN:
>>> (a) Download B-Keywords-1.22.tar.gz from here:
>>> https://metacpan.org/pod/B::Keywords <https://metacpan.org/pod/B::Keywords>
>>>
>>> (b) Unzip and untar it to a temp directory.
>>>
>>> (c) From the command line in that dire
Re: [GNC] password when using mysql backend
I don't think that Libsecret is optional and AFAIK no user configuration is necessary. The file you'll need to rewrite to suit your purposes is gnucash/gnome-utils/gnc-keyring.c. Good Luck. Regards, John Ralls > On Aug 13, 2021, at 9:09 PM, Fourhundred Thecat <400the...@gmx.ch> wrote: > > thank you, but I am not using gnome keyring, or any other key manager. > > I would like to simply store the password somewhere in a file in my > gnucash profile. > > how can I do this? > > > On 2021-08-13 17:59, John Ralls wrote: >>> On Aug 13, 2021, at 2:00 AM, Fourhundred Thecat <400the...@gmx.ch> wrote: >>> Is it possible to store the mysql password somewhere locally? >> >> It's supposed to be stored in libsecret. Check your trace file >> (https://wiki.gnucash.org/wiki/Tracefile) for errors/warnings >> gnc_keyring_set_password and gnc_keyring_get_password. >> >> Regards, >> John Ralls >> > ___ > 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] password when using mysql backend
> On Aug 13, 2021, at 2:00 AM, Fourhundred Thecat <400the...@gmx.ch> wrote: > > Hello, > > I am using gnucash 3.4-1 on Debian 10. And I am using mysql backend. > > Every time I start gnucash, I have to type my password manually. This is > very annoying, and as far as I can tell adds no real security. > > Is it possible to store the mysql password somewhere locally? > > If this is not possible, how could I hardcode the password into gnucash, > and recompile ? I am fine with recompiling, I had to do it for other > purpose anyway It's supposed to be stored in libsecret. Check your trace file (https://wiki.gnucash.org/wiki/Tracefile) for errors/warnings gnc_keyring_set_password and gnc_keyring_get_password. Regards, John Ralls ___ 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] Creating Reports
Good Day to yo all! I have just set up my family finances with GnuCash (version4.6) and am looking into the various reports. What I need, and have yet to find, is a simply report my wife and I can access to see how well me are doing with our budget each day. Specifically I am looking for the following: Checking Acct #1 Today's Balance + Checking Acct #2 Today's Balance = Daily Balance Subtotal - Budgeted Total amount budgeted for the current pay period. This would include All Budgeted Expenses & Amounts Transferred to holding accounts for later payments. This could also be expandable to the various sub accounts I have set up + Paid Amounts already paid out for all expenses and transfers to Holding Accounts. These cold also be expandable to include sub accounts. = Available Balance What is left for discretionary spending. This is the big one that I would like to see spelled out for us. Each of the reports I have seen and played with will do some of this but i haven't seen any that will give me all of it. If there is something out there or if I am missing something, I would really like to know. Anyone who could help me out with this, I would really appreciate. Thank you very much. John ___ 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] Mutual Fund - Price Import from csv, "Namespace could not be understood"
> On Aug 7, 2021, at 1:35 PM, Ashok Sinha wrote: > > Hello everyone, trying this list for the first time, I hope I am following > the instructions. > > I have downloaded and prepared an import.csv file with 2 lines as: > 05/08/21, INDIAMUTUAL,INF209KA12Z1, INR,143.021 > 05/08/21, INDIAMUTUAL,INF209K01546, INR,27.1064 > > Where the columns are Date, Namespace, From Symbol, To Currency, Amount > > The 'Namespace', & 'Currency To' dropdown comes up with an error > respectively as: > Error 1: Column 'From Namespace' could not be understood. Value can't be > parsed into a valid namespace. > Error 2: Column 'Currency To' could not be understood. Value can't be > parsed into a valide commodity. > > Could somebody please explain to me how to import the prices? I think I'm > doing it right - there's a screenshot below. > > The above example has 2 different mutual funds. Once the concept is proved, > I plan to update many (~20) mutual fund prices from a single import csv > file on a weekly basis. Try removing the leading spaces from the namespace and currency columns. Regards, John Ralls ___ 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] Gnucash on macOS Monterey beta
David, Please don't write me or other GnuCash developers directly unless explicitly asked to. Please use the lists, IRC, or the bug tracker. Yes, Gtk window scaling issues on Monterey have already been reported: https://bugs.gnucash.org/show_bug.cgi?id=798207 Regards, John Ralls > On Jul 27, 2021, at 3:57 PM, David Reed wrote: > > John, > > I'm have a couple hobby iOS/Mac apps so I've installed the macOS Monterey > beta in a separate APFS container. Just in case you're not aware, GnuCash > does not seem to work correctly on it. The window seems to not scale > correctly and I can't select the open/cancel button in the file dialog to > open a file. I may have missed someone asking on the GnuCash mailing list as > I haven't been good keeping up with it but wanted you to know if you weren't > aware so perhaps as Monterey gets closer to release, people are warned if it > doesn't work then yet. > > If it would be helpful to see screenshots (if you don't have access to > Monterey) or anything else, let me know. > > Thanks for all that you do in support GnuCash! > > Dave > ___ 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] Invoice font size has changed
> On Jul 27, 2021, at 10:01 AM, coolnodje wrote: > > Hi, > > the invoice I print from Gnucash have become printed smaller for some > reason. > I can't explain it, nor can I find any place to control this. (I > switched from Default to CSS experimental which makes it slightly larger > but still quite smaller than it used to be) > > I upgraded to 4.6 as soon as it was out (I'm using brew on MacOS ) and > believe my last invoice was made with this same latest version. > I rebooted my computer, which was on for a lot longer than when the new > release was installed. (it's not supposed to explain anything, but as I > keep Gnucash open all the time these days, switching book accounts, it > feels like it's the most meaningful change I've made to my Gnucash ... sic) Edit>Stylesheets. The CSS-based stylesheet uses CSS directly, so adjust the font-size attributes in the elements you want to change. If you don't know CSS works you might prefer to switch back to the stylesheet you were using before and edit it instead. Go to the fonts tab and use the font chooser to select the typeface and size you want for each element. Regards, John Ralls ___ 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] piecharts/linecharts turned blank in reports after upgrade
No, that switches only the libgnc*.so libs in lib/gnucash. There are others in lib/. You cannot build GnuCash with an installed GnuCash. You must `sudo apt-get remove gnucash` then `rm -rf *` your build directory and re-run cmake && ninja. Regards, John Ralls > On Jul 20, 2021, at 9:16 PM, Dong Lin wrote: > > > vm-ubuntu-1:~/src/build-gnucash$ mv lib lib-local-build > vm-ubuntu-1:~/src/build-gnucash$ ln -s /usr/lib/x86_64-linux-gnu/gnucash lib > > this only switches the libgnc-*.so libs only. all other libs continue to > point to /usr/lib. > > vm-ubuntu-1:~/src/build-gnucash$ ./bin/gnucash > ./bin/gnucash: symbol lookup error: ./bin/gnucash: undefined symbol: > gnc_run_report_with_error_handling > > >> Switched how? What libwebkit2gtk.so and libjavascriptcoregtk.so was >> libgnc-html.so linked to if not the ones in /usr/lib? >> >> Regards, >> John Ralls >> >>> On Jul 20, 2021, at 7:55 PM, Dong Lin wrote: >>> >>> >>> On a freshly installed Ubuntu 21.04 VM with apt installed GNC 4.4. the >>> apt >>> installed GNC runs fine with charts visible. >>> >>> But locally built GNC (tip of the latest maint branch) has the same >>> issue. >>> I tried switching the libs in build_dir to point to >>> /usr/lib/x86_64-linux-gnu/gnucash, but the local gnucash encountered an >>> undefined symbol gnc_run_report_with_error_handling and couldn't start. >>> >>> apt removed the system gnucash, purged ~/.cache. reran the local gnc, >>> same >>> problem, blank charts. >>> only the table is visible. >>> >>> the build environment was prepared with apt-get build-dep gnucash as >>> instructed. >>> ___ 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] piecharts/linecharts turned blank in reports after upgrade
Switched how? What libwebkit2gtk.so and libjavascriptcoregtk.so was libgnc-html.so linked to if not the ones in /usr/lib? Regards, John Ralls > On Jul 20, 2021, at 7:55 PM, Dong Lin wrote: > > > On a freshly installed Ubuntu 21.04 VM with apt installed GNC 4.4. the apt > installed GNC runs fine with charts visible. > > But locally built GNC (tip of the latest maint branch) has the same issue. > I tried switching the libs in build_dir to point to > /usr/lib/x86_64-linux-gnu/gnucash, but the local gnucash encountered an > undefined symbol gnc_run_report_with_error_handling and couldn't start. > > apt removed the system gnucash, purged ~/.cache. reran the local gnc, same > problem, blank charts. > only the table is visible. > > the build environment was prepared with apt-get build-dep gnucash as > instructed. > > >> >> Thank you John. I can confirm that 4.x works with Ubuntu 21.04. >> >> As for release 3.11, the problem exists with the unstable version of 3.11 >> (4064c58cd) only. The stable 3.11 (0fe8ba79e) release works just fine. >> >> | * | | 0fe9ba79e21d0545f4c1f9eb373a9450803a83c4 Release GnuCash 3.11 >> * | | | | | | 4064c58cd03b7f7fb613d593c93569048adb Release GnuCash >> 3.11 >> >> I guess issue lies in it's one of the 163 shared libs that GNC uses that >> came with Ubuntu 20.04. >> >> >>> Dong Lin, >>> >>> You've already demonstrated that the problem doesn't happen on 3.11 so >>> there's no point going backwards in 3.x. >>> According to https://repology.org/project/gnucash/versions Ubuntu 21.04 >>> provides GnuCash 4.5. I suggest that you clean up your system and >>> install >>> GnuCash 4.4 from apt. If it has trouble displaying charts then raise a >>> bug >>> on Ubuntu and let their packager figure out what's going on. >>> >>> Regards, >>> John Ralls >>> >>>> On Jul 18, 2021, at 6:24 PM, Dong Lin wrote: >>>> >>>> >>>> Thanks for the instructions John. I tried it on a Ubuntu 20.04 system >>>> with >>>> no GNC installed. The problem still exists in 4.x. It seems the 3.x >>>> stable branch works. The issue happens in the unstable branch only. >>>> >>>> I also tried running 4.x on a Mac, I can see the plot. Not sure if the >>>> issue is Linux only or Ubuntu only. >>>> >>>> unstable 2455071 bad >>>> stable 3.6-d42695e75 good >>>> unstable 3.5-b7479e8fb bad >>>> >>>> I cannot build 3.4 or anything older. The fix for >>>> G_TYPE_INSTANCE_GET_PRIVATE does not apply cleanly on older commits. >>>> Compile still fails after resolving all conflicts. >>>> >>>> So it seems a very old bug that hasn't been fixed in the unstable >>>> branch. >>>> I believe running 4.x or any 3.x unstable build on standard issue >>>> Ubuntu >>>> 20.04 should easily reproduce. >>>> >>>> >>>>> It turns out that bisecting between 63232f and 8024f4 flat won't work, >>>>> they're on different branches. 63232f is on the 3.x branch which is >>>>> why >>>>> it >>>>> works. 2c637a is from 2019 where the master branch splits off from the >>>>> maint branch (we had a pull request merge mishap at aa53c23 that >>>>> temporarily collapsed them together, but there hadn't been any >>>>> development >>>>> on master at that point anyway). 2c637a is actually the first commit >>>>> where >>>>> the two branches start to diverge. >>>>> >>>>> Since the failing 8024f4 is on master I looked at the changes leading >>>>> up >>>>> to that in a graphical history viewer. One particular change stands >>>>> out, >>>>> 2455071 where we start the conversion from jqplot to chartjs. That >>>>> would >>>>> be a good place to test. >>>>> >>>>> HOWEVER >>>>> The problem may well be that there are remnants of the Ubuntu-provided >>>>> GnuCash 3.8 that are interfering with the 4.x chartjs-based chart >>>>> rendering, so before you do any more bisecting I suggest that you >>>>> completely remove all GnuCash shared libraries, loadable modules, and >>>>> Scheme caches from your system, then reinstall GnuCash 4.6 with apt. >>>>> The >>>>> s
Re: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open files with OneDrive
I don't have One Drive so I'm guessing, but macOS10.15 introduced some security restrictions on access to certain folders which macOS 11 tightened up even more. You might need to give GnuCash some extra privileges. Open System Preferences, go to the Security and Privacy pane, select the privacy tab, and scroll down the left list to Files and Folders. With that selected find Gnucash.app in the right list and see what folders are listed under it. If OneDrive appears there and isn't checked, click the padlock in the lower left corner, authenticate, and then check the box for the OneDrive folder. Start GnuCash and see if you can find your file. If that doesn't work or if there is no line for OneDrive, go to the Full Disk Access item, one up in the left list. Find Gnucash.app in the right list and check its box (you'll have to click the padlock and authenticate if you haven't already). Start GnuCash and try to open the file. Regards, John Ralls > On Jul 20, 2021, at 11:53 AM, Derek Atkins wrote: > > Sounds like a permission problem. > Not sure how to fix it, I'm afraid. > -d > > On Tue, July 20, 2021 2:33 pm, cbp...@gmail.com wrote: >> Hi Derek, Gyle - thanks for the responses. >> >> I'd like to add one other error message - perhaps it will be helpful. When >> I try to go the File -> Open route, I get a slightly different error >> message (though it still doesn't work). The error message I get here is >> below. >> >> --- >> Could not read the contents of >> Error opening directory '/Users//OneDrive/': >> Operation not permitted >> --- >> >> Not sure if that means anything to anyone - but I figured I'd add it >> anyway in case it helps! >> >> Cameron >> >> -Original Message- >> From: Derek Atkins >> Sent: Tuesday, July 20, 2021 11:14 AM >> To: Gyle McCollam >> Cc: Cameron Podd ; gnucash-user@gnucash.org >> Subject: Re: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open >> files with OneDrive >> >> Gyle, >> >> Cameron is on a Mac, not a Windows box, so OneDrive may behave differently >> there. Right now it sounds like GnuCash cannot see the OneDrive >> directory. >> >> I am hoping JRalls can pipe up and provide some insights, as he is our >> resident Mac expert. >> >> -derek >> >> On Tue, July 20, 2021 2:07 pm, Gyle McCollam wrote: >>> I use one drive as well, but I have no problem with GNU Cash finding >>> the info. However, I have another directory between Documents and >>> GnuCashData.gnucash (although mine is named differently). >>> When you click on file/open you can navigate to the file on one drive >>> and it should work fine from that point. I had an old program called >>> Money Counts for Windows (MCW) and when I changed the name of that >>> subdirectory to GNUCash recently, I had a problem with GNC finding my >>> info, but using file/open and navigating to the new directory and then >>> ?.gnucash worked for me. Hopefully, this helps. >>> >>> Thank You, >>> Gyle McCollam >>> >>> Gyle McCollam >>> >>> 609.680.2326 Mobile >>> >>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email >>> >>> >>> From: gnucash-user >>> on behalf of Cameron Podd >>> Sent: Tuesday, July 20, 2021 11:33 AM >>> To: gnucash-user@gnucash.org >>> Subject: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open >>> files with OneDrive >>> >>> I am wondering if anyone has encountered - or has a possible solution >>> to - this bug I have found. I usually store my GNUCash file in OneDrive. >>> However, with the new update of OneDrive, GNUCash cannot see the file. >>> See the error below. Has anyone also seen this error - or know how to >>> correct it? >>> >>> Can't parse the URL >>> /Users//OneDrive/Documents/GnuCashData.gnucash >>> >>> Thanks - Cameron >>> >>> ___ >>> 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-A
Re: [GNC] My screenshot FYI. - Re: Big problem GC 4.6 wiping history list? Mac OS Big Sur
Anita, Thanks for the followup, but please remember to copy the list on all replies. Regards, John Ralls > On Jul 20, 2021, at 8:54 AM, Anita Graves wrote: > > Dear John and others who helped me, I wish to inform you that I was able to > solve my problem by simply carefully following the file path and discovered > that I had re-named a folder and that caused my problem. It had nothing to > do with trying to update GC. > > Thanks so much for your help and your kind attention! > > Anita > >> On 2 Jul 2021, at 8:04 PM, John Ralls wrote: >> >> Yes, that's the dialog I expected. It's offering to remove the entry in the >> File menu, not to delete the actual file. After all, it can't find the >> actual file so how could it delete it? >> >> Regards, >> John Ralls >> >> >>> On Jul 2, 2021, at 9:30 AM, Anita Graves wrote: >>> >>> >>> >>>> On 1 Jul 2021, at 7:36 PM, John Ralls wrote: >>>> >>>> >>>> >>>>> On Jun 28, 2021, at 11:52 PM, Anita Graves >>>>> wrote: >>>>> >>>>> Please see the attached screenshot: >>>>> >>>>> I don’t know what to do but I refuse to delete the file I need to work >>>>> with, or any of the other files in the history list. This all happened >>>>> to me when I installed GC 4.6. Before I was using 4.1. Now, when I try >>>>> to import a log file it gives the same screen. Then GC crashes! >>>>> >>>>> I am afraid to wipe all my history and all my work! >>>>> >>>>> Thanks for your help and suggestions. >>>> >>>> Your screenshot didn't make it onto the list, but if GnuCash is asking if >>>> you want to delete a file from the history list that means that it can't >>>> find the file. You'll want to investigate why that is, but rest assured >>>> that GnuCash isn't offering to delete the file, just to remove it from the >>>> history list. >>>> >>>> For the crash, please open a bug and attach the crash report from Console. >>>> You can find instructions for finding the crash report at >>>> https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did >>>> leading up to the crash in the bug description. >>>> >>>> Regards, >>>> John Ralls >>>> >>> >> > ___ 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] piecharts/linecharts turned blank in reports after upgrade
Dong Lin, You've already demonstrated that the problem doesn't happen on 3.11 so there's no point going backwards in 3.x. According to https://repology.org/project/gnucash/versions Ubuntu 21.04 provides GnuCash 4.5. I suggest that you clean up your system and install GnuCash 4.4 from apt. If it has trouble displaying charts then raise a bug on Ubuntu and let their packager figure out what's going on. Regards, John Ralls > On Jul 18, 2021, at 6:24 PM, Dong Lin wrote: > > > Thanks for the instructions John. I tried it on a Ubuntu 20.04 system with > no GNC installed. The problem still exists in 4.x. It seems the 3.x > stable branch works. The issue happens in the unstable branch only. > > I also tried running 4.x on a Mac, I can see the plot. Not sure if the > issue is Linux only or Ubuntu only. > > unstable 2455071 bad > stable 3.6-d42695e75 good > unstable 3.5-b7479e8fb bad > > I cannot build 3.4 or anything older. The fix for > G_TYPE_INSTANCE_GET_PRIVATE does not apply cleanly on older commits. > Compile still fails after resolving all conflicts. > > So it seems a very old bug that hasn't been fixed in the unstable branch. > I believe running 4.x or any 3.x unstable build on standard issue Ubuntu > 20.04 should easily reproduce. > > >> It turns out that bisecting between 63232f and 8024f4 flat won't work, >> they're on different branches. 63232f is on the 3.x branch which is why it >> works. 2c637a is from 2019 where the master branch splits off from the >> maint branch (we had a pull request merge mishap at aa53c23 that >> temporarily collapsed them together, but there hadn't been any development >> on master at that point anyway). 2c637a is actually the first commit where >> the two branches start to diverge. >> >> Since the failing 8024f4 is on master I looked at the changes leading up >> to that in a graphical history viewer. One particular change stands out, >> 2455071 where we start the conversion from jqplot to chartjs. That would >> be a good place to test. >> >> HOWEVER >> The problem may well be that there are remnants of the Ubuntu-provided >> GnuCash 3.8 that are interfering with the 4.x chartjs-based chart >> rendering, so before you do any more bisecting I suggest that you >> completely remove all GnuCash shared libraries, loadable modules, and >> Scheme caches from your system, then reinstall GnuCash 4.6 with apt. The >> shared libraries will be /usr/lib/libgnc* and you can get rid of the >> shared modules and system cached guile by `sudo rm -rf /usr/lib/gnucash/`. >> Remove ~/.cache/guile/ccache as well if it exists. That may fix the >> problem with no more troubleshooting required. If it doesn't `sudo apt-get >> remove gnucash` to have a clean system before doing any test builds. Guile >> is exceptionally stupid about what it loads and trying to build GnuCash >> when there's a package-manager version installed seldom comes out well. >> >> If more bisecting is in order, try 2455071. If it works, try 598c37; >> that's the end of the chartjs upgrades. If that works then check 8024f4 >> again to make sure that that still fails, then `git bisect --first-parent >> start 8024f4 598c37` to find the problem commit (which may well be a >> merge). >> >> Regards, >> John Ralls >> >> >>> On Jul 17, 2021, at 8:01 PM, Dong Lin wrote: >>> >>> >>> I see two 3.11 release commits in maint. >>> >>> 3.11-4064c58cd bad >>> 3.11-0fe9ba79e good >>> >>> bisecting in this range pointed to 2c637a971. >>> >>> bisecting in 63232f388..8024f44bc also singled out 2c637a971. >>> >>> But it cannot be as it's just a version update. Reverting it did not >>> produce a good run. >>> >>> >>>> >>>> That the problem seems to have arisen during the transition between 3.x >>>> and 4.0 does make it a bit more complicated. There are 391 commits >>>> between >>>> 63232f and 8024f4 including 57 merges from maint and 8 feature >>>> branches. >>>> That makes knowing that the problem exists in the latter commit and not >>>> in >>>> the former less helpful than it might be. >>>> >>>> You can test your hypothesis that a merge caused the regression by >>>> testing >>>> 3.11, the last release on the 3.x maint branch. If that fails you can >>>> bisect between it and 63232f. Use `git bisect`, it's the quickest and >>>> easiest way to find the commit that caused the problem. >>>
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
It turns out that bisecting between 63232f and 8024f4 flat won't work, they're on different branches. 63232f is on the 3.x branch which is why it works. 2c637a is from 2019 where the master branch splits off from the maint branch (we had a pull request merge mishap at aa53c23 that temporarily collapsed them together, but there hadn't been any development on master at that point anyway). 2c637a is actually the first commit where the two branches start to diverge. Since the failing 8024f4 is on master I looked at the changes leading up to that in a graphical history viewer. One particular change stands out, 2455071 where we start the conversion from jqplot to chartjs. That would be a good place to test. HOWEVER The problem may well be that there are remnants of the Ubuntu-provided GnuCash 3.8 that are interfering with the 4.x chartjs-based chart rendering, so before you do any more bisecting I suggest that you completely remove all GnuCash shared libraries, loadable modules, and Scheme caches from your system, then reinstall GnuCash 4.6 with apt. The shared libraries will be /usr/lib/libgnc* and you can get rid of the shared modules and system cached guile by `sudo rm -rf /usr/lib/gnucash/`. Remove ~/.cache/guile/ccache as well if it exists. That may fix the problem with no more troubleshooting required. If it doesn't `sudo apt-get remove gnucash` to have a clean system before doing any test builds. Guile is exceptionally stupid about what it loads and trying to build GnuCash when there's a package-manager version installed seldom comes out well. If more bisecting is in order, try 2455071. If it works, try 598c37; that's the end of the chartjs upgrades. If that works then check 8024f4 again to make sure that that still fails, then `git bisect --first-parent start 8024f4 598c37` to find the problem commit (which may well be a merge). Regards, John Ralls > On Jul 17, 2021, at 8:01 PM, Dong Lin wrote: > > > I see two 3.11 release commits in maint. > > 3.11-4064c58cd bad > 3.11-0fe9ba79e good > > bisecting in this range pointed to 2c637a971. > > bisecting in 63232f388..8024f44bc also singled out 2c637a971. > > But it cannot be as it's just a version update. Reverting it did not > produce a good run. > > >> >> That the problem seems to have arisen during the transition between 3.x >> and 4.0 does make it a bit more complicated. There are 391 commits between >> 63232f and 8024f4 including 57 merges from maint and 8 feature branches. >> That makes knowing that the problem exists in the latter commit and not in >> the former less helpful than it might be. >> >> You can test your hypothesis that a merge caused the regression by testing >> 3.11, the last release on the 3.x maint branch. If that fails you can >> bisect between it and 63232f. Use `git bisect`, it's the quickest and >> easiest way to find the commit that caused the problem. >> >> If 3.11 is good then you can run bisect so that it always tests merge >> commits and ignores the commits being merged with `git bisect >> --first-commit start 8024f4 63232f`. >> >> Regards, >> John Ralls >> >> >> >>> On Jul 17, 2021, at 7:46 AM, Dong Lin via gnucash-user >>> wrote: >>> >>> >>> Did more searches. the issue exists in 4.6, running gnc on Ubuntu >>> 20.04.1 >>> LTS with standard gnome. >>> >>> I've gone through the following commits in maint: >>> >>> 4.6 2021 228954c40 bad >>> 0425-2020 8024f44bc bad >>> 0425-2020 63232f388 good >>> 3.10 2020 7d39ccc9d good >>> 3.6 2019 d42695e75 good >>> 0615-2019 410ae9575 good >>> 0601-2019 170651602 good >>> 0601-2019 3a91eedb4 good >>> 0531-2019 69ea174cd bad >>> 0415-2019 0251d044b bad >>> 3.5 2019 b7479e8fb bad >>> >>> I couldn't go any older because ancient code cannot be compiled by my >>> environment. >>> >>> The merges really obscured the search. the order of the merged commits >>> are >>> not chronological. timestamps are time of commit, not time of merge. >>> >>> It looks as if the bug was fixed at one point, but it was lost in a >>> merge. >>> >>> >>> >>>> Running gnc in Ubuntu 20.04 LTS. Default gnc is 3.8. I built the >>>> gnc >>>> trees based off of master at various commits for the bisect. >>>> ; lsb_release -a >>>> No LSB modules are available. >>>> Distributor ID: Ubuntu >>>> Description:   Ubuntu 20.04.1 LTS >>>> Release:       20.04 >>>>
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Currency quotes work differently from stock quotes because forex markets
operate differently from stock exchanges. A particular stock symbol on any one
price source is unique and quoted in a single currency so only the symbol is
needed to retrieve the quote. Forex markets quote exchange rates between pairs
of currencies, e.g. GBP to USD or JPY to EUR. Simply asking for the current
quote for EUR isn't meaningful.
In F::Q to retrieve currency quotes you must use `currency` for the source and
you need two symbols as shown in Geoff's examples. Enabling online quotes for a
currency in the security editor won't work because that will try to retrieve a
price for a stock with the currency symbol from the selected source and odds
are there is no such stock.
To easily test that F::Q is working for currencies find a two-currency
transaction and right-click on it, then select "edit exchange rate" in the
context menu. The transfer dialog will appear. Click the Fetch Rate button and
if everything is behaving itself the current rate will fill in the exchange
rate box.
Regards,
John Ralls
> On Jul 18, 2021, at 7:30 AM, david.rom...@davidjromano.com
> wrote:
>
> Thanks Geoff, yes I think I did though I will recheck this.
>
> I've also tried this with an alternative key in case the first was the
> problem.
>
> David
> Sent from my iPhone
>
>> On 18 Jul 2021, at 13:55, Geoff wrote:
>>
>> Hi David
>>
>> Did you remember to set your alphavantage key as an environment variable
>> when testing with Perl from the command line?
>>
>> Can you try this:
>>
>> C:\Program Files (x86)\gnucash\bin>set
>> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>>
>> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
>> __Your_Actual_Key__
>>
>> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
>> gnc-fq-helper
>> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10 08:40:01") (last .
>> #e0.72002) (currency . "GBP")))
>>
>> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
>> gnc-fq-helper
>> (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05") (last .
>> #e4.8841) (currency . "RON")))
>>
>>
>> Also, it is normal to get the blank command window when doing Get Quotes on
>> Windows.
>>
>> Regards
>>
>> Geoff
>> =
>>
>>> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
>>> I'm having a problem with GNC-FQ not being able to retrieve currency data
>>> for the GBP / EUR currency pair.
>>> I had previously used FQ back when the data source was Yahoo, but when the
>>> Yahoo died I stopped using it.
>>> I now need to pick up GBP and EUR rates so I've installed the components
>>> required to get the Alphavantage feed to work - or so I hoped!
>>> Here's where I've got to so far:
>>> 1.I updated GNU Cash to current 4.6.
>>> 2.I installed Strawberry Perl version 5.32.1.1
>>> 3.I'm Running Windows 10 Professional 21H1 build 19043.110
>>> 4.I added my aphhavantage key in Preferences \ Online Quotes
>>> 5.I ran perl gnc-fq-check and got the following result:
>>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
>>> ("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia"
>>> "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada" "canadamutual"
>>> "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies"
>>> "fidelity" "fidelity_direct" "finanzpartner" "fondsweb" "fool" "ftfunds"
>>> "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary"
>>> "hustock" "iexcloud" "india" "indiamutual" "known_currencies"
>>> "morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx"
>>> "onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx"
>>> "tradeville" "troweprice" "troweprice_direct" "tsp
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
That the problem seems to have arisen during the transition between 3.x and 4.0 does make it a bit more complicated. There are 391 commits between 63232f and 8024f4 including 57 merges from maint and 8 feature branches. That makes knowing that the problem exists in the latter commit and not in the former less helpful than it might be. You can test your hypothesis that a merge caused the regression by testing 3.11, the last release on the 3.x maint branch. If that fails you can bisect between it and 63232f. Use `git bisect`, it's the quickest and easiest way to find the commit that caused the problem. If 3.11 is good then you can run bisect so that it always tests merge commits and ignores the commits being merged with `git bisect --first-commit start 8024f4 63232f`. Regards, John Ralls > On Jul 17, 2021, at 7:46 AM, Dong Lin via gnucash-user > wrote: > > > Did more searches. the issue exists in 4.6, running gnc on Ubuntu 20.04.1 > LTS with standard gnome. > > I've gone through the following commits in maint: > > 4.6 2021 228954c40 bad > 0425-2020 8024f44bc bad > 0425-2020 63232f388 good > 3.10 2020 7d39ccc9d good > 3.6 2019 d42695e75 good > 0615-2019 410ae9575 good > 0601-2019 170651602 good > 0601-2019 3a91eedb4 good > 0531-2019 69ea174cd bad > 0415-2019 0251d044b bad > 3.5 2019 b7479e8fb bad > > I couldn't go any older because ancient code cannot be compiled by my > environment. > > The merges really obscured the search. the order of the merged commits are > not chronological. timestamps are time of commit, not time of merge. > > It looks as if the bug was fixed at one point, but it was lost in a merge. > > > >> Running gnc in Ubuntu 20.04 LTS. Default gnc is 3.8. I built the gnc >> trees based off of master at various commits for the bisect. >> ; lsb_release -a >> No LSB modules are available. >> Distributor ID: Ubuntu >> Description:   Ubuntu 20.04.1 LTS >> Release:       20.04 >> Codename:      focal >> >> >> ; grep WEBKIT ./common/config.h >> /* Definitions for what WEBKIT version we're compiling against: */ >> #define WEBKIT2_4 1 >> /* #undef WEBKIT2_3 */ >> /* #undef WEBKIT1 */ >> >> >> I compared the preprocessor output for html/gnc-html-webkit2.c, the >> affected code block between the working and non-working versions are >> identical. But some line numbers for other .h files are different. So I >> have assumed that it's not 8024f44bc, but other 100+ commits that came >> with the tree merge. >> >> the VNC server runs on Ubuntu (the same machine that the binary is built >> on). The VNC viewer is MacOS (TigherVNC). Tried another viewer running on >> Linux, same outcome. >> >> There are many commits affecting barcharts in that range. The most >> relevant one seems to be this: >> 6b74f80bc Wed Dec 18 21:55:51 2019 +0800 >> [html-pie/scatter/bar/linechart] defer to html-chart renderer >> >> But reverting it resulted in too many conflicts that I dont know how to >> resolve. >> Will try again later using the maint branch. >> >> Thanks! >> >>> >>> >>>> On Jul 11, 2021, at 10:36 PM, Dong Lin via gnucash-user >>>> wrote: >>>> >>>> >>>> I am trying to upgrade from 3.8 to 4.6. But found that piecharts and >>>> linecharts in reports have turned blank. The associated tables are >>>> present >>>> though. >>>> >>>> Attempted to perform a binary search in master, and found the latest >>>> working commit is 63232f388. >>>> >>>> >>>> 8024f44bc Sat Apr 25 15:40:07 2020 >>>> -0700                Remove leftover >>>> webkit2 conditional. >>>> 63232f388 Sat Apr 25 14:40:57 2020 >>>> -0700                Merge Jean >>>> Laroche's 'Fix-3-SX-Problems' into maint >>>> >>>> >>>> Unfortunately 8024f44bc came from the maint branch and was merged with >>>> over a hundred other commits. I am not sure how to narrow it down. >>>> Reverting one of them resulted in lots of conflicts that I dont know >>>> how >>>> to resolve. >>>> >>>> I figured the problem has to be related to my environment as no one >>>> else >>>> has brought up the issue. My virtual desktop is >>>> driven by a VNC server (Ubuntu 20.04 LTS). It's not directly >>>> associated >>>> with a hardware graphics card with a ph
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
> On Jul 11, 2021, at 10:36 PM, Dong Lin via gnucash-user > wrote: > > > I am trying to upgrade from 3.8 to 4.6. But found that piecharts and > linecharts in reports have turned blank. The associated tables are present > though. > > Attempted to perform a binary search in master, and found the latest > working commit is 63232f388. > > > 8024f44bc Sat Apr 25 15:40:07 2020 -0700 Remove leftover > webkit2 conditional. > 63232f388 Sat Apr 25 14:40:57 2020 -0700 Merge Jean > Laroche's 'Fix-3-SX-Problems' into maint > > > Unfortunately 8024f44bc came from the maint branch and was merged with > over a hundred other commits. I am not sure how to narrow it down. > Reverting one of them resulted in lots of conflicts that I dont know how > to resolve. > > I figured the problem has to be related to my environment as no one else > has brought up the issue. My virtual desktop is > driven by a VNC server (Ubuntu 20.04 LTS). It's not directly associated > with a hardware graphics card with a physical cable to the monitor. We release off of the maint branch so you should do your bisect there. This isn't likely to have anything to do with your VNC server, nor with whatever you're connecting to it. In what environment are you actually running GnuCash and what version of WebKit is it using? Regards, John Ralls ___ 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] OFX Imports to new account reversed
> On Jul 5, 2021, at 8:56 PM, David Carlson wrote: > > I have been using GnuCash for years with OFX imports correctly populating > bank and credit card accounts with deposits and withdrawals. > > Today, using release 3.8 I set up a new credit card account, went online, > downloaded an OFX transaction file and proceeded to import it into > GnuCash. > > Surprise, purchases were entered as payments. I checked the raw OFX file > and it appears to be correct. The account type is Credit Card under a > Liability top account. > > What else can cause this? Were there any payments and were they recorded as purchases? In your OFX file what is the block after the tag? A normal CC one should look like USD In a purchase transaction what is the sign on the amount? It shouldn't matter, but what have you selected in Preferences>Accounts for Reverse Balance Accounts? Regards, John Ralls ___ 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] Finance Quote Not working on MacBook Air M1 chip
Super. I guess you needed to install JSON::Parse and maybe other dependencies in the Rosetta instance. No doubt it's lost now but I wonder if during the Rosetta install cpan saw that it was already installed and couldn't tell that it was for the wrong architecture. Regards, John Ralls > On Jul 3, 2021, at 11:35 PM, Deepti Randad wrote: > > Hey John - it worked after some trouble shooting - now Finance:Quote is > “recognised” by the GnuCash GUI - Again - Thanks for your help !! > > Regards, > Kamlesh > >> On 04-Jul-2021, at 11:52 AM, Deepti Randad wrote: >> >> I was able to create a “terminal instance” to run under Rosetta2 and also >> then was able to install Finance::Quote using gnc-fq-update. >> >> However, when I tried to run the command "echo '(yahoo_json "CSCO")' | >> ./gnc-fq-helper”, I get a bunch of errors - as follows: (I have not had >> chance to troubleshoot these yet, maybe next weekend) >> >> Thanks John for your guidance so far. >> >> >> Can't load >> '/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle' >> for module JSON::Parse: >> dlopen(/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle, >> 1): no suitable image found. Did find: >> >> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: >> mach-o, but wrong architecture >> >> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: >> mach-o, but wrong architecture at /System/Library/Perl/5.30/XSLoader.pm line >> 96. >> at /Library/Perl/5.30/darwin-thread-multi-2level/JSON/Parse.pm line 23. >> Compilation failed in require at >> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27. >> BEGIN failed--compilation aborted at >> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27. >> Compilation failed in require at (eval 301) line 1. >> BEGIN failed--compilation aborted at (eval 301) line 1. >> at ./gnc-fq-helper line 325. >> Can't locate object method "methods" via package >> "Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line >> 120. >> >> >>> On 01-Jul-2021, at 10:09 PM, John Ralls wrote: >>> >>> OK. I suspect that it's because GnuCash is running under Rosetta2 and that >>> forces the Intel perl. Try following the instructions in >>> https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/ >>> to create a Terminal instance that runs under Rosetta2 and use that to run >>> gnc-fq-update. >>> >>> Regards, >>> John Ralls >>> >>> >>> >>>> On Jun 30, 2021, at 5:31 AM, Deepti Randad wrote: >>>> >>>> Hallo John - Many Thanks for your response. >>>> >>>> I ran the GUI from the terminal command prompt as you have suggested - >>>> however, the problem remains the same - the application does not “get” / >>>> “find” Finance::Quote. >>>> >>>> Regards, >>>> Kamlesh >>>> >>>> Regards, >>>> Kamlesh >>>> >>>>> On 29-Jun-2021, at 8:43 AM, John Ralls wrote: >>>>> >>>>> /Applications/Gnucash.app/Contents/MacOS/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] Tools, Price Database
> On Jul 3, 2021, at 2:24 PM, Tommy Trussell wrote: > > On Sat, Jul 3, 2021 at 3:44 PM Gyle McCollam wrote: > >> I upgraded from version 3.6 to version 4.6 and when I add a new price for >> a stock it only takes 2 digits, previously I had 5 digits. How do I change >> it to 5 digits. I can’t find the screen to have it keep 5 digits. I >> enter the price as 5 digits, but when I save it it coverts it to 2 digits. >> Any help would be GREATLY appreciated. >> > > I saw this issue come across this list just the other day. Seems to be a > new bug: > https://bugs.gnucash.org/show_bug.cgi?id=798219 > > If the bug is causing a hardship, you might try downgrading to GnuCash 4.5, > or consider generating a patched version to use. > There's a workaround: After you type the price hit instead of clicking OK. Regards, John Ralls ___ 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] Big problem GC 4.6 wiping history list? Mac OS Big Sur
Please remember to copy the list on all replies. Windows and Linux users wish they had Console. It's very much a Mac thing; it's in Applications:Utilities. There are more detailed instructions in the wiki link I gave you. Regards, John Ralls > On Jul 2, 2021, at 9:35 AM, Anita Graves wrote: > > John, > > What is ‘Console’? Is that a PC thing? I don’t think we have that on Mac. > > Anita > >> On 1 Jul 2021, at 7:36 PM, John Ralls wrote: >> >> >> >>> On Jun 28, 2021, at 11:52 PM, Anita Graves >>> wrote: >>> >>> Please see the attached screenshot: >>> >>> I don’t know what to do but I refuse to delete the file I need to work >>> with, or any of the other files in the history list. This all happened to >>> me when I installed GC 4.6. Before I was using 4.1. Now, when I try to >>> import a log file it gives the same screen. Then GC crashes! >>> >>> I am afraid to wipe all my history and all my work! >>> >>> Thanks for your help and suggestions. >> >> Your screenshot didn't make it onto the list, but if GnuCash is asking if >> you want to delete a file from the history list that means that it can't >> find the file. You'll want to investigate why that is, but rest assured that >> GnuCash isn't offering to delete the file, just to remove it from the >> history list. >> >> For the crash, please open a bug and attach the crash report from Console. >> You can find instructions for finding the crash report at >> https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did >> leading up to the crash in the bug description. >> >> Regards, >> John Ralls >> > ___ 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] GNUCash 4.6 for Ubuntu 20.04 LTS
> On Jul 1, 2021, at 6:05 AM, David G. Pickett via gnucash-user > wrote: > > Bug: Entering price on price database - add, prices auto round to to places ! > Securities - edit says it is trades in 1/1000. Cannot find a setting to > control this. https://bugs.gnucash.org/show_bug.cgi?id=798219 Regards, John Ralls ___ 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] Finance Quote Not working on MacBook Air M1 chip
OK. I suspect that it's because GnuCash is running under Rosetta2 and that forces the Intel perl. Try following the instructions in https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/ to create a Terminal instance that runs under Rosetta2 and use that to run gnc-fq-update. Regards, John Ralls > On Jun 30, 2021, at 5:31 AM, Deepti Randad wrote: > > Hallo John - Many Thanks for your response. > > I ran the GUI from the terminal command prompt as you have suggested - > however, the problem remains the same - the application does not “get” / > “find” Finance::Quote. > > Regards, > Kamlesh > > Regards, > Kamlesh > >> On 29-Jun-2021, at 8:43 AM, John Ralls wrote: >> >> /Applications/Gnucash.app/Contents/MacOS/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] Big problem GC 4.6 wiping history list? Mac OS Big Sur
> On Jun 28, 2021, at 11:52 PM, Anita Graves wrote: > > Please see the attached screenshot: > > I don’t know what to do but I refuse to delete the file I need to work with, > or any of the other files in the history list. This all happened to me when > I installed GC 4.6. Before I was using 4.1. Now, when I try to import a log > file it gives the same screen. Then GC crashes! > > I am afraid to wipe all my history and all my work! > > Thanks for your help and suggestions. Your screenshot didn't make it onto the list, but if GnuCash is asking if you want to delete a file from the history list that means that it can't find the file. You'll want to investigate why that is, but rest assured that GnuCash isn't offering to delete the file, just to remove it from the history list. For the crash, please open a bug and attach the crash report from Console. You can find instructions for finding the crash report at https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did leading up to the crash in the bug description. Regards, John Ralls ___ 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] Preferences reset problem?
> On Jun 30, 2021, at 2:52 AM, Geert Janssens > wrote: > > Op dinsdag 29 juni 2021 22:22:36 CEST schreef incoming-gnuc...@sabot.com: >> After gnucash 4.5 was announced, I tested upgrading to it on a >> standalone test machine (running flatpak on ubuntu 20.04), and >> I encountered the issue later described here: >> >> https://bugs.gnucash.org/show_bug.cgi?id=798194 >> >> where all my gnucash settings were lost. On that same test machine, I >> tried downgrading to 4.4, but my settings were still gone. This >> seemed kind of scary, so I put off upgrading my real machine pending a >> fix. >> >> I see that the bug report linked to above includes some manual >> migration steps to export/re-import settings as a workaround, so I >> plan to just go ahead and try that (and I will go direct from 4.4 to >> 4.6, skipping 4.5). But I thought I'd check in to make sure that >> there was no other pending/better way or automatic approach to this, >> or is the manual workaround the way to go? >> > So far there's no better workaround. You can either manually set your > preferences again or use the command provided in the bug report. > > The short version of the issue is that a flatpak install of gnucash is as if > you install gnucash on a different machine, completely isolated from your > normal environment. There used to be a convenience to share preferences > between your normal environment and that "virtual" flatpak machine. That > convenience was dropped recently by the flatpak developers (well, the gnome > runtime developers really). Instead they provide a means to automatically > import settings from your main environment to the flatpak "virtual" machine, > but for historical reasons this can't work with gnucash. So as for the > convenience of having your preferences magically available in the flatpak > environment we're stuck between a rock and a hard place unfortunately. > >> If this issue affects all flatpak users, perhaps the release notes >> should reference the preferences issue and describe or link to the >> appropriate workaround? > > That's a reasonable idea. I hope someone will do so. Geert, Can you elaborate on the historical reasons on https://github.com/flathub/org.gnucash.GnuCash/pull/43? Regards, John Ralls ___ 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] Finance Quote Not working on MacBook Air M1 chip
> On Jun 27, 2021, at 4:05 AM, Deepti Randad via gnucash-user
> wrote:
>
> Hallo Folks -
>
> I recently installed GnuCash on MacBook Air with the Apple M1 chip - the
> GnuCash GUI itself seems to be working great. Then I tried installing
> finance::quote to get stock quotes automatically, however, this has not been
> working even after a lot of trouble shooting I did. Please find below the
> steps I have taken. Any help / direction will be appreciated. Thanks.
>
> Regards,
> Kamlesh
>
> Finance Quote on MacOS with MacBook Air M1 chip
>
> In the GnuCash GUI, I get the following error message in the “Security
> Editor” screen:
>> Warning: Finance::Quote not installed properly <
> and the rest of the fields below this are disabled.
> I followed the installation instructions on
> https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS
>
> <https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS>
>
> The about page of the GUI shows:
> Version: 4.5
> Build ID: 4.5+(2021-03-27)
> Finance::Quote: -
>
> I did the following for installation:
>
> First, run the gnc-fq-update - this I had to run a couple of times, but it
> succeeded.
>
> Now if I run it, I get the following:
>
> Date::Manip is up to date (6.85).
> Finance::Quote is up to date (1.49)
>
> Perldoc gives the following output:
>
> perldoc -lm Finance::Quote
> /Library/Perl/5.30/Finance/Quote.pm
>
> Then, I run the following command, gnc-fq-helper
>
> echo '(yahoo_json "CSCO")' | ./gnc-fq-helper
>
> This returns the data fetched:
> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-06-19 12:00:00") (last .
> #e52.07) (currency . "USD")))
>
> Another command I tried:
>
> ./gnc-fq-dump currency USD EUR
> 1 USD = 0.8428 EUR
>
> Therefore I am guessing Finance::Quote is working from command line.
>
> ./gnc-fq-check
>
> ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx"
> "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" "bsero"
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual"
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau"
> "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx"
> "platinum" "romania" "seb_funds" "sixfunds" "sixshares"
> "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk"
> "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts"
> "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json"
> "yahoo_yql" "za" "za_unittrusts"
Try running
/Applications/Gnucash.app/Contents/MacOS/Gnucash
from Terminal. Does that get it working?
Regards,
John Ralls
___
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] GnuCash 4.6 Flathub Build
We've resolved the issue with Flathub and GnuCash 4.6 is now published there. Regards, John Ralls ___ 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] GnuCash 4.6 Released
Thanks. The correct hashes are: 251b01dfb9f9c679db26926f934ca4d13c7092a485be04f60e2031d85a445733 gnucash-4.6.tar.bz2 ad3a6ec1f5fdf15fd167808cf351bc1aa7c012ea03a16c73a3d1c29bbd59a03d gnucash-4.6.tar.gz de0447be56f3c56194132a89766221dfac72742c04aa87a84716cdd1ff93cfa7 gnucash-4.6.setup.exe 1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 Gnucash-Intel-4.6-1.dmg 5c4f8957d4e4a27bd7be3bc42f6a0823c1bfa4da1efff3fc17d57db43899c58c gnucash-docs-4.6.tar.gz Regards, John Ralls > On Jun 27, 2021, at 4:21 PM, Glenn Fowler wrote: > > Hi, > > FYI the hashes for the last three are the same: > >251b01dfb9f9c679db26926f934ca4d13c7092a485be04f60e2031d85a445733 > gnucash-4.6.tar.bz2 >ad3a6ec1f5fdf15fd167808cf351bc1aa7c012ea03a16c73a3d1c29bbd59a03d > gnucash-4.6.tar.gz >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > gnucash-4.6.setup.exe >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > Gnucash-Intel-4.6-1.dmg >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > gnucash-docs-4.6.tar.gz > > On Sun, Jun 27, 2021 at 5:51 PM John Ralls wrote: > >> The GnuCash development team announces GnuCash 4.6, the sixth release in >> the stable 4.x series >> Between 4.5 and 4.6, the following bugfixes were accomplished: >> >>Bug 648335 - Display Created Transactions setting >> >>Add a preference for the 'Review Created Transactions' setting in the >> 'Since Last Run' dialog so that the default can be specified. >>Bug 743753 - Nearest in time security price selection is incorrect in >> reports >> >>Add new price source - 'nearest before report date' will ignore prices >> *after* report date. >>Bug 743999 - Deleting a digit from an existing number greater than >> four digits in length generates an error message. >> >>Because the grouping is off. Checking grouping on input is pointless >> so just ignore the grouping separator when parsing number input. >>Bug 753283 - Current Selection Highlight Lost After Transaction Edit >> in Scheduled Transaction Window >>Bug 787813 - Price change from editing a transaction not reflected in >> pricedb. >>Bug 794877 - Intro text of "Online Banking Setup" is outdated >>Bug 795804 - Extremely slow save >> >>Only update the status bar when the percentage changes by at least 1% >> because running the mainloop is expensive on macOS and Microsoft Windows. >> This speeds up all operations that run the progress bar with overly-fine >> resolution. >>Bug 796761 - Newline (char(10)) is inserted into the end of the string >> if copy & paste text from excel into the description field of transaction >>Bug 797787 - Feature request: preference setting to open new tabs >> adjacent to currently active tab >> >>tests preference; if enabled then new tab inserted after current. if >> disabled then new tab is at the end. >>Bug 797928 - Since last run asks for security price when no shares >> traded >>Bug 798093 - Changing the symbol/abbreviation of a security after the >> trading account was created breaks GnuCash.(Reopened) >>Bug 798133 - Gnucash crash when any custom action is entered >>Bug 798144 - Reconciliation uses different number than entered >> >>If a number was pasted into the balance end value with a currency >> symbol the number would silently fail on evaluate and cause the wrong value >> to be used. With previous changes to the GNCAmountEdit widget a warning >> symbol will indicate a validation error and prevents going forward. >>Bug 798148 - "Accounts" page Present (USD) column uses future prices >>Bug 798151 - Value entry box not tied to associated transaction in >> Since Last Run assistant >>Bug 798156 - glib 2.68.0 breaks gnucash >>Bug 798159 - Keyboard shortcut bug in 'manage document link' >>Bug 798162 - Type Ahead Initialization Problem >>Bug 798170 - Unbound variable: gnc-budget-lookup when running saved >> report Budget Report via gnucash-cli >>Bug 798177 - Price of new stock transactions not saved in price >> database >>Bug 798186 - Incorrect result editting account in register when >> overtyping a part selection. >>Bug 798188 - The Invoice Editor -> Printable Invoice toolbar button >> crashes on Windows >>Bug 798196 - not building with Boost 1.76 >>Bug 798199 - Pasting invalid value in date column crashes GnuCash >>Bug 798202 - Register input ignores theme on KDE rendering black text >> on black backgroun
[GNC] GnuCash 4.6 Released
The GnuCash development team announces GnuCash 4.6, the sixth release in the stable 4.x series Between 4.5 and 4.6, the following bugfixes were accomplished: Bug 648335 - Display Created Transactions setting Add a preference for the 'Review Created Transactions' setting in the 'Since Last Run' dialog so that the default can be specified. Bug 743753 - Nearest in time security price selection is incorrect in reports Add new price source - 'nearest before report date' will ignore prices *after* report date. Bug 743999 - Deleting a digit from an existing number greater than four digits in length generates an error message. Because the grouping is off. Checking grouping on input is pointless so just ignore the grouping separator when parsing number input. Bug 753283 - Current Selection Highlight Lost After Transaction Edit in Scheduled Transaction Window Bug 787813 - Price change from editing a transaction not reflected in pricedb. Bug 794877 - Intro text of "Online Banking Setup" is outdated Bug 795804 - Extremely slow save Only update the status bar when the percentage changes by at least 1% because running the mainloop is expensive on macOS and Microsoft Windows. This speeds up all operations that run the progress bar with overly-fine resolution. Bug 796761 - Newline (char(10)) is inserted into the end of the string if copy & paste text from excel into the description field of transaction Bug 797787 - Feature request: preference setting to open new tabs adjacent to currently active tab tests preference; if enabled then new tab inserted after current. if disabled then new tab is at the end. Bug 797928 - Since last run asks for security price when no shares traded Bug 798093 - Changing the symbol/abbreviation of a security after the trading account was created breaks GnuCash.(Reopened) Bug 798133 - Gnucash crash when any custom action is entered Bug 798144 - Reconciliation uses different number than entered If a number was pasted into the balance end value with a currency symbol the number would silently fail on evaluate and cause the wrong value to be used. With previous changes to the GNCAmountEdit widget a warning symbol will indicate a validation error and prevents going forward. Bug 798148 - "Accounts" page Present (USD) column uses future prices Bug 798151 - Value entry box not tied to associated transaction in Since Last Run assistant Bug 798156 - glib 2.68.0 breaks gnucash Bug 798159 - Keyboard shortcut bug in 'manage document link' Bug 798162 - Type Ahead Initialization Problem Bug 798170 - Unbound variable: gnc-budget-lookup when running saved report Budget Report via gnucash-cli Bug 798177 - Price of new stock transactions not saved in price database Bug 798186 - Incorrect result editting account in register when overtyping a part selection. Bug 798188 - The Invoice Editor -> Printable Invoice toolbar button crashes on Windows Bug 798196 - not building with Boost 1.76 Bug 798199 - Pasting invalid value in date column crashes GnuCash Bug 798202 - Register input ignores theme on KDE rendering black text on black background Bug 798203 - g_assert fault while reversing transaction Bug 798204 - Creation of Imbalance Accounts Bug 798212 - right-click the down-arrow in the date register changes focus to first split The following fixes and improvements were not associated with bug reports: Improve transaction sorting on effective num field so that alpha charachters and numbers larger than 1 billion will be ordered. Ordering is now numeric for leading numbers (so that 9 sorts before 10) and lexical beginning with the first non-numeric character. Note that if one of the values begins with an alpha character ordering will be entirely lexical. Lexical sorting is localized; as in the rest of GnuCash only standard ASCII numbers (codepoints U+0030 - U+0039) are treated as numbers. Add import preferences for the difference in time considered when matching an existing transaction to an imported one. A difference less than the matching-date-threshold raises the score of the match; a difference greater than match-date-not-threshold lowers the score. Add experimental report "IFRS weighted-average cost basis report". This is a work-in-progress to help calculate the cost basis of securities priced in a foreign currency. [income-gst-statement] amend headers post Brexit. UK left EU, therefore VAT headers have now changed. Plug a bunch of memory leaks. Change how the print_info is obtained for the register: Currently the register sets up some 'print_info' values using the default account but if the register is a stock register they should be obtained from a parent account with a currency. Change monetary value for gnc_default_share_print_info: Share values are not currencies so set the monetary value to 0 for the
Re: [GNC] Transaction report export file type
> On Jun 24, 2021, at 2:31 PM, Rich Shepard wrote: > > Is there a way to export a transaction report as a .csv or .txt file? I > looked at all options and didn't see any place to select the export format. > When I did export the file it defaulted to .html; that would take a lot of > cleaning and it would be nice to export to .csv or .txt. > > Any thoughts? It usually works to copy-and-paste the report into a spreadsheet. Regards, John Ralls ___ 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] Transactions imported from the file assigned to wrong account
Yes, that does sound like a bug. Please file a bug report at https://bugs.gnucash.org. You can easily cite this thread with https://code.gnucash.org/pipermail/gnucash-user/2021-June/096929.html Regards, John Ralls > On Jun 22, 2021, at 8:51 AM, Aleksandar Kocic wrote: > > While removing the account works, it seems like a bug. > > When I remove an account from Tools -> Import Map editor -> Online tab, I get > asked the next time which account I want to use when importing the file. > However, the Import Map Editor doesn't know how to process the file and > extract the account id (the "Match String"). Hence, the "Match String" is > left empty, and the next time I need to import a file, from the same bank but > a different account, the Import Map Editor picks up the existing account, no > question asked. > > As I pointed out before, it is a QFX file, and the line with the account id > looks like this: > USD1234567890CREDITLINE > > Regards, > Aleksandar > > > > On Mon, Jun 21, 2021 at 8:10 PM Aleksandar Kocic wrote: > Thanks John and David, > > The Import Map Editor helped. I removed the account in question, which btw > didn't have assigned the id, and it worked. I was asked to assign the account > when trying to import the file. > > On Mon, Jun 21, 2021 at 8:08 PM John Ralls wrote: > David Carlson pointed you halfway: Open Tools>Import Map Editor. > > The other half is to select the radio button "online" on the top of the > dialog. That should display the online-id to GnuCash account associations and > enable you to delete any that are incorrect. If there's only one then perhaps > GnuCash isn't picking up the right number; compare the online id with your > import file to see wha it's using. > > Regards, > John Ralls > > > > On Jun 21, 2021, at 4:56 PM, Aleksandar Kocic wrote: > > > > It is QFX. > > > > I understand the process; however, it doesn't work. All the files are > > assigned to the same account with no questions asked. > > > > Is there a way to remove this association and start fresh? > > > > On Mon., Jun. 21, 2021, 6:06 p.m. Jim DeLaHunt, > > wrote: > > > >> Aleksandar: > >> > >> Which file format are you importing? The UI and procedure are slightly > >> different for each one. I am most familiar with OFX file import, and > >> secondarily with CSV file import. > >> > >> At the beginning of the import process, there is a step when GnuCash has > >> you designate which GnuCash account should receive the transactions you > >> are importing. For OFX format files, GnuCash can then remember a > >> correspondence between the account number in the OFX file and the > >> GnuCash account which receives the transaction, and it doesn't need to > >> ask you the next time that you import. > >> > >> Have you read through the GnuCash Guide documentation about file import? > >> < > >> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx > >>> > >> > >> Best regards, > >> > >> —Jim DeLaHunt > >> > >> On 2021-06-21 13:17, Aleksandar Kocic wrote: > >>> I download the file from the bank's site and manually import it. > >>> > >>> I can see the account number in the file. However, for whatever reason, > >> the > >>> application chooses another account and it seems that cannot be changed. > >>> > >>> > >>> On Mon., Jun. 21, 2021, 3:55 p.m. John Ralls, > >> wrote: > >>> > >>>> > >>>>> On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic > >>>> wrote: > >>>>> Hi there, > >>>>> > >>>>> I am trying to import transactions downloaded from the bank. However, > >>>> since > >>>>> I have multiple accounts with the same institution, the transactions > >> are > >>>>> assigned to an already existing account. > >>>>> > >>>>> How do I select the account I want to use for importing transactions? > >>>> How are you doing the import and doesn't the bank include the bank > >> account > >>>> number? > >>>> > >>>> Regards, > >>>> John Ralls > >>>> > >>>> > >>> ___ > >>> gnucash-user mailing list >
Re: [GNC] Transactions imported from the file assigned to wrong account
David Carlson pointed you halfway: Open Tools>Import Map Editor. The other half is to select the radio button "online" on the top of the dialog. That should display the online-id to GnuCash account associations and enable you to delete any that are incorrect. If there's only one then perhaps GnuCash isn't picking up the right number; compare the online id with your import file to see wha it's using. Regards, John Ralls > On Jun 21, 2021, at 4:56 PM, Aleksandar Kocic wrote: > > It is QFX. > > I understand the process; however, it doesn't work. All the files are > assigned to the same account with no questions asked. > > Is there a way to remove this association and start fresh? > > On Mon., Jun. 21, 2021, 6:06 p.m. Jim DeLaHunt, > wrote: > >> Aleksandar: >> >> Which file format are you importing? The UI and procedure are slightly >> different for each one. I am most familiar with OFX file import, and >> secondarily with CSV file import. >> >> At the beginning of the import process, there is a step when GnuCash has >> you designate which GnuCash account should receive the transactions you >> are importing. For OFX format files, GnuCash can then remember a >> correspondence between the account number in the OFX file and the >> GnuCash account which receives the transaction, and it doesn't need to >> ask you the next time that you import. >> >> Have you read through the GnuCash Guide documentation about file import? >> < >> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx >>> >> >> Best regards, >> >> —Jim DeLaHunt >> >> On 2021-06-21 13:17, Aleksandar Kocic wrote: >>> I download the file from the bank's site and manually import it. >>> >>> I can see the account number in the file. However, for whatever reason, >> the >>> application chooses another account and it seems that cannot be changed. >>> >>> >>> On Mon., Jun. 21, 2021, 3:55 p.m. John Ralls, >> wrote: >>> >>>> >>>>> On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic >>>> wrote: >>>>> Hi there, >>>>> >>>>> I am trying to import transactions downloaded from the bank. However, >>>> since >>>>> I have multiple accounts with the same institution, the transactions >> are >>>>> assigned to an already existing account. >>>>> >>>>> How do I select the account I want to use for importing transactions? >>>> How are you doing the import and doesn't the bank include the bank >> account >>>> number? >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>> ___ >>> 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. >> > ___ > 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] Transactions imported from the file assigned to wrong account
> On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic wrote: > > Hi there, > > I am trying to import transactions downloaded from the bank. However, since > I have multiple accounts with the same institution, the transactions are > assigned to an already existing account. > > How do I select the account I want to use for importing transactions? How are you doing the import and doesn't the bank include the bank account number? Regards, John Ralls ___ 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] Transaction ordering on num field
> On Jun 15, 2021, at 5:19 PM, flywire wrote: > > http://gnucash.1415818.n4.nabble.com/GNC-dev-Dev-s-features-of-choice-tp4726710p4726713.html > >> "you can use Microsoft Access or Open/LibreOffice Base with SQLite3 via an >> ODBC driver" My, you're insistent on taking things out of context. Regards, John Ralls ___ 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] Transaction ordering on num field
> On Jun 15, 2021, at 4:43 PM, flywire wrote: > >> What "standard" are you referring to? > >> GnuCash stores information at the highest level in files. A file can be >> stored on your computer either as a single XML file (in all versions of >> GnuCash), or in a SQL database (in GnuCash version 2.4 and higher). That's just storage. Regardless of backend all of the data are loaded into C structs at the start of a session and all processing is done in C/C++ or Scheme on those structs. No database queries involved after the data are loaded. That's also a strange usage of the word "standard". > > The sort order of the application a user chooses to use to access the data. > It's a database. Whatever is generally available to sort alphanumeric data > in databases. Sorry, that doesn't make sense. Regards, John Ralls ___ 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] Transaction ordering on num field
What "standard" are you referring to? If you're arguing for the simplest possible that would be strcmp() that numerically compares each corresponding byte in two arrays of bytes. That works only for English encoded in ASCII. Doesn't work at all well for German, never mind Chinese. Glib provides a localization-supporting UTF-8 function that does work for all languages, g_utf8_compare(). The C and C++ standard sort functions are designed so that programs can easily implement sorts that support the use-cases being addressed: They take a callback function that returns 0 if the two arguments are equal, an int < 0 if the first one goes first and an int > 0 if the second one does. strcmp() and g_utf8_compare do that because the standard sort functions were designed around strcmp() and g_utf8_compare was designed as a drop-in replacement for strcmp(). But string comparison on its own doesn't work for ordering transactions by the num field in GnuCash. GnuCash has an obvious use-case where the num field contains serial numbers. As noted earlier it has keybindings for retrieving the last-used serial number and incrementing or decrementing it. It follows that numeric sorting is appropriate when it can be established that the field contains numbers, and that's what the current ordering callback does as long as the numbers fit in an int (±2 billion or so). But not all users do that, and it's complicated by the ability to use the split's action field for the transaction number so that one can have different values in different registers. It's a free text field: The input isn't (and never has been) checked to make sure that it's all numeric. The current ordering function behaves oddly in that case and a user brought that to our attention in https://github.com/Gnucash/gnucash/pull/983. That means that a hybrid approach is called for. It's pretty easily implemented, too. This is the evolution of GnuCash in action. Regards, John Ralls > On Jun 11, 2021, at 10:09 PM, flywire wrote: > > The question is about custom changes to the sorting algorithm (with an > undocumented feature) and I'm questioning actually using a *non-standard* > sorting algorithm. Using the 80:20 rule most of the benefit of the system > comes from a small part of it. How can GnuCash evolve if custom code is > carried forward forever? That may well involve a major change and as Will > pointed out it is easy to add leading zeros. > > - > > "The Reserve Bank of Australia (RBA) is Australia's central bank... It does > this by conducting monetary policy" https://www.rba.gov.au/about-rba/ > >> https://www.rba.gov.au/speeches/2020/sp-ag-2020-06-03.html#there-are-a-number-of-policy-implications >> https://www.rba.gov.au/speeches/2020/images/sp-ag-2020-06-03-graph01.gif >> "Is this suggesting the end of the cheque system? I think it may well >> be..." > > > > -- > 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. ___ 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] Incorrect Trial Balance Amounts
David, That would suppose that there's more documentation for the Trial Balance Report than the single sentence in https://www.gnucash.org/docs/v4/C/gnucash-guide/rpt_standardrpts.html#rpt_grp_incexp. Perhaps you'd like to write some? Regards, John Ralls > On Jun 15, 2021, at 12:12 AM, David Carlson > wrote: > > It would be nice if that method were described accurately in the > documentation, because going by the name it sounds like something completely > different and wrong if it is using incorrectly estimated prices instead of > actual transaction prices. I would make the same mistake if I were doing > what volker was doing. > > On Tue, Jun 15, 2021 at 1:02 AM Volker Englisch wrote: > Thank you for the explanation, John! I did have the price source for > the report set to "Nearest in time". After setting the source to > "Average Cost" the numbers came out as expected. > > Regarding your question about the proper recording of the capital gains, > I'm still going through the documentation to set up the accounts as > listed. My initial problem was that the numbers didn't add up even > before I sold anything. > > -- > Volker Englisch > phone: (240) 343-5343 (mobil) > mailto:vol...@englisch.us > > On 6/14/21 12:06 PM, John Ralls wrote: > >> On Jun 13, 2021, at 5:39 PM, Volker Englisch wrote: > >> > >> Hi there, > >> > >> I would like to check if I'm doing something wrong or if I'm correct in my > >> assumption that the Trial Balance report isn't displaying correct amounts > >> in all cases. > >> > >> I'm using Ubuntu 20.04.2 LTS with GnuCash 3.8. > >> > >> I started keeping track of some stock and entered the number of shares on > >> Jan. 1, 2021, for example. Let's say I have 100 shares worth $2 each. > >> Asset:Investment:MyStock200 (for 100 shares at $2) > >> Equity:Opening Balance200 > >> > >> After a while (April 1st) I sell all shares and enter the corresponding > >> transaction. The price for the shares increased to $3 since I started > >> tracking (I wish!): > >> Asset:Current Asset:Checking Account300 > >> Asset:Investment:MyStock 300 (for 100 shares, $100 > >> realized gains) > >> > >> When I run the trial balance report for the day I first entered MyStock > >> everything looks good: $200 debit / $200 credit. The same is true for the > >> day I sold MyStock: $300 debit / $200 credit, the difference is my gain. > >> However, when I run the trial balance for 03/01 for instance, the trial > >> balance shows $300 debit / $300 credit with $100 listed as unrealized > >> gains. > >> > >> What seems to be happening is that the TB calculates the value of the > >> stock based on the last price entered in the price editor rather than > >> using the last price prior to the date for which the TB is run. With two > >> entries in the price editor DB, one for 01/01 and one for 04/01 I would > >> expect the price for 01/01 to be used until 03/31. > >> > >> Am I doing something wrong? It's possible I'm not understanding precisely > >> how the TB is coming up with the numbers. > >> > >> Thank you! > > Did you record an income split for the capital gain? You mention the gain > > but I don't see the split for it in your example transaction. See > > https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.html for > > details about how to record capital gains/losses and why you should do so. > > > > As for price, the default in the Trial Balance Report is Average Cost > > (which isn't really, but the algorithm behind it is tailored specifically > > for the Trial Balance Report). That looks at the actual amounts and values > > in the splits; the Nearest in Time and Latest Price price sources consult > > the pricedb and won't balance, so don't use them. > > > > Regards, > > John Ralls > > > ___ > 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. > > > -- > David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] On a Mac, where are the database configuration details stored?
Generally speaking the passwords are stored in Keyring and the user is prompted if the password isn't found. I'm not sure what it does if the connection doesn't have a password. You can examine the keyring with /Applications/Utilities/Keyring Access. If it does have an entry for your database then you can either add the password there or delete the entry and GnuCash will prompt you for the password when you try to connect. If there's no entry then I think you need to use File>Open to make a fresh connection and provide all of the information in the connection dialog. On the off chance you want to look at the code start at https://github.com/Gnucash/gnucash/blob/maint/gnucash/gnome-utils/gnc-file.c#L748. Regards, John Ralls > On Jun 13, 2021, at 5:32 PM, Peter West wrote: > > Thanks John. > > I was looking for the way the connection is actually set up. At the moment, I > have no password requirement for local connections (and no external > connections.) If I want to add password validation to postgresql, what > happens to my GnuCash connection? > > > — > Peter West > p...@ehealth.id.au > “And if anyone forces you to go one mile, go with him two miles.” > >> On 14 Jun 2021, at 3:11 am, John Ralls wrote: >> >> >> >>> On Jun 13, 2021, at 4:09 AM, Peter West wrote: >>> >>> As it says, where can I find the details of the database connection? >> >> You mean for opening the most recently used book? In >> ~/Library/Preferences/org.gnucash.GnuCash.plist. You can read the values >> with e.g. >> defaults read org.gnucash.Gnucash /org/gnucash/history/file0 >> or all of them >> defaults read org.gnucash.Gnucash | grep history >> >> Regards, >> John Ralls >> > ___ 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?
> On Jun 13, 2021, at 8:53 PM, Jim DeLaHunt wrote: > > Imagine if cars or medicines or food were produced with that as a guiding > principle. They are. The state requires extensive training and licensing before one is allowed to operate a car or to prescribe medicine. There's no such requirement for food (unless you're selling prepared meals to others) and as a result factory food has caused enormous damage to health; and the licensing requirements don't stop people from doing great harm with all three. Yet only prescription drugs have restrictions on distribution: I've bought a bunch of cars over the years and never once has the seller asked for my driver's license. There's exactly one non-prescription drug with a restriction, psuedoephedrine, and that's to make it hard to buy enough to cook meth--but the permitted amount is more than enough to poison someone. There are also lots of examples of things readily available for sale where the user is well advised to get some training before using them, but there's no actual requirement to do so. Power saws are an excellent example. "If not duffer won't cut thumb off", to paraphrase Ransome. Caveat emptor is the way of the world. Regards, John Ralls ___ 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] Incorrect Trial Balance Amounts
> On Jun 13, 2021, at 5:39 PM, Volker Englisch wrote: > > Hi there, > > I would like to check if I'm doing something wrong or if I'm correct in my > assumption that the Trial Balance report isn't displaying correct amounts in > all cases. > > I'm using Ubuntu 20.04.2 LTS with GnuCash 3.8. > > I started keeping track of some stock and entered the number of shares on > Jan. 1, 2021, for example. Let's say I have 100 shares worth $2 each. >Asset:Investment:MyStock200 (for 100 shares at $2) >Equity:Opening Balance200 > > After a while (April 1st) I sell all shares and enter the corresponding > transaction. The price for the shares increased to $3 since I started > tracking (I wish!): > Asset:Current Asset:Checking Account300 > Asset:Investment:MyStock 300 (for 100 shares, $100 realized > gains) > > When I run the trial balance report for the day I first entered MyStock > everything looks good: $200 debit / $200 credit. The same is true for the > day I sold MyStock: $300 debit / $200 credit, the difference is my gain. > However, when I run the trial balance for 03/01 for instance, the trial > balance shows $300 debit / $300 credit with $100 listed as unrealized gains. > > What seems to be happening is that the TB calculates the value of the stock > based on the last price entered in the price editor rather than using the > last price prior to the date for which the TB is run. With two entries in > the price editor DB, one for 01/01 and one for 04/01 I would expect the price > for 01/01 to be used until 03/31. > > Am I doing something wrong? It's possible I'm not understanding precisely > how the TB is coming up with the numbers. > > Thank you! Did you record an income split for the capital gain? You mention the gain but I don't see the split for it in your example transaction. See https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.html for details about how to record capital gains/losses and why you should do so. As for price, the default in the Trial Balance Report is Average Cost (which isn't really, but the algorithm behind it is tailored specifically for the Trial Balance Report). That looks at the actual amounts and values in the splits; the Nearest in Time and Latest Price price sources consult the pricedb and won't balance, so don't use them. Regards, John Ralls ___ 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] On a Mac, where are the database configuration details stored?
> On Jun 13, 2021, at 4:09 AM, Peter West wrote: > > As it says, where can I find the details of the database connection? You mean for opening the most recently used book? In ~/Library/Preferences/org.gnucash.GnuCash.plist. You can read the values with e.g. defaults read org.gnucash.Gnucash /org/gnucash/history/file0 or all of them defaults read org.gnucash.Gnucash | grep history Regards, John Ralls ___ 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?
> On Jun 13, 2021, at 12:39 AM, Jim DeLaHunt wrote: > > GnuCash ships with Helper Scripts which make it easier to work with > Finance::Quote. They are: gnc-fq-check, gnc-fq-dump, gnc-fq-helper, and > gnc-fq-update. Collectively, call them gc-fq-* . > > When running these Helper Scripts from a command prompt on MacOS and Linux, > should they invoked as commands: > > % gnc-fq-check > > Or should they be invoked as an argument to a perl command: > > % perl gnc-fq-check > > ? > > The wiki page https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts > says, pretty clearly, the former: > > "While unixoid operating systems use a shebang (#!) to associate perl scripts > with the Perl interpreter, others, e.g. Windows, will fail…. > C:\> gnc-fq-check [fails]… > so use the following: … Prefix any gnc-fq-xxx perl script command with perl > and a space: … > perl gnc-fq-check …" > > The perl invocation is described as a workaround needed on Windows because > the shebang doesn't work. All the other examples show invocation as a > command, e.g. > > $ gnc-fq-check > > This makes a difference on Unixoid systems when there are multiple Perl > installations. Presumably command invocation of the helper scripts will > always obey the shebang and thus always run the same Perl installation. But > invocation as an argument to "perl" will run whichever Perl installation the > environment dictates. > > Am I correct in guessing that GnuCash 4.5 internally invokes these scripts > (maybe just gnc-fq-helper) as an argument to a perl command? > > If so, should the wiki page https://wiki.gnucash.org/wiki/Online_Quotes use > the same invocation? The answer depends on what the user wants or in this case for which perl they want to or did install F::Q. People who have multiple perl installations shouldn't need to be told; people who need to be told then they shouldn't have multiple perl installations. Arthur Ransome opened 'Swallows and Amazons` with the doggerel "Better drowned than duffers. If not duffers won't drown." An excellent guiding principle to system administration. Regards, John Ralls ___ 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.
