Re: Applying Customer overpayments

*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

The Wiki, and documentation

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: GNUCASH Free Accounting Software

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: Cash Flow View

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: Price Retrieval Failure, Part 2

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

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

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?

Re: Price Retrieval Failure, Part 2

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: Online quotes fetching the wrong price

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

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: GNUCASH Free Accounting Software

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

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

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

Duplicating Accounts?

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?

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

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

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

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

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?

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: Price Retrieval Failure, Part 2

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

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: Applying Customer overpayments

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: 2.7.4 install

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: can't change preferences [SOLVED]

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: Price Retrieval Failure, Part 2

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

Applying Customer overpayments

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: Accounting rules

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: Price Retrieval Failure, Part 2

> 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

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

Re: Price Retrieval Failure, Part 2

> 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: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

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.

Currency Issue

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

Price Retrieval Failure, Part 2

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

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

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

Re: Online quotes fetching the wrong price

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: Online quotes fetching the wrong price

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: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

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

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: Online quotes fetching the wrong price

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,

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

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

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

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: Instructions for GST India

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