Relate sales lines with purch lines

(0) Share

Report

Posted on by maober56

Hi everyone.

I have a question about relating SalesLine with PurchLine, I´m using the fields (IntercompanyOriginalSalesID, DataAreaId, and ItemId) but I find duplicated records cause the same ItemId can be in two or more rows, I need to use a unique field that relates each SalesLine record with each PurchLine record. can somebody please explain to me about the SourceLineDocument, I have this field fill on my SalesLine records but I cannot relate it with any table.

Thank you

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Deepak Agarwal 9,226 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Here are similar post, give a try,

https://community.dynamics.com/forums/thread/details/?threadid=a39a28bd-149d-4257-9f18-d82eff89eb4e

Was this reply helpful? Yes No
Verified answer

Layan Jwei 8,282 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi moaber,

I only have one example with one line in my devBox

And i can see that

PurchLine.InventTransId = SalesLine.InventRefTransId

Maybe you can also add to that PurchLine.ItemRefType=Sales

And PurchLine.SalesId = SalesLine.SalesId

But InventTransId and InvenRefTransId might be enough. Check few examples in your devBox to confirm.

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
maober56 99 on at

Like (0)

Report
Copy link

Link copied!

Hi Layan,

Thank you for your answer.

Effectly InventTransId and InventRefTransId make part of the relation but sadly in my case it doesn't work.

Was this reply helpful? Yes No