SELECT  a.[NO.] as [No.], a.[DOCDATE] as [DocDate], a.[DOCTYPE] as [DocType], a.DEBIT as [Debit], a.CREDIT as [Credit],
SUM( coalesce(a.Debit,0) - coalesce(a.Credit,0) )
OVER(ORDER BY a.[NO.] ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as [Balance]
FROM(
SELECT  ROW_NUMBER() OVER( ORDER BY DR.id )                     as 'NO.' ,
CONVERT(VARCHAR(13), CAST(DR.doc_date AS DATE), 100)    as 'DOCDATE',
v.which AS 'DOCTYPE',
CASE WHEN
v.which IN ('NETTOTAL', 'DELL/COL/CHARGE') THEN V.val
END AS DEBIT,
CASE WHEN
v.which IN ('CDW', 'PAYMENT') THEN V.val
END AS CREDIT
FROM [dbo].[doc_customer] DC
LEFT JOIN [dbo].[doc_rent] DR ON DR.doc_sourced_customer_id = DC.id
LEFT JOIN [dbo].[slip_rent] SR ON SR.doc_sourced_doc_rent_id = DR.id
LEFT JOIN [dbo].[slip_rent_payment] SP ON SP.doc_sourced_rent_id = DR.id OUTER APPLY
(VALUES ('NETTOTAL', SR.net_total),
('DELL/COL/CHARGE', SR.dell_col_charge),
('CDW', SR.CDW),
('PAYMENT', sp.amount)
) v(which, val)
WHERE DC.id                     = @id
AND DR.doc_source_company_id    = @doc_source_company_id
AND DR.doc_date                 = @doc_date
AND DR.deleted = 0
AND DR.void = 0
AND v.val IS NOT NULL
AND v.val <> ''
) a

Error in ORDER BY clause.
Error in list of function arguments: 'AS' not recognized.
Error in list of values in IN clause.
Unable to parse query text.