Skip to Content

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply