Is there any way to create a Saved Search on Trans...
# beginners
t
Is there any way to create a Saved Search on Transactions, but pull in specific price levels that are associated with the line items on the transaction to a results column, or at least into a formula field? Thank you!
j
Have you checked the "Item Fields..." option under the results? I'm not sure if you'll be able to pull multiple price levels or not specifically, but you should at least be able to pull a price group or reference the price level from the transaction itself?
t
I did, but since we have the complete price level matrix set up (with different levels, currencies, and quantities), then it counts as a separate join. So if I want to show price levels on an Item Search, I have to go into “Pricing Fields…“, and on a Transaction Search, if I go into “Item Fields…“, there’s no “Pricing Fields…” in there.
p
There should be a price level field/value for each line item on the transaction no?