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

Notifications

Announcements

Season of Giving Solutions is Here!
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,048

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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!

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi,

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

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans