Excellent idea. Thanks
Sent from my Verizon, Samsung Galaxy smartphone -------- Original message -------- From: gnucash-user-requ...@gnucash.org Date: 7/27/18 5:09 AM (GMT-05:00) To: gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 184, Issue 57 Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Re: GNUcash 3.2 file open issue (Adrien Monteleone) 2. Re: Payroll add-on, module, software? (R. Victor Klassen) 3. Re: Change text color (GT-I9070 H) 4. Posting Asset expenses via Vendor Bill (dlbonline) 5. Entering a 2-digit year generates the wrong date (Chris Velevitch) 6. Re: Payroll add-on, module, software? (Adrien Monteleone) 7. Re: Logs. (Colin Law) 8. Re: Getting My Account To Trial Balance (H M MacDonald OBE) 9. Re: Bug in design of commodity sell transactions? (was Re: Getting My Account To Trial Balance) (DaveC49) 10. Re: GNUcash 3.2 file open issue (DaveC49) 11. Re: Nabble Delay? (was Re: Future Payments) (DaveC49) ---------------------------------------------------------------------- Message: 1 Date: Thu, 26 Jul 2018 17:24:58 -0500 From: Adrien Monteleone <adrien.montele...@lusfiber.net> To: gnucash-user <gnucash-user@gnucash.org> Subject: Re: [GNC] GNUcash 3.2 file open issue Message-ID: <1dd9add6-c7dd-44f0-a3c2-c4a5a1718...@lusfiber.net> Content-Type: text/plain; charset=utf-8 As Mint is based on Ubuntu you *might* be facing the read-only usb bug. (which seems to keep reappearing after being allegedly fixed) What are the permissions on the parent folder for the mount point of the drive? And then the same for the gnucash folder and files? (I?m looking for either octals like ?755? or the string type like ?wrxwrx-r-?) And, I know this sounds terrible for Linux, but does a log-out/in or a system restart magically make the external drive read-write? (a strong indication of the aforementioned bug) Regards, Adrien > On Jul 26, 2018, at 4:15 PM, Don Pawluk <don.paw...@gmail.com> wrote: > > Gave it a try. Can open the file, but only as read-only and it will not save > back to the original location. Creates a temporary directory > \run\users\doc\1a36500 and puts files there. the files disappear when GNUcash > is closed. Have full access to read & write to the source directory when not > in GNUcash, but it does not seem to have write access. > > Thanks for the suggestion. > > On Thu, Jul 26, 2018 at 12:02 PM, Adrien Monteleone > <adrien.montele...@lusfiber.net> wrote: > Don, > > Presumably you already checked if the drives are visible where you expect > using Caja? > > If so, can you navigate to the usb/external and open the file from there? > > Regards, > Adrien > > > On Jul 26, 2018, at 1:50 PM, Don Pawluk <don.paw...@gmail.com> wrote: > > > > Running on Linux Mint 18.3 Mate, open file will not provide access to usb > > external drives or smb dirves. Will open on local PC drives. When bringing > > up file system there is no media folder where I would normally expect to > > find the usb external drives or smb drives. > > > > Any help would be appreciated, Don > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for 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. > ------------------------------ Message: 2 Date: Thu, 26 Jul 2018 18:40:28 -0400 From: "R. Victor Klassen" <rvklas...@gmail.com> To: John Ralls <jra...@ceridwen.us> Cc: "Maf. King" <m...@chilwell.net>, Gnucash Users <gnucash-user@gnucash.org> Subject: Re: [GNC] Payroll add-on, module, software? Message-ID: <ba203c22-2838-4df7-b270-69adb7afb...@gmail.com> Content-Type: text/plain; charset=utf-8 When I think of the requirements for payroll, it seems like it would require more than a ?plug-in? that accepts parameters that vary by jurisdiction. It would need to be more like a full programming language (well, not full - arbitrary loop controls not required - for language geeks, it would likely be regular, not even context-free). Having written a (brittle) program to generate payroll for Ontario, Canada, for the special case of agricultural workers - and yes, it is that specific - I could imagine (if I had the time and inclination) writing a program that handled all the cases of payroll for any employment class in any province of Canada. It would likely be several hundred lines of code, and refer to a database of probably a dozen and a half parameters per jurisdiction. Any idea that that would be universal beyond Canada would be fantasy. It might be easy, it might be hard to generalize to the US states. But it would be quite a lot of work to verify it worked for all 50 states - which is to say the structure would work, without getting the parameters right. And those are likely two of the most similar super-jurisdictions. It might eventually get easy to add jurisdictions. But it might not. But my point is that I would expect to need to encode an algorithm per jurisdiction, not just a series of parameters (like tax brackets, basic exemptions). > On Jul 26, 2018, at 11:28 AM, John Ralls <jra...@ceridwen.us> wrote: > > > >> On Jul 26, 2018, at 7:51 AM, John Ralls <jra...@ceridwen.us> wrote: >> >> >> >>> On Jul 26, 2018, at 6:01 AM, Maf. King <m...@chilwell.net> wrote: >>> >>> On Thursday, 26 July 2018 12:36:27 BST Mike or Penny Novack wrote: >>> >>>> >>>> Saying that no third party has expressed interest in writing something >>>> that would send a feed to gnucash ignores that gnucash does not have the >>>> capability of (properly) dealing with batch feeds. >>>> >>>> Michael >>> >>> Why do the words "chicken and egg" pop into my head...? >>> >>> IIRC, the original Business Features added by Derek were a module. One >>> could >>> theoretically compile GC (1.6 or 1.8?) with a flag and the whole A/P & A/R >>> subsystem wouldn't exist. But that may be the 20 years that John referred >>> to! >> >> No, Derek isn?t a 3rd-party developer. He's very much part of the core team >> and has been for most of those 20 years, though he?s shifted his >> contributions from coding to maintaining the infrastructure. > > It does occur to me, though, that more broadly there has been third-party > interest, just not in writing GnuCash plugin modules. Doug Doughty?s reports, > for example, are a different form of plug-in. S?bastien de Menten?s piecash > is completely external to GnuCash, using SQLite to directly access GnuCash > databases is another example. Anyone who?s used the GnuCash API or Scheme and > Python bindings is a 3rd party extending GnuCash, even if they don?t publish > their work for others to use. > > 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. ------------------------------ Message: 3 Date: Thu, 26 Jul 2018 20:27:15 -0400 From: GT-I9070 H <gti90...@gmail.com> To: adrien.montele...@lusfiber.net Cc: gnucash-user <gnucash-user@gnucash.org> Subject: Re: [GNC] Change text color Message-ID: <CAGci8eLMONvem_Zn++29oPhOBi1+t0Mv40tkjU0306_a9=p...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" One file for everything is better. In my .ini file there is only one section and one line to change the text size of the accounts page because it was the only method I found and worked, the .css method for this fails. For everything else I use .css, I've customized the registry with .css. For tabs I already got change color and font. I had already done searches on the list and I was not lucky. Of course we can wait, without problems, meanwhile I'll keep trying. Regards GTI Em qui, 26 de jul de 2018 ?s 18:20, Adrien Monteleone < adrien.montele...@lusfiber.net> escreveu: > Personally, I wouldn?t mess with .ini methods. I?d opt for a custom css > file. Then the task is to find out the nodes in the app you want to change > and set a ?color: ? declaration for that node. It?s possible that the node > of the main window or the CoA tab alone could get a color: declaration to > change the font color across the board. (if you gleaned from reading the > css-overview, every UI element?windows, controls, et cetera all have > ?nodes? that you can style according to your tastes. This is analogous to > HTML elements.) > > This is where the inspector comes in. Otherwise, do a list search as I > recall someone making this or similar changes in the last two or three > months. Perhaps one of the nodes they talk about is the one you want. > > I just cleaned out my 2.6.x installation in Ubuntu 16.04 and will get > around to building 3.2 or 3.3 likely tomorrow and then fire up the > inspector to start checking things out. I?d like to document in the wiki > and on git ALL of the UI nodes with screenshots. If you can wait a day or > two, I?ll make the first discovery the CoA text nodes and report them back > here. > > Regards, > Adrien > > > On Jul 26, 2018, at 4:20 PM, GT-I9070 H <gti90...@gmail.com> wrote: > > > > About the Inspector, my deductions are confirmed! ? ;) > > > > > > The question marks led you to think that my doubt was in what went after > the equal sign of the expression "gtk-font-color = ????". > > Thank you. Good clarifications about color names, but I have already > studied this on > https://developer.gnome.org/gtk3/stable/chap-css-overview.html and other > sites and in this part there are no problems. > > > > Well ... deductions are more of our abilities and for me there is a > great deal of success. > > > > Then ... the expression "gtk-font-color = ????" is one more of my > deductions, was invented by me, I have never seen this written elsewhere > and this is the problem. > > What is the correct expression for .ini file and/or .css file? > > > > I did several searches and testing and did not get anything that worked, > including with the expression: gtk-font-color=color name > > > > Regards > > GTI > > > > Em qui, 26 de jul de 2018 ?s 14:00, Adrien Monteleone < > adrien.montele...@lusfiber.net> escreveu: > > The inspector is for *nix and is part of GTK. I looked around to see if > it will run on windows (since GTK itself can run on windows) but have come > up dry so far. My own dabbling with the inspector is on the backburner, but > I?ll post my findings here and on the wiki when I get to it. > > > > As for the color, you need a color name, a reference to a system color, > or a color code. (which may be hex or rgb, rgba) Color names are either the > HTML ?websafe? color names, or pre-defined gtk-color names. > > > > See this page here and scroll down to the color section for exact > specifications: > https://developer.gnome.org/gtk3/stable/chap-css-overview.html > > > > So if you wanted text in steel blue, you could use either: > > > > gtk-font-color=SteelBlue > > > > or > > > > gtk-font-color=#4682b4 > > > > assuming ?gtk-font-color? is the correct property. > > > > Regards, > > Adrien > > > > > > > > > On Jul 26, 2018, at 10:53 AM, GT-I9070 H <gti90...@gmail.com> wrote: > > > > > > Hi Adrien, > > > Thanks for the reply. > > > > > > I forgot to mention that I'm on Windows 10. > > > I had already looked here https://wiki.gnucash.org/wiki/GTK3 and > found nothing to change the text color of the accounts page. > > > > > > The phrase "To enable it run in a terminal :" here > https://wiki.gnome.org/Projects/GTK%2B/Inspector does not clarify which > terminal and suggests that Inspector does not run on Windows. > > > Windows can't interpret these commands. > > > > > > This > > > > > > [Settings] > > > gtk-font-name=Arial 14 > > > > > > in my settings.ini file changes the font size. > > > > > > I guess I need something like: > > > > > > [Settings] > > > gtk-font-name=Arial 14 > > > gtk-font-color=???? > > > > > > to change the text color. > > > I've made some unsuccessful attempts. > > > > > > I'll keep trying. > > > > > > Regards > > > GTI > > > > > > > > > > > > Em qui, 26 de jul de 2018 ?s 04:04, Adrien Monteleone < > adrien.montele...@lusfiber.net> escreveu: > > > Look into using the GTK Inspector. > > > > > > See this: https://wiki.gnucash.org/wiki/GTK3 > > > > > > and this: https://wiki.gnome.org/Projects/GTK%2B/Inspector > > > > > > From that tool you should be able to find the selector(s) for text on > that tab. > > > > > > When you find out, please report back to help others looking to do the > same. (myself included) > > > > > > Regards, > > > Adrien > > > > > > > On Jul 21, 2018, at 10:07 PM, GT-I9070 H <gti90...@gmail.com> wrote: > > > > > > > > I use GnuCash v3.2 with Adwaita dark theme. > > > > > > > > The white color of the text on the accounts page is conflicting with > the > > > > colors of my accounts so I have to disable Preferences>Accounts>Show > the > > > > color of the account as the background color. > > > > > > > > I did some research and got a nice effect on the records pages and > tabs, > > > > but I did not get anything that worked on the accounts page. > > > > > > > > Is there anyway I can change the text color of the Accounts page? > > > > > > > > Thank you in advance > > > > GTI > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > gnucash-user@gnucash.org > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > > > ----- > > > > Please remember to CC this list on all your replies. > > > > You can do this by using Reply-To-List or Reply-All. > > > > > > > > > > > > > _______________________________________________ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > > ----- > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ------------------------------ Message: 4 Date: Thu, 26 Jul 2018 23:01:53 -0500 From: "dlbonline" <dlbonl...@cox.net> To: <gnucash-user@gnucash.org> Cc: <dlbonl...@cox.net>, <gnucash-user@gnucash.org> Subject: [GNC] Posting Asset expenses via Vendor Bill Message-ID: <002901d4255e$8e087720$aa196560$@cox.net> Content-Type: text/plain; charset="us-ascii" I am new to gnuCash, so I hope this is not already asked and answered. I have rental and flip property that carry expenses against an asset. For example, I have a painter paint a house for me. He sends an invoice, I enter the invoice into the Business->vendor->New Bill form. In the "Expense Account" column, I enter the following account (which does exist in the COA) Assets:Fixed Assets:House:473 Darlington:Paint. After the bill is posted, the transaction does not show up on the Asset's ledger. This appears to work if I enter the "Expense Account" as an existing expense account. For example Expenses:Home Repair:Paint. But, this does not show up on the ledger for the Asset, which is ultimately what I need. Is there a way to accomplish this transaction? Thanks. David Briggs dlbonl...@cox.net <mailto:dlbonl...@cox.net> 918 625 9170 ------------------------------ Message: 5 Date: Fri, 27 Jul 2018 12:57:24 +0800 From: Chris Velevitch <chris.velevi...@gmail.com> To: gnucash-u...@lists.gnucash.org Subject: [GNC] Entering a 2-digit year generates the wrong date Message-ID: <CANnPMYGAQpZaGLwB0m2cdEAGQLYd2ZReo4c2S=k6jagnsjw...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" When I enter a new transaction with a 2-digit year, the resultant date becames1899. For example, I enter 10 for the year and I get 1899 when I expect to get 2010. This worked in 2.x. Mac OSX: 10.11.6, GnuCash 3.2+ (2018-06-24) ------------------------------ Message: 6 Date: Fri, 27 Jul 2018 00:15:53 -0500 From: Adrien Monteleone <adrien.montele...@lusfiber.net> To: Gnucash Users <gnucash-user@gnucash.org> Subject: Re: [GNC] Payroll add-on, module, software? Message-ID: <77ab76f7-01d0-4c99-aff0-da3070ade...@lusfiber.net> Content-Type: text/plain; charset=utf-8 It strikes me as the problem is being overthought. If a spreadsheet can handle the calculations, it can?t be that complicated. If a spreadsheet can handle creating the proper csv for export and then import into gnucash, again, it can?t be that complicated. The complications are jurisdictional and apply BEFORE any transaction entry in csv form is generated. Maybe you accomplish this with a spreadsheet, maybe a python module or maybe even a webapp. The end result just needs to be a csv that can be imported into GnuCash. If you want to take it a step further, use the APIs to write the data and skip the csv step. I?d guess a plugin-module is possible, but it isn?t even necessary. I?d suspect plenty of people are using some combination (or other) solution that I?ve already mentioned. It?s just that they haven?t published it so no one knows about it. Someone out there is calculating payroll and automatically importing the resulting transaction to GnuCash, we just don?t know who they are or how they are going about it. (and perhaps their?s isn?t the best method even) Regards, Adrien > On Jul 26, 2018, at 5:40 PM, R. Victor Klassen <rvklas...@gmail.com> wrote: > > When I think of the requirements for payroll, it seems like it would require > more than a ?plug-in? that accepts parameters that vary by jurisdiction. It > would need to be more like a full programming language (well, not full - > arbitrary loop controls not required - for language geeks, it would likely be > regular, not even context-free). Having written a (brittle) program to > generate payroll for Ontario, Canada, for the special case of agricultural > workers - and yes, it is that specific - I could imagine (if I had the time > and inclination) writing a program that handled all the cases of payroll for > any employment class in any province of Canada. It would likely be several > hundred lines of code, and refer to a database of probably a dozen and a half > parameters per jurisdiction. > > Any idea that that would be universal beyond Canada would be fantasy. It > might be easy, it might be hard to generalize to the US states. But it would > be quite a lot of work to verify it worked for all 50 states - which is to > say the structure would work, without getting the parameters right. And > those are likely two of the most similar super-jurisdictions. > > It might eventually get easy to add jurisdictions. But it might not. > > But my point is that I would expect to need to encode an algorithm per > jurisdiction, not just a series of parameters (like tax brackets, basic > exemptions). > >> On Jul 26, 2018, at 11:28 AM, John Ralls <jra...@ceridwen.us> wrote: >> >> >> >>> On Jul 26, 2018, at 7:51 AM, John Ralls <jra...@ceridwen.us> wrote: >>> >>> >>> >>>> On Jul 26, 2018, at 6:01 AM, Maf. King <m...@chilwell.net> wrote: >>>> >>>> On Thursday, 26 July 2018 12:36:27 BST Mike or Penny Novack wrote: >>>> >>>>> >>>>> Saying that no third party has expressed interest in writing something >>>>> that would send a feed to gnucash ignores that gnucash does not have the >>>>> capability of (properly) dealing with batch feeds. >>>>> >>>>> Michael >>>> >>>> Why do the words "chicken and egg" pop into my head...? >>>> >>>> IIRC, the original Business Features added by Derek were a module. One >>>> could >>>> theoretically compile GC (1.6 or 1.8?) with a flag and the whole A/P & A/R >>>> subsystem wouldn't exist. But that may be the 20 years that John referred >>>> to! >>> >>> No, Derek isn?t a 3rd-party developer. He's very much part of the core >>> team and has been for most of those 20 years, though he?s shifted his >>> contributions from coding to maintaining the infrastructure. >> >> It does occur to me, though, that more broadly there has been third-party >> interest, just not in writing GnuCash plugin modules. Doug Doughty?s >> reports, for example, are a different form of plug-in. S?bastien de Menten?s >> piecash is completely external to GnuCash, using SQLite to directly access >> GnuCash databases is another example. Anyone who?s used the GnuCash API or >> Scheme and Python bindings is a 3rd party extending GnuCash, even if they >> don?t publish their work for others to use. >> >> Regards, >> John Ralls >> >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> ----- >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ------------------------------ Message: 7 Date: Fri, 27 Jul 2018 08:32:21 +0100 From: Colin Law <clan...@gmail.com> To: "varda...@aol.com" <varda...@aol.com> Cc: Derek Atkins <warl...@mit.edu>, varda241 via gnucash-user <gnucash-user@gnucash.org> Subject: Re: [GNC] Logs. Message-ID: <CAL=0gltbut8jay7czce9qai4agkcpc5qx-pgbkx5p8nvr0k...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" I am wondering why the log files bother you. Possibly you have done something like saving the accounts file on the desktop, so you see the log files there. If so then that is a bad plan. Instead I suggest making a folder specifically for the accounts file and using File > Save As to save it there. Then you can leave the log file setting at the default and they will be no bother, but will be there in case you need them. Colin On 26 July 2018 at 21:27, varda241--- via gnucash-user < gnucash-user@gnucash.org> wrote: > <div>Will try 1 day. Thanks</div><div><br></div>Sent from my Verizon ASUS > tablet > > -------- Original Message -------- > From:Derek Atkins <warl...@mit.edu> > Sent:Thu, 26 Jul 2018 10:55:44 -0400 > To:varda241 via gnucash-user <gnucash-user@gnucash.org> > Cc:David Carlson <david.carlson....@gmail.com>,varda241 <varda...@aol.com> > Subject:Re: [GNC] Logs. > > >Hi, > > > >varda241 via gnucash-user <gnucash-user@gnucash.org> writes: > > > >> > >> It is not just one or two. There are logs created each time I open the > >> program > > > >Which "log" are you talking about? > > > >Are you talking about the transaction logs? > >Or are you talking about the runtime (trace file) logs? > > > >There is no way to turn off transaction logs -- all you can do is define > >how long they will be kept. The shortest you can set that to is 1 day. > >If you set it to 0 it will keep them forever. > > > >> Please remember to CC this list on all your replies. > >> You can do this by using Reply-To-List or Reply-All. > > > >-derek > > > >-- > > Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory > > Member, MIT Student Information Processing Board (SIPB) > > URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH > > warl...@mit.edu PGP key available > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ------------------------------ Message: 8 Date: Thu, 26 Jul 2018 17:43:39 +0100 From: H M MacDonald OBE <sassunach...@gmail.com> To: Stan Brown <the_stan_br...@fastmail.fm>, GnuCash User List <gnucash-user@gnucash.org> Subject: Re: [GNC] Getting My Account To Trial Balance Message-ID: <d77fb7b2.3d24%sassunach...@gmail.com> Content-Type: text/plain; charset="ISO-8859-1" My accounts are showing a profit of ?20.99 which shows as an Imbalance of ?20.99. Sorry to be a bit slow on all of this but are folk saying that the ?20.99 needs to be added to current assets/equity to make the trial balance? I?ve tried that and it still fails. It can?t be added to the income as a profit since that will make the profit double. Clearly there?s something I?m still not getting ??? Thanks to everyone for their input so far. From: gnucash-user <gnucash-user-bounces+spahonsecobe=gmail....@gnucash.org> on behalf of Stan Brown <the_stan_br...@fastmail.fm> Date: Thursday, 26 July 2018 at 13:21 To: GnuCash User List <gnucash-user@gnucash.org> Subject: Re: [GNC] Getting My Account To Trial Balance David T. wrote: > For those who *do* have such holdings, a balanced transaction will still fail > the trial balance if the gain or loss isn?t entered. In this instance, there > will be no entries in IMBALANCE-XXX, since each transaction balances. > Example: buy 10 shares of X for $100, using cash from your checking account > (credit/debit of $100). Then sell those shares for $150 (debit/credit of > $150). > Both transaction balance?but where did that extra cash come from? Without > entering the gain of $50 as income, the Trial balance will fail. Is that really what happens? I can't understand why, if it does. Yes, you end up with an extra $50 in cash, and you also end up with MINUS $50 in the investment: the original debit of $100, and the sale credit of $50, leaving a credit (minus) balance of $50. As far as I can see, the trial balance still balances. Of course, a negative balance in an investment account should raise a red flag when (if) yo notice it: "Oops, I forgot to enter the gain as a transaction." But I don't see how it should make the trial balance fail. BTW, instead of a separate transaction, I might record the gain as a split: Assets:Cash $150 debit Assets:Investment $100 credit Income:Gain on investments $50 credit Is there any disadvantage to doing that, versus two transactions? Assets:Investment $50 debit Income:Gain on Investments $50 credit Assets:Cash $150 debit Assets::Investment $150 credit -- Stan Brown the_stan_br...@fastmail.fm http://BrownMath.com http://OakRoadSystems.com/ _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ------------------------------ Message: 9 Date: Thu, 26 Jul 2018 17:29:29 -0500 (CDT) From: DaveC49 <davidcous...@bigpond.com> To: gnucash-user@gnucash.org Subject: Re: [GNC] Bug in design of commodity sell transactions? (was Re: Getting My Account To Trial Balance) Message-ID: <1532644169309-0.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii Adrien, >From what little I know of the automatic gains/loss calculations by default the gain or loss on a transaction is created in an Orphan-Gains-CCC account by default and the user has to reassign the gain or loss to an appropriate income account. See https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-sell1.html#invest-sellAutoExample in the Tutorial and Concepts Guide for a description of how the Scrub function works. The transaction is balanced by the split into the Orphan-Gains-CCC account, which is not a true income account as such in the account heirarchy but is used so the procedure has a defined target. From Section 9.7.3.10 covering the scrub function which covers automatic generation of the required splits the user is then instructed to proceed to Section 9.7.3.6 where it describes reassignment of the Orphan-Gains-CCC account to the appropriate Income account. Here the CCC refers to the specific currency associated with the asset security account where trading is in multiple currencies so foa a trade in Austraian dollars it would be AUD or USD if the trade was in US dollars David ----- David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ------------------------------ Message: 10 Date: Thu, 26 Jul 2018 18:06:49 -0500 (CDT) From: DaveC49 <davidcous...@bigpond.com> To: gnucash-user@gnucash.org Subject: Re: [GNC] GNUcash 3.2 file open issue Message-ID: <1532646409727-0.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii Adrien, David, The same issue occurs in Linux Mint 19(Tara) which is Ubuntu 18.04 based. Nemo (file explorer) can see the mounted USB stick and access it directly or via the /media/<user>/ mount point for the device but the Gnucash file open dialog neither sees the USB stick or /media/<user>/ mount point when you click on other locations. It only lists a restricted set of the directories under / by comparison with what can be accessed from Nemo. Not being able to access the /media mount points would qualify as a bug. On LM19 /media has 755 permissions, the user directory under it has 750 and the mounted USB stick has 755 permissions. The file->Open dialog in LibreOffice which looks to be a similar GTK3 dialog does display the USB stick in the sidebar and it sees all the directories under / as well as any networked locations which don't show up in GnuCash either. if no-one has already filked a bug i will put one in later today. David Cousens ----- David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ------------------------------ Message: 11 Date: Thu, 26 Jul 2018 23:13:57 -0500 (CDT) From: DaveC49 <davidcous...@bigpond.com> To: gnucash-user@gnucash.org Subject: Re: [GNC] Nabble Delay? (was Re: Future Payments) Message-ID: <1532664837666-0.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii Adrien, I do use Nabble and also get the user list posts by email but as I am in Australia I sometiimes notice there is a long delay associated with being in this timezone. I'm not sure where the moderators are located but, I tend to post usually in the morning AEST (UTC -10:00) and my posts don't often appear on Nabble, until the next morning so often the issue has been dealt with by the time a post gets up. We need to be aware that not all responders are necessarily in the same time zone. This never seemed to be a problem a couple of years ago but maybe the location of the moderator(s) has changed and/or they only have a narrow time window available to them to lookover posts. Again no criticism of the moderators intended or to be inferred. I have never really expected immediate responses in any case so I don't find it too much of a problem but it does make conversations on a topic difficult at times. The delay is not just whether one is subscribed to the mail lists or not though. I am subscribed to both gnucash-dev and gnucash-user but use Nabble a lot of the time and my posts to both are still passed through a moderator and it does not matter whether I reply using Nabble online or by email I still receive an email saying my post is awaiting moderation. David Cousens ----- David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ------------------------------ Subject: Digest Footer _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ------------------------------ End of gnucash-user Digest, Vol 184, Issue 57 ********************************************* _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.