I am trying to write a T-SQL query to get the running total quantity of columns, I am by no means good at writing queries, but unfortunately here I am… basically after everything I have a temp table that has the data I need

SELECT 
    MQ.[Company], 
    MQ.[status],
    MQ.[Facility],
    MQ.[ItemCode],
    MQ.[Style],
    MQ.[Description],
    CONVERT(date, MQ.[PlannedDate], 101) AS [PlannedDate],
    MONTH(CONVERT(date, CONVERT(date, MQ.[PlannedDate], 101))) AS [PlannedDateMonth],
    YEAR(CONVERT(date, CONVERT(date, MQ.[PlannedDate], 101))) AS [PlannedDateYear],
    MQ.[On-HandApprove],
    MQ.[TransactionQuantity],
    MQ.[OrderNumber],
    MQ.[OrderLineNumber],
    MQ.[WorkOrderNumber],
    MQ.[PurchaseOrderNumber],
    MQ.[PurchaseOrderLineNumber],
    MQ.[OrderQuantity],
    MQ.[InTransit],
    MQ.[OutstandingQuantity],
    MQ.[PODueDate]
FROM 
    #MainQuery MQ
ORDER BY 
    MQ.[ItemCode], CONVERT(date, MQ.[PlannedDate], 101)

However I am trying to get a “running total quantity” based on the item code, and which facility it is located at. Created some fake data as

The formula to get it would be
For the first record per Itemcode/Facility:

(On-HandApprove – TransactionQuantity + OutstandingQuantity) = Running Total Quantity

For the next records per Itemcode/Facility:

(Previous Running Total Quantity – TransactionQuantity + OutstandingQuantity) = Running Total Quantity

So this is basically what I’m after, I have tried this

(SUM(MQ.[TransactionQuantity]) OVER (PARTITION BY MQ.[ItemCode],MQ.[Facility] ORDER BY CONVERT(date, MQ.[PlannedDate], 101) ROWS UNBOUNDED PRECEDING) - ISNULL(MQ.[On-HandApprove], 0) ) + ISNULL(MQ.[OutstandingQuantity], 0) AS [RunningTotalTransactionQuantity]

and a few different alterations of it but cant seem to get it the way I need it…..please help!!