on 2016 May 27 1:02 PM
Hi Gurus,
Need a query that shows
Customer name
sales employee
Payed amount per month
outstanding Balance
regards
Francis T
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
105 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.