Re: [GNC] Simple reporting help

[Michelle]

I guess that report is still experimental in the Linux version :-)
The Mint repos still have a build from 2019-12-29. V3.8

Thanks for making me aware of it though. I'll keep an eye on it.

On Mon, 2020-10-26 at 11:49 -0500, Gal wrote:
> Another way to achieve what you're looking for is to select Reports
> -->
> Experimental --> Income Statement (Multicolumn)
> 
> Then select the relevant account in the Accounts Tab, and select
> "Year" in
> the Period duration dropdown list in the General tab.
> 
> 
> 
> --
> 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] gnucash question

[John Ralls]

> On Oct 25, 2020, at 11:53 AM, Ed Anderson  wrote:
> 
> Hi,
> Does anyone know how to turn this off? "Acquiring lock"
> 
> [image: image.png]
> 

You can't turn it off. It's locking your aqbanking config file and if that's 
not instantaneous then either you're trying to keep that file on a remote drive 
with a slow connection or there's something wrong with your hard disk.

Regards,
John Ralls

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

Re: [GNC] gnucash question ("Acquiring lock")

[Stan Brown]

It's not some optional feature that you can turn off. The "lock" is a
sentinel file, to prevent you (or multiple people) from carelessly
opening multiple copies of the same file at the same time.

But normally the lock file is created in an instant, or if one already
exists you get a failure message in an instant. The fact that your copy
is having trouble _acquiring_ the lock (checking for the lock file's
existence, or creating one) suggests to me that there is some system
problem, like a full disk drive, a read-only directory, or something
else that is doing a lot of heavy disk activity at the same time.

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
https://OakRoadSystems.com

On 2020-10-25 11:53, Ed Anderson wrote:
> Hi,
> Does anyone know how to turn this off? "Acquiring lock"
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Simple reporting help

[Gal]

Another way to achieve what you're looking for is to select Reports -->
Experimental --> Income Statement (Multicolumn)

Then select the relevant account in the Accounts Tab, and select "Year" in
the Period duration dropdown list in the General tab.



--
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] Simple reporting help

[Michelle]

Hi Geoff,

That did the trick. Many thanks.

I do wish that on the General tab, Start date drop down, that they had
an option for, "Since the beginning of time." :-)

But that's given me exactly what I need. 

Many thanks for your help,

Michelle.


On Mon, 2020-10-26 at 22:24 +1100, Geoff wrote:
> Hi Michelle
> 
> One way to achieve this is to use the Transaction Report.
> 
> After selecting the relevant Account(s), stay in Options and tick 
> "Subtotal Table" on the Display tab, then select "Date" as the
> Primary 
> Key and "Yearly" as the Primary Subtotal on the Sorting tab.
> 
> You should get the subtotals at the start of the report, followed by
> all 
> the transactions.
> 
> See attached screenshot.
> 
> Hope this helps.
> 
> Regards
> 
> Geoff
> =
> 
> On 26/10/2020 8:39 pm, Michelle wrote:
> > Apologies for a newbie question. I've been using GnuCash for many
> > years
> > but I do little reporting with it.
> > 
> > What I'm trying to do is look at annual expenditure for a specific
> > account/catagory.
> > 
> > eg. I have - -cat:Car:Fuel ... and I want to know how much I've
> > spent
> > on fuel each year, over the last ten years.
> > 
> > I've tried a number of report options, but I'm not hitting the
> > right
> > report.
> > 
> > Could someone kindly help please.
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Simultaneous Users? Cloud Access? Split FE & BE?

[Fran_3 via gnucash-user]

 Thanks Will. 

That is more or less what i was talking about when I talked about "splitting" a 
Microsoft Access database so the data was on one computer (the server) and the 
user interface with the Microsoft Jet database engine, custom queries, data 
entry forms, reports, etc was on another. 

Ditto for writing the html/php/java script code for storing and retrieving data 
from an online Microsoft or Linux host computer/server.
When this division of ~data and ~code occurrs properly you can have multiple 
users access and, with proper protections, manipulate the data at the same time.

Regarding GnuCash... I view it, more or less, as two parts...1 - the code to 
get, store, manipulate, retrieve, and present the users data to the user2 - the 
actual data itself... which I think is in XML.(There are other ways to see the 
GnuCash "parts" of course.)
With that "model" in mind I guess I was wondering if provisions had been for 
the data to be split off, stored on a server, and accessed by multiple users... 
each with their own "front end" (as I call it)
All that said, I guess I know enough to be dangerous :-)

As someone mentioned I should probably have read the FAQ's and other stuff 
before I posted this question.
On Monday, October 26, 2020, 1:06:59 AM EDT, w...@theprescotts.com 
 wrote:  
 
 Just to chime in on the terminology...

In my current job I do back-end development for an NGO. We have another 
developer who works on the front end and a couple people working on a mobile 
app.

The back end is an application that runs on an Amazon Web Service instance. The 
front end is a web app that users use to communicate with the back end. The 
data is stored in a data base that the back end talks to. The back end has an 
API (Application Programming Interface) and the front end and mobile app both 
make https calls to the back end to talk to it as well as using some other 
protocols.

I believe this structure is common and what most developers have in mind when 
they refer to a back end and a front end. Stand alone applications like Gnucash 
probably would not normally be considered to have a back end or front end.

Will

On 2020 Oct 25, at 10-25 21:11:11, Fran_3 via gnucash-user 
 wrote:

Thanks Jim. Regarding Front End and Back End... 

When I used to develop Microsoft Access databases I would split it such 
that...- All the data was stored on a local peer-to-peer server. We called that 
the "Back End"
- The "Front End" would have the user interface with the queries, data entry 
forms, reports, etc. And, if I remember correctly, this could actually be 
different for each user of the mdb database so some people had easy access to 
certain things... like data entry only, etc.
In recent times I've been developing online databases with MySQL and PHP. In 
this case the "front end" would be the queries, etc coded in PHP while 
everything else would live in a MySQL database on the web server.
At least that is the language I've used to describe things to myself.



  On Sunday, October 25, 2020, 4:37:26 PM EDT, Jim DeLaHunt 
 wrote:  

On 2020-10-25 08:29, Fran_3 via gnucash-user wrote:

> - I have always considered GnuCash as a program that must be installed on the 
> local machine.
> - With the myBiz.gnucash file also on the local machine.
> - This means that two users can not open GnuCash on their respective machines 
> and access the myBiz.gnucash data file at the same time...
> 1 - Right so far?
> 2 - Am I also correct in assuming that the gnucash.exe is essentially the 
> data base's front end while myBiz.gnucash is the back end containing all the 
> data?
> 3 - If so is there anyway to keep the back end with the data (myBiz.gnuCash) 
> in the cloud and point the frond end on your local machine (gnucash.exe) to 
> the data stored in the cloud... like maybe stored on MyDrive at Google or 
> where ever?
> Thanks for any help.

Fran:

There are Frequently Asked Questions (FAQs) about "Multiple Computers, 
Users, ..." 
. 
You will find some answers there, especially to your questions 1 and 3.

Also, Stan Brown's Oct 12 answer 
 
to your question, "Re: [GNC] Will the file myStuff.gnucash work on Linux 
& Windows machines?" is relevant.

Regarding the terms "front end" and "back end", in software engineering 
they have specific meanings which don't line up with your question #2. 
In general, all of your bookkeeping information (transactions, balances, 
chart of accounts) is stored in your book file, myBiz.gnucash, and none 
is stored in the GnuCash.exe program. Some of the data you rely on when 
using GnuCash, such as your preferences, custom reports, etc., are in 
preferences files which are neither in your book file nor in the 
GnuCash.exe program. The "multiple computers" FAQ linked to above talks 
about this a little.

Best regards,
      —Jim DeLaHunt, Vancouver, 

Re: [GNC] Simple reporting help

[Geoff]

Hi Michelle

One way to achieve this is to use the Transaction Report.

After selecting the relevant Account(s), stay in Options and tick 
"Subtotal Table" on the Display tab, then select "Date" as the Primary 
Key and "Yearly" as the Primary Subtotal on the Sorting tab.


You should get the subtotals at the start of the report, followed by all 
the transactions.


See attached screenshot.

Hope this helps.

Regards

Geoff
=

On 26/10/2020 8:39 pm, Michelle wrote:

Apologies for a newbie question. I've been using GnuCash for many years
but I do little reporting with it.

What I'm trying to do is look at annual expenditure for a specific
account/catagory.

eg. I have - -cat:Car:Fuel ... and I want to know how much I've spent
on fuel each year, over the last ten years.

I've tried a number of report options, but I'm not hitting the right
report.

Could someone kindly help please.

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

[Michelle]

Apologies for a newbie question. I've been using GnuCash for many years
but I do little reporting with it.

What I'm trying to do is look at annual expenditure for a specific
account/catagory.

eg. I have - -cat:Car:Fuel ... and I want to know how much I've spent
on fuel each year, over the last ten years.

I've tried a number of report options, but I'm not hitting the right
report.

Could someone kindly help please.

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

[Richard De Vriese]

Hello,
When I import transactions from my bank using OFX/QFX import I notice that
the imported data overwrites the Description and Notes fields. I would
prefer that the matching transaction be simply marked as Cleared and leave
the Description and Notes fields as the originally were entered into
GnuCash register. I've verified that only the C column is checked in the
Import dialog, but these two fields still are being overwritten. GnuCash
did not do this in previous releases, e.g. checking the C column in the
import dialog resulted in the matching transaction being cleared, but
unmodified in any other way. Is this a known issue, or am I
misunderstanding the use of the C column?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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 question

[Ed Anderson]

Hi,
Does anyone know how to turn this off? "Acquiring lock"

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