Skip to Content
0
Aug 22, 2023 at 04:35 AM

Add Customer Group name in this Report

59 Views Last edit Aug 22, 2023 at 10:21 AM 2 rev

SELECT A.CardCode,A.CardName,SUM(A.Total) FROM

(SELECT T0.CardCode,T0.CardName ,SUM(T0.DocTotal) [Total] FROM OINV T0 INNER JOIN OFPR FP ON T0.[FinncPriod] = FP.[AbsEntry]

WHERE T0.CANCELED='N' AND FP.[Indicator]='[%0]'

GROUP BY T0.CardCode,T0.CardName

UNION ALL

SELECT T0.CardCode,T0.CardName ,-SUM(T0.DocTotal) [Total] FROM ORIN T0 INNER JOIN OFPR FP ON T0.[FinncPriod] = FP.[AbsEntry]

WHERE T0.CANCELED='N' AND FP.[Indicator]='[%0]'

GROUP BY T0.CardCode,T0.CardName) AS A

GROUP BY A.CardCode,A.CardName

HAVING SUM(A.Total) >5000000