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

All responses (3)

Answers (1)

maober56 95 on at

Like (0)

Report

Relate sales lines with purch lines

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.
Verified answer

Layan Jwei 7,264 Super User 2024 Season 2 on at

Like (1)

Report

Relate sales lines with purch lines

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
Suggested answer

Deepak Agarwal 8,564 on at

Like (1)

Report

Relate sales lines with purch lines

Hello,

Here are similar post, give a try,

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