web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Relations between WHS ...
Supply chain | Supply Chain Management, Commerce
Unanswered

Relations between WHS Load Line and Details

(0) ShareShare
ReportReport
Posted on by vannamani77 417

Hi,

I use Data Management to export WHSLoadTable and WHSLoadLine entity to BYOD.

In BYOD, I need to know the relationship between WHSLoadTable and WHSLoadLine. I used LoadID to link both. But It seems it is incorrect. 

Many LoadID in WHSLoadLine is not available in WHSLoadTable. More over I saw RecID is the primary key for WHSLoadLine table. I think I missing some other table between WHSLoadTable and WHSLoadLine,

Help me to link both table.

Regards,

Manivannan

I have the same question (0)
  • Mea_ Profile Picture
    Mea_ 60,284 on at

    Are those entities created by you ? WHSLoadLine should not have unique index by LoadID, because you can have multiple lines per load.

    Missing headers sounds like a broken data for me but Im not a WHS expert.

  • Zain Mehmood Profile Picture
    Zain Mehmood 4,187 Most Valuable Professional on at

    Hi,

    I agree with ievgen is there any customization involved in your scenario?

    Warm Regards,

    Zain

  • vannamani77 Profile Picture
    vannamani77 417 on at

    Yes both table are customized. The primary key for XXXWHSLoadTable is LoadId and for XXXWHSLoadLine is WHSLoadLineRecID which is equal to RecID of WHSLoadLine.

    In BYOD, for some loads, XXXWHSLoadLine table contains Item lines but in XXXWHSLoadTable corresponding loadID not available. But is D365 User interface header and lines are available. I don't know the reason why the header info not exported to BYOD for some records. I have set the export to Full push only. That's the reason I thought there should be some other table in between which establish relation between WHSLoadTable and WHSLoadLine.

  • Mea_ Profile Picture
    Mea_ 60,284 on at

    What entity are you using? Standard entities have filters behind and export only some type of loads, so either give us entity name it check if it has range defined.

  • vannamani77 Profile Picture
    vannamani77 417 on at

    XXXWHSLoadTable is based on standard WHSLoadTable entity and WHSLoadTable does not have any range. 

    - Manivannan

  • vannamani77 Profile Picture
    vannamani77 417 on at

    I found the problem. For few Loads User didn't enter Drop Off location. While export they join with LogisticsPostalAddressDestinationtable. That's the reason data not exported for few loads

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 271 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 171 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 130 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans