Could you help me to see inventory availability by its variants vs location?
Thank you in advance.
Why dont you pull this in Excel by running once for Variant and once for Location and then compare!!
If you put all open Item Ledger Entries for the item in Excel, you could just make a pivot table to show exactly what you need based on the sum of remaining qty and having variants and locations as rows and columns.