Hi Experts,
Please correct my codes i want to achieve like this,
Customer,Account Balance,PDC,
Select T0.CardCode,T0.CardName,(SUM(T1.Debit)- SUM(T1.Credit)) AS Balance From OCRD T0 Inner Join JDT1 T1 on T0.CardCode=T1.Shortname Right join Ochh T2 on T0.CardCode=T2.CardCode Where T0.Cardtype='c' Group By T0.CardCode,T0.CardName Having (SUM(T1.Debit)- SUM(T1.Credit))!=0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.