[set page_banner]Journal List[/set] [set fm_class]Ledger[/set] [set help_name]journal_list[/set] [set page_title]Journal List[/set] [set icon_name]icon_stats.gif[/set] @_FM_STD_HEAD_@ [query sql="SELECT COUNT(*) FROM gl_journal gj, gl_acctgrid ga, gl_chartofaccount gc WHERE gc.number BETWEEN '[value accountfrom]' AND '[value accountto]' AND gc.coa_id = ga.dim1 AND gj.ag_id = ga.ag_id AND gj.accountingdate BETWEEN '[value periodfrom]' AND '[value periodto]'" list=1] [seti rowsfound][sql-pos 0][/seti] [/query] [if scratch rowsfound] [query more=1 ml=10 list=1 sql="SELECT gc.number, gn.name, gj.accountingdate::date as accountingdate, gj.entereddr, gj.enteredcr FROM gl_journal gj, gl_acctgrid ga, gl_chartofaccount gc, gl_acctname gn WHERE gc.number between '[value accountfrom]' AND '[value accountto]' AND gc.ac_id = gn.ac_id AND gc.coa_id = ga.dim1 AND gj.ag_id = ga.ag_id AND gj.accountingdate BETWEEN '[value periodfrom]' AND '[value periodto]' ORDER BY gc.number, gj.accountingdate"] [list] [/list]
[L]Account[/L] [L]Description[/L] [L]Date[/L] [L]Debit[/L] [L]Credit[/L] ([L]#[/L]: [scratch rowsfound])
 
[sql-param number] [sql-param name] [sql-param accountingdate] [currency][sql-param entereddr][/currency] [currency][sql-param enteredcr][/currency]

[more-list] [more] [/more-list] [/query]
[set rowsfound][/set]
[else]

 
[L]No Journal entries found.[/L]

[/else] [/if] [L]BACK[/L] @_FM_STD_FOOTER_@