Great article in April issue of LJ...
Paul Lussier
pll@mclinux.com
Sat, 24 Mar 2001 22:02:26 -0500
This is a multipart MIME message.
--==_Exmh_1957731280
Content-Type: text/plain
Don't know if everyone here saw Robert Merkel's great article in this month's
issue of Linux Journal, but it's great. Thanks Robert.
I do have a couple of questions about it though, mostly having to do with
things I saw in the article that don't seem to match my personal experience
with GnuCash.
The first thing that jumped out at me was the screen capture of the
Transaction Report. How exactly did you get the headings to be:
Date Num Description Account Amount
With 1.4.11, running a transaction report, I get the headings as:
Amount Account Memo Description Num Date
Which I find slightly difficult to work with, but I can deal with it (though
I'd prefer if I could get a more logical heading order like the screenshot
displayed).
Also, though there's only 2 months displayed, it appears that your months are
in the proper order as well. My Transaction Report results in all the months
being out of order.
I don't feel that I'm doing anything out of the ordinary. All I'm doing is:
Selecting "Reports->Transaction Report"
Selecting Parameters
Selecting the account I want the report for (Expenses:Charities)
Selecting the period (1/1/2000 - 12/31/2000)
Selecting Sorting criteria: Primary Key->Date (subtotal monthly)
Primary sort order->Ascending
Secondary Key->Number
Secondary sort order->Ascending
Attached is the exported html file so you can all see what I'm talking about
(assuming you care :)
Also, another thing I've found, is that anytime you elect to export a report
of some kind, the default file name to export to is the same as the file name
you currently have open. I think this could be a grave mistake, and may lead
a beginner to accidently overwrite their .xac file!
Other than those to things, though, I love GnuCash. Thanks a lot all, and
thanks Robert for a great article, I really enjoyed it!
Seeya,
Paul
----
I'm in shape, my shape just happens to be pear!
If you're not having fun, you're not doing it right!
--==_Exmh_1957731280
Content-Type: text/html ; name="foo.html"
Content-Description: foo.html
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="FOO.HTM"
<HTML><HEAD><TITLE>Transaction Report</TITLE></HEAD><BODY><TABLE><TR bgco=
lor=3D#96b284 cellspacing=3D10 rules=3D"rows"><TH justify=3Dleft>Amount</=
TH><TH justify=3Dleft>Account</TH><TH justify=3Dleft>Memo</TH><TH justify=
=3Dleft>Description</TH><TH justify=3Dleft>Num</TH><TH justify=3Dleft>Dat=
e</TH></TR>
<TR bgcolor=3D#96b28c><TH>January</TH></TR><TR bgcolor=3D#f6ffdb><TD alig=
n=3Dright><font face=3D"Courier"> 50.00 </font></TD><TD>Expense=
s:Charities</TD><TD></TD><TD>Charity 1</TD><TD>877</TD><TD> 1/30/2000</TD=
></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 200.=
00 </font></TD><TD>Expenses:Charities</TD><TD> 4 weeks</TD><TD>Chari=
ty 1</TD><TD>874</TD><TD> 1/23/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 5.00=
</font></TD><TD>Expenses:Charities</TD><TD>2nd Collection</TD><TD>C=
harity 1</TD><TD></TD><TD> 1/23/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 6.00=
</font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 2</TD><=
TD></TD><TD> 1/16/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 10.0=
0 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 2</TD>=
<TD></TD><TD> 1/ 9/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 20.0=
0 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 3</TD>=
<TD></TD><TD> 1/ 2/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 291.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>December</TH></TR><TR bgcolor=3D#f6ffdb><TD ali=
gn=3Dright><font face=3D"Courier"> 250.00 </font></TD><TD>Expen=
ses:Charities</TD><TD></TD><TD>Charity 4</TD><TD>1007</TD><TD>12/11/2000<=
/TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 250.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>February</TH></TR><TR bgcolor=3D#ffffff><TD ali=
gn=3Dright><font face=3D"Courier"> 50.00 </font></TD><TD>Expens=
es:Charities</TD><TD></TD><TD>Charity 1</TD><TD>894</TD><TD> 2/20/2000</T=
D></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 50.0=
0 </font></TD><TD>Expenses:Charities</TD><TD> 2nd Collection</TD><TD=
>Charity 1</TD><TD>892</TD><TD> 2/13/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 100.=
00 </font></TD><TD>Expenses:Charities</TD><TD>2 weeks</TD><TD>Charit=
y 1</TD><TD>891</TD><TD> 2/13/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 0.00=
</font></TD><TD>Void</TD><TD></TD><TD>Void</TD><TD>881</TD><TD> 2/ =
1/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 200.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>November</TH></TR><TR bgcolor=3D#ffffff><TD ali=
gn=3Dright><font face=3D"Courier"> 15.00 </font></TD><TD>Expens=
es:Charities</TD><TD></TD><TD>Charity 2</TD><TD></TD><TD>11/12/2000</TD><=
/TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 200.=
00 </font></TD><TD>Expenses:Charities</TD><TD>4 Weeks</TD><TD>Charit=
y 1</TD><TD>998</TD><TD>11/19/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 215.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>March</TH></TR><TR bgcolor=3D#ffffff><TD align=3D=
right><font face=3D"Courier"> 10.00 </font></TD><TD>Expenses:Ch=
arities</TD><TD></TD><TD>Charity 7</TD><TD></TD><TD> 3/26/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 50.0=
0 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 1</TD>=
<TD>904</TD><TD> 3/19/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 50.0=
0 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 1</TD>=
<TD>903</TD><TD> 3/12/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 50.0=
0 </font></TD><TD>Expenses:Charities</TD><TD>2nd Collection</TD><TD>=
Charity 1</TD><TD>902</TD><TD> 3/ 5/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 100.=
00 </font></TD><TD>Expenses:Charities</TD><TD>2 weeks</TD><TD>Charit=
y 1</TD><TD>901</TD><TD> 3/ 5/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 260.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>October</TH></TR><TR bgcolor=3D#f6ffdb><TD alig=
n=3Dright><font face=3D"Courier"> 100.00 </font></TD><TD>Expens=
es:Charities</TD><TD>2 Weeks</TD><TD>Charity 1</TD><TD>977</TD><TD>10/ 8/=
2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 0.00=
</font></TD><TD>Void</TD><TD></TD><TD>Void</TD><TD>978</TD><TD>10/ =
8/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 200.=
00 </font></TD><TD>Expenses:Charities</TD><TD> 4 Weeks</TD><TD>Chari=
ty 1</TD><TD>976</TD><TD>10/10/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 50.0=
0 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 5</TD>=
<TD>988</TD><TD>10/20/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 150.=
00 </font></TD><TD>Expenses:Charities</TD><TD>3 Weeks</TD><TD>Charit=
y 1</TD><TD>990</TD><TD>10/22/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 500.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>April</TH></TR><TR bgcolor=3D#ffffff><TD align=3D=
right><font face=3D"Courier"> 40.00 </font></TD><TD>Expenses:Ch=
arities</TD><TD> 1st & 2nd Collection</TD><TD>Charity 1</TD><TD></TD><TD>=
4/23/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 0.00=
</font></TD><TD>Void</TD><TD></TD><TD>Void</TD><TD>920</TD><TD> 4/2=
1/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 200.=
00 </font></TD><TD>Expenses:Charities</TD><TD>4 weeks</TD><TD>Charit=
y 1</TD><TD>917</TD><TD> 4/16/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 0.00=
</font></TD><TD>Void</TD><TD></TD><TD>Void</TD><TD>912</TD><TD> 4/1=
0/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 0.00=
</font></TD><TD>Void</TD><TD></TD><TD>Void</TD><TD>913</TD><TD> 4/ =
1/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 200.=
00 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 4</TD=
><TD>909</TD><TD> 4/ 1/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 250.=
00 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 9</TD=
><TD>906</TD><TD> 4/ 1/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 690.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>September</TH></TR><TR bgcolor=3D#f6ffdb><TD al=
ign=3Dright><font face=3D"Courier"> 30.00 </font></TD><TD>Expen=
ses:Charities</TD><TD> 1st & 2nd Collection</TD><TD>Charity 1</TD><TD></T=
D><TD> 9/ 3/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 50.0=
0 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 8</TD>=
<TD>972</TD><TD> 9/ 8/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 0.00=
</font></TD><TD>Void</TD><TD></TD><TD>Void</TD><TD>968</TD><TD> 9/1=
2/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 80.00 </font></STRONG></TD><TD></T=
D><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>May</TH></TR><TR bgcolor=3D#ffffff><TD align=3D=
right><font face=3D"Courier"> 50.00 </font></TD><TD>Expenses:Ch=
arities</TD><TD>2nd Collection</TD><TD>Charity 1</TD><TD>931</TD><TD> 5/1=
7/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 200.=
00 </font></TD><TD>Expenses:Charities</TD><TD>4 Weeks</TD><TD>Charit=
y 1</TD><TD>930</TD><TD> 5/17/2000</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 50.0=
0 </font></TD><TD>Expenses:Charities</TD><TD> </TD><TD>Charity 1</TD=
><TD>932</TD><TD> 5/14/2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 50.0=
0 </font></TD><TD>Expenses:Charities</TD><TD></TD><TD>Charity 5</TD>=
<TD>927</TD><TD> 5/ 4/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 350.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>August</TH></TR><TR bgcolor=3D#ffffff><TD align=
=3Dright><font face=3D"Courier"> 200.00 </font></TD><TD>Expense=
s:Charities</TD><TD> 4 Weeks</TD><TD>Charity 1</TD><TD>961</TD><TD> 8/13/=
2000</TD></TR>
<TR bgcolor=3D#f6ffdb><TD align=3Dright><font face=3D"Courier"> 200.=
00 </font></TD><TD>Expenses:Charities</TD><TD> 4 Weeks</TD><TD>Chari=
ty 1</TD><TD>962</TD><TD> 8/27/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 400.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>June</TH></TR><TR bgcolor=3D#ffffff><TD align=3D=
right><font face=3D"Courier"> 35.00 </font></TD><TD>Expenses:Ch=
arities</TD><TD>Non-deductible</TD><TD>Charity 6</TD><TD>943</TD><TD> 6/2=
2/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 35.00 </font></STRONG></TD><TD></T=
D><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#96b28c><TH>July</TH></TR><TR bgcolor=3D#f6ffdb><TD align=3D=
right><font face=3D"Courier"> 200.00 </font></TD><TD>Expenses:C=
harities</TD><TD> 4 Weeks</TD><TD>Charity 1</TD><TD>955</TD><TD> 7/ 9/200=
0</TD></TR>
<TR bgcolor=3D#ffffff><TD align=3Dright><font face=3D"Courier"> 0.00=
</font></TD><TD>Void</TD><TD></TD><TD>Void</TD><TD>945</TD><TD> 7/1=
0/2000</TD></TR>
<TR bgcolor=3Df6ffe3cellspacing=3D10 rules=3D"rows"><TD align=3Dright><ST=
RONG><font face=3D"Courier"> 200.00 </font></STRONG></TD><TD></=
TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
<TR bgcolor=3D#bfdeba cellspacing=3D10 rules=3D"rows"><TD align=3Dright><=
STRONG><font face=3D"Courier"> 3,471.00 </font></STRONG></TD><T=
D></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
</table></BODY></HTML>=
--==_Exmh_1957731280--