News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Link Tables Smartlist ...

Microsoft Dynamics GP (Archived)

Link Tables Smartlist Builder

(0) Share

Report

Report

Posted on by Chris Flood

655

2 (GL20000 and SOP30200)Tables contain all the information I need to use Smartlist Builder to create a smartlist using this financial and sales information. I can't find a field that can be used to link these tables so I can produce the required smartlist. Do you have any recommendations on the best way to join these tables so I can extract the information needed for this smartlist report?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Link Tables Smartlist Builder

GL20000 and SOP30200 can be linked through the original transaction source field.

GL20000 - ORGNTSRC

SOP30200 - TRXSORCE

Although, in case you want to create a sales transaction report with the General Ledger details, you need to consider the GL30000 table. I have previously worked on such a report, you may check it on Sales Invoices and Returns with General Ledger Journals Details . You can create this view and built your customized smartlist accordingly

Never hesitate to share any further inquiries,

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