Re: [GNC] I can't get the budget feature to work.
Glad to see you have it working. Certainly, feedback to the user is important. The challenge is trying to determine (or guess) if the result was intended or not. GnuCash allows for users to heavily customize their chart of accounts to meet their individual needs. I’ve learned over the years that what appears as a bug to one person, might be desired behavior by another. Of course, the tools provided should work. I think in this case, some sort of test would need to be performed for GnuCash to check if any result was returned at all, and then if not, alert the user to the problem. There are some reports which do this already. (they will show a message indicating you need to set some options first to obtain any usable output) If you can reliably repeat the steps necessary to produce the ’not working’ condition and can well describe this condition, preferably with some screenshots, please file a bug on it. That won’t mean it will get tended to right away, but it will be documented as something needing attention for when developers do get to improving the budget module.(or any other part of the software so affected) Regards, Adrien > On Jan 24, 2019, at 11:36 PM, Lorrie Laskey wrote: > > Mystery solved. > > I did as you suggested and went through all of my account types and their > child accounts and did have some that were not categorized properly. > Voila! The budget now works. > > I would like to suggest some kind of user help when issues arise. If the > budget is not working, possibly an error message or a popup with helpful > suggestions or a bug report popup. > > Back to the budget, I am looking forward to testing my budget this year and > making wiser money choices and putting some money aside for special > purchases. Having my money under control is such a comforting feeling. > > Thanks to the creators of this wonderful tool. ___ 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] I can't get the budget feature to work.
Mystery solved. I did as you suggested and went through all of my account types and their child accounts and did have some that were not categorized properly. Voila! The budget now works. I would like to suggest some kind of user help when issues arise. If the budget is not working, possibly an error message or a popup with helpful suggestions or a bug report popup. Back to the budget, I am looking forward to testing my budget this year and making wiser money choices and putting some money aside for special purchases. Having my money under control is such a comforting feeling. Thanks to the creators of this wonderful tool. On Thu, Jan 24, 2019 at 7:37 PM Lorrie Laskey wrote: > Hi, > > I don't understand what you mean by "top-level account" and "one account > type". Can you give me examples? > > I don't understand much of gnucash despite reading the articles and > watching tutorials. > > On Thu, Jan 24, 2019 at 8:02 AM wrote: > >> Lorrie, >> >> I've seen this problem in GnuCash 2.6; I don't know whether it has >> changed in 3.x: >> >> Make sure that you have only one account of type Expense and one account >> of type Asset at the top level of your accounts. If you have more than >> one, then the budget function doesn't work as you've described. >> >> You can check this by going to the Accounts tab, right-clicking (in >> Windows, might be different on a Mac?) on each top-level account, and >> selecting "Edit Account". This will open an options window for the >> account. The account type is at the lower left. >> >> Hope that helps. >> >> On 2019-01-24 1:43 a.m., gnucash-user-requ...@gnucash.org wrote: >> > Message: 5 >> > Date: Wed, 23 Jan 2019 19:09:49 -0800 >> > From: Lorrie Laskey >> > To:gnucash-user@gnucash.org >> > Subject: [GNC] I can't get the budget feature to work. >> > Message-ID: >> > > 2ksto-bklwetca7...@mail.gmail.com> >> > Content-Type: text/plain; charset="UTF-8" >> > >> > Hi all, >> > >> > I created a 12 -period 2019 budget and entered child-level expenses and >> > income. >> > >> > The expenses have a total in the spreadsheet but are not showing up at >> the >> > bottom of the spreadsheet. Expenses still display as "0". >> > >> > What am I missing? >> >> ___ 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] Currency symbol (INR) not showing on Tax Invoice report
Update: It seems you *can* control them just for Mail. Edit > Substitutions > Smart Quotes. (or show Substitutions and then select/unselect) Let's see if that worked "". Yep, looks like it. Checking my system-wide preferences shows them still enabled but they rendered correctly here. Now I'll turn it back on for Mail... “”! (note, the menu preference is only available with a message window open for editing.) Regards, Adrien > On Jan 24, 2019, at 11:10 PM, John Ralls wrote: > > Adriene, > > That's "smart-quotes". Unfortunately there's no control in Mail to disable > it, not even setting plain text works. It can be disabled globally in System > Preferences>Keyboard>Text and I think separately in TextEdit and Pages. > > 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] Currency symbol (INR) not showing on Tax Invoice report
Yep, figured as much. I was hoping it was just a replacement table. I generally
prefer them for non-technical writing, but I probably need standard quotes
more. I probably didn’t notice it before because my editor of choice at the
moment is Atom which doesn’t auto-correct them. (so the setting is either not
global, or Atom doesn’t hook into that service, thankfully) I can just as
easily get proper quotes by using opt-[ and opt-], so I’m going to turn them
off.
Thanks.
Regards,
Adrien
> On Jan 24, 2019, at 11:10 PM, John Ralls wrote:
>
> Adriene,
>
> That's "smart-quotes". Unfortunately there's no control in Mail to disable
> it, not even setting plain text works. It can be disabled globally in System
> Preferences>Keyboard>Text and I think separately in TextEdit and Pages.
>
> Regards,
> John Ralls
>
>> On Jan 24, 2019, at 5:44 PM, Adrien Monteleone
>> wrote:
>>
>> Good catch! (my font is too small to notice easily)
>>
>> Sometimes I hate autocorrect. It isn’t intelligent enough to comprehend that
>> when composing in plain-text, I probably want the literal characters I
>> typed, not substitutions. (technically, I guess this *is* still plain text)
>> I have mine set to replace quotes with their proper versions. I guess I’ll
>> have to train my fingers to use proper quotes on my 3rd level keys instead
>> or else use autocorrect to replace those with their alternate versions.
>>
>> So yes, if the font name contains spaces, it must be enclosed in quotes
>> (single or double) - the kind you get by using the key (most likely) to the
>> immediate left of the enter/return key. (on U.S. or International
>> keyboards)—that is, ascii 34 or 39, html entity or .
>>
>> Now on that point to anyone reading this thread and trying to copy/paste my
>> sample rules - DON’T! They won’t work. You’ll need to type proper quotes in
>> place of mine.
>>
>> Regards,
>> Adrien
>>
>>> On Jan 24, 2019, at 4:56 PM, Fred Bone wrote:
>>>
>>> On Thursday, January 24, 2019 at 7:14, Adrien Monteleone said:
>>>
Place the following in the Embedded CSS section of the Notes tab under the
invoice’s options:
* {font: “name of font"; }
This will change the font on the entire invoice. It should then render the
INR currency symbol. If the font name has spaces, you must enclose it in
“”.
>>>
>>> NO!!!
>>>
>>> You must enclose it in "".
>>>
>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report
Adriene,
That's "smart-quotes". Unfortunately there's no control in Mail to disable it,
not even setting plain text works. It can be disabled globally in System
Preferences>Keyboard>Text and I think separately in TextEdit and Pages.
Regards,
John Ralls
> On Jan 24, 2019, at 5:44 PM, Adrien Monteleone
> wrote:
>
> Good catch! (my font is too small to notice easily)
>
> Sometimes I hate autocorrect. It isn’t intelligent enough to comprehend that
> when composing in plain-text, I probably want the literal characters I typed,
> not substitutions. (technically, I guess this *is* still plain text) I have
> mine set to replace quotes with their proper versions. I guess I’ll have to
> train my fingers to use proper quotes on my 3rd level keys instead or else
> use autocorrect to replace those with their alternate versions.
>
> So yes, if the font name contains spaces, it must be enclosed in quotes
> (single or double) - the kind you get by using the key (most likely) to the
> immediate left of the enter/return key. (on U.S. or International
> keyboards)—that is, ascii 34 or 39, html entity or .
>
> Now on that point to anyone reading this thread and trying to copy/paste my
> sample rules - DON’T! They won’t work. You’ll need to type proper quotes in
> place of mine.
>
> Regards,
> Adrien
>
>> On Jan 24, 2019, at 4:56 PM, Fred Bone wrote:
>>
>> On Thursday, January 24, 2019 at 7:14, Adrien Monteleone said:
>>
>>> Place the following in the Embedded CSS section of the Notes tab under the
>>> invoice’s options:
>>>
>>>
>>> * {font: “name of font"; }
>>>
>>>
>>> This will change the font on the entire invoice. It should then render the
>>> INR currency symbol. If the font name has spaces, you must enclose it in
>>> “”.
>>
>> NO!!!
>>
>> You must enclose it in "".
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] lost data
Hi John, I'm pretty sure there is no secret list of all the gnucash data files you've opened. You might like to check you just are not seeing some transactions because of a filter you've applied: In the register, View Filter By If you still cannot see some transactions, the list of recently opened files is held (In Windows) int the registry. This may help: https://lists.gnucash.org/pipermail/gnucash-user/2018-May/077231.html See my mail at the end. Regards, Chris Good Message: 10 Date: Fri, 25 Jan 2019 10:22:12 +0800 From: John Sears To: gnucash-user@gnucash.org Subject: Re: [GNC] lost data Message-ID: <32da9d3b-4650-292e-e82d-6b325c4f5...@yahoo.com> Content-Type: text/plain; charset=utf-8; format=flowed Thanks, Fairly sure its gone somewhere, and I have written over it somehow,? as I have all the associated files in pdf format, but no transactions in the accounts :(..? old pc used to do a regular backup, but ... Thanks anyway, and perhaps there is a list.. which hopfully someone can point me to, before I start searching my harddrive with a partition microscope. Thanks, John On 25/1/19 10:13 AM, Adrien Monteleone wrote: > As far as I know, only those four, so if you?ve been opening files searching for ?the one? you might have tainted the list. Perhaps one of the more seasoned users or devs knows if there is a larger master URI list. > > One final thing to consider is to check your balances. Are they otherwise correct? Run a transaction report and only show activity in Q4 (or a P/Income Statement) Do you get blank results or does something show up to indicate the data is there? If you get decent reporting, perhaps the register you are viewing is set to some filter. > > Other than that, without a backup... > > Regards, > Adrien > >> On Jan 24, 2019, at 8:07 PM, John Sears via gnucash-user wrote: >> >> Hi , >> >> Yep I've already tried this, and found various previous versions ( backups - which I obviously did not do often enough) .. but none on my computer with any log files or the transactions for Q4. I was rather hoping that GNU cash would list the files with the URI somewhere ( beyond the 4 that it does show under the file tab). Im assuming that the four listed files are dydnamic and it only keeps the four URI's? >> >> >> Thanks, >> >> John >> >> >> >> On 25/1/19 9:51 AM, Adrien Monteleone wrote: >>> You could use your file manager search function to look for *.gnucash files. >>> >>> But within GnuCash, do this: >>> >>> Try to open one of the files in your history list in the File menu. >>> If it exists still in that same place, it will open, if not, it will >>> tell you the URI of where it was expected to find it. This might >>> give some clue as to where to go looking. (I just did this and >>> discovered I had moved a file into a ?finances? subdirectory of its >>> former location) >>> >>> If it opens successfully, but you need to know where it is stored, go to Find > Open and you?ll see above the file list is a button based ?breadcrumb? trail showing you the file path. >>> >>> Regards, >>> Adrien >>> On Jan 24, 2019, at 6:38 PM, John Sears via gnucash-user wrote: Hi All, A few months ago, I moved the location of my GNUcash file (along with the addressing of the associated linked files - you may remember a post about this). I have been living a fairly hectic life since, moving country, massively downsizing etc, and a fairly annoying pc problem. I am sure that I did a lot of work on GNU Cash in Q4, but noticed the other day that all of these transactions were missing and that my GNUCash was pointing at an old GNUCash file. I've looked everywhere on my computer and USBs for the file that I think might contain the transactions that I am sure I put in ( It was a lot of work, so I don't want to just retype them again), but I just cannot find the file. I notice that GNUCash highlights the last 4 files that have been opened ( under the file tab) . Is there a way to see all the files that have been opened historically and their location in the file directory. I just cannot find the correct file or any logs for the data that I entered in Q4, and at least if I know the possible paths, I might be able to ascertain if the data has somehow managed to be deleted from that location, and then determine my way forward Thanks! john ___ 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] I can't get the budget feature to work.
Hi, I don't understand what you mean by "top-level account" and "one account type". Can you give me examples? I don't understand much of gnucash despite reading the articles and watching tutorials. On Thu, Jan 24, 2019 at 8:02 AM wrote: > Lorrie, > > I've seen this problem in GnuCash 2.6; I don't know whether it has > changed in 3.x: > > Make sure that you have only one account of type Expense and one account > of type Asset at the top level of your accounts. If you have more than > one, then the budget function doesn't work as you've described. > > You can check this by going to the Accounts tab, right-clicking (in > Windows, might be different on a Mac?) on each top-level account, and > selecting "Edit Account". This will open an options window for the > account. The account type is at the lower left. > > Hope that helps. > > On 2019-01-24 1:43 a.m., gnucash-user-requ...@gnucash.org wrote: > > Message: 5 > > Date: Wed, 23 Jan 2019 19:09:49 -0800 > > From: Lorrie Laskey > > To:gnucash-user@gnucash.org > > Subject: [GNC] I can't get the budget feature to work. > > Message-ID: > >2ksto-bklwetca7...@mail.gmail.com> > > Content-Type: text/plain; charset="UTF-8" > > > > Hi all, > > > > I created a 12 -period 2019 budget and entered child-level expenses and > > income. > > > > The expenses have a total in the spreadsheet but are not showing up at > the > > bottom of the spreadsheet. Expenses still display as "0". > > > > What am I missing? > > ___ 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] Fw: Budget Total Anomalies: attached files
Two ideas: 1. The error relates to the first column in the spreadsheet. The first column may include several budget periods. Please let us know the report general options. 2. The total amount may include amounts in the placeholder "expenses" account -- please check if this parent account has any transactions. Please file bugs, and ideally some test cases. On Fri., 25 Jan. 2019, 04:11 Peter Jackson I attach > 1) Export of Budget Report > 2) Excel version of same, which shows the January Downcast total (in > Green) does not equal Gnucash January Total at top of column' > > Please help. > Regards > > Peter > > > > -- Forwarded Message > From: Peter Jackson > Date: 20/01/19 14:23:59 > Subject: [GNC] Budget Total Anomalies > To: GNU Cash User > > I use Gnucash 3.4 on Windows 10. > > I have just noticed that the budget total figures are no longer correct. > Thus for example, in ExpensesBudget , the displayed Monthly total for > each month does not equal the sum of the individual account budgets. > > This imbalance then reflects across all budget reports. > > I am pretty certain that this is a new issue, as I tend to balance > regularly with a spreadsheet. > > Any suggestions > > Thanks > > > Peter > ___ > 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] lost data
In a worst case, there are linux-based data recovery tools you can run from a live cd that can image the drive and rebuild files from that image. Deleting a file and even emptying the trash does not necessarily destroy the data, but simply prevents the OS from accessing it and frees up the disk space to be written to. (it may not have been re-used yet) However, the time involved in doing such a recovery may be greater than simply re-entering the data if you have it in some other form. Best of luck. Regards, Adrien > On Jan 24, 2019, at 8:39 PM, John Sears via gnucash-user > wrote: > > Hi David, > > Ill check some of these out, but I have done a fairly extensive search on my > laptop already.. so fear the worst > > I think your description of what has happened is spot on... the trouble is > that in the meantime I think I have done a lot off "cleaning up", and I am > sort of dreadign that I have assigned it to the rubbish bin, and its already > been overwritten on file ( my hard disk is now in read only status, but I > fear I may have spotted it too late) > > Thanks a lot! > > john > ___ 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] lost data
Hi David, Ill check some of these out, but I have done a fairly extensive search on my laptop already.. so fear the worst I think your description of what has happened is spot on... the trouble is that in the meantime I think I have done a lot off "cleaning up", and I am sort of dreadign that I have assigned it to the rubbish bin, and its already been overwritten on file ( my hard disk is now in read only status, but I fear I may have spotted it too late) Thanks a lot! john On 25/1/19 10:21 AM, David Cousens wrote: John, If Adrien's suggestions don't work the following site has techniques for finding files on windows https://edu.gcfglobal.org/en/windowsbasics/finding-files-on-your-computer/1/ and for Linux https://www.linode.com/docs/tools-reference/tools/find-files-in-linux-using-the-command-line/. Looking for files with .gnucash extensions starting with your home directory and then expanding the search is your best bet. ($find -name "*.gnucash" will find all occurrences in the directory pointed to by path in Linux). A common problem which occurs sometimes is having opened a backup file (which is located in the same directory as your main file) and then subsequently opening the main file again. Your missing transactions could be in a backup file. See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html. David Cousens On Fri, 2019-01-25 at 08:38 +0800, John Sears via gnucash-user wrote: Hi All, A few months ago, I moved the location of my GNUcash file (along with the addressing of the associated linked files - you may remember a post about this). I have been living a fairly hectic life since, moving country, massively downsizing etc, and a fairly annoying pc problem. I am sure that I did a lot of work on GNU Cash in Q4, but noticed the other day that all of these transactions were missing and that my GNUCash was pointing at an old GNUCash file. I've looked everywhere on my computer and USBs for the file that I think might contain the transactions that I am sure I put in ( It was a lot of work, so I don't want to just retype them again), but I just cannot find the file. I notice that GNUCash highlights the last 4 files that have been opened ( under the file tab) . Is there a way to see all the files that have been opened historically and their location in the file directory. I just cannot find the correct file or any logs for the data that I entered in Q4, and at least if I know the possible paths, I might be able to ascertain if the data has somehow managed to be deleted from that location, and then determine my way forward Thanks! john ___ 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] lost data
Thanks, Fairly sure its gone somewhere, and I have written over it somehow, as I have all the associated files in pdf format, but no transactions in the accounts :(.. old pc used to do a regular backup, but ... Thanks anyway, and perhaps there is a list.. which hopfully someone can point me to, before I start searching my harddrive with a partition microscope. Thanks, John On 25/1/19 10:13 AM, Adrien Monteleone wrote: As far as I know, only those four, so if you’ve been opening files searching for “the one” you might have tainted the list. Perhaps one of the more seasoned users or devs knows if there is a larger master URI list. One final thing to consider is to check your balances. Are they otherwise correct? Run a transaction report and only show activity in Q4 (or a P/Income Statement) Do you get blank results or does something show up to indicate the data is there? If you get decent reporting, perhaps the register you are viewing is set to some filter. Other than that, without a backup... Regards, Adrien On Jan 24, 2019, at 8:07 PM, John Sears via gnucash-user wrote: Hi , Yep I've already tried this, and found various previous versions ( backups - which I obviously did not do often enough) .. but none on my computer with any log files or the transactions for Q4. I was rather hoping that GNU cash would list the files with the URI somewhere ( beyond the 4 that it does show under the file tab). Im assuming that the four listed files are dydnamic and it only keeps the four URI's? Thanks, John On 25/1/19 9:51 AM, Adrien Monteleone wrote: You could use your file manager search function to look for *.gnucash files. But within GnuCash, do this: Try to open one of the files in your history list in the File menu. If it exists still in that same place, it will open, if not, it will tell you the URI of where it was expected to find it. This might give some clue as to where to go looking. (I just did this and discovered I had moved a file into a ‘finances’ subdirectory of its former location) If it opens successfully, but you need to know where it is stored, go to Find > Open and you’ll see above the file list is a button based ‘breadcrumb’ trail showing you the file path. Regards, Adrien On Jan 24, 2019, at 6:38 PM, John Sears via gnucash-user wrote: Hi All, A few months ago, I moved the location of my GNUcash file (along with the addressing of the associated linked files - you may remember a post about this). I have been living a fairly hectic life since, moving country, massively downsizing etc, and a fairly annoying pc problem. I am sure that I did a lot of work on GNU Cash in Q4, but noticed the other day that all of these transactions were missing and that my GNUCash was pointing at an old GNUCash file. I've looked everywhere on my computer and USBs for the file that I think might contain the transactions that I am sure I put in ( It was a lot of work, so I don't want to just retype them again), but I just cannot find the file. I notice that GNUCash highlights the last 4 files that have been opened ( under the file tab) . Is there a way to see all the files that have been opened historically and their location in the file directory. I just cannot find the correct file or any logs for the data that I entered in Q4, and at least if I know the possible paths, I might be able to ascertain if the data has somehow managed to be deleted from that location, and then determine my way forward Thanks! john ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription
Re: [GNC] lost data
John, If Adrien's suggestions don't work the following site has techniques for finding files on windows https://edu.gcfglobal.org/en/windowsbasics/finding-files-on-your-computer/1/ and for Linux https://www.linode.com/docs/tools-reference/tools/find-files-in-linux-using-the-command-line/. Looking for files with .gnucash extensions starting with your home directory and then expanding the search is your best bet. ($find -name "*.gnucash" will find all occurrences in the directory pointed to by path in Linux). A common problem which occurs sometimes is having opened a backup file (which is located in the same directory as your main file) and then subsequently opening the main file again. Your missing transactions could be in a backup file. See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html. David Cousens On Fri, 2019-01-25 at 08:38 +0800, John Sears via gnucash-user wrote: > Hi All, > > A few months ago, I moved the location of my GNUcash file (along with > the addressing of the associated linked files - you may remember a post > about this). I have been living a fairly hectic life since, moving > country, massively downsizing etc, and a fairly annoying pc problem. I > am sure that I did a lot of work on GNU Cash in Q4, but noticed the > other day that all of these transactions were missing and that my > GNUCash was pointing at an old GNUCash file. I've looked everywhere on > my computer and USBs for the file that I think might contain the > transactions that I am sure I put in ( It was a lot of work, so I don't > want to just retype them again), but I just cannot find the file. > > I notice that GNUCash highlights the last 4 files that have been opened > ( under the file tab) . Is there a way to see all the files that have > been opened historically and their location in the file directory. I > just cannot find the correct file or any logs for the data that I > entered in Q4, and at least if I know the possible paths, I might be > able to ascertain if the data has somehow managed to be deleted from > that location, and then determine my way forward > > > Thanks! > > john > > > ___ > 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] lost data
As far as I know, only those four, so if you’ve been opening files searching for “the one” you might have tainted the list. Perhaps one of the more seasoned users or devs knows if there is a larger master URI list. One final thing to consider is to check your balances. Are they otherwise correct? Run a transaction report and only show activity in Q4 (or a P/Income Statement) Do you get blank results or does something show up to indicate the data is there? If you get decent reporting, perhaps the register you are viewing is set to some filter. Other than that, without a backup... Regards, Adrien > On Jan 24, 2019, at 8:07 PM, John Sears via gnucash-user > wrote: > > Hi , > > Yep I've already tried this, and found various previous versions ( backups - > which I obviously did not do often enough) .. but none on my computer with > any log files or the transactions for Q4. I was rather hoping that GNU cash > would list the files with the URI somewhere ( beyond the 4 that it does show > under the file tab). Im assuming that the four listed files are dydnamic and > it only keeps the four URI's? > > > Thanks, > > John > > > > On 25/1/19 9:51 AM, Adrien Monteleone wrote: >> You could use your file manager search function to look for *.gnucash files. >> >> But within GnuCash, do this: >> >> Try to open one of the files in your history list in the File menu. If it >> exists still in that same place, it will open, if not, it will tell you the >> URI of where it was expected to find it. This might give some clue as to >> where to go looking. (I just did this and discovered I had moved a file into >> a ‘finances’ subdirectory of its former location) >> >> If it opens successfully, but you need to know where it is stored, go to >> Find > Open and you’ll see above the file list is a button based >> ‘breadcrumb’ trail showing you the file path. >> >> Regards, >> Adrien >> >>> On Jan 24, 2019, at 6:38 PM, John Sears via gnucash-user >>> wrote: >>> >>> Hi All, >>> >>> A few months ago, I moved the location of my GNUcash file (along with the >>> addressing of the associated linked files - you may remember a post about >>> this). I have been living a fairly hectic life since, moving country, >>> massively downsizing etc, and a fairly annoying pc problem. I am sure >>> that I did a lot of work on GNU Cash in Q4, but noticed the other day >>> that all of these transactions were missing and that my GNUCash was >>> pointing at an old GNUCash file. I've looked everywhere on my computer and >>> USBs for the file that I think might contain the transactions that I am >>> sure I put in ( It was a lot of work, so I don't want to just retype them >>> again), but I just cannot find the file. >>> >>> I notice that GNUCash highlights the last 4 files that have been opened ( >>> under the file tab) . Is there a way to see all the files that have been >>> opened historically and their location in the file directory. I just >>> cannot find the correct file or any logs for the data that I entered in Q4, >>> and at least if I know the possible paths, I might be able to ascertain if >>> the data has somehow managed to be deleted from that location, and then >>> determine my way forward >>> >>> >>> Thanks! >>> >>> john >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see
Re: [GNC] lost data
Hi , Yep I've already tried this, and found various previous versions ( backups - which I obviously did not do often enough) .. but none on my computer with any log files or the transactions for Q4. I was rather hoping that GNU cash would list the files with the URI somewhere ( beyond the 4 that it does show under the file tab). Im assuming that the four listed files are dydnamic and it only keeps the four URI's? Thanks, John On 25/1/19 9:51 AM, Adrien Monteleone wrote: You could use your file manager search function to look for *.gnucash files. But within GnuCash, do this: Try to open one of the files in your history list in the File menu. If it exists still in that same place, it will open, if not, it will tell you the URI of where it was expected to find it. This might give some clue as to where to go looking. (I just did this and discovered I had moved a file into a ‘finances’ subdirectory of its former location) If it opens successfully, but you need to know where it is stored, go to Find > Open and you’ll see above the file list is a button based ‘breadcrumb’ trail showing you the file path. Regards, Adrien On Jan 24, 2019, at 6:38 PM, John Sears via gnucash-user wrote: Hi All, A few months ago, I moved the location of my GNUcash file (along with the addressing of the associated linked files - you may remember a post about this). I have been living a fairly hectic life since, moving country, massively downsizing etc, and a fairly annoying pc problem. I am sure that I did a lot of work on GNU Cash in Q4, but noticed the other day that all of these transactions were missing and that my GNUCash was pointing at an old GNUCash file. I've looked everywhere on my computer and USBs for the file that I think might contain the transactions that I am sure I put in ( It was a lot of work, so I don't want to just retype them again), but I just cannot find the file. I notice that GNUCash highlights the last 4 files that have been opened ( under the file tab) . Is there a way to see all the files that have been opened historically and their location in the file directory. I just cannot find the correct file or any logs for the data that I entered in Q4, and at least if I know the possible paths, I might be able to ascertain if the data has somehow managed to be deleted from that location, and then determine my way forward Thanks! john ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Problems with Budget
I see that now, check the reply I sent on the thread. On that note, last time, do not message me directly and only. I’m forwarding this to the list. Others may benefit from knowing my suggestion did not address the issue. This is not a private conversation. Regards, Adrien > On Jan 24, 2019, at 11:26 AM, Peter Jackson wrote: > > Thanks Adrien. So far as I can see your suggestion does not solve the problem. > Regards > Peter > > Nurton Court > Middleton-on-the-Hill > Ludlow SY8 4BD > Tel: 01568 750 248 Mob: 07955 586 476 ___ 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] lost data
You could use your file manager search function to look for *.gnucash files. But within GnuCash, do this: Try to open one of the files in your history list in the File menu. If it exists still in that same place, it will open, if not, it will tell you the URI of where it was expected to find it. This might give some clue as to where to go looking. (I just did this and discovered I had moved a file into a ‘finances’ subdirectory of its former location) If it opens successfully, but you need to know where it is stored, go to Find > Open and you’ll see above the file list is a button based ‘breadcrumb’ trail showing you the file path. Regards, Adrien > On Jan 24, 2019, at 6:38 PM, John Sears via gnucash-user > wrote: > > Hi All, > > A few months ago, I moved the location of my GNUcash file (along with the > addressing of the associated linked files - you may remember a post about > this). I have been living a fairly hectic life since, moving country, > massively downsizing etc, and a fairly annoying pc problem. I am sure that > I did a lot of work on GNU Cash in Q4, but noticed the other day that all > of these transactions were missing and that my GNUCash was pointing at an old > GNUCash file. I've looked everywhere on my computer and USBs for the file > that I think might contain the transactions that I am sure I put in ( It was > a lot of work, so I don't want to just retype them again), but I just cannot > find the file. > > I notice that GNUCash highlights the last 4 files that have been opened ( > under the file tab) . Is there a way to see all the files that have been > opened historically and their location in the file directory. I just cannot > find the correct file or any logs for the data that I entered in Q4, and at > least if I know the possible paths, I might be able to ascertain if the data > has somehow managed to be deleted from that location, and then determine my > way forward > > > Thanks! > > john > > > ___ > 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] Reconciliation is not adding up correctly - what to do??
If your reconciliation is not balancing, it might be worth a quick scan to ensure that any items that you know were reconciled previously are still registered as "cleared". Over the past year [v3.4, Win10], I've had several occasions where my reconciliation for a credit card or bank account would not balance. During the most recent two instances, I happened to notice that one or two items that I had reconciled the previous month were showing as "uncleared". As soon as I checked them, my balance came out OK. Larry On Thursday, January 24, 2019, 6:02:50 PM EST, gnucash-user-requ...@gnucash.org wrote: Date: Thu, 24 Jan 2019 17:01:47 + From: Colin Law On Thu, 24 Jan 2019 at 16:52, D wrote: > > As noted in the Tutorial, the opening balance in a reconciliation is > immaterial. What matters is the ending balance. If they match, then you can > finish reconciliation. It is not immaterial in the sense that if it does not match that from the bank statement then something is wrong, or at least unusual, such as is the very first reconcile in which case the first transaction should be the initial balance which should match the opening balance on the statement. Colin ...[snip]... ___ 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] Fw: Budget Total Anomalies: attached files
Hmm.. Okay, not a problem with the “same day of week” setting then. Do you have any hidden accounts in this budget report? or in the budget itself? Run the report again, make sure to select all children of expenses. In the budget module, use a View > Filter By... filter to make sure everything is visible. Both tabs in the filter dialog should have everything checked off. (by default, hidden and empty/unused accounts are not visible) It is possible you may have budgeted values entered for these accounts and then when re-opening the budget, they reverted to not visible, and when running the report, you might have selected accounts based off a visual inspection of the budget window. However, the visual math is *more* than what the Budget Report is showing. Which would indicate that if a non-visible account is the culprit (or more than one) the net result is a (£1,312.87). Is that figure significant to you in any of your accounts? Are there any negative expenses budgeted in non-visible accounts? Outside of that, I’m a bit perplexed as well since it is not the Actuals that are off but the Budget column that shows a variance from actual math. So actual transactions wouldn’t be something to investigate. If you still don’t have a solution try this: Open a brand new file. (you can export your account structure from the current file and import it to the new one to save time) Create a budget and enter the same figures, watching closely as you do between the reported total for budgeted expenses and what actual math shows it should be. Does this fresh file report the correct amount? (you’ll definitely have to make unused and hidden accounts visible in this case to even see them in the budget window) Does the entry in any particular account cause the expenses total to reduce instead of increase? (when entering a positive number) If the total does decrease when entering a positive amount, or else you have non-visible accounts in the current budget but with positive amounts, this would indicate the type of those accounts has a reversed sign and are probably not properly created as Expense accounts. This can be fixed from the Accounts tab and editing those account, assigning them the correct type. If for some reason you can’t change the type, you’ll need to create new accounts properly, delete the old accounts and let GnuCash move the transactions for you. Then go back to the budget and re-enter your budgeted expenses for them. One last thing to try: change your Reverse Balanced Accounts preference in GnuCash to “none”. (presuming this isn’t your current setting) Close GnuCash. Reopen, run the Budget Report - is it correct? (signs may be opposite of what is expected but all math should work out) Now, change the preference back to what you had before, close, reopen and run the report again. Any differences? (other than displayed signs) Regards, Adrien > On Jan 24, 2019, at 2:10 PM, Peter Jackson wrote: > > I attach > 1) Export of Budget Report > 2) Excel version of same, which shows the January Downcast total (in Green) > does not equal Gnucash January Total at top of column' > > Please help. > Regards > > Peter > > > > -- Forwarded Message > From: Peter Jackson > Date: 20/01/19 14:23:59 > Subject: [GNC] Budget Total Anomalies > To: GNU Cash User > > I use Gnucash 3.4 on Windows 10. > > I have just noticed that the budget total figures are no longer correct. > Thus for example, in ExpensesBudget , the displayed Monthly total for each > month does not equal the sum of the individual account budgets. > > This imbalance then reflects across all budget reports. > > I am pretty certain that this is a new issue, as I tend to balance regularly > with a spreadsheet. > > Any suggestions > > Thanks > > > Peter > 2019.xlsx>___ > 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] lost data
Hi All, A few months ago, I moved the location of my GNUcash file (along with the addressing of the associated linked files - you may remember a post about this). I have been living a fairly hectic life since, moving country, massively downsizing etc, and a fairly annoying pc problem. I am sure that I did a lot of work on GNU Cash in Q4, but noticed the other day that all of these transactions were missing and that my GNUCash was pointing at an old GNUCash file. I've looked everywhere on my computer and USBs for the file that I think might contain the transactions that I am sure I put in ( It was a lot of work, so I don't want to just retype them again), but I just cannot find the file. I notice that GNUCash highlights the last 4 files that have been opened ( under the file tab) . Is there a way to see all the files that have been opened historically and their location in the file directory. I just cannot find the correct file or any logs for the data that I entered in Q4, and at least if I know the possible paths, I might be able to ascertain if the data has somehow managed to be deleted from that location, and then determine my way forward Thanks! john ___ 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] Currency symbol (INR) not showing on Tax Invoice report
On Thursday, January 24, 2019 at 7:14, Adrien Monteleone said:
> Place the following in the Embedded CSS section of the Notes tab under the
> invoice’s options:
>
>
> * {font: “name of font"; }
>
>
> This will change the font on the entire invoice. It should then render the
> INR currency symbol. If the font name has spaces, you must enclose it in
> “”.
NO!!!
You must enclose it in "".
___
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] Fw: Budget Total Anomalies: attached files
I attach 1) Export of Budget Report 2) Excel version of same, which shows the January Downcast total (in Green) does not equal Gnucash January Total at top of column' Please help. Regards Peter -- Forwarded Message From: Peter Jackson Date: 20/01/19 14:23:59 Subject: [GNC] Budget Total Anomalies To: GNU Cash User I use Gnucash 3.4 on Windows 10. I have just noticed that the budget total figures are no longer correct. Thus for example, in ExpensesBudget , the displayed Monthly total for each month does not equal the sum of the individual account budgets. This imbalance then reflects across all budget reports. I am pretty certain that this is a new issue, as I tend to balance regularly with a spreadsheet. Any suggestions Thanks Peter FRAME: [1]frSheet FRAME: [2]frTabs This page uses frames, but your browser doesn't support them. References 1. file:///tmp/Full Report 2019_files/sheet001.html 2. file:///tmp/Full Report 2019_files/tabstrip.html Full Report 2019.xlsx Description: MS-Excel 2007 spreadsheet ___ 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 fails to start on Windows 10
Op donderdag 24 januari 2019 19:51:44 CET schreef Nadir Moss: > Solved the problem. I'm glad you found a solution. > GC seems to crash on startup when using Israel Local on windows. > Changed the Locale from Hebrew (Israel) to English (United Kindom) and now > all works OK. > Seems to be related to a supposedly solved bug: > https://bugs.gnucash.org/show_bug.cgi?id=796728 That bug is not solved. It's still marked as new. There's only a workaround in there, namely changing the locale as you found. 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] Almost ready to give up
Thanks for the responses. Unfortunately, I really need this to work. I've got numerous accounts with multiple banks and several different credit card companies. I have the same problem with all of them. I have been doing this for 2 months now and the reconciliation process takes 5-10 times longer now than it did with Quicken. As much as I hate Quicken, if I can't get aqbanking working properly, I will have to go back to Quicken because I'm running out of time and patience with this setup. As far as I can tell, I'm not even pulling a certificate and the process isn't even going out to the net. Unfortunately the lack of support and out of date documentation makes this nearly impossible to use as a viable solution. I would much rather pay for something that works and has support, than use something that is free, but doesn't work. AQbanking is the software that is supposed to connect the bank to the software. If it can't, they only have half a solution and I'll have to try to find something else. Thanks, Mike On 1/23/2019 6:10 PM, Michael Mantei wrote: I really want to get away from Quicken. I've been trying gnucash for a little over 2 months now, but I can't get the bank transfers to work. I'm no closer now than I was 2 months ago. This is where I am at... 0. I'm using gnuCash versioin 3.4 and the bundled aqbanking on a Windows 10 PC 1. I generated a version 4 UUID at https://www.uuidgenerator.net/version4 2. I entered my bank account username in both the User Name and User ID fields 3. I entered the generated UUID in the user setting ClientUId field in the aqbanking wizard, without any dashes 4. On the Bank Settings tab, I searched for JPMorgan Chase Bank and let it fill the fields. 5. On the Application Settings tab I have the Application ID set to QWIN, the Application Version set to 2700 and the Header Version set to 103. 6. I save this info then exit out. After re-entering gnucash and restarting the aqbanking wizard, I go to the Bank Settings tab and click on Retrieve Account List. 7. I am prompted for my password end enter it. I then see the following: 21:51:30 Saving communication log to /tmp/ofx.log 21:51:30 Sending request... 21:51:30 Using GnuTLS default ciphers. 21:51:30 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD 21:51:30 Signer not found 21:51:30 Certificate is not trusted 21:51:30 Waiting for response... 21:51:30 Operation finished, you can now close this window. The OFX.LOG file contains the following: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20190122215110.000 20190122215110.000MYUSERID MYPASSWORD ENGChase Bank1601QWIN27001df59207be3d4a6aa416de9233639b2d20190122215110.000119691231 8. This is all I ever see, regardless of how often I do it. There are no messages available on the Chase website. Quicken works fine, but AQBanking gives me nothing. 9. I've tried everything I can think of for 2 months, but my knowledge of the products is very limited and I've figured nothing out other than it won't work. 10. I've tried posting to what appear to be aqbanking message lists, but have no luck getting my posts to take. Any help would be appreciated. Thanks, Mike ___ 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 fails to start on Windows 10
Solved the problem. GC seems to crash on startup when using Israel Local on windows. Changed the Locale from Hebrew (Israel) to English (United Kindom) and now all works OK. Seems to be related to a supposedly solved bug: https://bugs.gnucash.org/show_bug.cgi?id=796728 On Wed, Jan 23, 2019 at 4:38 PM Nadir Moss wrote: > Hello, > > I am a new GC user. > I cannot start GNUCash on windows 10, I see the start image and tips of > the day box for a second then nothing happens. > Tried with 3.4 and 2.6... > Tried comparability mode to no avail. > > Any suggestions will be appreciated! > > Thanks in advance, > Nadir > ___ 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] Reconciliation is not adding up correctly - what to do??
On Thu, 24 Jan 2019 at 16:52, D wrote: > > As noted in the Tutorial, the opening balance in a reconciliation is > immaterial. What matters is the ending balance. If they match, then you can > finish reconciliation. It is not immaterial in the sense that if it does not match that from the bank statement then something is wrong, or at least unusual, such as is the very first reconcile in which case the first transaction should be the initial balance which should match the opening balance on the statement. Colin > > The Tutorial explains some of the circumstances that might cause an opening > balance not to match. > > David T. > > On January 24, 2019, at 9:30 PM, Colin Law wrote: > > On Thu, 24 Jan 2019 at 13:59, Finbar Mahon wrote: > > > > I understand the logic of what you describe, but, I started using > > GNUCash with effect from 1.1.2018. > > > > The opening balance on the bank statement for one of the asset a/c was > > €3,986.22 and the ending balance on 16.2.2018 was €5,117.09 > > > > Gnucash shows the ending balance as €5,117.02 but the reconcile shows > > another figure of €1,674.47 as the opening balance (bottom right hand > > side) while the left hand panel (funds in) shows the correct opening > > balance > > When you start a reconcile it should show the opening balance the same > as on your bank statement and you should manually enter the ending > balance to the value it shows on the bank statement. Are you doing > that? > > I don't understand where you are seeing the figures you describe. Can > you post a screenshot showing it? > > Colin > > > > > The outcome of the reconcile is the same as the opening balance above > > but now it is -ve!! > > > > Confused :-( > > > > On 19/01/2019 22:26, David Cousens wrote: > > > The reconciliation procedure works fine for me on several bank accounts, > > > my > > > credit card and paypal accounts in V2.6.19 and earlier, V3.1, V3.2, V3.3 > > > and > > > V3.4 provided previous reconciliations of the account were correct and no > > > transactions have been accidentally unreconciled. > > > > > > In the example you quote you have a starting difference of 72.15. The net > > > movement of 72.15 and an end balance of 144.30 which is as it should be: > > > > > > closing balance = starting balance +funds in -funds out > > > 144.30 = 72.15 + 331.12 - 258.97 = 114.30 > > > > > > You can only get a reconciliation difference of 0 if the starting balance > > > (generated by previous reconciliation) is actually the balance in your > > > account at the specified start date. AFAIK the starting balance shown in > > > the > > > dialog is the reconciled balance at the end of the last reconciled period. > > > Any changes made to reconciled transactions before that date after they > > > have > > > been reconciled will change the actual starting balance in the account > > > from > > > the reconciled value. I think it was possible to make changes to > > > reconciled > > > transactions in one register by editing one of the other splits to the > > > transaction in some earlier versions of GnuCash and this automatically > > > unreconciled the transaction. I think recent changes only unreconcile a > > > transaction if specific information about the transaction and/or the > > > amount > > > of the split affecting the reconciled account are changed but not sure > > > whether this is the case for the current release or not. > > > > > > First thing to check is for any unreconciled transactions before the start > > > date of the reconciliation you are having problems with. If you find any > > > go > > > back and redo the reconciliations forward from the period which contained > > > the unreconciled transaction to make sure everything is correct. The > > > starting difference of 72.15 being the same as the difference in funds in > > > and funds out suggests some sort of regular transaction for 72.15 might be > > > unrecorded or unreconciled. > > > Good luck > > > > > > 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. > >
Re: [GNC] Reconciliation is not adding up correctly - what to do??
As noted in the Tutorial, the opening balance in a reconciliation is immaterial. What matters is the ending balance. If they match, then you can finish reconciliation. The Tutorial explains some of the circumstances that might cause an opening balance not to match. David T. On January 24, 2019, at 9:30 PM, Colin Law wrote: On Thu, 24 Jan 2019 at 13:59, Finbar Mahon wrote: > > I understand the logic of what you describe, but, I started using > GNUCash with effect from 1.1.2018. > > The opening balance on the bank statement for one of the asset a/c was > €3,986.22 and the ending balance on 16.2.2018 was €5,117.09 > > Gnucash shows the ending balance as €5,117.02 but the reconcile shows > another figure of €1,674.47 as the opening balance (bottom right hand > side) while the left hand panel (funds in) shows the correct opening > balance When you start a reconcile it should show the opening balance the same as on your bank statement and you should manually enter the ending balance to the value it shows on the bank statement. Are you doing that? I don't understand where you are seeing the figures you describe. Can you post a screenshot showing it? Colin > > The outcome of the reconcile is the same as the opening balance above > but now it is -ve!! > > Confused :-( > > On 19/01/2019 22:26, David Cousens wrote: > > The reconciliation procedure works fine for me on several bank accounts, my > > credit card and paypal accounts in V2.6.19 and earlier, V3.1, V3.2, V3.3 and > > V3.4 provided previous reconciliations of the account were correct and no > > transactions have been accidentally unreconciled. > > > > In the example you quote you have a starting difference of 72.15. The net > > movement of 72.15 and an end balance of 144.30 which is as it should be: > > > > closing balance = starting balance +funds in -funds out > > 144.30 = 72.15 + 331.12 - 258.97 = 114.30 > > > > You can only get a reconciliation difference of 0 if the starting balance > > (generated by previous reconciliation) is actually the balance in your > > account at the specified start date. AFAIK the starting balance shown in the > > dialog is the reconciled balance at the end of the last reconciled period. > > Any changes made to reconciled transactions before that date after they have > > been reconciled will change the actual starting balance in the account from > > the reconciled value. I think it was possible to make changes to reconciled > > transactions in one register by editing one of the other splits to the > > transaction in some earlier versions of GnuCash and this automatically > > unreconciled the transaction. I think recent changes only unreconcile a > > transaction if specific information about the transaction and/or the amount > > of the split affecting the reconciled account are changed but not sure > > whether this is the case for the current release or not. > > > > First thing to check is for any unreconciled transactions before the start > > date of the reconciliation you are having problems with. If you find any go > > back and redo the reconciliations forward from the period which contained > > the unreconciled transaction to make sure everything is correct. The > > starting difference of 72.15 being the same as the difference in funds in > > and funds out suggests some sort of regular transaction for 72.15 might be > > unrecorded or unreconciled. > > Good luck > > > > 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. ___ 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] Reconciliation is not adding up correctly - what to do??
On Thu, 24 Jan 2019 at 13:59, Finbar Mahon wrote: > > I understand the logic of what you describe, but, I started using > GNUCash with effect from 1.1.2018. > > The opening balance on the bank statement for one of the asset a/c was > €3,986.22 and the ending balance on 16.2.2018 was €5,117.09 > > Gnucash shows the ending balance as €5,117.02 but the reconcile shows > another figure of €1,674.47 as the opening balance (bottom right hand > side) while the left hand panel (funds in) shows the correct opening > balance When you start a reconcile it should show the opening balance the same as on your bank statement and you should manually enter the ending balance to the value it shows on the bank statement. Are you doing that? I don't understand where you are seeing the figures you describe. Can you post a screenshot showing it? Colin > > The outcome of the reconcile is the same as the opening balance above > but now it is -ve!! > > Confused :-( > > On 19/01/2019 22:26, David Cousens wrote: > > The reconciliation procedure works fine for me on several bank accounts, my > > credit card and paypal accounts in V2.6.19 and earlier, V3.1, V3.2, V3.3 and > > V3.4 provided previous reconciliations of the account were correct and no > > transactions have been accidentally unreconciled. > > > > In the example you quote you have a starting difference of 72.15. The net > > movement of 72.15 and an end balance of 144.30 which is as it should be: > > > > closing balance = starting balance +funds in -funds out > > 144.30 = 72.15 + 331.12 - 258.97 = 114.30 > > > > You can only get a reconciliation difference of 0 if the starting balance > > (generated by previous reconciliation) is actually the balance in your > > account at the specified start date. AFAIK the starting balance shown in the > > dialog is the reconciled balance at the end of the last reconciled period. > > Any changes made to reconciled transactions before that date after they have > > been reconciled will change the actual starting balance in the account from > > the reconciled value. I think it was possible to make changes to reconciled > > transactions in one register by editing one of the other splits to the > > transaction in some earlier versions of GnuCash and this automatically > > unreconciled the transaction. I think recent changes only unreconcile a > > transaction if specific information about the transaction and/or the amount > > of the split affecting the reconciled account are changed but not sure > > whether this is the case for the current release or not. > > > > First thing to check is for any unreconciled transactions before the start > > date of the reconciliation you are having problems with. If you find any go > > back and redo the reconciliations forward from the period which contained > > the unreconciled transaction to make sure everything is correct. The > > starting difference of 72.15 being the same as the difference in funds in > > and funds out suggests some sort of regular transaction for 72.15 might be > > unrecorded or unreconciled. > > Good luck > > > > 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. ___ 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] I can't get the budget feature to work.
Lorrie, I've seen this problem in GnuCash 2.6; I don't know whether it has changed in 3.x: Make sure that you have only one account of type Expense and one account of type Asset at the top level of your accounts. If you have more than one, then the budget function doesn't work as you've described. You can check this by going to the Accounts tab, right-clicking (in Windows, might be different on a Mac?) on each top-level account, and selecting "Edit Account". This will open an options window for the account. The account type is at the lower left. Hope that helps. On 2019-01-24 1:43 a.m., gnucash-user-requ...@gnucash.org wrote: Message: 5 Date: Wed, 23 Jan 2019 19:09:49 -0800 From: Lorrie Laskey To:gnucash-user@gnucash.org Subject: [GNC] I can't get the budget feature to work. Message-ID: Content-Type: text/plain; charset="UTF-8" Hi all, I created a 12 -period 2019 budget and entered child-level expenses and income. The expenses have a total in the spreadsheet but are not showing up at the bottom of the spreadsheet. Expenses still display as "0". What am I missing? ___ 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] Reconciliation is not adding up correctly - what to do??
I understand the logic of what you describe, but, I started using GNUCash with effect from 1.1.2018. The opening balance on the bank statement for one of the asset a/c was €3,986.22 and the ending balance on 16.2.2018 was €5,117.09 Gnucash shows the ending balance as €5,117.02 but the reconcile shows another figure of €1,674.47 as the opening balance (bottom right hand side) while the left hand panel (funds in) shows the correct opening balance The outcome of the reconcile is the same as the opening balance above but now it is -ve!! Confused :-( On 19/01/2019 22:26, David Cousens wrote: The reconciliation procedure works fine for me on several bank accounts, my credit card and paypal accounts in V2.6.19 and earlier, V3.1, V3.2, V3.3 and V3.4 provided previous reconciliations of the account were correct and no transactions have been accidentally unreconciled. In the example you quote you have a starting difference of 72.15. The net movement of 72.15 and an end balance of 144.30 which is as it should be: closing balance = starting balance +funds in -funds out 144.30 = 72.15 + 331.12 - 258.97 = 114.30 You can only get a reconciliation difference of 0 if the starting balance (generated by previous reconciliation) is actually the balance in your account at the specified start date. AFAIK the starting balance shown in the dialog is the reconciled balance at the end of the last reconciled period. Any changes made to reconciled transactions before that date after they have been reconciled will change the actual starting balance in the account from the reconciled value. I think it was possible to make changes to reconciled transactions in one register by editing one of the other splits to the transaction in some earlier versions of GnuCash and this automatically unreconciled the transaction. I think recent changes only unreconcile a transaction if specific information about the transaction and/or the amount of the split affecting the reconciled account are changed but not sure whether this is the case for the current release or not. First thing to check is for any unreconciled transactions before the start date of the reconciliation you are having problems with. If you find any go back and redo the reconciliations forward from the period which contained the unreconciled transaction to make sure everything is correct. The starting difference of 72.15 being the same as the difference in funds in and funds out suggests some sort of regular transaction for 72.15 might be unrecorded or unreconciled. Good luck 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.
Re: [GNC] Check for negative amount in scheduled transaction formula
Hi Ron, Ron Stone writes: > Thanks for this Derek. I'm on a Mac and only see one copy of fin.scm > in the application bundle. Seems any edits to this would be lost at > the next upgrade. Should I be defining another one somewhere under > ~/Library/Application Support/GnuCash or elsewhere? Yes, this file will be over-written at the next upgrade. Creating a new file would require you to get gnucash to load it.. IMHO, you should make the edits to fin.scm now, and then make a patch and submit to to Bugzilla for inclusion in future versions. > Ron -derek > - Original Message - > From: "Derek Atkins" > To: "gnucash dgr9z" > Cc: "Gnucash Users" > Sent: Monday, January 21, 2019 3:16:52 PM > Subject: Re: [GNC] Check for negative amount in scheduled transaction formula > > gnucash.dg...@ncf.ca writes: > >> Hi, >> >> Is it possible to convert negative numbers to 0 in a formula? something like: >> a-b < 0 ? 0 : a-b >> >> If this needs to be defined as a function someplace, what would it >> look like, where would it go, and how would it be called from the >> template? > > Look at fin.scm and copy the functions in there. > >> Many thanks, >> Ron > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek -- Derek Atkins 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.
Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report
Place the following in the Embedded CSS section of the Notes tab under the
invoice’s options:
* {font: “name of font"; }
This will change the font on the entire invoice. It should then render the INR
currency symbol. If the font name has spaces, you must enclose it in “”.
If you only want to affect the header and actual invoice table (and not the
notes section) use this:
table {font: “name of font"; }
Note, that you can also specify a different font size, style (like bold and/or
italics) and even color like so:
* {font: “Arial" 1.5em bold italics; color: blue; }
(an ‘em’ is a relative unit for font sizes. 1 ‘em’ is 100% of whatever the base
style was. Or you can use px or pt such as 16px or 16pt if you prefer.)
If you want to target only cells with currency values this *might* work:
table.entries td > nobr:first-child { font: “name of font"; }
Also note, I don’t see a way to edit this permanently so you’d have to insert
it for every invoice. (perhaps saving the report config and then specifying a
different invoice number might do the trick) Otherwise, you’d have to edit
taxinvoice.css but that will get overwritten when you update Gnucash to the
next version.
Hope that helps.
Regards,
Adrien
> On Jan 19, 2019, at 7:25 AM, Deva - wrote:
>
> Adrien,
>
> I am happy to raise a bug, but after reading all responses on this issue,
> perhaps it’s not a bug even.
>
> Geert and you pointed out that the report can be changed using CSS styling,
> so someone with that know-how may be able to get what they want. I am ok with
> the workaround for now.
>
> Besides, if I recall correctly, Christopher also mentioned that since Tax
> Invoice report is eguile-based, it’s unlikely to be maintained. I am not even
> sure what eguile is, but I seem to like the presentation, flexibility and
> layout of both the balance sheet and tax invoice reports. So it’s unfortunate
> that the eguile reports may be going away soon.
>
> Cheers.
>
> On 19-Jan-2019, at 6:38 PM,
> mailto:gnucash-user-requ...@gnucash.org>>
> mailto:gnucash-user-requ...@gnucash.org>>
> wrote:
>
> Date: Sat, 19 Jan 2019 06:25:38 -0600
> From: Adrien Monteleone
> mailto:adrien.montele...@lusfiber.net>>
> To: "gnucash-user@gnucash.org"
> mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Currency symbol (INR) not showing on Tax Invoice
> report
> Message-ID:
> <14328ebb-6e35-4081-b534-92a928a85...@lusfiber.net>
> Content-Type: text/plain; charset=utf-8
>
> Glad to hear you can get the info you need, sorry to hear the suggestion
> doesn?t work.
>
> I?d say this is bug worthy.
>
> Regards,
> Adrien
>
> On Jan 19, 2019, at 5:53 AM, Deva -
> mailto:pobox.d...@outlook.in>> wrote:
>
> Adrien,
>
> Thanks for the pointer on how to figure the font associated with a symbol.
> Yes, I now see the names of all fonts for the various rupee symbols
> (including Helvetica).
>
> However, when I edit the default stylesheet to use any of the the available
> rupee symbol fonts (I tried a couple of them - there were too many to try all
> of them), the tax invoice report still doesn?t show the symbol.
>
> So for now, I am afraid I have to stick with the text version of the symbol.
>
> Cheers.
>
> On 18-Jan-2019, at 10:30 PM,
> gnucash-user-requ...@gnucash.org
> wrote:
>
> Date: Fri, 18 Jan 2019 08:25:54 -0600
> From: Adrien Monteleone
> mailto:adrien.montele...@lusfiber.net>>
> To:
> "gnucash-user@gnucash.org"
>
> mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Currency symbol (INR) not showing on Tax Invoice
> report
> Message-ID:
> mailto:b2a1446e-3d35-4cde-acde-6bd5ce65f...@lusfiber.net>>
> Content-Type: text/plain; charset=utf-8
>
> In Character Viewer, look up the rupee symbol via a search. Click the glyph
> for it in the middle pane. You?ll then see a list of font variations on the
> bottom right. As you click each one, at the top right you?ll get an enlarged
> version and just below that, you?ll see the name of the font it belongs to.
>
> Regards,
> Adrien
>
> On Jan 18, 2019, at 6:06 AM, Deva -
> mailto:pobox.d...@outlook.in>>
> wrote:
>
> Geert is probably right.
>
> As I mentioned in my previous post, I did try to change the default
> stylesheet fonts to a few commonly used fonts in documents
> (Arial/Helvetica/MS Sans Serif), but rupee symbol didn?t come up for any of
> them.
>
> I can see from the character viewer on my Mac that there are a number of
> variations of the rupee symbol available, but I can?t figure out which font
> is used on each of those
Re: [GNC] New Budget Help
Okay, I’ve watched the video. I think he’s confusing what double-entry is here and its purpose. That isn’t really necessary when working with budgets. It is necessary (and forced) when entering actual transactions. Also, note that transfers do not decrease by his expenses. He’s put the *excess* income after expenses into the checking account asset. If he added another expense here, the transfer line would not change, but the total would now be negative and he’d have to reduce the amount budgeted to checking. I would start either with planned income or planned expenses, then you’ll see where the other needs to be and adjust accordingly. If you have some transaction history, GnuCash has an estimating feature when you create a budget to populate values based on averages of that previous data. Use assets for savings or investments and liabilities for loan payments. Yes, the end goal is have a zero total (zero-sum budgeting) but you don’t have to if you don’t want to. So to sum up: The total of all budget entries under Income appear in the summary as Income The total of all budget entries under Expenses appear in the summary as Expenses The NET of all budget entries under Assets AND Liabilities AND Equity appear in the summary as Transfers The sum of all of these are the “Total” in the summary. (which depending on your budget method/goals, may or may not need to be zero when you are done) Regards, Adrien > On Jan 22, 2019, at 9:31 PM, Lorrie Laskey wrote: > > https://www.youtube.com/watch?v=_PMz7SMt68E ___ 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] TRANASACTION REPORT
Hello, Transaction report with table for exporting enabled functions perfect and results are shown in a tabular format. But with transaction filter inputs, the tabuler formation vanishes. Is it BUG ?? Please advise NOR - nor -- 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] Another sort field like 'Class' in Quicken?
Unfortunately, those are two different fields with the same name. They aren’t tied to each other at all. The Action field of a split does get filled with “payment” when you assign a payment to a bill/invoice, however. You can edit this if you want after the transaction is created. I haven’t seen that it messes with the payment link in any way. As far as I know, there is no built-in way to report on line items in bills or invoices. But if you choose *not* to consolidate splits when posting, you might get close. The Action field from the bill/invoice still won’t populate the Action field of the register transaction though. I’ve yet to see a purpose or use case for the Action column on a bill. I use it to denote ‘Hours’, ‘Project’ or ‘Materials’ on invoices to customers. Though that’s just for my customer’s information. I can’t see anyway to run any kind of report to see how many hours I billed last month for example. I have to track that outside of GnuCash. Regards, Adrien > On Jan 24, 2019, at 5:52 AM, nor via gnucash-user > wrote: > > hello all,Refer ACTION Field in Bill.It is not reflected in corresponding > Expenses Register. Hence Expenses transaction cannot be sorted w.r.t. ACTION > Field in bills. Is there any other way ?Nor ___ 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] Saving entries and storing it on desktop
The current text is pretty straight forward. I suppose an admonition not to run the gnucash.app from the .dmg folder might not hurt. I really suspect that has been the issue at least on the last two recent threads on this. And perhaps a screenshot or two for those who don’t already understand Mac’s installation method? (could be simply new to MacOS) Regards, Adrien > On Jan 24, 2019, at 5:46 AM, David T. via gnucash-user > wrote: > > David, > I'm not convinced that the text on that page should be changed--and if it > were, I'm not sure it would have helped. > David T. > > > > On Thu, Jan 24, 2019 at 16:17, David Cousens > wrote: Adrien, > > This seems to come up fairly often. Any chance you could have a go at > improving the instructions on the Wiki > https://wiki.gnucash.org/wiki/MacOS_Installation to make it a bit clearer > and perhaps include any changes relevant to more recent MacOS versions under > appropriate version headings. I was thinking of trawling through the recent > archives to have a go at it but it is possible better if a Mac user updates > it. > > 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. ___ 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] Another sort field like 'Class' in Quicken?
hello all,Refer ACTION Field in Bill.It is not reflected in corresponding Expenses Register. Hence Expenses transaction cannot be sorted w.r.t. ACTION Field in bills. Is there any other way ?Nor - nor -- 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] Saving entries and storing it on desktop
David, I'm not convinced that the text on that page should be changed--and if it were, I'm not sure it would have helped. David T. On Thu, Jan 24, 2019 at 16:17, David Cousens wrote: Adrien, This seems to come up fairly often. Any chance you could have a go at improving the instructions on the Wiki https://wiki.gnucash.org/wiki/MacOS_Installation to make it a bit clearer and perhaps include any changes relevant to more recent MacOS versions under appropriate version headings. I was thinking of trawling through the recent archives to have a go at it but it is possible better if a Mac user updates it. 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.
Re: [GNC] Saving entries and storing it on desktop
Certainly! I also inquired in late December about creating a custom branded dmg window with the /Applications alias to drag onto like many other Mac apps have. John gave me some links to get started, but unfortunately, that same day I got a large project dumped on my desk. (well, not unfortunate ‘cause it means more money, but unfortunate for this particular side-project with GnuCash) I hope to have it ready for the 3.5 release. That should reduce (I can’t expect ‘eliminate’) these topics. But yes, I’ll see if the wiki can be spruced up in the meantime. Regards, Adrien > On Jan 24, 2019, at 4:45 AM, David Cousens wrote: > > Adrien, > > This seems to come up fairly often. Any chance you could have a go at > improving the instructions on the Wiki > https://wiki.gnucash.org/wiki/MacOS_Installation to make it a bit clearer > and perhaps include any changes relevant to more recent MacOS versions under > appropriate version headings. I was thinking of trawling through the recent > archives to have a go at it but it is possible better if a Mac user updates > it. > > 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.
Re: [GNC] Saving entries and storing it on desktop
Adrien, This seems to come up fairly often. Any chance you could have a go at improving the instructions on the Wiki https://wiki.gnucash.org/wiki/MacOS_Installation to make it a bit clearer and perhaps include any changes relevant to more recent MacOS versions under appropriate version headings. I was thinking of trawling through the recent archives to have a go at it but it is possible better if a Mac user updates it. 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] Cash Account Question
Am 24.01.2019 um 01:32 schrieb Michael or Penny Novack: > On 1/23/2019 10:25 AM, Adrien Monteleone wrote: >> Yep, I’m one of those. I track every expense, entered from *where* I >> spent the funds. So if the money was the green folding kind (or coin) >> out of my wallet or pocket, I have an account for that. If I move >> money to/from my wallet, I track that too. And I routinely reconcile >> the amount. (no report of course to use, just a verification of the >> amount on hand when I do it.) But I do all of that because I’m part of >> the ‘un-banked’. >> >> Regards, >> Adrien > > Even people who ARE "banked" might have to do this. For example, were > they in an environment where lots of their transactions had to be in > cash. Not just a matter if THEY are "banked" but if the other people > they are interacting with are. > I personally also track every transaction with every payment method and also transactions of money between them. It might also have something to do, that I also do this at my job, where the requirements of tracking cash transactions are very strict due to rules set by the financial authorities. If you don’t track your cash right, they can estimate your sales. I can’t understand why you wouldn’t track your cash payments. Either track everything or nothing at all. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
