Re: [GNC] Scheduled transactions details

[Kalpesh Patel]

David,

 

Thank you for that primer appreciate it.

 

Boy was I under huge mis-understanding behind their intent for sure. My 
understanding of “value” was more aligned with like value of the transaction at 
hand for me, for example like $90 for the monthly train pass as a scheduled 
transaction.

 

Since I deal only with US Dollars currency, should that be just a value of 1? I 
reckon that I won’t have any transactions that creates imbalance.

 

From: David Carlson  
Sent: Tuesday, November 02, 2021 12:43 PM
To: Kalpesh Patel 
Cc: Gnucash Users 
Subject: Re: [GNC] Scheduled transactions details

 

I'll take a stab at answering these questions.

 

1 the value column comes into play when there are accounts valued in more than 
one currency or security and there is an exchange involved.   The most common 
case is an investment transaction.   The Since Last Run 😈  needs manual input 
to assign an exchange valuation to the transaction. 

 

2 All transactions must be balanced with equal debits and credits.  The 
Scheduled Transaction Editor cannot test amounts defined with variables for 
balance.   The Since Last Run 😈  can force the user to assign an exchange rate 
where needed, but for cases where there is still an imbalance in a single 
currency GnuCash will automatically assign it to an imbalance account in the 
specific currency. 

 

On Tue, Nov 2, 2021, 9:02 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

Hi Everyone –



Two questions –



1 - I noticed that the “Value” column next to “Status” in the “Since Last
Run …” window that pops-up when GNC is launched or manually run from
‘Actions” à ‘Scheduled Transaction’ à ‘Since Last Run…’ is blank. I know I
have some scheduled ones that have fixed amount so I was wondering where
that setting is configured to show the value of that transaction. All of my
scheduled transactions are set as reminder in advance and create in advance
if that is in play somehow.



2 – In scheduled transaction editor, is there a column that shows the amount
of the transaction, whether fixed amount or the formula? I think not given
that it could be a split transaction that would be difficult to represent in
a condensed format. I checked the column selector drop down and I don’t see
one so not likely but I figure I ask in case it is there and can be made to
seeable.



I am running GNC 4.8 on Windows 10.



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

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

[GNC] Updating from v 2.6.16.

[Mike Stillingfleet]

Good Evening All,

It would appear that my current version of 2.6.16 is a bit out of date.

I have been looking at a route to updating. 

I see that I can download a stable version 3.11 and 4.8.

My question is can I install all 3 versions at the same time so that I can 
migrate and check the integrity before moving forward whilst ensuring that I 
still have a viable system in 2.6.16.

If so how would I do the install.  I use Windows 10.

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

Re: [GNC] Updating from v 2.6.16.

[Liz]

On Thu, 04 Nov 2021 20:58:09 +
"Mike Stillingfleet"  wrote:

> My question is can I install all 3 versions at the same time so that
> I can migrate and check the integrity before moving forward whilst
> ensuring that I still have a viable system in 2.6.16.
> 
> If so how would I do the install.  I use Windows 10.

Can Mike do this with flatpak versions?

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

Re: [GNC] Updating from v 2.6.16.

[davidcousens49]

Mike,

There are three major issues associated with upgrading:

Upgrading the data file format;
Relocation of user preference data/config data (changes of storage location and
methodology;
Preserving any saved reports/config changes;

The first two generally take place, if at all at the major version transitions
2->3->4.

Release numbers are major.minor.micro

The major component of the release number usually flags incompatible
architecture changes, changes to database schema and the API. Minor version
numberssignify stable releases if even and unstable releases if odd. These are
primarily bug fixes and minor feature releases. The micro numbers are sequential
for each release

GnuCash generally includes an inbuilt, run once only procedure to update the
data file format and usually to relocate any config and reports to the new
locations from the last minor release.

Since you ar on Windows, you won't need to build your files the programs. You
can find copies of all releases of GnuCash on SourceForge at this location 
https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/.

Before starting it is a very good idea to make backup copies of your data
files,user data, config etc. File locations in GNuCash are discussed on the
wikipage https://wiki.gnucash.org/wiki/Configuration_Locations but this is a
fairly complex document as it covers all operating systems and GC versions.

Your data files are located in your user directory where you have chosen to
locate them.

The migration of user preferences, saved reports and online Banking data is
discussed in the wiki at 
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html. 

After making backups the procedure is fairly simple. Install GC V3.11
(download gnucash-3.11.setup.exe from 
https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/3.11/ and
run the .exe file to install it as usual on Windows. Open each of your data
files (if you have more than one data file) with the 3.11 version which will do
any necessary datafile modification and shifting of config data etc to new
locations and then save them. Check that all saved reports you use are listed in
the menu and can be used. If not you may need to copy them from the ~/.gnucash
directory specified in the migration wiki above. If everything is working then
you are ready to upgrade to V4. 

If not ask on the User forum for help before proceeding. You shouldn't have to
go back to 2.6 at all at this point, but if you did reinstall V2.6.16 you would
have to restore the data files and config, reports etc form your backups before
opening them.

To go to V4 if there are no problems the procedure is much the same. Make
backups of your data files and the config, reports etc files for V3 as discussed
in https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html.
You shouldn't need these but it never hurts to be careful.

The download the V4 version you wish to install (4.8) and install it. Open ALL
your data files (if more than one) and save them after GC has done any reuired
conversions and migrations). Again check you have all your previous
functionality and that your saved reports are available and functioning.

If all is ok you are good to go at the latest version. If not come back to the 
user forum for assistance.
David Cousens


On Thu, 2021-11-04 at 20:58 +, Mike Stillingfleet wrote:
> Good Evening All,
> 
> It would appear that my current version of 2.6.16 is a bit out of date.
> 
> I have been looking at a route to updating. 
> 
> I see that I can download a stable version 3.11 and 4.8.
> 
> My question is can I install all 3 versions at the same time so that I can
> migrate and check the integrity before moving forward whilst ensuring that I
> still have a viable system in 2.6.16.
> 
> If so how would I do the install.  I use Windows 10.
> 
> T.i.a

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

[GNC] General Ledger amounts missing

[sydnorbilling]

Relative newbie, even though using gnucash for four years, but only use it
once a year to prepare for tax filing and by the next time filing comes
around the following year I forget a lot of how it worked.

 

In trying to print out a General Ledger report, after selecting reports and
General Ledger under Assets & Liabilities, then going to options and
selecting the obvious under GENERAL, then DISPLAY, and ACCOUNTS when I click
OK, the report that comes up has NO AMOUNTS on it?

 

What simple item am I missing?

 

Sharon

 

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

Re: [GNC] Updating from v 2.6.16.

[Gyle McCollam]

Mike, I have been using 4.7 for a couple months now on Windows 10 and I have 
had zero issues.  Version 4.8 was an update for Mac users, because there was an 
issue on Macs with 4.7.  Upgrading the way, you ask would be extremely time 
consuming and I could see if it is not done right causing you many problems 
that a straight upgrade shouldn't cause.  However, if you want to go that route 
you would need to duplicate the program and data files to a new directory.  Not 
move, but duplicate, so you could copy them back if needed.  Then you could 
upgrade to 3.11, check it out and when satisfied, duplicate those program and 
data files to another newly created directory and repeat the upgrade process to 
4.7 or 4.8.  It is a lot of work when the releases are stable and you shouldn't 
have a problem with upgrading.  Whatever you choose, good luck.

Another thought, you could create a restore point in Windows, before each 
upgrade.  That way you can go back to the previous version.  However, you 
couldn't run the 3 versions simultaneously and while you are testing the new 
version any other programs you use would go back to that point in time as well.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Mike Stillingfleet 
Sent: Thursday, November 4, 2021 4:58 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Updating from v 2.6.16.


Good Evening All,

It would appear that my current version of 2.6.16 is a bit out of date.

I have been looking at a route to updating.

I see that I can download a stable version 3.11 and 4.8.

My question is can I install all 3 versions at the same time so that I can 
migrate and check the integrity before moving forward whilst ensuring that I 
still have a viable system in 2.6.16.

If so how would I do the install.  I use Windows 10.

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

Re: [GNC] General Ledger amounts missing

[Gyle McCollam]

Sharon, not sure, but the simple answer seems to be that under "edit report 
options" you didn't change the start and end dates.  The reports default to the 
current accounting period and you need the start and end of the year.  Hope 
this helps.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of sydnorbill...@bellsouth.net 
Sent: Thursday, November 4, 2021 7:05 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] General Ledger amounts missing

Relative newbie, even though using gnucash for four years, but only use it
once a year to prepare for tax filing and by the next time filing comes
around the following year I forget a lot of how it worked.



In trying to print out a General Ledger report, after selecting reports and
General Ledger under Assets & Liabilities, then going to options and
selecting the obvious under GENERAL, then DISPLAY, and ACCOUNTS when I click
OK, the report that comes up has NO AMOUNTS on it?



What simple item am I missing?



Sharon



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

Re: [GNC] Updating from v 2.6.16.

[David H]

Gyle,

That is not correct.  Version 4.8 was an upgrade for ALL OS's not just Mac
OS.  Version 4.8.2 was an update for Mac OS only to fix screen issues in
Monterey.

Cheers David H.


On Fri, 5 Nov 2021 at 09:16, Gyle McCollam  wrote:

> Mike, I have been using 4.7 for a couple months now on Windows 10 and I
> have had zero issues.  Version 4.8 was an update for Mac users, because
> there was an issue on Macs with 4.7.  Upgrading the way, you ask would be
> extremely time consuming and I could see if it is not done right causing
> you many problems that a straight upgrade shouldn't cause.  However, if you
> want to go that route you would need to duplicate the program and data
> files to a new directory.  Not move, but duplicate, so you could copy them
> back if needed.  Then you could upgrade to 3.11, check it out and when
> satisfied, duplicate those program and data files to another newly created
> directory and repeat the upgrade process to 4.7 or 4.8.  It is a lot of
> work when the releases are stable and you shouldn't have a problem with
> upgrading.  Whatever you choose, good luck.
>
> Another thought, you could create a restore point in Windows, before each
> upgrade.  That way you can go back to the previous version.  However, you
> couldn't run the 3 versions simultaneously and while you are testing the
> new version any other programs you use would go back to that point in time
> as well.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of Mike Stillingfleet 
> Sent: Thursday, November 4, 2021 4:58 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Updating from v 2.6.16.
>
>
> Good Evening All,
>
> It would appear that my current version of 2.6.16 is a bit out of date.
>
> I have been looking at a route to updating.
>
> I see that I can download a stable version 3.11 and 4.8.
>
> My question is can I install all 3 versions at the same time so that I can
> migrate and check the integrity before moving forward whilst ensuring that
> I still have a viable system in 2.6.16.
>
> If so how would I do the install.  I use Windows 10.
>
> T.i.a
> --
>   Mike Stillingfleet
>   mikestillingfl...@fastmail.co.uk
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] QFX import: transaction matching NOT learning to match

[David Mintz]

Hello,

I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I import a QFX, 
nearly all the transactions are assigned to "Imbalanced" even though I have 
gone through multiple iterations of trying to teach GC to recognize 
transactions by assigning the accounts manually. I have seen earlier postings 
about this, but the most detailed discussions were serveral years ago, and the 
most recent says, in substance, "just keep trying". I hesitate to do that 
because I fear it's a fool's errand. How many times do I need to tell it "Stop 
& Shop" belongs to Expenses:groceries?

One strange detail:  I tend to neglect my financial record-keeping for months 
at a time, but as I recall, I was not having this problem a few months ago. It 
seems to be a case of *it used to work but now it doesn't.*

I've read that it may be that it thinks "Imbalanced" is the answer, and cannot 
unlearn. Is there a any way to wipe the slate clean, so to speak, and force GC 
to start over so?

I've also seen that people have written Perl scripts to run against their data 
files and yeah, I could try that -- but I'd much prefer to get GnuCash to work 
properly without having to intervene this way.

Any suggestions?

Gratefully,

David


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

Re: [GNC] QFX import: transaction matching NOT learning to match

[David H]

David,

When you say "by assigning the accounts manually" what do you mean?  I did
see a posting a few months ago that said you have to assign the accounts
during the import process so the importer learns what account the txn is to
go to.  If you are assigning manually after the import process is finished
the importer is never going to learn and you'll have to keep doing it
yourself.

Cheers DAvid H.

On Fri, 5 Nov 2021 at 10:15, David Mintz  wrote:

> Hello,
>
> I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I import a
> QFX, nearly all the transactions are assigned to "Imbalanced" even though I
> have gone through multiple iterations of trying to teach GC to recognize
> transactions by assigning the accounts manually. I have seen earlier
> postings about this, but the most detailed discussions were serveral years
> ago, and the most recent says, in substance, "just keep trying". I hesitate
> to do that because I fear it's a fool's errand. How many times do I need to
> tell it "Stop & Shop" belongs to Expenses:groceries?
>
> One strange detail:  I tend to neglect my financial record-keeping for
> months at a time, but as I recall, I was not having this problem a few
> months ago. It seems to be a case of *it used to work but now it doesn't.*
>
> I've read that it may be that it thinks "Imbalanced" is the answer, and
> cannot unlearn. Is there a any way to wipe the slate clean, so to speak,
> and force GC to start over so?
>
> I've also seen that people have written Perl scripts to run against their
> data files and yeah, I could try that -- but I'd much prefer to get GnuCash
> to work properly without having to intervene this way.
>
> Any suggestions?
>
> Gratefully,
>
> David
>
>
> ---
> David Mintz
> https://davidmintz.org
> Capitalism has failed. https://wsws.org
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX import: transaction matching NOT learning to match

[Jean Laroche]

Make sure you do the assignment during the matching, in the matching 
window. Not after matching is all done in the registry (in which case GC 
does not learn anything).


Jean

On 11/4/21 5:13 PM, David Mintz wrote:

Hello,

I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I import a QFX, nearly all the transactions are 
assigned to "Imbalanced" even though I have gone through multiple iterations of trying to teach GC to 
recognize transactions by assigning the accounts manually. I have seen earlier postings about this, but the most 
detailed discussions were serveral years ago, and the most recent says, in substance, "just keep 
trying". I hesitate to do that because I fear it's a fool's errand. How many times do I need to tell it 
"Stop & Shop" belongs to Expenses:groceries?

One strange detail:  I tend to neglect my financial record-keeping for months 
at a time, but as I recall, I was not having this problem a few months ago. It 
seems to be a case of *it used to work but now it doesn't.*

I've read that it may be that it thinks "Imbalanced" is the answer, and cannot 
unlearn. Is there a any way to wipe the slate clean, so to speak, and force GC to start 
over so?

I've also seen that people have written Perl scripts to run against their data 
files and yeah, I could try that -- but I'd much prefer to get GnuCash to work 
properly without having to intervene this way.

Any suggestions?

Gratefully,

David


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

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

Re: [GNC] QFX import: transaction matching NOT learning to match

[David Mintz]

Yes yes, I am talking about having to assign the accounts during the import 
process in the matching window. I understand that that is the point in the 
workflow where you have to do this. That's how I've been doing it -- over and 
over.

---
David Mintz
https://davidmintz.org
Capitalism has failed. https://wsws.org

On Thu, Nov 4, 2021, at 8:24 PM, Jean Laroche wrote:
> Make sure you do the assignment during the matching, in the matching 
> window. Not after matching is all done in the registry (in which case GC 
> does not learn anything).
>
> Jean
>
> On 11/4/21 5:13 PM, David Mintz wrote:
>> Hello,
>>
>> I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I import a 
>> QFX, nearly all the transactions are assigned to "Imbalanced" even though I 
>> have gone through multiple iterations of trying to teach GC to recognize 
>> transactions by assigning the accounts manually. I have seen earlier 
>> postings about this, but the most detailed discussions were serveral years 
>> ago, and the most recent says, in substance, "just keep trying". I hesitate 
>> to do that because I fear it's a fool's errand. How many times do I need to 
>> tell it "Stop & Shop" belongs to Expenses:groceries?
>>
>> One strange detail:  I tend to neglect my financial record-keeping for 
>> months at a time, but as I recall, I was not having this problem a few 
>> months ago. It seems to be a case of *it used to work but now it doesn't.*
>>
>> I've read that it may be that it thinks "Imbalanced" is the answer, and 
>> cannot unlearn. Is there a any way to wipe the slate clean, so to speak, and 
>> force GC to start over so?
>>
>> I've also seen that people have written Perl scripts to run against their 
>> data files and yeah, I could try that -- but I'd much prefer to get GnuCash 
>> to work properly without having to intervene this way.
>>
>> Any suggestions?
>>
>> Gratefully,
>>
>> David
>>
>>
>> ---
>> David Mintz
>> https://davidmintz.org
>> Capitalism has failed. https://wsws.org
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] General Ledger amounts missing

[Adrian Yong]

Hi All,

I have raised this detail before...

It was explained to me that the normal General Ledger which classified
Assets, Liabilities, and Proprietorship with their total amounts so that
the auditor can be sure that A = L + P is observed but GNUCash works on a
double entry system so A = L + P will always be observed. However,
sometimes an entry may be a negative Asset instead of being a positive
Liability and this is not so easily picked up without a normal General
Ledger...

I have downloaded the General Ledger or Transaction Report and created my
normal GL using Excel.

Regards,
Adrian

On Fri, Nov 5, 2021 at 10:23 AM Gyle McCollam  wrote:

> Sharon, not sure, but the simple answer seems to be that under "edit
> report options" you didn't change the start and end dates.  The reports
> default to the current accounting period and you need the start and end of
> the year.  Hope this helps.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of sydnorbill...@bellsouth.net 
> Sent: Thursday, November 4, 2021 7:05 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] General Ledger amounts missing
>
> Relative newbie, even though using gnucash for four years, but only use it
> once a year to prepare for tax filing and by the next time filing comes
> around the following year I forget a lot of how it worked.
>
>
>
> In trying to print out a General Ledger report, after selecting reports and
> General Ledger under Assets & Liabilities, then going to options and
> selecting the obvious under GENERAL, then DISPLAY, and ACCOUNTS when I
> click
> OK, the report that comes up has NO AMOUNTS on it?
>
>
>
> What simple item am I missing?
>
>
>
> Sharon
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] My MacOS Finance::Quote Successful Tweaks

[Ken Farley]

Not a question, just my notes on how I got Finance::Quote to work on a 
new Mac Mini M1.


Operating system is OS X 11.6 (Big Sur)

GnuCash Version is 4.8 (from the -2.dmg)

My initial install left me unable to download quotes (via 
Finance::Quote). Research online eventually led to a Reddit discussion 
about similar problems. Apparently the root cause of the trouble was 
that module Mozilla::CA provides certificates for inquiries, but was not 
installed with the  default Perl. Sequence of installs necessary for 
success was:


sudo cpan -i B::Keywords
sudo cpan -i Test2
sudo cpan -i DateTime
sudo cpan -i DateTime::Locale
sudo cpan -i DateTime::Format::Strptime
sudo cpan -i Mozilla::CA

Once those are all done then go to:

/Applications/Gnucash/Contents/Resources/bin

and run the Finance::Quote fixing script:

sudo ./gnc-fq-update

After all the above, all the wonderful quotes were downloaded 
beautifully. Now, if I could only get the courage to "upgrade" to 
Monterey...


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

Re: [GNC] QFX import: transaction matching NOT learning to match

[Kalpesh Patel]

David –

 

I think you are looking for the matcher window where you can see this and
modify/delete them according to your need as I needed to undo erroneously
accepted matching transactions in the past. I don’t have the older 3.8
version running but I find that in 4.8 under “Tools” à “Import Map Editor”.
Make sure you set the selection to “Bayesian” at the top of the new opened
window of Import Map Editor. See if you find it in the same menu selection
under 3.8. You  can then click on Arrow on the left side of the each entry
to expand and see details on how it matches and to which account.
Alternatively use the Filter window at the bottom to limit matches that you
can view or Expand/Collapse All to do what they say.

 

Since you are running older version of it, recommendation is to upgrade to
newer 4.x version with 4.8 being the latest. I believe lots of improvements
have been made in the import process in 4.x series from what I remember.

 

Hope this helps.

 

 

--

 

Message: 9

Date: Thu, 04 Nov 2021 20:13:54 -0400

From: "David Mintz" 

To: gnucash-user@gnucash.org

Subject: [GNC] QFX import: transaction matching NOT learning to match

Message-ID: 

Content-Type: text/plain

 

Hello,

 

I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I import a
QFX, nearly all the transactions are assigned to "Imbalanced" even though I
have gone through multiple iterations of trying to teach GC to recognize
transactions by assigning the accounts manually. I have seen earlier
postings about this, but the most detailed discussions were serveral years
ago, and the most recent says, in substance, "just keep trying". I hesitate
to do that because I fear it's a fool's errand. How many times do I need to
tell it "Stop & Shop" belongs to Expenses:groceries?

 

One strange detail:  I tend to neglect my financial record-keeping for
months at a time, but as I recall, I was not having this problem a few
months ago. It seems to be a case of *it used to work but now it doesn't.*

 

I've read that it may be that it thinks "Imbalanced" is the answer, and
cannot unlearn. Is there a any way to wipe the slate clean, so to speak, and
force GC to start over so?

 

I've also seen that people have written Perl scripts to run against their
data files and yeah, I could try that -- but I'd much prefer to get GnuCash
to work properly without having to intervene this way.

 

Any suggestions?

 

Gratefully,

 

David

 

 

---

David Mintz

https://davidmintz.org

Capitalism has failed. https://wsws.org

 

--

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

Re: [GNC] QFX import: transaction matching NOT learning to match

[davidcousens49]

David

That should not be a problem at all. I used 3.7 and 3.8 before up grading to 4.8
and imported OFX files regularly without any problem and have recently been
importing them in 4.8 without any problems. Usually as long as the second
transfer account has been specified for all the transactions before the Import
button is pressed then the data for the import matching algorithm is stored
during the import process.  If that does not complete then the imbalance account
will normally only be applied if no transfer account was specified when it was
imported. If you don't complete the import process however the data isn't
recorded.

You can use the Tools->Import Map Editor to edit the stored data (Bayesian) and
look to see if an Imbalance account has actually been mapped at some stage but
AFAIK the matcher shouldn't store a mapping to an imbalance account in the
database. If you do find any data mapping to an Imbalance account in the "Mapped
to Account Name" column you can delete it in the editor by selecting the line
and pressing the "Delete" button at the bottom right of the window. Using the
Filter set to "Imbalance" should locate any such records. You can then multiply
select them and delete all of them.

David Cousens


On Thu, 2021-11-04 at 21:02 -0400, David Mintz wrote:
> Yes yes, I am talking about having to assign the accounts during the import
> process in the matching window. I understand that that is the point in the
> workflow where you have to do this. That's how I've been doing it -- over and
> over.
> 
> ---
> David Mintz
> https://davidmintz.org
> Capitalism has failed. https://wsws.org
> 
> On Thu, Nov 4, 2021, at 8:24 PM, Jean Laroche wrote:
> > Make sure you do the assignment during the matching, in the matching 
> > window. Not after matching is all done in the registry (in which case GC 
> > does not learn anything).
> > 
> > Jean
> > 
> > On 11/4/21 5:13 PM, David Mintz wrote:
> > > Hello,
> > > 
> > > I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I import a
> > > QFX, nearly all the transactions are assigned to "Imbalanced" even though
> > > I have gone through multiple iterations of trying to teach GC to recognize
> > > transactions by assigning the accounts manually. I have seen earlier
> > > postings about this, but the most detailed discussions were serveral years
> > > ago, and the most recent says, in substance, "just keep trying". I
> > > hesitate to do that because I fear it's a fool's errand. How many times do
> > > I need to tell it "Stop & Shop" belongs to Expenses:groceries?
> > > 
> > > One strange detail:  I tend to neglect my financial record-keeping for
> > > months at a time, but as I recall, I was not having this problem a few
> > > months ago. It seems to be a case of *it used to work but now it doesn't.*
> > > 
> > > I've read that it may be that it thinks "Imbalanced" is the answer, and
> > > cannot unlearn. Is there a any way to wipe the slate clean, so to speak,
> > > and force GC to start over so?
> > > 
> > > I've also seen that people have written Perl scripts to run against their
> > > data files and yeah, I could try that -- but I'd much prefer to get
> > > GnuCash to work properly without having to intervene this way.
> > > 
> > > Any suggestions?
> > > 
> > > Gratefully,
> > > 
> > > David
> > > 
> > > 
> > > ---
> > > David Mintz
> > > https://davidmintz.org
> > > Capitalism has failed. https://wsws.org
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see 
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription pr

Re: [GNC] My MacOS Finance::Quote Successful Tweaks

[David H]

Ken,

Thanks for that, I haven't had FQ running on Big Sur since I upgraded to it
during the beta's :-)  Will try that on my iMac running Big Sur in a
moment.  It came good on my MacBook Pro after upgrading to Monterey and
running gnc-fq-update I think it was but I still haven't got it running on
BS.  The modules you listed are all ones that FQ Update had issues with
when I tried to update on BS so here goes :-)

Cheers David H.


On Fri, 5 Nov 2021 at 12:58, Ken Farley  wrote:

> Not a question, just my notes on how I got Finance::Quote to work on a
> new Mac Mini M1.
>
> Operating system is OS X 11.6 (Big Sur)
>
> GnuCash Version is 4.8 (from the -2.dmg)
>
> My initial install left me unable to download quotes (via
> Finance::Quote). Research online eventually led to a Reddit discussion
> about similar problems. Apparently the root cause of the trouble was
> that module Mozilla::CA provides certificates for inquiries, but was not
> installed with the  default Perl. Sequence of installs necessary for
> success was:
>
> sudo cpan -i B::Keywords
> sudo cpan -i Test2
> sudo cpan -i DateTime
> sudo cpan -i DateTime::Locale
> sudo cpan -i DateTime::Format::Strptime
> sudo cpan -i Mozilla::CA
>
> Once those are all done then go to:
>
> /Applications/Gnucash/Contents/Resources/bin
>
> and run the Finance::Quote fixing script:
>
> sudo ./gnc-fq-update
>
> After all the above, all the wonderful quotes were downloaded
> beautifully. Now, if I could only get the courage to "upgrade" to
> Monterey...
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.