Can anyone tell me where the contact email address is held on a purchase order? I need to add it to the Purchase Order print. The only relevant tables I can identify are VendPurchOrderJour, VendPurchOrderTrans and VendPurchOrderPurchlink.
The required Email is in ContactPerson, but I cant see how this is linked to the report.
General Tab> Contact Information mail id is there…
you have to create same contact information field in Vendinvoicejour Table.
One initfrompurchtable method is there there you write the code like this
this.mailid = Purchtable.MailId;
while doing the Invoice the class(PurchformLetter_Invoice)will call this method and it will assign the purch table value(Mail Id) to Vend Invoice jour Table.
In Report
Directly drag and drop your field in report,
Because report will take the value from VendInvoiceJour Table.
Example,
Purchace order “001” you have mailid called “xyz@mail.com” you are invoicing now.
After Invoicing the xyz@mail.com will be there in VendInvoiceJour Table,