Re: Unrealized loss

[David Carlson]

If there was some way to search for or display transactions that contained
a non-zero exchange rate in one or more of it's split lines it might be
possible to track this down.

If the OP had made a typo years ago and corrected it but GnuCash left some
garbage it would not be easy to find.  I suppose that he could try Check
and Repair All to see if it makes a difference.

The fact that " setting the calculation mode to "average" or "nearest in
time" " makes a difference suggests that there may be more than one
transaction with a non-zero exchange rate and on different dates.

One other place to look is in the chart of accounts choose View > Filter by
> Other and check Show Hidden Accounts.  Then make sure the Commodity
column is shown and click on it two or three times to see if any account
has a currency other than his base currency.  If so, that would be the
place to look.

David C

On Wed, Apr 4, 2018 at 7:34 PM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> But the OP specifically said he doesn’t deal with stocks or any other
> investments. So there should be no such added prices. (and technically,
> those would be manual inputs via the transaction, just not via the Price
> Editor) As far as I’m aware, GnuCash doesn’t just grab prices from online
> without being told to in some fashion.
>
> Regards,
> Adrien
>
> > On Apr 4, 2018, at 3:55 PM, nvsoar  wrote:
> >
> > Hm.  Seems to me that a price is added to the system any time a
> stock is purchased or sold, or when a dividend is reinvested.
> > nvsoar
> >
> > On 04/04/18 09:32, Adrien Monteleone wrote:
> >> The value will usually change based on that setting. Sometimes ‘latest’
> and ’nearest in time’ will be the same, but that depends on running the
> report ON an actual day (not FOR an actual day) that is on or after a price
> update and before the next price update.
> >>
> >> First, you say you deleted all rates updated automatically by GC
> without you noticing. (does not happen, you have to open the price editor
> and tell it to ‘get quotes’) This leaves the presumption that there are
> other prices in the db that you either entered manually or intentionally
> updated with the ‘get quotes’ button.
> >>
> >> Then you say there are NO rates in the system.
> >>
> >> Which is it?
> >>
> >> If you open the Price Database is there anything at all listed in the
> window? (this includes a Currencies tree)
> >>
> >> Do you have ANY transactions where you purchased or entered an opening
> balance for a commodity or any currency other than the default book
> currency? (EUR)
> >>
> >> If you go to File > Properties, is ‘Use Trading Accounts’ checked?
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote:
> >>>
> >>> I suspect there is a bug that should be reported:
> >>>
> >>> As I do NOT manage currencies other than EUR and no traders accounts
> taking into account share values, I have deleted all exchanges rates that
> had been updated automatically by GC without my noticing.
> >>> BUT my Unrealized loss on a given day varies according to my setting
> the calculation mode to "average" or "nearest in time" for instance. It
> doesn's seem to make sense since there are NO exchange rates in my system.
> >>>
> >>> Ideas?
> >>> TIA
> >>> Alain
> >>>
> >>>
> >>>
> >>>
> >>> De: "sunfish62" 
> >>> À: cag...@free.fr, "John Ralls" 
> >>> Cc: "gnucash-user" 
> >>> Envoyé: Lundi 2 Avril 2018 14:52:46
> >>> Objet: Re: Unrealized loss
> >>>
> >>> Alain,
> >>>
> >>> Your new transaction is balanced, and won't affect the imbalance in
> another transaction.
> >>>
> >>> I personally find the unrealized gains issue to be exceedingly
> difficult to understand. Since you say you don't care about this, just
> ignore it.
> >>>
> >>> David T
> >>>
> >>>
> >>>
> >>>
> >>> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr
> >>>  wrote:
> >>>
> >>>
> >>>
> >>> De: [ mailto:cag...@free.fr | cag...@free.fr ]
> >>> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
> >>> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org |
> gnucash-user@gnucash.org ] >
> >>> Envoyé: Lundi 2 Avril 2018 13:51:03
> >>> Objet: Re: Unrealized loss
> >>>
> >>>
> >>>
> >>>
> >>> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ]
> >
> >>> À: [ mailto:cag...@free.fr | cag...@free.fr ]
> >>> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org |
> gnucash-user@gnucash.org ] >
> >>> Envoyé: Dimanche 1 Avril 2018 15:34:43
> >>> Objet: Re: Unrealized loss
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr |
> cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote:
> >>>
> >>>
> >>> Hello.
> >>>
> >>> I have have had an "unrealized loss" showing on my balance sheet for
> years. I haven't bothered too much as the amount is extremely small.
> (€7.70).
> >>>

Re: Error when editing Scheduled Transaction

[David Carlson]

Oh... I sometimes don't bother to put the curser back into another field
and hit Enter before clicking the OK box.  Usually, that does not matter
because it just triggers a cannot balance type of error which is easy to
override by clicking OK again.  Thanks for the help.

David C

On Wed, Apr 4, 2018 at 8:25 PM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> I was able to duplicate your issue but only if I didn’t enter through
> after deleting the copied memo. That is, leaving the extra split line there
> and hitting OK, produced the error. But when I hit enter after deleting the
> memo to ‘advance to the next transaction’ just like in a register, the
> extra split line disappears since it is empty, I then hit OK and there is
> no error.
>
> Regards,
> Adrien
>
> > On Apr 4, 2018, at 8:11 PM, David Carlson 
> wrote:
> >
> > It seems that the error happens if I copy some text from one of the
> existing three split memos and paste into the extra split memo box below
> the three existing split lines then delete that text without touching the
> other boxes in the extra split line before saving the scheduled transaction.
> >
> > I am fairly certain that I have used that extra memo field several times
> before when I wanted to swap memos between split lines in an SX.  If I
> added a split memo without a corresponding split account and left it there
> before saving I would expect a warning to enter an account, but not if I
> deleted the memo before trying to save the edit.  There is nothing visible
> to delete and I do not want to add an account for a non-existent memo.
> >
> > David C
> >
> > On Wed, Apr 4, 2018 at 7:43 PM, Adrien Monteleone <
> adrien.montele...@gmail.com> wrote:
> > Just curious, was the change that of changing one of the accounts?
> >
> > Have you tried either re-assigning the accounts or assigning them to
> something else (like Orphan or Imbalance if it will allow) saving, then
> changing them back?
> >
> > Are any of those accounts placeholders by chance? It might balk if so.
> >
> > I’ve encountered the error before a few times and each time I solved it
> by re-assigning and then changing it back. When I changed it back, I made
> sure not to type to search, but just scrolled through and selected.
> >
> > Regards,
> > Adrien
> >
> > > On Apr 4, 2018, at 6:45 PM, David Carlson 
> wrote:
> > >
> > > The Trace file error that I think matches is:
> > >
> > > * 17:30:21  CRIT  [gnc_split_register_get_trans_split()]
> bad
> > > row
> > > * 17:30:21  CRIT  gnucash_sheet_cursor_set_from_
> table:
> > > assertion 'gnucash_sheet_cell_valid (sheet, v_loc)' failed
> > >
> > > Where does the bad row come from if I only have three rows in this
> > > transaction?
> > >
> > >
> > > David C
> > > -- Forwarded message --
> > > From: David Carlson 
> > > Date: Wed, Apr 4, 2018 at 6:41 PM
> > > Subject: Error when editing Scheduled Transaction
> > > To: Gnucash Users 
> > >
> > >
> > > in Getdeb Release 2.6.17 in Ubuntu 16.04. The message popped up when I
> > > tried to save a change to a scheduled transaction and the wording
> > > is"Invalid Account in Split" "Split with memo has an invalid account"
> > >
> > > All three accounts in the transaction are existing but this message
> pops up
> > > when I try to save
> > >
> > > 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.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription 

Re: Register Font Size in Version 3

[Dave H]

George,

GnuCash is now using GTK3 so it's all changed - here's some info posted by
Geert a few days OK which might help you do what you want...

Cheers Dave H.


On 2018-03-31 08:37, Geert Janssens wrote:
>
> A more general note. I have done some experimentation about what can be
done
> to tweak the gnucash user interface in the absence of the Theme selector
we
> used to have for gnucash 2.x (that was removed from gtk for gtk3, not
> something gnucash had any say in).
>
> It turns out that apart from really starting to customize css settings
one can
> also install custom themes. It's still a bit of manual work but it's much
less
> complicated than looking for individual settings. What follows can be
used as
> a basis to document this on the gui tweak wiki page.
>
> Note this custom theme will affect all gtk3 based applications on your
system!
>
> Short summary:
> 1. Download an appropriate gtk3 theme from www.gnome-look.org
> 2. Install the theme in a directory where gtk3 looks for themes
> 3. create or adjust a settings.ini file to tell gtk3 to use this theme
>
> Slightly longer with platform dependent remarks:
>
>
> 1. Go to the gnome-look.org website
> 2. Click the "Gtk3 Themes" link (*not* the Gtk2 one)
> 3. Select a theme you like
> Alternatively you can search for keywords (like "dark") in the top right
> corner and then filter on "Gtk3 Theme category"
> 4. If you have found a theme you like, download the proper file (in the
files
> section of the theme page).
>
> Note depending on your operating system you may not be able to open all
theme
> files. I have seen for example .deb archives which are specifically
targeted
> at the Debian linux distribution and derivates such as Ubuntu. While
Ubuntu
> and Debian users can install those themes via their package manager these
> themes are not useful for other platforms.
> Theme files ending with .zip, .tar.gz or tar.xz are likely installable on
all
> platforms, although you may have to find a proper application to extract
them.
> On Windows 7-Zip is a good candiate,  linux users can probably extract the
> files directly from their file manager.
>
> So...
> Let's take the theme "Eye-friendly Dark RBC" as an example (it's not the
best
> theme but it can serve as an example). The file to download is
"Eye-friendly-
> Dark-RBC.tar.gz"
>
> 5. Extract this file using an appropriate tool. This  should give you a
> directory named "Eye-friendly-Dark-RBC"
>
> 6. Move this directory to a location on your system that's parsed by gtk.
This
> is platform dependent:
> - Linux: $HOME/.local/share/themes/
> - OS X: Here I'm not sure. Possibly
> $HOME/.local/share/themes/ (like on linux)
>   or  $HOME/Library/Application Support/themes/
>   I suspect the first unless one overrides the XDG_DATA_HOME environment
>   variable
> - Windows: %LOCALAPPDATA%\themes\
>
> 7. Next tell gtk to load this theme.
> Linux users can probably most easily do this by install the "Gnome Tweak
Tool"
> on their platform and select the new theme there.
>
> The manual method is this:
> Create a file named "settings.ini" in the appropriate location. Again this
> depends on your platform:
> - Linux: $HOME/.config/gtk-3.0/
> - OS X: Again I'm not sure. Possibly
> $HOME/.config/gtk-3.0/ (like on linux)
>   or  $HOME/Library/Application Support/Gnucash/config/gtk-3.0
>   I suspect the latter in this case because gnucash overrides the
>   XDG_CONFIG_HOME environment variable on OS X
> - Windows: %LOCALAPPDATA%\gtk-3.0\
>
> The contents of this file should be
>
> [Settings]
> gtk-theme-name=Eye-friendly-Dark-RBC
>
> And that's it. Note the name is the name of the directory as you put in
the
> themes directory.
>
> The next time you start gnucash it should pick up this theme.
>
> A few extra notes:
> * The default gtk3 theme is called "Adwaita"
> * On linux there's a second default theme called "Adwaita-dark" which
should
> also give you a dark themed gnucash. Unfortunately this doesn't work on
> Windows. I suppose it's not included or improperly configured there ? On
OS X
> I haven't tried this.
> * If you're adventurous you can probably also play with customized icon
themes
> which you find on the gnome-look.org website. These themes should be
installed
> in the icons directory next ot the themese directory. And to activate
them you
> can add gtk-icon-theme-name= in settings.ini.
> * Another setting some of you will be interested in is
> gtk-font-name=
> for example
> gtk-font-name=Abyssinica SIL Regular 10
> * More gtk settings one can override can be found here:
> https://developer.gnome.org/gtk3/stable/GtkSettings.html
>
> Regards,
>
> Geert
>
>

On 5 April 2018 at 08:23, GEORGE HAMMOND  wrote:

> Hello,
>
> I am using gnucash 3.0-1 on a 2011 iMac running OSX 10.13.4. I was
> previously using gnucash 2.6.7 on the same machine and OS .
> I Changed the font size in the register using the following code …
>
> style "font"
> {
>   font_name = "Sans 14"
> 

Re: gnucash 3.0 crashes opening accounts file

[John Ralls]

> On Apr 4, 2018, at 2:33 PM, Thevenin  wrote:
> 
> I've suffered the same today with my new install. It's never worked :)
> 
> My install is on Win10, and a redacted version of the trace log is below.
> 
> If you'd like me to post this to a new topic or elsewhere, let me know.
> 
> "* 16:00:17  INFO  [main] System locale returned English_United
> States.1252
> * 16:00:17  INFO  [main] Effective locale set to English_United
> States.1252.
> * 16:00:17  INFO  [gnc_load_app_icons] The icon theme search path
> has 10 elements.
> * 16:00:17  INFO  [gnc_load_app_icons] Path 0:
> C:\Users\krada\AppData\Local\icons
> * 16:00:17  INFO  [gnc_load_app_icons] Path 1:
> C:\Users\krada\.icons
> * 16:00:17  INFO  [gnc_load_app_icons] Path 2: c:\Program Files
> (x86)\gnucash/share\icons
> * 16:00:17  INFO  [gnc_load_app_icons] Path 3:
> /usr/local/share/icons
> * 16:00:17  INFO  [gnc_load_app_icons] Path 4: /usr/share/icons
> * 16:00:17  INFO  [gnc_load_app_icons] Path 5: c:\Program Files
> (x86)\gnucash/share\pixmaps
> * 16:00:17  INFO  [gnc_load_app_icons] Path 6:
> /usr/local/share/pixmaps
> * 16:00:17  INFO  [gnc_load_app_icons] Path 7: /usr/share/pixmaps
> * 16:00:17  INFO  [gnc_load_app_icons] Path 8: c:\Program Files
> (x86)\gnucash\share\gnucash\icons
> * 16:00:17  INFO  [gnc_load_app_icons] Path 9: c:\Program Files
> (x86)\gnucash\share\icons
> * 16:00:17  INFO  [gnc_hook_lookup] no hook lists
> * 16:00:17  INFO  [gnc_module_init_backend_dbi] GNC_DBD_DIR
> not set: using libdbi built-in default
> * 16:00:17  INFO  [gnc_module_init_backend_dbi] 3 DBD
> drivers found
> * 16:00:17  INFO  [gnc_module_init_backend_dbi] Driver:
> mysql
> * 16:00:17  INFO  [gnc_module_init_backend_dbi] Driver:
> pgsql
> * 16:00:17  INFO  [gnc_module_init_backend_dbi] Driver:
> sqlite3
> * 16:00:29 MESSG  Could not locate optional module
> gnucash/python interface v.0
> * 16:00:29 MESSG  loading system configuration
> * 16:00:29 MESSG  loading user configuration
> * 16:00:29 MESSG  loading saved reports
> * 16:00:29 MESSG  loading stylesheets
> * 16:00:34 MESSG  Found Finance::Quote version 1.47
> * 16:00:34  INFO  [xaccAccountRecomputeBalance] acct=Template
> Root starting baln=0/1
> 
> ...run through addition of currency values...
> 
> * 16:00:34  INFO  [QofSessionImpl::load_backend]  Selected
> provider GnuCash Libdbi (SQLITE3) Backend
> * 16:00:34  INFO  [QofDbiBackendProvider::type_check]
> exists, does not have SQLite format string -> not DBI
> * 16:00:34  INFO  [QofSessionImpl::load_backend] Provider,
> GnuCash Libdbi (SQLITE3) Backend, reported not being usable for book,
> file://G:\Gnu2018\GNU2018.gnucash.
> * 16:00:34  INFO  [QofSessionImpl::load_backend] The provider
> providers access_method, sqlite3, but we're loading for access_method, file.
> Skipping.
> * 16:00:34  INFO  [QofSessionImpl::load_backend] The provider
> providers access_method, mysql, but we're loading for access_method, file.
> Skipping.
> * 16:00:34  INFO  [QofSessionImpl::load_backend] The provider
> providers access_method, postgres, but we're loading for access_method,
> file. Skipping.
> * 16:00:34  INFO  [QofSessionImpl::load_backend] The provider
> providers access_method, xml, but we're loading for access_method, file.
> Skipping.
> * 16:00:34  INFO  [QofSessionImpl::load_backend]  Selected
> provider GnuCash File Backend Version 2
> * 16:00:34  INFO  [GncXmlBackend::session_begin]
> logpath=G:\Gnu2018\GNU2018.gnucash
> * 16:00:34  INFO  [QofSessionImpl::begin] Done running
> session_begin on backend
> * 16:01:40  INFO  [QofSessionImpl::load_backend]  Selected
> provider GnuCash Libdbi (SQLITE3) Backend
> * 16:01:40  INFO  [QofDbiBackendProvider::type_check]
> exists, does not have SQLite format string -> not DBI
> * 16:01:40  INFO  [QofSessionImpl::load_backend] Provider,
> GnuCash Libdbi (SQLITE3) Backend, reported not being usable for book,
> file://G:\Gnu2018\GNU2018.gnucash.
> * 16:01:40  INFO  [QofSessionImpl::load_backend] The provider
> providers access_method, sqlite3, but we're loading for access_method, file.
> Skipping.
> * 16:01:40  INFO  [QofSessionImpl::load_backend] The provider
> providers access_method, mysql, but we're loading for access_method, file.
> Skipping.
> * 16:01:40  INFO  [QofSessionImpl::load_backend] The provider
> providers access_method, postgres, but we're loading for access_method,
> file. Skipping.
> * 16:01:40  INFO  [QofSessionImpl::load_backend] The provider
> providers access_method, xml, but we're loading for access_method, file.
> Skipping.
> * 16:01:40  INFO  [QofSessionImpl::load_backend]  Selected
> provider GnuCash File Backend Version 2
> * 16:01:40  INFO  [GncXmlBackend::session_begin]
> logpath=G:\Gnu2018\GNU2018.gnucash
> * 16:01:40  INFO  [QofSessionImpl::begin] Done running
> session_begin on backend
> * 16:01:40  INFO  [xaccAccountRecomputeBalance] acct=Template
> Root starting baln=0/1
> 
> More commodity lines...
> 
> * 16:01:40  INFO  [QofSessionImpl::load] new 

Fwd: Error when editing Scheduled Transaction

[David Carlson]

The Trace file error that I think matches is:

* 17:30:21  CRIT  [gnc_split_register_get_trans_split()] bad
row
* 17:30:21  CRIT  gnucash_sheet_cursor_set_from_table:
assertion 'gnucash_sheet_cell_valid (sheet, v_loc)' failed

Where does the bad row come from if I only have three rows in this
transaction?


David C
-- Forwarded message --
From: David Carlson 
Date: Wed, Apr 4, 2018 at 6:41 PM
Subject: Error when editing Scheduled Transaction
To: Gnucash Users 


in Getdeb Release 2.6.17 in Ubuntu 16.04. The message popped up when I
tried to save a change to a scheduled transaction and the wording
is"Invalid Account in Split" "Split with memo has an invalid account"

All three accounts in the transaction are existing but this message pops up
when I try to save

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: Importing qfx files, version 3.0

[David Carlson]

As noted in the release notes that feature is known to not work per
https://bugzilla.gnome.org/show_bug.cgi?id=793461.

It is not known exactly when that will be fixed.

David C

On Wed, Apr 4, 2018 at 7:42 PM, Jim Poklitar  wrote:

> ​Until version 3.0, I could download and import .qfx transaction files from
> my bank for checking and savings ​accounts, as well as credit card
> transactions from several sources.  File->Import->Import OFX/QFX for any
> qfx suffixed files from any source worked flawlessly.
>
> With version 3.0, attempting to import any of these files yields a blank
> "Generic import transaction matcher" window.  I've looked at Tools->Import
> Map Editor, and see all my bank and credit card accounts in each of the
> Bayesian, Non-Bayesian, and Online ID radio-button tabs, but there doesn't
> seem to be any way to map a .qfx file.
>
> I have set up a couple csv mappings, but this seems to be a clumsy way of
> doing things, compared to the v 2.xx way of doing things.
>
> What am I missing?  How can I restore the ease of importing .qfx files in v
> 3.0?
> ___
> 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: GNUCash 3.0: Report Printing problems

[Adrien Monteleone]

I would think page size could most definitely affect breaks and flow of the 
document on the page. If there is less room for the content it has to flow to 
the next page. Though it is possible most reports are sized to at least A4, so 
you might not see any change and those using Letter would see different breaks, 
or if they are hardcoded, just more whitespace. I would also suspect font 
choice and size will affect this as well. (but if you’re copying to Excel, it 
won’t matter anyway)

I’m not a developer, so I can’t comment on the time-frame for direct printing 
issue. As for better reporting, it is sort of a cart-horse thing. There’s 
little point going through extensive effort to change the reporting mechanism 
until the app is a proper database which will allow for MUCH more flexible and 
customizable reports. This is why the devs have said it’s not on the top of the 
list. Top of the list is mostly behind the scenes changes to the base code so 
improvements like better reporting will be much easier to implement. They have 
a goal and a plan to get there, but reporting by necessity has to fall later in 
the scheme. (and if you understand the reporting mechanism, yes pun intended)

Note, there is a tool called Piecash which parses the XML that you can then use 
in custom reports. You could also save the file using the SQL or SQLite 
backends and query your data for reports. (just don’t write to the file without 
using the official API) There are also Python bindings available. Do a search 
for them here on the list, or check out the wiki ‘outside projects’. (or 
labeled something similar)

Regards,
Adrien

> On Apr 4, 2018, at 3:42 PM, Steve Parry  wrote:
> 
> Hi Adrien.
>  
> Thanks for your prompt replies to this and the subsequent comments from 
> others.
>  
> Re #3 (page size) - I'm not sure from my testing that this affects the PDF 
> output, maybe it's only the hysical printing formatting (when it is working 
> again!)?.
>  
> Regardless, it does seem that the copy and paste to excel may be the most 
> expedient way of formatting. I'm writing VBA Macros to auto format my common 
> reports. Thank you for the tip about copy and paste rather than go through 
> the HTML step
>  
> Re page numbers in the footer, I haven't found any variable for that, but as 
> I will now be going through Excel that's not required.
>  
> I suggest that financial reporting is a very high priority, and having that 
> as an integral function of GNUCash will be a huge timesaver globally amongst 
> your users
>  
> Thanks again for your guidance.
>  
> Cheers
> ...Steve
>  
>  
> -Original Message-
> From: gnucash-user  On 
> Behalf Of Adrien Monteleone
> Sent: Thursday, 5 April 2018 01:00
> To: GnuCash User List 
> Subject: Re: GNUCash 3.0: Report Printing problems
>  
> Welcome to GnuCash Steve!
>  
> I just caught up on a thread about W10 printing issues. It seems the problem 
> has indeed carried over to the 3.0 series. (and still exists in 2.6.x)
>  
> As long as you can then print that PDF, it’s an extra step, but you aren’t 
> locked out of printing.
>  
> Unfortunately, looking at your questions in 2-4, you might need an extra few 
> steps anyway.
>  
> There’s no need to export first, you can simply select-all and copy/paste 
> your report into Excel, and use that to format your printout with desired 
> page-breaks, paper size, and footer.
>  
> Directly to your #3 - Check in File > Page Setup. You can set paper size and 
> orientation there.
>  
> You can’t directly control page breaks, but you can change page orientation 
> and you can adjust font-size by editing the stylesheets or creating your own 
> stylesheet. However, you’ll likely have to alter this by trial and error and 
> then do so each time the report changes. (not very time efficient)
>  
> Likewise, you can customize the Footer stylesheet to your needs which will 
> allow you to print a footer on the page. There are some variables to use in 
> some places but I’m not sure if page-number and page-count are included in 
> these or if they’d even work in the footer. You might have to create a custom 
> report. (which would be even more trouble)
>  
> The easiest way to get all requirements is to copy/paste and format in Excel 
> as noted.
>  
> Please note, a proper reporting system is on the wish list, but it’s going to 
> be well down the road until after core parts of the app are rebuilt, 
> particularly, the transition to a true database app. Till then, we can always 
> use our favorite spreadsheet for custom and ‘pretty printing’.
>  
> Regards,
> Adrien
>  
> > On Apr 4, 2018, at 2:03 AM, Steve Parry  wrote:
> > 
> > Hi all,
> > 
> > GNUCash newbie here.
> > 
> > 
> > 
> > The problems I am having are: 
> > 
> > 1. I can only print to PDF – no option for real printer use. I 
> > understand this is a problem 

Re: Error when editing Scheduled Transaction

[Adrien Monteleone]

I was able to duplicate your issue but only if I didn’t enter through after 
deleting the copied memo. That is, leaving the extra split line there and 
hitting OK, produced the error. But when I hit enter after deleting the memo to 
‘advance to the next transaction’ just like in a register, the extra split line 
disappears since it is empty, I then hit OK and there is no error.

Regards,
Adrien

> On Apr 4, 2018, at 8:11 PM, David Carlson  wrote:
> 
> It seems that the error happens if I copy some text from one of the existing 
> three split memos and paste into the extra split memo box below the three 
> existing split lines then delete that text without touching the other boxes 
> in the extra split line before saving the scheduled transaction.
> 
> I am fairly certain that I have used that extra memo field several times 
> before when I wanted to swap memos between split lines in an SX.  If I added 
> a split memo without a corresponding split account and left it there before 
> saving I would expect a warning to enter an account, but not if I deleted the 
> memo before trying to save the edit.  There is nothing visible to delete and 
> I do not want to add an account for a non-existent memo.
> 
> David C
> 
> On Wed, Apr 4, 2018 at 7:43 PM, Adrien Monteleone 
>  wrote:
> Just curious, was the change that of changing one of the accounts?
> 
> Have you tried either re-assigning the accounts or assigning them to 
> something else (like Orphan or Imbalance if it will allow) saving, then 
> changing them back?
> 
> Are any of those accounts placeholders by chance? It might balk if so.
> 
> I’ve encountered the error before a few times and each time I solved it by 
> re-assigning and then changing it back. When I changed it back, I made sure 
> not to type to search, but just scrolled through and selected.
> 
> Regards,
> Adrien
> 
> > On Apr 4, 2018, at 6:45 PM, David Carlson  
> > wrote:
> >
> > The Trace file error that I think matches is:
> >
> > * 17:30:21  CRIT  [gnc_split_register_get_trans_split()] bad
> > row
> > * 17:30:21  CRIT  gnucash_sheet_cursor_set_from_table:
> > assertion 'gnucash_sheet_cell_valid (sheet, v_loc)' failed
> >
> > Where does the bad row come from if I only have three rows in this
> > transaction?
> >
> >
> > David C
> > -- Forwarded message --
> > From: David Carlson 
> > Date: Wed, Apr 4, 2018 at 6:41 PM
> > Subject: Error when editing Scheduled Transaction
> > To: Gnucash Users 
> >
> >
> > in Getdeb Release 2.6.17 in Ubuntu 16.04. The message popped up when I
> > tried to save a change to a scheduled transaction and the wording
> > is"Invalid Account in Split" "Split with memo has an invalid account"
> >
> > All three accounts in the transaction are existing but this message pops up
> > when I try to save
> >
> > 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.
> 
> ___
> 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.

Register Font Size in Version 3

[GEORGE HAMMOND]

Hello,

I am using gnucash 3.0-1 on a 2011 iMac running OSX 10.13.4. I was previously 
using gnucash 2.6.7 on the same machine and OS .
I Changed the font size in the register using the following code …

style "font"
{
  font_name = "Sans 14"
}
widget_class "*" style "font"
gtk-font-name = "Sans 14”

And saved it to a file named .gtkrc-2.0.gnucash which was placed in my home 
directory. It worked fine in the previous version, but now does not work with 
version 3.0 of gnucash.

This code and file name were from the gnu cash FAQ on the gnucash site. 

Thanks in advance for your help.


GEORGE HAMMOND
geh...@icloud.com



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

Error when editing Scheduled Transaction

[David Carlson]

 in Getdeb Release 2.6.17 in Ubuntu 16.04. The message popped up when I
tried to save a change to a scheduled transaction and the wording
is"Invalid Account in Split" "Split with memo has an invalid account"

All three accounts in the transaction are existing but this message pops up
when I try to save

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: Unrealized loss

[Adrien Monteleone]

But the OP specifically said he doesn’t deal with stocks or any other 
investments. So there should be no such added prices. (and technically, those 
would be manual inputs via the transaction, just not via the Price Editor) As 
far as I’m aware, GnuCash doesn’t just grab prices from online without being 
told to in some fashion.

Regards,
Adrien

> On Apr 4, 2018, at 3:55 PM, nvsoar  wrote:
> 
> Hm.  Seems to me that a price is added to the system any time a stock is 
> purchased or sold, or when a dividend is reinvested.
> nvsoar
> 
> On 04/04/18 09:32, Adrien Monteleone wrote:
>> The value will usually change based on that setting. Sometimes ‘latest’ and 
>> ’nearest in time’ will be the same, but that depends on running the report 
>> ON an actual day (not FOR an actual day) that is on or after a price update 
>> and before the next price update.
>> 
>> First, you say you deleted all rates updated automatically by GC without you 
>> noticing. (does not happen, you have to open the price editor and tell it to 
>> ‘get quotes’) This leaves the presumption that there are other prices in the 
>> db that you either entered manually or intentionally updated with the ‘get 
>> quotes’ button.
>> 
>> Then you say there are NO rates in the system.
>> 
>> Which is it?
>> 
>> If you open the Price Database is there anything at all listed in the 
>> window? (this includes a Currencies tree)
>> 
>> Do you have ANY transactions where you purchased or entered an opening 
>> balance for a commodity or any currency other than the default book 
>> currency? (EUR)
>> 
>> If you go to File > Properties, is ‘Use Trading Accounts’ checked?
>> 
>> Regards,
>> Adrien
>> 
>>> On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote:
>>> 
>>> I suspect there is a bug that should be reported:
>>> 
>>> As I do NOT manage currencies other than EUR and no traders accounts taking 
>>> into account share values, I have deleted all exchanges rates that had been 
>>> updated automatically by GC without my noticing.
>>> BUT my Unrealized loss on a given day varies according to my setting the 
>>> calculation mode to "average" or "nearest in time" for instance. It doesn's 
>>> seem to make sense since there are NO exchange rates in my system.
>>> 
>>> Ideas?
>>> TIA
>>> Alain
>>> 
>>> 
>>> 
>>> 
>>> De: "sunfish62" 
>>> À: cag...@free.fr, "John Ralls" 
>>> Cc: "gnucash-user" 
>>> Envoyé: Lundi 2 Avril 2018 14:52:46
>>> Objet: Re: Unrealized loss
>>> 
>>> Alain,
>>> 
>>> Your new transaction is balanced, and won't affect the imbalance in another 
>>> transaction.
>>> 
>>> I personally find the unrealized gains issue to be exceedingly difficult to 
>>> understand. Since you say you don't care about this, just ignore it.
>>> 
>>> David T
>>> 
>>> 
>>> 
>>> 
>>> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr
>>>  wrote:
>>> 
>>> 
>>> 
>>> De: [ mailto:cag...@free.fr | cag...@free.fr ]
>>> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
>>> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
>>> gnucash-user@gnucash.org ] >
>>> Envoyé: Lundi 2 Avril 2018 13:51:03
>>> Objet: Re: Unrealized loss
>>> 
>>> 
>>> 
>>> 
>>> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
>>> À: [ mailto:cag...@free.fr | cag...@free.fr ]
>>> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
>>> gnucash-user@gnucash.org ] >
>>> Envoyé: Dimanche 1 Avril 2018 15:34:43
>>> Objet: Re: Unrealized loss
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | 
>>> cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote:
>>> 
>>> 
>>> Hello.
>>> 
>>> I have have had an "unrealized loss" showing on my balance sheet for years. 
>>> I haven't bothered too much as the amount is extremely small. (€7.70).
>>> 
>>> I had kind advice on this forum as to identify the date on which the loss 
>>> showed up and the procedure to cancel it. I did find the date but stangely 
>>> not the transaction. So I'm not going to keep trying to cancel the loss any 
>>> longer.
>>> 
>>> I read that, without actually "cancelling" the loss, it is possible to 
>>> prevent it from showing. I know that this is not legal for a company, but 
>>> my book keeping is fully personal so I'd like to know the procedure.
>>> 
>>> 
>>> 
>>> 
>>> “Cancelling” isn’t really the right term. You need to record the loss as 
>>> either expense or negative income depending on how you handle capital 
>>> gains. There’s an explanation of how to do this in [ [ 
>>> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
>>> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] | [ 
>>> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
>>> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] .
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>> 
>>> I 

Re: Unrealized loss

[David T.]

Adrien, 
Gnucash places an entry in the price db when you create a buy or sell 
transaction.  This ensures that certain reports behave, I recall. 
As this issue has been discussed previously and at length, I would hesitate to 
file a bug until the experts weigh in on the esoteric aspects of unrealized 
gains in gnucash.  Currently, those experts are putting out bigger fires. 
David

 
 
  On Thu, Apr 5, 2018 at 5:35, Adrien Monteleone 
wrote:   But the OP specifically said he doesn’t deal with stocks or any other 
investments. So there should be no such added prices. (and technically, those 
would be manual inputs via the transaction, just not via the Price Editor) As 
far as I’m aware, GnuCash doesn’t just grab prices from online without being 
told to in some fashion.

Regards,
Adrien

> On Apr 4, 2018, at 3:55 PM, nvsoar  wrote:
> 
> Hm.  Seems to me that a price is added to the system any time a stock is 
> purchased or sold, or when a dividend is reinvested.
> nvsoar
> 
> On 04/04/18 09:32, Adrien Monteleone wrote:
>> The value will usually change based on that setting. Sometimes ‘latest’ and 
>> ’nearest in time’ will be the same, but that depends on running the report 
>> ON an actual day (not FOR an actual day) that is on or after a price update 
>> and before the next price update.
>> 
>> First, you say you deleted all rates updated automatically by GC without you 
>> noticing. (does not happen, you have to open the price editor and tell it to 
>> ‘get quotes’) This leaves the presumption that there are other prices in the 
>> db that you either entered manually or intentionally updated with the ‘get 
>> quotes’ button.
>> 
>> Then you say there are NO rates in the system.
>> 
>> Which is it?
>> 
>> If you open the Price Database is there anything at all listed in the 
>> window? (this includes a Currencies tree)
>> 
>> Do you have ANY transactions where you purchased or entered an opening 
>> balance for a commodity or any currency other than the default book 
>> currency? (EUR)
>> 
>> If you go to File > Properties, is ‘Use Trading Accounts’ checked?
>> 
>> Regards,
>> Adrien
>> 
>>> On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote:
>>> 
>>> I suspect there is a bug that should be reported:
>>> 
>>> As I do NOT manage currencies other than EUR and no traders accounts taking 
>>> into account share values, I have deleted all exchanges rates that had been 
>>> updated automatically by GC without my noticing.
>>> BUT my Unrealized loss on a given day varies according to my setting the 
>>> calculation mode to "average" or "nearest in time" for instance. It doesn's 
>>> seem to make sense since there are NO exchange rates in my system.
>>> 
>>> Ideas?
>>> TIA
>>> Alain
>>> 
>>> 
>>> 
>>> 
>>> De: "sunfish62" 
>>> À: cag...@free.fr, "John Ralls" 
>>> Cc: "gnucash-user" 
>>> Envoyé: Lundi 2 Avril 2018 14:52:46
>>> Objet: Re: Unrealized loss
>>> 
>>> Alain,
>>> 
>>> Your new transaction is balanced, and won't affect the imbalance in another 
>>> transaction.
>>> 
>>> I personally find the unrealized gains issue to be exceedingly difficult to 
>>> understand. Since you say you don't care about this, just ignore it.
>>> 
>>> David T
>>> 
>>> 
>>> 
>>> 
>>> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr
>>>  wrote:
>>> 
>>> 
>>> 
>>> De: [ mailto:cag...@free.fr | cag...@free.fr ]
>>> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
>>> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
>>> gnucash-user@gnucash.org ] >
>>> Envoyé: Lundi 2 Avril 2018 13:51:03
>>> Objet: Re: Unrealized loss
>>> 
>>> 
>>> 
>>> 
>>> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
>>> À: [ mailto:cag...@free.fr | cag...@free.fr ]
>>> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
>>> gnucash-user@gnucash.org ] >
>>> Envoyé: Dimanche 1 Avril 2018 15:34:43
>>> Objet: Re: Unrealized loss
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | 
>>> cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote:
>>> 
>>> 
>>> Hello.
>>> 
>>> I have have had an "unrealized loss" showing on my balance sheet for years. 
>>> I haven't bothered too much as the amount is extremely small. (€7.70).
>>> 
>>> I had kind advice on this forum as to identify the date on which the loss 
>>> showed up and the procedure to cancel it. I did find the date but stangely 
>>> not the transaction. So I'm not going to keep trying to cancel the loss any 
>>> longer.
>>> 
>>> I read that, without actually "cancelling" the loss, it is possible to 
>>> prevent it from showing. I know that this is not legal for a company, but 
>>> my book keeping is fully personal so I'd like to know the procedure.
>>> 
>>> 
>>> 
>>> 
>>> “Cancelling” isn’t really the right term. You need to record the loss as 
>>> either expense or 

Re: Error when editing Scheduled Transaction

[David Carlson]

It seems that the error happens if I copy some text from one of the
existing three split memos and paste into the extra split memo box below
the three existing split lines then delete that text without touching the
other boxes in the extra split line before saving the scheduled transaction.

I am fairly certain that I have used that extra memo field several times
before when I wanted to swap memos between split lines in an SX.  If I
added a split memo without a corresponding split account and left it there
before saving I would expect a warning to enter an account, but not if I
deleted the memo before trying to save the edit.  There is nothing visible
to delete and I do not want to add an account for a non-existent memo.

David C

On Wed, Apr 4, 2018 at 7:43 PM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> Just curious, was the change that of changing one of the accounts?
>
> Have you tried either re-assigning the accounts or assigning them to
> something else (like Orphan or Imbalance if it will allow) saving, then
> changing them back?
>
> Are any of those accounts placeholders by chance? It might balk if so.
>
> I’ve encountered the error before a few times and each time I solved it by
> re-assigning and then changing it back. When I changed it back, I made sure
> not to type to search, but just scrolled through and selected.
>
> Regards,
> Adrien
>
> > On Apr 4, 2018, at 6:45 PM, David Carlson 
> wrote:
> >
> > The Trace file error that I think matches is:
> >
> > * 17:30:21  CRIT  [gnc_split_register_get_trans_split()] bad
> > row
> > * 17:30:21  CRIT  gnucash_sheet_cursor_set_from_
> table:
> > assertion 'gnucash_sheet_cell_valid (sheet, v_loc)' failed
> >
> > Where does the bad row come from if I only have three rows in this
> > transaction?
> >
> >
> > David C
> > -- Forwarded message --
> > From: David Carlson 
> > Date: Wed, Apr 4, 2018 at 6:41 PM
> > Subject: Error when editing Scheduled Transaction
> > To: Gnucash Users 
> >
> >
> > in Getdeb Release 2.6.17 in Ubuntu 16.04. The message popped up when I
> > tried to save a change to a scheduled transaction and the wording
> > is"Invalid Account in Split" "Split with memo has an invalid account"
> >
> > All three accounts in the transaction are existing but this message pops
> up
> > when I try to save
> >
> > 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.
>
> ___
> 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: Importing qfx files, version 3.0

[Jim Poklitar]

Thanks David - bummer.

Back to 2.6.19.

Jim P

On Wed, Apr 4, 2018 at 8:44 PM, David Carlson 
wrote:

> As noted in the release notes that feature is known to not work per
> https://bugzilla.gnome.org/show_bug.cgi?id=793461.
>
> It is not known exactly when that will be fixed.
>
> David C
>
> On Wed, Apr 4, 2018 at 7:42 PM, Jim Poklitar 
> wrote:
>
>> ​Until version 3.0, I could download and import .qfx transaction files
>> from
>> my bank for checking and savings ​accounts, as well as credit card
>> transactions from several sources.  File->Import->Import OFX/QFX for any
>> qfx suffixed files from any source worked flawlessly.
>>
>> With version 3.0, attempting to import any of these files yields a blank
>> "Generic import transaction matcher" window.  I've looked at Tools->Import
>> Map Editor, and see all my bank and credit card accounts in each of the
>> Bayesian, Non-Bayesian, and Online ID radio-button tabs, but there doesn't
>> seem to be any way to map a .qfx file.
>>
>> I have set up a couple csv mappings, but this seems to be a clumsy way of
>> doing things, compared to the v 2.xx way of doing things.
>>
>> What am I missing?  How can I restore the ease of importing .qfx files in
>> v
>> 3.0?
>> ___
>> 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 3.0 Build error

[DaveC49]

After following the build instructions 
https://wiki.gnucash.org/wiki/Building#Ubuntu
  
I have checked glib-2.0 and libglib2.0 are installed

I received the following errors when building using cmake (v 3.5.1) on Linux
MInt 18.3 :

/$ cmake -D CMAKE_INSTALL_PREFIX=/usr/local/bin/gnucash-cmake -D
WITH_AQBANKING=OFF -D WITH_OFX=ON ../gnucash
CMake Error at CMakeLists.txt:5 (file):
  file problem creating directory: /glib-2.0/schemas


-- Performing Test have_mod_mask
-- Performing Test have_mod_mask - Failed
CMake Error at gnome/CMakeLists.txt:59 (gnc_add_swig_guile_command):
  Unknown CMake command "gnc_add_swig_guile_command".


CMake Warning (dev) in CMakeLists.txt:
  No cmake_minimum_required command is present.  A line of code such as

cmake_minimum_required(VERSION 3.5)

  should be added at the top of the file.  The version specified may be
lower
  if you wish to support older CMake versions for this project.  For more
  information run "cmake --help-policy CMP".
This warning is for project developers.  Use -Wno-dev to suppress it.

-- Configuring incomplete, errors occurred!
See also
"/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeOutput.log".
See also
"/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeError.log"./

Any ideas?




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

Setting Environmental Variable AQOFX_LOG_COMM

[Shyam Acharya]

Hi

I tried setting environmental variable AQOFX_LOG_COMM to 1 to debug a 
connection problem. However, I am unable to generate an ofx.log. I am using 
Windows 10. Two questions:

  1.  In addition to setting the AQOFX_LOG_COM value to 1 is there anything 
else that needs to be done? (ie setting path)
  2.  Where does GNUCash generate the file? Can I create a tmp directory in the 
desktop? If yes how do i point GnuCash to this directory.

Thanks!
___
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: Texhad an issue compiling for PCLinuxos....

[Steve Kelem]

Install the -dev version of that library.

Steve

On Tue, Apr 3, 2018, 7:09 AM Doug  wrote:

>
> Offline Tex
>
> Administrator
> Super Villain
> **
> Posts: 18933
> Space City, Tx
> View Profile Personal Message (Offline)
>
> Re: GnuCash
> « Reply #2 on: Today at 01:28:20 AM »
>
> Quote
>
> I've spent hours on this and this is what it gives me even though the
> library is installed in /usr/lib64/gnucash. I'm tired of it for now.
>
> [tex@localhost SPECS]$ gnucash
> gnucash: error while loading shared libraries: libgncmod-gnome-utils.so:
> cannot open shared object file: No such file or directory
> (end)
>
> Can anyone help me point Tex in the right direction please? (I will
> forward it to PCLibuxOS)
>
> regards, Doug (not a developer! merely an intermediary...)
> ___
> 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: Gnucash 3.0 Build error

[DaveC49]

The CMake error log for the above is

/$ cat
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeError.log
Performing C SOURCE FILE Test have_mod_mask failed with the following
output:
Change Dir:
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp

Run Build Command:"/usr/bin/make" "cmTC_549d5/fast"
/usr/bin/make -f CMakeFiles/cmTC_549d5.dir/build.make
CMakeFiles/cmTC_549d5.dir/build
make[1]: Entering directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Building C object CMakeFiles/cmTC_549d5.dir/src.c.o
/usr/bin/cc-Dhave_mod_mask   -o CMakeFiles/cmTC_549d5.dir/src.c.o   -c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c:2:21:
fatal error: gdk/gdk.h: No such file or directory
compilation terminated.
CMakeFiles/cmTC_549d5.dir/build.make:65: recipe for target
'CMakeFiles/cmTC_549d5.dir/src.c.o' failed
make[1]: *** [CMakeFiles/cmTC_549d5.dir/src.c.o] Error 1
make[1]: Leaving directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Makefile:126: recipe for target 'cmTC_549d5/fast' failed
make: *** [cmTC_549d5/fast] Error 2

Source file was:

#include 

int main (int argc, char** argv) {
  GdkModifierIntent foo = GDK_MODIFIER_INTENT_DEFAULT_MOD_MASK;
  return 0;
}

Performing C SOURCE FILE Test have_mod_mask failed with the following
output:
Change Dir:
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp

Run Build Command:"/usr/bin/make" "cmTC_a95b6/fast"
/usr/bin/make -f CMakeFiles/cmTC_a95b6.dir/build.make
CMakeFiles/cmTC_a95b6.dir/build
make[1]: Entering directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Building C object CMakeFiles/cmTC_a95b6.dir/src.c.o
/usr/bin/cc-Dhave_mod_mask   -o CMakeFiles/cmTC_a95b6.dir/src.c.o   -c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c:2:21:
fatal error: gdk/gdk.h: No such file or directory
compilation terminated.
CMakeFiles/cmTC_a95b6.dir/build.make:65: recipe for target
'CMakeFiles/cmTC_a95b6.dir/src.c.o' failed
make[1]: *** [CMakeFiles/cmTC_a95b6.dir/src.c.o] Error 1
make[1]: Leaving directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Makefile:126: recipe for target 'cmTC_a95b6/fast' failed
make: *** [cmTC_a95b6/fast] Error 2

Source file was:

#include 

int main (int argc, char** argv) {
  GdkModifierIntent foo = GDK_MODIFIER_INTENT_DEFAULT_MOD_MASK;
  return 0;
}

Performing C SOURCE FILE Test have_mod_mask failed with the following
output:
Change Dir:
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp

Run Build Command:"/usr/bin/make" "cmTC_27cdf/fast"
/usr/bin/make -f CMakeFiles/cmTC_27cdf.dir/build.make
CMakeFiles/cmTC_27cdf.dir/build
make[1]: Entering directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Building C object CMakeFiles/cmTC_27cdf.dir/src.c.o
/usr/bin/cc-Dhave_mod_mask   -o CMakeFiles/cmTC_27cdf.dir/src.c.o   -c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c:2:21:
fatal error: gdk/gdk.h: No such file or directory
compilation terminated.
CMakeFiles/cmTC_27cdf.dir/build.make:65: recipe for target
'CMakeFiles/cmTC_27cdf.dir/src.c.o' failed
make[1]: *** [CMakeFiles/cmTC_27cdf.dir/src.c.o] Error 1
make[1]: Leaving directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Makefile:126: recipe for target 'cmTC_27cdf/fast' failed
make: *** [cmTC_27cdf/fast] Error 2

Source file was:

#include 

int main (int argc, char** argv) {
  GdkModifierIntent foo = GDK_MODIFIER_INTENT_DEFAULT_MOD_MASK;
  return 0;
}
/



-
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: GnuCash 3.0 Released

[DaveC49]

Also congratulations to John Geert and the rest of the team and thanks for
all the effort.

David



-
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: Gnucash 3.0 Build error

[DaveC49]

*$ cat
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeError.log*
Performing C SOURCE FILE Test have_mod_mask failed with the following
output:
Change Dir:
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp

Run Build Command:"/usr/bin/make" "cmTC_549d5/fast"
/usr/bin/make -f CMakeFiles/cmTC_549d5.dir/build.make
CMakeFiles/cmTC_549d5.dir/build
make[1]: Entering directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Building C object CMakeFiles/cmTC_549d5.dir/src.c.o
/usr/bin/cc-Dhave_mod_mask   -o CMakeFiles/cmTC_549d5.dir/src.c.o   -c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c:2:21:
fatal error: gdk/gdk.h: No such file or directory
compilation terminated.
CMakeFiles/cmTC_549d5.dir/build.make:65: recipe for target
'CMakeFiles/cmTC_549d5.dir/src.c.o' failed
make[1]: *** [CMakeFiles/cmTC_549d5.dir/src.c.o] Error 1
make[1]: Leaving directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Makefile:126: recipe for target 'cmTC_549d5/fast' failed
make: *** [cmTC_549d5/fast] Error 2

Source file was:

#include 

int main (int argc, char** argv) {
  GdkModifierIntent foo = GDK_MODIFIER_INTENT_DEFAULT_MOD_MASK;
  return 0;
}

Performing C SOURCE FILE Test have_mod_mask failed with the following
output:
Change Dir:
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp

Run Build Command:"/usr/bin/make" "cmTC_a95b6/fast"
/usr/bin/make -f CMakeFiles/cmTC_a95b6.dir/build.make
CMakeFiles/cmTC_a95b6.dir/build
make[1]: Entering directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Building C object CMakeFiles/cmTC_a95b6.dir/src.c.o
/usr/bin/cc-Dhave_mod_mask   -o CMakeFiles/cmTC_a95b6.dir/src.c.o   -c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c:2:21:
fatal error: gdk/gdk.h: No such file or directory
compilation terminated.
CMakeFiles/cmTC_a95b6.dir/build.make:65: recipe for target
'CMakeFiles/cmTC_a95b6.dir/src.c.o' failed
make[1]: *** [CMakeFiles/cmTC_a95b6.dir/src.c.o] Error 1
make[1]: Leaving directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Makefile:126: recipe for target 'cmTC_a95b6/fast' failed
make: *** [cmTC_a95b6/fast] Error 2

Source file was:

#include 

int main (int argc, char** argv) {
  GdkModifierIntent foo = GDK_MODIFIER_INTENT_DEFAULT_MOD_MASK;
  return 0;
}

Performing C SOURCE FILE Test have_mod_mask failed with the following
output:
Change Dir:
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp

Run Build Command:"/usr/bin/make" "cmTC_27cdf/fast"
/usr/bin/make -f CMakeFiles/cmTC_27cdf.dir/build.make
CMakeFiles/cmTC_27cdf.dir/build
make[1]: Entering directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Building C object CMakeFiles/cmTC_27cdf.dir/src.c.o
/usr/bin/cc-Dhave_mod_mask   -o CMakeFiles/cmTC_27cdf.dir/src.c.o   -c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c
/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp/src.c:2:21:
fatal error: gdk/gdk.h: No such file or directory
compilation terminated.
CMakeFiles/cmTC_27cdf.dir/build.make:65: recipe for target
'CMakeFiles/cmTC_27cdf.dir/src.c.o' failed
make[1]: *** [CMakeFiles/cmTC_27cdf.dir/src.c.o] Error 1
make[1]: Leaving directory
'/home/david/Applications/gnucash-3.0/build-cmake/CMakeFiles/CMakeTmp'
Makefile:126: recipe for target 'cmTC_27cdf/fast' failed
make: *** [cmTC_27cdf/fast] Error 2

Source file was:

#include 

int main (int argc, char** argv) {
  GdkModifierIntent foo = GDK_MODIFIER_INTENT_DEFAULT_MOD_MASK;
  return 0;
}





-
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: Unrealized loss

[Adrien Monteleone]

I certainly didn’t advocate filing a bug on this. I think more sleuthing and 
answers are needed.

Yes, I understand the db gets an entry on a buy/sell transaction, but if you 
don’t have buy or sell transactions?...

And to be clear, those aren’t ‘automatically downloaded.’ They are the result 
of the transaction math.(perhaps the OP wasn’t expecting them to appear, but 
they really have to if the account is to be kept correct and reports work out 
properly, as you noted) We’re not talking about GC downloading new prices each 
day/month/week without being told to do so.

I’m at a loss with this thread because the OP hasn’t made clear that there 
aren’t any buy/sell transactions of anything. They claim they don’t use any 
currency other than EUR and don’t track stocks. The trading accounts could 
still be enabled, and a commodity added to the assets. And if this occurred on 
more than one date, well, then certainly, there will be more than one price in 
the db.(each one generated by GC as a result of the transaction)

But the OP has been silent on these questions, so it’s probably best to wait 
till he chimes back in to continue the guessing any further.

What we don’t know is:

Is he seeing this unrealized gain/loss without ANY prices AT ALL in the db? And 
without ANY other currencies other than the default book currency in play?(EUR) 
And without ANY assets denominated in ANYTHING but EUR? And without ANY stocks, 
funds, et cetera?

Until all of those answers are ‘yes’ I don’t think there’s a bug at all, but 
rather, either a transaction that is hard to find, or a user misunderstanding.

Regards,
Adrien

> On Apr 4, 2018, at 10:28 PM, David T.  wrote:
> 
> Adrien, 
> 
> Gnucash places an entry in the price db when you create a buy or sell 
> transaction.  This ensures that certain reports behave, I recall. 
> 
> As this issue has been discussed previously and at length, I would hesitate 
> to file a bug until the experts weigh in on the esoteric aspects of 
> unrealized gains in gnucash.  Currently, those experts are putting out bigger 
> fires. 
> 
> David
> 
> 
> On Thu, Apr 5, 2018 at 5:35, Adrien Monteleone
>  wrote:
> But the OP specifically said he doesn’t deal with stocks or any other 
> investments. So there should be no such added prices. (and technically, those 
> would be manual inputs via the transaction, just not via the Price Editor) As 
> far as I’m aware, GnuCash doesn’t just grab prices from online without being 
> told to in some fashion.
> 
> Regards,
> Adrien
> 
> > On Apr 4, 2018, at 3:55 PM, nvsoar  wrote:
> > 
> > Hm.  Seems to me that a price is added to the system any time a stock 
> > is purchased or sold, or when a dividend is reinvested.
> > nvsoar
> > 
> > On 04/04/18 09:32, Adrien Monteleone wrote:
> >> The value will usually change based on that setting. Sometimes ‘latest’ 
> >> and ’nearest in time’ will be the same, but that depends on running the 
> >> report ON an actual day (not FOR an actual day) that is on or after a 
> >> price update and before the next price update.
> >> 
> >> First, you say you deleted all rates updated automatically by GC without 
> >> you noticing. (does not happen, you have to open the price editor and tell 
> >> it to ‘get quotes’) This leaves the presumption that there are other 
> >> prices in the db that you either entered manually or intentionally updated 
> >> with the ‘get quotes’ button.
> >> 
> >> Then you say there are NO rates in the system.
> >> 
> >> Which is it?
> >> 
> >> If you open the Price Database is there anything at all listed in the 
> >> window? (this includes a Currencies tree)
> >> 
> >> Do you have ANY transactions where you purchased or entered an opening 
> >> balance for a commodity or any currency other than the default book 
> >> currency? (EUR)
> >> 
> >> If you go to File > Properties, is ‘Use Trading Accounts’ checked?
> >> 
> >> Regards,
> >> Adrien
> >> 
> >>> On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote:
> >>> 
> >>> I suspect there is a bug that should be reported:
> >>> 
> >>> As I do NOT manage currencies other than EUR and no traders accounts 
> >>> taking into account share values, I have deleted all exchanges rates that 
> >>> had been updated automatically by GC without my noticing.
> >>> BUT my Unrealized loss on a given day varies according to my setting the 
> >>> calculation mode to "average" or "nearest in time" for instance. It 
> >>> doesn's seem to make sense since there are NO exchange rates in my system.
> >>> 
> >>> Ideas?
> >>> TIA
> >>> Alain
> >>> 
> >>> 
> >>> 
> >>> 
> >>> De: "sunfish62" 
> >>> À: cag...@free.fr, "John Ralls" 
> >>> Cc: "gnucash-user" 
> >>> Envoyé: Lundi 2 Avril 2018 14:52:46
> >>> Objet: Re: Unrealized loss
> >>> 
> >>> Alain,
> >>> 
> >>> Your new transaction is balanced, and won't affect the imbalance in 
> >>> 

Re: Price Editor/Database lag

[DGPickett via gnucash-user]

I discovered my vm.swappiness=60, dropped it to 10 as recommended for desktop
LINUX.  Now no si/so on vmstat, but a peak in cs and a moderate delay,
around 20 seconds, when adding price quotes.

Again, it looks like it is using too big a RAM space to manage this data, or
some similar process inefficiency.  I would think a properly keyed tree
container would be good, allowing you to look up a symbol and then pull the
tree in key order from that point.  Perhaps it force-saves after every
modification?



--
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: Setting Environmental Variable AQOFX_LOG_COMM

[John Ralls]

> On Apr 4, 2018, at 3:34 AM, Shyam Acharya  wrote:
> 
> Hi
> 
> I tried setting environmental variable AQOFX_LOG_COMM to 1 to debug a 
> connection problem. However, I am unable to generate an ofx.log. I am using 
> Windows 10. Two questions:
> 
>  1.  In addition to setting the AQOFX_LOG_COM value to 1 is there anything 
> else that needs to be done? (ie setting path)
>  2.  Where does GNUCash generate the file? Can I create a tmp directory in 
> the desktop? If yes how do i point GnuCash to this directory.

That’s AQBanking stuff, so you might try their mailing lists. In general 
Windows puts logs in the user’s AppData/Local or AppData/Roaming depending on 
which way the user id is configured.

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: 2.6.19 crash: one account recovered, one not yet recovered [RESOLVED]

[John Ralls]

> On Apr 4, 2018, at 5:53 AM, Rich Shepard  wrote:
> 
> On Tue, 3 Apr 2018, John Ralls wrote:
> 
>> Does business.gnucash use the SQLite3 backend? If so, that would explain
>> the absence of backups, and I suggest you set up some OS-level backup
>> mechanism for it.
> 
> John,
> 
>  I use the default backend; 'file' shows it as a compressed Unix file;
> perhaps gzipped xml?
> 
>  Every midnight cron runs dirvish for incremental backups.
> 
>  What's interesting is since I loaded the business.gnucash file yesterday
> and everything displayed as it should, the list of files in the business
> subdirectory includes business.gnucash (which opens the current state of
> that account) as well as several .gnucash and .log files from yesterday's
> activities. For example, business.gnucash.20180403104944.gnucash and
> business.gnucash.20180403104944.log. So, the business account works as
> expected.
> 
>  On the other hand, the personal account can be loaded by specifying only a
> 'personal.gnucash.*.gnucash' file. When I open personal.gnucash I get an
> empty display with no CoA or anything else. Specifically, the recently
> opened file list shows 'personal.gnucash.20180403092939.gnucash'.
> 
>  I suspect that I can rename one of the datetime stamped files to
> personal.gnucash, and clean up that subdirectory. I would appreciate your
> thoughts on this.
> 
>  Having just opened gnucash, and shut it down, these are the files in the
> personal/ subdirectory:
> 
> gnucash-coa.gnucash
> personal.gnucash
> personal.gnucash.20180402112722.log
> personal.gnucash.20180402112803.log
> personal.gnucash.20180402112813.gnucash
> personal.gnucash.20180402112813.log
> personal.gnucash.20180403092537.log
> personal.gnucash.20180403092537.log.gnucash
> personal.gnucash.20180403092537.log.gnucash.20180403092911.log
> personal.gnucash.20180403092840.gnucash
> personal.gnucash.20180403092840.log
> personal.gnucash.20180403092939.gnucash
> personal.gnucash.20180403092939.gnucash.20180403095225.log
> personal.gnucash.20180403092939.gnucash.20180403104401.log
> personal.gnucash.20180403092939.gnucash.20180403125139.log
> personal.gnucash.20180403092939.gnucash.20180403125159.gnucash
> personal.gnucash.20180403092939.gnucash.20180403125159.log
> personal.gnucash.20180403092939.gnucash.20180404053639.log
> personal.gnucash.20180403092939.gnucash.20180404053716.log
> personal.gnucash.20180403092939.log
> personal.gnucash.20180403104006.log
> personal.gnucash.20180404053709.log
> 
>  The newest log file is
> personal.gnucash.20180403092939.gnucash.20180404053716.log while the newest
> .gnucash file is
> personal.gnucash.20180403092939.gnucash.20180403125159.gnucash.
> 
>  Can I copy the latter to personal.gnucash so that's the file name
> displayed in most-recently opened files? I would like to clean this up.

Rich,

The newest file *should* be personal.gnucash.20180403092939.gnucash; 
personal.gnucash.20180403092939.gnucash.20180403125159.gnucash should be the 
previous version from the last save.

Yes, you can rename any of the .gnucash files to personal.gnucash and then use 
File>Open to open it, then clean out the directory of the backups. The next 
time you open GnuCash 3.0 it will offer to delete the missing files from the 
MRU l list.

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: 2.6.19 crash: one account recovered, one not yet recovered [RESOLVED]

[Rich Shepard]

On Tue, 3 Apr 2018, John Ralls wrote:


Does business.gnucash use the SQLite3 backend? If so, that would explain
the absence of backups, and I suggest you set up some OS-level backup
mechanism for it.


John,

  I use the default backend; 'file' shows it as a compressed Unix file;
perhaps gzipped xml?

  Every midnight cron runs dirvish for incremental backups.

  What's interesting is since I loaded the business.gnucash file yesterday
and everything displayed as it should, the list of files in the business
subdirectory includes business.gnucash (which opens the current state of
that account) as well as several .gnucash and .log files from yesterday's
activities. For example, business.gnucash.20180403104944.gnucash and
business.gnucash.20180403104944.log. So, the business account works as
expected.

  On the other hand, the personal account can be loaded by specifying only a
'personal.gnucash.*.gnucash' file. When I open personal.gnucash I get an
empty display with no CoA or anything else. Specifically, the recently
opened file list shows 'personal.gnucash.20180403092939.gnucash'.

  I suspect that I can rename one of the datetime stamped files to
personal.gnucash, and clean up that subdirectory. I would appreciate your
thoughts on this.

  Having just opened gnucash, and shut it down, these are the files in the
personal/ subdirectory:

gnucash-coa.gnucash
personal.gnucash
personal.gnucash.20180402112722.log
personal.gnucash.20180402112803.log
personal.gnucash.20180402112813.gnucash
personal.gnucash.20180402112813.log
personal.gnucash.20180403092537.log
personal.gnucash.20180403092537.log.gnucash
personal.gnucash.20180403092537.log.gnucash.20180403092911.log
personal.gnucash.20180403092840.gnucash
personal.gnucash.20180403092840.log
personal.gnucash.20180403092939.gnucash
personal.gnucash.20180403092939.gnucash.20180403095225.log
personal.gnucash.20180403092939.gnucash.20180403104401.log
personal.gnucash.20180403092939.gnucash.20180403125139.log
personal.gnucash.20180403092939.gnucash.20180403125159.gnucash
personal.gnucash.20180403092939.gnucash.20180403125159.log
personal.gnucash.20180403092939.gnucash.20180404053639.log
personal.gnucash.20180403092939.gnucash.20180404053716.log
personal.gnucash.20180403092939.log
personal.gnucash.20180403104006.log
personal.gnucash.20180404053709.log

  The newest log file is
personal.gnucash.20180403092939.gnucash.20180404053716.log while the newest
.gnucash file is
personal.gnucash.20180403092939.gnucash.20180403125159.gnucash.

  Can I copy the latter to personal.gnucash so that's the file name
displayed in most-recently opened files? I would like to clean this up.

Regards,

Rich


___
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 3.0 Microsoft Security Essentials Threat Detected

[km22]

Hi,

When I try to download Gnucash 3.0 I get a Microsoft Security Essentials
(MSE) threat detection which then deletes the file.

Screenshot:

Is there a way for the developers to have this file correctly
categorized/assessed by MSE?  It is worrying to see these pop-ups (and
probably the first time I have seen one and hence why I want to be very
careful.) What is the best way for a user to self-assess (i.e. confirm
the file is not a real threat) and proceed with the download/installation?

Thanks,

Ken


___
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: virus download version 3.0

[Mike or Penny Novack]

On 4/2/2018 11:56 PM, Dave via gnucash-user wrote:

Thank you for your assistance and sorry for the false positive report I put
out there.

All virus checkers must sometimes give false positives or sometimes fail 
to detect viruses.


Consider the special virus program "if the supposedly perfect virus 
checker reports this program is a virus, halt, else act like a virus". 
The proposed perfect virus checker MUST incorrectly report this program. 
Just a modification of "The Fundamental Theorem of Computation".


Michael D Novack


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

Re: Importing Quicken

[David T. via gnucash-user]

Alen,

What you’ve done with the Benefits section is better, but I still feel that any 
mention of benefits of migration is misplaced here. Someone looking for ways to 
migrate from Quicken presumably has already come to this conclusion.

* I have edited the tips portion further. I added a tip regarding the whole 
Categories/Accounts paradigm. 

* I modified your tip regarding import of categories only, since it isn’t 
strictly necessary. 

I think it’s useful here to note that I didn’t have to either import the 
account structure or individual accounts separately when I imported my large 
QIF file way back in the dark ages—I simply exported everything in one big QIF 
and did the import from that. That was when I discovered the holes in my 
Quicken data. I chose to go back in to Quicken, fill in those holes, and 
re-export the entire file again, repeating until I had a clean enough import to 
move forward. I know that others have had a different experience.

* I modified the tip about multiple currencies to more accurately reflect the 
situation and make it clear that the problem isn’t with GnuCash, but with QIF.

Cheers,
David

> On Apr 4, 2018, at 12:52 PM, Alen Siljak  wrote:
> 
> Hi, David,
> 
> You are right. I've removed the benefits section but kept the fact about open 
> data standards. Apart from being a benefit (to me), it is also a consequence 
> of migration that may or may not be important for users.
> 
>> You mention multi-currency problems with QIF, saying that GnuCash only 
>> handles one currency per file. However, I am under the impression that the 
>> problem of multiple currencies had to do with the *QIF* specification, and 
>> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
>> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> 
> Yes, that's probably true. However, if an application interprets a transfer 
> in such a manner that it takes 100 Euros from one and then deposits 100 AUD 
> into another account without warning the user, that's a big no-no for me.
> 
> Thanks for the feedback!

___
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: Gnucash 3.0 Microsoft Security Essentials Threat Detected

[km22]

Thanks David C.  And I see this topic is already being discussed in a
separate thread:
http://gnucash.1415818.n4.nabble.com/virus-download-version-3-0-tp4698720p4698799.html

Thanks,
Ken


On 2018-04-04 22:02, David Carlson wrote:
> This has been reported to Microsoft.
>
> David C
>
> On Wed, Apr 4, 2018 at 7:53 AM, km22  > wrote:
>
> Hi,
>
> When I try to download Gnucash 3.0 I get a Microsoft Security
> Essentials
> (MSE) threat detection which then deletes the file.
>
> Screenshot:
>
> Is there a way for the developers to have this file correctly
> categorized/assessed by MSE?  It is worrying to see these pop-ups (and
> probably the first time I have seen one and hence why I want to be
> very
> careful.) What is the best way for a user to self-assess (i.e. confirm
> the file is not a real threat) and proceed with the
> download/installation?
>
> Thanks,
>
> Ken
>
>
> ___
> 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: Importing Quicken

[David Carlson]

David T,

Does the QIF importer detect duplicates created by transfers within the
same import file?  I seem to recall needing to separate accounts to
different files to detect them.

David C

On Wed, Apr 4, 2018 at 9:00 AM, David T.  wrote:

> Alen,
>
> What you’ve done with the Benefits section is better, but I still feel
> that any mention of benefits of migration is misplaced here. Someone
> looking for ways to migrate from Quicken presumably has already come to
> this conclusion.
>
> * I have edited the tips portion further. I added a tip regarding the
> whole Categories/Accounts paradigm.
>
> * I modified your tip regarding import of categories only, since it isn’t
> strictly necessary.
>
> I think it’s useful here to note that I didn’t have to either import the
> account structure or individual accounts separately when I imported my
> large QIF file way back in the dark ages—I simply exported everything in
> one big QIF and did the import from that. That was when I discovered the
> holes in my Quicken data. I chose to go back in to Quicken, fill in those
> holes, and re-export the entire file again, repeating until I had a clean
> enough import to move forward. I know that others have had a different
> experience.
>
> * I modified the tip about multiple currencies to more accurately reflect
> the situation and make it clear that the problem isn’t with GnuCash, but
> with QIF.
>
> Cheers,
> David
>
> > On Apr 4, 2018, at 12:52 PM, Alen Siljak  wrote:
> >
> > Hi, David,
> >
> > You are right. I've removed the benefits section but kept the fact about
> open data standards. Apart from being a benefit (to me), it is also a
> consequence of migration that may or may not be important for users.
> >
> >> You mention multi-currency problems with QIF, saying that GnuCash only
> handles one currency per file. However, I am under the impression that the
> problem of multiple currencies had to do with the *QIF* specification, and
> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle
> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> >
> > Yes, that's probably true. However, if an application interprets a
> transfer in such a manner that it takes 100 Euros from one and then
> deposits 100 AUD into another account without warning the user, that's a
> big no-no for me.
> >
> > Thanks for the feedback!
>
>
___
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: Gnucash 3.0 Microsoft Security Essentials Threat Detected

[David Carlson]

This has been reported to Microsoft.

David C

On Wed, Apr 4, 2018 at 7:53 AM, km22  wrote:

> Hi,
>
> When I try to download Gnucash 3.0 I get a Microsoft Security Essentials
> (MSE) threat detection which then deletes the file.
>
> Screenshot:
>
> Is there a way for the developers to have this file correctly
> categorized/assessed by MSE?  It is worrying to see these pop-ups (and
> probably the first time I have seen one and hence why I want to be very
> careful.) What is the best way for a user to self-assess (i.e. confirm
> the file is not a real threat) and proceed with the download/installation?
>
> Thanks,
>
> Ken
>
>
> ___
> 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: gnucash 3.0 crashes opening accounts file

[John Ralls]

> On Apr 4, 2018, at 2:12 AM, pjlbyrne  wrote:
> 
> Thanks John - I expect puttingin proxy configuration won't be too difficult.
> I will have a look later.
> 
> BTW I got the exact same crash running gc3 at home, opening the same
> accounts file. Perhaps it is related to the accounts file. I have been using
> gnucash for some years now, my file is 1.4MB in size - is that considered
> large?
> 
> Anyway it means I can debug it at home now, when, I have the time.
> 

No, 1.4M, even compressed, isn’t terribly large. My main database is about 7M 
compressed, 53M uncompressed.

There are a couple of open bugs on a similar problem, one of which, bug 782144 
, has a long chain of things 
we’ve tried to isolate the problem. You should probably read that before you 
start your own debugging.

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: GNUCash 3.0: Report Printing problems

[Adrien Monteleone]

Welcome to GnuCash Steve!

I just caught up on a thread about W10 printing issues. It seems the problem 
has indeed carried over to the 3.0 series. (and still exists in 2.6.x)

As long as you can then print that PDF, it’s an extra step, but you aren’t 
locked out of printing.

Unfortunately, looking at your questions in 2-4, you might need an extra few 
steps anyway.

There’s no need to export first, you can simply select-all and copy/paste your 
report into Excel, and use that to format your printout with desired 
page-breaks, paper size, and footer.

Directly to your #3 - Check in File > Page Setup. You can set paper size and 
orientation there.

You can’t directly control page breaks, but you can change page orientation and 
you can adjust font-size by editing the stylesheets or creating your own 
stylesheet. However, you’ll likely have to alter this by trial and error and 
then do so each time the report changes. (not very time efficient)

Likewise, you can customize the Footer stylesheet to your needs which will 
allow you to print a footer on the page. There are some variables to use in 
some places but I’m not sure if page-number and page-count are included in 
these or if they’d even work in the footer. You might have to create a custom 
report. (which would be even more trouble)

The easiest way to get all requirements is to copy/paste and format in Excel as 
noted.

Please note, a proper reporting system is on the wish list, but it’s going to 
be well down the road until after core parts of the app are rebuilt, 
particularly, the transition to a true database app. Till then, we can always 
use our favorite spreadsheet for custom and ‘pretty printing’.

Regards,
Adrien

> On Apr 4, 2018, at 2:03 AM, Steve Parry  wrote:
> 
> Hi all,
> 
> GNUCash newbie here.
> 
> 
> 
> The problems I am having are: 
> 
> 1.I can only print to PDF – no option for real printer use. I understand 
> this is a problem with GNUCash on W10, so I’ll let that go.
> 
> 
> 
> 2.If I create a PDF report it splits whatever is at the page break across 
> the pages. For example the top half of a text line will be on the bottom of 
> page 1 and the bottom half of the text on page 2. How do I make it page break 
> at the end of a line?
> 
> 
> 
> 3.Australia use A4 paper, but I can’t see where the PDF page size in 
> GNUCash is set up. One Report needs to be in A3 landscape, and currently I 
> have to export it to HTML, into Excel, reformat and then print it.  Is there 
> a way of setting the PDF print properties for GNUCash?
> 
> 
> 
> 4.I want to add a report footer that has “Page x of y” in for my 
> multi-page reports. How do I do that?
> 
> 
> 
> Thank you everyone – be gentle
> 
> 
> 
> Cheers
> 
> …Steve
> 
> ___
> 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: Importing Quicken

[David T. via gnucash-user]

When I did my import (over a decade ago, I believe), I had no problem with 
transfers. Since I was importing all in one pass, there were no duplicates 
created by transfers. 

I believe the duplication problem you describe specifically arises when you opt 
to import transaction data from individual accounts separately, since you have 
to tell the importer when a given transfer is already in the system from the 
other side. It’s precisely why I think it should NOT be the “preferred” way of 
importing from Quicken, since it forces the user to manually identify the other 
side of a transfer every time. That makes my head hurt just thinking about it. 

This is why I chose to run the Export-Import process iteratively, until I got 
the Quicken data massaged to my satisfaction. Then the imported data was all 
good.

Most of the challenge had to do with random category variations, and 
uncategorized transactions—which you well know will end up in IMBALANCE-USD.

David T.

> On Apr 4, 2018, at 7:16 PM, David Carlson  wrote:
> 
> David T,
> 
> Does the QIF importer detect duplicates created by transfers within the same 
> import file?  I seem to recall needing to separate accounts to different 
> files to detect them.
> 
> David C
> 
> On Wed, Apr 4, 2018 at 9:00 AM, David T.  > wrote:
> Alen,
> 
> What you’ve done with the Benefits section is better, but I still feel that 
> any mention of benefits of migration is misplaced here. Someone looking for 
> ways to migrate from Quicken presumably has already come to this conclusion.
> 
> * I have edited the tips portion further. I added a tip regarding the whole 
> Categories/Accounts paradigm.
> 
> * I modified your tip regarding import of categories only, since it isn’t 
> strictly necessary.
> 
> I think it’s useful here to note that I didn’t have to either import the 
> account structure or individual accounts separately when I imported my large 
> QIF file way back in the dark ages—I simply exported everything in one big 
> QIF and did the import from that. That was when I discovered the holes in my 
> Quicken data. I chose to go back in to Quicken, fill in those holes, and 
> re-export the entire file again, repeating until I had a clean enough import 
> to move forward. I know that others have had a different experience.
> 
> * I modified the tip about multiple currencies to more accurately reflect the 
> situation and make it clear that the problem isn’t with GnuCash, but with QIF.
> 
> Cheers,
> David
> 
> > On Apr 4, 2018, at 12:52 PM, Alen Siljak  > > wrote:
> >
> > Hi, David,
> >
> > You are right. I've removed the benefits section but kept the fact about 
> > open data standards. Apart from being a benefit (to me), it is also a 
> > consequence of migration that may or may not be important for users.
> >
> >> You mention multi-currency problems with QIF, saying that GnuCash only 
> >> handles one currency per file. However, I am under the impression that the 
> >> problem of multiple currencies had to do with the *QIF* specification, and 
> >> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
> >> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> >
> > Yes, that's probably true. However, if an application interprets a transfer 
> > in such a manner that it takes 100 Euros from one and then deposits 100 AUD 
> > into another account without warning the user, that's a big no-no for me.
> >
> > Thanks for the feedback!
> 
> 

___
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: Unrealized loss

[cageda]

I suspect there is a bug that should be reported: 

As I do NOT manage currencies other than EUR and no traders accounts taking 
into account share values, I have deleted all exchanges rates that had been 
updated automatically by GC without my noticing. 
BUT my Unrealized loss on a given day varies according to my setting the 
calculation mode to "average" or "nearest in time" for instance. It doesn's 
seem to make sense since there are NO exchange rates in my system. 

Ideas? 
TIA 
Alain 




De: "sunfish62"  
À: cag...@free.fr, "John Ralls"  
Cc: "gnucash-user"  
Envoyé: Lundi 2 Avril 2018 14:52:46 
Objet: Re: Unrealized loss 

Alain, 

Your new transaction is balanced, and won't affect the imbalance in another 
transaction. 

I personally find the unrealized gains issue to be exceedingly difficult to 
understand. Since you say you don't care about this, just ignore it. 

David T 




On Mon, Apr 2, 2018 at 17:02, cag...@free.fr 
 wrote: 



De: [ mailto:cag...@free.fr | cag...@free.fr ] 
À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] > 
Envoyé: Lundi 2 Avril 2018 13:51:03 
Objet: Re: Unrealized loss 




De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
À: [ mailto:cag...@free.fr | cag...@free.fr ] 
Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] > 
Envoyé: Dimanche 1 Avril 2018 15:34:43 
Objet: Re: Unrealized loss 






On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | cag...@free.fr 
] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote: 


Hello. 

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70). 

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer. 

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book 
keeping is fully personal so I'd like to know the procedure. 




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] | [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] . 

Regards, 
John Ralls 



I have identified the day on which the unrealized lossed first appeared. I have 
drawn a transaction report for that day (and the day before). There is no 
transaction that can remotely explain the loss. 
I do not handle foreign currencies. Regarding shares I do not use trader 
accounts or split transactions including profits or losses. I do not enter 
share values into GC until the day I sell them. There is no way in the meantime 
GC can take into account a difference in value. 

Something might help identify where the problem comes from: I had another 
instance with an unrealized loss as big as my total yearly income. It went away 
a few weeks (or months I'm not sure) after it showed up. There is no way a 
single transaction (or even a few ) on a particular day triggered an unrealized 
loss as big as my yearly income. 

What I would like at this stage is simply set GC NOT to SHOW unrealized 
losses/gains. No legal problem as I'm only managing my personal familyaccounts. 

TIA for you help 
Regards 
Alain 


I tried the following: 
C an equity account "Unrealized loss" : EUR 7.70 
D an income account "Realized loss" : EUR 7.70 
The total Equity remained the same - 7.70 
I changed the signs and the total equity remained at - 7.70 
I don't get it. 

TIA 
Alain 




___ 
gnucash-user mailing list 
[ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org ] 
To update your subscription preferences or to unsubscribe: 
[ https://lists.gnucash.org/mailman/listinfo/gnucash-user | 
https://lists.gnucash.org/mailman/listinfo/gnucash-user ] 
If you are using Nabble or Gmane, please see [ 
https://wiki.gnucash.org/wiki/Mailing_Lists | 
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: Unrealized loss

[cageda]

I do not manage prices whatsoever and I have deleted any prices updated 
automatically by GC. 

Alain 


De: "Colin Law"  
À: "Alain Dormoy"  
Cc: "gnucash-user"  
Envoyé: Mercredi 4 Avril 2018 18:20:15 
Objet: Re: Unrealized loss 

Have you got any price changes on that date? 

Colin 

On 4 April 2018 at 17:10, < [ mailto:cag...@free.fr | cag...@free.fr ] > wrote: 


I suspect there is a bug that should be reported: 

As I do NOT manage currencies other than EUR and no traders accounts taking 
into account share values, I have deleted all exchanges rates that had been 
updated automatically by GC without my noticing. 
BUT my Unrealized loss on a given day varies according to my setting the 
calculation mode to "average" or "nearest in time" for instance. It doesn's 
seem to make sense since there are NO exchange rates in my system. 

Ideas? 
TIA 
Alain 




De: "sunfish62" < [ mailto:sunfis...@yahoo.com | sunfis...@yahoo.com ] > 
À: [ mailto:cag...@free.fr | cag...@free.fr ] , "John Ralls" < [ 
mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] > 
Envoyé: Lundi 2 Avril 2018 14:52:46 
Objet: Re: Unrealized loss 

Alain, 

Your new transaction is balanced, and won't affect the imbalance in another 
transaction. 

I personally find the unrealized gains issue to be exceedingly difficult to 
understand. Since you say you don't care about this, just ignore it. 

David T 




On Mon, Apr 2, 2018 at 17:02, [ mailto:cag...@free.fr | cag...@free.fr ] 
< [ mailto:cag...@free.fr | cag...@free.fr ] > wrote: 



De: [ mailto: [ mailto:cag...@free.fr | cag...@free.fr ] | [ 
mailto:cag...@free.fr | cag...@free.fr ] ] 
À: "John Ralls" < [ mailto: [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] 
| [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] ] > 
Cc: "gnucash-user" < [ mailto: [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] | [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] ] > 
Envoyé: Lundi 2 Avril 2018 13:51:03 
Objet: Re: Unrealized loss 




De: "John Ralls" < [ mailto: [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] 
| [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] ] > 
À: [ mailto: [ mailto:cag...@free.fr | cag...@free.fr ] | [ 
mailto:cag...@free.fr | cag...@free.fr ] ] 
Cc: "gnucash-user" < [ mailto: [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] | [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] ] > 
Envoyé: Dimanche 1 Avril 2018 15:34:43 
Objet: Re: Unrealized loss 






On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto: [ mailto:cag...@free.fr | 
cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] | [ mailto: [ 
mailto:cag...@free.fr | cag...@free.fr ] | [ mailto:cag...@free.fr | 
cag...@free.fr ] ] ] wrote: 


Hello. 

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70). 

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer. 

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book 
keeping is fully personal so I'd like to know the procedure. 




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ [ [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] | [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] ] | [ [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] | [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] ] ] . 

Regards, 
John Ralls 



I have identified the day on which the unrealized lossed first appeared. I have 
drawn a transaction report for that day (and the day before). There is no 
transaction that can remotely explain the loss. 
I do not handle foreign currencies. Regarding shares I do not use trader 
accounts or split transactions including profits or losses. I do not enter 
share values into GC until the day I sell them. There is no way in the meantime 
GC can take into account a difference in value. 

Something might help identify where the problem comes from: I had another 
instance with an unrealized loss as big as my total yearly income. It went away 
a few weeks (or months I'm not 

Re: Unrealized loss

[Adrien Monteleone]

Assets and Liabilities most certainly can have different totals. The difference 
is Equity.

With GnuCash you have the option of letting it calculate the unrealized 
loss/gain and retain the flexibility to run custom reports, or, lose some 
reporting flexibility and periodically (through the close-books procedure) 
formally recognize that gain or loss to an Equity account. (that is, gain/loss 
as a result of Income - Expenses, not from sale of assets, that should be done 
at the actual sale)

Regards,
Adrien

> On Apr 2, 2018, at 11:47 AM, cag...@free.fr wrote:
> 
> It's not comfortable for an accountant's mind to have Assets and Liabilities 
> with different totals :-) 
> 
> I understand there is a way not to show Unrealized losses but I am at a loss 
> to find it. 
> 
> Alain 
> 
> 
> 
> 
> 
> 
> De: "David T."  
> À: cag...@free.fr, "John Ralls"  
> Cc: "gnucash-user"  
> Envoyé: Lundi 2 Avril 2018 14:52:46 
> Objet: Re: Unrealized loss 
> 
> Alain, 
> 
> Your new transaction is balanced, and won't affect the imbalance in another 
> transaction. 
> 
> I personally find the unrealized gains issue to be exceedingly difficult to 
> understand. Since you say you don't care about this, just ignore it. 
> 
> David T 
> 
> 
> 
> 
> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr 
>  wrote: 
> 
> 
> 
> De: [ mailto:cag...@free.fr | cag...@free.fr ] 
> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
> gnucash-user@gnucash.org ] > 
> Envoyé: Lundi 2 Avril 2018 13:51:03 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
> À: [ mailto:cag...@free.fr | cag...@free.fr ] 
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
> gnucash-user@gnucash.org ] > 
> Envoyé: Dimanche 1 Avril 2018 15:34:43 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> 
> 
> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | 
> cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote: 
> 
> 
> Hello. 
> 
> I have have had an "unrealized loss" showing on my balance sheet for years. I 
> haven't bothered too much as the amount is extremely small. (€7.70). 
> 
> I had kind advice on this forum as to identify the date on which the loss 
> showed up and the procedure to cancel it. I did find the date but stangely 
> not the transaction. So I'm not going to keep trying to cancel the loss any 
> longer. 
> 
> I read that, without actually "cancelling" the loss, it is possible to 
> prevent it from showing. I know that this is not legal for a company, but my 
> book keeping is fully personal so I'd like to know the procedure. 
> 
> 
> 
> 
> “Cancelling” isn’t really the right term. You need to record the loss as 
> either expense or negative income depending on how you handle capital gains. 
> There’s an explanation of how to do this in [ [ 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] | [ 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] . 
> 
> Regards, 
> John Ralls 
> 
> 
> 
> I have identified the day on which the unrealized lossed first appeared. I 
> have drawn a transaction report for that day (and the day before). There is 
> no transaction that can remotely explain the loss. 
> I do not handle foreign currencies. Regarding shares I do not use trader 
> accounts or split transactions including profits or losses. I do not enter 
> share values into GC until the day I sell them. There is no way in the 
> meantime GC can take into account a difference in value. 
> 
> Something might help identify where the problem comes from: I had another 
> instance with an unrealized loss as big as my total yearly income. It went 
> away a few weeks (or months I'm not sure) after it showed up. There is no way 
> a single transaction (or even a few ) on a particular day triggered an 
> unrealized loss as big as my yearly income. 
> 
> What I would like at this stage is simply set GC NOT to SHOW unrealized 
> losses/gains. No legal problem as I'm only managing my personal 
> familyaccounts. 
> 
> TIA for you help 
> Regards 
> Alain 
> 
> 
> I tried the following: 
> C an equity account "Unrealized loss" : EUR 7.70 
> D an income account "Realized loss" : EUR 7.70 
> The total Equity remained the same - 7.70 
> I changed the signs and the total equity remained at - 7.70 
> I don't get it. 
> 
> TIA 
> Alain 
> 
> 
> 
> 
> ___ 
> gnucash-user mailing list 
> [ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org ] 
> To update your subscription preferences or to unsubscribe: 
> [ https://lists.gnucash.org/mailman/listinfo/gnucash-user | 
> 

Re: Unrealized loss

[Colin Law]

Have you got any price changes on that date?

Colin

On 4 April 2018 at 17:10,  wrote:

> I suspect there is a bug that should be reported:
>
> As I do NOT manage currencies other than EUR and no traders accounts
> taking into account share values, I have deleted all exchanges rates that
> had been updated automatically by GC without my noticing.
> BUT my Unrealized loss on a given day varies according to my setting the
> calculation mode to "average" or "nearest in time" for instance. It doesn's
> seem to make sense since there are NO exchange rates in my system.
>
> Ideas?
> TIA
> Alain
>
>
>
>
> De: "sunfish62" 
> À: cag...@free.fr, "John Ralls" 
> Cc: "gnucash-user" 
> Envoyé: Lundi 2 Avril 2018 14:52:46
> Objet: Re: Unrealized loss
>
> Alain,
>
> Your new transaction is balanced, and won't affect the imbalance in
> another transaction.
>
> I personally find the unrealized gains issue to be exceedingly difficult
> to understand. Since you say you don't care about this, just ignore it.
>
> David T
>
>
>
>
> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr
>  wrote:
>
>
>
> De: [ mailto:cag...@free.fr | cag...@free.fr ]
> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org |
> gnucash-user@gnucash.org ] >
> Envoyé: Lundi 2 Avril 2018 13:51:03
> Objet: Re: Unrealized loss
>
>
>
>
> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
> À: [ mailto:cag...@free.fr | cag...@free.fr ]
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org |
> gnucash-user@gnucash.org ] >
> Envoyé: Dimanche 1 Avril 2018 15:34:43
> Objet: Re: Unrealized loss
>
>
>
>
>
>
> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr |
> cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote:
>
>
> Hello.
>
> I have have had an "unrealized loss" showing on my balance sheet for
> years. I haven't bothered too much as the amount is extremely small.
> (€7.70).
>
> I had kind advice on this forum as to identify the date on which the loss
> showed up and the procedure to cancel it. I did find the date but stangely
> not the transaction. So I'm not going to keep trying to cancel the loss any
> longer.
>
> I read that, without actually "cancelling" the loss, it is possible to
> prevent it from showing. I know that this is not legal for a company, but
> my book keeping is fully personal so I'd like to know the procedure.
>
>
>
>
> “Cancelling” isn’t really the right term. You need to record the loss as
> either expense or negative income depending on how you handle capital
> gains. There’s an explanation of how to do this in [ [
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html |
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] |
> [ https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html |
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] .
>
> Regards,
> John Ralls
>
>
>
> I have identified the day on which the unrealized lossed first appeared. I
> have drawn a transaction report for that day (and the day before). There is
> no transaction that can remotely explain the loss.
> I do not handle foreign currencies. Regarding shares I do not use trader
> accounts or split transactions including profits or losses. I do not enter
> share values into GC until the day I sell them. There is no way in the
> meantime GC can take into account a difference in value.
>
> Something might help identify where the problem comes from: I had another
> instance with an unrealized loss as big as my total yearly income. It went
> away a few weeks (or months I'm not sure) after it showed up. There is no
> way a single transaction (or even a few ) on a particular day triggered an
> unrealized loss as big as my yearly income.
>
> What I would like at this stage is simply set GC NOT to SHOW unrealized
> losses/gains. No legal problem as I'm only managing my personal
> familyaccounts.
>
> TIA for you help
> Regards
> Alain
>
>
> I tried the following:
> C an equity account "Unrealized loss" : EUR 7.70
> D an income account "Realized loss" : EUR 7.70
> The total Equity remained the same - 7.70
> I changed the signs and the total equity remained at - 7.70
> I don't get it.
>
> TIA
> Alain
>
>
>
>
> ___
> gnucash-user mailing list
> [ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org ]
> To update your subscription preferences or to unsubscribe:
> [ https://lists.gnucash.org/mailman/listinfo/gnucash-user |
> https://lists.gnucash.org/mailman/listinfo/gnucash-user ]
> If you are using Nabble or Gmane, please see [
> https://wiki.gnucash.org/wiki/Mailing_Lists |
> 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 

Re: Unrealized loss

[D via gnucash-user]

Alain,

If you have different lots of a commodity (for example, you purchase additional 
shares of a mutual fund), I believe that the price of the new purchase can 
affect the calculation of unrealized gains for the rest. Gnucash can determine 
a new value for your previous shares, and identifies an unrealized gain. Or at 
least, that's my meager understanding. As I said before, I find this issue very 
confusing, and not so long ago, I was the person insisting that there was a 
bug. Maybe there is, but I couldn't figure it out.

David T.


On April 4, 2018, at 9:34 PM, Adrien Monteleone  
wrote:

The value will usually change based on that setting. Sometimes ‘latest’ and 
’nearest in time’ will be the same, but that depends on running the report ON 
an actual day (not FOR an actual day) that is on or after a price update and 
before the next price update.

First, you say you deleted all rates updated automatically by GC without you 
noticing. (does not happen, you have to open the price editor and tell it to 
‘get quotes’) This leaves the presumption that there are other prices in the db 
that you either entered manually or intentionally updated with the ‘get quotes’ 
button.

Then you say there are NO rates in the system.

Which is it?

If you open the Price Database is there anything at all listed in the window? 
(this includes a Currencies tree)

Do you have ANY transactions where you purchased or entered an opening balance 
for a commodity or any currency other than the default book currency? (EUR)

If you go to File > Properties, is ‘Use Trading Accounts’ checked?

Regards,
Adrien

> On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote:
> 
> I suspect there is a bug that should be reported: 
> 
> As I do NOT manage currencies other than EUR and no traders accounts taking 
> into account share values, I have deleted all exchanges rates that had been 
> updated automatically by GC without my noticing. 
> BUT my Unrealized loss on a given day varies according to my setting the 
> calculation mode to "average" or "nearest in time" for instance. It doesn's 
> seem to make sense since there are NO exchange rates in my system. 
> 
> Ideas? 
> TIA 
> Alain 
> 
> 
> 
> 
> De: "sunfish62"  
> À: cag...@free.fr, "John Ralls"  
> Cc: "gnucash-user"  
> Envoyé: Lundi 2 Avril 2018 14:52:46 
> Objet: Re: Unrealized loss 
> 
> Alain, 
> 
> Your new transaction is balanced, and won't affect the imbalance in another 
> transaction. 
> 
> I personally find the unrealized gains issue to be exceedingly difficult to 
> understand. Since you say you don't care about this, just ignore it. 
> 
> David T 
> 
> 
> 
> 
> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr 
>  wrote: 
> 
> 
> 
> De: [ mailto:cag...@free.fr | cag...@free.fr ] 
> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
> gnucash-user@gnucash.org ] > 
> Envoyé: Lundi 2 Avril 2018 13:51:03 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
> À: [ mailto:cag...@free.fr | cag...@free.fr ] 
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
> gnucash-user@gnucash.org ] > 
> Envoyé: Dimanche 1 Avril 2018 15:34:43 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> 
> 
> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | 
> cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote: 
> 
> 
> Hello. 
> 
> I have have had an "unrealized loss" showing on my balance sheet for years. I 
> haven't bothered too much as the amount is extremely small. (€7.70). 
> 
> I had kind advice on this forum as to identify the date on which the loss 
> showed up and the procedure to cancel it. I did find the date but stangely 
> not the transaction. So I'm not going to keep trying to cancel the loss any 
> longer. 
> 
> I read that, without actually "cancelling" the loss, it is possible to 
> prevent it from showing. I know that this is not legal for a company, but my 
> book keeping is fully personal so I'd like to know the procedure. 
> 
> 
> 
> 
> “Cancelling” isn’t really the right term. You need to record the loss as 
> either expense or negative income depending on how you handle capital gains. 
> There’s an explanation of how to do this in [ [ 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] | [ 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] . 
> 
> Regards, 
> John Ralls 
> 
> 
> 
> I have identified the day on which the unrealized lossed first appeared. I 
> have drawn a transaction report for that day (and the day before). There is 
> no transaction that can remotely explain the loss. 
> I do not handle 

Re: Unrealized loss

[Adrien Monteleone]

The value will usually change based on that setting. Sometimes ‘latest’ and 
’nearest in time’ will be the same, but that depends on running the report ON 
an actual day (not FOR an actual day) that is on or after a price update and 
before the next price update.

First, you say you deleted all rates updated automatically by GC without you 
noticing. (does not happen, you have to open the price editor and tell it to 
‘get quotes’) This leaves the presumption that there are other prices in the db 
that you either entered manually or intentionally updated with the ‘get quotes’ 
button.

Then you say there are NO rates in the system.

Which is it?

If you open the Price Database is there anything at all listed in the window? 
(this includes a Currencies tree)

Do you have ANY transactions where you purchased or entered an opening balance 
for a commodity or any currency other than the default book currency? (EUR)

If you go to File > Properties, is ‘Use Trading Accounts’ checked?

Regards,
Adrien

> On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote:
> 
> I suspect there is a bug that should be reported: 
> 
> As I do NOT manage currencies other than EUR and no traders accounts taking 
> into account share values, I have deleted all exchanges rates that had been 
> updated automatically by GC without my noticing. 
> BUT my Unrealized loss on a given day varies according to my setting the 
> calculation mode to "average" or "nearest in time" for instance. It doesn's 
> seem to make sense since there are NO exchange rates in my system. 
> 
> Ideas? 
> TIA 
> Alain 
> 
> 
> 
> 
> De: "sunfish62"  
> À: cag...@free.fr, "John Ralls"  
> Cc: "gnucash-user"  
> Envoyé: Lundi 2 Avril 2018 14:52:46 
> Objet: Re: Unrealized loss 
> 
> Alain, 
> 
> Your new transaction is balanced, and won't affect the imbalance in another 
> transaction. 
> 
> I personally find the unrealized gains issue to be exceedingly difficult to 
> understand. Since you say you don't care about this, just ignore it. 
> 
> David T 
> 
> 
> 
> 
> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr 
>  wrote: 
> 
> 
> 
> De: [ mailto:cag...@free.fr | cag...@free.fr ] 
> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
> gnucash-user@gnucash.org ] > 
> Envoyé: Lundi 2 Avril 2018 13:51:03 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
> À: [ mailto:cag...@free.fr | cag...@free.fr ] 
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
> gnucash-user@gnucash.org ] > 
> Envoyé: Dimanche 1 Avril 2018 15:34:43 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> 
> 
> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | 
> cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote: 
> 
> 
> Hello. 
> 
> I have have had an "unrealized loss" showing on my balance sheet for years. I 
> haven't bothered too much as the amount is extremely small. (€7.70). 
> 
> I had kind advice on this forum as to identify the date on which the loss 
> showed up and the procedure to cancel it. I did find the date but stangely 
> not the transaction. So I'm not going to keep trying to cancel the loss any 
> longer. 
> 
> I read that, without actually "cancelling" the loss, it is possible to 
> prevent it from showing. I know that this is not legal for a company, but my 
> book keeping is fully personal so I'd like to know the procedure. 
> 
> 
> 
> 
> “Cancelling” isn’t really the right term. You need to record the loss as 
> either expense or negative income depending on how you handle capital gains. 
> There’s an explanation of how to do this in [ [ 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] | [ 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] . 
> 
> Regards, 
> John Ralls 
> 
> 
> 
> I have identified the day on which the unrealized lossed first appeared. I 
> have drawn a transaction report for that day (and the day before). There is 
> no transaction that can remotely explain the loss. 
> I do not handle foreign currencies. Regarding shares I do not use trader 
> accounts or split transactions including profits or losses. I do not enter 
> share values into GC until the day I sell them. There is no way in the 
> meantime GC can take into account a difference in value. 
> 
> Something might help identify where the problem comes from: I had another 
> instance with an unrealized loss as big as my total yearly income. It went 
> away a few weeks (or months I'm not sure) after it showed up. There is no way 
> a single transaction (or even a few ) on a particular day triggered an 
> unrealized loss as big as my yearly income. 
> 

Re: Unrealized loss

[cageda]

Thanks. OK. Will do. 

Alain 


De: "Christopher Lam"  
À: cag...@free.fr 
Cc: "gnucash-user"  
Envoyé: Mercredi 4 Avril 2018 20:41:37 
Objet: Re: Unrealized loss 

Hi Alain, please report bug and we can track discussion there. 

On Wed, 4 Apr 2018, 20:12 < [ mailto:cag...@free.fr | cag...@free.fr ] > wrote: 


I suspect there is a bug that should be reported: 

As I do NOT manage currencies other than EUR and no traders accounts taking 
into account share values, I have deleted all exchanges rates that had been 
updated automatically by GC without my noticing. 
BUT my Unrealized loss on a given day varies according to my setting the 
calculation mode to "average" or "nearest in time" for instance. It doesn's 
seem to make sense since there are NO exchange rates in my system. 

Ideas? 
TIA 
Alain 




De: "sunfish62" < [ mailto:sunfis...@yahoo.com | sunfis...@yahoo.com ] > 
À: [ mailto:cag...@free.fr | cag...@free.fr ] , "John Ralls" < [ 
mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] > 
Envoyé: Lundi 2 Avril 2018 14:52:46 
Objet: Re: Unrealized loss 

Alain, 

Your new transaction is balanced, and won't affect the imbalance in another 
transaction. 

I personally find the unrealized gains issue to be exceedingly difficult to 
understand. Since you say you don't care about this, just ignore it. 

David T 




On Mon, Apr 2, 2018 at 17:02, [ mailto:cag...@free.fr | cag...@free.fr ] 
< [ mailto:cag...@free.fr | cag...@free.fr ] > wrote: 



De: [ mailto: [ mailto:cag...@free.fr | cag...@free.fr ] | [ 
mailto:cag...@free.fr | cag...@free.fr ] ] 
À: "John Ralls" < [ mailto: [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] 
| [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] ] > 
Cc: "gnucash-user" < [ mailto: [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] | [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] ] > 
Envoyé: Lundi 2 Avril 2018 13:51:03 
Objet: Re: Unrealized loss 




De: "John Ralls" < [ mailto: [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] 
| [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] ] > 
À: [ mailto: [ mailto:cag...@free.fr | cag...@free.fr ] | [ 
mailto:cag...@free.fr | cag...@free.fr ] ] 
Cc: "gnucash-user" < [ mailto: [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] | [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] ] > 
Envoyé: Dimanche 1 Avril 2018 15:34:43 
Objet: Re: Unrealized loss 






On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto: [ mailto:cag...@free.fr | 
cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] | [ mailto: [ 
mailto:cag...@free.fr | cag...@free.fr ] | [ mailto:cag...@free.fr | 
cag...@free.fr ] ] ] wrote: 


Hello. 

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70). 

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer. 

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book 
keeping is fully personal so I'd like to know the procedure. 




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ [ [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] | [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] ] | [ [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] | [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] ] ] . 

Regards, 
John Ralls 



I have identified the day on which the unrealized lossed first appeared. I have 
drawn a transaction report for that day (and the day before). There is no 
transaction that can remotely explain the loss. 
I do not handle foreign currencies. Regarding shares I do not use trader 
accounts or split transactions including profits or losses. I do not enter 
share values into GC until the day I sell them. There is no way in the meantime 
GC can take into account a difference in value. 

Something might help identify where the problem comes from: I had another 
instance with an unrealized loss as big as my total yearly income. It went away 
a few weeks (or months I'm not sure) after it showed up. There is no way a 
single transaction 

Re: Unrealized loss

[Christopher Lam]

Hi Alain, please report bug and we can track discussion there.

On Wed, 4 Apr 2018, 20:12  wrote:

> I suspect there is a bug that should be reported:
>
> As I do NOT manage currencies other than EUR and no traders accounts
> taking into account share values, I have deleted all exchanges rates that
> had been updated automatically by GC without my noticing.
> BUT my Unrealized loss on a given day varies according to my setting the
> calculation mode to "average" or "nearest in time" for instance. It doesn's
> seem to make sense since there are NO exchange rates in my system.
>
> Ideas?
> TIA
> Alain
>
>
>
>
> De: "sunfish62" 
> À: cag...@free.fr, "John Ralls" 
> Cc: "gnucash-user" 
> Envoyé: Lundi 2 Avril 2018 14:52:46
> Objet: Re: Unrealized loss
>
> Alain,
>
> Your new transaction is balanced, and won't affect the imbalance in
> another transaction.
>
> I personally find the unrealized gains issue to be exceedingly difficult
> to understand. Since you say you don't care about this, just ignore it.
>
> David T
>
>
>
>
> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr
>  wrote:
>
>
>
> De: [ mailto:cag...@free.fr | cag...@free.fr ]
> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org |
> gnucash-user@gnucash.org ] >
> Envoyé: Lundi 2 Avril 2018 13:51:03
> Objet: Re: Unrealized loss
>
>
>
>
> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
> À: [ mailto:cag...@free.fr | cag...@free.fr ]
> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org |
> gnucash-user@gnucash.org ] >
> Envoyé: Dimanche 1 Avril 2018 15:34:43
> Objet: Re: Unrealized loss
>
>
>
>
>
>
> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr |
> cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote:
>
>
> Hello.
>
> I have have had an "unrealized loss" showing on my balance sheet for
> years. I haven't bothered too much as the amount is extremely small.
> (€7.70).
>
> I had kind advice on this forum as to identify the date on which the loss
> showed up and the procedure to cancel it. I did find the date but stangely
> not the transaction. So I'm not going to keep trying to cancel the loss any
> longer.
>
> I read that, without actually "cancelling" the loss, it is possible to
> prevent it from showing. I know that this is not legal for a company, but
> my book keeping is fully personal so I'd like to know the procedure.
>
>
>
>
> “Cancelling” isn’t really the right term. You need to record the loss as
> either expense or negative income depending on how you handle capital
> gains. There’s an explanation of how to do this in [ [
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html |
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] |
> [ https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html |
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] .
>
> Regards,
> John Ralls
>
>
>
> I have identified the day on which the unrealized lossed first appeared. I
> have drawn a transaction report for that day (and the day before). There is
> no transaction that can remotely explain the loss.
> I do not handle foreign currencies. Regarding shares I do not use trader
> accounts or split transactions including profits or losses. I do not enter
> share values into GC until the day I sell them. There is no way in the
> meantime GC can take into account a difference in value.
>
> Something might help identify where the problem comes from: I had another
> instance with an unrealized loss as big as my total yearly income. It went
> away a few weeks (or months I'm not sure) after it showed up. There is no
> way a single transaction (or even a few ) on a particular day triggered an
> unrealized loss as big as my yearly income.
>
> What I would like at this stage is simply set GC NOT to SHOW unrealized
> losses/gains. No legal problem as I'm only managing my personal
> familyaccounts.
>
> TIA for you help
> Regards
> Alain
>
>
> I tried the following:
> C an equity account "Unrealized loss" : EUR 7.70
> D an income account "Realized loss" : EUR 7.70
> The total Equity remained the same - 7.70
> I changed the signs and the total equity remained at - 7.70
> I don't get it.
>
> TIA
> Alain
>
>
>
>
> ___
> gnucash-user mailing list
> [ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org ]
> To update your subscription preferences or to unsubscribe:
> [ https://lists.gnucash.org/mailman/listinfo/gnucash-user |
> https://lists.gnucash.org/mailman/listinfo/gnucash-user ]
> If you are using Nabble or Gmane, please see [
> https://wiki.gnucash.org/wiki/Mailing_Lists |
> 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 

Re: GNUCash 3.0: Report Printing problems

[Dave H]

I've still got two icons - a printer icon and an export to pdf button hence
my confusion :-(

Cheers Dave H.

On 5 April 2018 at 04:36, Adrien Monteleone 
wrote:

> Since reports are PDF and direct printing of PDF was not working with
> WebKit2, the change was made to redirect File > Print and the Print button
> to instead export to PDF for now and the export button was removed since it
> was duplicate functionality. See this bug: https://bugzilla.gnome.org/
> show_bug.cgi?id=787018
>
> Regards,
> Adrien
>
> > On Apr 4, 2018, at 1:27 PM, Dave H  wrote:
> >
> > So I should be able to run a report such as the Balance Sheet and then
> click on the printer icon to print it on one of my physical printers ?
> Currently all that happens is that it wants to save it as a pdf - doesn't
> seem to be an option to send directly to the printer ?
> >
> > GnuCash 3.0, Mac High Sierra 10.13.4 so perhaps not just a Win10 issue ?
> >
> > Cheers Dave H.
> >
> > On 5 April 2018 at 01:00, Adrien Monteleone 
> wrote:
> > Welcome to GnuCash Steve!
> >
> > I just caught up on a thread about W10 printing issues. It seems the
> problem has indeed carried over to the 3.0 series. (and still exists in
> 2.6.x)
> >
> > As long as you can then print that PDF, it’s an extra step, but you
> aren’t locked out of printing.
> >
> > Unfortunately, looking at your questions in 2-4, you might need an extra
> few steps anyway.
> >
> > There’s no need to export first, you can simply select-all and
> copy/paste your report into Excel, and use that to format your printout
> with desired page-breaks, paper size, and footer.
> >
> > Directly to your #3 - Check in File > Page Setup. You can set paper size
> and orientation there.
> >
> > You can’t directly control page breaks, but you can change page
> orientation and you can adjust font-size by editing the stylesheets or
> creating your own stylesheet. However, you’ll likely have to alter this by
> trial and error and then do so each time the report changes. (not very time
> efficient)
> >
> > Likewise, you can customize the Footer stylesheet to your needs which
> will allow you to print a footer on the page. There are some variables to
> use in some places but I’m not sure if page-number and page-count are
> included in these or if they’d even work in the footer. You might have to
> create a custom report. (which would be even more trouble)
> >
> > The easiest way to get all requirements is to copy/paste and format in
> Excel as noted.
> >
> > Please note, a proper reporting system is on the wish list, but it’s
> going to be well down the road until after core parts of the app are
> rebuilt, particularly, the transition to a true database app. Till then, we
> can always use our favorite spreadsheet for custom and ‘pretty printing’.
> >
> > Regards,
> > Adrien
> >
> > > On Apr 4, 2018, at 2:03 AM, Steve Parry  wrote:
> > >
> > > Hi all,
> > >
> > > GNUCash newbie here.
> > >
> > >
> > >
> > > The problems I am having are:
> > >
> > > 1.I can only print to PDF – no option for real printer use. I
> understand this is a problem with GNUCash on W10, so I’ll let that go.
> > >
> > >
> > >
> > > 2.If I create a PDF report it splits whatever is at the page break
> across the pages. For example the top half of a text line will be on the
> bottom of page 1 and the bottom half of the text on page 2. How do I make
> it page break at the end of a line?
> > >
> > >
> > >
> > > 3.Australia use A4 paper, but I can’t see where the PDF page size
> in GNUCash is set up. One Report needs to be in A3 landscape, and currently
> I have to export it to HTML, into Excel, reformat and then print it.  Is
> there a way of setting the PDF print properties for GNUCash?
> > >
> > >
> > >
> > > 4.I want to add a report footer that has “Page x of y” in for my
> multi-page reports. How do I do that?
> > >
> > >
> > >
> > > Thank you everyone – be gentle
> > >
> > >
> > >
> > > Cheers
> > >
> > > …Steve
> > >
> > > ___
> > > 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 

Re: GNUCash 3.0: Report Printing problems

[Dave H]

So I should be able to run a report such as the Balance Sheet and then
click on the printer icon to print it on one of my physical printers ?
Currently all that happens is that it wants to save it as a pdf - doesn't
seem to be an option to send directly to the printer ?

GnuCash 3.0, Mac High Sierra 10.13.4 so perhaps not just a Win10 issue ?

Cheers Dave H.

On 5 April 2018 at 01:00, Adrien Monteleone 
wrote:

> Welcome to GnuCash Steve!
>
> I just caught up on a thread about W10 printing issues. It seems the
> problem has indeed carried over to the 3.0 series. (and still exists in
> 2.6.x)
>
> As long as you can then print that PDF, it’s an extra step, but you aren’t
> locked out of printing.
>
> Unfortunately, looking at your questions in 2-4, you might need an extra
> few steps anyway.
>
> There’s no need to export first, you can simply select-all and copy/paste
> your report into Excel, and use that to format your printout with desired
> page-breaks, paper size, and footer.
>
> Directly to your #3 - Check in File > Page Setup. You can set paper size
> and orientation there.
>
> You can’t directly control page breaks, but you can change page
> orientation and you can adjust font-size by editing the stylesheets or
> creating your own stylesheet. However, you’ll likely have to alter this by
> trial and error and then do so each time the report changes. (not very time
> efficient)
>
> Likewise, you can customize the Footer stylesheet to your needs which will
> allow you to print a footer on the page. There are some variables to use in
> some places but I’m not sure if page-number and page-count are included in
> these or if they’d even work in the footer. You might have to create a
> custom report. (which would be even more trouble)
>
> The easiest way to get all requirements is to copy/paste and format in
> Excel as noted.
>
> Please note, a proper reporting system is on the wish list, but it’s going
> to be well down the road until after core parts of the app are rebuilt,
> particularly, the transition to a true database app. Till then, we can
> always use our favorite spreadsheet for custom and ‘pretty printing’.
>
> Regards,
> Adrien
>
> > On Apr 4, 2018, at 2:03 AM, Steve Parry  wrote:
> >
> > Hi all,
> >
> > GNUCash newbie here.
> >
> >
> >
> > The problems I am having are:
> >
> > 1.I can only print to PDF – no option for real printer use. I
> understand this is a problem with GNUCash on W10, so I’ll let that go.
> >
> >
> >
> > 2.If I create a PDF report it splits whatever is at the page break
> across the pages. For example the top half of a text line will be on the
> bottom of page 1 and the bottom half of the text on page 2. How do I make
> it page break at the end of a line?
> >
> >
> >
> > 3.Australia use A4 paper, but I can’t see where the PDF page size in
> GNUCash is set up. One Report needs to be in A3 landscape, and currently I
> have to export it to HTML, into Excel, reformat and then print it.  Is
> there a way of setting the PDF print properties for GNUCash?
> >
> >
> >
> > 4.I want to add a report footer that has “Page x of y” in for my
> multi-page reports. How do I do that?
> >
> >
> >
> > Thank you everyone – be gentle
> >
> >
> >
> > Cheers
> >
> > …Steve
> >
> > ___
> > 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: GNUCash 3.0: Report Printing problems

[Christopher Lam]

Hi Steve

2-4 can be easily solved by File > Export > Export Report to file, and 
opening the file in a modern web browser for printing.


The report generation code exports to HTML natively, but is limited by 
the webkit implementation used. A modern web browser will obey the html 
rules better.


C

On 04/04/18 11:03, Steve Parry wrote:

Hi all,

GNUCash newbie here.

  


The problems I am having are:

1.  I can only print to PDF – no option for real printer use. I understand 
this is a problem with GNUCash on W10, so I’ll let that go.

  


2.  If I create a PDF report it splits whatever is at the page break across 
the pages. For example the top half of a text line will be on the bottom of 
page 1 and the bottom half of the text on page 2. How do I make it page break 
at the end of a line?

  


3.  Australia use A4 paper, but I can’t see where the PDF page size in 
GNUCash is set up. One Report needs to be in A3 landscape, and currently I have 
to export it to HTML, into Excel, reformat and then print it.  Is there a way 
of setting the PDF print properties for GNUCash?

  


4.  I want to add a report footer that has “Page x of y” in for my 
multi-page reports. How do I do that?

  


Thank you everyone – be gentle

  


Cheers

…Steve

___
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: GNUCash 3.0: Report Printing problems

[Adrien Monteleone]

Since reports are PDF and direct printing of PDF was not working with WebKit2, 
the change was made to redirect File > Print and the Print button to instead 
export to PDF for now and the export button was removed since it was duplicate 
functionality. See this bug: https://bugzilla.gnome.org/show_bug.cgi?id=787018

Regards,
Adrien

> On Apr 4, 2018, at 1:27 PM, Dave H  wrote:
> 
> So I should be able to run a report such as the Balance Sheet and then click 
> on the printer icon to print it on one of my physical printers ?  Currently 
> all that happens is that it wants to save it as a pdf - doesn't seem to be an 
> option to send directly to the printer ?
> 
> GnuCash 3.0, Mac High Sierra 10.13.4 so perhaps not just a Win10 issue ?
> 
> Cheers Dave H.
> 
> On 5 April 2018 at 01:00, Adrien Monteleone  
> wrote:
> Welcome to GnuCash Steve!
> 
> I just caught up on a thread about W10 printing issues. It seems the problem 
> has indeed carried over to the 3.0 series. (and still exists in 2.6.x)
> 
> As long as you can then print that PDF, it’s an extra step, but you aren’t 
> locked out of printing.
> 
> Unfortunately, looking at your questions in 2-4, you might need an extra few 
> steps anyway.
> 
> There’s no need to export first, you can simply select-all and copy/paste 
> your report into Excel, and use that to format your printout with desired 
> page-breaks, paper size, and footer.
> 
> Directly to your #3 - Check in File > Page Setup. You can set paper size and 
> orientation there.
> 
> You can’t directly control page breaks, but you can change page orientation 
> and you can adjust font-size by editing the stylesheets or creating your own 
> stylesheet. However, you’ll likely have to alter this by trial and error and 
> then do so each time the report changes. (not very time efficient)
> 
> Likewise, you can customize the Footer stylesheet to your needs which will 
> allow you to print a footer on the page. There are some variables to use in 
> some places but I’m not sure if page-number and page-count are included in 
> these or if they’d even work in the footer. You might have to create a custom 
> report. (which would be even more trouble)
> 
> The easiest way to get all requirements is to copy/paste and format in Excel 
> as noted.
> 
> Please note, a proper reporting system is on the wish list, but it’s going to 
> be well down the road until after core parts of the app are rebuilt, 
> particularly, the transition to a true database app. Till then, we can always 
> use our favorite spreadsheet for custom and ‘pretty printing’.
> 
> Regards,
> Adrien
> 
> > On Apr 4, 2018, at 2:03 AM, Steve Parry  wrote:
> >
> > Hi all,
> >
> > GNUCash newbie here.
> >
> >
> >
> > The problems I am having are:
> >
> > 1.I can only print to PDF – no option for real printer use. I 
> > understand this is a problem with GNUCash on W10, so I’ll let that go.
> >
> >
> >
> > 2.If I create a PDF report it splits whatever is at the page break 
> > across the pages. For example the top half of a text line will be on the 
> > bottom of page 1 and the bottom half of the text on page 2. How do I make 
> > it page break at the end of a line?
> >
> >
> >
> > 3.Australia use A4 paper, but I can’t see where the PDF page size in 
> > GNUCash is set up. One Report needs to be in A3 landscape, and currently I 
> > have to export it to HTML, into Excel, reformat and then print it.  Is 
> > there a way of setting the PDF print properties for GNUCash?
> >
> >
> >
> > 4.I want to add a report footer that has “Page x of y” in for my 
> > multi-page reports. How do I do that?
> >
> >
> >
> > Thank you everyone – be gentle
> >
> >
> >
> > Cheers
> >
> > …Steve
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 

Re: GNUCash 3.0: Report Printing problems

[Adrien Monteleone]

Perhaps I’m reading that bug report wrong. It may be that the solution 
implemented inadvertently removed direct to printer output. It seems webkit2 
can’t ‘export to pdf’ not that it can’t print at all. (how do Safari and Chrome 
print PDF then?)

Or maybe I’m just not understanding the issue and how GC produces on-screen 
reports.

But yes, I can’t print direct to a real printer either via File > Print or the 
Print button on 10.13.4 either, so not just a Windows or W10 problem.


Regards,
Adrien

> On Apr 4, 2018, at 1:36 PM, Adrien Monteleone  
> wrote:
> 
> Since reports are PDF and direct printing of PDF was not working with 
> WebKit2, the change was made to redirect File > Print and the Print button to 
> instead export to PDF for now and the export button was removed since it was 
> duplicate functionality. See this bug: 
> https://bugzilla.gnome.org/show_bug.cgi?id=787018
> 
> Regards,
> Adrien
> 
>> On Apr 4, 2018, at 1:27 PM, Dave H  wrote:
>> 
>> So I should be able to run a report such as the Balance Sheet and then click 
>> on the printer icon to print it on one of my physical printers ?  Currently 
>> all that happens is that it wants to save it as a pdf - doesn't seem to be 
>> an option to send directly to the printer ?
>> 
>> GnuCash 3.0, Mac High Sierra 10.13.4 so perhaps not just a Win10 issue ?
>> 
>> Cheers Dave H.
>> 
>> On 5 April 2018 at 01:00, Adrien Monteleone  
>> wrote:
>> Welcome to GnuCash Steve!
>> 
>> I just caught up on a thread about W10 printing issues. It seems the problem 
>> has indeed carried over to the 3.0 series. (and still exists in 2.6.x)
>> 
>> As long as you can then print that PDF, it’s an extra step, but you aren’t 
>> locked out of printing.
>> 
>> Unfortunately, looking at your questions in 2-4, you might need an extra few 
>> steps anyway.
>> 
>> There’s no need to export first, you can simply select-all and copy/paste 
>> your report into Excel, and use that to format your printout with desired 
>> page-breaks, paper size, and footer.
>> 
>> Directly to your #3 - Check in File > Page Setup. You can set paper size and 
>> orientation there.
>> 
>> You can’t directly control page breaks, but you can change page orientation 
>> and you can adjust font-size by editing the stylesheets or creating your own 
>> stylesheet. However, you’ll likely have to alter this by trial and error and 
>> then do so each time the report changes. (not very time efficient)
>> 
>> Likewise, you can customize the Footer stylesheet to your needs which will 
>> allow you to print a footer on the page. There are some variables to use in 
>> some places but I’m not sure if page-number and page-count are included in 
>> these or if they’d even work in the footer. You might have to create a 
>> custom report. (which would be even more trouble)
>> 
>> The easiest way to get all requirements is to copy/paste and format in Excel 
>> as noted.
>> 
>> Please note, a proper reporting system is on the wish list, but it’s going 
>> to be well down the road until after core parts of the app are rebuilt, 
>> particularly, the transition to a true database app. Till then, we can 
>> always use our favorite spreadsheet for custom and ‘pretty printing’.
>> 
>> Regards,
>> Adrien
>> 
>>> On Apr 4, 2018, at 2:03 AM, Steve Parry  wrote:
>>> 
>>> Hi all,
>>> 
>>> GNUCash newbie here.
>>> 
>>> 
>>> 
>>> The problems I am having are:
>>> 
>>> 1.I can only print to PDF – no option for real printer use. I 
>>> understand this is a problem with GNUCash on W10, so I’ll let that go.
>>> 
>>> 
>>> 
>>> 2.If I create a PDF report it splits whatever is at the page break 
>>> across the pages. For example the top half of a text line will be on the 
>>> bottom of page 1 and the bottom half of the text on page 2. How do I make 
>>> it page break at the end of a line?
>>> 
>>> 
>>> 
>>> 3.Australia use A4 paper, but I can’t see where the PDF page size in 
>>> GNUCash is set up. One Report needs to be in A3 landscape, and currently I 
>>> have to export it to HTML, into Excel, reformat and then print it.  Is 
>>> there a way of setting the PDF print properties for GNUCash?
>>> 
>>> 
>>> 
>>> 4.I want to add a report footer that has “Page x of y” in for my 
>>> multi-page reports. How do I do that?
>>> 
>>> 
>>> 
>>> Thank you everyone – be gentle
>>> 
>>> 
>>> 
>>> Cheers
>>> 
>>> …Steve
>>> 
>>> ___
>>> 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: GNUCash 3.0: Report Printing problems

[Adrien Monteleone]

I see I have both as well. Perhaps removing it didn’t make it into the final 
commit.

Regards,
Adrien

> On Apr 4, 2018, at 1:46 PM, Dave H  wrote:
> 
> I've still got two icons - a printer icon and an export to pdf button hence 
> my confusion :-(
> 
> Cheers Dave H.
> 
> On 5 April 2018 at 04:36, Adrien Monteleone  
> wrote:
> Since reports are PDF and direct printing of PDF was not working with 
> WebKit2, the change was made to redirect File > Print and the Print button to 
> instead export to PDF for now and the export button was removed since it was 
> duplicate functionality. See this bug: 
> https://bugzilla.gnome.org/show_bug.cgi?id=787018
> 
> Regards,
> Adrien
> 
> > On Apr 4, 2018, at 1:27 PM, Dave H  wrote:
> >
> > So I should be able to run a report such as the Balance Sheet and then 
> > click on the printer icon to print it on one of my physical printers ?  
> > Currently all that happens is that it wants to save it as a pdf - doesn't 
> > seem to be an option to send directly to the printer ?
> >
> > GnuCash 3.0, Mac High Sierra 10.13.4 so perhaps not just a Win10 issue ?
> >
> > Cheers Dave H.
> >
> > On 5 April 2018 at 01:00, Adrien Monteleone  
> > wrote:
> > Welcome to GnuCash Steve!
> >
> > I just caught up on a thread about W10 printing issues. It seems the 
> > problem has indeed carried over to the 3.0 series. (and still exists in 
> > 2.6.x)
> >
> > As long as you can then print that PDF, it’s an extra step, but you aren’t 
> > locked out of printing.
> >
> > Unfortunately, looking at your questions in 2-4, you might need an extra 
> > few steps anyway.
> >
> > There’s no need to export first, you can simply select-all and copy/paste 
> > your report into Excel, and use that to format your printout with desired 
> > page-breaks, paper size, and footer.
> >
> > Directly to your #3 - Check in File > Page Setup. You can set paper size 
> > and orientation there.
> >
> > You can’t directly control page breaks, but you can change page orientation 
> > and you can adjust font-size by editing the stylesheets or creating your 
> > own stylesheet. However, you’ll likely have to alter this by trial and 
> > error and then do so each time the report changes. (not very time efficient)
> >
> > Likewise, you can customize the Footer stylesheet to your needs which will 
> > allow you to print a footer on the page. There are some variables to use in 
> > some places but I’m not sure if page-number and page-count are included in 
> > these or if they’d even work in the footer. You might have to create a 
> > custom report. (which would be even more trouble)
> >
> > The easiest way to get all requirements is to copy/paste and format in 
> > Excel as noted.
> >
> > Please note, a proper reporting system is on the wish list, but it’s going 
> > to be well down the road until after core parts of the app are rebuilt, 
> > particularly, the transition to a true database app. Till then, we can 
> > always use our favorite spreadsheet for custom and ‘pretty printing’.
> >
> > Regards,
> > Adrien
> >
> > > On Apr 4, 2018, at 2:03 AM, Steve Parry  wrote:
> > >
> > > Hi all,
> > >
> > > GNUCash newbie here.
> > >
> > >
> > >
> > > The problems I am having are:
> > >
> > > 1.I can only print to PDF – no option for real printer use. I 
> > > understand this is a problem with GNUCash on W10, so I’ll let that go.
> > >
> > >
> > >
> > > 2.If I create a PDF report it splits whatever is at the page break 
> > > across the pages. For example the top half of a text line will be on the 
> > > bottom of page 1 and the bottom half of the text on page 2. How do I make 
> > > it page break at the end of a line?
> > >
> > >
> > >
> > > 3.Australia use A4 paper, but I can’t see where the PDF page size in 
> > > GNUCash is set up. One Report needs to be in A3 landscape, and currently 
> > > I have to export it to HTML, into Excel, reformat and then print it.  Is 
> > > there a way of setting the PDF print properties for GNUCash?
> > >
> > >
> > >
> > > 4.I want to add a report footer that has “Page x of y” in for my 
> > > multi-page reports. How do I do that?
> > >
> > >
> > >
> > > Thank you everyone – be gentle
> > >
> > >
> > >
> > > Cheers
> > >
> > > …Steve
> > >
> > > ___
> > > 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 

RE: GNUCash 3.0: Report Printing problems

[Steve Parry]

Hi Adrien.

 

Thanks for your prompt replies to this and the subsequent comments from others.

 

Re #3 (page size) - I'm not sure from my testing that this affects the PDF 
output, maybe it's only the hysical printing formatting (when it is working 
again!)?.

 

Regardless, it does seem that the copy and paste to excel may be the most 
expedient way of formatting. I'm writing VBA Macros to auto format my common 
reports. Thank you for the tip about copy and paste rather than go through the 
HTML step

 

Re page numbers in the footer, I haven't found any variable for that, but as I 
will now be going through Excel that's not required.

 

I suggest that financial reporting is a very high priority, and having that as 
an integral function of GNUCash will be a huge timesaver globally amongst your 
users

 

Thanks again for your guidance.

 

Cheers

...Steve

 

 

-Original Message-
From: gnucash-user  On 
Behalf Of Adrien Monteleone
Sent: Thursday, 5 April 2018 01:00
To: GnuCash User List 
Subject: Re: GNUCash 3.0: Report Printing problems

 

Welcome to GnuCash Steve!

 

I just caught up on a thread about W10 printing issues. It seems the problem 
has indeed carried over to the 3.0 series. (and still exists in 2.6.x)

 

As long as you can then print that PDF, it’s an extra step, but you aren’t 
locked out of printing.

 

Unfortunately, looking at your questions in 2-4, you might need an extra few 
steps anyway.

 

There’s no need to export first, you can simply select-all and copy/paste your 
report into Excel, and use that to format your printout with desired 
page-breaks, paper size, and footer.

 

Directly to your #3 - Check in File > Page Setup. You can set paper size and 
orientation there.

 

You can’t directly control page breaks, but you can change page orientation and 
you can adjust font-size by editing the stylesheets or creating your own 
stylesheet. However, you’ll likely have to alter this by trial and error and 
then do so each time the report changes. (not very time efficient)

 

Likewise, you can customize the Footer stylesheet to your needs which will 
allow you to print a footer on the page. There are some variables to use in 
some places but I’m not sure if page-number and page-count are included in 
these or if they’d even work in the footer. You might have to create a custom 
report. (which would be even more trouble)

 

The easiest way to get all requirements is to copy/paste and format in Excel as 
noted.

 

Please note, a proper reporting system is on the wish list, but it’s going to 
be well down the road until after core parts of the app are rebuilt, 
particularly, the transition to a true database app. Till then, we can always 
use our favorite spreadsheet for custom and ‘pretty printing’.

 

Regards,

Adrien

 

> On Apr 4, 2018, at 2:03 AM, Steve Parry <  
> spa...@vidar.com.au> wrote:

> 

> Hi all,

> 

> GNUCash newbie here.

> 

> 

> 

> The problems I am having are: 

> 

> 1. I can only print to PDF – no option for real printer use. I 
> understand this is a problem with GNUCash on W10, so I’ll let that go.

> 

> 

> 

> 2. If I create a PDF report it splits whatever is at the page break 
> across the pages. For example the top half of a text line will be on the 
> bottom of page 1 and the bottom half of the text on page 2. How do I make it 
> page break at the end of a line?

> 

> 

> 

> 3. Australia use A4 paper, but I can’t see where the PDF page size in 
> GNUCash is set up. One Report needs to be in A3 landscape, and currently I 
> have to export it to HTML, into Excel, reformat and then print it.  Is there 
> a way of setting the PDF print properties for GNUCash?

> 

> 

> 

> 4. I want to add a report footer that has “Page x of y” in for my 
> multi-page reports. How do I do that?

> 

> 

> 

> Thank you everyone – be gentle

> 

> 

> 

> Cheers

> 

> …Steve

> 

> ___

> 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: GNUCash 3.0: Report Printing problems

[Steve Parry]

Hi Chris,

Thanks for your reply.

Yes and no - printing the HTML directly or via PDF puts in multiple page breaks 
- eg blank page, heading, page break, report body, page break.

 

I'll stick to the Excel solution for now I think

 

Cheers

...Steve

 

 

-Original Message-
From: gnucash-user  On 
Behalf Of Christopher Lam
Sent: Thursday, 5 April 2018 04:34
To: gnucash-user@gnucash.org
Subject: Re: GNUCash 3.0: Report Printing problems

 

Hi Steve

 

2-4 can be easily solved by File > Export > Export Report to file, and opening 
the file in a modern web browser for printing.

 

The report generation code exports to HTML natively, but is limited by the 
webkit implementation used. A modern web browser will obey the html rules 
better.

 

C

 

On 04/04/18 11:03, Steve Parry wrote:

> Hi all,

> 

> GNUCash newbie here.

> 

>   

> 

> The problems I am having are:

> 

> 1. I can only print to PDF – no option for real printer use. I 
> understand this is a problem with GNUCash on W10, so I’ll let that go.

> 

>   

> 

> 2. If I create a PDF report it splits whatever is at the page break 
> across the pages. For example the top half of a text line will be on the 
> bottom of page 1 and the bottom half of the text on page 2. How do I make it 
> page break at the end of a line?

> 

>   

> 

> 3. Australia use A4 paper, but I can’t see where the PDF page size in 
> GNUCash is set up. One Report needs to be in A3 landscape, and currently I 
> have to export it to HTML, into Excel, reformat and then print it.  Is there 
> a way of setting the PDF print properties for GNUCash?

> 

>   

> 

> 4. I want to add a report footer that has “Page x of y” in for my 
> multi-page reports. How do I do that?

> 

>   

> 

> Thank you everyone – be gentle

> 

>   

> 

> Cheers

> 

> …Steve

> 

> ___

> 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: What does your Summary Bar say in Gnucash-3.0? Mine is rude

[Di Mang]

​On Ubuntu 17.10 (with XFCE) works the summary bar right: without
truncation.

Build ID: git 3.0-4-g70e636646+ (2018-04-01)
___
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: Unrealized loss

[nvsoar]

Hm.  Seems to me that a price is added to the system any time a 
stock is purchased or sold, or when a dividend is reinvested.

nvsoar

On 04/04/18 09:32, Adrien Monteleone wrote:

The value will usually change based on that setting. Sometimes ‘latest’ and 
’nearest in time’ will be the same, but that depends on running the report ON 
an actual day (not FOR an actual day) that is on or after a price update and 
before the next price update.

First, you say you deleted all rates updated automatically by GC without you 
noticing. (does not happen, you have to open the price editor and tell it to 
‘get quotes’) This leaves the presumption that there are other prices in the db 
that you either entered manually or intentionally updated with the ‘get quotes’ 
button.

Then you say there are NO rates in the system.

Which is it?

If you open the Price Database is there anything at all listed in the window? 
(this includes a Currencies tree)

Do you have ANY transactions where you purchased or entered an opening balance 
for a commodity or any currency other than the default book currency? (EUR)

If you go to File > Properties, is ‘Use Trading Accounts’ checked?

Regards,
Adrien


On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote:

I suspect there is a bug that should be reported:

As I do NOT manage currencies other than EUR and no traders accounts taking 
into account share values, I have deleted all exchanges rates that had been 
updated automatically by GC without my noticing.
BUT my Unrealized loss on a given day varies according to my setting the calculation mode to 
"average" or "nearest in time" for instance. It doesn's seem to make sense 
since there are NO exchange rates in my system.

Ideas?
TIA
Alain




De: "sunfish62" 
À: cag...@free.fr, "John Ralls" 
Cc: "gnucash-user" 
Envoyé: Lundi 2 Avril 2018 14:52:46
Objet: Re: Unrealized loss

Alain,

Your new transaction is balanced, and won't affect the imbalance in another 
transaction.

I personally find the unrealized gains issue to be exceedingly difficult to 
understand. Since you say you don't care about this, just ignore it.

David T




On Mon, Apr 2, 2018 at 17:02, cag...@free.fr
 wrote:



De: [ mailto:cag...@free.fr | cag...@free.fr ]
À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org 
] >
Envoyé: Lundi 2 Avril 2018 13:51:03
Objet: Re: Unrealized loss




De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] >
À: [ mailto:cag...@free.fr | cag...@free.fr ]
Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org 
] >
Envoyé: Dimanche 1 Avril 2018 15:34:43
Objet: Re: Unrealized loss






On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | cag...@free.fr 
] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote:


Hello.

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70).

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer.

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book keeping is 
fully personal so I'd like to know the procedure.




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] | [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] .

Regards,
John Ralls



I have identified the day on which the unrealized lossed first appeared. I have 
drawn a transaction report for that day (and the day before). There is no 
transaction that can remotely explain the loss.
I do not handle foreign currencies. Regarding shares I do not use trader 
accounts or split transactions including profits or losses. I do not enter 
share values into GC until the day I sell them. There is no way in the meantime 
GC can take into account a difference in value.

Something might help identify where the problem comes from: I had another 
instance with an unrealized loss as big as my total yearly income. It went away 
a few weeks (or months I'm not sure) after it showed up. There is no way a 
single transaction (or even a few ) on a particular day triggered an unrealized 
loss as big as my yearly income.

What I would like at this stage is simply set GC NOT to SHOW unrealized 

Issue compiling: any assistance?

[Doug]

Tex, the Administrator of PCLinuxos struck a problem. Can you help please?
(I am not a developer, but can pass any help on)

regards, Doug


Re: GnuCash
« Reply #2 on: Yesterday at 01:28:20 AM »

Quote

I've spent hours on this and this is what it gives me even though the library 
is installed in /usr/lib64/gnucash. I'm tired of it for now.

[tex@localhost SPECS]$ gnucash
gnucash: error while loading shared libraries: libgncmod-gnome-utils.so: cannot 
open shared object file: No such file or directory


-- 
Doug 
___
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: gnucash 3.0 crashes opening accounts file

[Thevenin]

I've suffered the same today with my new install. It's never worked :)

My install is on Win10, and a redacted version of the trace log is below.

If you'd like me to post this to a new topic or elsewhere, let me know.

"* 16:00:17  INFO  [main] System locale returned English_United
States.1252
* 16:00:17  INFO  [main] Effective locale set to English_United
States.1252.
* 16:00:17  INFO  [gnc_load_app_icons] The icon theme search path
has 10 elements.
* 16:00:17  INFO  [gnc_load_app_icons] Path 0:
C:\Users\krada\AppData\Local\icons
* 16:00:17  INFO  [gnc_load_app_icons] Path 1:
C:\Users\krada\.icons
* 16:00:17  INFO  [gnc_load_app_icons] Path 2: c:\Program Files
(x86)\gnucash/share\icons
* 16:00:17  INFO  [gnc_load_app_icons] Path 3:
/usr/local/share/icons
* 16:00:17  INFO  [gnc_load_app_icons] Path 4: /usr/share/icons
* 16:00:17  INFO  [gnc_load_app_icons] Path 5: c:\Program Files
(x86)\gnucash/share\pixmaps
* 16:00:17  INFO  [gnc_load_app_icons] Path 6:
/usr/local/share/pixmaps
* 16:00:17  INFO  [gnc_load_app_icons] Path 7: /usr/share/pixmaps
* 16:00:17  INFO  [gnc_load_app_icons] Path 8: c:\Program Files
(x86)\gnucash\share\gnucash\icons
* 16:00:17  INFO  [gnc_load_app_icons] Path 9: c:\Program Files
(x86)\gnucash\share\icons
* 16:00:17  INFO  [gnc_hook_lookup] no hook lists
* 16:00:17  INFO  [gnc_module_init_backend_dbi] GNC_DBD_DIR
not set: using libdbi built-in default
* 16:00:17  INFO  [gnc_module_init_backend_dbi] 3 DBD
drivers found
* 16:00:17  INFO  [gnc_module_init_backend_dbi] Driver:
mysql
* 16:00:17  INFO  [gnc_module_init_backend_dbi] Driver:
pgsql
* 16:00:17  INFO  [gnc_module_init_backend_dbi] Driver:
sqlite3
* 16:00:29 MESSG  Could not locate optional module
gnucash/python interface v.0
* 16:00:29 MESSG  loading system configuration
* 16:00:29 MESSG  loading user configuration
* 16:00:29 MESSG  loading saved reports
* 16:00:29 MESSG  loading stylesheets
* 16:00:34 MESSG  Found Finance::Quote version 1.47
* 16:00:34  INFO  [xaccAccountRecomputeBalance] acct=Template
Root starting baln=0/1

...run through addition of currency values...

* 16:00:34  INFO  [QofSessionImpl::load_backend]  Selected
provider GnuCash Libdbi (SQLITE3) Backend
* 16:00:34  INFO  [QofDbiBackendProvider::type_check]
exists, does not have SQLite format string -> not DBI
* 16:00:34  INFO  [QofSessionImpl::load_backend] Provider,
GnuCash Libdbi (SQLITE3) Backend, reported not being usable for book,
file://G:\Gnu2018\GNU2018.gnucash.
* 16:00:34  INFO  [QofSessionImpl::load_backend] The provider
providers access_method, sqlite3, but we're loading for access_method, file.
Skipping.
* 16:00:34  INFO  [QofSessionImpl::load_backend] The provider
providers access_method, mysql, but we're loading for access_method, file.
Skipping.
* 16:00:34  INFO  [QofSessionImpl::load_backend] The provider
providers access_method, postgres, but we're loading for access_method,
file. Skipping.
* 16:00:34  INFO  [QofSessionImpl::load_backend] The provider
providers access_method, xml, but we're loading for access_method, file.
Skipping.
* 16:00:34  INFO  [QofSessionImpl::load_backend]  Selected
provider GnuCash File Backend Version 2
* 16:00:34  INFO  [GncXmlBackend::session_begin]
logpath=G:\Gnu2018\GNU2018.gnucash
* 16:00:34  INFO  [QofSessionImpl::begin] Done running
session_begin on backend
* 16:01:40  INFO  [QofSessionImpl::load_backend]  Selected
provider GnuCash Libdbi (SQLITE3) Backend
* 16:01:40  INFO  [QofDbiBackendProvider::type_check]
exists, does not have SQLite format string -> not DBI
* 16:01:40  INFO  [QofSessionImpl::load_backend] Provider,
GnuCash Libdbi (SQLITE3) Backend, reported not being usable for book,
file://G:\Gnu2018\GNU2018.gnucash.
* 16:01:40  INFO  [QofSessionImpl::load_backend] The provider
providers access_method, sqlite3, but we're loading for access_method, file.
Skipping.
* 16:01:40  INFO  [QofSessionImpl::load_backend] The provider
providers access_method, mysql, but we're loading for access_method, file.
Skipping.
* 16:01:40  INFO  [QofSessionImpl::load_backend] The provider
providers access_method, postgres, but we're loading for access_method,
file. Skipping.
* 16:01:40  INFO  [QofSessionImpl::load_backend] The provider
providers access_method, xml, but we're loading for access_method, file.
Skipping.
* 16:01:40  INFO  [QofSessionImpl::load_backend]  Selected
provider GnuCash File Backend Version 2
* 16:01:40  INFO  [GncXmlBackend::session_begin]
logpath=G:\Gnu2018\GNU2018.gnucash
* 16:01:40  INFO  [QofSessionImpl::begin] Done running
session_begin on backend
* 16:01:40  INFO  [xaccAccountRecomputeBalance] acct=Template
Root starting baln=0/1

More commodity lines...

* 16:01:40  INFO  [QofSessionImpl::load] new book=0c1115f8

...Loads multiple investment account funds...

* 16:01:40  INFO  [xaccAccountSetGUID] acct=0c0e0488
* 16:01:40  INFO  [xaccAccountRecomputeBalance] acct=Root
Account starting baln=0/1
* 16:01:40  INFO  [xaccAccountSetGUID] acct=0c0e0288
* 16:01:40  INFO  

Re: Printing no longer works on Windows 10 Pro

[VidarParry]

Geert Janssens-4 wrote
> Now if the 3.0 release has the same issue, that would be a more likely get
> our 
> attention. So it would be useful if one of you that's having this issue
> can 
> try what happens when doing the same with the most recent gnucash 2.7.5 
> release. Keep in mind this is beta software, so use it only after you have 
> made a backup of your books!

I can confirm the problem is still occurring in GNUCash v3.0 on Windows 10
Home.

Cheers
...Steve



--
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 3.0: Report Printing problems

[Steve Parry]

Hi all,

GNUCash newbie here.

 

The problems I am having are: 

1.  I can only print to PDF – no option for real printer use. I understand 
this is a problem with GNUCash on W10, so I’ll let that go.

 

2.  If I create a PDF report it splits whatever is at the page break across 
the pages. For example the top half of a text line will be on the bottom of 
page 1 and the bottom half of the text on page 2. How do I make it page break 
at the end of a line?

 

3.  Australia use A4 paper, but I can’t see where the PDF page size in 
GNUCash is set up. One Report needs to be in A3 landscape, and currently I have 
to export it to HTML, into Excel, reformat and then print it.  Is there a way 
of setting the PDF print properties for GNUCash?

 

4.  I want to add a report footer that has “Page x of y” in for my 
multi-page reports. How do I do that?

 

Thank you everyone – be gentle

 

Cheers

…Steve

___
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: Importing Quicken

[Alen Siljak]

Hi, David,

You are right. I've removed the benefits section but kept the fact about open 
data standards. Apart from being a benefit (to me), it is also a consequence of 
migration that may or may not be important for users.

> You mention multi-currency problems with QIF, saying that GnuCash only 
> handles one currency per file. However, I am under the impression that the 
> problem of multiple currencies had to do with the *QIF* specification, and 
> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?

Yes, that's probably true. However, if an application interprets a transfer in 
such a manner that it takes 100 Euros from one and then deposits 100 AUD into 
another account without warning the user, that's a big no-no for me.

Thanks for the feedback!
___
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: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

Thanks John - I expect puttingin proxy configuration won't be too difficult.
I will have a look later.

BTW I got the exact same crash running gc3 at home, opening the same
accounts file. Perhaps it is related to the accounts file. I have been using
gnucash for some years now, my file is 1.4MB in size - is that considered
large?

Anyway it means I can debug it at home now, when I have the time.

Regards
Patrick



--
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: Re: GnuCash 3.0 Released

[Thomas Bray]

Good morning John,

The Github download link for GnuCash's 3.0 release is incorrect on the 
page/mailing list email below:


https://lists.gnucash.org/pipermail/gnucash-user/2018-April/075866.html

(Sorry, I'm fairly new to FOSS and don't quite know the terminology/how 
best to let you know)


The listed Github Win32 link is (incorrectly) listed as the following:

"Download GnuCash for Win32: 
https://github.com/Gnucash/gnucash/releases/download/3.0/gnucash-3.0.setup.exe; 



The valid direct link for the download is instead: 
_https://github.com/Gnucash/gnucash/releases/download/3.0/gnucash-3.0.-setup.exe_ 
(note the extra hyphen between "3.0." and "setup."


I'm excited to try out GnuCash; have a great day!

Best,

Thomas Bray

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