they have a custom record that is connected to the...
# advancedpdf
m
they have a custom record that is connected to their sales orders. it is connected with a parent field to the transaction. is it possible to print this in an advanced pdf?
g
To print fields from the linked custom record? If the custom record is stored on the Sales Order in a transaction body field, you should be able to print non-sublist fields from that record using a syntax like
$(record.custbody_custrecord.custrecord_fieldid}
💯 1
m
@Gabriel Folstein thank you! but it does not work unfortunately..
it gives empty values..
g
If creating the join isn't working, you can also create a second transaction body field that sources the value from the field on the custom record
m
yes, but then the purpose of the custom record is gone.. we want to have the custom record to avoid creating a lot of transaction custom body fields. thank you for your help!
l
You sure you have the correct IDs? We have the same concept and we are able to retrieve the custom record fields using the suggested join above.
g
I think I typed it in a misleading way. Recordid=transaction body Field is = custom records field
m
@Gabriel Folstein I am not following, sorry.. We have approx 10 fields on the custom record that we want to source in to the pdf
@Luis are you using record.id_of_transaction_body_field.fieldid_from_custom_record ?
It works now.. record.id_of_transaction_body_field.fieldid_from_custom_record don't know what I did wrong. Thanks guys!
fiesta parrot 1