manual billing error - billing_type needed first

[Dan Wells]

OpenSRF version: 1.2
Evergreen version: 1.6
PG version: 8.3
Linux version: Ubuntu 9.04 server edition

Attempts to add billing in stock 1.6 will give this error:

!!This software has encountered an error. Please tell your friendly system administrator or software developer the following:\npatron/bill_wizard.xul\nTypeError: billing_list.sort(function (a, b) {if (a.name() > b.name()) {return 1;}if (a.name() < b.name()) {return -1;}return 0;})[0] is undefined\n

This seems to be due to the fact that the 1.6 data seed values only include billing_type rows with IDs of 1-9, but 'add billing' only uses non-system reserved rows (id > 100).

This looks to already be fixed in trunk with these lines in the data seed file:

INSERT INTO config.billing_type (id, name, owner) VALUES ( 101, oils_i18n_gettext(101, 'Misc', 'cbt', 'name'), 1);

SELECT SETVAL('config.billing_type_id_seq'::TEXT, 101);

Reference link:
http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/src/sql/Pg/950.data.seed-values.sql

You can also fix this error by simply adding a Billing Type from the Admin->Server Administration menu of the staff client.

[Michael Peters (mrpeters)]

Thanks for the solution! Looks like this will be fixed for future versions, but the cause/solution here is appreciated!

[Mike Rylander (mrylander)]

I've added this to the 1.6 and 1.6.0 branches, for 1.6.0.2 and beyond. Thanks, Dan!