vtiger

[justinee]

Hi,
I have assigned a invoice to a user (salesperson), I'd like to have the salesperson's name on the invoice when I create a PDF version of the invoice. But I can't find the clue where can I start. Can anyone help me? thanks.

[prasad.a]

Hi justinee,

Start looking at modules/Invoice/CreatePDF.php and
include\fpdf\templates\body.php to get more idea on PDF creation for invoice.

Regards,
Prasad
vtiger Team

[justinee]

Hi, Prasad
Thanks for your post. I did look at the files you mentioned, but it seems that the invoice table doesn't have any info of the salesperson. I can't find where the value does to when I assigned a invoice to someone.


And, could anyone tell me what files should I change if I want to add some filed to a invoice.

I'd like to add a "ship date" and "ship via" into the invoice. so that I can trace the shipment.

Thanks advance.

[justinee]

Searched this forum and find I can write a SQL query with inner join like:

select user_name from vtiger_users inner as a join vtiger_crmentity as b on a.id=b.smownerid where b.crmid = $invoiceID.


I'll try it tonight.