How can one obtain sub-query Item data such as prices in a Saved Search?

How can you get prices per price level, price quantity and currency into a saved search cell?

For instance how would you get all of the prices in the image?

How can one obtain sub-query Item data such as prices in a Saved Search?

Is there a formula or fancy SQL function or a combination that could work or will I have to look at SuiteScript?

Beginner Asked on November 21, 2019 in Saved Searches.
Add Comment
1 Answer(s)
Best answer

Use the pricing join related fields in your columns.

RE: How can one obtain sub-query Item data such as prices in a Saved Search?

should give something that looks like

RE: How can one obtain sub-query Item data such as prices in a Saved Search?

Advanced Answered on November 21, 2019.

That’s perfect, thank you very much!

on November 22, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor