Skip to Content

SAP Business one Query Report of Customer Account Balance + PDC

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers