Query link for Sales Employee wise Sale
Select T1.ItemCode , T1.CardCode , T1.Cardname
T1.Price,T1.ListNum , T1.FromDate ,T1. ToDate ,T4. Quantity,
T4.SlpCode
from spp1 t1
inner join ocrd t2 on t1.cardcode=t2.cardcode
inner join oinv t3 on t3.cardcode=t1.cardcode
inner join inv1 t4 on t4.docentry=t3.docentry and t1.itemcode=t4.itemcode
