Re: [GNC] Transcation Search & Replace

2020-07-03 Thread Kevin Buckley
On Fri, 3 Jul 2020 at 04:00, listsub3  wrote:
>
> Typically bulk search replace changes would be for things like
> transaction category/account, changes in names in description/notes. etc.
>
> My GC data folder is currently 46mb (I have quite a lot of histrorical
> stuff).
>
> Seems like quite a functional omission in GC to me - it must be quite a
> common user task - I don't have an old Quicken on this machine but I
> know it used to be a breeze with that.
>
> Searching this list I found an an old response to the same question
> which indicated that this functionality would only be considered once GC
> had moved to a databese strcuture?

Not clear that one needs a database to do much of what you've listed
above, although an SQL syntax might offer extra capability, as regards
say, more easily narrowing the change down to a specific set of transactions.

If you have the XML file, then altering a common description string across
multiple transactions in the file, is a simple text-editing, find-and-replace
operation.

These two pseudy-coded examples are equivalent
(Note: not the actual Table names nor XML schema tags)

UPDATE TXN t SET t.description = 'corrected string' WHERE
t.description = 'erronenous string' ;

sed -ie 's/txn:description>erronenous
stringcorrected stringhttps://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] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread Chris Good
Has anyone figured out how to make the new paper clip and link glyphs look
better in Windows 10?

In Linux Ubuntu 18.04 they look great but in Windows 10 they look pretty
bad, especially the paper clip.

Please see attached.

 

C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains :

* {

   font: 16px arial, sans-serif;

}

 

Changing the font from 'arial' *does* effect most characters but not the
PaperClip or Link glyphs.

 

Here's the definition of the glyphs from
src/gnucash/register/register-core/assoccell.h

  #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE

  #define GLYPH_LINK  "\360\237\224\227" // Codepoint U+1F517

 

Regards,

Chris Good

 

___
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] Custom invoices don't work after upgrade

2020-07-03 Thread lomax
On Fri, 2020-07-03 at 10:04 +0800, Christopher Lam wrote:
> Going forward, it will be useful to attach your custom invoice and we
> can offer better feedback.

Sure, I just didn't want to expose anyone else to this mess - but if
you're feeling brave... 
/* Stylesheet for cwo-invoice.scm -- eguile-based Gnucash invoice report */
/* Version 0.03 */

@font-face {
  font-family: "DejaVuSansMono";
  src: url("DejaVuSansMono.ttf") format("truetype");
  font-weight: normal;
  font-style: normal;
}

body {
font-family: DejaVuSansMono;
font-size: 80%;
}

div.main { 
position: relative;
margin: 2em;
max-width: 18cm;
min-height: 22cm;
padding: 2em;
border: 1px solid #000;
}

h1.coyname {
margin: 0em;
padding: 0em;
text-align: left;
font-size: 1.8em;
}
h2.invoice {
padding: 0em;
margin: 0em;
font-size: 1.8em;
}
  h2.invoice small {
  font-weight: normal;
  }

table { 
font-family: DejaVuSansMono;
}
td.subjectname {
}
td.subjectaddr {
padding-bottom: 1em;
}

table.coytable {
margin-bottom: 1em;
}

table.entries {
border: none;
border-collapse: collapse;
border-spacing: 0; 
empty-cells: show;
}
table.entries th {
background: #ddd;
font-weight: bold;
padding: 0.2em 0.4em;
}
table.entries td {
padding: 0.2em 0.4em;
}
td.invnum {
font-weight: bold;
}
td.subtotal {
font-weight: bold;
}
td.total {
font-weight: bold;
}
table.coytable td, table.coytable tr {
vertical-align: top;
}

div#footer {
position: absolute;
bottom: 0;
left: 0;
right: 0;
padding: 1em 0;
border-top: 1px solid #000;
font-size: 0.9em;
text-align: center;
}http://www.w3.org/TR/html4/loose.dtd";>
 1?
   (tbl_cols   0)) ; number of columns for 'colspan' attributes

  ; load splits, if any
  (if (not (null? lot))
(set! splits
  (sort-list (gnc-lot-get-split-list lot) ; sort by date
 (lambda (s1 s2)
   (let ((t1 (xaccSplitGetParent s1))
 (t2 (xaccSplitGetParent s2)))
 (< (car (gnc-transaction-get-date-posted t1))
(car (gnc-transaction-get-date-posted t2

  ; pre-scan invoice entries to look for discounts and taxes
  (for entry in entries do
  (let ((action(gncEntryGetAction entry)) 
(qty   (gncEntryGetDocQuantity entry credit-note?))
(discount  (gncEntryGetInvDiscount entry))   
(taxable?   (gncEntryGetInvTaxable entry))
(taxtable  (gncEntryGetInvTaxTable entry)))
(if (not (string=? action "")) 
  (set! units? #t))
(if (not (= (gnc-numeric-to-double qty) 1.0))
  (set! qty? #t))
(if (not (gnc-numeric-zero-p discount)) (set! discount? #t))
;(if taxable - no, this flag is redundant
(if taxable? ; Also check if the taxable flag is set
  (if  (not (eq? taxtable '()))
  (begin ; presence of a tax table AND taxable flag means it's taxed
(set! tax? #t))

  ; pre-scan invoice splits to see if any payments have been made
  (for split in splits do
  (let* ((t (xaccSplitGetParent split)))
(if (not (equal? t txn))
  (set! payments? #t
?>






 












  
=cwo=
  
  

   
   

  




  

  

  
  
br owneraddr) ?>
  
  
 : 
 
  
  
 : 
 
  
  

  
  

  
  

  
  

  

  
  

  
br coyname) ?>
  
  
br coyaddr) ?>
  

  





 
  

  
  
  
  
  

  
  

  
  

  
  


  
  






  
  

  

   


  
  
  
  
  
  
  

  
  
  

  
  

  
  

  string (gnc:make-gnc-monetary currency disc)) ?>

  %


  
  


  


  
  
  





   


  


  
  
   
  
  


  





  
  
  
  
  





  
,

  


  
   




br notes) ?>
br opt-extra-notes) ?>



br coyaddr) ?>



Company registered in the UK #


" (_ "CWO Invoice") ""))
  (display (string-append "" (_ "No invoice has been selected -- please use the Options menu to select one.") "")))
(let* ((owner (gncInvoiceGetOwner  opt-invoice))
   (endowner  (gncOwnerGetEndOwner owner))
   (ownertype (gncOwnerGetType endowner)))
  (if (not (eqv? ownertype GNC-OWNER-CUSTOMER))
(begin
  

Re: [GNC] Custom invoices don't work after upgrade

2020-07-03 Thread lomax
Still locked in battle with my invoice template. While testing a few
changes I noticed they weren't being picked up - because I was editing
the wrong file. A search revealed no less than five(!) different
locations where I had copies of the template files: 

   ~/.local/share/gnucash/
   ~/.config/gnucash/
   ~/.gnucash
   /usr/share/gnucash/scm/gnucash/report/
   /usr/share/gnucash/scm/gnucash/reports/

I guess at least some of these are left-overs from earlier versions.
Perhaps I should apt-get purge and start over. Having perused the wiki
it is my understanding that custom template files should (now) go in
~/.config/gnucash/, but if I put everything in there and dump the other
duplicates I get an error "Template file "cwo-invoice.eguile.scm" can
not be read". My template consists of the following files: 

   cwo-invoice.eguile.scm
   cwo-invoice.scm
   cwo-invoice.css

I also have a config-user.scm in ~/.config/gnucash/ which contains
(load "~/.config/gnucash/cwo-invoice.scm"). Where do I put cwo-
invoice.eguile.scm so that GnuCash finds it? 



___
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] Custom invoices don't work after upgrade

2020-07-03 Thread Christopher Lam
Here you go. Seems to be a nice css template. You should submit for
inclusion ^_^

On Fri, 3 Jul 2020 at 11:24,  wrote:

> Still locked in battle with my invoice template. While testing a few
> changes I noticed they weren't being picked up - because I was editing
> the wrong file. A search revealed no less than five(!) different
> locations where I had copies of the template files:
>
>~/.local/share/gnucash/
>~/.config/gnucash/
>~/.gnucash
>/usr/share/gnucash/scm/gnucash/report/
>/usr/share/gnucash/scm/gnucash/reports/
>
> I guess at least some of these are left-overs from earlier versions.
> Perhaps I should apt-get purge and start over. Having perused the wiki
> it is my understanding that custom template files should (now) go in
> ~/.config/gnucash/, but if I put everything in there and dump the other
> duplicates I get an error "Template file "cwo-invoice.eguile.scm" can
> not be read". My template consists of the following files:
>
>cwo-invoice.eguile.scm
>cwo-invoice.scm
>cwo-invoice.css
>
> I also have a config-user.scm in ~/.config/gnucash/ which contains
> (load "~/.config/gnucash/cwo-invoice.scm"). Where do I put cwo-
> invoice.eguile.scm so that GnuCash finds it?
>
>
>
> ___
> 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.
>
=cwo=

  Invoice 01

   Customer-GBP
   B1
   B2
   B3
   b4
   b5
   Invoice Date:  04/11/19
   Due Date:  04/11/19
   myname
   myaddress1
   myaddress2
   myaddress3

 Date   Description Net Price Tax Rate Tax Amount Total Price
   02/11/19 Income Standard   £100.00  20% £20.00 £120.00
   02/11/19 Income Reduced£100.00   5%  £5.00 £105.00
   Sub-total  £200.00  £25.00 £225.00
   11/11/19 Payment received, thank you  -£225.00
   Amount Due   £0.00

   Inv-GBP Accumulatew

   Thank you for your patronage!
   myname
   myaddress1
   myaddress2
   myaddress3
   myphone
   Company registered in the UK #
diff --git a/gnucash/report/reports/standard/cwo-invoice.scm b/gnucash/report/reports/standard/cwo-invoice.scm
index 693831897..0f14f835b 100644
--- a/gnucash/report/reports/standard/cwo-invoice.scm
+++ b/gnucash/report/reports/standard/cwo-invoice.scm
@@ -22,25 +22,22 @@
 ; - specify a different module name below (eg mycwo-invoice)
 ; - refer to it from .gnucash/config.user
 ; (see http://wiki.gnucash.org/wiki/Custom_Reports )
-(define-module (gnucash report cwo-invoice))
+(define-module (gnucash reports standard cwo-invoice))
 
 (cond-expand
   (guile-2
   (use-modules (ice-9 local-eval)))  ; for the-environment
   (else ))
 (use-modules (gnucash gnc-module))
-(use-modules (gnucash gettext))
+(use-modules (gnucash core-utils))
 
 (gnc:module-load "gnucash/report/report-system" 0)
 (gnc:module-load "gnucash/html" 0)
 (gnc:module-load "gnucash/engine" 0)
 
-(use-modules (gnucash report standard-reports))
-(use-modules (gnucash report business-reports))
+(use-modules (gnucash reports))
 
-(use-modules (gnucash report eguile-utilities))
-(use-modules (gnucash report eguile-html-utilities))
-(use-modules (gnucash report eguile-gnc))
+(use-modules (gnucash eguile))
 
 (use-modules (srfi srfi-13)) ; for extra string functions
 
@@ -53,34 +50,33 @@
   ;; depending on how complicated the tax table is.
   ;; (When called from within the eguile template, anything
   ;; (display)ed becomes part of the HTML string.)
-  (if (or (not taxable) (eq? taxtable '()))
-(display " ")
+  (cond
+   ((or (not taxable) (eq? taxtable '()))
+(display " "))
+   (else
 (let* ((amttot  (gnc:make-commodity-collector))
-   (pctot   (gnc:make-numeric-collector)) 
+   (pctot   (gnc:make-value-collector))
(entries (gncTaxTableGetEntries taxtable))
(amt?#f)  ; becomes #t if any entries are amounts
(pc? #f)) ; becomes #t if any entries are percentages
-  (for entry in entries do
-  (let ((tttype (gncTaxTableEntryGetType   entry))
-(ttamt  (gncTaxTableEntryGetAmount entry)))
-(if (equal? tttype GNC-AMT-TYPE-VALUE)
-  (begin
-(set! amt? #t)
-(amttot 'add curr ttamt))
-  (begin
-(set! pc? #t)
-(pctot 'add ttamt)
-  (if pc? (begin (display (fmtnumeric (pctot 'total #f))) (display "%")))
-  (if (and amt? pc?) (display " + ")); both - this seems unlikely in practice
-  (if amt?
-(display-comm-coll-total amttot #f))

Re: [GNC] Custom invoices don't work after upgrade

2020-07-03 Thread lomax


On Fri, 2020-07-03 at 12:25 +, Christopher Lam wrote:
> Here you go. Seems to be a nice css template. You should submit for
> inclusion ^_^

Oh, many thanks! In a previous life I did CSS for a living, so it feels
a lot more familiar than Guile... Still stuck on where to put the cwo-
invoice.eguile.scm file though! I purged GnuCash, deleted all *gnucash
folders, and installed v3.10 which I found in my distro's backports
(Devuan Beowulf). Can't get to 4.0 without a manual install, and I much
prefer to stick with distro maintained packages, unless it is
absolutely necessary. Way I see it that's what the distro repos are
for, and I always have automatic updates enabled. Trust, security and
ease of maintenance are important to me. I might consider using a
GnuCash apt source to install from if one was available - you seem like
a thorough and trustworthy bunch. 
But yeah, where should I put cwo-invoice.eguile.scm? 
https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report only
made me more confused! And how do I apply the .patch files you so
kindly provided? I would prefer keeping everything under my home dir,
for ease of backup... 
___
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] Reimbursement in a credit card a/c

2020-07-03 Thread Mahon Finbar

I got reimbursed a sum of over €500 on my credit card account.

It seems to be causing some issues with reconciling the a/c.

I entered the amount as a 'credit card payment' The reimbursement meant 
that the a/c was in credit for quite a while :-) but is now back to 
'normal' i.e. I pay for things and then pay at the end of the month, 
always, i.e. I don't have a balance unpaid at that moment.


However, the a/c won't reconcile, even avoiding, as uncleared, the 
current outstandings.


Am I doing something wrong?

___
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] Custom invoices don't work after upgrade

2020-07-03 Thread Geert Janssens
Op vrijdag 3 juli 2020 15:11:13 CEST schreef lo...@clickworkorange.com:
> On Fri, 2020-07-03 at 12:25 +, Christopher Lam wrote:
> > Here you go. Seems to be a nice css template. You should submit for
> > inclusion ^_^
> 
> Oh, many thanks! In a previous life I did CSS for a living, so it feels
> a lot more familiar than Guile... Still stuck on where to put the cwo-
> invoice.eguile.scm file though!

It's unfortunately a bit messy.

An eguile report consists of three parts.

The report file (cwo-invoice.scm)
The equile template file (cwo-invoice.eguile.scm)
The css file (cwo-invoice.css)

The report file can go anywhere as you load it explicitly in the 
config-user.scm file.

The css and template file are searched for by default in what we refer to as 
GNC_USERDATA_DIR. On linux that is ~/.local/share/gnucash

If the files are not in that location, you can always make the report find them 
by setting full 
pathnames in the respective report options. However storing them in the default 
location will 
probably save you some hassle.

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
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] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread Adrien Monteleone
The glyphs are part of the emoji section of Unicode. I don’t expect changing 
the base font is going to affect them.

I’m not sure how to specify just an emoji set.

I’m also not sure if GTK CSS allows rotations and other transforms like web 
CSS, but you might give it a try. However, there doesn’t seem to be any CSS 
hook exposed for the cell where the glyphs are placed on the register sheet, so 
I don’t think you can target them with specificity.

Regards,
Adrien

> On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good  wrote:
> 
> Has anyone figured out how to make the new paper clip and link glyphs look
> better in Windows 10?
> 
> In Linux Ubuntu 18.04 they look great but in Windows 10 they look pretty
> bad, especially the paper clip.
> 
> Please see attached.
> 
> 
> 
> C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains :
> 
> * {
> 
>   font: 16px arial, sans-serif;
> 
> }
> 
> 
> 
> Changing the font from 'arial' *does* effect most characters but not the
> PaperClip or Link glyphs.
> 
> 
> 
> Here's the definition of the glyphs from
> src/gnucash/register/register-core/assoccell.h
> 
>  #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE
> 
>  #define GLYPH_LINK  "\360\237\224\227" // Codepoint U+1F517


___
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] Cost Basis Report on Transaction

2020-07-03 Thread Michael or Penny Novack

On 7/2/2020 6:13 AM, gnuc...@runbox.com wrote:

I'm evaluating gnuCash for tracking investments.  For my taxes I need a report 
of all stock sales during the year, showing the cost basis.  Perhaps even a 
report of the lots used in a sale.  I cannot find any of these on Standard 
Reports.  Am I missing it somewhere?  Are these reports called something 
different?


Are you structuring your CoA and entering your stock transactions in 
such a way as this data readily available?


In a case like this, it might be useful to get an old accounting book 
from the days of pen and ink on paper to see what account structure used 
and how transactions entered because they had to produce this 
information back then too.


I will simply point out that some of the orgs I kept books for did 
things like selling tee shirts as fundraisers, different batches of 
shirt bought at different cost, and "gross sales" and "cost of goods 
sold" are line items on the 990/990EZ. In this case only needed the 
totals BUT could have structured the "gross sales" and "cost of goods 
sold" to be able to track separate things, not just total.


Michael D Novack

<< hint -- the transaction recording the sale of a tee shirt type x 
would not be just debiting "cash" and crediting "sales". It would also 
be debiting "cost of goods sold" and crediting "basis of x shirts". IF 
necessary to provide more detail, that could have been children  "sales 
of x shirts" and "cost of x shirts sold"



___
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] Scheduled Transactions with Securities

2020-07-03 Thread Dale Alspach
The template for a scheduled transaction does not allow for shares or
share price. When a scheduled transaction includes an account which has
shares it defaults to $1 price per share. Is there anyway to get it to
use something more reasonable such as the last known price?

Dale

___
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] Scheduled Transactions with Securities

2020-07-03 Thread Adrien Monteleone
You should be able to use variables in SX templates. Then it will prompt you 
for a price.

Regards,
Adrien

> On Jul 3, 2020 w27d185, at 10:42 AM, Dale Alspach  wrote:
> 
> The template for a scheduled transaction does not allow for shares or
> share price. When a scheduled transaction includes an account which has
> shares it defaults to $1 price per share. Is there anyway to get it to
> use something more reasonable such as the last known price?


___
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] Scheduled Transactions with Securities

2020-07-03 Thread Adrien Monteleone
Does it not have a place to enter anything at all for those?

In that case, no, even variables would not work.

Regards,
Adrien

> On Jul 3, 2020 w27d185, at 10:49 AM, Adrien Monteleone 
>  wrote:
> 
> You should be able to use variables in SX templates. Then it will prompt you 
> for a price.
> 
> Regards,
> Adrien
> 
>> On Jul 3, 2020 w27d185, at 10:42 AM, Dale Alspach  
>> wrote:
>> 
>> The template for a scheduled transaction does not allow for shares or
>> share price. When a scheduled transaction includes an account which has
>> shares it defaults to $1 price per share. Is there anyway to get it to
>> use something more reasonable such as the last known price?
> 


___
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] Scheduled Transactions with Securities

2020-07-03 Thread David Carlson
Not sure what you mean by template.  In older releases one could just use
an existing stock transaction to copy to a new SX and then, when Since Last
Run entered it, Gnucash would ask for a price.  Not sure if 3.11 or 4.0 is
different.   I never tried fixing a price in the SX.



On Fri, Jul 3, 2020, 10:55 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Does it not have a place to enter anything at all for those?
>
> In that case, no, even variables would not work.
>
> Regards,
> Adrien
>
> > On Jul 3, 2020 w27d185, at 10:49 AM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >
> > You should be able to use variables in SX templates. Then it will prompt
> you for a price.
> >
> > Regards,
> > Adrien
> >
> >> On Jul 3, 2020 w27d185, at 10:42 AM, Dale Alspach 
> wrote:
> >>
> >> The template for a scheduled transaction does not allow for shares or
> >> share price. When a scheduled transaction includes an account which has
> >> shares it defaults to $1 price per share. Is there anyway to get it to
> >> use something more reasonable such as the last known price?
> >
>
>
> ___
> 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] Scheduled Transactions with Securities

2020-07-03 Thread Dale Alspach
This is  gnucash 3.6 on Mint 18. If I click Schedule, I get the same
window as if I had opened the scheduled transaction editor and for the
template tab I get a template with only 6 columns: Date (Scheduled),
Num, Description/Notes, Unlabelled (should be Transfer), Tot Debit, Tot
Credit.
If I start from the security account, there is a slightly different
first window (frequency) that opens, but clicking Advanced ends in the
same place.

Dale

On 7/3/20 12:17 PM, David Carlson wrote:
> Not sure what you mean by template.  In older releases one could just use
> an existing stock transaction to copy to a new SX and then, when Since Last
> Run entered it, Gnucash would ask for a price.  Not sure if 3.11 or 4.0 is
> different.   I never tried fixing a price in the SX.
> 
> 
> 
> On Fri, Jul 3, 2020, 10:55 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
>> Does it not have a place to enter anything at all for those?
>>
>> In that case, no, even variables would not work.
>>
>> Regards,
>> Adrien
>>
>>> On Jul 3, 2020 w27d185, at 10:49 AM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>>
>>> You should be able to use variables in SX templates. Then it will prompt
>> you for a price.
>>>
>>> Regards,
>>> Adrien
>>>
 On Jul 3, 2020 w27d185, at 10:42 AM, Dale Alspach 
>> wrote:

 The template for a scheduled transaction does not allow for shares or
 share price. When a scheduled transaction includes an account which has
 shares it defaults to $1 price per share. Is there anyway to get it to
 use something more reasonable such as the last known price?
>>>
>>
>>
>> ___
>> 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] Mac printing checks on GNUcash 4.x

2020-07-03 Thread John G Sullivan
I just updated and find that my printers are not available on the print checks 
dialog. I checked settings and find both the physical usb connected printer and 
the network connected printer are shown ‘ready’ via the Mac settings.

 

Macbook 2019, Catalina 10.15.5

Gnucash Version: 4.0

 

Suggestions?

 

John G Sullivan

Raleigh NC

___
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] Scheduled Transactions with Securities

2020-07-03 Thread David Carlson
Now I understand your question .  True, there is no place to enter shares
or price in the SX.  Thus it is assumed that whatever total amount is
calculated by the currency part of a transaction buys or sells as many
shares as calculated by the price that the user manually enters when the
Since. Last Run assistant creates the transaction.   I am not sure if
variables can be added, but since it is possible to build scheduled loan
transactions , that may also be possible in stock transactions.   I have
never tried it.  Historically,  variables in scheduled transactions were so
poorly documented it was hard to imagine how to structure them.  I think
the improved documentation may help with that, but I am way behind with
that part of Gnucash.

On Fri, Jul 3, 2020, 12:59 PM Dale Alspach  wrote:

> This is  gnucash 3.6 on Mint 18. If I click Schedule, I get the same
> window as if I had opened the scheduled transaction editor and for the
> template tab I get a template with only 6 columns: Date (Scheduled),
> Num, Description/Notes, Unlabelled (should be Transfer), Tot Debit, Tot
> Credit.
> If I start from the security account, there is a slightly different
> first window (frequency) that opens, but clicking Advanced ends in the
> same place.
>
> Dale
>
> On 7/3/20 12:17 PM, David Carlson wrote:
> > Not sure what you mean by template.  In older releases one could just use
> > an existing stock transaction to copy to a new SX and then, when Since
> Last
> > Run entered it, Gnucash would ask for a price.  Not sure if 3.11 or 4.0
> is
> > different.   I never tried fixing a price in the SX.
> >
> >
> >
> > On Fri, Jul 3, 2020, 10:55 AM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> Does it not have a place to enter anything at all for those?
> >>
> >> In that case, no, even variables would not work.
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Jul 3, 2020 w27d185, at 10:49 AM, Adrien Monteleone <
> >> adrien.montele...@lusfiber.net> wrote:
> >>>
> >>> You should be able to use variables in SX templates. Then it will
> prompt
> >> you for a price.
> >>>
> >>> Regards,
> >>> Adrien
> >>>
>  On Jul 3, 2020 w27d185, at 10:42 AM, Dale Alspach <
> alspac...@gmail.com>
> >> wrote:
> 
>  The template for a scheduled transaction does not allow for shares or
>  share price. When a scheduled transaction includes an account which
> has
>  shares it defaults to $1 price per share. Is there anyway to get it to
>  use something more reasonable such as the last known price?
> >>>
> >>
> >>
> >> ___
> >> 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 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] Mac printing checks on GNUcash 4.x

2020-07-03 Thread Frank H. Ellenberger
Hello John,
yes, this was already reported:
https://bugs.gnucash.org/show_bug.cgi?id=797831

Sorry
Frank

Am 03.07.20 um 23:47 schrieb John G Sullivan:
> I just updated and find that my printers are not available on the print 
> checks dialog. I checked settings and find both the physical usb connected 
> printer and the network connected printer are shown ‘ready’ via the Mac 
> settings.
> 
>  
> 
> Macbook 2019, Catalina 10.15.5
> 
> Gnucash Version: 4.0
> 
>  
> 
> Suggestions?
> 
>  
> 
> John G Sullivan
> 
> Raleigh NC
> 
> ___
> 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] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread Chris Good
Hi Adrien,

Wow, how did I not notice I used GunCash instead of GnuCash in the subject.

I wonder why the glyph is better in Linux than Windows - maybe some-one
knows...
I wonder if it is possible to somehow install the Ubuntu font or whatever
contains the emoji section of Unicode into Windows.

The Ubuntu 'Character Map' application shows the glyphs in Unicode category:
'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'.

I also wonder why GnuCash writes to the sheet directly rather than using a
treeview?
I'm currently trying to change it so there is a visual indication of an
attachment without having to go into double line view.
I cannot get it to make any difference using css but I can use code to
change the font to Italic, so now I'm working on how to get it to do that to
the Description only when there is an attachment. This seems the best I can
do at the moment.

Regards, Chris Good

Message: 4
Date: Fri, 3 Jul 2020 09:24:40 -0500
From: Adrien Monteleone 
To: GnuCash Users 
Subject: Re: [GNC] 

Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

The glyphs are part of the emoji section of Unicode. I don?t expect changing
the base font is going to affect them.

I?m not sure how to specify just an emoji set.

I?m also not sure if GTK CSS allows rotations and other transforms like web
CSS, but you might give it a try. However, there doesn?t seem to be any CSS
hook exposed for the cell where the glyphs are placed on the register sheet,
so I don?t think you can target them with specificity.

Regards,
Adrien

> On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good 
wrote:
> 
> Has anyone figured out how to make the new paper clip and link glyphs 
> look better in Windows 10?
> 
> In Linux Ubuntu 18.04 they look great but in Windows 10 they look 
> pretty bad, especially the paper clip.
> 
> Please see attached.
> 
> 
> 
> C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains :
> 
> * {
> 
>   font: 16px arial, sans-serif;
> 
> }
> 
> 
> 
> Changing the font from 'arial' *does* effect most characters but not 
> the PaperClip or Link glyphs.
> 
> 
> 
> Here's the definition of the glyphs from 
> src/gnucash/register/register-core/assoccell.h
> 
>  #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE
> 
>  #define GLYPH_LINK  "\360\237\224\227" // Codepoint U+1F517

___
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] Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread pyz01
Chris -- don't want to cause an uproar here - since this subject might have
been brought up before -- but IMO it would be nice to replace the reconcile
column with the attachment column.  With the advent of on-line banking and
real time charges via online payment services like Paypal -- I have not
"reconciled" my "checkbook" in over 10 years.   I can check my balance
daily; I always know and can see when something clears my account; I always
know what the balance available is; and -- I only get online statements.
So, again, IMO, the reconcile column is meaningless and should/could be
replaced.   

I have used the reconcile function only once and found it useless -- at
least for me.  But alas, I know many others will probably disagree. 

Ken


-Original Message-
From: gnucash-user  On
Behalf Of Chris Good
Sent: Friday, July 3, 2020 6:06 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GunCash 4.0 Paper Clip and Link glyphs for file/web
transaction associations

Hi Adrien,

Wow, how did I not notice I used GunCash instead of GnuCash in the subject.

I wonder why the glyph is better in Linux than Windows - maybe some-one
knows...
I wonder if it is possible to somehow install the Ubuntu font or whatever
contains the emoji section of Unicode into Windows.

The Ubuntu 'Character Map' application shows the glyphs in Unicode category:
'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'.

I also wonder why GnuCash writes to the sheet directly rather than using a
treeview?
I'm currently trying to change it so there is a visual indication of an
attachment without having to go into double line view.
I cannot get it to make any difference using css but I can use code to
change the font to Italic, so now I'm working on how to get it to do that to
the Description only when there is an attachment. This seems the best I can
do at the moment.

Regards, Chris Good

Message: 4
Date: Fri, 3 Jul 2020 09:24:40 -0500
From: Adrien Monteleone 
To: GnuCash Users 
Subject: Re: [GNC] 

Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

The glyphs are part of the emoji section of Unicode. I don?t expect changing
the base font is going to affect them.

I?m not sure how to specify just an emoji set.

I?m also not sure if GTK CSS allows rotations and other transforms like web
CSS, but you might give it a try. However, there doesn?t seem to be any CSS
hook exposed for the cell where the glyphs are placed on the register sheet,
so I don?t think you can target them with specificity.

Regards,
Adrien

> On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good 
wrote:
> 
> Has anyone figured out how to make the new paper clip and link glyphs 
> look better in Windows 10?
> 
> In Linux Ubuntu 18.04 they look great but in Windows 10 they look 
> pretty bad, especially the paper clip.
> 
> Please see attached.
> 
> 
> 
> C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains :
> 
> * {
> 
>   font: 16px arial, sans-serif;
> 
> }
> 
> 
> 
> Changing the font from 'arial' *does* effect most characters but not 
> the PaperClip or Link glyphs.
> 
> 
> 
> Here's the definition of the glyphs from 
> src/gnucash/register/register-core/assoccell.h
> 
>  #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE
> 
>  #define GLYPH_LINK  "\360\237\224\227" // Codepoint U+1F517

___
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] Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread Chris Good
Hi Ken,

I'm afraid I'm in the group that finds reconciling very useful. I want to
know if anyone is charging me when they shouldn't be, without having to
check my phone all the time. Admittedly it happens so infrequently I could
probably do without it, but I sleep better with it.

I know a developer is considering restructuring the columns to make better
use of wider displays. Maybe that will help you in future. Myself, I don't
really want to use the whole screen, but who knows, I often find I
automatically dislike change but end up liking it.

Regards,
Chris Good

-Original Message-
From: py...@cox.net  
Sent: Saturday, 4 July 2020 11:32 AM
To: 'Chris Good' ; gnucash-user@gnucash.org
Subject: RE: [GNC] Gnucash 4.0 Paper Clip and Link glyphs for file/web
transaction associations

Chris -- don't want to cause an uproar here - since this subject might have
been brought up before -- but IMO it would be nice to replace the reconcile
column with the attachment column.  With the advent of on-line banking and
real time charges via online payment services like Paypal -- I have not
"reconciled" my "checkbook" in over 10 years.   I can check my balance
daily; I always know and can see when something clears my account; I always
know what the balance available is; and -- I only get online statements.
So, again, IMO, the reconcile column is meaningless and should/could be
replaced.   

I have used the reconcile function only once and found it useless -- at
least for me.  But alas, I know many others will probably disagree. 

Ken


-Original Message-
From: gnucash-user  On
Behalf Of Chris Good
Sent: Friday, July 3, 2020 6:06 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GunCash 4.0 Paper Clip and Link glyphs for file/web
transaction associations

Hi Adrien,

Wow, how did I not notice I used GunCash instead of GnuCash in the subject.

I wonder why the glyph is better in Linux than Windows - maybe some-one
knows...
I wonder if it is possible to somehow install the Ubuntu font or whatever
contains the emoji section of Unicode into Windows.

The Ubuntu 'Character Map' application shows the glyphs in Unicode category:
'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'.

I also wonder why GnuCash writes to the sheet directly rather than using a
treeview?
I'm currently trying to change it so there is a visual indication of an
attachment without having to go into double line view.
I cannot get it to make any difference using css but I can use code to
change the font to Italic, so now I'm working on how to get it to do that to
the Description only when there is an attachment. This seems the best I can
do at the moment.

Regards, Chris Good

Message: 4
Date: Fri, 3 Jul 2020 09:24:40 -0500
From: Adrien Monteleone 
To: GnuCash Users 
Subject: Re: [GNC] 

Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

The glyphs are part of the emoji section of Unicode. I don?t expect changing
the base font is going to affect them.

I?m not sure how to specify just an emoji set.

I?m also not sure if GTK CSS allows rotations and other transforms like web
CSS, but you might give it a try. However, there doesn?t seem to be any CSS
hook exposed for the cell where the glyphs are placed on the register sheet,
so I don?t think you can target them with specificity.

Regards,
Adrien

> On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good 
wrote:
> 
> Has anyone figured out how to make the new paper clip and link glyphs 
> look better in Windows 10?
> 
> In Linux Ubuntu 18.04 they look great but in Windows 10 they look 
> pretty bad, especially the paper clip.
> 
> Please see attached.
> 
> 
> 
> C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains :
> 
> * {
> 
>   font: 16px arial, sans-serif;
> 
> }
> 
> 
> 
> Changing the font from 'arial' *does* effect most characters but not 
> the PaperClip or Link glyphs.
> 
> 
> 
> Here's the definition of the glyphs from 
> src/gnucash/register/register-core/assoccell.h
> 
>  #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE
> 
>  #define GLYPH_LINK  "\360\237\224\227" // Codepoint U+1F517

___
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 rememb

Re: [GNC] Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread w...@theprescotts.com
Until recently, reconciling was really my primary use of GnuCash. I also get 
digital statements, but reconciling is the about the only time I look at them.

Will


On 2020 Jul 3, at 07-03 20:45:03, Chris Good  wrote:

Hi Ken,

I'm afraid I'm in the group that finds reconciling very useful. I want to
know if anyone is charging me when they shouldn't be, without having to
check my phone all the time. Admittedly it happens so infrequently I could
probably do without it, but I sleep better with it.

I know a developer is considering restructuring the columns to make better
use of wider displays. Maybe that will help you in future. Myself, I don't
really want to use the whole screen, but who knows, I often find I
automatically dislike change but end up liking it.

Regards,
Chris Good

-Original Message-
From: py...@cox.net  
Sent: Saturday, 4 July 2020 11:32 AM
To: 'Chris Good' ; gnucash-user@gnucash.org
Subject: RE: [GNC] Gnucash 4.0 Paper Clip and Link glyphs for file/web
transaction associations

Chris -- don't want to cause an uproar here - since this subject might have
been brought up before -- but IMO it would be nice to replace the reconcile
column with the attachment column.  With the advent of on-line banking and
real time charges via online payment services like Paypal -- I have not
"reconciled" my "checkbook" in over 10 years.   I can check my balance
daily; I always know and can see when something clears my account; I always
know what the balance available is; and -- I only get online statements.
So, again, IMO, the reconcile column is meaningless and should/could be
replaced.   

I have used the reconcile function only once and found it useless -- at
least for me.  But alas, I know many others will probably disagree. 

Ken


-Original Message-
From: gnucash-user  On
Behalf Of Chris Good
Sent: Friday, July 3, 2020 6:06 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GunCash 4.0 Paper Clip and Link glyphs for file/web
transaction associations

Hi Adrien,

Wow, how did I not notice I used GunCash instead of GnuCash in the subject.

I wonder why the glyph is better in Linux than Windows - maybe some-one
knows...
I wonder if it is possible to somehow install the Ubuntu font or whatever
contains the emoji section of Unicode into Windows.

The Ubuntu 'Character Map' application shows the glyphs in Unicode category:
'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'.

I also wonder why GnuCash writes to the sheet directly rather than using a
treeview?
I'm currently trying to change it so there is a visual indication of an
attachment without having to go into double line view.
I cannot get it to make any difference using css but I can use code to
change the font to Italic, so now I'm working on how to get it to do that to
the Description only when there is an attachment. This seems the best I can
do at the moment.

Regards, Chris Good

Message: 4
Date: Fri, 3 Jul 2020 09:24:40 -0500
From: Adrien Monteleone 
To: GnuCash Users 
Subject: Re: [GNC] 

Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

The glyphs are part of the emoji section of Unicode. I don?t expect changing
the base font is going to affect them.

I?m not sure how to specify just an emoji set.

I?m also not sure if GTK CSS allows rotations and other transforms like web
CSS, but you might give it a try. However, there doesn?t seem to be any CSS
hook exposed for the cell where the glyphs are placed on the register sheet,
so I don?t think you can target them with specificity.

Regards,
Adrien

> On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good 
wrote:
> 
> Has anyone figured out how to make the new paper clip and link glyphs 
> look better in Windows 10?
> 
> In Linux Ubuntu 18.04 they look great but in Windows 10 they look 
> pretty bad, especially the paper clip.
> 
> Please see attached.
> 
> 
> 
> C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains :
> 
> * {
> 
>  font: 16px arial, sans-serif;
> 
> }
> 
> 
> 
> Changing the font from 'arial' *does* effect most characters but not 
> the PaperClip or Link glyphs.
> 
> 
> 
> Here's the definition of the glyphs from 
> src/gnucash/register/register-core/assoccell.h
> 
> #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE
> 
> #define GLYPH_LINK  "\360\237\224\227" // Codepoint U+1F517

___
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] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread John Ralls
Each vendor has their own emoji-block glyphs. The one you're seeing looks 
pretty similar to 
https://emojipedia.org/microsoft/windows-10-may-2019-update/paperclip/.

As for why it's being drawn directly on the sheet, that's because the GnuCash 
register is substantially older that GtkTreeView. You might remember Register2, 
Bob Fewell's attempt to rewrite it to use GtkTreeView for GnuCash 2.6. He 
wasn't able to make it stable enough and set it aside. It's still in the 
codebase: Run gnucash --extra and the Extra menu has "Open Account with 
Register2".

Regards,
John Ralls


> On Jul 3, 2020, at 6:05 PM, Chris Good  wrote:
> 
> Hi Adrien,
> 
> Wow, how did I not notice I used GunCash instead of GnuCash in the subject.
> 
> I wonder why the glyph is better in Linux than Windows - maybe some-one
> knows...
> I wonder if it is possible to somehow install the Ubuntu font or whatever
> contains the emoji section of Unicode into Windows.
> 
> The Ubuntu 'Character Map' application shows the glyphs in Unicode category:
> 'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'.
> 
> I also wonder why GnuCash writes to the sheet directly rather than using a
> treeview?
> I'm currently trying to change it so there is a visual indication of an
> attachment without having to go into double line view.
> I cannot get it to make any difference using css but I can use code to
> change the font to Italic, so now I'm working on how to get it to do that to
> the Description only when there is an attachment. This seems the best I can
> do at the moment.
> 
> Regards, Chris Good
> 
> Message: 4
> Date: Fri, 3 Jul 2020 09:24:40 -0500
> From: Adrien Monteleone 
> To: GnuCash Users 
> Subject: Re: [GNC] 
>   
> Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net>
> Content-Type: text/plain; charset=utf-8
> 
> The glyphs are part of the emoji section of Unicode. I don?t expect changing
> the base font is going to affect them.
> 
> I?m not sure how to specify just an emoji set.
> 
> I?m also not sure if GTK CSS allows rotations and other transforms like web
> CSS, but you might give it a try. However, there doesn?t seem to be any CSS
> hook exposed for the cell where the glyphs are placed on the register sheet,
> so I don?t think you can target them with specificity.
> 
> Regards,
> Adrien
> 
>> On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good 
> wrote:
>> 
>> Has anyone figured out how to make the new paper clip and link glyphs 
>> look better in Windows 10?
>> 
>> In Linux Ubuntu 18.04 they look great but in Windows 10 they look 
>> pretty bad, especially the paper clip.
>> 
>> Please see attached.
>> 
>> 
>> 
>> C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains :
>> 
>> * {
>> 
>>  font: 16px arial, sans-serif;
>> 
>> }
>> 
>> 
>> 
>> Changing the font from 'arial' *does* effect most characters but not 
>> the PaperClip or Link glyphs.
>> 
>> 
>> 
>> Here's the definition of the glyphs from 
>> src/gnucash/register/register-core/assoccell.h
>> 
>> #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE
>> 
>> #define GLYPH_LINK  "\360\237\224\227" // Codepoint U+1F517
> 
> ___
> 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] Reimbursement in a credit card a/c

2020-07-03 Thread Tommy Trussell
On Fri, Jul 3, 2020 at 8:36 AM Mahon Finbar  wrote:

> I got reimbursed a sum of over €500 on my credit card account.
>
> It seems to be causing some issues with reconciling the a/c.
>
> I entered the amount as a 'credit card payment' The reimbursement meant
> that the a/c was in credit for quite a while :-) but is now back to
> 'normal' i.e. I pay for things and then pay at the end of the month,
> always, i.e. I don't have a balance unpaid at that moment.
>
> However, the a/c won't reconcile, even avoiding, as uncleared, the
> current outstandings.
>
> Am I doing something wrong?
>

Hi! I can think of a couple of possibilities. Have you been reconciling the
credit card account every month, or was this the first time you tried?

If you have been reconciling it every month and this is the first time
you've had a problem, I would suspect you entered the statement balance as
a positive when it should have been a negative. (So in other words, most of
the time when you get a statement, you owe something, let's say €240. But
after the credit balance instead of -€260 -- negative two hundred sixty
euros.)

Another thing I noticed is that you said "I got reimbursed a sum of over
€500 on my credit card account."

When you got reimbursed, you do NOT enter that amount as if you wrote a
check to the credit card company -- if you were reimbursed for an
expenditure (either you returned an item to a store, or you were reimbursed
by a third party for things you bought on your credit card) then you would
enter that in the credit card register as a NEGATIVE expenditure. In the
register it would appear as a positive number in the same COLUMN as your
payments, but its other split account would offset whatever expenditure you
are being reimbursed for.

So in your credit card register, if you purchase an appliance, the original
transaction might look like:

Store AExpenses:Household:Appliances  [cr] €500

Then you return the appliance to store A for a full refund:

Store A   Expenses:Household:Appliances [dr] €500

The first transaction increases your credit card liability and the second
transaction reduces the credit card liability (in this case, as you
described it, below zero because in between the purchase and the return you
paid off your credit card bill). SO the next time you reconcile your
statement you would need to enter a NEGATIVE number in the starting balance.

If you had been reimbursed using a different form of payment (such as a
check or bank draft) then you would have entered it similarly into THAT
bank account, as a negative expenditure with the positive part of the money
going into the bank account.

If you need some more guidance, have a look at the GnuCash documentation,
especially section 2.9 of Chapter 2.

https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_txns.html


> 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] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread Adrien Monteleone


> On Jul 3, 2020 w27d185, at 8:05 PM, Chris Good  wrote:
> 
> Hi Adrien,
> 
> Wow, how did I not notice I used GunCash instead of GnuCash in the subject.

Even I had to read this three times before I realized what you meant!

Typos happen.
> 
> ...
> I'm currently trying to change it so there is a visual indication of an
> attachment without having to go into double line view.

I seem to recall one of the devs wanting to make this so, but I don’t think it 
was doable right off. It could be related to the old (but currently used) 
register code vs. 'register-2’ as John mentioned.


> I cannot get it to make any difference using css but I can use code to
> change the font to Italic, so now I'm working on how to get it to do that to
> the Description only when there is an attachment. This seems the best I can
> do at the moment.

If you can figure out how to target the glyph cell with CSS, please do tell. It 
would be useful for MacOS.

Regards,
Adrien

___
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] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations)

2020-07-03 Thread Michael Hendry
> On 4 Jul 2020, at 02:45, Chris Good  wrote:
> 
> Hi Ken,
> 
> I'm afraid I'm in the group that finds reconciling very useful. I want to
> know if anyone is charging me when they shouldn't be, without having to
> check my phone all the time. Admittedly it happens so infrequently I could
> probably do without it, but I sleep better with it.
> 
> I know a developer is considering restructuring the columns to make better
> use of wider displays. Maybe that will help you in future. Myself, I don't
> really want to use the whole screen, but who knows, I often find I
> automatically dislike change but end up liking it.
> 
> Regards,
> Chris Good


I agree with Chris that reconciliation is very useful, and I’d go so far as to 
say essential.

Without it, my reaction to an incoming bank or credit card statement couldn’t 
be more precise than “that looks about right”, with a gradual slide away from 
synchronisation.

A few examples:

My pension is paid net of tax and I set up a Scheduled Transaction (Sx) at the 
start of the financial year. My tax code varies through the year, and the net 
payment is tweaked during the year to get the whole-year tax-take correct - 
reconciliation allows me to knock these small differences into line.

Similarly, my mobile phone bill includes most of what I need in a fixed monthly 
payment, recorded by Sx, but occasionally adjusted to deal with surcharges for 
out-of-contract services.

Apart from my personal accounts, I deal with the bookkeeping for two small 
charities, whose accounts have to be certified by a qualified accountant for 
submission to the Office of the Scottish Charity Register. “About right” is not 
sufficient for this purpose, and as our accountants charge nominal sums for the 
service it is a matter of common courtesy to minimise (if not abolish 
altogether) any queries. One particular example from last year was an 
unpresented cheque which had been sent to another charity for a joint project 
and recorded through our books some months before the end-of-year.

Regards,

Michael Hendry


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