I do this using the "Export" choice in GnuCash, saving the report as an
html file on the desktop, then right-click + open with LibreOffice Calc.
In addition to what Hop said below about ticking the box for:
"Detect special numbers (such as dates)" in the import ...
I also need to do this
On Sat, 13 Apr 2024 20:07:26 -0700
tburmas wrote:
> Hello,
>
> I often have invoices that are open (in progress) that are not
> ready to post. Is there a way to see a list of these? The only way
> I have found to do so is to remember ahead of time a customer has an
> open invoice and
I found this information extremely enlightening. I didn't know that
there was a capability to use Google's capabilities to make a
spreadsheet and automatically include pricing data. It's as if Libre
Office Calc or Excel had an inbuilt function to retrieve pricing info.
Very useful information.
On 4/13/24 20:08:20 -0700, Bruce S wrote:
There is some miscellaneous housekeeping and cleanup that needs to be
done before pushing a final release to CPAN. Plus I had some other
changes that I was planning for v1.60 but haven't done yet. Instead of
v1.60, I may upload v1.59_01 tomorrow so
Business > Customer > Find Invoice
Set criteria to:
Is Posted?, unchecked
You can of course add other criteria to refine the search.
Regards,
Adrien
On 4/13/24 10:07 PM, tburmas wrote:
I often have invoices that are open (in progress) that are not
ready to post. Is there a way to see
d) silently read, comprehended, bookmarked, and filed away for possible
future use.
Thanks for the contribution, keep them coming :--))
Geoff
=
On 14/04/2024 3:50 pm, sunfish62--- via gnucash-user wrote:
David,
My goal in the example was not pedagogical; it was to give others in the
Hi, all. I had an odd transaction labeled as a "price margin code
change" show up on a brokerage account recently. It appears to represent
having "sold" all of my shares at one price, then "buying" them back at
a slightly different price, with the difference made up in having
somewhat more or
Hi Steven
Yes, this type of event is not unheard of. You need to find out more
information before deciding how to treat it in GnuCash. In particular,
did this trigger a capital gain/loss event, or does your existing cost
basis carry forward. Also was there an associated cash payout or
Hello David,
I do the same for my reports but paste it into Excel and whenever I had
that issue I either use powerquery for the clean up or more quick and dirty
approach of using functions to extract the correct figures, some MID/RIGHT
function, within the CLEAN one wrapping the result and if you
> On Apr 14, 2024, at 12:45, Lester Bennett wrote:
>
> I've upgraded from Gnucash 4.8 to 5.6 on Ubuntu and now don't have my saved
> reports.
> There is a /.local/share/gnucash/saved-reports-2.8 file with my original
> saved reports but they are not displayed under Saved Reports.
> The
Thanks Bruce for the update. I've installed it but must be doing something
wrong.
Syntax seems to work fine for YahooWeb, but I received an error if I do the
same command with YahooJSON. HTTP::CookieJar::LWP is installed and up to
date. I'm not sure how to troubleshoot this effectively.
Any
I've upgraded from Gnucash 4.8 to 5.6 on Ubuntu and now don't have my
saved reports.
There is a /.local/share/gnucash/saved-reports-2.8 file with my original
saved reports but they are not displayed under Saved Reports.
The original installation was via the Ubuntu App store but it is still
at
Hello community,
I uploaded 5 years worth of bank account transaction to gnu-cash.
I would like the apply the same transfer information to all the
transactions having the same description and keep applying it automatically
to all future transaction.
I found old topics about that saying it had
As far as I can tell, there were no associated capital gains or losses,
fees, or distributions. Frustratingly, the website lists the
transactions differently from what shows up in the downloadable CSV or
OFX files, though they at least seem to add up. And since the brokerage
moved to this new
yahoo_json not YahooJSON
--
Dave Reiser
dbrei...@icloud.com
> On Apr 14, 2024, at 17:03, Fross, Michael via gnucash-user
> wrote:
>
> Thanks Bruce for the update. I've installed it but must be doing something
> wrong.
>
> Syntax seems to work fine for YahooWeb, but I received an error
On 4/14/24 3:02 PM, David Reiser wrote:
yahoo_json not YahooJSON
Yeah... I've made that mistake myself many times. The original author of
the YahooJSON module chose to name the method (aka subroutine with the
name used in the Security Editor and on the command line) "yahoo_json".
Most
Thanks all. Yes, I just assumed the module name was the same. I’ll check
when I’m back at my computer, but I’m sure it wo4ks.
Much appreciated.
Michael
On Sun, Apr 14, 2024 at 5:02 PM David Reiser wrote:
> yahoo_json not YahooJSON
>
>
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> On
Verbose; not terse ...
gnucash-cli.exe --verbose -Q dump yahoo_json aapl
-Original Message-
From: David Reiser
Sent: Sunday, April 14, 2024 6:02 PM
To: Fross, Michael
Cc: david amaral ; gnucash-user@gnucash.org; Bruce Schuck
Subject: Re: [GNC] Finance Quotes Yahoo off the rails
I have always wondered why two are not in sync...
-Original Message-
From: Bruce Schuck
Sent: Sunday, April 14, 2024 6:14 PM
To: David Reiser ; Fross, Michael
Cc: david amaral ; gnucash-user@gnucash.org
Subject: Re: [GNC] Finance Quotes Yahoo off the rails again?
On 4/14/24 3:02 PM,
I have compiled the latest stable release 5.6 on Linux Mint. After
installation, I am able to run the program, but the application fails at
the finance-quotequery. I get the error
"https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=AAPL=price,summaryDetail,defaultKeyStatistics
Hello, Adrien, and welcome to MusicBrainz!
On 2024-04-14 13:03, Adrien Laveau wrote:
Hello community,
I uploaded 5 years worth of bank account transaction to gnu-cash.
I would like the apply the same transfer information to all the
transactions having the same description and keep applying it
Thank you.Installed on windows 11 Gnucash 5.6 flawlesly in an admin comand
window issued the command and all went without any errors.
On Sunday, April 14, 2024 at 08:45:09 AM GMT-7, Bruce Schuck
wrote:
On 4/13/24 20:08:20 -0700, Bruce S wrote:
> There is some miscellaneous
Unsurprising, but no, or at least, not yet.
They don't need to subscribe, it's all publicly available information:
https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111555.html
Lax IT security by various of my service providers has exposed my email
address and many more personal
On Sun, 14 Apr 2024 22:57:24 -0400
Michael DeBusk wrote:
> I've gotten two or three obviously-malicious e-mails pretending to be
> from this mailing list. The From: line lists the sender as "Gnucash
> User" but the address is not this one. I fear a spammer (or worse) has
> subscribed and is
Well if that is the case I think you should just mirror those
transactions in GnuCash. "Sell" all the old units at that valuation and
"buy" the new units back for the same consideration. No capital gains
will be booked. Your cost basis *per share* has changed, but not your
overall cost.
I've gotten two or three obviously-malicious e-mails pretending to be
from this mailing list. The From: line lists the sender as "Gnucash
User" but the address is not this one. I fear a spammer (or worse) has
subscribed and is harvesting addresses.
Is anyone else seeing this?
--
() ascii
26 matches
Mail list logo
