Re: [GNC] Questions

[Christopher Lam]

Thanks Adrien.
I've realised that unless the multicolumn report is merged into mainstream,
it will never gain enough exposure for bug reports. So perhaps it'll be
better to merge for 3.6 into an 'experimental' submenu within reports.
C


On Wed, 8 May 2019 at 13:24, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Stephen,
>
> Comparative-period P&L is not yet implemented in GnuCash. (but as Chris
> Lamm noted, he has a testing version of the report that *might* fit your
> needs - if you can try it, please do so)
>
> You *can* run a multi-column report with each period in its own column,
> but it will get messy with each column having its own row headers, as
> you’ve likely discovered. (you could set all columns to use all accounts,
> show zero balance accounts, and then copy/paste or export to spreadsheet
> and then manipulate from there)
>
> Probably an easier route is to maintain a spreadsheet of your P&L’s and
> paste in each column every period. Be sure to include all account including
> zero balance accounts so everything lines up on the proper rows in the
> spreadsheet. (I use this method along with percentage and variance columns
> that I add)
>
> Regards,
> Adrien
>
> > On May 6, 2019, at 8:35 AM, Stephen C. Camidge 
> wrote:
> >
> > 2) Yes, I can get multi column reports with the Transaction Report, show
> totals monthly by account, but it will not display monthly totals and it
> will not display Revenue separately from Expenses with totals for Revenue
> and for Expenses.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Questions

[Adrien Monteleone]

Stephen,

Comparative-period P&L is not yet implemented in GnuCash. (but as Chris Lamm 
noted, he has a testing version of the report that *might* fit your needs - if 
you can try it, please do so)

You *can* run a multi-column report with each period in its own column, but it 
will get messy with each column having its own row headers, as you’ve likely 
discovered. (you could set all columns to use all accounts, show zero balance 
accounts, and then copy/paste or export to spreadsheet and then manipulate from 
there)

Probably an easier route is to maintain a spreadsheet of your P&L’s and paste 
in each column every period. Be sure to include all account including zero 
balance accounts so everything lines up on the proper rows in the spreadsheet. 
(I use this method along with percentage and variance columns that I add)

Regards,
Adrien

> On May 6, 2019, at 8:35 AM, Stephen C. Camidge  wrote:
> 
> 2) Yes, I can get multi column reports with the Transaction Report, show 
> totals monthly by account, but it will not display monthly totals and it will 
> not display Revenue separately from Expenses with totals for Revenue and for 
> Expenses.


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

[Adrien Monteleone]

Sachin,

Since you’re using Windows I don’t think you have GTKInspector at your 
disposal. (I’m certainly free to be corrected on this point, but previous 
threads seem to indicate it isn’t available, at least currently)

I’m really tied up at the moment, but if someone else has the time to fire up 
the inspector on Linux or MacOS and do some experimenting...

Otherwise, I’ll look at this thread in a day or two and if I don’t see someone 
else has solved it, I’ll take a look.

Regards,
Adrien

> On May 6, 2019, at 5:57 AM, Sachin Danave  wrote:
> 
> Hi Geert
> 
> Thanks a lot. I was wondering if something was wrong with my installation !!
> 
> This brings me to my earlier question. Is there a way by which you can set
> a background colour to the Accounts screen ?
> 
> I dont mean the Account colour, that can be set. But can the whole Accounts
> screen have - say a Blue background ?
> 
> Not a must requirement but will improve the visibility ...
> 
> Thanks and Regards
> 
> Sachin

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

[Adrien Monteleone]

I could be vastly off base here, but, I think that message about 
“selecting...instead” is because the package build info is specifying a generic 
name but the actual packages have specific version names as part of the file 
name. There is a way to fix this. (still specify the version but the package 
name is generic) However, I’m not well versed enough to say how to accomplish 
it, only that I’ve experienced projects that faced this issue and solved it, so 
it is possible.

> On May 4, 2019, at 9:15 PM, Stephen M. Butler  wrote:
> 
> On 5/4/19 11:23 AM, Eric Coates wrote:
>> Stephan
>> 
>> Although I???m about to relate some problems I???ve had with your
>> GnuCash 3.5 on Ubuntu 19.04 before I do I want to say that I
>> appreciate your efforts (and those of your ???hand holders???!) on
>> providing tools to the community. Sincerely, thank you.
>> 
> <>
>> /Note, selecting 'gnucash' instead of './gnucash_3.5_amd64.deb'/
>> 
>> /Note, selecting 'gnucash-common' instead of
>> './gnucash-common_3.5_all.deb'/
>> 
>> /Note, selecting 'python3-gnucash' instead of
>> './python3-gnucash_3.5_amd64.deb'/
> 
> 
> This appears to be normal as I saw something similar.
> 
> What I don't see is it listing the three files in the get list.  Maybe
> these other problems (below) prevented that.  However, it may be that
> you grabbed the folder rather than the three individual files.  In which
> case, you will need to unzip the resulting download (Google Drive tends
> to zip them up and send them down as a zipped file if you grab them all
> at once).
> 
> 
>> /gnucash : Depends: libicu60 (>= 60.1-1~) but it is not installable/
>> 
>> /Depends: libpython3.6 (>= 3.6.5) but it is not installable/
> Strange. 
>> 
>> /Recommends: gnucash-docs but it is not going to be installed/
> I need to figure out how to build that at some point.  But it should
> find an older version in the repository and pick that up.
>> 
>> /Recommends: pythone3-gnucash but it is not installable/
> 
> Color me beet red!!  This is a typo in the dependency list.  My fault. 
> Guess I never saw this as I'm always forcing this to be installed with
> the correct name.
> 
>> 
>> /python3-gnucash : Depends: libpython3.6 (>= 3.6.5) but it is not
>> installable/
>> 
>> /Depends: python3 (< 3.7) but 3.7.3-1 is to be installed/
>> 
>> /E: Unable to correct problems, you have held broken packages./
> 
> Unless you truly didn't get the three distinct files (zip?), I'm baffled.
> 


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

[Adrien Monteleone]

You can also click the Account Name column repeatedly to get different sort 
orders.

The order I have from that process is:

Assets
Expenses
Equity
Liabilities
Income
Trading (optional)

Regards,
Adrien

> On May 4, 2019, at 2:57 PM, Maf. King  wrote:
> 
> On Saturday, 4 May 2019 20:20:40 BST Stephen C. Camidge wrote:
>> New user, may be obvious.
>> 
>> For some reason the parent account Liabilities shows up after Income. Income
>> shows up after Expenses. How do I reposition them?
>> 
> 
> Hi Stephen,
> 
> You mean in the Chart of Accounts?  I think that is sorting by alphabetical 
> order.  Possibly assign some account codes then add the column to the COA 
> view 
> (the down arrow on the right of the header line) and sort on that?
> 
> HTH,
> Maf.
> 


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

Re: [GNC] undo close?

[ToddAndMargo via gnucash-user]

On 5/7/19 6:48 PM, Derek Atkins wrote:

What do you mean archived?


It was GnuCash's wording.  And I don't know
what it means.  I tought it meant I was done
editing for the day.

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

[Derek Atkins]

What do you mean archived?

-derek
Sent using my mobile device. Please excuse any typos.
On May 7, 2019 9:45:56 PM ToddAndMargo via gnucash-user 
 wrote:



On 5/7/19 5:34 PM, Derek Atkins wrote:

So
it closed that tab (which is NOT closing the file).


It closed and archived

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

[ToddAndMargo via gnucash-user]

On 5/7/19 5:34 PM, Derek Atkins wrote:

So
it closed that tab (which is NOT closing the file).


It closed and archived

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

[Derek Atkins]

Hi,

On Tue, May 7, 2019 7:38 pm, ToddAndMargo via gnucash-user wrote:
>On 5/7/19 5:56 AM, Derek Atkins wrote:
>
> Which "close" did you accidentally hit, and where did you "hit" it?

That attachment answered the "which", but not the "where".

What Page/Tab were you on when you clicked it?  As I suggested in my
previous message (which you edited out in your reply and failed to fully
respond to), I suspect you were on the Chart of Accounts page (tab).  So
it closed that tab (which is NOT closing the file).  Hitting View -> New
Accounts Page would bring it up again.  Did you try that?

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] undo close?

[David Carlson]

Well, that is why so many of us have flat foreheads 🤕.  We have done it
too.

We have learned to go back to the CoA or another account that we recall has
a recent transfer and re-open the register window from there.

David Carlson

On Tue, May 7, 2019 at 6:43 PM ToddAndMargo via gnucash-user <
gnucash-user@gnucash.org> wrote:

>On 5/7/19 5:56 AM, Derek Atkins wrote:
>
> Which "close" did you accidentally hit, and where did you "hit" it?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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.

Re: [GNC] undo close?

[ToddAndMargo via gnucash-user]

On 5/7/19 3:50 AM, Colin Law wrote:

On Tue, 7 May 2019 at 11:45, ToddAndMargo via gnucash-user
 wrote:


On 5/7/19 3:17 AM, Colin Law wrote:

What popup tooltip do you see if you hover over the Close button that
you posted an image of?

Colin


I am too chicken to do it again.


I am not asking you to click it, just hover over it to see what the popup says.

Colin



"Close the currently active page"

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

[ToddAndMargo via gnucash-user]

   On 5/7/19 5:56 AM, Derek Atkins wrote:

Which "close" did you accidentally hit, and where did you "hit" it?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Building from source

[Robin Chattopadhyay]

Never mind... Sorry, I should have tried harder to find a solution. I had a
problem with the guile installation. Once I fixed that, re-compiled and
re-installed, the messages went away.

Thanks,
Robin



On Tue, May 7, 2019 at 12:26 PM Robin Chattopadhyay 
wrote:

> Hi-
>
> I am attempting to build from source on a new machine (a backup machine)
> and I keep running into this when I run gnucash from terminal:
>
> ;;; WARNING: loading compiled file
> /usr/local/lib/gnucash/scm/ccache/2.0/fin.go failed:
> ;;; ERROR: In procedure make_objcode_from_file: bad header on object file:
> "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00"
>
> There's a long running list of similar errors with different file names.
>
> I have repeatedly tried uninstalling and re-compiling, etc. but I'm not
> sure what's going wrong. I have also re-downloaded the source file from
> SourceForge, but that didn't change anything.
>
> Linux Mint 19.3
> Gnucash 3.5
>
> Thanks,
> Robin
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Quicken import and duplicate records

[Adrien Monteleone]

It’s a wiki. Create an account and make the edits.

Regards,
Adrien

> On May 7, 2019, at 12:04 PM, Cricket Onebit  
> wrote:
> 
> Can someone edit that page in the wiki? It would help new users a lot.
> 
> On Mon, 29 Apr 2019 at 17:00, David Carlson 
> wrote:
> 


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

[Robin Chattopadhyay]

Hi-

I am attempting to build from source on a new machine (a backup machine)
and I keep running into this when I run gnucash from terminal:

;;; WARNING: loading compiled file
/usr/local/lib/gnucash/scm/ccache/2.0/fin.go failed:
;;; ERROR: In procedure make_objcode_from_file: bad header on object file:
"\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00"

There's a long running list of similar errors with different file names.

I have repeatedly tried uninstalling and re-compiling, etc. but I'm not
sure what's going wrong. I have also re-downloaded the source file from
SourceForge, but that didn't change anything.

Linux Mint 19.3
Gnucash 3.5

Thanks,
Robin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Changing account tree on large database

[Cricket Onebit]

I used Sqlite and Python for a project a few years ago. SQLite was great,
including a few third-party viewers. The Python binding was a bit much to
comfortably wrap my brain around as fast as I wanted to. I was learning
Python, SQL, and re-learning HTML forms and static-state programming, all
at the same time, and making printable forms. Python has a really nice
minimal server for local websites.

I tried Apache and PHP for a local installation of WordPress and was not
happy with it. Too many settings that I didn't understand.

On Sat, 27 Apr 2019 at 12:29, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

>
>
> > On Apr 26, 2019, at 9:49 PM, Cricket Onebit 
> wrote:
> >
> > On Fri, 26 Apr 2019 at 22:14, Tommy Trussell 
> > wrote:
> >
> >>
> >> On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit <
> cricketbeauti...@gmail.com>
> >> wrote:
> >>
> >>> The speed thing is disappointing. I thought 3.5 fixed that, but maybe
> not
> >>> enough. I planned to save as XML to get going, since the docs say it's
> more
> >>> stable, then try SQLite.
> >>>
> >>
> >> The "standard" XML files are quick enough for me, though as time goes on
> >> it does take longer to load. I have never tried the database formats;
> the
> >> only upside (at the moment) is they give you some additional nerdy
> >> reporting options.
> >>
> >
> > Don't tempt me. I've spent enough hours learning "just enough" of
> > half-a-dozen languages for various projects that never quite did what I
> > wanted.
>
> Using the Sqlite backend I get one file that I can either use an sqlite
> viewer/query editor on, or using piecash, query directly for any custom
> report I want that isn’t offered by GnuCash. And I don’t have to mess with
> a MySQL db server. (which is fine, but if you don’t really *need* to...)
>
> I also get instant saves as I enter each transaction so no waiting around
> while it writes that massive file back to disk every 10 minutes or so.
>
> Let that temptation sink in.
>
> Regards,
> Adrien
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Changing account tree on large database

[Cricket Onebit]

I wish I'd thought of a separate account for what we owe her / she owes us
earlier, sigh, and one for our son to keep things even. I didn't record
things consistently because no method felt "right", and some is on a
separate spreadsheet.

The current plan is print out anything that affects her and do a
spreadsheet. It's fast and reliable, and time is short. (If she turns 18
before I finish, we have to formally get her permission to take money from
her savings account. Not a big deal, but one more step. Although, maybe it
would be best if we waited. A last-minute money grab looks bad.)


On Sat, 27 Apr 2019 at 12:21, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

>
>
> > On Apr 26, 2019, at 8:49 PM, Cricket Onebit 
> wrote:
> >
> >
> >
> > (Aside: https://wiki.gnucash.org/wiki/FAQ#SQL_Database recommends not
> using
> > the SQL just yet. Several posts on this list say otherwise. Out of date
> > manual, or optimistic / lucky users?)
>
> There was some display issue with business info when I first moved from
> 2.6.19 to 3.0, but that was fixed quickly and no data was lost. That is the
> only issue I’ve encountered personally, but you can check out Bugzilla and
> read over the SQL bugs to see if they scare you away from it, or you find
> you can live with them. (I’m using Sqlite3 backend for a few years now)
>
> >
> > I do need to calculate how much the kids owe us for things they said
> they'd
> > pay us back for. The cheques we wrote are in Quicken, but I didn't split
> > the transactions into "we pay / kid owes" at the time. That mess goes
> back
> > to 2010. I handled each big expense differently. I'll use a spreadsheet
> for
> > the final report rather than trying to get one from Quicken.
>
> I created a tree of accounts under `Assets:Current Assets` like so:
>
> Reimbursements:Family
> Reimbursements:Friends
>
> and then an account for each person under those. I have 5 siblings and we
> often consolidate large gift buys for our parents among other expenses, so
> I use these to track who owes me or who I owe. I have an account for each
> of my parents as well. Sometimes they give me money to buy something for
> them. I’ll first debit it to cash and credit their reimbursement account,
> and then debit their account and credit cash when I make the purchase. I
> don’t involve my expense accounts in this case because it was just a
> pass-through. Those aren’t *my* expenses. I suppose it could get a little
> messier involving cards or bank transfers/deposits but the idea is the
> same. For shared expenses like a large gift, I’ll only expense my portion
> and the rest goes through the reimbursement accounts.
>
> I suppose you could place these under Liabilities instead, but since the
> case is usually that my family owes me, I put them under assets. The sign
> of the balance will tell me which it really is.
>
> Regards,
> Adrien
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Quicken import and duplicate records

[Cricket Onebit]

Can someone edit that page in the wiki? It would help new users a lot.

On Mon, 29 Apr 2019 at 17:00, David Carlson 
wrote:

> The wiki that David Cousins pointed you to does not mention the fact that
> GnuCash can only find duplicates to transactions that already exist in the
> data.  Thus to avoid duplicates it is best to import one account at a time
> and to use use the GnuCash transaction matching feature to identify
> duplicates.
>
> David Carlson
>
> On Mon, Apr 29, 2019, 2:52 PM Priit Lilleleht 
> wrote:
>
> > Hi David C!
> >
> > Thank You, I have read the Quicken migration page in Wiki and probably
> > followed it mostly except for splitting the import into smaller pieces.
> The
> > first try was importing all 18 years of data at once. It took some time
> but
> > generally succeeded. I'll try to import just a few accounts to see if it
> > helps.
> >
> > I would like to have all the financial history in one database so
> importing
> > only last years or so does not appear appealing (as the migration page
> > suggests)...
> >
> > Best Regards,
> > Priit
> >
> > Kontakt David Cousens () kirjutas kuupäeval P,
> > 28. aprill 2019 kell 00:51:
> >
> > > Priit,
> > >
> > > Are you following the suggestions on the following Wiki page
> > > https://wiki.gnucash.org/wiki/Quicken_Migration.
> > >
> > > David Cousens
> > >
> > >
> > >
> > > -
> > > David Cousens
> > > --
> > > Sent from:
> > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Changing account tree on large database

[Cricket Onebit]

Very happy about the reports and tags.

Yes, I always take backups (and backups of backups). Dad used to design
hardware for telephone switching systems that absolutely had to work, and
Mom was an inaugural member of the 8-hours-lost club with 5-1/4 floppies.
The first computer I bought for myself (early Mac) was really stupid when
you saved a file. It started by deleting the current copy! Also, my husband
programs financial software.

So, yes, I keep multiple, labeled backups, and assume any equipment will
start smoking at any time.

On Sat, 27 Apr 2019 at 12:07, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

>
>
> > On Apr 26, 2019, at 4:28 PM, Cricket Onebit 
> wrote:
> >
> >
> >
> > Also, for this particular example, I’d opt for tags for each kid instead
> of accounts, see below about Cars.
> >
> > I didn't think GNUCash supported tags. I plan to use #tagone in a text
> field. That's one of the things I need to do in Quicken. Search for each
> transaction using a label, and put it in a text field. Problem: The text
> fields are short. Maybe I'll create accounts/categories for each tag, and
> add a $0.01 line. That will at least preserve the info. Then in GC edit
> again to put the tags in a text field and undo the $0.01 split. (Not $0
> because I think Quicken ignores $0 lines.)
> >
>
> There’s no official ’tag’ support, but some reports let you filter based
> on text in certain fields and you can use regular expressions if you like.
>
> >
> >
> > Does it also do that for a Transaction, Group by (sub-)account report? I
> use that one a lot. There's probably something close enough.
>
> The Transaction Report does this by default. I currently have a report
> open that is tracking my expenses at a Festival this weekend. I reload the
> report each day and it show my transactions with sub-account totals for
> amounts spent on Food, Beer, tips, etc. Each transaction has the festival
> name in the Notes field and I’m using that as a ’tag’ filter.
>
>
> > ++
> >
> > Enough stalling. Today's goal is to replace all the investment accounts
> with basic accounts. Apparently migrating investments isn't reliable. I
> won't lose any data because I haven't tracked investment details in Quicken
> in years. Also create appropriate income/loss accounts for the investment
> accounts so the year-end balances work. And, of course, lots of pre/post
> change reports to catch problems.
> >
>
> Work on a copy of the export and if something blows up, you won’t lose
> anything.
>
> Regards,
> Adrien
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Changing account tree on large database

[Cricket Onebit]

Yep, that's my plan. Quicken has a bulk-edit feature that I'll make good
use of. When I get around to it. Too many emergency late nights last week
to tackle something I need to be awake for.

For now, I've decided to do the urgent report in Quicken, then worry about
the conversion. I'd hoped to do the conversion before then, but then I'd
miss the deadline for the report.

Thanks!

On Sat, 27 Apr 2019 at 10:33, Greg Feneis  wrote:

> Alternatively, Cricket, instead of exporting from Quicken, then arranging
> things as you like, then importing to GnuCash, or some variation of that,
> you could make a copy of your Quicken working file and from within Quicken,
> arrange things as you like with a mind toward exporting to GnuCash, then
> export from Quicken and import to GnuCash.  At one point, I recall trying
> to decipher OFX or QIF files.  I found that exporting the same data as CSV
> and opening in Excel gave me good hints about what I was looking at in the
> OFX or QIF
>
>
>
>
> Kind regards,
>
> Greg Feneis
>
>
>
>
> On Fri, Apr 26, 2019 at 8:06 PM Cricket Onebit  >
> wrote:
>
> > >
> > > You WILL almost certainly see some strangeness in the imported data
> > > because Quicken doesn't strictly enforce balanced transactions as
> GnuCash
> > > does. When you're just dealing with a few years, you may find it easy
> to
> > go
> > > back and fix the odd strange transactions in Quicken, and start the
> > import
> > > over from scratch.
> > >
> >
> > That's my first choice. I already checked for uncategorized transactions,
> > and will remove the few stock purchases. Any other risky types?
> >
> > It seems like I started with the default GnuCash accounts, and worked
> from
> > > a printout of my Quicken accounts and categories, and created them in
> > > GnuCash beforehand. That made the transfer happen much faster because I
> > > wasn't creating new accounts as I went along.
> > >
> >
> > I remember letting GnuCash get the accounts from the QIF worked 2 years
> > ago. It was other things that didn't work. That method might affect its
> > ability to catch transfers. (Another reason I prefer double-entry
> > accounting. One transaction with many accounts, rather than two
> > transactions.)
> >
> >
> > > You might also try exporting just however many years of data from a
> > single
> > > bank account at a time until you have them all. Unless I'm
> > mis-remembering,
> > > I think the only places you'll have duplicate transactions will be
> those
> > > places where you transferred money BETWEEN the bank accounts.
> > >
> >
> > There are a lot of transfers, about 10 a month, with credit cards,
> mortgage
> > and car loan, and cash withdrawals.
> >
> > I think I'm ready for the next set of tests, hopefully in a few days.
> >
> > Good luck!
> > >
> >
> > Thanks! If the program is as good as the community, I'll be very happy.
> >
> > +++
> >
> > Not as a ladder from earth to Heaven, not as a witness to any creed,
> > But simple service simply given to his own kind in their common need.
> > -- Rudyard Kipling
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Create entry for vendor

[Adrien Monteleone]

So your line item in the bill would be an Inventory account of type asset. 
(Inventory is generally not an expense until you sell it, then you expense a 
special account called ‘Cost of Goods Sold’)

The result will debit (increase) the Inventory asset and credit (increase) your 
Accounts Payable account. (you should post the bill to Accounts Payable)

Regards,
Adrien


> On May 6, 2019, at 4:29 PM, Kebcoinc  wrote:
> 
> I just cannot remember
> I need to create a transaction for one of my vendors
> I know I need to increase the liability for this vendor
> but what would I decrease to balance?
> 
> I am actually increasing my inventory and increasing the liability
> 


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

[Derek Atkins]

Kebcoinc  writes:

> I just cannot remember.
> When I am entering a transaction for one of my vendors,
> I ordered some inventory,
> I want to increase the liability for this vendor
> What would I decrease to balance?

Your inventory asset account.

> I'm actually increasing my inventory and increasing my liability

Right.  If you credit the vendor and debit inventory, it will "increase"
both (because a liability is a "negative" account).

> 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] Okay, why won't it let me restore from backup?

[Derek Atkins]

ToddAndMargo via gnucash-user  writes:

> I restore yesterday's file and still get today's booboo

You restored the XXX.gnucash file, which is just your data.

> Why won't it let me restore from backup?

Because you didn't restore the METADATA file, which contains your open
tabs.  This would be the XXX.gcm file that would need to be restored.

> 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] undo close?

[Derek Atkins]

Hi,

ToddAndMargo via gnucash-user  writes:

> Hi All,
>
> If you accidentally hit "Close", is there a way to undo it other
> than from backup (which is what I did)?

Which "close" did you accidentally hit, and where did you "hit" it?
There are several options that come to mind:

1) The "Close Book" Tools-menu item
2) The [x] in the upper corner of the window (usually top-right in the
   titlebar area).  This is the window-manager "close" and can cause
   GnuCash to exit.   
3) The [x] in the tools-icon-row, which closes the current tab

In the case of '2', it will close all tabs in the window.  If this is
the only window you have open, it will exit gnucash.

In the case of '3', it depends which window/tab you were in when you hit
the button.

It SOUNDS like you did '3' in the Chart of Accounts tab.  GnuCash
*TRIES* to prevent you from doing this, but if you have multiple windows
open you can still get it to happen.  In this case, going to View -> New
Accounts Page will create a new Chart of Accounts tab.

Note that there is NOTHING you can do in the GnuCash window to delete
your data en-masse.  So there is no reason to have to "restore from
backup" here.

Hope this helps,

> Many thanks,
> -T

> 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] undo close?

[Colin Law]

On Tue, 7 May 2019 at 11:45, ToddAndMargo via gnucash-user
 wrote:
>
> On 5/7/19 3:17 AM, Colin Law wrote:
> > What popup tooltip do you see if you hover over the Close button that
> > you posted an image of?
> >
> > Colin
>
> I am too chicken to do it again.

I am not asking you to click it, just hover over it to see what the popup says.

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

[Sachin Danave]

Sorry for the late reply

Have not been accessing my emails.

For now, I will keep my focus on the non-technical part :) and stick to the
Excel option ...

Thanks for the help

Sachin

On Tue, May 7, 2019 at 2:25 AM Klaus Dahlke  wrote:

> Alternative is to use a database (mysql, postgres, SQLite) and e.g.
> libreoffice as GUI frontend for reporting/dataretrieval. Clearly, still
> some basic SQL know might be required.
>
> Cheers,
> Klaus
>
> On Wed, 1 May 2019 00:57:50 -0500
> Adrien Monteleone  wrote:
>
> > Unless you’re up for learning SQL, there is an easier path if all you
> want are pretty reports.
> >
> > You can copy/paste reports to a spreadsheet and manipulate from there.
> >
> > You can get part of the way to a ‘dashboard’ with the multi-column
> report. Look into it.
> >
> > Otherwise, probably an intermediate step would be to use the SQlite
> backend paired with piecash for your report queries.
> >
> > Maintaining and setting up a MySQL db is certainly more involved.
> >
> > Regards,
> > Adrien
> >
> > > On Apr 30, 2019, at 11:07 PM, Sachin Danave 
> wrote:
> > >
> > > Hi All,
> > >
> > > I am not a programmer and have been using MS Money for years. While I
> love
> > > the Gnucash features, I miss the MS Money colorful reports (and yes a
> > > beautiful dashboard).
> > >
> > > I came across a post (I think it was Reddit) that suggests that you can
> > > save Gnucash file to a MySQL database and then use an external
> > > reporting tool to generate custom reports.
> > >
> > > Has anyone tried this ? How difficult it is assuming no programming
> > > knowledge ?
> > >
> > > Thanks in advance
> > >
> > > Best Regards
> > >
> > > Sachin
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] undo close?

[ToddAndMargo via gnucash-user]

On 5/7/19 3:02 AM, Liz wrote:

On Tue, 7 May 2019 02:37:36 -0700
ToddAndMargo via gnucash-user  wrote:


Liz

Hi Liz,
I think there is some misunderstanding.  I pressed the "Close"
button, as in "close and archive the account".  I did not close the
"Tab". I know how to get the tabs back.
-T



I did remark before that you needed to give more detail, and that is another 
example.

Liz


That was what made me think about what could be the misunderstanding

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

[ToddAndMargo via gnucash-user]

On 5/7/19 3:17 AM, Colin Law wrote:

What popup tooltip do you see if you hover over the Close button that
you posted an image of?

Colin


I am too chicken to do it again.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Okay, why won't it let me restore from backup?

[ToddAndMargo via gnucash-user]

On Tue, May 7, 2019, 3:09 AM ToddAndMargo via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


On 5/7/19 12:08 AM, Colin Law wrote:
 > What exactly did you do when you tried to restore it from backup?
 > Without knowing what backup s/w or strategy you use we are in the
dark
 > on what you actually did.

What backup means is that I have copies of the data file squirrels away
wher Gnu Cash can't find them.  I restored yesterday's file to
the target directory where GnuCash does look.  I got back the same
closed account.  When I let GnuCash i on the secret as to where
the backups were, it ran the prior day's properly.  I then used
"Save As" to put it back where it normally resides and remove
GnuCash from seeing the backup archines.

Why it worked the second way and not the first is the mystery.



On 5/7/19 2:59 AM, David Carlson wrote:

ToddAndMargo,

GnuCash keeps information about some details such as which account 
windows were left open and their size and locations on the screen when 
you closed your data file in a different folder on your computer.  This 
information is called your preferences and it is a good idea to 
occasionally save a copy of them in a backup folder.  There is 
information online at gnucash.org  about how to find 
your preferences depending on the computer os and the version of GnuCash.


If you have saved any custom reports you should also back them up in the 
same way as you back up your preferences.


David Carlson




Hi David,

Ah Ha!  You pegged it:

~]$ find . -iname \*gnucash\*
./.local/share/gnucash
...
./.config/gnucash

Thank you!

-T



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

Re: [GNC] Okay, why won't it let me restore from backup?

[ToddAndMargo via gnucash-user]

On 5/7/19 2:58 AM, Colin Law wrote:

On Tue, 7 May 2019 at 09:09, ToddAndMargo via gnucash-user
 wrote:


I got back the same closed account.


If you had deleted the original file and replaced it with the new one
there is no way that it could have opened the old one (as it no longer
existed).
In fact do you actually mean that it opened the file but did not show
the Accounts page where you can see all the accounts?  If so then, as
has been said in another thread, all you needed to do was to click
File > New Accounts Page to open it.

The reason it automatically opened an Accounts Page when you did File

Open is because it thought it was opening a file it had not seen

before so brought up the default view.  When you let it automatically
open the one from the backup it thought it was re-opening the original
file so restored the pages that you had previously, which was none.

Colin



First I just renamed the file *.bad, then restored.  That
did not work.

Then I created a temporary directory and moved all of the gnucash 
entries, logs and all into it, so the main directory was

empty of all gnucash files.  Then restored it again.  It did not
work either.

What did the trick was running it from backup and using Save-As




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

[ToddAndMargo via gnucash-user]

On 5/7/19 3:06 AM, Liz wrote:

On Tue, 7 May 2019 02:37:36 -0700
ToddAndMargo via gnucash-user  wrote:


Hi Liz,
I think there is some misunderstanding.  I pressed the "Close"
button, as in "close and archive the account".  I did not close the
"Tab". I know how to get the tabs back.
-T


You need to think back to basic principles, and work out what "close
the books" does.
It puts in entries which zero out certain accounts and moves balances
to Equity.
So if you were looking for how you could deal with the situation, you
could start at those transactions.

Liz


I did not do it on purpose.  I did it because I am a "KLUTZ".

I restored from backup.

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

[ToddAndMargo via gnucash-user]

On 5/7/19 3:02 AM, Colin Law wrote:

What do you see if you click View > Filter By, both Account Type and
Other tabs therein.
Also show us the whole window please for the Accounts tab

Colin


I restored from backup.

It currently says "Show 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] undo close?

[Colin Law]

What popup tooltip do you see if you hover over the Close button that
you posted an image of?

Colin

On Tue, 7 May 2019 at 10:49, ToddAndMargo via gnucash-user
 wrote:
>
> On 5/7/19 2:37 AM, ToddAndMargo via gnucash-user wrote:
> >   I did not close the "Tab".
>
> The "Tab" did not close.  It was still there.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] undo close?

[Liz]

On Tue, 7 May 2019 02:37:36 -0700
ToddAndMargo via gnucash-user  wrote:

>Hi Liz,
>I think there is some misunderstanding.  I pressed the "Close"
> button, as in "close and archive the account".  I did not close the
> "Tab". I know how to get the tabs back.
>-T

You need to think back to basic principles, and work out what "close
the books" does.
It puts in entries which zero out certain accounts and moves balances
to Equity.
So if you were looking for how you could deal with the situation, you
could start at those transactions.

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

[Colin Law]

What do you see if you click View > Filter By, both Account Type and
Other tabs therein.
Also show us the whole window please for the Accounts tab

Colin

On Tue, 7 May 2019 at 10:49, ToddAndMargo via gnucash-user
 wrote:
>
> On 5/7/19 2:37 AM, ToddAndMargo via gnucash-user wrote:
> >   I did not close the "Tab".
>
> The "Tab" did not close.  It was still there.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Create entry for vendor

[Kebcoinc]

I just cannot remember
I need to create a transaction for one of my vendors
I know I need to increase the liability for this vendor
but what would I decrease to balance?

I am actually increasing my inventory and increasing the liability

Thanks



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

[GNC] Question about offset entery for inventory

[Kebcoinc]

I just cannot remember.
When I am entering a transaction for one of my vendors,
I ordered some inventory,
I want to increase the liability for this vendor
What would I decrease to balance?

I'm actually increasing my inventory and increasing my liability
Thanks



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

Re: [GNC] undo close?

[Liz]

On Tue, 7 May 2019 02:37:36 -0700
ToddAndMargo via gnucash-user  wrote:

> Liz
> 
>Hi Liz,
>I think there is some misunderstanding.  I pressed the "Close"
> button, as in "close and archive the account".  I did not close the
> "Tab". I know how to get the tabs back.
>-T


I did remark before that you needed to give more detail, and that is another 
example.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Okay, why won't it let me restore from backup?

[David Carlson]

ToddAndMargo,

GnuCash keeps information about some details such as which account windows
were left open and their size and locations on the screen when you closed
your data file in a different folder on your computer.  This information is
called your preferences and it is a good idea to occasionally save a copy
of them in a backup folder.  There is information online at gnucash.org
about how to find your preferences depending on the computer os and the
version of GnuCash.

If you have saved any custom reports you should also back them up in the
same way as you back up your preferences.

David Carlson



On Tue, May 7, 2019, 3:09 AM ToddAndMargo via gnucash-user <
gnucash-user@gnucash.org> wrote:

> On 5/7/19 12:08 AM, Colin Law wrote:
> > What exactly did you do when you tried to restore it from backup?
> > Without knowing what backup s/w or strategy you use we are in the dark
> > on what you actually did.
>
> What backup means is that I have copies of the data file squirrels away
> wher Gnu Cash can't find them.  I restored yesterday's file to
> the target directory where GnuCash does look.  I got back the same
> closed account.  When I let GnuCash i on the secret as to where
> the backups were, it ran the prior day's properly.  I then used
> "Save As" to put it back where it normally resides and remove
> GnuCash from seeing the backup archines.
>
> Why it worked the second way and not the first is the mystery.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Okay, why won't it let me restore from backup?

[Colin Law]

On Tue, 7 May 2019 at 09:09, ToddAndMargo via gnucash-user
 wrote:
>
> I got back the same closed account.

If you had deleted the original file and replaced it with the new one
there is no way that it could have opened the old one (as it no longer
existed).
In fact do you actually mean that it opened the file but did not show
the Accounts page where you can see all the accounts?  If so then, as
has been said in another thread, all you needed to do was to click
File > New Accounts Page to open it.

The reason it automatically opened an Accounts Page when you did File
> Open is because it thought it was opening a file it had not seen
before so brought up the default view.  When you let it automatically
open the one from the backup it thought it was re-opening the original
file so restored the pages that you had previously, which was none.

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

[ToddAndMargo via gnucash-user]

On 5/7/19 2:37 AM, ToddAndMargo via gnucash-user wrote:

  I did not close the "Tab".


The "Tab" did not close.  It was still there.

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

[ToddAndMargo via gnucash-user]

   On 5/6/19 11:22 PM, Liz wrote:

On Mon, 6 May 2019 19:35:24 -0700
ToddAndMargo via gnucash-user [1] wrote:


Hi All,

If you accidentally hit "Close", is there a way to undo it other
than from backup (which is what I did)?

Many thanks,
-T

Start here
[2]https://wiki.gnucash.org/wiki/FAQ#Q:_Somehow_I_managed_to_close_the_account_v
iew_tab._How_can_I_get_it_back.3F
After that, in the account tab, double click on accounts you want to
see open.

Don't Panic *

*[3]https://www.bustle.com/articles/25640-dont-panic-18-indispensable-life-lesso
ns-from-the-hitchhikers-guide-to-the-galaxy-series

Liz

   Hi Liz,
   I think there is some misunderstanding.  I pressed the "Close" button,
   as in "close and archive the account".  I did not close the "Tab".
   I know how to get the tabs back.
   -T

References

   1. mailto:gnucash-user@gnucash.org
   2. 
https://wiki.gnucash.org/wiki/FAQ#Q:_Somehow_I_managed_to_close_the_account_view_tab._How_can_I_get_it_back.3F
   3. 
https://www.bustle.com/articles/25640-dont-panic-18-indispensable-life-lessons-from-the-hitchhikers-guide-to-the-galaxy-series
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Okay, why won't it let me restore from backup?

[ToddAndMargo via gnucash-user]

On 5/7/19 12:08 AM, Colin Law wrote:

What exactly did you do when you tried to restore it from backup?
Without knowing what backup s/w or strategy you use we are in the dark
on what you actually did.


What backup means is that I have copies of the data file squirrels away 
wher Gnu Cash can't find them.  I restored yesterday's file to
the target directory where GnuCash does look.  I got back the same 
closed account.  When I let GnuCash i on the secret as to where

the backups were, it ran the prior day's properly.  I then used
"Save As" to put it back where it normally resides and remove
GnuCash from seeing the backup archines.

Why it worked the second way and not the first is the mystery.

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

[ToddAndMargo via gnucash-user]

   On 5/7/19 12:11 AM, Colin Law wrote:

On Tue, 7 May 2019 at 08:06, ToddAndMargo via gnucash-user
[1] wrote:


   GnuCash 2.3 and later
 View -> New Accounts Page

Q&A speakth with forked tongue.  Translation.  "You can't.  You
have to start over.  HAHAHAHAH."

Panic?  What me panic?  Good think I am a backup whore.  That
did work, eventually.

Wrong, it is "New Accounts Page" not "New Set of Accounts".  New Page,
not New Accounts.  All it does is to reopen the page that you closed.
Closing the page and re-opeing has not effect on the accounts file.

Colin

   Guess I am about to find out if this list will take HTML!
   That is where I was:
   And yes, I opened it.  I got back the singe line of the closed account.
   It was still closed.

References

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

[Colin Law]

On Tue, 7 May 2019 at 08:06, ToddAndMargo via gnucash-user
 wrote:

>GnuCash 2.3 and later
>  View -> New Accounts Page
>
> Q&A speakth with forked tongue.  Translation.  "You can't.  You
> have to start over.  HAHAHAHAH."
>
> Panic?  What me panic?  Good think I am a backup whore.  That
> did work, eventually.

Wrong, it is "New Accounts Page" not "New Set of Accounts".  New Page,
not New Accounts.  All it does is to reopen the page that you closed.
Closing the page and re-opeing has not effect on the accounts file.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Okay, why won't it let me restore from backup?

[Colin Law]

What exactly did you do when you tried to restore it from backup?
Without knowing what backup s/w or strategy you use we are in the dark
on what you actually did.

Colin

On Tue, 7 May 2019 at 03:44, ToddAndMargo via gnucash-user
 wrote:
>
> I restore yesterday's file and still get today's booboo
>
> Why won't it let me restore from backup?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] undo close?

[ToddAndMargo via gnucash-user]

On 5/6/19 11:22 PM, Liz wrote:

On Mon, 6 May 2019 19:35:24 -0700
ToddAndMargo via gnucash-user  wrote:


Hi All,

If you accidentally hit "Close", is there a way to undo it other
than from backup (which is what I did)?

Many thanks,
-T


Start here
https://wiki.gnucash.org/wiki/FAQ#Q:_Somehow_I_managed_to_close_the_account_view_tab._How_can_I_get_it_back.3F
After that, in the account tab, double click on accounts you want to
see open.

Don't Panic *

*https://www.bustle.com/articles/25640-dont-panic-18-indispensable-life-lessons-from-the-hitchhikers-guide-to-the-galaxy-series

Liz




Hi Liz,

Q: Somehow I managed to close the account view tab. How can
   I get it back?

A: A new account view tab can be opened from the menu. This
   is slightly different depending on the version of GnuCash
   you are using:

  GnuCash 2.3 and later
View -> New Accounts Page

Q&A speakth with forked tongue.  Translation.  "You can't.  You
have to start over.  HAHAHAHAH."

Panic?  What me panic?  Good think I am a backup whore.  That
did work, eventually.

Thank you!

-T




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