[GNC] How To Put Opening Balance in Acc Rev Account?5

Tue Mar 15 00:18:59 EDT 2022

I couldn't find a register to enter anything into.And I don't know what 'splits' are.
So I entered in the acc. rec. account I made for him.  I took a punt and entered -184 and it accepted it. Then I put in a 'payment' of 220 and it showed me a balance in red of  -34 which is fine.
that original 182 is not in red though.  not that I give a damn.
I see no way to get a statement of account from it though.  I tried 'report account' and it said there was nothing it could do.
:)

    On Tuesday, 15 March 2022, 02:04:24 pm ACDT, gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org> wrote:  

 Send gnucash-user mailing list submissions to
    gnucash-user at gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
    gnucash-user-request at gnucash.org

You can reach the person managing the list at
    gnucash-user-owner at gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."

Today's Topics:

  1. Re:  ??:  dit not run (Geoff)
  2.  ??:  dit not run (? ??)
  3. Re:  IRA/401K income detection (Michael or Penny Novack)
  4. Re:  MySQL back-end access failed @ MACOS 12 after MySQL
      server upgrade to 8.0.28 (Neko Chang)
  5.  How To Put Opening Balance in Acc Rev Account? (arthur brogard)
  6. Re:  How To Put Opening Balance in Acc Rev Account?
      (davidcousens49 at gmail.com)

----------------------------------------------------------------------

Message: 1
Date: Tue, 15 Mar 2022 08:31:42 +1100
From: Geoff <cleanoutmyshed at gmail.com>
To: ? ?? <xuhengxiao at outlook.com>, "gnucash-user at gnucash.org"
    <gnucash-user at gnucash.org>
Subject: Re: [GNC] ??:  dit not run
Message-ID: <6cecc9d1-62f9-6029-5c11-a9c1b43bb06e at gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed

Hi Kerwin

I am glad to hear that your previous issue has been resolved.

As I understand it, your current issue is that GnuCash cannot retrieve 
prices when you run it from the command line.

Because you have so many different versions of Perl installed on your 
computer, my conjecture is that GnuCash is picking up a different 
version of Perl than the one where you installed Finance::Quote.  This 
is why I asked you to run the SET PATH command, but you have not done this.

Also, you appear to be running Windows in a non-standard way with the 
\Program Files (x86)\ directory located on the D: drive and not the 
usual C: drive.  I am not saying that this is the cause of the problem, 
but it could be an additional factor.

Now, in your example below, you have introduced two more complications:
(1) Running GnuCash from the command line
(2) Using a GnuCash data store hosted remotely on OneDrive

There may be other explanations for your problem, and other readers on 
this list may suggest alternative solutions.

My advice is to keep it simple and go back to the basics with your 
troubleshooting:
(a) Completely remove *all* the versions of Perl on your computer
  (i) Uninstall using Windows Control Panel
  (ii) Use File Explorer to delete any remaining Perl folders
  (iii) Reboot your computer
(b) Make sure you are running the latest version of GnuCash (4.9)
(c) Install the latest version of Strawberry Perl for Windows
(d) Install the latest Finance::Quote module
(e) Test Finance::Quote from a Windows Command Prompt (not a mingw or 
any other shell) using gnc-fq-dump
(f) Use a local GnuCash data store on your C: drive.
(g) Invoke GnuCash via Windows, not the command line

Good luck!

Geoff
=====

On 14/03/2022 11:46 pm, ? ?? wrote:
> Dear Mr. Geoff ,
> 
> The previous issue has been resolved , the reason is the version of perl (activeperl or perl of msys) , I install Strawberry perl , but have another problem
> 
> kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin
> $ perl gnc-fq-dump alphavantage CSCO
> Finance::Quote fields Gnucash uses:
>      symbol: CSCO                <=== required
>        date: 03/11/2022          <=== recommended
>    currency: USD                  <=== required
>        last: 54.6900              <=\
>        nav:                      <=== one of these
>      price:                      <=/
>    timezone:                      <=== optional
>                                                            
> Finance::Quote is ok ,
> 
> $ gnucash-cli.exe --quotes get file://E:/onedrive/gnucash/gnucashxml/gnucash.gnucash
> ??? Finance::Quote ?? 1.51?
> gz_thread_func EOF
> 
> https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Perl_on_Windows , I want update price .
> 
> 
> -----????-----
> ???: Geoff <cleanoutmyshed at gmail.com>
> ????: 2022?3?14? 16:27
> ???: xuhengxiao at outlook.com; gnucash-user at gnucash.org
> ??: Re: [GNC] dit not run
> 
> Hi Kerwin
> 
> You appear to have 2, or possibly 3, versions of Perl installed - is that for a specific reason?
> 
> (1) An Activestate installation - what are the contents of your perl.bat file?
> 
> (2) One or two mingw versions in slightly different locations - why?
> 
> You need to determine which version of Perl that GnuCash is seeing when it runs - from a *WINDOWS* Command prompt (not a mingw shell) type in "SET PATH"
> 
> Regards
> 
> Geoff
> =====
> 
> On 13/03/2022 12:07 pm, xuhengxiao at outlook.com wrote:
>> Dir Sir / Madam,
>>
>> Finance::Quote module is installed and working
>>
>> kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin $ perl
>> gnc-fq-check ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia"
>> "asegr" "asx" "aufunds" "australia" "bamosz" "bet" "bmonesbittburns"
>> "bourso" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest"
>> "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies"
>> "fidelity" "fidelity_direct" "fidelityfixed" "financecanada"
>> "finanzpartner" "finland" "fool" "france" "ftfunds" "ftportfolios"
>> "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu"
>> "hufund" "hungary" "hustock" "iexcloud" "indiamutual"
>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau"
>> "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx"
>> "platinum" "romania" "seb_funds" "sixfunds" "sixshares"
>> "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk"
>> "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx"
>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard"
>> "vwd" "yahoo_json" "yahoo_yql" "za" "za_unittrusts")
>>
>> kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin $ where perl
>> C:\Users\kerwin\AppData\Local\activestate\cache\bin\perl.bat
>> D:\msys64\mingw64\bin\perl.exe
>> D:\msys64\usr\bin\perl.exe
>>
>> perl gnc-fq-dump -v alphavantage 600725.
>> nance::Quote fields Gnucash uses:
>> symbol: 600725.SS <=== requ
>> date: 03/11/2022 <=== reco
>> currency: CNY <=== requ
>> last: 3.8400 <=\
>> nav: <=== one
>> price: <=/
>> timezone: <=== opti
>> l fields returned by Finance::Quote for ock field value
>> ________________________________ 0725.SS close: 3.8400 0725.SS
>> currency: CNY 0725.SS currency_set_by_fq: 1 0725.SS date: 03/11/2022
>> 0725.SS high: 3.9800 0725.SS isodate: 2022-03-11 0725.SS last: 3.8400
>> 0725.SS low: 3.7600 0725.SS method: alphavantage 0725.SS open: 3.9800
>> 0725.SS success: 1 0725.SS symbol: 600725.SS 0725.SS volume: 52256390
>>
>> But gnucash did not run , it always check Finance::Quote .
>>
>> [cid:image001.png at 01D836B9.B832B450]
>>
>> Thanks & Best Regards / kerwin
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
>> s.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=04%7C01%7C%
>> 7C6f4a088eaafa45e8911908da05946393%7C84df9e7fe9f640afb435aaaaaaaaaaaa%
>> 7C1%7C0%7C637828432128336811%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwM
>> DAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=U3C
>> G8mG%2FDD6FkmpWOcJ8qLx65UR4KFQeD7kaKPLkrNQ%3D&reserved=0
>> If you are using Nabble or Gmane, please see https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=04%7C01%7C%7C6f4a088eaafa45e8911908da05946393%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637828432128336811%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=JPepCtZ0Qna3SSL1JBnT9OhQiQIplXSGEojY30soC%2Bs%3D&reserved=0 for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.

------------------------------

Message: 2
Date: Mon, 14 Mar 2022 12:46:37 +0000
From: ? ?? <xuhengxiao at outlook.com>
To: Geoff <cleanoutmyshed at gmail.com>, "gnucash-user at gnucash.org"
    <gnucash-user at gnucash.org>
Subject: [GNC] ??:  dit not run
Message-ID:
    <OSZP286MB0904D81EF2DC5E929A7AFBB8CA0F9 at OSZP286MB0904.JPNP286.PROD.OUTLOOK.COM>

Content-Type: text/plain; charset="gb2312"

Dear Mr. Geoff , 

The previous issue has been resolved , the reason is the version of perl (activeperl or perl of msys) , I install Strawberry perl , but have another problem 

kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin        
$ perl gnc-fq-dump alphavantage CSCO                      
Finance::Quote fields Gnucash uses:                        
    symbol: CSCO                <=== required            
      date: 03/11/2022          <=== recommended          
  currency: USD                  <=== required            
      last: 54.6900              <=\                      
      nav:                      <=== one of these        
    price:                      <=/                      
  timezone:                      <=== optional            

Finance::Quote is ok ,

$ gnucash-cli.exe --quotes get file://E:/onedrive/gnucash/gnucashxml/gnucash.gnucash
??? Finance::Quote ?? 1.51?
gz_thread_func EOF

https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Perl_on_Windows , I want update price .

-----????-----
???: Geoff <cleanoutmyshed at gmail.com> 
????: 2022?3?14? 16:27
???: xuhengxiao at outlook.com; gnucash-user at gnucash.org
??: Re: [GNC] dit not run

Hi Kerwin

You appear to have 2, or possibly 3, versions of Perl installed - is that for a specific reason?

(1) An Activestate installation - what are the contents of your perl.bat file?

(2) One or two mingw versions in slightly different locations - why?

You need to determine which version of Perl that GnuCash is seeing when it runs - from a *WINDOWS* Command prompt (not a mingw shell) type in "SET PATH"

Regards

Geoff
=====

On 13/03/2022 12:07 pm, xuhengxiao at outlook.com wrote:
> Dir Sir / Madam,
> 
> Finance::Quote module is installed and working
> 
> kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin $ perl 
> gnc-fq-check ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" 
> "asegr" "asx" "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" 
> "bourso" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" 
> "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" 
> "fidelity" "fidelity_direct" "fidelityfixed" "financecanada" 
> "finanzpartner" "finland" "fool" "france" "ftfunds" "ftportfolios" 
> "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" 
> "hufund" "hungary" "hustock" "iexcloud" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau" 
> "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
> "platinum" "romania" "seb_funds" "sixfunds" "sixshares" 
> "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" 
> "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" 
> "vwd" "yahoo_json" "yahoo_yql" "za" "za_unittrusts")
> 
> kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin $ where perl 
> C:\Users\kerwin\AppData\Local\activestate\cache\bin\perl.bat
> D:\msys64\mingw64\bin\perl.exe
> D:\msys64\usr\bin\perl.exe
> 
> perl gnc-fq-dump -v alphavantage 600725.
> nance::Quote fields Gnucash uses:
> symbol: 600725.SS <=== requ
> date: 03/11/2022 <=== reco
> currency: CNY <=== requ
> last: 3.8400 <=\
> nav: <=== one
> price: <=/
> timezone: <=== opti
> l fields returned by Finance::Quote for ock field value 
> ________________________________ 0725.SS close: 3.8400 0725.SS 
> currency: CNY 0725.SS currency_set_by_fq: 1 0725.SS date: 03/11/2022 
> 0725.SS high: 3.9800 0725.SS isodate: 2022-03-11 0725.SS last: 3.8400 
> 0725.SS low: 3.7600 0725.SS method: alphavantage 0725.SS open: 3.9800 
> 0725.SS success: 1 0725.SS symbol: 600725.SS 0725.SS volume: 52256390
> 
> But gnucash did not run , it always check Finance::Quote .
> 
> [cid:image001.png at 01D836B9.B832B450]
> 
> Thanks & Best Regards / kerwin
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
> s.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=04%7C01%7C%
> 7C6f4a088eaafa45e8911908da05946393%7C84df9e7fe9f640afb435aaaaaaaaaaaa%
> 7C1%7C0%7C637828432128336811%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwM
> DAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=U3C
> G8mG%2FDD6FkmpWOcJ8qLx65UR4KFQeD7kaKPLkrNQ%3D&reserved=0
> If you are using Nabble or Gmane, please see https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=04%7C01%7C%7C6f4a088eaafa45e8911908da05946393%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637828432128336811%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=JPepCtZ0Qna3SSL1JBnT9OhQiQIplXSGEojY30soC%2Bs%3D&reserved=0 for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

------------------------------

Message: 3
Date: Mon, 14 Mar 2022 19:48:48 -0400
From: Michael or Penny Novack <stepbystepfarm at comcast.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] IRA/401K income detection
Message-ID: <fb515e8f-c9e9-c891-4217-cc9933f92786 at comcast.net>
Content-Type: text/plain; charset=UTF-8; format=flowed

On 3/13/2022 10:28 PM, David G. Pickett via gnucash-user wrote:
> I understand that one characteristic/weakness of the double entry system is that you cannot tag a transfer with an income or expense account.? Still, accounting programs help prepare 1099R's, so there must be a way.? Keeping deferred tax items?a separate set of books would make income visible but assets would be divided.
>
>
> It'd be nice if there was some sort of account tax tag so transfers from pretax/tax deferred accounts to normal accounts would show on the tax report.
>
> My traditional 401k/IRA stuff is pure pretax, which I suspect is the overwhelming norm.? Of course, my Roth is tax free!? I am just too old/retired to put much into it!

The issues might be clearer if you stepped back a bit. You have the 
IRA/401k in your books as an asset. HOW did this amount get there? What 
were all the parts of THOSE transactions? Hint: do your books include a 
"deferred income" (say under equity). If not, how did you enter the 
transactions of a contribution? (not just a transfer between assets but 
also in the same amount a transfer between income and deferred income). 
And how did you record the market increases of the IRA/401K except as a 
debit to the 401k and a credit to "deferred income".

That's why some of us would NOT choose to have the 401k on our books as 
an asset. It's a "right" (to NOT receive income now but instead to 
receive it plus whatever it has earned over time at some later date). I 
think what has you confused is that it seems to have a clear "amount" 
associated with it so let's shift to a different sort of asset that is a 
right, an annuity.

Its book value? That whatever you paid for it. That stays the same until 
the annuity is no longer in effect under the terms of the contract. 
Whoever is then keeping your books (winding them up) would write it off 
against equity just like any other "loss" that is is not first processed 
through expenses. Meanwhile it is a source of "rents" (series of 
scheduled payments) that are debits to cash and credits to income as 
received. Not transfers from the "value" of the annuity which best 
remains unchanged.

Returning to your IRA/410k problem where you DO have it on your books as 
an asset with defined value. I suspect that was opening books with 
"starting values" but not having an account for "deferred income" (would 
have been for the same amount, opposite sense, since you say 100% before 
tax money? it's all deferred income). You can fix that (split that 
amount off from starting equity to a "deferred" account under equity. 
Now your distribution transaction can work (debit both cash and deferred 
income and credit IRA and income -- all the amount of the distribution)

Michael D Novack

------------------------------

Message: 4
Date: Tue, 15 Mar 2022 09:14:59 +0800
From: Neko Chang <epopen at gmail.com>
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL
    server upgrade to 8.0.28
Message-ID:
    <CAOO9QwhpnGyojt=mY-_Vj5S_jxeEe41BJZ+BDAAjFWBEuqn_OA at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

Hi All
I have no idea how to run on MACOS still.
Can help/information for it?

Thanks a lot

Neko Chang <epopen at gmail.com> ? 2022?2?17? ?? ??2:16???
>
> Hi gnucash-user
>
> I had been encounter as subject, can help to resolve?
>
> Detail:
> I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
> @ MySQL 8.0.23
> After MySQL upgrade to 8.0.28, Gnucash @ Ubuntu 20 work fine, but
> MACOS 12 won't.
>
> Log as below, generate by
> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug --extra
> --logto stdout
>    * 21:32:54 INFO <qof.session> [QofSessionImpl::load_backend] The
> provider providers access_method, file, but we're loading for
> access_method, mysql. Skipping.
>    * 21:32:54 INFO <qof.session> [QofSessionImpl::load_backend] The
> provider providers access_method, sqlite3, but we're loading for
> access_method, mysql. Skipping.
>    * 21:32:54 INFO <qof.session> [QofSessionImpl::load_backend]
> Selected provider GnuCash Libdbi (MYSQL) Backend
>    * 21:32:54 INFO <gnc.backend.dbi> [error_handler] DBI error: -5:
> An invalid name was passed to libdbi
>    * 21:32:54 INFO <gnc.backend.dbi> [error_handler] Note:
> GbcDbiSqlConnection not yet initialized. Skipping further error
> processing.
>    * 21:32:54 INFO <gnc.backend.dbi> [error_handler] DBI error: 2026:
> SSL connection error: unknown error number
>    * 21:32:54 INFO <gnc.backend.dbi> [error_handler] Note:
> GbcDbiSqlConnection not yet initialized. Skipping further error
> processing.
>    * 21:32:54 ERROR <gnc.backend.dbi>
> [GncDbiBackend<DbType::DBI_MYSQL>::session_begin()] Unable to connect
> to database 'gnucash'
>    * 21:32:54 INFO <qof.session> [QofSessionImpl::begin] Done running
> session_begin on backend
>
> Root cause version of libdbi maybe I guess.
> Package in Ubuntu 20 = 1.9.0
> Bundle in Gnucash = 1.8.? (by Google)
>
> Using package version of libdbi in MACOS possible?
> Or work-around/solution/fix at next version?
>
> Thanks very much.
> --
> Regards,
> Wei-Jen Chang

-- 
Regards,
Wei-Jen Chang

------------------------------

Message: 5
Date: Tue, 15 Mar 2022 03:07:24 +0000 (UTC)
From: arthur brogard <abrogard at yahoo.com>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: [GNC] How To Put Opening Balance in Acc Rev Account?
Message-ID: <1849286359.2554959.1647313644466 at mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8

I've opened an account receivable account for my rental place.? The tenant is in credit.? He's overpaid.? I need to open it with that balance.? I don't seem to be able to put in an opening balance at all.
What to do?
:)

    On Tuesday, 15 March 2022, 02:30:17 am ACDT, <gnucash-user-request at gnucash.org> wrote:  

 Send gnucash-user mailing list submissions to
??? gnucash-user at gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
??? https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
??? gnucash-user-request at gnucash.org

You can reach the person managing the list at
??? gnucash-user-owner at gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."

Today's Topics:

? 1. Re:? dit not run (Geoff)

----------------------------------------------------------------------

Message: 1
Date: Mon, 14 Mar 2022 19:26:44 +1100
From: Geoff <cleanoutmyshed at gmail.com>
To: "xuhengxiao at outlook.com" <xuhengxiao at outlook.com>,
??? "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] dit not run
Message-ID: <62bc2f4d-00d0-8682-527e-3603556f0637 at gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed

Hi Kerwin

You appear to have 2, or possibly 3, versions of Perl installed - is 
that for a specific reason?

(1) An Activestate installation - what are the contents of your perl.bat 
file?

(2) One or two mingw versions in slightly different locations - why?

You need to determine which version of Perl that GnuCash is seeing when 
it runs - from a *WINDOWS* Command prompt (not a mingw shell) type in 
"SET PATH"

Regards

Geoff
=====

On 13/03/2022 12:07 pm, xuhengxiao at outlook.com wrote:
> Dir Sir / Madam,
> 
> Finance::Quote module is installed and working
> 
> kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin
> $ perl gnc-fq-check
> ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau" "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json" "yahoo_yql" "za" "za_unittrusts")
> 
> kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin
> $ where perl
> C:\Users\kerwin\AppData\Local\activestate\cache\bin\perl.bat
> D:\msys64\mingw64\bin\perl.exe
> D:\msys64\usr\bin\perl.exe
> 
> perl gnc-fq-dump -v alphavantage 600725.
> nance::Quote fields Gnucash uses:
> symbol: 600725.SS <=== requ
> date: 03/11/2022 <=== reco
> currency: CNY <=== requ
> last: 3.8400 <=\
> nav: <=== one
> price: <=/
> timezone: <=== opti
> l fields returned by Finance::Quote for
> ock field value
> ________________________________
> 0725.SS close: 3.8400
> 0725.SS currency: CNY
> 0725.SS currency_set_by_fq: 1
> 0725.SS date: 03/11/2022
> 0725.SS high: 3.9800
> 0725.SS isodate: 2022-03-11
> 0725.SS last: 3.8400
> 0725.SS low: 3.7600
> 0725.SS method: alphavantage
> 0725.SS open: 3.9800
> 0725.SS success: 1
> 0725.SS symbol: 600725.SS
> 0725.SS volume: 52256390
> 
> But gnucash did not run , it always check Finance::Quote .
> 
> [cid:image001.png at 01D836B9.B832B450]
> 
> Thanks & Best Regards / kerwin
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

------------------------------

Subject: Digest Footer

_______________________________________________

gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

------------------------------

End of gnucash-user Digest, Vol 228, Issue 24
*********************************************

------------------------------

Message: 6
Date: Tue, 15 Mar 2022 13:32:32 +1000
From: davidcousens49 at gmail.com
To: gnucash-user at gnucash.org
Subject: Re: [GNC] How To Put Opening Balance in Acc Rev Account?
Message-ID: <b6eb2242407739a39d75befaeda00d774bc97205.camel at gmail.com>
Content-Type: text/plain; charset="UTF-8"

Arthur,

The Accounts Receivable account is an asset account which means it is debited to increase its balance and credited to decrease its balance. You want to it to have a negative balance by the amount your tenant is in credit. 
Manually nter a transaction at the date you opened the books with the following
entries/splits to create the negative opening balance xxx. You can do this
either from the Acounts Receivable or the Opening balances register.

Asset:Accounts Recievable    Credit xxx
Equity:Opening Balances      Debit  xxx

David Cousens

On Tue, 2022-03-15 at 03:07 +0000, arthur brogard via gnucash-user wrote:
> I've opened an account receivable account for my rental place.  The tenant is
> in credit.  He's overpaid.  I need to open it with that balance.  I don't seem
> to be able to put in an opening balance at all.
> What to do?
> :)
>  
> 
>    On Tuesday, 15 March 2022, 02:30:17 am ACDT, <
> gnucash-user-request at gnucash.org> wrote:  
>  
>  Send gnucash-user mailing list submissions to
>    gnucash-user at gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>    https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>    gnucash-user-request at gnucash.org
> 
> You can reach the person managing the list at
>    gnucash-user-owner at gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
>  1. Re:  dit not run (Geoff)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Mon, 14 Mar 2022 19:26:44 +1100
> From: Geoff <cleanoutmyshed at gmail.com>
> To: "xuhengxiao at outlook.com" <xuhengxiao at outlook.com>,
>    "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: [GNC] dit not run
> Message-ID: <62bc2f4d-00d0-8682-527e-3603556f0637 at gmail.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Hi Kerwin
> 
> You appear to have 2, or possibly 3, versions of Perl installed - is 
> that for a specific reason?
> 
> (1) An Activestate installation - what are the contents of your perl.bat 
> file?
> 
> (2) One or two mingw versions in slightly different locations - why?
> 
> You need to determine which version of Perl that GnuCash is seeing when 
> it runs - from a *WINDOWS* Command prompt (not a mingw shell) type in 
> "SET PATH"
> 
> Regards
> 
> Geoff
> =====
> 
> On 13/03/2022 12:07 pm, xuhengxiao at outlook.com wrote:
> > Dir Sir / Madam,
> > 
> > Finance::Quote module is installed and working
> > 
> > kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin
> > $ perl gnc-fq-check
> > ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx"
> > "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse"
> > "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
> > "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
> > "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
> > "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
> > "greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual"
> > "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau"
> > "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx"
> > "platinum" "romania" "seb_funds" "sixfunds" "sixshares"
> > "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk"
> > "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts"
> > "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json"
> > "yahoo_yql" "za" "za_unittrusts")
> > 
> > kerwin at KERWIN-PC D:\Program Files (x86)\gnucash\bin
> > $ where perl
> > C:\Users\kerwin\AppData\Local\activestate\cache\bin\perl.bat
> > D:\msys64\mingw64\bin\perl.exe
> > D:\msys64\usr\bin\perl.exe
> > 
> > perl gnc-fq-dump -v alphavantage 600725.
> > nance::Quote fields Gnucash uses:
> > symbol: 600725.SS <=== requ
> > date: 03/11/2022 <=== reco
> > currency: CNY <=== requ
> > last: 3.8400 <=\
> > nav: <=== one
> > price: <=/
> > timezone: <=== opti
> > l fields returned by Finance::Quote for
> > ock field value
> > ________________________________
> > 0725.SS close: 3.8400
> > 0725.SS currency: CNY
> > 0725.SS currency_set_by_fq: 1
> > 0725.SS date: 03/11/2022
> > 0725.SS high: 3.9800
> > 0725.SS isodate: 2022-03-11
> > 0725.SS last: 3.8400
> > 0725.SS low: 3.7600
> > 0725.SS method: alphavantage
> > 0725.SS open: 3.9800
> > 0725.SS success: 1
> > 0725.SS symbol: 600725.SS
> > 0725.SS volume: 52256390
> > 
> > But gnucash did not run , it always check Finance::Quote .
> > 
> > [cid:image001.png at 01D836B9.B832B450]
> > 
> > Thanks & Best Regards / kerwin
> > 
> > 
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _______________________________________________
> 
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 
> ------------------------------
> 
> End of gnucash-user Digest, Vol 228, Issue 24
> *********************************************
>  
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

------------------------------

Subject: Digest Footer

_______________________________________________

gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

------------------------------

End of gnucash-user Digest, Vol 228, Issue 25
*********************************************