Skip to Content
0

SAP Business one Query Report of Customer Account Balance + PDC

Apr 24 at 03:38 AM

16

avatar image

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

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers