[GNC] Reconcile Problem
Hi, This is my first post so hopefully I am doing things correctly. I have been appointed as Treasurer to a Club and have been handed the accounts from the previous treasurer who used Gnucash. The problem I am having is how can I see the previous reconciled transactions, I have looked in the preference settings but can't find any tick box that would allow me to do this. Any help much appreciated. ___ 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] Saved Report Configurations Missing After Upgrade to v3
Op donderdag 7 juni 2018 05:38:47 CEST schreef Mike Churchill via gnucash- user: > Ok Tom. Good to hear you were successful. I wondered about the 2.8 also, > but it seems to be the right file. Mike > The 2.8 version is a small oversight. It was decided fairly late in the last development cycle to name the next big release 3.0. Before that we were aiming for 2.8 as a natural follow up for 1.8->2.0->2.2->2.4->2.6. The release numbering scheme was changed, but we omitted renaming the saved- reports file. Tom, out of curiosity: where did you find the old saved-reports-2.4 file ? Normally gnucash does migrate the metadata to %APPDATA%\GnuCash on the first time you run a gnucash 3.x version from %USER%\.gnucash. I can imagine a few situations where that won't happen: 1. %APPDATA%\GnuCash already exists 2. Can't create %APPDATA%\GnuCash (in which case the trace file should have a warning) 3. %USER%\.gnucash doesn't exist A variation of 3. can be that you changed the HOME variable in the gnucash environment file or you have set GNC_DOT_DIR to point to another directory. In those cases the migration will never happen and the user should do this manually. 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.
Re: [GNC] Reconcile Problem
Hi, I'm not sure I understand your issue here. Gnucash will show you all your transactions, reconciled or not, unless you View - > Filter to turn it off. Perhaps your data file does not have earlier transactions? -derek Sent using my mobile device. Please excuse any typos. On June 7, 2018 9:51:51 AM Gareth Davies via gnucash-user wrote: Hi, This is my first post so hopefully I am doing things correctly. I have been appointed as Treasurer to a Club and have been handed the accounts from the previous treasurer who used Gnucash. The problem I am having is how can I see the previous reconciled transactions, I have looked in the preference settings but can't find any tick box that would allow me to do this. Any help much appreciated. ___ 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] USING THE SAME GNUCASH FILE ON BOTH LINUX AND WINDOWS COMPUTERS
Dennis Powless wrote > You could use a cloud based storage service, with all computers linked, > such as Dropbox. > You can have GC on as many computers as you see fit, each using the same > GC data file. > That way you’re not depending on a usb drive that could get misplaced > etc > Dennis Right. I can confirm this works fine as I'm using the same book on Windows and Linux machines, synchronized via Dropbox. The book itself is an sqlite database. Probably, if you used a MySql/MariaDb instance, all the workstations in the organization could connect to it seamlessly. I am not, however, using any custom reports in GnuCash. These used to be stored in user's profile directory and would have had to be copied to other machines. With v3 the location has changed but I believe the principle is the same. -- 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.
Re: [GNC] Reconcile Problem
Hi Gareth. Welcome to the list. With the account register open, click on the "view" item in the menu bar, then in the dialog that opens click on "filter by". Then click on "status" in that menu bar which opens a selection dialog. Clear the checks from all but "Reconciled". Then click on OK. Putting a check in the "save filter" box will make the selection persistent from session to session, otherwise the filter will revert to the default (all categories selected) the next time you open the account register. You'll have to set the filter for each account register individually. Ron Morse. On 06/07/2018 01:50 AM, Gareth Davies via gnucash-user wrote: Hi, This is my first post so hopefully I am doing things correctly. I have been appointed as Treasurer to a Club and have been handed the accounts from the previous treasurer who used Gnucash. The problem I am having is how can I see the previous reconciled transactions, I have looked in the preference settings but can't find any tick box that would allow me to do this. Any help much appreciated. ___ 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] gnctimeperiod-utilities.scm. etc.
I've added the 3 files gnctimeperiod-utilities.scm, transaction.scm and config.user to /home//.gnucash (Linux Mint, GC 2.6.12). Under the reports tab, I see 2 entries labveled "transaction report" - both seem to be identical. Running one of them gives me the result I needed (summary totals by description field for a period of time). The other does the exact same. And I noted a bug - I cannot set it to the previous year's start and end dates in the options dialog. It always reports only the current year. Did I install things wrongly? - Elmar ___ 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] Email Invoices
> On Jun 6, 2018, at 7:44 AM, J-P Hartzenberg wrote: > > Dear Sir/Madam > > How do you email out invoices directly from the system? You don’t. GnuCash contains no email interface. You can print/export the invoice to pdf and then email it as an attachment. 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] Saved Report Configurations Missing After Upgrade to v3
Hi Geert, The old saved-reports-2.4 file was found in the %USER%\.gnucash folder. None of the 3.-variations you mention apply here. When I located the 2.4 file, I backed up the new 2.8 file to take it completely out of the picture, then copied the 2.4 file over to %APPDATA%\GnuCash to see what would happen. If nothing, I figured I'd rename the file from 2.4 to 2.8, but it worked with the 2.4 name. Is this alright? Will it cause problems later? Is there a better way? A little history on this installation. I'm not sure I'd remember the initial installed version, but it was back in the fall of 2016 when I installed GnuCash on Windows in whatever manner the installer prescribed as the standard install. I LOVE the true double entry accounting GnuCash allows over the typical one-sided manner in which most financial programs (e.g., Quicken, et al) provide. My only disappointment has been in the reporting formats. Not so much what is in the reports or the ability to customize them; that's all perfectly acceptable. It's the overall report styling. I don't understand why on the Income Statement, for instance, there's a small font "Net Income for Period" line following a large, bold "Total Expenses" line. The formatting is whack, and I just don't see an easy way to correct it or any resources to teach me how. (Know of any? Please share!) That got me thinking that, since MySQL was an option, I could just ODBC in with Microsoft Access and potentially use it's report writer to generate prettier reports than I know how to make within GnuCash. I never really got to report designing in Access, but it sure got me over some initial reconciliation pains! But regardless, and for better or worse, I left the backend for GnuCash as MySQL. When I upgraded to 3.x, that is the environment it found itself upgrading. I'm slipping out of scope on the OP topic here, but (in the Windows environment, if that matters) what is the best practice for data storage? Am I setting myself up for problems using MySQL? Has my use of MySQL contributed to the missing report situation on upgrade to 3.x? Thanks, Tom On Thu, Jun 7, 2018 at 3:09 AM Geert Janssens wrote: > Op donderdag 7 juni 2018 05:38:47 CEST schreef Mike Churchill via gnucash- > user: > > Ok Tom. Good to hear you were successful. I wondered about the 2.8 > also, > > but it seems to be the right file. Mike > > > The 2.8 version is a small oversight. It was decided fairly late in the > last > development cycle to name the next big release 3.0. Before that we were > aiming > for 2.8 as a natural follow up for 1.8->2.0->2.2->2.4->2.6. > > The release numbering scheme was changed, but we omitted renaming the > saved- > reports file. > > > Tom, out of curiosity: where did you find the old saved-reports-2.4 file ? > > Normally gnucash does migrate the metadata to %APPDATA%\GnuCash on the > first > time you run a gnucash 3.x version from %USER%\.gnucash. > > I can imagine a few situations where that won't happen: > 1. %APPDATA%\GnuCash already exists > 2. Can't create %APPDATA%\GnuCash (in which case the trace file should > have a > warning) > 3. %USER%\.gnucash doesn't exist > > A variation of 3. can be that you changed the HOME variable in the gnucash > environment file or you have set GNC_DOT_DIR to point to another directory. > > In those cases the migration will never happen and the user should do this > manually. > > 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.
Re: [GNC] Saved Report Configurations Missing After Upgrade to v3
Op donderdag 7 juni 2018 16:48:11 CEST schreef Thomas Forrester: > Hi Geert, > > The old saved-reports-2.4 file was found in the %USER%\.gnucash folder. > None of the 3.-variations you mention apply here. > > When I located the 2.4 file, I backed up the new 2.8 file to take it > completely out of the picture, then copied the 2.4 file over to > %APPDATA%\GnuCash > to see what would happen. If nothing, I figured I'd rename the file from > 2.4 to 2.8, but it worked with the 2.4 name. Is this alright? Will it > cause problems later? Is there a better way? > No. That is what the migration should have done as well. > When I upgraded to 3.x, > that is the environment it found itself upgrading. Ok, do you think you could still find the trace file gnucash generated the first time you started gnucash 3.x ? Where to find trace files is described here: http://wiki.gnucash.org/wiki/Tracefile Secondly, the first time you ran gnucash 3.x did you get a pop up window explaining you your metadata was being moved to a new location ? And lastly, did you ever experiment with the 2.7 development series on your current machine ? > > I'm slipping out of scope on the OP topic here, but (in the Windows > environment, if that matters) what is the best practice for data storage? > Am I setting myself up for problems using MySQL? Has my use of MySQL > contributed to the missing report situation on upgrade to 3.x? > Xml is still considered the most stable format in general. That is independent of your OS. On the other hand the db formats are improving with each release. We did find a few issues in gnucash 3.0 and 3.1 in this area. So be sure to read the release notes for more details. 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.
Re: [GNC] Where is the theme selection in 3.x?
/*Hope something similar comes back in a future version, cause speaking on behalf of those who (1) don't have the time or (2) the skills or (3) the patience, following the instructions in that wiki link to get some decent color in GnuCash, well, that just "ain't" goin' happen.*/ */Not user friendly.../* -- 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.
Re: [GNC] Where is the theme selection in 3.x?
Op donderdag 7 juni 2018 19:03:09 CEST schreef randix: > /*Hope something similar comes back in a future version, cause speaking on > behalf of those who (1) don't have the time or (2) the skills or (3) the > patience, following the instructions in that wiki link to get some decent > color in GnuCash, well, that just "ain't" goin' happen.*/ > > */Not user friendly.../* > It can certainly come back if someone is willing to spend developer time on it. Preferably someone who isn't already buried in other gnucash development work... 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.
Re: [GNC] Email Invoices
Thank you John. Regards, J-P Hartzenberg -Original Message- From: John Ralls [mailto:jra...@ceridwen.us] Sent: Thursday, 07 June 2018 16:46 To: J-P Hartzenberg Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Email Invoices > On Jun 6, 2018, at 7:44 AM, J-P Hartzenberg wrote: > > Dear Sir/Madam > > How do you email out invoices directly from the system? You don’t. GnuCash contains no email interface. You can print/export the invoice to pdf and then email it as an attachment. 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] Email Invoices
Hi, J-P Hartzenberg writes: > Dear Sir/Madam > > How do you email out invoices directly from the system? There is no "direct" way. GnuCash is not a mail agent. You need to "print" the invoices (save to PDF), and then you need to manually use your email program to attach and send them to your customers. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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] Autofill with Open Date?
Hi, "Maf. King" writes: > On Wednesday, 6 June 2018 16:25:15 BST Sensei Tim Rosanelli wrote: >> Hi All, >> >> I am using Gnucash for my business and love it but I have one question. >> >> Most of my transaction are via credit card. That means that the invoice >> open date, line item date, post date, due date, and payment date are all >> the same. Gnucash autofills with todays date but I am usually entering >> invoices a few day later. Gnucash requires me to enter each date >> individually which requires a huge amount of time. >> >> Is there any way to automatically enter the post date, due date, and >> payment? Or is there any way for these field to autofill with the open >> date instead of today's date? This would save me hours of work each month. >> >> > > Hi Tim, > > I only use the business features for items that really are Accounts Payable, > where the bill will be paid some time after the date that is has been raised. > > For items that my business buys directly - by card or cash - I don't bother > with the whole create invoice - process payment and just use a credit card > register for those transactions. Moreover, it sounds like Tim is using an A/R or A/P register directly. Don't do that! Those registers are not meant for Human Interaction -- transactions into those registers are generally only supposed to be created by using the Business features (Invoice/Bill etc). > 0.02 > Maf. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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
Thank you Maf, The very first thread led me to the answer. Simply a matter of adding a ".AX" suffix to the share code! How I struggled to resolve the matter prior! As always the solution is simple. Thank again for responding to my outcry. Dave W On 06/06/18 23:48, Maf. King wrote: Hi, have you tried the list archives? Try this thread (yes it is Win, but that isn't relevant) https://lists.gnucash.org/pipermail/gnucash-user/2018-May/076983.html or maybe this https://lists.gnucash.org/pipermail/gnucash-user/2018-April/075839.html HTH, Maf. On Wednesday, 6 June 2018 13:50:39 BST WasserLand wrote: I have a problem with getting quotes for my ASX portfolio in GnuCash. Finance::Quote no longer works. I am running Ubuntu 16.04. Any help, please. Dave W On 04/06/18 13:07, WasserLand wrote: I have just re-subscribed to the List. I am sure this issue has been well aired so I apologise for the question: Can no longer get quotes for my share portfolio. ASX. It stopped some many months ago. Google has been of little help. Is there a present, definative way to get my quotes going again? Dave W ___ 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.
[GNC] Why Report Stock Fractional Share Price in 3.1?
https://money.stackexchange.com/questions/96145/why-is-gnucash-now-tracking-share-prices-in-fractions ___ 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.