Re: [GNC] Fwd: The two modules
Yes, it is the alignment of numbers that is the problem. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/18/2018 06:35 AM, Christopher Lam wrote: > Hi Stephen > Thank you this is very helpful. > From my understanding the non-eguile version does produce satisfactory > headings and contents. > However its alignment of numbers is odd? > Is the alignment of subtotals and totals perfect in your amended > eguile report? How should it look if there are deeper levels of > subaccounts? > For html export, open the report tab, then File>Export>Export Report. > I believe the standard balsheet can be refined but this will take some > time. > C > > On 18 June 2018 at 00:32, Stephen M. Butler <mailto:kg...@arrl.net>> wrote: > > Interesting on the age. I thought I'd downloaded the most recent > Linux > install. But, my version is 2.6.19 built from rev c1b5e6c8d+ on > 2018-04-09. May be best to wait for the next release due out > early next > week and see how those reports look. > > In the interim, attached are: > 1. GVE.gnucash -- my current set of books for an apartment > building I'm > selling > 2. Balance Sheet - standard.pdf -- Standard Balance Sheet report > (unformatted) > 3. Balance Sheet - formatted.pdf -- Eguile balance sheet after my > changes were applied > (Wife still has problems but willing to work with this. > Specifically, the "Profit/Loss" line should be part of Equities and be > added just after Retained earnings. She thinks I should have just one > line of retained earnings rather than the yearly line I created when > closing the books each year -- I'll have to clean up my chart of > accounts to accomplish that -- sigh!) Plus, I have top level accounts > with the five major names (Assets, Liabilities, Equities -- maybe > should > rename to Capital, Income and Expense). So the report does look funny > with the section titles repeated due to my top level accounts. > > I was going to include the eguile version -- but it no longer wants to > link in when I put that code back in place. Wish I truly > understood how > that linkage works. Doesn't seem to function as documented -- at > least > as to how I read/understood the document! But, since eguile is going > away, that probably doesn't matter. > > Also, is there a way to dump the html version of the reports. I think > that is what you wanted but I've only figured out how to capture > the pdf > version to a file rather than letting it print. Seems strange as I do > have 20 years on Unix type systems -- but mostly as an Oracle DBA and > didn't delve deep into the O/S. Even my korn shell scripting ability > has atrophied in the past year. > > I need to head out and attempt to destroy some bamboo that the > previous > owner let escape. Plus put in the column bases for the greenhouse the > wife wants for her orchids. Isn't retirement fun! How did I ever > have > time to make the daily trip to downtown Seattle for a living? > > --Steve > > > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com <mailto:stephen.m.butle...@gmail.com> > kg...@arrl.net <mailto:kg...@arrl.net> > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > On 06/15/2018 09:06 PM, Christopher Lam wrote: > > Thanks; this is from an old version of eguile balsheet which is > > already obsolete in 3.X onwards, and I know it'll be more > difficult to > > fix as time goes by. There are already changes from timepair to > > time64, compulsory CSS, removal of slots access... There is no > active > > eguile maintainer anymore, and I really cannot understand eguile. > > > > Would you be kind to comment upon the HTML output (File > Export > > > Export Report) of the standard (non-eguile) balsheet, with desired > > amendments? I can try to amend with backward compatibility. > > > > For bonus points, if you have a sample datafile with accounts and > > transactions that highlight the various functionality of balsheet > > (e.g. income/expense, equity, any foreign currency conversions or > > stock purchases - I'm sure the wife will have them in her textbooks) > > I'm sure I can fix the standard balsheet to
[GNC] Report updates
What is the general policy on changes to reports? Create a new one with a new name or update the existing one? My wife is an accountant and she liked the formatting of the Balance Sheet eguile over the standard Balance Sheet report. But she felt it was too busy with the totals and sub-totals being annotated and was horrified to find the Income Statement buried inside. So, I have hacked the code to enhance those two items. As way of introduction, as I am new to this list. I stated my I.T. life as a COBOL developer for the first two decades (along with some hardware specific other languages). Then spent a decade as an Oracle DBA with the final decade as an I.T. Development Manager with a couple of development teams and a DBA in my group. No, I don't know C or C++ nor the language I hacked on while "fixing" the balance sheet (eguile) report. Nor have I used GIT. Yes, I am retired (spent the last 12 months no touching any code whatsoever) and I am open to being led by the hand if a developer would be so kind as to guide this over-the-hill-old-dog! And yes, I plan to hack the eguile version of the Balance Sheet to create a more nicely formatted Income Statement. So, again, is policy to update the existing or create a new option on the report list? [My personal vote is to keep the list of options low and update existing -- but that's my background in software development]. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Report updates
Aha! Thank you. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/14/2018 11:54 AM, John Ralls wrote: > >> On Jun 14, 2018, at 11:24 AM, Stephen M. Butler wrote: >> >> What is the general policy on changes to reports? Create a new one with >> a new name or update the existing one? >> >> My wife is an accountant and she liked the formatting of the Balance >> Sheet eguile over the standard Balance Sheet report. But she felt it >> was too busy with the totals and sub-totals being annotated and was >> horrified to find the Income Statement buried inside. So, I have hacked >> the code to enhance those two items. >> >> As way of introduction, as I am new to this list. I stated my I.T. life >> as a COBOL developer for the first two decades (along with some hardware >> specific other languages). Then spent a decade as an Oracle DBA with >> the final decade as an I.T. Development Manager with a couple of >> development teams and a DBA in my group. No, I don't know C or C++ nor >> the language I hacked on while "fixing" the balance sheet (eguile) >> report. Nor have I used GIT. >> >> Yes, I am retired (spent the last 12 months no touching any code >> whatsoever) and I am open to being led by the hand if a developer would >> be so kind as to guide this over-the-hill-old-dog! >> >> And yes, I plan to hack the eguile version of the Balance Sheet to >> create a more nicely formatted Income Statement. So, again, is policy >> to update the existing or create a new option on the report list? [My >> personal vote is to keep the list of options low and update existing -- >> but that's my background in software development]. > We're actually working on removing eguile support in favor of proper CSS > stylesheets. That will make it easier to style reports to the user's liking > but will not affect the contents of the report at all. > That doesn't stop you from making an eguile Income Statement report for your > wife's use, just advises that you should be aware that a future version of > GnuCash will break it completely, at which point you'll have to fall back on > the regular income statement report--but if styling is the concern it will be > much easier. > > See https://wiki.gnucash.org/wiki/Custom_Reports; there's a somewhat dated > Eguile page linked off of that. > The direct answer to your question is that you should make a new report, with > a new GUID, and install it in your config directory (see > https://wiki.gnucash.org/wiki/Configuration_Locations). That way upgrading > GnuCash won't disturb your customizations. > > 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] New report
Yes. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/14/2018 03:45 PM, Derek Atkins wrote: > Did you change the report GUID as well as the name? > > -derek > Sent using my mobile device. Please excuse any typos. > On June 14, 2018 6:20:01 PM "Stephen M. Butler" wrote: > >> I modified /usr/share/gnucash/scm/gnucash/report/balsheet-eq.scm (and >> related files) and gave them a new name of balsheet-fmtd.scm (etc). >> >> However, when I fire up GnuCash, the new report does not appear. This >> seems to be consistent with the documentation shared with me earlier >> today. However, I haven't figured out how the original file gets loaded >> and made available. >> >> When I place my modified version into the old file name, the changes >> show up and work just fine. When I put the original back and put a copy >> of my new file into the standard-reports sub-directory, GnuCash dies >> while loading. >> >> 1. How does balsheet-eq.scm in the reports directory get loaded? >> >> 2. What did I do wrong such that the new file works when placed into >> the old file name but fails when put into standard-reports >> sub-directory? >> >> Old-Files New Files >> balsheet-eg.ccs stylesheet-reports.css (left in reports >> directory) >> balsheet-eg.scm balsheet-fmtd.scm >> balsheet-eg.eguile.scm balsheet-fmtd.eguile.scm (left in reports >> directory) >> >> I also tried copying all three of the new files to the standard-reports >> sub-directory and GnuCash still dies while loading. >> >> -- >> Stephen M Butler, PMP, PSM >> stephen.m.butle...@gmail.com >> kg...@arrl.net >> 253-350-0166 >> --- >> GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 >> >> ___ >> 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] New report
Here are the changes I made: 1. Removed the "Total" and "Total " notations. It is obvious from their position that they are totals and the verbiage clutters the report. 2. We don't use trading accounts and that just bothered her sense of the fundamental form of the report. I removed that section. Perhaps you can figure out how to suppress that output if there are no such accounts. 3. Having the income/expense report violated the purpose of the Balance Sheet. So I suppressed that print out and kept the "Profit/Loss" total to add into the Liabilities and Capital side. 4. The P total wasn't included with the LC section. So the report was out of balance by that amount. 5. She does want an Income statement that has this same type of formatting. So I broke the Income and Expense tables into two sections (but still suppressed the output) as preparation for replicating the code for a nicely formatted Income Statement report -- if I can figure out how to add a new report into the system. 6. One thing I noticed but haven't decided how to correct -- we have top level accounts name "Assets", "Equity", "Liability", "Income", and "Expense". I suspect I should really remove those and promote the lower accounts up one level to make them top level accounts of those particular types. However, it might be useful for the report to detect this condition and either use those account names for the section titles are suppress printing those top level placeholder accounts. Here is a diff of the relevant files in the reports directory: -- I will email you direct the two files with changes so you won't have to reverse the diff statements! root@stevelaptop:/usr/share/gnucash/scm/gnucash/report# diff balsheet-eg.css stylesheet-reports.css note that there were no changes -- just a file name change in anticipation of using it also for the income/expense statement root@stevelaptop:/usr/share/gnucash/scm/gnucash/report# diff balsheet-eg.scm balsheet-fmtd.scm 1a2,5 > ;; balsheet-fmtd.scm > ;; by Steve Butler stephen.m.butle...@gmail.com > ;; modified from: > ;; 34c38 < (define-module (gnucash report balsheet-eg)) --- > (define-module (gnucash report balsheet-fmtd)) 249c253 < (define reportname (_ "Balance Sheet (eguile)")) --- > (define reportname (_ "Balance Sheet:")) 354c358 < opthelp-template-file "balsheet-eg.eguile.scm")) --- > opthelp-template-file "balsheet-fmtd.eguile.scm")) 356c360 < opthelp-css-file "balsheet-eg.css")) --- > opthelp-css-file "stylesheet-reports.css")) 366c370 < (N_ "(Development version -- don't rely on the numbers on this report without double-checking them.Change the 'Extra Notes' option to get rid of this message)"))) --- > (N_ ""))) 427,431c431,434 < (trading-accounts < (assoc-ref split-up-accounts ACCT-TYPE-TRADING)) < (income-expense-accounts < (append (assoc-ref split-up-accounts ACCT-TYPE-INCOME) < (assoc-ref split-up-accounts ACCT-TYPE-EXPENSE))) --- > (income-accounts > (assoc-ref split-up-accounts ACCT-TYPE-INCOME)) > (expense-accounts > (assoc-ref split-up-accounts ACCT-TYPE-EXPENSE)) 678c681 < (gnc:debug "balsheet-eg.scm - generated html:") (gnc:debug html) --- > (gnc:debug "balsheet-fmtd.scm - generated html:") (gnc:debug html) 691,693c694,696 < 'report-guid "2e3751edeb7544e8a20fd19e9d08bb65" < 'menu-name (N_ "Balance Sheet using eguile-gnc") < 'menu-tip (N_ "Display a balance sheet (using eguile template)") --- > 'report-guid "e5cff0c5e1c54213899ff7f98bc9e2d7" > 'menu-name (N_ "Balance Sheet nicely formatted") > 'menu-tip (N_ "Display a formatted balance sheet") Some of the changes in this next module are simply ordering of statements so I could figure out why the report totals were not correct. root@stevelaptop:/usr/share/gnucash/scm/gnucash/report# diff balsheet-eg.eguile.scm balsheet-fmtd.eguile.scm 3a4,7 > ;; balsheet-fmtd.eguile.scm > ;; by Steve Butler stephen.m.butle...@gmail.com > ;; modified version: > ;; 8c12 < ;; balsheet-eg.scm via the eguile mechanism. --- > ;; balsheet-eg.scm via the eguile mechanism. -- modified to be balsheet-fmtd.scm 120c124 < (string-append (_ "Total") " " (accrec-namelink accrec)) --- > (string-append " " ) 168,169c172,173 < (accrec-tr (process-acc-list trading-accounts #t)) < (accrec-ie (process-acc-list income-expense-accounts #t)) --- > (accrec-in (process-acc-list income-accounts #t)) > (accrec-ex (process-acc-list expense-accounts #t)) 174,175c178,179 < (rshift-tr 0) < (rshift-ie 0) --- > (rshift-in 0) > (rshift-ex 0) 177,178c181,183 < (etl-cc
[GNC] New report
I modified /usr/share/gnucash/scm/gnucash/report/balsheet-eq.scm (and related files) and gave them a new name of balsheet-fmtd.scm (etc). However, when I fire up GnuCash, the new report does not appear. This seems to be consistent with the documentation shared with me earlier today. However, I haven't figured out how the original file gets loaded and made available. When I place my modified version into the old file name, the changes show up and work just fine. When I put the original back and put a copy of my new file into the standard-reports sub-directory, GnuCash dies while loading. 1. How does balsheet-eq.scm in the reports directory get loaded? 2. What did I do wrong such that the new file works when placed into the old file name but fails when put into standard-reports sub-directory? Old-Files New Files balsheet-eg.ccs stylesheet-reports.css (left in reports directory) balsheet-eg.scm balsheet-fmtd.scm balsheet-eg.eguile.scm balsheet-fmtd.eguile.scm (left in reports directory) I also tried copying all three of the new files to the standard-reports sub-directory and GnuCash still dies while loading. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 3.2 Released
On 06/29/2018 11:02 AM, Geert Janssens wrote: > Op vrijdag 29 juni 2018 19:54:04 CEST schreef Stephen M. Butler: >> On 06/29/2018 12:42 AM, Geert Janssens wrote: >>> Op maandag 25 juni 2018 19:42:37 CEST schreef Stephen M. Butler: >>>> Further research: >>>> >>>> It appears that net-charts.scm is a replacement for two other files in >>>> standard-reports: net-linecharts.scm and net-barcharts.scm >>>> >>>> I renamed those two to have a .old extension on them and GnuCash now >>>> starts up without complaining about duplicate report IDs. >>> Ah indeed. As you indicated you didn't uninstall first, the old files >>> remained in the installation directory causing the conflict. >> Hopefully I remember for the next upgrade. >> >>> The formal way to uninstall is a bit picky. You should run "make >>> uninstall" in your build directory *before* changing the source directory >>> to a newer version (be it a new git checkout or pull, or installing a new >>> release tar ball). >>> >>> If you installed gnucash in it's own prefix (by adding >>> -DCMAKE_INSTALL_PREFIX=xyz to your cmake run), uninstalling would be as >>> easy as deleting this prefix. >>> >>> But in this case manually removing/renaming the offending files works as >>> well. I would remove/rename the corresponding .go files in gnucash' >>> lib64/gnucash/ scm/ccache/ directory as well though. >> Hmm. Can't find that path. Here is what is in /lib64 on my Ubuntu >> 18.04 box: > Oh, right. I believe debian and derivates use a different scheme for 64-bit > applications > > Do you have > /usr/lib/x86_64-linux-gnu/gnucash/scm/ccache ? > > Geert > > Not that I see -- I am using a 64-bit O/S so maybe 32 bit apps are the odd member here? I did find them here though: /usr/local/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports Occasionally find can be useful! sudo find / -name net-barchart.go /usr/local/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/net-barchart.go I removed both. ___ 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] Upgrading GC under Ubuntu
On 06/29/2018 11:45 AM, John R. Sowden wrote: > It seems that GC is a very popular accounting program, and > Ubuntu/Linux is a very popular Operating System, yet when there is an > upgrade in GC, I cannot find a straightforward method of updating GC > under Ubuntu/Linux. > > I understand that there is a delay before the new version of GC is in > the Ubuntu Software download system. That is internal to Ubuntu. But > there are alternatives, such as an alternative repository and self > compiling. Oh yes, what about pre-compiled binaries like Windows and > Mac? > > Each could have clear concise instructions on how to perform the task. > > One could direct the user with specific commands to go th the > repository that gets the upgrade first. > > A script could be written and published with copious comments, testing > for dependencies, loading them, doing a security check of the > downloaded files, compiling and testing. > > Google has not turned out to be my friend, otherwise I would not be > writing this. There are articles years old, no install scripts, no > suggestions of repositories with instructions. > > Feel free to prove me wrong, I have spent a couple of hours searching > with many selected key words, > > John > Having just done a download and compile to my Ubuntu 18.04, let me share with you what I did. Sometimes reading the web sites leaves one (at least me) scratching their head vigorously -- in my case not a good idea with the hair I have left! 1. Read this page: https://wiki.gnucash.org/wiki/BuildUbuntu16.04 It works for 18.04 also. You didn't say which version of Ubuntu so I am presuming either 16.04 or 18.04 You may need to install a bunch of libraries. I found that a couple or more were already on my box. My box had some old libraries hanging around that I had to manually remove in /usr/src: sudo rm -rf /usr/src/gtest /usr/src/gmock See this note: https://larry-price.com/blog/2013/10/13/installing-gtest-and-gmock-libs-in-ubuntu-13-dot-04/ But don't worry. Just remove the above two entries (if they exist) and the install of googletest and googlemock will work. I ended up uninstalling the two packages on my way to figuring out what had happened. sudo apt-get install build-essential sudo apt-get install cmake sudo apt-get install libtool libltdl-dev sudo apt-get install libglib2.0 libglib2.0-dev #glib2 > v2.40.0 sudo apt-get install icu-devtools libicu-dev sudo apt-get install libboost-all-dev# boost > 1.50.0 - requires locale and regex built with ICU support sudo apt-get install guile-2.0 guile-2.0-dev # guile >=2.0.0 sudo apt-get install swig3.0 # swig >2.0.10 *(swig3.0 on Ubuntu18.04)* not required if building from tarball, sudo apt-get install googletest sudo apt-get install googlemock sudo apt-get install libgtest-dev # but from any version control system sudo apt-get install libxml2 libxml++2.6-dev sudo apt-get install libxslt1.1 libxslt1-dev sudo apt-get install xsltproc sudo apt-get install texinfo # required for makeinfo sudo apt-get install gtk+3.0 sudo apt-get install libgtk-3-dev sudo apt-get install libwebkit2gtk-4.0-37# > webkit2gtk-3.0 sudo apt-get install libwebkit2gtk-4.0-dev sudo apt-get install libdbi1 libdbi-dev # > v0.8.3 # one of the following three if you want a database backend option: sudo apt-get install libdbd-pgsql# PostgreSQL database sudo apt-get install libdbd-mysql# MySQL database sudo apt-get install libdbd-sqlite3 # Sqlite database sudo apt-get install libofx-dev sudo apt-get install aqbanking-tools libaqbanking-dev # > v4.0.0 sudo apt-get install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev sudo apt-get install ktoblzcheck libktoblzcheck1-dev sudo apt-get install python3-pytest As noted above, my box had many of these already so apt-get skipped the install for them and told me I already had the latest. 2. Download this source code from: https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/3.2/gnucash-3.2.tar.gz/download 3. Move the file to where you want to house your source: I made mine $HOME/Projects/GnuCash. mkdir -p $HOME/Projects/GnuCash cd Downloads mv gnucash* $HOME/Projects/GnuCash 4. Go there and build your source and build folders cd ../Projects/GnuCash gunzip gnucash* tar -xf gnucash* mkdir mybuild cd mybuild 5. Compile and install cmake ../gnucash* make sudo make install I'll admit that I made several mis-steps along the way and needed help from the great folks here. Hopefully this will get you going. Oh, uninstall gnucash first if you already have a version. I failed to do that and had to remove s
Re: [GNC] GnuCash 3.2 Released
On 06/29/2018 12:42 AM, Geert Janssens wrote: > Op maandag 25 juni 2018 19:42:37 CEST schreef Stephen M. Butler: >> Further research: >> >> It appears that net-charts.scm is a replacement for two other files in >> standard-reports: net-linecharts.scm and net-barcharts.scm >> >> I renamed those two to have a .old extension on them and GnuCash now >> starts up without complaining about duplicate report IDs. >> > Ah indeed. As you indicated you didn't uninstall first, the old files > remained > in the installation directory causing the conflict. Hopefully I remember for the next upgrade. > The formal way to uninstall is a bit picky. You should run "make uninstall" > in > your build directory *before* changing the source directory to a newer > version > (be it a new git checkout or pull, or installing a new release tar ball). > > If you installed gnucash in it's own prefix (by adding > -DCMAKE_INSTALL_PREFIX=xyz to your cmake run), uninstalling would be as easy > as deleting this prefix. > > But in this case manually removing/renaming the offending files works as > well. > I would remove/rename the corresponding .go files in gnucash' lib64/gnucash/ > scm/ccache/ directory as well though. Hmm. Can't find that path. Here is what is in /lib64 on my Ubuntu 18.04 box: drwxr-xr-x 2 root root 4096 May 6 20:28 ./ drwxr-xr-x 26 root root 4096 Jun 12 10:04 ../ lrwxrwxrwx 1 root root 32 Apr 16 13:14 ld-linux-x86-64.so.2 -> /lib/x86_64-linux-gnu/ld-2.27.so* lrwxrwxrwx 1 root root 20 May 6 20:28 ld-lsb-x86-64.so.2 -> ld-linux-x86-64.so.2* lrwxrwxrwx 1 root root 20 May 6 20:28 ld-lsb-x86-64.so.3 -> ld-linux-x86-64.so.2* And here is the location of all lib64 directories (via sudo find / -name lib64 /usr/src/linux-headers-3.19.0-28/arch/sh/lib64 /usr/src/linux-headers-3.19.0-26/arch/sh/lib64 /usr/src/linux-headers-3.19.0-25/arch/sh/lib64 /usr/src/linux-headers-4.15.0-23/arch/sh/lib64 /usr/src/linux-headers-3.19.0-29/arch/sh/lib64 /usr/src/linux-headers-4.15.0-22/arch/sh/lib64 /usr/src/linux-headers-3.19.0-27/arch/sh/lib64 /usr/src/linux-headers-3.19.0-23/arch/sh/lib64 /usr/src/linux-headers-3.19.0-24/arch/sh/lib64 /usr/src/linux-headers-3.16.0-32/arch/sh/lib64 /lib64 /var/tmp/mkinitramfs_pYKPbh/lib64 /var/tmp/mkinitramfs_edihqS/lib64 /var/tmp/mkinitramfs_JevWJj/lib64 /var/tmp/mkinitramfs_dZ5Hy3/lib64 /var/tmp/mkinitramfs_2s7hMA/lib64 /var/tmp/mkinitramfs_ncQdoR/lib64 /var/tmp/mkinitramfs_fF6uQ0/lib64 /var/tmp/mkinitramfs_pWngoT/lib64 /var/tmp/mkinitramfs_gE5Jr7/lib64 /var/tmp/mkinitramfs_9spxCx/lib64 /var/tmp/mkinitramfs_Qr12to/lib64 /var/tmp/mkinitramfs_FJaQ9o/lib64 /snap/core/4830/lib64 /snap/core/4571/lib64 /snap/core/4650/lib64 /opt/wine-devel/lib64 /opt/sophos-av/lib64 /opt/sophos-av/update/cache/Primary/sav-linux/x86/64/lib64 /opt/epson-inkjet-printer-201208w/lib64 > Geert > > Thanks, -- 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.
Re: [GNC] GnuCash 3.2 Released
On 06/29/2018 02:17 PM, Geert Janssens wrote: > Op vrijdag 29 juni 2018 21:04:31 CEST schreef Stephen M. Butler: >> On 06/29/2018 11:02 AM, Geert Janssens wrote: >>> Op vrijdag 29 juni 2018 19:54:04 CEST schreef Stephen M. Butler: >>>> On 06/29/2018 12:42 AM, Geert Janssens wrote: >>>>> Op maandag 25 juni 2018 19:42:37 CEST schreef Stephen M. Butler: >>>>>> Further research: >>>>>> >>>>>> It appears that net-charts.scm is a replacement for two other files in >>>>>> standard-reports: net-linecharts.scm and net-barcharts.scm >>>>>> >>>>>> I renamed those two to have a .old extension on them and GnuCash now >>>>>> starts up without complaining about duplicate report IDs. >>>>> Ah indeed. As you indicated you didn't uninstall first, the old files >>>>> remained in the installation directory causing the conflict. >>>> Hopefully I remember for the next upgrade. >>>> >>>>> The formal way to uninstall is a bit picky. You should run "make >>>>> uninstall" in your build directory *before* changing the source >>>>> directory >>>>> to a newer version (be it a new git checkout or pull, or installing a >>>>> new >>>>> release tar ball). >>>>> >>>>> If you installed gnucash in it's own prefix (by adding >>>>> -DCMAKE_INSTALL_PREFIX=xyz to your cmake run), uninstalling would be as >>>>> easy as deleting this prefix. >>>>> >>>>> But in this case manually removing/renaming the offending files works as >>>>> well. I would remove/rename the corresponding .go files in gnucash' >>>>> lib64/gnucash/ scm/ccache/ directory as well though. >>>> Hmm. Can't find that path. Here is what is in /lib64 on my Ubuntu >>>> 18.04 box: >>> Oh, right. I believe debian and derivates use a different scheme for >>> 64-bit >>> applications >>> >>> Do you have >>> /usr/lib/x86_64-linux-gnu/gnucash/scm/ccache ? >>> >>> Geert >> Not that I see -- I am using a 64-bit O/S so maybe 32 bit apps are the >> odd member here? >> >> I did find them here though: >> /usr/local/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports >> Occasionally find can be useful! >> >> sudo find / -name net-barchart.go >> /usr/local/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/net-ba >> rchart.go >> >> I removed both. > Ah, indeed. If you don't specify a prefix, cmake will use /usr/local. Sorry > for sending you around on different wrong paths. > > Geert > > > > No problem. Forces me to figure out what _is_ happening. At least you told me about the .go files. ___ 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 on 18.04
On 07/01/2018 09:36 AM, Roger Miskowicz wrote: > I have GC3.2 on two 16.04 linux systems and in one build I have > install_manifest.txt which includes the 'icons' directory and in the other > the install_manifest.txt does not exist (in this one the icons files were > installed months earlier so not part of my latest install). > > > I just rebuilt GC3.2 on 16.04 using: > > mkdir build > cd build > > cmake -D WITH_AQBANKING=OFF -D WITH_OFX=OFF ../gnucash > cmake .. > > make > > and the install_manifest.txt include the 'icons' directory. > > > Hope this helps, let me know if you would like to try something else. > > Roger I am on Ubuntu 18.04 and build 3.2 from the tar.gz download. I looked in my source and build directories and found: ./GnuCash/gnucash-3.1/data/pixmaps/hicolor/16x16/actions/gnc-account-report.png ./GnuCash/gnucash-3.1/data/pixmaps/hicolor/24x24/actions/gnc-account-report.png ./GnuCash/mybuild/share/gnucash/icons/hicolor/16x16/actions/gnc-account-report.png ./GnuCash/mybuild/share/gnucash/icons/hicolor/24x24/actions/gnc-account-report.png/usr/local/share/gnucash/icons ./GnuCash/gnucash-3.2/data/pixmaps/hicolor/16x16/actions/gnc-account-report.png ./GnuCash/gnucash-3.2/data/pixmaps/hicolor/24x24/actions/gnc-account-report.png My "mybuild" directory was cleaned before building 3.2 as I shared it with 3.1. From my ./GnuCash folder: cd mybuild cmake ../gnucash-3.2 make sudo make install The icons in the mybuild folder were copied to /usr/local/share/gnucash/icons > > On Sun, Jul 1, 2018 at 11:52 AM, Colin Law wrote: > >> On 1 July 2018 at 16:36, Roger Miskowicz wrote: >> >>> in 16.04 and GC3.2 using: >>> >>> $ locate gnc-account-report >>> /usr/local/share/gnucash/icons >>> I found: >>> >>> /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc- >>> account-report.png >>> /usr/local/share/gnucash/icons/hicolor/24x24/actions/gnc- >>> account-report.png >>> >>> Are these files found in 18.04? >>> >> No, in /usr/local/share/gnucash there is no icons folder. I have >> accounts gtkbuilder make-prefs-migration-script.xsl pixmaps >> tip_of_the_day.list >> checksjqplot migratable-prefs.xml scm ui >> >> The only png file is pixmaps/gnucash_splash.png >> >> There is no reference to /usr/local/share/gnucash/icons in the output of >> sudo make install. >> >> Colin >> >> Colin >> /usr/local/share/gnucash/icons >> >>> On Sun, Jul 1, 2018 at 10:55 AM, Colin Law wrote: >>> In the trace file I see around a dozen lines similar to * 13:29:29 WARN [gnc_load_app_icons()] No icon named 'gnc-account' found. Some gui elements may be missing their icons * 13:29:29 WARN [gnc_load_app_icons()] No icon named 'gnc-account-report' found. Some gui elements may be missing their icons Colin On 1 July 2018 at 13:39, Colin Law wrote: > Actually I see there are more icons missing, such as the Split button icon > in the toolbar. It seems that the missing files are the png files from > data/pixmaps/hicolor/?/actions. Are these supposed to be copied > somewhere by make install? > > Colin > > On 1 July 2018 at 11:21, Colin Law wrote: > >> Following the instructions for building GC 3.x on the wiki [1] has >> been accomplished on Ubuntu 18.04 with little difficulty, so many >> thanks to the contributors to the wiki. >> >> Just one small issue so far, the icons to the left of the account >> names are all showing as a little no entry sign, which I guess means >> the icon is missing. Does that mean I have missed something or is >> something missing from the build? >> >> Colin >> >> >> [1] https://wiki.gnucash.org/wiki/BuildUbuntu16.04 >> ___ 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 on 18.04
On 07/01/2018 10:33 AM, Colin Law wrote: > I have just rebuilt (on 18.04) using the exact same commands and my > manifest does not include the icons. Do you know what is supposed to tell > the system to install them? > > Colin Is it possible that it detected them in the install directory during the cmake step so it didn't think it needed to re-install them? > > On 1 July 2018 at 17:36, Roger Miskowicz wrote: > >> I have GC3.2 on two 16.04 linux systems and in one build I have >> install_manifest.txt which includes the 'icons' directory and in the other >> the install_manifest.txt does not exist (in this one the icons files were >> installed months earlier so not part of my latest install). >> >> >> I just rebuilt GC3.2 on 16.04 using: >> >> mkdir build >> cd build >> >> cmake -D WITH_AQBANKING=OFF -D WITH_OFX=OFF ../gnucash >> cmake .. >> >> make >> >> and the install_manifest.txt include the 'icons' directory. >> >> >> Hope this helps, let me know if you would like to try something else. >> >> Roger >> >> >> On Sun, Jul 1, 2018 at 11:52 AM, Colin Law wrote: >> >>> On 1 July 2018 at 16:36, Roger Miskowicz wrote: >>> in 16.04 and GC3.2 using: $ locate gnc-account-report I found: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-acc ount-report.png /usr/local/share/gnucash/icons/hicolor/24x24/actions/gnc-acc ount-report.png Are these files found in 18.04? >>> No, in /usr/local/share/gnucash there is no icons folder. I have >>> accounts gtkbuilder make-prefs-migration-script.xsl pixmaps >>> tip_of_the_day.list >>> checksjqplot migratable-prefs.xml scm ui >>> >>> The only png file is pixmaps/gnucash_splash.png >>> >>> There is no reference to /usr/local/share/gnucash/icons in the output of >>> sudo make install. >>> >>> Colin >>> >>> Colin >>> >>> On Sun, Jul 1, 2018 at 10:55 AM, Colin Law wrote: > In the trace file I see around a dozen lines similar to > > * 13:29:29 WARN [gnc_load_app_icons()] No icon named > 'gnc-account' found. Some gui elements may be missing their icons > * 13:29:29 WARN [gnc_load_app_icons()] No icon named > 'gnc-account-report' found. Some gui elements may be missing their icons > > Colin > > > On 1 July 2018 at 13:39, Colin Law wrote: > >> Actually I see there are more icons missing, such as the Split button > icon >> in the toolbar. It seems that the missing files are the png files > from >> data/pixmaps/hicolor/?/actions. Are these supposed to be copied >> somewhere by make install? >> >> Colin >> >> On 1 July 2018 at 11:21, Colin Law wrote: >> >>> Following the instructions for building GC 3.x on the wiki [1] has >>> been accomplished on Ubuntu 18.04 with little difficulty, so many >>> thanks to the contributors to the wiki. >>> >>> Just one small issue so far, the icons to the left of the account >>> names are all showing as a little no entry sign, which I guess means >>> the icon is missing. Does that mean I have missed something or is >>> something missing from the build? >>> >>> Colin >>> >>> >>> [1] https://wiki.gnucash.org/wiki/BuildUbuntu16.04 >>> >> > ___ > 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] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)
On 07/01/2018 06:05 PM, Christopher Lam wrote: > Discussions are useful; but would anyone have an idealised template, or > sample output that the balance sheet should produce? Idealy with the > 'account-has-children-and-amounts' peculiarity? > The balsheet in development will, ideally, replace the current (non-eguile) > one. > The existing one has amounts in the wrong columns, inflexible accountnames, > no multiple date points reporting, no linkage with other reports. > C Say the broker account has some activity (cash- $200) and also has Stock of $250 and Bonds of $150. Assets y Broker $200 Stock $250 Bonds $150 -- $600 xx > > On 2 July 2018 at 03:18, Christian Kluge wrote: > >> Am 01.07.2018 um 01:57 schrieb DaveC49: >>> Stephen John, Geert >>> >>> In accounting terms there are really only 3 basic account types: >>> Asset >>> Liability >>> Equity >>> >>> These all *must *satisfy the basic accounting equation Assets=Liabilities >>> +Equity. >>> >>> The two sides of this equation are what the German /European system >> defines >>> as Activa and Passiva but these groupings are primarily reporting >>> requirements not account heirarchy. Is there really a need to have an >>> additional placeholder category as the reporting grouping can be readily >>> defined from the existing basic account heirarchy structure? >>> >> In the German system active and passive are seen as the fundamental >> account types. In the end it leads to the same result, but I get your >> point of view. >> >> Hovever I would suggest make changes to the balance sheet report to be >> able to produce European reports. >> >> Regards, >> >> >> Christian Kluge >> >> ___ >> 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. > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Fwd: The two modules
On 06/25/2018 01:51 AM, DaveC49 wrote: > Stephen, > > You can possibly force the case of sum of the children account totals being > the parent account total by making the parent a placeholder account. Then > it cannot have any transactions into it, only the child accounts. > > David Cousens > > From a pure accounting perspective, that would be best. However, what should the report do/look like when the user isn't so astute? ___ 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] New Balsheet (and P report)
Have you read https://www.mscs.dal.ca/~selinger/accounting/tutorial.html and the companion https://www.mscs.dal.ca/~selinger/accounting/gnucash.html? I finished both last night and am working through chapter 12 of the current guide. I think it is an accounting setup issue more than a reporting issue. And our sample company is setup wrong based on what I read. On 06/25/2018 09:03 PM, Christopher Lam wrote: > Hi Stephen > > Thank you for valuable feedback... all these issues are cosmetic / > account selection, and are relatively trivial except that > Placeholder accounts can also contain transactions therefore must not > necessarily accumulate their children account amounts. > > My major concern relates to switching amounts to a so-called "Report > Currency". But IMO this leads to balance sheets to being confused with > 'stock valuation' > > The existing balance sheet offers weighted-average, average-cost, > nearest, latest. AFAIU weighted-average and average-cost obtains > prices from the actual transactions; nearest means 'use price nearest > to report-date', and latest means 'use today's nearest price' > > Let's say I bought: > 100 AAPL at $10 in 2006, and > 50 AAPL at $20 in 2009; and > AAPL was $110 in 2015 > AAPL is about $180 in 2018 > > I'm wanting stock valuation in 2015. > - original currency - shows 150 AAPL, no price conversion (i.e. simplest) > - cost price - 100x$10 + 50x$20 = $2000 (labour intensive because each > stock transaction must be analysed, and converted using any available > price entry to the report currency) > - nearest - 150x$110 = $16,500 (simple) > - latest - 150x$180 = $27,000 (also simple) > > Please check latest showing balsheet multicolumn amounts converted to > report currency; although they're esthetically nice, this has > increased the level of complexity a magnitude a tad too high... (I > wouldn't know how/if income/expense amounts can/must be subject to > price conversion...) > > I'd be keen to remove price conversion to report currency myself... > > > On 26 June 2018 at 03:34, Stephen M. Butler <mailto:kg...@arrl.net>> wrote: > > Christopher, > > I am attaching the three balance sheet reports available from > within GNC > for both our test company and for my apartment building. Of the > three, > the accountant likes the layout and totals of the eguile version > the best. > > Her specific comments regarding the Multicolumn (pnl) are: > > 1. Not unheard of to compare this year-to-date with last year-ti-date > on a balance sheet (and income/expense) report. Less likely to be > beginning period/end period. Most generally only done for last report > of the year (to compare back to prior year). She prefers the single > point-in-time version for personal and small company finances. > > 2. Placeholder accounts should not show $0.00. Their true value > is the > total for their level. > > 3. The dates should not be repeated for each section of the report. > Once at the top is enough. > > 4. Equity is the same as Net Worth. Its total should include: > a. Equity account totals > b. Trading account totals (if there are no trading accounts, > suppress that portion) > c. Period to date Profit/Loss which should match the (Income - > Expense) from the Income Statement. > > 5. Assets = Liabilities + Equity and the total of Liabilities and > Equity should be shown and match the total of Assets. > > 6. Put in the column underlines for the totals as is done on the > eguile > version. Then you can remove the "Total for XXX" labels as it will be > obvious it is a total. > > > Now, for our test company, I think we have a problem with the GPB > valuations. We haven't done any bookkeeping with multiple > currencies. > So will need input from somebody else. > > > > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com <mailto:stephen.m.butle...@gmail.com> > kg...@arrl.net <mailto:kg...@arrl.net> > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > On 06/25/2018 06:56 AM, Christopher Lam wrote: > > Seeking beta testers. > > > > > https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl > <https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl> > > > > Or, anyone with v3.2 onwards can copy the file directly into the > > build's standard-reports folder: > >
Re: [GNC] GnuCash 3.2 Released
Further research: It appears that net-charts.scm is a replacement for two other files in standard-reports: net-linecharts.scm and net-barcharts.scm I renamed those two to have a .old extension on them and GnuCash now starts up without complaining about duplicate report IDs. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/25/2018 10:20 AM, Stephen M. Butler wrote: > Compiled and installed on Ubuntu 18.04. > > When starting up it reports several duplicate report IDs. Should I have > uninstalled 3.1 first? I did these commands (with an empty mybuild): > > cd mybuild > > cmake ../gnucash-3.2 > > make > > sudo make install > > > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > On 06/24/2018 08:40 PM, John Ralls wrote: >> The GnuCash development team announces GnuCash 3.2, the second release of >> the 3.x stable release series. >> >> Changes >> >> Between 3.0 and 3.2, the following bugfixes were accomplished: >> >> • Bug 787401 - Test Report System - Report Definition. >> • Bug 794617 - Can't compile with -DWITH_GNUCASH=NO due to >> scm-gnome-utils. >> • Bug 795101 - Scroll Bar in Reconcile Window Floats in and covers the >> check boxes. >> • Bug 795247 - datepicker broken in Persian. GnuCash passes dates as >> integer y/m/d without using locale-specific formats, so we need to strip out >> 'E' and 'O' from the format when scanning dates or determining separators in >> gnc-date. None of '-', 'E', or 'O' are supported by boost (and '-' causes >> errors), so strip them out from formatters in gnc-datetime as well. >> • Bug 795253 - Have problems input Chinese. >> • Bug 795272 - QIF importer causes application crash if action is >> invalid. >> • Bug 795276 - Invalid date on price stops file from being parsed. >> • Bug 795362 - Special variable "i" not parsed in function calls. Due >> to balance tests with insane random values. >> • Bug 795471 - Impossible to Edit Budget Unless Maximized. >> • Bug 795519 - Credit card payment after reconciliation. >> • Bug 795666 - Backslash '\' in Description field spoils CSV Import >> without helpful error message. >> • Bug 795831 - When read only threshold set, dates are silently >> changed. Display a message box informing the user of the change. >> • Bug 795944 - Cannot store change to Business Suppliers data. >> • Bug 796079 - Repeatable Crash in Tax Report Options. >> • Bug 796081 - Tax Schedule Report - An error occurred while running >> the report. >> • Bug 796083 - Reconcile Selection Doesn't Work Anymore. >> • Bug 796117 - Connecting 3.1 to an existing mysql db drops all data. >> Provide a backup recovery function that instead of dropping primaries and >> restoring backups merges the primaries and backups. This should handle a >> worst-case safe-save failure where the backup tables don't have a complete >> set of rows for some reason. >> • Bug 796256 - Main Window stays hidden when starting after closing >> main window while minimized. >> • Bug 796369 - Notes lost or perhaps just not displaying when using >> SQLite backend. This bug caused data loss if you saved your SQLite3 database >> to a different file or database. The problem is that in SQLite3 (though not >> in MySQL or PgSQL) the subquery ((SELECT DISTINCT guid FROM transactions)) >> (note the double parentheses) returns only the first guid in the subquery's >> results. Some transactions are loaded by special queries and those queries >> are also used to retrieve the transaction's slots so they weren't affected. >> • Bug 796398 - Restrict accelerator keys to valid date range. >> • Bug 796409 - Incorrect Current Value for Stocks. Missed calculating >> the value in the register summary bar. >> • Bug 796423 - Cannot Input Chinese, seems does not work with other IME >> too. Toggles not in view with all rows selected weren't being redrawn. >> • Bug 796484 - csv import: iostream error. Unfortunately it turns out >> that we can't use filestreams because they can't take path arguments >> containing Unicode on Windows. >> • Bug 796527 - invalid currency on scheduled transactions. >> • Don't even check for price/exchange rat
Re: [GNC] GnuCash 3.2 Released
Compiled and installed on Ubuntu 18.04. When starting up it reports several duplicate report IDs. Should I have uninstalled 3.1 first? I did these commands (with an empty mybuild): cd mybuild cmake ../gnucash-3.2 make sudo make install Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/24/2018 08:40 PM, John Ralls wrote: > The GnuCash development team announces GnuCash 3.2, the second release of the > 3.x stable release series. > > Changes > > Between 3.0 and 3.2, the following bugfixes were accomplished: > > • Bug 787401 - Test Report System - Report Definition. > • Bug 794617 - Can't compile with -DWITH_GNUCASH=NO due to > scm-gnome-utils. > • Bug 795101 - Scroll Bar in Reconcile Window Floats in and covers the > check boxes. > • Bug 795247 - datepicker broken in Persian. GnuCash passes dates as > integer y/m/d without using locale-specific formats, so we need to strip out > 'E' and 'O' from the format when scanning dates or determining separators in > gnc-date. None of '-', 'E', or 'O' are supported by boost (and '-' causes > errors), so strip them out from formatters in gnc-datetime as well. > • Bug 795253 - Have problems input Chinese. > • Bug 795272 - QIF importer causes application crash if action is > invalid. > • Bug 795276 - Invalid date on price stops file from being parsed. > • Bug 795362 - Special variable "i" not parsed in function calls. Due > to balance tests with insane random values. > • Bug 795471 - Impossible to Edit Budget Unless Maximized. > • Bug 795519 - Credit card payment after reconciliation. > • Bug 795666 - Backslash '\' in Description field spoils CSV Import > without helpful error message. > • Bug 795831 - When read only threshold set, dates are silently > changed. Display a message box informing the user of the change. > • Bug 795944 - Cannot store change to Business Suppliers data. > • Bug 796079 - Repeatable Crash in Tax Report Options. > • Bug 796081 - Tax Schedule Report - An error occurred while running > the report. > • Bug 796083 - Reconcile Selection Doesn't Work Anymore. > • Bug 796117 - Connecting 3.1 to an existing mysql db drops all data. > Provide a backup recovery function that instead of dropping primaries and > restoring backups merges the primaries and backups. This should handle a > worst-case safe-save failure where the backup tables don't have a complete > set of rows for some reason. > • Bug 796256 - Main Window stays hidden when starting after closing > main window while minimized. > • Bug 796369 - Notes lost or perhaps just not displaying when using > SQLite backend. This bug caused data loss if you saved your SQLite3 database > to a different file or database. The problem is that in SQLite3 (though not > in MySQL or PgSQL) the subquery ((SELECT DISTINCT guid FROM transactions)) > (note the double parentheses) returns only the first guid in the subquery's > results. Some transactions are loaded by special queries and those queries > are also used to retrieve the transaction's slots so they weren't affected. > • Bug 796398 - Restrict accelerator keys to valid date range. > • Bug 796409 - Incorrect Current Value for Stocks. Missed calculating > the value in the register summary bar. > • Bug 796423 - Cannot Input Chinese, seems does not work with other IME > too. Toggles not in view with all rows selected weren't being redrawn. > • Bug 796484 - csv import: iostream error. Unfortunately it turns out > that we can't use filestreams because they can't take path arguments > containing Unicode on Windows. > • Bug 796527 - invalid currency on scheduled transactions. > • Don't even check for price/exchange rate on template > transactions, there's no point. > • Check all split commodities are valid, abort transaction > creation if not. > • If the template transaction's currency isn't used by any of > the splits set the new transaction's currency to the first-found currency if > there is one, otherwise to the first-found commodity. > • Bug 796537 - Transaction Report cannot sort by "num". > • Bug 796586 - QIF import incorrectly converts unicode characters from > UTF8 encoded file. > • Bug 796595 - QIF Import Select Account button to add a new account is > labled gnc-account-new but should be New. > • Bug 796600 - stock split cash-in-lieu income/asset labels backwards. > • Bug 796614 - Reconciliation report contains in
Re: [GNC] New Balsheet (and P report)
Christopher, I am attaching the three balance sheet reports available from within GNC for both our test company and for my apartment building. Of the three, the accountant likes the layout and totals of the eguile version the best. Her specific comments regarding the Multicolumn (pnl) are: 1. Not unheard of to compare this year-to-date with last year-ti-date on a balance sheet (and income/expense) report. Less likely to be beginning period/end period. Most generally only done for last report of the year (to compare back to prior year). She prefers the single point-in-time version for personal and small company finances. 2. Placeholder accounts should not show $0.00. Their true value is the total for their level. 3. The dates should not be repeated for each section of the report. Once at the top is enough. 4. Equity is the same as Net Worth. Its total should include: a. Equity account totals b. Trading account totals (if there are no trading accounts, suppress that portion) c. Period to date Profit/Loss which should match the (Income - Expense) from the Income Statement. 5. Assets = Liabilities + Equity and the total of Liabilities and Equity should be shown and match the total of Assets. 6. Put in the column underlines for the totals as is done on the eguile version. Then you can remove the "Total for XXX" labels as it will be obvious it is a total. Now, for our test company, I think we have a problem with the GPB valuations. We haven't done any bookkeeping with multiple currencies. So will need input from somebody else. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/25/2018 06:56 AM, Christopher Lam wrote: > Seeking beta testers. > > https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl > > Or, anyone with v3.2 onwards can copy the file directly into the > build's standard-reports folder: > https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm > > Adds new balsheet and income statement (i.e. Profit) report. I > still have further ideas in the pipeline, just wish to check accuracy > of amounts produced. Not all options have been implemented. > > C > ___ > 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. > CL Inc Balance Sheet 06/25/2018 Assets [1]Asset $0.00 [2]Bank1 $0.00 [3]Checking $0.00 [4]Savings $100.00 [5]Bonds $2,000.00 [6]Bank2 $500.00 [7]ForeignBank $0.00 [8]Broker $2,000.00 [9]Stock $4,000.00 [10]House $500.00 Total Assets $9,100.00 __ __ Liabilities [11]Liability $0.00 [12]Bank2 $0.00 [13]Loan -$9,000.00 [14]Creditcard -$500.00 Total Liabilities $9,500.00 __ Equity [15]Equity $400.00 Total Equity -$400.00 __ Total Liabilities & Equity $9,100.00 References 1. gnc-register:acct-guid=7fcbfd020fc34c04b40a9dc974b86bef 2. gnc-register:acct-guid=f99452f2d77548d6bf358d0ec762869b 3. gnc-register:acct-guid=c6ba7462d05848fb8ef0bd33d26009f2 4. gnc-register:acct-guid=9cd11b4781fc41f5aa19af7ecf2a5542 5. gnc-register:acct-guid=ac1afdb4517a40fd9181d58395ad59d6 6. gnc-register:acct-guid=000682dbdb2149f9891a3f3fe0f20bf5 7. gnc-register:acct-guid=18b586b15e6449a79429ec81c2c501ee 8. gnc-register:acct-guid=d6bdb46b4af0421eb376fc804836b6c4 9. gnc-register:acct-guid=a9eecc82cd904f44822550882a56bcb8 10. gnc-register:acct-guid=8e6fd8b862e84e0a9bfe6dd3c0ce21d7 11. gnc-register:acct-guid=26e0d29bd40f40468e7cda0650d8902d 12. gnc-register:acct-guid=4643a6d3c5c34c9d83d5e53c5ae34e59 13. gnc-register:acct-guid=c0fae8ed7a484d1ca883f34402cf56f6 14. gnc-register:acct-guid=686ff299b6a845cf9c906ba24b71dea9 15. gnc-register:acct-guid=3758364a8113489f9ce00013b2c1f065 CL Inc Balance Sheet (eguile) 06/25/2018 Assets Accounts [1]Asset [2]Bank1 [3]Checking $0.00 [4]Savings
[GNC] Test Company
Christopher, I have setup the COA as we discussed and entered the initial transaction. Somehow I don't have the ForeignBank setup correctly or I'm not understanding how to mix currencies. Please look at it and see if we can get the ForeignBank to show the proper valuation for the equity account. XML file attached. I had a little fun setting up the company info. --Steve Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/21/2018 06:09 PM, Stephen M. Butler wrote: > Christopher > > Going to the latest version is stymied until I hear back from one of the > developers on what went wrong with make. > > I'm new to using GnuCash so have not delved into the Foreign currency or > stocks. > > So, let's build a COA together and see what happens (on paper): > > 100 - Asset > 110 - " : Bank1 > 112 - " : " :Checking > 114 - " : " : Savings > 116 - " : " : Bonds > 120 - " : Bank2 > 130 - " : ForeignBank (GBP currency) > 140 - " : Broker > 142 - " : " : Cash > 144 - " : " : Stock > 150 - " : House > > 200 - Liability > 220 - " : Bank2 > 222 - " : " : Loan > 224 - " : " : Creditcard > > 300 - Equity > > 400 - Income > > 500 - Expense > > We may fill in the above further as we work along. So, our initial > transaction will be to setup our initial balances: > [Normally we would setup somewhat prior to the above purchases and buy > things out of the checking account -- but, we just installed the > software and are starting in the middle.] > > Transaction 001 > 114 Debit $100 > 116 Debit $2000 > 120 Debit $500 > 130 Debit GBP 500 (equivalent to $625 at time of purchase) > 142 Debit $2000 > 144 Debit $4000 (20 units @ $200) > 222 Credit $9000 > 224 Credit $500 > 300 Debit $275 [Note, we are below water here. Equity should be a > credit account and we are in the hole.] > > At this point I went to the house accountant and asked about unrealized > gain and how to book it. She said you don't. Not until there is an > event in which it is sold or traded. For tomorrow GBP might drop back > to parity, the stock might crash, and the housing market could implode. > > So, we may need input from others who might have a different viewpoint. > > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > On 06/18/2018 03:32 PM, Christopher Lam wrote: >> Hi Stephen >> >> One of the most unique features of gnucash is the multilevel account >> hierarchy, meaning both parent accounts and child accounts can carry >> balances. >> >> Would you mind liaising with the house accountant to ask about the >> following COA and the resulting balance sheet >> >> Asset (bal=$0.00) >> Asset:Bank1 (bal=$0.00) >> Asset:Bank1:Savings (bal=$100) >> Asset:Bank1:Bonds (bal=$2000) >> Asset:Bank2:Current (bal=$500) >> Asset:House (bal=$100,000, cost price) >> Asset:ForeignBank:Savings (bal=GBP 500, bought last year at a rate of >> 1 GBP = 1.25 USD >> Asset:Broker (bal=$2000) i.e.cash with broker >> Asset:Broker:Funds [stock] (bal=20units bought @ $200 each) >> Liability (bal=$0) >> Liability:Bank2 (bal=$0) >> Liability:Bank2:Loan (bal=-$9,000) >> Liability:Bank2:Creditcard (bal=-$500) >> >> Let's assume the current valuation of the unit funds is $250 i.e. >> unrealized gains of $1000; the house is currently valued at $110,000, >> and today 1 GBP = 1.30 USD :) >> >> How should the full expanded balance sheet look like? (XLS is fine) >> (if there are missing lines e.g. retained earnings etc please make up >> numbers and offer exact source) >> >> Thanks! >> >> >> On 19/06/18 00:16, Stephen M. Butler wrote: >>> Yes, it is the alignment of numbers that is the problem. >>> >>> Stephen M Butler, PMP, PSM >>> stephen.m.butle...@gmail.com >>> kg...@arrl.net >>> 253-350-0166 >>> --- >>> GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 >>> >>> On 06/18/2018 06:35 AM, Christopher Lam wrote: >>>> Hi Stephen >>>> Thank you this is very helpful. >>>> From my understanding the non-eguil
Re: [GNC] Fwd: The two modules
On 06/22/2018 12:29 AM, Geert Janssens wrote: > Op donderdag 21 juni 2018 00:01:32 CEST schreef Stephen M. Butler: >> Found libofx7 and installed that instead of libofx6 and libofx4. >> > These numbers seem to increase regularly... I have updated the install > instruction to only install libofx-dev. This will automatically pull in the > corresponding libofx and its dependencies. Thank you. Wish I knew more about the innards of Linus. Still feel like I need someone to hold my hand! >> In file included from /usr/src/gtest/src/gtest-all.cc:42:0: > > >> In file included from >> /home/steve/Projects/googletest/googletest/include/gtest/internal/gtest-inte >> rnal.h:39:0, from > It looks like the build is mixing two versions of googletest. One installed > systemwide (/usr/src/gtest) and one in /home/steve/Projects/googletest. > > I assume you have followed instructions to download googletest and then set > GMOCK_ROOT and GTEST_ROOT when running cmake. > > A recent commit should have solved this issue, but your experience seems to > suggest otherwise. Yes, is there a command to remove one? Which one? Or could I move the most recent (I presume /home/steve/Projects/googletest) up the /usr/src? > What source are you building from ? A tarball or git ? If git, what commit > have you currently checked out ? You can determine this by running > git describe > in your git checkout. Not git. Still haven't figured that piece out yet. I need to do that. I followed instructions from https://wiki.gnucash.org/wiki/Building and https://wiki.gnucash.org/wiki/BuildUbuntu16.04 and pulled the source from https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/3.1/ and clicked on the green button that downloaded: gnucash-3.1-1.tar.gz <https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/3.1/gnucash-3.1-1.tar.gz/download>. gunzipped that and tar -xf into /home/steve/Projects/GnuCash/. > Geert > > Thanks Geert. --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.
Re: [GNC] Fwd: The two modules
Geert, Thank you. Thank you. I now have a working version Version: 3.1 Build ID: 3.1+ (2018-04-28) up and running on Ubuntu 18.04 On 06/22/2018 11:32 AM, Geert Janssens wrote: > Ok, in that case I think the easiest way forward is to not use > GMOCK_ROOT and > GTEST_ROOT and let gnucash discover your system installed version of > googletest and ignore the one you downloaded in your homedirectory. > > You may have to add -dev packages for googletest and mayby googlemock (I > don't > know the exact names on Ubuntu). And be sure to remove your build directory > and start again from running cmake. > > Regards, > > Geert > > > It appears that /usr/src/gtest and /usr/src/gmock are from 2014. Also appears the packages were not installed so went searching for google-test and google-mock and did these commands: sudo apt-get install googletest sudo apt-get install googlemock sudo apt-get install libgtest-dev However, the "make" step complains about entries in /usr/src/gtest. So I removed the three packages and tried again. "cmake" complains gtest not present. So I removed the two directories in /usr/src (gtest and gmock) and reinstalled the three above. I now have these entries in /usr/src: lrwxrwxrwx 1 root root 21 Dec 22 2016 gmock -> googletest/googlemock drwxr-xr-x 4 root root 4096 Jun 22 12:22 googletest lrwxrwxrwx 1 root root 21 Dec 22 2016 gtest -> googletest/googletest cmake ../gnucash-3.1 worked great make worked fine (I did see these lines but make kept running) [ 38%] Linking CXX shared library ../../../lib/libgnc-backend-xml-utils.so CMakeFiles/gnc-backend-xml-utils.dir/gnc-xml-backend.cpp.o: In function `GncXmlBackend::write_to_file(bool)': gnc-xml-backend.cpp:(.text+0x11e6): warning: the use of `mktemp' is dangerous, better use `mkstemp' or `mkdtemp' [ 38%] Built target gnc-backend-xml-utils and sudo make install worked like a champ. Again, thank you. Could not have figured this out on my own. --Steve Now to mow the lawn for the weekend. <> ___ 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] Fwd: The two modules
The accountant is real uncomfortable with removing the cash account. She feels that the children should add up to the total for the parent. Given that GnuCash allows a parent to also have funds/transactions in addition to the children, I guess the work around would be to treat those as the initial, unidentified, child. That way, when you add up the column the total would include the contribution from the parent. A balance sheet is made at a single point in time, such as, close of business on . [or start of business, ..., midday, etc] Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/21/2018 11:15 PM, Christopher Lam wrote: > Hi Stephen > > Thank you this is useful. > > Confirms my suspicions that unrealized gains shouldn't appear in > balsheet. > > From your illustrations below, the only addition I'd offer is there > wouldn't be a separate 142 Broker:Cash account, it'd be "140 Broker > $2000", "144 Broker:Stock $4000" entries... would this be a legitimate > amendment? > > And are multiple-date balsheets legit? > > Ta > > > On 22/06/18 09:09, Stephen M. Butler wrote: >> Christopher >> >> Going to the latest version is stymied until I hear back from one of the >> developers on what went wrong with make. >> >> I'm new to using GnuCash so have not delved into the Foreign currency or >> stocks. >> >> So, let's build a COA together and see what happens (on paper): >> >> 100 - Asset >> 110 - " : Bank1 >> 112 - " : " :Checking >> 114 - " : " : Savings >> 116 - " : " : Bonds >> 120 - " : Bank2 >> 130 - " : ForeignBank (GBP currency) >> 140 - " : Broker >> 142 - " : " : Cash >> 144 - " : " : Stock >> 150 - " : House >> >> 200 - Liability >> 220 - " : Bank2 >> 222 - " : " : Loan >> 224 - " : " : Creditcard >> >> 300 - Equity >> >> 400 - Income >> >> 500 - Expense >> >> We may fill in the above further as we work along. So, our initial >> transaction will be to setup our initial balances: >> [Normally we would setup somewhat prior to the above purchases and buy >> things out of the checking account -- but, we just installed the >> software and are starting in the middle.] >> >> Transaction 001 >> 114 Debit $100 >> 116 Debit $2000 >> 120 Debit $500 >> 130 Debit GBP 500 (equivalent to $625 at time of purchase) >> 142 Debit $2000 >> 144 Debit $4000 (20 units @ $200) >> 222 Credit $9000 >> 224 Credit $500 >> 300 Debit $275 [Note, we are below water here. Equity should >> be a >> credit account and we are in the hole.] >> >> At this point I went to the house accountant and asked about unrealized >> gain and how to book it. She said you don't. Not until there is an >> event in which it is sold or traded. For tomorrow GBP might drop back >> to parity, the stock might crash, and the housing market could implode. >> >> So, we may need input from others who might have a different viewpoint. >> >> Stephen M Butler, PMP, PSM >> stephen.m.butle...@gmail.com >> kg...@arrl.net >> 253-350-0166 >> --- >> GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 >> >> On 06/18/2018 03:32 PM, Christopher Lam wrote: >>> Hi Stephen >>> >>> One of the most unique features of gnucash is the multilevel account >>> hierarchy, meaning both parent accounts and child accounts can carry >>> balances. >>> >>> Would you mind liaising with the house accountant to ask about the >>> following COA and the resulting balance sheet >>> >>> Asset (bal=$0.00) >>> Asset:Bank1 (bal=$0.00) >>> Asset:Bank1:Savings (bal=$100) >>> Asset:Bank1:Bonds (bal=$2000) >>> Asset:Bank2:Current (bal=$500) >>> Asset:House (bal=$100,000, cost price) >>> Asset:ForeignBank:Savings (bal=GBP 500, bought last year at a rate of >>> 1 GBP = 1.25 USD >>> Asset:Broker (bal=$2000) i.e.cash with broker >>> Asset:Broker:Funds [stock] (bal=20units bought @ $200 each) >>> Liability (bal=$0) >>> Liability:Bank2 (bal=$0) >>> Liability:Bank2:Loan (bal=-$9,000) >>> Liability:Bank2:Creditcard (bal=-$500) &
Re: [GNC] Fwd: The two modules
Thank you. Found those entries and also found I had missed to OFX portion -- but apt-get complains on that one: $ sudo apt-get install libofx6 libofx4 libofx-dev Reading package lists... Done Building dependency tree Reading state information... Done Package libofx6 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package 'libofx6' has no installation candidate E: Unable to locate package libofx4 Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/20/2018 01:32 PM, nvsoar wrote: > Seems to me that I read recently that gwenhywfar is an AQ Banking > package. On the same google page is an entry that it can be > downloaded from Source Forge. > nvsoar > > On 06/20/18 13:17, Stephen M. Butler wrote: >> Then I ran into this problem. Researching. >> >> I don't see 'gwenhywfar' listed on the installation page. Attempting to >> install says package not found. >> >> $ cmake -D CMAKE_INStALL_PREFIX=/usr/local ../gnucash-3.1 >> -- The C compiler identification is GNU 7.3.0 >> -- The CXX compiler identification is GNU 7.3.0 >> -- Check for working C compiler: /usr/bin/cc >> -- Check for working C compiler: /usr/bin/cc -- works >> -- Detecting C compiler ABI info >> -- Detecting C compiler ABI info - done >> -- Detecting C compile features >> -- Detecting C compile features - done >> -- Check for working CXX compiler: /usr/bin/c++ >> -- Check for working CXX compiler: /usr/bin/c++ -- works >> -- Detecting CXX compiler ABI info >> -- Detecting CXX compiler ABI info - done >> -- Detecting CXX compile features >> -- Detecting CXX compile features - done >> -- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1") >> -- Checking for module 'glib-2.0>=2.40' >> -- Found glib-2.0, version 2.56.1 >> -- Checking for module 'gio-2.0' >> -- Found gio-2.0, version 2.56.1 >> -- Checking for module 'gobject-2.0>=2.20'$ cmake -D >> CMAKE_INStALL_PREFIX=/usr/local ../gnucash-3.1 >> -- The C compiler identification is GNU 7.3.0 >> -- The CXX compiler identification is GNU 7.3.0 >> -- Check for working C compiler: /usr/bin/cc >> -- Check for working C compiler: /usr/bin/cc -- works >> -- Detecting C compiler ABI info >> -- Detecting C compiler ABI info - done >> -- Detecting C compile features >> -- Detecting C compile features - done >> -- Check for working CXX compiler: /usr/bin/c++ >> -- Check for working CXX compiler: /usr/bin/c++ -- works >> -- Detecting CXX compiler ABI info >> -- Detecting CXX compiler ABI info - done >> -- Detecting CXX compile features >> -- Detecting CXX compile features - done >> -- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1") >> -- Checking for module 'glib-2.0>=2.40' >> -- Found glib-2.0, version 2.56.1 >> -- Checking for module 'gio-2.0' >> -- Found gio-2.0, version 2.56.1 >> -- Checking for module 'gobject-2.0>=2.20' >> -- Found gobject-2.0, version 2.56.1 >> -- Checking for module 'gmodule-2.0>=2.20' >> -- Found gmodule-2.0, version 2.56.1 >> -- Checking for module 'gthread-2.0>=2.20' >> -- Found gthread-2.0, version 2.56.1 >> -- Checking for module 'libxml-2.0>=2.7.0' >> -- Found libxml-2.0, version 2.9.4 >> -- Checking for module 'libxslt' >> -- Found libxslt, version 1.1.29 >> -- Checking for module 'webkit2gtk-4.0' >> -- Found webkit2gtk-4.0, version 2.20.3 >> -- Checking for module 'gtk+-3.0>=3.10.0' >> -- Found gtk+-3.0, version 3.22.30 >> -- Checking for module 'zlib' >> -- Found zlib, version 1.2.11 >> -- Found Gettext: /usr/bin/msgmerge (found suitable version "0.19.8.1", >> minimum required is "0.19.6") >> -- Using guile-2.0.x >> -- Using guile SRFI-64 >> -- Checking for module 'gwenhywfar' >> -- No package 'gwenhywfar' found >> CMake Error at /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:415 >> (message): >> A required package was not found >> Call Stack (most recent call first): >> /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:593 >> (_pkg_check_modules_internal) >> common/cmake_modules/GncFindPkgConfig.cmake:253 (PKG_CHECK_MODULES) >> CMakeLists.txt:347 (GNC_PKG_CHECK_MODULES) >> >> >> -- Configuring incomplete, errors occurred! >> See also >> "/home/steve/Projects/GnuCash/mybuild/C
Re: [GNC] Fwd: The two modules
Found libofx7 and installed that instead of libofx6 and libofx4. After a few other missed steps I now have completed the "cmake ../gnucash-3.1" step However the "make" step has problems: ... [ 29%] Built target test-core-guile Scanning dependencies of target scm-test-core [ 29%] Generating ../../lib/gnucash/scm/ccache/2.0/gnucash/unittest-support.go wrote `/home/steve/Projects/GnuCash/mybuild/lib/gnucash/scm/ccache/2.0/gnucash/unittest-support.go' [ 29%] Built target scm-test-core Scanning dependencies of target gtest [ 29%] Building CXX object common/test-core/CMakeFiles/gtest.dir/usr/src/gtest/src/gtest-all.cc.o In file included from /usr/src/gtest/src/gtest-all.cc:42:0: /usr/src/gtest/src/gtest.cc: In destructor ‘virtual testing::Test::~Test()’: /usr/src/gtest/src/gtest.cc:1897:10: error: type ‘const class testing::internal::scoped_ptr’ argument given to ‘delete’, expected pointer delete gtest_flag_saver_; ^ /usr/src/gtest/src/gtest.cc: At global scope: /usr/src/gtest/src/gtest.cc:2177:1: error: prototype for ‘testing::TestInfo::TestInfo(const string&, const string&, const char*, const char*, testing::internal::TypeId, testing::internal::TestFactoryBase*)’ does not match any in class ‘testing::TestInfo’ TestInfo::TestInfo(const std::string& a_test_case_name, ^~~~ In file included from /home/steve/Projects/googletest/googletest/include/gtest/internal/gtest-internal.h:39:0, from /home/steve/Projects/googletest/googletest/include/gtest/gtest.h:58, from /usr/src/gtest/src/gtest-all.cc:39: /home/steve/Projects/googletest/googletest/include/gtest/gtest.h:801:35: error: candidates are: testing::TestInfo::TestInfo(const testing::TestInfo&) GTEST_DISALLOW_COPY_AND_ASSIGN_(TestInfo); ^ /home/steve/Projects/googletest/googletest/include/gtest/internal/gtest-port.h:918:3: note: in definition of macro ‘GTEST_DISALLOW_COPY_AND_ASSIGN_’ type(type const &) GTEST_CXX11_EQUALS_DELETE_; \ ^~~~ In file included from /usr/src/gtest/src/gtest-all.cc:39:0: /home/steve/Projects/googletest/googletest/include/gtest/gtest.h:756:3: error: testing::TestInfo::TestInfo(const string&, const string&, const char*, const char*, testing::internal::CodeLocation, testing::internal::TypeId, testing::internal::TestFactoryBase*) TestInfo(const std::string& test_case_name, ^~~~ In file included from /usr/src/gtest/src/gtest-all.cc:42:0: /usr/src/gtest/src/gtest.cc: In function ‘testing::TestInfo* testing::internal::MakeAndRegisterTestInfo(const char*, const char*, const char*, const char*, testing::internal::TypeId, testing::internal::SetUpTestCaseFunc, testing::internal::TearDownTestCaseFunc, testing::internal::TestFactoryBase*)’: /usr/src/gtest/src/gtest.cc:2227:45: error: no matching function for call to ‘testing::TestInfo::TestInfo(const char*&, const char*&, const char*&, const char*&, const void*&, testing::internal::TestFactoryBase*&)’ fixture_class_id, factory); ^ In file included from /usr/src/gtest/src/gtest-all.cc:39:0: /home/steve/Projects/googletest/googletest/include/gtest/gtest.h:756:3: note: candidate: testing::TestInfo::TestInfo(const string&, const string&, const char*, const char*, testing::internal::CodeLocation, testing::internal::TypeId, testing::internal::TestFactoryBase*) TestInfo(const std::string& test_case_name, ^~~~ /home/steve/Projects/googletest/googletest/include/gtest/gtest.h:756:3: note: candidate expects 7 arguments, 6 provided In file included from /usr/src/gtest/src/gtest-all.cc:42:0: /usr/src/gtest/src/gtest.cc: At global scope: /usr/src/gtest/src/gtest.cc:3486:76: error: definition of ‘testing::ScopedTrace::ScopedTrace(const char*, int, const testing::Message&)’ is not in namespace enclosing ‘testing::ScopedTrace’ [-fpermissive] ScopedTrace::ScopedTrace(const char* file, int line, const Message& message) ^ /usr/src/gtest/src/gtest.cc:3486:1: error: prototype for ‘testing::ScopedTrace::ScopedTrace(const char*, int, const testing::Message&)’ does not match any in class ‘testing::ScopedTrace’ ScopedTrace::ScopedTrace(const char* file, int line, const Message& message) ^~~ In file included from /home/steve/Projects/googletest/googletest/include/gtest/internal/gtest-internal.h:39:0, from /home/steve/Projects/googletest/googletest/include/gtest/gtest.h:58, from /usr/src/gtest/src/gtest-all.cc:39: /home/steve/Projects/googletest/googletest/include/gtest/gtest.h:2182:35: error: candidates are: testing::ScopedTrace::ScopedTrace(const testing::ScopedTrace&) GTEST_DISALLOW_COPY_AND_ASSIGN_(ScopedTrace); ^ /home/steve/Projects/googletest/googletest/include/gtest/internal/gtest-port.h:918:3: note: in definition of macro
Re: [GNC] Fwd: The two modules
Then I ran into this problem. Researching. I don't see 'gwenhywfar' listed on the installation page. Attempting to install says package not found. $ cmake -D CMAKE_INStALL_PREFIX=/usr/local ../gnucash-3.1 -- The C compiler identification is GNU 7.3.0 -- The CXX compiler identification is GNU 7.3.0 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Detecting C compile features -- Detecting C compile features - done -- Check for working CXX compiler: /usr/bin/c++ -- Check for working CXX compiler: /usr/bin/c++ -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Detecting CXX compile features -- Detecting CXX compile features - done -- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1") -- Checking for module 'glib-2.0>=2.40' -- Found glib-2.0, version 2.56.1 -- Checking for module 'gio-2.0' -- Found gio-2.0, version 2.56.1 -- Checking for module 'gobject-2.0>=2.20'$ cmake -D CMAKE_INStALL_PREFIX=/usr/local ../gnucash-3.1 -- The C compiler identification is GNU 7.3.0 -- The CXX compiler identification is GNU 7.3.0 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Detecting C compile features -- Detecting C compile features - done -- Check for working CXX compiler: /usr/bin/c++ -- Check for working CXX compiler: /usr/bin/c++ -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Detecting CXX compile features -- Detecting CXX compile features - done -- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1") -- Checking for module 'glib-2.0>=2.40' -- Found glib-2.0, version 2.56.1 -- Checking for module 'gio-2.0' -- Found gio-2.0, version 2.56.1 -- Checking for module 'gobject-2.0>=2.20' -- Found gobject-2.0, version 2.56.1 -- Checking for module 'gmodule-2.0>=2.20' -- Found gmodule-2.0, version 2.56.1 -- Checking for module 'gthread-2.0>=2.20' -- Found gthread-2.0, version 2.56.1 -- Checking for module 'libxml-2.0>=2.7.0' -- Found libxml-2.0, version 2.9.4 -- Checking for module 'libxslt' -- Found libxslt, version 1.1.29 -- Checking for module 'webkit2gtk-4.0' -- Found webkit2gtk-4.0, version 2.20.3 -- Checking for module 'gtk+-3.0>=3.10.0' -- Found gtk+-3.0, version 3.22.30 -- Checking for module 'zlib' -- Found zlib, version 1.2.11 -- Found Gettext: /usr/bin/msgmerge (found suitable version "0.19.8.1", minimum required is "0.19.6") -- Using guile-2.0.x -- Using guile SRFI-64 -- Checking for module 'gwenhywfar' -- No package 'gwenhywfar' found CMake Error at /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:415 (message): A required package was not found Call Stack (most recent call first): /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:593 (_pkg_check_modules_internal) common/cmake_modules/GncFindPkgConfig.cmake:253 (PKG_CHECK_MODULES) CMakeLists.txt:347 (GNC_PKG_CHECK_MODULES) -- Configuring incomplete, errors occurred! See also "/home/steve/Projects/GnuCash/mybuild/CMakeFiles/CMakeOutput.log". -- Found gobject-2.0, version 2.56.1 -- Checking for module 'gmodule-2.0>=2.20' -- Found gmodule-2.0, version 2.56.1 -- Checking for module 'gthread-2.0>=2.20' -- Found gthread-2.0, version 2.56.1 -- Checking for module 'libxml-2.0>=2.7.0' -- Found libxml-2.0, version 2.9.4 -- Checking for module 'libxslt' -- Found libxslt, version 1.1.29 -- Checking for module 'webkit2gtk-4.0' -- Found webkit2gtk-4.0, version 2.20.3 -- Checking for module 'gtk+-3.0>=3.10.0' -- Found gtk+-3.0, version 3.22.30 -- Checking for module 'zlib' -- Found zlib, version 1.2.11 -- Found Gettext: /usr/bin/msgmerge (found suitable version "0.19.8.1", minimum required is "0.19.6") -- Using guile-2.0.x -- Using guile SRFI-64 -- Checking for module 'gwenhywfar' -- No package 'gwenhywfar' found CMake Error at /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:415 (message): A required package was not found Call Stack (most recent call first): /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:593 (_pkg_check_modules_internal) common/cmake_modules/GncFindPkgConfig.cmake:253 (PKG_CHECK_MODULES) CMakeLists.txt:347 (GNC_PKG_CHECK_MODULES) -- Configuring incomplete, errors occurred! See also "/home/steve/Projects/GnuCash/mybuild/CMakeFiles/CMakeOutput.log". Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --------------- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/20/2018 12:34 PM, Stephen M. Butler wrote: > I decided to pull down the latest version (I know a new one is coming in > just a few days) to be sure I could compile it and utiliz
Re: [GNC] Fwd: The two modules
I decided to pull down the latest version (I know a new one is coming in just a few days) to be sure I could compile it and utilize the latest versions of the reports for this mock company. But, I ran into a slight problem installing the packages and hope I made the right choice: $ sudo apt-get install swig2.0 Reading package lists... Done Building dependency tree Reading state information... Done Package swig2.0 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source However the following packages replace it: swig:i386 swig E: Package 'swig2.0' has no installation candidate $ sudo apt-get install swig Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: swig3.0 Someone may wish to update the https://wiki.gnucash.org/wiki/BuildUbuntu16.04 page I was following. I'm on Ubuntu 18.04. --Steve Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/18/2018 03:32 PM, Christopher Lam wrote: <> ___ 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] Upgrading GC under Ubuntu
On 07/02/2018 12:34 PM, Colin Law wrote: > I thought you might have hit on something there (the shell) as I have > been using ssh to connect in to run it, but I have tried locally and > it is the same. I have added some cmake message output and can see > that the command to install to /usr/local/share/gnucash/icons does > nothing unless I hack the regex. The one to output to > /usr/local/share/icons is working correctly. I am using bash too. > > It doesn't make sense. I am at a loss to know what to try next. > > Colin > At times I've found I have to escape the * or the shell will immediately expand it. Other times it seems to pass through OK. I don't know why. I haven't tried here since it is working for me. Very strange. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 on 18.04
On 07/02/2018 06:04 AM, Colin Law wrote: > Well, this line in build/data/pixmaps/cmake_install.cmake > > file(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share/gnucash/icons" TYPE > DIRECTORY FILES "/home/me/apps/gnucash-3.2/data/pixmaps/hicolor" REGEX > ".*/apps.*" EXCLUDE) > > Is supposed to copy files from gnucash-3.2/data/pixmaps/hicolour/* to > /usr/local/share/gnucash/icons excluding the pattern .*/apps.* so it should > copy, for example, hicolor/16x16/actions/gnc-account.png but should exclude > hicolor/16x16/apps/* but it doesn't work on my system, it excludes > everything. If I remove the REGEX ".." EXCLUDE then it copies them all, > including those in the apps folder. I can't see why it doesn't work though. > > @Roger could you remove or rename /usr/local/share/gnucash/icons and run > sudo make install and see if it puts back all the icons such as > hicolor/actions/gnc-account.png. > > If it doesn't then there is a problem with the above cmake instruction, if > it does then for some reason that does not work on my cmake. > > For reference my cmake is 3.10.2-1ubuntu2 > > Colinif("x${CMAKE_INSTALL_COMPONENT}x" STREQUAL "xUnspecifiedx" OR NOT > CMAKE_INSTALL_COMPONENT) > file(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share/gnucash" TYPE > DIRECTORY FILES "/home/steve/Projects/GnuCash/gnucash-3.2/data/pixmaps" REGEX > "/Makefile[^/]*$" EXCLUDE REGEX "/CMake[^/]*$" EXCLUDE REGEX "/CTest[^/]*$" > EXCLUDE REGEX "/cmake[^/]*$" EXCLUDE REGEX "/hicolor$" EXCLUDE) > endif() > > if("x${CMAKE_INSTALL_COMPONENT}x" STREQUAL "xUnspecifiedx" OR NOT > CMAKE_INSTALL_COMPONENT) > file(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share/gnucash/icons" TYPE > DIRECTORY FILES > "/home/steve/Projects/GnuCash/gnucash-3.2/data/pixmaps/hicolor" REGEX > ".*/apps.*" EXCLUDE) > endif() > > if("x${CMAKE_INSTALL_COMPONENT}x" STREQUAL "xUnspecifiedx" OR NOT > CMAKE_INSTALL_COMPONENT) > file(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share/icons" TYPE > DIRECTORY FILES > "/home/steve/Projects/GnuCash/gnucash-3.2/data/pixmaps/hicolor" REGEX > ".*/actions.*" EXCLUDE) > endif() > > <> Mine is cmake -version cmake version 3.10.2 I found three relevant areas in my copy of that file: if("x${CMAKE_INSTALL_COMPONENT}x" STREQUAL "xUnspecifiedx" OR NOT CMAKE_INSTALL_COMPONENT) file(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share/gnucash" TYPE DIRECTORY FILES "/home/steve/Projects/GnuCash/gnucash-3.2/data/pixmaps" REGEX "/Makefile[^/]*$" EXCLUDE REGEX "/CMake[^/]*$" EXCLUDE REGEX "/CTest[^/]*$" EXCLUDE REGEX "/cmake[^/]*$" EXCLUDE REGEX "/hicolor$" EXCLUDE) endif() if("x${CMAKE_INSTALL_COMPONENT}x" STREQUAL "xUnspecifiedx" OR NOT CMAKE_INSTALL_COMPONENT) file(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share/gnucash/icons" TYPE DIRECTORY FILES "/home/steve/Projects/GnuCash/gnucash-3.2/data/pixmaps/hicolor" REGEX ".*/apps.*" EXCLUDE) endif() if("x${CMAKE_INSTALL_COMPONENT}x" STREQUAL "xUnspecifiedx" OR NOT CMAKE_INSTALL_COMPONENT) file(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share/icons" TYPE DIRECTORY FILES "/home/steve/Projects/GnuCash/gnucash-3.2/data/pixmaps/hicolor" REGEX ".*/actions.*" EXCLUDE) endif() Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Odd behavior on Transaction Report
On 07/02/2018 06:02 PM, Christopher Lam wrote: > Hi Stephen > The Running balance is directly retrieved from the split data; the > ordering of same-day splits is, I believe, dependent on the order of > data entered. > If it matters try setting one of the sortkeys to 'register order' - it > may work but even if it does, the custom sorter will sort strictly > by date, so, the running balances will have unpredictable order. > C > Yuck. To bad the report doesn't recalculate the balances in the order of the sort. > On 2 July 2018 at 12:07, Stephen M. Butler <mailto:kg...@arrl.net>> wrote: > > While balancing our checking account we ran into odd behavior on the > transaction report. > > The running balance column goes backwards when there are multiple > transactions on the same day. For example: > > 05/17/2018 1213 x > Green House > $40.00 > > $2,863.80 > 05/18/2018 1195 > Green House > $2,250.00 > > $1,564.45 > 05/18/2018 > I > IHSA > $126.58 > > $3,814.45 > 05/18/2018 > xxx > Church > $822.77 > > $3,941.03 > 05/18/2018 > xxx > Cash. > $200.00 > > $4,763.80 > 05/18/2018 > Transfer > Money Market $2,100.00 > > $4,963.80 > > > > > Notice how the running balance jumps from line 1 to line 6 then works > itself upwards back to line 2. Then it jumps to line 7 (not shown). > Made for an interesting hour until the accountant figured out what was > going on. > > -- > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com <mailto:stephen.m.butle...@gmail.com> > kg...@arrl.net <mailto:kg...@arrl.net> > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > ___ > 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. > > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)
On 06/29/2018 09:52 AM, Geert Janssens wrote: > Op vrijdag 29 juni 2018 16:59:07 CEST schreef John Ralls: >> Stock accounts need to have a parent denominated the currency in which the >> stock trades in order for the asset roll-up to work correctly on the >> Accounts page. Three-commodity transactions are possible using trading >> accounts, but I haven’t dealt with that stuff in a while and the details >> have gone fuzzy on me. I have been reading up on trading accounts and the similarity between currencies and stock. Essentially stock is just a different currency with an exchange rate that changes much to fast! >> >> Stock accounts aside, let’s not conflate different purposes. We *should* >> have an account type to accommodate the European Passive account with >> Liability and Equity children, so let’s create that. We’ll need to tweak >> some of the reports a bit to accommodate it, but otherwise it won’t have >> much impact. It should, of course, be what we now call a placeholder and it >> should be able to have only Root as a parent and only one each Liability >> and Equity placeholder children. To my way of thinking, if you want total flexibility, you should be able to define your top level accounts and name them according to your language and custom. Hence, for me: Assets Liabilities Equity Income Expense For friends across the big ocean: Activa Assets Expense Passiva Libilities Equity Income (At least I think that is how they organize them.) Each top level would need an indicator whether it is normally a Debit or Credit account. <> > Here's another example: a household that wants to track its finances, but > would want to keep separate account hierarchies per family member. Standard > response: create two files. However they would benefit from common reporting > which is cumbersome with two separate files. So what if we would allow to > create two independent account hierarchies in one file. With a view type > account one could create two top-levels ("Husband" and "Wife") and create a > independent hierarchy for each. While this could also be solved if we would > allow multiple root accounts and make that root visible I'm using it here to > illustrate there are use cases we are not covering well. Not sure how: WIFE HUSBAND would fit in as top level accounts though. I would think, at a minimum, they would be sub-accounts with the top level -- else how could you combine all the assets together for a total? Then again, with total flexibility, how do you define the generally accepted accounting formulas? <> > The package also doesn't have a hierarchical account tree. It's flat and > hierarchy is only added in reports as explained above. So there is no such > thing as a parent account in that package and hence no restriction on which > account type a certain account can be. > > Again in gnucash the chart of accounts is very central and visible so we > probably shouldn't drop its hierarchical structure just yet. > > The downside of this hierarchical structure is then of course we have to > think > about issues like whether or not we should allow accounts to have any type > of > child or not. I believe parts of gnucash rely on this (I seem to remember a > relatively recent issue in the export code that it didn't find all liability > accounts if they had a non-liability parent or such). > >> and I think that we already have too >> many overlapping account types with subtle behavior differences that are >> neither documented nor easily discoverable in code. >> > I'm all for clearing this up. If we can reduce the number of account types > that would be great. > For reference this is the list of 17 account types supported by the > commercial > package*: > Receivable, payable, bank and cash (one type), current assets, non-current > assets, prepayments, fixed assets, current liabilities, non-current- > liabilities, equity, current year earnings, other income, income, > depreciation, expenses, cost of revenue, credit card. > > Gnucash currently has 15 of which a few are internal only: > Bank, cash, credit, asset, liability, stock, mutual, currency, income, > expense, equity, receivable, payable, root and trading. And figuring out when to use which is hard enough without adding more. Maybe some of these should become indicators rather than account types and revert back to just the 5 basic? > The leftovers from this long discussion for immediate use may be summarized > as: > - on reports display placeholder accounts once as aggregate account and once > as its own account if it has splits. > - work to be more pedantic about the meaning of "placeholder". It should > become an empty account used for structuring the account hierarchy and for > collecting (sub)totals. > - introduce a read-only status for accounts one doesn't want to accidentally > modify, but that should still appear in the chart of
Re: [GNC] GnuCash 3.2 Released
On 06/29/2018 12:43 AM, DaveC49 wrote: > Stephen, > > It is generally a good idea to remove the previous version before installing > a new one. Gnucash will generally overwrite any existing files of the same > name, but you may be left with unnecessary files in some cases. Going from > 3.1 to 3.2 should be OK as there are unlikey to be major changes in the file > structure, but between major version could be problematical There are > instructions on the Wiki in the build instructions for Ubuntu 16.04 for > doing uninstalls in a variety of circumstances including manually deleting > all the files which will be the same for 18.04. I'll put a note in there re > uninstalling previous versionsbefore the build instructions to make it > clearer. > > If you still have the 3.1 build directory: > open a shell and cd to the build directory then type > sudo make uninstall Sadly, I aggressively removed it when bringing in 3.2 :-( So a learning experience that, hopefully, I can help others avoid. > > then do the install of V3.2 > > This uses a manifest created when Gnucash was installed to uninstall all of > the program files. It leaves user preference files untouched. > > David > > > > - > David Cousens > -- > 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] Fwd: The two modules
On 06/28/2018 10:02 PM, DaveC49 wrote: > Hi Stephen, > > I agree with your wife about not including the Income Statement inside a > Balance Sheet. These serve different functions and it just makes a Balance > Sheet more complicated than necessary. From an accounting perspective you > should be able to evaluate a balance sheet fairly quickly and having a > fairly uniform layout means comparison of balance sheets for different > entities is much easier, which is the rational for trying to get the IFRS > standards adopted world wide. My personal preference is for simple reports > which meet one specific objective well and clearly. > > As I explained in a post to John, I don't necessarily require GnuCash to > impose parent placholder accounts not to have transactions into them > specifically, but it would be a nice feature to have an option to make > adherence strict if the user requires it. It may however require > considerable code mods to achieve that and I can achieve that by just > removing any transactions which target an account i make a placeholder to a > sub-account or another account. More difficult of course if you have a large > number of such transactions. A lot of people use GnuCash for a lot of > functions other than formal accounting so as David T pointed out some people > use the placholder readonly functionality to meet other requirements. I > can't think of a specific case but I am all for retaining as much > flexibility in GnuCash as possible. It may be just better documentation fof > the Placholder setting may achieve that. > > Cheers > > David > It would be nice if there was a system wide preference flag (like the current Trading Accounts setting) that a user could turn on that would enforce that behavior. But, as you said, an individual can do the work to enforce it them-self. Another question, do you set only the five top level accounts (Asset, Expense, Equity (or Capital), Income and Expense) or do you have multiple top level accounts in each of the designated types? That is, do you do: Assets (asset type) Bank (bank type) Checking (bank) Savings (bank) etc Cash (cash) Home (asset) Or, Bank (asset) Checking (bank) Savings (bank) etc Cash (asset) Home (asset) The first gives one top level Asset account, the second gives three top level Asset accounts. --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.
Re: [GNC] Build on 18.04
On 07/01/2018 08:36 AM, Roger Miskowicz wrote: > in 16.04 and GC3.2 using: > > $ locate gnc-account-report > > I found: > > /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-account-report.png > /usr/local/share/gnucash/icons/hicolor/24x24/actions/gnc-account-report.png > > Are these files found in 18.04? I found them on my 18.04 Ubuntu -- I compile 3.2 locally and installed in /usr via sudo. > On Sun, Jul 1, 2018 at 10:55 AM, Colin Law wrote: > >> In the trace file I see around a dozen lines similar to >> >> * 13:29:29 WARN [gnc_load_app_icons()] No icon named >> 'gnc-account' found. Some gui elements may be missing their icons >> * 13:29:29 WARN [gnc_load_app_icons()] No icon named >> 'gnc-account-report' found. Some gui elements may be missing their icons >> >> Colin >> >> >> On 1 July 2018 at 13:39, Colin Law wrote: >> >>> Actually I see there are more icons missing, such as the Split button >> icon >>> in the toolbar. It seems that the missing files are the png files from >>> data/pixmaps/hicolor/?/actions. Are these supposed to be copied >>> somewhere by make install? >>> >>> Colin >>> >>> On 1 July 2018 at 11:21, Colin Law wrote: >>> Following the instructions for building GC 3.x on the wiki [1] has been accomplished on Ubuntu 18.04 with little difficulty, so many thanks to the contributors to the wiki. Just one small issue so far, the icons to the left of the account names are all showing as a little no entry sign, which I guess means the icon is missing. Does that mean I have missed something or is something missing from the build? Colin [1] https://wiki.gnucash.org/wiki/BuildUbuntu16.04 >>> >> ___ >> 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] Upgrading GC under Ubuntu
On 07/02/2018 07:31 AM, Colin Law wrote: > On 29 June 2018 at 20:50, Stephen M. Butler <mailto:kg...@arrl.net>> wrote: > > ... > Having just done a download and compile to my Ubuntu 18.04, let me > share > with you what I did. Sometimes reading the web sites leaves one (at > least me) scratching their head vigorously -- in my case not a > good idea > with the hair I have left! > > > Hi Stephen > > Following your 18.04 build have you got all the icons available? > Assuming you installed to /usr/local then you should see > $ ls -l /usr/local/share/gnucash/icons/hicolor/16x16/actions > total 72 > -rw-r--r-- 1 root root 540 Apr 15 00:51 gnc-account-delete.png > -rw-r--r-- 1 root root 416 Apr 15 00:51 gnc-account-edit.png > -rw-r--r-- 1 root root 460 Apr 15 00:51 gnc-account-new.png > -rw-r--r-- 1 root root 540 Apr 15 00:51 gnc-account-open.png > -rw-r--r-- 1 root root 334 Apr 15 00:51 gnc-account.png > > > If they are there could you help me to debug an install issue please? > Remove or rename /usr/local/share/gnucash/icons and rerun > sudo make install > Then check to see if the icons have been restored? When I try it on > 18.04 I am not getting the icons and have to hack one of the cmake > files to get it to work, but for others it works ok on Ubuntu 16.04. > > Thanks > > Colin > I have: ls -l /usr/local/share/gnucash/icons/hicolor/16x16/actions total 72 -rw-r--r-- 1 root root 540 Apr 14 16:51 gnc-account-delete.png -rw-r--r-- 1 root root 416 Apr 14 16:51 gnc-account-edit.png -rw-r--r-- 1 root root 460 Apr 14 16:51 gnc-account-new.png -rw-r--r-- 1 root root 540 Apr 14 16:51 gnc-account-open.png -rw-r--r-- 1 root root 334 Apr 14 16:51 gnc-account.png -rw-r--r-- 1 root root 417 Apr 14 16:51 gnc-account-report.png -rw-r--r-- 1 root root 549 Apr 14 16:51 gnc-gnome-pdf.png -rw-r--r-- 1 root root 824 Apr 14 16:51 gnc-invoice-duplicate.png -rw-r--r-- 1 root root 711 Apr 14 16:51 gnc-invoice-edit.png -rw-r--r-- 1 root root 542 Apr 14 16:51 gnc-invoice-new.png -rw-r--r-- 1 root root 767 Apr 14 16:51 gnc-invoice-pay.png -rw-r--r-- 1 root root 546 Apr 14 16:51 gnc-invoice.png -rw-r--r-- 1 root root 658 Apr 14 16:51 gnc-invoice-post.png -rw-r--r-- 1 root root 682 Apr 14 16:51 gnc-invoice-unpost.png -rw-r--r-- 1 root root 723 Apr 14 16:51 gnc-jumpto.png -rw-r--r-- 1 root root 616 Apr 14 16:51 gnc-split-trans.png -rw-r--r-- 1 root root 789 Apr 14 16:51 gnc-transfer.png -rw-r--r-- 1 root root 714 Apr 14 16:51 gnc-sx-new.png -rw-r--r-- 1 root root 789 Apr 14 16:51 gnc-transfer.png I then did: cd /usr/local/share/gnucash sudo mv icons smbhold cd ~/Projects/GnuCash/mybuild sudo make install << snip a long list>> -- Up-to-date: /usr/local/share/gnucash/pixmaps/gnucash_splash.png -- Installing: /usr/local/share/gnucash/icons/hicolor -- Installing: /usr/local/share/gnucash/icons/hicolor/scalable -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16 steve@stevelaptop:/usr/local/share/gnucash -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice-edit.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice-post.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-gnome-pdf.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-account-edit.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice-pay.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-account-new.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-account-report.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice-new.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice-duplicate.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-sx-new.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-jumpto.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-account-open.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-split-trans.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice-unpost.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-account.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-transfer.png -- Installing: /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-account-delete.png -- Installing: /usr/local/share/gnucash/icons/hicolor/24x24 -- Installing: /usr/local/share/gnucash/icons/hicolor/24x24/actions -- Installing: /usr/local/share/gnucash/icons/hicolor/24x24/actions/gnc-invoice-edit.png -- Installing: /usr/local/share/gnucash/
Re: [GNC] Build on 18.04
On 07/02/2018 07:19 AM, Colin Law wrote: > OK, thanks. > > I am confident now that my cmake in 18.04 (3.10.2-1ubuntu2) does not like > the regex in > REGEX ".*/apps.*" EXCLUDE > which excludes everything. If I replace this with > REGEX ".*/apps/gnucash-icon.*" EXCLUDE > then it works correctly. All the files in apps are of the form > gnucash-icon.* > I also tried > REGEX ".*/apps/.*" EXCLUDE > but that also excludes everything which doesn't make sense. > I can't find any reference to a bug like that in cmake but I can't see any > other reason it would not work. > > Has anyone else got the build going on 18.04? > > Colin > I am running 18.04 on Ubuntu. However, I didn't uninstall 3.1 when I built 3.2 so maybe that was a blessing in disguise! ___ 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] Fwd: The two modules
Christopher Going to the latest version is stymied until I hear back from one of the developers on what went wrong with make. I'm new to using GnuCash so have not delved into the Foreign currency or stocks. So, let's build a COA together and see what happens (on paper): 100 - Asset 110 - " : Bank1 112 - " : " :Checking 114 - " : " : Savings 116 - " : " : Bonds 120 - " : Bank2 130 - " : ForeignBank (GBP currency) 140 - " : Broker 142 - " : " : Cash 144 - " : " : Stock 150 - " : House 200 - Liability 220 - " : Bank2 222 - " : " : Loan 224 - " : " : Creditcard 300 - Equity 400 - Income 500 - Expense We may fill in the above further as we work along. So, our initial transaction will be to setup our initial balances: [Normally we would setup somewhat prior to the above purchases and buy things out of the checking account -- but, we just installed the software and are starting in the middle.] Transaction 001 114 Debit $100 116 Debit $2000 120 Debit $500 130 Debit GBP 500 (equivalent to $625 at time of purchase) 142 Debit $2000 144 Debit $4000 (20 units @ $200) 222 Credit $9000 224 Credit $500 300 Debit $275 [Note, we are below water here. Equity should be a credit account and we are in the hole.] At this point I went to the house accountant and asked about unrealized gain and how to book it. She said you don't. Not until there is an event in which it is sold or traded. For tomorrow GBP might drop back to parity, the stock might crash, and the housing market could implode. So, we may need input from others who might have a different viewpoint. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/18/2018 03:32 PM, Christopher Lam wrote: > Hi Stephen > > One of the most unique features of gnucash is the multilevel account > hierarchy, meaning both parent accounts and child accounts can carry > balances. > > Would you mind liaising with the house accountant to ask about the > following COA and the resulting balance sheet > > Asset (bal=$0.00) > Asset:Bank1 (bal=$0.00) > Asset:Bank1:Savings (bal=$100) > Asset:Bank1:Bonds (bal=$2000) > Asset:Bank2:Current (bal=$500) > Asset:House (bal=$100,000, cost price) > Asset:ForeignBank:Savings (bal=GBP 500, bought last year at a rate of > 1 GBP = 1.25 USD > Asset:Broker (bal=$2000) i.e.cash with broker > Asset:Broker:Funds [stock] (bal=20units bought @ $200 each) > Liability (bal=$0) > Liability:Bank2 (bal=$0) > Liability:Bank2:Loan (bal=-$9,000) > Liability:Bank2:Creditcard (bal=-$500) > > Let's assume the current valuation of the unit funds is $250 i.e. > unrealized gains of $1000; the house is currently valued at $110,000, > and today 1 GBP = 1.30 USD :) > > How should the full expanded balance sheet look like? (XLS is fine) > (if there are missing lines e.g. retained earnings etc please make up > numbers and offer exact source) > > Thanks! > > > On 19/06/18 00:16, Stephen M. Butler wrote: >> Yes, it is the alignment of numbers that is the problem. >> >> Stephen M Butler, PMP, PSM >> stephen.m.butle...@gmail.com >> kg...@arrl.net >> 253-350-0166 >> --- >> GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 >> >> On 06/18/2018 06:35 AM, Christopher Lam wrote: >>> Hi Stephen >>> Thank you this is very helpful. >>> From my understanding the non-eguile version does produce satisfactory >>> headings and contents. >>> However its alignment of numbers is odd? >>> Is the alignment of subtotals and totals perfect in your amended >>> eguile report? How should it look if there are deeper levels of >>> subaccounts? >>> For html export, open the report tab, then File>Export>Export Report. >>> I believe the standard balsheet can be refined but this will take some >>> time. >>> C >>> >>> On 18 June 2018 at 00:32, Stephen M. Butler >> <mailto:kg...@arrl.net>> wrote: >>> >>> Interesting on the age. I thought I'd downloaded the most recent >>> Linux >>> install. But, my version is 2.6.19 built from rev c1b5e6c8d+ on >>> 2018-04-09. May be best to wait for the next release due out >>> early next >>> week and see how those reports look. >>> >>> In the interim, attached are: >>> 1. GVE.gnucash -- my current set of books for an ap
Re: [GNC] GNUcash 3.2 file open issue
On 07/27/2018 03:46 PM, David Cousens wrote: > Hi John, > > Have posted it as Bug 796789 for V3.2. Other users with other OS and GnuCash > versions might like to comment on behavior on their systems which may help > with tracking down the problem. Not sure whether it is a bug in Ubuntu and > derivatives but Libre Office, GIMP with similar dialogs all seem to be able > to access the mounted USB sticks and network locations in the file open > dialogs. > > Cheers > David Cousens > Thunderbird on Ubuntu (all versions I've had) is not able to see a Windows mounted share. I have to copy the file over using the file manager. Have not tried GnuCash though. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Closing and reopening Gnucash
On 08/02/2018 07:24 AM, Adrien Monteleone wrote: > First, please reply to the list so others can benefit from the conversation. > > Absolutely you can save your file in a new location. > > Where would you like to save it? Somewhere in your Home folder tree is what > I’d think most people use. > > Does it need to be on a removable drive or can it be stored on the internal > HD/SSD? What was the reason for using the removable drive in the first place? > > p.s—I’m going to be away from my computer till this evening, but someone else > might chime in before me based on your answers. > > Regards, > Adrien > >> On Aug 2, 2018, at 9:08 AM, Dick Barmann wrote: >> >> How can I close "save as" to set a new location that will not have a long >> name and cannot not be found. My existing files are deep in the program and >> I keep getting that file cannot be found. Can I create a folder that can be >> found and close with it. I am using Linux. >> >> Richard Barmann >> >> Richard, You didn't indicate which version of *Nix you have. I am using Ubuntu 18.04. In my situation, I keep books for personal as well as an LLC I own. In my $HOME folder I created a Finance Folder and under that a folder for SteveWanita (could call it Personal) and one for the LLC. I save as to these folders the first time. And yes, it is a pain the see the folder with all the logs and backups in there. Once in a while I go on a jihad to clean them out. I'm running the supplied backup utility to send the daily backups to a Windows share that sits on the Windows box (external drive -- always mounted). On one occasion I had to recover my LLC finances from there as I was too aggressive in removing the logs/backups. <> However, I can click on the file name and GnuCash fires up with it opened and read to go. Or, I can click on the Icon for GnuCash frozen to the left panel and get whichever one I worked on last. Usually that isn't the one I want! Hope this helps. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Frequency of 28 Days
On 08/02/2018 10:36 AM, adb34 via gnucash-user wrote: > I got v3.1 from the site. I have now v3.2. To upgrade just run the v3.2 and > install over the top? If you do that, there will be a couple of files you need to remove by hand (duplicate reports). I took that route and had to chase those down (look in the archives for the details). Better to uninstall the old version first. Be sure you have copies of your data somewhere safe (not in the installed program folder). -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get help?
Adrien, I might be wrong, but I thought he said the .png files were not showing. That would be a Windows setting so it knows what app to use to display them. I think he needs this link: https://answers.microsoft.com/en-us/windows/forum/windows_10-files-winpc/windows-10-will-not-open-png-files-or-let-me-save/ff1c2ff8-c470-4600-8779-a56a2dc382ff --Steve (a different one) On 08/03/2018 07:23 AM, Adrien Monteleone wrote: > Steve, > > You can view online, or download a copy of both the Help Guide and the > Tutorial and Concepts Guide from the GnuCash.org website. (see Documentation > link on the left) There is also a wiki for the app (also linked on the left > on the main GnuCash.org page) with tons of info. > > Regards, > Adrien > >> On Aug 2, 2018, at 10:12 PM, Steve Rollison wrote: >> >> The online help file says "The primary source of use support is the user >> mailing list" - which is the link I clicked on to send this e-mail message. >> If this is not correct, can you please tell me how to get help? I've >> searched everywhere I could try to get an online answer-even a general >> Google search-all to avail. GnuCash looks like an incredible program but I'm >> lost at step one since I can't use the built-in help file. >> >> >> >> None of the "GnuCash Tutorial and Concepts Guide" graphics (.png files) >> display on my computer. >> >> >> >> Here are the details on my PC (although I don't really know what you might >> need to answer my question). >> >> . GnuCash 3.2 just installed >> >> . ASUS laptop (advertised as a gaming machine, though I don't play >> games) >> >> . Windows 10 Home ver 1083, build 71734.165 >> >> . Intel Core i7 processor >> >> . 16GB RAM >> >> . Running 1920 x 1080 resolution >> >> . NVIDIA GeForce GTX 1050Ti video card >> >> >> >> Thank you so much for any help/direction you might be able to provide. >> >> >> >> Steve Rollison >> >> ___ >> 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. > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get help?
On 08/03/2018 03:56 AM, Liz wrote: > On Thu, 2 Aug 2018 23:12:54 -0400 > "Steve Rollison" wrote: > >> The online help file says "The primary source of use support is the >> user mailing list" - which is the link I clicked on to send this >> e-mail message. If this is not correct, can you please tell me how to >> get help? I've searched everywhere I could try to get an online >> answer-even a general Google search-all to avail. GnuCash looks like >> an incredible program but I'm lost at step one since I can't use the >> built-in help file. >> >> >> >> None of the "GnuCash Tutorial and Concepts Guide" graphics (.png >> files) display on my computer. >> >> >> >> Here are the details on my PC (although I don't really know what you >> might need to answer my question). >> >> . GnuCash 3.2 just installed >> >> . ASUS laptop (advertised as a gaming machine, though I don't >> play games) >> >> . Windows 10 Home ver 1083, build 71734.165 >> >> . Intel Core i7 processor >> >> . 16GB RAM >> >> . Running 1920 x 1080 resolution >> >> . NVIDIA GeForce GTX 1050Ti video card >> >> >> >> Thank you so much for any help/direction you might be able to provide. >> >> >> >> Steve Rollison >> > Yes this is the place. > I suggest you submit one question per email, and subscribe to the list > so you don't wait for your messages to get through. > > Liz And for the .png files not displaying on Windows (sorry, I run a Linux box), a google search brought up this link: https://answers.microsoft.com/en-us/windows/forum/windows_10-files-winpc/windows-10-will-not-open-png-files-or-let-me-save/ff1c2ff8-c470-4600-8779-a56a2dc382ff Welcome to the group. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Hangs on startup
On 08/03/2018 07:18 AM, Finbar Mahon wrote: > I don't have a P+L for 1/1/192020!! > > Hangs at this point, most times, sometimes loads the current operations. > > Ideas? First I would verify you really want to be that far in the future! (I suspect just a typo here). But, even for 1/1/2020 might be a problem. I've not tried going out past the end of the current year. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Payroll add-on, module, software?
On 07/29/2018 05:26 PM, Mike or Penny Novack wrote: > On 7/26/2018 11:21 AM, John Ralls wrote: > >>> or as a separate program that maintains all of the HR stuff and >>> just sends the financial transactions to GnuCash. > << Just back from camping in the woods >> > > THAT is the sense I meant, though I would not think of it as a "plug > in" but possibly one of several external programs that were keeping > their own sort of data (like Payroll having HR data; Inventory having > things like shelving location, reorder levels, alternate supply > vendors, one like POS sending feeds to both Accounting ad Inventory, > etc.) > > All sharing the same feed format << and each "make" dependent on THAT > but not each other, or for that matter gnucash except with regard to > the format of the feed >> > > However "feed format" goes two ways, also a common ERROR format by > which the (new) input edit component reports WHY a feed was rejected > (or part of a feed if on a transaction by transaction basis). > > Michael > > P Accounts Payable and Accounts Receivable are in a similar vein. In fact, they share a common feature with payroll in that they deal with 3rd party entities (Receivable -- entities who owe you money; Payable -- entities to whom you owe money; Payroll -- entities who get paid for a salary/wage). That common module of dealing with names/addresses and relationships could be abstracted out of all three modules and made a common service. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Payroll add-on, module, software?
On 07/30/2018 02:16 PM, Mike or Penny Novack wrote: > : > >>> Accounts Payable and Accounts Receivable are in a similar vein. In >>> fact, they share a common feature with payroll in that they deal with >>> 3rd party entities (Receivable -- entities who owe you money; >>> Payable -- >>> entities to whom you owe money; Payroll -- entities who get paid for a >>> salary/wage). That common module of dealing with names/addresses and >>> relationships could be abstracted out of all three modules and made a >>> common service. >>> >>> >>> -- >>> Stephen M Butler, PMP, PSM >>> stephen.m.butle...@gmail.com >>> kg...@arrl.net >>> 253-350-0166 > Oh dear. No, I would see them as VERY different. And very different > information being kept. > > When I have a payable I owe THAT person an amount. > > When I have a payroll event I owe THAT person something (some portion > of the gross amount), and according to information on that person's > record owe (for example) the Feds various amounts, the state various > amounts (and neither of the previous single accounts -- example, > income tax and SS and medicare separate; state income tax and state > workman's comp separate, etc. ) and possibly various other > entities/accounts. I am required (by many jurisdictions) not only that > amounts be correct but that the employee get a statement along with > that check (or direct deposit). Many/most of the amounts depend on > data on the HR record. > > Michael D Novack That portion is correct. However, you have to track their name and address which would be the same for A/P and A/R. That is the portion that could be abstracted out. And yes, I did write a payroll system once back in the late 70's using a two-level network database and a transactional language (not COBOL even though I have 20 years experience with that also). And I have been a database administrator/designer for a couple of decades. So, abstracting out sub-systems is in my blood. However, lest folks get any ideas of drafting me, all my languages are now considered old school and I'd have to learn C, C++, XML, etc. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Compile of 3.2 fails
On 08/03/2018 11:12 AM, Michael via gnucash-user wrote: > Thanks for the reply David, > > I am building in ~/build-32. Extracted tar file is in > ~/Downloads/Applications/gnucash-3.2. > > Command (from build-32) is 'cmake > -DCMAKE_INSTALL_PREFIX=$HOME/build-32 -DWITH_AQBANKING=OFF > ../Downloads/Applications/gnucash-3.2'. Then make (with '>& log.txt' > added). > Is this where you want the final installation to live? I let mine default to the usual system folders. I also wonder if you want the final install in the same folder to which cmake does the compile (which would be the current working directory which you identified as $HOME/build-32. Based on the log it is having trouble with -- [ 30%] Generating ../../lib/gnucash/scm/ccache/2.0/gnucash/core-utils.go There is this interesting line -- ice-9/boot-9.scm:109:20: Undefined variable: gnc-build-userdata-path So if you go up two levels from $HOME/build-32 should take you to the /home folder. Do you have a lib directory there? I have mine in a different folder ($HOME/Projects/GnuCash/gnucash-3.2 and I made a folder $HOME/Projects/GnuCash/mybuild and then did these commands: cd mybuild cmake ../gnucash-3.2 make sudo make install So, I think it wants you to have an empty folder at the same level as $HOME/Downloads/Applications/gnucash-32 (say $HOME/Downloads/Applications/Build-GC-3.2) and be sitting in that folder when you issue 'cmake -DCMAKE_INSTALL_PREFIX=$HOME/build-32 -DWITH_AQBANKING=OFF ../gnucash-3.2' Then staying there issue the 'make >& log.txt' then 'make install' (sudo not needed as you are doing it in your own work space). --Steve > Output of log.txt is attached. > > I have built on a similar machine, so I believe you are right that > something in the over dependencies is wrong although I followed the > same instructions from the wiki. Mike > > > On 08/03/2018 04:47 AM, David Cousens wrote: >> Mike, >> >> It may be possible that there is a dependency that cmake doesn't check >> for that may be missing. There would normally be an error message in >> the output somewhere just before the "recipe for target failed" >> message. If when you run make you use >> make >& log.txt >> you can dump the make output to a logfile and search it with the text >> editor (xed). The other alternative is to edit the preferences for the >> terminal and make sure the limit scrolllback checkbox is not set. You >> can copy terminal output by selecting it, right click and copy or use >> CTRL-Shift-C. >> >> If you can post the make output either directly (if not too long) or >> use a pastebin if it is very long, we should be able to help sort the >> problem. If you are using Nabble you can attach files or attach then to >> the email. >> >> It would also help if you post the commands you used to setup the build >> directory and the cmake command you used as the cmake command syntax is >> very sensitive to the relative positioning of the source and build >> directories. >> >> David Cousens -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] accounting for the market value of a fixed asset
On 08/05/2018 07:06 AM, BOSCH John(J) - BRUCE POWER wrote: > Hi: I'm having trouble setting up the accounts to reflect the scenario below: > > Fixed asset = 2015 Pickup truck purchased in June 2015 for $62000 > Liability = Current outstanding loan amount = $38000 > ?? = Current market value of the truck = Approx $45000 > > Since I'm just starting to use GNUcash I input the values thus: > > Fixed asset = 2015 truck: $45000 > Liability = Truck Loan: $38000 > > What happens is that I get an entry in the "imbalance" account of $7000 which > makes sense because the asset value doesn't match the loan amount. > > Question: How do I structure the accounts above to reflect that I have $7000 > worth of equity in the vehicle without it showing up in the imbalance account? > > Thanks in advance > > John You need an Equity Account to which the $7000 would be applied to make the entry balance. Remember, Assets = Liabilities + Equity. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] accounting for the market value of a fixed asset
On 08/05/2018 07:36 PM, David Cousens wrote: > Stephen, > > The translation from your simpler reply to my more complicated treatment > lies in the classification of Income and Expense accounts as temporary > Equity accounts whose values are transferred into a permanent Eqity account > as a profit or loss at the end of the accounting period and the expanded > accounting equation Assets=Liabilities +Equity+Income -Expenses > > David. > Sometimes I cut too much off in my haste to get to the bottom line! :-) -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] liability or expense
On 08/06/2018 01:59 PM, Baldero Mendoza wrote: > Please be patient with me - brand new to this. > > Household financial stuff. I want to post a "google play" purchase. > Should I post as an expense or a liability? > > I have accounts open for things like "electricity" and that seems to > work just fine, but "google play" looks like it works sort of like a > credit card, so I listed it under "liabilities", and that seems to > work too. I made the connected account "checking" and it all seems to > balance and work. > > However, what bothers me is that the "google play" entry under > "liabilities" is listed as a red negative number. So I have two red > negative numbers listed now, one under "liabilities" and one under > "google play". Everything balances, so is it okay or should I place > "google play" purchases as "expenses"? (I just started gnucash so > there aren't any credit card or debit card purchases yet.) The > "expenses" stuff gets listed as black positive numbers even though > they're an outflow of money just like the "google play" stuff under > "liabilities". Maybe it's optional and can be done either way? > Confusing. > > Thank you everybody! > ___ All of us were brand new at one point. I'm not much past that stage either. I'm not a CPA nor a book-keeper (though am married to an accountant and have written accounting software), so this is just my opinion. 1. I would make an expense category for "Software" rather than tying it to "Google Play" -- but that's just my approach. Would make it an expense though. 2. The Google Play items (at least some of mine) get charged off to your credit card. That would be a Liability account (short-term). 3. So, the two sides for the transaction (purchase) would be the expense (Software or Google Play) and CreditCardClearingAccount (Liability). 4. When you pay off the credit card, the transaction would be the CreditCardClearingAccount (to reduce toward zero) and the Checking Account (Asset) from which the payment was made. Hope this helps clarify your thinking. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Fwd: liability or expense
On 08/06/2018 02:14 PM, Graham Balin wrote: > Forwarded as I forgot to 'reply all'. Sorry. Newbie brain! > > Cheerio > > Graham > > -- Forwarded message - > From: Graham Balin > Date: Mon, 6 Aug 2018, 10:12 pm > Subject: Re: [GNC] liability or expense > To: Baldero Mendoza > > > I have found Gnucash to be a very powerful hammer to crack a very small nut > using it for domestic accounts only. Does the job well but there are > features of double entry bookkeeping that are superfluous. For example you > will have an expenses;groceries account that will be a mass of entries and > will never be reconciled because it is irrelevant.just ignore it. It is > there to help you categorise your spending. Well, you can reconcile it if > you want to spend half your life on your accounts! > I'm into my 3rd month and haven't done any reports yet. Just pleased that > all bank accounts and liabilities (credit cards)are balanced and > reconciled. Investments are taking a bit longer to get my head around. > Good luck! > > Cheerio > > Graham You typically don't reconcile expense accounts. You can go through a year-end process that will "zero" the expense/income accounts and update equity (or whatever you want) via a year-end offsetting transaction. It's nice if you want the equity account updated annually. > On Mon, 6 Aug 2018, 10:02 pm Baldero Mendoza, wrote: > >> Please be patient with me - brand new to this. >> >> Household financial stuff. I want to post a "google play" purchase. >> Should I post as an expense or a liability? >> >> I have accounts open for things like "electricity" and that seems to >> work just fine, but "google play" looks like it works sort of like a >> credit card, so I listed it under "liabilities", and that seems to >> work too. I made the connected account "checking" and it all seems to >> balance and work. >> >> However, what bothers me is that the "google play" entry under >> "liabilities" is listed as a red negative number. So I have two red >> negative numbers listed now, one under "liabilities" and one under >> "google play". Everything balances, so is it okay or should I place >> "google play" purchases as "expenses"? (I just started gnucash so >> there aren't any credit card or debit card purchases yet.) The >> "expenses" stuff gets listed as black positive numbers even though >> they're an outflow of money just like the "google play" stuff under >> "liabilities". Maybe it's optional and can be done either way? >> Confusing. >> >> Thank you everybody! -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] liability or expense
On 08/06/2018 02:27 PM, Adrien Monteleone wrote: > Certainly, if you have a card tied to the account and you are charged for > each purchase on the spot, then no need for the mess I described. > > When you purchase: > > Dr. Expenses:Entertainment (software, whatever) > Cr. Credit Card (the one that will be charged) > > Use ‘Google Play’ as the Description for the transaction and the actual title > purchased as either the Note or the Memo on the expense split. > > When entering expenses, I generally use the Description field for the > ‘Vendor’ being paid. (who I purchased from) > > Otherwise, when you pay the credit card bill, that’s like any other > situation, as Google Play is no longer part of the equation as Stephen noted. > > Regards, > Adrien That's the "fun" side of accounting. So many ways to do the same thing. Only your CPA knows for sure how you should do it -- and that's because it will be how s/he wants it done. > >> On Aug 6, 2018, at 4:20 PM, Stephen M. Butler wrote: >> >> On 08/06/2018 01:59 PM, Baldero Mendoza wrote: >>> Please be patient with me - brand new to this. >>> >>> Household financial stuff. I want to post a "google play" purchase. >>> Should I post as an expense or a liability? >>> >>> I have accounts open for things like "electricity" and that seems to >>> work just fine, but "google play" looks like it works sort of like a >>> credit card, so I listed it under "liabilities", and that seems to >>> work too. I made the connected account "checking" and it all seems to >>> balance and work. >>> >>> However, what bothers me is that the "google play" entry under >>> "liabilities" is listed as a red negative number. So I have two red >>> negative numbers listed now, one under "liabilities" and one under >>> "google play". Everything balances, so is it okay or should I place >>> "google play" purchases as "expenses"? (I just started gnucash so >>> there aren't any credit card or debit card purchases yet.) The >>> "expenses" stuff gets listed as black positive numbers even though >>> they're an outflow of money just like the "google play" stuff under >>> "liabilities". Maybe it's optional and can be done either way? >>> Confusing. >>> >>> Thank you everybody! >>> ___ >> All of us were brand new at one point. I'm not much past that stage >> either. >> >> I'm not a CPA nor a book-keeper (though am married to an accountant and >> have written accounting software), so this is just my opinion. >> >> 1. I would make an expense category for "Software" rather than tying it >> to "Google Play" -- but that's just my approach. Would make it an >> expense though. >> >> 2. The Google Play items (at least some of mine) get charged off to >> your credit card. That would be a Liability account (short-term). >> >> 3. So, the two sides for the transaction (purchase) would be the >> expense (Software or Google Play) and CreditCardClearingAccount (Liability). >> >> 4. When you pay off the credit card, the transaction would be the >> CreditCardClearingAccount (to reduce toward zero) and the Checking >> Account (Asset) from which the payment was made. >> >> Hope this helps clarify your thinking. >> -- >> Stephen M Butler, PMP, PSM >> stephen.m.butle...@gmail.com >> kg...@arrl.net >> 253-350-0166 >> --- >> GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] keeping entities separate
On 08/13/2018 08:28 AM, Adrien Monteleone wrote: > The learning curve is infinite, it just flattens out with occasional small > bumps. > > Before proceeding any further - talk to a local CPA about your specific > situation. And chat with your attorney about how much asset protection you need between you and the businesses (and between each business). That may also dictate how much effort you need to expend to keep them separate (or co-mingled). > Generally though, are they legally separate entities that you file separate > tax returns for? Then you likely want to separate them. If they are > pass-throughs and you file everything on personal tax forms, you most likely > want them in the same file. > > As Michael noted, you can structurally segregate or simply ’tag’ your > business transactions for your own sanity and internal reporting purposes but > this will require a well thought out plan and the discipline to not co-mingle > business transactions with personal. > > If you need to separate these transactions into individual books, I’d say you > need to structurally separate them using specialized accounts or account > trees, then exporting the accounts/tree for each entity and then importing > them into blank books accordingly. Some data might have to be manually > entered, or take a round trip through a spreadsheet as not everything is > easily exportable. (customers and vendors come to mind) > > So the process of dividing into multiple books starts with arranging the > single book as if you’d keep it all together anyway. > > After you talk to your CPA and you decide on a course of action, we can of > course assist with describing the options and methods and point you in the > right direction. > > Regards, > Adrien > >> On Aug 13, 2018, at 7:52 AM, patrushkha via gnucash-user >> wrote: >> >> I just started using Gnucash and thought I'd gotten through the learning >> curve; I have 2 small businesses and entered both of them as well as my >> personal data, but discovered they are all mixed together. At least I think >> so, I'm not versed enough to understand how I got there or how to untangle >> entities. >> Can anyone suggest a process to separate them OR do I have to start all >> over? >> >> I'm also willing to hire someone to get me on track- Los Angeles area. >> >> Thank you so much, >> Pat >> ___ >> 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] keeping entities separate
On 08/13/2018 05:52 AM, patrushkha via gnucash-user wrote: > I just started using Gnucash and thought I'd gotten through the learning > curve; I have 2 small businesses and entered both of them as well as my > personal data, but discovered they are all mixed together. At least I think > so, I'm not versed enough to understand how I got there or how to untangle > entities. > Can anyone suggest a process to separate them OR do I have to start all over? > > I'm also willing to hire someone to get me on track- Los Angeles area. > > Thank you so much, > Pat I also have a small business that has its own bank account, loan, income, expense. I keep a separate file and don't mingle it with my personal books. This helps now that I'm selling it. However, it has a small price to enter transfers from personal to business and versus into both books. It my personal side its between two assets (my banking and my LLC ownership). On the business books it goes between the business bank account and an equity account (my equity in the business). If these are more like small hobbies, then you might dedicate some expense/income accounts just for the hobby to use and mingle everything else. Note that if you are seeking "corporate shield" for your business activities then you need to keep a separate set of books and bank accounts. Otherwise, at least here in the USA, the courts will "pierce the veil" and hold you personally liable for actions of the business. That was important for me as my LLC owned an apartment building. If something bad where to happen there, I might lose the apartment building but I should be able to protect my personal assets. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] File Format Documentation (Bug 777893)
On 08/14/2018 10:09 PM, David T. wrote: > Stephen, > > >> On Aug 14, 2018, at 4:50 PM, Stephen M. Butler wrote: >> >> On 08/14/2018 04:24 PM, David T. wrote: >>> Steve, >>> >>> Thanks for your input. I believe we’re in agreement here; I wasn’t trying >>> to suggest that GC become a DBMS, but rather it would learn to utilize DBMS >>> features that many seem to expect. >>> >>> I’m not great with the appropriate terminology to use. Do you have language >>> I could use that would more accurately reflect the direction that GC is >>> headed? >>> >>> David >> I hoped as much. Let's take this pair of sentences: >> >> Use of SQL formats for storage implies to many that GnuCash is database >> management software (DBMS). While that is a long term goal of the >> development team, GnuCash as currently designed is not DBMS. >> >> And change them to this: >> >> Use of a SQL back-end engine for storage implies to many that GnuCash >> has fully implemented DBMS features including multi-user and incremental >> data manipulation. That is a long-term goal of the development team. >> However GnuCash does not currently implement these features. >> > This is great; I will use it. > >> Then I think this next section can disappear entirely: >> >> Many features that users of DBMS expect from a DBMS are not implemented in >> GnuCash. The GnuCash data schema is not normalized. Significant elements of >> the data logic is implemented in code, rather than data structure. >> Gnucash uses the SQL back end to load the entire data store into memory in >> the same manner as the XML back end. Consequently, use of the SQL back end >> does not enable simultaneous multi-user access to a GnuCash file, although >> that is one long term goal. >> > I’m not sure I want to remove these comments, as they are issues of > significance that have come up on the lists over the years. How about this: > > The GnuCash data schema is not normalized. Moreover, significant elements of > the data logic is implemented in code, rather than data structure. Finally, > Gnucash uses the SQL back end to load the entire data store into memory in > the same manner as the XML back end. Consequently, use of the SQL back end > does not enable simultaneous multi-user access to a GnuCash file. > >> And I will change this piece: >> >> One benefit of the SQL back end is that it saves changes incrementally, and >> every change is committed to the back end as it happens. This is in contrast >> to the XML back end, which only writes to the data file when the user >> invokes the Save command. >> >> To say: >> One benefit of the SQL back end is that it saves changes to the back end as >> they happen. This is in contrast to the XML back end, which only writes to >> the data file when the user invokes the Save command. > How about: > One benefit of the SQL back end is that it commits changes to the file > immediately. This is in contrast to the XML back end, which only writes to > the data file when the user invokes the Save command. > > The final result for this section is this: > ——— > Use of a SQL back-end engine for storage implies to many that GnuCash has > fully implemented DBMS features including multi-user and incremental data > manipulation. That is a long-term goal of the development team. However > GnuCash does not currently implement these features. > The GnuCash data schema is not normalized. Moreover, significant elements of > the data logic is implemented in code, rather than data structure. Finally, > Gnucash uses the SQL back end to load the entire data store into memory in > the same manner as the XML back end. Consequently, use of the SQL back end > does not enable simultaneous multi-user access to a GnuCash file. > One benefit of the SQL back end is that it commits changes to the file > immediately. This is in contrast to the XML back end, which only writes to > the data file when the user invokes the Save command. > ——— > > Better? > David Yes, that fixes the problems I saw and conveys the important pieces the user needs to know. Thanks. Steve >> >> Hope this helps. >> >> --Steve >> >>>> On Aug 14, 2018, at 3:50 PM, Stephen M. Butler wrote: >>>> >>>> On 08/14/2018 03:05 PM, David T. via gnucash-user wrote: >>>>> Hello, >>>>> >>>>> In response to Bug 777893 >>>>> (https://bugs.gnucash.org/show_bug.cgi?id=777893 >>>>> <https://bugs.gnucash.org/sho
Re: [GNC] File Format Documentation (Bug 777893)
On 08/14/2018 04:24 PM, David T. wrote: > Steve, > > Thanks for your input. I believe we’re in agreement here; I wasn’t trying to > suggest that GC become a DBMS, but rather it would learn to utilize DBMS > features that many seem to expect. > > I’m not great with the appropriate terminology to use. Do you have language I > could use that would more accurately reflect the direction that GC is headed? > > David I hoped as much. Let's take this pair of sentences: Use of SQL formats for storage implies to many that GnuCash is database management software (DBMS). While that is a long term goal of the development team, GnuCash as currently designed is not DBMS. And change them to this: Use of a SQL back-end engine for storage implies to many that GnuCash has fully implemented DBMS features including multi-user and incremental data manipulation. That is a long-term goal of the development team. However GnuCash does not currently implement these features. Then I think this next section can disappear entirely: Many features that users of DBMS expect from a DBMS are not implemented in GnuCash. The GnuCash data schema is not normalized. Significant elements of the data logic is implemented in code, rather than data structure. Gnucash uses the SQL back end to load the entire data store into memory in the same manner as the XML back end. Consequently, use of the SQL back end does not enable simultaneous multi-user access to a GnuCash file, although that is one long term goal. And I will change this piece: One benefit of the SQL back end is that it saves changes incrementally, and every change is committed to the back end as it happens. This is in contrast to the XML back end, which only writes to the data file when the user invokes the Save command. To say: One benefit of the SQL back end is that it saves changes to the back end as they happen. This is in contrast to the XML back end, which only writes to the data file when the user invokes the Save command. Hope this helps. --Steve > >> On Aug 14, 2018, at 3:50 PM, Stephen M. Butler wrote: >> >> On 08/14/2018 03:05 PM, David T. via gnucash-user wrote: >>> Hello, >>> >>> In response to Bug 777893 (https://bugs.gnucash.org/show_bug.cgi?id=777893 >>> <https://bugs.gnucash.org/show_bug.cgi?id=777893>), I have written a more >>> detailed description of the storage choices available to users for >>> insertion into the Tutorial & Concepts Guide at section 2.5. Given the >>> extent of the text, I am including it here so that the broader community >>> can offer suggestions for improvement. Note that I will insert appropriate >>> encoding once I finalize the content. >>> >>> Thanks, >>> David T. >>> >>> >>> Proposed text for Tutorial & Concepts Guide section 2.5 >>> >>> >>> 2.5 Storing your financial data >>> 2.5.1 Overview >>> GnuCash offers several formats for storing your financial data. The default >>> file storage format is XML, while a number of flavors of SQL storage are >>> available. Users can choose a file format from the File Save and File Save >>> As dialogs. >>> The primary GnuCash storage format is an XML file. The file is by default >>> compressed with gzip, which is a preference that is set at >>> Edit→Preferences→General→Use file compression. >>> GnuCash also supports SQL storage via the DBI back end. It supports >>> PostgreSQL, MySQL and SQLite3 databases. >>> >>> Storage Comparison >>> As noted, GnuCash allows storage in either XML or SQL formats. Each of >>> these formats has benefits and shortcomings that the user should consider >>> for their needs and abilities. >>> The XML format is the most stable and established format, and for this >>> reason, it is the recommended format for most users. SQL storage was added >>> for the 2.4 release and has become an increasingly popular choice for users. >>> Use of SQL formats for storage implies to many that GnuCash is database >>> management software (DBMS). While that is a long term goal of the >>> development team, GnuCash as currently designed is not DBMS. It is a >>> financial application that can store its data in SQL files. >> I would strongly suggest that GnuCash never (triple underscore) become a >> DBMS engine. I would encourage it to be an application that uses a >> strong DBMS engine (which it already does) as a back-end and that the >> team would apply data normalization and multi-user techniques to the >> front-end application. >> >> Note the
Re: [GNC] File Format Documentation (Bug 777893)
On 08/14/2018 03:05 PM, David T. via gnucash-user wrote: > Hello, > > In response to Bug 777893 (https://bugs.gnucash.org/show_bug.cgi?id=777893 > <https://bugs.gnucash.org/show_bug.cgi?id=777893>), I have written a more > detailed description of the storage choices available to users for insertion > into the Tutorial & Concepts Guide at section 2.5. Given the extent of the > text, I am including it here so that the broader community can offer > suggestions for improvement. Note that I will insert appropriate encoding > once I finalize the content. > > Thanks, > David T. > > > Proposed text for Tutorial & Concepts Guide section 2.5 > > > 2.5 Storing your financial data > 2.5.1 Overview > GnuCash offers several formats for storing your financial data. The default > file storage format is XML, while a number of flavors of SQL storage are > available. Users can choose a file format from the File Save and File Save As > dialogs. > The primary GnuCash storage format is an XML file. The file is by default > compressed with gzip, which is a preference that is set at > Edit→Preferences→General→Use file compression. > GnuCash also supports SQL storage via the DBI back end. It supports > PostgreSQL, MySQL and SQLite3 databases. > > Storage Comparison > As noted, GnuCash allows storage in either XML or SQL formats. Each of these > formats has benefits and shortcomings that the user should consider for their > needs and abilities. > The XML format is the most stable and established format, and for this > reason, it is the recommended format for most users. SQL storage was added > for the 2.4 release and has become an increasingly popular choice for users. > Use of SQL formats for storage implies to many that GnuCash is database > management software (DBMS). While that is a long term goal of the development > team, GnuCash as currently designed is not DBMS. It is a financial > application that can store its data in SQL files. I would strongly suggest that GnuCash never (triple underscore) become a DBMS engine. I would encourage it to be an application that uses a strong DBMS engine (which it already does) as a back-end and that the team would apply data normalization and multi-user techniques to the front-end application. Note the difference between a front-end application and the back-end DBMS engine. --Steve (retired Oracle DBA and former application developer) > Many features that users of DBMS expect from a DBMS are not implemented in > GnuCash. The GnuCash data schema is not normalized. Significant elements of > the data logic is implemented in code, rather than data structure. > Gnucash uses the SQL back end to load the entire data store into memory in > the same manner as the XML back end. Consequently, use of the SQL back end > does not enable simultaneous multi-user access to a GnuCash file, although > that is one long term goal. > One benefit of the SQL back end is that it saves changes incrementally, and > every change is committed to the back end as it happens. This is in contrast > to the XML back end, which only writes to the data file when the user invokes > the Save command. > The SQL back end does allow users with SQL experience to write queries > against the data to create custom reports without using Gnucash’s internal > report system. It is important to note that modification of GnuCash data > using external access modes is strongly discouraged by the development team, > and damages to a GnuCash data file that result from such modifications are > strictly the responsibility of the user. > > Storage Comparison Table > > XML SQL > Default Optional > Requires no additional software Requires additional software > Requires no additional expertise Requires expertise with DBMS > CompressedUncompressed > Save on command Save on commit > Uses log filesDoes not use log files > Not multi-userNot multi-user > Limited external processing External processing through SQL queries > > > ___ > 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. >
Re: [GNC] File Format Documentation (Bug 777893)
case both XML) >>>>>> However, the file extension used is “gnucash” and not “xml” >>>>> Facepalm. I forgot about that. (I honestly rarely even look at the >>>>> location where it’s stored anyway) I’d suspect unless Win10 uses the file >>>>> descriptor for file type instead of the extension as was the practice >>>>> through at least Win7, then no, those users won’t see XML anywhere. (if >>>>> the descriptor is set as XML that is) >>>>> >>>>> So I just checked on both MacOS and Ubuntu, MacOS reports the ‘Kind’ as >>>>> ‘Gnucash Document’ regardless if sqlite or xml, and at least with xml, >>>>> Ubuntu reports the file type as ’spreadsheet’. (yes, it’s registered to >>>>> open with GnuCash, but this was built from source, so perhaps the file >>>>> type was not registered properly, repo versions may vary) >>>>> >>>>> So I guess on that point I was way off. >>>>> >>>>> >>>>>> Perhaps the save process needs to be refactored to identify clearly and >>>>>> separately the name of the data file AND its format? >>>>> Since .gnucash is not really proprietary or somehow a special format from >>>>> XML then I agree, the extension should be .xml. >>>>> >>>>> Combine this with the fact that the sqlite version of the file ALSO uses >>>>> the .gnucash extension can make for some confusion. At a glance, you >>>>> can’t tell what the format is. You can’t even tell until you try to open >>>>> it with something other than GnuCash. (or you notice that GnuCash doesn’t >>>>> offer a Save option) The only reason I know which is which is I had to >>>>> use filename.xml.gnucash to tell them apart. That’s a usability bug in my >>>>> opinion. I don’t know how hard that is to change, but I’d support the >>>>> move. >>>>> >>>>> On that note, the documentation somewhere (I suppose in the ‘file > >>>>> save/save as’ section) should document that the extension is currently >>>>> ‘.gnucash’. A new user shouldn’t have to go to a wiki or website FAQ >>>>> after reading the documentation for something this basic. >>>>> >>>>> Would it be out of order to include in your table that both use this >>>>> extension? If you expand the table to show MySQL and Postgres, I suppose >>>>> that row would have some other note since their data stores are very >>>>> different than single files. (though in this case they might store it >>>>> that way, I haven’t used either to know) >>>>> >>>>> Regards, >>>>> Adrien >>>>> >>>>> >>>>>>> Knowing this might very well help them find their file if they know the >>>>>>> format they are looking for. >>>>>>> >>>>>>> But I do agree, the documentation should cover where files are stored. >>>>>>> Ideally, this should be made part of the Help or Guide in the Getting >>>>>>> Started section. It is certainly a common enough issue on the list. >>>>>>> >>>>>>> Regards, >>>>>>> Adrien >>>>>>> >>>>>>>> On Aug 15, 2018, at 10:24 AM, Christoph R >>>>>>>> wrote: >>>>>>>> >>>>>>>> Hi David, >>>>>>>> >>>>>>>>> The default file storage format is XML >>>>>>>> I would not call this “XML" but "plain file”. From a user perspective >>>>>>>> it is not important in which internal format it is stored. But it >>>>>>>> makes a big difference if it is a simple file created by Gnucash or if >>>>>>>> Gnucash needs to connect to a DBMS. >>>>>>>> >>>>>>>> And one of the biggest confusion for users on the mailing list is the >>>>>>>> question: “Where is my data?”. Pointing out that all your accounts and >>>>>>>> transactions are in a simple file might reduce that problem. >>>>>>>> >>>>>>>> Cheers, >>>>>>>> Christoph >>>>>>>> >>>>>> >>>>> -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Going Back to Go Forward?
On 08/06/2018 09:09 PM, David Carlson wrote: > I would consider needing to close and reopen a bank account register after > each transaction edit executed by pasting some text from the clipboard to > be a major showstopper when I have ten or twenty transaction s a day. > > David C And for me the backspace key doesn't work. So, I avoid pasting (but I can touch type enough to shock my mother-in-law who taught keyboarding in high school). > On Mon, Aug 6, 2018, 10:42 PM Michael via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> I guess I hadn't tried to do a paste into a transaction. I see what >> you mean, although I didn't need to restart gnucash to recover. While >> I was typing the answer came from David Reiser that it will be fixed >> when 3.3 comes out. Mike >> >> On Mon, Aug 6, 2018 at 8:12 PM, Thomas Forrester >> wrote: >>> Well, in particular, what I mentioned in the original post: once you >>> use >>> the clipboard to paste into a transaction, all further editing of >>> that. or >>> apparently anything else is just not going to happen until you >>> restart the >>> program. To me, that's about the biggest show-stopper I could ever >>> consider with *any* program - having to restart it all the time just >>> to get >>> it working again. I should think this massive problem would have been >>> corrected almost immediately given the magnitude of the inconvenience >>> it >>> causes, but it has been quite a while and I have no clue how long it >>> will >>> take. >>> >>> If someone can tell me it's already been fixed and there is a 3.2.1 >>> (or >>> whatever) release due any second now, great! I'll wait it out. But >>> a few >>> more months till something happens, well, um... >>> >>> On Mon, Aug 6, 2018 at 11:18 AM Adrien Monteleone < >>> adrien.montele...@lusfiber.net> wrote: >>> >>>> You may not get a warning or alert! >>>> >>>> Also, yes, at the very least the date/time stamps are different and >>>> this >>>> is particularly an issue with the MySQL backend if I recall >>>> correctly. I >>>> wouldn’t attempt to step back any further than 2.6.21, but I’d >>>> ask, what in >>>> particular are you finding that you need to step back for? >>>> >>>> There were some early issues with data but those seem to have been >>>> solved >>>> by 3.2. (I’m using the sqlite3 backend, and had to switch to XML >>>> during the >>>> interim but am back to normal with the 3.2 release) Sure there are >>>> a few >>>> annoyances with the 3.x series so far, but those are being worked >>>> out. >>>> >>>> Regards, >>>> Adrien >>>> >>>> > On Aug 6, 2018, at 10:15 AM, Thomas Forrester >>>> >>>> wrote: >>>> > >>>> > Thanks, Mike. >>>> > >>>> > So from what you are saying, there is some sort of data >>>> structures check >>>> > that would alert me if I am using a version of the program that is >>>> > incompatible with the data version. Checking my downloads, I >>>> find I have >>>> > the .21 installer which I wouldn't have unless I had installed >>>> that >>>> > version. So Looks like I may be good to take a step back. >>>> > >>>> > Maybe a corollary question then - although backward compatible >>>> with a >>>> .21 >>>> > database, does 3.x introduce any new changes to the data >>>> structures that >>>> > would make this a really bad idea? >>>> > >>>> > On Mon, Aug 6, 2018 at 9:26 AM Michael wrote: >>>> > >>>> >> It is my understanding that 2.6.21 is the only 2.6.x that is >>>> compatible >>>> >> with the 3.2 data structure. I have used 2.6.21 successfully >>>> with 3.2 >>>> >> data, but older 2.6.x report that they are not compatible. I >>>> believe >>>> that >>>> >> is true of xml and sql databases. Mike >>>> >> >>>> >> On Mon, Aug 6, 2018 at 4:17 AM, Thomas Forrester >>>> >>> > >>>> >> wrote: >>>> >> >>>> >> On a Windows computer, I upgraded to 3.2 from 2
Re: [GNC] liability or expense
On 08/06/2018 11:15 PM, Baldero Mendoza wrote: > Wow, what a great help group! Lots of great advice from many > knowledgeable people. > > I settled on making an expense account out of google play > ("Google_play_stuff") and matching it to a checking account, skipping > the credit card part since, with me, that is always transitory and > instantaneous anyway. (Hope that doesn't bite me down the road.) > > Maybe it's unimportant but I do like not having those red negative > numbers on the accounts, even if everything does seem to balance. > > Thanks everybody! Also, I hope I did the "cc" thing correctly. And another way to treat Google Play -- like a debit card that directly hits the checking! > On Mon, Aug 6, 2018 at 5:50 PM, Stephen M. Butler wrote: >> On 08/06/2018 02:27 PM, Adrien Monteleone wrote: >>> Certainly, if you have a card tied to the account and you are charged for >>> each purchase on the spot, then no need for the mess I described. >>> >>> When you purchase: >>> >>> Dr. Expenses:Entertainment (software, whatever) >>> Cr. Credit Card (the one that will be charged) >>> >>> Use ‘Google Play’ as the Description for the transaction and the actual >>> title purchased as either the Note or the Memo on the expense split. >>> >>> When entering expenses, I generally use the Description field for the >>> ‘Vendor’ being paid. (who I purchased from) >>> >>> Otherwise, when you pay the credit card bill, that’s like any other >>> situation, as Google Play is no longer part of the equation as Stephen >>> noted. >>> >>> Regards, >>> Adrien >> That's the "fun" side of accounting. So many ways to do the same >> thing. Only your CPA knows for sure how you should do it -- and that's >> because it will be how s/he wants it done. >> >>>> On Aug 6, 2018, at 4:20 PM, Stephen M. Butler wrote: >>>> >>>> On 08/06/2018 01:59 PM, Baldero Mendoza wrote: >>>>> Please be patient with me - brand new to this. >>>>> >>>>> Household financial stuff. I want to post a "google play" purchase. >>>>> Should I post as an expense or a liability? >>>>> >>>>> I have accounts open for things like "electricity" and that seems to >>>>> work just fine, but "google play" looks like it works sort of like a >>>>> credit card, so I listed it under "liabilities", and that seems to >>>>> work too. I made the connected account "checking" and it all seems to >>>>> balance and work. >>>>> >>>>> However, what bothers me is that the "google play" entry under >>>>> "liabilities" is listed as a red negative number. So I have two red >>>>> negative numbers listed now, one under "liabilities" and one under >>>>> "google play". Everything balances, so is it okay or should I place >>>>> "google play" purchases as "expenses"? (I just started gnucash so >>>>> there aren't any credit card or debit card purchases yet.) The >>>>> "expenses" stuff gets listed as black positive numbers even though >>>>> they're an outflow of money just like the "google play" stuff under >>>>> "liabilities". Maybe it's optional and can be done either way? >>>>> Confusing. >>>>> >>>>> Thank you everybody! >>>>> ___ >>>> All of us were brand new at one point. I'm not much past that stage >>>> either. >>>> >>>> I'm not a CPA nor a book-keeper (though am married to an accountant and >>>> have written accounting software), so this is just my opinion. >>>> >>>> 1. I would make an expense category for "Software" rather than tying it >>>> to "Google Play" -- but that's just my approach. Would make it an >>>> expense though. >>>> >>>> 2. The Google Play items (at least some of mine) get charged off to >>>> your credit card. That would be a Liability account (short-term). >>>> >>>> 3. So, the two sides for the transaction (purchase) would be the >>>> expense (Software or Google Play) and CreditCardClearingAccount >>>> (Liability). >>>> >>>> 4. When you pay off the credit card, the transaction would be the >>>> CreditCardClearingAccount (to reduce toward zero) and the Checking >>>> Account (Asset) from which the payment was made. >>>> >>>> Hope this helps clarify your thinking. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] keeping entities separate
On 08/13/2018 10:28 PM, patrushkha via gnucash-user wrote: > Thanks for responding. I am clear that I want to have all the entities > separate- I thought I had set them up that way, but cannot discern how to > access them individually, and that's why I think I might have missed > something in the initial set up and that they are combined. You will need to have three separate file names. Could be in the same folder but I put mine in different folders. You may need to dump the transactions as a csv file and use a spreadsheet to break them into three different csv files to import to the new files. Others on here may have other shortcuts to break this apart. > > -Original Message- > From: Mike or Penny Novack > To: gnucash-user > Sent: Mon, Aug 13, 2018 6:54 am > Subject: Re: [GNC] keeping entities separate > > On 8/13/2018 8:52 AM, patrushkha via gnucash-user wrote: >> I just started using Gnucash and thought I'd gotten through the learning >> curve; I have 2 small businesses and entered both of them as well as my >> personal data, but discovered they are all mixed together. At least I think >> so, I'm not versed enough to understand how I got there or how to untangle >> entities. >> Can anyone suggest a process to separate them OR do I have to start all over? >> >> I'm also willing to hire someone to get me on track- Los Angeles area. >> >> Thank you so much, >> Pat > Oh dear. You are describing THREE entities here so ideally you should > want to have three sets of books If you are showing somebody the set of > books for one of the businesses (say you are selling it) no reason for > this prospective buyer to see anything about the other business or your > personal finances. > > I can't tell you whether better literally to start over or to > disentangle (temporarily having FOUR sets of books). There are other > questions you need to answer. For example, do these businesses have > their own bank accounts? Or are you perforce going to remain somewhat > entangled. > > Michael D Novack > > PS: If one or both of these "businesses" are small/minor it WOULD be > possible to carry them within your main personal books. And still be > able to see/report on each separately. BUT be advised that the chances > of error would be very high because neither gnucash nor any other > bookkeeping system would prevent you from entering a transaction in the > wrong place. > > > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 3 in the Debian / Ubuntu pipeline?
On 08/21/2018 03:11 PM, GWB wrote: > As Bert pointed out, if you can use Debian unstable, the version is 3.2: > > << > Source Package: gnucash (1:3.2-1) > from https://packages.debian.org/source/unstable/gnucash > > Ironically, I usually find Debian unstable to be, in fact, more stable > than the "stable" version of some other distros. But Debian will tell > you otherwise: > > https://www.debian.org/releases/sid/ > > Listen to Debian in this case, especially since it's your financial > data. So using the Ubuntu naming method, think of Sid Unstable as > "Sid Vicious", and expect lots of crashes, core dumps, and other nasty > things to occur when you're using gnucash. They won't be caused by > gnucash, but they will affect what you're trying to do. > > If you can navigate that and work around the instability, give it a > try. I'm OK with 2.6.whatever until Ubuntu 18 gets 3. > > Gordon I have been running Ubuntu 18.04 for some time and have found it to be fine for my business and personal use. In addition, I downloaded 3.2 source when it was announced and compiled it. Some problems but nothing that hurt my data. Currently I have 3.2-100 (a patch set) pulled down from github and that solves the data entry problems I was experiencing. If you are comfortable compiling the code (isn't that hard once the dependencies are installed) then the group here will help if you run into error conditions. --Steve > > On Tue, Aug 21, 2018 at 4:55 PM, GWB wrote: >> I'm not sure how the version history works in Ubuntu or Debian, but I >> installed GnuCash 2.6.7 from getdeb.org quite a while ago, and >> "pinned" it (so that apt-get upgrade would not go to the version up) >> to that version hoping that gnucash in Ubuntu 14 would catch up with >> 2.6.7. Ubuntu 14 ("Trusty Tahr") still only has 2.6.1, but 18.04 >> ("Bionic Beaver" really? who comes up with these names?) has indeed >> included 2.16.19, as John recalled. 18.04 is my next upgrade. >> >> Every time I run "apt-get update" I am reminded that getdeb.org is >> gone, and has been for some time. Did getdeb.org have gnucash 3.0 at >> some point before it went dark? >> >> I don't see either the Ubuntu or Debian package maintainers (perhaps >> the same person or team in this case) moving too quickly to upgrade >> gnucash in their package repos. But maybe I'm wrong, which would be >> nice. But if you do find a repository with 3.x.x, I would pin it (or >> "version lock") to a lower version in order not to get too far ahead >> of the main repos for your linux distribution. >> >> Alas, 18.10 ("Cosmic Cuttlefish") lists: >> >> gnucash (1:2.6.19-1) >> [universe]personal and small-business financial-accounting software >> >> at https://packages.ubuntu.com/cosmic/gnome/ >> >> Perhaps 19 ("Vomiting Vole") will have gnucash 3. Until then, check >> for other repos, look in unstable and testing to see if some >> adventurous soul decided to be creative, and unless you absolutely >> need some feature in the latest release, pin your version and don't >> get too far ahead of the main repo for your distribution. >> >> Gordon >> >> On Mon, Aug 20, 2018 at 7:41 PM, Lincoln A Baxter >> wrote: >>> Just curious... It has been almost a year since Gnucash was removed to >>> Debian testing. >>> >>> It has (re)entered SID on 7/4, and there it sits... >>> >>> Who is responsible for working on the "excuses" for why is stays in >>> SID: https://tracker.debian.org/pkg/gnucash, and has not migrated to >>> Testing? >>> >>> Lincoln >>> >>> >>> On Thu, 2018-07-05 at 00:39 -0600, Bert Riding wrote: >>>> I spoke too soon. 1:3.2-1 is now out in the unstable Debian repo. >>>> >>>> On Thu, 5 Jul 2018 12:52:51 +0800 >>>> Plutocrat wrote: >>>> >>>>> Hi, >>>>> >>>>> I've been troubled by the lack of Gnucash activity in Debian/Ubuntu >>>>> repositories. I previously used getdeb, which went silent around >>>>> September 2017. I tried contacting the owners, but no reply. There >>>>> was also an attempt on Launchpad to provided more recent versions via >>>>> a PPA, but that also went inactive a few years back. Again I tried to >>>>> contact the owners, but no response. And the main repos are stuck on >>>>> 2.6 >>>>> >>>>> So for the last week or so
[GNC] Balsheet-eg.scm problem
When I load gnucash the below messages come out. However, I can't find references to "business-reports" in the code. I also don't see it in evel-string.scm (in the ice-9 folder). Ideas? sudo find / -name eval-string.scm [sudo] password for steve: /usr/share/guile/2.0/ice-9/eval-string.scm find: ‘/run/user/1000/gvfs’: Permission denied gnucash --logto=stdout (gnucash:11506): Gtk-WARNING **: 22:02:10.785: Theme parsing error: gtk.css:1278:13: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' (gnucash:11506): Gtk-WARNING **: 22:02:10.785: Theme parsing error: gtk.css:1281:15: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' <> ;;; note: source file /usr/local/share/gnucash/scm/gnucash/report/balsheet-eg.scm ;;; newer than compiled /usr/local/lib/gnucash/scm/ccache/2.0/gnucash/report/balsheet-eg.go ;;; found fresh local cache at /home/steve/.cache/guile/ccache/2.0-LE-8-2.0/usr/local/share/gnucash/scm/gnucash/report/balsheet-eg.scm.go Backtrace: In ice-9/eval-string.scm: 37: 19 [lp (use-modules (gnucash report business-reports))] In ice-9/eval.scm: 505: 18 [# (use-modules #)] In ice-9/psyntax.scm: 1106: 17 [expand-top-sequence ((use-modules #)) () ((top)) ...] 989: 16 [scan ((use-modules (gnucash report business-reports))) () ...] 279: 15 [scan ((# #) #(syntax-object *unspecified* # #)) () (()) ...] In ice-9/boot-9.scm: 3589: 14 [process-use-modules (((gnucash report business-reports)))] 705: 13 [map # ((#))] 3590: 12 [# (#)] 2867: 11 [resolve-interface (gnucash report business-reports) #:select ...] 2792: 10 [# # ...] 3068: 9 [try-module-autoload (gnucash report business-reports) #f] 2404: 8 [save-module-excursion #] 3088: 7 [#] In unknown file: ?: 6 [primitive-load-path "gnucash/report/business-reports" ...] In business-reports.scm: 123: 5 [#] In ice-9/boot-9.scm: 3589: 4 [process-use-modules (((gnucash report balsheet-eg)))] 705: 3 [map # ((#))] 3590: 2 [# (#)] 2870: 1 [resolve-interface (gnucash report balsheet-eg) #:select ...] In unknown file: ?: 0 [scm-error misc-error #f ...] ERROR: In procedure scm-error: ERROR: no code for module (gnucash report balsheet-eg) -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Business Account Set Up Question & Customer Billing Question
On 08/21/2018 07:31 PM, Khristine Ann Ramella wrote: > OK, so trying to use gnu for business. Have a two person llc. I set up the > equity accounts like shown based on all the research on gnuhelp and general > accounting I could find. > > Each member contributed 720 to start the business. The first person 720 was > put in checking immediately. I put it under Opening Balances and sent it to > checking. So far so good. The second 720 came in a month later. When I go to > make the deposit to the checking account how do categorize it? > > Also, why does Equity only show as 740 ? Shouldn't it be 1440 to represent > the 720 from each member? > > [cid:image001.jpg@01D4399E.B10A5F50] > > I also have a billing question. When I enter a credit card charge or checking > account debit, I want to be able to assign a customer & their specific job > to the purchase. We buy & bill out a lot of supplies for each client-most > with an upcharge so it isn't an even swap. In Qbooks you can just check a > box and assign the purchase or invoice to the customer job, so I can see > expenses versus billing right away for the customer and their job. I did some > gnusearch on this and didn't really get a clear cut answer. > > I would hate to have to go back to QB but this is a deal breaker-lots of > parts for each customer and each customer has lots of jobs (installs/service > calls) > > Thanks so much for your expertise!!! > > Oh. I looked at the image again. It looks like you have a bunch of sub-accounts under Equity that offset each other except for the opening balance of 740. I'd talk with a CPA about how they want the COA structured. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Business Account Set Up Question & Customer Billing Question
On 08/21/2018 07:31 PM, Khristine Ann Ramella wrote: > OK, so trying to use gnu for business. Have a two person llc. I set up the > equity accounts like shown based on all the research on gnuhelp and general > accounting I could find. > > Each member contributed 720 to start the business. The first person 720 was > put in checking immediately. I put it under Opening Balances and sent it to > checking. So far so good. The second 720 came in a month later. When I go to > make the deposit to the checking account how do categorize it? > > Also, why does Equity only show as 740 ? Shouldn't it be 1440 to represent > the 720 from each member? > > [cid:image001.jpg@01D4399E.B10A5F50] > > I also have a billing question. When I enter a credit card charge or checking > account debit, I want to be able to assign a customer & their specific job > to the purchase. We buy & bill out a lot of supplies for each client-most > with an upcharge so it isn't an even swap. In Qbooks you can just check a > box and assign the purchase or invoice to the customer job, so I can see > expenses versus billing right away for the customer and their job. I did some > gnusearch on this and didn't really get a clear cut answer. > > I would hate to have to go back to QB but this is a deal breaker-lots of > parts for each customer and each customer has lots of jobs (installs/service > calls) > > Thanks so much for your expertise!!! > Yes, your equity account should show 1440. Go to that account on the account page and double click on it. It should show you all the detailed transactions. Hopefully you will spot something in there that will lead you to your answer. Probably an errant transaction that didn't belong in that account (or one you forgot happened). Could you put something in the memo portion of the main transaction (would show on all splits) and then filter by that? I've not used customer billing so can't help any further than that. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 3 in the Debian / Ubuntu pipeline?
On 08/21/2018 08:32 PM, GWB wrote: > Yes, thank you, I may try building from source. Has there ever been a > standalone .deb package for GnuCash? I don't know what the flatpack > is, but it occurs to me that for linux, debian, etc., a 3.x .deb might > be worthwhile. But I don't think I have seen a .deb package on the > download links at GnuCash.org. > > If not, is that intentional? Some distros are good with > "automagically" finding and installing dependencies when using .deb > packages, and some are not. Source may be less hassle anyway on some > distros. > I'm not sure which distro the developers use. So there may not be one that could create a deb package. I'm not sure what would be involved to do that. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
I tripped over a few more typos that seemingly were unrelated to the errors produced. I can get this set of files to work usurping the balsheet-eg.scm report. If I change that back to balsheet-fmtd.scm (and fix the name dependencies in the file), it isn't seen by GNC. Moving the files down to standard-reports throws other errors that I can't figure out. So, what has to happen to get the report to load independent of balsheet-eg? --Steve On 08/22/2018 02:17 PM, Stephen M. Butler wrote: > On 08/22/2018 08:01 AM, Derek Atkins wrote: >> Hi, >> >> There should be a >> /usr/local/share/gnucash/scm/gnucash/report/business-reports* >> in your installation. > I see a business-reports.scm file there. The other files are: > steve@stevelaptop:/usr/local/share/gnucash/scm/gnucash/report$ ls -l > total 916 > -rw-r--r-- 1 root root 30346 Aug 8 12:34 aging.scm > -rw-r--r-- 1 root root 1240 Aug 8 12:34 balsheet-eg.css > -rw-r--r-- 1 root root 11728 Aug 8 12:34 balsheet-eg.eguile.scm > -rw-r--r-- 1 root root 33739 Aug 21 19:21 balsheet-eg.old > -rw-r--r-- 1 root root 33386 Aug 21 20:51 balsheet-eg.scm > -rw-r--r-- 1 root root 11556 Aug 21 21:27 balsheet-fmtd.eguile.scm > -rw-r--r-- 1 root root 34010 Aug 21 19:22 balsheet-fmtd.scm > -rw-r--r-- 1 root root 5383 Aug 8 12:34 business-reports.scm > -rw-r--r-- 1 root root 38987 Aug 8 12:34 customer-summary.scm > -rw-r--r-- 1 root root 27079 Aug 8 12:34 easy-invoice.scm > -rw-r--r-- 1 root root 10148 Aug 8 12:34 eguile-gnc.scm > -rw-r--r-- 1 root root 5523 Aug 8 12:34 eguile-html-utilities.scm > -rw-r--r-- 1 root root 4142 Aug 8 12:34 eguile-utilities.scm > -rw-r--r-- 1 root root 32028 Aug 8 12:34 fancy-invoice.scm > -rw-r--r-- 1 root root 21430 Aug 8 12:34 hello-world.scm > -rw-r--r-- 1 root root 11639 Aug 21 19:22 income-statement2.scm > -rw-r--r-- 1 root root 24147 Aug 8 12:34 invoice.scm > -rw-r--r-- 1 root root 21536 Aug 8 12:34 job-report.scm > drwxr-xr-x 2 root root 4096 Aug 8 19:13 locale-specific > -rw-r--r-- 1 root root 32733 Aug 8 12:34 owner-report.scm > -rw-r--r-- 1 root root 4115 Aug 8 12:34 payables.scm > -rw-r--r-- 1 root root 2521 Aug 8 12:34 receipt.css > -rw-r--r-- 1 root root 13049 Aug 8 12:34 receipt.eguile.scm > -rw-r--r-- 1 root root 12901 Aug 8 12:34 receipt.scm > -rw-r--r-- 1 root root 4635 Aug 8 12:34 receivables.scm > -rw-r--r-- 1 root root 5486 Aug 8 12:34 report-gnome.scm > drwxr-xr-x 3 root root 4096 Aug 8 19:13 report-system > -rw-r--r-- 1 root root 28028 Aug 8 12:34 report-system.scm > drwxr-xr-x 3 root root 4096 Aug 8 19:13 standard-reports > -rw-r--r-- 1 root root 5648 Aug 8 12:34 standard-reports.scm > -rw-r--r-- 1 root root 12994 Aug 8 12:34 stylesheet-easy.scm > -rw-r--r-- 1 root root 12910 Aug 8 12:34 stylesheet-fancy.scm > -rw-r--r-- 1 root root 13592 Aug 8 12:34 stylesheet-footer.scm > -rw-r--r-- 1 root root 20856 Aug 8 12:34 stylesheet-head-or-tail.scm > -rw-r--r-- 1 root root 7547 Aug 8 12:34 stylesheet-plain.scm > -rw-r--r-- 1 root root 1240 Aug 21 19:22 stylesheet-reports.css > -rw-r--r-- 1 root root 1518 Aug 8 12:34 stylesheets.scm > -rw-r--r-- 1 root root 1855 Aug 8 12:34 taxinvoice.css > -rw-r--r-- 1 root root 19239 Aug 8 12:34 taxinvoice.eguile.scm > -rw-r--r-- 1 root root 19041 Aug 8 12:34 taxinvoice.scm > -rw-r--r-- 1 root root 39142 Aug 8 12:34 taxtxf-de_DE.scm > -rw-r--r-- 1 root root 192419 Aug 8 12:34 taxtxf.scm > -rw-r--r-- 1 root root 847 Aug 8 12:34 > test-load-report-stylesheets-module.scm > -rw-r--r-- 1 root root 1497 Aug 8 12:34 utility-reports.scm > -rw-r--r-- 1 root root 8988 Aug 8 12:34 view-column.scm > -rw-r--r-- 1 root root 4431 Aug 8 12:34 welcome-to-gnucash.scm > > > >> What version of GnuCash is this? Considering it's /usr/local I'm >> guessing you built it yourself. Did you possibly upgrade a 2.6.x to 3.y >> version and overwrite the older version? > I've been running v3.2 for awhile (compiled locally) and recently pulled > down from github to fix some bugs so now have v3.2-100. > > I had made changes to the eguile balance sheet program pre-3.x but > hadn't moved it in thinking the new multi-column balance sheet report > would make it obsolete. That turns out to not be the case and the new > one is headed in a different direction. > > So, I pulled out the old code and attempted to install > (balsheet-fmtd.scm and balsheet-fmtd.eguile.scm) but GNC ignored them. > I remembered that I had to load them under the original name > balsheet-eg.scm previously before GNC saw them and added them in (after > that I could have both sitting there and working). So, I renamed > balscheet-eg.scm to *.old andw copied balsheet-fmt.scm to have the > balsheet-eg.
Re: [GNC] Balsheet-eg.scm problem
On 08/23/2018 08:04 AM, Christopher Lam wrote: > I can confirm loading of eguile reports is different. Hence I could not > trigger loading. Hence there's no test for them. > > Off they go, please! Ach! OK. So what language should I learn this winter? Anything that looks like: COBOL, BASIC, Fortran, PL/SQL, Pascal (just a smidgen), Transact, SPL (HP-3000)? I have been thinking that putting C under my belt might be useful -- then I retired! --Steve > On Thu, 23 Aug 2018, 21:20 Derek Atkins wrote: > >> Hi, >> >> "Stephen M. Butler" writes: >> >>> I tripped over a few more typos that seemingly were unrelated to the >>> errors produced. >>> >>> I can get this set of files to work usurping the balsheet-eg.scm >>> report. If I change that back to balsheet-fmtd.scm (and fix the name >>> dependencies in the file), it isn't seen by GNC. >>> >>> Moving the files down to standard-reports throws other errors that I >>> can't figure out. So, what has to happen to get the report to load >>> independent of balsheet-eg? >> [snip] >>>>>> 3068: 9 [try-module-autoload (gnucash report business-reports) #f] >>>>>> 2404: 8 [save-module-excursion #>>>>> ice-9/boot-9.scm:3069:17 ()>] >>>>>> 3088: 7 [#] >>>>>> In unknown file: >>>>>>?: 6 [primitive-load-path "gnucash/report/business-reports" ...] >>>>>> In business-reports.scm: >>>>>> 123: 5 [#] >>>>>> In ice-9/boot-9.scm: >>>>>> 3589: 4 [process-use-modules (((gnucash report balsheet-eg)))] >>>>>> 705: 3 [map #>>>>> (mif-args)> ((#))] >>>>>> 3590: 2 [#>>>>> (mif-args)> (#)] >>>>>> 2870: 1 [resolve-interface (gnucash report balsheet-eg) #:select ...] >>>>>> In unknown file: >>>>>>?: 0 [scm-error misc-error #f ...] >>>>>> >>>>>> ERROR: In procedure scm-error: >>>>>> ERROR: no code for module (gnucash report balsheet-eg) >> Basically, the issue being reported is that it is trying to find "gnucash >> report balsheet-eg" but it can't. WHY it thinks there is "no code for >> module" is a different question. One possibility is caching -- you >> should definitely clear your guile cache. You can also "touch" the .scm >> files to make them look newer so they get recompiled. >> >> I was under the impression that all the files in standard-reports get >> auto-loaded. So just pulling a new report in there should be >> sufficient. HOWEVER the e-guile reports MIGHT be different. >> >> Also, ensure the file name and path matches the module name. >> >> -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 >> ___ -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
On 08/23/2018 09:44 AM, Geert Janssens wrote: > Op donderdag 23 augustus 2018 15:17:34 CEST schreef Derek Atkins: >> Hi, >> >> "Stephen M. Butler" writes: >>> I tripped over a few more typos that seemingly were unrelated to the >>> errors produced. >>> >>> I can get this set of files to work usurping the balsheet-eg.scm >>> report. If I change that back to balsheet-fmtd.scm (and fix the name >>> dependencies in the file), it isn't seen by GNC. >>> >>> Moving the files down to standard-reports throws other errors that I >>> can't figure out. So, what has to happen to get the report to load >>> independent of balsheet-eg? >> >> I was under the impression that all the files in standard-reports get >> auto-loaded.So just pulling a new report in there should be >> sufficient. > That is correct. However Stephen has put his customized balsheet-fmtd.scm > report in > /usr/local/share/gnucash/scm/gnucash/report > instead of > /usr/local/share/gnucash/scm/gnucash/report/standard-reports I tried in standard-reports and it threw errors. Moved back up to report and it works. I'm sure there is something about the code that I didn't change correctly for the new location. > Files in the former directory are not automatically loaded, a historical > artifact we should one day fix. > >> HOWEVER the e-guile reports MIGHT be different. > What is different about the e-guile reports is that they are business > reports. > And contrary to the standard reports they are only loaded if explicitly > mentioned in > /usr/local/share/gnucash/scm/gnucash/report/business-reports.scm > (in a use-modules construct). Aha. The missing piece of information. >> Also, ensure the file name and path matches the module name. >> > This is the problem IMO. The attached balsheet-fmtd.scm (renamed to balsheet- > eg.scm) defines this module: > (define-module (gnucash report balsheet-fmtd)) > As this file replaces balsheet-eg.scm there no longer is a module defined by > (define-module (gnucash report balsheet-eg)) > > And hence gnucash complains it can't find that one. I changed the define-module and the debug lines to match the balsheet-eg name. That got it to work. > > To solve this, restore the original balsheet-eg.scm and instead add a line in > business-reports.scm like this: > > (use-modules (gnucash report balsheet-fmtd)) OK. Will take this path. > > Better still: don't mess with the installation directory at all and instead > follow > https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report > to load your custom report. I tried that path and it didn't work. One of these days I'll figure out what I did wrong there. But, if the above will work then I'm willing to suffer making the changes for each new release. > > Regards, > > Geert > > > Thanks Geert. I believe you gave me the missing piece of information that I needed. --Steve (feeling my way in the twilight) -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
On 08/23/2018 06:17 AM, Derek Atkins wrote: > Hi, > > "Stephen M. Butler" writes: > >> I tripped over a few more typos that seemingly were unrelated to the >> errors produced. >> >> I can get this set of files to work usurping the balsheet-eg.scm >> report. If I change that back to balsheet-fmtd.scm (and fix the name >> dependencies in the file), it isn't seen by GNC. >> >> Moving the files down to standard-reports throws other errors that I >> can't figure out. So, what has to happen to get the report to load >> independent of balsheet-eg? > Basically, the issue being reported is that it is trying to find "gnucash > report balsheet-eg" but it can't. WHY it thinks there is "no code for > module" is a different question. One possibility is caching -- you > should definitely clear your guile cache. You can also "touch" the .scm > files to make them look newer so they get recompiled. > > I was under the impression that all the files in standard-reports get > auto-loaded. So just pulling a new report in there should be > sufficient. HOWEVER the e-guile reports MIGHT be different. > > Also, ensure the file name and path matches the module name. > > -derek > Thanks Derek. I've reverted back to usurping the balsheet eguile names. My version is running that way and since my purpose was to clean up some things I didn't like about the eguile version, I don't need to keep it around. One of these days I should take time to learn the language instead of hacking at it. If anyone has insights on how to get an eguile report loaded in standard-reports (and I don't see any others there so it may not be possible), I'd like to have that input. Maybe I can learn the language over winter! --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
On 08/23/2018 10:58 AM, John Ralls wrote: > >> On Aug 23, 2018, at 8:59 AM, Stephen M. Butler wrote: >> >> On 08/23/2018 08:04 AM, Christopher Lam wrote: >>> I can confirm loading of eguile reports is different. Hence I could not >>> trigger loading. Hence there's no test for them. >>> >>> Off they go, please! >> Ach! OK. So what language should I learn this winter? Anything that >> looks like: COBOL, BASIC, Fortran, PL/SQL, Pascal (just a smidgen), >> Transact, SPL (HP-3000)? I have been thinking that putting C under my >> belt might be useful -- then I retired! > Pascal and HP-SPL are both Algol descendants, as is C, so learning that will > likely be closest to your work experience. I don't think there are many > people writing new code in procedural languages like COBOL, FORTAN, and BASIC. > > If you want to learn 21st-century programming idioms I recommend Python, but > unless you've already encountered object-oriented programming you'll want to > start with a "how-to-program" book rather than the language reference. Object > orientation requires a different approach to breaking the problem into > solvable pieces ("decomposition") than modular ("block-oriented") languages > like Pascal, HP-SPL, and C. > > That said, if you want to write reports that are internal to GnuCash you've > got to learn Scheme. If you're willing to use a SQL backend you can query the > database and use any language you like and can find a compiler for on the > results. > > Regards, > John Ralls > > Thanks John. I read the "Tao of Objects" a decade or so ago. But that's as close as I've gotten to doing anything with that class of programming. Looks like C and Scheme are on my todo list. I'll check to see if there is a CBT for Scheme. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
On 08/24/2018 12:40 AM, Geert Janssens wrote: > Op donderdag 23 augustus 2018 19:35:43 CEST schreef Stephen M. Butler: >> On 08/23/2018 09:44 AM, Geert Janssens wrote: >>> Better still: don't mess with the installation directory at all and >>> instead >>> follow >>> https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report >>> to load your custom report. >> I tried that path and it didn't work. One of these days I'll figure out >> what I did wrong there. But, if the above will work then I'm willing to >> suffer making the changes for each new release. > What error did you get in this case ? I expect it to be different and related > to the location of the associated *-eguile.scm and/or *.css file ? > > Geert moved balsheet-fmtd.scm and balsheet-fmtd.eguild.scm to standard-reports folder. Commented out the line for balsheet-fmtd in business-reports.scm to get back to the state where I had the problems. These error messages: gnucash --logto stdout (gnucash:10123): Gtk-WARNING **: 16:57:47.073: Theme parsing error: gtk.css:1278:13: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' (gnucash:10123): Gtk-WARNING **: 16:57:47.073: Theme parsing error: gtk.css:1281:15: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' Backtrace: In ice-9/eval-string.scm: 44: 19 [read-and-eval # #:lang ...] 37: 18 [lp (use-modules (gnucash report standard-reports))] In ice-9/eval.scm: 505: 17 [# (use-modules #)] In ice-9/psyntax.scm: 1106: 16 [expand-top-sequence ((use-modules #)) () ((top)) ...] 989: 15 [scan ((use-modules (gnucash report standard-reports))) () ...] 279: 14 [scan ((# #) #(syntax-object *unspecified* # #)) () (()) ...] In ice-9/boot-9.scm: 3589: 13 [process-use-modules (((gnucash report standard-reports)))] 705: 12 [map # ((#))] 3590: 11 [# (#)] 2867: 10 [resolve-interface (gnucash report standard-reports) #:select ...] 2792: 9 [# # ...] 3068: 8 [try-module-autoload (gnucash report standard-reports) #f] 2404: 7 [save-module-excursion #] 3088: 6 [#] In unknown file: ?: 5 [primitive-load-path "gnucash/report/standard-reports" ...] In standard-reports.scm: 149: 4 [#] In ice-9/boot-9.scm: 771: 3 [for-each # #] In standard-reports.scm: 153: 2 [# balsheet-fmtd.eguile] In ice-9/boot-9.scm: 2870: 1 [resolve-interface (gnucash report standard-reports ...) #:select ...] In unknown file: ?: 0 [scm-error misc-error #f ...] ERROR: In procedure scm-error: ERROR: no code for module (gnucash report standard-reports balsheet-fmtd.eguile) Now, put the line back into business-reports.scm but pointing down to standard-reports: (use-modules (gnucash report standard-reports balsheet-fmtd)) and see these errors: gnucash --logto stdout (gnucash:10175): Gtk-WARNING **: 17:04:08.548: Theme parsing error: gtk.css:1278:13: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' (gnucash:10175): Gtk-WARNING **: 17:04:08.548: Theme parsing error: gtk.css:1281:15: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' Backtrace: In ice-9/eval-string.scm: 44: 19 [read-and-eval # #:lang ...] 37: 18 [lp (use-modules (gnucash report standard-reports))] In ice-9/eval.scm: 505: 17 [# (use-modules #)] In ice-9/psyntax.scm: 1106: 16 [expand-top-sequence ((use-modules #)) () ((top)) ...] 989: 15 [scan ((use-modules (gnucash report standard-reports))) () ...] 279: 14 [scan ((# #) #(syntax-object *unspecified* # #)) () (()) ...] In ice-9/boot-9.scm: 3589: 13 [process-use-modules (((gnucash report standard-reports)))] 705: 12 [map # ((#))] 3590: 11 [# (#)] 2867: 10 [resolve-interface (gnucash report standard-reports) #:select ...] 2792: 9 [# # ...] 3068: 8 [try-module-autoload (gnucash report standard-reports) #f] 2404: 7 [save-module-excursion #] 3088: 6 [#] In unknown file: ?: 5 [primitive-load-path "gnucash/report/standard-reports" ...] In standard-reports.scm: 149: 4 [#] In ice-9/boot-9.scm: 771: 3 [for-each # #] In standard-reports.scm: 153: 2 [# balsheet-fmtd.eguile] In ice-9/boot-9.scm: 2870: 1 [resolve-interface (gnucash report standard-reports ...) #:select ...] In unknown file: ?: 0 [scm-error misc-error #f ...] ERROR: In procedure scm-error: ERROR: no code for module (gnucash report standard-reports balsheet-fmtd.eguile) Moved everything back to reports folder, fixed up business-reports.scm, and the define module and these are the only warnings (expected): gnucash --logto stdout (gnucash:10219): Gtk-WARNING **: 17:08:21.297: Theme parsing error: gtk.css:1278:13: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' (gnucash:10219): Gtk-WARNING **: 17:08:21.297: Theme parsing error: gtk.css:1281:15: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' ;;; note: source file /usr/local/share/gnucash/scm/gnucash/report/business-reports.scm ;;; newer than compiled /usr/local/lib/gnucash/scm/ccache/2.0/gnuca
Re: [GNC] Balsheet-eg.scm problem
On 08/24/2018 06:31 AM, Derek Atkins wrote: > "Stephen M. Butler" writes: > >> I tried in standard-reports and it threw errors. Moved back up to >> report and it works. I'm sure there is something about the code that I >> didn't change correctly for the new location. > What error(s) did it throw when it was in standard-reports? > > Did you change the module name, too, to reflect its new location? > > -derek Yup. See my response to Geert. I think I have all the error variants covered in that email. This is working for me now in the report folder. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
On 08/25/2018 02:15 AM, Geert Janssens wrote: > Having said all that my original question was what problems you had when > setting up the report as decribed in > https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report > With that I meant what problems did you encounter when storing *all three > files* in $HOME/.local/share/gnucash and creating a load file in I hadn't picked up that the files had to be in that folder. So had left them in the report folder. > $HOME/.config/gnucash called config-user.scm with this content: > (load (gnc-build-userdata-path "balsheet-fmtd.scm")) I had given the path to the report folder. > > This works equally well on my system and is recommended. > > So what issues do you get when setting up the reports in your home directory ? It appears to be ignored. I moved the three files to $HOME/.local/share/gnucash (bold in the below list): $ pwd /home/steve/.local/share/gnucash $ ls -l total 164 -rw-r--r-- 1 steve steve 19148 Aug 25 21:03 accelerator-map *-rw-r--r-- 1 steve steve 11472 Aug 25 20:58 balsheet-fmtd.eguile.scm** **-rw-r--r-- 1 steve steve 33386 Aug 25 20:58 balsheet-fmtd.scm** **d*rwxrwxr-x 2 steve steve 4096 Jul 1 19:03 books-rw-r--r-- 1 steve steve 1240 Aug 25 20:58 stylesheet-reports.css -drwxrwxr-x 2 steve steve 4096 Jun 22 12:38 checks -rw-rw-r-- 1 steve steve 0 Aug 25 21:03 expressions-2.0 -rw-rw-r-- 1 steve steve 7877 Aug 13 11:00 saved-reports-2.8 -rw-rw-r-- 1 steve steve 3121 Aug 13 11:00 saved-reports-2.8-backup *-rw-r--r-- 1 steve steve 1240 Aug 25 20:58 stylesheet-reports.css** **-*rw-rw-r-- 1 steve steve 1614 Aug 25 21:03 stylesheets-2.0 drwxrwxr-x 2 steve steve 4096 Jun 22 12:38 translog Created the gnucash folder and config.user file in .config: $ pwd /home/steve/.config/gnucash $ ls -l total 12 -rw-r--r-- 1 steve steve 53 Aug 25 20:56 config.user $ cat config.user (load (gnc-build-userdata-path "balsheet-fmtd.scm")) The report isn't loaded and there is no error message. gnucash --logto stdout (gnucash:5078): Gtk-WARNING **: 21:00:39.924: Theme parsing error: gtk.css:1278:13: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' (gnucash:5078): Gtk-WARNING **: 21:00:39.924: Theme parsing error: gtk.css:1281:15: The 'icon-shadow' property has been renamed to '-gtk-icon-shadow' ;;; note: source file /usr/local/share/gnucash/scm/gnucash/report/business-reports.scm ;;; newer than compiled /usr/local/lib/gnucash/scm/ccache/2.0/gnucash/report/business-reports.go ;;; found fresh local cache at /home/steve/.cache/guile/ccache/2.0-LE-8-2.0/usr/local/share/gnucash/scm/gnucash/report/business-reports.scm.go Sorry to be so dense but I'm obviously missing something. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Process Payment and convenience fees
On 08/27/2018 05:39 AM, Justin H Haynes wrote: > It worked just fine. From the Accounts Payable register, I edited the > payment transaction and added two splits - 1 from the Liabilities:Credit Card > account to pay the fee, and 1 to the Expenses:Fees. In the reference field, > I left all the “Payment” splits generated by GNUCash alone, and for the 2 I > added, I put “Fee” in that field. > > So the payment amount in billing is correct, but I still have the fee > recorded in the transaction. > > It is probably a good idea not to change the payment split I would guess. > $ My wife is an accountant so I popped the question to her. You have a couple of options according to her: 1. Include the fee as part of the utility expense. 2. Create a separate expense account. Do the latter if you want to keep track of the total expenses through the fee. The former if you don't care. Note that with the first you won't balance at the end of the year with any YTD totals the utility company might produce (for reconciling purposes). As for the implementation of the payment, I'd just add another split for the fee amount with the expense side going to whichever expense account you decide making the total out of CC the $603.49. >> On Aug 26, 2018, at 12:16 PM, Justin H Haynes >> wrote: >> >> I have two invoices to pay to a utility company. Let’s say the amounts of >> the invoices are $200 and $300 for a total of $500. I have paid $600, so >> the payment correctly is applied to those two invoices, and $100 to the >> Accounts Payable account. I can see the three transactions in Account >> payable. Actually 3 splits - 1 for each of the amounts of the 2 invoices, >> and 1 for the remainder, then on the other side of the transaction the $600 >> from Liabilities:Credit Card. >> >> However, there was a convenience fee charged by the payment processor for >> the city utilities. So, the amount charged to my credit card was $603.49. >> >> Will the best way to deal with this be to edit the split from the >> Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees? >> >> >> Thanks!, >> >> Justin >> >> -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
On 08/27/2018 10:43 AM, Geert Janssens wrote: > > "Stephen M. Butler" schreef op 26 augustus 2018 06:15:27 > CEST: >> On 08/25/2018 02:15 AM, Geert Janssens wrote: >> >>> Having said all that my original question was what problems you had >> when >>> setting up the report as decribed in >>> https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report >>> With that I meant what problems did you encounter when storing *all >> three >>> files* in $HOME/.local/share/gnucash and creating a load file in >> I hadn't picked up that the files had to be in that folder. So had >> left >> them in the report folder. >>> $HOME/.config/gnucash called config-user.scm with this content: >>> (load (gnc-build-userdata-path "balsheet-fmtd.scm")) >> I had given the path to the report folder. >>> This works equally well on my system and is recommended. >>> >>> So what issues do you get when setting up the reports in your home >> directory ? >> >> It appears to be ignored. >> >> I moved the three files to $HOME/.local/share/gnucash (bold in the >> below >> list): >> >> $ pwd >> /home/steve/.local/share/gnucash >> $ ls -l >> total 164 >> -rw-r--r-- 1 steve steve 19148 Aug 25 21:03 accelerator-map >> *-rw-r--r-- 1 steve steve 11472 Aug 25 20:58 balsheet-fmtd.eguile.scm** >> **-rw-r--r-- 1 steve steve 33386 Aug 25 20:58 balsheet-fmtd.scm** >> **d*rwxrwxr-x 2 steve steve 4096 Jul 1 19:03 books-rw-r--r-- 1 steve >> steve 1240 Aug 25 20:58 stylesheet-reports.css >> -drwxrwxr-x 2 steve steve 4096 Jun 22 12:38 checks >> -rw-rw-r-- 1 steve steve 0 Aug 25 21:03 expressions-2.0 >> -rw-rw-r-- 1 steve steve 7877 Aug 13 11:00 saved-reports-2.8 >> -rw-rw-r-- 1 steve steve 3121 Aug 13 11:00 saved-reports-2.8-backup >> *-rw-r--r-- 1 steve steve 1240 Aug 25 20:58 stylesheet-reports.css** >> **-*rw-rw-r-- 1 steve steve 1614 Aug 25 21:03 stylesheets-2.0 >> drwxrwxr-x 2 steve steve 4096 Jun 22 12:38 translog >> >> Created the gnucash folder and config.user file in .config: >> >> $ pwd >> /home/steve/.config/gnucash >> $ ls -l >> total 12 >> -rw-r--r-- 1 steve steve 53 Aug 25 20:56 config.user >> $ cat config.user >> (load (gnc-build-userdata-path "balsheet-fmtd.scm")) >> > In gnucash 3 this file shoulb be named config-user.scm > > It looks like you missed the extension. > > Regards, > > Geert > Sent from my smartphone. Please excuse my brevity. > Yes I did!! And that works! I've cleaned up /usr/local/share/gnucash/scm/gnucash/report to revert it back to the state when 3.2 was last compiled. I think I'll remember that this is there now and will have a place to look it up if I forget the details. Thank you for hanging in there with me. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
On 08/22/2018 08:01 AM, Derek Atkins wrote: > Hi, > > There should be a > /usr/local/share/gnucash/scm/gnucash/report/business-reports* > in your installation. I see a business-reports.scm file there. The other files are: steve@stevelaptop:/usr/local/share/gnucash/scm/gnucash/report$ ls -l total 916 -rw-r--r-- 1 root root 30346 Aug 8 12:34 aging.scm -rw-r--r-- 1 root root 1240 Aug 8 12:34 balsheet-eg.css -rw-r--r-- 1 root root 11728 Aug 8 12:34 balsheet-eg.eguile.scm -rw-r--r-- 1 root root 33739 Aug 21 19:21 balsheet-eg.old -rw-r--r-- 1 root root 33386 Aug 21 20:51 balsheet-eg.scm -rw-r--r-- 1 root root 11556 Aug 21 21:27 balsheet-fmtd.eguile.scm -rw-r--r-- 1 root root 34010 Aug 21 19:22 balsheet-fmtd.scm -rw-r--r-- 1 root root 5383 Aug 8 12:34 business-reports.scm -rw-r--r-- 1 root root 38987 Aug 8 12:34 customer-summary.scm -rw-r--r-- 1 root root 27079 Aug 8 12:34 easy-invoice.scm -rw-r--r-- 1 root root 10148 Aug 8 12:34 eguile-gnc.scm -rw-r--r-- 1 root root 5523 Aug 8 12:34 eguile-html-utilities.scm -rw-r--r-- 1 root root 4142 Aug 8 12:34 eguile-utilities.scm -rw-r--r-- 1 root root 32028 Aug 8 12:34 fancy-invoice.scm -rw-r--r-- 1 root root 21430 Aug 8 12:34 hello-world.scm -rw-r--r-- 1 root root 11639 Aug 21 19:22 income-statement2.scm -rw-r--r-- 1 root root 24147 Aug 8 12:34 invoice.scm -rw-r--r-- 1 root root 21536 Aug 8 12:34 job-report.scm drwxr-xr-x 2 root root 4096 Aug 8 19:13 locale-specific -rw-r--r-- 1 root root 32733 Aug 8 12:34 owner-report.scm -rw-r--r-- 1 root root 4115 Aug 8 12:34 payables.scm -rw-r--r-- 1 root root 2521 Aug 8 12:34 receipt.css -rw-r--r-- 1 root root 13049 Aug 8 12:34 receipt.eguile.scm -rw-r--r-- 1 root root 12901 Aug 8 12:34 receipt.scm -rw-r--r-- 1 root root 4635 Aug 8 12:34 receivables.scm -rw-r--r-- 1 root root 5486 Aug 8 12:34 report-gnome.scm drwxr-xr-x 3 root root 4096 Aug 8 19:13 report-system -rw-r--r-- 1 root root 28028 Aug 8 12:34 report-system.scm drwxr-xr-x 3 root root 4096 Aug 8 19:13 standard-reports -rw-r--r-- 1 root root 5648 Aug 8 12:34 standard-reports.scm -rw-r--r-- 1 root root 12994 Aug 8 12:34 stylesheet-easy.scm -rw-r--r-- 1 root root 12910 Aug 8 12:34 stylesheet-fancy.scm -rw-r--r-- 1 root root 13592 Aug 8 12:34 stylesheet-footer.scm -rw-r--r-- 1 root root 20856 Aug 8 12:34 stylesheet-head-or-tail.scm -rw-r--r-- 1 root root 7547 Aug 8 12:34 stylesheet-plain.scm -rw-r--r-- 1 root root 1240 Aug 21 19:22 stylesheet-reports.css -rw-r--r-- 1 root root 1518 Aug 8 12:34 stylesheets.scm -rw-r--r-- 1 root root 1855 Aug 8 12:34 taxinvoice.css -rw-r--r-- 1 root root 19239 Aug 8 12:34 taxinvoice.eguile.scm -rw-r--r-- 1 root root 19041 Aug 8 12:34 taxinvoice.scm -rw-r--r-- 1 root root 39142 Aug 8 12:34 taxtxf-de_DE.scm -rw-r--r-- 1 root root 192419 Aug 8 12:34 taxtxf.scm -rw-r--r-- 1 root root 847 Aug 8 12:34 test-load-report-stylesheets-module.scm -rw-r--r-- 1 root root 1497 Aug 8 12:34 utility-reports.scm -rw-r--r-- 1 root root 8988 Aug 8 12:34 view-column.scm -rw-r--r-- 1 root root 4431 Aug 8 12:34 welcome-to-gnucash.scm > What version of GnuCash is this? Considering it's /usr/local I'm > guessing you built it yourself. Did you possibly upgrade a 2.6.x to 3.y > version and overwrite the older version? I've been running v3.2 for awhile (compiled locally) and recently pulled down from github to fix some bugs so now have v3.2-100. I had made changes to the eguile balance sheet program pre-3.x but hadn't moved it in thinking the new multi-column balance sheet report would make it obsolete. That turns out to not be the case and the new one is headed in a different direction. So, I pulled out the old code and attempted to install (balsheet-fmtd.scm and balsheet-fmtd.eguile.scm) but GNC ignored them. I remembered that I had to load them under the original name balsheet-eg.scm previously before GNC saw them and added them in (after that I could have both sitting there and working). So, I renamed balscheet-eg.scm to *.old andw copied balsheet-fmt.scm to have the balsheet-eg.scm name. That led me to discover several changes that were needed (apparently due to changes from 2.6 to 3.x). I am down to this error and not understanding what it has to do with the changes I made. I've attached my versions of the old eguile balance sheet just in case the stdout has a clue to what line in this is causing the problem. Remember that balsheet-fmtd.scm is currently named balsheet-eg.scm in the above folder. > -derek --Steve PS Sorry for the delayed response. Was out raising the south wall on my new greenhouse (10x20). Too hot outside now even though the air quality is better than the last few days. > "Stephen M. Butler" writes: > >> When I load gnucash the below messages come out. However, I can't find >> references to "business-reports" in the code. I also don't see it in >> evel-st
Re: [GNC] Help breaking up a file
On 08/27/2018 06:36 AM, David Cousens wrote: > Eric, > > What version of Gnucash are you currently using and on what operating > system? > > If it is 3.2, you can export the transactions using the default export > format to a csv file and import them using the same default format. The > format is selectable in the setup assistants for both export (here just use > the default settings in the first pane of the assistant and don't change > them) and on import select the GnuCash Export Setting in the Load and Save > Settings combo box at the top. > > I did this this afternoon with a couple of month's data while testing out > some changes I was making to the importer and it worked flawlessly apart > from one quirk. You have to make sure the default date format when you > import the exported data matches the date format for your locale or whatever > date format you have set in the GnuCash preferences for dates for your > books. > > My understanding is that before v3 GnuCash was unable to easily reimport its > own export data but from V3.0 on this should work OK so if you are using a > v2.6 variant this may be the problem and causing the errors on import. I > would try it with a small block of data initially until you are sure you > have the settings right. > > David Cousens. > > > > - > David Cousens > -- > 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. > I have thought that a useful feature would be a balance-forward option on the year-end close tool. That option would replace all of the transactions in an account with a single entry that is the balance at the end of the year (or specified date if someone has a fiscal year non-calendar). Since the year-end close just ran, all the income and expense accounts would net to zero. I would have it saved to a new file rather than replacing the old (or ask for a name for the "old" file and write the pre-action file to there). I suppose this could be a stand-alone feature but it seems most useful in conjunction with the "close" option. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] balance sheet and account equation for Business Accounts
On 07/25/2018 09:13 AM, nor via gnucash-user wrote: > I have separate income accounts for USD and Euro transactions. When the need > arises than only funds from Euro is converted to default USD account held at > the bank at the prevailing exchange rate. > > balance sheet report is with exchange rates at balance sheet report date. > May be these exchange rate variations are not automatically accounts as > gain/loss in B/L report. > > nor > You need to enable trading accounts and follow the setup described at https://wiki.gnucash.org/wiki/Trading_Accounts Please read the two articles it mentions at the top. Essentially foreign exchange rate changes act like stock price fluctuations. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Compiling 2.6.12
First -- be sure to cc the user group (gnucash-user@gnucash.org) so that others can jump in and help. Second -- I presume you have looked at this page https://wiki.gnucash.org/wiki/BuildUbuntu16.04 It has the entire list for building on 18.04. I know it says 16.04 but it also works for 18.04 Third -- you are aware that 2.6.19 is available for 18.04 from the packaged libraries. That would have several bug fixes. In addition, you could pull down 2.6.21 (as Geert suggested) and get even more fixes. <> On 08/31/2018 11:07 AM, Paul Schwartz wrote:O > Very long message > Package glib-2.0 was not found in the pkg-config search path. Perhaps > you should add the directory containing `glib-2.0.pc' to the > PKG_CONFIG_PATH environment variable No package 'glib-2.0' found > Package gio-2.0 was not found in the pkg-config search path. Perhaps > you should add the directory containing `gio-2.0.pc' to the > PKG_CONFIG_PATH environment variable No package 'gio-2.0' found > Package gthread-2.0 was not found in the pkg-config search path. > Perhaps you should add the directory containing `gthread-2.0.pc' to > the PKG_CONFIG_PATH environment variable No package 'gthread-2.0' > found Package gobject-2.0 was not found in the pkg-config search path. > Perhaps you should add the directory containing `gobject-2.0.pc' to > the PKG_CONFIG_PATH environment variable No package 'gobject-2.0' > found Package gmodule-2.0 was not found in the pkg-config search path. > Perhaps you should add the directory containing `gmodule-2.0.pc' to > the PKG_CONFIG_PATH environment variable No package 'gmodule-2.0' found > configure: error: Library requirements (glib-2.0 >= 2.28 gio-2.0 >= > 2.25 gthread-2.0 gobject-2.0 gmodule-2.0) not met; consider adjusting > the PKG_CONFIG_PATH environment variable if your libraries are in a > nonstandard prefix so pkg-config can find them. > > When you installed glib did you remove anything? > > Paul > There was something funky on my machine and I did have to clean up some items. I searched my sent folder and found that gtest and gmock on my system were very old. You may need to remove them and then forcibly remove the two folders /usr/src/gtest and /usr/src/gmock and then add them back: sudo apt-get install googletest sudo apt-get install googlemock sudo apt-get install libgtest-dev > On Fri, Aug 31, 2018 at 11:48 AM Stephen M. Butler <mailto:kg...@arrl.net>> wrote: > > On 08/31/2018 10:36 AM, Paul Schwartz wrote: > > I have been trying to compile 2.6.12 on Ubuntu 18.04. I have not > been able > > to get past the recognition of glib-2.0 in configure. I have > installed > > glib-2.0 and glib-2.0-dev with apt. I have tried setting > PKG_CONFIG_PATH > > to /usr/share before running > conhttps://wiki.gnucash.org/wiki/BuildUbuntu16.04figure. Nothing > seems to work. Some > > suggestions would be appreciated. > > > > Paul > > > What error messages do you get? I was compiling 3.1 and 3.2 on Ubuntu > 18.04 and had to load the generic glib and let 18.04 figure out which > one to install. > > > -- > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com <mailto:stephen.m.butle...@gmail.com> > kg...@arrl.net <mailto:kg...@arrl.net> > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > ___ > 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 > 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. > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balance Sheet Issue
On 09/04/2018 02:53 PM, Paul Schwartz wrote: > If I want to reproduce the Balance Sheet Report I get from version 2.6.12 > in version 2.6.19, are there files that I can othe copy from one to the > other? > > Paul I forgot which OS you have. On Ubuntu (local build) they are in /usr/local/share/gnucash/scm/gnucash/report/standard-reports I think it is one file (if you are talking about the non-eguile one): balance_sheet.scm (try searching your installed software location). The eguile version is up one level from there. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] [OT] Why is Debit abbreviated Dr?
On 09/05/2018 12:05 PM, Christian Kluge wrote: > Am 05.09.2018 um 20:42 schrieb Geoff Jankowski via gnucash-user: >> David >> >> I would love to agree with you but….. >> >> In standard journal notation cr is a debt and dr an asset. This is because >> it is nothing to do with credit (+ve) and debit (-ve) in any sense (or >> tense) but to do with a creditor (to whom we owe) and a debtor (who owes >> us). Hence dr and cr relate to debtor and creditor and not to any form of >> debit or credit. >> >> For example, if I take cash from the cash box and deposit it at the bank I >> enter a cr to the cashbook and a dr to the bank account. > Actually you should a transit account for the period in between taking > and out of the cash box and that journal entry and the day the bank > actually books this deposit on your banking statement. > >> Totally counterintuitive which is why accountancy is a black art and should >> be banned. >> Which is why I, as a software/database guy, just cringe when my wife, the accountant, yells out, "You reversed the journal entries again!" I tried to reason it out know I got it wrong last time by trying to reason it out from the time before when I also got it wrong. I'm no longer sure that three rights make a left. I'm pretty sure that two rights make a U turn of which I am doing a lot lately. > Every form of accounting assumes that the debit side will give its value > back one day as the original Italian formulations «deve dare» “shall > give“ and «deve avere» “shall have”, everyone knows that’s never going > to happen but still, nothing counterintuitive there. > > Kind regards > > > Christian Kluge > > ___ > 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balance Sheet Issue
I'm out of ideas. I ended up modifying the Eguile version to get the behavior my wife wanted. What is it that the report isn't doing? On 09/05/2018 10:19 AM, Paul Schwartz wrote: > First added balance-sheet.scm and then commodity-utilities.scm. There > was no commodity-utilities.scm file in the .19 release. The report > changed but it didn't give the same result as the .12 version. > > Any more suggestions? > Thanks > > Paul > > On Tue, Sep 4, 2018 at 9:34 PM John Ralls <mailto:jra...@ceridwen.us>> wrote: > > > > > On Sep 4, 2018, at 4:05 PM, Stephen M. Butler <mailto:kg...@arrl.net>> wrote: > > > > On 09/04/2018 02:53 PM, Paul Schwartz wrote: > >> If I want to reproduce the Balance Sheet Report I get from > version 2.6.12 > >> in version 2.6.19, are there files that I can othe copy from > one to the > >> other? > >> > >> Paul > > I forgot which OS you have. On Ubuntu (local build) they are in > > /usr/local/share/gnucash/scm/gnucash/report/standard-reports > > > > I think it is one file (if you are talking about the non-eguile > one): > > balance_sheet.scm (try searching your installed software location). > > > > The eguile version is up one level from there. > > You may also want files from .../report/report-system, in > particular commodity-utilities.scm. > > Regards, > John Ralls > ___ > 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 > 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. > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How do I enter a transaction with an account not in the Gnucash ledger?
On 09/09/2018 12:26 PM, Robert Heller wrote: > At Sun, 9 Sep 2018 11:59:57 -0700 Mark Phillips > wrote: > >> How do I enter the following transaction in gnucash? >> >> I have a business checking account and a personal checking account. My >> Gnucash file only tracks the business checking account. Occasionally, I >> grab the wrong debit card from my wallet to pay for a business expense. >> >> For example, let's say I use my personal debit card to pay $100 of business >> expenses. For this example let's say I bought $100 of nuts and bolts (since >> I feel like a nut not being able to work this out). How do I enter this >> transaction into my business Gnucash ledger to account for (1) transferring >> money out of my business checking to reimburse my personal checking and (2) >> record the expense in the appropriate business account? > You will have to add an additional account for this. Call it "personal > reimbursment account" or whatever. Not sure what type of account (could just > be a "bank account"). > > You would either make one transaction with a set of splits: > > $100 *from* "personal reimbursment account" *to* "Nuts and Bolts account" > $100 *from* "business checking" *to* "personal reimbursment account" > > Or two separate transactions, which might make sense if there is a "delay" in > the reimbursment (eg you don't get around to it for a couple of days, etc.). > > At the end of the day, the "personal reimbursment account" is normally at a > balance of $0, except when you "grab the wrong debit card" and when you > handle > the reimbursment. > >> Thanks! >> >> Mark >> >> PS The good news is I have only done this twice since 2015! That clearing account would be a liability account. Think like IBM (even if you own stock and are a part owner). You would turn in an expense report. They would record it against their accounts payable (the other side being the appropriate expense accounts). At their weekly check run, they would cut you a check against the checking account (other side to accounts payable). Your business has a separate identity from you. You could do the above all the time and eliminate the business credit card (reduce your risk if the wallet was stolen). You could simplify the above process by eliminating the accounts payable (liability) account and cut a check directly to pay the expense report. Then one side would be the appropriate expense accounts with the other side being against your checking account. But, I'd treat you (personally) as any other vendor who provided service and/or materials. If you cut them a check when the invoice (expense statement) is presented, then treat yourself just like you treat them others. In essence you wore three hats (maybe more): 1. Employee 2. Vendor 3. Business (management) 4. (not to mention the owner hat) Have fun. Just ask yourself, "If I worked for IBM and put something for them on my personal CC, how would they pay me back?" Then act like they would. Have fun. And remember the paper work. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Upgrading GC under Ubuntu
hare/gnucash/icons/hicolor/16x16/actions/gnc-account-delete.png > -- Installing: > /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice.png > -- Installing: > /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-split-trans.png > -- Installing: > /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice-new.png > -- Installing: > /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-sx-new.png > -- Installing: > /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-jumpto.png > -- Installing: > /usr/local/share/gnucash/icons/hicolor/16x16/actions/gnc-invoice-pay.png > -- Installing: /usr/local/share/gnucash/icons/hicolor/32x32 > -- Installing: /usr/local/share/gnucash/icons/hicolor/48x48 > -- Installing: /usr/local/share/gnucash/icons/hicolor/96x96 > -- Installing: /usr/local/share/gnucash/icons/hicolor/64x64 > -- Up-to-date: /usr/local/share/icons/hicolor > -- Up-to-date: /usr/local/share/icons/hicolor/256x256 > -- Up-to-date: /usr/local/share/icons/hicolor/256x256/apps > -- Installing: /usr/local/share/icons/hicolor/256x256/apps/gnucash-icon.png > -- Up-to-date: /usr/local/share/icons/hicolor/scalable > -- Up-to-date: /usr/local/share/icons/hicolor/scalable/apps > -- Installing: /usr/local/share/icons/hicolor/scalable/apps/gnucash-icon.svg > -- Up-to-date: /usr/local/share/icons/hicolor/24x24 > -- Up-to-date: /usr/local/share/icons/hicolor/24x24/apps > -- Installing: /usr/local/share/icons/hicolor/24x24/apps/gnucash-icon.png > -- Up-to-date: /usr/local/share/icons/hicolor/128x128 > -- Up-to-date: /usr/local/share/icons/hicolor/128x128/apps > -- Installing: /usr/local/share/icons/hicolor/128x128/apps/gnucash-icon.png > -- Up-to-date: /usr/local/share/icons/hicolor/22x22 > -- Up-to-date: /usr/local/share/icons/hicolor/22x22/apps > -- Installing: /usr/local/share/icons/hicolor/22x22/apps/gnucash-icon.png > -- Up-to-date: /usr/local/share/icons/hicolor/16x16 > -- Up-to-date: /usr/local/share/icons/hicolor/16x16/apps > -- Installing: /usr/local/share/icons/hicolor/16x16/apps/gnucash-icon.png > -- Up-to-date: /usr/local/share/icons/hicolor/32x32 > -- Up-to-date: /usr/local/share/icons/hicolor/32x32/apps > -- Installing: /usr/local/share/icons/hicolor/32x32/apps/gnucash-icon.png > -- Up-to-date: /usr/local/share/icons/hicolor/48x48 > -- Up-to-date: /usr/local/share/icons/hicolor/48x48/apps > -- Installing: /usr/local/share/icons/hicolor/48x48/apps/gnucash-icon.png > -- Up-to-date: /usr/local/share/icons/hicolor/96x96 > -- Up-to-date: /usr/local/share/icons/hicolor/96x96/apps > -- Installing: /usr/local/share/icons/hicolor/96x96/apps/gnucash-icon.png > -- Up-to-date: /usr/local/share/icons/hicolor/64x64 > -- Up-to-date: /usr/local/share/icons/hicolor/64x64/apps > -- Installing: /usr/local/share/icons/hicolor/64x64/apps/gnucash-icon.png > > Like Stephen Gnucash seems to be working fine in spite of this in my case. > Despite the icons not being there, they are being used in GnuCash. I have > explicitly checked the post/unpoost invoice and create, edit, duplicate > invoice icons and they are present and working. Definitely very strange > unless the icons are built into the program and are only in the share > dircectory for reference or some historical purpose. I will try and chack > further when i have a bit more time. > > David Cousens --Steve Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Upgrading GC under Ubuntu
On 07/04/2018 01:57 AM, Colin Law wrote: > Eureka moment - it is obvious if I just look in the right place. The > full cmake command I have is > > file(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share/gnucash/icons" > TYPE DIRECTORY FILES > "/home/colinl/apps/gnucash-3.2/data/pixmaps/hicolor" REGEX ".*/apps.*" > EXCLUDE) > > The REGEX is given the full path, which includes > /home/colinl/apps/gnucash-3.2/data/pixmaps/hicolor. I have put my > source directory under a folder called apps so the regex matches > everything! Changing the regex to > > REGEX "hicolor/.*/apps.*" EXCLUDE > > works perfectly. > > Colin I love computers. They do exactly what they are told to do. It's just that sometimes what I think they were told is something different than what the computer thinks. It usually wins! When you finally see things through its eyes you have this Aha! Insight. (with apologies to Martin Gardiner) --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.
Re: [GNC] Fwd: The two modules
On 06/27/2018 04:41 PM, DaveC49 wrote: > Stephen, > > As an accountant I would prefer to have parent accounts as placeholder > accounts which cannot be the target of transactions directly (this can be > set in the edit Account dialog and marks the account as read only) as the > placeholder total should then be the sum of its active child accounts. This > will give clean easy to read reports which make obvious sense. My wife is also an accountant and prefers that method also. I setup my books that way. However, I'm trying to help Christopher with modifying his version of the balance sheet to more fully meet my wife's expectations (she likes the formatting of the eguile version but hates the inclusion of the income statement within the equity portion of that report. <> > An active non-placeholder account should not have child/subaccounts, > although I don't think GnuCash actually prevents this. In this case, the > parent account total is the sum of the child subaccount totals plus the sum > of any transactions into the parent account itself. This will make a report > look to be incorrect as the sum of transactions into the parent account is > not presented separately and its total will not be the sum of the child > account totals. I can't think of a use case where this would be desirable, > but some people may be happy with that behavior. I don't think this behavior > has changed since I first checked it out in an earlier version (around 2.2 I > think). This is a problem. In a good report the parent with transactions should show a line for the parent so that the column total for that parent (on the balance sheet) is correct. At least, as a former IT software development manager, I would insist that a column total show all of it's inputs. Maybe the financial folks can band together to get the developers to enforce no-transactions to a parent account. <> > Hope this helps make sense and helps you to get GnuCash working as you want > > Cheers > > David Cousens > Thanks David. Except for the layout of the Balance Sheet and the Income Statement reports, this has been working out great. --Steve Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D ___ 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] Fwd: The two modules
On 06/28/2018 10:10 AM, Geert Janssens wrote: > Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler: >> On 06/27/2018 04:41 PM, DaveC49 wrote: >>> An active non-placeholder account should not have child/subaccounts, >>> although I don't think GnuCash actually prevents this. In this case, the >>> parent account total is the sum of the child subaccount totals plus the >>> sum >>> of any transactions into the parent account itself. This will make a >>> report >>> look to be incorrect as the sum of transactions into the parent account is >>> not presented separately and its total will not be the sum of the child >>> account totals. I can't think of a use case where this would be desirable, >>> but some people may be happy with that behavior. I don't think this >>> behavior has changed since I first checked it out in an earlier version >>> (around 2.2 I think). >> This is a problem. In a good report the parent with transactions should >> show a line for the parent so that the column total for that parent (on >> the balance sheet) is correct. >> > This seems to make most sense to me: > If a parent has transactions put it twice: > Once as aggregate account and once as an account on it's own. That would meet > both needs. The aggregate will total it's own transactions with those of its > child accounts. Or put differently the aggregate account would treat itself > as > a child account. I like that approach. >> Maybe the financial folks can band together to get the developers to >> enforce no-transactions to a parent account. > I think we should modify the concepts. "Placeholder" is ambiguous and for the > lack of a better solution is has been abused to make existing accounts read- > only. Surprise! Given enough rope we will tie knots. > Perhaps it's time to introduce a "View" type account which is only used to > structure the account tree (and as aggregate account in reports) and next to > that introduce a read-only attribute to normal accounts. Placeholder could > then be phased out in favor of these two. We could even try to automate this > using some heuristics: > - if a placeholder account has no transactions, convert it into a view account > - if a placeholder account does have transactions, make it read-only instead. > Add in an informational message to the user about what was done so the user > can make corrections if needed (like adding view accounts if an account was > being used for both functions). > > Geert > > This would help the non-accountant to setup their books in a more traditional form. Especially if GnC enforced parent accounts to become "View" accounts. It would also help the report writers to present the information logically without having to resort to extra decision making about how to handle a parent who has transactions. --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.
Re: [GNC] Forward payments
On 06/28/2018 12:25 AM, Tony Vanson wrote: > Thank you for your quick response. My Staff account is set up as an Expense > not as an Asset. In this particular case would I need to set up a new > account Current Assets:Staff - as a child account under Current Assets? > Cheers I would set it up as an asset. Even if you physically handed them the cash and they physically put it into their wallet for future disbursement as needed, it is still your asset. If anything is left over when you return it would come back to you for put back into the bank. I presume you will get periodic statements about how that asset is being disbursed so you can make the appropriate entries to transfer funds to the appropriate expense accounts (just like you do now, except the asset side is not the bank but the "staff accountant"). That way you could notice if the funds were running short and do online banking to send more funds to that person. > On Thu, Jun 28, 2018 at 2:08 PM, Maf. King wrote: > >> On Thursday, 28 June 2018 07:53:02 BST Tony Vanson wrote: >>> Hi all, >>> Hopefully someone can advise me how to treat the following problem which >>> stumps me. >>> I am using GNUcash 2.6.18 on Windows 10. >>> I shall be away for several months and have transferred credit from my >>> Savings account to my Staff account with a lump sum amount for her to pay >>> her Salary, Electricity, Pool chemicals, Internet access etc, on the due >>> date. All these are set up as expense accounts. >>> All accounts, apart from her Salary and Internet access, are variable in >>> amount and payment date. >>> I assume that I have to split the lump sum to the various accounts as >> they >>> are paid or is there some other method? >>> I also need to take into account that the payment I've made to the Staff >>> account may be too small or too large. >>> Any enlightenment to a personally perplexing problem would be greatly >>> appreciated. >>> P.S. I only use GNUcash for my personal information and does not have any >>> taxation or other legal requirement. >>> Cheers >> Hi Tony. >> >> Do you have accounts in GC that represent your Savings account & Staff >> accounts? >> >> To me it seems that you should let GC reflect reality - you've got a >> transaction from Assets:Savings to Assets:StaffAccount. as the payments >> are >> made, you have transactions between Assets:StaffAccount & expense accounts >> as >> appropriate. (presumably, you could be emailed details of payments made to >> keep your GC up to date?) >> >> If, on your return, you have balance left in Assets:StaffAccount, just >> record >> a transaction putting it back into savings. >> >> HTH, >> Maf. >> >> >> >> >> > ___ 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] compiling 3.2 on linux (ubuntu)
On 09/29/2018 10:52 PM, Jeff Abrahamson wrote: > I downloaded 3.2.tar.bz. After unbzipping, I do this (ubuntu 18.04.1): > > $ mkdir -p gnucash-3.2/build-3.2 > $ cd gnucash-3.2/build-3.2 > $ cmake ../gnucash/ > CMake Error at CMakeLists.txt:5 (file): > file problem creating directory: /glib-2.0/schemas > > > -- Performing Test have_mod_mask > -- Performing Test have_mod_mask - Failed > CMake Error at gnome/CMakeLists.txt:59 (gnc_add_swig_guile_command): > Unknown CMake command "gnc_add_swig_guile_command". > > > CMake Warning (dev) in CMakeLists.txt: > No cmake_minimum_required command is present. A line of code such as > > cmake_minimum_required(VERSION 3.10) > > should be added at the top of the file. The version specified may > be lower > if you wish to support older CMake versions for this project. For > more > information run "cmake --help-policy CMP". > This warning is for project developers. Use -Wno-dev to suppress it. > > -- Configuring incomplete, errors occurred! > See also > "/home/jeff/.../gnucash/gnucash-3.2/build-3.2/CMakeFiles/CMakeOutput.log". > See also > "/home/jeff/.../gnucash/gnucash-3.2/build-3.2/CMakeFiles/CMakeError.log". > $ > > CMakeError.log suggests the real problem is not finding gdk/gdk.h. This > is provided from two packages, libgtk-3-dev and libgtk2.0-dev. But > installing those doesn't change the error. (I manually confirm gdk.h is > present: /usr/include/gtk-2.0/gdk/gdk.h.) > > Thinking this was a caching problem, I removed and recreated > ./build-3.2/. Same problem. > > Any pointers? > I also compile on Ubuntu 18.04. However, I make my build folder at the same level as the gnucash source. I think your cmake is setup assuming you would go up a level and over and back down to gnucash. However, you are not setup that way. Either do cmake .. or move your build folder up to the same level as the source. On my system I have a main Projects folder (several different projects of which GnuCash is just one more): $HOME/Projects/GnuCash/gnucash-3.2 $HOME/Projects/GnuCash/GNC-Build-3.2 cd $HOME/Projects/GnuCash/GNC-Build-3.2 cmake ../gnucash-3.2 Best --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Repeatable Mac crash
On 09/30/2018 10:07 AM, Michael or Penny Novack wrote: > >>> On Sep 29, 2018, at 4:30 AM, Robert Kesterson >>> wrote: > >>> >>> When I open Gnucash, it opens the last file I had open, which is >>> great. Then I start the second instance from a terminal with “open >>> -n /Applications/GnuCash.app” and it starts up. Since the most >>> recent file is already open, it will complain that it can’t get the >>> lock and ask what I want to do. Since there isn’t an “open a >>> different file” option ... > > But there IS a way to open gnucash for another file. Or rather a way > to start gnucash without it opening a file, thus allowing you to > specify what file you want to open. The -nofile option << I don't know > exactly how to specify that for a mac >> > > I am always opening gnucash that way since keeping four sets of books > and the last opened is usually not the one I want to open. > > Michael > I found it easier to just navigate to the file with the file explorer (at least on Linux) and double click on the file. GnuCash then launches and opens that file. > ___ > 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Libboost_regex needed
Not sure who maintains the Wiki for Ubuntu builds, but I had to install libboost-all-dev on my Ubuntu 18.04 last night in order to run GnuCash after a successful compile/build. Longer story -- Tried to upgrade to 18.10. Worked until I shut down and powered up the next morning. Could not mount the home directory (turns out it is encrypted and the mount got a "bad address"). Trying to roll back to 18.04 compounded the problem (booting off a live USB ISO reported the disk config was wrong). I finally gave up and loaded a fresh Ubuntu 18.04 and have spent the last two days getting things installed and back running. GnuCash was one of the last ones. I pulled the latest from github (git clone) did a clean cmake, make, sudo make install but ran into the missing shared library libboost-regex. After an hour of digging I finally found reference to libboost-all-dev. That installed a lot of things but cured the missing shared library. I think I'll give 18.10 a couple of months to mature some more. I also un-encrypted the home directory. Thankfully the restore from the daily backups worked (took a long time). Wish there was a way to backup the current o/s state and restore/reload it automatically rather than all that typing I had to do to get items added back. I'm sure I missed a lot (my favorites are not so crowded today)! --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Libboost_regex needed
On 10/23/18 8:54 AM, Colin Law wrote: I have not heard of any problems with encrypted drives on Ubuntu 18.04, did you ask on, for example, the Ubuntu Users list for help getting it sorted? Problem happened on 18.10 after upgrade and reboot. Folks gave suggestions and it made things worse. At least I'm back up with my restore from backup. Colin On Tue, 23 Oct 2018 at 16:49, Stephen M. Butler wrote: Not sure who maintains the Wiki for Ubuntu builds, but I had to install libboost-all-dev on my Ubuntu 18.04 last night in order to run GnuCash after a successful compile/build. Longer story -- Tried to upgrade to 18.10. Worked until I shut down and powered up the next morning. Could not mount the home directory (turns out it is encrypted and the mount got a "bad address"). Trying to roll back to 18.04 compounded the problem (booting off a live USB ISO reported the disk config was wrong). I finally gave up and loaded a fresh Ubuntu 18.04 and have spent the last two days getting things installed and back running. GnuCash was one of the last ones. I pulled the latest from github (git clone) did a clean cmake, make, sudo make install but ran into the missing shared library libboost-regex. After an hour of digging I finally found reference to libboost-all-dev. That installed a lot of things but cured the missing shared library. I think I'll give 18.10 a couple of months to mature some more. I also un-encrypted the home directory. Thankfully the restore from the daily backups worked (took a long time). Wish there was a way to backup the current o/s state and restore/reload it automatically rather than all that typing I had to do to get items added back. I'm sure I missed a lot (my favorites are not so crowded today)! --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 3.3 crash after upgrading from Ubuntu 18.04 to 18.10
On 10/25/18 1:06 AM, Colin Law wrote: This was an Ubuntu 18.04 machine with 2.16.9 installed from the Ubuntu repo. I upgraded the machine to Ubuntu 18.10 and GC got upgraded to 3.3 from the repo. The machine has a long history however so it is not possible to say how the guile libs were installed. I do have another machine still running Ubuntu 18.04 and GC 2.6.19 and I see it has guile-2.0 installed and not guile-2.2. I will be upgrading that one once I am happy that Ubuntu 18.10 does not have any major problems. Colin Be sure to do a shutdown and power on cycle first on th 18.10. I lost access to my home directory on power up (got a mount: bad address message). I had to reload 18.04 and restore files from a backup. I think part of the problem was the home directory was encrypted -- and thus the mount issue at login. BTW, the login just cycled around which was the first clue something was wrong. --Steve On Thu, 25 Oct 2018 at 01:10, John Ralls wrote: Good detective work. Guile is supposed to be able to handle having multiple versions installed and to link the right libraries, but I suppose if you had guile-2.0-compiled files in a guile cache and guile-2.2-compiled ones installed by the .deb it might get confused. Was this a clean install of Ubuntu or were you upgrading and using a GnuCash you’d built yourself before upgrading? Regards, John Ralls On Oct 24, 2018, at 9:40 AM, Colin Law wrote: Yes, that was the issue (two versions of boot-9.scm). Having checked dependencies and so on, including doing a dry run remove to check it wasn't going to remove anything critical, I uninstalled guile-2.0-libs and now it runs ok. So is this a packaging bug? Colin On Wed, 24 Oct 2018 at 16:39, Colin Law wrote: Further to this I see I have two files ice-9/boot-9.scm /usr/share/guile/2.2/ice-9/boot-9.scm /usr/share/guile/2.0/ice-9/boot-9.scm Could it be picking up the wrong one, or is that a red herring? Colin On Wed, 24 Oct 2018 at 15:57, Colin Law wrote: Just upgraded my Ubuntu 18.04 to 18.10. This upgraded GC from 2.6.19 (at least I think it was 19) to 3.3 and now GC crashes immediately on startup. Starting in a terminal gives result below. There is nothing in the trace file. On another machine with a fresh install of 18.10 GC 3.3 runs fine so I guess it is to with updated file locations or something. Colin $ gnucash Backtrace: In ice-9/boot-9.scm: 2994:20 19 (_) 2312:4 18 (save-module-excursion _) 3014:26 17 (_) In unknown file: 16 (primitive-load-path "gnucash/utilities" #) In utilities.scm: 28:0 15 (_) In ice-9/boot-9.scm: 3377:20 14 (process-use-modules _) 222:17 13 (map1 (((gnucash core-utils 3378:31 12 (_ ((gnucash core-utils))) 2800:17 11 (resolve-interface (gnucash core-utils) #:select _ # _ # …) In ice-9/threads.scm: 390:8 10 (_ _) In ice-9/boot-9.scm: 2726:13 9 (_) In ice-9/threads.scm: 390:8 8 (_ _) In ice-9/boot-9.scm: 2994:20 7 (_) 2312:4 6 (save-module-excursion _) 3014:26 5 (_) In unknown file: 4 (primitive-load-path "gnucash/core-utils" #) In core-utils.scm: 40:0 3 (_) In ice-9/boot-9.scm: 2071:24 2 (call-with-deferred-observers #) 260:13 1 (for-each # …) In unknown file: 0 (scm-error misc-error #f "~A ~S" ("Undefined variab…" …) …) ERROR: In procedure scm-error: Undefined variable: gnc-build-userdata-path ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 3.3 crash after upgrading from Ubuntu 18.04 to 18.10
On 10/25/18 8:56 AM, Colin Law wrote: On Thu, 25 Oct 2018 at 16:51, Stephen M. Butler <mailto:kg...@arrl.net>> wrote: Be sure to do a shutdown and power on cycle first on th 18.10. When? The last thing that the upgrade to 18.10 does is a reboot. That was successful. After that I shutdown for the night (laptop). The next day when it powered up got the login cycle that just went back to the login page instead of showing the desktop. Hitting clt/alt/F3 got a terminal screen and that login showed the login-password working but the mount of the home directory failed. Now, I started back a few years ago (forget which version) and have had a lot of changes over the years. Maybe a newer starting point would work OK. Also, my home directory was encrypted. So, if yours isn't, things should work. Anyway, I've since removed the encryption but am holding off on 18.10 for a few weeks. I lost access to my home directory on power up (got a mount: bad address message). I had to reload 18.04 and restore files from a backup. I think part of the problem was the home directory was encrypted -- and thus the mount issue at login. BTW, the login just cycled around which was the first clue something was wrong. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 3.3 CSV Importer Freezing on MacOS
On 11/5/18 7:42 AM, btrib wrote: True! ...however, text editor is unable to open the main data file. How can the main file be manually accessed? Uncompress the file. Your OS should have a utility that can do that. On Linux I would use gunzip. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 3.3 CSV Importer Freezing on MacOS
On 11/5/18 11:09 AM, btrib wrote: So, I'm just trying to understand, I deactivate compression and this makes the file openable as xml? After GNC has saved the file one more time. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Compiling 2.6.12
On 08/31/2018 10:36 AM, Paul Schwartz wrote: > I have been trying to compile 2.6.12 on Ubuntu 18.04. I have not been able > to get past the recognition of glib-2.0 in configure. I have installed > glib-2.0 and glib-2.0-dev with apt. I have tried setting PKG_CONFIG_PATH > to /usr/share before running configure. Nothing seems to work. Some > suggestions would be appreciated. > > Paul > What error messages do you get? I was compiling 3.1 and 3.2 on Ubuntu 18.04 and had to load the generic glib and let 18.04 figure out which one to install. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] [regression] delete key functionality lost after pasting into a transaction field
On 09/02/2018 09:39 AM, Adrien Monteleone wrote: > I think this is already fixed for the upcoming 3.3 release. (end of > September?) > > Regards, > Adrien > >> On Sep 1, 2018, at 4:37 PM, jim.e wrote: >> >> I also am having the same problem of after pasting to a transaction, >> backspace and delete keys don't work. >> Thanks I haven't had the problem since grabbing 3.2-100 from github a few weeks back. So, I'm pretty sure the fix is already in (but not in 3.2 base) and ready for 3.3. >> >> >> >> -- >> 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. > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] *.deb package for GnuCash 3.4 Released
On 12/31/18 2:17 AM, Colin Law wrote: > On Mon, 31 Dec 2018 at 10:06, Colin Law wrote: >> On Sun, 30 Dec 2018 at 20:33, Stephen M. Butler wrote: >>> For those interested in a deb file but not willing to compile yourself: >>> https://drive.google.com/open?id=172BMIvLgD7twcGEWkR5GcddoZ_A4QWfY --> >>> gnucash_3.4-0-1_amd64.deb >> I am trying this on Ubuntu 18.10 and when running it I get >> error while loading shared libraries: libboost_regex.so.1.65.1: cannot >> open shared object file: No such file or directory > OK, found solution > sudo apt install libboost-regex1.65.1 > > It seems to be working ok on Ubuntu 18.10 now. Subject to further > testing of course. Will let you know. > > Colin > . > Thanks Colin for that info. I was starting a search for libboost but then thought to read the rest of the emails and you had already found the solution. Along that vein, the checkinstall documentation seems to imply the deb file is good only for same O/S and release #. Launchpad seems to be the only open source platform for ppa but it is oriented toward Ubuntu. It does appear to have options for 32/64 bit and the various Ubuntu and Debian releases. However, their requirements for packaging are quite a ways beyond my skill level. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 pEpkey.asc Description: application/pgp-keys ___ 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] Location of GnuCash data files
On 12/31/18 9:29 AM, Stan Brown wrote: > Under "Uddating advice", I believe Finbar Mahon wrote: > >> On reading it I see that what is missing is how to find where the >> gnucash file is saved. The problem is that where it is was specified >> by yourself when you first saved your accounts file. Just as it is if >> you save a word processor document for example, so the wiki assumes >> you remember where that is. > True enough, and a couple of people have suggested how to find a file. > > But word processors typically DON'T put dozens of log files in the same > directory or folder as the actual document. Because Gnucash does, when > someone naively saves a Gnucash data file to her desktop, it's almost > immediately cluttered with log files. The same was true when I naively saved > my first GnuCash file to the same folder as my financial spreadsheets -- > relatively quickly they were buried under a blizzard of log files. (Granted, > I'm exaggerating a bit, for effect.) > > I understand the usefulness of the log files, but why aren't they written to > the temp folder? Or better yet, why aren't they written to a user-specified > location, with the temp folder as default? > This sounds like an idea that needs to be filed as an enhancement request. I'd suggest an alternative might be to create two sub-folders in the folder where the data file is stored: 1. ./GnuCash-Backups 2. ./GnuCash-Logs That would keep them from cluttering up the main folder but be readily at hand and easily identifiable. Of course, I've used *Nix style paths but the idea should port to Windows (I don't know Mac). --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 pEpkey.asc Description: application/pgp-keys ___ 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] *.deb package for GnuCash 3.4 Released
On 12/31/18 5:54 AM, Les wrote: > Thanks for the great work Steve. > > I am currently using Linux Mint 18.2 and GC 2.6.17. I am wondering if > this .deb will run on my system, or will I have to update Linux MInt > to 19.0? > > Thanks > > Les I think we are in exploration mode at this point. Checkinstall says it is only for same make/model. Colin found that he could get it to work on Ubuntu 18.10 (my box is 18.04). I am not that knowledgeable of how the various distros map to each other. --Steve > > On 12/30/18 2:25 PM, Stephen M. Butler wrote: >> For those interested in a deb file but not willing to compile yourself: >> https://drive.google.com/open?id=172BMIvLgD7twcGEWkR5GcddoZ_A4QWfY >> --> gnucash_3.4-0-1_amd64.deb >> >> The zero after 3.4 is the commit number after the tag (there are >> currently none) and the one after that is the first attempt to build >> that on my box. >> >> I have removed the interim 3.3 versions from Google drive and now >> only have the base 3.3 version also available: >> https://drive.google.com/open?id=1PUEq8qE4yzq_HrBfJZQ376QbdTmJdYsP >> --> gnucash_3.3-0-1_amd64.deb >> >> These were built on Ubuntu 18.04 based on a git pull of the maint >> branch. >> >> --Steve >> >> >> On 12/30/18 12:01 PM, John Ralls wrote: >>> The GnuCash development team announces GnuCash 3.4, the fifth >>> release of the 3.x stable release series. >>> >>> Changes >>> >>> Between 3.3 and 3.4, the following bugfixes were accomplished: >>> >>> • Bug 498072 - GnuCash show taxes on invoice when individual >>> taxes is not checked >>> • Bug 760825 - On duplicating a bill, the entry dates should be >>> set to the bill date, not to the current date - followup: >>> Use neutral time on entry post dates instead of canonical time >>> • Bug 767772 - Associated file with transaction is lost when >>> moving entry between accounts >>> • Bug 775580 - Inaccurate information provided for "Common >>> Accounts" when using "New Account Hierarchy Setup" >>> • Bug 779565 - Treeview header combos do not work at first load >>> • Bug 788332 - Last Reconcile Date column sorts by day of month >>> not date >>> • Bug 789674 - Close Book tool regression >>> • Bug 793156 - Incorrect date sort order in Generic import >>> matcher window >>> • Bug 795080 - Some dates reset to 01/01/1970 >>> • Bug 795237 - Update of "wohnungsw" template >>> • Bug 795425 - Version 2018 of german account template SKR49 >>> • Bug 796772 - Receivable Ageing Report invalid URL for Totals >>> column >>> • Bug 796806 - Crash after OFX import if line item dragged >>> • Bug 796842 - Add new employee window may not fit on screen >>> • Bug 796849 - Load another QIF file causes "that file already >>> loaded" dialog >>> • Bug 796875 - Unable to use arrow keys to advance past >>> pre-filled text in register >>> • Bug 796878 - test-qofsession fails on x86_32. >>> • Bug 796883 - Register text oddities >>> HOME and END need to be treated like right and left arrow keys. >>> • Bug 796886 - OFX Import does not show source account in the >>> transaction matching window >>> • Bug 796887 - Remove account slot key color if there is no >>> valid color >>> • Bug 796893 - invoice.GetDatePosted() and other date related >>> functions returns strange values for uninitalised dates. >>> • Bug 796896 - Button to complete an export not intuitively >>> placed or discoverable >>> • Bug 796903 - Crash when searching invoice by Invoice Owner >>> • Bug 796914 - Customer Summary is giving error >>> • Bug 796915 - Update Account colour background >>> • Bug 796940 - Invalid transaction date-posted KVP causes >>> date-posted to not be saved. >>> • Bug 796944 - Tab navigation From Company Address field in New >>> Book Options >>> • Bug 796945 - Search Search Criteria window does not scroll >>> when added criteria exceed a certain amount >>> • Bug 796948 - Scheduled Transactions Entered Since Last Run Are >>> not Visible >>> • Bug 796949 - Incorrect conversion of 0,01 USD to EUR >>> • Bug 796960 - Incorrect amount sort order in Generic import >>> matcher window >>> • Bug 796961 - Can't overwrite existing MYSQL database, V3.3. >>>