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) / Pulling the phone numb...
Microsoft Dynamics GP (Archived)

Pulling the phone number for the address ID used in the Receivables Transaction Entry window

(0) ShareShare
ReportReport
Posted on by Community Member

The user can select a customer address ID from a look up in the Receivables Transaction Entry window.  I need to pull the phone number associated with this address ID and display it on the report form.  I've used RW_RMAddrIDInfo() in the past to pull the phone number associated with the "Bill To" field on the customer card, but can not seem to find a function that reads which ID is assigned in the window and then retrieves the proper phone number.  Any help would be greatly appreciated.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mick Egan Profile Picture
    Mick Egan 3,561 on at
    RE: Pulling the phone number for the address ID used in the Receivables Transaction Entry window

    kthebo,

    I tested this just by adding the phone field from the RM Open Temp Table on the Report, and the phone number changes depending on Address ID elect.

    Mick

  • Community Member Profile Picture
    Community Member on at
    RE: Pulling the phone number for the address ID used in the Receivables Transaction Entry window

    Thank you Mick.  I did figure that out after I made the post.  I should have come back in and closed that out.  My apologies.  Being new to Report Writer I didn't at first realize that the process of selecting additional fields on the Temp table was so easy.  All of my experience thus far has been bringing in fields from other tables as a result of relationships.  Initially I thought I was limited to the fields that had defaulted in.  Thanks very much for taking the time to respond.  

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans