Re: [GNC] Adding Namespace Item to Price Editor

[Derek Atkins]

Hi,

On Sun, March 21, 2021 2:14 pm, Jack Frillman via gnucash-user wrote:
>
> In the GNUCash Price Editor  you have to choose from a list of seven
> *Namespace* items:
>
> Currencies, All non-currencies, AMEX, EUREX, FUND, NASDAQ, NYSE
>
> Is there any way of adding an item to this list?

When you create a new commodity, you can choose to type in anything you
wish in that section (i.e., you don't have to choose only from the
available list).

> Thanks.

> 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] mortgage refinance

[Derek Atkins]

Peter,

On Sun, March 21, 2021 10:07 am, Peter West wrote:
> What’s the other side of the new loan set-up? Cash at bank?
>
> So
> Liability Loan A  100,000 Cr
> Liability Loan B  105,000 Cr
> Asset Bank105,000 Dr

This is wrong -- your Debits and Credits don't sum to zero.

>
> Then
> Asset Bank100,000 Cr  -> 5,000 Dr
> Liability Loan A  100,000 Dr -> Zero balance
> Liability Loan B  105,000 Dr
>
> Like that?

I think I understand what you are trying to say, and *I'm* very confused
by what you are saying!!!

-derek

>
> Peter
>
> —
> Peter West
> p...@ehealth.id.au
> “Now is the judgment of this world; now will the ruler of this world be
> cast out.”
>
>> On 21 Mar 2021, at 11:42 pm, D via gnucash-user
>>  wrote:
>>
>> New loan gets a new liability account. Transaction from new loan top old
>> loan pays off old loan. Old loan goes to zero, is reconciled, and can be
>> set as placeholder and hidden, if desired. Future transactions pay new
>> loan.
>>
>> On Mar 21, 2021, 09:26, at 09:26, Parker Graham  wrote:
>>> Have mortgage set up in system but refinanced it and need help on how
>>> to
>>> payoff existing loan and set up new loan
>>>
>>> ___
>>> 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.
>


-- 
   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] mortgage refinance

[Derek Atkins]

Let's say your old loan has $95,000 remaining.
Your new loan is $105,000
I am ignoring loan costs, interest prepays, escrow, etc.

You would create a transaction:

  Loan Payout   Old Loan   Debit   $95000
New Loan   Credit $105000
Cash   Debit   $1

I.e., you will Increase cash $10k, and then pay off the old loan and take
out the new loan.

-derek

On Sun, March 21, 2021 9:41 am, Parker Graham wrote:
> not following, please give me example such as original loan is
> 100,000.00 refi loan is 105,000.00
>
> thanks
>
> On 3/21/21 9:36 AM, py...@cox.net wrote:
>> Several ways to do this.   Here is the easiest way I know:
>>
>> Mortgage Loan (start loan B)   Increase - Loan Amount
>> Mortgage Loan (start loan B)Decrease -Principal Amount
>> remaining
>> from Loan A
>>
>> Net result - New loan amount before first payment.  Now the two entries
>> are
>> actually the net result of a split transaction entry that comes right
>> from
>> the closing statement received from the mortgage company.  If you follow
>> that statement - you should be good to go.
>>
>> Hope that helps.
>>
>>
>> -Original Message-
>> From: gnucash-user  On
>> Behalf Of Parker Graham
>> Sent: Sunday, March 21, 2021 6:25 AM
>> To: gnucash-user@gnucash.org
>> Subject: [GNC] mortgage refinance
>>
>> Have mortgage set up in system but refinanced it and need help on how to
>> payoff existing loan and set up new loan
>>
>> ___
>> 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.
>


-- 
   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] weird price for LU0067412154

[Derek Atkins]

Hi,

On Wed, March 17, 2021 3:18 pm, Andrea Borgia wrote:
>
> Il 17/03/21 20:12, Derek Atkins ha scritto:
>> What quote source are you using?  This doesn't work for me with
>> Yahoo-JSON:
>
> It was in the first screenshot, here is the text version:

The screenshot didn't make it through the email, most likely because you
sent it as an embedded image in HTML instead of as a text with attachment.

>
> gnc-fq-dump morningstarch LU0067412154

When I run this, I get:

gnc-fq-dump morningstarch LU0067412154
Finance::Quote fields Gnucash uses:
symbol: LU0067412154 <=== required
  date: 03/17/2021   <=== recommended
  currency: USD  <=== required
  last: 2150.31  <=\
   nav: 2150.31  <=== one of these
 price: 2150.31  <=/
  timezone:  <=== optional


> gnc-fq-dump mstaruk LU0067412154

This gives me different results:

gnc-fq-dump mstaruk LU0067412154
Finance::Quote fields Gnucash uses:
symbol: LU0067412154 <=== required
  date: 03/17/2021   <=== recommended
  currency: USD  <=== required
  last: 5356.02  <=\
   nav: 5356.02  <=== one of these
 price: 5356.02  <=/
  timezone:  <=== optional

So I would say the issue is upstream, possibly with the quote sources.

> 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] weird price for LU0067412154

[Derek Atkins]

What quote source are you using?  This doesn't work for me with Yahoo-JSON:

gnc-fq-dump yahoo_json LU0067412154
Use of uninitialized value $json_name in concatenation (.) or string at
/usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 132.
Use of uninitialized value $info{"LU0067412154\34currency"} in string eq
at /usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 145.
Use of uninitialized value $info{"LU0067412154\34currency"} in string eq
at /usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 145.
Use of uninitialized value $info{"LU0067412154\34currency"} in string eq
at /usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 156.
Use of uninitialized value in sprintf at
/usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 178.
Use of uninitialized value in sprintf at
/usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 178.
Finance::Quote fields Gnucash uses:
symbol: LU0067412154 <=== required
  date: 03/17/2021   <=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!

-derek


On Wed, March 17, 2021 3:07 pm, Andrea Borgia wrote:
> Hi.
>
> Something odd is going on but I can't decide if it is F::Q at fault or GC:
>
> Thing is, the UK website lists a totally reasonable price, so it's
> either gnc-fq-dump or F::Q who is playing fast and loose with numbers :)
>
>
> The price editor is affected as well, actually that's how I found out.
> For the moment I simply switched source but I'm puzzled.
>
> Any pointers?
>
>
> Thanks,
>
> Andrea.
>
>
> ___
> 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.
>


-- 
   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] Scheduled transaction frequency?

[Derek Atkins]

I don't think you can do that with the current implementation.

-derek

On Tue, March 16, 2021 1:04 pm, gnu Gord wrote:
> I'm trying to add a scheduled transaction that occurs 21 days after the
> 10th of each month.
> With this timing, the transaction does not occur on a specific date in the
> month. Some months it's on the 31st and some months it's on the first of
> the next month, ETC
>
> I can't figure out how to enter that in GnuCash.
> ___
> 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.
>


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

[GNC] [MAINT] Unplanned network outage

[Derek Atkins]

Hi everyone,

I apologize for the 23-hour outage.  Some landscape installers did some
work unannounced and sliced my network line in the process.  As you can
tell, it's back now!  Yay rapid response.

Even though this is the last operation that I expect to have, I am still
seriously considering an LTE backup, and an insurance policy.  I can get
the hardware relatively inexpensively -- it's the data service that I'm
trying to find.

Again, sorry for any inconvenience.  Just me, it wasn't easy here, either!
 LOL.

Happy Gnucashing!

-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] Best way to close unpaid invoices?

[Derek Atkins]

Adrien,

On Mon, March 8, 2021 10:54 am, Adrien Monteleone wrote:
> You should refrain from making manual entries or edits in AR/AP. It
> isn't that you can't or that anything will blow up, but you may forget
> that the Business Features will not see those edits/transactions where
> you might expect them to.
>
> If you really need to make manual edits/entries, create an 'Other AR/AP'
> account, as a child of the main account, and make sure it is of type
> 'Asset/Liability' and *not* of type 'AR/AP'. (there can be only 1 of
> each of those)
>
> With the method listed below, the Business Features (and their reports)
> 'think' the customer paid when they did not.

I would suggest that the method Alan used below is EXACTLY the RIGHT thing
to do, and indeed it's exactly how I would (and have) handled bad debts in
the past.

Manual adjustment of payment transactions is explicitly allowed, so long
as you don't change the split tied to the AR/AP account.  But changing the
transfer account from Cash to Expenses:Bad Debt, or even splitting the
Cash split like Alan did, is perfectly acceptable.

> See my other reply describing how to close these out properly in GnuCash.

-derek

> Regards,
> Adrien
>
> On 3/8/21 2:33 AM, Alan Hopkins wrote:
>> Hi all
>> I'm new to GNU Cash but I just tested a method that worked and I
>> think
>> is valid.
>> I went to the client's invoice and paid the full amount ($120) which
>> then was entered by GNUCash into the Accounts Receivable.
>> I then went into the Accounts Receivable account, located the
>> payment,
>> looked at the Splits (DR $120 Assets:CashOnHand, CR $120 A/R) and
>> changed the splits to be Debit CashOnHand $60 Debit Bad Debts $60
>> Credit Accounts Receivable $120.
>> The invoice is recorded as paid and no longer appears in reminders
>> and
>> all the accounts are in the correct state.
>> Maybe that may be of 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.
>


-- 
   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] Opening Multiple Data Accounts

[Derek Atkins]

HI,

On Wed, March 3, 2021 11:40 am, Bruce Irving wrote:
>>Date: Mon, 1 Mar 2021 10:49:34 -0600
>>Subject: Re: [GNC] Linux question
>>
>>When you say "multiple data accounts", do you mean that you can open more
> than one Gnucash f>ile at once on Mac OS? How do you do that? I haven't
> been able to and it would be convenient.
>>
>>Regards,
>>Will
>
> I have 3 data files, each in its own directory (folder)  When I want to
> open one of them, I navigate to that directory then double click the data
> file.
>
> To open another, I again navigate to the appropriate directory and double
> click the data file and it starts another instance of GnuCash.
>
> This works in both Windows and Linux.  I don't know about Mac.

This does not work on a Mac; indeed, on a Mac double-clicking on a file
DOES NOT open that data file.  Specifically, on a Mac, it will start
GnuCash, but gnucash will re-open the last file it had open and NOT the
file you double-clicked.

To open a second file on a Mac (if you can -- I don't know), you would
need to run GnuCash from the Terminal and pass the filename on the
commandline.

NOTE:  Having multiple instances of GnuCash open at the same time can
potentially cause Preference and Metadata loss, as files may get written
by one copy and then those changes get over-written by another copy.  This
includes metadata like open windows and tabs, saves reports, etc.  YMMV.

> HTH
> Bruce

> 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] Need help correcting transaction account

[Derek Atkins]

HI,

Jump over to the AR/AP account for the transaction and there it should
have the Invoice # in the register.

-derek

On Mon, March 1, 2021 12:21 pm, Rich Shepard wrote:
> ast October 24th I mis-posted an SBA-PPP loan salary payment as a debit to
> the loan liability account rather than to the members draw expense
> account.
>
> I cannot delete that transaction and re-enter it because gnucash tells me
> it
> was paid on an invoice, and I cannot find that invoice searching for the
> payee name in the Business->Vendor->Find invoice dialog box.
>
> I'm stymied and need to learn how to correct that transaction. The
> liability
> account should show only the PPP loan amount while the draw against it
> should be to the Expenses->SBA-PPP Salary account.
>
> TIA,
>
> 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.
>


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

[Derek Atkins]

Hi,

On Mon, March 1, 2021 11:49 am, Stephen C. Camidge wrote:
> I am looking to modify Gnucash preferences on Linux.

Like I said... Edit -> Preference.

If it's not being stored persistently, then you don't have the dconf
service running.

> I mean multiple registers open.

It absolutely supports this.  You may need to flip the preference from Tab
to Window or Window to Tab depending on how you want it to behave.  Edit
-> Preferences -> Register Defaults, "Register opens in new window"

> Thank you,
> Steve

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

[Derek Atkins]

Hi,

On Mon, March 1, 2021 11:39 am, Stephen C. Camidge wrote:
> I am starting to learn about Linux (I use Gnucash on my Mac) and copied my
> datafile over to Gnucash installed on Manjaro Linux via a flashdrive.
>
> On the Mac I have preferences I can tweak and I can have mutiple data
> accounts open at once. I do not see this under Linux.

Linux has preferences you can tweak.  Edit -> Preferences.

As for "multiple data accounts" -- do you mean "multiple files" open, or
just multiple registers open?  You can absolutely have multiple registers
open..  For multiple data files, on Linux, you need to run GnuCash
multiple times -- I wasn't sure you could even DO that on a Mac?

>
> Please advise.

Hope this helps..

>
> Thank you
> Steve

> 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] How to enter zero-share transaction splits in an Asset:Stock account?

[Derek Atkins]

HI,

On Sun, February 28, 2021 3:17 pm, Evelyn Yamanaka wrote:
> I'm trying to enter a split with zero shares in a stock account for the
> purpose of manually recording capital gains/losses. I'm using GnuCash 4.4
> on Win 10.
>
> According to the gnucash-guide documentation:
> -
> In order for GnuCash to commit the zero-share, zero-price split for
> account
> Assets:Stock:SYMBOL to the transaction in the following schemes, you
> *must*
> Tab out of that
> split. If you use the Enter key, GnuCash will convert the split into
> shares
> of the commodity
> -
>
> However, when I do this, the share and price columns are
> STILL automatically populated with non-zero amounts.
>
> In detail, I am doing this:
> 1. Click on a new transaction
> 2. Enter date, 
> 3.  out of [Num]
> 4. Enter transaction description, 
> 5. (Advance to first split)  out of [Action]
> 6. Enter split description, 
> 7. ([Account] auto-populated with current account)  out of [Account]
> 8.  out of [Shares], leaving it blank

Don't do this.  Enter a '0' here explicitly.

> 9.  out of [Price], leaving it blank
> 10. Enter "100" into [Debit], 
> 11.  out of [Credit]
>
> At this point, the next line / split is activated. However, [Shares] from
> the split I just left is automatically populated with the amount I entered
> in [Debit]. The same thing happens if I enter a value for [Credit]
> instead.
> Essentially, I cannot leave the first split without [Shares] automatically
> taking the value from either [Credit] or [Debit].

Correct. There are 3 important fields:  #Shares, Price, and Debit/Credit. 
 Only #Shares and Debit/Credit is stored, the Price is *always* computed,
so generally it is best to enter those two fields.

GnuCash sort-of requires you to enter two of those three.  If you only
enter one field (e.g. DebCred), then it assumes a share price of 1 and you
get the behavior you observed.  However, if you explicitly enter 0 in the
#shares column, then you will have entered 2 column data and GnuCash will
take them as you entered them.

If you enter all three, it will complain and ask you which to use.

> At no point in this process have I hit .
>
> I know there is the option to use automatic lots to create capital
> gain/loss transactions. However, I'm recording past SpecID transactions
> for
> which individual lot information is not available, and the number and
> complexity of those transactions make it impractical to reverse engineer
> specific lot information. Therefore, I'm trying to manually record
> realized
> capital gains/losses without assigning them to specific lots. However, the
> inability to enter zero-share transactions into Asset:Stock accounts is
> preventing me from doing this.

I hope my explanation above helped!

> 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] Fwd: www.gnucash.org

[Derek Atkins]

Hi,

Actually, this probably should go to gnucash-devel instead of
gnucash-user.  So please reply only to -devel..

Right now we do have some diversified DNS -- Linas runs 2 DNS servers and
I run one.  We could set up one more...  So THAT (DNS) isn't the issue.

I could also set up a www "mirror" at my site, so "www.gnucash.org" would
be somewhat diversified.  However, I'd rather it be a hot-spare than a
round-robin solution, and *that* is something I don't know how to do. 
What I mean is that we could set up multiple IP targets for
www.gnucash.org in DNS, but clients would then hit both of them, whereas
what I would want is for them only to hit the second if the first is
unavailable.

Moreover, that would only work for Linas' server (www), it wouldn't help
for mine (which also runs master git, wiki, email lists, etc).

I certainly welcome ideas, but we want to be the masters of our own
destiny, which means running our own servers and not using e.g. AWS.

-derek

On Sat, February 27, 2021 9:18 am, David G. Pickett via gnucash-user wrote:
> gnucash should have geographically diversified web servers?
>
>
> -Original Message-
> From: Linas Vepstas 
> To: David G. Pickett 
> Sent: Fri, Feb 26, 2021 6:18 pm
> Subject: Re: www.gnucash.org
>
> That's a question for the gnucash-user mailing list. I am not involved in
> spinning out releases. or in development, for that matter.
> -- Linas
>
> On Tue, Feb 23, 2021 at 2:18 PM David G. Pickett 
> wrote:
>
> PS: Now web site is up, no 4.4 for Ubuntu 20-04 lts?
>
>
> -Original Message-
> From: David G. Pickett 
> To: linasveps...@gmail.com 
> Sent: Mon, Feb 22, 2021 8:44 pm
> Subject: Re: www.gnucash.org
>
> The trick to dns fallover is having each web server be a dns server of the
> same domain saying it is the www.  The dns servrs that are up and
> accessible give out their own address.  This is old but a robust outer
> layer.
>
> Cloud services can set up multiple servers that are just virtual slices
> many places in their cloud.
>
>
> -Original Message-
> From: Linas Vepstas 
> To: David G. Pickett 
> Sent: Sun, Feb 21, 2021 7:30 pm
> Subject: Re: www.gnucash.org
>
> Well, there's a mirror at utwente, I believe, but there's no automated
> failover to that. The master DNS server was down as well.
>
> I've set up dns failover in the past, but its kind of tricky, and hard to
> test, and didn't seem entirely reliable.
> -- Linas
>
> On Sun, Feb 21, 2021 at 2:49 PM David G. Pickett 
> wrote:
>
>  Need a diverse set of mirror/duplicate locations!  Ask around!
> On Saturday, February 20, 2021, 04:28:37 PM EST, Linas Vepstas
>  wrote:
>
>  Website is in Texas. No electric power for 5 days! -- Linas
>
> On Thu, Feb 18, 2021 at 7:59 AM David G. Pickett 
> wrote:
>
> Has gnucash gone broke?  The website has been missing for days!
>
>
> --
> Patrick: Are they laughing at us?Sponge Bob: No, Patrick, they are
> laughing next to us. 
>
>
>
>
> --
> Patrick: Are they laughing at us?Sponge Bob: No, Patrick, they are
> laughing next to us. 
>
>
>
>
> --
> Patrick: Are they laughing at us?Sponge Bob: No, Patrick, they are
> laughing next to us. 
>
> ___
> 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.
>


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

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

Re: [GNC] Transaction Reconcile behavior differences

[Derek Atkins]

Hi,

On Tue, February 23, 2021 8:34 am, Peter S. Shenkin wrote:
> Perhaps I’m wrong about this (still a neophyte) but I have the idea that
> the accounting concept of reconciliation applies to external accounts.

Reconciliation is all about ensuring that your books match *something*
else.  It *usually* implies a Bank, Loan, Credit Card, etc statement, but
that's not necessarily always the case.  You could, for example, reconcile
an account against a pile of receipts, or invoices, or anything else. 
Personally I use reconciliation for my reimbursable business expenses (so
I know which transactions have been filed for reimbursement, and which
have been paid out).

> In GC 4.3, if a transaction is imbalanced, it show up with an “Imbalance”
> amount. Does this not suffice for internal account transfers?

Imbalance has nothing to do with reconciliation.  You get an Imbalance
amount whenever you have an imbalanced transaction.  Taking a step back,
ever transaction must balance, meaning the Debits and Credits sum to 0. 
This means every transaction must touch at least two accounts (a debit
account and a credit account).  For example, a basic transaction could
credit Liabilities:CreditCard and debit Expenses:Groceries.  This is also
labeled "Transfer Account" in the GnuCash register, and if you open the
L:CC account you'll see "E:Groceries" in the transfer account column.

If you try to enter a transaction without specifying the transfer account,
it will default to "Imbalance".  This is "bad" -- it means you have not
properly categorized your transactions.  So if you ever find transactions
in your Imbalance account, you should fix that.

Similarly, if you try to enter a multi-split transaction and attempt to
commit it before you are done, GnuCash will auto-balance it into
Imbalance.  Again, this is something you should fix.

Needless to say, none of this applies to reconciliation.

> External transactions as well have to be balanced within the accounting
> system and will show up as an imbalance if they are not, but in addition,
> have to be reconciled with the external account balances, if I understand
> “reconciliation” correctly.

While your conclusion is correct, the reasoning is not quite.  The goal of
reconciliation is to ensure your books match some statement or external
list of transactions.  IF you have internal transfers between virtual
accounts then yes, you should still reconcile those, even though they are
not on the bank's statement.  Why?  Because you want your reconciled
balance to be correct.  Also, you would want to ensure that if you View ->
Filter By -> Status to look for non-reconciled transactions, the
intra-bank transfers don't show up and muddy the waters.

Hope this helps,

-derek

> -P.
>
> On Tue, Feb 23, 2021 at 7:52 AM Derek Atkins  wrote:
>
>> It is certainly possible that the behavior changed between 3.2 and 4.2
>>
>> -derek
>> Sent using my mobile device. Please excuse any typos.
>> On February 23, 2021 7:38:59 AM John Nickell 
>> wrote:
>> > I believe on Linux I was running 3.2 (last note that I have which
>> > references a version), but I did a destructive update and can't
>> confirm
>> > that now. On Windows I'm running 4.2
>> >
>> > On Tue, Feb 23, 2021 at 6:17 AM Derek Atkins  wrote:
>> > What version were you using on Linux?
>> > What version on windows?
>> > Most likely this is a change of behavior due to different gnucash
>> versions
>> > and not change of OS.
>> >
>> > -derek
>> > Sent using my mobile device. Please excuse any typos.
>> >
>> > On February 23, 2021 7:14:40 AM John Nickell 
>> wrote:
>> >
>> >> I recently switched from GnuCash on Linux Mint to GnuCash on Windows.
>> I
>> >> brought the same GnuCash data file over between computers.
>> >>
>> >> My checking account is setup in GnuCash as a parent account with
>> multiple
>> >> sub accounts to the checking account.
>> >> When reconciling (including sub accounts) on Linux if I selected a
>> >> transaction that had multiple splits or was simply a transfer among
>> sub
>> >> accounts, all of the transaction splits that were part of that same
>> >> transaction would also be marked as reconciled. (i.e. their box would
>> be
>> >> checked and the reconcile balance would reflect a $0 change.)
>> >>
>> >> When reconciling on Windows I'm having to reconcile each split
>> individually
>> >> and if the transaction is between two sub accounts within the
>> checking
>> >> account I must reconcile both the debit and t

Re: [GNC] Transaction Reconcile behavior differences

[Derek Atkins]

It is certainly possible that the behavior changed between 3.2 and 4.2

-derek
Sent using my mobile device. Please excuse any typos.
On February 23, 2021 7:38:59 AM John Nickell  wrote:
I believe on Linux I was running 3.2 (last note that I have which 
references a version), but I did a destructive update and can't confirm 
that now. On Windows I'm running 4.2


On Tue, Feb 23, 2021 at 6:17 AM Derek Atkins  wrote:
What version were you using on Linux?
What version on windows?
Most likely this is a change of behavior due to different gnucash versions 
and not change of OS.


-derek
Sent using my mobile device. Please excuse any typos.

On February 23, 2021 7:14:40 AM John Nickell  wrote:


I recently switched from GnuCash on Linux Mint to GnuCash on Windows. I
brought the same GnuCash data file over between computers.

My checking account is setup in GnuCash as a parent account with multiple
sub accounts to the checking account.
When reconciling (including sub accounts) on Linux if I selected a
transaction that had multiple splits or was simply a transfer among sub
accounts, all of the transaction splits that were part of that same
transaction would also be marked as reconciled. (i.e. their box would be
checked and the reconcile balance would reflect a $0 change.)

When reconciling on Windows I'm having to reconcile each split individually
and if the transaction is between two sub accounts within the checking
account I must reconcile both the debit and the credit action separately.

Is this expected and desired on the Windows version of GnuCash, or is there
a setting I'm missing so that a reconciling "part" of a transaction
reconciles all of the transaction within the account?

I'm not looking for a reconciliation in my checking account to reconcile
the transaction split in the savings account, but for transaction splits
that are within the same parent checking account being reconciled I'd like
to see similar behavior as I saw on the Linux version. Or at least
understand this is 'expected'.

I've made pretty heavy use of these split transaction types and this
unexpected difference in transferring OS's has slowed down my
reconciliation process.

If an example helps:
I us a single transaction to transfer a $1000 paycheck into three sub
accounts. $300 for Automobile, $500 for Savings, $200 for Food.  All are
still within the same parent checking account. In Linux checking the box to
reconcile the $200 food transaction would also check the Automobile,
Savings and $1000 split.  In my experience with Windows all 4 transaction
splits must be "checked" individually.

Checking

Food
Automobile
Savings

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

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


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

Re: [GNC] Transaction Reconcile behavior differences

[Derek Atkins]

What version were you using on Linux?
What version on windows?
Most likely this is a change of behavior due to different gnucash versions 
and not change of OS.


-derek
Sent using my mobile device. Please excuse any typos.
On February 23, 2021 7:14:40 AM John Nickell  wrote:


I recently switched from GnuCash on Linux Mint to GnuCash on Windows. I
brought the same GnuCash data file over between computers.

My checking account is setup in GnuCash as a parent account with multiple
sub accounts to the checking account.
When reconciling (including sub accounts) on Linux if I selected a
transaction that had multiple splits or was simply a transfer among sub
accounts, all of the transaction splits that were part of that same
transaction would also be marked as reconciled. (i.e. their box would be
checked and the reconcile balance would reflect a $0 change.)

When reconciling on Windows I'm having to reconcile each split individually
and if the transaction is between two sub accounts within the checking
account I must reconcile both the debit and the credit action separately.

Is this expected and desired on the Windows version of GnuCash, or is there
a setting I'm missing so that a reconciling "part" of a transaction
reconciles all of the transaction within the account?

I'm not looking for a reconciliation in my checking account to reconcile
the transaction split in the savings account, but for transaction splits
that are within the same parent checking account being reconciled I'd like
to see similar behavior as I saw on the Linux version. Or at least
understand this is 'expected'.

I've made pretty heavy use of these split transaction types and this
unexpected difference in transferring OS's has slowed down my
reconciliation process.

If an example helps:
I us a single transaction to transfer a $1000 paycheck into three sub
accounts. $300 for Automobile, $500 for Savings, $200 for Food.  All are
still within the same parent checking account. In Linux checking the box to
reconcile the $200 food transaction would also check the Automobile,
Savings and $1000 split.  In my experience with Windows all 4 transaction
splits must be "checked" individually.

Checking

Food
Automobile
Savings

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

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


___
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] Wildcard matching on import

[Derek Atkins]

You can file an RFE in Bugzilla.
You could put it on overvoice.
We have not had good success with crowd funded development.
Depending on whether you want QIF or other methods, it's either Scheme of C 
hacking.  Github PR is best option to submit code.


-derek
Sent using my mobile device. Please excuse any typos.
On February 20, 2021 12:30:57 PM Paul Harmsworth  wrote:

By rules I mean the text used for matching, which is stored in the DB.

But if regex can't be done that is truly a pity.

Is there a way of getting change requests  scheduled, and crowd funded?


On Sat, 20 Feb 2021, 18:25 Derek Atkins,  wrote:
I don't know what "rules" you are talking about.  The importers either use 
string matching or tokenized bayesian matching.  There is no glob or regex 
matching.


-derek
Sent using my mobile device. Please excuse any typos.

On February 20, 2021 11:50:15 AM Paul Harmsworth  wrote:

Hi,
It doesn't support editing the rules yet I can do that directly in the dB...
So I am wondering if properly escaped * in the DB will perhaps work.
This lack of user control of rules is a serious product limitation.
Regards
Paul

On Sat, 20 Feb 2021, 17:14 Derek Atkins,  wrote:
Sorry,
Gnucash does not support wildcard matching for import mapping.

-derek
Sent using my mobile device. Please excuse any typos.

On February 20, 2021 11:11:19 AM Paul Harmsworth  wrote:


Hi,

Interesting but I want to be able to use wild cards. I can edit the gnucash
db and I want something like *zork*

Doe anyone know how this can be done?

Regards

Paul

On Sat, 20 Feb 2021, 16:36 David Carlson, 
wrote:


Paul,

You might look at <https://wiki.gnucash.org/wiki/Bayes> for a start.  I
am not sure if this page has been updated for the changes that were made
when GnuCash added a way to edit the matching criteria. For general concept
I would Google "Bayesian Matching"

On Sat, Feb 20, 2021 at 7:50 AM Paul Harmsworth 
wrote:


Hi,

I love Gnucash and have used it often. But, the lack of easy end user
control of matching rules is annoying.

Whilst I can easily edit the matching lines in the xml DB. I cannot figure
out how to do wildcard matching. Is it possible to use some kind of escape
chars in the xml to force wildcard matching?

Regards

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



--
David 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] Wildcard matching on import

[Derek Atkins]

I don't know what "rules" you are talking about.  The importers either use 
string matching or tokenized bayesian matching.  There is no glob or regex 
matching.


-derek
Sent using my mobile device. Please excuse any typos.
On February 20, 2021 11:50:15 AM Paul Harmsworth  wrote:

Hi,
It doesn't support editing the rules yet I can do that directly in the dB...
So I am wondering if properly escaped * in the DB will perhaps work.
This lack of user control of rules is a serious product limitation.
Regards
Paul

On Sat, 20 Feb 2021, 17:14 Derek Atkins,  wrote:
Sorry,
Gnucash does not support wildcard matching for import mapping.

-derek
Sent using my mobile device. Please excuse any typos.

On February 20, 2021 11:11:19 AM Paul Harmsworth  wrote:


Hi,

Interesting but I want to be able to use wild cards. I can edit the gnucash
db and I want something like *zork*

Doe anyone know how this can be done?

Regards

Paul

On Sat, 20 Feb 2021, 16:36 David Carlson, 
wrote:


Paul,

You might look at <https://wiki.gnucash.org/wiki/Bayes> for a start.  I
am not sure if this page has been updated for the changes that were made
when GnuCash added a way to edit the matching criteria. For general concept
I would Google "Bayesian Matching"

On Sat, Feb 20, 2021 at 7:50 AM Paul Harmsworth 
wrote:


Hi,

I love Gnucash and have used it often. But, the lack of easy end user
control of matching rules is annoying.

Whilst I can easily edit the matching lines in the xml DB. I cannot figure
out how to do wildcard matching. Is it possible to use some kind of escape
chars in the xml to force wildcard matching?

Regards

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



--
David 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] Wildcard matching on import

[Derek Atkins]

Sorry,
Gnucash does not support wildcard matching for import mapping.

-derek
Sent using my mobile device. Please excuse any typos.
On February 20, 2021 11:11:19 AM Paul Harmsworth  wrote:


Hi,

Interesting but I want to be able to use wild cards. I can edit the gnucash
db and I want something like *zork*

Doe anyone know how this can be done?

Regards

Paul

On Sat, 20 Feb 2021, 16:36 David Carlson, 
wrote:


Paul,

You might look at  for a start.  I
am not sure if this page has been updated for the changes that were made
when GnuCash added a way to edit the matching criteria. For general concept
I would Google "Bayesian Matching"

On Sat, Feb 20, 2021 at 7:50 AM Paul Harmsworth 
wrote:


Hi,

I love Gnucash and have used it often. But, the lack of easy end user
control of matching rules is annoying.

Whilst I can easily edit the matching lines in the xml DB. I cannot figure
out how to do wildcard matching. Is it possible to use some kind of escape
chars in the xml to force wildcard matching?

Regards

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




--
David 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] Reverse all transactions

[Derek Atkins]

Hi,

On Thu, February 11, 2021 3:26 pm, Anton Gladky wrote:
> Hi Derek,
>
> Thanks for a quick reply!
>
>> How did the entries get input into GnuCash?
> Manually, but in a reverse order.
>
>> Why do you believe they are incorrect (reversed)?
> Well all entries in "Expenses" are in "Rebate" column,
> and all entries in "Income" are in "Charge" column.
>
> So I believe all of them need to be reversed.
>
> Now the root structure looks like this:
>
> Assets: -10
> Expenses: -10
> Income: 10

Two things:

1) Yes, this definitely looks wrong.  Sorry.
2) From my experience it's much better (and easier) to enter transactions
from Asset and Liability accounts instead of Income and Asset accounts.

I'm afraid you're going to have to re-enter your data.

You can TRY to export it to CSV, manipulate it there, and then import.

-derek

>
> Thanks
>
> Anton
>
>
> Am Do., 11. Feb. 2021 um 21:17 Uhr schrieb Derek Atkins :
>
>> Hi,
>>
>> On Thu, February 11, 2021 3:12 pm, Anton Gladky wrote:
>> > Dear all,
>> >
>> > I need to reverse all transactions in a relatively large database.
>> > Something like "Increase <-> Decrease" for all entries.
>> >
>> > Is there any effective way to do it? Maybe, is it possible to
>> > operate on sqlte-database directly?
>>
>> How did the entries get input into GnuCash?
>> Why do you believe they are incorrect (reversed)?
>>
>> In short, no, there is no way to do it, and hand-modifying the database
>> could corrupt it.  But depending how the transactions were entered,
>> there
>> may be an easy way to "start over" and do it correctly --- assuming that
>> they ARE incorrect.
>>
>> GnuCash has a preference to "reverse" the sign on some normally-negative
>> accounts, so it's also possible that setting is incorrect, but your data
>> is correct.
>>
>> This is why I'm asking the questions above.
>>
>> Hope this helps,
>>
>> > Thanks
>> >
>> > Anton
>>
>> > 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
>>
>>
>


-- 
   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] Reverse all transactions

[Derek Atkins]

Hi,

On Thu, February 11, 2021 3:12 pm, Anton Gladky wrote:
> Dear all,
>
> I need to reverse all transactions in a relatively large database.
> Something like "Increase <-> Decrease" for all entries.
>
> Is there any effective way to do it? Maybe, is it possible to
> operate on sqlte-database directly?

How did the entries get input into GnuCash?
Why do you believe they are incorrect (reversed)?

In short, no, there is no way to do it, and hand-modifying the database
could corrupt it.  But depending how the transactions were entered, there
may be an easy way to "start over" and do it correctly --- assuming that
they ARE incorrect.

GnuCash has a preference to "reverse" the sign on some normally-negative
accounts, so it's also possible that setting is incorrect, but your data
is correct.

This is why I'm asking the questions above.

Hope this helps,

> Thanks
>
> Anton

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

[GNC] [MAINT] Unplanned network outage

[Derek Atkins]

Hi,

Some of you may have noticed that code went offline around 2:30am US/ET
this morning.  My ISP made a change which caused my "magic box" (a device
I use to work around a NAT table limit) to stop working.  I manually
corrected the issue at 7:15am and have written some code to attempt to do
that automagically next time.  Of course I can't test that until the next
time $ISP decides to do some network hardware work.

I apologize for any inconvenience.

-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] How to get invoices to appear in the Reports|Tax schedule report?

[Derek Atkins]

Hi,

On Thu, February 11, 2021 1:28 pm, Paul Kinzelman wrote:
> I'm running GC 4.4
>
> I'm having trouble generating a tax report that includes paid invoices.
> I'm not an accounting heavy-weight so I'm likely doing something wrong,
> but I don't know what it is.
>
> I created an invoice for a customer and posted it.
> What I see is the money went into AccountsReceivable which is right.
>
> Then they pay the invoice and I mark the invoice as paid.
> The money goes from AccountsReceivable into Checking.
> So when I look at the Checking account, the money says it
> came from the AccountsReceivable account.
>
> However, this money never appears in an Income account.

UMM.. So what account(s) are you specifying on the line-items in the Invoice?
When you post it to A/R -- what are the *other* split-accounts on that
posted transaction?
Those should be your Income accounts.

> So when I do a Reports|TaxScheduleReport that amount
> doesn't appear anywhere in the report so that income is missed
> because AccountsReceivable is not set to be Tax Related but it
> seems like it should be.

Sounds like you're not entering your invoices correctly.

> So if I go to Edit|TaxReport to try to make AccountsReceivable be tax
> related, it does not give me the option to bind it to Schedule C
> like all the other accounts allow. It allows only:
> Tax Report Only - No TXF Report
> F8606 IRA basis at beg of year
> F8606 IRA basis at end of year
> HomeWks Cost of new home

Yeah, don't do that.  A/R isn't a Tax account.

> Shouldn't I be able to specify the AccountsReceivable account
> to be binded to Schedule C Sales income?

No.  A/R is an Asset.

> To get around it I can change the entry in the checking account for
> the amount to come from Income:Sales and it works but I shouldn't
> have to do that.

Indeed.  It should be Income:Sales -> A/R and then A/R -> Checking.

> Shouldn't a paid invoice amount (from AccountsReceivable)
> somehow appear in Income:Sales? Or is
> that for cash-basis accounting and I do want it in
> Accounts:Receiveable for Accrual basis? And if so, shouldn't
> AccountsReceivable be
> able to be designated to appear in my Schedule C under Income?

It should appear in Income:Sales when you post the invoice (not when you
pay it).  If it is not doing that, you're mis-assigning your invoice
line-items.

> TIA!
> -Paul Kinzelman, Peralta NM

> 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] Balance Sheet and Cash Flow Report

[Derek Atkins]

Hi,

On Wed, February 10, 2021 1:20 pm, E. Nick Henery wrote:
> Team
> I am new at this, so please bare with me as I learn the correct process.
>
> I am not sure If this the place to ask these questions.  If not would you
> please direct me to the right location?

You reached the right place.

> I use an iMac and I use CheckBook Pro from the Apple Store to do my
> accounting for personal and a small business.
>
> I can export a QIF file from CheckBook Pro.  My question is:  If I import
> the QIF file from CheckBook Pro into GNUCash, will GNUCash set up the
> account in GNUCash and use the categories I have used in CheckBook Pro?

It depends on how the QIF looks.  IF Checkbook Pro outputs QIF with
Category information, then GnuCash will use that category information. 
Within the import, you get to map each QIF Category with a GnuCash
(Expense) Account.  For example, the "Groceries" category might get mapped
to "Expenses:Groceries" GnuCash account.

If there is no category, the importer will attempt to use the Payee or
Memo fields, and lets you map THOSE to GnuCash accounts.

> Apple Support directed me to look at GNUCash, and it looks like it will do
> what I need.  That is; if the import of the QIF file into GNUCash is
> successful, can I produce a Balance Sheet and Cash Flow Report by month
> over a set period (Yearly)?
>
> If I am in the wrong place to ask these questions; I apologize for any
> inconvenience I cause.  Thanks Nick

Hopefully this helps?

> 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] flatpak 4.4 reports anomaly

[Derek Atkins]

Honestly, I don't know.  Hopefully Geert or John or Chris will reply with
more authoritative answers.

-derek

On Tue, February 9, 2021 4:17 pm, Elmar wrote:
> Since they do run and do extract the correct data OK, can I simply
> resave them, or if not, trivially alter some aspect to save under a new
> name to avoid having to remember what I all tweaked in each of them?
>
> On 2/9/21 4:02 PM, Derek Atkins wrote:
>> Hi,
>>
>> It is certainly true that 2.6 reports are not compatible with 4.4.  So
>> yes, I would expect saved reports to not have made the transition.
>>
>> -derek
>>
>> On Tue, February 9, 2021 3:58 pm, Elmar wrote:
>>> Running the flatpak 4.4 on Linux Mint 19.3 - I've copied my version
>>> 2.6.19 reports into the gnucash folder in
>>> /home/ets/.var/app/org.gnucash.GnuCash/data/gnucash (saved reports
>>> 2.4).  They al show up and run fine, BUT as soon as I try to delete one
>>> of them, I get a CTD, a locked data file, and when I start the programk
>>> (open anyway) and reopen the reports menu, only 2 of the many reports I
>>> have saved show up.  Is ther a fundamental incompatability with the
>>> report?  I can get my reports back if I delete the file
>>> /home/ets/.var/app/org.gnucash.GnuCash/data/gnucash/saved-reports-2.8
>>> and they do run, but I cannot delete any of them, and trying to export
>>> their output results in the same crash.  Do I have to recreate ALL my
>>> reports in the new version of GC?
>>> ___
>>> 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.
>>>
>>
>
>


-- 
   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] flatpak 4.4 reports anomaly

[Derek Atkins]

Hi,

It is certainly true that 2.6 reports are not compatible with 4.4.  So
yes, I would expect saved reports to not have made the transition.

-derek

On Tue, February 9, 2021 3:58 pm, Elmar wrote:
> Running the flatpak 4.4 on Linux Mint 19.3 - I've copied my version
> 2.6.19 reports into the gnucash folder in
> /home/ets/.var/app/org.gnucash.GnuCash/data/gnucash (saved reports
> 2.4).  They al show up and run fine, BUT as soon as I try to delete one
> of them, I get a CTD, a locked data file, and when I start the programk
> (open anyway) and reopen the reports menu, only 2 of the many reports I
> have saved show up.  Is ther a fundamental incompatability with the
> report?  I can get my reports back if I delete the file
> /home/ets/.var/app/org.gnucash.GnuCash/data/gnucash/saved-reports-2.8
> and they do run, but I cannot delete any of them, and trying to export
> their output results in the same crash.  Do I have to recreate ALL my
> reports in the new version of GC?
> ___
> 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.
>


-- 
   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] Scheduled Transaction Mystery?

[Derek Atkins]

Do you have the SX set up to notify you on creation?  If not, it could
create without telling you.

-derek


On Thu, February 4, 2021 3:36 pm, Jack Slater wrote:
> Started it.
>
> Last Run Window did pop up and showed nothing. Closed it.
>
> No variables included.
>
> On Thu, Feb 4, 2021 at 2:11 PM John Ralls  wrote:
>
>> When you say you opened GnuCash, does that mean that you started it? Or
>> has it been running since before 2 February and you switched to its
>> window?
>>
>> If the former, when you started it for the first time did the Since Last
>> Run window come up, what did it say about that transaction, and what did
>> you do? Does the scheduled transaction have a variable that requires
>> user
>> input?
>>
>> Regards,
>> John Ralls
>>
>> > On Feb 4, 2021, at 10:48 AM, Jack Slater 
>> wrote:
>> >
>> > It should be listed in the register for sure regardless and I have not
>> > deleted it.  I simply opened GnuC and looked and its not there.
>> >
>> > On Thu, Feb 4, 2021 at 12:42 PM Jean Laroche  wrote:
>> >
>> >> I think if you set it up to create x days in advance, when the
>> >> transaction is created, the "last occurrence" is set to the day of
>> the
>> >> transaction (no to the day it was created). So that would explain why
>> >> you see "Last occurrence 2/5/21".
>> >>
>> >> Is it possible that you somehow deleted the occurrence that was
>> created?
>> >>
>> >> J.
>> >>
>> >> On 2/4/21 10:19 AM, Jack Slater wrote:
>> >>> Today is 2/4/21.
>> >>> Transaction scheduled for the 5th of every month.
>> >>> Looking at Scheduled Transactions, it reads Last Occurance 2/5/21.
>> >>> Transaction options are set to Create Automatically and Create 3
>> days
>> in
>> >>> advance.
>> >>> No transaction listed in register.
>> >>>
>> >>> Seems pretty illogical to me. What am I missing?
>> >>> ___
>> >>> 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.
>


-- 
   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] End of year, how to clone a set of accounts for the new year?

[Derek Atkins]

HI,

On Tue, February 2, 2021 12:07 pm, Chris Green wrote:
> On Tue, Feb 02, 2021 at 10:12:09AM -0500, Derek Atkins wrote:
>> Hi,
>>
>> On Tue, February 2, 2021 10:03 am, Chris Green wrote:
>> [snip]
>> > Yes, that works, thanks Derek.  I suppose it's not too onerous as I
>> > only do it once a year! :-)
>>
>> This begs the question:  Why are you doing this?  Why not just backup
>> the
>> data file, then run tools -> Close Books to zero out your income/expense
>> accounts, and then continue on with the same data file?  Why start over
>> from scratch?
>>
> Because having a separate xxx.gnucash file for each year fits much
> better with my way of working where I have a directory for each year
> and keep all the documents for one year in the same place.  Thus I
> have the general accounts, the building fund accounts, copies of
> GiftAid forms, invoices etc. all in one directory which is easily
> saved and transportable.

That kind of archiving makes sense, but I don't see why you need to
actually start over.  You could keep the existing data as you start the
new year.  I.e., you could do the equivalent of:

  copy datafile from 2020/foo.gnucash to 2021/foo.gnucash

Also keep in mind, GnuCash can also get confused if you have multiple
files of the same name in different directories.  So the above might cause
issues with metadata, because both would want to open "foo.gnucash.gcm".

> It also means I can use the same report format as I don't have to
> generate a report for each year, the report is always for 'everything
> in the accounts'.

I'm not sure what "same report format" means here.

>> GnuCash happily deals with multiple years of data; the reports happily
>> report for you.
>
> Only if you specify the date *every time* you generate the report,
> unless you copy them when you generate them.

The default settings work pretty well.  So really, you should rarely have
to change dates, except when there is something specific you want.  Those
reports currently default to the current accounting period, which can be
arbitrary or fixed.

For me, I have "Previous Year" Balance Sheet and Income Statement reports
that I leave open.

>
>>And if you separate it that way, it makes it very
>> hard to
>> go back and look at previous years' data.  It seems like a lot of work,
>
> No it isn't, it's trivial.  "cd ~/pcc/2019;gnucash general.gnucash"
>
> Going back to a previous year in the GUI feels more difficult to me! :-)

It's only difficult because of how you separate them.  For me, I can take
my (open) GnuCash and run a Balance Sheet report, go to the options, and
select 12/31/2009 and -- voila, I've got my EoY balance sheet from 2009. 
I can search for historical transactions as well.  Also, if I have rare
transactions, the auto-fill works great.  For example, I recently had a
shredding company come to take care of a bunch of boxes of papers.  The
last time I used them was 7 years ago.  But I was able to duplicate that
old transaction (and see that I paid the same amount!)  ...  All because
the data is all there together.

NB that while GnuCash does let you have multiple instances of the
application open at one time, they will contend for your Preferences, so
if you make preferences changes in one they may get overwritten by
another.

Anyways, do what works for you.  I'm just suggesting there might be better
ways, or at least ways that require less work.

> Chris Green

> 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] End of year, how to clone a set of accounts for the new year?

[Derek Atkins]

Hi,

On Tue, February 2, 2021 10:03 am, Chris Green wrote:
[snip]
> Yes, that works, thanks Derek.  I suppose it's not too onerous as I
> only do it once a year! :-)

This begs the question:  Why are you doing this?  Why not just backup the
data file, then run tools -> Close Books to zero out your income/expense
accounts, and then continue on with the same data file?  Why start over
from scratch?

GnuCash happily deals with multiple years of data; the reports happily
report for you.  And if you separate it that way, it makes it very hard to
go back and look at previous years' data.  It seems like a lot of work,
unless you have some external force requiring you to start over?

> 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] End of year, how to clone a set of accounts for the new year?

[Derek Atkins]

Try saving it as XML, and then opening it, and then Save-As Sqlite

-derek

On Tue, February 2, 2021 9:37 am, Chris Green wrote:
> On Wed, Jan 20, 2021 at 08:07:07AM -0500, D. wrote:
>> > Is there any easy way to create a set of empty copies of an existing
>> > set of accounts so I can start the new year easily?
>>
>> File -> Export -> Export Accounts
>>
> Well, I have been trying to do this but it doesn't work.
>
> I am using gnucash with sqlite on Linux.
>
> The first problem is that one *always* gets the file lock issue if you
> do this because the new database created by the export always has the
> lock table in it.  This isn't a big issue of course because you can
> ignore the message or remove the lock table.
>
> However the saved accounts database is somehow broken.
>
> I have done the following:-
>
> Start gnucash with "gnucash general.gnucash"
>
> Select File->Export->Export Accounts
>
> Set the data format to sqlite3
>
> Save as 'newyear'
>
> Quit from gnucash
>
> Run "gnucash newyear.gnucash"
>
> Click "Start anyway" when the lock file message pops up
>
> I then get a pop-up window saying "An error occurred while
> processing /home/chris/pcc/2020/newyear.gnucash"
>
>
> So how do I get this to work?
>
> --
> Chris Green
> ___
> 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.
>


-- 
   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] find and replace

[Derek Atkins]

Hi,

On Sat, January 30, 2021 2:13 pm, gnu Gord wrote:
> Is it possible to find a specific split transaction based on the memo
> field
> and assign the account to transfer for that split item?

No, there is no way to en-masse manipulate multiple transactions.  The
ONLY en-masse thing you can do is reassign all transaction from one
account to another account.  For example, you could move ALL transactions
from "Imbalance-USD" into, e.g. Expenses:Groceries, by deleting the
Imbalance-USD account and telling GnuCash to target.  But if you're
looking to reassign a subset of transactions, then no, there is no way to
do that.

> Let me explain. I'm new to GnuCash and have just imported my Quicken data
> QIF file but it appears that some transactions within splits have no
> transfer account assigned. It appears that I did not have a category
> assigned to them in Quicken. However, most seem to have the same memo
> text.
> There are really too many to do manually so some sort of find/replace
> would
> be helpful. If it's not possible within GnuCash, can the XML file be
> edited
> directly?

Sounds like you might be better off starting over and re-importing the
QIF.  Fix the QIF file to assign a proper account target (or better yet,
map the Memo to the correct account during the QIF import).

> 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] List of invoices

[Derek Atkins]

How about a transaction report of your A/R account?
Filter by dates; Sort by amount?
That will give you the invoice numbers -- then you can open and print
those invoices.

-derek

On Sat, January 30, 2021 10:50 am, R. Victor Klassen wrote:
> Our taxing authority is doing something more than a rubber stamp and less
> than a full audit of our HST (a.k.a VAT) for the last year.  Among other
> things they are requesting our 10 largest invoices to different customers.
> Most of what we sell is zero-rated, meaning that there is no tax (food).
> But we do sell some other things as well, for which we charge tax.  I can
> look at a transaction report to easily find the 10 largest instances of
> charging tax, but they seem to want the 10 largest invoices (independent
> of tax).
>
> Is there a way of listing invoices within a time period, without
> restricting it by customer and showing the invoice amount?   It’s
> certainly not in a report I commonly use.
> ___
> 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.
>


-- 
   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] Rate column

[Derek Atkins]

It is a "hidden" column for computing exchange rates.
You can re-hide it by returning it to 1 pixel wide.

-derek

On Fri, January 29, 2021 10:54 am, Rare Bear wrote:
> I've noticed a "Rate" appearing on several of my credit card accounts to
> the right of "Balance".  All of the entries are "1.000" and it doesn't
> seem
> to affect any of the functionality other than the fact that it takes up
> screen space.
>
> Does anyone know what it is for?
>
> Thanks
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
   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] Help adding withholding tax and VAT in seperate fileds of the invoice.

[Derek Atkins]

Hi,

On Wed, January 27, 2021 8:49 am, Nikos Parafestas wrote:
> Beacuse of the taxation sytem in my country I need to add withholding
> tax and VAT in seperate fields in the invoice. This applies to every
> tansaction with a net price of 300 euro or more.

The first thing to note is that GnuCash only allows you to apply a single
Tax Table per invoice line-item, but each line item can have its own
unique tax-table.  You can (I believe) supply a "default tax table" which
gets applied.  There is no way to set a floor, meaning that you will need
to manually determine if/when the tax(es) apply.

> For example if the Net Price is 1000 euro the invoice should include
> the following:
> ---
> 1. Net Price = 1000 euro
> 2. VAT = 240 euro
> 3. Total Price 1240 euro
> 4. Withholding Tax (which is 20% of the Net Price. This amount the
> client pays directly to the goverment not to me) = 200 euro
> 5. Payable (Total - Witholding Tax) = 1040 euro
> 
>
> 1-3  : I have managed to add them correctly
> 4 & 5: I don't have a clue how to add them.

The best way to think about your particular case is with some algebra, and
you'll need to help me a bit to fill that in.

GnuCash has two ways to compute taxes:  either they are included in the
price, or they are added to the price.

If tax is included, then the line-item price is what the user pays, and
the tax is computed in such a way that value+tax = price.  In other words,
if the price is $100 and 5% tax is included, then the customer pays you
$100, of which $4.76 is tax (because 5% of $95.24 is 4.76, and 95.24 +
4.76 == 100).

If the tax is added on, then the line-item price is the basis for the tax,
and the user pays the price+tax total.  In other words, if the price is
$100 and there is 5% tax, the user pays $105.

Now, back to the GnuCash tax tables.  You can include multiple taxes in a
tax table, but the two are independent.  So let's say you have a 5% state
tax and a 2% city tax, where the user pays a total of 7%.  This is easy,
you have two entries in the tax table, one for 5% and one for 2%.

However, there are places (e.g. Canada), where one tax includes the other.
 For example, you might have a 10% GST and a 7% PST, where the PST
*includes* the GST.  In this case, you would put the 10% GST in one tax
table line, but for PST you cannot say 7%, because the 7% includes the
10%.  This is where the algebra comes in.  To compute the PST, you're want
to compute x% where:

x% of price = 7% of (price + 10% of price)
  x * price = .07 * (1 + 0.1) price
  x = .07 * (1 + 0.1)
= .077
= 7.7%

So you would enter GST of 10% and PST of 7.7% to get the correct taxes
computed.

Now, back to YOUR case.  It sounds like you have:
  price = 1000
  VAT = 24% of the price
  Withholding = is 20% of price
  Invoice amount is price + VAT - Withholding

So really, the invoice amount is price + 4%.

It sounds like you need to actually show VAT and Withholding amounts on
the invoice.  Do you need to actually RECORD the VAT + Withholding
amounts, or just display them on the invoice?  What if the customer does
not actually pay the withholding to the government?  Are you still on the
hook for it?

I am asking because the answer to these questions will tell us if we need
to handle it within the tax table system, or by the invoice report.

If you are only on the hook for 4%, regardless of whether they pay or not,
then you should probably just record the 4% and update the invoice to
report the 24% and 20% values.  However if you need to actually record
that, we might have a SMALL problem, because I am not sure that GnuCash
supports a "negative" rate, which is what you would need for the
withholding.

> I hope I made it clear.

Ditto..

> ps. If you want to help I would like to ask you to provide your answers
> in a way that a novice user like me can understand.

I hope what I've written above helps you -- but you'll still need to fill
in the blanks.

> 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] Updates on Windows

[Derek Atkins]

David,

On Thu, January 21, 2021 9:09 am, David T. wrote:
> Derek,
>
> Thanks for the quick reply. Not being a Linux user (much), I immediately
> wonder whether the Linux removal and reinstallation process removes
> existing menu shortcuts that a user may have implemented, such as
> placing an icon on the OS menu bar. Do you know?

It shouldn't remove those bindings, as the bindings are stored in the
user-data area and not in the program-data area.

> David

-derek

>   On 1/21/2021 8:58 AM, Derek Atkins wrote:
>> David,
>>
>> I will just suggest that it is Mac tht is the oddity here.
>> Linux packages also remove older versions when upgrading.
>>
>> -derek
>>
>> On Thu, January 21, 2021 8:53 am, David T. via gnucash-user wrote:
>>> Hello,
>>>
>>> I've used GnuCash for a very long time, under different operating
>>> systems (currently GC4.4 on WIndows 10), and I have a minor question
>>> about the upgrade process under Windows.
>>>
>>> When I updated under MacOS, I was able to install multiple versions in
>>> parallel simply by renaming the app bundle in Applications (for
>>> example,
>>> from Gnucash.app to Gnucash-3.11.app). It was then possible to run
>>> either version, if needed. Under Windows, however, the installation
>>> process begins by removing the earlier version from the system.
>>>
>>> Setting aside the wisdom or folly aspect of having or running multiple
>>> versions of GnuCash, I am curious why it is that the Windows installer
>>> always removes the previous version before installing the next. While
>>> this is a minor point, it *does* have an effect in my daily usage. I
>>> pin
>>> the Gnucash icon to the taskbar, to make it easy to find and run
>>> (Aside:
>>> one of the things I like least about Windows 10 is its management of
>>> the
>>> Apps menu). When the new version gets installed, this is not preserved,
>>> and I have to re-pin the icon after every update. As I've already
>>> noted,
>>> this is a minor point, but it's the kind of oddity that sticks in my
>>> brain.
>>>
>>> Could someone explain this oddity to me?
>>>
>>> TIA,
>>>
>>> David
>>>
>>> ___
>>> 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.
>>>
>>
>


-- 
   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] Updates on Windows

[Derek Atkins]

David,

I will just suggest that it is Mac tht is the oddity here.
Linux packages also remove older versions when upgrading.

-derek

On Thu, January 21, 2021 8:53 am, David T. via gnucash-user wrote:
> Hello,
>
> I've used GnuCash for a very long time, under different operating
> systems (currently GC4.4 on WIndows 10), and I have a minor question
> about the upgrade process under Windows.
>
> When I updated under MacOS, I was able to install multiple versions in
> parallel simply by renaming the app bundle in Applications (for example,
> from Gnucash.app to Gnucash-3.11.app). It was then possible to run
> either version, if needed. Under Windows, however, the installation
> process begins by removing the earlier version from the system.
>
> Setting aside the wisdom or folly aspect of having or running multiple
> versions of GnuCash, I am curious why it is that the Windows installer
> always removes the previous version before installing the next. While
> this is a minor point, it *does* have an effect in my daily usage. I pin
> the Gnucash icon to the taskbar, to make it easy to find and run (Aside:
> one of the things I like least about Windows 10 is its management of the
> Apps menu). When the new version gets installed, this is not preserved,
> and I have to re-pin the icon after every update. As I've already noted,
> this is a minor point, but it's the kind of oddity that sticks in my
> brain.
>
> Could someone explain this oddity to me?
>
> TIA,
>
> David
>
> ___
> 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.
>


-- 
   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] Where does Gnucash remember what it did last - I want it to forget!

[Derek Atkins]

HI,

GnuCash will always re-open the last file you used.

If you don't want that, then supply the --nofile option.

-derek

On Wed, January 20, 2021 12:02 pm, Chris Green wrote:
> When I open gnucash *anywhere* (as in anywhere in the directory
> hierarchy) it *still* insists on opening the last accounts I used. I
> don't want it to second guess me like this, I want an 'empty' GnuCash
> unless I tell it which accounts to open.
>
> I've removed ~/.local/share/gnucash and I have removed
> ~/.cache/gnucash but still it insists on opening the same accounts
> file.
>
> It is saved *somewhere* in my home directory because if I start
> gnucash as another user I get an 'empty' startup.
>
> --
> Chris Green
> ___
> 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.
>


-- 
   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] Where does gnucash put the lock file on Linux?

[Derek Atkins]

Hi,

On Wed, January 20, 2021 8:33 am, Chris Green wrote:
> On Wed, Jan 20, 2021 at 08:23:23AM -0500, Derek Atkins wrote:
>> Hi,
>>
>> The lock file is created in the same directory as the data file.
>> Is that directory not writeable?  That would cause the error.
>
> The directory is definitely writeable and there definitely isn't any
> sort of lock file in the directory:-
>
> chris$ cd tmp/pcc/2020
> /home/chris/tmp/pcc/2020
> chris$ ls
> building.gnucash  building.gnucash.20210120121447.log  general.gnucash
> chris$ ls -al
> total 504
> drwxrwxr-x 2 chris chris   4096 Jan 20 12:14 .
> drwxrwxr-x 3 chris chris   4096 Jan 20 12:13 ..
> -rw-r--r-- 1 chris chris 212992 Jan 20 12:14 building.gnucash
> -rw-rw-r-- 1 chris chris381 Jan 20 12:14
> building.gnucash.20210120121447.log
> -rw-r--r-- 1 chris chris 290816 Jan 20 12:14 general.gnucash
> chris$ gnucash general.gnucash
> Found Finance::Quote version 1.49.
> chris$
>
> The above sequence pops up the can't create lock file error.

The "cannot obtain lock" error has multiple causes.  Have you checked the
Tracefile to see if there is anything printed that might suggest which
error is happening?

The error occurs when:
1) There is a lock file already there, or
2) There is NOT a lock file already present, but gnucash cannot create a
new lock file

If you're in case #2, then you won't see a lock file listed.

Is your disk full?  What do you get from:
  df /home/chris/tmp/pcc/2020
  df -i /home/chris/tmp/pcc/2020/

Also, what kind of filesystem underlies /home/chris/tmp/pcc/2020 ?

>> If GnuCash cannot create (and lock) the lock file then it will throw the
>> error.
>> If you are SURE that there is not another process running, you can "Open
>> Anyways" and that will clear the error.
>>
> Yes, I realise that, but it's not "right". :-)

It depends on the underlying error.  If the lock file is actually there
but, say, gnucash crashed, then "Open Anyways" *is* the right solution.
Obviously that's not the case here.

>> NB that gnucash may mix the metadata for two versions of the same-named
>> file located in different directories.  The GCM file does not contain
>> the
>> file location information.
>>
> I'm not quite sure I follow that, I do have general.gnucash in two
> different places.  Are you saying that this may cause problems and
> that I should rename my 'previous year' accounts to (for example)
> general2020.gnucash as well as moving them to a suitably named
> sub-directory?

If you open a file foo.gnucash, gnucash creatres a metadata file
foo.gnucash.gcm in $HOME/.local/share/gnucash/books.  Now, if you copy
foo.gnucash from DIR1/foo.gnucash to DIR2/foo.gnucash, when you open
DIR2/foo.gnucash it will use the same foo.gnucash.gcm file, because DIR1
vs DIR2 is not encoded anywhere.

So yes, IF you decide to archive data files, you should change the name.

NB: there is no need to start over every year; GnuCash hapily accounts for
multiple years of data and reports know how to handle that.

> 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] Where does gnucash put the lock file on Linux?

[Derek Atkins]

Hi,

The lock file is created in the same directory as the data file.
Is that directory not writeable?  That would cause the error.
If GnuCash cannot create (and lock) the lock file then it will throw the
error.
If you are SURE that there is not another process running, you can "Open
Anyways" and that will clear the error.

NB that gnucash may mix the metadata for two versions of the same-named
file located in different directories.  The GCM file does not contain the
file location information.

-derek

On Wed, January 20, 2021 7:35 am, Chris Green wrote:
> I seem to have an odd error with GnuCash saying another copy is
> running but only when the xxx.gnucash file is in a certain location.
>
> I needed to move my gnucash database, called general.gnucash to a new
> location as it's end of year.
>
> After copying it I can still open it in its original location but
> running 'gnucash general.gnucash' in the new location brings up the
> error box about another copy running.  There *isn't* another copy
> running, I've closed it down properly (and I've also tried restarting
> the system).
>
> So why can't GnuCash start with the file in the new location?
>
> --
> Chris Green
> ___
> 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.
>


-- 
   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] Login error

[Derek Atkins]

Hi,

On Fri, January 15, 2021 3:28 pm, d16...@gmail.com wrote:
> I am trying to login but I keep getting
>
> gnucash-user roster authentication failed.

Where are you trying to login?

> I am sure that I am using the correct password
>
>
>
> Peter

> 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] UK specific: MTD - Making Tax Digital

[Derek Atkins]

Chris,

As someone sitting across the pond from you... I think there is definitely
interest in MTD in GnuCash.  The issue, I think, is going to be the GPL
nature of anything you would contribute to GnuCash, and the challenge of
obtaining the API key for said GPLed code.  Having said that, I suspect
the developers would welcome a PR that includes this functionality.

-derek

On Thu, January 14, 2021 10:42 am, chr...@floatdene.com wrote:
> Hi Mark,
>
> This is a bit of Java code that takes a csv input and then submits to HMRC
> and has been approved for production for over a year. I have been
> impressed
> with GnuCash and surprised that it does not have a MTD VAT submission
> option. It will require a bit of work to integrate with GnuCash and I am
> reluctant to do this if there is very limited interest!
>
> Thanks to all who have responded so far. Let's leave it out there for a
> couple of weeks and see if there is any more interest.
>
> Thanks,
> Chris
>
>
>
> --
> 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.
>


-- 
   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] Accounts receivable - BUG or misunderstanding?

[Derek Atkins]

HI,

On Tue, January 12, 2021 10:58 am, G Simba wrote:
> [cid:image003.png@01D6E93E.DC70EA40]
>
> I create two sub-accounts receivable, one use $B!o(B and another use
> HK$, as the figure shows.

The figure shows your hierarchy.  You have a top-level Receivables account
(what account type?  What currency) with two subaccounts, A and B (what
account types / currencies for A & B)?

> $B!o(B95.29 in total is $B!o(B95.29, but  HK$120 goes to negative
> $B!o(B-97.49
> My currency rate is positive, so it is weird and the total number may be
> incorrect.

Your diagram is not showing this, so I am not sure I understand where you
are seeing these positive/negative numbers and/or the currency
conversions?

> Could you help me about it?

I am afraid we will need more information about what you are seeing, and
what transactions are posted to which accounts in order to help you figure
out what is going on.

> Thanks for reading.
>
> Best Regards,
> GUAN Xihao.

> 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] [GNC-dev] [MAINT] Short network upgrade this weekend

[Derek Atkins]

Hi,

The router upgrade is complete.

Please let me know if you notice any network issues to code or any of its
services.

-derek


On Fri, January 8, 2021 12:13 pm, Derek Atkins wrote:
> Hi,
>
> I plan to update the software on my main router over the weekend.
> Exact time still TBD, but if all goes well you will barely see a blip.
> If it does NOT go well, then it's possible there might be some extended
> downtime to code.gnucash.org.
>
> Based on my research there has been a lot of positive experiences
> upgrading to this new software version.  I'm upgrading because I hit a
> feature limitation in the firmware it was running (from June 2019) which
> was (finally!) fixed in this new release.
>
> I'll announce on IRC before I refresh, and email when it's complete.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


-- 
   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] How to stop shortcuts from appearing on the home screen after every every transaction is entered?

[Derek Atkins]

Stan,

On Fri, January 8, 2021 1:26 pm, Stan Brown wrote:
>
> (In my opinion, it's unfortunate that GnuCash writes temporary files to
> the data directory rather than %TEMP% or the equivalent, because it
> leads to the problem the OP is asking for help. I know we had a
> discussion a few months ago about this very common problem. There was
> talk of adding an option, or an environment variable, to specify where
> backup files should be stored, but I don't know if that suggestion has
> been implemented, or will be.)

I would argue that Log and Backup files are not temporary and should
definitely not be treated as such.

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

[GNC] [MAINT] Short network upgrade this weekend

[Derek Atkins]

Hi,

I plan to update the software on my main router over the weekend.
Exact time still TBD, but if all goes well you will barely see a blip.
If it does NOT go well, then it's possible there might be some extended
downtime to code.gnucash.org.

Based on my research there has been a lot of positive experiences
upgrading to this new software version.  I'm upgrading because I hit a
feature limitation in the firmware it was running (from June 2019) which
was (finally!) fixed in this new release.

I'll announce on IRC before I refresh, and email when it's complete.

-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] How to stop shortcuts from appearing on the home screen after every every transaction is entered?

[Derek Atkins]

Hi,

On Fri, January 8, 2021 10:50 am, Jesse VonStein wrote:
> Very technology challenged user.

GnuCash creates a log file and backup data files as you enter and save
your data.  This is to prevent data loss, so is a good thing.
By default, GnuCash stores those logs and backup files in the same
directory as your main data file.  So, if your main data file is on the
desktop, then all the backup and log files will also be saved on the
desktop.
The BEST way around this is to move your data file off the desktop and
into it's own directory (folder).  You can do this file File -> Save As
and then selecting the target folder.  GnuCash will then remember this new
location, and will re-open your data file the next time you start it
(unless you start it by double-clicking on a data file).
Hope this helps!

> 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] Account Receivable account not working

[Derek Atkins]

Hi Bill,

Please verify two things:
1) You have an account of type A/Receivable, and
2) That A/R account has the same currency as your Customer

-derek

On Wed, January 6, 2021 7:20 am, Bill Turner wrote:
> I have just started using GnuCash and have set up opening balances and I
> then tried to create an invoice but I cannot get it to post because the
> "post to account" field in the "question" dialog is not responsive.
> I think I have the accounts receivable account set up correctly but it
> will
> not show in the drop down of the "post to account" field.
> This seems to be such a basic function so I'm wondering what I'm missing
> to
> make it work.
>
>
> Bill Turner
>
> 51/44 Zealey Rd Nambour QLD, 4560
>
> MOB: 0412 168 989
> billturner1945...@gmail.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.
>


-- 
   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] Support message:// for transaction associations

[Derek Atkins]

Hi.
First, the more cross-platform uri would be mailto:
Second, the issue is that gnucash catches all uris internally so there are 
no external bindings.


-derek
Sent using my mobile device. Please excuse any typos.
On January 2, 2021 9:42:48 AM Ira Fuchs  wrote:

I am running Gnucash for under MacOS mojave. On MacOS it is possible to get 
a URL that takes you to a mail message(in mail.app). The URL is of the form 
 
. If I 
enter this URL as the location for an association and then try to go to it 
in gnucash, I get the error message that the file cannot be found. (If the 
URL is pasted into Safari, it opens the email message directly). It would 
be very helpful if Gnucash associations could point to email invoices directly.

___
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] [MAINT] turned on IPv6 support

[Derek Atkins]

Hi,

I just turned on IPv6 support for code.gnucash.org.
Please let me know if you find any issues with the services (email, git,
wiki, archives).
Thanks,

-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] Sales tax changes and posting an invoice wrong tax amounts

[Derek Atkins]

Hi,
This is not true.
Gnucash absolutely allows you to change the tax rates without affecting 
posted invoices.  When you post an invoice gnucash makes a read-only copy 
of the tax tables associated.  When you change it, it doesn't change the copy.


If you unpost an invoice it will ask you whether to keep the copied tax 
tables or revert to the current ones.  This let's you choose.


Happy Gnucashing!

-derek
Sent using my mobile device. Please excuse any typos.
On December 17, 2020 1:15:46 AM Adrien Monteleone 
 wrote:



You can't change a rule. This would mess with any other invoices that
use(d) it. (the tax calcs are done on-the-fly, so if the rate changed,
those invoices would be wrong if you tried to view them, edit them, etc.)

Therefore, if the rate changes, you have to create a new rule.

Regards,
Adrien

On 12/16/20 6:15 PM, christ...@eliminator-rc.com wrote:

We have a problem we ran into using Gnucash. We originally setup our tax
tables for Canada to reflect 8% PST and 5% GST. We then changed the PST to
7% back in 2019. We have an invoice where it posts the right amount to all
the accounts so the accounting side is correct. But when we post the invoice
the tax amount changes in front of our eyes to an incorrect amount. It seems
like it is still using 8% PST. Again it only happens on the printable
invoice and in the invoice details. The accounts and reports all look
correct. We got around the problem by creating a new Sales Tax Rule and
setting it directly to 7% and 5%. Now when we use the new rule and post an
invoice it uses the right amounts. Is this a common problem or is this a bug
in Gnucash?


___
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] Invoice payment

[Derek Atkins]

HI,

On Wed, December 16, 2020 6:21 pm, Garry Cooke wrote:
> Hi, Customer has 3 invoices. Pays with 2 deposits into bank. On the
> imported bank transactions i select ‘process payment’. Select invoice,
> expecting amount to be applied to invoice and balance to applied to next
> invoice. Instead i get a credit to the customer.

Correct.  By only selecting one invoice you told it to apply the payment
only to that one invoice.  Had you selected #1 AND #2 it would have split
the payment between them (filling #1 and then applying the remainder to
#2).

>   2nd payment i leave
> invoice blank and get same result.

What do you mean by "same result"?   It didn't apply the 2nd payment to
any invoices?

>I end up with 3 unpaid invoices and
> 2credits against customer.

Wait..  Why did the first invoice not get paid?

>   I attempted to resolve by selecting invoice and
> using to credit to pay, which worked. But when i print customer report to
> use as statement it has 3 transactions included with $0. What am i
> missing? Why were the amounts not applied to the invoices when applied
> from incoming bank transaction?

Try selecting the appropriate invoices when you apply the payment.

> 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] Saving to MySQL

[Derek Atkins]

Hi,

On Thu, December 10, 2020 9:27 am, Ira Fuchs wrote:
> (Found mysql in /usr/local/mysql/bin)
> I can get to the mysql prompt but how to get Gnucash to be able to save?
>

Is the server running?
Can you actually get to the server via the command-line?
What do you get from "show databases;" from the command-line prompt?

IF you can connect and "show databases" works, then you just need to give
GnuCash the same connection information.   Oh, and you need to have all
permissions to create the gnucash database.

> 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] How to use Reminders?

[Derek Atkins]

Hi,

Before I respond inline below, I just want to point out that GnuCash is
not a calendaring system.  If you want to remember things like your Boss'
birthday or Valentine's day, there are much better tools (like your
calendar!) to do that.  So use those tools for those kinds of reminders.

Having said that

On Wed, December 9, 2020 1:10 pm, Fran_3 via gnucash-user wrote:
> Problem with "Bills Due" reminder popup is if you have forgotten to Post
> the bill you don't get reminded.

Why do you not post the bill as soon as you get it?  I mean, if you take
the time to enter in your bill into the system, why not post it
immediately?  It's not like the bill is going to change over time, or be
ammended.  So in the immortal words of "Doctor, it hurts when I do
this"...  "Don't Do That."

Post your bill when you enter it.  That's what the reminders are for, to
pay the bill that you entered AND POSTED.

>  Problem with missing your boss's birthday
> is you forgot what date it was.

This is not a GnuCash problem; use your calendar for that.  There are many
options, like Orange and Evolution, which will do a MUCH better job.

> So, how do you create a general purpose Reminders for various things in
> GnuCash like..- Post Electric Bill Today (this reminds you to go find the
> bill online or in the mail or wherever & post it)
> - Boss's birthday is on April 1st- Valentines Day coming up on February
> 14th- Leave check under door mat for yard guy

None of these reminders belong in GnuCash.

> I see the calendar view via clicking... Actions > Schedule > Edit
> Scheduled Transactions
> And the tabs & fields when I click "New"
> And most of the fields are obvious except under Template Transaction...
> I'm clueless about what I'm looking at...Is tat a template for...- a new
> bill to be posted- a reminder to pay a bill- or what?

The Template Transaction is the transaction you have scheduled.  The
template will be executed and posted into your accounts when the SX fires.
 The template can be anything (well, any transaction -- you cannot
schedule a Business feature object like Invoice or Bill).  I, personally,
use them to schedule Loan (and Mortgage) payments, because it can
approximate interest calculations.

> And, what about a reminder that is not a financial transaction?
> Questions:
> 1 - Is there a way to create General Purpose Reminders in GnuCash?

No.

> 2 - Where can I find instructions on how to navigate to General Purpose
> Reminders?

Read up on Evolution (the program, not the Theory of).

> 3 - Is there a document that explains the use of the various fields in
> either...
> a. the General Purpose Reminder or in
>
> b. Scheduled Transactions Reminders?

There should be documentation the SX Editor, yes.  Check the Help file.

Oh, one more thing -- keep in mind that you can post-date a transaction. 
For example, I tell my bank to go pay my credit card $1234 on the 17th. 
Even though today is the 9th, I can enter a transaction dated the 17th
from Bank -> CC for $1234, so GnuCash records that I set the bank billpay
up to do that for me.

Hope this helps,

> Thanks for any help.

> 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] Possible Suggestion: Give transactions a default 'Jump to' target account

[Derek Atkins]

David,

On Tue, December 8, 2020 3:59 pm, David H wrote:
> Being primarily a keyboard user I would find a keyboard shortcut for the
> Split action to be of more use as I use it quite often as I prefer to work
> in basic txn view.

You could add a keyboard accelerator for Actions -> Split Transaction

> 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] Possible Jump Enhancement

[Derek Atkins]

Just a devil's advocate question, but how is hitting the Jump button to
get a popup to see the splits any different than hitting the Split button
to get the register to expand the transaction to see the splits?

It's still two mouse-clicks to get to the target account, but without a
popup.

-derek


On Tue, December 8, 2020 12:25 pm, Edith Murphy wrote:
> Hi David,
>
> I would find that helpful as it would allow the quick jump for a split
> transaction when looking at the basic ledger.  Also a way to see which
> accounts are involved in a split transaction without having to click
> split.  I often want a quick look at info from the auto-split ledger
> without having to switch to it.
>
> Thank you and all the people who work on this program.  I appreciate what
> you do.
>
> Edith
>
>
> ed...@mossbrookfiberarts.com
> Yarn and Soul
>
> Class Schedule: mossbrookfiberarts.com/classes
>
>
>
>
>
>> On Dec 8, 2020, at 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
>>
>> Send gnucash-user mailing list submissions to
>>  gnucash-user@gnucash.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>  https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>>  gnucash-user-requ...@gnucash.org
>>
>> You can reach the person managing the list at
>>  gnucash-user-ow...@gnucash.org
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>>
>>
>> Today's Topics:
>>
>>   1.  Possible Suggestion: Give transactions a default 'Jump to'
>>  target account (David Carlson)
>>   2.  Fwd: Re: Possible Suggestion: Give transactions a default
>>  'Jump to' target account (Stan Brown)
>>
>>
>> --
>>
>> Message: 1
>> Date: Tue, 8 Dec 2020 10:18:28 -0600
>> From: David Carlson 
>> To: Gnucash Users 
>> Subject: [GNC] Possible Suggestion: Give transactions a default 'Jump
>>  to' target account
>> Message-ID:
>>  
>> Content-Type: text/plain; charset="UTF-8"
>>
>> I am considering proposing an enhancement to GnuCash to provide a
>> default
>> 'Jump to' target action. If there are only two split lines in the
>> transaction, it would be the transfer account.  In complex transactions
>> there would be a pop-up giving a list of the accounts in the transaction
>> and asking which account to 'Jump to'.  This action would be overridden
>> by
>> the current 'Jump to' destination when the focus is in a split line.
>>
>> The primary purpose of this proposal would be to define a 'Jump to'
>> destination that is invocable from the base fields of the transaction
>> which
>> are often the only fields visible when the account register display is
>> set
>> to 'Basic Ledger'.
>>
>> Before I make the proposal, I would like comments on whether this is
>> worth
>> pursuing.
>>
>> --
>> David Carlson
>>
>>
>> --
>>
>> Message: 2
>> Date: Tue, 8 Dec 2020 08:36:35 -0800
>> From: Stan Brown 
>> To: GnuCash User List 
>> Subject: [GNC] Fwd: Re: Possible Suggestion: Give transactions a
>>  default 'Jump to' target account
>> Message-ID: <40380037-868b-e813-2f7f-210b51592...@fastmail.fm>
>> Content-Type: text/plain; charset=utf-8
>>
>> Apologies -- I clicked "reply" instead of "reply List".
>>
>>
>>
>> Since you asked for opinions --
>>
>> Speaking for myself only, I just click Split in the top row of icons,
>> then click on the account I want in the expanded transaction and Jump. I
>> don't think the pop-up would help me in my workflow.
>>
>> --
>> Stan Brown
>> Tehachapi, CA, USA
>> https://BrownMath.com
>> https://OakRoadSystems.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.
>


-- 
   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] [GNC-dev] [MAINT] Planned server reboot Monday, Dec 7, 8:00pm US/EST

[Derek Atkins]

Reboot finished and everything should be back to normal.
Please let me know if you notice any issues.
Thanks!

-derek


On Sun, December 6, 2020 9:15 pm, Derek Atkins wrote:
> TL;DR: Unless I hear major objections, I plan to reboot the VM server
> tomorrow, Monday, Dec 7, around 8pm US/EST (0100 UTC Dec 8), in order to
> refresh / update some certificates.  Please let me know if this is an
> issue.
>
> Long Version:
>
> The GnuCash infrastructure uses a single-host OVirt VM platform for its
> production system.  Unfortunately, this means that certain system
> maintenance efforts require system reboots, and, unfortunately, replacing
> the certificates is one of those.  All the new certificates are in place
> so I should just need to reboot the system to allow it to take effect.
>
> The reason for the certificate update is two-fold:
>
> 1) Many of the certificates were set to expire next year (2021), so they
> would have to be renewed anyway.  Granted, this date was November 1, so I
> had most of the year to do it, but still, it had to be done within the
> next 11 months.
>
> 2) More importantly, the certificates were all using SHA1, and this was
> causing problems with e.g. remote-viewer complaining that the certificates
> were not secure.  This is JohnR and, after I update my own system this
> weekend, me.
>
> If I had a multi-server Ovirt setup (e.g. 3 hosts), then I could
> round-robin update them.  I migrate all the running VMs to the other two
> hosts and then I can safely take the third host down and do whatever I
> needed.  Then I bring it up again, let everything stabilize, and then move
> to the next one.  Alas, with a single host, I can't do this so I need to
> reboot.
>
> total downtime should be no more than 30 minutes, assuming of course I got
> everything right.  Also, I am *hoping* this will fix the remote-viewer
> issue, but I won't know for sure until after I reboot.
>
> If you all have any questions, concerns, or the timing is bad, please let
> me know.
>
> Thanks!
>
> -derek
>
> PS: For John, Frank, Geert, etc -- due to the certificate changes you will
> need to remove the old certificates from your browser trusted-cert cache
> first and then import the new ones.  Search for IHTFP.  If you don't
> remove it, it'll give you an error that the certificate changed but has
> the same Issuer/Serial#.  I'm sorry, but there's nothing I can do about
> that.
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


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

[GNC] [MAINT] Planned server reboot Monday, Dec 7, 8:00pm US/EST

[Derek Atkins]

TL;DR: Unless I hear major objections, I plan to reboot the VM server
tomorrow, Monday, Dec 7, around 8pm US/EST (0100 UTC Dec 8), in order to
refresh / update some certificates.  Please let me know if this is an
issue.

Long Version:

The GnuCash infrastructure uses a single-host OVirt VM platform for its
production system.  Unfortunately, this means that certain system
maintenance efforts require system reboots, and, unfortunately, replacing
the certificates is one of those.  All the new certificates are in place
so I should just need to reboot the system to allow it to take effect.

The reason for the certificate update is two-fold:

1) Many of the certificates were set to expire next year (2021), so they
would have to be renewed anyway.  Granted, this date was November 1, so I
had most of the year to do it, but still, it had to be done within the
next 11 months.

2) More importantly, the certificates were all using SHA1, and this was
causing problems with e.g. remote-viewer complaining that the certificates
were not secure.  This is JohnR and, after I update my own system this
weekend, me.

If I had a multi-server Ovirt setup (e.g. 3 hosts), then I could
round-robin update them.  I migrate all the running VMs to the other two
hosts and then I can safely take the third host down and do whatever I
needed.  Then I bring it up again, let everything stabilize, and then move
to the next one.  Alas, with a single host, I can't do this so I need to
reboot.

total downtime should be no more than 30 minutes, assuming of course I got
everything right.  Also, I am *hoping* this will fix the remote-viewer
issue, but I won't know for sure until after I reboot.

If you all have any questions, concerns, or the timing is bad, please let
me know.

Thanks!

-derek

PS: For John, Frank, Geert, etc -- due to the certificate changes you will
need to remove the old certificates from your browser trusted-cert cache
first and then import the new ones.  Search for IHTFP.  If you don't
remove it, it'll give you an error that the certificate changed but has
the same Issuer/Serial#.  I'm sorry, but there's nothing I can do about
that.

-- 
   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] Fwd: Need help using Gnucash IRC to live chat

[Derek Atkins]

HI,

On Sat, December 5, 2020 6:51 pm, Fran_3 via gnucash-user wrote:
>  1 - How do you browse there in Firefox? Does it have a built in IRC
> client?2 - I've installed HexChat and got on the FreeNode server but no
> gnucash channel there...
> When I attempt to join #gnucash I get this prompt...
> "The #gnucash irc channel is #gnucash on irc.gnome.org... please join us
> all there!"

this implies you joined a different IRC network -- probably freenode.
You need to join GIMPnet.

> 3 - Problem is I don't know how to navigate to irc.gnome.org... is that
> the name of an IRC chat server?

Yes.  AKA GIMPnet

> 4 - On mIRC they list "servers" and each server has channels...
> But on HexChat they list "Networks" which I assume is the same as
> "servers" in mIRC... right?

Generally, yes.

> I'll be darn'd if I know why I'm having such a hard time with this... but
> thanks for any help :-)

I used HexChat, and it says "GIMPnet / #gnucash"

-derek

>
> On Saturday, December 5, 2020, 1:34:01 PM EST, David Carlson
>  wrote:
>
>   Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> -- Forwarded message -
> From: Fred 
> Date: Sat, Dec 5, 2020 at 11:48 AM
> Subject: Re: [GNC] Need help using Gnucash IRC to live chat
> To: David Carlson 
>
>
> I rarely do IRC, but when I do I just browse there in Firefox, which seems
> to give me a reasonable view into the channel.
>
> On Sat, Dec 5, 2020 at 12:06 PM David Carlson
> 
> wrote:
>
>> Derek is right.  Wiki IRC to find a list.
>>
>> On Sat, Dec 5, 2020, 10:45 AM Derek Atkins  wrote:
>>
>> > There are tons of free IRC clients.
>> > -derek
>> >
>> > On Sat, December 5, 2020 11:22 am, Fran_3 via gnucash-user wrote:
>> > > 1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 -
>> Are
>> > > their any free open source alternatives to mIRC?Thanks for any 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.
>> > >
>> >
>> >
>> > --
>> >        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.
>>
>
>
> --
> 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
&g

Re: [GNC] Need help using Gnucash IRC to live chat

[Derek Atkins]

There are tons of free IRC clients.
-derek

On Sat, December 5, 2020 11:22 am, Fran_3 via gnucash-user wrote:
> 1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 - Are
> their any free open source alternatives to mIRC?Thanks for any 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.
>


-- 
   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] entry point error after recent automatic windows 10 update

[Derek Atkins]

Hi Lauren,
Sorry you are having these issues.
I presume you are installing the official gnucash package that you 
downloaded from the links off www.gnucash.org?
Can you manually uninstall what you have installed, download the package 
again, and reinstall it?
As others have said, there are many happy windows users, so it sounds like 
something got corrupted on your system.

A full uninstall and reinstall should correct that.
Good luck!

-derek
Sent using my mobile device. Please excuse any typos.
On November 26, 2020 8:04:34 AM laurel hargis  wrote:


No I am not.

Thank you

On Wed, Nov 25, 2020 at 10:39 PM D. via gnucash-user <
gnucash-user@gnucash.org> wrote:


Laurel,

I'm sorry you're having these troubles. Many windows users (myself
included) are successfully using gnucash on windows. A search online showed
several very old email threads with this error; however, they were from
users of a repackaged version of Gnucash from a group called portableapps.

Is it at all possible that yoga are trying to use a portable version of
Gnucash?

David T.


 Original Message 
From: nvsoar 
Sent: Wed Nov 25 22:47:47 EST 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] entry point error after recent automatic windows 10
update

On 11/25/20 19:19, David Cousens wrote:
> Laurel,
>
> Uninstalling and reinstalling the Windows 10 system should be a last
resort.
>
> *Before you do that, at least make a copy of all the data files in your
user
> directory either on a USB stick or a copy to another computer*. *Don't
let a
> technician reinstall it without doing this first*. Your user files will
be
> stored in C:/Users// where you will need to substitute
your
> actual user name on the computer for the placeholder  in
the
> above path.  Copy all files in that location onto a USB stick or other
> medium before attempting a reinstall of Windows. You will then be able to
> restore your user data files from the USB stick if you do have to do a
> Windows reinstall and reinstall all programs.  That should prevent any
loss
> of data stored in the GNuCash files.
>
> GnuCash 4.2 should not be looking for that file in that location which
may
> suggest that the initial install of GC 4.2 has perhaps not completely
> removed all files from a previous version (which it should do during the
> install procedure) and that an outdated dll file is being accessed and in
> turn is looking for a routine in a dll which no longer exists.  AFAIK
there
> have been some rewrites of the GnuCash library files recently which could
> lead to this.
>
> You could also try making sure any subsequent Windows updates are
installed
> and that Windows 10 itself is fully up to date.
>
> Try manually removing GnuCash using the Control Panel  programs tab
before
> reinstalling GnuCash from a fresh download of 4.2. If old files have not
> been removed properly this may unload them.
>
> If that doesn't work I would then try reinstalling the version you had
> previously and see if it works  Doing a manual uninstall of the previous
> version  from the control panel after a reinstall of the old version
should
> then get rid of any previous program files which may have been left in
> place.  Then follow that by reinstalling GC 4.2.
>
> David
>
>
>
> -
> David Cousens
> --
> Sent from:
http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
snip - I support the above approach suggested by David Cousens. FWIW - I
use the Revo Uninstaller because I found that the Windows uninstaller
still leaves stuff hanging around.  As for file finding I use an
application called Everything that indexes all windows files - much
faster than Windows search.  (Links are
https://www.revouninstaller.com/  and https://www.voidtools.com/) _nvsoar
___
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 

Re: [GNC] Split Transactions

[Derek Atkins]

Hi,

On Mon, November 16, 2020 11:50 am, Kalpesh Patel wrote:
> Not to hit enter/return to move to next line is kind of counter-intuitive
> from everything else as I also get frustrated when entering some of the
> transactions. It would be nice to have an option, if it isn't there
> already,
> where a enter/return could be made to interpret as moving to next line and
> having an either explicit button or something else to "click" to close the
> transaction.

Enter/Return *IS* that explicit button to commit the transaction.

There are plenty of other options to move around, like Tab and arrow keys.

>>> 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] Strange behaviour

[Derek Atkins]

Hi,

On Mon, November 16, 2020 10:46 am, Mahon Finbar wrote:
> Sorry, I think I posted this already in the wrong address.
>
> Hi,
>
> Just now I was making an entry in an account I use regularly, one of my
> bank accounts. and was entering a salary cheque which required an
> alteration of one figure.
>
> It worked fine, date, description, etc., until I tried to change the
> digit on the figure. It put the cursor behind the digit but when I tried
> to change it the blue circle appeared and gnucash closed, completely.
>
> I relaunched, having to do 'open anyway' at the lock question, and
> opened the account, which was closed. The entry I was trying to make was
> not there, although the previous entry was. I tried to enter the salary
> entry, tried to change the digit and the same thing happened , blue
> circle, closed.

What OS/Distro?
What version of GnuCash?

I'm not sure what you mean by "Blue Circle"?

> Any ideas?

Initial thought is a Gtk bug, but it could depend on the answers to those
previous questions.

> Barry

> 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] Export Multiple Customer Reports in Single File

[Derek Atkins]

HI,

On Mon, November 16, 2020 11:36 am, Elizabeth A Brock wrote:
> Has anyone developed a report to download multiple Customer Reports in a
> single html file? If so, would you be willing to share it? I need this
> information but I don't think it exists as a standard report, and I'm not
> a skilled (or even an unskilled) report writer.

What exactly are you trying to accomplish?  A Customer Report is designed
to be something you send to that specific Customer, so I'm not sure what
it would mean to have multiple Customers reported together.

For YOUR use, you have the Aging report, which tells you how each customer
stands, or you could try the Account Report on your A/R account, which
will give you all the history of invoices and payments.

Good Luck,

> Many thanks.
> Beth Brock

> 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] List Replies

[Derek Atkins]

Greg,

On Mon, November 16, 2020 8:33 am, Greg Feneis wrote:
> That seems like an unnecessary dichotomy.  Perhaps it's a limitation of
> mailman, or our ability to administer?  On the other list I belong to that
> server causes either reply type to default to only the list server without
> obscuring the originator's address.

You just stated the issue: "that server causes either reply type to
default to ONLY the list server" (emphasis mine).  THAT is the issue.  We
DO NOT WANT that behavior.  We WANT people to be able to reply privately
to people.  Making private replies challenging is just a non-starter.

Please go read the archives for the last dozen threads on this topic.

Thanks,

-derek

>
>
>
> Kind regards, Greg Feneis
> (Pixel 3)
>
>
> On Mon, Nov 16, 2020, 05:20 Derek Atkins  wrote:
>
>> Greg,
>>
>> This topic comes up about once a year or so, usually closer to Spring as
>> people start working on their taxes and asking for help.
>>
>> In short, yes, mailman COULD be set up to set the Reply-To the list.
>> The
>> downside of that approach is that it makes it MUCH MUCH harder (nearly
>> impossible) to make an off-list (private) reply.  The decision, which
>> has
>> been made over and over again over the past 20 years, is that making it
>> POSSIBLE to make a private reply is more important than making it always
>> reply-to-list.
>>
>> This is why every message has a note to remind people to Reply-All.
>>
>> -derek
>>
>> On Mon, November 16, 2020 8:06 am, Greg Feneis wrote:
>> > Hi friends,
>> >
>> > A frequent encounter on this list is members replying to an email's
>> > originator and not to the list server.
>> >
>> > In the grand scheme, not a big deal. However, other lists I belong to
>> > don't
>> > seem to have this issue.  I'm wondering if a list server setting could
>> > help.
>> >
>> > For this other list I belong to, when I receive an email, it appears
>> to
>> > come from the originator's name and email address.  But, no matter if
>> I
>> > use
>> > reply, or reply-all, the initial email composition only ever begins
>> with
>> > the list server as the only recipient.
>> >
>> > I imagine this feature has to do with the construction of the email
>> > messages being sent from the server to the list members.
>> >
>> > Could our mailman server be set to do the same thing?🤔
>> >
>> > Kind regards, Greg Feneis
>> > (Pixel 3)
>> > ___
>> > 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.
>> >
>>
>>
>> --
>>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.
>


-- 
   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] List Replies

[Derek Atkins]

Greg,

This topic comes up about once a year or so, usually closer to Spring as
people start working on their taxes and asking for help.

In short, yes, mailman COULD be set up to set the Reply-To the list.  The
downside of that approach is that it makes it MUCH MUCH harder (nearly
impossible) to make an off-list (private) reply.  The decision, which has
been made over and over again over the past 20 years, is that making it
POSSIBLE to make a private reply is more important than making it always
reply-to-list.

This is why every message has a note to remind people to Reply-All.

-derek

On Mon, November 16, 2020 8:06 am, Greg Feneis wrote:
> Hi friends,
>
> A frequent encounter on this list is members replying to an email's
> originator and not to the list server.
>
> In the grand scheme, not a big deal. However, other lists I belong to
> don't
> seem to have this issue.  I'm wondering if a list server setting could
> help.
>
> For this other list I belong to, when I receive an email, it appears to
> come from the originator's name and email address.  But, no matter if I
> use
> reply, or reply-all, the initial email composition only ever begins with
> the list server as the only recipient.
>
> I imagine this feature has to do with the construction of the email
> messages being sent from the server to the list members.
>
> Could our mailman server be set to do the same thing?🤔
>
> Kind regards, Greg Feneis
> (Pixel 3)
> ___
> 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.
>


-- 
   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] Split Transactions

[Derek Atkins]

This is covered in great detail in the documentation.

Tl;Dr.. Open your checking account. Input date, description, one of the 
expenses, and total amount. Then click the split button.  Now start 
splitting the amounts to all the expense accounts.  Do not hit enter/return 
until you are finished. Instead use tab or the arrow keys.


-derek
Sent using my mobile device. Please excuse any typos.
On November 14, 2020 8:17:44 PM Nathan Rosenthal  wrote:


I am almost sure someone has figured out how to enter what I call a
split transaction - writing one check to cover multiple expense accounts.

I cannot seem to get this to work properly.
___
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] Problem with Posting Invoice

[Derek Atkins]

Hi,

On Thu, November 12, 2020 5:40 pm, Dr. J. Richard Herbert wrote:
> Thanks Derek, it was the currency setting in my customer entries.
> Somewhere along the line I forgot to set them. Is there a way to set CDN
> as an across the board default?

What do you have set in Edit -> Preferences -> Accounts -> Default Currency?

> Richard

-derek

>
> On 11/12/20 5:55 PM, Derek Atkins wrote:
>> HI,
>>
>> My initial guess is that the Invoice currency does not match the AP
>> Account.  Check you customer currency setting, or the global business
>> currency setting?  You may need to re-select the customer (not edit,
>> literally re-select) so the invoice would reset the currency correctly.
>>
>> -derek
>>
>>
>> On Thu, November 12, 2020 2:09 pm, Dr. J. Richard Herbert wrote:
>>> Help,
>>>
>>> I cannot post invoices for new customers. The invoice enters fine but
>>> when I post, it will not allow me to select a "post to account". I have
>>> been using gnucash for about 12 months without any problems. I did not
>>> require new client entries for a few months so I am uncertain when this
>>> started. I first saw the problem when I was running Fedora 30 or 31. I
>>> am now running Opensuse Tumbleweed.
>>>
>>> I have attached 2 screen shots to help.
>>>
>>>
>>> What is wrong?
>>>
>>> Richard
>>>
>>> ___
>>> 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.
>


-- 
   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] Problem with Posting Invoice

[Derek Atkins]

HI,

My initial guess is that the Invoice currency does not match the AP
Account.  Check you customer currency setting, or the global business
currency setting?  You may need to re-select the customer (not edit,
literally re-select) so the invoice would reset the currency correctly.

-derek


On Thu, November 12, 2020 2:09 pm, Dr. J. Richard Herbert wrote:
> Help,
>
> I cannot post invoices for new customers. The invoice enters fine but
> when I post, it will not allow me to select a "post to account". I have
> been using gnucash for about 12 months without any problems. I did not
> require new client entries for a few months so I am uncertain when this
> started. I first saw the problem when I was running Fedora 30 or 31. I
> am now running Opensuse Tumbleweed.
>
> I have attached 2 screen shots to help.
>
>
> What is wrong?
>
> Richard
>
> ___
> 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.
>


-- 
   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] Your Classification / Tagging Implementation

[Derek Atkins]

Nope.
Credit checking and debit expense.

-derek
Sent using my mobile device. Please excuse any typos.
On November 7, 2020 7:27:04 PM "w...@theprescotts.com" 
 wrote:


IANA (I am no accountant), but don't you have the credit/debit reversed on 
the example Assets:Checking and Expenses:Eating out.


I would think it would be debit to checking (withdrawal) and a credit to 
Eating out. Maybe I don't know what Cr and Dr stand for.


Will

On 2020 Nov 7, at 11-07 15:49:52, Gal  wrote:

The most requested feature in gnucash is to have transaction classification,
also known as tags / dimensions / categories / classes
https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1543027-transaction-classifications

Say I spend 100€ at a restaurant during a vacation in Italy.
The obvious transaction is a 100€ credit to checking account and 100€ debit
to Expenses:Eating out
But I would also like to be able to track the vacation expenses, so I have
to classify all transactions took place during the vacation, for example
with a #italy2020 tag.

Summarizing all discussions I've read, there are two common workarounds, or
ways to manually implement classification in gnucash:

1. By adding the tag #italy2020 to the description, note or memo field of
the transaction.
The transaction report can then filter transactions by the tag string.

2. By creating an additional account, called italy2020, and change the
transaction splits in the following way:
Cr. Assets:Checking 100€
Dr. Tags:italy2020 100€
--
Cr. Tags:italy2020 100€
Dr. Expenses:Eating out 100€


Those of you who implement such taggings, can you share your method, and why
you prefer your method over the other?



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


___
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] creating gnucash custom check printing files on Mac

[Derek Atkins]

Hi,
You might need to show hidden files and folders when you look for the
".chk" files.  On my (Linux) system they are i /usr/share/gnucash/checks/
There is also an online tool that would let you define a custom check
format.  From File -> Print Check you can select "Custom" and set a bunch
of fields.  Or you can find the .chk files and build a new one.

-derek

On Fri, November 6, 2020 4:57 pm, Bart Schroeder wrote:
> Using Gnucash 4.2 on Mac OS 10.15.  None of pre-defined check printing
> formats work for my purpose.  So, how to duplicate, then modify one of
> these print formats.  I am unable to locate any check files (using Mac
> interface) to use as sample files.   In terminal, none show in Application
> directory as suggested in documentation.  Can someone please ID steps to
> create new check format files and where they should be located.
>
> Thank you in advance,
>
> Bart
> ___
> 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.
>


-- 
   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] Cannot Obtain Lock error?

[Derek Atkins]

HI,

On Wed, November 4, 2020 3:02 pm, Jack Slater wrote:
> I used to get this a bit a few years ago.  It has reappeared.  I just
> continue to save the file anyway but I get nervous about file integrity,
> etc. every time I see it. So what's going on and how do I stop it?

Make sure you exit gnucash cleanly and that it fully quits before you
shutdown your computer.

Either that or you have a filesystem/storage problem where it can't
actually create the lock file.

> Jack

> 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] Fidelity and TD Ameritrade setup

[Derek Atkins]

On Mon, November 2, 2020 11:56 am, Martin Preuss wrote:
> Hi,
>
[snip]
>
> Example log files might help me, too.
>
> I would need an example OFX file with those transactions to implement
> brokerage stuff, but I didn't find any helpfull examples OFX files on the
> internet so far :-/

Yeah, I think you'll need to find a couple people who trust you to provide
you actual data.

> 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] Looking for Upgrade Tips

[Derek Atkins]

2.4.21, not 2.3.21.
Should be available in the archive.

-derek
Sent using my mobile device. Please excuse any typos.
On November 1, 2020 9:45:32 PM TanyaMc70  wrote:


Thank you. I see the 2.3.21 is not available for my version of Windows. Is
that going to be an issue?



--
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] Bizarre happenings

[Derek Atkins]

Hi
What version of gnucash?
What OS/Distro?
What happens when you run the report and click on the Options button?

-derek
Sent using my mobile device. Please excuse any typos.
On November 1, 2020 1:39:15 PM alessandra derniat <4san...@live.com> wrote:

My copy of gnucash is acting strange and will not let me access any options 
for reports. I’m stuck with the options I had the last time I used it.


Can someone help me fix this? I’ve been using this program successfully for 
almost 2 years and in general am very happy with it but this has me looking 
around for something else.

Thanks,
Sandy


Sent from Mail for Windows 10

___
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] [GNC-dev] Gnucash server going offline shortly..

[Derek Atkins]

Well, this clearly didn't make it out before my UPS died.
Power has been restored and services should be running normally again.
Please let me know if you notice anything not working.

Note to self, the UPS lasted a bit over 4 hours.

This is the first significant power outage we've had in 3 years, and
according to our neighbors across the street the last significant power
outage was 6-7 years ago.  So basically less-than-twice-a-decade.

We will see if past performance is any indicator of future results :)

-derek

On Sat, October 31, 2020 11:00 am, Derek Atkins wrote:
> Hi,
> Power is out here due to Tropical Storm Zeta.
> The UPS is down to 30%.
> So I am going to cleanly shut down the gnucash server shortly which will
> take down email, wiki, git..
> I will restart it ASAP when power is restored.
>
> -derek
> Sent using my mobile device. Please excuse any typos.
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


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

[GNC] Gnucash server going offline shortly..

[Derek Atkins]

Hi,
Power is out here due to Tropical Storm Zeta.
The UPS is down to 30%.
So I am going to cleanly shut down the gnucash server shortly which will 
take down email, wiki, git..

I will restart it ASAP when power is restored.

-derek
Sent using my mobile device. Please excuse any typos.
___
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] Importing qif from Moneydance

[Derek Atkins]

Hi,

On Wed, October 28, 2020 12:16 pm, Reed Nelson via gnucash-user wrote:
> I tried to import a test bank account qif from Moneydance version
> 2020.1(1928) into GnuCash version 4.2 (Ubuntu 20.04.1 LTS).   I installed
> GnuCash with the software install app  (Software 3.36.1)
>
> Below is the error message and qif file contents.    I could not find the
> log file to get more information on the errors nor figure out how to start
> GnuCash via command line in a terminal.
>
> I would appreciate any suggestions.
> Thanks.
>
>
> Reconciliation status: Unrecognized status ' '. Defaulting touncleared.

I can't tell the cause of this report.

> Transaction amount:Unrecognized or inconsistent format.

This issue is due to the 'CX' in the amount.

> gif file contents:
> !Type:Class
> NMy Finances
> DMy Finances
> ^
> !Type:Cat
> !Option:AutoSwitch
> !Account
> NTest Bank Account
> D
> TBank
> ^
> !Clear:AutoSwitch
>
> !Option:AutoSwitch
> !Account
> NTest Bank Account
> D
> TBank
> ^
> !Type:Bank
> D12/31/1969
> T100.00CX

This CX is the issue for the "amount" format error.

> N
> POpening Balance
> M
> L[Start Balance]
> ^
> D10/28/2020
> T-50.00
> C
> N
> PCheck
> M
> LOther:No Category
> ^

> 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] Deleting test data

[Derek Atkins]

HI,

You can simplify this by just doing:  File -> Export -> Export Accounts
and then File -> Open the new file.  There is no need to go into CSV
format if you're importing it back into GnuCash.

Note that this *ONLY* exports the account tree; if you have business
objects (customers/vendors/taxtables) they will NOT be exported into the
new data file.

-derek

On Wed, October 28, 2020 5:49 am, Eric Coates via gnucash-user wrote:
> Hi
>
> If you've done a lot of work setting up various accounts and you want to
> preserve that work the following is a way of doing that:
>
> File > Export > Export Account Tree to CSV
> Progress through the various stages (be sure to remember the file name and
> its location)
>
> File > New File
> Progress through the stages making the necessary choices. (In my test I
> just accepted all the default options, they seemed to be based on my
> locale.)
>
> There were (in my tests) some errors that related to missing commodities -
> I ignored them, not always a good thing.
>
> File > Import > Import Accounts from CSV
> Proceed through the stages
>
> In my tests that gave me a good basis to start from, probably best to
> check things out. Make further additions changes/corrections as required.
>
> Good luck!
>
> Eric
> 
>
>
> you can clickj File -> "New File" on the menu to create a new database.
>
> On Wed, Oct 28, 2020 at 2:43 PM tireguy  wrote:
>
>> I looked some test data into GNUcash when i first used the program now i
>> would like to delete the test data and load my real data.  I have tried
>> to
>> uninstall and reinstall but test data still there. Is there a way to get
>> rid
>> of that data??
>>
>>
>>
>> --
>> 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
>> seehttps://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.
>
>
> -- Best Regards LI Daobing
> ___ 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.
>


-- 
   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] update on piecash, unofficial python bindings for GnuCash

[Derek Atkins]

Hi,

On Sun, October 25, 2020 8:58 am, Sébastien de Menten wrote:

> I just discovered on https://wiki.gnucash.org/wiki/Python_Bindings that
> piecash is referenced (thank you Henrik). Could you update the comment now
> that piecash supports 4.2 ? and also adapt the link to the documentation
> of
> piecash (currently it refers to https://pythonhosted.org/piecash/ instead
> of  https://piecash.readthedocs.io). Thank you again Henrik!

It is a wiki -- you can make the changes yourself :)

> Regards,
>
> Sébastien

> 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] Payment initiation; was: FreeBSD and GNUCash

[Derek Atkins]

On Thu, October 15, 2020 2:18 pm, Frank H. Ellenberger wrote:
>  the european protocolls EBICS and FinTS have the
> ability to upload PAyment INitiation (PAIN).

And BOY does it hurt!!!   LOL.

> Regards
> Frank

> 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] Account view question

[Derek Atkins]

Hi,

On Wed, October 7, 2020 6:22 pm, Kalpesh Patel wrote:
> Hello GNUCash subscribers -
>
> I was looking for a way to see delta change between yesterday and today in
> the Account View page. I have added columns from the drop down list such
> Present, Cleared, Reconciled, Total, etc., but I did not see anything that
> would come close to show me 'change from yesterday' type of column.
>
> If there is a way then any help that would make that column available for
> display would be welcome.
>

I'm sorry to say but I know of no such feature in GnuCash.

Sorry.

> 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] 8.1.1. Find Transaction

[Derek Atkins]

You must be in your 60s or 70s (or older) if you think you were around 
before the term regex was created.
The term regex (REGular EXpression) has been around at least since the 80s 
if not earlier.  It is a way to search for, well, a regular expression.
There are several resources for regex examples, and regex has been 
standardized for many decades.

Happy hacking.

-derek
Sent using my mobile device. Please excuse any typos.
On October 2, 2020 10:50:45 PM David Carlson  
wrote:



Geoff,

Thank you for the very nice description of how to implement the mechanics
of an iterative search.  Now all we need is an easy to understand
description of how each of the search criteria work, including (especially,
with examples) exactly what regex means to those of us that went to school
before that term existed, how to know exactly which split lines are
searched and which split lines just come along for the ride into the
results, and perhaps why the search dialog disappears, which was the
original problem that started this thread.

I can't seem to make the help for that dialog appear from the help button
in that dialog.  I finally found the actual help in the F1 Help manual
under Tools and Assistants > Find which completely glosses over the
subjects in the previous paragraph.

On Fri, Oct 2, 2020 at 7:49 PM Geoff  wrote:


Regardless of whether the search box disappears or not, GnuCash's
"search within search results" feature is still pretty nifty.

I've attached a screenshot showing four consecutive searches illustrating:
New search (the other options are always disabled on the initial search)
Add results to current search
Refine current search
Delete results from current search

First search is to locate transactions with value less than 200.
Second search is to add in transactions with value more than 800.
Third search is to restrict to description containing "gnucash".
Fourth search is to remove transactions posted on 26th September.

(Harking back to our school days, I think we can say that GnuCash search
provides the Set Theory equivalents of Union, Intersection, and
Complement
https://www.britannica.com/science/set-theory/Operations-on-sets.  But I
digress.)

The trick is to invoke the second and subsequent searches from the
"Search Results" tab and not the Chart of Accounts.

This is, of course, a simple example.  Any given search operation also
lets you specify multiple criteria ("Add" button), and whether "all
criteria" must be met or just "any criteria" ie AND or OR logic.

James, I hope this tip improves your search results.

Regards

Geoff
=
Version: 4.1
Build ID: 4.1+(2020-07-25)
Finance::Quote: 1.49
Windows 10


On Sat, 26 Sep 2020 13:47:10 -0500 (CDT), Jamestk wrote:
Hello good folks,

I wanted to check if there was a simpler way when using the 'find
transaction'feature repeatedly.

When searching for transactions it normally involves a batch of invoices or
receipts which are not showing withing reports, most often this is due to
me
selecting incorrect accounts or similar, easy way is to use find feature -

Searches are basic, Select find from edit menu then opt for 'value' setting
leaving all other criteria std, often this works but if it returns nil
results you have to start over, is there anyway of saving the search or to
edit and re-run the original without having to start from scratch?

8.1 help file is okay but a bit technical in parts.

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




--
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] Stock Levels

[Derek Atkins]

Gnucash does not have inventory support.

If you only need to track a few items you can probably hack something 
together using a Stock account, but it is not a true inventory.


-derek
Sent using my mobile device. Please excuse any typos.
On October 2, 2020 5:17:09 AM Duikerbos  wrote:


Morning

I am starting a small Broiler project and using GnuCash to track
transactions

Is it possible to track stock levels, birds purchased less birds sold?


Frederick


___
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] Anyone have a current gnc-vcs-info.h they can post here?

[Derek Atkins]

Don't use github tarballs.
We would turn them off if they would let us!
Either use an official release tarball or fit clone.

-derek
Sent using my mobile device. Please excuse any typos.
On October 2, 2020 7:27:09 AM B Wooster  wrote:


The githib .zip archive fails to build for what I think is a known issue -
tarballs, cmake, make does not work for gnucash build.

Can someone reply to this message with a currently valid gnc-vcs-info.h? I
hacked itup, but it fails in the version-info2env step.

 Manually hacked up gnc-vcs-info.h like this, but it will fail later in
version-info2env step:
#define GNC_VCS_REV "4.20"
#define GNC_VCS_REV_DATE "11"
#define GNC_VCS_REV_YEAR "2020"
#define GNC_VCS_REV_Y_M "2020-10"

I got around it by using make -i, and it built gnucash, so somewhat OK for
now. Just experimenting right now.

clean make error:
...
Scanning dependencies of target gnc-vcs-info
make[2]: *** No rule to make target
'.../gnucash-maint/libgnucash/core-utils/gnc-vcs-info.h', needed by
'libgnucash/core-utils/CMakeFiles/gnc-vcs-info'.  Stop.
make[1]: *** [CMakeFiles/Makefile2:5180:
libgnucash/core-utils/CMakeFiles/gnc-vcs-info.dir/all] Error 2
make: *** [Makefile:163: all] Error 2


[not a member of devel group so hoping someone from gnucash-user can reply!
thanks!]

Debian system, gnucash-maint zip archive 2020-Oct-1:

make -i
...
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
 list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
 .../gnucash-maint/cmake/configure-manpage.cmake:14 (versioninfo2env)


[ 50%] Built target gnucash-cli-manpage
[ 50%] Generating gnucash.1
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
 list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
 .../gnucash-maint/cmake/configure-manpage.cmake:14 (versioninfo2env)


[ 50%] Built target gnucash-manpage
...
[ 68%] Built target gnucash-cli
make[2]: *** No rule to make target '.../gnucash-maint/gnucash/gnome/
gnucash.appdata.xml.in', needed by 'gnucash/gnome/gnucash.appdata.xml'.
Stop.
[ 68%] Built target gnucash-appdata
[ 68%] Generating gnucash.desktop
CMake Error at .../gnucash-maint/cmake/version-info2env.cmake:10 (list):
 list index: 1 out of range (-1, 0)
Call Stack (most recent call first):
 .../gnucash-maint/cmake/configure-gnucash-desktop.cmake:15
(versioninfo2env)
___
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] How to have Transaction Report show Debit Totals (&/or Credit Totals) ?

[Derek Atkins]

Hi,

On Fri, September 25, 2020 2:40 pm, Fran_3 via gnucash-user wrote:
> Is there anyway to have a Transaction Report show the total of the Debits
> column... or the Credits column... or both?
> (I thought sure I had done this before but today I stared and stared at
> the Transaction Report Tabs and didn't see it.)
> Thanks for any help.

If you start with the register you want summed, you can run Report ->
Account Report and it will sum it up for you.   Not the same as a
transaction report, because you need to configure everything from the
register before you run the report.

> 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] Is there any easy way to produce monthly reports?

[Derek Atkins]

HI,

You can *try* the Reports -> Experimental -> {Balance Sheet / Income
Statement } multicolumn reports.

-derek

On Fri, September 25, 2020 12:05 pm, Chris Green wrote:
> The auditor here likes to see monthly figures so I need to produce
> Cash Flow or Profit and Loss reports or something similar for each
> month.
>
> Is there any easy/quick way to configure these other than to select
> the report, set the dates and save the report once for each month?
>
> Also, are there any reports that show each month's figures in columns
> on a single 'sheet'?
>
> Surely lots of organisations want monthly figures.
>
> --
> Chris Green
> ___
> 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.
>


-- 
   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] MT940 memo being truncated

[Derek Atkins]

Hi,

Did you expand the transaction and turn on double-line mode to see if some
of it is in a Split Memo or the Transaction Notes fields?

-derek

On Mon, September 21, 2020 5:30 pm, Gordonjackson75 wrote:
> Notwithstanding the known requirement to "skip first 3 lines" of ABN Amro
> MT940 files, I think there's a problem with 4.1 import.
>
> In 4.1, importing MT940 results in tag 86 ( Info to Account Owner ) being
> truncated, to only show the first line of the tag.  In the ABN Amro
> format,
> the contents can line-break for 3 lines.  This is standard format I
> believe.
>
> Previously in v3.x I could import MT940 messages from ABN Amro,  and I
> would
> get all of the tag 86 contents appearing in the Transaction Description.
>
> Example, prior to 4.1 (I was on 3.something), I could import MT940
> transactions and get this as the Transaction Description:
>
> SEPA INCASSO ALGEMEEN DOORLOPEND INCASSANT: NL03ZZZ30177126 NAAM: TLS
> BV
> INZ. OV-CHIPKAART   MACHTIGING: NL03ZZZ30177126x xx
> OMSCHRIJVING: AUTOMATISCH OPLADE N OV-CHIPKAART KAARTNUMMER:XXX
> OPLAADDATUM/TIJD:28- 06-19 13:31
>
> In 4.1, importing MT940, I get this:
>
> SEPA INCASSO ALGEMEEN DOORLOPEND INCASSANT: NL03ZZZ30177126
>
> Both files contain the same format of data.
>
> I guess (from searching the forums) that importing MT940 is not
> particularly
> common, but it is making reconciling the import nearly impossible.  Any
> guidance appreciated! (I could down grade I guess..)
>
>
>
>
> --
> 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.
>


-- 
   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] Can't "Save As" to sqlite, is it a compile option?

[Derek Atkins]

On Mon, September 21, 2020 9:59 am, Chris Green wrote:
> On Mon, Sep 21, 2020 at 07:25:54AM -0400, D. wrote:
>> No need. 
>> https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html
>>
> OK, it's there, but I didn't find it very easily (could be me of
> course).
>
> Is there any major disadvantage to making it a dependency on Linux as
> well as on Windows and Mac?

No; just that it's up to every package maintainer to do it, and we do not
have any control over that.  You can petition with your
package-maintainer-of-choice to add the dependency.

> 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] Can't "Save As" to sqlite, is it a compile option?

[Derek Atkins]

The SQL backend uses libdbi and that is a compile-time option. However you
need runtime libraries to enable the various SQL backends to work.

Most likely you don't have the appropriate SQLite database drivers
installed.  Search for libdbi-dbd-sqlite and similar.

-derek

On Sun, September 13, 2020 10:34 am, Chris Green wrote:
> I am running GnuCash 3.8 Build ID: 3.8b+(2019-12-29) on [x]ubuntu 20.04.
>
> I have started keeping a small PCC accounts with this but decided I
> wanted to move to storing the data in sqlite rather than the default
> XML.
>
> It doesn't seem to be possible, if I click on SaveAs in the File menu
> the only Data Format I'm offered is XML.
>
> Is this because sqlite storage is a compile time option that hasn't
> been included in the Ubuntu build, or is there something else I need
> to do?
>
> --
> Chris Green
> ___
> 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.
>


-- 
   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] I'm still a bit confused about when things get saved.

[Derek Atkins]

Hi,

On Thu, September 10, 2020 11:18 am, R. Victor Klassen wrote:
> At least on the Mac, there’s no guarantee that it is physically written to
> disk immediately.  I’ve experienced a handful of posted and printed
> invoices disappearing due to a power outage.  Probably less likely to
> happen on a system with an SSD drive, as there’s not as much reason to
> wait to flush disk buffers to disk.  This would be an issue with the
> SQLite implementation, likely not in GnuCash directly.

Well, sure, GnuCash cannot control the OS's file system semantics.  And
indeed, in pretty much every modern OS there is a delay from when an
application "writes" something to the file system vs when the OS flushes
that file system out to the storage media (HDD or an SSD). There are some
was that applications can inform the OS that it it wants it written *now*
(e.g. flush the IO).  However, in a power outage, all bets are off.

Save Early, Save Often!

-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] I'm still a bit confused about when things get saved.

[Derek Atkins]

Hi,

On Thu, September 10, 2020 8:32 am, Chris Green wrote:
>
> When does data entered get saved?  Also are there different 'levels'
> of save as it were?

Yes, there are different levels of data storage, per se.  There are:

* Data Entry -- the data only lives in the UI
* Commit -- the data is stored into the in-memory cache of your data
* Save -- the in-memory cache is written to disk

> It seems to be as follows but I'd like to be sure (*and* I'd like to be
> able to change things somewhat) :-
>
> While entering values (including date, description etc. as well as
> the actual amounts) the data isn't saved anywhere.  If you leave
> the transaction you're editing without hitting the +Enter button
> then the data doesn't get anywhere useful.  *But* the data isn't
> lost, it's still there if you go away to another account and then
> back.

Correct.  You have to actually commit the transaction for the changes to
be, well, committed.  This is considered a FEATURE that it is not
committed until you are ready to do so.  Sometimes you might need to visit
a different register to validate some data.  So yes, you must commit the
transaction explicitly.

> When you hit +Enter the transaction gets 'added to the accounts'
> and totals, balances, etc. will be updated with the new transaction.
> What isn't clear is whether this also stores the new transaction
> to file.

Correct, this is "commiting" the transaction.  At this stage it will only
go into the in-memory cache of your data.  It is not written to disk
(unless you're using a SQL backend -- that's one of the two main
differences between SQL and XML-File storage).

> Whenever I leave GnuCash I get the Save warning (unless I've just
> done a Save) saying that everything will be lost.  This appears to
> always be everything since I started a new session, not just the
> last transaction.  So does GnuCash have an 'in memory' (or at
> least not in the normal saved file) copy of the accounts that is
> only saved when you explicitly do a 'Save'?

Yes.  If you are using the XML-File backend (the default) then you must
explicitly dave the data for it to get stored to disk.  There is an
autosave feature that will automatically save your data every (30?)
minutes (I don't recall the default setting).

If you use the SQL backend then your commits are saved to storage
immediately as explained above.  HOWEVER, the other main difference is
that with the File-XML backend you get an explicit backup file created
every time you save, but with SQL, there is NO backup file -- you are
expected to make frequent backups of your database.  This is particularly
important as GnuCash has no "undo" function.

> Are my above guesses about when data is saved correct?  Does one
> *always* have to hit +Enter or are there implicit ways of doing it?
> I'd really prefer transactions to get stored when I move move away to
> another account rather than having to hit +Enter.

There are other ways to do it other than hitting "Enter".  Specifically,
any time you leave the transaction *in the same register* it will
implicitly commit it.  But you must physically (well, visually) change to
a ddiferent transaction *IN THE SAME REGISTER*.  I.e., you must manually
exit the transaction.  You can do this by the up/down arrows, tabbing out,
or hitting Enter.  But exiting the register is not sufficient.

>   Can GnuCash be configured for more 'automatic' storing of entered data?

Yes, there is the autosave feature mentioned abocve, or you can change to
a SQL backend (with the caveat that you need to manually back up your data
frequently).

> Many/most applications seem to save data automatically by default,
> i.e. the data gets saved to file/disk as you move from field to field.

Um, I don't think so.  Havent you ever lost work in Word/Excel/Powerpoint
(or their LibreOffice counterparts)?  I know I have!  Indeed, MOST
applications require a manual save, or have a periodic (but not
instantaneous) auto-save.  A save-as-you-go is VERY expensive, especially
when a save means serializing the whole dataset into a file and writing it
to disk -- with lots of data that can take several seconds at a pop.  Many
(most!) people wouldn't want their session to freeze for 10 seconds every
time they enter a transaction!

I am not saying that there isn't room for improvement, but we got to where
we are today over multiple decades of back and forth to ensure the "best"
of all worlds, but with tweaks to make everyone happy.  Feel free to set
your autosave to 1 minute if that's what you want.  If you haven't made
any change then it won't do anything, but it does mean your app will
fr

Re: [GNC] Is there an 'easy' way to have a transaction with 'sub-transactions' as it were?

[Derek Atkins]

Hi,

On Tue, September 8, 2020 10:29 am, Chris Green wrote:
> I'm feeling my way with these PCC accounts but I do feel as if GnuCash
> will do quite well for me.
>
> Anyway, next silly question, two of our income streams are
> 'Collections in services' and 'Offertory Box'.  These are (currently)
> recorded separately in the accounts but get paid into the bank
> together.   So, for example, I have for one Sunday in January a
> collection of £48.00 and £10.50 in the offertory box which get paid
> into the bank on a single paying in slip of £58.50.
>
> Is there a way of recording the amounts as two income entries but as
> only one bank account credit?

Sure.  Create a single split transaction.

Start from your Bank account and create a deposit for the total, 58.50.
Then click the Split button to expand it out and then you can enter (in
the withdrawal column) the two splits.  One for Income:Collection for 48,
and one for Income:Offertory for 10.50.

> Obviously I could simply record two transactions with the same paying
> in slip reference number, not that onerous, I was just hoping there
> might be an easier/better way.

Well, your other option is to use a Suspense account.  This would involve
three total transactions:

Income:Collection -> Suspense
Income:Offertory -> Suspense
Suspense -> Bank

> In the long run it may well be that they're only recoroded separately
> because "it was always done that way" but I don't want to rock the
> boat too much!  :-)

That's an option, too.  And when you reconcile the bank account at the end
of the month you can "combine" them then.

For what it's worth I often have the oppose problem. I place an order for
multiple items from Amazon for $100 and THEY split it up into multiple
changes which I have to reconcile together.

> 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] Help - entering opening balances

[Derek Atkins]

On Tue, September 8, 2020 10:15 am, Chris Green wrote:
>>
> Yes, thanks, I seem to have got there now.
>
> However I still think the help system was a bit rubbish! :-)

You are absolutely encouraged to help improve it!!!  :-)

> Chris Green

> 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] Help - entering opening balances

[Derek Atkins]

On Tue, September 8, 2020 10:13 am, Chris Green wrote:
> On Tue, Sep 08, 2020 at 11:01:29PM +1000, Peter West wrote:
>>Hi Chris,
>>
>>Don’t create accounts under Equity. Create your savings and current
>>account under Assets. Then enter your opening balances as Stan Brown
>>describes.
>>
> But GnuCash actually has an 'Opening Balances' placeholder in Equity,
> isn't that where your opening balance credits to the bank accounts
> come from?

Yes, but not as sub-accounts.

I.e., don't create E:O-B:Bank1, E-O-B:Bank2, etc.
Just create a transaction from E:O-B -> Assets:Bank1 and E:O-B ->
Assets:Bank2.

> Chris Green

> 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] Help - entering opening balances

[Derek Atkins]

Hi,

On Tue, September 8, 2020 8:52 am, Chris Green wrote:
> I am at the stage of lots of rude words at the moment! :-)
>
> I am just starting to try and set up GnuCash for the PCC accounts and
> I've fallen at the first hurdle.  I can't work out how to enter
> opening balances for the two accounts we have - a current account and
> a savings account (which is basically the building fund).
[snip]
> So, ignoring the help system, how do I enter an Opening Balance?
> There's a section in accounts under 'Equity' for opening balances and
> I tried creating two accounts under that and entering balances but the
> result made no sense at all to me.  Having entered an opening balance
> I'd expect the balance sheet to show me that amount but GnuCash just
> did a decrease and a balancing increase in the Equity account which
> doesn't really make much sense.

An O-B transaction is nothing special, it's just a regular double-entry
transaction between the account in question and the Equity:Opening
Balances account.  You can create an O-B when you create an account, or,
after the account is created, you can just manually create the O-B
transaction.

So for example if you start with $100 in your Bank, the O-B would be a
transaction that Debit's Bank $100 (putting the $100 into it) and credits
E:O-B.

There's nothing special about it.

Happy Gnucashing,

> 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] 1) search list 2) gnucash-u...@lists.gnucash.org vs gnucash-user@gnucash.org

[Derek Atkins]

HI,

On Tue, September 1, 2020 8:57 am, Fran_3 via gnucash-user wrote:
> 1 - Is there anyway to search the list archives... like maybe you would do
> an online forum?

Google search works pretty well, especially if you add
site:lists.gnucash.org to your search parameters.

We don't have a "forum", we have a mailing list that has been around for
more than 20 years.

> 2 - I've ended up with two emails addresses for GnuCash...
> gnucash-user@lists.gnucash.organdgnucash-u...@gnucash.org
> What is the difference?Will both get my email distributed to the list
> members?

Both work.

> Thanks for any help.

> 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] How to transfer multiple bills from Vendor A to Vendor B? Journal Entry or what & how?

[Derek Atkins]

HI,

On Thu, August 27, 2020 11:50 am, Fran_3 via gnucash-user wrote:
> We have some unpaid bills posted to Vendor A's account...We need to
> transfer the total of those bills from Vendor A's account to Vendor B's
> account.Then pay that total out of Vendor B's account
> We do not want to delete the individual bills from Vendor A's account.We
> just want to transfer the total of the bills so that we show that we moved
> the total of the bills to Account B.
> Once the transfer is done we will record the payment of the bills in
> Account B.
> I thought we could do this with a journal entry but I can't see how to do
> that as when I look at...Tools > General Journal
> How can I do this so I have a record in the system of what happened?

Do you want the bills for Vendor A to show as "paid"?  If so, the only way
to do that would be to "Process Payment" for them.  But there is no way,
internally, to create a transaction that will transfer the outstanding
balance from one vendor to another in a single transaction.

You COULD potentially to it through a suspense account.  So you "pay" the
vendor A bills from some account (Equity:Vendor Shift?).  Then you create
a new bill for vendor B that pulls from that Equity account and moves the
balance back into AP.  Then you can Process Payment to pay Vendor B.

Two notes:

1) You may not be able to do this from an equity account -- it might make
sense to do the second step first and figure out what account you want to
(and can) use, and then move the funds from Vendor A.

2) You can safely change the "far" account of the Vendor A payment.  So
e.g. you could Process Payment from Bank to A/P for Vendor A, and then
change "Bank" to anything else.  So long as you don't change the amount or
touch the AP side, everything stays kosher under the covers.

Hope this helps!

> Thanks for any help.

> 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] New User - can't modify inoice notes.

[Derek Atkins]

Hi,

Please be sure to CC gnucash-user on all your replies using your mailer's
reply-to-list or reply-all functionality so everyone can see your
responses and continue to help...

On Wed, August 26, 2020 4:02 pm, Lester Bennett wrote:
> I had already done that. I modify the Notes then click apply and the
> changes appear on the printable invoice screen. I then click Save Config
> but the next time I open the same invoice or create a new one it comes
> back to the default Notes. I want this to be the same for all future
> invoices.

You would need to save it as a custom invoice, and then when you want to
print a new invoice you would need to run the custom version and then
choose the new invoice to print.  You won't be able to do it from the
"Print Invoice" button.

Another option is to just keep the configured printable invoice tab open,
and then again just select the new invoice from the options of that report
when you want to print a new invoice.

-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] New User - can't modify inoice notes.

[Derek Atkins]

HI,

On Wed, August 26, 2020 3:06 pm, Lester Bennett wrote:
> I am new to Gnucash. I have just taken on the position of Treasurer of
> my local Men's Shed and moved to computerised computing seeing as I have
> an IT background.
> Being a non-profit organisation we don't normally issue invoices but we
> did a job for a local company recently and they needed an invoice for
> their records. I tried to change the notes at the bottom of the invoice
> that normally show "Thank you for your patronage!" to include our bank
> account details but the changes don't appear at the bottom of the
> printable invoice just the default notes. When I go into edit the
> invoice the changes do appear in Notes. How do I get these Notes to
> appear at the bottom of the printable invoice?

That text doesn't come from the Invoice, it's part of the report.

With the printable invoice report open, go to the Report Options.
Then go to the Display tab.
In there you will find the text you want to modify.

> Lester

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