Search for Item Groups with Items that had transactions today

I’d like to create a search of all Item Groups where one of the member inventory items had a transaction today. Is this even possible given there’s no way to reference the member items transaction fields?

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

Scheduled Script or Map/Reduce could set field values for you – this would be the “most” effective/streamlined.

However, you could use a combination of several scheduled workflows to make this work. However – you’d be somewhat time delayed there, so it wouldn’t be my first option/choice.

Advanced Answered on October 7, 2019.

If you could join from the item record to the transaction, I think this would be possible in SuiteAnalytics Workbook, but it looks like you can’t do that join in SAW even though you can in a saved search.  Super sad face.

on October 7, 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