Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Relation Between 2 tables

Posted on 26 Sep 2017 07:32:53 by 3,027

Hi

  How the relation can be maintained between Posted Warehouse receipt Line & Purchase Receipt Line Record Wise in a report

Thanks

*This post is locked for comments

  • Verified answer
    Binesh Profile Picture
    Binesh 7,885 on 27 Sep 2017 at 13:57:09
    RE: Relation Between 2 tables

    Where you found these fields:

    Receipt Document No & Receipt Document Line No.

    I think its custom fields, check the filed ID.

  • jsshivalik Profile Picture
    jsshivalik 3,027 on 27 Sep 2017 at 13:49:31
    RE: Relation Between 2 tables

    Hi

     Thanks . One more thing there is Receipt Document No & Receipt Document Line No . Are these also same as Receipt No , receipt Line No

    Thanks

  • Binesh Profile Picture
    Binesh 7,885 on 27 Sep 2017 at 12:32:29
    RE: Relation Between 2 tables

    Check data, not sure

    "Purch. Inv. Line"."Receipt Line No."

  • jsshivalik Profile Picture
    jsshivalik 3,027 on 27 Sep 2017 at 12:08:22
    RE: Relation Between 2 tables

    Hi

     Thanks . For line wise which field should be compared.

    Thanks

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on 27 Sep 2017 at 11:11:33
    RE: Relation Between 2 tables

    Hello,

    Check this,

    "Purch. Rcpt. Header."No."

    and

    "Purch. Inv. Line"."Receipt No."

  • jsshivalik Profile Picture
    jsshivalik 3,027 on 27 Sep 2017 at 10:42:52
    RE: Relation Between 2 tables

    Hi

     I have changed the tables. I want relation between below tables.

      I want to read Data From Purchase Receipt Header record wise . For each record wise Item details values to be get from Purchase Invoice Line table. How i should link both tables Row Wise. In One Purchase Receipt Line same item can exist more than once.

    Thanks

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on 27 Sep 2017 at 08:41:34
    RE: Relation Between 2 tables

    Hello jsshivalik,

    Let us know your complete requirement so we can give you as much as possible.

  • jsshivalik Profile Picture
    jsshivalik 3,027 on 26 Sep 2017 at 13:23:54
    RE: Relation Between 2 tables

    Hi Binesh

       Posted Source No. FieldNo(61)              Document No. FieldNo(3). What field should be used if Line Wise to be checked.

    Thanks

  • ManishS Profile Picture
    ManishS 6,578 on 26 Sep 2017 at 12:33:57
    RE: Relation Between 2 tables

    source line no.

  • jsshivalik Profile Picture
    jsshivalik 3,027 on 26 Sep 2017 at 10:22:03
    RE: Relation Between 2 tables

    Hi

       If with line no to be compared which fields should be compared. In my case in Posted Warehouse Receipt line one item can be multiple times under same No.

    Thanks

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans