Re: 2.7.4 install

2018-02-08 Thread Geert Janssens
Op donderdag 8 februari 2018 02:03:44 CET schreef Michael via gnucash-user: > Hello all, I haven't seen much about 2.7.4, so maybe this is not the > place. Anyway I was able to install on linux using cmake (first time > for me). Went reasonably well given all. It worked! Used yahoo as json >

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread John Ralls
> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user > wrote: > > In thread > https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html > , > I noted that after upgrading

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
John, Thanks for the suggestion. I inserted the line as you indicated (at line 324 in my copy of gnc-fq-helper), but didn’t get any output on the command line after “Found Finance::Quote version 1.47” I’m not much for perl, but I noticed your snippet had one ‘(‘, one ‘{‘, and two ‘}’. I

Applying Customer overpayments

2018-02-08 Thread Alan Johnson
Hello, I'm having an issue with GnuCash. A customer has a overpayment/credit balance. How do I apply it to an invoice so that it comes out of the AR report at the bottom of the customer report? The total due / sums are correct, but the customer report has a 91+ day balance of (0.03). I would

Re: can't change preferences [SOLVED]

2018-02-08 Thread Geert Janssens
Op woensdag 7 februari 2018 09:16:45 CET schreef Graham Menhennitt: > Thanks again for your help, > Graham I glad to hear you managed to sort this out! Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: Accounting rules

2018-02-08 Thread Adrien Monteleone
Sorry, I'm not using my usual mail software and forgot to reply to the list. I'm copying this for posterity, my apologies Bert for the duplicate message. -- I suppose the term 'exploit' then was the most concise and precise choice. It just wasn't what I guess I was thinking of in

Re: Applying Customer overpayments

2018-02-08 Thread Geert Janssens
Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson: > Hello, I'm having an issue with GnuCash. A customer has a > overpayment/credit balance. How do I apply it to an invoice so that it > comes out of the AR report at the bottom of the customer report? The > total due / sums are

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread Geert Janssens
David, You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/ Library/Application Support/Gnucash) If you then start gnucash from the command line, it should print out the value of your API key there, together with the version of Finance::Quote that got installed. Unless the

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-08 Thread Roger Miskowicz
Thanks Tim, that is the same as my situation and I like your solution. I am not worried about tax time as I just need to have a general idea I can use for a sort of sanity check. I will try your solution in parallel. On Thu, Feb 8, 2018 at 11:30 AM, Timothy B. Taylor

Re: How to relate Transfer Sales to Cash to Customer?

2018-02-08 Thread Derek Atkins
No. Customers only exist in AR. Sorry. -derek Sent using my mobile device. Please excuse any typos. On February 8, 2018 2:17:56 PM Fran_3 via gnucash-user wrote: When a customer pays cash or by credit card there is no reason to create an invoice... so we click

How to relate Transfer Sales to Cash to Customer?

2018-02-08 Thread Fran_3 via gnucash-user
When a customer pays cash or by credit card there is no reason to create an invoice... so we click Accounts Tab -> Action -> Transfer and transfer directly Sales to Cash But there seems to be no way to relate this to a customer so when we run a Customer Report the transactions don't show up. Is

Re: How to relate Transfer Sales to Cash to Customer?

2018-02-08 Thread Greg Feneis
I suspect Gnu Cash needs a point of sale (POS) module to handle this functionality. I bet patches are welcome. Patches, he's a popular guy. Kind regards, Greg Feneis (Galaxy S5) On Feb 8, 2018 11:23 AM, "Derek Atkins" wrote: No. Customers only exist in AR. Sorry. -derek

Duplicating Accounts?

2018-02-08 Thread Steve Isenberg via gnucash-user
I figured out how to do this once before and now for thelife of I cannot remember. I am trying to duplicate an expense account and allof its sub-accounts, with a new name of course, and zero balances. This is not a transfer of funds and I'm not duplicatingtransactions. It is basically a copy

Re: How to relate Transfer Sales to Cash to Customer?

2018-02-08 Thread Mike or Penny Novack
On 2/8/2018 4:00 PM, Greg Feneis wrote: I suspect Gnu Cash needs a point of sale (POS) module to handle this functionality. I think not exactly a module withing gnucash. What gnucash would need is the ability to accept a feed from a (typical) POS system. Whether a POS system is practical as

Finance::Quote - ASX problems (alphavantage and ASX sources)

2018-02-08 Thread ln . mailinglists
Hi All, Just a quick heads up that neither source for ASX share prices is working properly/consistently at the moment (or at least I haven't worked out the consistency issues with alpha vantage).  1) The old (and most reliable) "Single" source data feed direct from the ASX stopped working

Re: Online quotes fetching the wrong price

2018-02-08 Thread farleykj
You could also, without any alphavantage stuff, obtain quotes from the "yahoo_json" source, again using NAB.AX as the symbol. Hopefully yahoo won't kill off this source, too. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: GNUCASH Free Accounting Software

2018-02-08 Thread James fuller
Adrian, I saw your reply below. I cannot seem to print by date range. What I’m trying to do is print the bank account transactions by date. Specifically the year 2017. I also need to print out a couple of expense account transactions for the same period. I did not close 2016 and every

Re: GNUCASH Free Accounting Software

2018-02-08 Thread David Carlson
If you want to do a register report for a certain time range open the register window and choose View > Filter by.. > Date to select your time window then select Reports > Account Report. David C On Thu, Feb 8, 2018 at 5:44 PM, James fuller wrote: > Adrian, > I saw your

Re: Instructions for GST India

2018-02-08 Thread Deva -
Thanks Amish. I am glad you were able to compensate for my failings… I am sure many users can benefit from your template, especially if it gets shipped as part of the next release like Frank said. Cheers, Deva > > Message: 1 > Date: Wed, 7 Feb 2018 22:26:35 +0530 > From: Amish

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
Oh, and I mentioned this in the earlier thread, but it bears repeating: the Security Editor window has the option to display price source. As with the Chart of Accounts window, there is a selector arrow on the upper right corner which drops down a list of user-selectable co,lumns for display.

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
Unfortunately, adding these lines to my config.user did not result in any further information. I am stumped, and disappointed. It seems that an upgrade of GnuCash not only tanks one’s customized environment file in the application bundle (understandable), but also any additional files that a

13 Column Reporting Starting July ending June plus Total

2018-02-08 Thread Roger Hatton
Is there a simple way to generate a 13 column Profit and Loss and a 13 column Balance Sheet showing monthly movements? My apology if this question has been asked often before but being new I can't see the answer to what I hope is a simple question, with one menu item to action these two reports?

The Wiki, and documentation

2018-02-08 Thread Matt Graham
Thanks Dave (And sorry – I knew I forget at least one of the regular mailing list people... Should have just said that you all rock ☹ ) Anyway – your comments make a good point regarding the never ending push to try to keep it all up to date. I know that the Tut and concepts guide and manual

Re: Applying Customer overpayments

2018-02-08 Thread Alan Johnson
*replying to the list Geert, Thanks. That worked. However it wanted to apply the funds to the checking account (which were already deposited/received). I deleted that part of the transaction from the AR register, and the balance offset still works, just does not reflect as a payment on the

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
In reply to my own message, in the interest of trying to run a fresh installation of GnuCash, I logged in to a different (new) Mac user account and replicated the test there. In other words, I opened GnuCash and created a simple file with AAPL and tried to retrieve prices. I receive the same

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David Reiser
> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user > wrote: > > In thread > https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html > , > I noted that after upgrading

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread John Ralls
David, Sorry for the typos, I should have tested first. Then I would have realized that of course price-quotes.scm eats gnc-fq-helper’s stdout--that’s after all how it gets the quotes. Unfortunately it seems also to send stderr to /dev/null so that approach won’t work without changing

Re: Cash Flow View

2018-02-08 Thread David T. via gnucash-user
Matt, The wiki can always use help, so thank you! I think your approach makes sense. I will note that there already is a set of installation pages, and it may be most useful simply to move the relevant questions and answers to them. I suspect that there are similar overlaps in other areas of

Re: GNUCASH Free Accounting Software

2018-02-08 Thread David T. via gnucash-user
Or run a transaction report and set the dates accordingly. > On Feb 9, 2018, at 5:20 AM, David Carlson wrote: > > If you want to do a register report for a certain time range open the > register window and choose View > Filter by.. > Date to select your time >

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-08 Thread Roger Miskowicz
Sorry, I just want to take a number from one online brokerage report and manually put it into gnucash. On Thu, Feb 8, 2018 at 6:28 AM, David T. wrote: > Roger, > > You stay by stating that you are able to generate a report that tells you > "the current value of everything."

Re: Online quotes fetching the wrong price

2018-02-08 Thread Derek Atkins
No, the namespace has no meaning to gnucash. It's purely for human organization. Change the stock code. -derek Sent using my mobile device. Please excuse any typos. On February 8, 2018 9:10:53 AM Justin Smith wrote: Thanks - that works for me too... So how do

Re: Online quotes fetching the wrong price

2018-02-08 Thread Justin Smith
Responding to my own email... Adding ".AX" to each security "Symbol/abbreviation" for ASX stocks fixed my issue. Yahoo didn't need this suffix, but alphavantage does. Now all good! Cheers, Justin. On 8 February 2018 at 22:10, Justin Smith wrote: > Thanks - that

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-08 Thread David T. via gnucash-user
Roger,  You stay by stating that you are able to generate a report that tells you "the current value of everything."  Then, you ask how you can add another layer of complexity to accomplish the same thing? I don't understand: what's wrong with the report?  David On Thu, Feb 8, 2018 at

Re: Online quotes fetching the wrong price

2018-02-08 Thread David T. via gnucash-user
Justin, I see the same command line result. I will note that the date listed there is for 2017 (mine is the same), which suggests something is out of whack. Looking online, I see that NAB was at 33.14 on 03/13/2017, so that doesn’t work. I’ve tried various versions of the exchange (ASX, ASE,

How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-08 Thread Roger Miskowicz
I have an Investment Account which is a collection of stocks, certificates, cash etc in two currencies. I can get a report that tells me in my local currency the current value of everything. I would like to create a stock, fund, or whatever appropriate with 1 share for which I can manually

Re: Online quotes fetching the wrong price

2018-02-08 Thread Justin Smith
Hi David, Thanks for your email - it's interesting that it's not just me. I was hoping the issue was my configuration... You ask about NAB and Mar 13 but I have this same problem ("random" USD quotes) with *all* my ASX stocks (20+). Cheers, Justin. On 8 February 2018 at 21:01, David T.

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-08 Thread David Carlson
If you want to create a fictional stock and manually enter prices from time to time that is easy. Just use the security editor and invent a name and symbol, possibly under the group called Fund. Do not set an online quote source. Then manually use the price editor to enter prices for whatever

Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
In thread https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html , I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac (OS X 10.13.3), Price retrieval was failing with the

Currency Issue

2018-02-08 Thread Les
I know this has been discussed in the past: I have a foreign bank account, denominated in the local currency.  Within this account, I also hold other currencies. However, the other currencies, instead of relating to the local currency, is relating to my native currency: USD.  This greatly

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-08 Thread Roger Miskowicz
I went through the section 9.5.3 Entering Pre-Existing Stocks for about the fifth time. Don't know what I did differently but it now works as expected. Before it used to crash when I tried a price update. Actually it still crashes when I click on Apply instead of Ok when editing a Price Entry.