Re: [GNC] Downgrading to 2.6.21

2019-04-13 Thread Adrien Monteleone
2.6.15 can’t reliably read the data file from 3.x. (if at all, I haven’t tested 
it)

The lowest you can go is 2.6.19.

You could use the Flatpak version, the .deb that was posted on this list, or 
build from source.

Regards,
Adrien

> On Apr 13, 2019, at 1:31 AM, Gour  wrote:
> 
> On Mon, 8 Apr 2019 20:10:36 -0700
> John Ralls  wrote:
> 
> Hello,
> 
>> 2.6.21 and 3.x are supposed to be fully file-compatible. Earlier
>> releases in the 2.6 series may not be depending on what 3.x features
>> you use.
> 
> I'm changing my distro - from Manjaro where I had 3.5 I moved to Devuan
> (Debian) 'unstable' where I have 3.4 and everything, so far looks OK,
> but I'm considering to switch to 'stable' (Ascii) version which has
> 2.6.15 and wonder what can I expect?
> 
> 
> Sincerely,
> Gour
> 


___
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] credit card opening balance

2019-04-13 Thread Adrien Monteleone
Any asset account would do. You can use the cash or checking/bank account 
already created by the startup wizard, or add a new one. It doesn’t have to be 
anything special because you don’t care about it. It’s just to satisfy 
double-entry.

Regards,
Adrien

> On Apr 13, 2019, at 1:47 AM, ToddAndMargo via gnucash-user 
>  wrote:
> 
> 
> Looks like I am either back to a spread sheet or chasing down
> what type of account Adrian told me to link.  I will find it
> somewhere in the threads.


___
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] credit card opening balance

2019-04-13 Thread ToddAndMargo via gnucash-user

On 4/13/19 12:30 AM, Adrien Monteleone wrote:

Any asset account would do. You can use the cash or checking/bank account 
already created by the startup wizard, or add a new one. It doesn’t have to be 
anything special because you don’t care about it. It’s just to satisfy 
double-entry.

Regards,
Adrien


Thank you

I am going to start a new thread to describe how far I have got.



___
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] Don't understand why I have what I have

2019-04-13 Thread ToddAndMargo via gnucash-user

Hi All, especially Adrian,

Here is what I have so far.

I have two accounts:
"Little Visa", which is a Credit card account
"Little Visa -- Expense", which is an expense account

Credit card charges I have entered into "LittleVisa" (transfer column)
as a "debit".  I get a corresponding "credit" in "little Visa--expense".

Payment go into "LittleVisa -- Expense" as a "debit".  I get
a corresponding "credit" in "LittleVisa".

Every entry I have found on my bank statement I have placed a "c"
for "checked" in the "R" column of "Little Visa".

I have about 15 entries

And will wonders ever cease, the "Balance" at the bottom is
correct!

Confusions:

1)  In "Transaction Journal", I have to assign each and every
transaction to "little visa" and "Little Visa--expense".
How do I make these two the default?

2)  In "Basic Journal", it shows everything as "LittleVisa -- Expense".
The balance is still correct.   Why not "LittleVisa"?

3)  When I press the "reconcile" button, it asked me for the "statement
date".  Is that the ending date on my bank statement?  If so,
it changes the "ending balance" to some bizarre number not
even close to the ending balance on the bank statement.  Why?

4)  If I try to enter a test charge, it goes into "Imbalance-USD".
I can change it back, but why?

Many thanks,
-T




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


Re: [GNC] Don't understand why I have what I have

2019-04-13 Thread Maf. King
Hi,

Answers inline below...

On Saturday, 13 April 2019 09:14:39 BST ToddAndMargo via gnucash-user wrote:
> Hi All, especially Adrian,
> 
> Here is what I have so far.
> 
> I have two accounts:
>  "Little Visa", which is a Credit card account
>  "Little Visa -- Expense", which is an expense account
> 
> Credit card charges I have entered into "LittleVisa" (transfer column)
> as a "debit".  I get a corresponding "credit" in "little Visa--expense".
> 
> Payment go into "LittleVisa -- Expense" as a "debit".  I get
> a corresponding "credit" in "LittleVisa".
> 
> Every entry I have found on my bank statement I have placed a "c"
> for "checked" in the "R" column of "Little Visa".
> 
> I have about 15 entries
> 
> And will wonders ever cease, the "Balance" at the bottom is
> correct!
> 
> Confusions:
> 
> 1)  In "Transaction Journal", I have to assign each and every
>  transaction to "little visa" and "Little Visa--expense".
>  How do I make these two the default?

If you enter from the credit card account, that sets one "half" of the 
transaction to LittleVisa.  OVer time, if you have repeat purchases with the 
same description, GC will recall the "other" account.  EG eating again at 
Joe's diner will auto-fill a template transaction and all you will need to do 
is edit the sum of money.


> 
> 2)  In "Basic Journal", it shows everything as "LittleVisa -- Expense".
>  The balance is still correct.   Why not "LittleVisa"?

Presumably, you are in the basic journal for LittleVisa. so the other account 
is the expense half.  For your unusual use case, the other account is always 
the same.  for must of the rest of us, the other account might be 
Expenses:fuel or Expenses:Groceries etc.

> 
> 3)  When I press the "reconcile" button, it asked me for the "statement
>  date".  Is that the ending date on my bank statement?  If so,
>  it changes the "ending balance" to some bizarre number not
>  even close to the ending balance on the bank statement.  Why?

Yes, date is the ending date shown on your statement.  GC auto computes what 
is thinks the balance is at that date.  What GC thinks and what the bank think 
won't always agree, due to bank processing times etc.  Just edit the end 
balance to that of the statement, and all should be well in the end. 

> 
> 4)  If I try to enter a test charge, it goes into "Imbalance-USD".
>  I can change it back, but why?

Because you didn't set the "other account" to something?  GC *has* to balance 
a transaction that is entered, so if the credits != debits, it puts an 
imbalance line in - really it is gently saying that you've messed up and you 
need to re-assign that txn.  in your use case it probably isn't important, and 
you could put every txn to imbalance.

HTH,
Maf.


> 
> Many thanks,
> -T






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


Re: [GNC] Don't understand why I have what I have

2019-04-13 Thread Adrien Monteleone


> On Apr 13, 2019, at 3:14 AM, ToddAndMargo via gnucash-user 
>  wrote:
> 
> Hi All, especially Adrian,
> 
> Here is what I have so far.
> 
> I have two accounts:
>"Little Visa", which is a Credit card account
>"Little Visa -- Expense", which is an expense account
> 
> Credit card charges I have entered into "LittleVisa" (transfer column)
> as a "debit".  I get a corresponding "credit" in "little Visa--expense”.

Backwards. Charges should be credits to the credit card account and debits to 
the expense account.

> 
> Payment go into "LittleVisa -- Expense" as a "debit".  I get
> a corresponding "credit" in "LittleVisa”.

Again, backwards. Reverse your debits and credits. Payments are a debit to the 
credit card account and credit to the asset account used to make the payment.

Also, you don’t want to make your payments go to the expense account. You 
aren’t paying the card with expenses, you’re paying it with an asset. (that 
account I mentioned in the other thread...)

Note, now that you can see what is going on, you can switch back to Basic View 
and informal labels if you prefer. (payment/charge instead of debit/credit)

Regards,
Adrien
___
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] Finance::Quotes stopped working for me

2019-04-13 Thread David Carlson
A different router could also mean a different ISP, a different DNS, and
that is just the starting point...

David Carlson

On Fri, Apr 12, 2019 at 11:58 PM Ronal B Morse  wrote:

> Maybe a firewall configuration issue? Bruno's router might be blocking a
> required port where his neighbor's is not.
>
> RBM
>
> On 4/12/19 9:54 PM, John Ralls wrote:
> > Bruno,
> >
> > That's weird. No, I can't think of anything associated with your mac's
> networking config that would cause perl and only perl to fail when using
> your router/modem and not your neighbors.
> >
> > Regards,
> > John Ralls
> >
> >> On Apr 12, 2019, at 8:35 PM, Bruno Acklin  wrote:
> >>
> >> Hi John,
> >>
> >> Thanks, confirmed that it’s nothing to do with Perl and gnucash /
> financequote.
> >>
> >> I connected to my neighbors Wifi and finance quote works like a charm.
> When I go back through my router I times out again.
> >> Any suggestion if it is a DNS or a TCP, or UDP poor I should look for
> and configure?
> >>
> >> Best, Bruno
> >>
> >>> On Mar 30, 2019, at 8:02 PM, John Ralls 
> wrote:
> >>>
> >>> Stockdump.pl isn't misinterpreting anything. You can pass it multiple
> symbols and it prepends the symbol to each message so that you know which
> message goes with which symbol.
> >>>
> >>> It seems unlikely that it's a DNS issue, but you could take the laptop
> somewhere where there's public wifi and try from there. An Apple Store
> might be a good choice, because then you can show the problem to a "Genius"
> and see what they think.
> >>>
> >>> I'm out of ideas for what could be borked with perl. You might try
> creating a new user and running stock dump as that user (you'll need to
> adjust permissions in your home directory) just to make sure that it isn't
> something goofy in your environment.
> >>>
> >>> Regards,
> >>> John Ralls
> >>>
> >>>
> >>>
>  On Mar 30, 2019, at 3:59 PM, Bruno Acklin  wrote:
> 
>  John,
> 
>  Thanks for your help and patience!
> 
>  I did just that and updated Net::HTTP, as well as LWP, Date::Manip
> and Finance::Quote again. All of them are confirmed up to date now.
> 
>  But calling …/stockdump.pl still yields an "internal server error”
> 500:
> 
>  Brunos-MacBook-Pro:~ backlin$
> ~/.cpan/build/Finance-Quote-1.47-FVw_VE/Examples/stockdump.pl yahoo_json
> aapl
>  $VAR1 = {
>   'aaplsymbol' => 'aapl',
>   'aaplsuccess' => 0,
>   'aaplerrormsg' => 'Error retrieving quote for aapl. Attempt
> to fetch the URL
> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted
> in HTTP response 500 (Internal Server Error)'
> };
> 
>  Why is stockdump.pl misinterpreting the parameters and prepending
> apple to ‘symbol’ and ‘success’ and 'error msg’?
> 
>  Still, calling the very URL in the error message using curl works
> instantly:
>  Brunos-MacBook-Pro:~ backlin$ curl
> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
> 
> {"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Nasdaq
> Real Time
> Price","currency":"USD","fullExchangeName":"NasdaqGS","longName":"Apple ..
> 
>  Could Perl address another "internal server” which times out? A DNS
> issue?
>  Do you have any other suggestions to try, or can point out the
> program hierarchy to trace these calls?
>  (Again reminding that I have this problem on two independent
> installations, and it appeared overnight, while gnucash on Desktop, and
> Perl Terminal window on Laptop were open and running.)
> 
>  Thanks, Bruno
> 
> > On Mar 28, 2019, at 6:15 PM, John Ralls <
> jra...@ceridwen.fremont.ca.us> wrote:
> >
> > ~/.cpan/build/Finance-Quote-1.47-X/Examples/stockdump.p
> 
> >>>
> >>
> >> ___
> >> 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/list

Re: [GNC] Finance::Quotes stopped working for me

2019-04-13 Thread Adrien Monteleone
More likely a blocked port though since the OP said curl works to retrieve the 
same URL, but not perl. A look at the perl script will probably expose the 
issue.

Regards,
Adrien

> On Apr 13, 2019, at 4:29 AM, David Carlson  
> wrote:
> 
> A different router could also mean a different ISP, a different DNS, and
> that is just the starting point...
> 
> David Carlson
> 


___
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] Upgrade 2.6.18 to 3.5

2019-04-13 Thread Ian K via gnucash-user
Tony,

I recently ugraded from 2.6.21 to 3.5 on Windows 10 and had to locate the
saved reports. I'll tell you what I did.
On my system this was a file called "saved-reports-2.4", which was located
at:

C:\users\USERNAME\.gnucash where USERNAME is the current user.

I copied this file to:

C:\Users\USERNAME\AppData\Roaming\GnuCash

These locations might be different on your system, you can find the USERNAME
folder by hitting the Windows key and typing %userprofile%. Also you can
fing the Appdata folder by typing %appdata%

Hope this helps.



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


Re: [GNC] Upgrade 2.6.18 to 3.5

2019-04-13 Thread Tony Vanson
Thanks Ian. Spot on!
Cheers

On Sat, Apr 13, 2019 at 5:12 PM Ian K via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Tony,
>
> I recently ugraded from 2.6.21 to 3.5 on Windows 10 and had to locate the
> saved reports. I'll tell you what I did.
> On my system this was a file called "saved-reports-2.4", which was located
> at:
>
> C:\users\USERNAME\.gnucash where USERNAME is the current user.
>
> I copied this file to:
>
> C:\Users\USERNAME\AppData\Roaming\GnuCash
>
> These locations might be different on your system, you can find the
> USERNAME
> folder by hitting the Windows key and typing %userprofile%. Also you can
> fing the Appdata folder by typing %appdata%
>
> Hope this helps.
>
>
>
> --
> 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.
>


-- 
*Tony Vanson*

*The older I get,*
*the better I was*
___
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] Finance::Quotes stopped working for me

2019-04-13 Thread John Ralls
The URL is given several times in the thread, it's http, port 80. That aside, 
get real: A firewall that blocks a port when perl's LWP is the agent but not 
when curl or a web browser is?

Besides, the request isn't blocked, it's munged so that Yahoo! returns a 
500--server error response. So we have to imagine that the router can somehow 
tell that the packets are coming from curl and not messing with them or perl 
LWP and messing with them? That's a pretty amazing firewall.

Regards,
John Ralls

> On Apr 13, 2019, at 2:32 AM, Adrien Monteleone 
>  wrote:
> 
> More likely a blocked port though since the OP said curl works to retrieve 
> the same URL, but not perl. A look at the perl script will probably expose 
> the issue.
> 
> Regards,
> Adrien
> 
>> On Apr 13, 2019, at 4:29 AM, David Carlson  
>> wrote:
>> 
>> A different router could also mean a different ISP, a different DNS, and
>> that is just the starting point...
>> 
>> David Carlson
>> 
> 
> 
> ___
> 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] Finance::Quotes stopped working for me

2019-04-13 Thread David Carlson
There must be something else going on that hasn't been found yet.

David Carlson

On Sat, Apr 13, 2019, 9:18 AM John Ralls  wrote:

> The URL is given several times in the thread, it's http, port 80. That
> aside, get real: A firewall that blocks a port when perl's LWP is the agent
> but not when curl or a web browser is?
>
> Besides, the request isn't blocked, it's munged so that Yahoo! returns a
> 500--server error response. So we have to imagine that the router can
> somehow tell that the packets are coming from curl and not messing with
> them or perl LWP and messing with them? That's a pretty amazing firewall.
>
> Regards,
> John Ralls
>
> > On Apr 13, 2019, at 2:32 AM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >
> > More likely a blocked port though since the OP said curl works to
> retrieve the same URL, but not perl. A look at the perl script will
> probably expose the issue.
> >
> > Regards,
> > Adrien
> >
> >> On Apr 13, 2019, at 4:29 AM, David Carlson 
> wrote:
> >>
> >> A different router could also mean a different ISP, a different DNS, and
> >> that is just the starting point...
> >>
> >> David Carlson
> >>
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Finance::Quotes stopped working for me

2019-04-13 Thread AC
LWP apparently will also self report a 500 status if the connection
fails for any reason.  The first suggestion would be to add lots of
debugging to the perl script to dump its internal state at various
points and also snoop on the connection.

I would also check to see if the malfunctioning router is utilizing a
proxy of some form.  Some tools are able to pick up on a proxy if the OS
has automatically put in the appropriate environmental variables but I
don't believe LWP can do that.  (Curl does look for the environment
variables and most browsers can query the OS for proxy information).

Admittedly it would be very odd to have a proxy running on a basic
router but not impossible.

On 2019-04-13 07:59, David Carlson wrote:
> There must be something else going on that hasn't been found yet.
> 
> David Carlson
> 
> On Sat, Apr 13, 2019, 9:18 AM John Ralls  wrote:
> 
>> The URL is given several times in the thread, it's http, port 80. That
>> aside, get real: A firewall that blocks a port when perl's LWP is the agent
>> but not when curl or a web browser is?
>>
>> Besides, the request isn't blocked, it's munged so that Yahoo! returns a
>> 500--server error response. So we have to imagine that the router can
>> somehow tell that the packets are coming from curl and not messing with
>> them or perl LWP and messing with them? That's a pretty amazing firewall.
>>
>> Regards,
>> John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Split transaction: more than two off-setting accounts

2019-04-13 Thread Rich Shepard

When I enter a mortgage payment I credit the checking account and have three
off-setting debit accounts: principal, interest, and escrow.

The split transaction button opens only two rows so I enter the checking
account credit and the principal amount debit, then close the transaction
and re-open it to enter interest and escrow.

Is there a way to open the split with more than two data entry rows? If not
I'll just continue doing what I have been, but would like to avoid
closing/re-opening the transaction if there is a way to do so.

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.


Re: [GNC] Split transaction: more than two off-setting accounts

2019-04-13 Thread Christian Kluge
Am 13.04.2019 um 20:37 schrieb Rich Shepard:

> Is there a way to open the split with more than two data entry rows? If not
> I'll just continue doing what I have been, but would like to avoid
> closing/re-opening the transaction if there is a way to do so.

Just change the values in the debit and credit columns.

As long as the sums of debit and credit don’t match you can add further
entries.

Kind regards

Christian Kluge

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


Re: [GNC] Split transaction: more than two off-setting accounts

2019-04-13 Thread Rich Shepard

On Sat, 13 Apr 2019, Christian Kluge wrote:


Just change the values in the debit and credit columns.
As long as the sums of debit and credit don’t match you can add further
entries.


Christian,

That works as long as there are available rows. Two are the default so when
I want to add two more rows closing and re-opening the transaction presents
an imbalance row and another one. This provides the needed space. I've not
found a way to add more rows when that transaction is on the bottom of the
gnucash window.

When the transaction is saved and a new pair of rows is displayed, clicking
on the split transaction does display a new, blank row.

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.


Re: [GNC] Split transaction: more than two off-setting accounts

2019-04-13 Thread Christian Kluge
Am 13.04.2019 um 21:10 schrieb Rich Shepard:
> On Sat, 13 Apr 2019, Christian Kluge wrote:
> 
>> Just change the values in the debit and credit columns.
>> As long as the sums of debit and credit don’t match you can add further
>> entries.
> 
> That works as long as there are available rows. Two are the default so when
> I want to add two more rows closing and re-opening the transaction presents
> an imbalance row and another one. This provides the needed space. I've not
> found a way to add more rows when that transaction is on the bottom of the
> gnucash window.
> 
> When the transaction is saved and a new pair of rows is displayed, clicking
> on the split transaction does display a new, blank row.
> 


You can change Imbalance to any account to any account you like.

If you don’t exit the transaction beforehand this account also won’t be
set up in your CoA.

The other solution could be to switch to full transaction view for every
transaction.

There you always have a final empty line.

Kind regards

Christian KLuge

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


Re: [GNC] Split transaction: more than two off-setting accounts

2019-04-13 Thread Derek Atkins
Rich,

On Sat, April 13, 2019 3:10 pm, Rich Shepard wrote:
> On Sat, 13 Apr 2019, Christian Kluge wrote:
>
>> Just change the values in the debit and credit columns.
>> As long as the sums of debit and credit don’t match you can add further
>> entries.
>
> Christian,
>
> That works as long as there are available rows. Two are the default so
> when
> I want to add two more rows closing and re-opening the transaction
> presents
> an imbalance row and another one. This provides the needed space. I've not
> found a way to add more rows when that transaction is on the bottom of the
> gnucash window.
>
> When the transaction is saved and a new pair of rows is displayed,
> clicking
> on the split transaction does display a new, blank row.

No need to do that.  Just tab off the second row (TAB off, don't hit
Enter/Return), and Gnucash will create a new row for you.  Enter that row.
 Tab off the end.  Poof -- another row.   Lather. Rinse. Repeat.

Only hit Enter/Return when you are DONE with the whole shebang.

> Regards,
>
> Rich

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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


Re: [GNC] Finance::Quotes stopped working for me

2019-04-13 Thread Adrien Monteleone
It doesn’t make any sense to me either. But curl works, perl doesn’t. What does 
that perl script actually do when it tries to pull that URL?

Regards,
Adrien

> On Apr 13, 2019, at 9:17 AM, John Ralls  wrote:
> 
> The URL is given several times in the thread, it's http, port 80. That aside, 
> get real: A firewall that blocks a port when perl's LWP is the agent but not 
> when curl or a web browser is?
> 
> Besides, the request isn't blocked, it's munged so that Yahoo! returns a 
> 500--server error response. So we have to imagine that the router can somehow 
> tell that the packets are coming from curl and not messing with them or perl 
> LWP and messing with them? That's a pretty amazing firewall.
> 
> Regards,
> John Ralls
> 
>> On Apr 13, 2019, at 2:32 AM, Adrien Monteleone 
>>  wrote:
>> 
>> More likely a blocked port though since the OP said curl works to retrieve 
>> the same URL, but not perl. A look at the perl script will probably expose 
>> the issue.
>> 
>> Regards,
>> Adrien
>> 
>>> On Apr 13, 2019, at 4:29 AM, David Carlson  
>>> wrote:
>>> 
>>> A different router could also mean a different ISP, a different DNS, and
>>> that is just the starting point...
>>> 
>>> David Carlson
>>> 

___
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] Split transaction: more than two off-setting accounts

2019-04-13 Thread David Carlson
Two other ways that could work  include a) tab after entering the
description might trigger auto complete into a full clone of the last
transaction  or b) use auto split ledger view or transaction journal view
.  Either of those methods add extra rows for additional split accounts.

David Carlson

On Sat, Apr 13, 2019, 2:29 PM Derek Atkins  wrote:

> Rich,
>
> On Sat, April 13, 2019 3:10 pm, Rich Shepard wrote:
> > On Sat, 13 Apr 2019, Christian Kluge wrote:
> >
> >> Just change the values in the debit and credit columns.
> >> As long as the sums of debit and credit don’t match you can add further
> >> entries.
> >
> > Christian,
> >
> > That works as long as there are available rows. Two are the default so
> > when
> > I want to add two more rows closing and re-opening the transaction
> > presents
> > an imbalance row and another one. This provides the needed space. I've
> not
> > found a way to add more rows when that transaction is on the bottom of
> the
> > gnucash window.
> >
> > When the transaction is saved and a new pair of rows is displayed,
> > clicking
> > on the split transaction does display a new, blank row.
>
> No need to do that.  Just tab off the second row (TAB off, don't hit
> Enter/Return), and Gnucash will create a new row for you.  Enter that row.
>  Tab off the end.  Poof -- another row.   Lather. Rinse. Repeat.
>
> Only hit Enter/Return when you are DONE with the whole shebang.
>
> > Regards,
> >
> > Rich
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction: more than two off-setting accounts

2019-04-13 Thread Rich Shepard

On Sat, 13 Apr 2019, Derek Atkins wrote:


No need to do that. Just tab off the second row (TAB off, don't hit
Enter/Return), and Gnucash will create a new row for you. Enter that row.
Tab off the end. Poof -- another row. Lather. Rinse. Repeat.

Only hit Enter/Return when you are DONE with the whole shebang.


Derek,

Thank you. I did not see that in the user guide, nor became aware of using
the tab key by reading messages to the mail list.

That's a very useful capability.

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


Re: [GNC] Don't understand why I have what I have

2019-04-13 Thread ToddAndMargo via gnucash-user

On 4/13/19 2:25 AM, Adrien Monteleone wrote:




On Apr 13, 2019, at 3:14 AM, ToddAndMargo via gnucash-user 
 wrote:

Hi All, especially Adrian,

Here is what I have so far.

I have two accounts:
"Little Visa", which is a Credit card account
"Little Visa -- Expense", which is an expense account

Credit card charges I have entered into "LittleVisa" (transfer column)
as a "debit".  I get a corresponding "credit" in "little Visa--expense”.


Backwards. Charges should be credits to the credit card account and debits to 
the expense account.



Payment go into "LittleVisa -- Expense" as a "debit".  I get
a corresponding "credit" in "LittleVisa”.


Again, backwards. Reverse your debits and credits. Payments are a debit to the 
credit card account and credit to the asset account used to make the payment.

Also, you don’t want to make your payments go to the expense account. You 
aren’t paying the card with expenses, you’re paying it with an asset. (that 
account I mentioned in the other thread...)

Note, now that you can see what is going on, you can switch back to Basic View 
and informal labels if you prefer. (payment/charge instead of debit/credit)

Regards,
Adrien


Oh Geez,

I try to reverse the numbers and get all kinds of junk to Imbalance USD.
Is there a way to elegantly do this?




___
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] Unable to import QIF or QFX.

2019-04-13 Thread Evan Platt
GNUCASH / Windows 3.5+ 2019-3-30. / Windows 10 64.

Exported a QFX file from Quicken 2019 R18.16 (latest build).

Import QFX: I get a generic transaction import screen. It's blank.

Import QIF: One or two accounts worked. One account as an example:
I get to Start Import. It says importing, It says if there's no errors
it will proceed, otherwise it will display the error. It then says
failed, and the white box is empty. No error message.
Any suggestions?
___
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] Don't understand why I have what I have

2019-04-13 Thread David Cousens
Todd,

When you edit a register and change a debit entry to a credit entry for
example in the first line, the original transaction will have had an equal
credit entry corresponding to the original debit entry. After you edit the
first line younow have two credit entries for the transaction and no
corresponding debit entry until you change the second line. GnuCash
automatically balances the transaction so it creates a default debit entry
to the Imbalance account. If you continue and then edit the original credit
entry in the second line to make it a debit, the automatically calculated
correcting entry to the Imbalance account should change to zero again and
when you hit enter after correcting the second line.

This behavior is all described in the GnuCash Tutorial and Concepts guide
and Help manual. You would really save yourself a lot of confusion if you
worked through some of the examples on how the registers function.

Chapter 6 of the Help manual
https://www.gnucash.org/docs/v3/C/gnucash-help/ch_Common_Trans_Ops.html
describes what is happening and why.

Whether to debit or credit an account in a transaction in an accounting
program may also not be what you expect from the everday experience with
bank statements etc. 

The actual behavior of debits and credits on each type of account is
summarized below for each basic account type.

Asset accounts: Debits increase the account balance - credits decrease the
account balance;
Liability Accounts: Debits decrease the account balance  - credits increase
the account balance;
Equity Accounts: Debits decrease the account balance - credits increase the
account balance;
Income accounts: Debits decrease the account balance - credits increase the
account balance;
Expense accounts:Debits increase the account balance - credits decrease the
account balance;

this works like this because sum of the balances in the accounts of each
account type in double entry satisfy the followingrelationship:

Sum of Assets= Sum of of Liabilities + Sum of Equity +Sum of Income - Sum of
Expenses
and the requirement for each transaction that the Sum of the debit entries
equals the sum of the credit entries.

GnuCash strictly implements and enforces these requirements on accounts and
transactions which is why you get the apparently inexplicable behavior.

David Cousens



David Cousens



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


Re: [GNC] Don't understand why I have what I have

2019-04-13 Thread Christian Kluge
Am 14.04.2019 um 02:14 schrieb David Cousens:

> Whether to debit or credit an account in a transaction in an accounting
> program may also not be what you expect from the everday experience with
> bank statements etc. 
> 

I just wanted to add the reason for this.

A bank statement is an extract from their accounting showing their point
of view.

So each debit for you is a credit for them and vice versa.

Kind regards

Christian Kluge

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


Re: [GNC] Unable to import QIF or QFX.

2019-04-13 Thread David Cousens
Evan

OFX/QFX files can be edited or examined with a text editor. Usual caution
about line endings and text editors between Linux and Windows environments
apply

 First check to see if the exported file from Quicken had any content. If
nothing is coming up after selecting the file and pressing the import button
then either the file has no content or GnuCash is failing to parse the
content correctly.  OFX/QFX files are 

It is unlikely that Quicken would release a program that doesn't write
correct QFX files but it is always remotely possible. They should be
readable as OFX files as well, they just contain extra tags for proprietary
information which is ignored on import to GnuCash
 
The latter could result from corruption of the file during writing/editing
copying as well as software bugs. Unclosed or missing tags are one
possibility 

The QFX/OFX formats are described in the following
https://en.wikipedia.org/wiki/QFX_(file_format)
http://www.ofx.net/downloads/OFX%202.2.pdf

and some info about QIF
https://en.wikipedia.org/wiki/Quicken_Interchange_Format. 

There have been no major problems reported recently with OFX/QFX or QIF
import at the level of stopping an import. I have imported OFX/QFX files
from my bank in 3.5 on Linux Mint in the last day without any problems and
import has been working for the the recent 2.6 versions. Less sure about
QIF. If the files look OK then it may be a Windows only bug.

David Cousens







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


Re: [GNC] Don't understand why I have what I have

2019-04-13 Thread ToddAndMargo via gnucash-user

On 4/13/19 5:31 PM, Christian Kluge wrote:

Am 14.04.2019 um 02:14 schrieb David Cousens:


Whether to debit or credit an account in a transaction in an accounting
program may also not be what you expect from the everday experience with
bank statements etc.



I just wanted to add the reason for this.

A bank statement is an extract from their accounting showing their point
of view.

So each debit for you is a credit for them and vice versa.

Kind regards

Christian Kluge


Okay!  Now I get it.  It is the Bank' statement, not mine.

Thank you!

___
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] Unable to import QIF or QFX.

2019-04-13 Thread Evan Platt
Wow I feel like an idiot. Attention to detail LOL. Quicken is
exporting a QXF file. Gnucash is importing QFX. So my guess is to
export from quicken to Gnucash I have to do account by account with
QIF? Or is there some other way?

So Importing one of my QIF files (my main QIF file) - file looks good.
About 2 MB. When importing, it just says failed. It's at the final QIF
import screen. No details on the log :(

On Sat, Apr 13, 2019 at 5:44 PM David Cousens  wrote:
>
> Evan
>
> OFX/QFX files can be edited or examined with a text editor. Usual caution
> about line endings and text editors between Linux and Windows environments
> apply
>
>  First check to see if the exported file from Quicken had any content. If
> nothing is coming up after selecting the file and pressing the import button
> then either the file has no content or GnuCash is failing to parse the
> content correctly.  OFX/QFX files are
>
> It is unlikely that Quicken would release a program that doesn't write
> correct QFX files but it is always remotely possible. They should be
> readable as OFX files as well, they just contain extra tags for proprietary
> information which is ignored on import to GnuCash
>
> The latter could result from corruption of the file during writing/editing
> copying as well as software bugs. Unclosed or missing tags are one
> possibility
>
> The QFX/OFX formats are described in the following
> https://en.wikipedia.org/wiki/QFX_(file_format)
> http://www.ofx.net/downloads/OFX%202.2.pdf
>
> and some info about QIF
> https://en.wikipedia.org/wiki/Quicken_Interchange_Format.
>
> There have been no major problems reported recently with OFX/QFX or QIF
> import at the level of stopping an import. I have imported OFX/QFX files
> from my bank in 3.5 on Linux Mint in the last day without any problems and
> import has been working for the the recent 2.6 versions. Less sure about
> QIF. If the files look OK then it may be a Windows only bug.
>
> David Cousens
>
>
>
>
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Don't understand why I have what I have

2019-04-13 Thread ToddAndMargo via gnucash-user

On 4/13/19 3:53 PM, ToddAndMargo via gnucash-user wrote:

Oh Geez,

I try to reverse the numbers and get all kinds of junk to Imbalance USD.
Is there a way to elegantly do this?



I exported it to a CSV.   I found founbd columns:

Amount With Sym
Amount Num.

It it really easy to reverse their signs and write it back
out with Libre Office Calc

Is there a way to read it back in and overwrite what was there?

Many thanks,
-T


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


Re: [GNC] Some chinese words can not be displayed

2019-04-13 Thread John Ralls
Thanks for following up. I've made an entry on 
https://wiki.gnucash.org/wiki/GTK3 about it.

Regards,
John Ralls

> On Apr 13, 2019, at 3:51 PM, Richard Zhang  wrote:
> 
> Hi John,
> I put the settings.ini into the C:\Users\erzhang\AppData\Local\gtk-3.0 with 
> following settting:
> 
> [Settings]
> gtk-font-name=Microsoft YaHei 14
> 
> It back to normal.
> Thanks!
> BR/Richard
> 
> 
> -Original Message-
> From: Richard Zhang 
> Sent: 2019年3月27日 17:03
> To: 'John Ralls' 
> Cc: gnucash-user@gnucash.org
> Subject: RE: [GNC] Some chinese words can not be displayed
> 
> Hi John,
> Thanks for your reply.
> I will study the documents and try to fix it.
> BR//Richard
> 
> 
> -Original Message-
> From: John Ralls  
> Sent: 2019年3月25日 22:44
> To: Richard Zhang 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Some chinese words can not be displayed
> 
> 
> 
>> On Mar 24, 2019, at 7:34 AM, Richard Zhang  wrote:
>> 
>> Hi Support,
>> I got a problem when I use the GNUCASH.
>> 
>> Environment: Window 10 Enterprise
>> Version: 1709
>> Language: English
>> 
>> Symptom: some words in menu and description can not be displayed.
>> [cid:image001.png@01D4E22A.DB249AA0]
>> 
>> Pls help.
> 
> You need to configure a font with better Unicode support. See 
> https://wiki.gnucash.org/wiki/GTK3. The hard part is figuring out which font 
> to use.
> 
> Regards,
> John Ralls
> 
> 

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


Re: [GNC] Don't understand why I have what I have

2019-04-13 Thread David Carlson
ToddAndMargo,


On Sat, Apr 13, 2019 at 9:22 PM ToddAndMargo via gnucash-user <
gnucash-user@gnucash.org> wrote:

> On 4/13/19 3:53 PM, ToddAndMargo via gnucash-user wrote:
> > Oh Geez,
> >
> > I try to reverse the numbers and get all kinds of junk to Imbalance USD.
> > Is there a way to elegantly do this?
>
>
> I exported it to a CSV.   I found founbd columns:
>
>  Amount With Sym
>  Amount Num.
>
> It it really easy to reverse their signs and write it back
> out with Libre Office Calc
>
> Is there a way to read it back in and overwrite what was there?
>
> Many thanks,
> -T
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

When editing a transaction in GnuCash it is easy and recommended to tab
from field to field in the transaction and change the text, signs or
amounts as desired, with the caveat that tabbing off the right end of a
line will trigger GnuCash to calculate a sum of the two values in the
credit and debit fields and place a positive value in one of the boxes.

Then you can continue through the transaction until all lines are as
desired.  To commit your completed edit press Return or Enter whatever it
is called on your keyboard.  GnuCash will then re-arrange the lines so all
the lines with positive values in the left box appear first, then lines
with positive values in the right box appear below.  If there are lines
with zeros the zeros disappear but the line remains with empty boxes in
between the other lines.  This is also when GnuCash adds lines called
Imbalance if all the lines do not add up to zero.  Once you get used to
that behavior it seems automatic and logical.

-- 
David Carlson
___
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] Don't understand why I have what I have

2019-04-13 Thread ToddAndMargo via gnucash-user

On 4/13/19 8:53 PM, David Carlson wrote:

ToddAndMargo,


On Sat, Apr 13, 2019 at 9:22 PM ToddAndMargo via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


On 4/13/19 3:53 PM, ToddAndMargo via gnucash-user wrote:
 > Oh Geez,
 >
 >
I try to reverse the numbers and get all kinds of junk to Imbalance USD.
 > Is there a way to elegantly do this?


I exported it to a CSV.   I found founbd columns:

      Amount With Sym
      Amount Num.

It it really easy to reverse their signs and write it back
out with Libre Office Calc

Is there a way to read it back in and overwrite what was there?

Many thanks,
-T


When editing a transaction in GnuCash it is easy and recommended to tab 
from field to field in the transaction and change the text, signs or 
amounts as desired, with the caveat that tabbing off the right end of a 
line will trigger GnuCash to calculate a sum of the two values in the 
credit and debit fields and place a positive value in one of the boxes.


Then you can continue through the transaction until all lines are as 
desired.  To commit your completed edit press Return or Enter whatever 
it is called on your keyboard.  GnuCash will then re-arrange the lines 
so all the lines with positive values in the left box appear first, then 
lines with positive values in the right box appear below.  If there are 
lines with zeros the zeros disappear but the line remains with empty 
boxes in between the other lines.  This is also when GnuCash adds lines 
called Imbalance if all the lines do not add up to zero.  Once you get 
used to that behavior it seems automatic and logical.


--
David Carlson


That explains a lot.  I had been pressing Enter on every block.


___
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] move files into sub folder

2019-04-13 Thread Karen Remick
When I installed GnuCash I told it to put files in the folder for my 
business. I made the incorrect assumption that they'd be put into a 
file. Instead they are mixed in with the other files for my business. 
I'd like to put all the GnuCash files in one folder (let's call it 
GnuCashFiles) and have the program add any new files to that folder. How 
do I tell the program where the files are? I haven't seen the name of 
the file they are currently in, so I don't know what to edit.


___
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] move files into sub folder

2019-04-13 Thread Adrien Monteleone
The GnuCash datafile ends in .gnucash.

Simply create your desired folder and move the file there. Then (if on Windows 
or Linux) double-click the data file to open it and GnuCash will remember its 
new location. Otherwise (or on a Mac) Open GnuCash first, (it will fail to find 
the last used file because you moved it) and choose File > Open and then 
navigate to the new location and select the data file and click `Open`.

There may be other files (logs, backups) associated with your GnuCash data 
file, you can move them all to the same place. (but GnuCash will create new 
ones in the new directory anyway)

Regards,
Adrien

> On Apr 13, 2019, at 11:45 PM, Karen Remick  
> wrote:
> 
> When I installed GnuCash I told it to put files in the folder for my 
> business. I made the incorrect assumption that they'd be put into a file. 
> Instead they are mixed in with the other files for my business. I'd like to 
> put all the GnuCash files in one folder (let's call it GnuCashFiles) and have 
> the program add any new files to that folder. How do I tell the program where 
> the files are? I haven't seen the name of the file they are currently in, so 
> I don't know what to edit.


___
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] Don't understand why I have what I have

2019-04-13 Thread Adrien Monteleone
I understand you don’t care for the official documentation, but how much 
frustration have you endured by not reading it and just trying to plow through? 
How many times have you asked for help or for understanding that would have 
been avoided by reading the manual?

Help Manual (https://www.gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=help, or 
p.56 in the PDF)
Chapter 6. Common Transaction Operations
6.2. Enter Transaction via register

"Note
When working on transactions in GnuCash, be aware that the Enter key and the 
Tab key behave differently, and perform different actions.

The Enter key moves to the first field of the next split, regardless of which 
field you are in. If there is no next split, proceeds to the next transaction. 
In any case, Enter finishes the transaction edit, and any imbalance is posted 
to Imbalance-CUR, where CUR is the currency of the transaction.

The Tab key moves to the next field in the current split. If it's the last 
field, moves to the next split, creating a new one if there isn't one. If the 
split is blank, the Tab key finishes the transaction and posts any imbalance to 
Imbalance-CUR, as above."

The rest of the section proceeds to explain, step by step, field by field, what 
to enter and how to do it unambiguously.

Regards,
Adrien

> On 4/14/19 12:16 AM, ToddAndMargo wrote:
> 
> That explains a lot. I had been pressing Enter on every block.

___
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] move files into sub folder

2019-04-13 Thread D via gnucash-user
Alternatively, after creating the subfolder, open Gnucash (which will open your 
last file automatically), select File->Save As, and save your file to the new 
subfolder. Exit Gnucash and verify that your file its in its new location, and 
then clear out the old folder.

David

On April 14, 2019, at 10:28 AM, Adrien Monteleone 
 wrote:

The GnuCash datafile ends in .gnucash.

Simply create your desired folder and move the file there. Then (if on Windows 
or Linux) double-click the data file to open it and GnuCash will remember its 
new location. Otherwise (or on a Mac) Open GnuCash first, (it will fail to find 
the last used file because you moved it) and choose File > Open and then 
navigate to the new location and select the data file and click `Open`.

There may be other files (logs, backups) associated with your GnuCash data 
file, you can move them all to the same place. (but GnuCash will create new 
ones in the new directory anyway)

Regards,
Adrien

> On Apr 13, 2019, at 11:45 PM, Karen Remick  
> wrote:
> 
> When I installed GnuCash I told it to put files in the folder for my 
> business. I made the incorrect assumption that they'd be put into a file. 
> Instead they are mixed in with the other files for my business. I'd like to 
> put all the GnuCash files in one folder (let's call it GnuCashFiles) and have 
> the program add any new files to that folder. How do I tell the program where 
> the files are? I haven't seen the name of the file they are currently in, so 
> I don't know what to edit.


___
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] Don't understand why I have what I have

2019-04-13 Thread D via gnucash-user
This.

On April 14, 2019, at 10:44 AM, Adrien Monteleone 
 wrote:

I understand you don’t care for the official documentation, but how much 
frustration have you endured by not reading it and just trying to plow through? 
How many times have you asked for help or for understanding that would have 
been avoided by reading the manual?

Help Manual (https://www.gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=help, or 
p.56 in the PDF)
Chapter 6. Common Transaction Operations
6.2. Enter Transaction via register

"Note
When working on transactions in GnuCash, be aware that the Enter key and the 
Tab key behave differently, and perform different actions.

The Enter key moves to the first field of the next split, regardless of which 
field you are in. If there is no next split, proceeds to the next transaction. 
In any case, Enter finishes the transaction edit, and any imbalance is posted 
to Imbalance-CUR, where CUR is the currency of the transaction.

The Tab key moves to the next field in the current split. If it's the last 
field, moves to the next split, creating a new one if there isn't one. If the 
split is blank, the Tab key finishes the transaction and posts any imbalance to 
Imbalance-CUR, as above."

The rest of the section proceeds to explain, step by step, field by field, what 
to enter and how to do it unambiguously.

Regards,
Adrien

> On 4/14/19 12:16 AM, ToddAndMargo wrote:
> 
> That explains a lot. I had been pressing Enter on every block.

___
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] Some chinese words can not be displayed

2019-04-13 Thread Richard Zhang
Hi John,
I put the settings.ini into the C:\Users\erzhang\AppData\Local\gtk-3.0 with 
following settting:

[Settings]
gtk-font-name=Microsoft YaHei 14

It back to normal.
Thanks!
BR/Richard


-Original Message-
From: Richard Zhang 
Sent: 2019年3月27日 17:03
To: 'John Ralls' 
Cc: gnucash-user@gnucash.org
Subject: RE: [GNC] Some chinese words can not be displayed

Hi John,
Thanks for your reply.
I will study the documents and try to fix it.
BR//Richard


-Original Message-
From: John Ralls  
Sent: 2019年3月25日 22:44
To: Richard Zhang 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Some chinese words can not be displayed



> On Mar 24, 2019, at 7:34 AM, Richard Zhang  wrote:
> 
> Hi Support,
> I got a problem when I use the GNUCASH.
> 
> Environment: Window 10 Enterprise
> Version: 1709
> Language: English
> 
> Symptom: some words in menu and description can not be displayed.
> [cid:image001.png@01D4E22A.DB249AA0]
> 
> Pls help.

You need to configure a font with better Unicode support. See 
https://wiki.gnucash.org/wiki/GTK3. The hard part is figuring out which font to 
use.

Regards,
John Ralls


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


[GNC] Help me out with the online currencies price retrieval

2019-04-13 Thread Petrus Arief
Dear Gnucash User & Development Team,

My name is Petrus.
I have a problem with my online price retrieval.
I installed the newest version of strawberry perl & gnucash and installed
the Online Price Retrieval for Gnucash, but I'm facing this error
(attached).

[image: image.png]
___
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.