Hello Everybody.
I want to add data from the item ...
# advancedpdff
Frerik De Groot
04/26/2024, 5:56 AMHello Everybody.
I want to add data from the item record for a sales order without creating fields on the transaction line that sourced the data from the item record.
Is there a way inside the freemarker <list> where you can join the item.item with the item record itself so you can acces all the item fields inside the list ?
t
Tim Chapman
04/26/2024, 12:48 PMSure, that’s only one level deep I wouldn’t see the problem. Have you tested it?
s
Stefan Reeder
04/26/2024, 1:10 PMitem.item.someotherfield is actually more than 1 level deep, as it's coming from record.item.item.someotherfield
Stefan Reeder
04/26/2024, 1:10 PMIt's currently a bit problematic and seems to repeat the first line's sub-field data... Might be an enhancement request for this
Stefan Reeder
04/26/2024, 1:12 PMCurrently my best solution is a list/record custom column of type "item" and use a workflow to copy the item (if it's not an item group header/footer, or subtotal/description etc...)
Then you can use that customfield to access all the data your like from the item record at the cost of only one custom column field
🙌 1
e
Emily S
04/26/2024, 4:32 PMI have had success making a custom column field which is hidden and does not store value, whose value is sourced from a certain field on the line's item record. These fields are accessible in advanced PDF even though they do not store value.
Yes it requires creating a custom field on the transaction line, but since it is hidden, it does not affect my users or their workflow.
🙌 1
3 Views