Re: [SL] How to add Account Description as column in GL and other reports

[Armaghan S. <sa...@le...>]

As far as I know this is not available in current sql-ledger version.
We can request Dieter to  add this in the coming versions of SL. For
the time being I have patched my installation for this. You need to
edit two files for this. SL/GL.pm and bin/mozilla/gl.pl.

In GL.pm, you add something like following in $query (sub
transactions). Put this in all three queries comprising UNION.
                 c.description AS accdescription,

In bin/mozilla/gl, follow 'accno' and add similar code for accdescription.

Let me know if you can't do it and I shall send you my patched gl.pl
and GL.pm files (for 2.8.11)

Regards


-- 
Purpose-built SQL-Ledger Hosting
http://www.ledger123.com/

Free trial available.
--

On 1/17/08, Prem Pradeep <pre...@gm...> wrote:
> I need to provide a lot of reporting and the readers of the reports want a
> column added to all sql-ledger reports that show the account description.
> How could I accomplish this in sql-ledger?
>
> thanks
> Prem
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>