Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / report writer - linkin...
Microsoft Dynamics GP (Archived)

report writer - linking new tables - internet addresses table onto a packing slip

(0) ShareShare
ReportReport
Posted on by iruser2 2,046

hi folks

I would like to add the internet addresses SY01200 table to the packing slip so that I can print the INetInfo field on my packing slip.

The window in GP has the customer ID and the address ID that are both going to be on the packing slip so you would think you could do the link.

Relationships in report writer however are not showing those fields.  I am also challenged by how to link the master type = CUS to tell the internet addresses table that I want a customer.

Any assistance in setting up the link would be appreciated.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: report writer - linking new tables - internet addresses table onto a packing slip

    Hi,

    You retrieved Internet Address information from C Tanguay or you can create a custom RW function based on suggested sql query by @Harry

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: report writer - linking new tables - internet addresses table onto a packing slip

    I don't think you need to tell it you want a customer, because you're going to only return records where the Customer ID matches the Master_ID in the SY01200 table.  It looks like this in SQL:

    select EmailToAddress, INET1,* from RM00101

    inner join SY01200 on rm00101.CUSTNMBR = sy01200.Master_ID

    and sy01200.Master_Type = 'CUS'

    I tested and you don't need to use the Master_Type field (last line of the query) to restrict the outcome unless your CUSTNMBR is the same as an Item Number, Vendor Number, etc.

    You should be aware the EmailToAddress field and INET1 field contain email data depending on where a person records the information in the Internet Information Window.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: report writer - linking new tables - internet addresses table onto a packing slip

    Hi,

    David Musgrave has a great post on this you should check out.

    http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/05/11/accessing-internet-information-from-report-writer.aspx

    Good luck!

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans