Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Relation between InventTransferLine and SalesTable

Posted on by Microsoft Employee

Can anyone tell me how to build a relation between InventTransferLine and SalesTable.

Thanks in Advance...

Categories:
  • Verified answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,083 on at
    RE: Relation between InventTransferLine and SalesTable

    Hi Akhil Kumar Janjirala,

    I recommend you check InventRef* fields on SalesLine. There are 3 fields that used to link different documents

    InventRefType - Type of reference document

    InventRefId - header refererence id

    InventRefTransId - transaction InventTransId reference

    The is a relation on salesLine to InventTransferTable and if you expand it with InventRefTransId you can get link to InventTransferLine

    pastedimage1603431551174v1.png

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Relation between InventTransferLine and SalesTable

    Hi Akhil Kumar Janjirala,

    You can view objects in AOT and compare their relationships.

    131.PNG1464.PNG

  • Martin Dráb Profile Picture
    Martin Dráb 225,588 Super User on at
    RE: Relation between InventTransferLine and SalesTable

    These tables are not much related. Where do you see a logical relation? What's the business requirement you're working on?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans