Re: [GNC] Additional check for out of balance 'Trial Balance' and 'Balance Sheet'

[Michael or Penny Novack]

Further investigation found that in the 'Edit Account' panel, the 'Smallest
fraction' was set at '1' on this particular account, and the amount was
being rounded up on one side, causing the mismatch. Setting the 'Smallest
fraction' to 'Use Commodity Value' and running 'Repair All' sorted the
problem.

I hope the above may be a solution for someone and save them time, if not
hair.


It bears repeating, as soon as rounding is involved, exactly in balance 
goes out the window. It is simply a reality of mathematics that rounded 
A + rounded B is not necessarily equal to rounded (A + B). Your problem 
could exist even if both sides were rounded/


LOL -- in my working days, one of the things I did a number of times was 
calculate the value of the "fuzz" (the maximum discrepancy between 
calculations done in different order as a result of limits in 
precision/rounding --- so the computer program would consider the two 
equal if the difference were less than "fuzz"). And those of us doing 
calculations in science/engineering know that the order in which we do 
them can have a great effect on the possible "error" << so we choose the 
order of calculations that minimizes that >>


In its original form. double entry bookkeeping could demand exact 
balance because the only operation was addition/subtraction and no 
rounding involved.



Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quote problem MacOS High Sierra.

[John Ralls]

What results when you try from the command line, e.g.
  ALPHAVANTAGE_API_KEY= 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency EUR USD
?

Regards,
John Ralls




> On Mar 19, 2023, at 3:17 PM, G R Hewitt  wrote:
> 
> Hi John,
> Thanks for getting back.
> Yes I do, and I just checked, it is still there.
> 
> 
> On Sun, 19 Mar 2023 at 22:15, John Ralls  wrote:
> Do you have an alphavantage api key?
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 19, 2023, at 2:50 PM, G R Hewitt  wrote:
> > 
> > Hello everyone,
> > Gnucash 4.13
> > Finance Quote 1.54
> > MacPro 2010 High Sierra
> > iMac 2017 Ventura
> > 
> > After hours of much aggravation - don't ask ' I eventually got Finance
> > Quote 1.54 to install, the 'Get Quotes' button was active and I was well
> > pleased with myself.
> > 
> > Anyway, on pressing it I got the dismaying message:
> > 'Unable to retrieve quotes for these items: CURRENCY:EUR'
> > 
> > I have searched for answers and found none.
> > 
> > Can anyone point me in the right direction, please to solving this.
> > 
> > Thanks in advance.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quote problem MacOS High Sierra.

[G R Hewitt]

Hi John,
Thanks for getting back.
Yes I do, and I just checked, it is still there.


On Sun, 19 Mar 2023 at 22:15, John Ralls  wrote:

> Do you have an alphavantage api key?
>
> Regards,
> John Ralls
>
>
> > On Mar 19, 2023, at 2:50 PM, G R Hewitt  wrote:
> >
> > Hello everyone,
> > Gnucash 4.13
> > Finance Quote 1.54
> > MacPro 2010 High Sierra
> > iMac 2017 Ventura
> >
> > After hours of much aggravation - don't ask ' I eventually got Finance
> > Quote 1.54 to install, the 'Get Quotes' button was active and I was well
> > pleased with myself.
> >
> > Anyway, on pressing it I got the dismaying message:
> > 'Unable to retrieve quotes for these items: CURRENCY:EUR'
> >
> > I have searched for answers and found none.
> >
> > Can anyone point me in the right direction, please to solving this.
> >
> > Thanks in advance.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quote problem MacOS High Sierra.

[John Ralls]

Do you have an alphavantage api key?

Regards,
John Ralls


> On Mar 19, 2023, at 2:50 PM, G R Hewitt  wrote:
> 
> Hello everyone,
> Gnucash 4.13
> Finance Quote 1.54
> MacPro 2010 High Sierra
> iMac 2017 Ventura
> 
> After hours of much aggravation - don't ask ' I eventually got Finance
> Quote 1.54 to install, the 'Get Quotes' button was active and I was well
> pleased with myself.
> 
> Anyway, on pressing it I got the dismaying message:
> 'Unable to retrieve quotes for these items: CURRENCY:EUR'
> 
> I have searched for answers and found none.
> 
> Can anyone point me in the right direction, please to solving this.
> 
> Thanks in advance.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Additional check for out of balance 'Trial Balance' and 'Balance Sheet'

[G R Hewitt]

I thought it might be useful to pass on another possible reason for having
an out-of-kilter 'Trial Balance' and 'Balance Sheet'

I spent quite some time in an effort to get mine to balance, they were out
by £3.07 and this amount had steadily grown. I decided I was going to nail
it once and for all and work my may through the General Journal. Quite by
chance I decided to use the cursor keys, rather than scroll with the mouse
wheel - this went at a steady pace checking Credit and Debit were the same.
Then, an error dialogue opened up saying there was a disparity and offered
solutions. I chose 'Manual', but found I couldn't change the errant amount
- even in the register. Note there are small grey squares surrounding the
incorrect entry cells, most useful.
Further investigation found that in the 'Edit Account' panel, the 'Smallest
fraction' was set at '1' on this particular account, and the amount was
being rounded up on one side, causing the mismatch. Setting the 'Smallest
fraction' to 'Use Commodity Value' and running 'Repair All' sorted the
problem.

I hope the above may be a solution for someone and save them time, if not
hair.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Finance Quote problem MacOS High Sierra.

[G R Hewitt]

Hello everyone,
Gnucash 4.13
Finance Quote 1.54
MacPro 2010 High Sierra
iMac 2017 Ventura

After hours of much aggravation - don't ask ' I eventually got Finance
Quote 1.54 to install, the 'Get Quotes' button was active and I was well
pleased with myself.

Anyway, on pressing it I got the dismaying message:
'Unable to retrieve quotes for these items: CURRENCY:EUR'

I have searched for answers and found none.

Can anyone point me in the right direction, please to solving this.

Thanks in advance.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] GnuCash 4.904 Released

[John Ralls]

The GnuCash development team announces GnuCash 4.904, the fifth unstable 
release leading to GnuCash 5.0.
This is an unstable release for testing purposes. Do not use it with production 
data! Make a copy of your book to test this release.
New Features

A new Stock Transaction Assistant to guide you through entering most 
investment transactions for stocks, bonds, and mutual funds. You can access it 
from Actions>Stock Assistant when you have the Accounts page ora Stock or Fund 
account register open.
A new Investment Lots report showing a graph of capital gains and losses in 
a period by investment lot. Note that if you don't use the View Lots dialog to 
manage capital gains and losses this report won't have anything to show you. 
Use Reports>Assets & Liabilities>Investment Lots to see the report.
The Online Quotes facility has been completely rewritten and the old 
gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with 
finance-quote-wrapper. The functions performed by those programs may now be 
accomplished by passing commands to gnucash-cli -Q, see gnucash-cli --help for 
specifics. The perl module requirements have changed with the rewrite: The new 
version doesn't need Date::Manip but needs JSON::Parse instead. gnc-fq-update 
has been, er, updated to reflect that.
A new tab on the New/Edit Account dialog called More Properties includes 
entries to set a high and low limit on an account. That's coupled to a new 
column that's available on the Accounts Page, Balance Limit. If you set a high 
or low limit and the account balance falls above or below the respective limit 
an indicator will be shown in the Balance Limit column.
The description field quickfill in the register now displays a drop-down 
list of possible completions instead of just one inline completion.
File import menu items for the MT940, MT942, and DTAUS formats is replaced 
with a single Import from AQBanking that supports importing any file format 
supported by AQBanking, including the frequently requested CAMT.

The report generated by the Print Invoice button on the Edit Invoice tab 
can now be configured as a book option at the bottom of the Business tab; this 
permits selecting a saved configuration of one of the standard invoice reports. 
Another option enables a delay, during which a dialog box will appear enabling 
the user to select a different report.

Note: When saving a configuration make sure that the invoice number is not 
set or you'll get that particular invoice instead of the one that you pressed 
the button for.

Between 4.903 and 4.904, the following bugfixes were accomplished:
The following fixes will also appear in GnuCash 4.14:

Bug 798570 - Budget totals for income, expenses and remaining to budget 
incorrect for one specific date.

The following fixes are in 4.904 only and will not appear in GnuCash 4.14:

Bug 798558 - Irregular line spacing in Account Tree View
Bug 798773 - Help file launches in browser when using command-H to hide 
GnuCash

This is a MacOS-only problem. Note that for the fix to have effect you must 
remove the file accelerator-map from GNC_CONFIG_HOME when GnuCash isn't running.
Bug 798778 - GnuCash quits abruptly when attempting to edit options for 
certain reports.
Bug 798781 - Printing multiple checks prints duplicate checks
Bug 798787 - gnc-register-owner-option currently broken

The following fixes and improvements were not associated with bug reports:

Fix quotes codecvt to wchar_t error on Windows.
Budget totals for one period would be wrong when increasing the number of 
periods.
Change the handling of accelerator maps. Gtk no longer supports changing 
these from the menus and the save no longer writes out the accelerators that 
have their default values, so to assist users editing them we have generated 
default ones that we include with GnuCash and have disabled saving when 
quitting GnuCash. At startup GnuCash will check for the presence of the file 
accelerator-map in GNC_CONFIG_HOME and if it's not found will copy in the 
default one.
Properly parse plus signs while importing numbers in a CSV file.
Fix CSV price import file loading.
CsvImport - actually do as the warning indicates: If an invalid column is 
found in a preset, replace it with a NONE column, rather than not inserting a 
column at all.

New and Updated Translations: Chinese (Simplified), Croatian, Hungarian, 
Japanese, Portuguese, Portuguese (Brazil), Spanish, Swedish
Help translate GnuCash on Weblate: https://hosted.weblate.org/engage/gnucash/

Translators note that there is a new project Program-beta on weblate for this 
unstable branch. Having twice the strings causes us to exceed the free account 
limit, but Weblate has so far just warned us about it. If we need to change the 
branch we'll announce it on gnucash-devel.

Known Problems: 

Complete list of all open bugs: 

Re: [GNC] Outstanding / due invoices report?

[Simon Roberts]

Ah, many thanks. Sorry for missing that, and much appreciate your help :)

Cheers,
Simon


On Sun, Mar 19, 2023 at 11:29 AM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> Simon
>
> You can use the customer report to get a statement which you can send,
> this includes the invoice paid and also outstanding with ageing.
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Simon Roberts <
> si...@dancingcloudservices.com>
> *Sent:* Sunday, March 19, 2023 10:17 AM
> *To:* Gnucash Users 
> *Subject:* [GNC] Outstanding / due invoices report?
>
> Hi all,
>
> I'm wondering if there's a built-in report, in a form suitable for sending
> to a client, that lists the invoices they currently owe. Or perhaps those
> that are overdue?
>
> I'm creating a reminder as a simple email message, but this seems like
> something others might need, and therefore something that might be part of
> GNC already.
>
> Ideally, it would be nice to be able to append this to any new invoice for
> that same customer, maybe.
>
> I have found Business->Customer->Invoices Due Reminder, but that seems to
> be solely to tell me what's due/overdue and isn't printable.
>
> Does any such thing exist?
>
> Cheers,
> Simon
>
> --
> Simon Roberts
> (303) 249 3613
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help with downloading transactions.

[Stan Brown (using GC 2.6.19)]

On 2023-03-19 08:26, Kalpesh Patel wrote:
> In the US I highly recommend that you look into placing security freeze on
> your credit files and at ChexSystems at minimum, which now is free for
> everyone unlike in the past where you were charged fee for it. 

Excellent advice. (Thanks for mentioning ChexSystems; I had not thought
to freeze my record there too.)

Not only is the freeze free, but temporarily lifting it, when you
yourself are actually applying for a mortgage or other credit somewhere,
is also free. (At least that's true for credit bureaus; I don't know if
ChexSystems operates under the same rules.)

The bad news is that you have to do it at all of the credit bureaus; one
will not communicate news of a freeze to the others.

To save you some searching, here are the URLs:









Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnu-fq-check missing

[John Ralls]

I figured out the problem with boost::process's codecvt: It doesn't like empty 
strings and if there's no alphavantage key set we were trying to set the 
ALPHAVANTAGE_API_KEY environment variable with an empty string. I've fixed 
that, it will be in 4.904 which I'll proceed to release; if nothing goes wrong 
that will be later today (well, today if you're in America. I might not make it 
for Eurpeans and it's already tomorrow in the far east.)

Regards,
John Ralls


> On Mar 14, 2023, at 9:02 AM, john  wrote:
> 
> Neither the quick fix nor a more involved attempt worked. Boost::process is a 
> bit opaque but what it's telling us is that somewhere it wants codecvt to 
> convert some string from char to wchar_t. I'm having difficulty figuring out 
> where.
> 
> Regards,
> John Ralls
> 
>> On Mar 13, 2023, at 2:58 PM, John Ralls  wrote:
>> 
>> Urk, looks like a problem with converting a string to wchar_t for Windows, 
>> we didn't set up codecvt in gnc-quotes.cpp. I can reproduce it here, trying 
>> a quick fix.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Mar 13, 2023, at 2:12 PM, rolf.hoef...@gmail.com wrote:
>>> 
>>> wow.. never expected such a quick and personalized answer.. Thx!
>>> I'm using now the unstable release 4.902. 
>>> I followed your instructions, but after trying gnucash-cli -Q info, I get 
>>> the following error:
>>> "Failed to initialize Finance::Quote: boost::process codecvt to wchar_t: 
>>> error"
>>> Within Gnucash app, still not able to use it..
>>> Thanks again, John!
>>> BR,
>>> Rolf
>>> 
>>> On Mon, Mar 13, 2023 at 12:15 PM john  wrote:
>>> 
>>> 
 On Mar 12, 2023, at 5:37 PM, rolf.hoef...@gmail.com wrote:
 
 Hi, I've been trying hard to be able to run "Install Online Price
 Retrieval", and I almost made it.. but I got this.. and it's right..
 there's no gnu-fq-check program in bin.. how can I get it? I think I'm
 almost there..
>>> 
>>> That depends on the version of GnuCash. If it's a 4.90x beta gnc-fq-check, 
>>> gnc-fq-helper, and gnc-fq-dump have been replaced with 
>>> finance-quote-wrapper and their function is now in gnucash-cli. We 
>>> neglected to modify the Install Online Price Retrieval tool to reflect 
>>> that. The two calls to gnc-fq-check and gnc-fq-helper in 
>>> install-fq-mods.cmd are final checks to make sure everything succeeded, so 
>>> you probably are done. You can run c:\Program Files 
>>> (x86)\gnucash\bin\gnucash-cli -Q info and …\gnucash-cli -Q dump 
>>> alphavantage AMZN to test it.
>>> 
>>> OTOH if you're using a production release of GnuCash then gnc-fq-check 
>>> should be in C:\Program Files (x86)\gnucash\bin and since 
>>> install-fq-mods.cmd is in that directory too it should have found it.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Temporary Website URL

[Murugan Muruganandam]

Brad
i agree with David, the website issue was an blip which was solved using a work 
around and am sure the team is working to restore the certificate.
On the statement from your acquaintance that he does not use open source is 
quite a stretch, on top of my mind Linux , am very sure his website or his 
database is running on Linux.
I would strongly recommend that your acquaintance take a look into GNUCash 
software and share is frank opinion about the merits and de merits.  this 
software was built solely on comments and requests from people.




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
David T. via gnucash-user 
Sent: Sunday, March 19, 2023 3:05 AM
To: Robert Heller 
Cc: David Reiser via gnucash-user 
Subject: Re: [GNC] Temporary Website URL

Brad,

I just want to note that your acquaintance has a remarkably parochial attitude 
about software. GnuCash has been available and actively developed for something 
like 25 years.

It seems to me that in this era of "big data," those commercial companies are 
more interested in the customer as a source of data mining income than as a 
partner using their software.

*And* outages with major commercial platforms (Twitter, Facebook?) underscore 
that it is not just open source projects that fail sometimes.

David T.



On Mar 18, 2023, 4:21 PM, at 4:21 PM, Robert Heller  wrote:
>At Sat, 18 Mar 2023 06:04:52 -0700 Brad Morrison
> wrote:
>
>>
>> Thanks for point these situations out Ken! The reason I joined the
>> GnuCash-User mailing lists was because I sent a link to an
>acquaintance
>> that does bookkeeping professionally and he texted back that the
>website
>> was down, he then did a Google search and tried the GnuCash result on
>
>> his own and that link didn't work either, and he then goes on to tell
>me
>> that this is why he doesn't trust open source projects with his
>business
>> or his clients' business. It was pretty embarrassing for me and I
>have
>> hesitated to refer any possibly interested professionals that I meet
>to
>> GnuCash since.
>>
>> I can confirm the certificate error for website #1. It looks like
>> gnucash.org uses Let's Encrypt (https://letsencrypt.org/) as the
>> certificate authority and the certificate was valid from December 12,
>
>> 2022 until March 11, 2023. My understanding was that Let's Encrypt
>was
>> free, so that might mean that it just has to be
>renewed/reauthorized...?
>
>Let's Encrypt uses a program "certbot" which is supposed to
>automagically
>renew the certificate.  It does try to verify the domain it is for by
>visiting
>the website.  Since there was a webserver config problem (the redirect
>config
>was broken), it is likely that the automagical renewal failed...
>
>>
>> I can confirm that website #2 still lists the "Apache2 Ubuntu Default
>
>> Page" error for the non-https/secure gnucash website. I believe that
>> John mentioned that Linas upgraded his server in January and that
>broke
>> this feature and it has not been fixed since.
>>
>
>Yes, this webserver config error needs to be fixed.  Once it is fixed,
>the
>Let's Encrypt certbot program will be able to renew the certificate,
>which
>will fix the https://www.gnucash.org error.
>
>> I also see Gnucash website #3 as working well. I can see that that
>> website also uses Let's Encrypt as the certificate authority and that
>
>> certificate is valid from March 5, 2023 until June 3, 2023.
>>
>> I also noticed that website #1 & #2 has 2 "Subject Alt Names"
>> (gnucash.org & www.gnucash.org) on that 
>> certificate, while website #3
>
>> has just 1 (code.gnucash.org).
>
>Yes, this is a "normal" thing.  Almost all www.xxx.yyy 
>hostnames refer
>to the
>same logical host as xxx.yyy -- eg while commonly normal websites start
>with
>www, most also work without the 'www.'.
>
>>
>> After briefly reading a few of the mailing list messages on US
>> banks/credit unions that are not allowing their transaction to be
>> downloaded/available in an open format, I have also wanted to start
>> emailing various financial institutions about whether they intend to
>> make such a format available. I would still need to further review
>the
>> formatting situation described in the email chains before I start
>asking
>> around and then opening an account at such a financial institution,
>but
>> if the main GnuCash website still doesn't work, it is hard to write
>such
>> emails at all.
>>
>> Brad
>>
>>
>> On 3/17/23 11:00, Ken Pyzik wrote:
>> > So checking websites statuses today:
>> >
>> > https://www.gnucash.org  - privacy/certificate error
>> > http://www.gnucash.org  - Default appache2 page
>> > https://code.gnucash.org/website  - working perfectly.
>> >
>> > As noted - this has been an issue since 11 February.  The https://
>was working at one point a couple of weeks ago -- but now it is not.
>> >
>> > FYI -- Ken
>> >
>> > -Original Message-
>> > From:
>gnucash-user  On
>Behalf Of 

Re: [GNC] Outstanding / due invoices report?

[Murugan Muruganandam]

Simon

You can use the customer report to get a statement which you can send, this 
includes the invoice paid and also outstanding with ageing.




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Simon Roberts 
Sent: Sunday, March 19, 2023 10:17 AM
To: Gnucash Users 
Subject: [GNC] Outstanding / due invoices report?

Hi all,

I'm wondering if there's a built-in report, in a form suitable for sending
to a client, that lists the invoices they currently owe. Or perhaps those
that are overdue?

I'm creating a reminder as a simple email message, but this seems like
something others might need, and therefore something that might be part of
GNC already.

Ideally, it would be nice to be able to append this to any new invoice for
that same customer, maybe.

I have found Business->Customer->Invoices Due Reminder, but that seems to
be solely to tell me what's due/overdue and isn't printable.

Does any such thing exist?

Cheers,
Simon

--
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 4.9.x fails to open

[john]

Please open a bug report 
(https://bugs.gnucash.org/enter_bug.cgi?product=GnuCash) and attach the whole 
crash report. 

Regards,
John Ralls


> On Mar 19, 2023, at 7:21 AM, G R Hewitt  wrote:
> 
> Greetings fellow users.
> 
> I wanted to try out the latest - though unstable - versions.
> 
> Downloaded and installed OK and I get the splash screen then it all
> disappears.
> Thinking it was my ageing MacPro mid 2010 running High Sierra I loaded it
> on my 2017 iMac running Ventura, with the same results.
> 
> The crash report, relevant part said:
> -
> System Integrity Protection: enabled
> 
> Crashed Thread:0  Dispatch queue: com.apple.main-thread
> 
> Exception Type:EXC_CRASH (SIGABRT)
> Exception Codes:   0x, 0x
> Exception Note:EXC_CORPSE_NOTIFY
> 
> Termination Reason:DYLD, [0x4] Symbol missing
> 
> Dyld Error Message:
>  Symbol not found: _aligned_alloc
>  Referenced from:
> /Applications/Gnucash.app/Contents/MacOS/../Resources/lib/libgnc-app-utils.dylib
>  Expected in: /usr/lib/libSystem.B.dylib
> -
> Any suggestions welcome, thanks in advance.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help with downloading transactions.

[Kalpesh Patel]

Being a victim (financial institutions and gov't agencies do not agree with
this in the US as they believe that you and I are just a innocent third party
and largely they are the ones who have been defrauded) of larger theft after a
breach they were able to garner close to six figure fraud in matter of days I
whole heartly agree that should check your transactions frequently as
possible. While most will make you whole eventually, it nonetheless is an
anticipated time-consuming undertaking when you get engulfed in it. 

In the US I highly recommend that you look into placing security freeze on
your credit files and at ChexSystems at minimum, which now is free for
everyone unlike in the past where you were charged fee for it. 

Those that want to perpetrate fraud have gotten better by surveilling accounts
by putting what appears to be a small (in pennies sometimes) "trial" purchases
over time to see if they can be caught before making a leap. While financial
institutions have very intelligent surveillance systems in place to catch such
activities, you are really the best defense for your account.


> --
> 
> Message: 1
> Date: Sat, 18 Mar 2023 08:35:57 -0700
> From: Stan Brown 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Help with downloading transactions.
> Message-ID: <7770b345-5253-7fc6-2edd-15c70d27b...@fastmail.fm>
> Content-Type: text/plain; charset=UTF-8
> 
> On 2023-03-18 06:13, Simon Roberts wrote:
> > I feel compelled to add my agreement with Alan. This kind of crime is on
> > the rise and we're all vulnerable.
> 
> And that's why it's important to monitor accounts no less often than
> every few days -- waiting till the end of the month gives fraudsters too
> much time to operate.
> 
> Most banks these days (at least in US) let you configure your account to
> send you an email or text notification with the amount every time your
> card is used. All that I have used let you specify a minimum transaction
> amount for such alerts. IMHO the proper choice of a minimum of one cent.
> 
> > Credit card companies insist on giving
> > many fiscally prudent folks much higher credit limits than they actually
> > use, and that just adds to the risk.
> 
> It does. But as long as credit scores are higher for people for utilize
> a lower percentage of their credit limits, there is a good reason not to
> turn down a higher limit if you can get one. (Credit scores can affect
> not just loans you may apply for but also whether you can rent an
> apartment or get car insurance at normal rates.)
> 
> > Debit cards are worse since the
> > protections are far weaker (at least in the U.S.).
> 
> Many banks extend the same protections to their own debit cards that the
> law mandates for credit cards, so protection is not necessarily worse --
> in theory. But even in those cases, you're correct in practice since a
> fraudulent withdrawal from your checking account via debit card takes
> the money out immediately, which may cause legitimate checks or
> withdrawals to bounce.
> 
> > I check my data twice monthly with downloads.
> 
> Better than not checking it at all, but IMHO not often enough.
> 
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> 
> 
> --

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Gnucash 4.9.x fails to open

[G R Hewitt]

Greetings fellow users.

I wanted to try out the latest - though unstable - versions.

Downloaded and installed OK and I get the splash screen then it all
disappears.
Thinking it was my ageing MacPro mid 2010 running High Sierra I loaded it
on my 2017 iMac running Ventura, with the same results.

The crash report, relevant part said:
-
System Integrity Protection: enabled

Crashed Thread:0  Dispatch queue: com.apple.main-thread

Exception Type:EXC_CRASH (SIGABRT)
Exception Codes:   0x, 0x
Exception Note:EXC_CORPSE_NOTIFY

Termination Reason:DYLD, [0x4] Symbol missing

Dyld Error Message:
  Symbol not found: _aligned_alloc
  Referenced from:
/Applications/Gnucash.app/Contents/MacOS/../Resources/lib/libgnc-app-utils.dylib
  Expected in: /usr/lib/libSystem.B.dylib
-
Any suggestions welcome, thanks in advance.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Outstanding / due invoices report?

[Simon Roberts]

Hi all,

I'm wondering if there's a built-in report, in a form suitable for sending
to a client, that lists the invoices they currently owe. Or perhaps those
that are overdue?

I'm creating a reminder as a simple email message, but this seems like
something others might need, and therefore something that might be part of
GNC already.

Ideally, it would be nice to be able to append this to any new invoice for
that same customer, maybe.

I have found Business->Customer->Invoices Due Reminder, but that seems to
be solely to tell me what's due/overdue and isn't printable.

Does any such thing exist?

Cheers,
Simon

-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Temporary Website URL

[David T. via gnucash-user]

Brad, 

I just want to note that your acquaintance has a remarkably parochial attitude 
about software. GnuCash has been available and actively developed for something 
like 25 years.

It seems to me that in this era of "big data," those commercial companies are 
more interested in the customer as a source of data mining income than as a 
partner using their software.

*And* outages with major commercial platforms (Twitter, Facebook?) underscore 
that it is not just open source projects that fail sometimes. 

David T. 



On Mar 18, 2023, 4:21 PM, at 4:21 PM, Robert Heller  wrote:
>At Sat, 18 Mar 2023 06:04:52 -0700 Brad Morrison
> wrote:
>
>> 
>> Thanks for point these situations out Ken! The reason I joined the 
>> GnuCash-User mailing lists was because I sent a link to an
>acquaintance 
>> that does bookkeeping professionally and he texted back that the
>website 
>> was down, he then did a Google search and tried the GnuCash result on
>
>> his own and that link didn't work either, and he then goes on to tell
>me 
>> that this is why he doesn't trust open source projects with his
>business 
>> or his clients' business. It was pretty embarrassing for me and I
>have 
>> hesitated to refer any possibly interested professionals that I meet
>to 
>> GnuCash since.
>> 
>> I can confirm the certificate error for website #1. It looks like 
>> gnucash.org uses Let's Encrypt (https://letsencrypt.org/) as the 
>> certificate authority and the certificate was valid from December 12,
>
>> 2022 until March 11, 2023. My understanding was that Let's Encrypt
>was 
>> free, so that might mean that it just has to be
>renewed/reauthorized...?
>
>Let's Encrypt uses a program "certbot" which is supposed to
>automagically 
>renew the certificate.  It does try to verify the domain it is for by
>visiting 
>the website.  Since there was a webserver config problem (the redirect
>config 
>was broken), it is likely that the automagical renewal failed...
>
>> 
>> I can confirm that website #2 still lists the "Apache2 Ubuntu Default
>
>> Page" error for the non-https/secure gnucash website. I believe that 
>> John mentioned that Linas upgraded his server in January and that
>broke 
>> this feature and it has not been fixed since.
>> 
>
>Yes, this webserver config error needs to be fixed.  Once it is fixed,
>the 
>Let's Encrypt certbot program will be able to renew the certificate,
>which 
>will fix the https://www.gnucash.org error.
>
>> I also see Gnucash website #3 as working well. I can see that that 
>> website also uses Let's Encrypt as the certificate authority and that
>
>> certificate is valid from March 5, 2023 until June 3, 2023.
>> 
>> I also noticed that website #1 & #2 has 2 "Subject Alt Names" 
>> (gnucash.org & www.gnucash.org) on that certificate, while website #3
>
>> has just 1 (code.gnucash.org).
>
>Yes, this is a "normal" thing.  Almost all www.xxx.yyy hostnames refer
>to the 
>same logical host as xxx.yyy -- eg while commonly normal websites start
>with 
>www, most also work without the 'www.'.
>
>> 
>> After briefly reading a few of the mailing list messages on US 
>> banks/credit unions that are not allowing their transaction to be 
>> downloaded/available in an open format, I have also wanted to start 
>> emailing various financial institutions about whether they intend to 
>> make such a format available. I would still need to further review
>the 
>> formatting situation described in the email chains before I start
>asking 
>> around and then opening an account at such a financial institution,
>but 
>> if the main GnuCash website still doesn't work, it is hard to write
>such 
>> emails at all.
>> 
>> Brad
>> 
>> 
>> On 3/17/23 11:00, Ken Pyzik wrote:
>> > So checking websites statuses today:
>> >
>> > https://www.gnucash.org  - privacy/certificate error
>> > http://www.gnucash.org  - Default appache2 page
>> > https://code.gnucash.org/website  - working perfectly.
>> >
>> > As noted - this has been an issue since 11 February.  The https://
>was working at one point a couple of weeks ago -- but now it is not.
>> >
>> > FYI -- Ken
>> >
>> > -Original Message-
>> > From:
>gnucash-user  On
>Behalf Of John Ralls
>> > Sent: Sunday, February 19, 2023 3:40 PM
>> > To:gnucash-annou...@lists.gnucash.org
>> > Cc: gnucash-devel; Gnucash
>Users
>> > Subject: [GNC] Temporary Website URL
>> >
>> > As most everyone already knowswww.gnucash.org  has been offline
>since 11 February because Linas Vepstas lost internet access and his
>ISP, Grande Networks in Austin, TX, has not fixed it.
>> >
>> > To provide replacement service until Linas gets back online we've
>set up an alternate site,https://code.gnucash.org/website/.
>> >
>> > Regards,
>> > John Ralls
>> >
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > Please