Re: [GNC] Style Sheets - general questions

2020-06-18 Thread flywire
> 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).

I suppose my preference would be no background in the CSS but maybe it's
needed to overwrite any underlying windows.

Thanks again 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] Style Sheets - general questions

2020-06-18 Thread Adrien Monteleone
Interesting.

I haven’t looked at the standard inline report CSS lately, so I didn’t realize 
there was a background specified.

How is it interfering with adding columns in LO Calc?

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

Then I style the way I want.

Templates can be employed and applied with a click or so if you desire.

That would remove said background color, though I agree it shouldn’t be there. 
(neither should a foreground color) Those properties should be inherited from 
‘default’ or specified by the user if they don’t like ‘default’.

Regards,
Adrien

> On Jun 18, 2020 w25d170, at 7:49 PM, flywire  wrote:
> 
> I was really pleased to be pointed to opening HTML reports directly in LO
> Calc last month. I can see CSS is very versatile but I'm not proficient
> with it.
> 
> Hopefully someone can contribute a quick guide for GnuCash reports at some
> stage. I'd be happy with just turning off the white background because the
> main thing I do is add extra columns.

___
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-18 Thread Adrien Monteleone
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.


Re: [GNC] Style Sheets - general questions

2020-06-18 Thread Adrien Monteleone
You don’t even have to export to CSV.

You can ’save’ the report which will be HTML formatted and open it in a 
spreadsheet app, or just copy/paste to a spreadsheet.

If your are having issues with pagination/line-breaks, that is the way to go.

There are some issues (especially on MacOS) with the version of Webkit which 
renders the reports that affect pagination.

You *could* use the experimental all-CSS stylesheet, and tweak to your hearts 
content, but even then, you might have some issues.

It is, for now, much faster and easier to just move the report to a spreadsheet 
and manipulate from there for printing pretty.

The advantage is you also have the option of adding things like variance and 
percentage columns that aren’t easy to do with the standard reports. (you’d 
have to re-write them, using Scheme)


Regards,
Adrien

> On Jun 18, 2020 w25d170, at 5:31 PM, w...@theprescotts.com wrote:
> 
> Scott,
> 
> Like you I have used GnuCash for personal use for years and now am using it 
> for an organization I belong to. I didn't like the appearance of the standard 
> reports. Instead of trying to customize them, I just export the transactions 
> as a csv file and open in Apple's Numbers spreadsheet program. From there it 
> is quick and easy to copy them to some standard spreadsheets that I use in my 
> reports. Because the csv file contains columns with the account names it is 
> very easy to sort them by account and or date. In fact the organize function 
> in Numbers does a good job of breaking them up by account.
> 
> Certainly, not the only way to solve the problem, but it is a method that has 
> worked for me.
> 
> Will
> 
> 
> On 2020 Jun 18, at 06-18 16:53:07, Scott Soderling  wrote:
> 
> Windows 10, GnuCash 3.10 I've been using GnuCash for several years now for
> my personal use. I am now a treasurer of a members association at a golf
> club, which has used other software to do their accounting. I would like to
> transition to using GnuCash.
> 
> My questions are around report generation. For my personal use, it hasn't
> been that important. However with the club, balance sheets, income
> statements, budget reports, etc will now become important, getting the
> report into the format I like on the screen, and then to print.
> 
> I've been reading through the GC documentation and experimenting. Between
> using the options available within individual reports, along with trying
> different Style Sheets, I am encouraged that there is potential to tweak
> the report formats to my liking.
> 
> When I look at the drop down list of Style Sheets, I see the following: CSS
> (experimental), Default, Easy, Footer, Head orTail, Technicolor. After
> trying them out, I've made the following conclusions (I'm leaving out the
> experimental one for now):
> 
> *Default Style Sheet *- The entire report is left justified on the screen
> and page, Quite basic, limited color, no images. However this is the ONLY
> place that the "Table border width" setting actually does something -
> border around the entire report along with grid lines around every cell.
> This setting does nothing in any of the other Style Sheets that I can see.
> 
> *Easy, Footer, and Technicolor Style Sheets* - Report is centered on the
> screen and page, more options than Default. Unless I'm missing something,
> they are identical.
> 
> *Head or Tail Style Sheet* - Similar to the above three sheets, with more
> data displayed in either the header or footer area of the report.
> 
> Now some questions.
> 
> 1. Why are the Easy, Footer and Technicolor style sheets all the same?
> 2. Why does the "Table border width" setting only work with the Default
> Style Sheet? I can see instances where that grid effect would be good with
> the other Style Sheets.
> 3. Why aren't printed multi-page reports formatted for each page? Page
> breaks just fall wherever they fall, headings aren't repeated at the top of
> each page, no options for displaying page numbers, etc.
> 
> I think GnuCash is a great piece of software. I'm just trying to understand
> how to get output from it the way I want. Thanks very much for all replies.


___
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] Style Sheets - general questions

2020-06-18 Thread flywire
I was really pleased to be pointed to opening HTML reports directly in LO
Calc last month. I can see CSS is very versatile but I'm not proficient
with it.

Hopefully someone can contribute a quick guide for GnuCash reports at some
stage. I'd be happy with just turning off the white background because the
main thing I do is add extra columns.
___
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-18 Thread w...@theprescotts.com
Scott,

Like you I have used GnuCash for personal use for years and now am using it for 
an organization I belong to. I didn't like the appearance of the standard 
reports. Instead of trying to customize them, I just export the transactions as 
a csv file and open in Apple's Numbers spreadsheet program. From there it is 
quick and easy to copy them to some standard spreadsheets that I use in my 
reports. Because the csv file contains columns with the account names it is 
very easy to sort them by account and or date. In fact the organize function in 
Numbers does a good job of breaking them up by account.

Certainly, not the only way to solve the problem, but it is a method that has 
worked for me.

Will


On 2020 Jun 18, at 06-18 16:53:07, Scott Soderling  wrote:

Windows 10, GnuCash 3.10 I've been using GnuCash for several years now for
my personal use. I am now a treasurer of a members association at a golf
club, which has used other software to do their accounting. I would like to
transition to using GnuCash.

My questions are around report generation. For my personal use, it hasn't
been that important. However with the club, balance sheets, income
statements, budget reports, etc will now become important, getting the
report into the format I like on the screen, and then to print.

I've been reading through the GC documentation and experimenting. Between
using the options available within individual reports, along with trying
different Style Sheets, I am encouraged that there is potential to tweak
the report formats to my liking.

When I look at the drop down list of Style Sheets, I see the following: CSS
(experimental), Default, Easy, Footer, Head orTail, Technicolor. After
trying them out, I've made the following conclusions (I'm leaving out the
experimental one for now):

*Default Style Sheet *- The entire report is left justified on the screen
and page, Quite basic, limited color, no images. However this is the ONLY
place that the "Table border width" setting actually does something -
border around the entire report along with grid lines around every cell.
This setting does nothing in any of the other Style Sheets that I can see.

*Easy, Footer, and Technicolor Style Sheets* - Report is centered on the
screen and page, more options than Default. Unless I'm missing something,
they are identical.

*Head or Tail Style Sheet* - Similar to the above three sheets, with more
data displayed in either the header or footer area of the report.

Now some questions.

1. Why are the Easy, Footer and Technicolor style sheets all the same?
2. Why does the "Table border width" setting only work with the Default
Style Sheet? I can see instances where that grid effect would be good with
the other Style Sheets.
3. Why aren't printed multi-page reports formatted for each page? Page
breaks just fall wherever they fall, headings aren't repeated at the top of
each page, no options for displaying page numbers, etc.

I think GnuCash is a great piece of software. I'm just trying to understand
how to get output from it the way I want. Thanks very much for all replies.

Scott
___
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] Style Sheets - general questions

2020-06-18 Thread Scott Soderling
Windows 10, GnuCash 3.10 I've been using GnuCash for several years now for
my personal use. I am now a treasurer of a members association at a golf
club, which has used other software to do their accounting. I would like to
transition to using GnuCash.

My questions are around report generation. For my personal use, it hasn't
been that important. However with the club, balance sheets, income
statements, budget reports, etc will now become important, getting the
report into the format I like on the screen, and then to print.

I've been reading through the GC documentation and experimenting. Between
using the options available within individual reports, along with trying
different Style Sheets, I am encouraged that there is potential to tweak
the report formats to my liking.

When I look at the drop down list of Style Sheets, I see the following: CSS
(experimental), Default, Easy, Footer, Head orTail, Technicolor. After
trying them out, I've made the following conclusions (I'm leaving out the
experimental one for now):

*Default Style Sheet *- The entire report is left justified on the screen
and page, Quite basic, limited color, no images. However this is the ONLY
place that the "Table border width" setting actually does something -
border around the entire report along with grid lines around every cell.
This setting does nothing in any of the other Style Sheets that I can see.

*Easy, Footer, and Technicolor Style Sheets* - Report is centered on the
screen and page, more options than Default. Unless I'm missing something,
they are identical.

*Head or Tail Style Sheet* - Similar to the above three sheets, with more
data displayed in either the header or footer area of the report.

Now some questions.

1. Why are the Easy, Footer and Technicolor style sheets all the same?
2. Why does the "Table border width" setting only work with the Default
Style Sheet? I can see instances where that grid effect would be good with
the other Style Sheets.
3. Why aren't printed multi-page reports formatted for each page? Page
breaks just fall wherever they fall, headings aren't repeated at the top of
each page, no options for displaying page numbers, etc.

I think GnuCash is a great piece of software. I'm just trying to understand
how to get output from it the way I want. Thanks very much for all replies.

Scott
___
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-18 Thread Alton Brantley
Are you, by chance, using the “Import transactions from CSV” capability to 
update your accounts?

If so, you should be aware that sometimes the transaction matched is one that 
has already been reconciled, so it appears that the transaction has been added 
when, in fact, it has updated a previously reconciled transaction, replaced it 
as a “cleared” transaction, and then rereconciles it, leaving the account 
showing a missing transaction.

___
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-18 Thread Carl
   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.
   Thanks, all,
   Carl
 __

   From: D. [[1]mailto:sunfis...@yahoo.com]
   Subject: [GNC] Disappearing entries
   Date: Thursday, June 18, 2020, 2:34 PM
   To: Carl
   Cc: Michael Hendry; Gnucash Users

Hard to say how bad this is. I'd start with the newest data file (by modificatio
n date) that does NOT include the 14-digit timestamp, and see what was there. Th
at may or may not be the file named "GC January 12 2019.gnucash". More likely it
's newer ("GC January 15 2020.gnucash", for example).

You would then be able to tell how many different times you opened a backup by s
eeing how many log files were created after that last file. Working on a spare c
opy of that last file, you could try running the log files dated afterward to re
create the work. This may or may not work, depending on whether you changed the
account structure. If it works, great. If not, you'll have to recreate the trans
actions manually.

I avoid this problem by only having one simply named basic data file in my data
directory (in my case, "accounts.gnucash"). Backups and dated storage copies get
 placed in remote folders to keep the idiot from screwing things up (which he is
 very good at!).

David T.


 Original Message 
From: [2]l...@ipadring.net
Sent: Thu Jun 18 13:32:14 EDT 2020
To: "D." [3], Michael Hendry [4]
Cc: Derek Atkins [5], Gnucash Users [6]
Subject: Re: [GNC] Disappearing entries

Ok, how do I fix this...or what file should I use?

Carl

On June 18, 2020 4:50:11 PM UTC, "D." [7] wrote:

I'd definitely agree that his data is forked. Both ways!


 Original Message 
From: Michael Hendry [8]
Sent: Thu Jun 18 12:27:13 EDT 2020
To: Derek Atkins [9]
Cc: [10]gnucash-user@gnucash.org, Carl [11]
Subject: Re: [GNC] Disappearing entries


On 18 Jun 2020, at 17:22, Derek Atkins [12] wrote:

Hi,

On Thu, June 18, 2020 11:48 am, Carl wrote:


   Here's the command that's used- gnucash %f

Hmm.. This could be part of the issue.  %f probably means "filename".

So

if you click a file it'll open that one directly and not the main

file.


Below is the name of my GC file (regardless of the name of the

file

below the date and time stamp on the file.on the far   right

of

the file manager...is current for when I last used the   file-

June 17

2020 at 7 PM
 GC January 12 2019.gnucash.20190518080326.gnucash

AND... here we have what could be part of your issue.  This is a

backup

file.  Specifically, this is a backup file that was generated on May

18,

2019 (at 8:03 am).  So at SOME point you started working from a

year-old

backup file.  It's unclear when that happened.  But you have most

likely

forked your data.

Is that a minced oath?

Michael

___
gnucash-user mailing list
[13]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[14]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
[15]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.

References

   1. mailto:sunfis...@yahoo.com
   2. mailto:l...@ipadring.net
   3. mailto:sunfis...@yahoo.com
   4. mailto:hendry.mich...@gmail.com
   5. mailto:de...@ihtfp.com
   6. mailto:gnucash-user@gnucash.org
   7. mailto:sunfis...@yahoo.com
   8. mailto:hendry.mich...@gmail.com
   9. mailto:de...@ihtfp.com
  10. mailto:gnucash-user@gnucash.org
  11. mailto:l...@ipadring.net
  12. mailto:de...@ihtfp.com
  13. mailto:gnucash-user@gnucash.org
  14. https://lists.gnucash.org/mailman/listinfo/gnucash-user
  15. https://wiki.gnucash.org/wiki/Mailing_Lists
___
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-18 Thread D. via gnucash-user
Hard to say how bad this is. I'd start with the newest data file (by 
modification date) that does NOT include the 14-digit timestamp, and see what 
was there. That may or may not be the file named "GC January 12 2019.gnucash". 
More likely it's newer ("GC January 15 2020.gnucash", for example).

You would then be able to tell how many different times you opened a backup by 
seeing how many log files were created after that last file. Working on a spare 
copy of that last file, you could try running the log files dated afterward to 
recreate the work. This may or may not work, depending on whether you changed 
the account structure. If it works, great. If not, you'll have to recreate the 
transactions manually. 

I avoid this problem by only having one simply named basic data file in my data 
directory (in my case, "accounts.gnucash"). Backups and dated storage copies 
get placed in remote folders to keep the idiot from screwing things up (which 
he is very good at!).

David T. 


 Original Message 
From: l...@ipadring.net
Sent: Thu Jun 18 13:32:14 EDT 2020
To: "D." , Michael Hendry 
Cc: Derek Atkins , Gnucash Users 
Subject: Re: [GNC] Disappearing entries

Ok, how do I fix this...or what file should I use?

Carl

On June 18, 2020 4:50:11 PM UTC, "D."  wrote:
>I'd definitely agree that his data is forked. Both ways!
>
>
> Original Message 
>From: Michael Hendry 
>Sent: Thu Jun 18 12:27:13 EDT 2020
>To: Derek Atkins 
>Cc: gnucash-user@gnucash.org, Carl 
>Subject: Re: [GNC] Disappearing entries
>
>> On 18 Jun 2020, at 17:22, Derek Atkins  wrote:
>> 
>> Hi,
>> 
>> On Thu, June 18, 2020 11:48 am, Carl wrote:
>> 
>>>Here's the command that's used- gnucash %f
>> 
>> Hmm.. This could be part of the issue.  %f probably means "filename".
> So
>> if you click a file it'll open that one directly and not the main
>file.
>> 
>> 
>>> Below is the name of my GC file (regardless of the name of the  
>file
>>> below the date and time stamp on the file.on the far   right
>of
>>> the file manager...is current for when I last used the   file-
>June 17
>>> 2020 at 7 PM
>>>  GC January 12 2019.gnucash.20190518080326.gnucash
>> 
>> AND... here we have what could be part of your issue.  This is a
>backup
>> file.  Specifically, this is a backup file that was generated on May
>18,
>> 2019 (at 8:03 am).  So at SOME point you started working from a
>year-old
>> backup file.  It's unclear when that happened.  But you have most
>likely
>> forked your data.
>
>Is that a minced oath?
>
>Michael
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.

___
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-18 Thread look
Ok, how do I fix this...or what file should I use?

Carl

On June 18, 2020 4:50:11 PM UTC, "D."  wrote:
>I'd definitely agree that his data is forked. Both ways!
>
>
> Original Message 
>From: Michael Hendry 
>Sent: Thu Jun 18 12:27:13 EDT 2020
>To: Derek Atkins 
>Cc: gnucash-user@gnucash.org, Carl 
>Subject: Re: [GNC] Disappearing entries
>
>> On 18 Jun 2020, at 17:22, Derek Atkins  wrote:
>> 
>> Hi,
>> 
>> On Thu, June 18, 2020 11:48 am, Carl wrote:
>> 
>>>Here's the command that's used- gnucash %f
>> 
>> Hmm.. This could be part of the issue.  %f probably means "filename".
> So
>> if you click a file it'll open that one directly and not the main
>file.
>> 
>> 
>>> Below is the name of my GC file (regardless of the name of the  
>file
>>> below the date and time stamp on the file.on the far   right
>of
>>> the file manager...is current for when I last used the   file-
>June 17
>>> 2020 at 7 PM
>>>  GC January 12 2019.gnucash.20190518080326.gnucash
>> 
>> AND... here we have what could be part of your issue.  This is a
>backup
>> file.  Specifically, this is a backup file that was generated on May
>18,
>> 2019 (at 8:03 am).  So at SOME point you started working from a
>year-old
>> backup file.  It's unclear when that happened.  But you have most
>likely
>> forked your data.
>
>Is that a minced oath?
>
>Michael
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
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-18 Thread D. via gnucash-user
I'd definitely agree that his data is forked. Both ways!


 Original Message 
From: Michael Hendry 
Sent: Thu Jun 18 12:27:13 EDT 2020
To: Derek Atkins 
Cc: gnucash-user@gnucash.org, Carl 
Subject: Re: [GNC] Disappearing entries

> On 18 Jun 2020, at 17:22, Derek Atkins  wrote:
> 
> Hi,
> 
> On Thu, June 18, 2020 11:48 am, Carl wrote:
> 
>>Here's the command that's used- gnucash %f
> 
> Hmm.. This could be part of the issue.  %f probably means "filename".  So
> if you click a file it'll open that one directly and not the main file.
> 
> 
>> Below is the name of my GC file (regardless of the name of the   file
>> below the date and time stamp on the file.on the far   right of
>> the file manager...is current for when I last used the   file- June 17
>> 2020 at 7 PM
>>  GC January 12 2019.gnucash.20190518080326.gnucash
> 
> AND... here we have what could be part of your issue.  This is a backup
> file.  Specifically, this is a backup file that was generated on May 18,
> 2019 (at 8:03 am).  So at SOME point you started working from a year-old
> backup file.  It's unclear when that happened.  But you have most likely
> forked your data.

Is that a minced oath?

Michael

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

___
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-18 Thread Michael Hendry
> On 18 Jun 2020, at 17:22, Derek Atkins  wrote:
> 
> Hi,
> 
> On Thu, June 18, 2020 11:48 am, Carl wrote:
> 
>>Here's the command that's used- gnucash %f
> 
> Hmm.. This could be part of the issue.  %f probably means "filename".  So
> if you click a file it'll open that one directly and not the main file.
> 
> 
>> Below is the name of my GC file (regardless of the name of the   file
>> below the date and time stamp on the file.on the far   right of
>> the file manager...is current for when I last used the   file- June 17
>> 2020 at 7 PM
>>  GC January 12 2019.gnucash.20190518080326.gnucash
> 
> AND... here we have what could be part of your issue.  This is a backup
> file.  Specifically, this is a backup file that was generated on May 18,
> 2019 (at 8:03 am).  So at SOME point you started working from a year-old
> backup file.  It's unclear when that happened.  But you have most likely
> forked your data.

Is that a minced oath?

Michael

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


Re: [GNC] Will Image Attachments go through the email list server?

2020-06-18 Thread Adrien Monteleone
In a worst case, use a free file host and post the link.

Regards,
Adrien

> On Jun 18, 2020 w25d170, at 11:24 AM, Derek Atkins  wrote:
> 
> The list server will strip out HTML (with embedded images) and only send
> through the text, but if you actually *attach* the file it'll make it
> through.
> 
> -derek
> 
> On Thu, June 18, 2020 11:56 am, Fran_3 via gnucash-user wrote:
>> Just wondering if I can include an image file with a post?
>> 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] Will Image Attachments go through the email list server?

2020-06-18 Thread Derek Atkins
The list server will strip out HTML (with embedded images) and only send
through the text, but if you actually *attach* the file it'll make it
through.

-derek

On Thu, June 18, 2020 11:56 am, Fran_3 via gnucash-user wrote:
> Just wondering if I can include an image file with a post?
> 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.
>


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

2020-06-18 Thread Derek Atkins
Hi,

On Thu, June 18, 2020 11:48 am, Carl wrote:

> Here's the command that's used- gnucash %f

Hmm.. This could be part of the issue.  %f probably means "filename".  So
if you click a file it'll open that one directly and not the main file.


> Below is the name of my GC file (regardless of the name of the   file
> below the date and time stamp on the file.on the far   right of
> the file manager...is current for when I last used the   file- June 17
> 2020 at 7 PM
>   GC January 12 2019.gnucash.20190518080326.gnucash

AND... here we have what could be part of your issue.  This is a backup
file.  Specifically, this is a backup file that was generated on May 18,
2019 (at 8:03 am).  So at SOME point you started working from a year-old
backup file.  It's unclear when that happened.  But you have most likely
forked your data.

-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] Will Image Attachments go through the email list server?

2020-06-18 Thread Fred Bone
On 18 June 2020 at 15:56, Fran_3 said:

> Just wondering if I can include an image file with a post?

Plenty of people do. Whether you can might depend on your email client.

___
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] Will Image Attachments go through the email list server?

2020-06-18 Thread Fran_3 via gnucash-user
Just wondering if I can include an image file with a post?
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] New Bill: Bill ID vs Billing ID

2020-06-18 Thread Fran_3 via gnucash-user
 Thanks to all for responding to this.
For now we have decided to make up our own definitions for the two fields...
Bill ID: we leave it blank so GnuCash auto numbers it for us.
Billing ID: we enter the Vendor's Bill number aka their "Invoice" number. If 
the vendor does not put an Invoice Number on their Bill to us then we enter the 
vendor's initials plus the due month and year like... 
gdJun20 for a GoDaddy bill due June, 2020
Thanks again for all the response to this OP.


On Wednesday, June 17, 2020, 12:29:38 PM EDT, Derek Atkins 
 wrote:  
 
 Hi,

Fran_3 via gnucash-user  writes:

> In 7.10.1 are the field definitions for a New Bill from a
> vendor... two of them are...
>
> Invoice Info - Invoice ID (optional) - the identification number of
> the invoice as emitted by the vendor (IE: the vendor’s internal number
> for this invoice).
> Billing Info - Billing ID (optional) - the vendor’s ID for the bill
> (e.g.: their invoice #).
> This is confusing to me as follows...
> On Bills we receive from vendors we often find a number on the
> document we use to identify it...1 - Vendor's Bill Number

The idea is that both you and the other entity might have your own
unique identifiers for the Bill or Invoice, so this lets you put them
both on.  This boils down to "naming is hard".

When you send out an Invoice to a customer you have your invoice number
on it, but the customer may want something on it (like a PO#).

When you receive a Bill from a vendor it will have their invoice# on it,
but you might want your own counter for it.

This is why there are two cases.

These numbers are irrespective of due dates.

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

2020-06-18 Thread Carl
 __

   From: Derek Atkins [[1]mailto:de...@ihtfp.com]
   Subject: [GNC] Disappearing entries
   Date: Thursday, June 18, 2020, 11:27 AM
   To: Carl
   Cc: [2]gnucash-user@gnucash.org

Hi,

Carl [3] writes:

Okay, so you're on current GnuCash on Linux.  Good.


3) How do you open GnuCash and/or the GnuCash data file?

   I click on a shortcut link on my desktop

What, exactly, is the shortcut running?  What is the embedded "commandline"?
Is it a link to a file or the app directly?
(I'm just wondering if, by chance, you're opening a backup file).

   Here's the command that's used- gnucash %f

4) How are you shutting down GnuCash?

   I click "Save"if not previously saved and then click the X in the
   top left of the GC screen

Okay, just making sure you don't shutdown the computer with GnuCash
still running.


   5) What backend storage method are you using?

   Don't know exactly what that means?  Maybe it means where and how is
   the gc work file stored?  It's local.

The question is more, is it XML or SQL?  Both could be local.
If you run "file /path/to/your/datafile.gnucash" what does it say?
If it says 'gzip' then it's XML.

   I assume it's xml as when in GC I used File>Save as-> and the
   format it presented was xml

   Below is the name of my GC file (regardless of the name of the file
   below the date and time stamp on the file.on the far right of the
   file manager...is current for when I last used the file- June 17 2020
   at 7 PM
   GC January 12 2019.gnucash.20190518080326.gnucash

6) Are you SURE that you're not somehow modifying a reconciled transaction
from the other side?

   Yes, very sure.

GnuCash is very unlikely to have lost your data.  When these kinds of
errors occur, they are ostensibly an PEBKAC issue, either a view that
hides the data, a non-default sort that makes data look wrong, opening a
backup file instead of the main data file, etc.


   Thanks,

   Carl


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

-derek

References

   1. mailto:de...@ihtfp.com
   2. mailto:gnucash-user@gnucash.org
   3. mailto:l...@ipadring.net
___
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-18 Thread Derek Atkins
Hi,

Carl  writes:

Okay, so you're on current GnuCash on Linux.  Good.

> 3) How do you open GnuCash and/or the GnuCash data file?
>
>I click on a shortcut link on my desktop

What, exactly, is the shortcut running?  What is the embedded "commandline"?
Is it a link to a file or the app directly?
(I'm just wondering if, by chance, you're opening a backup file).

> 4) How are you shutting down GnuCash?
>
>I click "Save"if not previously saved and then click the X in the
>top left of the GC screen

Okay, just making sure you don't shutdown the computer with GnuCash
still running.

>5) What backend storage method are you using?
>
>Don't know exactly what that means?  Maybe it means where and how is
>the gc work file stored?  It's local.

The question is more, is it XML or SQL?  Both could be local.
If you run "file /path/to/your/datafile.gnucash" what does it say?
If it says 'gzip' then it's XML.

> 6) Are you SURE that you're not somehow modifying a reconciled transaction
> from the other side?
>
>Yes, very sure.

GnuCash is very unlikely to have lost your data.  When these kinds of
errors occur, they are ostensibly an PEBKAC issue, either a view that
hides the data, a non-default sort that makes data look wrong, opening a
backup file instead of the main data file, etc.

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


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

2020-06-18 Thread Gio Bacareza
No. I'm just using default

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-18 Thread Adrien Monteleone
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 
>  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.


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

2020-06-18 Thread Christopher Lam
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.
>
___
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.