Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor

Query link for Sales Employee wise Sale

Select T1.ItemCode , T1.CardCode , T1.Cardname 

T1.Price,T1.ListNum , T1.FromDate  ,T1. ToDate ,T4. Quantity,


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

1 Comment
Labels in this area