Re: Invoice & Bill Posting Date Issues Across Multiple Periods

[DaveC49]

Hi Adrien,

I am assuming here you mean when you are pre-billed by a supplier of a good
or service. What follows is not necessarily restricted to insurance or even
to prepayment but just uses these to illustrate the principle. If you mean
that you are pre-billing a client, my apologies and please ignore.

I think the issue is not that there is a single event associated with things
like prepayments but that there are multiple events. If one wishes to meet
the full requirement to provide an accurate reflection of events in your
accounts, for example to handle the issue of pre-billing of insurance for a
future accounting period you have (at least) the following events which you
record in your accounts as they occur unless of course
regulations/legislation specifies otherwise.

1. Insurer issues an invoice to you.  You have no knowledge of this until
you receive it. This doesn't appear in your accounts.

2. You receive an invoice from the insurer. It will specify a due date and
terms and conditions, possibly a discount if paid in advance or interest if
not paid by the due date and an amount to be  paid at a future date.  You
raise a Bill in your accounts. I would choose the date you receive the
invoice from the insurer 
as the post date as this is when you become aware of the obligation to make
that future payment and receive in return insurance cover for an agreed
period, which may or may not be from the due date even though it generally
is.  You would record the bill with a debit to an Asset:PrepaidInsurance
account and a corresponding credit to Liability:A/P created by posting the
bill. You could equally use the date on the invoice issued by the
insurer/supplier, unless there is a significant difference between the date
it was issued and the date you received it, but the latter is really the
most significant event associated with the bill for your accounts. (Dates on
line items in the invoice from a general supplier to you may be relevant
however if you are matching a particular expense to specific items of
revenue of course).

3. You pay the Bill at or before the due date. (Ignore the discount
possibility.) Again I would use the date I raised a cheque, authorised a
transfer from my account, handed over cash etc. depending on how I paid the
bill. In the case of a cheque or where there may be a significant delay in
an electronic funds transfer after you have authorised it, you may use a
temporary clearing account to record that you have made the payment and then
clear that account when the funds are actually transferred (cheque cleared
or electronic transfer from your account recorded if this level of detail is
of importance to you). In the simplest form this would be a credit to your
Asset:Bank account and a debit to the Liability:A/P at the date you made the
payment.

4. The final step would be to expense the prepayment at periodic times
during the period of the insurance with a credit to Asset:PrepaidInsurance 
and a debit to Expense:Insurance. 

By capitalising the insurance prepayment, it can be carried through over
into a future accounting period and expensed in that period.

I am not sure what you meant by "My issue isn’t the idea of a pre-paid
asset, my issue is that it is increasing when I post the bill, not when I
pay it."  I guess you mean the A/P balance by it or do you mean the Expense
account (or an Asset account if it is prepaid). If it is the A/P balance,
then that is the correct expected behavior as Derek has pointed out. If the
posting date is not relevant to matching particular income then capitalising
it to an asset account then expensing it at the relevant date wil do the
trick. Next issue is whether the asset account should be under current
assets, if it is to be expensed within the current period or in non-current
assets where it is to be expensed in a succeeding period.



-
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: Cannot edit opening balance

[Carmelo Pagan]

I guess I stated the issue improperly.  I was trying to edit the opening 
balance after a reconciliation attempt had failed. The reconciliation 
difference was exactly the amount of the opening on my paper statement. I then 
realized I had not entered an opening balance amount (using the opening 
balances tab) when I created the account.  I then entered an opening balance 
via the Equity:Opening Balances account. When I attempted the reconciliation, 
the “starting balance” in the reconciliation window displayed a deficit amount 
instead of the amount I had entered in the Equity account.

I tried several measures in an attempt to get the negative amount in the 
reconciliation to reset to the newly entered opening balance. 

These included but were not limited to,.
1. Deleting the previously entered opening balance, hoping I could return to 
the original state  Result: Negative starting balance remained unchanged
2. Unreconciled all previously reconciled transactions and reattempted 
reconciliation. Result: Same Negative balance displayed,
3. Reverted to one of the backup files dated before the first reconciliation. 
Result: Same Negative amount displayed.

Hopefully this sheds some light on the discussion.

Sincerely , 
Carmelo Pagán 

> On Dec 12, 2017, at 12:52 PM, Carmelo Pagán  wrote:
> 
> I thank everyone for their feedback. 
> 
> I resolved it the painful way of creating a new file, downloading my 
> transactions (Thanks to Bruno Acklin's posting of the settings I needed), 
> then establishing the opening balances before reconciling the first time.  
> Fortunately, I am relatively new to GnuCash, so I only had to go through six 
> months' worth of transactions.
> 
> Lesson learned.
> 
> Carmelo Pagan
> 
> -Original Message-
> From: gnucash-user 
> [mailto:gnucash-user-bounces+c.pagan=sbcglobal@gnucash.org] On Behalf Of 
> John Ralls
> Sent: Monday, December 11, 2017 6:53 PM
> To: DaveC49 
> Cc: gnucash-user@gnucash.org
> Subject: Re: Cannot edit opening balance
> 
> 
> 
>> On Dec 11, 2017, at 2:51 PM, DaveC49  wrote:
>> 
>> John,
>> 
>> That is exactly what the Opening Balance dialog actually does in 
>> Gnucash (it creates those entries) and once the entries have been 
>> created they are easily edited either from the Opening Balances 
>> register or from the register for the account for which you set the 
>> opening balance,  just as you can edit any other transaction.
> 
> Yes, Dave, I know. But the OP said that he didn’t use the Opening Balance tab 
> of the new account dialog, he created an Opening Balance transaction by hand 
> afterwards. Since he didn’t use the dialog it’s possible he made a mistake 
> and I instructed him how he might check for one and repair it if he needs to.
> 
> 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.
> 
> ___
> 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: Cannot edit opening balance

[Dale Alspach]

Rather than changing the opening balance a correcting transaction needed
to be added. One side of the transaction would be the difference between
the incorrect starting balance and the correct starting balance and the
other side would be in Opening Balances or whatever caused the problem.
Next reconcile the account being sure to mark the correcting transaction
even though it does not match anything in the bank statement.

Once you have successfully reconciled the account, the starting balance
for the next reconcile will be the ending balance from this reconciliation.

Dale

On 12/13/2017 10:05 PM, Carmelo Pagán wrote:
> I tried that, but the reconcile window starting balance stayed fixed.
> 
> -Original Message-
> From: gnucash-user 
> [mailto:gnucash-user-bounces+c.pagan=sbcglobal@gnucash.org] On Behalf Of 
> Ronal B Morse
> Sent: Tuesday, December 12, 2017 4:08 PM
> To: gnucash-user@gnucash.org
> Subject: Re: Cannot edit opening balance
> 
> Is there some reason you couldn't just change the opening balance in the 
> register to the correct amount, then performing the reconcile?
> 
> RBM
> 
> 
> 
> On 12/12/2017 10:52 AM, Carmelo Pagán wrote:
>> I thank everyone for their feedback.
>>
>> I resolved it the painful way of creating a new file, downloading my 
>> transactions (Thanks to Bruno Acklin's posting of the settings I needed), 
>> then establishing the opening balances before reconciling the first time.  
>> Fortunately, I am relatively new to GnuCash, so I only had to go through six 
>> months' worth of transactions.
>>
>> Lesson learned.
>>
>> Carmelo Pagan
>>
>> -Original Message-
>> From: gnucash-user 
>> [mailto:gnucash-user-bounces+c.pagan=sbcglobal@gnucash.org] On 
>> Behalf Of John Ralls
>> Sent: Monday, December 11, 2017 6:53 PM
>> To: DaveC49 
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: Cannot edit opening balance
>>
>>
>>
>>> On Dec 11, 2017, at 2:51 PM, DaveC49  wrote:
>>>
>>> John,
>>>
>>> That is exactly what the Opening Balance dialog actually does in 
>>> Gnucash (it creates those entries) and once the entries have been 
>>> created they are easily edited either from the Opening Balances 
>>> register or from the register for the account for which you set the 
>>> opening balance,  just as you can edit any other transaction.
>> Yes, Dave, I know. But the OP said that he didn’t use the Opening Balance 
>> tab of the new account dialog, he created an Opening Balance transaction by 
>> hand afterwards. Since he didn’t use the dialog it’s possible he made a 
>> mistake and I instructed him how he might check for one and repair it if he 
>> needs to.
>>
>> 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.
>>
>> ___
>> 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.
> 
___
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: Cannot edit opening balance

[Carmelo Pagán]

I tried that, but the reconcile window starting balance stayed fixed.

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+c.pagan=sbcglobal@gnucash.org] On Behalf Of 
Ronal B Morse
Sent: Tuesday, December 12, 2017 4:08 PM
To: gnucash-user@gnucash.org
Subject: Re: Cannot edit opening balance

Is there some reason you couldn't just change the opening balance in the 
register to the correct amount, then performing the reconcile?

RBM



On 12/12/2017 10:52 AM, Carmelo Pagán wrote:
> I thank everyone for their feedback.
>
> I resolved it the painful way of creating a new file, downloading my 
> transactions (Thanks to Bruno Acklin's posting of the settings I needed), 
> then establishing the opening balances before reconciling the first time.  
> Fortunately, I am relatively new to GnuCash, so I only had to go through six 
> months' worth of transactions.
>
> Lesson learned.
>
> Carmelo Pagan
>
> -Original Message-
> From: gnucash-user 
> [mailto:gnucash-user-bounces+c.pagan=sbcglobal@gnucash.org] On 
> Behalf Of John Ralls
> Sent: Monday, December 11, 2017 6:53 PM
> To: DaveC49 
> Cc: gnucash-user@gnucash.org
> Subject: Re: Cannot edit opening balance
>
>
>
>> On Dec 11, 2017, at 2:51 PM, DaveC49  wrote:
>>
>> John,
>>
>> That is exactly what the Opening Balance dialog actually does in 
>> Gnucash (it creates those entries) and once the entries have been 
>> created they are easily edited either from the Opening Balances 
>> register or from the register for the account for which you set the 
>> opening balance,  just as you can edit any other transaction.
> Yes, Dave, I know. But the OP said that he didn’t use the Opening Balance tab 
> of the new account dialog, he created an Opening Balance transaction by hand 
> afterwards. Since he didn’t use the dialog it’s possible he made a mistake 
> and I instructed him how he might check for one and repair it if he needs to.
>
> 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.
>
> ___
> 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: GnuCash: Price Editor -- Linux Mint

[Dave H]

Assuming you've setup everything as per the wiki link in your email it
shows up under the "Unknown" quote source.

Cheers Dave H.

On 14 December 2017 at 09:52, Bill Swanson  wrote:

> How do I update the Price Editor to use the Financial::Quote?
>
> GnuCash  Version: 2.6.12
>
> I used the:
> perl -MCPAN -e shell
> install Finance::Quote
>
> Got version 1.47
>
> How do I get this to show up in the drop down in the Security Editor? (
> *Alphavantage)*
>
> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
>
> The OS is LinuxMint 17.1
>
> --
> Bill Swanson
> 207-2443946
> ___
> 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: Gnucash & macOS High Sierra.

[John Ralls]

The base currency of the book is completely separate from the LC_MONETARY 
setting in the environment, so you can have a Euro account and still have 
LC_MONETARY set to en_GB so that you have dots for the decimal separator.

As for storing 99/100 as ‘0.99’, that’s backwards. GnuCash always stores 
numbers as rationals and the SX string parser knows how to parse rationals so I 
think that if you actually write “99/100” in your SX formula it will be 
locale-safe. You might try switching back to en_GB, editing the SXes to use 
rationals instead of decimals, and then switch back to fr_FR for the commas 
(assuming that you actually want to “go native” and use commas for the decimal 
separator). That should resolve the problem without having to delete and 
recreate the scheduled transactions.

One more thing: The list is archived at 
https://lists.gnucash.org/mailman/listinfo/gnucash-user 
 so even if you do 
accidentally delete a message you can still read it there.

Regards,
John Ralls

> On Dec 13, 2017, at 1:11 PM, Pam Dooner  wrote:
> 
> Just to clarify. My OS is in English but I live in France !
> 
> Le mer. 13 déc. 2017 à 21:38, Pam Dooner  > a écrit :
> 
>> Thank you very much for resending this. The message had gone into my spam
>> box and I’d deleted it before I realised it wasn’t spam. I’d hoped to not
>> have to delete the old scheduled transactions but looks like that’s what is
>> required.
>> 
>> Le mer. 13 déc. 2017 à 20:17, Dave H  a écrit :
>> 
>>> John Ralls replied to Pam's original other posting a couple of days ago
>>> with a wiki link to changing langauage and other locale settings as follows
>>> ...
>>> 
>>> Cheers Dave H.
>>> 
>>> 
 On Dec 11, 2017, at 9:54 AM, Pam Dooner  wrote:
 
 Hi. I just upgraded to High Sierra and while gnucash opens and is
>>> usable,
 trying to open the scheduled transaction editor crashes the editor and
 gnush has to be force-quit. I get a parsing error on opening if there
>>> are
 any scheduled transactions run since last opened so I wanted to edit the
 transactions as the program no longer accepts the full stop as a decimal
 separator since my locale is in euros. I then thought I'd just create
>>> new
 scheduled transactions but that crashes too. After the parsing error
 message the program opens but the amount of the entry is blank and it
>>> keeps
 repeating this each time I open the program. It means I have to enter
>>> each
 of my scheduled transactions manually, which is a bit of pain to say the
 least, since I have 2 separate bank accounts! Any solution, workaround?
>>> 
>>> Did you delete the old scheduled transactions, the ones with dots for
>>> decimal separators?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> [1]
>>> http://wiki.gnucash.org/wiki/Locale_Settings#Changing_the_Language_on_OSX
>>> 
>>> 
>>> 
>>> On 14 December 2017 at 04:58, Derek Atkins  wrote:
>>> 
 Changing the currency is not sufficient. You need to change how numbers
 are printed. I'm not sure how to do that on your platform.
 
 -derek
 Sent using my mobile device. Please excuse any typos.
 
 On December 13, 2017 1:44:52 PM Pam Dooner  wrote:
 
> Changing the locale seems only to affect new accounts. I have tried to
> ask for GBP but nothing has changed.
> Pam
> 
> 
> *Pam Dooner*
> 
> On 13 December 2017 at 19:39, Derek Atkins  wrote:
> 
>> Yes, if you change your locale back to the old locale it should work
>> again.
>> 
>> -derek
>> 
>> On Wed, December 13, 2017 1:34 pm, Pam Dooner wrote:
>>> Thank you for this explanation. If I change my locale to UK, will
>>> everything then be OK? Otherwise how do I change the SX definitions?
>>> Regards,
>>> Pam
>>> 
>>> 
>>> *Pam Dooner*
>>> 
>>> On 13 December 2017 at 16:30, Derek Atkins  wrote:
>>> 
 Hi,
 
 Pam Dooner  writes:
 
> yes, definitely 2.6.18. Just tried again and this time managed to
>> get
 a
> pop-up saying "An error occurred while processing 0.99"
> I am trying to change all my decimal points to commas to coincide
>> with
 the
> euro locale that I have to use now it seems. In the older
>> versions,
 there
> was no issue with commas and points. I have UK accounts and
>> european
> accounts so ought to be able to use both but this version (and the
 previous
> one) seem to cause the error if I try to use a decimal point. So
>> I'll
 have
> to try to edit the file elsewhere and re-import it. I had hoped
>> there
 might
> 

Re: GnuCash: Price Editor -- Linux Mint

[Bill Swanson]

How do I update the Price Editor to use the Financial::Quote?

GnuCash  Version: 2.6.12

I used the:
perl -MCPAN -e shell
install Finance::Quote

Got version 1.47

How do I get this to show up in the drop down in the Security Editor? (
*Alphavantage)*

https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

The OS is LinuxMint 17.1

-- 
Bill Swanson
207-2443946
___
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 on multiple computers

[Sharon Shaw Elrod]

I found instructions for putting gnucash on Google Drive, but I don't
understand them. Here is what I found:
>* I want to have Gnucash on all my computers so depending which one I'm
using *









*> I have access to my financial analysis. > > Or will I run into
problems? Nope, piece of cake: Just set GNC_DOT_DIR to a folder on your
Google Drive. You didn't say what OS you're using, so in Linux you can just
set it in .bashrc. On OSX you'll want to edit
Gnucash.app/Contents/MacOS/Gnucash. On Windows the easiest way is to edit
the shortcut in the menu (right-click on it and select Properties from the
context menu). Regards, John Ralls*


*Where do I find GNC_DOT_DIR? Where is the menu referred to in the quote
above?*
*Thanks for your assistance.*
___
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 & macOS High Sierra.

[Pam Dooner]

Just to clarify. My OS is in English but I live in France !

Le mer. 13 déc. 2017 à 21:38, Pam Dooner  a écrit :

> Thank you very much for resending this. The message had gone into my spam
> box and I’d deleted it before I realised it wasn’t spam. I’d hoped to not
> have to delete the old scheduled transactions but looks like that’s what is
> required.
>
> Le mer. 13 déc. 2017 à 20:17, Dave H  a écrit :
>
>> John Ralls replied to Pam's original other posting a couple of days ago
>> with a wiki link to changing langauage and other locale settings as follows
>> ...
>>
>> Cheers Dave H.
>>
>>
>> > On Dec 11, 2017, at 9:54 AM, Pam Dooner  wrote:
>> >
>> > Hi. I just upgraded to High Sierra and while gnucash opens and is
>> usable,
>> > trying to open the scheduled transaction editor crashes the editor and
>> > gnush has to be force-quit. I get a parsing error on opening if there
>> are
>> > any scheduled transactions run since last opened so I wanted to edit the
>> > transactions as the program no longer accepts the full stop as a decimal
>> > separator since my locale is in euros. I then thought I'd just create
>> new
>> > scheduled transactions but that crashes too. After the parsing error
>> > message the program opens but the amount of the entry is blank and it
>> keeps
>> > repeating this each time I open the program. It means I have to enter
>> each
>> > of my scheduled transactions manually, which is a bit of pain to say the
>> > least, since I have 2 separate bank accounts! Any solution, workaround?
>>
>> Did you delete the old scheduled transactions, the ones with dots for
>> decimal separators?
>>
>> Regards,
>> John Ralls
>>
>> [1]
>> http://wiki.gnucash.org/wiki/Locale_Settings#Changing_the_Language_on_OSX
>>
>>
>>
>> On 14 December 2017 at 04:58, Derek Atkins  wrote:
>>
>>> Changing the currency is not sufficient. You need to change how numbers
>>> are printed. I'm not sure how to do that on your platform.
>>>
>>> -derek
>>> Sent using my mobile device. Please excuse any typos.
>>>
>>> On December 13, 2017 1:44:52 PM Pam Dooner  wrote:
>>>
 Changing the locale seems only to affect new accounts. I have tried to
 ask for GBP but nothing has changed.
 Pam


 *Pam Dooner*

 On 13 December 2017 at 19:39, Derek Atkins  wrote:

> Yes, if you change your locale back to the old locale it should work
> again.
>
> -derek
>
> On Wed, December 13, 2017 1:34 pm, Pam Dooner wrote:
> > Thank you for this explanation. If I change my locale to UK, will
> > everything then be OK? Otherwise how do I change the SX definitions?
> > Regards,
> > Pam
> >
> >
> > *Pam Dooner*
> >
> > On 13 December 2017 at 16:30, Derek Atkins  wrote:
> >
> >> Hi,
> >>
> >> Pam Dooner  writes:
> >>
> >> > yes, definitely 2.6.18. Just tried again and this time managed to
> get
> >> a
> >> > pop-up saying "An error occurred while processing 0.99"
> >> > I am trying to change all my decimal points to commas to coincide
> with
> >> the
> >> > euro locale that I have to use now it seems. In the older
> versions,
> >> there
> >> > was no issue with commas and points. I have UK accounts and
> european
> >> > accounts so ought to be able to use both but this version (and the
> >> previous
> >> > one) seem to cause the error if I try to use a decimal point. So
> I'll
> >> have
> >> > to try to edit the file elsewhere and re-import it. I had hoped
> there
> >> might
> >> > have been a way of globally changing all previous entries with a
> >> decimal
> >> > point to commas. In the actual accounts, it has changed them all
> to
> >> commas
> >> > but not in scheduled transactions!
> >> > Pam
> >>
> >> Scheduled Transactions do not survive a locale change, specifically
> a
> >> change where the decimal separator changes characters.  The reason
> is
> >> that the SX data is stored as text, not as a numeric, so "99/100"
> gets
> >> stored as 0.99 and then it expects to be parsed as 0.99 -- however
> if
> >> you change your locale so that a comma is a decimal separator then
> >> GnuCash expects to read back 0,99.  But when it sees 0.99 it doesn't
> >> know how to interpret that.
> >>
> >> The only fix is to change the SX definitions, or to change your
> locale
> >> specification of (IIRC) LC_NUMERIC back to the old style.
> >>
> >> I don't know if there is a way change the character from within the
> >> program.
> >>
> >> > *Pam Dooner*
> >>
> >> > Please remember to CC this list on all your replies.
> >> > You can do this by using Reply-To-List or Reply-All.
> >>
> >> -derek
> 

Re: Gnucash & macOS High Sierra.

[Dave H]

John Ralls replied to Pam's original other posting a couple of days ago
with a wiki link to changing langauage and other locale settings as follows
...

Cheers Dave H.


> On Dec 11, 2017, at 9:54 AM, Pam Dooner  wrote:
>
> Hi. I just upgraded to High Sierra and while gnucash opens and is usable,
> trying to open the scheduled transaction editor crashes the editor and
> gnush has to be force-quit. I get a parsing error on opening if there are
> any scheduled transactions run since last opened so I wanted to edit the
> transactions as the program no longer accepts the full stop as a decimal
> separator since my locale is in euros. I then thought I'd just create new
> scheduled transactions but that crashes too. After the parsing error
> message the program opens but the amount of the entry is blank and it
keeps
> repeating this each time I open the program. It means I have to enter each
> of my scheduled transactions manually, which is a bit of pain to say the
> least, since I have 2 separate bank accounts! Any solution, workaround?

Did you delete the old scheduled transactions, the ones with dots for
decimal separators?

Regards,
John Ralls

[1] http://wiki.gnucash.org/wiki/Locale_Settings#Changing_the_
Language_on_OSX



On 14 December 2017 at 04:58, Derek Atkins  wrote:

> Changing the currency is not sufficient. You need to change how numbers
> are printed. I'm not sure how to do that on your platform.
>
> -derek
> Sent using my mobile device. Please excuse any typos.
>
> On December 13, 2017 1:44:52 PM Pam Dooner  wrote:
>
>> Changing the locale seems only to affect new accounts. I have tried to
>> ask for GBP but nothing has changed.
>> Pam
>>
>>
>> *Pam Dooner*
>>
>> On 13 December 2017 at 19:39, Derek Atkins  wrote:
>>
>>> Yes, if you change your locale back to the old locale it should work
>>> again.
>>>
>>> -derek
>>>
>>> On Wed, December 13, 2017 1:34 pm, Pam Dooner wrote:
>>> > Thank you for this explanation. If I change my locale to UK, will
>>> > everything then be OK? Otherwise how do I change the SX definitions?
>>> > Regards,
>>> > Pam
>>> >
>>> >
>>> > *Pam Dooner*
>>> >
>>> > On 13 December 2017 at 16:30, Derek Atkins  wrote:
>>> >
>>> >> Hi,
>>> >>
>>> >> Pam Dooner  writes:
>>> >>
>>> >> > yes, definitely 2.6.18. Just tried again and this time managed to
>>> get
>>> >> a
>>> >> > pop-up saying "An error occurred while processing 0.99"
>>> >> > I am trying to change all my decimal points to commas to coincide
>>> with
>>> >> the
>>> >> > euro locale that I have to use now it seems. In the older versions,
>>> >> there
>>> >> > was no issue with commas and points. I have UK accounts and european
>>> >> > accounts so ought to be able to use both but this version (and the
>>> >> previous
>>> >> > one) seem to cause the error if I try to use a decimal point. So
>>> I'll
>>> >> have
>>> >> > to try to edit the file elsewhere and re-import it. I had hoped
>>> there
>>> >> might
>>> >> > have been a way of globally changing all previous entries with a
>>> >> decimal
>>> >> > point to commas. In the actual accounts, it has changed them all to
>>> >> commas
>>> >> > but not in scheduled transactions!
>>> >> > Pam
>>> >>
>>> >> Scheduled Transactions do not survive a locale change, specifically a
>>> >> change where the decimal separator changes characters.  The reason is
>>> >> that the SX data is stored as text, not as a numeric, so "99/100" gets
>>> >> stored as 0.99 and then it expects to be parsed as 0.99 -- however if
>>> >> you change your locale so that a comma is a decimal separator then
>>> >> GnuCash expects to read back 0,99.  But when it sees 0.99 it doesn't
>>> >> know how to interpret that.
>>> >>
>>> >> The only fix is to change the SX definitions, or to change your locale
>>> >> specification of (IIRC) LC_NUMERIC back to the old style.
>>> >>
>>> >> I don't know if there is a way change the character from within the
>>> >> program.
>>> >>
>>> >> > *Pam Dooner*
>>> >>
>>> >> > 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>> >>Member, MIT Student Information Processing Board  (SIPB)
>>> >>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>>> >>warl...@mit.eduPGP key available
>>> >>
>>> >
>>>
>>>
>>> --
>>>Derek Atkins 617-623-3745
>>>de...@ihtfp.com www.ihtfp.com
>>>Computer and Internet Security Consultant
>>>
>>>
>>
___
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 & macOS High Sierra.

[Derek Atkins]

Changing the currency is not sufficient. You need to change how numbers are 
printed. I'm not sure how to do that on your platform.


-derek
Sent using my mobile device. Please excuse any typos.



On December 13, 2017 1:44:52 PM Pam Dooner  wrote:


Changing the locale seems only to affect new accounts. I have tried to ask
for GBP but nothing has changed.
Pam


*Pam Dooner*

On 13 December 2017 at 19:39, Derek Atkins  wrote:


Yes, if you change your locale back to the old locale it should work again.

-derek

On Wed, December 13, 2017 1:34 pm, Pam Dooner wrote:
> Thank you for this explanation. If I change my locale to UK, will
> everything then be OK? Otherwise how do I change the SX definitions?
> Regards,
> Pam
>
>
> *Pam Dooner*
>
> On 13 December 2017 at 16:30, Derek Atkins  wrote:
>
>> Hi,
>>
>> Pam Dooner  writes:
>>
>> > yes, definitely 2.6.18. Just tried again and this time managed to get
>> a
>> > pop-up saying "An error occurred while processing 0.99"
>> > I am trying to change all my decimal points to commas to coincide with
>> the
>> > euro locale that I have to use now it seems. In the older versions,
>> there
>> > was no issue with commas and points. I have UK accounts and european
>> > accounts so ought to be able to use both but this version (and the
>> previous
>> > one) seem to cause the error if I try to use a decimal point. So I'll
>> have
>> > to try to edit the file elsewhere and re-import it. I had hoped there
>> might
>> > have been a way of globally changing all previous entries with a
>> decimal
>> > point to commas. In the actual accounts, it has changed them all to
>> commas
>> > but not in scheduled transactions!
>> > Pam
>>
>> Scheduled Transactions do not survive a locale change, specifically a
>> change where the decimal separator changes characters.  The reason is
>> that the SX data is stored as text, not as a numeric, so "99/100" gets
>> stored as 0.99 and then it expects to be parsed as 0.99 -- however if
>> you change your locale so that a comma is a decimal separator then
>> GnuCash expects to read back 0,99.  But when it sees 0.99 it doesn't
>> know how to interpret that.
>>
>> The only fix is to change the SX definitions, or to change your locale
>> specification of (IIRC) LC_NUMERIC back to the old style.
>>
>> I don't know if there is a way change the character from within the
>> program.
>>
>> > *Pam Dooner*
>>
>> > 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>Member, MIT Student Information Processing Board  (SIPB)
>>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>>warl...@mit.eduPGP key available
>>
>


--
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant



___
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 & macOS High Sierra.

[Pam Dooner]

Changing the locale seems only to affect new accounts. I have tried to ask
for GBP but nothing has changed.
Pam


*Pam Dooner*

On 13 December 2017 at 19:39, Derek Atkins  wrote:

> Yes, if you change your locale back to the old locale it should work again.
>
> -derek
>
> On Wed, December 13, 2017 1:34 pm, Pam Dooner wrote:
> > Thank you for this explanation. If I change my locale to UK, will
> > everything then be OK? Otherwise how do I change the SX definitions?
> > Regards,
> > Pam
> >
> >
> > *Pam Dooner*
> >
> > On 13 December 2017 at 16:30, Derek Atkins  wrote:
> >
> >> Hi,
> >>
> >> Pam Dooner  writes:
> >>
> >> > yes, definitely 2.6.18. Just tried again and this time managed to get
> >> a
> >> > pop-up saying "An error occurred while processing 0.99"
> >> > I am trying to change all my decimal points to commas to coincide with
> >> the
> >> > euro locale that I have to use now it seems. In the older versions,
> >> there
> >> > was no issue with commas and points. I have UK accounts and european
> >> > accounts so ought to be able to use both but this version (and the
> >> previous
> >> > one) seem to cause the error if I try to use a decimal point. So I'll
> >> have
> >> > to try to edit the file elsewhere and re-import it. I had hoped there
> >> might
> >> > have been a way of globally changing all previous entries with a
> >> decimal
> >> > point to commas. In the actual accounts, it has changed them all to
> >> commas
> >> > but not in scheduled transactions!
> >> > Pam
> >>
> >> Scheduled Transactions do not survive a locale change, specifically a
> >> change where the decimal separator changes characters.  The reason is
> >> that the SX data is stored as text, not as a numeric, so "99/100" gets
> >> stored as 0.99 and then it expects to be parsed as 0.99 -- however if
> >> you change your locale so that a comma is a decimal separator then
> >> GnuCash expects to read back 0,99.  But when it sees 0.99 it doesn't
> >> know how to interpret that.
> >>
> >> The only fix is to change the SX definitions, or to change your locale
> >> specification of (IIRC) LC_NUMERIC back to the old style.
> >>
> >> I don't know if there is a way change the character from within the
> >> program.
> >>
> >> > *Pam Dooner*
> >>
> >> > 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >>Member, MIT Student Information Processing Board  (SIPB)
> >>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
> >>warl...@mit.eduPGP key available
> >>
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
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 & macOS High Sierra.

[Derek Atkins]

Yes, if you change your locale back to the old locale it should work again.

-derek

On Wed, December 13, 2017 1:34 pm, Pam Dooner wrote:
> Thank you for this explanation. If I change my locale to UK, will
> everything then be OK? Otherwise how do I change the SX definitions?
> Regards,
> Pam
>
>
> *Pam Dooner*
>
> On 13 December 2017 at 16:30, Derek Atkins  wrote:
>
>> Hi,
>>
>> Pam Dooner  writes:
>>
>> > yes, definitely 2.6.18. Just tried again and this time managed to get
>> a
>> > pop-up saying "An error occurred while processing 0.99"
>> > I am trying to change all my decimal points to commas to coincide with
>> the
>> > euro locale that I have to use now it seems. In the older versions,
>> there
>> > was no issue with commas and points. I have UK accounts and european
>> > accounts so ought to be able to use both but this version (and the
>> previous
>> > one) seem to cause the error if I try to use a decimal point. So I'll
>> have
>> > to try to edit the file elsewhere and re-import it. I had hoped there
>> might
>> > have been a way of globally changing all previous entries with a
>> decimal
>> > point to commas. In the actual accounts, it has changed them all to
>> commas
>> > but not in scheduled transactions!
>> > Pam
>>
>> Scheduled Transactions do not survive a locale change, specifically a
>> change where the decimal separator changes characters.  The reason is
>> that the SX data is stored as text, not as a numeric, so "99/100" gets
>> stored as 0.99 and then it expects to be parsed as 0.99 -- however if
>> you change your locale so that a comma is a decimal separator then
>> GnuCash expects to read back 0,99.  But when it sees 0.99 it doesn't
>> know how to interpret that.
>>
>> The only fix is to change the SX definitions, or to change your locale
>> specification of (IIRC) LC_NUMERIC back to the old style.
>>
>> I don't know if there is a way change the character from within the
>> program.
>>
>> > *Pam Dooner*
>>
>> > 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>Member, MIT Student Information Processing Board  (SIPB)
>>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>>warl...@mit.eduPGP key available
>>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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 & macOS High Sierra.

[Pam Dooner]

Thank you for this explanation. If I change my locale to UK, will
everything then be OK? Otherwise how do I change the SX definitions?
Regards,
Pam


*Pam Dooner*

On 13 December 2017 at 16:30, Derek Atkins  wrote:

> Hi,
>
> Pam Dooner  writes:
>
> > yes, definitely 2.6.18. Just tried again and this time managed to get a
> > pop-up saying "An error occurred while processing 0.99"
> > I am trying to change all my decimal points to commas to coincide with
> the
> > euro locale that I have to use now it seems. In the older versions, there
> > was no issue with commas and points. I have UK accounts and european
> > accounts so ought to be able to use both but this version (and the
> previous
> > one) seem to cause the error if I try to use a decimal point. So I'll
> have
> > to try to edit the file elsewhere and re-import it. I had hoped there
> might
> > have been a way of globally changing all previous entries with a decimal
> > point to commas. In the actual accounts, it has changed them all to
> commas
> > but not in scheduled transactions!
> > Pam
>
> Scheduled Transactions do not survive a locale change, specifically a
> change where the decimal separator changes characters.  The reason is
> that the SX data is stored as text, not as a numeric, so "99/100" gets
> stored as 0.99 and then it expects to be parsed as 0.99 -- however if
> you change your locale so that a comma is a decimal separator then
> GnuCash expects to read back 0,99.  But when it sees 0.99 it doesn't
> know how to interpret that.
>
> The only fix is to change the SX definitions, or to change your locale
> specification of (IIRC) LC_NUMERIC back to the old style.
>
> I don't know if there is a way change the character from within the
> program.
>
> > *Pam Dooner*
>
> > 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
>
___
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: Docs: Where to document?

[Nith Valley Organics]

We do have sqlite3 on the mac.

> On Dec 12, 2017, at 7:57 PM, brad  wrote:
> 
> I would like to see something on this in the wiki.
> 
> Just because Mac & windows don't have python and sql by default doesn't mean 
> that the knowledge base should be dumbed down.
> 
> 
> On 12/11/2017 09:29 PM, John Ralls wrote:
>> 
>>> On Dec 11, 2017, at 4:41 PM, Charles Sliger  wrote:
>>> 
>>> 
>>> On Mon, 2017-12-11 at 16:01 -0800, John Ralls wrote:
> On Dec 11, 2017, at 2:27 PM, Charles Sliger  wrote:
> 
> I'm starting to migrate from QuickBooks to GnuCash.
> I'm working my way through the integration issues with
> Gnucash - Python - Postgresql
> How would the GnuCash team prefer that I document this for the benefit
> of others?
> 
> I've got about 30 years of unix/database/network systems engineering
> under my belt and without that to draw on I don't think I would be able
> to work my way through this as the documentation seems rather sparse and
> fractured.
> 
> I'll have to document it for my own purposes anyway so let me know if
> there's interest.
> 
 Chaz,
 
 Can you outline what you propose to document? Integration with QuickBooks 
 doesn’t really make sense to me and SQL servers have plenty of 
 documentation themselves as well as hundreds of books and websites 
 teaching how to administer them. Repeating any of that in our 
 documentation would be pointless.
 
 Regards,
 John Ralls
 
 
>>> John,
>>> What I will be documenting is the actual nuts and bolts process for
>>> using GnuCash, Python, and Postgresql together.  Integration is probably
>>> too strong a word right now but I see these three as being very
>>> complementary.  While it might be true that all of the information is
>>> out there somewhere, I have had to make a number of educated guesses in
>>> the process of just getting GnuCash and Postgresql working together.
>>> This was after purchasing and reading all three books on GnuCash and
>>> spending a good deal of time with on-line research.  Most people are not
>>> going to have the time to become dba's in order to reap the benefits of
>>> an RDBMS such as Postgresql.  I find they can benefit from having the
>>> documentation for something like this pulled together in a single
>>> narrative.  Given that the average PC today can easily handle running a
>>> combination like this, it seems natural to leverage the capabilities of
>>> a database like Postgresql.
>>> S...  I just thought I'd ask if there was a place put this kind of
>>> information and a process for getting it there.
>> It seems to me that your personal blog might be a good place to document the 
>> “process”. I think that anything involving coding is not of major interest 
>> to 99 and 44/100% of our user base. That’s not to say that you can’t write 
>> useful articles about it for the wiki, but the wiki’s general style is more 
>> descriptive than narrative.
>> 
>> As for most people not having the time to learn to be DBAs, I agree. What I 
>> disagree about is that they should set up a DB server anyway. With your 30 
>> years of experience you might think that maintaining a DB server and 
>> ensuring that it’s secure and that the data is properly backed up is 
>> trivial, but for nearly all users that’s far from being the case. If it’s 
>> possible to write “How to be a competent DBA in 30 minutes” then there are a 
>> dozen books and 100+ websites out there already. I haven’t found them and I 
>> don’t think it’s possible, but if I’m wrong then far better to put some 
>> pointers in the wiki than to create the 137th version.
>> 
>> It is possible, even simple, to enjoy the benefits of SQL without messing 
>> around with being a server DBA. SQLite3 creates a very usable SQL database 
>> in a single file that can be easily copied for backup, no administration 
>> required--in fact, nothing much to administer.
>> 
>> One more point: You perhaps misunderstand how GnuCash uses the database 
>> backends. It is not (yet, nor will it be in 2.8) a database application. It 
>> uses the database as a data store, reading the whole thing into memory at 
>> the beginning of the session. After that the only queries are updates and 
>> inserts.
>> 
>> To answer your final question, the place in the GnuCash infrastructure to 
>> put it would be the wiki, https://wiki.gnucash.org/wiki 
>> . Thanks to spammers we have had to insert 
>> human approval into the account creation process. Just say something about 
>> what you want to write so that we know that you’re not a spam-bot or someone 
>> who thinks they need a wiki account to use the program and your request will 
>> be quickly approved. After that there’s a one-week waiting period for your 
>> account to be blessed for editing. There might be an issue about creating 
>> pages after 

Re: Report error An error occurred while running the report.

[Christopher Lam]

Also the trace file will be useful.
https://wiki.gnucash.org/wiki/Tracefile

On 13 Dec 2017 23:40, "Christopher Lam"  wrote:

> Well start by stating which report caused the error. Which options did you
> modify. Did you change any global or book defaults. Any particularities
> about your data file etc.
>
> On 13 Dec 2017 21:08, "Dane Dormio"  wrote:
>
> How would I do this?
>
> - 619-663-7819
>
> www.danedormio.com
>
> On Wed, Dec 13, 2017 at 6:27 PM, Christopher Lam <
> christopher@gmail.com> wrote:
>
>> Not every report handles error conditions smoothly. It would be useful to
>> summarise the report chosen and the options used. The report can then be
>> fixed for the next release.
>>
>> On 13 Dec 2017 4:22 PM, "Dane Dormio"  wrote:
>>
>>> I am running the latest version of GNUcash (2.6.18) on Windows 10.  When
>>> I
>>> choose report type the default report for that type works fine, but when
>>> I
>>> try to customize the report I get the following error: "Report error An
>>> error occurred while running the report."  Currently I am trying to run
>>> an
>>> expense report over a ten day period for a single expense category and am
>>> getting this error.  What can I do to fix it?
>>>
>>> Thanks
>>> ___
>>> 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: Report error An error occurred while running the report.

[Christopher Lam]

Well start by stating which report caused the error. Which options did you
modify. Did you change any global or book defaults. Any particularities
about your data file etc.

On 13 Dec 2017 21:08, "Dane Dormio"  wrote:

How would I do this?

- 619-663-7819

www.danedormio.com

On Wed, Dec 13, 2017 at 6:27 PM, Christopher Lam 
wrote:

> Not every report handles error conditions smoothly. It would be useful to
> summarise the report chosen and the options used. The report can then be
> fixed for the next release.
>
> On 13 Dec 2017 4:22 PM, "Dane Dormio"  wrote:
>
>> I am running the latest version of GNUcash (2.6.18) on Windows 10.  When I
>> choose report type the default report for that type works fine, but when I
>> try to customize the report I get the following error: "Report error An
>> error occurred while running the report."  Currently I am trying to run an
>> expense report over a ten day period for a single expense category and am
>> getting this error.  What can I do to fix it?
>>
>> Thanks
>> ___
>> 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: Gnucash & macOS High Sierra.

[Derek Atkins]

Hi,

Pam Dooner  writes:

> yes, definitely 2.6.18. Just tried again and this time managed to get a
> pop-up saying "An error occurred while processing 0.99"
> I am trying to change all my decimal points to commas to coincide with the
> euro locale that I have to use now it seems. In the older versions, there
> was no issue with commas and points. I have UK accounts and european
> accounts so ought to be able to use both but this version (and the previous
> one) seem to cause the error if I try to use a decimal point. So I'll have
> to try to edit the file elsewhere and re-import it. I had hoped there might
> have been a way of globally changing all previous entries with a decimal
> point to commas. In the actual accounts, it has changed them all to commas
> but not in scheduled transactions!
> Pam

Scheduled Transactions do not survive a locale change, specifically a
change where the decimal separator changes characters.  The reason is
that the SX data is stored as text, not as a numeric, so "99/100" gets
stored as 0.99 and then it expects to be parsed as 0.99 -- however if
you change your locale so that a comma is a decimal separator then
GnuCash expects to read back 0,99.  But when it sees 0.99 it doesn't
know how to interpret that.

The only fix is to change the SX definitions, or to change your locale
specification of (IIRC) LC_NUMERIC back to the old style.

I don't know if there is a way change the character from within the program.

> *Pam Dooner*

> 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Report error An error occurred while running the report.

[Derek Atkins]

Dane Dormio  writes:

> I am running the latest version of GNUcash (2.6.18) on Windows 10.  When I
> choose report type the default report for that type works fine, but when I
> try to customize the report I get the following error: "Report error An
> error occurred while running the report."  Currently I am trying to run an
> expense report over a ten day period for a single expense category and am
> getting this error.  What can I do to fix it?

Can you report the gnucash.trace that occurs when you get this error?
If there was an underlying crash in the report then it should be
reported there.

> 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Accounts as hyperlinks ignores the report options date range bug

[Derek Atkins]

HI,

Chris Velevitch  writes:

> I've recreated a profit and loss report with a specific date range and set
> the display accounts as hyperlinks.

How are you encoding the date range in the account hyperlink?

> When I click on a link, the account is not filtered by the date range for
> the report, I get all transactions for that account. Is this a bug?

> 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Invoice & Bill Posting Date Issues Across Multiple Periods

[Derek Atkins]

Adrien Monteleone  writes:

> I don’t think I’m mixing cash-accrual, but just to clear up any
> confusion, let’s forget when I actually pay the pre-paid expense. When
> do I incur it? When the bill is generated by the insurer? When I
> receive the bill? When I enter it in GnuCash? When it is due? (the
> effective date of the policy) In short, what should my posting date
> be? (#2 below)

Well, when you incur the "expense" differs based on cash vs accrual
accounting.  IMHO (IANAA) you incur the expense (under accrual) some
time between when the bull is generated and when you receive it.  Under
cash it's of course when you pay it.

[snip]
> I’ll wait for now. I see this as a separate issue. I'm not asking a
> question of cash vs. accrual for post-billed expenses, but single
> vs. multiple posting dates. Just under an accrual method, a
> multi-period bill/invoice is not recognized properly in one step. It
> still (like paper) requires correcting entries to accrue amounts back
> and forth across period boundaries. I see that the needed info is
> already present in the bill/invoice, just not being used.

As I said in my last reply, there is a 1:1 mapping of Invoice <->
Transaction, so you cannot have "multiple posting dates".  If that's an
issue, then enter multiple invoices.

You CAN have a single invoice (with a single date) that collects
multiple days or work.  For example, if I get my car serviced the work
done could take a week -- the bill I receive from them has a single
date, but the line-items each have individual dates.  It doesn't matter
if the car was in the shop across an accounting period boundary -- it's
a single bill and gets entered/dated when you receive it.

Maybe you need to supply a use case where you actually receive a single
bill for something that actually needs to be split across multiple
periods.  I still don't see that here. 

> Now, maybe making this change would help both use cases, but the cash
> case still depends on payment dates, and I’m not concerned with
> payment dates at all here, just single vs. multi-period postings.
>
> My apologies if addressing the pre-billed/pre-paid recognition
> question at the same time as the single/multi-period posting question
> confused things. I considered separating the posts and probably should
> have. They are two separate issues.

I think they are related issues.  There's a question of when the value
hits your A/R or A/P accounts, when it hits your Bank account, and when
it hits your Income/Expense accounts. Of course there's the added
question of what do you do with the value if you necessarily need to
split the dates of when it hits A/R;A/P vs when it hits your
Bank;Income/Expense.

> Thanks for your insights,
> Adrien

> 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Invoice & Bill Posting Date Issues Across Multiple Periods

[Derek Atkins]

Adrien Monteleone  writes:

> Thank you Derek,
>
> The inefficiency I referenced was in respect to having to make many
> accrual entries at the end and beginning of each month simply to shift
> the recognition of parts of invoices and bills to their proper periods
> that otherwise would not have to be done if the posting process
> allowed for using the line-item dates. As it stands, using a single
> posting date for a bill/invoice that either crosses periods or
> contains multiple periods results in incorrect recognition. This is
> what I mean by a carryover limitation of paper ledgers. That practice
> was necessary with paper. It is not with computers. (at least I don’t
> see that it is, of course, if you *want* to make all those entries
> manually, by all means… )

The design is such that a single invoice is not supposed to cross period
boundaries.  If you find you are invoicing your customers across
periods, that implies (to me) that you don't invoice often enough (or
your periods are way too short).  Making new invoices (at least one per
period) is rather cheap, so I recommend you do that ;)

It's certainly true that the invoice posting and payments could occur in
different boundaries -- which revert back to the cash v accrual
accounting question.  In accrual accounting that disparity is fine.

Oh, and in terms of a vendor bill, in my mind the period is when I
receive the bill.  If someone did work for me in December and doesn't
bill me until February, I'm booking it in February.

> I’m not asking for the business features to work on a cash basis. I’m
> wanting them to not cause me to have to make multiple correcting
> entries for proper expense and revenue recognition. I’m not concerned
> with recognizing bills/invoices when the money changes hands. I’m
> concerned with recognizing them when the expense is incurred or the
> work performed. This works perfectly if everything is tidy in one
> period. It’s a mess if the ‘document' is not.

If it's your own invoicing, then just invoice more often.

If it's a vendor bill, then treat it as a single transaction regardless
of when they did the work... Or enter it as multiple related vendor
bills.

> Perhaps I’m misunderstanding something that you or someone else could
> help clear up for me. Let’s take a simpler example of a single period
> bill:
>
> I receive local telephone service in October. The phone company
> generates a bill for that October service on November 7th. It arrives
> (postmarked) November 12th. I enter it in GnuCash the same day. The
> due date is November 27th.
>
> What should my posting date be?
>
> 1) November 7th?
> 2) November 12th?
> 2) November 27th?
> 3) some date in October? (31st perhaps)
> 4) something else?

Nov 12.  That's when you received the bill and posted it to your account.

> What should the ‘opening date’ be?
>
> 1) November 7th?
> 2) November 12th?
> 3) something else?
> 4) If I enter the bill on November 13th, is *that* the opening date?
>
> I guess I’m thinking the ‘opening date’ must preceded the posting
> date, but I suppose that doesn’t matter. (maybe that’s me carrying
> over from paper here)

The opening date would be Nov 7.  That's the date the bill is dated.

> Now, let’s complicate things:
>
> I also receive long-distance telephone service from the same phone
> company and they bill me on one bill for everything. That November 7th
> bill is for long-distance calls made in September AND October. All
> other dates remain the same.
>
> What should my posting date be?
>
> 1) same as above?
> 2) same as above and then I have to accrue September’s charges back
> and forth from the above date?
> 3) some date in September and then accrue October’s charges back and forth?
> 4) something else?

Same as above.  It doesn't matter that you made the calls in September,
it matters that you're being billed in November.

> What should the ‘opening date be?
>
> 1) same as above?
> 2) some date in September?
> 3) something else?

Same as above.

> (Thankfully, I don’t have to deal with customer charge-backs using the
> business features in this scenario as not only is there a limitation
> of one customer & job per bill, there is the added limitation of one
> period. But it would be nice to see how much expense a particular
> customer is ‘costing' me.)
>
> Derek, thank you very much for your time and effort and thank you for
> writing the business features in the first place! Long ago I was sold
> on GnuCash over other options precisely because I found this mailing
> list and found that developers are active on it. I can’t express
> enough how valuable that is and how much it is appreciated. I shudder
> to think of the cold, faceless brick wall I would encounter (and have)
> with other software. GnuCash and its developer team deserve FOSS
> awards for sure.
>
> Please don’t take anything I say here as any form of criticism or
> complaint. I’m merely trying to understand how this is supposed to
> 

Re: Issue opening Gnucash file

[Derek Atkins]

Hi,

Well, the last potential issue is that the g_utf8_to_utf16() critical
log message is the cause.  This would imply that there is some non-UTF8
characters in your data file.  How it got into your data file is
unclear, but alas you might need to track that down.

Can you try to open a backup file?  Maybe you can track down when the
errant data occurred?

-derek

green thumb  writes:

> I'm sure.  I looked at the properties of the file and it is .gnucash. There
> are also two log files in the same folder that contain the last changes I
> made, so I know what they look like.  I also created a new test file just to
> see what files should be present.  The test file works fine there other
> doesn't, which also tells me it is something with this file and not the
> program.
>
> Kevin  
>
> --
> From: Derek Atkins 
> Sent: Tuesday, December 12, 2017 10:11 AM
> To: green thumb
> Cc: gnucash-user@gnucash.org
> Subject: Re: Issue opening Gnucash file
>  
> Hi,
>
> green thumb  writes:
>
>> I have been using Gnucash for awhile now.  I am working in Windows 10.
>> Recently I tried to open my file and got the error "No suitable
>> backend was found for C:...".  When I look at the trace file I see get
>> the message :
>
> Are you sure you clicked on your .gnucash file and not a .gnucash.gcm or
> .log file?
>
>> * 17:22:17 WARN  Could not spawn perl: Failed to
>> execute child process (No such file or directory)
>> * 17:23:24  WARN  Could not find the icon 'gtk-file'. The 'hicolor'
> theme
>> was not found either, perhaps you need to install it.
>> You can get a copy from:
>> http://icon-theme.freedesktop.org/releases
>> * 17:23:28  CRIT  g_utf8_to_utf16: assertion 'str != NULL' failed
>>
>> I installed the newest Gnucash program (version 2.6.18).
>>
>> Not sure what to do now.  Would really like to get access to this file
>> again.  Any ideas or suggestions.
>
>> 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>  Derek's Home Page - Massachusetts Institute of Technology
>  web.mit.edu  
> [warlord-2003-2] Derek Atkins ---  This is the Home Page of  
>  Derek Atkins . I, as you know, am Derek. It 
>  has been many years since I've reorganized ...   
>
>warl...@mit.eduPGP key available
>

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Report error An error occurred while running the report.

[Christopher Lam]

Not every report handles error conditions smoothly. It would be useful to
summarise the report chosen and the options used. The report can then be
fixed for the next release.

On 13 Dec 2017 4:22 PM, "Dane Dormio"  wrote:

> I am running the latest version of GNUcash (2.6.18) on Windows 10.  When I
> choose report type the default report for that type works fine, but when I
> try to customize the report I get the following error: "Report error An
> error occurred while running the report."  Currently I am trying to run an
> expense report over a ten day period for a single expense category and am
> getting this error.  What can I do to fix it?
>
> Thanks
> ___
> 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: Gnucash & macOS High Sierra.

[Maf. King]

On Wednesday, 13 December 2017 11:39:10 GMT Pam Dooner wrote:
> yes, definitely 2.6.18. Just tried again and this time managed to get a
> pop-up saying "An error occurred while processing 0.99"
> I am trying to change all my decimal points to commas to coincide with the
> euro locale that I have to use now it seems. In the older versions, there
> was no issue with commas and points. I have UK accounts and european
> accounts so ought to be able to use both but this version (and the previous
> one) seem to cause the error if I try to use a decimal point. So I'll have
> to try to edit the file elsewhere and re-import it. I had hoped there might
> have been a way of globally changing all previous entries with a decimal
> point to commas. In the actual accounts, it has changed them all to commas
> but not in scheduled transactions!
> Pam

Hi Pam,

I believe that any version of GC would cause you grief in the situation you 
describe.

I think I read on this list that the template transaction amounts in a 
scheduled transaction are stored as alphanumeric strings, so if there is a 
comma or decimal point in those, they really are those physical characters.

whereas, the numbers in the registers are stored as numbers, so the comma/
decimal point isn't stored as a physical character, software effectively puts 
it  in automatically to make the numbers meaningful to a human as it displays 
them. 

I know it doesn't help your pain, but I thought it might offer some context. 

Maf.


___
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 & macOS High Sierra.

[David T. via gnucash-user]

So, that sounds like a problem with a change in locale settings, and not a 
problem with Sierra. 
I doubt the original poster is encountering the same problem as you. 
David
 
 
  On Wed, Dec 13, 2017 at 16:39, Pam Dooner wrote:   yes, 
definitely 2.6.18. Just tried again and this time managed to get a
pop-up saying "An error occurred while processing 0.99"
I am trying to change all my decimal points to commas to coincide with the
euro locale that I have to use now it seems. In the older versions, there
was no issue with commas and points. I have UK accounts and european
accounts so ought to be able to use both but this version (and the previous
one) seem to cause the error if I try to use a decimal point. So I'll have
to try to edit the file elsewhere and re-import it. I had hoped there might
have been a way of globally changing all previous entries with a decimal
point to commas. In the actual accounts, it has changed them all to commas
but not in scheduled transactions!
Pam


*Pam Dooner*

On 13 December 2017 at 11:36, Dave H  wrote:

> Pam,
>
> I haven't had any of the issues you are talking about - running 2.6.18 on
> 10.13.2 at the moment on both an iMac and a Macbook pro.  My scheduled
> transactions are all editable and scheduling correctly.  Are you sure
> you're running 2.6.18 and not 2.6.17 which is the version that has issues I
> believe ?
>
> Cheers Dave H.
>
> On 13 December 2017 at 19:56, Pam Dooner  wrote:
>
>> The latest version opens but there are issues. Such as scheduled
>> transactions not being editable or scheduled. Trying just causes crash and
>> having to force quit. I’m going to try to edit the gnucash file on an older
>> windows pc then open it in high sierra to see if that helps.
>> Watch this space!
>>
>> Le mer. 13 déc. 2017 à 10:14, Dave H  a écrit :
>>
>>> There is an issue when you are not using the latest version of gnucash on
>>> High Sierra.  If you aren't using 2.6.18 download and install 2.6.18 and
>>> your issue should go away.
>>>
>>> Cheers Dave H.
>>>
>>> On 13 December 2017 at 08:47, James Armstrong 
>>> wrote:
>>>
>>> > Hi,
>>> >
>>> > Without thinking I,ve just updated my MacBook Pro with the latest
>>> version
>>> > of macOS High Sierra version 10.13.1.
>>> >
>>> > Gnucash will not start!
>>> >
>>> > A pop up message states:  Gnucash cannot be opened because of a
>>> problem.
>>> > Check with the developer to make sure Gnucash works with this version
>>> of
>>> > macOS.
>>> >
>>> > Is this the case?
>>> >
>>> > Any help you could offer would be much appreciated.
>>> >
>>> > Thank you.
>>> >
>>> > Jim
>>> >
>>> >
>>> > James Armstrong
>>> > LonghornJim®
>>> > 07905 103568
>>> > j...@longhornjim.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.
>>
>> --
>> Sent from Pam’s iPhone
>>
>
>
___
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: Report error An error occurred while running the report.

[David T. via gnucash-user]

Are you sure that there are any transactions for the period you selected? I'm 
not certain, but I believe that an empty return set gives this. This is an 
unfortunate communication. 
David


 
 
  On Wed, Dec 13, 2017 at 13:18, Dane Dormio wrote:   I 
am running the latest version of GNUcash (2.6.18) on Windows 10.  When I
choose report type the default report for that type works fine, but when I
try to customize the report I get the following error: "Report error An
error occurred while running the report."  Currently I am trying to run an
expense report over a ten day period for a single expense category and am
getting this error.  What can I do to fix it?

Thanks
___
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: Gnucash & macOS High Sierra.

[Pam Dooner]

yes, definitely 2.6.18. Just tried again and this time managed to get a
pop-up saying "An error occurred while processing 0.99"
I am trying to change all my decimal points to commas to coincide with the
euro locale that I have to use now it seems. In the older versions, there
was no issue with commas and points. I have UK accounts and european
accounts so ought to be able to use both but this version (and the previous
one) seem to cause the error if I try to use a decimal point. So I'll have
to try to edit the file elsewhere and re-import it. I had hoped there might
have been a way of globally changing all previous entries with a decimal
point to commas. In the actual accounts, it has changed them all to commas
but not in scheduled transactions!
Pam


*Pam Dooner*

On 13 December 2017 at 11:36, Dave H  wrote:

> Pam,
>
> I haven't had any of the issues you are talking about - running 2.6.18 on
> 10.13.2 at the moment on both an iMac and a Macbook pro.  My scheduled
> transactions are all editable and scheduling correctly.  Are you sure
> you're running 2.6.18 and not 2.6.17 which is the version that has issues I
> believe ?
>
> Cheers Dave H.
>
> On 13 December 2017 at 19:56, Pam Dooner  wrote:
>
>> The latest version opens but there are issues. Such as scheduled
>> transactions not being editable or scheduled. Trying just causes crash and
>> having to force quit. I’m going to try to edit the gnucash file on an older
>> windows pc then open it in high sierra to see if that helps.
>> Watch this space!
>>
>> Le mer. 13 déc. 2017 à 10:14, Dave H  a écrit :
>>
>>> There is an issue when you are not using the latest version of gnucash on
>>> High Sierra.  If you aren't using 2.6.18 download and install 2.6.18 and
>>> your issue should go away.
>>>
>>> Cheers Dave H.
>>>
>>> On 13 December 2017 at 08:47, James Armstrong 
>>> wrote:
>>>
>>> > Hi,
>>> >
>>> > Without thinking I,ve just updated my MacBook Pro with the latest
>>> version
>>> > of macOS High Sierra version 10.13.1.
>>> >
>>> > Gnucash will not start!
>>> >
>>> > A pop up message states:   Gnucash cannot be opened because of a
>>> problem.
>>> > Check with the developer to make sure Gnucash works with this version
>>> of
>>> > macOS.
>>> >
>>> > Is this the case?
>>> >
>>> > Any help you could offer would be much appreciated.
>>> >
>>> > Thank you.
>>> >
>>> > Jim
>>> >
>>> >
>>> > James Armstrong
>>> > LonghornJim®
>>> > 07905 103568
>>> > j...@longhornjim.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.
>>
>> --
>> Sent from Pam’s iPhone
>>
>
>
___
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 & macOS High Sierra.

[Dave H]

Pam,

I haven't had any of the issues you are talking about - running 2.6.18 on
10.13.2 at the moment on both an iMac and a Macbook pro.  My scheduled
transactions are all editable and scheduling correctly.  Are you sure
you're running 2.6.18 and not 2.6.17 which is the version that has issues I
believe ?

Cheers Dave H.

On 13 December 2017 at 19:56, Pam Dooner  wrote:

> The latest version opens but there are issues. Such as scheduled
> transactions not being editable or scheduled. Trying just causes crash and
> having to force quit. I’m going to try to edit the gnucash file on an older
> windows pc then open it in high sierra to see if that helps.
> Watch this space!
>
> Le mer. 13 déc. 2017 à 10:14, Dave H  a écrit :
>
>> There is an issue when you are not using the latest version of gnucash on
>> High Sierra.  If you aren't using 2.6.18 download and install 2.6.18 and
>> your issue should go away.
>>
>> Cheers Dave H.
>>
>> On 13 December 2017 at 08:47, James Armstrong 
>> wrote:
>>
>> > Hi,
>> >
>> > Without thinking I,ve just updated my MacBook Pro with the latest
>> version
>> > of macOS High Sierra version 10.13.1.
>> >
>> > Gnucash will not start!
>> >
>> > A pop up message states:   Gnucash cannot be opened because of a
>> problem.
>> > Check with the developer to make sure Gnucash works with this version of
>> > macOS.
>> >
>> > Is this the case?
>> >
>> > Any help you could offer would be much appreciated.
>> >
>> > Thank you.
>> >
>> > Jim
>> >
>> >
>> > James Armstrong
>> > LonghornJim®
>> > 07905 103568
>> > j...@longhornjim.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.
>
> --
> Sent from Pam’s iPhone
>
___
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 & macOS High Sierra.

[Dave H]

There is an issue when you are not using the latest version of gnucash on
High Sierra.  If you aren't using 2.6.18 download and install 2.6.18 and
your issue should go away.

Cheers Dave H.

On 13 December 2017 at 08:47, James Armstrong  wrote:

> Hi,
>
> Without thinking I,ve just updated my MacBook Pro with the latest version
> of macOS High Sierra version 10.13.1.
>
> Gnucash will not start!
>
> A pop up message states:   Gnucash cannot be opened because of a problem.
> Check with the developer to make sure Gnucash works with this version of
> macOS.
>
> Is this the case?
>
> Any help you could offer would be much appreciated.
>
> Thank you.
>
> Jim
>
>
> James Armstrong
> LonghornJim®
> 07905 103568
> j...@longhornjim.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: GnuCash: Docs: Where to document?

[Wm via gnucash-user]

On 13/12/2017 00:57, brad wrote:

I would like to see something on this in the wiki.

Just because Mac & windows don't have python and sql by default doesn't 
mean that the knowledge base should be dumbed down.


It is not a case of dumbing down.  Building gnucash with python on 
windows is genuinely difficult.  It involves exact versions of a whole 
load of supporting bits and pieces and as soon as any of those change 
you have to start again.


--
Wm


___
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 & macOS High Sierra.

[James Armstrong]

Hi,

Without thinking I,ve just updated my MacBook Pro with the latest version of 
macOS High Sierra version 10.13.1.

Gnucash will not start! 

A pop up message states:   Gnucash cannot be opened because of a problem. Check 
with the developer to make sure Gnucash works with this version of macOS.

Is this the case?

Any help you could offer would be much appreciated.

Thank you.

Jim 


James Armstrong 
LonghornJim®
07905 103568
j...@longhornjim.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.

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

[adrian]

I'm tracking expenses so I know where my money goes, not in order to comply
with regulations.   It seems like if I were tracking these expenses because
I was going to deduct them from something from business income for tax
purposes then the best approach would be to isolate the business
expenses---purchase the gift card with a business asset and then use the
gift card only for business expenses and there's no ambiguity.  If, in fact,
you buy a discounted asset and then use it to buy some deductible things and
some non-deductible things I don't have a clue what accounting law requires. 
Would you be allowed to spend $250 on deductible items, $250 on
non-deductible items, and then the $70 becomes taxable income?  Nontaxable
income?  To me the only strategy that seems reasonable for making sense of
this is the very one I'm proposing, which would be equivalent to dividing
the $70 proportionally into taxable and nontaxable income.   As you say, the
"gift" method is potentially problematic because you can't tell which $70 is
"gift" and which isn't, so it seems like that makes accurate accounting
impossible. 

To me it does not make any sense to identify discounts from merchants as
"gifts".  That's just not an accurate description of the situation.  The
merchant did not give me a "gift".  The merchant gave me a discount.  I
suppose I have to agree that if I walked into a store where I never shop and
the storekeeper handed me $70 there would be no other reasonable way to
account for this.  But this is not a situation that occurs.   The merchant
offered me the $70 only after I already paid $430.   My thinking when I
bought the gift card was specifically that I will acquire merchandise from
this merchant (in the future) at a discount---not that I am getting a gift
from the merchant.  Just like I do not consider it a gift if I order an item
at "50% off".  This situation seems to me the same.  

Declaring the $70 to be a rebate from the merchant seems like a reasonable
method.  I just didn't like that so well because it captures this $70 in a
meaningless "rebate" category that doesn't really tell me what actually
happened.   And as I said before, I wouldn't buy a Widget marked "50% off"
for $100 and enter this as a $200 expense with a $100 (nontaxable) gift
income.   




Adrien Monteleone wrote
> I have to concur on the $70 gift idea.
> 
> You paid $430 for a stored value card that has $500 on it.
> 
> This is no different than if you handed a bank teller $430 in small bills
> and they returned to you 5 one hundred dollar bills. (assuming the bank is
> just fine with that)
> 
> When you spend $100 from this card you aren’t really spending $86. You’re
> spending $100.
> 
> After you’ve spent $430, the next $70 on the card is a gift to you from
> whomever sold you the card.
> 
> But you can’t truly determine which $70 is gift and which isn’t.
> 
> The easiest and likely most correct transaction is this:
> 
> Dr. Assets:Cash $430
> Dr. Income:Gift Received $70
> Cr. Assets:Prepaid Card $500
> 
> When you use the card, all transactions are just normal as if you’d paid
> $500 for it.
> 
> There is no discount. There is no rebate. You received a ‘gift’ of $70 in
> the form of extra stored value on the card.
> 
> Had you paid nothing and received a card with a $70 value, the transaction
> would be:
> 
> Dr. Income:Gift Received $70
> Cr. Assets:Prepaid Card $70
> 
> Note, the difference is NOT the $70. The difference is what you paid for
> the extra value, in this case $430.
> 
> Had you paid $430 for one card and the merchant gave you a separate card
> with $70 value on it (that’s two cards totaling $500) then your entries
> would be this:
> 
> Dr. Assets:Cash $430
> Cr. Assets:Prepaid Card $430
> 
> Dr. Income:Gift Received $70
> Cr. Assets:Prepaid Card $70
> 
> There’s no fundamental difference in these two separate transactions than
> the combined transaction above. They record the same net amounts in the
> same places. The fact that all of this takes place on one card instead of
> two, or that the gift is from a merchant instead of a family member or
> friend does not change the nature of the transaction.
> 
> You can record anything you want the way you want if this is just for you
> to keep track of, but the goal should always be to use transactions to
> show an accurate picture of what happened. What happened is NOT that you
> saved money on future purchases. What happened is you received a gift of
> $70 in the form of a stored value card.
> 
> But by all means, ask a CPA if it’s that important to you.
> 
> Regards,
> Adrien
> 
>> On Dec 7, 2017, at 3:46 PM, nvsoar 

> nvsoar@

>  wrote:
>> 
>> On 12/06/17 12:44, adrian wrote:
>>> Tommy Trussell wrote
> Adrian:
> In the case at hand I spent $430 on the gift card and when I buy
> something
> that costs $100, I'm really only spending $86.  That's what makes
> sense
> to
> me for how this ought to be counted.   Since I don't know the 

Accounts as hyperlinks ignores the report options date range bug

[Chris Velevitch]

I've recreated a profit and loss report with a specific date range and set
the display accounts as hyperlinks.

When I click on a link, the account is not filtered by the date range for
the report, I get all transactions for that account. Is this a bug?



Chris
--
Chris Velevitch
m: 0415 469 095
___
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.