News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How do you link the no...

Microsoft Dynamics GP (Archived)

How do you link the notes in the sy03900 table with the SOP10100 table? I tried the noteindx field but they do not match each other so I am at a loss.

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Michael Marinaro 8 on at

Like (1)

Report

Re: How do you link the notes in the sy03900 table with the SOP10100 table? I tried the noteindx field but they do not match each other so I am at a loss.

The note index field should work fine. I just tried below and it does work correctly. What do you mean by they do not match each other? All the notes for the entire company are in SY03900 so you might see more data than you'd expect.

select * from sy03900 a join sop10100 b

on a.noteindx=b.noteindx

Thanks,

Mike

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans