Hey all! I am trying to create a formula field to ...
# general
r
Hey all! I am trying to create a formula field to pull in an item field in transaction Line field. I figured I could do this by defaulting it using a formula field like this (item.countryofmanufacture}. however this does not work, is there any way to get a join field here in the line time list?
m
Robert, I think your problem might be the same as mine. If you uncheck the box "Store value", your field will become a simple and "visual" referente, but if I'm not mistaken It would be impossible to present in saved searches, if you keep the box checked, you would have to edit and save the record to get this refered value. I resolved this way: I left the box "Store value" checked, removed this default value, used the feature mass update to update the already created records and then I developed a script to fill the field I want everytime a particular field changed.
r
yeah I could do that, but would rather have a simpler solution.
c
You can search for non-stored values. It'll pull it back up to 1 level. You can't get a source of a source though.
I've seen it have to be a free-text, non-stored field and then you can put the formula in for the default value (if it exists).
m
I was trying to get a source of a source, I was at revenue element and I wanted to get a value from Revenue Element > Entity > custfield I'd created
r
This is a sales order line item field. I can add any of the other line item fields but cannot seem to add a field from the item record itself. {item.displayname} does not work either.