Re: [GNC] Register layout
> On Feb 20, 2020, at 12:52 PM, Ron wrote: > > How do I re-arrange the layout of the check register to my liking? > > How do I get auto-fill for the payee? The register layout is currently hard coded, so it's "our way or the highway", sorry. Auto fill works by repeating previous entries so once you've created a transaction for a particular payee in an account you'll get auto-fill for subsequent entries with the same description. You can fiddle that a bit by letting autocomplete fill in based on a partial entry, tabbing through to the debit or credit column and then tabbing back and editing the description to what you want for the current transaction. For example, I like the description of dividend reinvestments to include the number of units as a cross-check. I might have 10/11/2019 Reinvest FMAGX 23.11 Assets:Investments:Fidelity:Magellan Fund251.67 and when it's time to do the next dividend I'll start "Reinvest FMAGX" and let it fill in the 23.11 and tab through so that it fills in the account for me. I'll edit the new value and then back-tab to the description and change the number of units. When I hit enter the transfer dialog will pop up where I'll enter the number of units again. Then when I go to reconcile the FMAGX account if it doesn't reconcile I can check the amount against what I put in the description and if there's a discrepancy it's a good clue about why it doesn't reconcile. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to use input method in GnuCash installed from Flatpak ?
Long, if you look back through the archives I think you will find some posts re having to grant permissions to the flatpak system to access Linux system resources. http://docs.flatpak.org/en/latest/sandbox-permissions-reference.html 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] How to use input method in GnuCash installed from Flatpak ?
i'm using ibus 1.5.17 on my linux mint 19.3 and installed GnuCash from Flatpak -- 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] Upgrade
Thanks Frank. On 2/20/20 4:41 PM, Frank H. Ellenberger wrote: Hello Les, did you read https://wiki.gnucash.org/wiki/Flatpak? Regards Frank Am 20.02.20 um 22:32 schrieb Les: I am currently using Linux Mint 19.1 and GC 2.6.19 and I am wondering if I can upgrade to 3.8 using flatpak? Thanks, Les ___ 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] Failed import
It would be great if you could try narrow down the offending transaction and submit the qif file in Bugzilla. On Fri, 21 Feb 2020, 3:29 am Ron, wrote: > I thought I had this figured out and have been importing small chunks from > Quicken. I imported 6 months twice from a credit card and it was fine. > Tried > to import the last 2 months and it failed. I removed 2 duplicate > transactions, but still happened. Any ideas? > > > > Ron > > > > ___ > 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] Upgrade
Hello Les, did you read https://wiki.gnucash.org/wiki/Flatpak? Regards Frank Am 20.02.20 um 22:32 schrieb Les: > I am currently using Linux Mint 19.1 and GC 2.6.19 and I am wondering if > I can upgrade to 3.8 using flatpak? > > Thanks, > > Les ___ 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] Upgrade
I am currently using Linux Mint 19.1 and GC 2.6.19 and I am wondering if I can upgrade to 3.8 using flatpak? Thanks, Les ___ 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] Register layout
How do I re-arrange the layout of the check register to my liking? How do I get auto-fill for the payee? Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to use input method in GnuCash installed from Flatpak ?
Hello Long, Am 20.02.20 um 19:30 schrieb Long: > Dear GnuCash, > i'm vietnamese and tried to use Ibus method to type in your software > installed from Flatpak. Because i really don't know how to install your > software from source, read some wiki doesn't help me, maybe easiest guide > will helpful. > For now, the "ONLY" way is write down my things and copy it into your app, > my god. does your computer fulfill all requirements: https://github.com/flatpak/flatpak/issues/675#issuecomment-344857243 ? Regards Frank ___ 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] Failed import
I thought I had this figured out and have been importing small chunks from Quicken. I imported 6 months twice from a credit card and it was fine. Tried to import the last 2 months and it failed. I removed 2 duplicate transactions, but still happened. Any ideas? Ron ___ 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] Precision in exchange rate conversion
Yes, they're both standard registers (both bank current accounts in fact). Paul On 20/02/2020 16:06, Derek Atkins wrote: Hi, Are you doing this in a standard register or in a Stock/Mutual register? In a stock/mutual register it has inputs for quantity, amount, and price-per-unit. In this case, the quantity and amount are stored, and the price-per-unit is computed. You can enter 2/3 and GnuCash will compute the 3rd for you, so if we recommend entering in the two stored values. In the regular register, however, where you get an "exchange rate dialog", that's not how it works. In that case it DOES store and use the exchange rate. So if you have the rate "displayed" as a decimal then it can round and cause this behavior. If it's stored as a fraction, then you wont have that behavior. It USED to be the case that the "rate" column was hidden and always stored as a fraction, so this wasn't an issue. I'm not sure when it changed. John's message reminded me of this change, but I was unaware that it affected the rate column (which, IMHO, it should not have since it is supposed to be a non-visible column in the standard register). -derek On Thu, February 20, 2020 1:53 pm, Paul Abraham wrote: No, sorry, that's not what I meant. I'm sure the fractional representation, unhelpful though it is, is right*. It's the fact that if I set the display setting to decimal, gnucash tramples on the input value for the converted amount - I enter 11102.12 and it changes it to 11102.08. This is what is not very clever - the programming here . Display settings shouldn't affect actual data, and especially not user entered data (and even more especially not without advising the user - it does this silently). * ... well, in a sense: The arithmetic is right. But that isn't how exchange rates work - banks don't start from the original and converted values and calculate an absolutely precise ratio between the two. The exchange rate comes first. The original value is multiplied by the exchange rate (which is a decimal value) and then round the result to form the converted value. Gnucash's fractional version is a fiction. Regards Paul Abraham On 20/02/2020 01:01, John Ralls wrote: That's not mangling the data, it's presenting the exact value of 11102.12/1975.10, a number that isn't representable as a decimal without rounding. As for the display being clever, of course it isn't, it's a computer. But it you enter the two values 11102.12 and 1975.10 GnuCash shouldn't change them, it should just calculate the ratio and present that as the price, either exactly as 5 + 61331/98755 or as 5.621041972558352 rounded to however many decimal places. When I test that, it's exactly what I get, see the attached screen shot. Note the exact exchange rate in the exchange rate box but the rounded decimal values to the right of it. Regards, John Ralls On Feb 19, 2020, at 12:12 PM, Paul Abraham [1]<[1]p...@acasa.org.uk> wrote: Hmm. That seems to work, but it certainly isn't what I want. The exchange rate is now shown as "5 + 61331/98755" which is less than helpful - it most certainly is not how real world exchange rates are quoted, and it makes comparison almost impossible! Why does the display option mangle the data? That isn't very clever. I think I'll just stick in a fudge factor as a separate split to correct the total though it's a long way from ideal. Thanks very much for the answer, though. I can stop chasing moonbeams now ;-) [[2]cid:part2.62ACF325.60F042A3@acasa.org.uk] References 1. [3]mailto:p...@acasa.org.uk ___ gnucash-user mailing list [4]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [5]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [6]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. References 1. mailto:[1]p...@acasa.org.uk 2. cid:part2.62ACF325.60F042A3@acasa.org.uk 3. mailto:p...@acasa.org.uk 4. mailto:gnucash-user@gnucash.org 5. https://lists.gnucash.org/mailman/listinfo/gnucash-user 6. https://wiki.gnucash.org/wiki/Mailing_Lists ___ 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] Precision in exchange rate conversion
Hi, Are you doing this in a standard register or in a Stock/Mutual register? In a stock/mutual register it has inputs for quantity, amount, and price-per-unit. In this case, the quantity and amount are stored, and the price-per-unit is computed. You can enter 2/3 and GnuCash will compute the 3rd for you, so if we recommend entering in the two stored values. In the regular register, however, where you get an "exchange rate dialog", that's not how it works. In that case it DOES store and use the exchange rate. So if you have the rate "displayed" as a decimal then it can round and cause this behavior. If it's stored as a fraction, then you wont have that behavior. It USED to be the case that the "rate" column was hidden and always stored as a fraction, so this wasn't an issue. I'm not sure when it changed. John's message reminded me of this change, but I was unaware that it affected the rate column (which, IMHO, it should not have since it is supposed to be a non-visible column in the standard register). -derek On Thu, February 20, 2020 1:53 pm, Paul Abraham wrote: >No, sorry, that's not what I meant. I'm sure the fractional >representation, unhelpful though it is, is right*. > >It's the fact that if I set the display setting to decimal, gnucash >tramples on the input value for the converted amount - I enter 11102.12 >and it changes it to 11102.08. This is what is not very clever - the >programming here . Display settings shouldn't affect actual data, and >especially not user entered data (and even more especially not without >advising the user - it does this silently). > >* ... well, in a sense: The arithmetic is right. But that isn't how >exchange rates work - banks don't start from the original and converted >values and calculate an absolutely precise ratio between the two. The >exchange rate comes first. The original value is multiplied by the >exchange rate (which is a decimal value) and then round the result to >form the converted value. Gnucash's fractional version is a fiction. > >Regards > >Paul Abraham > >On 20/02/2020 01:01, John Ralls wrote: > >That's not mangling the data, it's presenting the exact value of >11102.12/1975.10, a number that isn't representable as a decimal >without rounding. > >As for the display being clever, of course it isn't, it's a computer. > >But it you enter the two values 11102.12 and 1975.10 GnuCash shouldn't >change them, it should just calculate the ratio and present that as the >price, either exactly as 5 + 61331/98755 or as 5.621041972558352 >rounded to however many decimal places. When I test that, it's exactly >what I get, see the attached screen shot. Note the exact exchange rate >in the exchange rate box but the rounded decimal values to the right of >it. > >Regards, > >John Ralls > > On Feb 19, 2020, at 12:12 PM, Paul Abraham <[1]p...@acasa.org.uk> > wrote: > Hmm. That seems to work, but it certainly isn't what I want. The >exchange rate is now shown as "5 + 61331/98755" which is less than >helpful - it most certainly is not how real world exchange rates > are >quoted, and it makes comparison almost impossible! >Why does the display option mangle the data? That isn't very > clever. I >think I'll just stick in a fudge factor as a separate split to > correct >the total though it's a long way from ideal. >Thanks very much for the answer, though. I can stop chasing > moonbeams >now ;-) > >[cid:part2.62ACF325.60F042A3@acasa.org.uk] > > References > >1. mailto:p...@acasa.org.uk > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to use input method in GnuCash installed from Flatpak ?
Dear GnuCash, i'm vietnamese and tried to use Ibus method to type in your software installed from Flatpak. Because i really don't know how to install your software from source, read some wiki doesn't help me, maybe easiest guide will helpful. For now, the "ONLY" way is write down my things and copy it into your app, my god. -- 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] Credit Card bill autopay
the easiest way to do that is : 1 - Enter a transactions to your Credit Card with "NO AMOUNT" 2 - Right click to it and make a Schedule 3 - In the Frequency Tab, make it create transaction every months at 1st or 2nd. 4 - In the Overview Tab, choose a Create in advance = 19 days (from 12 to 1st = ~19 days) That it, so every month, about 12, it will create a payment to your credit card with "no amount", you can access to your account and enter the amount you want. I know that it still requires you manually enter your amount, but with this tips, i think it's easiest and best. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Where should i put my account "Loan to a Friend" when they evaded debt ?
On 20/2/20 2:47 pm, Long wrote: Hello GnuCash Users, I just assumed that when i loan to a friend and they don't give my money back, and then, where should i put that Account to make it doesn't not affect my Assets ? i mean, my Asset only had 100$, "Stealer" owed to me about 20$, everytime i open GnuCash... oh, look, this month i got 120$, and check my bank, oh man, it's only 100$... To Expense : I assumed that i want to put it to Expense, maybe it's make sense, because i already spent my money. To Liability : How about move it to Liability ? so look at a placeholder "Liability", my owe will decrease because i will make a negative account for "owed to me". it seems like unreasonable for me when i check my owed. of course, this is just assumed, like the way GnuCash teach us when the first time we fall in love with GnuCash. Thank you for take your time to read this post, and help me. Expense account --->> Bad debts. Write it off and be glad the experience only cost you 20 bucks... -- 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. -- the melancholy of all things completed. ___ 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.