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,
[email protected] <[email protected]> wrote:
Send gnucash-user mailing list submissions to
[email protected]
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
[email protected]
You can reach the person managing the list at
[email protected]
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?
([email protected])
----------------------------------------------------------------------
Message: 1
Date: Tue, 15 Mar 2022 08:31:42 +1100
From: Geoff <[email protected]>
To: ? ?? <[email protected]>, "[email protected]"
<[email protected]>
Subject: Re: [GNC] ??: dit not run
Message-ID: <[email protected]>
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@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 <[email protected]>
> ????: 2022?3?14? 16:27
> ???: [email protected]; [email protected]
> ??: 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, [email protected] wrote:
>> Dir Sir / Madam,
>>
>> Finance::Quote module is installed and working
>>
>> kerwin@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@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:[email protected]]
>>
>> Thanks & Best Regards / kerwin
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> [email protected]
>> 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: ? ?? <[email protected]>
To: Geoff <[email protected]>, "[email protected]"
<[email protected]>
Subject: [GNC] ??: dit not run
Message-ID:
<oszp286mb0904d81ef2dc5e929a7afbb8ca...@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@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 <[email protected]>
????: 2022?3?14? 16:27
???: [email protected]; [email protected]
??: 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, [email protected] wrote:
> Dir Sir / Madam,
>
> Finance::Quote module is installed and working
>
> kerwin@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@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:[email protected]]
>
> Thanks & Best Regards / kerwin
>
>
> _______________________________________________
> gnucash-user mailing list
> [email protected]
> 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 <[email protected]>
To: [email protected]
Subject: Re: [GNC] IRA/401K income detection
Message-ID: <[email protected]>
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 <[email protected]>
To: [email protected]
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...@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 <[email protected]> ? 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 <[email protected]>
To: "[email protected]" <[email protected]>
Subject: [GNC] How To Put Opening Balance in Acc Rev Account?
Message-ID: <[email protected]>
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,
<[email protected]> wrote:
Send gnucash-user mailing list submissions to
??? [email protected]
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
??? [email protected]
You can reach the person managing the list at
??? [email protected]
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 <[email protected]>
To: "[email protected]" <[email protected]>,
??? "[email protected]" <[email protected]>
Subject: Re: [GNC] dit not run
Message-ID: <[email protected]>
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, [email protected] wrote:
> Dir Sir / Madam,
>
> Finance::Quote module is installed and working
>
> kerwin@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@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:[email protected]]
>
> Thanks & Best Regards / kerwin
>
>
> _______________________________________________
> gnucash-user mailing list
> [email protected]
> 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
[email protected]
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: [email protected]
To: [email protected]
Subject: Re: [GNC] How To Put Opening Balance in Acc Rev Account?
Message-ID: <[email protected]>
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, <
> [email protected]> wrote:
>
> Send gnucash-user mailing list submissions to
> [email protected]
>
> 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
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> 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 <[email protected]>
> To: "[email protected]" <[email protected]>,
> "[email protected]" <[email protected]>
> Subject: Re: [GNC] dit not run
> Message-ID: <[email protected]>
> 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, [email protected] wrote:
> > Dir Sir / Madam,
> >
> > Finance::Quote module is installed and working
> >
> > kerwin@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@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:[email protected]]
> >
> > Thanks & Best Regards / kerwin
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > [email protected]
> > 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
> [email protected]
> 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
> [email protected]
> 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
[email protected]
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
*********************************************
_______________________________________________
gnucash-user mailing list
[email protected]
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.
