Re: [GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

[Christopher Lam]

>
> > While I am at it, I note that the report setting to reverse account
> signs on the transaction report doesn’t seem to affect the total amount any
> more—it worked correctly in 2.6.19. ISTR that others have noted this—or
> does that need to get a bug as well?
> >
>

I'm afraid the previous 'reverse accounts' strategy was flawed.

If both *income & expense* accounts are selected for reporting, until about
2.6.19 the strategy was as follows:
Total Income: $1000
Total Expenses: $800
Grand Total: $1800. which is meaningless

Now, the report can be as follows, depending on reverse-accounts status:
Total Income: $1000
Total Expenses: $800
Grand Total: -$200

The grand total will add *un*reversed amounts, and, bearing in mind income
accounts are technically negative, will produce a "Grand Total" of -$200.

Instead of figuring out which reverse-amount strategy to follow, I'd
recommend enabling 'display/amount=double' which will explicitly place the
amount in (IMHO) the correct debit/credit column. The only downside to this
is that the 'display/subtotal-table' will then be unavailable.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

[John Ralls]

> On May 2, 2018, at 1:09 PM, David T. via gnucash-user 
>  wrote:
> 
> Hello,
> 
> Before I submit a bug report, I’d like to see whether there has been some 
> change to the reports system that causes the degradation I am seeing, and if 
> there is a different way to achieve my same goal.
> 
> I have a custom report that is set to display a single figure for YTD totals 
> for a subset of my income accounts (dividends). This is a simple transaction 
> report that has the Income:Dividend accounts selected, is set to cover the 
> current accounting period, and is supposed to display only “Totals”. 
> 
> In general, the result is as follows:
> 
> YTD Dividends
> From 01/01/2018 to 05/02/2018
> 
> Grand Total $9,999.00
> 
> In the past, this report would present the current YTD dividend total in a 
> single figure in a compact area (I use it on a dashboard multicolumn 
> display). With 3.1, however, I get all the accounts listed, and no figures 
> anywhere (not for individual accounts, and not for a grand total). 
> Furthermore, if I try to load the saved report separately, I get a generic 
> “Report Error” message. If I close out GC 3.1 without saving and reload the 
> file in 2.6.19, the report functions as expected.
> 
> Finally, if I try to recreate the report from scratch, I cannot get the 
> report to format as I prefer—with no account information and a single YTD 
> amount. I can only seem to get the total if I display all the transaction 
> data, which defeats the purpose of my report showing me at a glance how much 
> dividend income I have accumulated YTD.
> 
> Has anyone encountered this problem and found a remedy?
> 
> While I am at it, I note that the report setting to reverse account signs on 
> the transaction report doesn’t seem to affect the total amount any more—it 
> worked correctly in 2.6.19. ISTR that others have noted this—or does that 
> need to get a bug as well?
> 

I think someone has mentioned that issue before, perhaps on IRC, and that Chris 
Lam had proposed a small change to the Transaction Report to restore that 
capability.

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.

[GNC] locale setting

[Jose Lello]

GnuCash 2.6.12 - rev ed11f6d+ on 2016-04-18

Linux Mint 18.3 Sylvia

Instead of the euro simbol, I get ???. I tried:

~$ LANG=en_GB.UTF-8 LANGUAGE=en_GB.UTF8 LC_ALL=en_GB.UTF-8 /usr/bin/gnucash

(process:18886): GLib-CRITICAL **: g_setenv: assertion 'value != NULL'
failed

(process:18886): gnc.core-utils-WARNING **: Couldn't properly override
environment variable "LANGUAGE". This may lead to unexpected results
Traceback (most recent call last):
  File "/usr/share/gnucash/python/init.py", line 3, in 
    from gnucash import *
ImportError: No module named gnucash
Found Finance::Quote version 1.38
[PIPELIGHT:LIN:unknown] attached to process.
[PIPELIGHT:LIN:unknown] checking environment variable
PIPELIGHT_SILVERLIGHT5_1_CONFIG.
[PIPELIGHT:LIN:unknown] searching for config file pipelight-silverlight5.1.
[PIPELIGHT:LIN:unknown] trying to load config file from
'/home/jlello/.config/pipelight-silverlight5.1'.
[PIPELIGHT:LIN:unknown] trying to load config file from
'/etc/pipelight-silverlight5.1'.
[PIPELIGHT:LIN:unknown] trying to load config file from
'/usr/share/pipelight/configs/pipelight-silverlight5.1'.
[PIPELIGHT:LIN:unknown] sandbox not found or not installed!
[PIPELIGHT:LIN:silverlight5.1] using wine prefix directory
/home/jlello/.wine-pipelight.
[PIPELIGHT:LIN:silverlight5.1] checking plugin installation - this might
take some time.
[install-dependency] wine-silverlight5.1-installer is already installed
in '/home/jlello/.wine-pipelight'.
[install-dependency] wine-mpg2splt-installer is already installed in
'/home/jlello/.wine-pipelight'.
fixme:winediag:start_process Wine Staging 1.9.7 is a testing version
containing experimental patches.
fixme:winediag:start_process Please mention your exact version when
filing bug reports on winehq.org.
wine: DLL not found.
err:wineboot:ProcessRunKeys Error running cmd
L"C:\\windows\\system32\\winemenubuilder.exe -a -r" (1157)
[PIPELIGHT:WIN:silverlight5.1] embedded mode is on.
[PIPELIGHT:WIN:silverlight5.1] windowless mode   is off.
[PIPELIGHT:WIN:silverlight5.1] linux windowless mode is off.
[PIPELIGHT:WIN:silverlight5.1] force SetWindow   is off.
[PIPELIGHT:WIN:silverlight5.1] window class hook is on.
[PIPELIGHT:WIN:silverlight5.1] strict draw ordering  is off.
[PIPELIGHT:WIN:silverlight5.1] replaced API function CreateWindowExA.
[PIPELIGHT:WIN:silverlight5.1] replaced API function CreateWindowExW.
[PIPELIGHT:WIN:silverlight5.1] replaced API function TrackPopupMenuEx.
[PIPELIGHT:WIN:silverlight5.1] replaced API function TrackPopupMenu.
fixme:ntdll:EtwRegisterTraceGuidsW (0x7b8d21a7, 0x7b970120,
{aa087e0e-0b35-4e28-8f3a-440c3f51eef1}, 1, 0x71f478, (null), (null),
0x7b970120): stub
fixme:ntdll:EtwRegisterTraceGuidsW   register trace class
{aa087e0e-0b35-4e28-8f3a-440c3f51eef1}
[PIPELIGHT:WIN:silverlight5.1] init successful!
[PIPELIGHT:WIN:silverlight5.1] OpenGL Vendor: Intel Open Source
Technology Center
[PIPELIGHT:WIN:silverlight5.1] OpenGL Renderer: Mesa DRI Intel(R) 965GM
x86/MMX/SSE2
[PIPELIGHT:WIN:silverlight5.1] Your GPU is in the whitelist, hardware
acceleration should work.
[PIPELIGHT:LIN:silverlight5.1] using thread asynccall event handling.
openjdk version "1.8.0_162"
OpenJDK Runtime Environment (build 1.8.0_162-8u162-b12-0ubuntu0.16.04.2-b12)
OpenJDK 64-Bit Server VM (build 25.162-b12, mixed mode)
^Cfixme:console:CONSOLE_DefaultHandler Terminating process 8 on event 0
fixme:advapi:UnregisterTraceGuids deadbeef: stub

---

An instance of GnuCash opened with the problem fixed, but opening
GnuCash from the Menu showed the same problem again

Thank you,

José

-- 

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

Re: [GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

[Adrien Monteleone]

David,

I haven’t noticed this case in particular but do see some other unique 3.1 
report problems. (filed a bug on one a couple of days ago) But since you 
mentioned other approaches, does not turning on the Total (Period) column on 
the Accounts tab not give you the info you’re looking for? I have this turned 
on and since totals roll-up to the parent, it shows me what I would expect to 
see if I ran such a report as you describe.

I just played with the Transaction Report and I also can’t get the individual 
sub-accounts to not display. But that might be intended. If I only select the 
parent, and run a *Transaction* report, I get nothing, because well, there are 
no transactions in it. I have to select the child accounts that hold the actual 
transactions. And that is what is being subtotaled. The “Totals” option appears 
to only sum all of the individual accounts. (or not) I don’t think it should 
mean to ONLY display that total. If it used to function that way, I should 
think it was a bug that has now been fixed.

I do see the option ‘Show subtotals only (hide transactional data)’ in the 
sorting tab (shouldn’t this belong in ‘display’?) but I don’t see an option to 
hide the per-account sub-totals.

Regards,
Adrien

> Hello,
> 
> Before I submit a bug report, I’d like to see whether there has been some 
> change to the reports system that causes the degradation I am seeing, and if 
> there is a different way to achieve my same goal.
> 
> I have a custom report that is set to display a single figure for YTD totals 
> for a subset of my income accounts (dividends). This is a simple transaction 
> report that has the Income:Dividend accounts selected, is set to cover the 
> current accounting period, and is supposed to display only “Totals”. 
> 
> In general, the result is as follows:
> 
> YTD Dividends
> From 01/01/2018 to 05/02/2018
> 
> Grand Total $9,999.00
> 
> In the past, this report would present the current YTD dividend total in a 
> single figure in a compact area (I use it on a dashboard multicolumn 
> display). With 3.1, however, I get all the accounts listed, and no figures 
> anywhere (not for individual accounts, and not for a grand total). 
> Furthermore, if I try to load the saved report separately, I get a generic 
> “Report Error” message. If I close out GC 3.1 without saving and reload the 
> file in 2.6.19, the report functions as expected.
> 
> Finally, if I try to recreate the report from scratch, I cannot get the 
> report to format as I prefer—with no account information and a single YTD 
> amount. I can only seem to get the total if I display all the transaction 
> data, which defeats the purpose of my report showing me at a glance how much 
> dividend income I have accumulated YTD.
> 
> Has anyone encountered this problem and found a remedy?
> 
> While I am at it, I note that the report setting to reverse account signs on 
> the transaction report doesn’t seem to affect the total amount any more—it 
> worked correctly in 2.6.19. ISTR that others have noted this—or does that 
> need to get a bug as well?
> 
> Cheers,
> 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.

[GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

[David T. via gnucash-user]

Hello,

Before I submit a bug report, I’d like to see whether there has been some 
change to the reports system that causes the degradation I am seeing, and if 
there is a different way to achieve my same goal.

I have a custom report that is set to display a single figure for YTD totals 
for a subset of my income accounts (dividends). This is a simple transaction 
report that has the Income:Dividend accounts selected, is set to cover the 
current accounting period, and is supposed to display only “Totals”. 

In general, the result is as follows:

YTD Dividends
From 01/01/2018 to 05/02/2018

Grand Total $9,999.00

In the past, this report would present the current YTD dividend total in a 
single figure in a compact area (I use it on a dashboard multicolumn display). 
With 3.1, however, I get all the accounts listed, and no figures anywhere (not 
for individual accounts, and not for a grand total). Furthermore, if I try to 
load the saved report separately, I get a generic “Report Error” message. If I 
close out GC 3.1 without saving and reload the file in 2.6.19, the report 
functions as expected.

Finally, if I try to recreate the report from scratch, I cannot get the report 
to format as I prefer—with no account information and a single YTD amount. I 
can only seem to get the total if I display all the transaction data, which 
defeats the purpose of my report showing me at a glance how much dividend 
income I have accumulated YTD.

Has anyone encountered this problem and found a remedy?

While I am at it, I note that the report setting to reverse account signs on 
the transaction report doesn’t seem to affect the total amount any more—it 
worked correctly in 2.6.19. ISTR that others have noted this—or does that need 
to get a bug as well?

Cheers,
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.

[GNC] GnuCash-3.1

[Michael via gnucash-user]

I am trying GNC-3.1 on Archlabs with good success.  It is available as one 
of their packages.  Only issue to date is display of prices as fractions, 
which I believe is a known issue.  Thanks to all.  Mike

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

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

[Geert Janssens]

Op woensdag 2 mei 2018 16:50:38 CEST schreef Dennis Powless:
> -DCMAKE_INSTALL_RPEFIX=$HOME/.local
> 
> Do I literally type this in terminal?  After the other steps?

You may want to read some background on the cmake command to understand how it 
works. Building from source does require some basic knowledge of the build 
system.

You type litterally
cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local ..

Including the ".."

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] new v3.0 install Ubuntu 18.04 LTS

[Dennis Powless]

-DCMAKE_INSTALL_RPEFIX=$HOME/.local

Do I literally type this in terminal?  After the other steps?







Sent from my iPhone

> On May 2, 2018, at 3:26 AM, Geert Janssens  wrote:
> 
> your user's homedirectory (-DCMAKE_INSTALL_RPEFIX=
> $HOME/.local). You can
___
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] Characters coding in files history list

[John Ralls]

> On May 1, 2018, at 4:22 AM, Jacques Beckand  wrote:
> 
> Hi,
> 
> Gnucash 3.1 does not use right characters coding for retrieving files from
> the files history list inherited from Gnucash 2.6.21
> 
> If the historical gnucash file path contains an accented character, it
> doesn't find it. For example, instead of looking for "Comptabilité", it
> looks for "Comptabilié"
> 
> There is a way to fix this: when asked, remove the file from the history
> list, then open it by navigating to its folder, and the history list will
> then be updated with right path coding.
> 
> Many thanks indeed for your hard work

Please file a bug report on this.

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] Usage question

[John Ralls]

> On May 1, 2018, at 2:16 PM, Jay Ridgley  wrote:
> 
> Good afternoon,
> 
> Given the following:
> 
> GnuCash data file on a network drive (possibly in a cloud). GnuCash open in 
> r/w mode.
> 
> May other instances (other users on other systems) of GnuCash be opened 
> automatically in read only mode ONLY (with some type of system setting)?
> 
> May reports be generated by the read only users?
> 
> Can the data file be shared by different operating systems (MS, Apple and/or 
> Linux)?

Yes to all except for the automatic part. The first user to open the file will 
get the lock and everyone else who subsequently starts GnuCash will get the 
“Can’t get the lock” dialog on which they can select “Open Read Only”. There’s 
no way to tell GnuCash to open the file read only if the lock is available.

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] [GNC-dev] Gnucash-Intel-3.1-2.dmg

[John Ralls]

Dave,

It just won’t run from the .dmg. I don’t know if it’s new behavior or not, but 
it worked fine for me after I dragged it to the same normal folder that Gnucash 
is in (/Applications in my case).

Regards,
John Ralls

> On May 1, 2018, at 3:48 PM, Dave H  wrote:
> 
> Hi John,
> 
> Have just installed 3.1.2 from the dmg and I usually double-click on both
> the Gnucash.app and the FinanceQuote Update.app to trigger the security
> warning and say open anyway before I copy them to the Application folder
> replacing the previous version.  When I double click on FinanceQuote
> Update.app I'm getting an error - "The variable gnc_fq_update is not
> defined." - is this something to worry about or is it just because I'm not
> running it correctly ?
> 
> Cheers Dave H.
> 
> 
> On 30 April 2018 at 15:22, John Ralls  wrote:
> 
>> I found this evening that the Gnucash.app in Gnucash-Intel-3.1-1.dmg was
>> missing a line in the environment file so that it wasn't able to use the
>> SQL backend. I've fixed the problem and uploaded a replacement,
>> Gnucash-Intel-3.1-2.dmg.
>> The sha-256 signature is 71d06ea408302defacf08dcc8343ad
>> e86eeb2298b8b33e75a6e240754c2faf71.
>> 
>> If you'd rather do minor surgery on GnuCash instead of downloading a new
>> dmg, select GnuCash in Finder and control-(or right-)click on it. Select
>> "Show Package Contents" from the context menu, then navigate to
>> Contents/Resources/etc/gnucash. Select 'environment', control-(or
>> right-)click on it, and select "Open With...". Pick an editor, TextEdit
>> will do fine.
>> 
>> Go to the end of the file and add the line
>>  GNC_DBD_DIR={SYS_LIB}/dbd
>> save as plain text and quit.
>> 
>> 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-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel

___
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] Characters coding in files history list

[Jacques Beckand]

Hi,

Gnucash 3.1 does not use right characters coding for retrieving files from
the files history list inherited from Gnucash 2.6.21

If the historical gnucash file path contains an accented character, it
doesn't find it. For example, instead of looking for "Comptabilité", it
looks for "Comptabilié"

There is a way to fix this: when asked, remove the file from the history
list, then open it by navigating to its folder, and the history list will
then be updated with right path coding.

Many thanks indeed for your hard work

Jacques Bezckand


Diacre Jacques Beckand
Unité Pastorale des Sources Vives
rue de la Mutualité 77 1180 Uccle
GSM 0476 469426
___
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] new v3.0 install Ubuntu 18.04 LTS

[Geert Janssens]

If you followed the instructions from the beginning of that page you can run 
the cmake command literally as it's written down

It tells cmake to prepare a gnucash build based on the sources found in the 
parent directory (the .. in the command) and to be installed in the .local 
subdirectory of your user's homedirectory (-DCMAKE_INSTALL_RPEFIX=
$HOME/.local). You can choose another final installation destination, but it's 
recommended you don't use /usr or /usr/local. The first is reserved for 
packages installed via your package manager, the latter tends to suffer from 
interference by packages installed in /usr. Anywhere under your home directory 
is fine and as of 3.1 you could also install under /opt (but in that case the 
make install step should be run via sudo).

Regards,

Geert

Op woensdag 2 mei 2018 02:23:38 CEST schreef Dennis Powless:
> Any ideas or help on building gnucash.
> 
> Or, should I create a new thread?
> 
> D
> 
> On Sun, Apr 29, 2018 at 9:11 PM, Dennis Powless  wrote:
> > Directions found here: https://wiki.gnucash.org/wiki/BuildUbuntu16.04
> > 
> > I'm not sure I follow the directions .
> > I navigate to the folder that contains gnucash-3.1  (which is in the
> > home/dennis/applications folder) by cd gnucash-3.1
> > 
> > 
> > I'm not sure about the line.. cmake -D CMAKE_INSTALL_PREPFIX   do I
> > type all that in terminal or do I have to define it with the items in the
> > <>?
> > 
> > I don't follow the setAdd $HOME/.local/bin to $PATH
> > 
> > Thanks
> > 
> > Dennis



___
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.