80
Hi experts,
I'm new to D365.
I need your help.
Can you please suggest me how to make a relationship between custPackingSliptrans and sales line or between custPackingSliptrans and custinvoicetrans.
I wanted to get the packing slips for the sales lines.
Thank you.
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 :-)
Hi Katy,
Thank you for your reply.
In my report I need to show sales order- sales line details - packing slip id - invoice details.
Hi,
what do you need to report? Cause if you have an n:n connection you will have duplicates of course but these are related to your process so I am wondering - what exactly is the problem?
Regards Katy
Hi sahin.
Thank you for your reply.
We can use inventtransid,
But the problem is when we have multiple packing slips for a single salesline. Or multiple packing slips for multiple sales line.
You can find it via InventTransId
#1
Martin Dráb
601
Most Valuable Professional
#2
Abhilash Warrier
416
#3
Adis
384
Super User 2025 Season 1
Share
Report
All responses (
Answers (
