i just want to confirm with anybody who knows more than me before i head down a different path but: is there a way to create inventory valuation by lot number reporting using NS reports? i know i can probably get a search that gets the info, but my accounting team obviously would like to have the starting balance, pivot table maneuverability, and the click through to the detail is much better than a drill down in a search, but i can't seem to figure it out. wondering if i'm missing something or if i'm going to have to use a search/suiteql/suiteanalytics or something else