Issue Retrieving Both Active and Reserved Stock in Reports

Summary:

I’m creating some reports and need to retrieve both active stock and reserved stock. However, when querying the inventory.curr_qty table, I noticed that it only returns the active stock.

How can I also retrieve the reserved stock? Is there another table or a specific join required to get this information? Are there any filters or conditions I should consider?

I appreciate any help!

25A.02m