[set page_banner]Accounts Receivables[/set] [set fm_class]receivables[/set] [set help_name]accounts receivables[/set] [set page_title]Accounts Receivables[/set] [set icon_name]icon_orders.gif[/set] @_FM_STD_HEAD_@ [value name=select_ar set=""] [query sql="SELECT count(*) FROM ar_journal WHERE total > paid" list=1] [seti rowsfound][sql-pos 0][/seti] [/query] [if scratch rowsfound] [L]Select[/L] [L]Customernr[/L] [L]Name[/L] [L]Address[/L] [L]Postal Code[/L] [L]Invoicenr[/L] [L]Amount[/L] [L]Rest[/L] ([L]#[/L]: [scratch rowsfound]) [query more=1 ml=10 list=1 sql="SELECT ar.ar_id, c.customernr, c.name, c.address1, c.postalcode, ar.invoicenr, ar.total, ar.total-ar.paid AS rest FROM ar_journal ar, co_custaddr_v c WHERE ar.total > ar.paid AND ar.contact_id = c.contact_id ORDER BY invoicenr"] [list] [sql-param customernr] [sql-param name] [sql-param address1] [sql-param postalcode] [sql-param invoicenr] [currency][sql-param total][/currency] [currency][sql-param rest][/currency] [/list] [more-list] [more] [/more-list] [/query] [set [L]Cancel Selected[/L]] mv_todo=return mv_action=Cancel mv_nextpage=freemoney/invoiceCancel [/set] [set [L]Update Selected[/L]] mv_todo=return mv_action=Update [/set] [set rowsfound][/set] [else] [L]No Accounts Receivable rows found.[/L] [L]Please press New to add a/r entries.[/L] [/else] [/if] @_FM_STD_FOOTER_@
[L]No Accounts Receivable rows found.[/L] [L]Please press New to add a/r entries.[/L]