Accounts as hyperlinks ignores the report options date range bug

2017-12-13 Thread 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 _

Report error An error occurred while running the report.

2017-12-13 Thread Dane Dormio
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 ex

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

2017-12-13 Thread 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---

Gnucash & macOS High Sierra.

2017-12-13 Thread 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.

Re: GnuCash: Docs: Where to document?

2017-12-13 Thread Wm via gnucash-user
On 12/12/2017 00:41, 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 wou

Re: GnuCash: Docs: Where to document?

2017-12-13 Thread 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 genuin

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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 MacBo

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread Pam Dooner
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

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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 be

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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 comm

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

2017-12-13 Thread 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.1

Re: Accounts as hyperlinks ignores the report options date range bug

2017-12-13 Thread David T. via gnucash-user
I suspect that this is how the links are programmed, so, technically not a bug--but certainly not what you are hoping for.  You should file an enhancement request on Bugzilla, but you might not see action on it for some time; the reports don't get a lot of developer attention.  David On We

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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

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

2017-12-13 Thread 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

Re: Issue opening Gnucash file

2017-12-13 Thread 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

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-13 Thread 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

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-13 Thread 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? (

Re: Accounts as hyperlinks ignores the report options date range bug

2017-12-13 Thread 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,

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

2017-12-13 Thread 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." Curr

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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 vers

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

2017-12-13 Thread 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 a

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

2017-12-13 Thread 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

Re: GnuCash: Docs: Where to document?

2017-12-13 Thread 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, Joh

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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 th

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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 > > >

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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 acc

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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, >

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread Pam Dooner
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 re

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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 schedule

gnucash on multiple computers

2017-12-13 Thread 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: Jus

Re: GnuCash: Price Editor -- Linux Mint

2017-12-13 Thread 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

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread 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

Re: GnuCash: Price Editor -- Linux Mint

2017-12-13 Thread 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

RE: Cannot edit opening balance

2017-12-13 Thread 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

Re: Cannot edit opening balance

2017-12-13 Thread 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 reco

Re: Cannot edit opening balance

2017-12-13 Thread 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 b

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-13 Thread 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 i