for this, you need to go down to the DB table invoices_items and change the field type from VARCHAR to TEXT

yes i did that. but how can i change it to textarea in the invoice page?

oh, in that case you need to go to the /administrator/components/com_invoices/views/invoice/tmpl/form.php file and change it there...
but also in the javascript file /assets/items.js

be careful because it can be tricky...

hi germi, thanks so much for your reply. it worked ok after modifying form.php. but i can't find what is change in items.js as i notice the function is new_song()?

another question - when the product desc and notes are shown on the invoice template, the line breaks are all gone, resulting in 1 line. how can i change that?

yes, that's the function.

after this:

newCell = newRow.insertCell(5);

some new content is added, you need to replace the input for a textarea.

2) that's because no HTML is allowed in here.
what you would need to do in this case is open /administrator/components/com_invoices/models/invoice.php and find the store() function

after this:

if(!$data) $data = JRequest::get( 'post' );

you need to add this:

$data['notes'] = JRequest::getVar('notes', '', 'post', 'string', JREQUEST_ALLOWRAW);

to allow HTML in that field.

hi germi, thank you so much for your help. everything worked out except allowing html in the desc field.

i put in $data['desc'] = JRequest::getVar('desc', '', 'post', 'string', JREQUEST_ALLOWRAW); as well but there is no response. is there a different place to put it?

it's not $data['desc'] because there are many items. the items are handled below in the same function

look for this code...:
[code ]"desc" => $data["0_description_" . $item_id],[/code]