Is there a clean, reliable way to programmatically query historical inventory levels for an item and location? So far I've tried querying transactions and playing through them to compute a balance at a point in time, but that approach seems slow and error-prone. I'm looking for alternatives

it seems like this is a common request and surprised NS doesn't offer much other than the Inventory Valuation report which is probably the closest. I have done via saved search before but takes a while to run as well. Have not tried via SuiteQL