date:20190116

It's fine to make recommendations. During the transaction upgrade I
remembered some wishlist items and was able to implement them.

The limitations for reversing subtotals stem from the fact that subtotal &
grouping is not limited to account types, but can also be organised by date
and other keys. And to try establishing a reversing strategy for these keys
is an exercise in futility and it was safer to just disable subtotal
reversals. Hence the "recommended" amount display is now dual column
debit&credit which is works well.

On Thu., 17 Jan. 2019, 10:49 David T.  Chris,
>
> Thanks for the offer, but readers of these lists over the years can vouch
> for my utter inability to contribute meaningfully to any code. That's why
> I've tried to contribute to the documentation (although to be truthful,
> even that is a stretch).
>
> I apologize for suggesting tasks for you to do, and I will attempt in the
> future not to make that mistake again. It's too bad the transaction report
> will continue to have these problems for the foreseeable future. I'll try
> and figure out some way to document its quirks on the wiki, so that people
> may be made aware of them and work around them.
>
> David
>
>
> On Thu, Jan 17, 2019 at 8:04, Christopher Lam
>  wrote:
> I don't know, sorry. You're very welcome to dive into code and try.
> https://github.com/Gnucash/gnucash/pull/229 will be a good place to start
> research.
>
> On Thu., 17 Jan. 2019, 10:24 David T. 
> Chris,
>
> While I understand and respect the goal of backward compatibility, I'll
> point out that your changes to this report have already broken backward
> compatibility, as evidenced by my original example.  Settings which worked
> previously yield meaningless results now, and I have had to go through
> every one of my reports that are based on the transaction report and fix
> what got broken.
>
> For my use case (not all that exotic, IMHO), the setting appears to be
> broken; when transactions are shown, are you saying the transactions are
> reversed, but the totals are not? Because that would drive me crazy...
>
> Is there truly no way to store and calculate values internally to the
> report but display results the way the user requests to see them?
>
> David
>
>
> On Thu, Jan 17, 2019 at 7:13, Christopher Lam
>  wrote:
> Sadly, the gnucash project has a long history of never removing features.
>
> The amount sign reversal is still functional for the transactional
> amounts. Only the subtotals are unaffected.
>
> On Thu., 17 Jan. 2019, 09:08 D 
> Then why include the option? It no longer does anything, except imply to
> the user that they have control over something they Nik longer can control.
>
> David
>
>
> On January 17, 2019, at 6:27 AM, Christopher Lam <
> christopher@gmail.com> wrote:
>
>
> This is by design.
>
> Previously a transaction report including *all* accounts for a specified
> period would erroneously add the sign-reversed amounts as displayed, which
> would lead to the grand total being a nonsensical number. Eg income $100 
> expense
> $50. Amounts:
> Bank $100 -$50
> Income $100
> Expense $50
> Grand total $200 (nonsense)
>
> From 3.0 onwards the subtotal strategy always adds the non-reversed
> amounts, which means the grand total for all accounts for any specified
> period would always be $0 thanks to the accounting equation.
>
> Bank $100 -$50
> Income -$100 (subtotal negative)
> Expense $50
> Grand total $0
>
> On Thu., 17 Jan. 2019, 00:34 David T. 
> Chris,
>
> I do note one issue with the new transaction report: it doesn’t seem to
> utilize the Sign Reverses option—at least, not that I can see.
>
> Cheers,
> David
>
> > On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > Chris,
> >
> > Thank you for the lead.
> >
> > It turns out that I can get almost exactly the same result using the
> hide transactional data option, when I combine it with "Amount - Single”.
> The only difference is that the Account name is not presented before the
> total line. I consider that to be an improvement, actually.
> >
> > Bug avoided.
> >
> > David
> >
> >> On Jan 16, 2019, at 6:01 PM, Christopher Lam 
> wrote:
> >>
> >> There's "Sorting / Show subtotals only (hide transactional data)"
> >>
> >> You may be right that 'Display / Amount' = none is not completely
> handled as before.
> >>
> >> Please file a bug, and screenshot a sample report, anonymised; please
> enable 'General / Add options summary' to display options used.
> >>
> >> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
> >>
> >> Thank you for finding these edge .
>
>
___
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 repli

Re: [GNC] Transaction Report Preference missing?

It seems the Balance sheet honors the setting, but using the ’None’ option in 
Preferences produces a disconcerting result.

With the option set to Credit Accounts, all amounts (normally balanced) are 
positive.

With the option set to None, the Liability and Equity line items are negative, 
but with positive totals!

So I would guess it is possible to honor the setting, but using ’None’ might 
produce an odd looking report. From your description, it seems the Transaction 
Report is effectively choosing ’None’ for the user.

Regards,
Adrien

> On Jan 16, 2019, at 8:24 PM, David T. via gnucash-user 
>  wrote:
> 
> Chris,
> While I understand and respect the goal of backward compatibility, I'll point 
> out that your changes to this report have already broken backward 
> compatibility, as evidenced by my original example.  Settings which worked 
> previously yield meaningless results now, and I have had to go through every 
> one of my reports that are based on the transaction report and fix what got 
> broken. 
> For my use case (not all that exotic, IMHO), the setting appears to be 
> broken; when transactions are shown, are you saying the transactions are 
> reversed, but the totals are not? Because that would drive me crazy...
> Is there truly no way to store and calculate values internally to the report 
> but display results the way the user requests to see them?
> 
> David
> 
> 
>  On Thu, Jan 17, 2019 at 7:13, Christopher Lam 
> wrote:   Sadly, the gnucash project has a long history of never removing 
> features.
> The amount sign reversal is still functional for the transactional amounts. 
> Only the subtotals are unaffected.
> On Thu., 17 Jan. 2019, 09:08 D  
> 
> Then why include the option? It no longer does anything, except imply to the 
> user that they have control over something they Nik longer can control.
> 
> David
> 
> 
> On January 17, 2019, at 6:27 AM, Christopher Lam  
> wrote:
> 
> 
> This is by design.
> Previously a transaction report including *all* accounts for a specified 
> period would erroneously add the sign-reversed amounts as displayed, which 
> would lead to the grand total being a nonsensical number. Eg income $100 
> expense $50. Amounts:Bank $100 -$50Income $100Expense $50Grand total $200 
> (nonsense)
> From 3.0 onwards the subtotal strategy always adds the non-reversed amounts, 
> which means the grand total for all accounts for any specified period would 
> always be $0 thanks to the accounting equation.
> Bank $100 -$50Income -$100 (subtotal negative)Expense $50Grand total $0
> On Thu., 17 Jan. 2019, 00:34 David T.  
> Chris,
> 
> I do note one issue with the new transaction report: it doesn’t seem to 
> utilize the Sign Reverses option—at least, not that I can see.
> 
> Cheers,
> David 
> 
>> On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user 
>>  wrote:
>> 
>> Chris,
>> 
>> Thank you for the lead. 
>> 
>> It turns out that I can get almost exactly the same result using the hide 
>> transactional data option, when I combine it with "Amount - Single”. The 
>> only difference is that the Account name is not presented before the total 
>> line. I consider that to be an improvement, actually.
>> 
>> Bug avoided.
>> 
>> David
>> 
>>> On Jan 16, 2019, at 6:01 PM, Christopher Lam  
>>> wrote:
>>> 
>>> There's "Sorting / Show subtotals only (hide transactional data)"
>>> 
>>> You may be right that 'Display / Amount' = none is not completely handled 
>>> as before.
>>> 
>>> Please file a bug, and screenshot a sample report, anonymised; please 
>>> enable 'General / Add options summary' to display options used.
>>> 
>>> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
>>> 
>>> Thank you for finding these edge .
> 
> 
> 
> 
> ___
> 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] "Save Report Configuration" Crashes GnuCash and Tr

Got it.

Sorry for the misunderstanding.

Regards,
Adrien

> On Jan 16, 2019, at 8:33 PM, David T.  wrote:
> 
> Ah. I understand where we are disconnecting. 
> 
> 1. Gnucash truncated my reports file upon saving any new reports. 
> 2. I exited Gnucash and upon reopening found that two thirds of my reports 
> were no longer there. 
> 3. I exited Gnucash again, and verified in the OS that the file was much 
> smaller, opened the file in a text editor and verified that hundreds of lines 
> were gone. 
> 4. I deleted this truncated file and copied back in the original reports file 
> from a backup. 
> 
> So, long story short, the errant report was (probably) causing Gnucash to 
> truncate the file if I asked it to save a report. 
> 
> On Thu, Jan 17, 2019 at 7:14, Adrien Monteleone
>  wrote:
> I understand what you mean by they were ‘gone’ because Gnucash couldn’t read 
> the remainder of the file. But does opening saved-reports-2.8 in a text 
> editor (something like Atom, Gedit, vi, emacs, etc.) show the subsequent 
> reports still defined there? (warning, I think this file is in Scheme, but 
> you can do a find on your report names)
> 
> I can’t fathom how removing an errant report magically un-truncated a file. 
> If the data was gone, it was gone. But if Gnucash simply couldn’t read it 
> past a certain point, though the report definitions were still there, that 
> would make sense. (what is perplexing is why the OS would report a different 
> file size)
> 
> Or did you simply restore a 2.8 backup or a saved-reports-2.4 version and 
> remove the offending report to ‘recover' the lost reports? I wasn’t quite 
> clear in my understanding there.
> 
> Regards,
> Adrien
> 
> > On Jan 16, 2019, at 7:03 PM, D  wrote:
> > 
> > Adrien,
> > 
> > It's not merely a case of the OS reporting the wrong file size; the file 
> > was in fact truncated. Reports were gone. 
> > 
> > It's more likely that something in the particular report was causing 
> > Gnucash to discard the data before saving. I say this because Gnucash 
> > consistently put the original file into saved-reports-2.4-backup. All 182kb 
> > of it.
> > 
> > David
> > 
> > On January 17, 2019, at 2:07 AM, Adrien Monteleone 
> >  wrote:
> > 
> > David,
> > 
> > I’ve seen that very strange issue happen on two other occasions, once with 
> > a mailbox file and once with an XML file. I can’t fathom why the OS reports 
> > less data than is really there as it shouldn’t care if the file is 
> > malformed or not to the filetype’s specifications when it reports total 
> > size on disk. I’ve seen this on both Linux and Mac. (I never tested those 
> > files on Windows to see if that OS would do the same) This might be some 
> > sort of bug related to how files are split up on disk, or if such file 
> > errors result in an errant change to the file table entry, (FAT, journal, 
> > etc.) I dunno.
> > 
> > Unfortunately, I no longer remember the exact issues, but certainly, 
> > correcting the text in the file in my cases, (I could load the entire file 
> > in a text editor) restored access to my data and got the OS to report the 
> > real file size.
> > 
> > Regards,
> > Adrien
> > 
> >> On Jan 16, 2019, at 10:54 AM, David T. via gnucash-user 
> >>  wrote:
> >> 
> >> Geert and others,
> >> 
> >> I would like to follow up on the issues I raised earlier. 
> >> 
> >> First off, the crashing upon saving the report has gone away. I have no 
> >> idea why.
> >> 
> >> As for the saved-reports truncation issue, after a break from all of this, 
> >> I returned to do some tinkering around. Repeated efforts to modify a few 
> >> of my reports for the latest version of the Transaction Report yielded the 
> >> same results: my saved-reports file was truncated at 32kb.
> >> 
> >> I began the process of trying to document all 56 saved reports in my file 
> >> (including trying to remove outdated ones) so that I could wipe the slate 
> >> clean and start over again. A third of the way through, I ran into a 
> >> report that was embedded in a multicolumn report which was not yielding 
> >> expected results. This report would only return a cryptic error message. 
> >> My suspicions aroused, I removed the report from the multicolumn report, 
> >> saved the multicolumn report, closed, and then reopened GnuCash. 
> >> 
> >> All my reports were still there, and further edits on saved reports did 
> >> not truncate the saved-reports file.
> >> 
> >> I’m not certain, but I wonder whether there is an issue in the multicolumn 
> >> report code—to wit, I see that the entries for each section appear to be 
> >> based on other reports, and I wonder what would happen if I were to remove 
> >> the stored report upon which that section is built?
> >> 
> >> Anyhow, it appears that the truncation issue had to do with this erroneous 
> >> saved report. I have no idea what could have fixed the crasher.
> >> 
> >> Cheers,
> >> David
> >> 
> >>> On Dec 29, 2018, at 9:31 PM, Geert Janssens  
> >>> wrote:
> >>

Re: [GNC] Transaction Report Preference missing?

Chris, 
Thanks for the offer, but readers of these lists over the years can vouch for 
my utter inability to contribute meaningfully to any code. That's why I've 
tried to contribute to the documentation (although to be truthful, even that is 
a stretch).
I apologize for suggesting tasks for you to do, and I will attempt in the 
future not to make that mistake again. It's too bad the transaction report will 
continue to have these problems for the foreseeable future. I'll try and figure 
out some way to document its quirks on the wiki, so that people may be made 
aware of them and work around them. 
David

  On Thu, Jan 17, 2019 at 8:04, Christopher Lam 
wrote:   I don't know, sorry. You're very welcome to dive into code and 
try.https://github.com/Gnucash/gnucash/pull/229 will be a good place to start 
research.
On Thu., 17 Jan. 2019, 10:24 David T.  
wrote:   Sadly, the gnucash project has a long history of never removing 
features.
The amount sign reversal is still functional for the transactional amounts. 
Only the subtotals are unaffected.
On Thu., 17 Jan. 2019, 09:08 D  
wrote:

This is by design.
Previously a transaction report including *all* accounts for a specified period 
would erroneously add the sign-reversed amounts as displayed, which would lead 
to the grand total being a nonsensical number. Eg income $100 expense $50. 
Amounts:Bank $100 -$50Income $100Expense $50Grand total $200 (nonsense)
From 3.0 onwards the subtotal strategy always adds the non-reversed amounts, 
which means the grand total for all accounts for any specified period would 
always be $0 thanks to the accounting equation.
Bank $100 -$50Income -$100 (subtotal negative)Expense $50Grand total $0
On Thu., 17 Jan. 2019, 00:34 David T.  On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user 
>  wrote:
> 
> Chris,
> 
> Thank you for the lead. 
> 
> It turns out that I can get almost exactly the same result using the hide 
> transactional data option, when I combine it with "Amount - Single”. The only 
> difference is that the Account name is not presented before the total line. I 
> consider that to be an improvement, actually.
> 
> Bug avoided.
> 
> David
> 
>> On Jan 16, 2019, at 6:01 PM, Christopher Lam  
>> wrote:
>> 
>> There's "Sorting / Show subtotals only (hide transactional data)"
>> 
>> You may be right that 'Display / Amount' = none is not completely handled as 
>> before.
>> 
>> Please file a bug, and screenshot a sample report, anonymised; please enable 
>> 'General / Add options summary' to display options used.
>> 
>> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
>> 
>> Thank you for finding these edge .

___
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] Tax Issues

This sounds like bug #796687, which had been discussed on gnucash-devel 
recently. 
David

  On Thu, Jan 17, 2019 at 7:45, John Ralls wrote:   

> On Jan 16, 2019, at 2:40 PM, Mike stagl  wrote:
> 
> For what its worth, I updated to Gnucash 3.4 on both a Debian 9 machine and a 
> Windows 7 machine, and both fail to apply the Tax Reporting Options.
> 
> Either this is a bug, or I am doing something wrong on both machines!
> 
> Thanks all!

The Tax Report Options dialog doesn’t seem to be storing the Name or Type 
fields, so only the Edit button underneath is enabled. The accounts are getting 
marked tax related and when one clicks Edit and reselects e.g. Individual 
Income Tax then the rest of the dialog is enabled and the settings entered 
before are still set.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Preference missing?

I don't know, sorry. You're very welcome to dive into code and try.
https://github.com/Gnucash/gnucash/pull/229 will be a good place to start
research.

On Thu., 17 Jan. 2019, 10:24 David T.  Chris,
>
> While I understand and respect the goal of backward compatibility, I'll
> point out that your changes to this report have already broken backward
> compatibility, as evidenced by my original example.  Settings which worked
> previously yield meaningless results now, and I have had to go through
> every one of my reports that are based on the transaction report and fix
> what got broken.
>
> For my use case (not all that exotic, IMHO), the setting appears to be
> broken; when transactions are shown, are you saying the transactions are
> reversed, but the totals are not? Because that would drive me crazy...
>
> Is there truly no way to store and calculate values internally to the
> report but display results the way the user requests to see them?
>
> David
>
>
> On Thu, Jan 17, 2019 at 7:13, Christopher Lam
>  wrote:
> Sadly, the gnucash project has a long history of never removing features.
>
> The amount sign reversal is still functional for the transactional
> amounts. Only the subtotals are unaffected.
>
> On Thu., 17 Jan. 2019, 09:08 D 
> Then why include the option? It no longer does anything, except imply to
> the user that they have control over something they Nik longer can control.
>
> David
>
>
> On January 17, 2019, at 6:27 AM, Christopher Lam <
> christopher@gmail.com> wrote:
>
>
> This is by design.
>
> Previously a transaction report including *all* accounts for a specified
> period would erroneously add the sign-reversed amounts as displayed, which
> would lead to the grand total being a nonsensical number. Eg income $100 
> expense
> $50. Amounts:
> Bank $100 -$50
> Income $100
> Expense $50
> Grand total $200 (nonsense)
>
> From 3.0 onwards the subtotal strategy always adds the non-reversed
> amounts, which means the grand total for all accounts for any specified
> period would always be $0 thanks to the accounting equation.
>
> Bank $100 -$50
> Income -$100 (subtotal negative)
> Expense $50
> Grand total $0
>
> On Thu., 17 Jan. 2019, 00:34 David T. 
> Chris,
>
> I do note one issue with the new transaction report: it doesn’t seem to
> utilize the Sign Reverses option—at least, not that I can see.
>
> Cheers,
> David
>
> > On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > Chris,
> >
> > Thank you for the lead.
> >
> > It turns out that I can get almost exactly the same result using the
> hide transactional data option, when I combine it with "Amount - Single”.
> The only difference is that the Account name is not presented before the
> total line. I consider that to be an improvement, actually.
> >
> > Bug avoided.
> >
> > David
> >
> >> On Jan 16, 2019, at 6:01 PM, Christopher Lam 
> wrote:
> >>
> >> There's "Sorting / Show subtotals only (hide transactional data)"
> >>
> >> You may be right that 'Display / Amount' = none is not completely
> handled as before.
> >>
> >> Please file a bug, and screenshot a sample report, anonymised; please
> enable 'General / Add options summary' to display options used.
> >>
> >> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
> >>
> >> Thank you for finding these edge .
>
>
___
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] "Save Report Configuration" Crashes GnuCash and Tr

Ah. I understand where we are disconnecting. 
1. Gnucash truncated my reports file upon saving any new reports. 2. I exited 
Gnucash and upon reopening found that two thirds of my reports were no longer 
there. 3. I exited Gnucash again, and verified in the OS that the file was much 
smaller, opened the file in a text editor and verified that hundreds of lines 
were gone. 4. I deleted this truncated file and copied back in the original 
reports file from a backup. 

So, long story short, the errant report was (probably) causing Gnucash to 
truncate the file if I asked it to save a report. 
 
 
  On Thu, Jan 17, 2019 at 7:14, Adrien 
Monteleone wrote:   I understand what you mean 
by they were ‘gone’ because Gnucash couldn’t read the remainder of the file. 
But does opening saved-reports-2.8 in a text editor (something like Atom, 
Gedit, vi, emacs, etc.) show the subsequent reports still defined there? 
(warning, I think this file is in Scheme, but you can do a find on your report 
names)

I can’t fathom how removing an errant report magically un-truncated a file. If 
the data was gone, it was gone. But if Gnucash simply couldn’t read it past a 
certain point, though the report definitions were still there, that would make 
sense. (what is perplexing is why the OS would report a different file size)

Or did you simply restore a 2.8 backup or a saved-reports-2.4 version and 
remove the offending report to ‘recover' the lost reports? I wasn’t quite clear 
in my understanding there.

Regards,
Adrien

> On Jan 16, 2019, at 7:03 PM, D  wrote:
> 
> Adrien,
> 
> It's not merely a case of the OS reporting the wrong file size; the file was 
> in fact truncated. Reports were gone. 
> 
> It's more likely that something in the particular report was causing Gnucash 
> to discard the data before saving. I say this because Gnucash consistently 
> put the original file into saved-reports-2.4-backup. All 182kb of it.
> 
> David
> 
> On January 17, 2019, at 2:07 AM, Adrien Monteleone 
>  wrote:
> 
> David,
> 
> I’ve seen that very strange issue happen on two other occasions, once with a 
> mailbox file and once with an XML file. I can’t fathom why the OS reports 
> less data than is really there as it shouldn’t care if the file is malformed 
> or not to the filetype’s specifications when it reports total size on disk. 
> I’ve seen this on both Linux and Mac. (I never tested those files on Windows 
> to see if that OS would do the same) This might be some sort of bug related 
> to how files are split up on disk, or if such file errors result in an errant 
> change to the file table entry, (FAT, journal, etc.) I dunno.
> 
> Unfortunately, I no longer remember the exact issues, but certainly, 
> correcting the text in the file in my cases, (I could load the entire file in 
> a text editor) restored access to my data and got the OS to report the real 
> file size.
> 
> Regards,
> Adrien
> 
>> On Jan 16, 2019, at 10:54 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Geert and others,
>> 
>> I would like to follow up on the issues I raised earlier. 
>> 
>> First off, the crashing upon saving the report has gone away. I have no idea 
>> why.
>> 
>> As for the saved-reports truncation issue, after a break from all of this, I 
>> returned to do some tinkering around. Repeated efforts to modify a few of my 
>> reports for the latest version of the Transaction Report yielded the same 
>> results: my saved-reports file was truncated at 32kb.
>> 
>> I began the process of trying to document all 56 saved reports in my file 
>> (including trying to remove outdated ones) so that I could wipe the slate 
>> clean and start over again. A third of the way through, I ran into a report 
>> that was embedded in a multicolumn report which was not yielding expected 
>> results. This report would only return a cryptic error message. My 
>> suspicions aroused, I removed the report from the multicolumn report, saved 
>> the multicolumn report, closed, and then reopened GnuCash. 
>> 
>> All my reports were still there, and further edits on saved reports did not 
>> truncate the saved-reports file.
>> 
>> I’m not certain, but I wonder whether there is an issue in the multicolumn 
>> report code—to wit, I see that the entries for each section appear to be 
>> based on other reports, and I wonder what would happen if I were to remove 
>> the stored report upon which that section is built?
>> 
>> Anyhow, it appears that the truncation issue had to do with this erroneous 
>> saved report. I have no idea what could have fixed the crasher.
>> 
>> Cheers,
>> David
>> 
>>> On Dec 29, 2018, at 9:31 PM, Geert Janssens  
>>> wrote:
>>> 
>>> Hi David,
>>> 
>>> A very disturbing situation to be in.
>>> 
>>> I think the first step is to narrow down the possible issues.
>>> 
>>> Op zaterdag 29 december 2018 16:18:43 CET schreef David T. via gnucash-user:
 Hello,
 
 As the subject line notes, I am again encountering a crasher in GnuCash 3.3
 on MacOS Mo

Re: [GNC] Transaction Report Preference missing?

Chris,
While I understand and respect the goal of backward compatibility, I'll point 
out that your changes to this report have already broken backward 
compatibility, as evidenced by my original example.  Settings which worked 
previously yield meaningless results now, and I have had to go through every 
one of my reports that are based on the transaction report and fix what got 
broken. 
For my use case (not all that exotic, IMHO), the setting appears to be broken; 
when transactions are shown, are you saying the transactions are reversed, but 
the totals are not? Because that would drive me crazy...
Is there truly no way to store and calculate values internally to the report 
but display results the way the user requests to see them?

David

  On Thu, Jan 17, 2019 at 7:13, Christopher Lam 
wrote:   Sadly, the gnucash project has a long history of never removing 
features.
The amount sign reversal is still functional for the transactional amounts. 
Only the subtotals are unaffected.
On Thu., 17 Jan. 2019, 09:08 D  
wrote:

This is by design.
Previously a transaction report including *all* accounts for a specified period 
would erroneously add the sign-reversed amounts as displayed, which would lead 
to the grand total being a nonsensical number. Eg income $100 expense $50. 
Amounts:Bank $100 -$50Income $100Expense $50Grand total $200 (nonsense)
From 3.0 onwards the subtotal strategy always adds the non-reversed amounts, 
which means the grand total for all accounts for any specified period would 
always be $0 thanks to the accounting equation.
Bank $100 -$50Income -$100 (subtotal negative)Expense $50Grand total $0
On Thu., 17 Jan. 2019, 00:34 David T.  On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user 
>  wrote:
> 
> Chris,
> 
> Thank you for the lead. 
> 
> It turns out that I can get almost exactly the same result using the hide 
> transactional data option, when I combine it with "Amount - Single”. The only 
> difference is that the Account name is not presented before the total line. I 
> consider that to be an improvement, actually.
> 
> Bug avoided.
> 
> David
> 
>> On Jan 16, 2019, at 6:01 PM, Christopher Lam  
>> wrote:
>> 
>> There's "Sorting / Show subtotals only (hide transactional data)"
>> 
>> You may be right that 'Display / Amount' = none is not completely handled as 
>> before.
>> 
>> Please file a bug, and screenshot a sample report, anonymised; please enable 
>> 'General / Add options summary' to display options used.
>> 
>> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
>> 
>> Thank you for finding these edge .

___
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] Tax Issues

2019-01-16 Thread John Ralls

> On Jan 16, 2019, at 2:40 PM, Mike stagl  wrote:
> 
> For what its worth, I updated to Gnucash 3.4 on both a Debian 9 machine and a 
> Windows 7 machine, and both fail to apply the Tax Reporting Options.
> 
> Either this is a bug, or I am doing something wrong on both machines!
> 
> Thanks all!

The Tax Report Options dialog doesn’t seem to be storing the Name or Type 
fields, so only the Edit button underneath is enabled. The accounts are getting 
marked tax related and when one clicks Edit and reselects e.g. Individual 
Income Tax then the rest of the dialog is enabled and the settings entered 
before are still set.

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] Transaction Report Preference missing?

Sadly, the gnucash project has a long history of never removing features.

The amount sign reversal is still functional for the transactional amounts.
Only the subtotals are unaffected.

On Thu., 17 Jan. 2019, 09:08 D  Then why include the option? It no longer does anything, except imply to
> the user that they have control over something they Nik longer can control.
>
> David
>
>
> On January 17, 2019, at 6:27 AM, Christopher Lam <
> christopher@gmail.com> wrote:
>
>
> This is by design.
>
> Previously a transaction report including *all* accounts for a specified
> period would erroneously add the sign-reversed amounts as displayed, which
> would lead to the grand total being a nonsensical number. Eg income $100 
> expense
> $50. Amounts:
> Bank $100 -$50
> Income $100
> Expense $50
> Grand total $200 (nonsense)
>
> From 3.0 onwards the subtotal strategy always adds the non-reversed
> amounts, which means the grand total for all accounts for any specified
> period would always be $0 thanks to the accounting equation.
>
> Bank $100 -$50
> Income -$100 (subtotal negative)
> Expense $50
> Grand total $0
>
> On Thu., 17 Jan. 2019, 00:34 David T. 
>> Chris,
>>
>> I do note one issue with the new transaction report: it doesn’t seem to
>> utilize the Sign Reverses option—at least, not that I can see.
>>
>> Cheers,
>> David
>>
>> > On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> >
>> > Chris,
>> >
>> > Thank you for the lead.
>> >
>> > It turns out that I can get almost exactly the same result using the
>> hide transactional data option, when I combine it with "Amount - Single”.
>> The only difference is that the Account name is not presented before the
>> total line. I consider that to be an improvement, actually.
>> >
>> > Bug avoided.
>> >
>> > David
>> >
>> >> On Jan 16, 2019, at 6:01 PM, Christopher Lam <
>> christopher@gmail.com> wrote:
>> >>
>> >> There's "Sorting / Show subtotals only (hide transactional data)"
>> >>
>> >> You may be right that 'Display / Amount' = none is not completely
>> handled as before.
>> >>
>> >> Please file a bug, and screenshot a sample report, anonymised; please
>> enable 'General / Add options summary' to display options used.
>> >>
>> >> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
>> >>
>> >> Thank you for finding these edge cases.
>> >>
>> >> C
>> >>
>> >>
>> >> On 16/1/19 8:09 pm, David T. via gnucash-user wrote:
>> >>> Hello,
>> >>>
>> >>> Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I
>> use around this time of year (I call it “W-2 - David”) that shows me the
>> total amounts assigned to a subset of my expense accounts (i.e., my tax
>> expense accounts).
>> >>>
>> >>> The purpose of this report is to allow me to compare my GnuCash
>> numbers to the numbers issued to me by my employer. In GnuCash 2.6.19, this
>> report looks something like this:
>> >>>
>> >>> ———
>> >>>
>> >>> From 01/01/2018 To 12/31/2018
>> >>>
>> >>> Fed
>> >>> Total For Fed   $X.XX
>> >>> Medicare
>> >>> Total For Medicare  $X.XX
>> >>> Soc Sec
>> >>> Total For Soc Sec   $X.XX
>> >>> State
>> >>> Total For State $X.XX
>> >>> Grand Total $X.XX
>> >>>
>> >>> ———
>> >>>
>> >>> As I said, this report is intended to match my employer’s reporting,
>> so I can compare the two.
>> >>>
>> >>>
>> >>> However, when I run the *SAME REPORT* in GnuCash 3.4, I get
>> unsatisfactory changes to the results. My LITERAL results are:
>> >>>
>> >>> ———
>> >>>
>> >>> From 01/01/2018 to 12/31/2018
>> >>>
>> >>> Account
>> >>> Fed
>> >>> Fed
>> >>> Fed
>> >>> Fed
>> >>> Fed
>> >>> Fed
>> >>> Fed
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Medicare
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> Soc Sec
>> >>> State
>> >>> State
>> >>> State
>> >>> State
>> >>> State
>> >>> State
>> >>> State
>> >>> State
>> >>> ———
>> >>>
>> >>> Now, there are two significant problems here: first, every
>> transaction for the year gets a line, and second, THERE ARE NO AMOUNTS. I
>> have tinkered with every setting I can find on the report options, but I
>> cannot find the setting that will display ONLY THE TOTALS. It would appear
>> that in a recent update to this report, the “NONE” option on line amounts
>> has been removed.
>> >>>
>> >>> Unless someone can point me to the obvious place where I missed this
>> setting, I believe this is a regression i

Re: [GNC] "Save Report Configuration" Crashes GnuCash and Truncates saved-reports-2.8

I understand what you mean by they were ‘gone’ because Gnucash couldn’t read 
the remainder of the file. But does opening saved-reports-2.8 in a text editor 
(something like Atom, Gedit, vi, emacs, etc.) show the subsequent reports still 
defined there? (warning, I think this file is in Scheme, but you can do a find 
on your report names)

I can’t fathom how removing an errant report magically un-truncated a file. If 
the data was gone, it was gone. But if Gnucash simply couldn’t read it past a 
certain point, though the report definitions were still there, that would make 
sense. (what is perplexing is why the OS would report a different file size)

Or did you simply restore a 2.8 backup or a saved-reports-2.4 version and 
remove the offending report to ‘recover' the lost reports? I wasn’t quite clear 
in my understanding there.

Regards,
Adrien

> On Jan 16, 2019, at 7:03 PM, D  wrote:
> 
> Adrien,
> 
> It's not merely a case of the OS reporting the wrong file size; the file was 
> in fact truncated. Reports were gone. 
> 
> It's more likely that something in the particular report was causing Gnucash 
> to discard the data before saving. I say this because Gnucash consistently 
> put the original file into saved-reports-2.4-backup. All 182kb of it.
> 
> David
> 
> On January 17, 2019, at 2:07 AM, Adrien Monteleone 
>  wrote:
> 
> David,
> 
> I’ve seen that very strange issue happen on two other occasions, once with a 
> mailbox file and once with an XML file. I can’t fathom why the OS reports 
> less data than is really there as it shouldn’t care if the file is malformed 
> or not to the filetype’s specifications when it reports total size on disk. 
> I’ve seen this on both Linux and Mac. (I never tested those files on Windows 
> to see if that OS would do the same) This might be some sort of bug related 
> to how files are split up on disk, or if such file errors result in an errant 
> change to the file table entry, (FAT, journal, etc.) I dunno.
> 
> Unfortunately, I no longer remember the exact issues, but certainly, 
> correcting the text in the file in my cases, (I could load the entire file in 
> a text editor) restored access to my data and got the OS to report the real 
> file size.
> 
> Regards,
> Adrien
> 
>> On Jan 16, 2019, at 10:54 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Geert and others,
>> 
>> I would like to follow up on the issues I raised earlier. 
>> 
>> First off, the crashing upon saving the report has gone away. I have no idea 
>> why.
>> 
>> As for the saved-reports truncation issue, after a break from all of this, I 
>> returned to do some tinkering around. Repeated efforts to modify a few of my 
>> reports for the latest version of the Transaction Report yielded the same 
>> results: my saved-reports file was truncated at 32kb.
>> 
>> I began the process of trying to document all 56 saved reports in my file 
>> (including trying to remove outdated ones) so that I could wipe the slate 
>> clean and start over again. A third of the way through, I ran into a report 
>> that was embedded in a multicolumn report which was not yielding expected 
>> results. This report would only return a cryptic error message. My 
>> suspicions aroused, I removed the report from the multicolumn report, saved 
>> the multicolumn report, closed, and then reopened GnuCash. 
>> 
>> All my reports were still there, and further edits on saved reports did not 
>> truncate the saved-reports file.
>> 
>> I’m not certain, but I wonder whether there is an issue in the multicolumn 
>> report code—to wit, I see that the entries for each section appear to be 
>> based on other reports, and I wonder what would happen if I were to remove 
>> the stored report upon which that section is built?
>> 
>> Anyhow, it appears that the truncation issue had to do with this erroneous 
>> saved report. I have no idea what could have fixed the crasher.
>> 
>> Cheers,
>> David
>> 
>>> On Dec 29, 2018, at 9:31 PM, Geert Janssens  
>>> wrote:
>>> 
>>> Hi David,
>>> 
>>> A very disturbing situation to be in.
>>> 
>>> I think the first step is to narrow down the possible issues.
>>> 
>>> Op zaterdag 29 december 2018 16:18:43 CET schreef David T. via gnucash-user:
 Hello,

 As the subject line notes, I am again encountering a crasher in GnuCash 3.3
 on MacOS Mojave when I try to save a report configuration for a report
 whose settings have changed. Upon restart, I find that the saved reports
 have been trashed, and the saved-reports-2.8 file is truncated at a
 fraction of its prior size.

 Further specifics: I am opening a saved report which is intended to 
 document
 a small subset of expense accounts. I have added a new subaccount to this
 set of expenses, and I wish to add this new subaccount to the existing
 saved report. I open the report (Reports->Saved Report Configurations) and
 then select the options for the report. I click to the Accounts tab, add
 the ne

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread D via gnucash-user

Then why include the option? It no longer does anything, except imply to the 
user that they have control over something they Nik longer can control.

David

On January 17, 2019, at 6:27 AM, Christopher Lam  
wrote:

This is by design.


Previously a transaction report including *all* accounts for a specified period 
would erroneously add the sign-reversed amounts as displayed, which would lead 
to the grand total being a nonsensical number. Eg income $100 expense $50. 
Amounts:

Bank $100 -$50

Income $100

Expense $50

Grand total $200 (nonsense)


From 3.0 onwards the subtotal strategy always adds the non-reversed amounts, 
which means the grand total for all accounts for any specified period would 
always be $0 thanks to the accounting equation.


Bank $100 -$50

Income -$100 (subtotal negative)

Expense $50

Grand total $0


On Thu., 17 Jan. 2019, 00:34 David T.  On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user 
>  wrote:
> 
> Chris,
> 
> Thank you for the lead. 
> 
> It turns out that I can get almost exactly the same result using the hide 
> transactional data option, when I combine it with "Amount - Single”. The only 
> difference is that the Account name is not presented before the total line. I 
> consider that to be an improvement, actually.
> 
> Bug avoided.
> 
> David
> 
>> On Jan 16, 2019, at 6:01 PM, Christopher Lam  
>> wrote:
>> 
>> There's "Sorting / Show subtotals only (hide transactional data)"
>> 
>> You may be right that 'Display / Amount' = none is not completely handled as 
>> before.
>> 
>> Please file a bug, and screenshot a sample report, anonymised; please enable 
>> 'General / Add options summary' to display options used.
>> 
>> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
>> 
>> Thank you for finding these edge cases.
>> 
>> C
>> 
>> 
>> On 16/1/19 8:09 pm, David T. via gnucash-user wrote:
>>> Hello,
>>> 
>>> Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use 
>>> around this time of year (I call it “W-2 - David”) that shows me the total 
>>> amounts assigned to a subset of my expense accounts (i.e., my tax expense 
>>> accounts).
>>> 
>>> The purpose of this report is to allow me to compare my GnuCash numbers to 
>>> the numbers issued to me by my employer. In GnuCash 2.6.19, this report 
>>> looks something like this:
>>> 
>>> ———
>>> 
>>> From 01/01/2018 To 12/31/2018
>>> 
>>> Fed
>>> Total For Fed       $X.XX
>>> Medicare
>>> Total For Medicare  $X.XX
>>> Soc Sec
>>> Total For Soc Sec   $X.XX
>>> State
>>> Total For State     $X.XX
>>> Grand Total $X.XX
>>> 
>>> ———
>>> 
>>> As I said, this report is intended to match my employer’s reporting, so I 
>>> can compare the two.
>>> 
>>> 
>>> However, when I run the *SAME REPORT* in GnuCash 3.4, I get unsatisfactory 
>>> changes to the results. My LITERAL results are:
>>> 
>>> ———
>>> 
>>> From 01/01/2018 to 12/31/2018
>>> 
>>> Account
>>> Fed
>>> Fed
>>> Fed
>>> Fed
>>> Fed
>>> Fed
>>> Fed
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> State
>>> State
>>> State
>>> State
>>> State
>>> State
>>> State
>>> State
>>> ———
>>> 
>>> Now, there are two significant problems here: first, every transaction for 
>>> the year gets a line, and second, THERE ARE NO AMOUNTS. I have tinkered 
>>> with every setting I can find on the report options, but I cannot find the 
>>> setting that will display ONLY THE TOTALS. It would appear that in a recent 
>>> update to this report, the “NONE” option on line amounts has been removed.
>>> 
>>> Unless someone can point me to the obvious place where I missed this 
>>> setting, I believe this is a regression in the report. I ought to be able 
>>> to display a report that includes totals only.
>>> 
>>> David T.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using

Re: [GNC] "Save Report Configuration" Crashes GnuCash and Truncates saved-reports-2.8

2019-01-16 Thread D via gnucash-user

Adrien,

It's not merely a case of the OS reporting the wrong file size; the file was in 
fact truncated. Reports were gone. 

It's more likely that something in the particular report was causing Gnucash to 
discard the data before saving. I say this because Gnucash consistently put the 
original file into saved-reports-2.4-backup. All 182kb of it.

David

On January 17, 2019, at 2:07 AM, Adrien Monteleone 
 wrote:

David,

I’ve seen that very strange issue happen on two other occasions, once with a 
mailbox file and once with an XML file. I can’t fathom why the OS reports less 
data than is really there as it shouldn’t care if the file is malformed or not 
to the filetype’s specifications when it reports total size on disk. I’ve seen 
this on both Linux and Mac. (I never tested those files on Windows to see if 
that OS would do the same) This might be some sort of bug related to how files 
are split up on disk, or if such file errors result in an errant change to the 
file table entry, (FAT, journal, etc.) I dunno.

Unfortunately, I no longer remember the exact issues, but certainly, correcting 
the text in the file in my cases, (I could load the entire file in a text 
editor) restored access to my data and got the OS to report the real file size.

Regards,
Adrien

> On Jan 16, 2019, at 10:54 AM, David T. via gnucash-user 
>  wrote:
> 
> Geert and others,
> 
> I would like to follow up on the issues I raised earlier. 
> 
> First off, the crashing upon saving the report has gone away. I have no idea 
> why.
> 
> As for the saved-reports truncation issue, after a break from all of this, I 
> returned to do some tinkering around. Repeated efforts to modify a few of my 
> reports for the latest version of the Transaction Report yielded the same 
> results: my saved-reports file was truncated at 32kb.
> 
> I began the process of trying to document all 56 saved reports in my file 
> (including trying to remove outdated ones) so that I could wipe the slate 
> clean and start over again. A third of the way through, I ran into a report 
> that was embedded in a multicolumn report which was not yielding expected 
> results. This report would only return a cryptic error message. My suspicions 
> aroused, I removed the report from the multicolumn report, saved the 
> multicolumn report, closed, and then reopened GnuCash. 
> 
> All my reports were still there, and further edits on saved reports did not 
> truncate the saved-reports file.
> 
> I’m not certain, but I wonder whether there is an issue in the multicolumn 
> report code—to wit, I see that the entries for each section appear to be 
> based on other reports, and I wonder what would happen if I were to remove 
> the stored report upon which that section is built?
> 
> Anyhow, it appears that the truncation issue had to do with this erroneous 
> saved report. I have no idea what could have fixed the crasher.
> 
> Cheers,
> David
> 
>> On Dec 29, 2018, at 9:31 PM, Geert Janssens  
>> wrote:
>> 
>> Hi David,
>> 
>> A very disturbing situation to be in.
>> 
>> I think the first step is to narrow down the possible issues.
>> 
>> Op zaterdag 29 december 2018 16:18:43 CET schreef David T. via gnucash-user:
>>> Hello,
>>> 
>>> As the subject line notes, I am again encountering a crasher in GnuCash 3.3
>>> on MacOS Mojave when I try to save a report configuration for a report
>>> whose settings have changed. Upon restart, I find that the saved reports
>>> have been trashed, and the saved-reports-2.8 file is truncated at a
>>> fraction of its prior size.
>>> 
>>> Further specifics: I am opening a saved report which is intended to document
>>> a small subset of expense accounts. I have added a new subaccount to this
>>> set of expenses, and I wish to add this new subaccount to the existing
>>> saved report. I open the report (Reports->Saved Report Configurations) and
>>> then select the options for the report. I click to the Accounts tab, add
>>> the new account (CMD-Click) and click save. The new version of the report
>>> now displays. I click on the “Save Report Configuration” button, and
>>> GnuCash disappears. There is no further information displayed (i.e., I do
>>> not receive an Apple message about the program ending unexpectedly, etc.).
>>> Neither does it appear that there is a crash report; the only crash I can
>>> find regarding GnuCash dates from 12/18, and today is not 12/18.
>>> 
>> When this happens is there anything in the trace file ?
>> 
>>> More disturbingly, when I reopen GnuCash, I find that my Saved Report
>>> Configurations file has been truncated, resulting in a loss of most of my
>>> reports. (Because I’ve had similar troubles with GnuCash trashing my
>>> reports file, I have copies of saved-reports-2.8 stored in safe spots.) The
>>> saved-reports-2.8 file goes from 182 kb to 34 kb. Upon restart, I have only
>>> 7 saved reports.
>>> 
>> So some of them are still in there ? Is the last one that's still there 
>> completely stored in the saved repo

Re: [GNC] Transaction Report Preference missing?

This is by design.

Previously a transaction report including *all* accounts for a specified
period would erroneously add the sign-reversed amounts as displayed, which
would lead to the grand total being a nonsensical number. Eg income
$100 expense
$50. Amounts:
Bank $100 -$50
Income $100
Expense $50
Grand total $200 (nonsense)

From 3.0 onwards the subtotal strategy always adds the non-reversed
amounts, which means the grand total for all accounts for any specified
period would always be $0 thanks to the accounting equation.

Bank $100 -$50
Income -$100 (subtotal negative)
Expense $50
Grand total $0

On Thu., 17 Jan. 2019, 00:34 David T.  Chris,
>
> I do note one issue with the new transaction report: it doesn’t seem to
> utilize the Sign Reverses option—at least, not that I can see.
>
> Cheers,
> David
>
> > On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > Chris,
> >
> > Thank you for the lead.
> >
> > It turns out that I can get almost exactly the same result using the
> hide transactional data option, when I combine it with "Amount - Single”.
> The only difference is that the Account name is not presented before the
> total line. I consider that to be an improvement, actually.
> >
> > Bug avoided.
> >
> > David
> >
> >> On Jan 16, 2019, at 6:01 PM, Christopher Lam 
> wrote:
> >>
> >> There's "Sorting / Show subtotals only (hide transactional data)"
> >>
> >> You may be right that 'Display / Amount' = none is not completely
> handled as before.
> >>
> >> Please file a bug, and screenshot a sample report, anonymised; please
> enable 'General / Add options summary' to display options used.
> >>
> >> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
> >>
> >> Thank you for finding these edge cases.
> >>
> >> C
> >>
> >>
> >> On 16/1/19 8:09 pm, David T. via gnucash-user wrote:
> >>> Hello,
> >>>
> >>> Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use
> around this time of year (I call it “W-2 - David”) that shows me the total
> amounts assigned to a subset of my expense accounts (i.e., my tax expense
> accounts).
> >>>
> >>> The purpose of this report is to allow me to compare my GnuCash
> numbers to the numbers issued to me by my employer. In GnuCash 2.6.19, this
> report looks something like this:
> >>>
> >>> ———
> >>>
> >>> From 01/01/2018 To 12/31/2018
> >>>
> >>> Fed
> >>> Total For Fed   $X.XX
> >>> Medicare
> >>> Total For Medicare  $X.XX
> >>> Soc Sec
> >>> Total For Soc Sec   $X.XX
> >>> State
> >>> Total For State $X.XX
> >>> Grand Total $X.XX
> >>>
> >>> ———
> >>>
> >>> As I said, this report is intended to match my employer’s reporting,
> so I can compare the two.
> >>>
> >>>
> >>> However, when I run the *SAME REPORT* in GnuCash 3.4, I get
> unsatisfactory changes to the results. My LITERAL results are:
> >>>
> >>> ———
> >>>
> >>> From 01/01/2018 to 12/31/2018
> >>>
> >>> Account
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> State
> >>> State
> >>> State
> >>> State
> >>> State
> >>> State
> >>> State
> >>> State
> >>> ———
> >>>
> >>> Now, there are two significant problems here: first, every transaction
> for the year gets a line, and second, THERE ARE NO AMOUNTS. I have tinkered
> with every setting I can find on the report options, but I cannot find the
> setting that will display ONLY THE TOTALS. It would appear that in a recent
> update to this report, the “NONE” option on line amounts has been removed.
> >>>
> >>> Unless someone can point me to the obvious place where I missed this
> setting, I believe this is a regression in the report. I ought to be able
> to display a report that includes totals only.
> >>>
> >>> David T.
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@

Re: [GNC] OFX import sometimes loses transaction memos

2019-01-16 Thread David Carlson

On Wed, Jan 16, 2019, 4:36 PM David Cousens  David
>
> Have you tried examining the file with ofxdump? If you are on Linux, it can
> be installed with "sudo apt install ofx".  Not sure about how to get it for
> WIndows or MacOS. It will dump to stdout whatever ofxdump can determine
> about an ofx response file including error messages. It tests conformance
> with the libofx librarryofxdump. You may need to use it with the debug
> switch and possibly the parsing messages if using it without the optional
> switches doesn't give enough info. I.e.
>
> $ofxdump --msg_debug --msg_parser
>
> 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.
>

David,

I have already examined one of the OFX files that has a mix of some trans
actions with memos that were and we're not imported with a binary editor
and found no difference except possibly number of characters in the string.

Right now I am away from home and cannot try OFX DUMP to see if it knows
whether there is a maximum string length, but if there is and it is less
than 200 characters I would be surprised.

If that is true, I would hope that it would truncate strings rather than
drop them.

David C arlson

>
___
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] Australian Stock Quotes

2019-01-16 Thread Chris Good

Message: 8
Date: Wed, 16 Jan 2019 17:56:37 +0530
From: "David T." 
To: normanj 
Cc: Gnucash Users 
Subject: Re: [GNC] Australian Stock Quotes
Message-ID: 
Content-Type: text/plain;   charset=utf-8

Norman,

Glad to help. In the future, be sure to ?Reply All? so that your message
gets back to the list. That way, everyone gets to hear the denouement.

David

> On Jan 16, 2019, at 5:35 PM, Norman Jessup  wrote:
> 
> Thanks David,
> 
> This is very helpful
> 
> regards,
> 
> Norman Jessup
> 
> 
> 
> 
> 
> On 16/1/19 10:24 pm, David T. wrote:
>> Norman,
>> 
>> While the ?FinanceQuote Update? module might not have been changed since
2010, *Finance Quote* (which actually performs quote retrieval for GnuCash)
most certainly has been updated numerous times since then. If you *run*
?FinanceQuote Update,? it will ? update Finance Quote for you. The most
recent version of Finance::Quote is 1.47, and is dated November 12, 2017.
>> 
>> Please note that there has been a huge amount of discussion about F::Q
over the last year and a half (which is probably what underlies your note
about it stopping working); to keep the story short, Yahoo! decided to stop
providing price quotes. From the resulting hullaballoo, F::Q changed primary
quote providers, either to AlphaVantage or to Yahoo! Json. You will need to
reset your commodities each to use a currently-valid source. Much of this is
explained on the wiki at
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

Note Paragraph 3.
>> 
>> Cheers,
>> David T.
>> 
>>> On Jan 16, 2019, at 9:10 AM, normanj mailto:njes...@tpg.com.au>> wrote:
>>> 
>>> A year or two (or three) ago the share price tool stopped working for
>>> Australian shares.   I saw some forum posts suggesting that source of
>>> Australian quotes was no longer available and needed to be changed.
>>> 
>>> While there have been several new version of GnuCash released since 
>>> then, the FinanceQuote Update module does not appear to have changed
since 2010.
>>> 
>>> I've tried without success to modify the tool myself.  Is anyone 
>>> able to point me towards detailed instructions about what I need to do
to fix this?
>>> or possibly where I can download a more up-to-date version of the tool?
>>> 
>>> Thank you
>>> 
>>> 
>>> 
>>> 
>>> 
>>> --
>>> Sent from: 
>>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html 
>>> 
>>> ___

Hi Norman,

There is already a fix (from me) for using the ASX as a source in
Finance::Quote which has been merged [1] and is waiting (since Jul 16, 2018)
for a new release (1.48?).

The (main?) F::Q maintainer Erik Colson has said he no longer has time and
asked for volunteers to take over. A couple of months ago (I think) some-one
did volunteer but I haven't seen any progress yet.

As it has been a while, it is possible my latest fix no longer works either.
I haven't tested the ASX lately as there are 2 alternatives:
1) Yahoo_JSON
2) AlphaVantage (you may need to put a sleep into the perl code if you have
many stocks).

If you are still interested in modifying F::Q:
a) You will need to program in perl (you must know that already but I'm
saying this for others) and know a little about html.
b) The git repository is here: [2] There is some useful info in the
README.md at the bottom of this page.

[1] https://github.com/finance-quote/finance-quote/pull/82
[2] https://github.com/finance-quote/finance-quote

Regard, Chris Good

___
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] Tax Issues

2019-01-16 Thread Mike stagl

For what its worth, I updated to Gnucash 3.4 on both a Debian 9 machine and a 
Windows 7 machine, and both fail to apply the Tax Reporting Options.

Either this is a bug, or I am doing something wrong on both machines!

Thanks 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] OFX import sometimes loses transaction memos

2019-01-16 Thread David Cousens

David 

Have you tried examining the file with ofxdump? If you are on Linux, it can
be installed with "sudo apt install ofx".  Not sure about how to get it for
WIndows or MacOS. It will dump to stdout whatever ofxdump can determine
about an ofx response file including error messages. It tests conformance
with the libofx librarryofxdump. You may need to use it with the debug
switch and possibly the parsing messages if using it without the optional
switches doesn't give enough info. I.e.

$ofxdump --msg_debug --msg_parser

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] Tax Issues

2019-01-16 Thread Dan Nelms

I am running GnuCash 3.4 on Windows 10. I have the same issue on GnuCash
3.4 and I also had the issue with GnuCash 3.3.

Dan

On 1/16/2019 1:45 PM, Adrien Monteleone wrote:
> Sorry I don’t have a copy of 3.3 handy to test, but on 3.4 it works as 
> expected. (I’m using MacOS)
>
> As a side note, I did notice how annoying it is that one can’t assign 
> multiple accounts to be tax related without exiting the dialog. Clicking ‘OK’ 
> closes the dialog and the user has to go back to Edit > Tax Reporting 
> Options, find the next account, mark it tax related, choose a form, click 
> ‘OK’, rinse repeat. It seems to me there should be an ‘Apply’ button that is 
> missing.
>
> Regards,
> Adrien 
>
>> On Jan 16, 2019, at 11:51 AM, Mike stagl  wrote:
>>
>> I'm using GnuCash 3.3 on Debian 9.
>>
>> I have an existing GnuCash file from 2018 that I would like to modify
>> to start using the the Tax Reporting features of GnuCash.  It doesn't
>> appear to be working.  Here is what I have tried.
>>
>> Edit -> Tax Reporting Options 
>> I EDIT Income Tax Identity to Individual (U.S. Form 1040) and enter a
>> name like "Tax"; select an expense account; click Tax Related checkbox;
>> I pick a form from Schedule E on the list; and I click OK.
>>
>> When I view the accounts tab, the Tax Info column displays "Tax Entity
>> Type Not Specified".  Also, the Tax Report from the Reports menu comes
>> up with no data (it says I need to enter the Tax Report Options dialog
>> to set up tax Entity Types).
>>
>> I see a few comments about the tax stuff not working from time to time,
>> I am wondering what the latest is in version 3.3.
>>
>> Any ideas?  Thanks everyone!
>>
>> 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.
>>
>
> ___
> 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] Tax Issues

Sorry I don’t have a copy of 3.3 handy to test, but on 3.4 it works as 
expected. (I’m using MacOS)

As a side note, I did notice how annoying it is that one can’t assign multiple 
accounts to be tax related without exiting the dialog. Clicking ‘OK’ closes the 
dialog and the user has to go back to Edit > Tax Reporting Options, find the 
next account, mark it tax related, choose a form, click ‘OK’, rinse repeat. It 
seems to me there should be an ‘Apply’ button that is missing.

Regards,
Adrien 

> On Jan 16, 2019, at 11:51 AM, Mike stagl  wrote:
> 
> I'm using GnuCash 3.3 on Debian 9.
> 
> I have an existing GnuCash file from 2018 that I would like to modify
> to start using the the Tax Reporting features of GnuCash.  It doesn't
> appear to be working.  Here is what I have tried.
> 
> Edit -> Tax Reporting Options 
> I EDIT Income Tax Identity to Individual (U.S. Form 1040) and enter a
> name like "Tax"; select an expense account; click Tax Related checkbox;
> I pick a form from Schedule E on the list; and I click OK.
> 
> When I view the accounts tab, the Tax Info column displays "Tax Entity
> Type Not Specified".  Also, the Tax Report from the Reports menu comes
> up with no data (it says I need to enter the Tax Report Options dialog
> to set up tax Entity Types).
> 
> I see a few comments about the tax stuff not working from time to time,
> I am wondering what the latest is in version 3.3.
> 
> Any ideas?  Thanks everyone!
> 
> 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.
> 

___
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] "Save Report Configuration" Crashes GnuCash and Truncates saved-reports-2.8

David,

I’ve seen that very strange issue happen on two other occasions, once with a 
mailbox file and once with an XML file. I can’t fathom why the OS reports less 
data than is really there as it shouldn’t care if the file is malformed or not 
to the filetype’s specifications when it reports total size on disk. I’ve seen 
this on both Linux and Mac. (I never tested those files on Windows to see if 
that OS would do the same) This might be some sort of bug related to how files 
are split up on disk, or if such file errors result in an errant change to the 
file table entry, (FAT, journal, etc.) I dunno.

Unfortunately, I no longer remember the exact issues, but certainly, correcting 
the text in the file in my cases, (I could load the entire file in a text 
editor) restored access to my data and got the OS to report the real file size.

Regards,
Adrien

> On Jan 16, 2019, at 10:54 AM, David T. via gnucash-user 
>  wrote:
> 
> Geert and others,
> 
> I would like to follow up on the issues I raised earlier. 
> 
> First off, the crashing upon saving the report has gone away. I have no idea 
> why.
> 
> As for the saved-reports truncation issue, after a break from all of this, I 
> returned to do some tinkering around. Repeated efforts to modify a few of my 
> reports for the latest version of the Transaction Report yielded the same 
> results: my saved-reports file was truncated at 32kb.
> 
> I began the process of trying to document all 56 saved reports in my file 
> (including trying to remove outdated ones) so that I could wipe the slate 
> clean and start over again. A third of the way through, I ran into a report 
> that was embedded in a multicolumn report which was not yielding expected 
> results. This report would only return a cryptic error message. My suspicions 
> aroused, I removed the report from the multicolumn report, saved the 
> multicolumn report, closed, and then reopened GnuCash. 
> 
> All my reports were still there, and further edits on saved reports did not 
> truncate the saved-reports file.
> 
> I’m not certain, but I wonder whether there is an issue in the multicolumn 
> report code—to wit, I see that the entries for each section appear to be 
> based on other reports, and I wonder what would happen if I were to remove 
> the stored report upon which that section is built?
> 
> Anyhow, it appears that the truncation issue had to do with this erroneous 
> saved report. I have no idea what could have fixed the crasher.
> 
> Cheers,
> David
> 
>> On Dec 29, 2018, at 9:31 PM, Geert Janssens  
>> wrote:
>> 
>> Hi David,
>> 
>> A very disturbing situation to be in.
>> 
>> I think the first step is to narrow down the possible issues.
>> 
>> Op zaterdag 29 december 2018 16:18:43 CET schreef David T. via gnucash-user:
>>> Hello,
>>> 
>>> As the subject line notes, I am again encountering a crasher in GnuCash 3.3
>>> on MacOS Mojave when I try to save a report configuration for a report
>>> whose settings have changed. Upon restart, I find that the saved reports
>>> have been trashed, and the saved-reports-2.8 file is truncated at a
>>> fraction of its prior size.
>>> 
>>> Further specifics: I am opening a saved report which is intended to document
>>> a small subset of expense accounts. I have added a new subaccount to this
>>> set of expenses, and I wish to add this new subaccount to the existing
>>> saved report. I open the report (Reports->Saved Report Configurations) and
>>> then select the options for the report. I click to the Accounts tab, add
>>> the new account (CMD-Click) and click save. The new version of the report
>>> now displays. I click on the “Save Report Configuration” button, and
>>> GnuCash disappears. There is no further information displayed (i.e., I do
>>> not receive an Apple message about the program ending unexpectedly, etc.).
>>> Neither does it appear that there is a crash report; the only crash I can
>>> find regarding GnuCash dates from 12/18, and today is not 12/18.
>>> 
>> When this happens is there anything in the trace file ?
>> 
>>> More disturbingly, when I reopen GnuCash, I find that my Saved Report
>>> Configurations file has been truncated, resulting in a loss of most of my
>>> reports. (Because I’ve had similar troubles with GnuCash trashing my
>>> reports file, I have copies of saved-reports-2.8 stored in safe spots.) The
>>> saved-reports-2.8 file goes from 182 kb to 34 kb. Upon restart, I have only
>>> 7 saved reports.
>>> 
>> So some of them are still in there ? Is the last one that's still there 
>> completely stored in the saved reports file ? And what's the first report 
>> that's not saved ? Do you see anything particular about this one ?
>> 
>> What if you remove this first report that's not saved from your original 
>> saved 
>> reports file (after making a proper backup of course) and restore this 
>> manually edited file. Can you now save your new report correctly ?
>> 
>> Regards,
>> 
>> Geert
>> 
>> 
> 
>

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

You can have multiple versions installed at once, they just either have to be 
installed in different locations, or if you want them all in /Applications, 
they each need to have different names. (can’t have two files with the same 
name in any directory) An easy choice would be to append the version number 
before the “.app” in “Gnucash.app”.

The more important consideration is making sure to work with backup copies of 
the data and don’t touch the original until it is sorted out.

Regards,
Adrien

> On Jan 16, 2019, at 8:52 AM, Christopher Lam  
> wrote:
> 
> This seems to be the eguile-based "tax invoice" report.
> 
> Perhaps you can try the other "Printable/Easy/Fancy Invoice" reports and let 
> us know?
> 
> With MacOS it'll be very difficult to investigate this; usually we'd advocate 
> 'bisecting' i.e. try various releases until the exact breaking one is found, 
> but I'm not sure this is feasible with MacOS.
> 
> Sorry, and good luck.
> 

___
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 all my transactions on Gnu cash

Back to the original problem,

I would suspect maybe a viewing filter is at play? That *could* explain why 
some transactions aren’t visible.

The read-only problem *could* be a permissions issue on the file itself. If 
register transactions are the only thing that is ‘read-only’ then I’d say that 
eliminates MacOS file permission problems. It would be an all or nothing deal. 
(try creating a scheduled transaction, or edit a budget, enter an invoice, etc.)

Also, I’m not sure what you mean by “I also cannot see anything more than an 
overall view of the account, ie no dates etc.”

Could you provide a screenshot? (block out any sensitive info of course)

Regards,
Adrien

> On Jan 15, 2019, at 8:38 AM, Georgina Hunter-Jones  
> wrote:
> 
> Thanks, i’ll Try that. Georgina
> 
> On Tue, Jan 15, 2019 at 2:00 PM Derek Atkins  wrote:
> 
>> Dear Georgina,
>> 
>> [snip]
>>> Op dinsdag 15 januari 2019 12:52:50 CET schreef Georgina Hunter-Jones:
 Dear Geert,
 Thank you, that helped to a certain extent. I can now see lines of
 information with the account details. However, it appears to be 'read
 only'
 and I cannot enter any further data. I also cannot see anything more
 than
 an overall view of the account, ie no dates etc.
 
 Anything I can do to change that? Thank you very much for your help so
 far.
 Best wishes, Georgina
>> 
>> This sounds like it could be a permissions problem, although I'm not
>> familiar enough with MacOS permissions to know how best to fix it.
>> Hopefully a MacOS expert will come in.  But it really sounds like when you
>> copied your data file you put it into a directory that your current user
>> does not have access to write new files.
>> 
>> Can you try this:
>> 
>> Make a new folder from the Finder
>> Copy your data file to the new Folder
>> Open GnuCash
>> File -> Open the data file from the new folder
>> 
>> Does this help?
>> 
 On Tue, Jan 15, 2019 at 8:31 AM Geert Janssens
 
 
 wrote:
> A few other suggestions:
> 
> 1. Which files did you transfer ? While that sounds obvious, it is not
> always
> so. So this question is to ensure you really did copy your gnucash
 data
> file
> to the older computer.
> 
> 2. How have you tried to open your gnucash data file ? It's important
 to
> realize that on MacOS double-clicking on a random gnucash data file
> doesn't
> necessarily mean that file will be opened. GnuCash will always reopen
 that
> previously last opened file (which may be different from the one you
> double-
> clicked on). To fix that you can:
> - Start the gnucash application
> - Select File->Open
> - Navigate to your gnucash data file and open it this way
> 
> Will that bring your data back ?
> 
> Regards,
> 
> Geert
>> 
>>> 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.


___
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] Tax Issues

2019-01-16 Thread Mike stagl

I'm using GnuCash 3.3 on Debian 9.

I have an existing GnuCash file from 2018 that I would like to modify
to start using the the Tax Reporting features of GnuCash.  It doesn't
appear to be working.  Here is what I have tried.

Edit -> Tax Reporting Options 
I EDIT Income Tax Identity to Individual (U.S. Form 1040) and enter a
name like "Tax"; select an expense account; click Tax Related checkbox;
 I pick a form from Schedule E on the list; and I click OK.

When I view the accounts tab, the Tax Info column displays "Tax Entity
Type Not Specified".  Also, the Tax Report from the Reports menu comes
up with no data (it says I need to enter the Tax Report Options dialog
to set up tax Entity Types).

I see a few comments about the tax stuff not working from time to time,
I am wondering what the latest is in version 3.3.

Any ideas?  Thanks everyone!

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.

[GNC] OFX import sometimes loses transaction memos

2019-01-16 Thread David Carlson

Using GnuCash 2.6.17? in Ubunutu 16.04 I noticed that the OFX importer from
time to time will fail to import some, but not all transaction memos for
only one of the banks that that are currently active in my data.

This bank tends to send lenghthy memos.  One of the failed memos had 98
ASCII characters, another accepted memo had 42 ASCII characters.  The OFX
files from this bank do not contain cr or lf characters before the <
characters, instead have 15 spaces.

Does anyone else have. A similar problem or a suggestion about might cause
this?


David C
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] "Save Report Configuration" Crashes GnuCash and Truncates saved-reports-2.8

Geert and others,

I would like to follow up on the issues I raised earlier. 

First off, the crashing upon saving the report has gone away. I have no idea 
why.

As for the saved-reports truncation issue, after a break from all of this, I 
returned to do some tinkering around. Repeated efforts to modify a few of my 
reports for the latest version of the Transaction Report yielded the same 
results: my saved-reports file was truncated at 32kb.

I began the process of trying to document all 56 saved reports in my file 
(including trying to remove outdated ones) so that I could wipe the slate clean 
and start over again. A third of the way through, I ran into a report that was 
embedded in a multicolumn report which was not yielding expected results. This 
report would only return a cryptic error message. My suspicions aroused, I 
removed the report from the multicolumn report, saved the multicolumn report, 
closed, and then reopened GnuCash. 

All my reports were still there, and further edits on saved reports did not 
truncate the saved-reports file.

I’m not certain, but I wonder whether there is an issue in the multicolumn 
report code—to wit, I see that the entries for each section appear to be based 
on other reports, and I wonder what would happen if I were to remove the stored 
report upon which that section is built?

Anyhow, it appears that the truncation issue had to do with this erroneous 
saved report. I have no idea what could have fixed the crasher.

Cheers,
David

> On Dec 29, 2018, at 9:31 PM, Geert Janssens  
> wrote:
> 
> Hi David,
> 
> A very disturbing situation to be in.
> 
> I think the first step is to narrow down the possible issues.
> 
> Op zaterdag 29 december 2018 16:18:43 CET schreef David T. via gnucash-user:
>> Hello,
>> 
>> As the subject line notes, I am again encountering a crasher in GnuCash 3.3
>> on MacOS Mojave when I try to save a report configuration for a report
>> whose settings have changed. Upon restart, I find that the saved reports
>> have been trashed, and the saved-reports-2.8 file is truncated at a
>> fraction of its prior size.
>> 
>> Further specifics: I am opening a saved report which is intended to document
>> a small subset of expense accounts. I have added a new subaccount to this
>> set of expenses, and I wish to add this new subaccount to the existing
>> saved report. I open the report (Reports->Saved Report Configurations) and
>> then select the options for the report. I click to the Accounts tab, add
>> the new account (CMD-Click) and click save. The new version of the report
>> now displays. I click on the “Save Report Configuration” button, and
>> GnuCash disappears. There is no further information displayed (i.e., I do
>> not receive an Apple message about the program ending unexpectedly, etc.).
>> Neither does it appear that there is a crash report; the only crash I can
>> find regarding GnuCash dates from 12/18, and today is not 12/18.
>> 
> When this happens is there anything in the trace file ?
> 
>> More disturbingly, when I reopen GnuCash, I find that my Saved Report
>> Configurations file has been truncated, resulting in a loss of most of my
>> reports. (Because I’ve had similar troubles with GnuCash trashing my
>> reports file, I have copies of saved-reports-2.8 stored in safe spots.) The
>> saved-reports-2.8 file goes from 182 kb to 34 kb. Upon restart, I have only
>> 7 saved reports.
>> 
> So some of them are still in there ? Is the last one that's still there 
> completely stored in the saved reports file ? And what's the first report 
> that's not saved ? Do you see anything particular about this one ?
> 
> What if you remove this first report that's not saved from your original 
> saved 
> reports file (after making a proper backup of course) and restore this 
> manually edited file. Can you now save your new report correctly ?
> 
> 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] Transaction Report Preference missing?

Chris,

I do note one issue with the new transaction report: it doesn’t seem to utilize 
the Sign Reverses option—at least, not that I can see.

Cheers,
David 

> On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user 
>  wrote:
> 
> Chris,
> 
> Thank you for the lead. 
> 
> It turns out that I can get almost exactly the same result using the hide 
> transactional data option, when I combine it with "Amount - Single”. The only 
> difference is that the Account name is not presented before the total line. I 
> consider that to be an improvement, actually.
> 
> Bug avoided.
> 
> David
> 
>> On Jan 16, 2019, at 6:01 PM, Christopher Lam  
>> wrote:
>> 
>> There's "Sorting / Show subtotals only (hide transactional data)"
>> 
>> You may be right that 'Display / Amount' = none is not completely handled as 
>> before.
>> 
>> Please file a bug, and screenshot a sample report, anonymised; please enable 
>> 'General / Add options summary' to display options used.
>> 
>> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
>> 
>> Thank you for finding these edge cases.
>> 
>> C
>> 
>> 
>> On 16/1/19 8:09 pm, David T. via gnucash-user wrote:
>>> Hello,
>>> 
>>> Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use 
>>> around this time of year (I call it “W-2 - David”) that shows me the total 
>>> amounts assigned to a subset of my expense accounts (i.e., my tax expense 
>>> accounts).
>>> 
>>> The purpose of this report is to allow me to compare my GnuCash numbers to 
>>> the numbers issued to me by my employer. In GnuCash 2.6.19, this report 
>>> looks something like this:
>>> 
>>> ———
>>> 
>>> From 01/01/2018 To 12/31/2018
>>> 
>>> Fed
>>> Total For Fed   $X.XX
>>> Medicare
>>> Total For Medicare  $X.XX
>>> Soc Sec
>>> Total For Soc Sec   $X.XX
>>> State
>>> Total For State $X.XX
>>> Grand Total $X.XX
>>> 
>>> ———
>>> 
>>> As I said, this report is intended to match my employer’s reporting, so I 
>>> can compare the two.
>>> 
>>> 
>>> However, when I run the *SAME REPORT* in GnuCash 3.4, I get unsatisfactory 
>>> changes to the results. My LITERAL results are:
>>> 
>>> ———
>>> 
>>> From 01/01/2018 to 12/31/2018
>>> 
>>> Account
>>> Fed
>>> Fed
>>> Fed
>>> Fed
>>> Fed
>>> Fed
>>> Fed
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Medicare
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> Soc Sec
>>> State
>>> State
>>> State
>>> State
>>> State
>>> State
>>> State
>>> State
>>> ———
>>> 
>>> Now, there are two significant problems here: first, every transaction for 
>>> the year gets a line, and second, THERE ARE NO AMOUNTS. I have tinkered 
>>> with every setting I can find on the report options, but I cannot find the 
>>> setting that will display ONLY THE TOTALS. It would appear that in a recent 
>>> update to this report, the “NONE” option on line amounts has been removed.
>>> 
>>> Unless someone can point me to the obvious place where I missed this 
>>> setting, I believe this is a regression in the report. I ought to be able 
>>> to display a report that includes totals only.
>>> 
>>> David T.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> 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


This seems to be the eguile-based "tax invoice" report.

Perhaps you can try the other "Printable/Easy/Fancy Invoice" reports and 
let us know?


With MacOS it'll be very difficult to investigate this; usually we'd 
advocate 'bisecting' i.e. try various releases until the exact breaking 
one is found, but I'm not sure this is feasible with MacOS.


Sorry, and good luck.

On 15/1/19 8:58 pm, Deva - wrote:

Hello,

I am on GnuCash 3.4, Mac OS 10.13.6 (High Sierra).

Please see attached for a sample invoice I generate out of GnuCash based on the 
Tax Invoice report (sensitive data has been masked). Today was the first time I 
tried to run this report from GnuCash 3.4 and I noticed that the INR currency 
symbol is showing up as a missing symbol icon.

Any suggestions on how to fix this?

I tried turning off the display of currency symbol in the report via 
Edit->Report Options, but didn’t see anything to that effect.

Cheers,
Deva

___
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] [MAINT] server upgrade planned Feb 3, 2019 1200-2300 US/EST

2019-01-16 Thread Derek Atkins

Liz  writes:

> Well that's so many hours less spam I get to check
> I'm quite happy with the proposal

Hahah.  I don't expect to have 11 hours of down time -- but I don't know
what my personal schedule will be that day so I wanted to leave
wiggle-room for when I'll actually get to do the work.  I might not be
able to start until 1800 local time instead of 1200 local -- it's really
going to depend on the family and our superbowl plans.  I figured, worst
case, I would have the laptop next to me while watching the game :)

> :)
>
> Liz

> 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] Lost all my transactions on Gnu cash

2019-01-16 Thread Derek Atkins

D via gnucash-user  writes:

> Interesting. I seem to recall someone instructing people to use only
> lists.gnucash.org for such searches, and was not aware of the
> reference you cite. A search of the wiki only shows an example for
> lists.gnucash.org on the mailing lists page. I must be showing my
> age...

No, the current primary suggestion is google limited to
site:lists.gnucash.org for your searches.

> David T.

> 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] Transaction Report Preference missing?

Chris,

Thank you for the lead. 

It turns out that I can get almost exactly the same result using the hide 
transactional data option, when I combine it with "Amount - Single”. The only 
difference is that the Account name is not presented before the total line. I 
consider that to be an improvement, actually.

Bug avoided.

David

> On Jan 16, 2019, at 6:01 PM, Christopher Lam  
> wrote:
> 
> There's "Sorting / Show subtotals only (hide transactional data)"
> 
> You may be right that 'Display / Amount' = none is not completely handled as 
> before.
> 
> Please file a bug, and screenshot a sample report, anonymised; please enable 
> 'General / Add options summary' to display options used.
> 
> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
> 
> Thank you for finding these edge cases.
> 
> C
> 
> 
> On 16/1/19 8:09 pm, David T. via gnucash-user wrote:
>> Hello,
>> 
>> Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use 
>> around this time of year (I call it “W-2 - David”) that shows me the total 
>> amounts assigned to a subset of my expense accounts (i.e., my tax expense 
>> accounts).
>> 
>> The purpose of this report is to allow me to compare my GnuCash numbers to 
>> the numbers issued to me by my employer. In GnuCash 2.6.19, this report 
>> looks something like this:
>> 
>> ———
>> 
>> From 01/01/2018 To 12/31/2018
>> 
>> Fed
>> Total For Fed$X.XX
>> Medicare
>> Total For Medicare   $X.XX
>> Soc Sec
>> Total For Soc Sec$X.XX
>> State
>> Total For State  $X.XX
>> Grand Total  $X.XX
>> 
>> ———
>> 
>> As I said, this report is intended to match my employer’s reporting, so I 
>> can compare the two.
>> 
>> 
>> However, when I run the *SAME REPORT* in GnuCash 3.4, I get unsatisfactory 
>> changes to the results. My LITERAL results are:
>> 
>> ———
>> 
>> From 01/01/2018 to 12/31/2018
>> 
>> Account
>> Fed
>> Fed
>> Fed
>> Fed
>> Fed
>> Fed
>> Fed
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Medicare
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> Soc Sec
>> State
>> State
>> State
>> State
>> State
>> State
>> State
>> State
>> ———
>> 
>> Now, there are two significant problems here: first, every transaction for 
>> the year gets a line, and second, THERE ARE NO AMOUNTS. I have tinkered with 
>> every setting I can find on the report options, but I cannot find the 
>> setting that will display ONLY THE TOTALS. It would appear that in a recent 
>> update to this report, the “NONE” option on line amounts has been removed.
>> 
>> Unless someone can point me to the obvious place where I missed this 
>> setting, I believe this is a regression in the report. I ought to be able to 
>> display a report that includes totals only.
>> 
>> David T.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
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

2019-01-16 Thread Deva -

Thank you for your response, Frank.

When I look at the “Default” stylesheet, Arial is the default font. When I look
at the Character Viewer on my Mac, I can see that the INR (rupee) symbol is
available, though I couldn’t figure out what font that is.

This was not a problem until 3.3, so I am not sure how to fix this in 3.4.

I tried changing the default stylesheet’s font to Helvetica/MS Sans Serif, but
it still doesn’t show the report with proper symbol for INR.

Following your other wiki instructions, I then looked at Tools->Security Editor
to check if the currency symbol is there and everything looks ok on that screen
(see attached screenshot). I can see the currency editor shows the proper
symbol for INR (rupee).

Also note that this is only a problem in reports. The currency symbol is
showing fine on the main account tree page.

Please let me know if there’s anything else I can try.

Cheers.

[cid:0133440E-F5D0-4450-BC47-65D732752428@Belkin]
On 15-Jan-2019, at 7:38 PM, Frank H. Ellenberger
mailto:frank.h.ellenber...@gmail.com>> wrote:

Hi Deva,

Am 15.01.19 um 13:58 schrieb Deva -:
Hello,

I am on GnuCash 3.4, Mac OS 10.13.6 (High Sierra).

Please see attached for a sample invoice I generate out of GnuCash based on the
Tax Invoice report (sensitive data has been masked). Today was the first time I
tried to run this report from GnuCash 3.4 and I noticed that the INR currency
symbol is showing up as a missing symbol icon.

Any suggestions on how to fix this?

You need (to install and) use a font, wich contains the symbol. See
https://wiki.gnucash.org/wiki/FAQ#Q:_How_get_I_rid_of_strange_unreadable_characters_or_adjust_the_font_size

I tried turning off the display of currency symbol in the report via
Edit->Report Options, but didn’t see anything to that effect.

At least you should be able to use something else, see
https://wiki.gnucash.org/wiki/FAQ#Q:_I_dislike_some_of_the_new_currency_symbols_of_GnuCash_2.6

Cheers,
Deva

Cheers
Frank

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Preference missing?


There's "Sorting / Show subtotals only (hide transactional data)"

You may be right that 'Display / Amount' = none is not completely 
handled as before.


Please file a bug, and screenshot a sample report, anonymised; please 
enable 'General / Add options summary' to display options used.


Also, https://bugs.gnucash.org/show_bug.cgi?id=795064

Thank you for finding these edge cases.

C


On 16/1/19 8:09 pm, David T. via gnucash-user wrote:

Hello,

Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use around 
this time of year (I call it “W-2 - David”) that shows me the total amounts 
assigned to a subset of my expense accounts (i.e., my tax expense accounts).

The purpose of this report is to allow me to compare my GnuCash numbers to the 
numbers issued to me by my employer. In GnuCash 2.6.19, this report looks 
something like this:

———

 From 01/01/2018 To 12/31/2018

Fed
Total For Fed   $X.XX
Medicare
Total For Medicare  $X.XX
Soc Sec
Total For Soc Sec   $X.XX
State
Total For State $X.XX
Grand Total $X.XX

———

As I said, this report is intended to match my employer’s reporting, so I can 
compare the two.


However, when I run the *SAME REPORT* in GnuCash 3.4, I get unsatisfactory 
changes to the results. My LITERAL results are:

———

 From 01/01/2018 to 12/31/2018

Account
Fed
Fed
Fed
Fed
Fed
Fed
Fed
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
State
State
State
State
State
State
State
State
———

Now, there are two significant problems here: first, every transaction for the 
year gets a line, and second, THERE ARE NO AMOUNTS. I have tinkered with every 
setting I can find on the report options, but I cannot find the setting that 
will display ONLY THE TOTALS. It would appear that in a recent update to this 
report, the “NONE” option on line amounts has been removed.

Unless someone can point me to the obvious place where I missed this setting, I 
believe this is a regression in the report. I ought to be able to display a 
report that includes totals only.

David T.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Australian Stock Quotes

Norman,

Glad to help. In the future, be sure to “Reply All” so that your message gets 
back to the list. That way, everyone gets to hear the denouement.

David

> On Jan 16, 2019, at 5:35 PM, Norman Jessup  wrote:
> 
> Thanks David,
> 
> This is very helpful
> 
> regards,
> 
> Norman Jessup
> 
> 
> 
> 
> 
> On 16/1/19 10:24 pm, David T. wrote:
>> Norman,
>> 
>> While the “FinanceQuote Update” module might not have been changed since 
>> 2010, *Finance Quote* (which actually performs quote retrieval for GnuCash) 
>> most certainly has been updated numerous times since then. If you *run* 
>> “FinanceQuote Update,” it will … update Finance Quote for you. The most 
>> recent version of Finance::Quote is 1.47, and is dated November 12, 2017.
>> 
>> Please note that there has been a huge amount of discussion about F::Q over 
>> the last year and a half (which is probably what underlies your note about 
>> it stopping working); to keep the story short, Yahoo! decided to stop 
>> providing price quotes. From the resulting hullaballoo, F::Q changed primary 
>> quote providers, either to AlphaVantage or to Yahoo! Json. You will need to 
>> reset your commodities each to use a currently-valid source. Much of this is 
>> explained on the wiki at 
>> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F 
>>  
>> Note Paragraph 3.
>> 
>> Cheers,
>> David T.
>> 
>>> On Jan 16, 2019, at 9:10 AM, normanj >> > wrote:
>>> 
>>> A year or two (or three) ago the share price tool stopped working for
>>> Australian shares.   I saw some forum posts suggesting that source of
>>> Australian quotes was no longer available and needed to be changed.
>>> 
>>> While there have been several new version of GnuCash released since then,
>>> the FinanceQuote Update module does not appear to have changed since 2010.
>>> 
>>> I've tried without success to modify the tool myself.  Is anyone able to
>>> point me towards detailed instructions about what I need to do to fix this? 
>>> or possibly where I can download a more up-to-date version of the tool?
>>> 
>>> Thank you
>>> 
>>> 
>>> 
>>> 
>>> 
>>> --
>>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org 
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> 
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>>>  for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Report Preference missing?

Hello,

Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use around 
this time of year (I call it “W-2 - David”) that shows me the total amounts 
assigned to a subset of my expense accounts (i.e., my tax expense accounts).

The purpose of this report is to allow me to compare my GnuCash numbers to the 
numbers issued to me by my employer. In GnuCash 2.6.19, this report looks 
something like this:

———

From 01/01/2018 To 12/31/2018

Fed
Total For Fed   $X.XX
Medicare
Total For Medicare  $X.XX
Soc Sec
Total For Soc Sec   $X.XX
State
Total For State $X.XX
Grand Total $X.XX

———

As I said, this report is intended to match my employer’s reporting, so I can 
compare the two.


However, when I run the *SAME REPORT* in GnuCash 3.4, I get unsatisfactory 
changes to the results. My LITERAL results are:

———

From 01/01/2018 to 12/31/2018

Account
Fed
Fed
Fed
Fed
Fed
Fed
Fed
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Medicare
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
Soc Sec
State
State
State
State
State
State
State
State
———

Now, there are two significant problems here: first, every transaction for the 
year gets a line, and second, THERE ARE NO AMOUNTS. I have tinkered with every 
setting I can find on the report options, but I cannot find the setting that 
will display ONLY THE TOTALS. It would appear that in a recent update to this 
report, the “NONE” option on line amounts has been removed.

Unless someone can point me to the obvious place where I missed this setting, I 
believe this is a regression in the report. I ought to be able to display a 
report that includes totals only.

David T.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Australian Stock Quotes