Customer Balance Query

[Former Member]

Hi Gurus,

Need a query that shows

Customer name

sales employee

Payed amount per month

outstanding Balance

regards

Francis T

57

[Former Member]

Hi Francis,

try below query and check whether it fulfill your requirement or not.

Select distinct T0.CardCode,T0.CardName,Sum(T0.PaidToDate) over (Partition by T2.SlpName) as 'Amount Paid',T1.Balance,T2.SlpName

from OINV T0 inner join OCRD T1 on T0.CardCode = T1.CardCode

inner join OSLP T2 on T2.SlpCode = T0.SlpCode

where T0.DocDate >= [%0] and T0.Docdate <= [%1]

Thanks,

Harshal