[SL] General Ledger Transaction Listing

[David J <ja...@in...>]

Hi List

We're trying to produce a report that would probably be
called "GL Transaction list, sorted by account" or similar. 
Sometimes simply called a "General Ledger listing".

Company Auditors (and tax auditors) usually ask for this
report.  All GL transactions, within a date range, sorted by
account code (or range), and then sorted by date.  Presented
nicely, topped and tailed, and printed.

Most accounting systems I've ever used have a way of
producing such a list, for a range of accounts, and/or for a
range of dates.  Importantly, ALL the details of each
transaction need to be listed, ie Date, Source, Reference,
Memo, Description, Notes, Amount, and account balance.
Such a report is fairly standard for any accountant or
auditor seeking to confirm entries in the GL system. But we
can't quite find how to do this in SQL-L.

Can get close by using the Trial Balance (by date range),
then click at one account at a time.
That produces a list of transactions for a single account,
but also there's no full details, memos notes, etc. Have
also examined the SQL-L manual without finding how to do
this.

Has anybody else mastered this ?

TIA's

-David J