Re: Version Migration

[David T. via gnucash-user]

The biggest problem with the database back end is users' misconception that its 
use implies database functionality. They think it will allow them to perform 
database actions on the data set,  as well as have multiple users 
simultaneously. As you know, neither of these is true at this time. 
David

 
 
  On Wed, Aug 30, 2017 at 1:04, Colin Law wrote:   On 29 
August 2017 at 19:12, D  wrote:
> ...
> The database back end is stable, and has been for a while now. There is
> nothing to prevent a user from making use of it, even for production.

OK, but note the OP is going to use 2.6.15, which was released in Dec
2016 I believe. I don't know whether there have been any significant
sql related bugs since then.

Even if not, then it cannot be denied that the xml backend has had
vastly more use than the sql backend. Certainly anyone using a db
should make sure they take regular backups of the db (which can be
trickier than just copying the xml file).

Colin  
___
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: Budget Slowing Down Windows 10

[Phil Longstaff]

I am aware of the very slow performance with budget. I have some ideas to
improve it but have not found time to put into it. It seems to only affect
Windows. It runs fine on linux.

Phil

On Fri, Aug 25, 2017 at 1:55 PM, Proberts042  wrote:

> Slow to me is several minutes.
>
> I have installed GnuCash on a Linux operating system (Ubuntu) and it seemed
> to work well. However, did not try the Budget feature there. I would like
> to
> use an open source operating system but sharing word processor files with
> my
> teachers and students proves difficult because Google Drive and LibreOffice
> render Word tables remarkably differently than Microsoft, and even make
> changes so that the documents are really different when run in Windows
> again. I know of no way to get around this. I hope that these problems are
> solved in the near future as I would love to use Linux machines
> exclusively.
> We want to move more toward open-source software systems. GnuCash, even
> with
> its limitations running in a Windows environment, is great (except for
> Budget). We have also started using OpenSiS-CE for our school information
> management system.
>
> So I guess I will wait for the software experts to see what they can do
> about this Budget thing. I would really like to use this feature for
> planning.
>
> Thanks for your help
>
>
>
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Budget-Slowing-Down-Windows-10-tp4693398p4693425.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> 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: Adding invoice numbers to business checks

[Cindy Ames]

Hi Derek,

On Mon, Aug 28, 2017 at 8:12 AM, Derek Atkins  wrote:

>
> Keep in mind that a payment could be applied to multiple invoices; it's
> not a 1:1 map.  So if there are multiple invoices, which number would
> you put into the transaction notes?
>
> I typically do pay multiple invoices with one transaction.  The template
I'm using is a voucher-style template, with the check at the top and two
copies of the voucher below which lists the individual invoice amounts,
prefaced with the accounts name, which in my case is "Liabilities:Accounts
Payable".  I'm not currently using this to print checks, I would just like
to be able to use this to easily print a list of invoices being paid that I
can supply to a vendor.  Instead of it listing the account name (the
template appears to be using "SPLITS_ACCOUNT") I'd like to just list the
bill id.  I've tried SPLITS_MEMO but it apparently doesn't contain any
data.  I'm not sure where the SPLITS_MEMO data would come from, perhaps the
Notes field when entering a new bill?  (I'll have to experiment with that.)


I'm referring to this for the possible fields to use in the template:
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/check_format_info.html.
I'm not seeing anything that corresponds to a bill ID number, though I'm
wondering if "ACTION" would get me what I'm looking for if I enable the
"Use Split Action for Field Number" in my Book Options (like it describes
in that URL) but I don't want to do that if I don't have to since the help
docs warn against changing that setting at any time other than your initial
setup.  I suppose I could make a backup before trying it, or else create a
new gnucash file to test it out in.


> Also, have you tried putting something into the "Memo" when you post the
> payment?  IIRC that should go into the Transaction Notes field, which
> should appear on the "memo" line of your printed check.
>
> No, I haven't, and I could manually enter all the invoice bill ID's there,
but if I can make my template automatically list them I would definitely
prefer that.

Regards,
Cindy
___
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: Version Migration

[Colin Law]

On 29 August 2017 at 16:36, james  wrote:
> Hello all,
>
> Background
> So I've been running on gnucash 2.4.11 for some years.
> it's been great, the only problems were my lack of
> knowledge of finance. I want to migrate to version 2.6.15
> (using gentoo linux).
>
>
> My only accounting problem is my depreciation does not match
> what the accountant has been doing. They are the authority,
> so It's entries on depreciation that need to be fixed.
>
> Note, I have never 'closed the books' since the beginning because
> I knew I need to fix the depreciation schedules on about (6) items.
> It's a small company. I've been sick off and on for (3) years
> running, so not much actively the last few years. I'm finally
> better and ready to resume active business.
>
> 
>
>
> So, should I fix the depreciation on the new version of gnucash
> (my preferred method) or on the old slow lappy and version 2.4.11?
>
>
> I'm in the process of installing a laptop to exclusively run gnucash,
> mostly offline (no physical internet) on gentoo linux (fav distro).
>
>
> Any documents I need to review before doing the migration to the new
> laptop? I have both scp and usb sticks for the migration.
>
> I think I want to use a database now, pgsql.
>
> hit me up with ideas, and whatever make me plan out this migration
> before starting...

If you do not have any saved reports then all you need to is to plug
the usb stick in the old machine, in GC use File > Save As to save
your accounts file to the stick, plug it in the new machine, open GC
and use File > Open to open it from the stick then File > Save As to
save it somewhere appropriate.

Note that the database storage schemes are not yet recommended for
'production' use I believe.

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

Version Migration

[james]

Hello all,

Background
So I've been running on gnucash 2.4.11 for some years.
it's been great, the only problems were my lack of
knowledge of finance. I want to migrate to version 2.6.15
(using gentoo linux).


My only accounting problem is my depreciation does not match
what the accountant has been doing. They are the authority,
so It's entries on depreciation that need to be fixed.

Note, I have never 'closed the books' since the beginning because
I knew I need to fix the depreciation schedules on about (6) items.
It's a small company. I've been sick off and on for (3) years
running, so not much actively the last few years. I'm finally
better and ready to resume active business.




So, should I fix the depreciation on the new version of gnucash
(my preferred method) or on the old slow lappy and version 2.4.11?


I'm in the process of installing a laptop to exclusively run gnucash,
mostly offline (no physical internet) on gentoo linux (fav distro).


Any documents I need to review before doing the migration to the new
laptop? I have both scp and usb sticks for the migration.

I think I want to use a database now, pgsql.

hit me up with ideas, and whatever make me plan out this migration
before starting...

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