Hi Everybody, I have a question on a saved search on Transaction item lines. I know that on the first two lines of an Item Group, a certain field (Asset in this case) should be filled. So this is on the Item Group line itself and the second line in the group. See the first two lines in the screenshot.
For some reason only for the first line of the item group the asset field is filled.
With a saved search I can determine the second line for which the Asset is empty, but I cannot get the asset value from the first line. I would like to use that to do a csv update.
Does anybody now how I can get this information in the saved search. Probably a formula is needed here.
Good to know, the item group can be on any line number of the transaction. But always for the first line of the item group, the asset is filled, and for the second line it is not.
Many thanks.