diff options
| -rw-r--r-- | UI/Contact/contact.html | 8 | ||||
| -rw-r--r-- | sql/modules/Company.sql | 3 | ||||
| -rw-r--r-- | sql/modules/Roles.sql | 2 |
3 files changed, 8 insertions, 5 deletions
diff --git a/UI/Contact/contact.html b/UI/Contact/contact.html index 759d374b..68a14a05 100644 --- a/UI/Contact/contact.html +++ b/UI/Contact/contact.html @@ -220,8 +220,8 @@ problems with multi-word single-quoted constructs in PI tags. -CT --> <td> <?lsmb INCLUDE input element_data = { label = text('Tax Number/SSN:'), - name = "taxnumber", - value = taxnumber, + name = "tax_id", + value = tax_id, type = "text", size = "19" } #' ?> @@ -276,8 +276,8 @@ problems with multi-word single-quoted constructs in PI tags. -CT --> } ?> </td> <td> <?lsmb INCLUDE select element_data = { - name = "payment_account_id" - default_values = [payment_account_id] + name = "cash_account_id" + default_values = [cash_account_id] options = cash_acc_list label = text('Payment') text_attr = "text" diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index faffe92e..d935317d 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -144,6 +144,7 @@ CREATE TYPE entity_credit_search_return AS ( enddate date, ar_ap_account_id int, cash_account_id int, + tax_id text, threshold numeric ); @@ -161,7 +162,7 @@ BEGIN ec.taxincluded, ec.creditlimit, ec.terms, ec.meta_number, ec.business_id, ec.language_code, ec.pricegroup_id, ec.curr::char(3), ec.startdate, ec.enddate, ec.ar_ap_account_id, - ec.cash_account_id, ec.threshold + ec.cash_account_id, c.tax_id, ec.threshold INTO out_row FROM company c JOIN entity e ON (c.entity_id = e.id) diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql index e8ae3bb4..b91298f1 100644 --- a/sql/modules/Roles.sql +++ b/sql/modules/Roles.sql @@ -577,6 +577,7 @@ IN ROLE "lsmb_<?lsmb dbname ?>__list_ap_transactions"; GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__process_payment"; GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__process_payment"; +GRANT UPDATE ON ap TO "lsmb_<?lsmb dbname ?>__process_payment"; INSERT INTO menu_acl (node_id, acl_type, role_name) @@ -591,6 +592,7 @@ IN ROLE "lsmb_<?lsmb dbname ?>__list_ar_transactions"; GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__process_receipt"; GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__process_receipt"; +GRANT UPDATE ON ar TO "lsmb_<?lsmb dbname ?>__process_receipt"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (35, 'allow', 'lsmb_<?lsmb dbname ?>__process_receipt'); |