Re: [GNC] Switching to trading accounts in existing database

[Christoph R]

Hi Mike, Lukas,

I am using trading accounts since multiple years and can confirm that the UI 
can be pretty cumbersome. I got used to it. Besides the regular problems in 
getting the transactions straight it works pretty well

Cheers,
Christoph

> Am 22.01.2021 um 06:13 schrieb Mike Alexander :
> 
> When I implemented trading accounts several years ago they were a bit 
> controversial.  Some people thought they were more trouble than they were 
> worth and argued that they should be an opt-in choice.  One of the initial 
> design goals was that if you didn't turn them on nothing would change in the 
> way GnuCash behaved.  The initial implementation had some rough edges too, 
> which didn't help.  It's been a while since any significant problems have 
> come up with them (although a new bug was filed on them today) so maybe this 
> question should be revisited.
> 
> It's also the case that the user interface leaves a bit to be desired.  It is 
> harder than it should be to enter multi-currency transactions with trading 
> accounts turned on.  At the time I implemented them there was an effort 
> underway to rewrite the code that supports the register UI and the new 
> implementation would have improved this.  Unfortunately that effort was later 
> abandoned and we're left with the old UI code.  I have ideas for how to 
> improve it, but my time and ability to do much coding is limited these days 
> so I probably won't get to it soon.  See 
> https://bugs.gnucash.org/show_bug.cgi?id=797913 for more information about 
> this.
> 
> I know what you mean about multiple currencies.  I haven't moved around as 
> often as you have, but I've lived in a couple of countries and spend a lot of 
> time traveling in various others.  I think I have accounts in nearly 30 
> currencies over a 30 year period.  I used to have income and expense accounts 
> in multiple currencies, but this turned out to not work well so I now use 
> only one currency for all of them and convert transactions in other 
> currencies into USD.  This works for me since it is still my home currency 
> although I am under increasing pressure to move to Canada.
> 
> Mike
> 
> On 21 Jan 2021, at 21:06, Lukas Haase wrote:
> 
>> Hi Christopher,
>> 
>> This is very sad. Sad for various reasons.
>> 
>> I went over these documents previously (but did not read them thoroughly).
>> 
>> My takeaway is:
>> * Storing the conversion rate per transaction makes the accounting equation 
>> as a function of time inconsistent (but it is consistent for each snaphot in 
>> time).
>> * Trading account accounts for these inaccuracies.
>> 
>> My question was more why the trading accounts (which seem to me the cleaner, 
>> superior and better way) are not enabled by default.
>> 
>> Also, can you comment a bit more why precicely this would be a major 
>> minefield? (If you know it, of course).
>> 
>> Multiple databases are just extremely hard for some people (like me).
>> 
>> Consider living for a couple of months to a year in a different place. There 
>> is just no way to separate this in a clean way without replicating all the 
>> transactions in different databases. BTDT.
>> 
>> Also I moved multiple times. Even then, there is no clear cut: Initially I 
>> would use credit cards, ATM etc. from previous country. Even the first or 
>> second rent may be partially paid with funds from the previous location. It 
>> takes a few months until I could consider the books between two countries 
>> sufficiently separate. The only ways are a) Massive transaction Replication 
>> b) booking everything I pay with funds from old country into old database. 
>> But with my rent example, it gets very inconsistent how much I paid rent at 
>> the new place.
>> 
>> Lastly, simple portfolio accounting (e.g. crypto currencies) if they are 
>> bought in different countries.
>> 
>> I am curious what the potential mines are so I can try to avoid them.
>> 
>> Lukas
>> 
>> 
>> 
>> On 2021-01-21 20:20, Christopher Lam wrote:
>>> Multicurrency is a major minefield.
>>> Start from https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
>>> and finish with
>>> https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
>>> background on trading accounts.
>>> From discussion with accountant, it would seem that the safest approach is
>>> to have 1 book per home currency. When you move countries you'd be better
>>> off with a new book with a new home currency. Taking temporary trips abroad
>>> gets the currencies translated to home currency. AFAIU. IANAA YMMV.
>>> https://techcrunch.com/2010/08/14/internet-must-be-true/
>>> 
>>> On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:
>>> 
 Hi Mike,
 
 On 2021-01-21 02:24, Mike Alexander wrote:
> On 19 Jan 2021, at 20:08, Lukas Haase wrote:
> 
>> So I got recommended using trading accounts. But suddenly all my
>> previous multi-currency transactions get a small grey box with a cross
>> (hinting the transaction is 

Re: [GNC] Online action "Get Transactions" not available for this account

[Christoph R]

Hi,

this happens to me sometimes too. A restart of Gnucash normally solves it. 

I did not figure out the circumstances yet. 

Cheers,
Christoph

> Am 17.09.2020 um 21:37 schrieb a b :
> 
> PS: hbci is activated, just checked with the bank's online banking page.
> 
> PPS: Running Gnucash via Flatpak.
> 
> On Thu, 17 Sep 2020, 21:12 a b,  wrote:
> 
>> Hi there,
>> 
>> After finally overcoming the PhotoTAN issue with a Python script and
>> having successfully loaded and mapped the accounts I tried - for the first
>> time since it broke with PSD2 last year - to load the transactions into
>> Gnucash, only to be short changed again with an error message: Online
>> action "Get Transactions" not available for this account.
>> 
>> As a quick Google search didn't yet yield any useful results: any idea
>> here how to resolve? Would I need to talk to my bank to reenable some
>> setting or is it something I can amend locally?
>> 
>> Thanks for your help!
>> 
>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] multiple currencies in one transaction

[Christoph R]

Hi Mike,

> It seems to me that the simplest solution, and one that might work reasonably 
> well, is to make it possible (via a view option) to switch any register into 
> the format used for non-currency registers where there are separate columns 
> for shares, price, and value for each split.


as a heavy user of multiple currencies and trading accounts I would very much 
welcome that.

Cheers,
Christoph

> Am 20.08.2019 um 00:36 schrieb Mike Alexander :
> 
> I’ve been thinking for a while about how the register could be changed to 
> better handle multiple currency transactions with trading accounts   turned 
> on.  Back when I implemented trading accounts I knew this was a problem.  
> However at that time it was expected that the Register2 rewrite of the 
> register code would make the old register code obsolete so I didn’t worry 
> about it too much.  This is clearly no longer a valid assumption.
> 
> It seems to me that the simplest solution, and one that might work reasonably 
> well, is to make it possible (via a view option) to switch any register into 
> the format used for non-currency registers where there are separate columns 
> for shares, price, and value for each split.  The labels would need to be 
> changed for currency splits since “shares” becomes the value in the split’s 
> currency, “price” becomes exchange rate, and "value" remains the value in the 
> transaction currency.  Getting all the details right might be tricky, but 
> this seems to have possibilities.
> 
> The current code shows only one of those three values, and which one depends 
> on whether trading accounts are turned on.  If they are on it shows the value 
> in the split’s currency.  If off, it shows the value in the transaction's 
> currency.  This adds still more confusion to the situation.  A simple change 
> would be to make it always show the value in the split’s currency.  At least 
> then there wouldn’t be this confusion about what is being shown.  I didn’t do 
> this at the time because one of the goals was to make GnuCash work identical 
> to the way it worked before if trading accounts were turned off.
> 
> If I get some free time I might try to play around with this idea and see 
> where it goes.  If anyone else thinks this might work and wants to take a 
> crack at it, be my guest.  My time for software development is very limited 
> these days.
> 
>   Mike
> 
> PS: this probably should be moved to the Dev list if someone wants to 
> continue the discussion.
> 
>> On Aug 16, 2019, at 2:12 PM, John Ralls  wrote:
>> 
>> It's a difference in the way that the register works with or without trading 
>> accounts. If trading accounts are turned off then the register displays all 
>> splits converted to that register account's currency. If they're on then it 
>> displays each split in its own account's currency, with symbols for all but 
>> the current register's currency.
>> 
>> When dealing with multiple currencies "balance" can adopt different 
>> meanings. GnuCash requires that a transaction must balance in the 
>> transaction currency, which is generally the one for the account in whose 
>> register the transaction was created (or the first parent account 
>> denominated in a currency if the register is for a non-currency account). 
>> Since in a currency register the transaction currency value and the exchange 
>> rate between the register currency and transaction currency are hidden that 
>> can be difficult, especially in split view where the user is responsible for 
>> getting the (possibly invisible) values right. The more currencies involved 
>> in the transaction the harder it gets.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Aug 16, 2019, at 9:39 AM, Jeff Abrahamson  wrote:
>>> 
>>> Thanks, that's great, I'll have a play with that after work.
>>> 
>>> Two points concern me:
>>> 
>>> 1.  I don't see currency symbols in my registers.  Is this a setting?
>>> 
>>> 2.  I've been taught in accounting that transactions must balance, and
>>> so I was expecting to see the GBP register all in GBP, the CHF register
>>> all in CHF, and the EUR register all in EUR.  That is, if one sums the
>>> columns of a register, the Dr and Cr columns should have the same sum. 
>>> Am I confused about this principle?
>>> 
>>> I'll need to read about the trading accounts feature.  As someone who
>>> regularly spends money in several currencies, I don't really think of
>>> these transactions as P related, though I'm aware they could be
>>> modeled that way.
>>> 
>>> Jeff
>>> 
>>> 
>>> On 16/08/2019 18:13, Adrien Monteleone wrote:
 So the Cafe’s price was CHF 5.70?
 Your card was debited GBP 4.67?
 
 The Expense:Coffee account is set to EUR?
 
 
 First, yes, you’ll need Trading Accounts turned on.
 
 Second, open the price db and fetch rates, then check the EUR-GBP rate, 
 you’ll need it later. (I don’t see a way around this at present) For this 
 example, we’ll use 1.0957 

Re: [GNC] Concern with the lengthy list of "Known Issues"

[Christoph R]

Hi,

I am using gnucash since 2004 for multiple accounts and have my whole personal 
history since then in one file. I am running gnucash on MacOs in German which 
is somewhat special and the only dev for MacOs is John. Thanks to him for all 
the work putting he is putting in! I was a pretty happy user up until 3.0. 

But with the 3.x series there are more problems than I am used to and progress 
is very slow. The only version working for me so far is 3.5, which is my 
production version for now. Versions before crashed or failed on important 
operations (like the csv importer, which is the main reason I am using 3.x). 
3.6 apparently has a stray ifdef on MacOs which makes the program always fall 
back to English. So I am back to 3.5.

And the release cycle is pretty long. So even when bugs are fixed it takes a 
lot of time to get them in a stable build.

As much as I am proponent of using the latest software versions: with gnucash 
3.x I cannot wholeheartedly
recommend it. The good thing though is that you can try and go back. The latest 
2.x version reads 3.x files. And switching between 3.x versions back and forth 
works too.

Cheers,
Christoph

> Am 21.07.2019 um 19:31 schrieb scotts :
> 
> I have been using Gnucash for about 3 years now, and for the most part
> enjoying the experience! I use it for my personal finances (bank accounts,
> credit cards, investments, etc). I am also the treasurer of a golf club
> association and am considering moving their accounting over to Gnucash.
> 
> I am currently using Windows version 2.6.21. Of course at the moment, the
> most current stable release is version 3.6. My only hesitation in upgrading
> is what seems to me to be a very long list of "known issues" with the
> release.
> 
> I'm looking for other opinions. In my experience, version 2.6.21 seems to
> pretty much work as advertised. No crashes, runs quickly enough on my
> computer, all the functions I've tried seem to work fine. Normally I would
> upgrade any software to the latest release, hopefully taking advantage of
> bug fixes and new features. But when I see the long list of issues, I
> hesitate.
> 
> Would appreciate any comments from others. Am I being overly paranoid?
> Thanks a lot!
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Should the CSV Importer obey with the "automatic digital point" setting?

[Christoph R]

Hi,

currently the CSV importer obeys with the “automatic digital point” setting in 
Preferences->General.

IMO this should be changed. The above setting is a convenience for manual 
input. But csv files are normally generated automatically and often do not 
include a point for whole figures. In that case the imported figure will be 
wrong - which happened to me.

Any opinions?

Cheers,
Christoph

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

Re: [GNC] Backspace key stops working

[Christoph R]

Ok, I digged a bit more and found the following behavior:

- In the register go to the accounts field and type the first letter of an 
existing account
- the accounts picker comes up.
- select the account. 
- Select any other input field

Now it’s messed up:

- hitting Right, Left or the CMD key selects to everything after the first 
letter. 
- Right and left do nothing any more. 
- Trying to select another position with the mouse does initially seem to work. 
But as soon as you want to do something you are back to the previous selection

If you typed more in step one, the selection will start after the length of 
your input before selecting the account from the picker.

HTH


Gruß,
Christoph

> Am 30.12.2018 um 10:07 schrieb David Carlson :
> 
> John requested that users report every detail of your actions leading up to 
> the problem and exactly which keystrokes do not work.  So far the developers 
> cannot replicate the problem.  A "Same here" comment does not help with 
> diagnosing the problem.
> 
> David C
> 
> On Sun, Dec 30, 2018 at 2:09 AM Christoph R  <mailto:subscriptions%2blis...@rohland.net>> wrote:
> Same here
> 
> Gruß,
> Christoph
> 
> > Am 30.12.2018 um 04:49 schrieb Bruce Lang  > <mailto:quil...@chariot.net.au>>:
> > 
> > Me too
> > 
> > Issue is when I enter a new transaction. It auto-fills the previous similar 
> > transaction which is what I want but when I go to edit the details - 
> > let's say I want to change a word using Shift-Back (or Forward) arrow, it 
> > selects either a section of the words starting about 4 characters from the 
> > left and extending about 8 characters across, rather than the parts of the 
> > words or whole words that I want to remove. For example "if the first words 
> > are "coaching session" it will highlight "ching sessi"), no matter where I 
> > have the cursor positioned in the field when I depress the shift key. 
> > However, if I start typing from the positioned cursor, the issue 
> > disappears... I can then edit as usual.
> > 
> > It's not a big issue... but irritating.
> > 
> > *Bruce*
> > 
> > **
> > 
> > On 29/12/2018 11:19 am, Ethan Swint wrote:
> >> Just encountered this bug/feature again - the backspace key stops working, 
> >> only in Gnucash, and Gnucash must be restarted to restore the 
> >> functionality. I remember encountering this pre-Gnucash 3.
> >> 
> >> Anyone else encountered this, or have an idea what might be triggering 
> >> this behavior?
> >> 
> >> Regards,
> >> Ethan
> >> 
> >> Sent from my iPhone
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org <mailto: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.
> >> 
> >> 
> > 
> > 
> > ---
> > This email has been checked for viruses by AVG.
> > https://www.avg.com <https://www.avg.com/>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org <mailto: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 <mailto: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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Backspace key stops working

[Christoph R]

Same here

Gruß,
Christoph

> Am 30.12.2018 um 04:49 schrieb Bruce Lang :
> 
> Me too
> 
> Issue is when I enter a new transaction. It auto-fills the previous similar 
> transaction which is what I want but when I go to edit the details - 
> let's say I want to change a word using Shift-Back (or Forward) arrow, it 
> selects either a section of the words starting about 4 characters from the 
> left and extending about 8 characters across, rather than the parts of the 
> words or whole words that I want to remove. For example "if the first words 
> are "coaching session" it will highlight "ching sessi"), no matter where I 
> have the cursor positioned in the field when I depress the shift key. 
> However, if I start typing from the positioned cursor, the issue 
> disappears... I can then edit as usual.
> 
> It's not a big issue... but irritating.
> 
> *Bruce*
> 
> **
> 
> On 29/12/2018 11:19 am, Ethan Swint wrote:
>> Just encountered this bug/feature again - the backspace key stops working, 
>> only in Gnucash, and Gnucash must be restarted to restore the functionality. 
>> I remember encountering this pre-Gnucash 3.
>> 
>> Anyone else encountered this, or have an idea what might be triggering this 
>> behavior?
>> 
>> Regards,
>> Ethan
>> 
>> Sent from my iPhone
>> ___
>> 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.
>> 
>> 
> 
> 
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.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.

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

Re: [GNC] Launching on Mac (was Repeatable Mac crash)

[Christoph R]

I tried that in 2.6 and it did not work. You could only set fixed parameters 
for the gnucash binary.

Cheers,
Christoph

> Am 05.10.2018 um 16:25 schrieb John Ralls :
> 
> That’s the way GnuCash used to launch, with a bash script, but bash can’t 
> AFAIK get the filename from LaunchServices. AppleScript or Automator script 
> might work.
> 
> Christoph, if you want to try that, the approach would be to rename 
> Gnucash.app/Contents/MacOS/Gnucash to something else and name the script 
> Gnucash.
> 
> Regards,
> John Ralls
> 
>> On Oct 4, 2018, at 9:52 PM, Tommy Trussell > <mailto:tommy.truss...@gmail.com>> wrote:
>> 
>> If it works to call gnucash with the files on the command line, can you put 
>> the automator script (or a bash script or applescript) into the GnuCash 
>> bundle, set the bundle's plist to call the script, and pass the command line 
>> arguments to the gnucash binary using the script?
>> 
>> I don't have a modern Mac set up anymore -- I think my newest runs snow 
>> leopard -- so I can't try this myself with the latest binary. 
>> 
>> 
>> On Wed, Oct 3, 2018 at 8:01 PM John Ralls > <mailto:jra...@ceridwen.us>> wrote:
>> Christoph,
>> 
>> Indeed that would be confusing.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> > On Oct 3, 2018, at 11:46 AM, Christoph R > > <mailto:subscriptions%2blis...@rohland.net>> wrote:
>> > 
>> > Hi John,
>> > 
>> > I realized that it has a flaw in general use: The automator script and 
>> > Gnucash are treated as two different programs by MacOS and show up in the 
>> > dock independently. So it would be pretty confusing for a normal user. 
>> > 
>> > Cheers,
>> > Christoph
>> > 
>> >> Am 01.10.2018 um 22:34 schrieb John Ralls > >> <mailto:jra...@ceridwen.us>>:
>> >> 
>> >> Christoph,
>> >> 
>> >> I’d never even considered putting Automator into the launch process. 
>> >> Instead I tried to catch the OpenFile notification from LaunchServices. 
>> >> The problem with that is that we don’t get the notification until the 
>> >> event loop is started and GnuCash loads the file before starting the 
>> >> event loop. I didn’t figure that out until November or December and by 
>> >> that point I wasn’t willing to rearrange the start up so close to the 
>> >> release, especially since we were already struggling with the Gtk3 
>> >> changes. Getting Automator to catch the notification and adjust the 
>> >> command line is a clever hack.
>> >> 
>> >> How would it work for installation? IIUC we’d still need the Gnucash.app 
>> >> bundle alongside the Automator script and I suppose the Automator script 
>> >> would also need to know the installed path of the bundle in order to 
>> >> start it from its shell.
>> >> 
>> >> Regards,
>> >> John Ralls
>> >> 
>> >> 
>> >> 
>> >>> On Oct 1, 2018, at 8:41 AM, Christoph R 
>> >>> > >>> <mailto:subscriptions%2blis...@rohland.net>> wrote:
>> >>> 
>> >>> Hi John,
>> >>> 
>> >>> reading this I instantly created an Automator Shell Script which opens 
>> >>> with “—nofile” when double clicked and with the file when I drop a file 
>> >>> on it. After changing the file information too I can now double click on 
>> >>> a .gnucash file to open it.
>> >>> 
>> >>> What’s the reason that we cannot implement this - or something similar - 
>> >>> in the standard package?
>> >>> 
>> >>> Cheers,
>> >>> Christoph
>> >>> 
>> >>>> Am 01.10.2018 um 16:17 schrieb John Ralls > >>>> <mailto:jra...@ceridwen.us>>:
>> >>>> 
>> >>>> 
>> >>>> 
>> >>>>> On Oct 1, 2018, at 4:02 AM, Robert Kesterson > >>>>> <mailto:robe...@robertk.com>> wrote:
>> >>>>> 
>> >>>>> On 30 Sep 2018, at 9:06, John Ralls wrote:
>> >>>>> 
>> >>>>>>> … >
>> >>>>>> Since you’re running two instances of GnuCash it’s likely that the 
>> >>>>>> trace file will be garbled, so if you could use the following from 
>> >>>>>> 

Re: [GNC] Repeatable Mac crash

[Christoph R]

Hi John,

reading this I instantly created an Automator Shell Script which opens with 
“—nofile” when double clicked and with the file when I drop a file on it. After 
changing the file information too I can now double click on a .gnucash file to 
open it.

What’s the reason that we cannot implement this - or something similar - in the 
standard package?

Cheers,
Christoph

> Am 01.10.2018 um 16:17 schrieb John Ralls  >:
> 
> 
> 
>> On Oct 1, 2018, at 4:02 AM, Robert Kesterson > > wrote:
>> 
>> On 30 Sep 2018, at 9:06, John Ralls wrote:
>> 
 … >
>>> Since you’re running two instances of GnuCash it’s likely that the trace 
>>> file will be garbled, so if you could use the following from the command 
>>> line instead:
>>> /Applications/Gnucash.app/Contents/MacOS/Gnucash --logto=~/gnucash.trace
>>> That will create a separate trace file in your user directory that you can 
>>> also attach to the bug report. You could even add the file path for the 
>>> file you really want to open to the end of that and save yourself the 
>>> “can’t get the lock” drill.
>> 
>> It appears that this works around the issue.  I did as you suggested and 
>> launched with the binary rather than the app package, and I gave it the 
>> alternate log location and specified the path to open on the command line. 
>> Since this is a pretty long command line that I don’t want to type often, I 
>> saved it as an executable shell script, one for each set of books.  Now when 
>> I run them both, they both run.  No crash. Should I still run them the old 
>> way and file a bug?  The workaround seems reliable, and I’m happy…
> 
> I don’t know why you’d want to run the way that causes a crash, but you 
> should file a bug.
> 
> 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.




Gruß,
Christoph

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

Re: [GNC] re-adding billable expenses to an invoice

[Christoph R]

> I THOUGHT the query was created every time, but it's possible the query
> only includes the chargeback items before it is posted the first time.
> If you've posted and then unposted the invoice, it's certainly possible
> the logic will not include new chargebacks.

Adding chargebacks to an posted and then unposted invoice worked for me in 
Gnucash 3.2

Cheers,
Christoph

> Am 11.09.2018 um 17:25 schrieb Derek Atkins :
> 
> Hi,
> 
> Matthew Pounsett  writes:
> 
>> On 6 September 2018 at 12:04, Derek Atkins  wrote:
>> 
>>Matthew Pounsett  writes:
>> 
>>> I accidentally flubbed some keyboard entry while putting together an
>>> invoice and messed up a billable expense item which had been
>>automatically
>>> added when the invoice was created.  Since there is no "Undo" the best
>>> option seemed to be to delete the entry and start over, but I can't find
>>a
>>> way to instruct GnuCash to add billable items to an invoice.  It seems
>>to
>>> do it automatically at invoice creation, and no other way.
>>> 
>>> Am I missing something?
>> 
>>When you are editing the invoice, just click in the "Billable" column
>>when adding the line-item to mark it as billable.
>> 
>> I think you've misunderstood the question.   There are already billable
>> expenses in the system.  I'm generating the invoice in which those billable
>> items will be passed on to the client.
> 
> Yes, clearly I did...
> 
>> I need to re-add the billable expenses to the invoice.  There doesn't appear
>> to be a way to do that... it looks like they are only added when the invoice
>> is first created.. I can't find any button, menu, or anything else that would
>> trigger adding billable expenses to an existing invoice.
> 
> I honestly don't recall if there is a way to add additional billable
> charge-back items to an already-created invoice.  I wrote that original
> code over 15 years ago; I'd have to search through it again to remind
> myself how it works (and see what changes may have been made).
> 
> The way it is supposed to work is that when the invoice is opened for
> the correct customer (or correct job), it will find all items and
> chargebacks.  Then you need to manually "add" those chargebacks to this
> particular invoice by clicking on the "included" column.
> 
> I THOUGHT the query was created every time, but it's possible the query
> only includes the chargeback items before it is posted the first time.
> If you've posted and then unposted the invoice, it's certainly possible
> the logic will not include new chargebacks.
> 
> Also, make sure the chargeback == invoice owner (customer and/or job).
> If the chargeback is to a job but the invoice is a customer, it
> definitely wont show up.
> 
> -derek
> 
> -- 
>   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>   Member, MIT Student Information Processing Board  (SIPB)
>   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>   warl...@mit.eduPGP key available
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] File Format Documentation (Bug 777893)

[Christoph R]

> Am 16.08.2018 um 17:06 schrieb Derek Atkins :
> 
> A user shouldn't really care whether a gnucash datafile is XML or SQLite -- 
> it should just work.  

Exactly! The internal data format does not matter to the user. The handling 
within and outside of Gnucash does.

Gruß,
Christoph



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

Re: [GNC] Billing employee expenses back to a customer

[Christoph R]

Hi Matthew,

You need to first press the button “Edit Invoice”. Then you can change the 
customer. 

Cheers,
Christoph

> Am 09.06.2018 um 02:41 schrieb Matthew Pounsett :
> 
> I'm entering an employee expense voucher that includes some receipts that
> are billable back to a customer.  If I'm reading the documentation
> correctly, I should be able to enter a customer name in the "Default
> chargeback project - Customer" field, and then mark individual line items
> as billable in order for them to show up in the customer account.
> 
> However, when I place the cursor in the customer field and try to type I
> get system beeps, indicating that I can't type in that field.  And the Edit
> button next to the field doesn't seem to do anything.
> 
> Have I missed a step somewhere?  I have not set up any Jobs.. do I need to
> do that in order to bill back?
> 
> A side note.. the documentation text for the Customer and Job fields is
> identical to each other in both the v2.6 and v3 docs.  It looks like the
> Customer description was C into the Job description and then not updated.
> ___
> 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: Register Font Size in Version 3

[Christoph R]

Hi George and others,

I finally found the time to address this for myself.

Creating  ~/Library/Application Support/Gnucash/gtk-3.0.css

with this content:

* {
  font: 14px arial, sans-serif;
}

did all I needed.

Cheers,
Christoph

> Am 05.04.2018 um 00:23 schrieb 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.

___
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 Losses" in Trial Balance Report

[Christoph R]

Hi Richard,

> Adrien asked if I have Trading Accounts enabled. I didn't know about this 
> feature, and I see that I have it turned off. I turned it on and re-generated 
> my Trial Balance, but I didn't see any difference.

You need to run “Actions -> Check & Repair -> Check & Repair All” to add the 
needed splits to existing transactions.

Gruß,
Christoph

> Am 23.03.2018 um 05:47 schrieb Richard :
> 
> HI all,
> 
> Thanks everyone for your thoughts. Once I see what my accountant does with 
> these foreign currency transactions, I will try entering them back into 
> GnuCash and see what happens. 
> 
> A message from Christopher mentioned stocks and capital gains. I don't have 
> any stocks in my books, but as I mentioned I do have a small gain or loss due 
> to currency conversion. I'm working with my accountant on this. What's so 
> strange about this "Unrealized losses" line that appeared in the trial 
> balance is that it's so much larger than any gain or loss that I have from 
> currency conversion. However, the "Unrealized losses" line could disappear 
> when I account for these currency exchange gains or losses correctly. 
> 
> Adrien asked if I have Trading Accounts enabled. I didn't know about this 
> feature, and I see that I have it turned off. I turned it on and re-generated 
> my Trial Balance, but I didn't see any difference.
> 
> Cheers,
> Richard
> 
> 
> 
> On 23/3/18, 2:25 AM, "gnucash-user on behalf of Adrien Monteleone" 
>  adrien.montele...@gmail.com> wrote:
> 
>The rounding error I found can be very large depending on the variance 
> between the exchange rate for each transaction and the date of the report. 
> But, I don’t think it affects anything else, because it’s a function of the 
> report, not any math Gnucash otherwise performs. And I’ve never seen this 
> discrepancy anywhere else. Others are using multiple currencies without major 
> issue, so I don’t think overall that there’s any danger. Perhaps someone who 
> routinely uses multiple currencies AND performs Trial Balance reports could 
> weigh in.
> 
>As for the Unrealized line, do you have Trading Accounts enabled by 
> chance? I’d have to play with it, but perhaps that is why you are seeing that 
> line at all. (I have it on in my book) I don’t know the implications of 
> turning that off once it’s on. One of the more seasoned users or developers 
> would have to chime in.
> 
>However, you can ‘adjust it out’ if need be. (that’s the purpose of a 
> trial-balance, to determine what if any adjusting entries need to be made) In 
> this case, you won’t be making any actual transaction entries in Gnucash - 
> just on the Trial Balance.
> 
>Check this out:
> 
>Trial Balance Total Debits - Trial Balance Total Credits + 
> Unrealized(+Gain, -Loss) = rounding error (or zero if no error)
> 
>If this equation holds true for your Trial Balance Report, then you are 
> otherwise in balance. If not, then you really do have an error somewhere that 
> you need to correct/adjust for.
> 
>To determine the actual rounding error, open the foreign currency asset 
> account. Add up all of the entries in the native currency. (If you have 
> Trading Accounts on, you’ll see two debits and credits for each transaction, 
> one in the native currency of the book, and one in the foreign currency of 
> the account) Then subtract balance of this account found on the trial 
> balance. The result is the rounding error. So for example if the sum of your 
> SGD entries is debit S$1100 and the Trial Balance report says the account is 
> really debit S$1000, then the rounding error is S$100.
> 
>So if the result of Total Debits - Total Credits - Unrealized Loss = 
> S$100, then you are otherwise in balance.
> 
>I’ve tried several reports to do this math for me to no avail. Probably 
> the closest is the Account report, but that doesn’t give totals in the native 
> currency, only the foreign currency set for that account. I suppose though it 
> would be trivial enough to copy/export to a spreadsheet to generate that 
> figure. My XAG account only has about 10 entries, so I don’t mind doing the 
> calculator math. 
> 
> 
>Regards,
>Adrien
> 
>> On Mar 22, 2018, at 4:42 AM, Richard  wrote:
>> 
>> Thanks for your thoughts, Adrien.
>> 
>> Yes, I do have losses from changes in exchange rates between when I booked a 
>> currency and the date of the report. However, these changes were tiny 
>> compared to the "Unrealized Losses" figure that appeared in the Trial 
>> Balance report. So, while I agree that this report shouldn't show virtual 
>> accounts, the bigger question in my mind is, "Where did this number come 
>> from?" That's still a mystery to me, but the use of multiple currencies is 
>> definitely a trigger. As soon as I remove all transactions in a foreign 
>> currency, 

Re: Online Transactions - Sender Not Found

[Christoph R]

Hi Evan,

I do not use OFX but the HBCI backend of aqbanking. When my bank changes the 
certificate Gnucash starts to ask for verification for the new certificate. But 
it does not store the answer. 

Calling aqbanking from the command line like "aqbanking-cli request —balance” 
asks to verify the certificate and stores it. After that all is fine for me 
again.

Cheers,
Christoph

> Am 13.03.2018 um 03:22 schrieb Evan Van Dyke :
> 
> GnuCash used to report acceptable security certificates when importing online 
> transactions, but lately I’ve been getting “Signer not found; certificate is 
> not trusted” when trying to do an online import (from every source: chase, 
> citi, others).
> 
> I’d like to try and understand why GnuCash stopped liking the provided 
> certificates… and if there is a way to fix it.  The problem has been there 
> with gnu cash 2.6.x for a while (currently on 19), and in 2.7.6 as well 
> (tried it tonight just to see).  On Mac OS X, if that makes a difference.
> 
> Looking at 5th/3rd bank for instance, it seems like their OFX server (should) 
> have a valid cert:
> https://www.ssllabs.com/ssltest/analyze.html?d=banking.53.com 
> 
> 
> Thoughts/help/ideas?
> 
> —Evan
> ___
> 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: Trading Accounts

[Christoph R]

And run “Actions -> Check & Repair -> Check & Repair All” to add the needed 
splits to existing transactions.

Gruß,
Christoph

> Am 12.02.2018 um 01:27 schrieb David Carlson :
> 
> I think that if you want to stop using trading account s it is difficult to
> turn them off.
> 
> I would set up a test file to try them on until you decide whether you like
> them.
> 
> David  C
> 
> On Feb 11, 2018 5:39 PM, "Adrien Monteleone" 
> wrote:
> 
>> Yes, you can add trading accounts (or any other accounts) as needed to your
>> current file.
>> 
>> Regards,
>> Adrien
>> 
>> On Sun, Feb 11, 2018 at 4:18 PM, Les  wrote:
>> 
>>> I have been using GC for several years, and although I trade stocks, I
>>> have never used the "Trading Accounts" option.  Can I just start using
>> it,
>>> or would I need to start a new GC file?
>>> 
>>> Thanks,
>>> 
>>> Les
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> ___
>> 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: can i use to handle VAT?

[Christoph R]

And I use it for German VAT.

Gruß,
Christoph

> Am 04.02.2018 um 11:25 schrieb Maf. King :
> 
> On Saturday, 3 February 2018 19:12:30 GMT Joanna Howells wrote:
>> I am new to accounting software so just wanted to know if gnucash
>> handles VAT?  I may be asking a daft question, but the other free
>> software I've looked at specifically says it does handle VAT but there
>> is no mention that I can see in the description of gnucash.
>> 
>> look forward to hearing back from someone?  many thanks!
>> 
> 
> Hi Joanna,
> 
> I've used GC to handle UK VAT for about 15 years now.
> 
> HTH,
> Maf.
> 
> ___
> 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: Validation of OFX TLS Certificates?

[Christoph R]

Hi Jeff,

I do not think that aqbanking checks against the system certificates. But you 
should have to accept a certificate only once. BUT when called directly from 
Gnucash aqbanking this does not work. It only remembers the certificate when 
called from the the command line e.g. with 
"/Applications/Gnucash.app/Contents/MacOS/aqbanking-cli request —balance”. 
After that it will only ask you again when the certificate changes. 

Cheers,
Christoph

> Am 16.01.2018 um 04:33 schrieb Jeff Kletsky :
> 
> I haven't been able to find much on getting past AqBanking not verifying 
> certificates for OFX connections.
> 
> https://wiki.gnucash.org/wiki/De/Setting_up_OFXDirectConnect_in_GnuCash_2 
> says to "blindly" accept them, which seems risky in this day and age. I found 
> a question around it asked on the list, but unanswered on 2016-11-23, "OFX 
> connection certificate troubles"
> 
> http://www.linuxsecurity.com/content/view/188984/102/ suggests that 
> gwenhywfar was patched to "use system ca-certificates" in 2015.
> 
> Before I dig further into this, is there a way to have the certificates 
> properly validated and, ideally, the revocation list checked? MacOS X here, 
> but a "generic" solution as a framework would also help!
> 
> Thanks,
> 
> Jeff
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Read only transactions

[Christoph R]

Maybe you have set the day limit in the books options? “File-> Options”..

Cheers,
Christoph

> Am 13.01.2018 um 17:51 schrieb Cliff McDiarmid :
> 
>> Sent: Wednesday, January 10, 2018 at 7:21 PM
> 
>> From: "Cliff McDiarmid" 
>> To: gnucash-user@gnucash.org
>> Subject: Read only transactions
> 
>> Hi
>  
>> I still haven't sorted my Quicken import, getting the correct balances 
>> without a 'balance adjustment' is difficult.
>  
>> But the question is:  How do i delete an account when it contains read only 
>> transactions?  I know i can move the transactions elsewhere, but I need to 
>> delete the accounts.
>  
>> I understand that the 'placeholder box' needs to be unchecked; it already 
>> is.  Need a solution, Google yields nothing.
>  
>   
>  Okay so there's no answer or maybe it's a dumb question.
> 
> So, is there anyway I can set the transactions within an account to read and 
> write?
> 
> thanks
> 
> Cliff
>  
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GL Accounts

[Christoph R]

Hi Caleb,

all outstanding payments and receivables are collected in the A/R and A/P 
accounts. You distribute your income and expenses in the invoices and bills to 
the Income and Expense accounts. 

You should see the A/R and A/P accounts as transitory payment accounts for the 
business functionality. Do not use them manually. 

Cheers,
Christoph

> Am 08.12.2017 um 15:52 schrieb Caleb Walker :
> 
> Thank you Mr. King for your response.  My question is not about accounting 
> principles but more so how do I do that in GC.  When I go to “Process 
> Payment” the only thing available to “Post To” is “Assets:Accounts 
> Receivable”.  I cannot put anything else in there nor can I put multiple 
> accounts in there.  Also in the “Transfer Account” section I can only choose 
> one account.  However, in processing a payment it should normally debit a 
> cash account but having the freedom to debit or credit any account would be 
> useful.
> 
> Then I went to create an invoice and in the "Invoice Entries” section I can 
> only select and Income Account in the “Income Account” column.  I tried to 
> type in an equity account like “Equity:Opening Balances:Caleb Startup 
> Capital” and the program said that the account did not exist.
> 
> I have followed these same examples in A/P as well to no avail.  Is there a 
> config file I need to edit to allow me to get out of this “jail” where the 
> program is forcing me to shoe-horn my processes?  I also cannot find a way to 
> do a “split transaction” yet.  I am still looking though.
> 
>> On Dec 8, 2017, at 1:11 AM, Maf. King  wrote:
>> 
>> Hi Caleb, 
>> 
>> welcome to the list.  Answers inline...
>> 
>> On Thursday, 7 December 2017 17:56:18 GMT Caleb Walker wrote:
>>> Hello All,
>>> 
>>> I am trying to use GNUCash like I use Sage 100 understanding it is not as
>>> full featured as Sage but might be ok with another business I am starting. 
>>> What I would like to do is make payments to something other than AP or
>>> receive invoices to something other than AR.  Is that possible? 
>> 
>> Yes.  if a transaction isn't a AP purchase, why would you shoe-horn it into 
>> AP?  EG. you buy something with cash. the transaction is Assets:CashOnHand 
>> -> 
>> Expenses:Whatever, which you can record perfectly easily in GC.  
>> 
>>> One
>>> example, I made a payment to my landlord and part of it was a deposit which
>>> I would like to go into an asset account and the other part is rent which
>>> would go into an expense account. How do I do that with this software? 
>> 
>> You'd need a "split transaction", so £100 from Assets:Bank can be split to 
>> any 
>> other number of accounts - eg £30 to assets:landordDeposit, and £20 to 
>> Sales:tax and £50 to expenses:rent
>> 
>>> Another example, I received cash into the account that I would like to tie
>>> into an equity account to show owners startup capital.  How do I easily get
>>> the money over there?  Thank you for your help
>> 
>> Assets:Bank <- Equity:OwnerCapital:CalebWalker would be one way.
>> 
>> I suggest you give an hour or two to the tutorial & concepts guide at some 
>> point which will cover these questions in more depth. See 
>> http://gnucash.org/viewdoc.phtml?doc=guide
>> 
>> Good luck with your new venture.
>> Maf.
>> 
>> 
>>> 
>>> Caleb
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 
>> -- 
>> Maf. King
>> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
>> 
>> 
>> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Interesting Discovery in my accounts

[Christoph R]

Hi Jay, 

you must have (accidentally?) changed a transaction dated from 2014 after 
closing the books. 

Gruß,
Christoph

> Am 02.12.2017 um 23:01 schrieb Jay Ridgley :
> 
> Good Afternoon,
> I just discovered that in 2014 a number of my expense accounts were not 
> correctly closed (they had a balance other that ZERO)!
> 
> Questions that I have:
> 
> 1. How did it happen?
> 2. Has this happened to anyone else?
> 3. How do I correct the problem?
> 
> I can not go back and recreate 3 YEARS of data.
> 
> Ideas...
> 
> Regards,
> Jay
> -- 
> Jay Ridgley
> jridgley2 at austin.rr.com
> Registered Linux User ID - 9115
> https://linuxcounter.net/cert/9115.png
> Registered Ubuntu User ID - 23320
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: MacOS Sierra - Upgrade Problems

[Christoph R]

Hi Fiona,

upgrade to the latest version (2.6.18) from http://www.gnucash.org

Cheers,
Christoph

> Am 28.11.2017 um 16:10 schrieb Fiona Vella :
> 
> Hello all,
> 
> I recently upgraded to MacOS High Sierra and now the Gnucash application
> will no longer open. Have others experienced this problem elsewhere? Is
> there a fix?
> 
> Thanks in advance.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Gncash 2.6.17 crash on Mac Os High Sierra 10.13.Beta

[Christoph R]

Use the current release (2.6.18). It is out there 

Cheers,
Christoph

> Am 28.11.2017 um 10:23 schrieb Alexis Lucena :
> 
> The simplest solution until the next release is to copy
> /usr/lib/libz.1.dylib into Gnucash.app/Contents/Resources/lib. You might
> want to move the existing one aside first just to be safe. 
> 
> How can i do that
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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.3 > 2.6.18?

[Christoph R]

Dear Sean,

2.6.18 has a higher version number than 2.6.3 (18 > 3!). 

And yes, you will need 2.6.18 to run gnucash on High Sierra.

Cheers,
Christoph

> Am 21.11.2017 um 19:04 schrieb Sean Perlmutter :
> 
> Hi GnuCashers,
> 
> New to the list and a rook when it comes to technical stuff, so forgive me
> in advance.
> 
> I’ve got the same issue as this
> :
> Just updated to High Sierra, now GnuCash won’t open. And I can’t find
> Gnucash.app/contents/Resources/lib.
> 
> It looks like the workaround is to simply update to the newest version of
> GnuCash. Which I’m happy to do. But something is odd.
> 
> I have version 2.6.3, installed March 2014. And the GnuCash homepage shows
> the most recent version as 2.6.18. The version number is lower! Am I
> missing something? Is that a more recent version than 2.6.3?
> 
> Thanks in advance for your help.
> Sean
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Mac OS accelerator keys

[Christoph R]

Hi Deva,

did you remove the semicolon at the start of the line? 
The semicolon is the comment character which will make Gnucash ignore the line.

Cheers,
Christoph

> Am 13.09.2017 um 07:44 schrieb Deva - :
> 
> Thank you for the response John.
> 
> It was nice to know some historical context on this one.
> 
> I changed the ~/Library/Application Support/Gnucash/accelerator-map file as 
> you suggested (see sample extract below). First, I had it as "b”, 
> “l”, etc. Started up gnucash, but nothing was happening when I pressed 
> the Alt+l or Alt+j key on an open account register while I was on a 
> transaction line.
> 
> So I closed gnucash, went back and edited the file again to replace  
> with  as shown in the extract here. Started up gnucash again, and 
> used the “Command” key with these letter combinations, but still no effect.
> 
> ; (gtk_accel_path 
> "/GncPluginPageRegisterActions/ViewStyleBasicAction" "b”)
> ; (gtk_accel_path 
> "/GncPluginPageRegisterActions/ViewStyleAutoSplitAction" 
> "l”)
> ; (gtk_accel_path 
> "/GncPluginPageRegisterActions/JumpTransactionAction" "j”)
> ; (gtk_accel_path 
> "/GncPluginPageRegisterActions/DuplicateTransactionAction" 
> "d”)
> 
> I perform these actions fairly frequently on any given transaction register, 
> so I am keen on getting this to work.
> 
> Am I missing something?
> 
> Cheers,
> Deva
> 
> On 12-Sep-2017, at 8:09 PM, John Ralls 
> > wrote:
> 
> 
> 
> On Sep 12, 2017, at 5:30 AM, Deva - 
> > wrote:
> 
> Hello,
> 
> I am running Gnucash v2.6.6 on Mac OS Sierra.
> 
> This is in response to an earlier post clarifying how to setup keyboard 
> access to frequently performed functions by Christopher Lam (see below). I 
> couldn’t find a way to respond to that specific thread from my daily digest 
> mail, hence this.
> 
> I presume that post was about a windows fix. On my Mac, I found a similar 
> file called osx_accel_map under 
> /Applications/Gnucash/Contents/Resources/share/gnucash/ui.
> 
> I edited the file (after making a backup of the original file) for the 2 
> lines mentioned in the earlier post, but instead of "j" and 
> "l”, I changed it to “j” and “l” based on other such 
> entries in the file.
> 
> I restarted gnucash after these edits, but these accelerator keys don’t seem 
> to work on an open register. I tried pressing both  as well as 
>  for the  key, but with no effect - nothing happens.
> 
> Can you please let me know how I can set this up for a Mac?
> 
> Deva,
> 
> The file you want to edit is ~/Library/Application 
> Support/Gnucash/accelerator-map. The one in the bundle is obsolete and not 
> used.
> 
>  means “Command” on Mac and “Control” everywhere else.  means 
> “Alt”; on a Mac that’s the Alt/Option key. (The history about that is that I 
> had a spirited discussion with Mitch Natterer of The GIMP about how to map 
> control to command.  isn’t a modifier key in Gtk. I wanted to map 
> command to meta, but Mitch insisted that  should be Alt/Option to be 
> consistent with Linux and Win32. He solved the problem rather elegantly by 
> inventing . Shortly after that Mike Alexander improved my 
> accelerator map code in GnuCash to not use osx_accel_map but didn’t remove it 
> in case it might prove useful.)
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Flash Drive

[Christoph R]

Hi John,

even if you gave up on the topic I would like to point you to: 
https://portableapps.com/de/apps/office/gnucash_portable 
. 

I did not use it for a while but it worked for me nicely with an older version.

Cheers,
Christoph

> Am 15.07.2017 um 21:31 schrieb John Wright :
> 
> David,
> 
> I have pretty much given up on that idea, as you said its a very complex 
> approach, and to be honest, probably not worth the time for the benefit.  I 
> saw the space used on the hard drive, and yes I do have enough space for 
> that, so I think I will store the data on the flash drive and run the app 
> from the hard drive.  As you said, that's a pretty trivial thing to do and 
> won't take a lot of time.
> 
> Thanks.
> 
> John
> 
> 
> On 07/15/2017 12:19 AM, David T. wrote:
>> John,
>> 
>> I seem to have misunderstood. I thought you said you were only trying to 
>> store the data file on the flash drive; this sounds like you are trying to 
>> store the entire application there.
>> 
>> Storing the data file is trivial, but trying to load the entire application 
>> is another story. Since I am not a Linux guy, I will defer to the comments 
>> made here by the others about the difficulties of running an application 
>> from removable storage.
>> 
>> Gnucash on my mac takes a total of about 175Mb of space. Surely that could 
>> fit in the limited space available to you? If that is still a stretch, you 
>> can probably delete some of the different language help files; the Japanese 
>> docs especially eat up a lot of space.
>> 
>> David
>> 
>> 
>>On Sat, Jul 15, 2017 at 1:08, John Wright
>> wrote:
>> 
>>David,
>> 
>>Yes, in fact I have gotten the error several times. My first
>>attempt at running gnucash from a flash drive went this way. 
>> Installed it on the hard drive,  then moved all the gnucash files
>>(except libs) to flash drive,  added a .desktop file to
>>user/share/applications.  That worked ok, but I couldn't find the
>>icon, and all the lib files were still on the hard drive.
>> 
>>The reason I want to do this is that the laptop I just purchased
>>has a 15GB m-stat sshd.  So I really don't have a lot of room to
>>play with.  Sort of a throwback to the days when everything we ran
>>was stored on floppy drives and either a very small hard drive or
>>no hard drive at all.  Of course that was way before the internet.
>> 
>>John
>> 
>> 
>>On 07/14/2017 01:20 PM, David wrote:
>>> 
>>>I guess it's lucky that John only wants to load his data from the
>>>flash drive, then.
>>> 
>>>John, be aware that GnuCash always tries to load the last file it
>>>had open; if the folder isn't available when you fire it up, you
>>>will receive an error. Just be sure the USB stick is inserted and
>>>mounted before you start GC, and you should be fine.
>>> 
>>>David
>>> 
>>> 
>>> 
>>>
>>>*From:* David Carlson 
>>>
>>>*Sent:* Fri Jul 14 22:00:33 GMT+05:00 2017
>>>*To:* Robert Heller 
>>>
>>>*Cc:* "gnucash-user@gnucash.org"
>>> 
>>>, John Wright
>>> 
>>>*Subject:* Re: Flash Drive
>>> 
>>>Perhaps this is not sensible, but I once experimented with installing
>>>Gnucash on a USB key configured as a Tails OS with persistent storage.
>>>That is based on Debian Linux.  It worked, but it was somewhat clumsy.  
>>> The
>>>nice thing is that all the data is completely encrypted and insulated 
>>> from
>>>intruders, "sandboxed" if you will.
>>> 
>>>David C
>>> 
>>>On Fri, Jul 14, 2017 at 10:30 AM, Robert Heller 
>>>   wrote:
>>> 
>>>> At Fri, 14 Jul 2017 14:39:17 +0100 Colin Law  
>>>   wrote:
>>>>
>>>> >
>>>> > On this list you have to use Reply All to reply otherwise the message
>>>> > just goes to the previous user (as this did). Forwarding this to the
>>>> > list for information.  Also see reply below.
>>>> >
>>>> > On 14 July 2017 at 12:31, John Wright  
>>>   wrote:
>>>> > > Colin,
>>>> > >
>>>> > > Sorry for the confusion.  I what to just run gnucash from the flash
>>>> drive.
>>>> > > Fedora will be installed on the pc and gnucash as well as all the
>>>> gnucash
>>>> > > data will be on the flash drive.
>>>> >
>>>> > To be pedantic you don't want to run gnucash from the flash drive, 
>>> you
>>>> > want to run gnucash from the