Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Need help with linking...
Microsoft Dynamics GP (Archived)

Need help with linking fields in excel report builder

(0) ShareShare
ReportReport
Posted on by Katie Pieczynski 3,225

Hello,

I created a report using one of Vicotrias views and adding additional tables.  Everything was working okay until I added the PM Address MSTR table.

I had to add this table to get the country code and country to pull in.  Once I added this table my data brings in multiple rows of the same data.   I have tried left outer and equals (on Vendor ID) and I have tried to link it to the view and to the PM Vendor Master file.  Am I missing something?  My tables are below

view_AP_Apply

PM Vendor Master File

Address Electronic Funds Transfer Master

PM Paid Transaction History File

PM Address MSTR

Thanks for any help.

*This post is locked for comments

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Need help with linking fields in excel report builder

    Well, it must be, so I am sure I can get a Mark as Answer on my reply above? :-)

  • Katie Pieczynski Profile Picture
    Katie Pieczynski 3,225 on at
    RE: Need help with linking fields in excel report builder

    Thanks Mariano!

    Yes I am just needing it for the primary address and of course the vendors have multiple address.  I cant believe I didnt think about that.  (Must be because it is Friday)

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Need help with linking fields in excel report builder

    The question is, the country code for which address though. The query will show as many records per address for each line of the apply, for a specific vendor if you do not filter the address ID. Are you looking to add the country code for the remit to address? Otherwise, the vendor master table already contains the country colum.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans