[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_@ [set paid][/set] [if value mv_action] [then] [if value select_ar] [query list=1 sql="SELECT contact_id, invoicenr, total, total-paid AS rest FROM ar_journal WHERE ar_id=[value select_ar]"] [seti contact_id][sql-param contact_id][/seti] [seti invoicenr][sql-param invoicenr][/seti] [seti totalamt][sql-param total][/seti] [seti rest][sql-param rest][/seti] [/query] [query list=1 sql="SELECT customernr FROM co_customer WHERE contact_id=[scratch contact_id]"] [seti custnr][sql-param customernr][/seti] [/query] [query list=1 sql="SELECT address1, postalcode, city FROM co_address WHERE contact_id=[scratch contact_id]"] [seti addr1][sql-param address1][/seti] [seti postalcode][sql-param postalcode][/seti] [seti city][sql-param city][/seti] [/query] [if scratch custtype == 60001] [query list=1 sql="SELECT firstname,lastname FROM co_person WHERE contact_id=[value select_customer]"] [seti name][sql-param lastname], [sql-param firstname][/seti] [/query] [/if] [if scratch custtype == 60002] [query list=1 sql="SELECT name, attention FROM co_company WHERE contact_id=[value select_customer]"] [seti name][sql-param name][/seti] [/query] [/if] [else] [set error][L]**Please choose a row[/L][/set] [/else] [/if] [seti submit_value][value mv_action][/seti] [/then] [else] [set error][L]**Go here.[/L][/set] [/else] [/if] [if !scratch error]
| |||||||||||||||||||
|
[L]BACK[/L] [/else] [/if] @_FM_STD_FOOTER_@