GnuCash: Multiple Views Of Data

[Charles Sliger]

Switching from QuickBooks to GnuCash.
Q: Is there any facility in GnuCash that allows you to create multiple
views (reports, etc) of your financial data?
In QuickBooks you can use what they call a "Class" to provide an
alternate grouping of records that can be used in reports.
What would be even better would be the ability to assign a set of
keywords to data items (transaction, etc) that could then be used in
reports to look at the same item from multiple viewpoints (jobs,
projects, localities, financing streams, material lots, etc).
Does anything like this exist in GnuCash or is anything along these
lines in the works?
Regards,
-- 
-chaz
Charles Sliger
c...@bctonline.com
"No matter where you go... There you are... Buckaroo Banzai"





___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

budget

[Dennis Powless]

I'm trying to wrap my head around the budget.  I'm stuck on the carry over
each month.  Does this value go in the 'budget available' the next month
AND the income to be spent the next month.  Or, just in the income the next
month.  I don't think gnucash accounts for any of this, was trying to work
it out on a spreadsheet and then once I figure it out, was going to see how
I can add it into the budget.

D
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Deleting an invoice or credit

[John Morris]

Hi Derek,
  I'm noticed the problem in the Easy Invoice report in the past. I don't have 
time right now to confirm the problem still exists. Given the current state of 
development, I have no confidence that the problem has been eliminated.

Best,
John

> On Sep 20, 2017, at 10:33 AM, Derek Atkins  wrote:
> 
> John Morris  writes:
> 
>>> But you can edit it, including changing the customer involved and the
>>> invoice number. So the next time you need an invoice or credit note, you
>>> can just reuse this practice one instead of generating a new one.
>> 
>>  The only problem with this idea is that some ways of finding an
>> invoice do not notice the change in the invoice number. Therefore,
>> when I reuse an invoice like this, I have to remember that I won't
>> always be able to find the new invoice by invoice number.
> 
> What doesn't notice it?  That would be a bug.
> 
>> Best,
>> John
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Backup help

[Art via gnucash-user]

 I just read your message after I sent my previous one. I was using MYSQL 
master-slave
replication with my desktop servers and only running a client my laptop, but 
after realizing how quick the dump & restore was and how rarely I actually "go 
mobile", it was easier for me to just do the restore from the dump. However, 
your point is well taken. Since I already have the MySQL server running on my 
laptop, I can do a MYSQL master-slave replication. I just didn't think about 
it. Thanks!
- Art

On Tuesday, September 19, 2017, 11:28:30 PM EDT, DaveC49 
 wrote:  
 
 Hi Art, Roger

Just a quick comment. If you are using the MYSQL backend you can sync
databases on different machines reasonably easily using MYSQL master-slave
replication (https://dev.mysql.com/doc/refman/5.7/en/replication.html) as an
alternative to maintaining a mobile copy.

There is a bit of a learning curve in setting it up and some maintenance if
the databases do get out of sync. I use it on a Linux desktop and my Linux 
laptop to keep a number of application databases synced using SSL over my
LAN.  It syncs automatically whenever the laptop is connected to the LAN. I
haven't tried syncing from a Linux box to a Windows box but it shouldn't be
too much of a problem as it is all done in MYSQL configuration as long as
the basic underlying network connectivity is there. There can be timing
issues if the databases on different machines are updated at the same time
which are not generally a problem for a single user.

You can use the TinyCA (https://tinyca.alioth.debian.org/) to generate the
necessary SSL certificates. I set MySQL  both machines up as master-master
servers so that no matter which machine I make changes to the database they
are  duplicated to the other machine.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Backup help

[John Ralls]

> On Sep 20, 2017, at 1:35 AM, DaveC49  wrote:
> 
> Hi Colin,
> 
> i agree with both you and Bram there. It is not a reliable backup of the
> database but really only useful for sharing a database across several
> machines and worked well for the use case where my laptop was generally
> connected to my LAN and I worked away from home occasionally.  haven't had
> any experience with how it copes with simultaneous access and locking
> issues.  There is also the MYSQL Cluster as another approach. You also need
> to check that the replication is up to date and completed before assuming
> the databases are identical.  I use a cron job and mysqldump to dump  the
> databases  to an NAS for backup.

Um, wouldn’t it be easier to just use one of the machines as a server and 
connect to it with GnuCash from the other machines?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash on ArchLinux

[alarin]

Hey John

Do you know when is it going to happen when 2.8 is released? 
Problem is that none of the tips other guys suggested worked and in the 
meanwhile i found some other free accounting software but i still would like to 
test gnucash at some point.

B.wishes
Andres

--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com

16. Sep 2017 02:47 by jra...@ceridwen.us:


>
>
>> On Sep 13, 2017, at 2:16 PM, >> ala...@tuta.io>>  wrote:
>>
>> I have installed all the other programs with just this one command - sudo 
>> pacman -S xxx and seems like you are telling me that everything is fine with 
>> gnucash :) It even works on my Android tablet with no problem, but I find is 
>> easier to work with real keyboard.
>>
>> Is it not possible to fix it so that people can install it on Linux just 
>> with this one command? Seems like it is getting complicated..
>
> Sure, if the Linux distribution you use supports GnuCash. Arch has decided 
> not to, so you can either jump through the extra hoops they require, switch 
> to a distro that does, or switch to an accounting package that Arch does 
> support.
>
> Distros dropping GnuCash is due to our use of the WebKit1 API long after its 
> best-by date. GnuCash 2.8 will use WebKit2 and we expect that the distros 
> that have dropped support will restore it when 2.8 is released.
>
> Regards,
> John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Backup help

[DaveC49]

Hi Colin,

i agree with both you and Bram there. It is not a reliable backup of the
database but really only useful for sharing a database across several
machines and worked well for the use case where my laptop was generally
connected to my LAN and I worked away from home occasionally.  haven't had
any experience with how it copes with simultaneous access and locking
issues.  There is also the MYSQL Cluster as another approach. You also need
to check that the replication is up to date and completed before assuming
the databases are identical.  I use a cron job and mysqldump to dump  the
databases  to an NAS for backup.


David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Backup help

[Bram Mertens]

Colin,

You've got that correct. Replication, just like e.g. RAID protects against
some forms of data loss but it is not a full backup solution.

It could be part of it though, e.g. if running a more permanent backup from
the slave is easier than running it on the master.

MySQL/MariaDB have specific commands to create backups, look at mysqldump
for details.
As with all backups: it is important to test not only the backup part but
also the part of restoring it.  Depending on the options you set with
mysqldump the recovery part differs.
E.g. You may need to make sure you have a backup of the mysql user's
passwords, which is a separate task.

Regards

Bram

On Wed, Sep 20, 2017 at 9:59 AM Colin Law  wrote:

> Just to point out that database replication might not be considered a
> good form of backup. It copes with something like a disc crash but if,
> for example, a user or bug were accidentally to delete large sections
> of the db then that deletion would be copied to the slave database.
> Unless I misunderstand how replication works.
>
> Colin
>
> On 20 September 2017 at 04:27, DaveC49  wrote:
> > Hi Art, Roger
> >
> > Just a quick comment. If you are using the MYSQL backend you can sync
> > databases on different machines reasonably easily using MYSQL
> master-slave
> > replication (https://dev.mysql.com/doc/refman/5.7/en/replication.html)
> as an
> > alternative to maintaining a mobile copy.
> >
> > There is a bit of a learning curve in setting it up and some maintenance
> if
> > the databases do get out of sync. I use it on a Linux desktop and my
> Linux
> > laptop to keep a number of application databases synced using SSL over my
> > LAN.  It syncs automatically whenever the laptop is connected to the
> LAN. I
> > haven't tried syncing from a Linux box to a Windows box but it shouldn't
> be
> > too much of a problem as it is all done in MYSQL configuration as long as
> > the basic underlying network connectivity is there. There can be timing
> > issues if the databases on different machines are updated at the same
> time
> > which are not generally a problem for a single user.
> >
> > You can use the TinyCA (https://tinyca.alioth.debian.org/) to generate
> the
> > necessary SSL certificates. I set MySQL  both machines up as
> master-master
> > servers so that no matter which machine I make changes to the database
> they
> > are  duplicated to the other machine.
> >
> > David Cousens
> >
> >
> >
> > -
> > David Cousens
> > --
> > Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Backup help

[Colin Law]

Just to point out that database replication might not be considered a
good form of backup. It copes with something like a disc crash but if,
for example, a user or bug were accidentally to delete large sections
of the db then that deletion would be copied to the slave database.
Unless I misunderstand how replication works.

Colin

On 20 September 2017 at 04:27, DaveC49  wrote:
> Hi Art, Roger
>
> Just a quick comment. If you are using the MYSQL backend you can sync
> databases on different machines reasonably easily using MYSQL master-slave
> replication (https://dev.mysql.com/doc/refman/5.7/en/replication.html) as an
> alternative to maintaining a mobile copy.
>
> There is a bit of a learning curve in setting it up and some maintenance if
> the databases do get out of sync. I use it on a Linux desktop and my Linux
> laptop to keep a number of application databases synced using SSL over my
> LAN.  It syncs automatically whenever the laptop is connected to the LAN. I
> haven't tried syncing from a Linux box to a Windows box but it shouldn't be
> too much of a problem as it is all done in MYSQL configuration as long as
> the basic underlying network connectivity is there. There can be timing
> issues if the databases on different machines are updated at the same time
> which are not generally a problem for a single user.
>
> You can use the TinyCA (https://tinyca.alioth.debian.org/) to generate the
> necessary SSL certificates. I set MySQL  both machines up as master-master
> servers so that no matter which machine I make changes to the database they
> are  duplicated to the other machine.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.