web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 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.

  • 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)

  • MG-16101311-0 Profile Picture
    MG-16101311-0 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? :-)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans