[GNC] CVS Deposit Issue

[Chris Ledbetter via gnucash-user]

I am importing Transactions via CSV.  When the importing is finished the 
Deposit is being doubled upon import.  I am using 4.12 and have not updated yet 
since I am doing a lot of input and would rather not mess with this until 
later.  I use a MacBook Pro M1 Ventura 13.3.1.  Here is a demo import CSV file 
that Deposits $15 via import but should be $7.50.  I have been going in and 
dividing transactions in the register by 2 to get the correct values.  I just 
tried dividing the cells by 2 before exporting to CSV but when the system 
doubles the amount at import, there is often a penny difference.  If there is 
an easy work around that will be fine.  I can get by doing the math in the 
register but I’d rather not.  Here is a screenshot of my sample numbers file 
that I export to CSV before I import.  Thanks
___
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 5 - import transactions

[Valued Customer via gnucash-user]

Hi. This is the first time I've tried to use the mailing list for help. I think 
I may having the same issue being described in this string. 
iMac Intel 2021 Ventura
Gnucash Version: 5.0
Build ID: 5.0+(2023-03-25)

When I import transactions from CVS no matching is occurring even though many 
of the transactions' descriptions are exact matches. If there is a solution in 
this email exchange, I'm not understanding it. 

I've spent a lot of time with Gnucash over the last few months and have entered 
two years worth of transactions. I've had some limited success with the import 
matcher but, my last attempt resulted in zero matches.

Mitch



Sincerely,
Valued Customer

Sent with Proton Mail secure email.

--- Original Message ---
On Tuesday, April 25th, 2023 at 3:16 PM, Joseph St. Denis via gnucash-user 
 wrote:


> I finally got the CVS download to work in 5.0. I had to drop using the type 
> of transaction to get it to work. Instead of the four columns that I used in 
> 4.13. When I tried a second CVS transfer from a second account Gnucash 
> shutdown. When I reopened Gnucash all the transactions were present.
> 
> All the best
> 
> Joseph St Denis
> 
> Get Outlook for Androidhttps://aka.ms/AAb9ysg
> 
> 
> From: gnucash-user gnucash-user-bounces+stdenis0=yahoo@gnucash.org on 
> behalf of Christian Lynbech christ...@defun.dk
> 
> Sent: Tuesday, April 25, 2023 3:34:33 PM
> To: john jra...@ceridwen.us
> 
> Cc: gnucash-user@gnucash.org gnucash-user@gnucash.org
> 
> Subject: Re: [GNC] Gnucash 5 - import transactions
> 
> I have now done a few more experiments and is not any less confused.
> 
> So to iterate, using 4.14, automatching works, using 5.0 it does not
> work.
> 
> I tried turning on logging as John suggested. When I import to 5.0, I
> get nothing logged during the operation. However, when trying to do the
> import with 4.14, I am getting a number of warnings like this:
> 
> * 20:07:17 INFO  [GncTxImport::update_pre_split_props] User 
> warning: Column 'Konto' could not be understood.
> 
> 
> The word "Konto" is danish for "Account". Even so, automatching did
> work. I am attaching the log files from the two attempts below.
> 
> I then thought, perhaps this is a language thing (I am using danish both
> on my computer and in the books), so I c'tried changing the language to
> english but it did change the results, no automatching on verson 5.
> Also, the warnings I see in version 4, now was in english (e.g
> "Account").
> 
> I have also tried generating a completely new book, as simple as can be,
> but the behaviour is exactly the same, so it is not something something
> that has piled up in my actual book.
> 
> Since this does not appear to be a universal issue, it is possible that
> it is somehow language related.
> 
> Attached below are the two aforementioned log files, the one named with
> "4" is from the 4.14 run (which works) and the one with a "5" is from the
> 5.0 version (that is not working).
> 
> I can provide my test book and sample CSV files as well, if anybody
> would like to see them.
> 
> Thanks for taking an interest in my issue.
> 
> /Christian
> 
> 
> ___
> 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 5 - import transactions

[Joseph St. Denis via gnucash-user]

I finally got the CVS download to work in 5.0. I had to drop using the type of 
transaction to get it to work. Instead of the four columns that I used in 4.13. 
When I tried a second CVS transfer from a second account Gnucash shutdown. When 
I reopened Gnucash all the transactions were present.

All the best

Joseph St Denis

Get Outlook for Android

From: gnucash-user  on 
behalf of Christian Lynbech 
Sent: Tuesday, April 25, 2023 3:34:33 PM
To: john 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Gnucash 5 - import transactions

I have now done a few more experiments and is not any less confused.

So to iterate, using 4.14, automatching works, using 5.0 it does not
work.

I tried turning on logging as John suggested. When I import to 5.0, I
get nothing logged during the operation. However, when trying to do the
import with 4.14, I am getting a number of warnings like this:

* 20:07:17  INFO  [GncTxImport::update_pre_split_props] User 
warning: Column 'Konto' could not be understood.

The word "Konto" is danish for "Account". Even so, automatching did
work. I am attaching the log files from the two attempts below.

I then thought, perhaps this is a language thing (I am using danish both
on my computer and in the books), so I c'tried changing the language to
english but it did change the results, no automatching on verson 5.
Also, the warnings I see in version 4, now was in english (e.g
"Account").

I have also tried generating a completely new book, as simple as can be,
but the behaviour is exactly the same, so it is not something something
that has piled up in my actual book.

Since this does not appear to be a universal issue, it is possible that
it is somehow language related.

Attached below are the two aforementioned log files, the one named with
"4" is from the 4.14 run (which works) and the one with a "5" is from the
5.0 version (that is not working).

I can provide my test book and sample CSV files as well, if anybody
would like to see them.

Thanks for taking an interest in my issue.

   /Christian


___
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 5 - import transactions

[Christian Lynbech]

I have now done a few more experiments and is not any less confused.

So to iterate, using 4.14, automatching works, using 5.0 it does not
work.

I tried turning on logging as John suggested. When I import to 5.0, I
get nothing logged during the operation. However, when trying to do the
import with 4.14, I am getting a number of warnings like this:

* 20:07:17  INFO  [GncTxImport::update_pre_split_props] User 
warning: Column 'Konto' could not be understood.

The word "Konto" is danish for "Account". Even so, automatching did
work. I am attaching the log files from the two attempts below.

I then thought, perhaps this is a language thing (I am using danish both
on my computer and in the books), so I c'tried changing the language to
english but it did change the results, no automatching on verson 5.
Also, the warnings I see in version 4, now was in english (e.g
"Account").

I have also tried generating a completely new book, as simple as can be,
but the behaviour is exactly the same, so it is not something something
that has piled up in my actual book.

Since this does not appear to be a universal issue, it is possible that
it is somehow language related.

Attached below are the two aforementioned log files, the one named with
"4" is from the 4.14 run (which works) and the one with a "5" is from the
5.0 version (that is not working).

I can provide my test book and sample CSV files as well, if anybody
would like to see them.

Thanks for taking an interest in my issue.

   /Christian




gnucash-4.log
Description: Binary data


gnucash5.log
Description: Binary data





---
On Mon, Apr 24 2023, john wrote:

> On Apr 12, 2023, at 1:31 AM, Christian Lynbech  wrote:
> 
> After upgrading to Gnucash 5 (Version: 5.0 Build ID: 5.0+(2023-03-25)),
> it seems that I am no longer getting automatching to accounts when
> importing transactions from a CSV file.
> 
> I was not too concerned when I tried to do the first import and no
> matching appeared but now when I tried to do a second import, again no
> matching is done.
> 
> Are there any changes to how this works? Anybody else seeing problems
> with transaction import?
> 
> Is there a way I can see what matching data has been recorded?

There aren't changes to the matcher but Geert went through the CSV
importer bugs in January and fixed a bunch of them.

Tools>import Map Editor that Adrien suggested in his reply to your
Tools> original post will show you the recorded tokens and what
Tools> accounts they indicate.

You can get more logging info by running GnuCash from Terminal with
--log gnc.import=debug. The output is written to the trace file, which
you can change by adding --logto=stderr to send it to the console or
--logto=/some/path to send it to a more convenient file.

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.

Re: [GNC] Reconcile w/ open transaction

[Fred Tydeman]

OS:  Linux Fedora 37
GnuCash 4.14

On Tue, Apr 25, 2023 at 9:30 PM David Carlson 
wrote:

> Fred, Please remind us of your GnuCash release and OS, since there has
> been some rather recent changes in the areas involved on your question.
>
> On Tue, Apr 25, 2023, 1:14 PM Fred Tydeman  wrote:
>
>> I updated three transactions by changing N to C in the R column and
>> correcting the amount in the last of the three transactions.
>> I did a Reconcile and ended it with Finish.
>> I tried to save the book / file.  That got me a popup telling me I had an
>> open transaction and should I close it.  I clicked on: close it.
>> The Y from the Reconcile reverted back to the C before the Reconcile.
>> So, I had to do the Reconcile again.
>> It seems to me that trying to do a Reconcile should check for any open
>> (not saved) transactions before starting the reconcile process.
>> ___
>> 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] Error in Advanced Portfolio

[Fred Tydeman]

I tracked the problem to a return of capital that I had entered the day
after I sold all the shares of a stock.
By moving the return of capital to the day before the sale, the error went
away.
I never had a negative share balance.  The return of capital has money, but
no shares.
So, I found the error message misleading.

On Tue, Apr 25, 2023 at 7:08 AM Fred Tydeman  wrote:

> When I run an Advanced Portfolio report, I am getting:
>
> There is an error processing the transaction 'spinoff of 0.00 currency
> units'. This may to be caused by a sell transaction causing a negative
> stock balance, and a subsequent buy transaction causing a zero balance.
> This leads to a division-by-zero error. It can be fixed by preventing
> negative stock balances.
>
> One way to find out which security is to start picking subsets of accounts.
> Is there a better way to find out which security it is complaining about?
>
>
>
___
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] Reconcile w/ open transaction

[David Carlson]

Fred, Please remind us of your GnuCash release and OS, since there has been
some rather recent changes in the areas involved on your question.

On Tue, Apr 25, 2023, 1:14 PM Fred Tydeman  wrote:

> I updated three transactions by changing N to C in the R column and
> correcting the amount in the last of the three transactions.
> I did a Reconcile and ended it with Finish.
> I tried to save the book / file.  That got me a popup telling me I had an
> open transaction and should I close it.  I clicked on: close it.
> The Y from the Reconcile reverted back to the C before the Reconcile.
> So, I had to do the Reconcile again.
> It seems to me that trying to do a Reconcile should check for any open
> (not saved) transactions before starting the reconcile process.
> ___
> 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] Reconcile w/ open transaction

[Fred Tydeman]

I updated three transactions by changing N to C in the R column and
correcting the amount in the last of the three transactions.
I did a Reconcile and ended it with Finish.
I tried to save the book / file.  That got me a popup telling me I had an
open transaction and should I close it.  I clicked on: close it.
The Y from the Reconcile reverted back to the C before the Reconcile.
So, I had to do the Reconcile again.
It seems to me that trying to do a Reconcile should check for any open
(not saved) transactions before starting the reconcile process.
___
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] moving stocks across accounts lost the basis price in the Portfolio report

[Murugan Muruganandam]

hi Mattia

When moving securities across portfolio, if you do not want any profit/loss, 
then you have to register exact price which you have bought.
Expenses incurred earlier are what you paid for the transaction. This should 
not be grossed up in your pricing when you transfer; as this will result in 
Realized Loss in your original portfolio.
If you want to transfer the expenses also to a new expenses account, then you 
can add the following entries in the transfer transaction


Dr Investment:Stocks USD: AMZN:  $1256.2  (Price $ 125.62, Qty 10)
Cr: Assets: Investments: Stock USD: AMZN : $1256.2 (Price $ 125.62, Qty -10)
Cr  Expenses: fees:Investment: USD:   $3.95
Dr  Expenses: Fees: Stocks: USD:   $3.95 (new expenses account)




Saludos Cordiales


Murugan


From: Mattia Rizzolo 
Sent: Tuesday, April 25, 2023 7:23 AM
To: Murugan Muruganandam 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] moving stocks across accounts lost the basis price in the 
Portfolio report

Hello Murugan, and apologizes, it seems back in January I missed your
answer somehow!

So, I attached here a screenshot of just the AMZN stock which I moved
around.  For the purposes of the move, I eneded up including the fees
into the basis price; normally I use the "gross pricing" method as I am
interested in tracking how much fees I pay and to whom.  Do you think
this the correct way to handle this?

Incidentally, doing this also created a new entry in the price database,
with the price that I inserted there… (which is… wrong in this case,
isn't it? So I'll end up having to manually delete them all again?)


On Mon, Apr 24, 2023 at 02:42:51PM +, Murugan Muruganandam wrote:
>
> hi mattia
>
> this query was responded in January
>
>
> On the transfer transaction, you are transferring it with zero price.
> you need to transfer it with a cost price , then only system will recognize 
> the profit/loss. in your transaction you are buying and selling at 0 price , 
> so the system considers it as 100% loss
>
> please look at the sample images attached in the email
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user 
>  on behalf of 
> Mattia Rizzolo 
> Sent: Monday, April 24, 2023 9:44 AM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] moving stocks across accounts lost the basis price in the 
> Portfolio report
>
> Hello,
>
> A couple of weeks ago I had some stocks moved across different accounts.
>
> In gnucash, I tried recording them as this, for example:
>
> shares  price  debit  credit
> A:Investements:Broker1:P1:USD:AMZN  -10
> A:Investements:Broker1:P2:USD:AMZN   10
>
> I left price/debit/credit completely empty, and no other split.
>
> I noticed a few days later that these transactions (I moved roughly a
> dozen titles) generated some prices in the Price Database, adding a
> recorded price of $0 for all the stocks that were involved in this move;
> I noticed this when I had a glance at the net worth report and noticed a
> stupid downward peak.  So I removed the faulty prices from the database
> and now that looks correct.
>
> Even more recently I was looking at the "Advance Portfolio" report, and
> realized now that all the stocks that were involved in this move seem to
> have a "Basis" of €0.00 (and also money-in/money-out).
>
> This seems to be caused by the fact that in the Advanced Portfolio each
> account is on its own, so unticking the "Include accounts with no
> shares" I noticed that, limiting to my example above, I have two AMZN
> lines:
>  * one with 0 shares, 0€ money out, -100.00% realized loss.
>  * one with 10 shares, 0€ money in/out, 0€ basis, and empty cells (due
>to the 0€ basis, which I guess would cause divide-by-zero errors)
> (I mentioned a related issue I had with this here:
> https://lists.gnucash.org/pipermail/gnucash-user/2023-January/105229.html
> )
>
>
> How do you recommend I fix this situation?  Should I just add a price to
> the transactions to give them a basis, or what else?  If I did that, how
> could I also "carry over" the fees accrued till now?  Just manually
> compute them in the "new basis"?
>
>
> Thank you for your suggestions.
>
>
>
> PS: For some stocks I could potentially rename the accounts instead of
> doing this move, but this wouldn't be possible for all stocks, as both
> portfolios (in the same broker, yes) have shares of the same companies
> that I need to keep separate.
>
> --
> regards,
> Mattia Rizzolo
>
> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
> More about me:  https://mapreri.org : :'  :
> Launchpad user: https://launchpad.net/~mapreri  `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-

> Date: Fri, 27 Jan 2023 02:16:03 +
> From: Murugan Muruganandam 
> To: Mattia Rizzolo 
> Subject: Re: [GNC] coalesce the stock accounts in 

Re: [GNC] Can't reenter password for OFX DirectConnect

[Brad Morrison]

Hi Alex S/all,

Hopefully someone else will address the GnuCash aspect of your specific 
issue with the OFXDirectConnect. I would like to comment on the 
situation with banks allowing transactional data downloads in the OFX 
file format (https://en.wikipedia.org/wiki/Open_Financial_Exchange).


I am still trying to find a professional bookkeeper in the USA that uses 
GnuCash, but based on not seeing anyone respond on this mailing list to 
Bob Treumann's March 1 ask or my March 7 reply, I'm assuming that there 
are no US-based professional bookkeepers on this mailing list that use 
GnuCash AND are taking on new clients.


All 3 of the local (Sonoma County, CA, USA - 
https://en.wikipedia.org/wiki/Sonoma_County,_California) bookkeeping 
firms that I have asked about using GnuCash were unfamiliar with the 
software, 2 of the 3 only used Quickbooks (1 also used Xero), and only 1 
expressed any interest in using GnuCash, but did not email back when I 
followed up a week later. I found these bookkeeping firms through Sonoma 
County Go Local's directory 
(https://sonomacounty.golocal.coop/businesses/services-professional/accounting-tax-bookkeeping-and-payrol/). 
It does not appear that the 2 national bookkeeping organizations 
(https://aipb.org/ & https://nacpb.org/) that I found online have local 
chapters, although I have not asked them directly yet.


As part of this project of mine, I have been trying to find a bank that 
allows transactional data downloads in the OFX file format and using 
that inquiry as an opportunity to ask about whether the bank has a 
policy of sourcing/using open source software. I started with SRI 
(https://en.wikipedia.org/wiki/Socially_responsible_investing) banks 
that I knew of because I thought that they would be the most open to & 
interested in open source software and the concepts/philosophies of 
transparency and sharing behind its development and use. Every bank that 
I have asked so far has said that they do not allow transactional data 
downloads in the OFX file format and none have said that they have a 
policy regarding open source software. I have received responses from 
these banks so far:


 * https://en.wikipedia.org/wiki/Beneficial_State_Bank
 * https://en.wikipedia.org/wiki/Amalgamated_Bank
 * https://en.wikipedia.org/wiki/Pacific_Premier_Bancorp
 * https://en.wikipedia.org/wiki/National_Cooperative_Bank

I have sent inquires to more banks, but those are the only ones that 
have responded so far. I have not asked Regions Bank 
(https://en.wikipedia.org/wiki/Regions_Financial_Corporation), but after 
seeing your post, I was going to. However, it does not appear from their 
website messages section (https://www.regions.com/help > 
https://www.regions.com/digital-banking/digital-services/reggie-digital-assistant) 
that they accept incoming electronic messages from non-customers. I have 
also been surprised that Regions Bank does not seem to have a "Contact 
Us" tab anywhere on their header or footer list of standard options, so 
I used the "Help & support" section. Maybe they are not seeking new 
customers, but that would be unusual...? As a customer, you may want to 
reach out to ask Regions Bank if they still support OFX Direct Connect.


Finally, I have been able to find 2 regional credit unions that allow 
transactional data downloads in the OFX file format 
(https://www.redwoodcu.org/ & 
https://en.wikipedia.org/wiki/Patelco_Credit_Union). I have only asked 
these 2 credit unions so far and since both said yes (and RCU even 
directed me to their page about financial data downloads - 
https://www.redwoodcu.org/ask-rcu/2199/) and none of the banks that have 
even responded to me have said yes, I wondered if some back end 
technology provider that FDIC insured 
(https://en.wikipedia.org/wiki/Federal_Deposit_Insurance_Corporation) 
banks use, but NCUA insured 
(https://en.wikipedia.org/wiki/National_Credit_Union_Administration) 
credit unions do not use might be responsible for this lack of support 
for OFX...?


After having such little luck fishing for banks that support OFX, it 
just occurred to me over the weekend that it might be a good idea to ask 
banking associations 
(https://en.wikipedia.org/wiki/Independent_Community_Bankers_of_America 
& https://www.icba.org/) and advocacy organizations that work with banks 
(https://www.greenamerica.org/finance & https://mightydeposits.com/) 
about interest from community banks in OFX, GnuCash, & open source 
software.


When I write local organizations, I usually reference the North Bay 
Linux Users Group (NBLUG - https://nblug.org/) because I am on the 
board, but I leave that part out of my template when inquiring with 
larger or non-local financial institutions & organizations. I'm open to 
any suggestions/ideas/help if anyone else is interested in this project...


Onward and upward,

Brad


On 4/24/23 13:59, Thepwnd via gnucash-user wrote:

This is a weird one for me. I have an account with Regions Bank that I 

Re: [GNC] Gnucash 5 - import transactions

[Geert Janssens]

Hi Joseph,

Can you be a bit more precise here ? What steps have you taken to import (which 
menu 
item you started from, which options in the importer did you tweak, what do you 
see on 
screen at the spot you get stuck,...)

Regards,

Geert

Op maandag 24 april 2023 22:39:18 CEST schreef Joseph St. Denis via 
gnucash-user:
> I am also having problems with the CVS imports, but my problem is that the
> only way I can complete the download is to eliminate the errors and no
> entrys are selected. I tried the date, discretionary
> 

___
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] Error in Advanced Portfolio

[David Carlson]

You could pick half the time interval, then half of whichever half was not
ok.  If both halves have errors, it gets more fun, but it still works as a
procedure.

On Mon, Apr 24, 2023, 11:09 PM Fred Tydeman  wrote:

> When I run an Advanced Portfolio report, I am getting:
>
> There is an error processing the transaction 'spinoff of 0.00 currency
> units'. This may to be caused by a sell transaction causing a negative
> stock balance, and a subsequent buy transaction causing a zero balance.
> This leads to a division-by-zero error. It can be fixed by preventing
> negative stock balances.
>
> One way to find out which security is to start picking subsets of accounts.
> Is there a better way to find out which security it is complaining about?
> ___
> 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] Building Gnucash on Fedora 37 - "No package 'glib-2.0' found" error

[Geert Janssens]

Hi,

A late reply...

I'm on Fedora 37 as well, but can't reproduce the error.

I'm currently building the current stable branch though, not 4.13. Where does 
your 
gnucash-4.13 come from ? Is that a release tarball, or a git checkout ?

Regards,

Geert

Op donderdag 9 maart 2023 23:52:52 CEST schreef Vivek Gani:
> Hi,
> 
> I'm trying to build gnucash from source (rather than the rpm package or
> flatpak for python bindings) on Linux (Fedora 37) and keep running into an
> issue where on build I get the error:
> 
> ```
> -- Checking for module 'glib-2.0>=2.56.1'
> --   No package 'glib-2.0' found
> ```
> 
> What I've tried so far:
> - I've installed glib2.0-devel via `sudo dnf install glib2-devel`
> - I've checked via `yum provides */glib2.0.pc` which shows it is in the
> `/usr/lib64/pkgconfig` directory.
> - I've checked the contents of `echo $PKG_CONFIG_PATH` which shows
> directories like `/usr/lib64/pkgconfig` are listed.
> - I've tried building gnucash with various different arguments, but similar
> to the directions in
> https://wiki.gnucash.org/wiki/CMake#GnuCash_Configuration_Variables &
> https://wiki.gnucash.org/wiki/Building_On_Linux#Build_using_CMake_and_Ninja
> I've tried in my build directory:
> `cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt
> -DCMAKE_PREFIX_PATH=$PKG_CONFIG_PATH  -DCMAKE_VERBOSE_MAKEFILE=on
> ../gnucash-4.13`
> 
> and get the glib error. It happens also without the CMAKE_PREFIX_PATH, just
> running plain `cmake .` in the gnucash source directory, etc.
> 
> Any idea what I'm missing to get things to build?
> 
> Thanks in advance,
> Vivek
> ___
> 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] CSV import crash in 5.0+

[Geert Janssens]

Op vrijdag 21 april 2023 04:59:40 CEST schreef John Ralls:
> > On Apr 20, 2023, at 6:52 AM, Joseph Vernice  wrote:
> > 
> > I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading
> > to
> > 5.0 (and above nightly builds) I am unable to import transactions from
> > CSV.  The system crashes when I select the CSV import profile or when I
> > try
> > to create a new one.  The crash accors immediately after selecting the
> > profile OR after assigning the AMOUNT column. I have resorted to the
> > latest
> > pre-5.0 build in order to import from CSV.  Unfortunately, my Fidelity
> > checking account only allows for CSV export, so this is an essential means
> > for me to import into gnucash. Thank you everyone for all your help.
> 
> There are two open CSV crashers,
> https://bugs.gnucash.org/show_bug.cgi?id=798799 and
> https://bugs.gnucash.org/show_bug.cgi?id=798830. The first is about the CSV
> having fewer fields in the first line than in the second and while GnuCash
> shouldn't crash in that case IMO it should reject the file as ill-formed.
> The second involves entries having a '/' character.
> 
> If your problem file matches neither of those please file a new bug report.
> Be sure to attach the trace file[1] and if possible a stack trace[2].
> 
> Regards,
> John Ralls
> 
> [1] https://wiki.gnucash.org/wiki/Tracefile
> [2] https://wiki.gnucash.org/wiki/Stack_Trace
> 
> 
If GnuCash crashes then this is very likely the same issues as
https://bugs.gnucash.org/show_bug.cgi?id=798877
(https://bugs.gnucash.org/show_bug.cgi?id=798799 is a duplicate of this one)

That issue has now been fixed and will appear in tomorrow's nightly. You can 
try that one to 
test if you like.

Regards,

Geert
___
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.