1 Reply by SimpleTechGuy

(8 replies, posted in Accounts Receivable)

Hi guys,

Sorry to revive this old topic, but it seems like the method for editing the emails has changed a bit in the newer versions of FA.  Is this true or am I just missing something? 

FYI - I'm trying to edit the subject and the body of the email and to add a signature with my company information.

All the best,

Go to forum: Accounts Receivable

2 Reply by SimpleTechGuy

(7 replies, posted in Reporting)

Thanks for your help tclim, changing from tinytext to text and taking out some spacing in the memo fixed my problem...

Go to forum: Reporting

3 Reply by SimpleTechGuy

(7 replies, posted in Reporting)

Been working on this all morning and finally gave in and searched the forums just to find someone else is working on the same thing.  What a small world! 

Anyway, I've tried the reporting/includes/reports_classes.inc and it didn't work for me.

Also tried editing /sales/customer_invoice.php and /sales/view/view_invoice to no avail.

I think I may have found the issue after looking in the /sql/en_US-demo.sql file on lines 389-396.  It looks like FA is creating the memo_ field in the Comments table as tinytext which has a maximum length of 255 characters...  I don't know how to fix this yet, but it seems this is def. the problem. 

Maybe somebody who knows a little more about SQL can figure out how to change from Tinytext to something that allows more characters...

EDIT:

Changed memo_ from tinytext to text fixed the problem, but now the text just goes off the screen when you print the invoice.  Now the question is, how to make the bottom of the invoice move down when there is more text in the memo_ column...

Go to forum: Reporting