need bp account balance in the query

Hi Experts

i need bp account balance in this Query

------------------------------

Select *

from

(

Select ROW_NUMBER() over ( partition by Cardcode Order by Docentry desc) as Ord,

OPCH .DocNum ,OPCH .DocDate,OPCH .CardCode ,OPCH .CardName ,OPCH .DocTotal

from OPCH

) D

Where D.Ord = 1 and d.CardCode like '%SP%' ORDER BY D.DocDate

Regards