[set page_banner]Trial Balance[/set] [set fm_class]Ledger[/set] [set help_name]trial_balance[/set] [set page_title]Trial Balance[/set] [set icon_name]admin/icon_stats.gif[/set] @_FM_STD_HEAD_@ [query sql="SELECT COUNT(*) FROM gl_balance gb, gl_acctgrid ga, gl_chartofaccount gc WHERE gc.number BETWEEN '[value accountfrom]' AND '[value accountto]' AND gc.ac_id = ga.dim1 AND gb.ag_id = ga.ag_id AND gb.periodnr BETWEEN '[value periodfrom]' AND '[value periodto]'" list=1] [seti rowsfound][sql-pos 0][/seti] [/query] [if scratch rowsfound] [query more=1 ml=20 list=1 sql="SELECT gc.number, gn.name, MIN(gb.begindr) as begindr, MIN(gb.begincr) as begincr, SUM(gb.perioddr) as perioddr, SUM(gb.periodcr) as periodcr FROM gl_balance gb, 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 gb.ag_id = ga.ag_id AND gb.periodnr BETWEEN '[value periodfrom]' AND '[value periodto]' GROUP BY gc.number, gn.name"] [list] [/list]
[L]Account[/L] [L]Description[/L] [L]Beginning Balance[/L] [L]Debit[/L] [L]Credit[/L] [L]Ending Balance[/L] ([L]#[/L]: [scratch rowsfound])
 
[sql-param number] [sql-param name] [seti beginbal][calc][sql-param begindr]+0 - ([sql-param begincr]+0)[/calc][/seti] [currency][scratch beginbal][/currency] [currency][sql-param perioddr][/currency] [currency][sql-param periodcr][/currency] [currency][calc] my $total; $total = [scratch beginbal]+0 if ($Values->{sumtype} eq "ytd"); $total += [sql-param perioddr]-[sql-param periodcr]; $total; [/calc][/currency]

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

 
[L]No Balance rows found.[/L]

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