I'm sure this is a long shot, but I figured if anyone would know, they would be in this channel 🙂 I have a use case where I would like to have a remote system notified when the total quantity available for an item changes (in my case, the aggregate quantity available from multiple locations) for ANY REASON, e.g. SO, PO, Return Authorization, Inventory Adjustment, etc... Is there an easy path to accomplish this that I am not seeing? Or do I need to create a lot of scripted records and apply them to all the possible record types which could modify inventory?

it would be easier to and more reliable to do a search based on the last quantity available change

If I were to use suiteql, which table/fields would I be looking at? I do not see, for instance, any last modified fields on the

InventoryItemLocations

table, which is where I am getting my values currently

_Last_ _Quantity_ _Available_ _Change_ Field on an Item Saved Search

Thank you!