Dear u send me the coding thanks
but this is not workin properly
i m using vfp 5.0

I change some thing in ur coding please follow it

select st.Item_code, ;
nvl(pr.consg_no, nvl(rc.consg_no, sl.consg_no)) as 'consg_no',;
nvl(rc.qty,0) as rcptqty, ;
nvl(pr.qty,0) as purchqty, ;
nvl(sl.qty,0) as salesqty ;
from sl st ;
left join purchase pr on st.Item_code = pr.Item_code ;
left join receipt rc on st.Item_code = rc.Item_code ;
left join sales sl on st.Item_code = sl.Item_code ;
order by st.Item_code, consg_no ;
into cursor crsReport