SQL for returning total stock holding by location.

Can anyone write me the T-SQL for listing the total free stock by location?

So if I have 3 locations L1,L2,L3 for Item PROD0001 which has an inventory of 1000. I would want the following returned in rows and columns.

Location Inventory

L1 300

L2 150

L3 550

I’ve worked this out so I just need it confirming that I have it right? I need the [Inventory] to be the total quantity free for reservations.

SELECT [Location Code], [Item No_], sum([Remaining Quantity]) [Inventory]
FROM [dbo].[ZHS$Item Ledger Entry]
group by [Location Code], [Item No_]