Re: [GNC] Old-New user with an upgrade problem
John, You will need to use $sudo apt install gnucash to install from the repository. You may also need to use apt-get instead of apt if the alias apt is not defined on Debian. to locate the executable $whereis gnucash should give you the path to the executable any libraries and shared modules/resources 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.
Re: [GNC] Old-New user with an upgrade problem
Flatpak is not the only option, you can also build from source. It does take some work to set up the dependencies for building and the build tools, but once done, you should be able to easily build each new version as they come out. Setup should take maybe 15-30 minutes depending on any errors or stumbling blocks. (which as you know can translate into lots of research time) It is a good way to learn the various install tools though, which are useful in any case. The GnuCash wiki building instructions are very thorough and (from what I find) complete. You do have to read them carefully. I'd read them all (with links) at least through to the end at least once. Then you can see your starting point and start issuing commands to set up the build environment and then the build itself. Flatpak avoids that with the caveat of a larger download and the aforementioned sandbox quirks you'd need to work around. (if they present a problem) With both approaches, you won't get automatic updates. You'll have to either build again, or download a new Flatpak and install it. There are ways to 'tell' apt about manually built software, but I've never done it and am not sure what advantage there is in doing so. I don't think there is anything similar for Flatpak. The executable path on Debian (and likely most distros) is: /usr/bin/gnucash Concerning your error message, that looks like you were in the process of building the app and it didn't complete. Do you have source code repos turned on? You shouldn't need them. A simple: apt install gnucash should do the trick. And if that install works correctly, you should see a GnuCash entry in whatever App menu your desktop provides. If the standard Gnome, hitting the Super (Windows) key will give you a search field where you can type "Gnucash" and it will display the launcher. You can also click the dot grid on the dock for an overlay of all apps. (XFCE, LXQt, KDE, etc. all provide more traditional 'start' menus) If you don't see an entry for GnuCash after installation, something went wrong. Finally, you might be in a situation where your system is in such a state that you either need to trace down and fix any installation/upgrade issues with the base OS, or do a backup and fresh install from a newly downloaded ISO. Be certain to do a full backup. Config and Preference files you may have changed over the years can lurk in unexpected places, and you'll be glad you have a copy to refer to. Also investigate how to obtain a list of all installed software. At the least, it gives you a reference to work from when re-installing, but some procedures even make it easy to re-install everything. (just newer versions) Regards, Adrien On 8/24/20 9:56 PM, John Angelico wrote: Thanks Adrien. Is Flatpak the only way to get 4.x onto a Debian system? I have cleared out my 2.6.12 version (a local build which apt did not see at all) by hand, after uninstalling 3.4 from the repo. I then reinstalled 3.4 using apt but it won't start. I see my cursor indicating something waiting but nothing appears on screen. The Task manager doesn't show any activity either. When I start from a terminal (still can't find the path to the executable, though) this is what I see: --- ~$ gnucash (gnucash:1345): Gtk-WARNING **: 12:51:42.047: Theme parsing error: gtk.css:5597:11: Not using units is deprecated. Assuming 'px'. (gnucash:1345): Gtk-WARNING **: 12:51:42.047: Theme parsing error: gtk.css:5597:14: '0' is not a valid color name (gnucash:1345): Gtk-WARNING **: 12:51:42.048: Theme parsing error: gtk.css:5831:14: '202020' is not a valid color name (gnucash:1345): Gtk-WARNING **: 12:51:42.048: Theme parsing error: gtk.css:5846:20: Junk at end of value for border-width (gnucash:1345): Gtk-WARNING **: 12:51:42.048: Theme parsing error: gtk.css:5871:20: Junk at end of value for border-width (gnucash:1345): Gtk-WARNING **: 12:51:42.048: Theme parsing error: gtk.css:5898:20: Junk at end of value for border-width ** gnc.gui:ERROR:/build/gnucash-9jHHoN/gnucash-3.4/gnucash/gnome-utils/gnc-main-window.c:3676:gnc_main_window_setup_window: assertion failed: (filename) Aborted --- Do I have an incomplete install? ___ 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] Capital Gain Calculations on Split Stocks
Peter, I thought the same about partial sales, but have found now that almost all my scenarios can be addressed in the lots tool. In my case, matching the broker's sales record up to the correct lot yields accurate results, except in this situation with a split stock. I agree with you generally about making sure I'm tracking it all the same as the broker, since that's where the tax folks are going. David Original Message From: peterb Sent: Mon Aug 24 22:52:23 EDT 2020 To: "David T." Cc: Gnucash Users Subject: Re: [GNC] Capital Gain Calculations on Split Stocks My experience is that the View Lots cap gain method is tractable right up to the point where you have partial lots, and is not really usable (or, at least, I don't find it usable) afterwards. When I have a partial sale of a lot, I don't even try to use it. Just add a gain/loss transaction by hand with the numbers that you know are correct (since these numbers are coming from your broker and will be *what is reported to your tax authority, *they're the best source of truth; if your trial balance is off after that, double-check that your cost basis in GnuCash agrees with your broker's records). On Mon, Aug 24, 2020 at 9:41 PM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi, > > In the last couple of days, I have learned TONS about how to manage > capital gains with assorted lots in the GnuCash realm. The financial > institution I use has algorithms that adjust my accounts to minimize tax > implications. This results in sales against specific lots within > GnuCash, and I've been able to match sales with specific lots and > achieve numbers in GnuCash which match the institution's calculations. > All good! > > However, I have one account with a single purchase, followed by a two > for one split, followed by a partial sale. Using the lots in this case, > however, yields wildly variant and incorrect results. In the attached > image, you can see the full transaction history, along with the lots > window indicating the assignment of the February sale to Lot 0 with a > loss of $169.96. > > This happens because 7*53.29 (the original share price) = $373.03, and > 203.07 - 373.03 = -169.96 > > If I choose to use Lot 2 for the match, the result is $203.07 gain > (7*0=$0 cost). This also is wrong. > > The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is > what the institution is reporting. I am hesitant to adjust the gain > value to match this amount, as I suspect that GnuCash will then report > the account as out of balance. I have seen in the past that incorrect > gains calculations can throw off the balance sheet, with painful > remedies and memories. My questions here are: > > 1) Is there a way to have GnuCash properly track cost basis in an > account with a stock split? > > 2) If I arbitrarily change the gains transaction, will subsequent > balance sheet numbers be in balance? > > 3) What is the proper way to handle a stock split? > > TIA, > > David T. > > ___ > 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] Capital Gain Calculations on Split Stocks
Christopher, Thanks for the reply. I'll have to figure out how I'd trigger the --extra flag in Windows and take a look at that report. It may make the whole gains process a little easier. As it is, a statement with 10-15 sales transactions can take quite some time to work through. I understand generally how it all is working, although determining which lots the broker has designated for sale can be challenging. (It also took a while to figure out how to force the software to use a disparate set of lots for one sale. It turns out that you have to sequence the lot selection so that the open lot is the lot selected last. I could imagine an impossible-to-achieve in gnucash situation, where a sale used multiple incomplete lots, leaving them both open. Lots as currently implemented couldn't do this, although i honestly can't imagine a real world use for this.) I tried to follow the discussion at bug 797796, but have to admit it didn't make a lot of sense to me. I'm more concerned about how the gains are recorded as valued transactions than with the reports, but I'll take a look at the report shortly. Thanks, David Original Message From: Christopher Lam Sent: Mon Aug 24 22:01:35 EDT 2020 To: "David T." Cc: Gnucash Users Subject: Re: [GNC] Capital Gain Calculations on Split Stocks David, I don't use stock at all myself but have a couple of suggestions. 1) lots can be made much more visible with the "lot-viewer" report which is hidden behind the --extra flag. 2) FIFO and LIFO are handled in advanced-portfolio, and adjusted cost basis is a difficult task documented and being discussed in https://github.com/Gnucash/gnucash/pull/763 and bug 797796. 3) stock splits are recognised and handled by advanced portfolio. I don't understand this report myself. On Tue, 25 Aug 2020, 9:40 am David T. via gnucash-user, < gnucash-user@gnucash.org> wrote: > Hi, > > In the last couple of days, I have learned TONS about how to manage > capital gains with assorted lots in the GnuCash realm. The financial > institution I use has algorithms that adjust my accounts to minimize tax > implications. This results in sales against specific lots within > GnuCash, and I've been able to match sales with specific lots and > achieve numbers in GnuCash which match the institution's calculations. > All good! > > However, I have one account with a single purchase, followed by a two > for one split, followed by a partial sale. Using the lots in this case, > however, yields wildly variant and incorrect results. In the attached > image, you can see the full transaction history, along with the lots > window indicating the assignment of the February sale to Lot 0 with a > loss of $169.96. > > This happens because 7*53.29 (the original share price) = $373.03, and > 203.07 - 373.03 = -169.96 > > If I choose to use Lot 2 for the match, the result is $203.07 gain > (7*0=$0 cost). This also is wrong. > > The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is > what the institution is reporting. I am hesitant to adjust the gain > value to match this amount, as I suspect that GnuCash will then report > the account as out of balance. I have seen in the past that incorrect > gains calculations can throw off the balance sheet, with painful > remedies and memories. My questions here are: > > 1) Is there a way to have GnuCash properly track cost basis in an > account with a stock split? > > 2) If I arbitrarily change the gains transaction, will subsequent > balance sheet numbers be in balance? > > 3) What is the proper way to handle a stock split? > > TIA, > > David T. > > ___ > 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] Old-New user with an upgrade problem
Thanks Adrien. Is Flatpak the only way to get 4.x onto a Debian system? I have cleared out my 2.6.12 version (a local build which apt did not see at all) by hand, after uninstalling 3.4 from the repo. I then reinstalled 3.4 using apt but it won't start. I see my cursor indicating something waiting but nothing appears on screen. The Task manager doesn't show any activity either. When I start from a terminal (still can't find the path to the executable, though) this is what I see: --- ~$ gnucash (gnucash:1345): Gtk-WARNING **: 12:51:42.047: Theme parsing error: gtk.css:5597:11: Not using units is deprecated. Assuming 'px'. (gnucash:1345): Gtk-WARNING **: 12:51:42.047: Theme parsing error: gtk.css:5597:14: '0' is not a valid color name (gnucash:1345): Gtk-WARNING **: 12:51:42.048: Theme parsing error: gtk.css:5831:14: '202020' is not a valid color name (gnucash:1345): Gtk-WARNING **: 12:51:42.048: Theme parsing error: gtk.css:5846:20: Junk at end of value for border-width (gnucash:1345): Gtk-WARNING **: 12:51:42.048: Theme parsing error: gtk.css:5871:20: Junk at end of value for border-width (gnucash:1345): Gtk-WARNING **: 12:51:42.048: Theme parsing error: gtk.css:5898:20: Junk at end of value for border-width ** gnc.gui:ERROR:/build/gnucash-9jHHoN/gnucash-3.4/gnucash/gnome-utils/gnc-main-window.c:3676:gnc_main_window_setup_window: assertion failed: (filename) Aborted --- Do I have an incomplete install? Regards, John Angelico On Tue, 25 Aug 2020 at 06:46, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Just for info, > > Flatpak is a way to install software without dealing with dependency > issues. > > Rather than try to use versions (perhaps incompatible ones) of > dependencies already on your system or in the repos, a Flatpak contains > everything needed to run the chosen app. > > In addition, Flatpak apps run in a sandbox so as not to affect other > parts of the system. > > The advantages includes avoiding dependency hell, along with being able > to run software more current than a stagnant and frozen repo. (which can > be years old) > > The disadvantage is a bit of bloat for that app since it contains all > the dependencies, as well as a few issues with communicating outside the > sandbox which can affect databases and printing. (still possible, just > not out-of-the-box easy) > > Best of luck with whatever route you choose. > > Regards, > Adrien > > On 8/22/20 9:38 PM, John Angelico wrote: > > > I don't know much about Flatpack. It seems to be a development > environment > > but I''ll see how much extra load it may put onto my creaking old system > :-) > > ___ > 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. > -- Best regards John A ___ 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] Capital Gain Calculations on Split Stocks
My experience is that the View Lots cap gain method is tractable right up to the point where you have partial lots, and is not really usable (or, at least, I don't find it usable) afterwards. When I have a partial sale of a lot, I don't even try to use it. Just add a gain/loss transaction by hand with the numbers that you know are correct (since these numbers are coming from your broker and will be *what is reported to your tax authority, *they're the best source of truth; if your trial balance is off after that, double-check that your cost basis in GnuCash agrees with your broker's records). On Mon, Aug 24, 2020 at 9:41 PM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi, > > In the last couple of days, I have learned TONS about how to manage > capital gains with assorted lots in the GnuCash realm. The financial > institution I use has algorithms that adjust my accounts to minimize tax > implications. This results in sales against specific lots within > GnuCash, and I've been able to match sales with specific lots and > achieve numbers in GnuCash which match the institution's calculations. > All good! > > However, I have one account with a single purchase, followed by a two > for one split, followed by a partial sale. Using the lots in this case, > however, yields wildly variant and incorrect results. In the attached > image, you can see the full transaction history, along with the lots > window indicating the assignment of the February sale to Lot 0 with a > loss of $169.96. > > This happens because 7*53.29 (the original share price) = $373.03, and > 203.07 - 373.03 = -169.96 > > If I choose to use Lot 2 for the match, the result is $203.07 gain > (7*0=$0 cost). This also is wrong. > > The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is > what the institution is reporting. I am hesitant to adjust the gain > value to match this amount, as I suspect that GnuCash will then report > the account as out of balance. I have seen in the past that incorrect > gains calculations can throw off the balance sheet, with painful > remedies and memories. My questions here are: > > 1) Is there a way to have GnuCash properly track cost basis in an > account with a stock split? > > 2) If I arbitrarily change the gains transaction, will subsequent > balance sheet numbers be in balance? > > 3) What is the proper way to handle a stock split? > > TIA, > > David T. > > ___ > 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] GC v4.1 on Windows and v3.1 on Ubuntu
Larry, If you are up to building GnuCash on Ubuntu you can use 4.1. See the thread Ubuntu distribution version for more detail. it's a bit of a challenge if you aren't used to building software first time through but after that generally pretty straightforward. 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.
Re: [GNC] GC v4.1 on Windows and v3.1 on Ubuntu
If you accepted the default, then you aren't using a database. The default is XML for all platforms. But I don't think it would be wise to run two different major versions to access the same file. There is a possibility you could use 4.1 and 3.11 (the last 3.x release) but you'd have to get a developer to verify. Regards, Adrien On 8/24/20 9:23 PM, Larry Long wrote: Is the same GnuCash database compatible back and forth between v4.1 and v3.1 applications? I run GnuCash on my Windows PC at home. However, when traveling I like to copy my GC database onto my little Ubuntu notebook and enter new data while away from home.When I return home, I copy the updated database file back onto my Windows PC. Adrian has me interested in updating my Window copy of GC to v4.1, but I gather that there might be issues in getting my Ubuntu edition of GC updated to v4.1. Thus, my question as to whether I could use GC v4.1 on Windows, copy my database to my notebook, update the data with GC v3.1 and then painlessly bring the database back for use with v4.1? Unfortunately, I don't remember the format of my GC database and don't see how to display it. As I recall, I just accepted the default during installation. Thanks in advance for any advice. ___ 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] GC v4.1 on Windows and v3.1 on Ubuntu
Is the same GnuCash database compatible back and forth between v4.1 and v3.1 applications? I run GnuCash on my Windows PC at home. However, when traveling I like to copy my GC database onto my little Ubuntu notebook and enter new data while away from home.When I return home, I copy the updated database file back onto my Windows PC. Adrian has me interested in updating my Window copy of GC to v4.1, but I gather that there might be issues in getting my Ubuntu edition of GC updated to v4.1. Thus, my question as to whether I could use GC v4.1 on Windows, copy my database to my notebook, update the data with GC v3.1 and then painlessly bring the database back for use with v4.1? Unfortunately, I don't remember the format of my GC database and don't see how to display it. As I recall, I just accepted the default during installation. Thanks in advance for any advice. Larry Long ___ 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] Ubuntu distribution version
Derek, Have you installed all the dependencies first https://wiki.gnucash.org/wiki/Installing_Dependencies If so $sudo apt-get install googletest will install the googletest framework including google mock. In most cases cmake will give you the name of the library that is missing. Eg the libdbi drivers. You can build GnuCash without them if you are not using the database backends but the default build includes them and the unit tests check their operation so they are now normally included in the default build. I need to update the wiki to reflect that.. you need to do $sudo apt-get install libdbi1 libdbi-dev and one of the following database drivers $sudo apt-get install libdbd-mysql or $sudo apt-get install libdbd-pgsql or $sudo apt-get install libdbd-sqlite3. The package names given in the cmake output may differ slightly from the package names in the repository for a given distribution. Use $apt-cache search where string is a few characters from the package name will usually help in identifying the correct name on your distribution . They may have 'lib' prefixed onto the package name and may include other build information. In most cases for the build what need to be added to your system are the development header files which generally have a postfix '-dev' onto the package name. You will need the binary libraries at run time so I usually include the binaries and headers in the install command but you may find the binary libraries are often already installed by other programs/packages. apt generally reports that and just installs the headers if they aren't present. You can safely ignore the warning re Gettext 0.20 (or build it if you are feeling advenmturous). Once cmake completes without reporting any missing packages you should be ready to buiild. Ninja is becoming the preferred build utility rather than make. To use it you first install it with sudo apt-get install ninja-build and then add a "-GNinja" flag to the cmake command. the build and install commandis then $ninja and $sudo ninja install 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.
Re: [GNC] Capital Gain Calculations on Split Stocks
David, I don't use stock at all myself but have a couple of suggestions. 1) lots can be made much more visible with the "lot-viewer" report which is hidden behind the --extra flag. 2) FIFO and LIFO are handled in advanced-portfolio, and adjusted cost basis is a difficult task documented and being discussed in https://github.com/Gnucash/gnucash/pull/763 and bug 797796. 3) stock splits are recognised and handled by advanced portfolio. I don't understand this report myself. On Tue, 25 Aug 2020, 9:40 am David T. via gnucash-user, < gnucash-user@gnucash.org> wrote: > Hi, > > In the last couple of days, I have learned TONS about how to manage > capital gains with assorted lots in the GnuCash realm. The financial > institution I use has algorithms that adjust my accounts to minimize tax > implications. This results in sales against specific lots within > GnuCash, and I've been able to match sales with specific lots and > achieve numbers in GnuCash which match the institution's calculations. > All good! > > However, I have one account with a single purchase, followed by a two > for one split, followed by a partial sale. Using the lots in this case, > however, yields wildly variant and incorrect results. In the attached > image, you can see the full transaction history, along with the lots > window indicating the assignment of the February sale to Lot 0 with a > loss of $169.96. > > This happens because 7*53.29 (the original share price) = $373.03, and > 203.07 - 373.03 = -169.96 > > If I choose to use Lot 2 for the match, the result is $203.07 gain > (7*0=$0 cost). This also is wrong. > > The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is > what the institution is reporting. I am hesitant to adjust the gain > value to match this amount, as I suspect that GnuCash will then report > the account as out of balance. I have seen in the past that incorrect > gains calculations can throw off the balance sheet, with painful > remedies and memories. My questions here are: > > 1) Is there a way to have GnuCash properly track cost basis in an > account with a stock split? > > 2) If I arbitrarily change the gains transaction, will subsequent > balance sheet numbers be in balance? > > 3) What is the proper way to handle a stock split? > > TIA, > > David T. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Capital Gain Calculations on Split Stocks
Hi, In the last couple of days, I have learned TONS about how to manage capital gains with assorted lots in the GnuCash realm. The financial institution I use has algorithms that adjust my accounts to minimize tax implications. This results in sales against specific lots within GnuCash, and I've been able to match sales with specific lots and achieve numbers in GnuCash which match the institution's calculations. All good! However, I have one account with a single purchase, followed by a two for one split, followed by a partial sale. Using the lots in this case, however, yields wildly variant and incorrect results. In the attached image, you can see the full transaction history, along with the lots window indicating the assignment of the February sale to Lot 0 with a loss of $169.96. This happens because 7*53.29 (the original share price) = $373.03, and 203.07 - 373.03 = -169.96 If I choose to use Lot 2 for the match, the result is $203.07 gain (7*0=$0 cost). This also is wrong. The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is what the institution is reporting. I am hesitant to adjust the gain value to match this amount, as I suspect that GnuCash will then report the account as out of balance. I have seen in the past that incorrect gains calculations can throw off the balance sheet, with painful remedies and memories. My questions here are: 1) Is there a way to have GnuCash properly track cost basis in an account with a stock split? 2) If I arbitrarily change the gains transaction, will subsequent balance sheet numbers be in balance? 3) What is the proper way to handle a stock split? TIA, David T. ___ 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] Ubuntu distribution version
Thanks for the info everyone. So now I'm trying to build GnuCash 4.1 on Ubuntu 18, mainly because I opened my files on GnuCash 4.1 on a Windows device. Maybe I'm getting myself into more trouble than it's worth. But I'm currently stuck at Cmake not finding Googletest. Attached is the terminal lines that show what's up, and why I think it should find Googletest. Hope someone on here has a bit of experience with this. If it weren't for the extensive documentation on GnuCash's website about how to build it on Linux, I wouldn't even be close to this far. :) Thanks, Derek On 2020-08-24 4:48 p.m., Adrien Monteleone wrote: There are considerable report improvements in 4.x and hands down, the search-as-you-type feature when entering accounts in a transaction is by far, the greatest productivity and user friendly feature I've seen in any desktop software in years. It is super fast, and narrows down your choices very quickly. No more typing through the account hierarchy with separators to assign that account which is 8 levels deep. (but you still can if you want to) Once you use it, you won't know how you managed without it. Regards, Adrien On 8/24/20 9:57 AM, Derek Zehr wrote: Are there any major advantages and improvements to versions 3 and 4? ___ 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. me@device:~/Applications/build-gnucash-4.1$ sudo cmake -DCMAKE_INSTALL_PREFIX=/opt -DWITH_PYTHON=ON ../gnucash-4.1/ CMake Warning at CMakeLists.txt:251 (message): Gettext version 0.20 or more recent is required to translate the 'developer_name' tag in gnucash.appdata.xml. All but that tag will be translated in the generated file. -- Using guile-2.2.x -- Using guile SRFI-64 -- Using guile textual-ports CMake Error at CMakeLists.txt:459 (message): Include file was not found - did you install libdbi0-dev or libdbi-dev? CMake Error at CMakeLists.txt:462 (message): Library libdbi was not found CMake Error at CMakeLists.txt:466 (message): No libdbi drivers found, SQL tests will fail. -- Checking for GTEST CMake Error at common/cmake_modules/GncAddTest.cmake:162 (message): GTEST not found. Please install it or set GTEST_ROOT Call Stack (most recent call first): CMakeLists.txt:622 (gnc_gtest_configure) -- Configuring incomplete, errors occurred! See also "/home/me/Applications/build-gnucash-4.1/CMakeFiles/CMakeOutput.log". See also "/home/me/Applications/build-gnucash-4.1/CMakeFiles/CMakeError.log". me@device:~/Applications/build-gnucash-4.1$ printenv GTEST_ROOT /home/me/.local/src/googletest me@device:~/Applications/build-gnucash-4.1$ ls $GTEST_ROOT appveyor.yml ci CONTRIBUTING.md googletestLICENSE platformio.ini WORKSPACE BUILD.bazel CMakeLists.txt googlemock library.json mybuild README.md ___ 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] Monthly Payments on posted Liability?
Thanks Steve, Michael, and Adrian.Steve answered it, Adrian explained, and Michael made the point about interest and taxes. All good and helpful. On Monday, August 24, 2020, 5:18:38 PM EDT, Michael or Penny Novack wrote: > > On 8/24/20 11:19 AM, Stan Brown wrote: >> On 2020-08-24 09:01, Fran_3 via gnucash-user wrote: >>> For a posted liability of say $1,000with an agreement to pay in 10 >>> monthly installments of $100 each.How do you enter those monthly >>> payments and...1 - have the payment applied to the liability Also, something seems to have been left out. A liability of $1000 paid off by ten payments of $100 would mean this was a no interest loan. More usually, you are paying interest. So some of each payment is a reduction of the liability and some interest expense. A split transaction. Even if this were a purchase on an installment contract (so no explicitly stated interest) strictly correct would be to assume what rate should be implied and enter the liability at this discounted amount. These days might not matter for personal finances but I bet it does for business since the interest would be a deductible expense. Mind, I have never looked at the "installment sales" or "installment purchases" parts of the1040. Michael D Novack ___ 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] Difficulty with online price retrieval
Samantha, Sorry, yes, I got busy on other work. # means that no quote information made it in to the code that handles the quotes. I can't reproduce the problem. Since you revealed your key I even used that, worked fine: * 14:34:32 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 14:34:32 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 14:34:57 DEBUG ALPHAVANTAGE_API_KEY= * 14:34:57 DEBUG handling-request: (currency CAD USD) * 14:35:04 DEBUG results: ((CAD (symbol . CAD) (gnc:time-no-zone . 2020-08-24 14:34:58) (last . 15127/2) (currency . USD))) * 14:35:04 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 14:35:04 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. It does occur to me the US markets are closed at 10:15 BST, but I suppose that you also checked with gnc-fq-dump around the same time and that worked OK. There's one other thing to try in Powershell but it would be odd if gnc-fq-dump works and this doesn't: $Env:ALPHAVANTAGE_API_KEY = 'xxx' '(currency "USD" "GBP")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper Should produce something like (("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25") (last . #e0.7658) (currency . "GBP"))) Regards, John Ralls > On Aug 24, 2020, at 3:16 AM, Samantha Payn > wrote: > > Dear John and list > I think this response of mine from a week ago must have fallen through the > net? > Any assistance gratefully received > Samantha Payn >> -- Original Message -- >> From: Samantha Payn >> To: John Ralls >> CC: Gnucash Users >> Date: 17 August 2020 10:19 >> Subject: Re: [GNC] Difficulty with online price retrieval >> >> >> John, thank you for your continued patience! >> This is what I got: >> * 10:13:32 DEBUG rpt-subdir=gnucash/reports/standard >> * 10:13:32 DEBUG mod-dir=C:\Program Files >> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard >> * 10:13:32 DEBUG dir-files=(view-column trial-balance transaction >> taxinvoice register reconcile-report receivables receipt price-scatter >> portfolio payables owner-report new-owner-report new-aging net-charts >> lot-viewer job-report invoice income-statement income-gst-statement >> general-ledger general-journal equity-statement dashboard customer-summary >> category-barchart cashflow-barchart cash-flow budget budget-income-statement >> budget-flow budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg >> balance-sheet balance-forecast advanced-portfolio account-summary >> account-piecharts) >> * 10:13:32 DEBUG rpt-subdir=gnucash/reports/example >> * 10:13:32 DEBUG mod-dir=C:\Program Files >> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example >> * 10:13:32 DEBUG dir-files=(welcome-to-gnucash sample-graphs >> hello-world daily-reports average-balance) >> * 10:13:32 DEBUG rpt-subdir=gnucash/reports/locale-specific/us >> * 10:13:32 DEBUG mod-dir=C:\Program Files >> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us >> * 10:13:32 DEBUG dir-files=(taxtxf) >> * 10:13:32 DEBUG rpt-subdir=gnucash/report/stylesheets >> * 10:13:32 DEBUG mod-dir=C:\Program Files >> (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets >> * 10:13:32 DEBUG dir-files=(plain head-or-tail footer css) >> * 10:13:33 DEBUG gnc:fq-check-sources results: (1.49 adig aex >> aiahk alphavantage amfiindia asegr asx aufunds australia bamosz bet >> bmonesbittburns bourso bse bsero canada canadamutual citywire cominvest cse >> deka dutch dwsfunds europe fetch_live_currencies fidelity fidelity_direct >> fidelityfixed financecanada finanzpartner finland fool france ftfunds >> ftportfolios ftportfolios_direct fundlibrary goldmoney greece hex hu hufund >> hungary hustock iexcloud indiamutual known_currencies lerevenu maninv >> morningstar morningstarau morningstarch morningstarjp mstaruk nasdaq nyse nz >> nzx platinum romania seb_funds sixfunds sixshares stockhousecanada_fund >> tdefunds tdwaterhouse tiaacref tnetuk troweprice troweprice_direct trustnet >> tsp tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds vanguard vwd >> yahoo_json yahoo_yql za za_unittrusts) >> * 10:13:33 MESSG Found Finance::Quote version 1.49 >> * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when >> 'never round' specified. >> * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when >> 'never round' specified. >> * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when >> 'never round' specified. >> * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when >> 'never round' specified. >> * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when >> 'never round' specified. >> * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when >> 'never round' specified. >> * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding r
Re: [GNC] Monthly Payments on posted Liability?
On 8/24/20 11:19 AM, Stan Brown wrote: On 2020-08-24 09:01, Fran_3 via gnucash-user wrote: For a posted liability of say $1,000with an agreement to pay in 10 monthly installments of $100 each.How do you enter those monthly payments and...1 - have the payment applied to the liability Also, something seems to have been left out. A liability of $1000 paid off by ten payments of $100 would mean this was a no interest loan. More usually, you are paying interest. So some of each payment is a reduction of the liability and some interest expense. A split transaction. Even if this were a purchase on an installment contract (so no explicitly stated interest) strictly correct would be to assume what rate should be implied and enter the liability at this discounted amount. These days might not matter for personal finances but I bet it does for business since the interest would be a deductible expense. Mind, I have never looked at the "installment sales" or "installment purchases" parts of the1040. Michael D Novack ___ 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] Monthly Payments on posted Liability?
You can't get the individual payments to show up in the Bills Due Reminder. You can set up a Scheduled Transaction, but set it only to remind you in advance, but not auto-create. (or at least set it to let you review and edit it when it does) These reminders when then show up in the Since Last Run dialog. (auto on startup, or manually from the Actions menu) If you've used the Business features to post that original liability, it will show up in the Bills Due Reminder, but with the original due date, (which could be the final date if you like) and will adjust the balance due as you make payments. In this case, when you make payments, you just "Process Payment" for that vendor and fill out the payment window. The posting of the payment will be done for you and you can track your payments to that particular vendor easily with a Vendor report. Regards, Adrien On 8/24/20 11:19 AM, Stan Brown wrote: On 2020-08-24 09:01, Fran_3 via gnucash-user wrote: For a posted liability of say $1,000with an agreement to pay in 10 monthly installments of $100 each.How do you enter those monthly payments and...1 - have the payment applied to the liability Debit:That liability Credit:Your bank account 2 - have the monthly payment appear in the "Bills Due Reminder"3 - or any report that shows you.. upcoming expenses, item by item for the next x days... upcoming revenue, item by item for the next x days Why not just set up the 10 times recurring payment with your bank's bill-pay feature? Then you can set up a 10 times scheduled transaction in GnuCash. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Ubuntu distribution version
There are considerable report improvements in 4.x and hands down, the search-as-you-type feature when entering accounts in a transaction is by far, the greatest productivity and user friendly feature I've seen in any desktop software in years. It is super fast, and narrows down your choices very quickly. No more typing through the account hierarchy with separators to assign that account which is 8 levels deep. (but you still can if you want to) Once you use it, you won't know how you managed without it. Regards, Adrien On 8/24/20 9:57 AM, Derek Zehr wrote: Are there any major advantages and improvements to versions 3 and 4? ___ 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] Old-New user with an upgrade problem
Just for info, Flatpak is a way to install software without dealing with dependency issues. Rather than try to use versions (perhaps incompatible ones) of dependencies already on your system or in the repos, a Flatpak contains everything needed to run the chosen app. In addition, Flatpak apps run in a sandbox so as not to affect other parts of the system. The advantages includes avoiding dependency hell, along with being able to run software more current than a stagnant and frozen repo. (which can be years old) The disadvantage is a bit of bloat for that app since it contains all the dependencies, as well as a few issues with communicating outside the sandbox which can affect databases and printing. (still possible, just not out-of-the-box easy) Best of luck with whatever route you choose. Regards, Adrien On 8/22/20 9:38 PM, John Angelico wrote: I don't know much about Flatpack. It seems to be a development environment but I''ll see how much extra load it may put onto my creaking old system :-) ___ 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 Flatpak on GalliumOS Linux
Thanks, Frank. This — sudo flatpak override org.gnucash.GnuCash --filesystem= — worked like a charm. The embarrassing thing is that, in searching for a solution, I actually looked at that page, but it didn't register that the flatpak sandboxing was my problem. Duh! Do I have to rerun that override command each time I start GnuCash? After a reboot? Or is it a persistent setting? On Mon, Aug 24, 2020 at 3:07 PM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Art, > did you see > https://wiki.gnucash.org/wiki/Flatpak#Granting_Access_to_Other_Resources > HTH > Frank > > Am 24.08.20 um 19:46 schrieb Art Chimes: > > Anyone have any experience with GnuCash installed via Flatpak on > > GalliumOS? (It's a niche distro designed to turn a Chromebook into a > > Linux machine.) > > > > I installed GC 4.1 and it runs fine ... except that it doesn't > > recognize the USB drive where I my data file lives. The USB drive and > > the data file, which I copied over from a working GnuCash installation > > on a Windows machine, show up fine in Thunar (Linux) file manager and > > via terminal CLI. The "open file" dialog format looks like GnuCash's, > > not like something I've seen on my Gallium machine. > > > > If I copy the data file to a location that shows up in the open-file > > dialog (e.g. Desktop) it loads fine. > > > > Any ideas how I can remove the USB drive's cloak of invisibility from > > the open-file dialog? > > > > Thanks, Art > > > > PS - I also posted my query in the GalliumOS subreddit, in case > > someone there has a solution. > > ___ 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] Ubuntu distribution version
Bruce, In addition to Frank's suggestion, if you drill down through the GnuCash website from the start point I gave you previously there are references to Flatpak builds which is another way to backport GnuCash release 4.1 into several flavors of Linux. That route is not for everyone, as there are some limitations that may make that a bad choice on some computers. David Carlson On Mon, Aug 24, 2020 at 2:04 PM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Bruce, > > perhaps you should start with > https://packages.ubuntu.com/search?keywords=gnucash > That will give you the overview, which GnuCash version in which release > is in universe available. > > In some cases -{updates|backports} got more recent version > than . > > HTH > Frank > > Am 24.08.20 um 19:36 schrieb Bruce Irving via gnucash-user: > > Unfortunately, the only listing there for 3.8 is: gnucash-docs (3.8-1) > [universe] Documentation for gnucash, a personal finance tracking program > > which is the documentation. I wish it was the newer version as I'm on a > derivative of ubuntu. > > > > Bruce > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash Flatpak on GalliumOS Linux
Op maandag 24 augustus 2020 19:46:55 CEST schreef Art Chimes: > Anyone have any experience with GnuCash installed via Flatpak on > GalliumOS? (It's a niche distro designed to turn a Chromebook into a > Linux machine.) > > I installed GC 4.1 and it runs fine ... except that it doesn't > recognize the USB drive where I my data file lives. The USB drive and > the data file, which I copied over from a working GnuCash installation > on a Windows machine, show up fine in Thunar (Linux) file manager and > via terminal CLI. The "open file" dialog format looks like GnuCash's, > not like something I've seen on my Gallium machine. > > If I copy the data file to a location that shows up in the open-file > dialog (e.g. Desktop) it loads fine. > > Any ideas how I can remove the USB drive's cloak of invisibility from > the open-file dialog? > Hi Art, What you experience is the restrictions imposed by the flatpak sandbox. By default it only allows access to files in your home directory. You can widen the access by using the flatpak override command like so flatpak override --filesystem=host org.gnucash.GnuCash The "host" option in the command above is fairly new. Can you try this and report back if this works for you ? Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash Flatpak on GalliumOS Linux
Art, did you see https://wiki.gnucash.org/wiki/Flatpak#Granting_Access_to_Other_Resources HTH Frank Am 24.08.20 um 19:46 schrieb Art Chimes: > Anyone have any experience with GnuCash installed via Flatpak on > GalliumOS? (It's a niche distro designed to turn a Chromebook into a > Linux machine.) > > I installed GC 4.1 and it runs fine ... except that it doesn't > recognize the USB drive where I my data file lives. The USB drive and > the data file, which I copied over from a working GnuCash installation > on a Windows machine, show up fine in Thunar (Linux) file manager and > via terminal CLI. The "open file" dialog format looks like GnuCash's, > not like something I've seen on my Gallium machine. > > If I copy the data file to a location that shows up in the open-file > dialog (e.g. Desktop) it loads fine. > > Any ideas how I can remove the USB drive's cloak of invisibility from > the open-file dialog? > > Thanks, Art > > PS - I also posted my query in the GalliumOS subreddit, in case > someone there has a solution. > ___ > 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] Ubuntu distribution version
Bruce, perhaps you should start with https://packages.ubuntu.com/search?keywords=gnucash That will give you the overview, which GnuCash version in which release is in universe available. In some cases -{updates|backports} got more recent version than . HTH Frank Am 24.08.20 um 19:36 schrieb Bruce Irving via gnucash-user: > Unfortunately, the only listing there for 3.8 is: gnucash-docs (3.8-1) > [universe] Documentation for gnucash, a personal finance tracking program > which is the documentation. I wish it was the newer version as I'm on a > derivative of ubuntu. > > Bruce ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash Flatpak on GalliumOS Linux
Anyone have any experience with GnuCash installed via Flatpak on GalliumOS? (It's a niche distro designed to turn a Chromebook into a Linux machine.) I installed GC 4.1 and it runs fine ... except that it doesn't recognize the USB drive where I my data file lives. The USB drive and the data file, which I copied over from a working GnuCash installation on a Windows machine, show up fine in Thunar (Linux) file manager and via terminal CLI. The "open file" dialog format looks like GnuCash's, not like something I've seen on my Gallium machine. If I copy the data file to a location that shows up in the open-file dialog (e.g. Desktop) it loads fine. Any ideas how I can remove the USB drive's cloak of invisibility from the open-file dialog? Thanks, Art PS - I also posted my query in the GalliumOS subreddit, in case someone there has a solution. ___ 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] Ubuntu distribution version
Hello, That makes sense, David and John. Thanks. According to this list Ubuntu 20 supports Gnucash 3.8 https://packages.ubuntu.com/focal/allpackages?format=txt.gz Are there any major advantages and improvements to versions 3 and 4? Derek Unfortunately, the only listing there for 3.8 is: gnucash-docs (3.8-1) [universe] Documentation for gnucash, a personal finance tracking program which is the documentation. I wish it was the newer version as I'm on a derivative of ubuntu. Bruce Preach the Gospel wherever you go. If necessary, use words. ___ 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] Monthly Payments on posted Liability?
On 2020-08-24 09:01, Fran_3 via gnucash-user wrote: > For a posted liability of say $1,000with an agreement to pay in 10 monthly > installments of $100 each.How do you enter those monthly payments and...1 - > have the payment applied to the liability Debit:That liability Credit:Your bank account 2 - have the monthly payment appear in the "Bills Due Reminder"3 - or any report that shows you.. upcoming expenses, item by item for the next x days... upcoming revenue, item by item for the next x days Why not just set up the 10 times recurring payment with your bank's bill-pay feature? Then you can set up a 10 times scheduled transaction in GnuCash. -- Regards, Stan Brown Tehachapi, CA, USA https://BrownMath.com https://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.
[GNC] Monthly Payments on posted Liability?
For a posted liability of say $1,000with an agreement to pay in 10 monthly installments of $100 each.How do you enter those monthly payments and...1 - have the payment applied to the liability2 - have the monthly payment appear in the "Bills Due Reminder"3 - or any report that shows you.. upcoming expenses, item by item for the next x days... upcoming revenue, item by item for the next x days I ask because clicking Reports > Vendor > Process Payments seems to only look in AP... or does it? Thanks for any help. ___ 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] Ubuntu distribution version
Check out this page and references therein for most details: https://gnucash.org/new_features-4.0.phtml There are probably a few minor differences overlooked. On Mon, Aug 24, 2020 at 9:59 AM Derek Zehr wrote: > > Hello, > > That makes sense, David and John. Thanks. According to this list Ubuntu 20 > supports Gnucash 3.8 > > https://packages.ubuntu.com/focal/allpackages?format=txt.gz > > Are there any major advantages and improvements to versions 3 and 4? > > Derek > > On Monday, August 24, 2020 06:12 EDT, "David Cousens" < > davidcous...@bigpond.com> wrote: > Derek, > > The choices on what versions are supplied wiith a given OS version are > made > by the maintainers of the OS distribution. They usually use the current > GnuCash version (but not always) at the time of release of a new OS > version. > If you want to stay up to date with GnuCash, the main options are to use > the > flatpak or snap versions of GnuCash where available or to build the latest > version of GnuCash from the sources as described in the wiki > https://wiki.gnucash.org/wiki/Building_On_Linux. Once build environment > and > the dependencies are installed the process is generally fairly simple. > Also > check the developer mailing list for any problems with building the most > recent version. MySQL8 proved problematical in building GC 4.0/4.1 > recently > on Linux Mint 20 (ubuntu 20.04 based) which was fixed by downgrading a > mysqlclient library that GnuCash depends on as described in the dev > mailing > list. > > 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. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Ubuntu distribution version
Hello, That makes sense, David and John. Thanks. According to this list Ubuntu 20 supports Gnucash 3.8 https://packages.ubuntu.com/focal/allpackages?format=txt.gz Are there any major advantages and improvements to versions 3 and 4? Derek On Monday, August 24, 2020 06:12 EDT, "David Cousens" wrote: Derek, The choices on what versions are supplied wiith a given OS version are made by the maintainers of the OS distribution. They usually use the current GnuCash version (but not always) at the time of release of a new OS version. If you want to stay up to date with GnuCash, the main options are to use the flatpak or snap versions of GnuCash where available or to build the latest version of GnuCash from the sources as described in the wiki https://wiki.gnucash.org/wiki/Building_On_Linux. Once build environment and the dependencies are installed the process is generally fairly simple. Also check the developer mailing list for any problems with building the most recent version. MySQL8 proved problematical in building GC 4.0/4.1 recently on Linux Mint 20 (ubuntu 20.04 based) which was fixed by downgrading a mysqlclient library that GnuCash depends on as described in the dev mailing list. 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. ___ 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] Fwd: Re: Difficulty with online price retrieval
Dear John and list I think this response of mine from a week ago must have fallen through the net? Any assistance gratefully received Samantha Payn -- Original Message -- From: Samantha Payn To: John Ralls CC: Gnucash Users Date: 17 August 2020 10:19 Subject: Re: [GNC] Difficulty with online price retrieval John, thank you for your continued patience! This is what I got: * 10:13:32 DEBUG rpt-subdir=gnucash/reports/standard * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard * 10:13:32 DEBUG dir-files=(view-column trial-balance transaction taxinvoice register reconcile-report receivables receipt price-scatter portfolio payables owner-report new-owner-report new-aging net-charts lot-viewer job-report invoice income-statement income-gst-statement general-ledger general-journal equity-statement dashboard customer-summary category-barchart cashflow-barchart cash-flow budget budget-income-statement budget-flow budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet balance-forecast advanced-portfolio account-summary account-piecharts) * 10:13:32 DEBUG rpt-subdir=gnucash/reports/example * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example * 10:13:32 DEBUG dir-files=(welcome-to-gnucash sample-graphs hello-world daily-reports average-balance) * 10:13:32 DEBUG rpt-subdir=gnucash/reports/locale-specific/us * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us * 10:13:32 DEBUG dir-files=(taxtxf) * 10:13:32 DEBUG rpt-subdir=gnucash/report/stylesheets * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets * 10:13:32 DEBUG dir-files=(plain head-or-tail footer css) * 10:13:33 DEBUG gnc:fq-check-sources results: (1.49 adig aex aiahk alphavantage amfiindia asegr asx aufunds australia bamosz bet bmonesbittburns bourso bse bsero canada canadamutual citywire cominvest cse deka dutch dwsfunds europe fetch_live_currencies fidelity fidelity_direct fidelityfixed financecanada finanzpartner finland fool france ftfunds ftportfolios ftportfolios_direct fundlibrary goldmoney greece hex hu hufund hungary hustock iexcloud indiamutual known_currencies lerevenu maninv morningstar morningstarau morningstarch morningstarjp mstaruk nasdaq nyse nz nzx platinum romania seb_funds sixfunds sixshares stockhousecanada_fund tdefunds tdwaterhouse tiaacref tnetuk troweprice troweprice_direct trustnet tsp tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds vanguard vwd yahoo_json yahoo_yql za za_unittrusts) * 10:13:33 MESSG Found Finance::Quote version 1.49 * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:31 DEBUG ALPHAVANTAGE_API_KEY=7HZ0P6PV6VC2GODA * 10:15:31 DEBUG handling-request: (currency USD GBP) * 10:15:31 DEBUG results: # * 10:15:31 DEBUG handling-request: (currency EUR GBP) * 10:15:31 ERROR There was a system error while retrieving the price quotes. * 10:15:37 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:37 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. On 15 August 2020 19:20 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Run GnuCash from Powershell as you did before: & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug (The last time the command was & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug --nofile but that last command, --nofile, tells GnuCash to not open the previous data file. Last time I didn't need to see anything from a data file and starting GnuCash without one is faster. This time I do want you to have access to your data file.) This time edit an exchange rate on an existing multi-currency transaction and use the Fetch Rate button to attempt to get an online quote. Dismiss the error dialog, cancel the edit, and quit GnuCash. Then list the log files Get-ChildItem -P
Re: [GNC] Ubuntu distribution version
Derek, The choices on what versions are supplied wiith a given OS version are made by the maintainers of the OS distribution. They usually use the current GnuCash version (but not always) at the time of release of a new OS version. If you want to stay up to date with GnuCash, the main options are to use the flatpak or snap versions of GnuCash where available or to build the latest version of GnuCash from the sources as described in the wiki https://wiki.gnucash.org/wiki/Building_On_Linux. Once build environment and the dependencies are installed the process is generally fairly simple. Also check the developer mailing list for any problems with building the most recent version. MySQL8 proved problematical in building GC 4.0/4.1 recently on Linux Mint 20 (ubuntu 20.04 based) which was fixed by downgrading a mysqlclient library that GnuCash depends on as described in the dev mailing list. 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.