Re: [GNC] Style Sheets - general questions

2020-06-19 Thread Maf. King
On Friday, 19 June 2020 03:32:38 BST Adrien Monteleone wrote:

> 
> I’ll offer this: I always select the entire sheet (clicking that empty cell
> in both row/column headers) and remove *all* styling.
> 

Nice tip, thanks!

Maf.


___
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] Question marks instead of currency in reports

2020-06-19 Thread Gio Bacareza
Thank you for the help Christopher. Yes there are bold fonts capable of
displaying Philippine Peso but the report still displays question marks.
See screenshot below

[image: image.png]

On Thu, Jun 18, 2020 at 2:20 PM Christopher Lam 
wrote:

> The only technical difference between regular lines and total lines is
> that the latter is in bold. Try checking your font for bold symbol?
>
> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:
>
>> it now shows up in the reports but the total is still a question mark. see
>> screenshot below
>> [image: image.png]
>>
>> On Thu, Jun 18, 2020 at 1:49 PM Gio Bacareza  wrote:
>>
>> > Hi Adrien and others,
>> >
>> > I checked the character viewer and Peso is confirmed to be there
>> available
>> > in various fonts including Apple Symbols collection. See screenshot.
>> > [image: image.png]
>> >
>> > It is also in the Security Editor. see screenshot below
>> > [image: image.png]
>> >
>> > So I don't know what else I need to do.
>> >
>> >
>> >
>> > On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone <
>> > adrien.montele...@lusfiber.net> wrote:
>> >
>> >> Your font probably doesn’t have that symbol. Check your custom CSS file
>> >> and find a different font. I’d use either the Mac Character Viewer or
>> Font
>> >> Book to find a suitable one. It looks like that is Unicode 20B1. A
>> simple
>> >> search in Character Viewer for ‘peso’ brought it right up. Select the
>> >> character in the search results in the middle pane, then use the
>> >> bottom-right pane to click each sample to see what fonts have it.
>> (that is
>> >> a really bad UI/UX for this, but it is doable)
>> >>
>> >> Also check Tools > Security editor and make sure a symbol is displayed
>> >> there. If not, you can reset it manually.
>> >>
>> >> Regards,
>> >> Adrien
>> >>
>> >> > On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza <
>> gbacar...@gmail.com>
>> >> wrote:
>> >> >
>> >> > Why am I getting question marks instead of currency in the reports?
>> >> >
>> >> > Gnucash Version: 3.7
>> >> > Preferences / Default Currency = PHP (Philippine Peso)
>> >> >
>> >> > Mac OSX Catalina
>> >>
>> >> ___
>> >> 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.
>> >>
>> >
>> >
>> > --
>> > cheers,
>> >
>> > Gio
>> >
>>
>>
>> --
>> cheers,
>>
>> Gio
>> ___
>> 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.
>>
>

-- 
cheers,

Gio
___
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] Question marks instead of currency in reports

2020-06-19 Thread Fred Bone
On 19 June 2020 at 18:29, Gio Bacareza said:

> Thank you for the help Christopher. Yes there are bold fonts capable of
> displaying Philippine Peso but the report still displays question marks.
> See screenshot below
> 
> [image: image.png]

Your total line is very obviously not in Arial so the display of Arial in 
Character Viewer is irrelevant.

___
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] Question marks instead of currency in reports

2020-06-19 Thread Gio Bacareza
Thank you Fred. I was also pointing out to other fonts. That was just an
example to show that it's there.

On Fri, Jun 19, 2020, 7:04 PM Fred Bone  wrote:

> On 19 June 2020 at 18:29, Gio Bacareza said:
>
> > Thank you for the help Christopher. Yes there are bold fonts capable of
> > displaying Philippine Peso but the report still displays question marks.
> > See screenshot below
> >
> > [image: image.png]
>
> Your total line is very obviously not in Arial so the display of Arial in
> Character Viewer is irrelevant.
>
> ___
> 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] Question marks instead of currency in reports

2020-06-19 Thread Gio Bacareza
I finally solved it! Thank you Adrien. I followed your lead and examined
the style sheets. There I found out that the default style sheets has Fonts
set to NONE. I still don't quite understand what default font GNUCASH
defaults to if it is set at NONE but I experimented and created my own
style sheet and explicitly specified a font. It worked! Thanks Adrien.

I'm just curious. What font does it default to if it's set to NONE? Thanks

On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Also, are you using a custom/modified stylesheet for the report with a
> different font for the totals?
>
> Regards,
> Adrien
>
> > On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam <
> christopher@gmail.com> wrote:
> >
> > The only technical difference between regular lines and total lines is
> that
> > the latter is in bold. Try checking your font for bold symbol?
> >
> > On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:
> >
> >> it now shows up in the reports but the total is still a question mark.
> see
> >> screenshot below
> >> [image: image.png]
>
>
> ___
> 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.
>


-- 
cheers,

Gio
___
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] Question marks instead of currency in reports

2020-06-19 Thread pobox . deva
Gio,

I had the same problem with my invoice report a while ago whereby my INR 
currency symbol was displayed as question marks. Adrien helped with some CSS 
styling code (which I had to put on the Notes tab in Embedded CSS box). After I 
put this snippet there, it all works fine now.

h1.coyname { text-align: left; }
* { font-family: Helvetica; }

You can try with a font-family name of your choice to see if that helps.

Cheers.

> On 19-Jun-2020, at 3:59 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 19 Jun 2020 18:29:38 +0800
> From: Gio Bacareza mailto:gbacar...@gmail.com>>
> To: Christopher Lam  >
> Cc: GnuCash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Question marks instead of currency in reports
> Message-ID:
>>
> Content-Type: text/plain; charset="utf-8"
> 
> Thank you for the help Christopher. Yes there are bold fonts capable of
> displaying Philippine Peso but the report still displays question marks.
> See screenshot below
> 
> [image: image.png]
> 
> On Thu, Jun 18, 2020 at 2:20 PM Christopher Lam  >
> wrote:
> 
>> The only technical difference between regular lines and total lines is
>> that the latter is in bold. Try checking your font for bold symbol?
>> 
>> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, > > wrote:
>> 
>>> it now shows up in the reports but the total is still a question mark. see
>>> screenshot below
>>> [image: image.png]
>>> 
>>> On Thu, Jun 18, 2020 at 1:49 PM Gio Bacareza >> > wrote:
>>> 
 Hi Adrien and others,
 
 I checked the character viewer and Peso is confirmed to be there
>>> available
 in various fonts including Apple Symbols collection. See screenshot.
 [image: image.png]
 
 It is also in the Security Editor. see screenshot below
 [image: image.png]
 
 So I don't know what else I need to do.
 
 
 
 On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone <
 adrien.montele...@lusfiber.net > 
 wrote:
 
> Your font probably doesn?t have that symbol. Check your custom CSS file
> and find a different font. I?d use either the Mac Character Viewer or
>>> Font
> Book to find a suitable one. It looks like that is Unicode 20B1. A
>>> simple
> search in Character Viewer for ?peso? brought it right up. Select the
> character in the search results in the middle pane, then use the
> bottom-right pane to click each sample to see what fonts have it.
>>> (that is
> a really bad UI/UX for this, but it is doable)
> 
> Also check Tools > Security editor and make sure a symbol is displayed
> there. If not, you can reset it manually.
> 
> Regards,
> Adrien
> 
>> On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza <
>>> gbacar...@gmail.com >
> wrote:
>> 
>> Why am I getting question marks instead of currency in the reports?
>> 
>> Gnucash Version: 3.7
>> Preferences / Default Currency = PHP (Philippine Peso)
>> 
>> Mac OSX Catalina
> 
> ___
> 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.
> 
 
 
 --
 cheers,
 
 Gio
 
>>> 
>>> 
>>> --
>>> cheers,
>>> 
>>> Gio
>>> ___
>>> 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.
>>> 
>> 
> 
> -- 
> cheers,
> 
> Gio

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

Re: [GNC] Question marks instead of currency in reports

2020-06-19 Thread John Ralls
Hard to tell for reports, that would be up to webkit and while I found where 
it's set in the webkit source I don't see any default value there. Gtk's 
default on MacOS is SystemDefaultFont (San Francisco on El Cap and later) 12pt.

Regards,
John Ralls


> On Jun 19, 2020, at 4:47 AM, Gio Bacareza  wrote:
> 
> I finally solved it! Thank you Adrien. I followed your lead and examined
> the style sheets. There I found out that the default style sheets has Fonts
> set to NONE. I still don't quite understand what default font GNUCASH
> defaults to if it is set at NONE but I experimented and created my own
> style sheet and explicitly specified a font. It worked! Thanks Adrien.
> 
> I'm just curious. What font does it default to if it's set to NONE? Thanks
> 
> On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
>> Also, are you using a custom/modified stylesheet for the report with a
>> different font for the totals?
>> 
>> Regards,
>> Adrien
>> 
>>> On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam <
>> christopher@gmail.com> wrote:
>>> 
>>> The only technical difference between regular lines and total lines is
>> that
>>> the latter is in bold. Try checking your font for bold symbol?
>>> 
>>> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:
>>> 
 it now shows up in the reports but the total is still a question mark.
>> see
 screenshot below
 [image: image.png]
>> 
>> 
>> ___
>> 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.
>> 
> 
> 
> -- 
> cheers,
> 
> Gio
> ___
> 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] Cursor Focus on Wrong Tab

2020-06-19 Thread David T. via gnucash-user

Hello,

I swear I reported troubles with this a long time ago, and I could have 
sworn I added a bug about it. My recollection was that I was the only 
person who could duplicate the issue, and so it never went anywhere 
further. However, I find no evidence on Bugzilla or in the lists. Alas. 
My search skills are clearly lacking.


The issue is this: when I am in Tab "H" and duplicate a transaction by 
clicking the toolbar Duplicate button, once I have concluded the process 
by selecting a new date and pressing Enter, my cursor appears to be in 
tab "H", but is actually on Tab "B" (which is the first register 
account, after the COA). If I attempt to edit the transaction at this 
point, the transaction that receives input is NOT the visible 
transaction in tab H, but rather the hidden transaction on tab B.


In the attached image, "Base Salary" is the aforementioned tab H, in 
which I have just created a new transaction by clicking the Duplicate 
button, choosing today's date and pressing Enter, which has created the 
06/19/2020 transaction that is visible on screen.


If you look down where the big arrow is pointing, however, you will see 
"66.59" clearly displayed. "66.59" is actually the value of a 
transaction in the Checking register. If I start typing, the 
transaction that receives input *is in the Checking register and NOT the 
visible transaction in the Base Salary register.* I have to remember to 
use the mouse to actively click in the on screen transaction in order to 
"select" the transaction I just created on the currently-visible 
register and which appears to currently have focus.


To say this is confusing is an understatement--and it only gets worse if 
I start typing, fail to see any change, and then remember to click the 
current register. Now, the visible register gets focus--and the hidden 
register (which has changes I unwittingly have made) gets a commit. 
Obviously, this can have significant negative effects: the transaction I 
blindly edited has changed and been saved. Maybe that transaction is now 
unreconciled. Maybe I put gibberish into the description. Maybe I put 
gibberish into the transfer account, and GnuCash will send me a 
mysterious message that the account doesn't exist, would I like to 
create it. Maybe I have changed the amount on that transaction.


I hope that this email provides enough information that others can now 
see the problem that I have seen for a long time; if others can 
duplicate this, I'll enter a bug report.


David T.

___
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] Disappearing entries

2020-06-19 Thread Derek Atkins
Carl  writes:

> Well, as it was supposed to happen, all worked out well.  Just changed the
> biggest file or the one named below to some generic file name.  It works
> fineso far.

Just be careful when you open GnuCash.  It is best to just let GnuCash
auto-open the last-used file instead of trying to click on a filemane.
When you click on a file to open you're likely to mis-click and not
notice that you've opened a backup (which, by default, it stored in the
same directory as the main data file).

> Thanks, all,

You're welcome.

Good Luck!

> Carl

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] How to find UnPosted Bill?

2020-06-19 Thread Fran_3 via gnucash-user
Seems like I ran into this way back but can't remember the solution...
- If a bill is created...- Then the bill tab is closed before it is "Posted"
it seems it does not appear in... 
Business > Vendor > Find Billnor in...Reports > Experimental > Vendor Report 
(beta)
So where is it? How to find it and post it?
Thanks.

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


Re: [GNC] Style Sheets - general questions

2020-06-19 Thread Adrien Monteleone


> On Jun 19, 2020 w25d171, at 12:14 AM, flywire  wrote:
> 
>> How is it interfering with adding columns in LO Calc?
> 
> Only different formatting.
> 
>> select the entire sheet (clicking that empty cell in both row/column
> headers) and remove *all* styling.
> 
> No luck with that, Just selected cells and set to Background colour (No
> Fill).

Hmm.  I just tried it by exporting to HTML, ‘insert sheet from file’ in LO 
Calc, selected all cells (via that empty header cell), and in ‘Cell Appearance 
> Background’ clicked ’No Fill’ and it worked as expected.

I tested this with LO 6.4.3.2 on MacOS. I suppose mileage may vary.

If you don’t need the other styles, simply selecting all cells and using the 
right-click ‘Clear Direct Formatting’ should also do the trick.

I also tested with copy/paste, but then I recalled I’ve set my normal paste in 
LO Calc to be ‘Paste Special > Unformatted Text’ so I can’t test with the 
defaults that probably bring in styling. I should think once pasted though you 
should be able to manipulate like any other cells.

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.


Re: [GNC] How to find UnPosted Bill?

2020-06-19 Thread Derek Atkins
Hi,

On Fri, June 19, 2020 12:12 pm, Fran_3 via gnucash-user wrote:
> Seems like I ran into this way back but can't remember the solution...
> - If a bill is created...- Then the bill tab is closed before it is
> "Posted"
> it seems it does not appear in...
> Business > Vendor > Find Billnor in...Reports > Experimental > Vendor
> Report (beta)
> So where is it? How to find it and post it?

It definitely wont be in the latter if it's not posted.

It SHOULD be in the former, unless you are only searching for posted
invoices?  What search criteria are you using?

> Thanks.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Question marks instead of currency in reports

2020-06-19 Thread Adrien Monteleone
You *might* be able to find that info by running the GTKInspector. There is a 
panel that will show you the current values of various UI elements. But no 
guarantee it will show you the actual font used rather than just a declaration. 
It’s worth a shot I suppose if it is really important to tweak.

That might be considered an RFE. If GnuCash specified a font family (not just 
one) that has all the currency symbols then it is unlikely anyone would ever 
come across this issue.

Glad to hear you solved it.

Regards,
Adrien

> On Jun 19, 2020 w25d171, at 6:47 AM, Gio Bacareza  wrote:
> 
> I finally solved it! Thank you Adrien. I followed your lead and examined the 
> style sheets. There I found out that the default style sheets has Fonts set 
> to NONE. I still don't quite understand what default font GNUCASH defaults to 
> if it is set at NONE but I experimented and created my own style sheet and 
> explicitly specified a font. It worked! Thanks Adrien.
> 
> I'm just curious. What font does it default to if it's set to NONE? Thanks
> 
> On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone 
>  wrote:
> Also, are you using a custom/modified stylesheet for the report with a 
> different font for the totals?
> 
> 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.


Re: [GNC] Question marks instead of currency in reports

2020-06-19 Thread Adrien Monteleone
That’s the beauty of a mailing list - I forgot all about that option.

Thanks!

Regards,
Adrien

> On Jun 19, 2020 w25d171, at 6:56 AM, pobox.d...@outlook.in wrote:
> 
> Gio,
> 
> I had the same problem with my invoice report a while ago whereby my INR 
> currency symbol was displayed as question marks. Adrien helped with some CSS 
> styling code (which I had to put on the Notes tab in Embedded CSS box). After 
> I put this snippet there, it all works fine now.
> 
> h1.coyname { text-align: left; }
> * { font-family: Helvetica; }
> 
> You can try with a font-family name of your choice to see if that helps.
> 
> Cheers.
> 


___
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] How to find UnPosted Bill?

2020-06-19 Thread Adrien Monteleone
I just did an Invoice Find. I have 2 that are unposted for a customer, and they 
both show up in the results.

Neither has a due date (blank cell) and the ‘posted date’ shows as 
"12/31/1969". (which probably should be blank instead)

So, not super easy to spot, but you have enough clues to see them and sort 
accordingly.

Regards,
Adrien

> On Jun 19, 2020 w25d171, at 11:22 AM, Derek Atkins  wrote:
> 
> Hi,
> 
> On Fri, June 19, 2020 12:12 pm, Fran_3 via gnucash-user wrote:
>> Seems like I ran into this way back but can't remember the solution...
>> - If a bill is created...- Then the bill tab is closed before it is
>> "Posted"
>> it seems it does not appear in...
>> Business > Vendor > Find Billnor in...Reports > Experimental > Vendor
>> Report (beta)
>> So where is it? How to find it and post it?
> 
> It definitely wont be in the latter if it's not posted.
> 
> It SHOULD be in the former, unless you are only searching for posted
> invoices?  What search criteria are you using?


___
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] Cursor Focus on Wrong Tab

2020-06-19 Thread David Carlson
I suspect that there are actually other instances in the code where
pointers get out of sync, and I am sure that it is incredibly difficult to
test every case, especially in the existing code.  Hopefully, in release
4.0 it will start to get easier to test these things.

One tool that I use for a different circumstance where the working focus is
not visible on the screen is to hit the Tab key, which usually causes the
current window to show the location of the curser.  That does not address
the underlying issues.

On Fri, Jun 19, 2020 at 10:32 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I swear I reported troubles with this a long time ago, and I could have
> sworn I added a bug about it. My recollection was that I was the only
> person who could duplicate the issue, and so it never went anywhere
> further. However, I find no evidence on Bugzilla or in the lists. Alas.
> My search skills are clearly lacking.
>
> The issue is this: when I am in Tab "H" and duplicate a transaction by
> clicking the toolbar Duplicate button, once I have concluded the process
> by selecting a new date and pressing Enter, my cursor appears to be in
> tab "H", but is actually on Tab "B" (which is the first register
> account, after the COA). If I attempt to edit the transaction at this
> point, the transaction that receives input is NOT the visible
> transaction in tab H, but rather the hidden transaction on tab B.
>
> In the attached image, "Base Salary" is the aforementioned tab H, in
> which I have just created a new transaction by clicking the Duplicate
> button, choosing today's date and pressing Enter, which has created the
> 06/19/2020 transaction that is visible on screen.
>
> If you look down where the big arrow is pointing, however, you will see
> "66.59" clearly displayed. "66.59" is actually the value of a
> transaction in the Checking register. If I start typing, the
> transaction that receives input *is in the Checking register and NOT the
> visible transaction in the Base Salary register.* I have to remember to
> use the mouse to actively click in the on screen transaction in order to
> "select" the transaction I just created on the currently-visible
> register and which appears to currently have focus.
>
> To say this is confusing is an understatement--and it only gets worse if
> I start typing, fail to see any change, and then remember to click the
> current register. Now, the visible register gets focus--and the hidden
> register (which has changes I unwittingly have made) gets a commit.
> Obviously, this can have significant negative effects: the transaction I
> blindly edited has changed and been saved. Maybe that transaction is now
> unreconciled. Maybe I put gibberish into the description. Maybe I put
> gibberish into the transfer account, and GnuCash will send me a
> mysterious message that the account doesn't exist, would I like to
> create it. Maybe I have changed the amount on that transaction.
>
> I hope that this email provides enough information that others can now
> see the problem that I have seen for a long time; if others can
> duplicate this, I'll enter a bug report.
>
> David T.
>
> ___
> 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.
>


-- 
David Carlson
___
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] Cursor Focus on Wrong Tab

2020-06-19 Thread D. via gnucash-user
In this case, tab moves you to other fields in the hidden tab. Only by clicking 
in the visible register does it change. 


 Original Message 
From: David Carlson 
Sent: Fri Jun 19 15:00:49 EDT 2020
To: "David T." 
Cc: Gnucash Users 
Subject: Re: [GNC] Cursor Focus on Wrong Tab

I suspect that there are actually other instances in the code where
pointers get out of sync, and I am sure that it is incredibly difficult to
test every case, especially in the existing code.  Hopefully, in release
4.0 it will start to get easier to test these things.

One tool that I use for a different circumstance where the working focus is
not visible on the screen is to hit the Tab key, which usually causes the
current window to show the location of the curser.  That does not address
the underlying issues.

On Fri, Jun 19, 2020 at 10:32 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I swear I reported troubles with this a long time ago, and I could have
> sworn I added a bug about it. My recollection was that I was the only
> person who could duplicate the issue, and so it never went anywhere
> further. However, I find no evidence on Bugzilla or in the lists. Alas.
> My search skills are clearly lacking.
>
> The issue is this: when I am in Tab "H" and duplicate a transaction by
> clicking the toolbar Duplicate button, once I have concluded the process
> by selecting a new date and pressing Enter, my cursor appears to be in
> tab "H", but is actually on Tab "B" (which is the first register
> account, after the COA). If I attempt to edit the transaction at this
> point, the transaction that receives input is NOT the visible
> transaction in tab H, but rather the hidden transaction on tab B.
>
> In the attached image, "Base Salary" is the aforementioned tab H, in
> which I have just created a new transaction by clicking the Duplicate
> button, choosing today's date and pressing Enter, which has created the
> 06/19/2020 transaction that is visible on screen.
>
> If you look down where the big arrow is pointing, however, you will see
> "66.59" clearly displayed. "66.59" is actually the value of a
> transaction in the Checking register. If I start typing, the
> transaction that receives input *is in the Checking register and NOT the
> visible transaction in the Base Salary register.* I have to remember to
> use the mouse to actively click in the on screen transaction in order to
> "select" the transaction I just created on the currently-visible
> register and which appears to currently have focus.
>
> To say this is confusing is an understatement--and it only gets worse if
> I start typing, fail to see any change, and then remember to click the
> current register. Now, the visible register gets focus--and the hidden
> register (which has changes I unwittingly have made) gets a commit.
> Obviously, this can have significant negative effects: the transaction I
> blindly edited has changed and been saved. Maybe that transaction is now
> unreconciled. Maybe I put gibberish into the description. Maybe I put
> gibberish into the transfer account, and GnuCash will send me a
> mysterious message that the account doesn't exist, would I like to
> create it. Maybe I have changed the amount on that transaction.
>
> I hope that this email provides enough information that others can now
> see the problem that I have seen for a long time; if others can
> duplicate this, I'll enter a bug report.
>
> David T.
>
> ___
> 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.
>


-- 
David Carlson

___
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] Get quotes problem with testing version 3.905

2020-06-19 Thread John Bonnett

On 17/06/2020 10:39 am, Chris Good wrote:

Message: 8
Date: Wed, 17 Jun 2020 08:53:24 +0930
From: John Bonnett 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Get quotes problem with testing version 3.905
Message-ID: 
Content-Type: text/plain; charset=utf-8; format=flowed

Here is my previous email with the graphics replaced by some relevant text.

I installed v3.905 to help with testing. I have a problem with getting
online quotes which worked fine with the latest release version.
Everything else has been OK so far.

I get this message now:


ERROR:: ALPHAVANTAGE_API_KEY must be set for currency and quotes; see
https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US

Although that URL provides lots of good information, none of my active
stocks, for which I am trying to get online quotes, are using
Alphavantage. I do have some inactive/obsolete stocks which are
defaulting to Alphavantage. Most of my active stocks are from the
Australian exchange ASX. I have one on NASDAQ for which I am using
Yahoo-json but that does not seem to work and did not on the release
version either. Here are the versions in my About dialog:


Version 3.905

Build ID: 3.905+(2020-06-14)

Finance::Quote: 1.47


Should I try to remove all reference to Alphavantage from even
inactive stocks?

John Bonnett


Hi John,

If you haven't got a free Alpha Vantage API key and do have stocks that need
it, you either need to get an API key or untick 'Get Quotes' in the security
editor for those stocks using source alphavantage.
If you have accounts using multiple currencies, then you also need to untick
'Get Quotes' in the security editor for all the currencies if you don't want
exchange rates to be downloaded.

3.905 now gives you an error message rather that failing with an obscure
error msg.

See https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US

Regards, Chris Good


Hi Chris,

I had noticed those obscure error messages you mention. I have resolved 
my problem and it was that I had a currency, which I don't remember ever 
adding. I actually found out about it by examining my data as 
uncompressed XML and searching for . I then discovered I 
had to check a box in the security editor to see it in the GUI. I 
unchecked 'Get Quotes' for it and now the only messages I get are 
expected ones.


Thanks for you help.

John Bonnett


___
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] Cursor Focus on Wrong Tab

2020-06-19 Thread David H
Hi David T.,

I seem to recall your original email but at the time I was unsure if what I
was seeing was the same issue and it seems to have gone away anyway, but
maybe it is the same thing :-)

My issue was that I was seeing the odd blank transaction in my savings
account register, coincidentally the register that is always next to the
accounts tab.  Additionally I used to have an issue with duplicating
transactions where the transaction was duplicated ok with today's date but
it seemed to be locked and I couldn't just tab across to update the
amount.  I probably tried both tabbing and hitting enter - perhaps that
created the blank transaction, who knows. I used to have to click on a
different transaction and then come back to the duplicate transaction to
update it for some reason so I was wondering if this was connected to the
blank transaction in some way.  Howsomever these little annoyances seem to
have gone away.  I'm pretty quick to update as soon as a new version comes
out and am currently running the latest test version (3.905) on Win 10, Win
7, MacOS Catalina.  I vaguely recall seeing a blank transaction as recently
as a couple of weeks ago which would have been on version 3.10 when I
opened gnucash on a pc I hadn't used for awhile.

I'm using Gnucash on multiple pc's - Win 7, Win 10, MacOS Catalina (x2),
Ubuntu Linux 20.04 and using dropbox to synchronise the file between
platforms.  My workflow consists of generally having 6 registers open in
addition to the accounts tab and I usually update a single register at a
time from right to left and normally always scroll down after updating each
register so the date in the blank transaction is highlighted when I tab to
the next register if it matters :-)

As I said I haven't seen one of these blank transactions for a while so
they may have gone away altogether.

What version of gnucash are you using and what os ?

Cheers David H.


On Sat, 20 Jun 2020 at 01:32, David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I swear I reported troubles with this a long time ago, and I could have
> sworn I added a bug about it. My recollection was that I was the only
> person who could duplicate the issue, and so it never went anywhere
> further. However, I find no evidence on Bugzilla or in the lists. Alas.
> My search skills are clearly lacking.
>
> The issue is this: when I am in Tab "H" and duplicate a transaction by
> clicking the toolbar Duplicate button, once I have concluded the process
> by selecting a new date and pressing Enter, my cursor appears to be in
> tab "H", but is actually on Tab "B" (which is the first register
> account, after the COA). If I attempt to edit the transaction at this
> point, the transaction that receives input is NOT the visible
> transaction in tab H, but rather the hidden transaction on tab B.
>
> In the attached image, "Base Salary" is the aforementioned tab H, in
> which I have just created a new transaction by clicking the Duplicate
> button, choosing today's date and pressing Enter, which has created the
> 06/19/2020 transaction that is visible on screen.
>
> If you look down where the big arrow is pointing, however, you will see
> "66.59" clearly displayed. "66.59" is actually the value of a
> transaction in the Checking register. If I start typing, the
> transaction that receives input *is in the Checking register and NOT the
> visible transaction in the Base Salary register.* I have to remember to
> use the mouse to actively click in the on screen transaction in order to
> "select" the transaction I just created on the currently-visible
> register and which appears to currently have focus.
>
> To say this is confusing is an understatement--and it only gets worse if
> I start typing, fail to see any change, and then remember to click the
> current register. Now, the visible register gets focus--and the hidden
> register (which has changes I unwittingly have made) gets a commit.
> Obviously, this can have significant negative effects: the transaction I
> blindly edited has changed and been saved. Maybe that transaction is now
> unreconciled. Maybe I put gibberish into the description. Maybe I put
> gibberish into the transfer account, and GnuCash will send me a
> mysterious message that the account doesn't exist, would I like to
> create it. Maybe I have changed the amount on that transaction.
>
> I hope that this email provides enough information that others can now
> see the problem that I have seen for a long time; if others can
> duplicate this, I'll enter a bug report.
>
> David T.
>
> ___
> 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

Re: [GNC] Style Sheets - general questions

2020-06-19 Thread Errata Eratum via gnucash-user
Thank you.


Sent from Yahoo Mail for iPhone


On Thursday, June 18, 2020, 9:28 PM, Adrien Monteleone 
 wrote:

I’ll add that extensive work is currently being done on many reports to improve 
them.

(you can see some of these efforts in Reports > Experimental)

But think of the GnuCash reports as getting you the basic form, and then if you 
want something different, export to spreadsheet and manipulate further to your 
liking.

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.



___
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] Old version Gnucash

2020-06-19 Thread James Fuller
Hi,
Is there a website where I can find and download earlier versions of GnuCash?

Thanks,

James Fuller


Sent from my iPad
___
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] Cursor Focus on Wrong Tab

2020-06-19 Thread D. via gnucash-user
David, 

Thanks for the reply. Can't believe I forgot version info. GC3.5 Windows 10. 

I just found another piece of this. I reopened gnucash just now, and it opened 
with the previous window settings. When I clicked the duplicate button in tab H 
this time, however, I didn't get the same behavior. It all worked fine. Odd! 

So, I backed out and recreated my original steps. First, I open my checking 
account, and locate a transaction with a split connected to my other account. 
Next, I highlight the split for that account, and jump to that account. Now, 
when I click the duplicate button, I get the odd behavior. 

Further experiments yield seemingly random behavior. If I go to a different tab 
C in the same session, and jump to a new register, tab J, tab B remains the 
hidden tab to receive focus. If, instead, I restart gnucash and repeat the 
steps, then tab C is the register with focus-- even if I repeat my steps later 
in the session from tab B. It's almost as if the first register from which you 
jump is the special register until restart. 

I did test to see which transaction would be deleted in this scenario; 
thankfully, it's the one that's in the visible register. 

Your problem might correlate to mine, I believe, if your hidden account were on 
the blank transaction while you were pressing tab and enter; in that case, the 
hidden register would commit an empty transaction. Your clicks on other entries 
in the visible register return thre focus to this register. 

I'll keep digging to see what the edges of this are...


 Original Message 
From: David H 
Sent: Fri Jun 19 19:41:56 EDT 2020
To: "David T." 
Cc: Gnucash Users 
Subject: Re: [GNC] Cursor Focus on Wrong Tab

Hi David T.,

I seem to recall your original email but at the time I was unsure if what I
was seeing was the same issue and it seems to have gone away anyway, but
maybe it is the same thing :-)

My issue was that I was seeing the odd blank transaction in my savings
account register, coincidentally the register that is always next to the
accounts tab.  Additionally I used to have an issue with duplicating
transactions where the transaction was duplicated ok with today's date but
it seemed to be locked and I couldn't just tab across to update the
amount.  I probably tried both tabbing and hitting enter - perhaps that
created the blank transaction, who knows. I used to have to click on a
different transaction and then come back to the duplicate transaction to
update it for some reason so I was wondering if this was connected to the
blank transaction in some way.  Howsomever these little annoyances seem to
have gone away.  I'm pretty quick to update as soon as a new version comes
out and am currently running the latest test version (3.905) on Win 10, Win
7, MacOS Catalina.  I vaguely recall seeing a blank transaction as recently
as a couple of weeks ago which would have been on version 3.10 when I
opened gnucash on a pc I hadn't used for awhile.

I'm using Gnucash on multiple pc's - Win 7, Win 10, MacOS Catalina (x2),
Ubuntu Linux 20.04 and using dropbox to synchronise the file between
platforms.  My workflow consists of generally having 6 registers open in
addition to the accounts tab and I usually update a single register at a
time from right to left and normally always scroll down after updating each
register so the date in the blank transaction is highlighted when I tab to
the next register if it matters :-)

As I said I haven't seen one of these blank transactions for a while so
they may have gone away altogether.

What version of gnucash are you using and what os ?

Cheers David H.


On Sat, 20 Jun 2020 at 01:32, David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I swear I reported troubles with this a long time ago, and I could have
> sworn I added a bug about it. My recollection was that I was the only
> person who could duplicate the issue, and so it never went anywhere
> further. However, I find no evidence on Bugzilla or in the lists. Alas.
> My search skills are clearly lacking.
>
> The issue is this: when I am in Tab "H" and duplicate a transaction by
> clicking the toolbar Duplicate button, once I have concluded the process
> by selecting a new date and pressing Enter, my cursor appears to be in
> tab "H", but is actually on Tab "B" (which is the first register
> account, after the COA). If I attempt to edit the transaction at this
> point, the transaction that receives input is NOT the visible
> transaction in tab H, but rather the hidden transaction on tab B.
>
> In the attached image, "Base Salary" is the aforementioned tab H, in
> which I have just created a new transaction by clicking the Duplicate
> button, choosing today's date and pressing Enter, which has created the
> 06/19/2020 transaction that is visible on screen.
>
> If you look down where the big arrow is pointing, however, you will see
> "66.59" clearly displayed. "66.59" is actually the value of a
> transaction in 

Re: [GNC] Old version Gnucash

2020-06-19 Thread D. via gnucash-user
https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/


 Original Message 
From: James Fuller 
Sent: Fri Jun 19 22:52:20 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Old version Gnucash

Hi,
Is there a website where I can find and download earlier versions of GnuCash?

Thanks,

James Fuller


Sent from my iPad
___
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.