Hi,
I have no idea if it helps you or not but here's my sql query to connect salesline + custpackingsliptrans, inventmodelgroupitem I used to exclude service items.
select distinct SALESLINE.ITEMID,
SALESLINE.SALESID,
isnull(PACKINGSLIPID, '<none>'),
isnull(CUSTPACKINGSLIPTRANS.DLVTERM, '<none>')
from SALESLINE left outer join
CUSTPACKINGSLIPTRANS on SALESLINE.INVENTTRANSID = CUSTPACKINGSLIPTRANS.INVENTTRANSID left outer join
INVENTMODELGROUPITEM on SALESLINE.ITEMID = INVENTMODELGROUPITEM.ITEMID and salesline.DATAAREAID = INVENTMODELGROUPITEM.ITEMDATAAREAID
Like that there shouldn't be any duplicates... let me know what you think about it.
Best regards
Katy :-)
