Re: [GNC] Strange incorrect due date calculated on a duplicated bill
10:59:00 the canonical "neutral" time, chosen so that the date doesn't change regardless (almost) of time zone. Regards, John Ralls > On May 30, 2022, at 4:10 PM, Adrien Monteleone > wrote: > > I'm using SQLite, but the time stamp for posting is: > > 2021-11-07 10:59:00 > > Which seems to be a regularly used stamp, for this vendor at least. > > A subsequent duplicated bill (off of this one) for December correctly > calculated Net20 from 12/7 as 12/27. (also using the 10:59:00 stamp) > > Regards, > Adrien > > On 5/30/22 5:54 PM, Derek Atkins wrote: >> Hi, >> First, yes, the attachment came through. >> Second, you posted on the 7th and the due date is the 26th. >> My initial guess, as it's a Net20, is that there is a TimeOfDay issue at >> hand here, where the addition of 20 days is such that it thinks it's >> before the 27th. >> Did you actually post it? If so, can you take a look at the XML for the >> invoice and see what date/time is actually presented? > > ___ > 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] Duplicating a bill with a linked document duplicates the link as well
Trying to edit one of these document links produced a crash. It is filed here for anyone interested: https://bugs.gnucash.org/show_bug.cgi?id=798545 Regards, Adrien On 5/30/22 8:25 PM, Adrien Monteleone wrote: Not sure if this is intended behavior. I use the 'Duplicate' bill/invoice feature to repeat something that requires little or no change, save for the relevant dates. But I just realized, I've got a chain of duplicated vendor bills off one bill that already had a linked PDF copy of the bill. I was later going to link the proper PDF files to each GnuCash bill, but I noticed that they all already have the exact same link as the original, thus all pointing to the same file. There might be a use case I'm not thinking of, but this seems a bit odd to me. It also means I can't use a workflow to process all bills that don't have attachments as a way of keeping track of which ones need to be updated. I now need to check the links for each and every one till I find out which happened to be the original. ___ 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] Duplicating a bill with a linked document duplicates the link as well
Not sure if this is intended behavior. I use the 'Duplicate' bill/invoice feature to repeat something that requires little or no change, save for the relevant dates. But I just realized, I've got a chain of duplicated vendor bills off one bill that already had a linked PDF copy of the bill. I was later going to link the proper PDF files to each GnuCash bill, but I noticed that they all already have the exact same link as the original, thus all pointing to the same file. There might be a use case I'm not thinking of, but this seems a bit odd to me. It also means I can't use a workflow to process all bills that don't have attachments as a way of keeping track of which ones need to be updated. I now need to check the links for each and every one till I find out which happened to be the original. -- Regards, Adrien ___ 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] Strange incorrect due date calculated on a duplicated bill
I'm using SQLite, but the time stamp for posting is: 2021-11-07 10:59:00 Which seems to be a regularly used stamp, for this vendor at least. A subsequent duplicated bill (off of this one) for December correctly calculated Net20 from 12/7 as 12/27. (also using the 10:59:00 stamp) Regards, Adrien On 5/30/22 5:54 PM, Derek Atkins wrote: Hi, First, yes, the attachment came through. Second, you posted on the 7th and the due date is the 26th. My initial guess, as it's a Net20, is that there is a TimeOfDay issue at hand here, where the addition of 20 days is such that it thinks it's before the 27th. Did you actually post it? If so, can you take a look at the XML for the invoice and see what date/time is actually presented? ___ 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] Strange incorrect due date calculated on a duplicated bill
Hi, First, yes, the attachment came through. Second, you posted on the 7th and the due date is the 26th. My initial guess, as it's a Net20, is that there is a TimeOfDay issue at hand here, where the addition of 20 days is such that it thinks it's before the 27th. Did you actually post it? If so, can you take a look at the XML for the invoice and see what date/time is actually presented? -derek On Mon, May 30, 2022 6:35 pm, Adrien Monteleone wrote: > I'm catching up on some paperwork and entering old vendor bills. I've > never seen this issue before, and can't seem to figure out why this one > bill is not correctly calculating the due date. > > Screen shot is attached. (hopefully it goes through) > > Terms are set at Net20. Every other bill for this vendor correctly > calculates the due date as the 27th of the month, for their bills posted > on the 7th. > > I don't think using the Duplicate feature is even at play because I just > did that about 10 times prior with no issues. > > Any ideas? Bug? > -- > Regards, > Adrien___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote on Mac Air
> On May 30, 2022, at 5:09 PM, Dieter Kip via gnucash-user > wrote: > > Hi there! > > I installed Finance::Quite on my MacBook Air and GnuCash recognizes that it > is installed on the computer. However, GnuCash is not obtaining any quotes…. > > When I test the “generic” commands to test the program like ECHO I got a > response… All other commands like gnc-fa-update are not executed…. > > Could that be because the GnuCash path is not recognized/properly set up to > get the quotes into GnuCash? > > Thank you very much for your help!! > > With kind regards, > > Dieter Kip > > It could be a lot of things, but when I had a similar instance doing “install Mozilla::CA” via cpan solved my issue. In general, I’ve always had the CA file installed, but when Apple messed with the location of perl, the lack of the CA file wasn’t caught during the installation of Finance::Quote or any of its dependencies. -- Dave Reiser dbrei...@icloud.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] Finance::Quote on Mac Air
The fq-update & manual quote commands should work if it is installed properly. It may not be. How did you install it? What API are you using? Alphavantage? You need to put your API key in GnuCash preferences for GnuCash to be able to use it. Regards, Adrien On 5/30/22 4:09 PM, Dieter Kip via gnucash-user wrote: Hi there! I installed Finance::Quite on my MacBook Air and GnuCash recognizes that it is installed on the computer. However, GnuCash is not obtaining any quotes…. When I test the “generic” commands to test the program like ECHO I got a response… All other commands like gnc-fa-update are not executed…. Could that be because the GnuCash path is not recognized/properly set up to get the quotes into 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.
[GNC] Finance::Quote on Mac Air
Hi there! I installed Finance::Quite on my MacBook Air and GnuCash recognizes that it is installed on the computer. However, GnuCash is not obtaining any quotes…. When I test the “generic” commands to test the program like ECHO I got a response… All other commands like gnc-fa-update are not executed…. Could that be because the GnuCash path is not recognized/properly set up to get the quotes into GnuCash? Thank you very much for your help!! With kind regards, Dieter Kip Sent from my iPhone ___ 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] Question about gnucash
> On May 30, 2022, at 3:27 AM, stephen.lohn...@oxnee.com wrote: > > Dear gnucash-user, > > > > I have a question is there any documentation about installing and creating > report via Scheme. I assume that it is interpretive language so that once it > is installed in in the correct directory it will be visibly to use. > > > > I have tried to connect it to PostgreSQL but I have not had any success, I > know that my PostgreSQL is working correctly as I use for Django > development, I tried the sqlite3 that seems to work but I don't know where > the db file is created as I have a sqlite browser > For custom reports, https://wiki.gnucash.org/wiki/Custom_Reports is a good starting point. For pgsql if you're a Linux user you may need to install libdbd-pgsql; note that that's what Debian calls it, other distros may have slightly different names. The SQLite3 file is created wherever you told GnuCash to create it in the File>New or File>Save As dialogs. 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] error when I try to save in MySQL or sqlite3
I see how you might have gotten the impression that the bundles don't have everything you need. I've rewritten it to be clearer. Thanks. Regards, John Ralls > On May 28, 2022, at 2:58 PM, D wrote: > > Oh. My mistake. It's in the Guide at: > > https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html > On May 28, 2022, at 17:47, John Ralls wrote: > What wiki page is that? > > Regards, > John Ralls > > >> On May 28, 2022, at 11:49 AM, David T. < sunfis...@yahoo.com> wrote: >> >> I guess the wiki page that suggests that sql drivers might not be available >> for Windows could be updated... >> >> On May 28, 2022 2:44:14 PM EDT, "David T. via gnucash-user" < >> gnucash-user@gnucash.org> wrote: >> Oh. Okay. Thanks for the correction. >> >> On May 28, 2022 10:42:43 AM EDT, John Ralls wrote: >> >> >> >> >> You are mistaken. The Windows bundle includes everything necessary >> to connect to Postgres and MySQL. >> >> >> >> >> >> Regards, >> >> >> John Ralls >> >> >> >> >> >> >> >> >> >> >> >> >>On May 28, 2022, at 5:17 AM, David T. via gnucash-user < >> >> gnucash-user@gnucash.org >> > wrote: >> >> >> >> >> >> Gustavo, >> >> >> >> >> >> The image didn't come through, and you didn't give the version of Gnucash >> you're using, but the mail client tag line suggests that you are on Windows, >> and I'll assume it's a recent version of Gnucash. >> >> >> >> >> >> Most likely, you're using the standard download of Gnucash for Windows, >> which I believe doesn't include the database drivers for postgresql by >> default. You would need to download and compile Gnucash yourself to get that >> functionality, something that requires a bit of research and work on your >> part. >> >> >> >> >> >> You might explain why you are trying to use the SQL back end in the first >> place; most users don't benefit from using them. >> >> >> >> >> >> David >> >> >> >> >> >> >> >> >> On May 26, 2022 12:26:29 PM EDT, Gustavo Adolfo Landaeta Mantilla < >> >> glandaet...@hotmail.com >> > wrote: >> >> >> >> >> >> >> Hi >> >> >> >> >> >> I tried to save a new book in postgres that I just installed but is giving >> me an error : >> >> >> [ >> >> cid:image001.png@01D87125.7088C5D0 >> ] >> >> >> >> >> >> I followed the tutorial in google ( >> >> https://youtu.be/3DuNTVVhupc >> ) and I can see that it works for him, but I don’ t know why is not working >> for me. >> >> >> >> >> >> Can yo help with this issue? >> >> >> >> >> >> Kind Regards >> >> >> >> >> >> Gustavo >> >> >> >> >> >> >> >> >> Sent from Mail< >> >> https://go.microsoft.com/fwlink/?LinkId=550986 >> > for Windows >> >> >> >> >> >> >> >> >> >> >> >> 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] Startup issue - two windows
I was running GnuCash full screen. Since switching to Windows mode, I have not had the issue at startup about interaction between Tip of the Day and Scheduled transactions. This is GnuCash 4.10 on Linux Fedora On Tue, May 10, 2022 at 8:40 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The issue with not being able to close the tip of the day window is the > Scheduled Transactions window has stolen focus. > > First click on the Tip of the Day window to raise it to the 'top of the > window stack' and then close it. > > Then use whatever means of your OS to reveal windows hidden beneath > other windows. There you'll see the Scheduled Transaction window, where > you can interact/dismiss it. > > Alternatively, do that part first, then dismiss the Tip of the Day window. > > What OS? Are you running GnuCash full screen at startup? > > Regards, > Adrien > > On 5/10/22 9:48 PM, Fred Tydeman wrote: > > I have Tip of the Day enabled. > > I have Scheduled transactions enabled. > > Sometimes, when I start gnucash, > > the Tip of the day popup window shows, > > then after the file is fully loaded, > > something about Scheduled transactions window shows > > (but is hidden by the Tip of the day). > > Clicking on the Close button of the Tip of the day does NOT close it. > > I do not know what the Scheduled transactions window wants > > as I cannot see it. > > Pressing Enter, clears the Scheduled transactions window. > > Then I can Close the Tip of the day window. > > ___ > 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] Report Error: Trial balance
Running GnuCash 4.10 on Linux. Tried to do a Trial Balance Report. Got: Report error An error occurred while running the report. 7 (apply-smob/1 #) In c-interface.scm: 35:4 6 (gnc:call-with-error-handling _ _) In ice-9/boot-9.scm: 829:9 5 (catch _ _ # …) In c-interface.scm: 39:40 4 (_) In report-core.scm: 752:25 3 (gnc:report-render-html #< type: "216cd0cf6931453ebcce…> …) In standard/trial-balance.scm: 517:29 2 (trial-balance-renderer _) In commodity-utilities.scm: 905:8 1 (gnc:sum-collector-commodity # …) In unknown file: 0 (+ 0 7 93000 21 9400 48500 35000 32576559/100 0 0 0 0 0 …) In procedure +: Wrong type: #f ___ 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] Quotes issue
On Sat, 28 May 2022 17:26:47 -0700 John Ralls wrote: > You're missing that the environment in your shell isn't necessarily > the one that GnuCash sees unless you launch GnuCash from that shell. > Enter your API key in Preferences>Online Quotes to cover that case. > > Regards, > John Ralls > That was it! Thanks, Steve > > > On May 28, 2022, at 4:42 PM, Steve wrote: > > > > When I do Tools->Price Database->Get Quotes I get: > > > > ERROR: ALPHAVANTAGE_API_KEY must be set for currency and quotes. > > See > > https://wiki.gnucash.org/wiki/Online_Quotes/#Source_Alphavantage.-2C_US > > > > and yet: > > > > steve@stevesdesktop:~/Downloads$ env|grep ALPHAVANTAGE > > ALPHAVANTAGE_API_KEY=D5IXXX > > > > steve@stevesdesktop:~/Downloads$ gnc-fq-dump currency GBP USD > > 1 GBP = 1.2630887 USD > > > > steve@stevesdesktop:~/Downloads$ gnc-fq-dump yahoo_json GOOGL > > Finance::Quote fields Gnucash uses: > > symbol: GOOGL<=== required > > date: 05/27/2022 <=== recommended > > currency: USD <=== required > > last: 2246.33 <=\ > > nav: <=== one of these > >price: <=/ > > timezone: <=== optional > > steve@stevesdesktop:~/Downloads$ > > > > I have all my quotes set up to use yahoo_json so what am I missing? > > > > Steve > > ___ > > 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] Duplicate stocks
I am doing File Import Import Prices from a CSV file... Next Select a csv file with Symbol, Date, Currency, and Amount data Click the column headers for: Date, Currency, and Amount But, when I click the Commodity From bar I get a popup window with my securities listed along with currencies. However, most stocks or mutual funds are listed twice. I looked in bugs.gnucash.org and did not see this bug. ___ 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] Question about gnucash
Dear gnucash-user, I have a question is there any documentation about installing and creating report via Scheme. I assume that it is interpretive language so that once it is installed in in the correct directory it will be visibly to use. I have tried to connect it to PostgreSQL but I have not had any success, I know that my PostgreSQL is working correctly as I use for Django development, I tried the sqlite3 that seems to work but I don't know where the db file is created as I have a sqlite browser Regards Stephen This is the version I am using on MS windows 10 ___ 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.