Re: [GNC] moving multiple transactions

2018-09-30 Thread Jeff Abrahamson
On 01/10/18 02:22, David Cousens wrote:
> Jeff,
>
> That is not currently available but I recently made changes in the importer
> matching which allowed multiple selection of transactions and assignment in
> that case of a destination account. That is not in the current and the newly
> released version 
>  as yet. It may be possible to  similarly process multiple transactions  to
> the account registers as well. The use case that I think can be addressed is
> where in an account register there are a number of transactions where the
> split of the transaction to that register needs to be changed to another
> account. It could work with a CTRL-click to select multiple transactions,
> followed by a right click to bring up the popup menu and adding an option to
> move the selected transactions to another account and a select account
> dialog followed to select an accont to transfer the splits to. 

Cool about the importer changes, I look forward to seeing them when the
code makes its way to my gnucash stability zone.

And good suggestions, thanks.

In the end, the suggestion to search in order to get a register window
with just those transactions, then to refine the search to the
(initially) same set by specifying the incorrect account allowed very
efficient copying and pasting.  So the initial need is past.

> The question has been asked before but that does not necessarily initiate
> any changes in the program. What is needed is a feature request Bug report
> at bugs.gnucash.org. If you raise a Bug request and describe how you would
> like it to work it will  then at least be assigned a priority in the list of
> fixes.

Point well taken.  I'll have a think and file a bug.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.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
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] V3.3 and Security Prices

2018-09-30 Thread John Ralls



> On Sep 30, 2018, at 7:33 PM, Fross, Michael  wrote:
> 
> Hello everyone,
> 
> Just installed v3.3 and I'm still seeing the fractional display in the
> price column of security accounts.  I'm not sure if it's just me.  I'm
> happy to test anything out and help in any way I can.
> 
> All of my security accounts show the same behavior and I've confirmed I'm
> running v3.3.
> 
> Here is a screen shot:
> 
> 
> 
> 
> Congrats on the release.  I've really fallen in love with GNUCash over the
> last few years.

Is Preferences>General Force Prices to display as decimals checked?

I intended to make it default to checked but it seems not to be.

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
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] [GNC-dev] GnuCash 3.3 Released

2018-09-30 Thread John Ralls
That’s the result of https://bugzilla.gnome.org/show_bug.cgi?id=787867 
 and some related bugs and 
changes. After much thrashing about Behdad discovered that even though Apple 
says that resolution is in points, they actually mean CSS points (96/inch) 
instead of printer’s points (72/inch).

Regards,
John Ralls


> On Sep 30, 2018, at 4:33 PM, chris graves  wrote:
> 
> Damn, you guys have been busy, thanks for all the hard work!
> 
> One thing that popped out right away was that the font size for most aspects 
> of the program has increased by 6 or so points (this is on MacOS).  Actually 
> it was quite pleasing to my old eyes, but unexpected.
> 
>> On Sep 30, 2018, at 1:42 PM, John Ralls  wrote:
>> 
>> The GnuCash development team announces GnuCash 3.3, the fourth release of 
>> the 3.x stable release series.
>> 
>> Changes
>> 
>> Between 3.2 and 3.3, the following bugfixes were accomplished:
>> 
>>  • Bug 771667 - Different warnings when changing reconciled splits vs. 
>> splits linked to reconciled splits.
>>  • Bug 784420 - "Save changes on closing" window waits 2^32 seconds when 
>> "Time to wait for answer" is set 0.
>>  • Bug 786708 - GnuCash won't load currency fractions larger than 
>> 100. Also create larger fractions for the account dialog.
>>  • Bug 787439 - Segmentation Fault in Transfer dialog after clearing 
>> Date field and pressing escape.
>>  • Bug 789594 - Unable to overwrite sqlite3 database file.
>>  • Bug 792446 - Mixed languages in error dialog.
>>  • Bug 794526 - Python bindings can't find loadable modules.
>>  • Bug 794755 - Commodity Register displays fractional prices.
>> Prices will now be displayed in decimal, rounded to two more places than the 
>> currency's smallest unit.
>> 
>>  • Bug 794870 - If no book is opened, gnucash still asks if the user 
>> wants to save changes when opening a file.
>>  • Bug 795821 - GnuCash could not obtain the lock for 
>> file://C:\Users\username\Documents\GnuCash\2.6.21\\.gnucash
>>  • Bug 796054 - Unposting and reposting invoice doubles amounts.
>>  • Bug 796137 - query.search_for outputs critical qof.object errors and 
>> prevents queries being run.
>>  • Bug 796248 - Editing Scheduled Transaction.
>> In addition to not begining to edit already-loaded transactions, don't try 
>> to load splits that are already loaded. It shouldn't be possible to load a 
>> transaction without also loading its splits.
>> 
>>  • Bug 796474 - Segmentation fault while setting up online banking.
>> Allow only a single instance of the assistant.
>> 
>>  • Bug 796509 - Saved reports don't respect *some* 'Edit report options'.
>>  • Bug 796579 - Cannot go forward with empty duplicates screen.
>>  • Bug 796665 - Backspace Key Inoperable After Ctrl+V.
>>  • Bug 796669 - Dark Theme Text Colors Hard to Read.
>> Only add the register-foreground class when using Gnucash built in colours. 
>> When this setting not used, the foreground colour by default will be what 
>> ever the theme has set and will be down to the user to over ride along with 
>> the other register colours.
>> 
>>  • Bug 796724 - Can't overwrite gnucash DB on MariaDB.
>>  • Bug 796725 - 4 of 6 Date Posted options fail to return matching 
>> transactions.
>>  • Bug 796734 - Auto-complete entry not highlighting to allow for 
>> incremental entry.
>>  • Bug 796737 - Patch to restore gncmod-python.c.
>>  • Bug 796739 - Toolbar buttons have no labels.
>>  • Bug 796751 - reconcile window usability - R column should be next to 
>> Amount.
>>  • Bug 796755 - buggy window handling at startup.
>>  • Bug 796756 - OFX import fails to recognize associated income accounts.
>>  • Bug 796759 - --add-price-quotes leaves a lock on the file.
>>  • Bug 796762 - Scrollbar partially hides the delete button in the Saved 
>> Report Configurations window.
>> The vertical scrollbar obscures the delete button in the tree view so add a 
>> dummy blank column to the end and set it to the width of the vertical 
>> scrollbar.
>> 
>>  • Bug 796766 - Credit note creating 'imbalance' with wrong entries.
>>  • Bug 796777 - CVE-2008-1391: Integer overflow in included strfmon 
>> function.
>>  • Bug 796788 - Strange behaviour in options of multicolumn report.
>>  • Bug 796792 - SaveAs Overwrite dialogue in background and not visible.
>>  • Bug 796812 - gnc_date_cell_get_date and gnc_date_cell_get_date_gdate 
>> have different date validation behaviour.
>>  • Bug 796813 - Date validation inconsistent.
>>  • Bug 796814 - Changing a book's read-only threshold doesn't 
>> immediately affect open registers.
>>  • Bug 796816 - Notes field in Duplicate Invoice dialogue is 'read-only'.
>>  • Bug 796819 - Bad icon with Spanish localization.
>> Drop translations of the 'gnucash-icon' string from our po files and add a 
>> note for 

[GNC] V3.3 and Security Prices

2018-09-30 Thread Fross, Michael
Hello everyone,

Just installed v3.3 and I'm still seeing the fractional display in the
price column of security accounts.  I'm not sure if it's just me.  I'm
happy to test anything out and help in any way I can.

All of my security accounts show the same behavior and I've confirmed I'm
running v3.3.

Here is a screen shot:




Congrats on the release.  I've really fallen in love with GNUCash over the
last few years.


Michael
___
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] moving multiple transactions

2018-09-30 Thread David Cousens
Jeff,

That is not currently available but I recently made changes in the importer
matching which allowed multiple selection of transactions and assignment in
that case of a destination account. That is not in the current and the newly
released version 
 as yet. It may be possible to  similarly process multiple transactions  to
the account registers as well. The use case that I think can be addressed is
where in an account register there are a number of transactions where the
split of the transaction to that register needs to be changed to another
account. It could work with a CTRL-click to select multiple transactions,
followed by a right click to bring up the popup menu and adding an option to
move the selected transactions to another account and a select account
dialog followed to select an accont to transfer the splits to. 

The question has been asked before but that does not necessarily initiate
any changes in the program. What is needed is a feature request Bug report
at bugs.gnucash.org. If you raise a Bug request and describe how you would
like it to work it will  then at least be assigned a priority in the list of
fixes.

David Cousens.



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] can Gnucash provide a list of unreconciled cheques?

2018-09-30 Thread Liz
On Sun, 30 Sep 2018 11:53:02 -0600
Ronal B Morse  wrote:

> On Sun, 2018-09-30 at 12:42 -0500, Barnabooth wrote:
> > There are times (particularly near year's-end) when a
> > simple list of the
> > unreconciled  (i.e. uncashed) cheques would be very
> > convenient.
> > I seem to see nothing in either the reports or the
> > reconciliation window
> > that would do.
> > 
> > Is there a way?
> > 
> > Thanks
> > 
> >   
> With the register in question open, try: 
> 
> View > Filter By >  Status  
> 
> Then select that which you want to see/not see from the
> choices available
> 
> RBM
> 
>
Then make a transaction report and you have a printable list

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.


[GNC] Fwd: Question about a scheduled transaction

2018-09-30 Thread Charter
Hello,
Sorry please disregard the previous question, I figured it out. I had another 
currency type for the account I was trying to use.

Thanks,
Russ

> Begin forwarded message:
> 
> From: Charter 
> Subject: Question about a scheduled transaction
> Date: September 30, 2018 at 2:28:30 AM EDT
> To: gnucash-user@gnucash.org
> 
> Hello,
> I am setting up scheduled transactions and one of the transaction I setup I 
> get a message that I can not set it up to automatically.  The message reads 
> "Scheduled Transactions with variables or involving more than one commodity 
> cannot be automatically created".  The transaction is setup just like the 
> others, but I am not sure what the message means.  
> 
> I am thinking that maybe I have something entered in the journal or 
> something.  This is my first time using double entry method so it is probably 
> something I am doing  wrong.  
> 
> I did find a entry in the General Ledger with the same name but with a 
> different date but I removed it and I still get the message. 
> 
> I would appreciate any advice you can give me on this.
> 
> Thank you
> Russ

___
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] Question about a scheduled transaction

2018-09-30 Thread Charter
Hello,
I am setting up scheduled transactions and one of the transaction I setup I get 
a message that I can not set it up to automatically.  The message reads 
"Scheduled Transactions with variables or involving more than one commodity 
cannot be automatically created".  The transaction is setup just like the 
others, but I am not sure what the message means.  

I am thinking that maybe I have something entered in the journal or something.  
This is my first time using double entry method so it is probably something I 
am doing  wrong.  

I did find a entry in the General Ledger with the same name but with a 
different date but I removed it and I still get the message. 

 I would appreciate any advice you can give me on this.

Thank you
Russ
___
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] [GNC-dev] GnuCash 3.3 Released

2018-09-30 Thread John Ralls
The GnuCash development team announces GnuCash 3.3, the fourth release of the 
3.x stable release series.

Changes

Between 3.2 and 3.3, the following bugfixes were accomplished:

• Bug 771667 - Different warnings when changing reconciled splits vs. 
splits linked to reconciled splits.
• Bug 784420 - "Save changes on closing" window waits 2^32 seconds when 
"Time to wait for answer" is set 0.
• Bug 786708 - GnuCash won't load currency fractions larger than 
100. Also create larger fractions for the account dialog.
• Bug 787439 - Segmentation Fault in Transfer dialog after clearing 
Date field and pressing escape.
• Bug 789594 - Unable to overwrite sqlite3 database file.
• Bug 792446 - Mixed languages in error dialog.
• Bug 794526 - Python bindings can't find loadable modules.
• Bug 794755 - Commodity Register displays fractional prices.
Prices will now be displayed in decimal, rounded to two more places than the 
currency's smallest unit.

• Bug 794870 - If no book is opened, gnucash still asks if the user 
wants to save changes when opening a file.
• Bug 795821 - GnuCash could not obtain the lock for 
file://C:\Users\username\Documents\GnuCash\2.6.21\\.gnucash
• Bug 796054 - Unposting and reposting invoice doubles amounts.
• Bug 796137 - query.search_for outputs critical qof.object errors and 
prevents queries being run.
• Bug 796248 - Editing Scheduled Transaction.
In addition to not begining to edit already-loaded transactions, don't try to 
load splits that are already loaded. It shouldn't be possible to load a 
transaction without also loading its splits.

• Bug 796474 - Segmentation fault while setting up online banking.
Allow only a single instance of the assistant.

• Bug 796509 - Saved reports don't respect *some* 'Edit report options'.
• Bug 796579 - Cannot go forward with empty duplicates screen.
• Bug 796665 - Backspace Key Inoperable After Ctrl+V.
• Bug 796669 - Dark Theme Text Colors Hard to Read.
Only add the register-foreground class when using Gnucash built in colours. 
When this setting not used, the foreground colour by default will be what ever 
the theme has set and will be down to the user to over ride along with the 
other register colours.

• Bug 796724 - Can't overwrite gnucash DB on MariaDB.
• Bug 796725 - 4 of 6 Date Posted options fail to return matching 
transactions.
• Bug 796734 - Auto-complete entry not highlighting to allow for 
incremental entry.
• Bug 796737 - Patch to restore gncmod-python.c.
• Bug 796739 - Toolbar buttons have no labels.
• Bug 796751 - reconcile window usability - R column should be next to 
Amount.
• Bug 796755 - buggy window handling at startup.
• Bug 796756 - OFX import fails to recognize associated income accounts.
• Bug 796759 - --add-price-quotes leaves a lock on the file.
• Bug 796762 - Scrollbar partially hides the delete button in the Saved 
Report Configurations window.
The vertical scrollbar obscures the delete button in the tree view so add a 
dummy blank column to the end and set it to the width of the vertical scrollbar.

• Bug 796766 - Credit note creating 'imbalance' with wrong entries.
• Bug 796777 - CVE-2008-1391: Integer overflow in included strfmon 
function.
• Bug 796788 - Strange behaviour in options of multicolumn report.
• Bug 796792 - SaveAs Overwrite dialogue in background and not visible.
• Bug 796812 - gnc_date_cell_get_date and gnc_date_cell_get_date_gdate 
have different date validation behaviour.
• Bug 796813 - Date validation inconsistent.
• Bug 796814 - Changing a book's read-only threshold doesn't 
immediately affect open registers.
• Bug 796816 - Notes field in Duplicate Invoice dialogue is 'read-only'.
• Bug 796819 - Bad icon with Spanish localization.
Drop translations of the 'gnucash-icon' string from our po files and add a note 
for translators to not translate this string or use the literal 'gnucash-icon' 
as translation.

• Bug 796820 - References to 'Gnome Bugzilla' should be changed to 
'GnuCash Bugzilla'.
• Bug 796833 - Excel csv Format misprocessed.
Convert all line ending styles to the one expected by the C++ standard library 
before starting to parse a csv file.

• Bug 796839 - Find transaction won't filter on Date Posted.
• Bug 796858 - TypeError: in method 'qof_query_int32_predicate', 
argument 2 of type 'gint32' on gnucash.gnucash_core.QueryInt32Predicate.
The Following fixes and improvemts were not associated with bug reports:

• Set toolbar buttons to show both icon and text.
And make the icon small to recover some vertical screen estate. The motivation 
for this is that Gtk has dropped the ability for users to change a toolbar's 
appearance. And as our icons 

[GNC] [GNC-dev] GnuCash 3.2 Released

2018-09-30 Thread John Ralls
The GnuCash development team announces GnuCash 3.3, the fourth release of the 
3.x stable release series.

Changes

Between 3.2 and 3.3, the following bugfixes were accomplished:

• Bug 771667 - Different warnings when changing reconciled splits vs. 
splits linked to reconciled splits.
• Bug 784420 - "Save changes on closing" window waits 2^32 seconds when 
"Time to wait for answer" is set 0.
• Bug 786708 - GnuCash won't load currency fractions larger than 
100. Also create larger fractions for the account dialog.
• Bug 787439 - Segmentation Fault in Transfer dialog after clearing 
Date field and pressing escape.
• Bug 789594 - Unable to overwrite sqlite3 database file.
• Bug 792446 - Mixed languages in error dialog.
• Bug 794526 - Python bindings can't find loadable modules.
• Bug 794755 - Commodity Register displays fractional prices.
Prices will now be displayed in decimal, rounded to two more places than the 
currency's smallest unit.

• Bug 794870 - If no book is opened, gnucash still asks if the user 
wants to save changes when opening a file.
• Bug 795821 - GnuCash could not obtain the lock for 
file://C:\Users\username\Documents\GnuCash\2.6.21\\.gnucash
• Bug 796054 - Unposting and reposting invoice doubles amounts.
• Bug 796137 - query.search_for outputs critical qof.object errors and 
prevents queries being run.
• Bug 796248 - Editing Scheduled Transaction.
In addition to not begining to edit already-loaded transactions, don't try to 
load splits that are already loaded. It shouldn't be possible to load a 
transaction without also loading its splits.

• Bug 796474 - Segmentation fault while setting up online banking.
Allow only a single instance of the assistant.

• Bug 796509 - Saved reports don't respect *some* 'Edit report options'.
• Bug 796579 - Cannot go forward with empty duplicates screen.
• Bug 796665 - Backspace Key Inoperable After Ctrl+V.
• Bug 796669 - Dark Theme Text Colors Hard to Read.
Only add the register-foreground class when using Gnucash built in colours. 
When this setting not used, the foreground colour by default will be what ever 
the theme has set and will be down to the user to over ride along with the 
other register colours.

• Bug 796724 - Can't overwrite gnucash DB on MariaDB.
• Bug 796725 - 4 of 6 Date Posted options fail to return matching 
transactions.
• Bug 796734 - Auto-complete entry not highlighting to allow for 
incremental entry.
• Bug 796737 - Patch to restore gncmod-python.c.
• Bug 796739 - Toolbar buttons have no labels.
• Bug 796751 - reconcile window usability - R column should be next to 
Amount.
• Bug 796755 - buggy window handling at startup.
• Bug 796756 - OFX import fails to recognize associated income accounts.
• Bug 796759 - --add-price-quotes leaves a lock on the file.
• Bug 796762 - Scrollbar partially hides the delete button in the Saved 
Report Configurations window.
The vertical scrollbar obscures the delete button in the tree view so add a 
dummy blank column to the end and set it to the width of the vertical scrollbar.

• Bug 796766 - Credit note creating 'imbalance' with wrong entries.
• Bug 796777 - CVE-2008-1391: Integer overflow in included strfmon 
function.
• Bug 796788 - Strange behaviour in options of multicolumn report.
• Bug 796792 - SaveAs Overwrite dialogue in background and not visible.
• Bug 796812 - gnc_date_cell_get_date and gnc_date_cell_get_date_gdate 
have different date validation behaviour.
• Bug 796813 - Date validation inconsistent.
• Bug 796814 - Changing a book's read-only threshold doesn't 
immediately affect open registers.
• Bug 796816 - Notes field in Duplicate Invoice dialogue is 'read-only'.
• Bug 796819 - Bad icon with Spanish localization.
Drop translations of the 'gnucash-icon' string from our po files and add a note 
for translators to not translate this string or use the literal 'gnucash-icon' 
as translation.

• Bug 796820 - References to 'Gnome Bugzilla' should be changed to 
'GnuCash Bugzilla'.
• Bug 796833 - Excel csv Format misprocessed.
Convert all line ending styles to the one expected by the C++ standard library 
before starting to parse a csv file.

• Bug 796839 - Find transaction won't filter on Date Posted.
• Bug 796858 - TypeError: in method 'qof_query_int32_predicate', 
argument 2 of type 'gint32' on gnucash.gnucash_core.QueryInt32Predicate.
The Following fixes and improvemts were not associated with bug reports:

• Set toolbar buttons to show both icon and text.
And make the icon small to recover some vertical screen estate. The motivation 
for this is that Gtk has dropped the ability for users to change a toolbar's 
appearance. And as our icons 

Re: [GNC] can Gnucash provide a list of unreconciled cheques?

2018-09-30 Thread Paul Kinzelman

Couldn't you just start a reconciliation on that account even if you
don't have a statement? I'm kind of a novice with GC, but it seems
to me you could get a list that way.

On 9/30/2018 12:28 PM, John Ralls wrote:



On Sep 30, 2018, at 10:42 AM, Barnabooth  wrote:

There are times (particularly near year's-end) when a simple list of the
unreconciled  (i.e. uncashed) cheques would be very convenient.
I seem to see nothing in either the reports or the reconciliation window
that would do.

Is there a way?

Edit>Find or f to open the find dialog.
Search for
Number matches regex .+
Reconcile is not cleared

That assumes that you enter numbers when you write paper checks and only in 
that instance. If that's not the case you'll need to figure out some other way 
to separate checks from everything else.

Note that if you use find from the Accounts page you'll be searching all 
accounts; if you do so from a register page you'll be searching only the 
corresponding account.

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
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] can Gnucash provide a list of unreconciled cheques?

2018-09-30 Thread John Ralls



> On Sep 30, 2018, at 10:42 AM, Barnabooth  wrote:
> 
> There are times (particularly near year's-end) when a simple list of the
> unreconciled  (i.e. uncashed) cheques would be very convenient.
> I seem to see nothing in either the reports or the reconciliation window
> that would do.
> 
> Is there a way?

Edit>Find or f to open the find dialog.
Search for 
   Number matches regex .+ 
   Reconcile is not cleared

That assumes that you enter numbers when you write paper checks and only in 
that instance. If that's not the case you'll need to figure out some other way 
to separate checks from everything else.

Note that if you use find from the Accounts page you'll be searching all 
accounts; if you do so from a register page you'll be searching only the 
corresponding account.

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
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] can Gnucash provide a list of unreconciled cheques?

2018-09-30 Thread Ronal B Morse
On Sun, 2018-09-30 at 12:42 -0500, Barnabooth wrote:
> There are times (particularly near year's-end) when a
> simple list of the
> unreconciled  (i.e. uncashed) cheques would be very
> convenient.
> I seem to see nothing in either the reports or the
> reconciliation window
> that would do.
> 
> Is there a way?
> 
> Thanks
> 
> 
With the register in question open, try: 

View > Filter By >  Status  

Then select that which you want to see/not see from the
choices available

RBM


___
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] can Gnucash provide a list of unreconciled cheques?

2018-09-30 Thread Barnabooth
There are times (particularly near year's-end) when a simple list of the
unreconciled  (i.e. uncashed) cheques would be very convenient.
I seem to see nothing in either the reports or the reconciliation window
that would do.

Is there a way?

Thanks



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Repeatable Mac crash

2018-09-30 Thread John Ralls


> On Sep 30, 2018, at 10:14 AM, Stephen M. Butler  wrote:
> 
> On 09/30/2018 10:07 AM, Michael or Penny Novack wrote:
>> 
 On Sep 29, 2018, at 4:30 AM, Robert Kesterson 
 wrote:
>> 
 
 When I open Gnucash, it opens the last file I had open, which is
 great.  Then I start the second instance from a terminal with “open
 -n /Applications/GnuCash.app” and it starts up.  Since the most
 recent file is already open, it will complain that it can’t get the
 lock and ask what I want to do.  Since there isn’t an “open a
 different file” option ...
>> 
>> But there IS a way to open gnucash for another file. Or rather a way
>> to start gnucash without it opening a file, thus allowing you to
>> specify what file you want to open. The -nofile option << I don't know
>> exactly how to specify that for a mac >>
>> 
>> I am always opening gnucash that way since keeping four sets of books
>> and the last opened is usually not the one I want to open.
>> 
>> Michael
>> 
> 
> I found it easier to just navigate to the file with the file explorer
> (at least on Linux) and double click on the file.  GnuCash then launches
> and opens that file.

That doesn't work on Macs.

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
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] Repeatable Mac crash

2018-09-30 Thread Stephen M. Butler
On 09/30/2018 10:07 AM, Michael or Penny Novack wrote:
>
>>> On Sep 29, 2018, at 4:30 AM, Robert Kesterson 
>>> wrote:
>
>>>
>>> When I open Gnucash, it opens the last file I had open, which is
>>> great.  Then I start the second instance from a terminal with “open
>>> -n /Applications/GnuCash.app” and it starts up.  Since the most
>>> recent file is already open, it will complain that it can’t get the
>>> lock and ask what I want to do.  Since there isn’t an “open a
>>> different file” option ...
>
> But there IS a way to open gnucash for another file. Or rather a way
> to start gnucash without it opening a file, thus allowing you to
> specify what file you want to open. The -nofile option << I don't know
> exactly how to specify that for a mac >>
>
> I am always opening gnucash that way since keeping four sets of books
> and the last opened is usually not the one I want to open.
>
> Michael
>

I found it easier to just navigate to the file with the file explorer
(at least on Linux) and double click on the file.  GnuCash then launches
and opens that file.
> ___
> 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.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Repeatable Mac crash

2018-09-30 Thread Michael or Penny Novack



On Sep 29, 2018, at 4:30 AM, Robert Kesterson  wrote:




When I open Gnucash, it opens the last file I had open, which is great.  Then I 
start the second instance from a terminal with “open -n 
/Applications/GnuCash.app” and it starts up.  Since the most recent file is 
already open, it will complain that it can’t get the lock and ask what I want 
to do.  Since there isn’t an “open a different file” option ...


But there IS a way to open gnucash for another file. Or rather a way to 
start gnucash without it opening a file, thus allowing you to specify 
what file you want to open. The -nofile option << I don't know exactly 
how to specify that for a mac >>


I am always opening gnucash that way since keeping four sets of books 
and the last opened is usually not the one I want to open.


Michael

___
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] compiling 3.2 on linux (ubuntu)

2018-09-30 Thread Stephen M. Butler
On 09/29/2018 10:52 PM, Jeff Abrahamson wrote:
> I downloaded 3.2.tar.bz.  After unbzipping, I do this (ubuntu 18.04.1):
>
> $ mkdir -p gnucash-3.2/build-3.2
> $ cd gnucash-3.2/build-3.2
> $ cmake ../gnucash/
> CMake Error at CMakeLists.txt:5 (file):
>   file problem creating directory: /glib-2.0/schemas
>
>
> -- Performing Test have_mod_mask
> -- Performing Test have_mod_mask - Failed
> CMake Error at gnome/CMakeLists.txt:59 (gnc_add_swig_guile_command):
>   Unknown CMake command "gnc_add_swig_guile_command".
>
>
> CMake Warning (dev) in CMakeLists.txt:
>   No cmake_minimum_required command is present.  A line of code such as
>
>     cmake_minimum_required(VERSION 3.10)
>
>   should be added at the top of the file.  The version specified may
> be lower
>   if you wish to support older CMake versions for this project.  For
> more
>   information run "cmake --help-policy CMP".
> This warning is for project developers.  Use -Wno-dev to suppress it.
>
> -- Configuring incomplete, errors occurred!
> See also
> "/home/jeff/.../gnucash/gnucash-3.2/build-3.2/CMakeFiles/CMakeOutput.log".
> See also
> "/home/jeff/.../gnucash/gnucash-3.2/build-3.2/CMakeFiles/CMakeError.log".
> $
>
> CMakeError.log suggests the real problem is not finding gdk/gdk.h.  This
> is provided from two packages, libgtk-3-dev and libgtk2.0-dev.  But
> installing those doesn't change the error.  (I manually confirm gdk.h is
> present: /usr/include/gtk-2.0/gdk/gdk.h.)
>
> Thinking this was a caching problem, I removed and recreated
> ./build-3.2/.  Same problem.
>
> Any pointers?
>
I also compile on Ubuntu 18.04.  However, I make my build folder at the
same level as the gnucash source.  I think your cmake is setup assuming
you would go up a level and over and back down to gnucash.  However, you
are not setup that way.

Either do cmake ..

or move your build folder up to the same level as the source.  On my
system I have a main Projects folder (several different projects of
which GnuCash is just one more):


$HOME/Projects/GnuCash/gnucash-3.2

$HOME/Projects/GnuCash/GNC-Build-3.2

cd $HOME/Projects/GnuCash/GNC-Build-3.2

cmake ../gnucash-3.2


Best

--Steve

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] moving multiple transactions

2018-09-30 Thread John Ralls



> On Sep 30, 2018, at 8:32 AM, Jeff Abrahamson  wrote:
> 
> While doing end of year validation, I've found a hundred or so
> transactions that were inadvertently entered against the wrong account.
> 
> I see from googling that this is asked frequently and, in the past,
> hasn't been possible.
> 
>In 2012
>
> http://gnucash.1415818.n4.nabble.com/changing-a-large-number-of-transactions-in-a-batch-impossible-td4656242.html
> 
>In 2014
>https://lists.gnucash.org/pipermail/gnucash-user/2014-February/052770.html
> 
>In 2017
>http://gnucash.1415818.n4.nabble.com/bulk-transaction-update-td4688921.html
> 
> It seemed worth checking if any newer solutions have arisen.  But maybe
> I'll go brew a cup of tea and get on with it. ;-)

Still nothing like that available in the GUI. You'll find it easiest if you can 
create a find query that gets them all into a journal register.

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
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] moving multiple transactions

2018-09-30 Thread Jeff Abrahamson
While doing end of year validation, I've found a hundred or so
transactions that were inadvertently entered against the wrong account.

I see from googling that this is asked frequently and, in the past,
hasn't been possible.

In 2012

http://gnucash.1415818.n4.nabble.com/changing-a-large-number-of-transactions-in-a-batch-impossible-td4656242.html

In 2014
https://lists.gnucash.org/pipermail/gnucash-user/2014-February/052770.html

In 2017
http://gnucash.1415818.n4.nabble.com/bulk-transaction-update-td4688921.html

It seemed worth checking if any newer solutions have arisen.  But maybe
I'll go brew a cup of tea and get on with it. ;-)

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.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
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] compiling 3.2 on linux (ubuntu)

2018-09-30 Thread John Ralls



> On Sep 29, 2018, at 10:52 PM, Jeff Abrahamson  wrote:
> 
> I downloaded 3.2.tar.bz.  After unbzipping, I do this (ubuntu 18.04.1):
> 
>$ mkdir -p gnucash-3.2/build-3.2
>$ cd gnucash-3.2/build-3.2
>$ cmake ../gnucash/
>CMake Error at CMakeLists.txt:5 (file):
>  file problem creating directory: /glib-2.0/schemas
> 
> 
>-- Performing Test have_mod_mask
>-- Performing Test have_mod_mask - Failed
>CMake Error at gnome/CMakeLists.txt:59 (gnc_add_swig_guile_command):
>  Unknown CMake command "gnc_add_swig_guile_command".
> 
> 
>CMake Warning (dev) in CMakeLists.txt:
>  No cmake_minimum_required command is present.  A line of code such as
> 
>cmake_minimum_required(VERSION 3.10)
> 
>  should be added at the top of the file.  The version specified may
>be lower
>  if you wish to support older CMake versions for this project.  For
>more
>  information run "cmake --help-policy CMP".
>This warning is for project developers.  Use -Wno-dev to suppress it.
> 
>-- Configuring incomplete, errors occurred!
>See also
>"/home/jeff/.../gnucash/gnucash-3.2/build-3.2/CMakeFiles/CMakeOutput.log".
>See also
>"/home/jeff/.../gnucash/gnucash-3.2/build-3.2/CMakeFiles/CMakeError.log".
>$
> 
> CMakeError.log suggests the real problem is not finding gdk/gdk.h.  This
> is provided from two packages, libgtk-3-dev and libgtk2.0-dev.  But
> installing those doesn't change the error.  (I manually confirm gdk.h is
> present: /usr/include/gtk-2.0/gdk/gdk.h.)
> 
> Thinking this was a caching problem, I removed and recreated
> ./build-3.2/.  Same problem.
> 
> Any pointers?

cmake ..
*not* cmake ../gnucash

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
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] Repeatable Mac crash

2018-09-30 Thread John Ralls


> On Sep 29, 2018, at 4:30 AM, Robert Kesterson  wrote:
> 
> I’ve been using GnuCash forever, running the 2.x series up until a couple of 
> months ago on Mac High Sierra.  I routinely have two instances of Gnucash 
> running — one personal and one business.  A couple of months ago I updated to 
> GnuCash 3.2.  Since then I have a 100% repeatable crash scenario that I 
> wonder if anyone knows how to solve.
> 
> When I open Gnucash, it opens the last file I had open, which is great.  Then 
> I start the second instance from a terminal with “open -n 
> /Applications/GnuCash.app” and it starts up.  Since the most recent file is 
> already open, it will complain that it can’t get the lock and ask what I want 
> to do.  Since there isn’t an “open a different file” option, I hit the button 
> to create a new file.  Gnucash opens.  Then I pull down the recent files menu 
> and select my other file (for example, if personal is open, I select the 
> business file).  Gnucash will ask if I want to save the empty set of accounts 
> it created a moment ago.  I say no, and it reads my second file.
> 
> The moment the second file finishes reading (the progress bar moves all the 
> way across), Gnucash crashes.  This is 100% repeatable — happens this way 
> every single time, no matter which file I have open first or second.
> 
> I can then run the second instance again, and the other file will have now 
> moved to the position of most recent file opened, and it will open 
> automatically.  It will complain that it is locked (since it crashed without 
> removing it), and I tell it to ignore it and it will run fine.
> 
> Again, this is 100% repeatable.  If there is a known fix, I’d love to hear 
> it.  If not, what can I do to help track this down so it can get fixed?

Please open a bug report and attach (don’t paste it into a comment!) the crash 
report you’ll find by opening Applications:Utilities:Console and selecting User 
Reports on the sidebar. You can control-click on a report and select “show in 
finder” to get its location.

Since you’re running two instances of GnuCash it’s likely that the trace file 
will be garbled, so if you could use the following from the command line 
instead:
  /Applications/Gnucash.app/Contents/MacOS/Gnucash --logto=~/gnucash.trace
That will create a separate trace file in your user directory that you can also 
attach to the bug report. You could even add the file path for the file you 
really want to open to the end of that and save yourself the “can’t get the 
lock” drill.

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
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] Mojave compatibility

2018-09-30 Thread John Ralls
But see https://bugs.gnucash.org/show_bug.cgi?id=796867 
. There’s apparently a problem 
with Dark Mode on some computers. I haven’t yet been able to reproduce it.

Regards,
John Ralls


> On Sep 29, 2018, at 9:37 PM, David Reiser via gnucash-user 
>  wrote:
> 
> Works for me.
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Sep 29, 2018, at 10:40 AM, Bob Wall  wrote:
>> 
>> Is Gnucash 3.2 compatible with macOS Mojave?
>> 
> 
> ___
> 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] QIF import is empty

2018-09-30 Thread Jeff Abrahamson
It looks like my QIF was slightly invalid.  Playing about with the
gnucash android app and asking it to send me a qif transaction, I came
up with this, which works:

!Account
N5_COMPTES FINANCIERS:51_BANQUES, ETABLISSEMENTS FINANCIERS ET
ASSIMILES:512_Banques:5121_Comptes en monnaie
nationale:51215_Comptes online:512151_Helloasso
^
!Type:Bank
NHA-20180930-123
D2018/9/30
PSomething yummy
MThis is a note
S6_CHARGES:62_AUTRES SERVICES EXTERIEURS:625_Déplacements, missions
et réceptions:6251_Voyages et déplacements:62511_Voyages,
Déplacements sportifs, Stages du club)
$-6001.00
^

Notably, I needed to use full hierarchical names and add an N field to
the !account section (rather than !Account:).  Or at
least, this worked, I'm not fully certain my explanation is correct.

Jeff Abrahamson


On 29/09/18 16:03, Jeff Abrahamson wrote:
> I've written a short python script that writes a qif file.  I'm using
> gnucash 2.6.19 from ubuntu 18.04.1.  I want to import the qif file.
>
> !Type:Bank
> !Account:512151_Helloasso
> D05/10/2017
> T60.0
> NHA-20171005-30
> PDescription here
> S7061_Participation rameurs aux déplacements et stages
> $60.0
> EPAF (some...@somewhere.fr)
>
> ^
> D05/10/2017
> T40.0
> NHA-20171005-29
> PCDescription here
> S7061_Participation rameurs aux déplacements et stages
> $40.0
> EPAF (someone_else@somewhere_else.com)
>
> ^
>
> I found that I needed to rename the output file to be the name of the
> account to which I'm importing it, despite the second line (the account
> name) and despite having that account window open, otherwise I got this
> error:
>
> /The QIF file you have loaded appears to have transactions for just //one 
> account, but the file does not specify a name for that account /
>
> Strange, but fine.  Now, though, when the qif importer gets to the
> "accounts found" dialog, it doesn't show any accounts and no
> transactions are imported.
>
> In my particular case here, the transactions are very homogeneous: all
> of them credit 7061 and all of them debit 512151.
>
> Any suggestions why I'm seeing neither an error nor importing transactions?
>
> Thanks in advance.
>

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.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
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.