need query of business partner account balance

[vinayak_chavan]

hi all,

new to sap b1

required query to get account balance with origin number

[former_member188586]

hi please check bellow Query once

SELECT T1.[AcctName],(sum(T0.[Debit])-sum(T0.[Credit])) "Cumulative Balances",T0.[Project] FROM JDT1 T0  INNER JOIN OACT T1 ON T0.Account = T1.AcctCode WHERE T1.[AcctName] =[%0] AND T0.[refdate] >= [%1]  AND T0.[refdate] <= [%2] GROUP BY T0.[Project],T1.[AcctName]

--ramudu

[a_grootens]

Hi Vinayak,

Could you be a little more specific in your requirements.

Regards,

Andy