S
Shiva Duriseati
Guest
Hi, You can use EVAL block which can retrieve the values from "BankDetails" object. Like you said creating related fields in "Contract" and then accessing them "Invoice" would also work but it is not recommended because when you add few more fields to "BankDetails" object again you have to add them as related field in Contract which will be a complex task. Please look at sample example where we can access "bankdetails" by passing id using "related contract" from token helper in document template of "Invoice" object. Example: If you are creating a document template of type "HTML" Name of the bank is : #EVAL[ var a=rbv_api.selectQuery("SELECT name FROM BankDetails where id={!R60150413.R60150424#id}", 10); return a[0][0]; ] Please note you can use EVAL block in text or xml files also this function has to return some string value. Hope this helps. Regards, Shiva
Continue reading...
Continue reading...