Re: [GNC] Report - Income Statement - Layout problem

[john]

On the subject of flatpak, some users have reported problems with webkit 
displaying reports since the Gnome41 runtime was updated to WebKitGtk 2.36.0 
earlier this week, see https://bugs.gnucash.org/show_bug.cgi?id=798486 
. The project lead has given 
me a couple of suggestions that I'll include in the 4.10 flatpak build 
tomorrow, and if those don't work there's a workaround in the bug report. 

Regards,
John Ralls


> On Mar 26, 2022, at 7:35 PM, Adrien Monteleone 
>  wrote:
> 
> And there is always the Flatpak. So if you aren't comfortable with building, 
> it is a bit easier to install.
> 
> Since freeze on Ubuntu 22.04 Jammy has already happened (release targeted to 
> 4/21/22), I doubt it will include GnuCash 4.10, lucky if it is 4.9.
> 
> You *might* be able to get a special request through for 4.10 to whomever the 
> package maintainer is, but that might be out of their hands.
> 
> Regards,
> Adrien
> 
> On 3/26/22 7:07 PM, Liz wrote:
>> On Sat, 26 Mar 2022 23:58:16 +0100
>> Carl-Kensaku HERBORT  wrote:
>>> But I will test it with my current one as soon as the 4.10 version
>>> comes to Ubuntu (or if it takes too long, I will download it
>>> manually) and let you know if it works on my end.
>> Ubuntu seems to be very slow getting updated Gnucash versions, building
>> it yourself would be worthwhile and should be much less than 3 months.
> 
> ___
> 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] Report - Income Statement - Layout problem

[Adrien Monteleone]

And there is always the Flatpak. So if you aren't comfortable with 
building, it is a bit easier to install.


Since freeze on Ubuntu 22.04 Jammy has already happened (release 
targeted to 4/21/22), I doubt it will include GnuCash 4.10, lucky if it 
is 4.9.


You *might* be able to get a special request through for 4.10 to 
whomever the package maintainer is, but that might be out of their hands.


Regards,
Adrien

On 3/26/22 7:07 PM, Liz wrote:

On Sat, 26 Mar 2022 23:58:16 +0100
Carl-Kensaku HERBORT  wrote:


But I will test it with my current one as soon as the 4.10 version
comes to Ubuntu (or if it takes too long, I will download it
manually) and let you know if it works on my end.


Ubuntu seems to be very slow getting updated Gnucash versions, building
it yourself would be worthwhile and should be much less than 3 months.


___
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] Report - Income Statement - Layout problem

[Liz]

On Sat, 26 Mar 2022 23:58:16 +0100
Carl-Kensaku HERBORT  wrote:

> But I will test it with my current one as soon as the 4.10 version
> comes to Ubuntu (or if it takes too long, I will download it
> manually) and let you know if it works on my end.

Ubuntu seems to be very slow getting updated Gnucash versions, building
it yourself would be worthwhile and should be much less than 3 months.

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

Re: [GNC] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Hello,

That's great news ! Big thanks to the developers !

My next income statement report is not due for a year (or 3 months at 
earliest).


But I will test it with my current one as soon as the 4.10 version comes 
to Ubuntu (or if it takes too long, I will download it manually) and let 
you know if it works on my end.


Have a nice week-end !

Best regards

Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 26.03.22 à 13:09, Adrien Monteleone a écrit :

Carl-Kensaku,

It looks like the fix has been implemented for v4.10 due out tomorrow.

I just finished testing Chris's fix and so far it seems to do the trick.

Your P&L/Income Statements should line up now regardless of the account 
depth or the length of account names.


Regards,
Adrien

On 3/23/22 10:32 AM, Carl-Kensaku HERBORT wrote:

Hello,

Yes, I know all that. I love doing bash scripting.

But thanks for taking the time to explain (might benefit someone else 
too).


___
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] Report - Income Statement - Layout problem

[Adrien Monteleone]

Carl-Kensaku,

It looks like the fix has been implemented for v4.10 due out tomorrow.

I just finished testing Chris's fix and so far it seems to do the trick.

Your P&L/Income Statements should line up now regardless of the account 
depth or the length of account names.


Regards,
Adrien

On 3/23/22 10:32 AM, Carl-Kensaku HERBORT wrote:

Hello,

Yes, I know all that. I love doing bash scripting.

But thanks for taking the time to explain (might benefit someone else too).


___
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] Report - Income Statement - Layout problem

[Adrien Monteleone]

And indeed, I just tested this in LibreOffice.

Both methods work to automatically resize the columns to line up, though 
export/open retains fonts, background, etc.


Select-All followed by Copy/Paste into a blank sheet brings up the Text 
Import dialog, and I left the default options.


This method will stick everything in the spreadsheet cells with no 
formatting carried over. (it will insert as plain text, so your 
spreadsheet styles will override)


You may find this easier as you can define your spreadsheet styles 
perhaps more intuitively using an office app than via CSS in GnuCash.


Then simply multi-select and apply those styles to the relevant cells.

The amount of setup work you need to do just depends on how you want it 
to look and how often you need to do this. Templates can help here 
considerably.


Regards,
Adrien

On 3/23/22 12:34 PM, Adrien Monteleone wrote:

Carl-Kensaku,

No need to dig into Scheme or HTML to fix this.

The devs will address it soon enough I'm sure, but this is a 
'presentation' issue.


That can always be fixed in the short term by either exporting and 
opening in a spreadsheet, or Select-All & Copy/Paste to a spreadsheet.


 From there you can easily fix the first label column to the same size. 
(it might even do it automatically since it will import both tables into 
one sheet)


Many people make their reports 'pretty' using spreadsheet apps. It also 
allows for additional math that would be difficult to write having to 
learn Scheme. (such as Variance columns or other various aggregate 
subtotals)


___
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] Report - Income Statement - Layout problem

[Adrien Monteleone]

Carl-Kensaku,

No need to dig into Scheme or HTML to fix this.

The devs will address it soon enough I'm sure, but this is a 
'presentation' issue.


That can always be fixed in the short term by either exporting and 
opening in a spreadsheet, or Select-All & Copy/Paste to a spreadsheet.


From there you can easily fix the first label column to the same size. 
(it might even do it automatically since it will import both tables into 
one sheet)


Many people make their reports 'pretty' using spreadsheet apps. It also 
allows for additional math that would be difficult to write having to 
learn Scheme. (such as Variance columns or other various aggregate 
subtotals)


Regards,
Adrien

On 3/23/22 10:26 AM, Carl-Kensaku HERBORT wrote:

Hello,

Yes, I know GnuCash is an open-source volunteer effort, hence all the 
thank you, and answering sometimes to the same questions several times 
from different people. It's normal in a volunteer project.


I am myself a long-time grateful and enthusiastic open-source software 
user and IRL helper (you won't find me in many forums answering 
questions but I am doing it in the physical world).


But, I don't think users should be sorry or ashamed to have some level 
of expectation that a software will work when it comes to a core, basic 
and widely used/needed function (even if it is an open-source volunteer 
project). For most SMEs (at least in my country), the whole point and 
sole purpose of an accounting software is to produce two reports: Income 
Statement and Balance Sheet (non-multicolumn). It is a legal requirement 
for most SMEs for the tax declaration and other formalities.


It didn't work out in GnuCash (so far). No problem, no hard feelings and 
certainly no blame: it is a wonderful piece of software. And I am happy 
if it gets solved sometime in the future by some hard-working generous 
programmers giving their free time.


But I will not feel sorry or ashamed to just have expectations.

On the other hand, I am really sorry if that hurt your feelings, that 
wasn't the intent. My apologies.


Again, thank you all so much for all your help.


___
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] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Hello,

Yes, I know all that. I love doing bash scripting.

But thanks for taking the time to explain (might benefit someone else too).

Thank you very much

Best regards,

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 23.03.22 à 16:26, Michael or Penny Novack a écrit :

On 3/23/2022 9:48 AM, Carl-Kensaku HERBORT wrote:

I already have to use two separate software: an ERP/CRM for invoicing 
and daily accounting and GnuCash for heavier monthly/yearly 
accounting, mainly to produce the Income Statement Report and Balance 
Sheet report (or so was my plan). I didn't know that GnuCash was not 
made for that and that a third software (or SCHEME/HTML coding & 
modifications) was needed just to get even basic reports that all SME 
business need.


I guess there is a first for everything: I am giving up. 



Hopefully you are still here to read this, but if not, might clarify a 
misconception others might also have.


That an "application" might not all be implemented in the same computer 
language does NOT make it "multiple software". In fact, it is advisable 
to design any sizeable program in pieces (for SEVERAL reasons) and the 
pieces can be in different languages, choosing the language based on 
what makes that part easier to code. Keep in mind that the pieces, once 
compiled, aren't "in" their source code language any more.


OK, all the programmers in a large "shop" might not know all of the 
languages and so only work on a part of the system whee they do know the 
language. Others, like myself, might be fluent in all the main languages 
used and a least be able to read all of them.


You CAN write anything in any "complete" computer language but some are 
particularly well suited to some task but clumsy for other things. To 
give you an example, early in my working days, when learning the IBM 
mainframe string processing language CLIST I came up with a "case 
problem" for myself, a "palindrome tester" -- prompts the user to enter 
a string and reports if that string is a palindrome (by TEXT palindrome 
rules, not mathematical palindrome rules which it trivial) and then asks 
the user for another or to quit. After that I used this "case problem" 
with every new language I learned to investigate its string processing 
capability. Typically a program of a hundred or two lines. But if having 
the standard tools of any 'nix operating system (linux, for example) can 
be done in bash + the library of standard 'nix utilities in about 5 
lines (say a hundred or two CHARACTERS).


BUT  this is very much to the point here. Gnucash is accounting 
software. I expect it to be able to do THAT well. I do not expect of it 
the capabilities of a powerful general purpose editor (program designed 
to edit/format data). So while I could get by in SCHEME (not fluent in 
LISP but can read it OK and it doesn't take me long to learn another 
language) I do NOT try to edit gnucash reports IN GNUCASH. I don't care 
how messed up in appearance as long as all the DATA is present in the 
report and correct. I can simply export the raw report and then edit to 
my heart's content with a powerful editor designed for THAT purpose.


Michael D Novack

___
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] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Hello,

Yes, I know GnuCash is an open-source volunteer effort, hence all the 
thank you, and answering sometimes to the same questions several times 
from different people. It's normal in a volunteer project.


I am myself a long-time grateful and enthusiastic open-source software 
user and IRL helper (you won't find me in many forums answering 
questions but I am doing it in the physical world).


But, I don't think users should be sorry or ashamed to have some level 
of expectation that a software will work when it comes to a core, basic 
and widely used/needed function (even if it is an open-source volunteer 
project). For most SMEs (at least in my country), the whole point and 
sole purpose of an accounting software is to produce two reports: Income 
Statement and Balance Sheet (non-multicolumn). It is a legal requirement 
for most SMEs for the tax declaration and other formalities.


It didn't work out in GnuCash (so far). No problem, no hard feelings and 
certainly no blame: it is a wonderful piece of software. And I am happy 
if it gets solved sometime in the future by some hard-working generous 
programmers giving their free time.


But I will not feel sorry or ashamed to just have expectations.

On the other hand, I am really sorry if that hurt your feelings, that 
wasn't the intent. My apologies.


Again, thank you all so much for all your help.

Best regards

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 23.03.22 à 15:21, Christopher Lam a écrit :
Please be aware that GnuCash is a volunteer effort. In so many (20+) 
years of users there have been no complaints about this particular 
layout issue in the Income Statement. A fresh pair of eyes, however, 
found this genuine layout issue. The Multicolumn Income Statement report 
in the Experimental menu may be more suitable; it is much more capable 
and has a more conventional layout.


Meanwhile, now that this is now known, and Adrien has kindly found the 
root cause, it is likely that the developers will be able to fix the 
Income Statement.


On Wed, 23 Mar 2022 at 13:49, Carl-Kensaku HERBORT > wrote:


Hello,

Thanks to everyone for your help and time.

It is a shame that it is so complicated to make the Income Statement
report look normal, like the Balance Sheet report, which also has two
sections (Assets and Liabilities) that have no problem at all.

I already have to use two separate software: an ERP/CRM for invoicing
and daily accounting and GnuCash for heavier monthly/yearly accounting,
mainly to produce the Income Statement Report and Balance Sheet report
(or so was my plan). I didn't know that GnuCash was not made for that
and that a third software (or SCHEME/HTML coding & modifications) was
needed just to get even basic reports that all SME business need.

I guess there is a first for everything: I am giving up.

Again, thanks a lot to everyone who took on their free time to
answer my
questions.

Have a nice day

Best regards

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 22.03.22 à 05:24, Adrien Monteleone a écrit :
 > I stand corrected, this can happen regardless of the depth
preference.
 >
 > The issue is entirely caused (best I can tell) by using separate
tables
 > for the Income & Expense sections.
 >
 > Since the browser will adjust the label column to fit the
content, if
 > those content widths differ, you'll see misalignment.
 >
 > In my case, due to some long account names, my Income section was
 > slightly wider than the Expense section despite being depth
limited to
 > 4. (the reverse of the OP's image and what I found at depth > 4)
 >
 > The quickest solution is simply to put the Income & Expense
sections in
 > one HTML table element. This will cause the browser to size all
1st 
 > elements on each row to the same maximum to fit the widest content.
 > (effectively sizing the first column all the same)
 >
 > There might be a complication with the ordering since there is a
report
 > option to turn off 'default Income section first' in the report.
 >
 > One small additional issue, is that this approach provides no
spacing
 > between sections.
 >
 > This can be solved by adding:
 >
 > 
 >      
 >       
 >      
 > 
 >
 > after the first section's total row. (this generates a blank
table row
 > with content height as a visual spacer, which can be adjusted with a
 > font-size declaration if desired.)
 >
 > I don't like that approach, but it is quick and easy. (the report
HTML
 > is full of presentation hacks, and one such hack, possibly
causing this
 > problem, is the use of   being inserted as an account label
   

Re: [GNC] Report - Income Statement - Layout problem

[Michael or Penny Novack]

On 3/23/2022 9:48 AM, Carl-Kensaku HERBORT wrote:

I already have to use two separate software: an ERP/CRM for invoicing 
and daily accounting and GnuCash for heavier monthly/yearly 
accounting, mainly to produce the Income Statement Report and Balance 
Sheet report (or so was my plan). I didn't know that GnuCash was not 
made for that and that a third software (or SCHEME/HTML coding & 
modifications) was needed just to get even basic reports that all SME 
business need.


I guess there is a first for everything: I am giving up. 



Hopefully you are still here to read this, but if not, might clarify a 
misconception others might also have.


That an "application" might not all be implemented in the same computer 
language does NOT make it "multiple software". In fact, it is advisable 
to design any sizeable program in pieces (for SEVERAL reasons) and the 
pieces can be in different languages, choosing the language based on 
what makes that part easier to code. Keep in mind that the pieces, once 
compiled, aren't "in" their source code language any more.


OK, all the programmers in a large "shop" might not know all of the 
languages and so only work on a part of the system whee they do know the 
language. Others, like myself, might be fluent in all the main languages 
used and a least be able to read all of them.


You CAN write anything in any "complete" computer language but some are 
particularly well suited to some task but clumsy for other things. To 
give you an example, early in my working days, when learning the IBM 
mainframe string processing language CLIST I came up with a "case 
problem" for myself, a "palindrome tester" -- prompts the user to enter 
a string and reports if that string is a palindrome (by TEXT palindrome 
rules, not mathematical palindrome rules which it trivial) and then asks 
the user for another or to quit. After that I used this "case problem" 
with every new language I learned to investigate its string processing 
capability. Typically a program of a hundred or two lines. But if having 
the standard tools of any 'nix operating system (linux, for example) can 
be done in bash + the library of standard 'nix utilities in about 5 
lines (say a hundred or two CHARACTERS).


BUT  this is very much to the point here. Gnucash is accounting 
software. I expect it to be able to do THAT well. I do not expect of it 
the capabilities of a powerful general purpose editor (program designed 
to edit/format data). So while I could get by in SCHEME (not fluent in 
LISP but can read it OK and it doesn't take me long to learn another 
language) I do NOT try to edit gnucash reports IN GNUCASH. I don't care 
how messed up in appearance as long as all the DATA is present in the 
report and correct. I can simply export the raw report and then edit to 
my heart's content with a powerful editor designed for THAT purpose.


Michael D Novack

___
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] Report - Income Statement - Layout problem

[Christopher Lam]

Please be aware that GnuCash is a volunteer effort. In so many (20+) years
of users there have been no complaints about this particular layout issue
in the Income Statement. A fresh pair of eyes, however, found this genuine
layout issue. The Multicolumn Income Statement report in the Experimental
menu may be more suitable; it is much more capable and has a more
conventional layout.

Meanwhile, now that this is now known, and Adrien has kindly found the root
cause, it is likely that the developers will be able to fix the Income
Statement.

On Wed, 23 Mar 2022 at 13:49, Carl-Kensaku HERBORT  wrote:

> Hello,
>
> Thanks to everyone for your help and time.
>
> It is a shame that it is so complicated to make the Income Statement
> report look normal, like the Balance Sheet report, which also has two
> sections (Assets and Liabilities) that have no problem at all.
>
> I already have to use two separate software: an ERP/CRM for invoicing
> and daily accounting and GnuCash for heavier monthly/yearly accounting,
> mainly to produce the Income Statement Report and Balance Sheet report
> (or so was my plan). I didn't know that GnuCash was not made for that
> and that a third software (or SCHEME/HTML coding & modifications) was
> needed just to get even basic reports that all SME business need.
>
> I guess there is a first for everything: I am giving up.
>
> Again, thanks a lot to everyone who took on their free time to answer my
> questions.
>
> Have a nice day
>
> Best regards
>
> --
> Carl-Kensaku HERBORT
> DIGIENE
> Case postale
> CH-1002 Lausanne
> Suisse
>
> +41 (0) 21 320 22 66
>
> Le 22.03.22 à 05:24, Adrien Monteleone a écrit :
> > I stand corrected, this can happen regardless of the depth preference.
> >
> > The issue is entirely caused (best I can tell) by using separate tables
> > for the Income & Expense sections.
> >
> > Since the browser will adjust the label column to fit the content, if
> > those content widths differ, you'll see misalignment.
> >
> > In my case, due to some long account names, my Income section was
> > slightly wider than the Expense section despite being depth limited to
> > 4. (the reverse of the OP's image and what I found at depth > 4)
> >
> > The quickest solution is simply to put the Income & Expense sections in
> > one HTML table element. This will cause the browser to size all 1st 
> > elements on each row to the same maximum to fit the widest content.
> > (effectively sizing the first column all the same)
> >
> > There might be a complication with the ordering since there is a report
> > option to turn off 'default Income section first' in the report.
> >
> > One small additional issue, is that this approach provides no spacing
> > between sections.
> >
> > This can be solved by adding:
> >
> > 
> >  
> >   
> >  
> > 
> >
> > after the first section's total row. (this generates a blank table row
> > with content height as a visual spacer, which can be adjusted with a
> > font-size declaration if desired.)
> >
> > I don't like that approach, but it is quick and easy. (the report HTML
> > is full of presentation hacks, and one such hack, possibly causing this
> > problem, is the use of   being inserted as an account label
> > indention mechanism rather than generating additional columns.)
> >
> > I'm not sure of the table semantics with this approach either.
> >
> > Technically, the report is a single entity, so perhaps a single table is
> > better in that regard even though each section has its own subtotal.
> >
> > I did play with adding cell padding-right to the first label-cell and it
> > worked, but that requires some calculation based on which column will
> > end up wider, and very likely a magic number or two for refinement, so
> > that's likely out as a solution.
> >
> > It might also be possible to calculate and add em-based padding-left to
> > the account label cells, (rather than multiple   entities) but that
> > doesn't really solve the variable overall column-width problem. (it just
> > changes how the indention is accomplished)
> >
> > Fixed-width would very likely be a mess too. (and still have to be
> > calculated, and that might break on a per-browser basis)
> >
> > There might still be an out playing with box-sizing and/or display
> > properties but I don't really see any magic happening since the widths
> > are calculated independently.
> >
> > One final stretch might be to play with the size of the containers of
> > the two tables, but I seriously doubt it as that affects overflow
> > usually, not expanding something smaller.
> >
> > Regards,
> > Adrien
> >
> > On 3/21/22 9:47 PM, Adrien Monteleone wrote:
> >> For me, this only happens at depths 5,6, & 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
>

Re: [GNC] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Hello,

Thanks to everyone for your help and time.

It is a shame that it is so complicated to make the Income Statement 
report look normal, like the Balance Sheet report, which also has two 
sections (Assets and Liabilities) that have no problem at all.


I already have to use two separate software: an ERP/CRM for invoicing 
and daily accounting and GnuCash for heavier monthly/yearly accounting, 
mainly to produce the Income Statement Report and Balance Sheet report 
(or so was my plan). I didn't know that GnuCash was not made for that 
and that a third software (or SCHEME/HTML coding & modifications) was 
needed just to get even basic reports that all SME business need.


I guess there is a first for everything: I am giving up.

Again, thanks a lot to everyone who took on their free time to answer my 
questions.


Have a nice day

Best regards

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 22.03.22 à 05:24, Adrien Monteleone a écrit :

I stand corrected, this can happen regardless of the depth preference.

The issue is entirely caused (best I can tell) by using separate tables 
for the Income & Expense sections.


Since the browser will adjust the label column to fit the content, if 
those content widths differ, you'll see misalignment.


In my case, due to some long account names, my Income section was 
slightly wider than the Expense section despite being depth limited to 
4. (the reverse of the OP's image and what I found at depth > 4)


The quickest solution is simply to put the Income & Expense sections in 
one HTML table element. This will cause the browser to size all 1st  
elements on each row to the same maximum to fit the widest content. 
(effectively sizing the first column all the same)


There might be a complication with the ordering since there is a report 
option to turn off 'default Income section first' in the report.


One small additional issue, is that this approach provides no spacing 
between sections.


This can be solved by adding:


     
      
     


after the first section's total row. (this generates a blank table row 
with content height as a visual spacer, which can be adjusted with a 
font-size declaration if desired.)


I don't like that approach, but it is quick and easy. (the report HTML 
is full of presentation hacks, and one such hack, possibly causing this 
problem, is the use of   being inserted as an account label 
indention mechanism rather than generating additional columns.)


I'm not sure of the table semantics with this approach either.

Technically, the report is a single entity, so perhaps a single table is 
better in that regard even though each section has its own subtotal.


I did play with adding cell padding-right to the first label-cell and it 
worked, but that requires some calculation based on which column will 
end up wider, and very likely a magic number or two for refinement, so 
that's likely out as a solution.


It might also be possible to calculate and add em-based padding-left to 
the account label cells, (rather than multiple   entities) but that 
doesn't really solve the variable overall column-width problem. (it just 
changes how the indention is accomplished)


Fixed-width would very likely be a mess too. (and still have to be 
calculated, and that might break on a per-browser basis)


There might still be an out playing with box-sizing and/or display 
properties but I don't really see any magic happening since the widths 
are calculated independently.


One final stretch might be to play with the size of the containers of 
the two tables, but I seriously doubt it as that affects overflow 
usually, not expanding something smaller.


Regards,
Adrien

On 3/21/22 9:47 PM, Adrien Monteleone wrote:

For me, this only happens at depths 5,6, & ALL.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

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

Re: [GNC] Report - Income Statement - Layout problem

[Adrien Monteleone]

I stand corrected, this can happen regardless of the depth preference.

The issue is entirely caused (best I can tell) by using separate tables 
for the Income & Expense sections.


Since the browser will adjust the label column to fit the content, if 
those content widths differ, you'll see misalignment.


In my case, due to some long account names, my Income section was 
slightly wider than the Expense section despite being depth limited to 
4. (the reverse of the OP's image and what I found at depth > 4)


The quickest solution is simply to put the Income & Expense sections in 
one HTML table element. This will cause the browser to size all 1st  
elements on each row to the same maximum to fit the widest content. 
(effectively sizing the first column all the same)


There might be a complication with the ordering since there is a report 
option to turn off 'default Income section first' in the report.


One small additional issue, is that this approach provides no spacing 
between sections.


This can be solved by adding:



 



after the first section's total row. (this generates a blank table row 
with content height as a visual spacer, which can be adjusted with a 
font-size declaration if desired.)


I don't like that approach, but it is quick and easy. (the report HTML 
is full of presentation hacks, and one such hack, possibly causing this 
problem, is the use of   being inserted as an account label 
indention mechanism rather than generating additional columns.)


I'm not sure of the table semantics with this approach either.

Technically, the report is a single entity, so perhaps a single table is 
better in that regard even though each section has its own subtotal.


I did play with adding cell padding-right to the first label-cell and it 
worked, but that requires some calculation based on which column will 
end up wider, and very likely a magic number or two for refinement, so 
that's likely out as a solution.


It might also be possible to calculate and add em-based padding-left to 
the account label cells, (rather than multiple   entities) but that 
doesn't really solve the variable overall column-width problem. (it just 
changes how the indention is accomplished)


Fixed-width would very likely be a mess too. (and still have to be 
calculated, and that might break on a per-browser basis)


There might still be an out playing with box-sizing and/or display 
properties but I don't really see any magic happening since the widths 
are calculated independently.


One final stretch might be to play with the size of the containers of 
the two tables, but I seriously doubt it as that affects overflow 
usually, not expanding something smaller.


Regards,
Adrien

On 3/21/22 9:47 PM, Adrien Monteleone wrote:

For me, this only happens at depths 5,6, & 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] Report - Income Statement - Layout problem

[Adrien Monteleone]

I can reproduce with 4.9 on BigSur.

Investigating using Firefox Inspector to view the HTML, I see that there 
is padding being added to the Expenses section.


For me, this only happens at depths 5,6, & ALL.

It seems the left hand column where the labels are, is expanding to fit 
the depth of accounts requested *and* the text of those account names.


In my case, my Expense depth is greater than my Income depth. (which is 
capped at 4, and thus why I see the bug appear at 5 or higher)


I also happen to have a few accounts with long names, so the effect is 
not as great for me as for the OP, but it seems this string length will 
influence the calculated width.


The effect shows up because the Expense section and the Income section 
are two separate HTML tables, and thus their columns are sizing 
independent of each other to contain their respective content.


One possible fix (while still using tables) is to make the entire report 
a single table though that would of course require a bit of visual 
tweaking to get back to what it looks like now.


In the meantime, I'm investigating replacing the inserted ' ' as an 
account label indention mechanism, with something else. (either another 
empty  and thus another column, or a means to pad the cells via CSS)


There might be a 'non-table' solution, but that too would take quite a 
bit of investigation and a complete re-write of the report(s) affected.


Regards,
Adrien

On 3/20/22 5:02 PM, John Ralls wrote:

I can't reproduce that here. Does that happen with all of the stylesheets? Have 
you perhaps modified the Technicolor stylesheet so that the Revenue block is 
smaller than the Expenses one?


___
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] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Hello,

Yes, it happens with all the stylesheets.

No, I haven't modified any of the stylesheets.

Thank you for your help

Best regards

Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 20.03.22 à 23:02, John Ralls a écrit :

I can't reproduce that here. Does that happen with all of the stylesheets? Have 
you perhaps modified the Technicolor stylesheet so that the Revenue block is 
smaller than the Expenses one?

Regards,
John Ralls



On Mar 20, 2022, at 9:51 AM, Carl-Kensaku HERBORT  wrote:

Hello,

The effective nesting level is the same.

No, I don't need an option to justify columns. I just need the income statement 
report to look as normal as the balance sheet report (see screen capture).

I really don't need anything more.

Have a nice week-end

Best regards

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 20.03.22 à 16:27, Michael or Penny Novack a écrit :

On 3/20/2022 5:21 AM, Carl-Kensaku HERBORT wrote:

Hello again,

I have tried a more recent version on MacOS (Version 4.9 / build ID 
4.9+(2021-12-18) / Finance::Quote:-). It solves the first problem of string 
translation.

But the second problem is still there: the width and column alignment of the 
revenue part is not synchronized with those of the expense part.

Do you have any ideas ?

You did not say  is the effective nesting level of income and expense the 
same?
Even if so, the resulting report would not be what I wanted in a report in the final form I 
would be presenting to the board at meetings or having published in an annual report 
<< I used to be treasurer of some 501(c)3 organizations and used gnucash to keep the 
books >>
I suspect that what you want (from the developers) is an option to "justify columns from the 
right". That's what I would have in the "finished product" reports. In the case of the Income 
Statement (Statement of Revenues and Expenses --- what a non-profit calls this report) but also with Balance 
Sheet reports. Instead of writing custom reports* I export and then edit with full control over the level of 
detail in different parts, column alignment, etc. and can add annotation as needed. There is a lot of detail 
work** in producing a "pretty print" report.
Michael D Novack
* I am a retired pro. While not fluent in the language used to create the reports, I can at 
least read LISP and so soon could be << when you have written in half a dozen 
languages, what's one more >> But the first time this came up, I was advised not to 
bother, just export raw reports and edit to the finished product. Great editors already 
exist so why try to reinvent the wheel.
** For example, page breaks. You don't want them at an awkward place in the 
report so might want to insert some blank lines to prevent that. You might want 
top levels or total lines a different font size or bold, et.
___
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.

<2022-03-18-11h36-gnucash-balance-sheet-report.png><2022-03-18-11h37-gnucash-income-statement-report.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.



___
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] Report - Income Statement - Layout problem

[Christopher Lam]

You can do Edit > Stylesheet > (choose stylesheet - technicolor?) > Tables
> Table Border Width to 1px or more.
then OK > Close > Reload report to draw the table lines, which will help
show layout errors.
I wonder if you have an unusual account tree hierarchy.
Maybe file a bug and attach File > Export > Export account tree to CSV file
and the screenshots with layout.

On Fri, 18 Mar 2022 at 10:44, Carl-Kensaku HERBORT  wrote:

> Hello,
>
> As promised in my previous e-mail below, here are two screen captures:
> 1. the balance sheet report: working perfectly
> 2. the income statement report: with width problem and alignment problem
>
> I hope the pictures are allowed on the mailing list.
>
> Thank you for your help
>
> Best regards
>
> --
> Carl-Kensaku HERBORT
> DIGIENE
> Case postale
> CH-1002 Lausanne
> Suisse
>
> +41 (0) 21 320 22 66
>
> Le 18.03.22 à 11:31, Carl-Kensaku HERBORT a écrit :
> > Hello,
> >
> > A. TITLE TRANSLATION PROBLEM
> >
> > I have already tried changing the title line. The title line is divided
> > in four parts, the first two of which can be customized:
> > 1. Company name (by default: blank) - customizable at will
> > 2. Core title (by default: "Income statement") - customizable at will
> > 3. A fixed string ("For Period Covering") - not customizable
> > 4. Start and end dates ("01.01.2021 to 31.12.2021") - defined by the
> > dates you choose
> >
> > I left the company name blank, so in my case the entire title line is:
> > "Compte de résultat For Period Covering 01.01.2021 to 31.12.2021"
> >
> > The only problem is that the third part ("For Period Covering") is not
> > translated and I cannot find where is the option to change or remove it.
> >
> >
> > B. WIDTH AND COLUMNS ALIGNMENT
> >
> > Maybe I didn't use the right words: I don't care about things being
> > pretty (color, lines, etc). The report is messed up in its basic
> > structure. Maybe showing you is better. I don't know if I can send a
> > picture as attachment on the mailing list. I will try sending it in the
> > next e-mail.
> >
> > Thank you for your help
> >
> > Best regards
> >
> > Carl-Kensaku HERBORT
> > DIGIENE
> > Case postale
> > CH-1002 Lausanne
> > Suisse
> >
> > +41 (0) 21 320 22 66
> >
> > Le 18.03.22 à 03:23, Michael or Penny Novack a écrit :
> >> On 3/17/2022 5:49 PM, Carl-Kensaku HERBORT wrote:
> >>> Dear everyone,
> >>> Thank you all for being here to help new users like me.
> >>> I am having problems with the "income statement" report ("compte de
> >>> resultat" in french).
> >>>
> >>> The columns of the revenue part and the columns of the expense part
> >>> are not aligned. In fact, the entire layout of these two parts
> >>> (including the width) seem to be independently managed from each
> >>> other (contrary to what happens with the parts making up the "balance
> >>> sheet"/"bilan" report, perfectly aligned and with an identical width).
> >>> The result is quite ugly. Changing the stylesheet or making accounts
> >>> name shorter or longer doesn't solve the problem. Could you please
> >>> help me out ?
> >>>
> >>> An other problem is that there is an untranslated string in the
> >>> middle of the title of the income statement report: "For Period
> >>> Covering". As I am creating the report in french, it is a bit of a
> >>> problem. Is there a way to replace this string by a translation or
> >>> get rid of this string completely (whatever is easiest) ?
> >>
> >> The second question helps with the first because it makes me think
> >> that you have not yet investigated all the report options available to
> >> you. The process is, run the report (open it) and then use
> >> edit=>report options to change various things about the report. Though
> >> how you could be running an income statement without setting the
> >> effective date range is beyond me.
> >>
> >> Report title is one of the things you can make whatever your heart
> >> desires. I had been keeping books for non-profits so "Statement of
> >> Revenues and Expenses"
> >>
> >> HOWEVER -- if your "not lining up" is a matter of different levels of
> >> nesting in your CoA << income accounts vs expense accounts >> the
> >> report might need prettying up. It is a waste of time to try to do
> >> pretty printing INSIDE the accounting package. You want a full service
> >> editor for that. Run the report, export the raw report, and then edit
> >> THAT with your favorite editor.
> >>
> >> Michael D Novack
> >>
> >>
> >> ___
> >> 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

Re: [GNC] Report - Income Statement - Layout problem

[John Ralls]

I can't reproduce that here. Does that happen with all of the stylesheets? Have 
you perhaps modified the Technicolor stylesheet so that the Revenue block is 
smaller than the Expenses one?

Regards,
John Ralls


> On Mar 20, 2022, at 9:51 AM, Carl-Kensaku HERBORT  wrote:
> 
> Hello,
> 
> The effective nesting level is the same.
> 
> No, I don't need an option to justify columns. I just need the income 
> statement report to look as normal as the balance sheet report (see screen 
> capture).
> 
> I really don't need anything more.
> 
> Have a nice week-end
> 
> Best regards
> 
> --
> Carl-Kensaku HERBORT
> DIGIENE
> Case postale
> CH-1002 Lausanne
> Suisse
> 
> +41 (0) 21 320 22 66
> 
> Le 20.03.22 à 16:27, Michael or Penny Novack a écrit :
>> On 3/20/2022 5:21 AM, Carl-Kensaku HERBORT wrote:
>>> Hello again,
>>> 
>>> I have tried a more recent version on MacOS (Version 4.9 / build ID 
>>> 4.9+(2021-12-18) / Finance::Quote:-). It solves the first problem of string 
>>> translation.
>>> 
>>> But the second problem is still there: the width and column alignment of 
>>> the revenue part is not synchronized with those of the expense part.
>>> 
>>> Do you have any ideas ? 
>> You did not say  is the effective nesting level of income and expense 
>> the same?
>> Even if so, the resulting report would not be what I wanted in a report in 
>> the final form I would be presenting to the board at meetings or having 
>> published in an annual report << I used to be treasurer of some 501(c)3 
>> organizations and used gnucash to keep the books >>
>> I suspect that what you want (from the developers) is an option to "justify 
>> columns from the right". That's what I would have in the "finished product" 
>> reports. In the case of the Income Statement (Statement of Revenues and 
>> Expenses --- what a non-profit calls this report) but also with Balance 
>> Sheet reports. Instead of writing custom reports* I export and then edit 
>> with full control over the level of detail in different parts, column 
>> alignment, etc. and can add annotation as needed. There is a lot of detail 
>> work** in producing a "pretty print" report.
>> Michael D Novack
>> * I am a retired pro. While not fluent in the language used to create the 
>> reports, I can at least read LISP and so soon could be << when you have 
>> written in half a dozen languages, what's one more >> But the first time 
>> this came up, I was advised not to bother, just export raw reports and edit 
>> to the finished product. Great editors already exist so why try to reinvent 
>> the wheel.
>> ** For example, page breaks. You don't want them at an awkward place in the 
>> report so might want to insert some blank lines to prevent that. You might 
>> want top levels or total lines a different font size or bold, et.
>> ___
>> 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.
> <2022-03-18-11h36-gnucash-balance-sheet-report.png><2022-03-18-11h37-gnucash-income-statement-report.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.

___
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] Report - Income Statement - Layout problem

[Michael or Penny Novack]

On 3/20/2022 12:51 PM, Carl-Kensaku HERBORT wrote:

Hello,

The effective nesting level is the same.
No, I don't need an option to justify columns. I just need the income 
statement report to look as normal as the balance sheet report (see 
screen capture).

I really don't need anything more.

Have a nice week-end

Best regards 


ROF, it's all weekends to me (long retired)

Has anybody else seen something like that strange Income Statement 
report? The old version of gnucash that I run doesn't have report 
options for "justification". And yes Carl, that not lining up is that 
sort of difference between "income" and "expense" << income is not just 
narrower, but is centered as opposed to left justified or right justified >>


Michael D Novack



___
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] Report - Income Statement - Layout problem

[Michael or Penny Novack]

On 3/20/2022 5:21 AM, Carl-Kensaku HERBORT wrote:

Hello again,

I have tried a more recent version on MacOS (Version 4.9 / build ID 
4.9+(2021-12-18) / Finance::Quote:-). It solves the first problem of 
string translation.


But the second problem is still there: the width and column alignment 
of the revenue part is not synchronized with those of the expense part.


Do you have any ideas ? 


You did not say  is the effective nesting level of income and 
expense the same?


Even if so, the resulting report would not be what I wanted in a report 
in the final form I would be presenting to the board at meetings or 
having published in an annual report << I used to be treasurer of some 
501(c)3 organizations and used gnucash to keep the books >>


I suspect that what you want (from the developers) is an option to 
"justify columns from the right". That's what I would have in the 
"finished product" reports. In the case of the Income Statement 
(Statement of Revenues and Expenses --- what a non-profit calls this 
report) but also with Balance Sheet reports. Instead of writing custom 
reports* I export and then edit with full control over the level of 
detail in different parts, column alignment, etc. and can add annotation 
as needed. There is a lot of detail work** in producing a "pretty print" 
report.


Michael D Novack

* I am a retired pro. While not fluent in the language used to create 
the reports, I can at least read LISP and so soon could be << when you 
have written in half a dozen languages, what's one more >> But the first 
time this came up, I was advised not to bother, just export raw reports 
and edit to the finished product. Great editors already exist so why try 
to reinvent the wheel.


** For example, page breaks. You don't want them at an awkward place in 
the report so might want to insert some blank lines to prevent that. You 
might want top levels or total lines a different font size or bold, et.



___
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] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Hello again,

I have tried a more recent version on MacOS (Version 4.9 / build ID 
4.9+(2021-12-18) / Finance::Quote:-). It solves the first problem of 
string translation.


But the second problem is still there: the width and column alignment of 
the revenue part is not synchronized with those of the expense part.


Do you have any ideas ?

Thanks you for your help

Best regards

Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 20.03.22 à 09:46, Carl-Kensaku HERBORT a écrit :

Hello,

I have the latest version available on Ubuntu 20.04.4.

- GnuCash About:
Version: 3.8 / Build ID: 3.8b+(2019-12-29) / Finance::Quote: 1.49

- Ubuntu package: 1:3.8b-1ubuntu1

best regards

Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 18.03.22 à 18:06, john a écrit :



On Mar 18, 2022, at 8:50 AM, Michael or Penny Novack 
 wrote:





B. WIDTH AND COLUMNS ALIGNMENT

Maybe I didn't use the right words: I don't care about things being 
pretty (color, lines, etc). The report is messed up in its basic 
structure. Maybe showing you is better. I don't know if I can send a 
picture as attachment on the mailing list. I will try sending it in 
the next e-mail.


You don't need to send me a picture. I do know what you are talking 
about. But I am also considering things like having column alignment 
under the meaning of "pretty".


I (also) have columns not lined up in the "raw report" as produced by 
gnucash. But I have deep nesting (in some of my boos) and the nesting 
is not the same for all parts of income or expenses. So I expect to 
be exporting the raw report and then editing outside of gnucash and I 
fix the column alignment then. This is less of a burden to me because 
I am going to have to edit the reports anyway. Because:


1) As treasurer I will need levels of detail to determine things like 
"do I need to fill out a 1099-MISC for this intern when (is their PAY 
> $600; what they get for mileage reimbursement isn't "pay"). All the 
board will want to see then I present at the meeting is "total amount 
for all interns". So I will need both "full detail" and "detail at 
the level a board would want from conceptually the report.


2) I will be adding annotation to the report handed out to the board 
(or for the annual report to the public). In other words, flag 
anything unusual and explain in a footnote. Thus an expense item zero 
when something would be expected there the annotation might be 
"vendor did not send us the invoice for printing and mailing the 
annual meeting notices until after the end of the quarter".


3) Related to the above example , I want to SELECTIVELY show or not 
show zero amounts.


BUT --- your problem with a fixed text not being translated is a 
"bug" and should be brought to the attention of whoever is handling 
"French translation". However, to be fair (to do the user's part) 
instead of JUST reporting this by itself look at all of the reports 
to see if there aren't other fixed text lines that were forgotten in 
the "French" version. I did this for a living (designed/wrote/tested 
software). When we budgeted for a project, that included a bucket for 
USER time.


This is why I, a retired pro with decades in the cypher mines (and 
doing :financial software to boot) am NOT helping with development. I 
am not going to volunteer to do the design/coding without user 
commitment to their part of the process << both in the design phase 
and the testing phase >>




What version of GnuCash are you using? That string should be 
translated in GnuCash 4.6 and later.


Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

___
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] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Hello,

I have the latest version available on Ubuntu 20.04.4.

- GnuCash About:
Version: 3.8 / Build ID: 3.8b+(2019-12-29) / Finance::Quote: 1.49

- Ubuntu package: 1:3.8b-1ubuntu1

best regards

Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 18.03.22 à 18:06, john a écrit :




On Mar 18, 2022, at 8:50 AM, Michael or Penny Novack 
 wrote:




B. WIDTH AND COLUMNS ALIGNMENT

Maybe I didn't use the right words: I don't care about things being pretty 
(color, lines, etc). The report is messed up in its basic structure. Maybe 
showing you is better. I don't know if I can send a picture as attachment on 
the mailing list. I will try sending it in the next e-mail.


You don't need to send me a picture. I do know what you are talking about. But I am also 
considering things like having column alignment under the meaning of "pretty".

I (also) have columns not lined up in the "raw report" as produced by gnucash. 
But I have deep nesting (in some of my boos) and the nesting is not the same for all 
parts of income or expenses. So I expect to be exporting the raw report and then editing 
outside of gnucash and I fix the column alignment then. This is less of a burden to me 
because I am going to have to edit the reports anyway. Because:

1) As treasurer I will need levels of detail to determine things like "do I need to fill out a 1099-MISC for this 
intern when (is their PAY > $600; what they get for mileage reimbursement isn't "pay"). All the board will 
want to see then I present at the meeting is "total amount for all interns". So I will need both "full 
detail" and "detail at the level a board would want from conceptually the report.

2) I will be adding annotation to the report handed out to the board (or for the annual 
report to the public). In other words, flag anything unusual and explain in a footnote. 
Thus an expense item zero when something would be expected there the annotation might be 
"vendor did not send us the invoice for printing and mailing the annual meeting 
notices until after the end of the quarter".

3) Related to the above example , I want to SELECTIVELY show or not show zero 
amounts.

BUT --- your problem with a fixed text not being translated is a "bug" and should be brought to the 
attention of whoever is handling "French translation". However, to be fair (to do the user's part) 
instead of JUST reporting this by itself look at all of the reports to see if there aren't other fixed text 
lines that were forgotten in the "French" version. I did this for a living (designed/wrote/tested 
software). When we budgeted for a project, that included a bucket for USER time.

This is why I, a retired pro with decades in the cypher mines (and doing :financial 
software to boot) am NOT helping with development. I am not going to volunteer to do the 
design/coding without user commitment to their part of the process << both in the 
design phase and the testing phase >>



What version of GnuCash are you using? That string should be translated in 
GnuCash 4.6 and later.

Regards,
John Ralls


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

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

Re: [GNC] Report - Income Statement - Layout problem

[john]

> On Mar 18, 2022, at 8:50 AM, Michael or Penny Novack 
>  wrote:
> 
> 
> 
>> B. WIDTH AND COLUMNS ALIGNMENT
>> 
>> Maybe I didn't use the right words: I don't care about things being pretty 
>> (color, lines, etc). The report is messed up in its basic structure. Maybe 
>> showing you is better. I don't know if I can send a picture as attachment on 
>> the mailing list. I will try sending it in the next e-mail. 
> 
> You don't need to send me a picture. I do know what you are talking about. 
> But I am also considering things like having column alignment under the 
> meaning of "pretty".
> 
> I (also) have columns not lined up in the "raw report" as produced by 
> gnucash. But I have deep nesting (in some of my boos) and the nesting is not 
> the same for all parts of income or expenses. So I expect to be exporting the 
> raw report and then editing outside of gnucash and I fix the column alignment 
> then. This is less of a burden to me because I am going to have to edit the 
> reports anyway. Because:
> 
> 1) As treasurer I will need levels of detail to determine things like "do I 
> need to fill out a 1099-MISC for this intern when (is their PAY > $600; what 
> they get for mileage reimbursement isn't "pay"). All the board will want to 
> see then I present at the meeting is "total amount for all interns". So I 
> will need both "full detail" and "detail at the level a board would want from 
> conceptually the report.
> 
> 2) I will be adding annotation to the report handed out to the board (or for 
> the annual report to the public). In other words, flag anything unusual and 
> explain in a footnote. Thus an expense item zero when something would be 
> expected there the annotation might be "vendor did not send us the invoice 
> for printing and mailing the annual meeting notices until after the end of 
> the quarter".
> 
> 3) Related to the above example , I want to SELECTIVELY show or not show zero 
> amounts.
> 
> BUT --- your problem with a fixed text not being translated is a "bug" and 
> should be brought to the attention of whoever is handling "French 
> translation". However, to be fair (to do the user's part) instead of JUST 
> reporting this by itself look at all of the reports to see if there aren't 
> other fixed text lines that were forgotten in the "French" version. I did 
> this for a living (designed/wrote/tested software). When we budgeted for a 
> project, that included a bucket for USER time.
> 
> This is why I, a retired pro with decades in the cypher mines (and doing 
> :financial software to boot) am NOT helping with development. I am not going 
> to volunteer to do the design/coding without user commitment to their part of 
> the process << both in the design phase and the testing phase >>
> 

What version of GnuCash are you using? That string should be translated in 
GnuCash 4.6 and later.

Regards,
John Ralls


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

Re: [GNC] Report - Income Statement - Layout problem

[Michael or Penny Novack]

B. WIDTH AND COLUMNS ALIGNMENT

Maybe I didn't use the right words: I don't care about things being 
pretty (color, lines, etc). The report is messed up in its basic 
structure. Maybe showing you is better. I don't know if I can send a 
picture as attachment on the mailing list. I will try sending it in 
the next e-mail. 


You don't need to send me a picture. I do know what you are talking 
about. But I am also considering things like having column alignment 
under the meaning of "pretty".


I (also) have columns not lined up in the "raw report" as produced by 
gnucash. But I have deep nesting (in some of my boos) and the nesting is 
not the same for all parts of income or expenses. So I expect to be 
exporting the raw report and then editing outside of gnucash and I fix 
the column alignment then. This is less of a burden to me because I am 
going to have to edit the reports anyway. Because:


1) As treasurer I will need levels of detail to determine things like 
"do I need to fill out a 1099-MISC for this intern when (is their PAY > 
$600; what they get for mileage reimbursement isn't "pay"). All the 
board will want to see then I present at the meeting is "total amount 
for all interns". So I will need both "full detail" and "detail at the 
level a board would want from conceptually the report.


2) I will be adding annotation to the report handed out to the board (or 
for the annual report to the public). In other words, flag anything 
unusual and explain in a footnote. Thus an expense item zero when 
something would be expected there the annotation might be "vendor did 
not send us the invoice for printing and mailing the annual meeting 
notices until after the end of the quarter".


3) Related to the above example , I want to SELECTIVELY show or not show 
zero amounts.


BUT --- your problem with a fixed text not being translated is a "bug" 
and should be brought to the attention of whoever is handling "French 
translation". However, to be fair (to do the user's part) instead of 
JUST reporting this by itself look at all of the reports to see if there 
aren't other fixed text lines that were forgotten in the "French" 
version. I did this for a living (designed/wrote/tested software). When 
we budgeted for a project, that included a bucket for USER time.


This is why I, a retired pro with decades in the cypher mines (and doing 
:financial software to boot) am NOT helping with development. I am not 
going to volunteer to do the design/coding without user commitment to 
their part of the process << both in the design phase and the testing 
phase >>


Michael D Novack


___
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] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Hello,

A. TITLE TRANSLATION PROBLEM

I have already tried changing the title line. The title line is divided 
in four parts, the first two of which can be customized:

1. Company name (by default: blank) - customizable at will
2. Core title (by default: "Income statement") - customizable at will
3. A fixed string ("For Period Covering") - not customizable
4. Start and end dates ("01.01.2021 to 31.12.2021") - defined by the 
dates you choose


I left the company name blank, so in my case the entire title line is:
"Compte de résultat For Period Covering 01.01.2021 to 31.12.2021"

The only problem is that the third part ("For Period Covering") is not 
translated and I cannot find where is the option to change or remove it.



B. WIDTH AND COLUMNS ALIGNMENT

Maybe I didn't use the right words: I don't care about things being 
pretty (color, lines, etc). The report is messed up in its basic 
structure. Maybe showing you is better. I don't know if I can send a 
picture as attachment on the mailing list. I will try sending it in the 
next e-mail.


Thank you for your help

Best regards

Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 18.03.22 à 03:23, Michael or Penny Novack a écrit :

On 3/17/2022 5:49 PM, Carl-Kensaku HERBORT wrote:

Dear everyone,
Thank you all for being here to help new users like me.
I am having problems with the "income statement" report ("compte de 
resultat" in french).


The columns of the revenue part and the columns of the expense part 
are not aligned. In fact, the entire layout of these two parts 
(including the width) seem to be independently managed from each other 
(contrary to what happens with the parts making up the "balance 
sheet"/"bilan" report, perfectly aligned and with an identical width).
The result is quite ugly. Changing the stylesheet or making accounts 
name shorter or longer doesn't solve the problem. Could you please 
help me out ?


An other problem is that there is an untranslated string in the middle 
of the title of the income statement report: "For Period Covering". As 
I am creating the report in french, it is a bit of a problem. Is there 
a way to replace this string by a translation or get rid of this 
string completely (whatever is easiest) ? 


The second question helps with the first because it makes me think that 
you have not yet investigated all the report options available to you. 
The process is, run the report (open it) and then use edit=>report 
options to change various things about the report. Though how you could 
be running an income statement without setting the effective date range 
is beyond me.


Report title is one of the things you can make whatever your heart 
desires. I had been keeping books for non-profits so "Statement of 
Revenues and Expenses"


HOWEVER -- if your "not lining up" is a matter of different levels of 
nesting in your CoA << income accounts vs expense accounts >> the report 
might need prettying up. It is a waste of time to try to do pretty 
printing INSIDE the accounting package. You want a full service editor 
for that. Run the report, export the raw report, and then edit THAT with 
your favorite editor.


Michael D Novack


___
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] Report - Income Statement - Layout problem

[Michael or Penny Novack]

On 3/17/2022 5:49 PM, Carl-Kensaku HERBORT wrote:

Dear everyone,
Thank you all for being here to help new users like me.
I am having problems with the "income statement" report ("compte de 
resultat" in french).


The columns of the revenue part and the columns of the expense part 
are not aligned. In fact, the entire layout of these two parts 
(including the width) seem to be independently managed from each other 
(contrary to what happens with the parts making up the "balance 
sheet"/"bilan" report, perfectly aligned and with an identical width).
The result is quite ugly. Changing the stylesheet or making accounts 
name shorter or longer doesn't solve the problem. Could you please 
help me out ?


An other problem is that there is an untranslated string in the middle 
of the title of the income statement report: "For Period Covering". As 
I am creating the report in french, it is a bit of a problem. Is there 
a way to replace this string by a translation or get rid of this 
string completely (whatever is easiest) ? 


The second question helps with the first because it makes me think that 
you have not yet investigated all the report options available to you. 
The process is, run the report (open it) and then use edit=>report 
options to change various things about the report. Though how you could 
be running an income statement without setting the effective date range 
is beyond me.


Report title is one of the things you can make whatever your heart 
desires. I had been keeping books for non-profits so "Statement of 
Revenues and Expenses"


HOWEVER -- if your "not lining up" is a matter of different levels of 
nesting in your CoA << income accounts vs expense accounts >> the report 
might need prettying up. It is a waste of time to try to do pretty 
printing INSIDE the accounting package. You want a full service editor 
for that. Run the report, export the raw report, and then edit THAT with 
your favorite editor.


Michael D Novack


___
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] Report - Income Statement - Layout problem

[Carl-Kensaku HERBORT]

Dear everyone,

Thank you all for being here to help new users like me.

I am having problems with the "income statement" report ("compte de 
resultat" in french).


The columns of the revenue part and the columns of the expense part are 
not aligned. In fact, the entire layout of these two parts (including 
the width) seem to be independently managed from each other (contrary to 
what happens with the parts making up the "balance sheet"/"bilan" 
report, perfectly aligned and with an identical width).


The result is quite ugly. Changing the stylesheet or making accounts 
name shorter or longer doesn't solve the problem. Could you please help 
me out ?


An other problem is that there is an untranslated string in the middle 
of the title of the income statement report: "For Period Covering". As I 
am creating the report in french, it is a bit of a problem. Is there a 
way to replace this string by a translation or get rid of this string 
completely (whatever is easiest) ?


Thanks a lot for your help

Best regards

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66
___
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.