Re: [GNC] Online Price Retrieval Fails

2018-09-05 Thread nvsoar
On 09/05/18 17:27, John Ralls wrote: On Sep 5, 2018, at 12:26 PM, nvsoar wrote: Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) reports DateManip could not be found; reports the following at the end. * Run gnc-fq-helper Can't locate Date/Manip.pm in @INC (you may

Re: [GNC] Negative assets!

2018-09-05 Thread John Ralls
> On Sep 5, 2018, at 5:51 PM, Muhammad Bashir Al-Noimi > wrote: > > On 09/06/2018 03:25 AM, John Ralls wrote: >> That’s Assets:Current Assets on the Accounts page, right? Not an entry in >> the summary bar at the bottom of the page? > YES; It's an account in Accounts tree defined as a

Re: [GNC] Balance Sheet Issue

2018-09-05 Thread Paul Schwartz
I have stocks that either distribute cash as return-of-capital or report income/losses that change the basis of the stock. The balance sheet in 2.6.12 calculates the proper value for the stock. 2.6.19 does not. Paul On Wed, Sep 5, 2018 at 5:44 PM Stephen M. Butler wrote: > I'm out of ideas. I

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread prl
For what it's worth, both my oldish Macquarie Australian Dictionary and my even older Shorter Oxford agree that Dr is an abbreviation for debtor. Neither gives any etymology for the abbreviation and the Oxford doesn't give any historical reference for it. The online free Oxford dictionary

Re: [GNC] Negative assets!

2018-09-05 Thread Muhammad Bashir Al-Noimi
On 09/06/2018 03:25 AM, John Ralls wrote: That’s Assets:Current Assets on the Accounts page, right? Not an entry in the summary bar at the bottom of the page? YES; It's an account in Accounts tree defined as a placeholder. Might you have hidden accounts with negative balances?

Re: [GNC] Online Price Retrieval Fails

2018-09-05 Thread John Ralls
> On Sep 5, 2018, at 12:26 PM, nvsoar wrote: > > Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) > reports DateManip could not be found; reports the following at the end. > > * Run gnc-fq-helper > Can't locate Date/Manip.pm in @INC (you may need to install the

Re: [GNC] Negative assets!

2018-09-05 Thread John Ralls
> On Sep 5, 2018, at 8:09 AM, Muhammad Bashir Al-Noimi > wrote: > > On 09/05/2018 06:06 PM, Muhammad Bashir Al-Noimi wrote: >> On 09/04/2018 05:55 PM, John Ralls wrote: >>> When you deleted the accounts, what did you tell GnuCash to do with the >>> transactions? >> I don't remember exactly.

Re: [GNC] Balance Sheet Issue

2018-09-05 Thread John Ralls
> On Sep 5, 2018, at 10:19 AM, Paul Schwartz wrote: > > First added balance-sheet.scm and then commodity-utilities.scm. There was no > commodity-utilities.scm file in the .19 release. The report changed but it > didn't give the same result as the .12 version. It was there, otherwise the

[GNC] Finance Quotes Using Yahoo json

2018-09-05 Thread Dan Nelms
Thanks for your help. I went to my Windows directory where gnc-fq-dump resides. I entered: perl gnc-fq-dump -v yahoo_json JPM It sucessfully returned the price for JPM. So I guess the Perl code is working. However, Price Editor in GnuCash still says Unable to retrieve.

Re: [GNC] Balance Sheet Issue

2018-09-05 Thread Stephen M. Butler
I'm out of ideas.  I ended up modifying the Eguile version to get the behavior my wife wanted. What is it that the report isn't doing? On 09/05/2018 10:19 AM, Paul Schwartz wrote: > First added balance-sheet.scm and then commodity-utilities.scm. There > was no commodity-utilities.scm file in

Re: [GNC] Nabble Editor

2018-09-05 Thread David Cousens
Derek, My problem seemed to be a result of either the interaction between Nabble and Mailman and may even get down to the settings users are using in the editor to compose mail putting in hard returns. The Nabble interface itself is a scaleable window and only soft wraps on display at the window

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread David Cousens
On Wed, 2018-09-05 at 16:08 +0100, Colin Law wrote: > Wow, well now we know (or actually don't know), but we know we don't > know in great depth and detail :) Colin I think that pretty well sums up the arguments between various accountancy historians. David

[GNC] re-adding billable expenses to an invoice

2018-09-05 Thread Matthew Pounsett
I accidentally flubbed some keyboard entry while putting together an invoice and messed up a billable expense item which had been automatically added when the invoice was created. Since there is no "Undo" the best option seemed to be to delete the entry and start over, but I can't find a way to

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread David Cousens
Geoff On Wed, 2018-09-05 at 20:42 +0200, Geoff Jankowski via gnucash-user wrote: > For example, if I take cash from the cash box and deposit it at the bank I > enter a cr to the cashbook and a dr to the > bank account. I don't find the above really counterintuitive. It treats the cash book and

[GNC] Downloading Ciurrency Prices

2018-09-05 Thread Les
Hoping someone can help.  I am using GC 2.6.17 on Linux Mint 18.2.  Up till 20180904, I was getting quotes for AUD, CAD, HKD and USD.  Beginning 20180904, I am no longer obtaining quotes for AUD and CAD.  (I only have the above quotes set in Security Editor due to Alphavantage's limit of 4.

Re: [GNC] gnucash-user Digest, Vol 186, Issue 14

2018-09-05 Thread bnichol12 via gnucash-user
Here you go! > > On Sep 5, 2018 at 3:36 PM,wrote: > > > Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To > subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email,

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Stephen M. Butler
On 09/05/2018 12:05 PM, Christian Kluge wrote: > Am 05.09.2018 um 20:42 schrieb Geoff Jankowski via gnucash-user: >> David >> >> I would love to agree with you but….. >> >> In standard journal notation cr is a debt and dr an asset. This is because >> it is nothing to do with credit (+ve) and

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Roger Miskowicz
I thought that debit and credit only existed in double entry accounting and simply identified columns as either Left or Right? On Wed, Sep 5, 2018 at 2:43 PM Geoff Jankowski via gnucash-user < gnucash-user@gnucash.org> wrote: > David > > I would love to agree with you but….. > > In standard

Re: [GNC] Finance Quotes Using Yahoo json

2018-09-05 Thread Dale Alspach
Have you tried to see whether the perl code itself works? (Below is on linux but something similar should work in perl on windows.) Assuming you have fnc-fq-dump installed, from a command prompt something like (perhaps prefixed by perl. See https://wiki.gnucash.org/wiki/Online_Quotes)

[GNC] Online Price Retrieval Fails

2018-09-05 Thread nvsoar
Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) reports DateManip could not be found; reports the following at the end. * Run gnc-fq-helper Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/strawberry/perl/site/lib

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Christian Kluge
Am 05.09.2018 um 20:42 schrieb Geoff Jankowski via gnucash-user: > David > > I would love to agree with you but….. > > In standard journal notation cr is a debt and dr an asset. This is because > it is nothing to do with credit (+ve) and debit (-ve) in any sense (or tense) > but to do with a

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Mike or Penny Novack
On 9/5/2018 2:42 PM, Geoff Jankowski via gnucash-user wrote: David I would love to agree with you but….. In standard journal notation cr is a debt and dr an asset. This is because it is nothing to do with credit (+ve) and debit (-ve) in any sense (or tense) but to do with a creditor (to

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Christian Kluge
Hi Am 05.09.2018 um 16:58 schrieb David Cousens: > Derek > > […] the first documented use of the accounting equation used the terms debere > (to owe) and credere (to entrust) to describe > the two sides of the basic accounting equation but there is also evidence > that Pacciola used Per

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Geoff Jankowski via gnucash-user
David I would love to agree with you but….. In standard journal notation cr is a debt and dr an asset. This is because it is nothing to do with credit (+ve) and debit (-ve) in any sense (or tense) but to do with a creditor (to whom we owe) and a debtor (who owes us). Hence dr and cr relate

Re: [GNC] Balance Sheet Issue

2018-09-05 Thread Paul Schwartz
First added balance-sheet.scm and then commodity-utilities.scm. There was no commodity-utilities.scm file in the .19 release. The report changed but it didn't give the same result as the .12 version. Any more suggestions? Thanks Paul On Tue, Sep 4, 2018 at 9:34 PM John Ralls wrote: > > > > On

Re: [GNC] Finance Quotes Using Yahoo json

2018-09-05 Thread Dan Nelms
Could I be missing some type of variable setting in the environment file? I know that when I first setup AlphaVantage (before the update to 3.2) I had to put my Alphavantage key in the environment file. Since Yahoo was not an option when 3.2 came out, maybe a variable that made Yahoo work before

Re: [GNC] Finance Quotes Using Yahoo json

2018-09-05 Thread Fross, Michael
Don't know what else to try other than perhaps some of the other F:Q quote sources. Of course after this discussion, I'm sure my Yahoo_JSON quotes will soon start to fail... :-) Michael On Wed, Sep 5, 2018 at 9:54 AM, Dan Nelms wrote: > Hi Michael, > > I tried your securities (ACN and

Re: [GNC] Negative assets!

2018-09-05 Thread Muhammad Bashir Al-Noimi
On 09/05/2018 06:06 PM, Muhammad Bashir Al-Noimi wrote: On 09/04/2018 05:55 PM, John Ralls wrote: When you deleted the accounts, what did you tell GnuCash to do with the transact ions? I don't remember exactly. Do you have any Imbalance-XXX accounts? Yes I've these accounts

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Colin Law
Wow, well now we know (or actually don't know), but we know we don't know in great depth and detail :) Colin On Wed, 5 Sep 2018 at 16:01, David Cousens wrote: > > Derek > > Latin past participles of creditum and debitum are debere and credere are a > possible explanation. Another theory is the

Re: [GNC] Negative assets!

2018-09-05 Thread Muhammad Bashir Al-Noimi
On 09/04/2018 05:55 PM, John Ralls wrote: When you deleted the accounts, what did you tell GnuCash to do with the transact ions? I don't remember exactly. Do you have any Imbalance-XXX accounts? Yes I've these accounts but they are empty. -- Best Regards, Muhammad Bashir Al-Noimi

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread David Cousens
Derek Latin past participles of creditum and debitum are debere and credere are a possible explanation. Another theory is the Dr stands for debit record and Cr credit record. Another is that Dr is from debtors and Cr is from creditors. I favour the first because Luca Pacciola who is often

Re: [GNC] Finance Quotes Using Yahoo json

2018-09-05 Thread Dan Nelms
Hi Michael, I tried your securities (ACN and FBIOX) with yahoo_json. Got unable to retrieve... I tried a couple of my securities with alphavantage. It worked fine. I tried your sec with Yahoo together with mine with alphaV at same time. It got mine and yours were unable... I tried your

Re: [GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Geoff Jankowski via gnucash-user
Debtor = dr Creditor = cr Geoff +44 20 7100 1092 +44 7770 58 48 38 +33 5 46 97 13 89 +33 6 22 93 00 53 > On 5 Sep 2018, at 15:59, Derek Atkins wrote: > > Hi All, > > I'm an Engineer by training; I've picked up a ton of accounting > knowledge just by being involved here for the

[GNC] [OT] Why is Debit abbreviated Dr?

2018-09-05 Thread Derek Atkins
Hi All, I'm an Engineer by training; I've picked up a ton of accounting knowledge just by being involved here for the past few decades, but there's one thing I've seen recently that I honestly don't underdstand and would appreciate if a CPA or Accounting Historian could answer. Specifically,

Re: [GNC] Finance Quotes Using Yahoo json

2018-09-05 Thread Fross, Michael
Hello Dan, I just looked at my GNC Price Database and the following quotes are returned successfully for me with Yahoo_JSON. Why don't you try a few of these and see if they work for you. They are current as of September 4, 2018 for me. Stock: ACN Fund: FBIOX, FBMPX, FCYIX Regards, Michael

Re: [GNC] GNC] Chart of Accounts sort order in v3.2 - Help

2018-09-05 Thread Alan Maddocks
I re-installed version 2.6.6 and that has 3 Account sort options: the choice of alphabetical and reverse alphabetical and also the order that the accounts were entered in. I have already spent time entering the account codes. As you have mentioned the many problems reported with version 3.x

Re: [GNC] UK Shares and Yahoo as JSON

2018-09-05 Thread Eric Coates
Graham I have used Morningstar GB sucessfully for Unit Trust prices for quite a while now. I've just tried it for (a selection of my UK) shares but no luck. Thanks for the suggestion. Eric On 05/09/18 07:03, Graham Balin wrote: Have you tried

Re: [GNC] GNC] Chart of Accounts sort order in v3.2 - Help

2018-09-05 Thread Fred Bone
On 04 September 2018 at 18:03, Stan Brown said: > I can confirm that the change did NOT happen between 2.x and 3.2. I > have 2.6.19, and when I click on Amount Name, in the Accounts tab, I get > only the choice of alphabetical and reverse alphabetical. I'm running 2.6.21 (on Windows 10) and I

Re: [GNC] UK Shares and Yahoo as JSON

2018-09-05 Thread Graham Balin
Have you tried single-Morningstar GB as your source? Cheerio Graham On Tue, 4 Sep 2018, 8:15 pm Eric Coates, wrote: > Hi > > Context: I’m running GnuCash 2.16.7 on Ubuntu 1604 with Finance-Quote 1.47. > > Like many others I have been using AlphaVantage as the source for my > online share