[set page_banner]Order Invoicing List[/set] [set fm_class]Orders[/set] [set help_name]order invoicing list[/set] [set page_title]Order Invoicing List[/set] [set icon_name]icon_item.gif[/set] @_FM_STD_HEAD_@ [value name=select_order set=""] [value name=select_all set=""] [query sql="SELECT COUNT(*) FROM so_orderhead WHERE status = 100 AND ordernr NOT IN (SELECT ordernr FROM so_invoice)" list=1] [seti rowsfound][sql-pos 0][/seti] [/query] [if scratch rowsfound] [query more=1 ml=20 list=1 sql="SELECT o.ordernr, p.lastname||', '||p.firstname AS name FROM so_orderhead o, co_customer cu, co_person p WHERE o.status = 100 AND o.contact_id = cu.contact_id AND cu.type=60001 AND cu.contact_id = p.contact_id AND ordernr NOT IN (SELECT ordernr FROM so_invoice) UNION SELECT o.ordernr, co.name AS name FROM so_orderhead o, co_customer cu, co_company co WHERE o.status = 100 AND o.contact_id = cu.contact_id AND cu.type=60002 AND cu.contact_id = co.contact_id AND ordernr NOT IN (SELECT ordernr FROM so_invoice) ORDER BY ordernr"] [list] [/list]
[L]Select[/L] [L]Ordernr[/L] [L]Name[/L] ([L]#[/L]: [scratch rowsfound])
 
[sql-param ordernr] [sql-param name]

[more-list] [more] [/more-list] [/query]
[L]All[/L]
[set [L]Invoice[/L]] mv_todo=return mv_action=Invoice [/set] [set rowsfound][/set] [else]

 
[L]No orders were found.[/L]

[comment] Should we go diretly to the update page w/o needing user input? [/comment] [L]Please press New to add invoices.[/L]

[/else] [/if] @_FM_STD_FOOTER_@