Re: Read only transactions

[Cliff McDiarmid]

   Sent: Sunday, January 14, 2018 at 5:20 PM
   From: "Geert Janssens" 
   To: gnucash-user@gnucash.org
   Cc: "Cliff McDiarmid" , "Colin Law"
   
   Subject: Re: Read only transactions
   Op zondag 14 januari 2018 16:14:18 CET schreef Cliff McDiarmid:
   > Sent: Sunday, January 14, 2018 at 12:27 PM
   > From: "Colin Law" 
   > To: "Cliff McDiarmid" 
   > Cc: gnucash-user@gnucash.org
   > Subject: Re: Read only transactions
   >
   > >Sorry, it is in File > Properties > Accounts. Best left at zero
   > >unless you want earlier transactions to be protected.
   >
   > Yes that's what mine is set to, i.e. zero.
   >
   > Where is this read only nonsense coming from then?
   >
   > Cliff
   >There are several reasons why transactions can be read-only.
   >The "Read-only" treshold is one.
   >If you have voided a transaction, that one will become read-only as
   well.
   >And if the transaction is the result of posting an invoice or bill
   using the
   >business features, it will equally be read-only.
   >There may be other reasons but I only know of these.
   >Solutions:
   >In the case of a voided transaction, unvoid it. In case of a
   transaction from
   >a bill or invoice (or employee voucher for that matter), use the
   business
   >features to unpost it again.
   Thanks Geert.  I thought you had the answer, I had 5 voided
   transactions 'buried' amoungst my data.   I reset them using the filter
   option and then saved the filter, but I still can't delete these a/cs I
   have.  The voided transactions have disappeared from the accounts in
   question, but still reappear when searching all accounts.  What's going
   on?

   Cliff
___
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: Double Entry of Informal "Loan" & Repayment

[Mike or Penny Novack]

On 1/14/2018 1:57 PM, Keith Lewis wrote:

I'm new to GC, longtime Quicken user. This is a double-entry accounting question rather than a GC 
question-hope that's okay in this mailing list. I made a purchase for a gift w credit card and used 
expenses:gifts to balance. Afterwards, a friend wanted to help with the gift and so paid me half with cash. 
I think I should deposit that cash into assets:wallet and balance with expenses:gift. But isnt the cash from 
my friend income? Does this sound right to you? Now imagine my friend had offered ahead of time to help pay 
for the gift, but didn't immediately have the cash. I think I could record the transactions as above or set 
up a "loan" account to track the "loan". IOW split liability:creditcard -> 
expense:gifts + liability:creditcard -> loan; then when he pays me back, loan -> asset:wallet.Thanks 
for your time,Keith
No, not income but an adjustment to an expense. You (later) learned that 
you were not paying for all of the gift but sharing the cost. So an 
adjustment transaction: (when he pays you)

debit  wallet
   creditgift expense
   description could explain -- say "friend is paying for half the 
gift"


Now let's examine the second case where the friend agreed to do this but 
hadn't yet. In other words, you paid for the gift but he owes you for 
that share of it. I am assuming that you mentioned credit card because 
that is HOW you paid for the gift.


when gift purchased
debitgift expense (for your share)
debitowed by friend (that is an ASSET type account)
 creditcredit card (for the purchase price

when he pays you back that's a transfer between assets
debit   wallet
 credit owed by friend   (that "asset" is now zero)

Michael D Novack




Michael D Novack
___
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: Installation on Windows 10

[David Carlson]

Snarky,

It does seem very odd that GnuCash is unable to write to that folder.  Can
you save other documents to that folder?

I would recommend creating a special subfolder for GnuCash data files as
GnuCash will be creating a lot of temporary files in the same folder.

David C


On Jan 14, 2018 12:52 PM, "Snarky Email"  wrote:

>I installed gnucash on my Windows 10 system and the new file setup
>fails.  I am using defaults for a new account to practice/test with.
>When I try to save as xml I get this error:  GnuCash could not write to
>C:\Users\Joe\Documents\gnucashtest.gnucash.  That database may be on a
>read-only file system, or you may not have write permission for the
>directory."
>I do have full access on the folder.
>Any help would be appreciated.
> ___
> 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.

Double Entry of Informal "Loan" & Repayment

[Keith Lewis]

I'm new to GC, longtime Quicken user. This is a double-entry accounting 
question rather than a GC question-hope that's okay in this mailing list. I 
made a purchase for a gift w credit card and used expenses:gifts to balance. 
Afterwards, a friend wanted to help with the gift and so paid me half with 
cash. I think I should deposit that cash into assets:wallet and balance with 
expenses:gift. But isnt the cash from my friend income? Does this sound right 
to you? Now imagine my friend had offered ahead of time to help pay for the 
gift, but didn't immediately have the cash. I think I could record the 
transactions as above or set up a "loan" account to track the "loan". IOW split 
liability:creditcard -> expense:gifts + liability:creditcard -> loan; then when 
he pays me back, loan -> asset:wallet.Thanks for your time,Keith
___
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.

Installation on Windows 10

[Snarky Email]

   I installed gnucash on my Windows 10 system and the new file setup
   fails.  I am using defaults for a new account to practice/test with.
   When I try to save as xml I get this error:  GnuCash could not write to
   C:\Users\Joe\Documents\gnucashtest.gnucash.  That database may be on a
   read-only file system, or you may not have write permission for the
   directory."
   I do have full access on the folder.
   Any help would be appreciated.
___
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: Read only transactions

[Christoph R]

Maybe you have set the day limit in the books options? “File-> Options”..

Cheers,
Christoph

> Am 13.01.2018 um 17:51 schrieb Cliff McDiarmid :
> 
>> Sent: Wednesday, January 10, 2018 at 7:21 PM
> 
>> From: "Cliff McDiarmid" 
>> To: gnucash-user@gnucash.org
>> Subject: Read only transactions
> 
>> Hi
>  
>> I still haven't sorted my Quicken import, getting the correct balances 
>> without a 'balance adjustment' is difficult.
>  
>> But the question is:  How do i delete an account when it contains read only 
>> transactions?  I know i can move the transactions elsewhere, but I need to 
>> delete the accounts.
>  
>> I understand that the 'placeholder box' needs to be unchecked; it already 
>> is.  Need a solution, Google yields nothing.
>  
>   
>  Okay so there's no answer or maybe it's a dumb question.
> 
> So, is there anyway I can set the transactions within an account to read and 
> write?
> 
> thanks
> 
> Cliff
>  
> ___
> 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: Read only transactions

[Geert Janssens]

Op zondag 14 januari 2018 16:14:18 CET schreef Cliff McDiarmid:
>Sent: Sunday, January 14, 2018 at 12:27 PM
>From: "Colin Law" 
>To: "Cliff McDiarmid" 
>Cc: gnucash-user@gnucash.org
>Subject: Re: Read only transactions
> 
>>Sorry, it is in File > Properties > Accounts. Best left at zero
>>unless you want earlier transactions to be protected.
> 
>Yes that's what mine is set to, i.e. zero.
> 
>Where is this read only nonsense coming from then?
> 
>Cliff

There are several reasons why transactions can be read-only.

The "Read-only" treshold is one.

If you have voided a transaction, that one will become read-only as well.

And if the transaction is the result of posting an invoice or bill using the 
business features, it will equally be read-only.

There may be other reasons but I only know of these.

Solutions:

In the case of a voided transaction, unvoid it. In case of a transaction from 
a bill or invoice (or employee voucher for that matter), use the business 
features to unpost it again.

Regards,

Geert


___
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: gnc-fq-update download

[farleykj]

I don't know where the gnc-fq-* files are put on a Linux installation, but
they are just short Perl scripts that do the stuff for you. I'm on OS X, and
on there the files are in /Applications/Gnucash.app/Contents/Resources/bin
Either way, here the text from "gnc-fq-update". You can copy this into a
file, make it executable with a "chmod 755" and you should be in business.

--- [ BEGIN SCRIPT ] ---
#!/usr/bin/perl -w  
##  
### gnc-fq-update - presents a scheme interface to Finance::Quote   
### Copyright 2001 Gnumatic, Inc.   
### 
### This program is free software; you can redistribute it and/or   
### modify it under the terms of the GNU General Public License as  
### published by the Free Software Foundation; either version 2 of  
### the License, or (at your option) any later version. 
### 
### This program is distributed in the hope that it will be useful, 
### but WITHOUT ANY WARRANTY; without even the implied warranty of  
### MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the   
### GNU General Public License for more details.
### 
### You should have received a copy of the GNU General Public License   
### along with this program# if not, contact:   
### 
### Free Software Foundation   Voice:  +1-617-542-5942  
### 51 Franklin Street, Fifth FloorFax:+1-617-542-2652  
### Boston, MA  02110-1301,  USA   g...@gnu.org 
 
##  

use strict; 
use CPAN;   

if ($( != 0) {  
  print "\n";   
  print "You probably need to be root before running gnc-fq-update.";   
  print "\n\n"; 
  print "Are you sure, you want to update parts of your Perl library? (y/n)
";  

  my $input = ;  
  chomp ($input);   

  exit 0 if ($input ne "y");
}   

CPAN::Shell->install('Date::Manip'); #Required by gnc-fq-helper 
CPAN::Shell->install('Finance::Quote'); 

## Local Variables: 
## mode: perl   
## End:
--- [ END SCRIPT ] ---



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

can I make account names be left justified?

[Jeff Abrahamson]

When viewing a ledger in gnucash 2.6.15 (rev 1ef17e6+), the description
is left-justified (good!) but the account names are right justified.  Is
there a way to make the account names be left justified?

Thanks.

Some context, but this is really trivia:  In France, the basic structure
of account numbers are set by legislation.  This seems insane the first
time one learns this, but it does turn it out to make it easier to
compare books between different organisations.  Anyway, the result is
that having those account numbers at the beginning of account names
makes a huge amount of sense in France.  So seeing the left side is more
important than seeing the right side.  (It also means that turning on
the feature only to show leaf accounts works really well, because the
account number already clearly indicates where in the account tree I am.)

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/


___
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: Correcting Opening Balances

[Mike or Penny Novack]

On 1/13/2018 5:17 PM, David Carlson wrote:

Did you check the transactions as you imported them to weed out duplicates
and correct errors?

If not, I would suggest starting over to get at least reasonably close to a
good starting point.
Also, this is a case where the solution to the problem more obvious if 
you understand what "opening balance" is doing, how you would be doing 
that if setting up your books manually (hand creating the opening 
TRANSACTIONs), and the proper/formal method of correcting "errors" and 
omissions << entering a correcting transaction instead of editing an 
existing one>>


If you are going to import from another system, run a Balance Sheet (of 
that other system) as of the date you will be using for the import. That 
will show you what the opening values SHOULD be.


Michael D Novack
___
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: Manually entering historic records

[Colin Law]

On 14 January 2018 at 09:59, Gregory L. Davis  wrote:
> Trevor:
>
> It sounds to me like you have to increase the number of days for "Read only"
> transactions.  Try clicking on the file menu, then preferences. In the
> "Accounts" tab, increase "Day Threshold for Read-Only Transactions (red
> line):".  You can set the number of days to to something like 800 to include
> all of 2016.

Is that a new feature? I don't see it in 2.6.17.
I think it is Edit > Preferences rather than File, but I still don't have it.

Colin

>
> Hope this helps,
>
> greg
>
>
>
>
> I've been following the user group for years but still not started the move
> from 20yrs of MSmoney... all looks too hard with an MSM file with records
> back to 1997.
> I thought I could test the water with a new business and associated bank
> account that started in 2016.I've been managing this with a spreadsheet as
> very few transactions.
> So I set up a business set of accounts and tried entering manually, the
> historic records... I'm immediately stumped. It does not let me enter past
> dates. Clearly I'm going about this in the wrong way.Advice
> appreciated.Trevor
>
>
> --
> Gregory L. Davis
> g...@centurytel.net
>
> ___
> 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: Read only transactions

[Colin Law]

What have you specified for Day Threshold for Read-Only Transactions
(red line): in Edit > Preferences > Accounts?

Colin

On 14 January 2018 at 12:04, Cliff McDiarmid  wrote:
>   Sent: Saturday, January 13, 2018 at 5:22 PM
> From: "Colin Law" 
> To: "Cliff McDiarmid" 
> Cc: gnucash-user@gnucash.org
> Subject: Re: Read only transactions
> On 13 January 2018 at 17:12, Cliff McDiarmid 
> wrote:
>>
>> >Sent: Saturday, January 13, 2018 at 4:58 PM
>> >From: "Colin Law" 
>> >To: "Cliff McDiarmid" 
>> .Cc: gnucash-user@gnucash.org
>> >Subject: Re: Read only transactions
>> >On 10 January 2018 at 19:21, Cliff McDiarmid 
>> > wrote:
>>>
>>> Hi
>>>
>>> I still haven't sorted my Quicken import, getting the correct balances
>>> without a 'balance adjustment' is difficult.
>>
>>
>> >Add (or adjust) an appropriate opening balance.
>>
>>>
>>>
>>> But the question is: How do i delete an account when it contains read
>>> only transactions? I know i can move the transactions elsewhere, but I
>>> need to delete the accounts.
>>
>>
>> >What do you mean by read only transactions?
>>
>> Well I assume, as in Linux, that one cannot write to or change these
>> files.
>>
>> >When you delete an account that contains transactions it should ask you
>> > which account you want to move them to.
>>
>> Yes, that's right it does. But it won't let me delete the account
>> altogether, because the account contains read only transactions. Other
>> accounts I've deleted have given one the option of moving the files as you
>> say or deleting them entirely.
>
>>All the accounts are in one file, so if you have read access to the
>>file then it is not a permissions issue. How are you trying to delete
>>the account and exactly what do you see when you try to delete it?
>
> I right click on the account and select delete account.   I get a box that
> gives me two options. To move the transactions and to delete them, but the
> delete option is greyed out.  The message in the same box says:  'This
> account contains read-only transactions which may not be deleted'
>
> Cliff
>
___
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: Read only transactions

[Cliff McDiarmid]

 Sent: Saturday, January 13, 2018 at 5:22 PM
   From: "Colin Law" 
   To: "Cliff McDiarmid" 
   Cc: gnucash-user@gnucash.org
   Subject: Re: Read only transactions
   On 13 January 2018 at 17:12, Cliff McDiarmid 
   wrote:
   >
   > >Sent: Saturday, January 13, 2018 at 4:58 PM
   > >From: "Colin Law" 
   > >To: "Cliff McDiarmid" 
   > .Cc: gnucash-user@gnucash.org
   > >Subject: Re: Read only transactions
   > >On 10 January 2018 at 19:21, Cliff McDiarmid
    wrote:
   >>
   >> Hi
   >>
   >> I still haven't sorted my Quicken import, getting the correct
   balances
   >> without a 'balance adjustment' is difficult.
   >
   >
   > >Add (or adjust) an appropriate opening balance.
   >
   >>
   >>
   >> But the question is: How do i delete an account when it contains
   read
   >> only transactions? I know i can move the transactions elsewhere, but
   I
   >> need to delete the accounts.
   >
   >
   > >What do you mean by read only transactions?
   >
   > Well I assume, as in Linux, that one cannot write to or change these
   files.
   >
   > >When you delete an account that contains transactions it should ask
   you which account you want to move them to.
   >
   > Yes, that's right it does. But it won't let me delete the account
   altogether, because the account contains read only transactions. Other
   accounts I've deleted have given one the option of moving the files as
   you say or deleting them entirely.
   >All the accounts are in one file, so if you have read access to the
   >file then it is not a permissions issue. How are you trying to delete
   >the account and exactly what do you see when you try to delete it?
   I right click on the account and select delete account.   I get a box
   that gives me two options. To move the transactions and to delete them,
   but the delete option is greyed out.  The message in the same box
   says:  'This account contains read-only transactions which may not be
   deleted'

   Cliff
___
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: Manually entering historic records

[Gregory L. Davis]

Trevor:

It sounds to me like you have to increase the number of days for "Read 
only" transactions.  Try clicking on the file menu, then preferences. 
In the "Accounts" tab, increase "Day Threshold for Read-Only 
Transactions (red line):".  You can set the number of days to to 
something like 800 to include all of 2016.


Hope this helps,

greg




I've been following the user group for years but still not started the 
move from 20yrs of MSmoney... all looks too hard with an MSM file with 
records back to 1997.
I thought I could test the water with a new business and associated bank 
account that started in 2016.I've been managing this with a spreadsheet 
as very few transactions.
So I set up a business set of accounts and tried entering manually, the 
historic records... I'm immediately stumped. It does not let me enter 
past dates. Clearly I'm going about this in the wrong way.Advice 
appreciated.Trevor



--
Gregory L. Davis
g...@centurytel.net
___
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: Manually entering historic records

[Rick Copple]

Hi Trevor,

What exactly is it doing to prevent you from entering past dates? I enter them 
all the time. You do have to enter the / dividers. Like instead of 11418 you 
would have to enter 1/14/18 to get the date to come out right. 

--
Rick Copple


On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:

> I've been following the user group for years but still not started the move 
> from 20yrs of MSmoney... all looks too hard with an MSM file with records 
> back to 1997.
> I thought I could test the water with a new business and associated bank 
> account that started in 2016.I've been managing this with a spreadsheet as 
> very few transactions.
> So I set up a business set of accounts and tried entering manually, the 
> historic records... I'm immediately stumped. It does not let me enter past 
> dates. Clearly I'm going about this in the wrong way.Advice appreciated.Trevor
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/
___
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.