Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Relate sales lines with purch lines

(0) ShareShare
ReportReport
Posted on by 95
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
  • maober56 Profile Picture
    maober56 95 on at
    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 Profile Picture
    Layan Jwei 7,264 Super User 2024 Season 2 on at
    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 Profile Picture
    Deepak Agarwal 8,564 on at
    Relate sales lines with purch lines

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,661 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans